Hey,
jemand eine Ahnung, warum die Spielerdaten nicht gespeichert werden?
Geladen werden sie ohne Probleme, sollte also nicht an den Variablen/der Datenban
public SavePlayer(playerid)
{
new query[256];
mysql_format(mysql, query, sizeof(query), "UPDATE players SET IP='%s', Admin='%d', Level='%d', Kills='%d', Deaths='%d', Money='%d' Wanteds='%d' JailTime='%d' WHERE ID='%d'",\
IP[playerid], pData[playerid][Admin], pData[playerid][Level], pData[playerid][Kills], pData[playerid][Deaths], pData[playerid][Money], pData[playerid][Wanteds], pData[playerid][JailTime], pData[playerid][ID]);
mysql_tquery(mysql, query, "", "");
}
[15:01:18] [DEBUG] mysql_format - connection: 1, len: 256, format: "UPDATE players SET IP='%s', Admin='%d', Level='%d', Kills='%d', Deaths='%d', Money='%d' Wanteds='%d' JailTime='%d' WHERE ID='%d'"
[15:01:18] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE players SET IP='127.0.0.1', Admin='0', Level='1337', Kill", callback: "(null)", format: "(null)"
[15:01:18] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[15:01:18] [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 'Wanteds='0' JailTime='0' WHERE ID='1'' at line 1
[15:01:18] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
Ist das ganze zu lang? Weil es in der Log bei Kill" einfach abgeschnitten ist...