[theonethatownz]

This is the section it writes the inital info into the table

Код:

            GetPlayerName(playerid, playername, sizeof(playername)); 
            GetPlayerIp(playerid, playerip, sizeof(playerip)); 
            WP_Hash(Player[playerid][Password], 129, inputtext); 
            mysql_format(mysql, query, sizeof(query), "INSERT INTO `accounts` (`Name`, `Password`, `IP`, `Admin`, `VIP`, `Money`, `PosX`, `PosY`, `PosZ`, `PosA`, `Skin`, `Thirst`, `Hunger`, `Banned`, `Bans`, `Kicks`, `Warns`, `Muted`, `Quests`, `TimeH`, `TimeM`, `Infection`) VALUES ('%e', '%e', '%e', 0, 0, 0, %f, %f, %f, %f, 23, 100, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0)", playername, Player[playerid][Password], playerip, SPAWN_X, SPAWN_Y, SPAWN_Z, SPAWN_A); 

			mysql_format(mysql, query, sizeof(query), "INSERT INTO `accounts` (`Item1`, `Item2`, `Item3`, `Item4`, `Item5`, `Item6`, `Item7`, `Item8`, `Item9`, `Item10`, `Storage`) VALUES (0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)"); 
			
            mysql_tquery(mysql, query, "OnAccountRegister", "i", playerid);