[Error] ​Error ID: 1064, You have an error in your SQL Syntax

Guten Tag,

Ich habe ein kleines Problem mit meiner Speicherung, ich habe mein altes Achievment-System wieder ausgegraben, und habe es eingefügt.
Ich kann mich einloggen, doch sobald ich ein Achievment mache, und danach versuche zu Reloggen, geht garnichts mehr. (Account wird nicht geladen)

In der MySQL-Log findet sich folgender Fehler:

Error ID: 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 '`ArchivmentLevel5`='0', `ArchivmentLevel10`='0', `ArchivmentLevel20`='0', `Archi' at line 1

Nun habe ich schon erfahren das new query nicht hoch genug gesetzt seinen kann, deshalb habe ich dieses von 128 auf 15000 gesetzt, aber immer noch das selbe Problem.
Vielleicht ist mir was wichtiges Entfallen, viele Augen sehen besser als 2 ^^.

Hier die Speicherung:

public OnPlayerLogin(playerid,password[])
{
RemoveBuildings(playerid);
new tmp[15000],
string[15000],
sendername[MAX_PLAYER_NAME],
Beschwerden = 0;
//new LoginChecker;
getdate(Jahr, Monat, Tag);
gettime(Stunde, Minute, Sekunde);
GetPlayerName(playerid, sendername, sizeof(sendername)); //Wir Speichern den Namen des Spielers in der Variable [i]SpielerInfo[playerid][pName][/i]
if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))//Wir fragen ab ob der angegebene Spieler auch Online ist, und kein NPC ist (nur zur sicherhheit)
{
new pwhashlol[129], teststr[512];
mysql_real_escape_string(sendername, sendername);
WP_Hash(pwhashlol,sizeof(pwhashlol),password);
format(teststr, sizeof(teststr),"SELECT * FROM `users` WHERE Name = '%s' AND Password = '%s'", sendername,pwhashlol);
self_mysql_queryEx(teststr);//wir holen uns alles aus der tabelle "tabelle_mit_den_haeusern"
mysql_store_result();//speichern dann das ergebniss
if(mysql_num_rows() == 0)
{
ShowPlayerDialog(playerid, Login, DIALOG_STYLE_PASSWORD, ""#SERVERNAME" Community: Passwort Falsch", "Das eingegebene Passwort ist Falsch, bitte versuche es erneut.","Login","Verlassen");
return 1;
}
new val[ 15000 ];
while(mysql_fetch_row_format(string,"|"))
{
self_mysql_get_field("Level", val); PlayerInfo[playerid][pLevel] = strval( val );
self_mysql_get_field("AdminLevel", val); PlayerInfo[playerid][pAdmin] = strval( val );
self_mysql_get_field("Checkpoint", val); CCP[playerid] = strval( val );
self_mysql_get_field("CPrison", val); xPrison[playerid] = strval( val );
self_mysql_get_field("RunningCP", val); RunningCP[playerid] = strval( val );
self_mysql_get_field("Rolex", val); PlayerInfo[playerid][pRolex] = strval( val );
self_mysql_get_field("Swissonic", val); PlayerInfo[playerid][pSwissonic] = strval( val );
self_mysql_get_field("Casio", val); PlayerInfo[playerid][pCasio] = strval( val );
self_mysql_get_field("Breitling", val); PlayerInfo[playerid][pBreitling] = strval( val );
self_mysql_get_field("Nixon", val); PlayerInfo[playerid][pNixon] = strval( val );
self_mysql_get_field("IceWatch", val); PlayerInfo[playerid][pIceWatch] = strval( val );
self_mysql_get_field("StartCoints", val); PlayerInfo[playerid][pStartCoints] = strval( val );
self_mysql_get_field("Coints", val); PlayerInfo[playerid][pCoints] = strval( val );
self_mysql_get_field("Spawnheal", val); PlayerInfo[playerid][pSpawnheal] = strval( val );
self_mysql_get_field("Deaglespawn", val); PlayerInfo[playerid][pDeaglespawn] = strval( val );
self_mysql_get_field("M4Spawn", val); PlayerInfo[playerid][pM4Spawn] = strval( val );
self_mysql_get_field("MP5Spawn", val); PlayerInfo[playerid][pMP5Spawn] = strval( val );
self_mysql_get_field("MehrZinsen", val); PlayerInfo[playerid][pMehrZinsen] = strval( val );
self_mysql_get_field("SpawnhealZeit", val); PlayerInfo[playerid][pSpawnhealZeit] = strval( val );
self_mysql_get_field("DeaglespawnZeit", val); PlayerInfo[playerid][pDeaglespawnZeit] = strval( val );
self_mysql_get_field("M4SpawnZeit", val); PlayerInfo[playerid][pM4SpawnZeit] = strval( val );
self_mysql_get_field("MP5SpawnZeit", val); PlayerInfo[playerid][pMP5SpawnZeit] = strval( val );
self_mysql_get_field("MehrZinsenZeit", val); PlayerInfo[playerid][pMehrZinsenZeit] = strval( val );
self_mysql_get_field("Medickit", val); PlayerInfo[playerid][pMedickit] = strval( val );
//self_mysql_get_field("OsterEi1", val); PlayerInfo[playerid][pOsterEi1] = strval ( val );
//self_mysql_get_field("OsterEi2", val); PlayerInfo[playerid][pOsterEi2] = strval ( val );
//self_mysql_get_field("OsterEi3", val); PlayerInfo[playerid][pOsterEi3] = strval ( val );
//self_mysql_get_field("OsterEi4", val); PlayerInfo[playerid][pOsterEi4] = strval ( val );
//self_mysql_get_field("OsterEi5", val); PlayerInfo[playerid][pOsterEi5] = strval ( val );
//self_mysql_get_field("AlleEier", val); PlayerInfo[playerid][pAlleEier] = strval ( val );
self_mysql_get_field("FreiKarte", val); PlayerInfo[playerid][pFreiKarte] = strval ( val );
self_mysql_get_field("Helfer", val); PlayerInfo[playerid][pHelfer] = strval ( val );
self_mysql_get_field("Startbonus", val); PlayerInfo[playerid][pStartbonus] = strval ( val );
self_mysql_get_field("MeineWGrenze", val); PlayerInfo[playerid][pMeineWGrenze] = strval ( val );
self_mysql_get_field("MeineDGrenze", val); PlayerInfo[playerid][pMeineDGrenze] = strval ( val );
self_mysql_get_field("Kreditkarte", val); PlayerInfo[playerid][pKreditkarte] = strval( val );
self_mysql_get_field("KreditkarteBenutzung", val); PlayerInfo[playerid][pKreditkartebenutzen] = strval( val );
self_mysql_get_field("Personalausweis",val); PlayerInfo[playerid][pPersonalausweis] = strval ( val );
self_mysql_get_field("Namechange", val); PlayerInfo[playerid][pSchongeandert] = strval( val );
self_mysql_get_field("krankenkasse", val); PlayerInfo[playerid][pKrankenkasse] = strval( val );
self_mysql_get_field("krankenzeit", val); PlayerInfo[playerid][pKrankenkasseTime] = strval( val );
self_mysql_get_field("DonateRank", val); PlayerInfo[playerid][pDonatorRank] = strval( val );
self_mysql_get_field("UpgradePoints", val); PlayerInfo[playerid][gPupgrade] = strval( val );
self_mysql_get_field("ConnectedTime", val); PlayerInfo[playerid][pConnectTime] = strval( val );
self_mysql_get_field("Registered", val); PlayerInfo[playerid][pReg] = strval( val );
self_mysql_get_field("Sex", val); PlayerInfo[playerid][pSex] = strval( val );
self_mysql_get_field("Age", val); PlayerInfo[playerid][pAlter] = strval( val );
self_mysql_get_field("Origin", val); PlayerInfo[playerid][pOrigin] = strval( val );
self_mysql_get_field("Muted", val); PlayerInfo[playerid][pMuted] = strval( val );
self_mysql_get_field("Respect", val); PlayerInfo[playerid][pRespekt] = strval( val );
self_mysql_get_field("Gehalt",val); PlayerInfo[playerid][pGehalt] = strval( val );
self_mysql_get_field("Money", val); PlayerInfo[playerid][pCash] = strval( val );
self_mysql_get_field("Bank", val); PlayerInfo[playerid][pBank] = strval( val );
self_mysql_get_field("Allowed", val); PlayerInfo[playerid][pAllowed] = strval( val );
self_mysql_get_field("Crimes", val); PlayerInfo[playerid][pCrimes] = strval( val );
self_mysql_get_field("Kills", val); PlayerInfo[playerid][pKills] = strval( val );
self_mysql_get_field("sKills", val); PlayerInfo[playerid][psKills] = strval( val );
self_mysql_get_field("Deaths", val); PlayerInfo[playerid][pDeaths] = strval( val );
self_mysql_get_field("Arrested", val); PlayerInfo[playerid][pArrested] = strval( val );
self_mysql_get_field("ArrestTime", val); PlayerInfo[playerid][pArrestTime] = strval( val );
self_mysql_get_field("PhoneBook", val); PlayerInfo[playerid][pPhoneBook] = strval( val );
self_mysql_get_field("LottoNr", val); PlayerInfo[playerid][pLottoNr] = strval( val );
self_mysql_get_field("Fishes", val); PlayerInfo[playerid][pFishes] = strval( val );
self_mysql_get_field("BiggestFish", val); PlayerInfo[playerid][pBiggestFish] = strval( val );
self_mysql_get_field("Job", val); PlayerInfo[playerid][pJob] = strval( val );
self_mysql_get_field("Paycheck", val); PlayerInfo[playerid][pPayCheck] = strval( val );
self_mysql_get_field("HeadValue", val); PlayerInfo[playerid][pHeadValue] = strval( val );
self_mysql_get_field("Jailed", val); PlayerInfo[playerid][pJailed] = strval( val );
self_mysql_get_field("JailTime", val); PlayerInfo[playerid][pJailTime] = strval( val );
self_mysql_get_field("Leader", val); PlayerInfo[playerid][pLeader] = strval( val );
self_mysql_get_field("Member", val); PlayerInfo[playerid][pMember] = strval( val );
self_mysql_get_field("Rank", val); PlayerInfo[playerid][pRank] = strval( val );
self_mysql_get_field("Skin", val); PlayerInfo[playerid][pChar] = strval( val );
self_mysql_get_field("Vertragszeit", val); PlayerInfo[playerid][pVertragszeit] = strval( val );
self_mysql_get_field("DetSkill", val); PlayerInfo[playerid][pDetSkill] = strval( val );
self_mysql_get_field("SexSkill", val); PlayerInfo[playerid][pSexSkill] = strval( val );
self_mysql_get_field("LawSkill", val); PlayerInfo[playerid][pAnwaltSkill] = strval( val );
self_mysql_get_field("MechSkill", val); PlayerInfo[playerid][pMechSkill] = strval( val );
self_mysql_get_field("JackSkill", val); PlayerInfo[playerid][pJackSkill] = strval( val );
self_mysql_get_field("CarSkill", val); PlayerInfo[playerid][pCarSkill] = strval( val );
self_mysql_get_field("NewsSkill", val); PlayerInfo[playerid][pNewsSkill] = strval( val );
self_mysql_get_field("DrugsSkill", val); PlayerInfo[playerid][pDrugsSkill] = strval( val );
self_mysql_get_field("CookSkill", val); PlayerInfo[playerid][pCookSkill] = strval( val );
self_mysql_get_field("FishSkill", val); PlayerInfo[playerid][pFishSkill] = strval( val );
self_mysql_get_field("pSHealth", val); PlayerInfo[playerid][pSHealth] = floatstr( val );
self_mysql_get_field("PhoneNr", val); PlayerInfo[playerid][pNummer] = strval( val );
self_mysql_get_field("House", val); PlayerInfo[playerid][pPhousekey] = strval( val );
self_mysql_get_field("Hotel",val); PlayerInfo[playerid][pPhotelkey] = strval( val );
self_mysql_get_field("Biz", val); PlayerInfo[playerid][pBizKey] = strval( val );
self_mysql_get_field("CarLic", val); PlayerInfo[playerid][pCarLic] = strval( val );
self_mysql_get_field("FlyLic", val); PlayerInfo[playerid][pFlyLic] = strval( val );
self_mysql_get_field("BoatLic", val); PlayerInfo[playerid][pBoatLic] = strval( val );
self_mysql_get_field("FishLic", val); PlayerInfo[playerid][pFishLic] = strval( val );
self_mysql_get_field("GunLic", val); PlayerInfo[playerid][pGunLic] = strval( val );
self_mysql_get_field("Zollpass", val); PlayerInfo[playerid][pZollpass] = strval( val );
self_mysql_get_field("Gun1", val); PlayerInfo[playerid][pGun1] = strval( val );
self_mysql_get_field("Gun2", val); PlayerInfo[playerid][pGun2] = strval( val );
self_mysql_get_field("Gun3", val); PlayerInfo[playerid][pGun3] = strval( val );
self_mysql_get_field("Gun4", val); PlayerInfo[playerid][pGun4] = strval( val );
self_mysql_get_field("Ammo1", val); PlayerInfo[playerid][pAmmo1] = strval( val );
self_mysql_get_field("Ammo2", val); PlayerInfo[playerid][pAmmo2] = strval( val );
self_mysql_get_field("Ammo3", val); PlayerInfo[playerid][pAmmo3] = strval( val );
self_mysql_get_field("Ammo4", val); PlayerInfo[playerid][pAmmo4] = strval( val );
self_mysql_get_field("CarTime", val); PlayerInfo[playerid][pCarTime] = strval( val );
self_mysql_get_field("PayDay", val); PlayerInfo[playerid][pPayDay] = strval( val );
self_mysql_get_field("PayDayHad", val); PlayerInfo[playerid][pPayDayHad] = strval( val );
self_mysql_get_field("CDPlayer", val); PlayerInfo[playerid][pCDPlayer] = strval( val );
self_mysql_get_field("AlcoholPerk", val); PlayerInfo[playerid][pAlcoholPerk] = strval( val );
self_mysql_get_field("DrugPerk", val); PlayerInfo[playerid][pDrugPerk] = strval( val );
self_mysql_get_field("MiserPerk", val); PlayerInfo[playerid][pMiserPerk] = strval( val );
self_mysql_get_field("TraderPerk", val); PlayerInfo[playerid][pTraderPerk] = strval( val );
self_mysql_get_field("PainKillerPerk", val); PlayerInfo[playerid][pPainKillerPerk] = strval( val );
self_mysql_get_field("DonutPerk", val); PlayerInfo[playerid][pDonutPerk] = strval ( val );
self_mysql_get_field("Peilsender", val); PlayerInfo[playerid][pPeilsender] = strval ( val );
self_mysql_get_field("Panzerung", val); PlayerInfo[playerid][pPanzerung] = strval ( val );
self_mysql_get_field("Munition", val); PlayerInfo[playerid][pMunition] = strval ( val );
self_mysql_get_field("Gefängniskosten", val); PlayerInfo[playerid][pJailkosten] = strval ( val );
self_mysql_get_field("Tutorial", val); PlayerInfo[playerid][pTut] = strval( val );
self_mysql_get_field("Warnings", val); PlayerInfo[playerid][pWarns] = strval( val );
self_mysql_get_field("Fuel", val); PlayerInfo[playerid][pFuel] = strval( val );
self_mysql_get_field("Married", val); PlayerInfo[playerid][pMarried] = strval( val );
self_mysql_get_field("MarriedTo", val); strmid(PlayerInfo[playerid][pMarriedTo], val, 0, strlen(val), 255);
self_mysql_get_field("WantedLevel", val); PlayerInfo[playerid][pWantedLevel] = strval( val );
self_mysql_get_field("Spawn", val); PlayerInfo[playerid][pSpawn] = strval( val );
self_mysql_get_field("SavedMaterials", val); PlayerInfo[playerid][pSaveMats] = strval( val );
self_mysql_get_field("SavedDrugs", val); PlayerInfo[playerid][pSaveDrugs] = strval( val );
self_mysql_get_field("SaveCodes", val); PlayerInfo[playerid][pSaveCodes] = strval( val );
self_mysql_get_field("BikeLic", val); PlayerInfo[playerid][pBikeLic] = strval( val );
self_mysql_get_field("LKWLic", val); PlayerInfo[playerid][pLKWLic] = strval( val );
self_mysql_get_field("DonatorTime", val); PlayerInfo[playerid][pDonatorZeit] = strval( val );
self_mysql_get_field("WerberName", val); strmid(PlayerInfo[playerid][pWerberName], val, 0, strlen(val), 255);
self_mysql_get_field("FightingStyle", val); PlayerInfo[playerid][pFightingStyle] = strval( val );
self_mysql_get_field("Handy", val); PlayerInfo[playerid][pHandy] = strval( val );
self_mysql_get_field("OnDutySkin", val); PlayerInfo[playerid][pOnDutySkin] = strval( val );
self_mysql_get_field("CarLicPoints", val); PlayerInfo[playerid][pCarLicPoints] = strval( val );
self_mysql_get_field("BikeLicPoints", val); PlayerInfo[playerid][pBikeLicPoints] = strval( val );
self_mysql_get_field("InviteSperre", val); PlayerInfo[playerid][pInviteSperre] = strval( val );
self_mysql_get_field("warntime1", val); PlayerInfo[playerid][pWarnTime1] = strval( val );
self_mysql_get_field("warntime2", val); PlayerInfo[playerid][pWarnTime2] = strval( val );
self_mysql_get_field("Ticketsopen", val); PlayerInfo[playerid][pTicketsopen] = strval( val );
self_mysql_get_field("OldName", val); strmid(PlayerInfo[playerid][pOldName], val, 0, strlen(val), 255);
self_mysql_get_field("OrgMember", val); PlayerInfo[playerid][pOrgaID] = strval( val );
self_mysql_get_field("OrgLeader", val); PlayerInfo[playerid][pOrgaLeader] = strval( val );
self_mysql_get_field("OrgManager", val); PlayerInfo[playerid][pOrgaManager] = strval ( val );
self_mysql_get_field("OrgName", val); strmid(PlayerInfo[playerid][pOrgaName], val, 0, strlen(val), 255);
self_mysql_get_field("SQLid", val); PlayerInfo[playerid][pSQLID] = strval( val );
self_mysql_get_field("OPBeschwerden", val); Beschwerden = strval( val );
self_mysql_get_field("RegisterFinish", val); PlayerInfo[playerid][pRegisterFinish] = strval( val );
self_mysql_get_field("Banned", val); PlayerInfo[playerid][pBanned] = strval( val );
self_mysql_get_field("EMail", val); strmid(PlayerInfo[playerid][pEmail], val, 0, strlen(val), 255);
self_mysql_get_field("ArchivmentLevel5", val); PlayerInfo[playerid][pArchivmentLevel5] = strval( val );
self_mysql_get_field("ArchivmentLevel10", val); PlayerInfo[playerid][pArchivmentLevel10] = strval( val );
self_mysql_get_field("ArchivmentLevel20", val); PlayerInfo[playerid][pArchivmentLevel20] = strval( val );
self_mysql_get_field("ArchivmentMillionaer", val); PlayerInfo[playerid][pArchivmentMillionaer] = strval( val );
self_mysql_get_field("ArchivmentUrgestein", val); PlayerInfo[playerid][pArchivmentUrgestein] = strval( val );
self_mysql_get_field("ArchivmentGov",val); PlayerInfo[playerid][pArchivmentGov] = strval ( val );
self_mysql_get_field("ArchivmentGF",val); PlayerInfo[playerid][pArchivmentGF] = strval ( val );
self_mysql_get_field("ArchivmentHouse",val); PlayerInfo[playerid][pArchivmentHouse] = strval ( val );
self_mysql_get_field("ArchivmentErsterBlick",val); PlayerInfo[playerid][pArchivmentErsterBlick] = strval ( val );
self_mysql_get_field("ArchivmentCoP",val); PlayerInfo[playerid][pArchivmentCoP] = strval ( val );
self_mysql_get_field("ArchivmentPresident",val); PlayerInfo[playerid][pArchivmentPresident] = strval ( val );
self_mysql_get_field("ArchivmentLive",val); PlayerInfo[playerid][pArchivmentLive] = strval ( val );
self_mysql_get_field("ArchivmentNFS",val); PlayerInfo[playerid][pArchivmentNFS] = strval ( val );
self_mysql_get_field("ArchivmentWanted",val); PlayerInfo[playerid][pArchivmentWanted] = strval ( val );
self_mysql_get_field("ArchivmentGangKills20",val); PlayerInfo[playerid][pArchivmentGangKills20] = strval ( val );
self_mysql_get_field("ArchivmentHeisseWare",val); PlayerInfo[playerid][pArchivmentHeisseWare] = strval ( val );
self_mysql_get_field("ArchivmentFarmer",val); PlayerInfo[playerid][pArchivmentFarmer] = strval ( val );
self_mysql_get_field("ArchivmentDrogen",val); PlayerInfo[playerid][pArchivmentDrogen] = strval ( val );
self_mysql_get_field("ArchivmentDienstMarke",val); PlayerInfo[playerid][pArchivmentDienstMarke] = strval ( val );
self_mysql_get_field("ArchivmentHeisenberg",val); PlayerInfo[playerid][pArchivmentHeisenberg] = strval ( val );
self_mysql_get_field("ArchivmentHomeTown",val); PlayerInfo[playerid][pArchivmentHomeTown] = strval ( val );
self_mysql_get_field("ArchivmentBankRaub",val); PlayerInfo[playerid][pArchivmentBankRaub] = strval ( val );
self_mysql_get_field("ArchivmentAON",val); PlayerInfo[playerid][pArchivmentAON] = strval ( val );
self_mysql_get_field("ArchivmentAssasine",val); PlayerInfo[playerid][pArchivmentAssasine] = strval ( val );
self_mysql_get_field("ArchivmentSniper",val); PlayerInfo[playerid][pArchivmentSniper] = strval ( val );
self_mysql_get_field("ArchivmentMostWanted",val); PlayerInfo[playerid][pArchivmentMostWanted] = strval ( val );
self_mysql_get_field("ArchivmentKing",val); PlayerInfo[playerid][pArchivmentKing] = strval ( val );
self_mysql_get_field("ArchivmentSMS",val); PlayerInfo[playerid][pArchivmentSMS] = strval ( val );
self_mysql_get_field("ArchivmentAD",val); PlayerInfo[playerid][pArchivmentAD] = strval ( val );
self_mysql_get_field("ArchivmentSterben",val); PlayerInfo[playerid][pArchivmentSterben] = strval ( val );
self_mysql_get_field("ArchivmentSense",val); PlayerInfo[playerid][pArchivmentSense] = strval ( val );
self_mysql_get_field("ArchivmentPleite",val); PlayerInfo[playerid][pArchivmentPleite] = strval ( val );
mysql_free_result();
}

public PlayerUpdate(playerid)
{
if(IsPlayerConnected(playerid))
{
if(IsPlayerNPC(playerid))
{
return 1;
}
new playername[MAX_PLAYER_NAME];
GetPlayerName(playerid, playername, sizeof(playername));
new endstring[10600];
new var[15000];
new Float: p[4];
GetPlayerPos(playerid, p[0], p[1], p[2]);
GetPlayerFacingAngle(playerid, p[3]);
format(endstring, sizeof(endstring), "UPDATE `users` SET ");
format(var, sizeof(var), "`Level`='%d', ", PlayerInfo[playerid][pLevel]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`AdminLevel`='%d', ", PlayerInfo[playerid][pAdmin]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Checkpoint`='%d', ", CCP[playerid]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`CPrison`='%d', ", xPrison[playerid]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`RunningCP`='%d', ", RunningCP[playerid]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Rolex`='%d', ", PlayerInfo[playerid][pRolex]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Swissonic`='%d', ", PlayerInfo[playerid][pSwissonic]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Casio`='%d', ", PlayerInfo[playerid][pCasio]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Breitling`='%d', ", PlayerInfo[playerid][pBreitling]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Nixon`='%d', ", PlayerInfo[playerid][pNixon]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`IceWatch`='%d', ", PlayerInfo[playerid][pIceWatch]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`StartCoints`='%d', ", PlayerInfo[playerid][pStartCoints]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Coints`='%d', ", PlayerInfo[playerid][pCoints]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Spawnheal`='%d', ", PlayerInfo[playerid][pSpawnheal]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Deaglespawn`='%d', ", PlayerInfo[playerid][pDeaglespawn]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`M4Spawn`='%d', ", PlayerInfo[playerid][pM4Spawn]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`MP5Spawn`='%d', ", PlayerInfo[playerid][pMP5Spawn]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`MehrZinsen`='%d', ", PlayerInfo[playerid][pMehrZinsen]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`SpawnhealZeit`='%d', ", PlayerInfo[playerid][pSpawnhealZeit]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`DeaglespawnZeit`='%d', ", PlayerInfo[playerid][pDeaglespawnZeit]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`M4SpawnZeit`='%d', ", PlayerInfo[playerid][pM4SpawnZeit]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`MP5SpawnZeit`='%d', ", PlayerInfo[playerid][pMP5SpawnZeit]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`MehrZinsenZeit`='%d', ", PlayerInfo[playerid][pMehrZinsenZeit]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Medickit`='%d', ", PlayerInfo[playerid][pMedickit]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Startbonus`='%d', ", PlayerInfo[playerid][pStartbonus]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`MeineWGrenze`='%d', ", PlayerInfo[playerid][pMeineWGrenze]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`MeineDGrenze`='%d', ", PlayerInfo[playerid][pMeineDGrenze]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`FreiKarte`='%d', ", PlayerInfo[playerid][pFreiKarte]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Helfer`='%d', ", PlayerInfo[playerid][pHelfer]);
strcat(endstring, var, sizeof(endstring));
/*format(var, sizeof(var), "`OsterEi1`='%d', ", PlayerInfo[playerid][pOsterEi1]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`OsterEi2`='%d', ", PlayerInfo[playerid][pOsterEi2]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`OsterEi3`='%d', ", PlayerInfo[playerid][pOsterEi3]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`OsterEi4`='%d', ", PlayerInfo[playerid][pOsterEi4]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`OsterEi5`='%d', ", PlayerInfo[playerid][pOsterEi5]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`AlleEier`='%d', ", PlayerInfo[playerid][pAlleEier]);
strcat(endstring, var, sizeof(endstring));*/
format(var, sizeof(var), "`Kreditkarte`='%d', ", PlayerInfo[playerid][pKreditkarte]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`KreditkarteBenutzung`='%d', ", PlayerInfo[playerid][pKreditkartebenutzen]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Personalausweis`='%d', ", PlayerInfo[playerid][pPersonalausweis]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Namechange`='%d', ", PlayerInfo[playerid][pSchongeandert]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`krankenkasse`='%d', ", PlayerInfo[playerid][pKrankenkasse]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`krankenzeit`='%d', ", PlayerInfo[playerid][pKrankenkasseTime]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`DonateRank`='%d', ", PlayerInfo[playerid][pDonatorRank]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`UpgradePoints`='%d', ", PlayerInfo[playerid][gPupgrade]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`ConnectedTime`='%d', ", PlayerInfo[playerid][pConnectTime]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Registered`='%d', ", PlayerInfo[playerid][pReg]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Sex`='%d', ", PlayerInfo[playerid][pSex]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Age`='%d', ", PlayerInfo[playerid][pAlter]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Origin`='%d', ", PlayerInfo[playerid][pOrigin]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Muted`='%d', ", PlayerInfo[playerid][pMuted]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Respect`='%d', ", PlayerInfo[playerid][pRespekt]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Gehalt`='%d', ", PlayerInfo[playerid][pGehalt]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Money`='%d', ", PlayerInfo[playerid][pCash]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Bank`='%d', ", PlayerInfo[playerid][pBank]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Allowed`='%d', ", PlayerInfo[playerid][pAllowed]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Crimes`='%d', ", PlayerInfo[playerid][pCrimes]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Kills`='%d', ", PlayerInfo[playerid][pKills]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`sKills`='%d', ", PlayerInfo[playerid][psKills]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Deaths`='%d', ", PlayerInfo[playerid][pDeaths]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Arrested`='%d', ", PlayerInfo[playerid][pArrested]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`ArrestTime`='%d', ", PlayerInfo[playerid][pArrestTime]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`PhoneBook`='%d', ", PlayerInfo[playerid][pPhoneBook]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`LottoNr`='%d', ", PlayerInfo[playerid][pLottoNr]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Fishes`='%d', ", PlayerInfo[playerid][pFishes]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`BiggestFish`='%d', ", PlayerInfo[playerid][pBiggestFish]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Job`='%d', ", PlayerInfo[playerid][pJob]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Paycheck`='%d', ", PlayerInfo[playerid][pPayCheck]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`RegisterFinish`='%d'", PlayerInfo[playerid][pRegisterFinish]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var),"`ArchivmentLevel5`='%d', ", PlayerInfo[playerid][pArchivmentLevel5]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var),"`ArchivmentLevel10`='%d', ", PlayerInfo[playerid][pArchivmentLevel10]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var),"`ArchivmentLevel20`='%d', ", PlayerInfo[playerid][pArchivmentLevel20]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var),"`ArchivmentMillionaer`='%d', ", PlayerInfo[playerid][pArchivmentMillionaer]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var),"`ArchivmentUrgestein`='%d', ", PlayerInfo[playerid][pArchivmentUrgestein]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var),"`ArchivmentGov`='%d', ", PlayerInfo[playerid][pArchivmentGov]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var),"`ArchivmentGF`='%d', ", PlayerInfo[playerid][pArchivmentGF]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var),"`ArchivmentHouse`='%d', ", PlayerInfo[playerid][pArchivmentHouse]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var),"`ArchivmentErsterBlick`='%d', ", PlayerInfo[playerid][pArchivmentErsterBlick]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var),"`ArchivmentCoP`='%d', ", PlayerInfo[playerid][pArchivmentCoP]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var),"`ArchivmentPresident`='%d', ", PlayerInfo[playerid][pArchivmentPresident]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var),"`ArchivmentLive`='%d', ", PlayerInfo[playerid][pArchivmentLive]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var),"`ArchivmentNFS`='%d', ", PlayerInfo[playerid][pArchivmentNFS]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var),"`ArchivmentWanted`='%d', ", PlayerInfo[playerid][pArchivmentWanted]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var),"`ArchivmentGangKills20`='%d', ", PlayerInfo[playerid][pArchivmentGangKills20]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var),"`ArchivmentHeisseWare`='%d', ", PlayerInfo[playerid][pArchivmentHeisseWare]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var),"`ArchivmentFarmer`='%d', ", PlayerInfo[playerid][pArchivmentFarmer]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var),"`ArchivmentDrogen`='%d', ", PlayerInfo[playerid][pArchivmentDrogen]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var),"`ArchivmentDienstMarke`='%d', ", PlayerInfo[playerid][pArchivmentDienstMarke]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var),"`ArchivmentHeisenberg`='%d', ", PlayerInfo[playerid][pArchivmentHeisenberg]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var),"`ArchivmentHomeTown`='%d', ", PlayerInfo[playerid][pArchivmentHomeTown]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var),"`ArchivmentBankRaub`='%d', ", PlayerInfo[playerid][pArchivmentBankRaub]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var),"`ArchivmentAON`='%d', ", PlayerInfo[playerid][pArchivmentAON]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var),"`ArchivmentAssasine`='%d', ", PlayerInfo[playerid][pArchivmentAssasine]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var),"`ArchivmentSniper`='%d', ", PlayerInfo[playerid][pArchivmentSniper]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var),"`ArchivmentMostWanted`='%d', ", PlayerInfo[playerid][pArchivmentMostWanted]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var),"`ArchivmentKing`='%d', ", PlayerInfo[playerid][pArchivmentKing]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var),"`ArchivmentSMS`='%d', ", PlayerInfo[playerid][pArchivmentSMS]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var),"`ArchivmentAD`='%d', ", PlayerInfo[playerid][pArchivmentAD]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var),"`ArchivmentSterben`='%d', ", PlayerInfo[playerid][pArchivmentSterben]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var),"`ArchivmentSense`='%d', ", PlayerInfo[playerid][pArchivmentSense]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var),"`ArchivmentPleite`='%d', ", PlayerInfo[playerid][pArchivmentPleite]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), " WHERE `Name`='%s'", playername);
strcat(endstring, var, sizeof(endstring));
printf(endstring);
self_mysql_queryEx(endstring);

Die Achievments sind ganz unten.

Gruß,
Shadow

Zitat von ZeroTheHero

Letzter Code von dir, Zeile 149, fehlt ein Leerzeichen.

Dein Code:
format(var, sizeof(var), "`RegisterFinish`='%d'", PlayerInfo[playerid][pRegisterFinish]);

Wie es mMn sein müsste:
format(var, sizeof(var), "`RegisterFinish`='%d' ", PlayerInfo[playerid][pRegisterFinish]);

Hey,

Danke! Ist mir gar nicht aufgefallen, dennoch speichern die Achievments leider nach dem selben Chema wie erwähnt nicht

Zitat von ZeroTheHero

Hmmm

Ich sehe du hast in Zeile 217 einen print. Könntest du den mal eben hier rein posten?

Soll ich jetzt alle Treffer mit "printf" hier rein schicken? oder wie meinst du das?

printf("SERVER: Der Server wurde erfolgreich gestartet");
new string3[123];
for(new i=0; i<MAX_PLAYERS;i++){
if(IsPlayerConnected(i)){
format(string3, sizeof(string3), "UPDATE `users` SET `Status`='0'");
self_mysql_queryEx(string3);
format(string3, sizeof(string3), "UPDATE `users` SET `Legende`='0'");
self_mysql_queryEx(string3);
}
}
mysql_debug(1);//um alles MySQL zu debuggen 0 = Aus -> 1 = An
new string[MAX_PLAYER_NAME],
string1[MAX_PLAYER_NAME],
string2[256];

#if defined MySQL
MySQLConnection = mysql_connect(MySQL_Host, MySQL_User, MySQL_DB, MySQL_Passwort);
printf("SERVER: Versucht die Verbindung zur Datenbank aufzubauen");
#endif

LoadProperty();
printf("OnGamemodeInt: LoadProperty");
LoadBiz();
printf("OnGamemodeInt: LoadBiz");
LoadSBiz();
printf("OnGamemodeInt: LoadSBiz");
LoadTankenBiz();
printf("OnGamemodeInt: LoadTankenBiz");
LoadGangAutos();
printf("OnGamemodeInt: LoadGangAutos");
LoadStuff();
printf("OnGamemodeInt: LoadStuff");
LoadKassenInfo();
printf("OnGamemodeInt: LoadKassenInfo");
LoadGangfightZones();
printf("OnGamemodeInt: LoadGangfightZones");
LoadGangWarInfos();
printf("OnGamemodeInt: LoadGangWarInfos");
LoadGangmotd();
printf("OnGamemodeInt: LoadGangMotds");
LoadGangBNDInfos();
printf("OnGamemodeInt: LoadGangBNDInfos");

AntiDeAMX();
printf("AntiDeAMX aufgerufen");
News[hTaken1] = 0; News[hTaken2] = 0; News[hTaken3] = 0; News[hTaken4] = 0; News[hTaken5] = 0;
format(string, sizeof(string), "Nothing");
strmid(News[hAdd1], string, 0, strlen(string), 255);
strmid(News[hAdd2], string, 0, strlen(string), 255);
strmid(News[hAdd3], string, 0, strlen(string), 255);
strmid(News[hAdd4], string, 0, strlen(string), 255);
strmid(News[hAdd5], string, 0, strlen(string), 255);
format(string1, sizeof(string1), "Niemand");
strmid(News[hContact1], string1, 0, strlen(string1), 255);
strmid(News[hContact2], string1, 0, strlen(string1), 255);
strmid(News[hContact3], string1, 0, strlen(string1), 255);
strmid(News[hContact4], string1, 0, strlen(string1), 255);
strmid(News[hContact5], string1, 0, strlen(string1), 255);
PlayerHaul[1][pCapasity] = 150;
PlayerHaul[2][pCapasity] = 150;
PlayerHaul[3][pCapasity] = 150;
PlayerHaul[4][pCapasity] = 150;
PlayerHaul[5][pCapasity] = 75;
PlayerHaul[6][pCapasity] = 75;
PlayerHaul[7][pCapasity] = 75;
//SetPDistance(40);
SetNameTagDrawDistance(30.0);
EnableStuntBonusForAll(0);
AllowInteriorWeapons(1);
AllowAdminTeleport(1);
DisableInteriorEnterExits();
ManualVehicleEngineAndLights();

printf("Beginne Autos zu spawnen");

printf("Autos wurden erfolgreich Geladen und Gespawnt");
UpdateTime();
printf("Gangautos werden Gespawnt...");
CreateGangAutos();
printf("Gangautos wurden erfolgreich Gespawn");
Create3DTexte();
printf("3DTexte erfolgreich Geladen");
SetTimer("ProTimer", 100, true);
SetProTimer("SetSekundenTimer1", 100, false);
SetProTimer("EiswagenTimer", 600, false);
SetProTimer("SetSekundenTimer3", 300, false);
SetProTimer("SetSekundenTimer5", 500, false);
SetProTimer("SetSekundenTimer6", 600, false);
SetProTimer("SetBlitzTimer", 600, false);
SetProTimer("STDCheck", 60000, true);
SetProTimer("CheckGas", 20000, true);
SetProTimer("GangPay", 60000*120,true);
SetProTimer("MinutenTimer", 1000*60, true);
SetProTimer("PickupTimer", 1000, true);
SetProTimer("Production", 600000, true);
SetProTimer("Keys", 500, true);
SetProTimer("ServerSaveTime", 3600000, true);
for(new veh = 0; veh < MAX_VEHICLES; veh++){
SetVehicleToRespawn(veh);
sirene[veh] = -1;
sirene1[veh] = -1;
sirene2[veh] = -1;
sirene3[veh] = -1;
}
printf("Autos wurden erfolgreich respawnt");
printf("Server erfolgreich gestartet");

[15:47:17] UPDATE `users` SET `Level`='41', `AdminLevel`='2000', `Checkpoint`='0', `CPrison`='0', `RunningCP`='0', `Rolex`='1', `Swissonic`='0', `Casio`='0', `Breitling`='0', `Nixon`='0', `IceWatch`='0', `StartCoints`='1', `Coints`='273', `Spawnheal`='0', `Deaglespawn`='0', `M4Spawn`='0', `MP5Spawn`='0', `MehrZinsen`='0', `SpawnhealZeit`='-1', `DeaglespawnZeit`='-1', `M4SpawnZeit`='-1', `MP5SpawnZeit`='-1', `MehrZinsenZeit`='0', `Medickit`='0', `Startbonus`='1', `MeineWGrenze`='1', `MeineDGrenze`='4720', `FreiKarte`='0', `Helfer`='2', `Kreditkarte`='1', `KreditkarteBenutzung`='1', `Personalausweis`='1', `Namechange`='57', `krankenkasse`='0', `krankenzeit`='54', `DonateRank`='2', `UpgradePoints`='8', `ConnectedTime`='351', `Registered`='1', `Sex`='1', `Age`='21', `Origin`='1', `Muted`='0', `Respect`='101', `Gehalt`='0', `Money`='2308254', `Bank`='290484903', `Allowed`='0', `Crimes`='638', `Kills`='573', `sKills`='71', `Deaths`='338', `Arrested`='89', `ArrestTime`='8670', `PhoneBook`='1', `LottoNr`='0', `Fishes`='0', `BiggestFish`='0', `Job`='0', `Paycheck`='0', `RegisterFinish`='1', `ArchivmentLevel5`='0', `ArchivmentLevel10`='0', `ArchivmentLevel20`='0', `ArchivmentMillionaer`='0', `ArchivmentUrgestein`='0', `ArchivmentGov`='0', `ArchivmentGF`='0', `ArchivmentHouse`='0', `ArchivmentErsterBlick`='0', `ArchivmentCoP`='0', `ArchivmentPresident`='0', `ArchivmentLive`='0', `ArchivmentNFS`='0', `ArchivmentWanted`='0', `ArchivmentGangKills20`='0', `ArchivmentHeisseWare`='0', `ArchivmentFarmer`='0', `ArchivmentDrogen`='1', `ArchivmentDienstMarke`='0', `ArchivmentHeisenberg`='1', `ArchivmentHomeTown`='0', `ArchivmentBankRaub`='0', `ArchivmentAON`='0', `ArchivmentAssasine`='0', `ArchivmentSniper`='0', `ArchivmentMostWanted`='0', `ArchivmentKing`='0', `ArchivmentSMS`='0', `ArchivmentAD`='0', `ArchivmentSterben`='0', `ArchivmentSense`='0', `ArchivmentPleite`='0', WHERE `Name`='Jon.Moxley'

[15:47:17] UPDATE `users` SET `HeadValue`='0', `Jailed`='0', `JailTime`='0', `Leader`='7', `Member`='-1', `Rank`='11', `Skin`='2', `Vertragszeit`='0', `DetSkill`='14599', `SexSkill`='0', `LawSkill`='0', `MechSkill`='0', `JackSkill`='0' WHERE `Name`='Jon.Moxley'

15:47:17] UPDATE `users` SET `CarSkill`='0', `NewsSkill`='18', `DrugsSkill`='0', `CookSkill`='0', `FishSkill`='0', `pSHealth`='100.0', `PhoneNr`='2901', `House`='112', `Hotel`='-1', `Biz`='-1', `CarLic`='1', `FlyLic`='1', `BoatLic`='1', `FishLic`='1', `GunLic`='1', `Zollpass`='0' WHERE `Name`='Jon.Moxley'
[15:47:17] UPDATE `users` SET `Gun1`='0', `Gun2`='0', `Gun3`='0', `Gun4`='0', `Ammo1`='0', `Ammo2`='0', `Ammo3`='0', `Ammo4`='0', `CarTime`='0', `PayDay`='21', `PayDayHad`='1', `CDPlayer`='0', `AlcoholPerk`='0', `PainKillerPerk`='5', `DrugPerk`='7', `MiserPerk`='0', `TraderPerk`='0', `DonutPerk`='4', `Peilsender`='1', `Panzerung`='2', `Munition`='2', `Gefängniskosten`='5', `Tutorial`='1', `Warnings`='0' WHERE `Name`='Jon.Moxley'
[15:47:17] UPDATE `users` SET `Fuel`='20', `Married`='0', `MarriedTo`='Niemand', `WantedLevel`='0', `Spawn`='0', `SavedMaterials`='67974', `SavedDrugs`='35058', `SaveCodes`='0', `BikeLic`='1', `LKWLic`='0', `DonatorTime`='1499181837', `WerberName`='Niemand', `FightingStyle`='5', `Handy`='2' WHERE `Name`='Jon.Moxley'
[15:47:17] UPDATE `users` SET `OnDutySkin`='165', `CarLicPoints`='0', `BikeLicPoints`='0', `InviteSperre`='1494506916', `warntime1`='0', `warntime2`='0', `Ticketsopen`='104', `DonatorTime`='1499181837', `OldName`='Mike_Shinoda', `ClientIP`='31.17.249.196', `OrgMember`='5', `OrgLeader`='-1', `OrgManager`='1', `OrgName`='Irish Crime Family', `Banned`='0', `Email`='Keine' WHERE `Name`='Jon.Moxley'
[15:47:17] UPDATE `users` SET `Level`='41', `AdminLevel`='2000', `Checkpoint`='0', `CPrison`='0', `RunningCP`='0', `Rolex`='1', `Swissonic`='0', `Casio`='0', `Breitling`='0', `Nixon`='0', `IceWatch`='0', `StartCoints`='1', `Coints`='273', `Spawnheal`='0', `Deaglespawn`='0', `M4Spawn`='0', `MP5Spawn`='0', `MehrZinsen`='0', `SpawnhealZeit`='-1', `DeaglespawnZeit`='-1', `M4SpawnZeit`='-1', `MP5SpawnZeit`='-1', `MehrZinsenZeit`='0', `Medickit`='0', `Startbonus`='1', `MeineWGrenze`='1', `MeineDGrenze`='4720', `FreiKarte`='0', `Helfer`='2', `Kreditkarte`='1', `KreditkarteBenutzung`='1', `Personalausweis`='1', `Namechange`='57', `krankenkasse`='0', `krankenzeit`='54', `DonateRank`='2', `UpgradePoints`='8', `ConnectedTime`='351', `Registered`='1', `Sex`='1', `Age`='21', `Origin`='1', `Muted`='0', `Respect`='101', `Gehalt`='0', `Money`='2308254', `Bank`='290484903', `Allowed`='0', `Crimes`='638', `Kills`='573', `sKills`='71', `Deaths`='338', `Arrested`='89', `ArrestTime`='8670', `PhoneBook`='1', `LottoNr`='0', `Fishes`='0', `BiggestFish`='0', `Job`='0', `Paycheck`='0', `RegisterFinish`='1', `ArchivmentLevel5`='0', `ArchivmentLevel10`='0', `ArchivmentLevel20`='0', `ArchivmentMillionaer`='0', `ArchivmentUrgestein`='0', `ArchivmentGov`='0', `ArchivmentGF`='0', `ArchivmentHouse`='0', `ArchivmentErsterBlick`='0', `ArchivmentCoP`='0', `ArchivmentPresident`='0', `ArchivmentLive`='0', `ArchivmentNFS`='0', `ArchivmentWanted`='0', `ArchivmentGangKills20`='0', `ArchivmentHeisseWare`='0', `ArchivmentFarmer`='0', `ArchivmentDrogen`='1', `ArchivmentDienstMarke`='0', `ArchivmentHeisenberg`='1', `ArchivmentHomeTown`='0', `ArchivmentBankRaub`='0', `ArchivmentAON`='0', `ArchivmentAssasine`='0', `ArchivmentSniper`='0', `ArchivmentMostWanted`='0', `ArchivmentKing`='0', `ArchivmentSMS`='0', `ArchivmentAD`='0', `ArchivmentSterben`='0', `ArchivmentSense`='0', `ArchivmentPleite`='0', WHERE `Name`='Jon.Moxley'

Das gibt er in der Console aus

Zitat von ZeroTheHero

Zeile 213 (1. Post 4. Code) von:
format(var, sizeof(var),"`ArchivmentPleite`='%d', ", PlayerInfo[playerid][pArchivmentPleite]);

Zu:
format(var, sizeof(var),"`ArchivmentPleite`='%d' ", PlayerInfo[playerid][pArchivmentPleite]);

Das "," vor dem WHERE könnte zum Fehler führen.

Das ist ja bei jeden Eintrag so, muss ich das dann bei jeden Eintrag entfernen oder nur bei diesen?

Zitat von ZeroTheHero

Nur bei diesem bestimmten, weil danach die WHERE Bedingung kommt.

Das scheint es augenscheinlich gewesen zu sein, die Achievments speichern, die Accounts laden, ich danke vielmals für die Hilfe, sitze da schon lange dran

Gruß,
Shadow