help (mysql)
#4

like this -
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);
also see this http://forum.sa-mp.com/showpost.php?...18&postcount=6
Reply


Messages In This Thread
help (mysql) - by JeaSon - 06.12.2014, 17:07
Re: help (mysql) - by Ryz - 06.12.2014, 17:21
Re: help (mysql) - by CoaPsyFactor - 06.12.2014, 17:25
Re: help (mysql) - by BroZeus - 06.12.2014, 17:26
Re: help (mysql) - by Vince - 06.12.2014, 17:29
Re: help (mysql) - by Ryz - 06.12.2014, 17:32
Re: help (mysql) - by CoaPsyFactor - 06.12.2014, 18:33

Forum Jump:


Users browsing this thread: 1 Guest(s)