SA-MP Forums Archive
MySQL Error | HELP PLEASE - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: MySQL Error | HELP PLEASE (/showthread.php?tid=271452)


MySQL Error | HELP PLEASE - Tigerkiller - 24.07.2011

Hi all.
My problem is when a player diconnected i will save all datas
but if i save banreason or bannedby i got this error
PHP код:
[17:40:36] [MySQL] Error (0): Failed to exeute query. Unknown column 'None' in 'field list'.
[17:40:36] [MySQL] Error (0): Failed to exeute query. Unknown column 'None' in 'field list'. 
in Banreason and Bannedby

PHP код:
public OnPlayerDisconnect(playerid, reason)
{
    if(PlayerLoggin[playerid] == true)
    {
        PlayerLoggin[playerid] = false;
        new query[200],name[24],escname[24];
        GetPlayerName(playerid,name,sizeof name);
        mysql_real_escape_string(name,escname);
        format(query,sizeof query,"UPDATE `Accounts` SET `Adminlevel` = %d WHERE `Nickname` = '%s'",Acc[playerid][Adminlevel],escname); mysql_query(query);
        format(query,sizeof query,"UPDATE `Accounts` SET `Geld` = %d WHERE `Nickname` = '%s'",Acc[playerid][Geld],escname); mysql_query(query);
        format(query,sizeof query,"UPDATE `Accounts` SET `Score` = %d WHERE `Nickname` = '%s'",Acc[playerid][Score],escname); mysql_query(query);
        format(query,sizeof query,"UPDATE `Accounts` SET `Warns` = %d WHERE `Nickname` = '%s'",Acc[playerid][Warns],escname); mysql_query(query);
        format(query,sizeof query,"UPDATE `Accounts` SET `Kills` = %d WHERE `Nickname` = '%s'",Acc[playerid][Kills],escname); mysql_query(query);
        format(query,sizeof query,"UPDATE `Accounts` SET `Deaths` = %d WHERE `Nickname` = '%s'",Acc[playerid][Deaths],escname); mysql_query(query);
        format(query,sizeof query,"UPDATE `Accounts` SET `Banned` = %d WHERE `Nickname` = '%s'",Acc[playerid][Banned],escname); mysql_query(query);
        format(query,sizeof query,"UPDATE `Accounts` SET `Bannedby` = %s WHERE `Nickname` = '%s'",Acc[playerid][Bannedby],escname); mysql_query(query);
        format(query,sizeof query,"UPDATE `Accounts` SET `Banreason` = %s WHERE `Nickname` = '%s'",Acc[playerid][Banreason],escname); mysql_query(query);
        mysql_free_result();
    }
    return 1;
} 
i hope anyone can help me.
ps: i use strickenkidґs mysql plugin

Re: MySQL Error | HELP PLEASE - a32112365445 - 25.07.2011

new escbannedby[24],escbanreason[64];
mysql_real_escape_string(Acc[playerid][Bannedby],escbannedby);
mysql_real_escape_string(Acc[playerid][Banreason],escbanreason);
format(query,sizeof query,"UPDATE `Accounts` SET `Bannedby` = '%s' WHERE `Nickname` = '%s'",escbannedby,escname); mysql_query(query);
format(query,sizeof query,"UPDATE `Accounts` SET `Banreason` = '%s' WHERE `Nickname` = '%s'",escbanreason,escname); mysql_query(query);

I think.