help (mysql)
#3

Ryz, it's clear that you haven't read query :P

pawn Код:
new query[3000];
            mysql_format(mysql, query, sizeof(query),"INSERT INTO `players` (`Username`, `Password`, `IP`, `Admin`, `Score`, `Kills`, `Deaths`, `Cookie`, `Notify` ,`TotalTime`,`SkinID`");
            mysql_format(mysql, query, sizeof(query),"%s`AccountLocked`, `AccountBanned`, `BanningAdmin`, `BannedReason`, `MoneyBank`,`Health`, `Armour`, `LastActivity`", query);
            mysql_format(mysql, query, sizeof(query),"%s`WeaponSlot1`, `WepSlotAmmo1`, `WeaponSlot2`, `WepSlotAmmo2`, `WeaponSlot3`, `WepSlotAmmo3`, `WeaponSlot4`, `WepSlotAmmo4`, `WeaponSlot5`, `WepSlotAmmo5`, `Money`) ", query);
            mysql_format(mysql, query, sizeof(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,)",query, Name[playerid], pInfo[playerid][Password], IP[playerid]);
            mysql_tquery(mysql, query, "OnAccountRegister", "i", playerid);
this should do
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)