28.06.2015, 07:19
(
Последний раз редактировалось kloning1; 28.06.2015 в 19:04.
Причина: FIXED
)
top
function save player
ERROR!
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?
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;
}
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;
}
Код:
[14:07:58] [ERROR] CMySQLQuery::Execute[] - (error #1054) Unknown column '' in 'field list'
so? what wrong? I am very confused on this issue
I've been there 4 hours looking for a solution
any can help me?