[Tigerkiller]

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

[a32112365445]

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.