R39-4 Mysql Plugin wont work!
#1

I cannt find the error! Anyone help me?


PHP код:
forward SaveAccountStats(playerid);
public 
SaveAccountStats(playerid)
{
    if(
Logged[playerid] == 1)
    {
        new 
query[2048];
        
mysql_format(g_SQLquerysizeof(query), "UPDATE `accounts` SET `Cash`=%d, `AdminLevel`=%d, `VIPLevel`=%d, `Kills`=%d, `Deaths`=%d, `Score`=%d, `Rank`=%s, `Headshots`=%d, `Banned`=%d, `Warns`=%d,\
          `hours`=%d, `minutes`=%d, `Color`=%d, `Turfs`=%d, `VW`=%d, `Interior`=%d, `PM`=%d, `Clan`=%s, `ClRank`=%d, `ClLeader`=%d, `Invited`=%d, `Inviting`=%d  WHERE `ID`=%d"
,\
        
Player[playerid][pCash],
        
Player[playerid][pAdminLevel],
        
Player[playerid][pVIPLevel],
        
Player[playerid][pKills],
        
Player[playerid][pDeaths],
        
Player[playerid][pScore],
        
Player[playerid][pRank],
        
Player[playerid][pHeadshots],
        
Player[playerid][pBanned],
        
Player[playerid][pWarns],
        
Player[playerid][phours],
        
Player[playerid][pminutes],
        
Player[playerid][pColor],
        
Player[playerid][pTurfs],
        
Player[playerid][pVW],
        
Player[playerid][pInt],
        
Player[playerid][pPM],
        
Player[playerid][pClan],
        
Player[playerid][pClRank],
        
Player[playerid][pClLeader],
        
Player[playerid][pInvited],
        
Player[playerid][pInviting],
        
Player[playerid][pID]);
        
mysql_tquery(g_SQLquery"""");
        return 
1;
    }
    return 
0;

And here my mysql log

PHP код:
[15:55:13] [DEBUGmysql_format connection1len2048format"UPDATE `accounts` SET `Cash`=%d, `AdminLevel`=%d, `VIPLevel`=%d, `Kills`=%d, `Deaths`=%d, `Score`=%d, `Rank`=%s, `Headshots`=%d,..."
[15:55:13] [DEBUGmysql_tquery connection1query"UPDATE `accounts` SET `Cash`=10000, `AdminLevel`=1339, `VIPLevel"callback"(null)"format"(null)"
[15:55:13] [DEBUGCMySQLQuery::Execute[] - starting query execution
[15:55:13] [ERRORCMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' `Headshots`=0, `Banned`=0, `Warns`=0,`hours`=0, `minutes`=11, `Color`=0, `Turfs' at line 1
[15:55:13] [DEBUGCMySQLQuery::Execute[] - error will be triggered in OnQueryError 
Ty for help!
Reply


Messages In This Thread
R39-4 Mysql Plugin wont work! - by PrettyDiamond - 06.02.2016, 14:46
Re: R39-4 Mysql Plugin wont work! - by AmigaBlizzard - 06.02.2016, 15:24
Re: R39-4 Mysql Plugin wont work! - by PrettyDiamond - 06.02.2016, 15:44
Re: R39-4 Mysql Plugin wont work! - by Vince - 06.02.2016, 15:53
Re: R39-4 Mysql Plugin wont work! - by PrettyDiamond - 07.02.2016, 07:56
Re: R39-4 Mysql Plugin wont work! - by AmigaBlizzard - 10.02.2016, 20:47
Re: R39-4 Mysql Plugin wont work! - by mirou123 - 10.02.2016, 20:50
Re: R39-4 Mysql Plugin wont work! - by PrettyDiamond - 11.02.2016, 17:04
Re: R39-4 Mysql Plugin wont work! - by AmigaBlizzard - 11.02.2016, 22:50

Forum Jump:


Users browsing this thread: 1 Guest(s)