06.12.2014, 17:26
like this -
also see this http://forum.sa-mp.com/showpost.php?...18&postcount=6
pawn Код:
new query[1000];
format(query,sizeof(query),""):
strcat(query,"INSERT INTO `players` (`Username`, `Password`, `IP`, `Admin`, `Score`, `Kills`, `Deaths`, `Cookie`, `Notify` ,`TotalTime`,`SkinID`");
strcat(query,"`AccountLocked`, `AccountBanned`, `BanningAdmin`, `BannedReason`, `MoneyBank`,`Health`, `Armour`, `LastActivity`");
strcat(query,"`WeaponSlot1`, `WepSlotAmmo1`, `WeaponSlot2`, `WepSlotAmmo2`, `WeaponSlot3`, `WepSlotAmmo3`, `WeaponSlot4`, `WepSlotAmmo4`, `WeaponSlot5`, `WepSlotAmmo5`, `Money`) ");
strcat(query,"VALUES ('%e', '%s', '%s', 0, 0, 0, 0, 0, 0, 0 , 0, 0, 0, 0, 0, 0, 99.0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,)");
mysql_format(mysql, query,sizeof(query),query,Name[playerid], pInfo[playerid][Password], IP[playerid]);
mysql_tquery(mysql, query, "OnAccountRegister", "i", playerid);