[kloning1]

top

pawn Код:

enum plyrinfo
{
    // some data
    pBanned,
    pABanned[MAX_PLAYER_NAME],
    pBanReason[128]
};
public OnPlayerUpdate(playerid)
{
    // some system and data
    format(pInfo[playerid][pBanReason],128, "tidak");
    format(pInfo[playerid][pABanned], MAX_PLAYER_NAME, "none");
    // blabla bla
    return 1;
}

function save player

pawn Код:

stock SaveStats(playerid)
{
    new query[512], asu[24+MAX_PLAYER_NAME], benreson[128];
    format(asu,sizeof(asu),"%s",pInfo[playerid][pABanned]);
    format(benreson,sizeof(benreson),"%s",pInfo[playerid][pBanReason]);
    format(query, sizeof(query), "UPDATE `zmusers` SET `pEXP`=%d, `pKills`=%d, `pDeaths`=%d, `pRank`=%d, `pEvac`=%d, `pAdminLevel`=%d, `pAdminMapping`=%d, `pDonateLevel`=%d, `pZmc`=%d, `pHour`=%d, `pMin`=%d, `pSec`=%d,",
    pInfo[playerid][pEXP], pInfo[playerid][pKills], pInfo[playerid][pDeaths], pInfo[playerid][pRank], pInfo[playerid][pEvac], pInfo[playerid][pAdminLevel], pInfo[playerid][pAdminMapping], pInfo[playerid][pDonateLevel],  pInfo[playerid][pZmc], pInfo[playerid][pHour], pInfo[playerid][pMin], pInfo[playerid][pSec]);
    mysql_format(mysql, query, sizeof(query), "%s `pMapsPlayed`=%d, `pMoney`=%d, `gLeader`=%d, `gMember`=%d, `pWarnings`=%d, `pBanned`=%d, `pABanned`=`%s`, `pBanReason`=`%s` WHERE `Username`='%e'",
    query, pInfo[playerid][pMapsPlayed], pInfo[playerid][pMoney], pInfo[playerid][gLeader], pInfo[playerid][gMember], pInfo[playerid][pWarnings], pInfo[playerid][pBanned], asu, benreson, PlayerName(playerid));
    mysql_tquery(mysql, query);
    return 1;
}

ERROR!

Код:

[14:07:58] [ERROR] CMySQLQuery::Execute[] - (error #1054) Unknown column '' in 'field list'

In My DB


so? what wrong? I am very confused on this issue
I've been there 4 hours looking for a solution
any can help me?

[AlonzoTorres]

pawn Код:

stock SaveStats(playerid)
{
    new query[512], asu[24+MAX_PLAYER_NAME], benreson[128];
    format(asu,sizeof(asu),"%s",pInfo[playerid][pABanned]);
    format(benreson,sizeof(benreson),"%s",pInfo[playerid][pBanReason]);
    format(query, sizeof(query), "UPDATE `zmusers` SET `pEXP`=%d, `pKills`=%d, `pDeaths`=%d, `pRank`=%d, `pEvac`=%d, `pAdminLevel`=%d, `pAdminMapping`=%d, `pDonateLevel`=%d, `pZmc`=%d, `pHour`=%d, `pMin`=%d, `pSec`=%d ->,<-", // Remove the last comma (,)
    pInfo[playerid][pEXP], pInfo[playerid][pKills], pInfo[playerid][pDeaths], pInfo[playerid][pRank], pInfo[playerid][pEvac], pInfo[playerid][pAdminLevel], pInfo[playerid][pAdminMapping], pInfo[playerid][pDonateLevel],  pInfo[playerid][pZmc], pInfo[playerid][pHour], pInfo[playerid][pMin], pInfo[playerid][pSec]);
    mysql_format(mysql, query, sizeof(query), "%s `pMapsPlayed`=%d, `pMoney`=%d, `gLeader`=%d, `gMember`=%d, `pWarnings`=%d, `pBanned`=%d, `pABanned`=`%s`, `pBanReason`=`%s` WHERE `Username`='%e'",
    query, pInfo[playerid][pMapsPlayed], pInfo[playerid][pMoney], pInfo[playerid][gLeader], pInfo[playerid][gMember], pInfo[playerid][pWarnings], pInfo[playerid][pBanned], asu, benreson, PlayerName(playerid));
    mysql_tquery(mysql, query);
    return 1;
}

[kloning1]

Quote:

Originally Posted by AlonzoTorres pawn Код: stock SaveStats(playerid) {     new query[512], asu[24+MAX_PLAYER_NAME], benreson[128];     format(asu,sizeof(asu),"%s",pInfo[playerid][pABanned]);     format(benreson,sizeof(benreson),"%s",pInfo[playerid][pBanReason]);     format(query, sizeof(query), "UPDATE `zmusers` SET `pEXP`=%d, `pKills`=%d, `pDeaths`=%d, `pRank`=%d, `pEvac`=%d, `pAdminLevel`=%d, `pAdminMapping`=%d, `pDonateLevel`=%d, `pZmc`=%d, `pHour`=%d, `pMin`=%d, `pSec`=%d ->,<-", // Remove the last comma (,)     pInfo[playerid][pEXP], pInfo[playerid][pKills], pInfo[playerid][pDeaths], pInfo[playerid][pRank], pInfo[playerid][pEvac], pInfo[playerid][pAdminLevel], pInfo[playerid][pAdminMapping], pInfo[playerid][pDonateLevel],  pInfo[playerid][pZmc], pInfo[playerid][pHour], pInfo[playerid][pMin], pInfo[playerid][pSec]);     mysql_format(mysql, query, sizeof(query), "%s `pMapsPlayed`=%d, `pMoney`=%d, `gLeader`=%d, `gMember`=%d, `pWarnings`=%d, `pBanned`=%d, `pABanned`=`%s`, `pBanReason`=`%s` WHERE `Username`='%e'",     query, pInfo[playerid][pMapsPlayed], pInfo[playerid][pMoney], pInfo[playerid][gLeader], pInfo[playerid][gMember], pInfo[playerid][pWarnings], pInfo[playerid][pBanned], asu, benreson, PlayerName(playerid));     mysql_tquery(mysql, query);     return 1; }

Код:

[16:44:41] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[16:44:41] [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 '`pMapsPlayed`=1, `pMoney`=0, `gLeader`=0, `gMember`=0, `pWarnings`=0, `pBanned`=' at line 1
[16:44:41] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[16:44:41] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[16:44:41] [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 '`pMapsPlayed`=1, `pMoney`=0, `gLeader`=0, `gMember`=0, `pWarnings`=0, `pBanned`=' at line 1
[16:44:41] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError

[kloning1]

BUMP!

[AlonzoTorres]

Remove the "query," part next to pInfo[playerid][pMapsPlayed]