Hi leute.
ich habe mit strickenkid´s include ein login/registersystem erstellt und alles funktioniert.
mein problem ist das wenn ein spieler disconnected und banreason und bannedby gespeichert wird bekomm ich folgenden error/s
[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'.
hier werden die sachen gespeichert
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;
}
hoffe es kann mir wer helfen
EDIT: Kann mir keiner helfen ? / rechtschreibung
EDIT2: Problem gelöst dank Goldkiller