Hallo.
Ich habe mein speichersystem auf MySQL und er macht alles schon fast PERFEKT außer ... eine einzige Stelle im AccSpeichern.
Ich sende euch mal den ErrorCode:
[20:10:38] _______________!!!Error!!!_______________
[20:10:38] ErrorID: 1064 |
[20:10:38] Error Text: 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 'XTCSucht`='0', `Koks`='0', `KoksSucht`='0', `Heroin`='0', `HeroinSucht`='0', `Ma' at line 1 |
[20:10:38] Result/Thread ID: -1 |
[20:10:38] Query Message: UPDATE accounts SET `XTC'='0', `XTCSucht`='0', `Koks`='0', `KoksSucht`='0', `Heroin`='0', `HeroinSucht`='0', `Mats`='0', `Knastzeit`='0', `InAlka`='0', `KnastSkin`='0', `Baned`='0', `TimeBan`='0', `SBan`='0', `Haus`='0', `Fightstyle`='4', `MuteTime`='0', `HandyNr`='0' WHERE Name='Patooo' |
[20:10:38] _________________________________________
Hier die PAWN Zeile:
format(gesamt,128,"UPDATE "ACCTABELLE" SET `XTC'='%i', `XTCSucht`='%i',",SInfo[playerid][SXTC],SInfo[playerid][SXTCSucht]);
format(sql,128," `Koks`='%i', `KoksSucht`='%i', `Heroin`='%i',",SInfo[playerid][SKoks],SInfo[playerid][SKoksSucht],SInfo[playerid][SHeroin]);strcat(gesamt,sql);
format(sql,128," `HeroinSucht`='%i', `Mats`='%i', `Knastzeit`='%i',",SInfo[playerid][SHeroinSucht],SInfo[playerid][SMats],SInfo[playerid][Knastzeit]);strcat(gesamt,sql);
format(sql,128," `InAlka`='%i', `KnastSkin`='%i', `Baned`='%i',",SInfo[playerid][InAlka],SInfo[playerid][KnastSkin],SInfo[playerid][Baned]);strcat(gesamt,sql);
format(sql,128," `TimeBan`='%d', `SBan`='%d', `Haus`='%i',",SInfo[playerid][TimeBan],SInfo[playerid][SBan],SInfo[playerid][Haus]);strcat(gesamt,sql);
format(sql,128," `Fightstyle`='%i', `MuteTime`='%i', `HandyNr`='%i'",GetPlayerFightingStyle(playerid),SInfo[playerid][MuteTime],SInfo[playerid][HandyNr]);strcat(gesamt,sql);
format(sql,36," WHERE Name='%s'",SInfo[playerid][Name]);strcat(gesamt,sql);
mysql_query(gesamt);
//edit: kann geclost werden