[ERROR] Mysql Can't save data player
#1

this error
pawn Код:
[23:59:14] [DEBUG] mysql_format - connection: 1, len: 512, format: "%s pAdminMapping = %d pDonateLevel = %d pZmc = %d pMapsPlayed = %d pMoney = %d pIP = %s pBanned = %d gLeader = %d gMember = %d p..."
[23:59:14] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE zmusers SET pEXP = 0 pKills = 0 pDeaths = 1 pRank = 0 pEv", callback: "(null)", format: "(null)"
[23:59:14] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[23:59:14] [ERROR] CMySQLQuery::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 'pKills = 0 pDeaths = 1 pRank = 0 pEvac = 0 pAdminLevel = 0 pAdminMapping = 0 pDo' at line 1
[23:59:14] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
this my custom function
pawn Код:
stock SaveStats(playerid)
{
    new IP[16];
    GetPlayerIp(playerid, IP, sizeof(IP));
    new query[512];
    format(query, sizeof(query), "UPDATE zmusers SET pEXP = %d pKills = %d pDeaths = %d pRank = %d pEvac = %d pAdminLevel = %d",
    pInfo[playerid][pEXP], pInfo[playerid][pKills], pInfo[playerid][pDeaths], pInfo[playerid][pRank], pInfo[playerid][pEvac], pInfo[playerid][pAdminLevel]);
    mysql_format(mysql, query, sizeof(query), "%s pAdminMapping = %d pDonateLevel = %d pZmc = %d pMapsPlayed = %d pMoney = %d pIP = %s pBanned = %d gLeader = %d gMember = %d pWarnings = %d",
    query, pInfo[playerid][pAdminMapping], pInfo[playerid][pDonateLevel],  pInfo[playerid][pZmc], pInfo[playerid][pMapsPlayed], pInfo[playerid][pMoney], IP, pInfo[playerid][pBanned],  pInfo[playerid][gLeader], pInfo[playerid][gMember], pInfo[playerid][pWarnings]);
    mysql_tquery(mysql, query, "", "");
    return 1;
}
where i wrong?
Reply


Messages In This Thread
[ERROR] Mysql Can't save data player - by kloning1 - 25.06.2015, 17:00
Re: [ERROR] Mysql Can't save data player - by SecretBoss - 25.06.2015, 17:04
Re: [ERROR] Mysql Can't save data player - by kloning1 - 25.06.2015, 17:05
Re: [ERROR] Mysql Can't save data player - by SecretBoss - 25.06.2015, 17:06
Re: [ERROR] Mysql Can't save data player - by Vince - 25.06.2015, 17:25
Re: [ERROR] Mysql Can't save data player - by kloning1 - 25.06.2015, 17:46
Re: [ERROR] Mysql Can't save data player - by kloning1 - 25.06.2015, 19:07

Forum Jump:


Users browsing this thread: 2 Guest(s)