help (mysql)
#1

i got this error when i try to register
PHP код:
[22:52:40] [DEBUGCMySQLQuery::Execute[OnAccountRegister] - starting query execution
[22:52:40] [ERRORCMySQLQuery::Execute[OnAccountRegister] - (error #1064) Erreur de syntaxe prиs de 'VALUES ('INSERT INTO `players` (`Username`, `Password`, `IP`, `Admin`, `Score`, ' а la ligne 1
[22:52:40] [DEBUGCMySQLQuery::Execute[OnAccountRegister] - error will be triggered in OnQueryError 
this is inserting query
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);
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)