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

Wichtiger Hinweis: Bitte ändert nicht manuell die Schriftfarbe auf schwarz sondern belasst es bei der Standardeinstellung. Somit tragt ihr dazu bei dass euer Text auch bei Verwendung unseren dunklen Forenstils noch lesbar ist!

Tipp: Ihr wollt längere Codeausschnitte oder Logfiles bereitstellen? Benutzt unseren eigenen PasteBin-Dienst Link
  • 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

  • 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]);

  • 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 :(


  • 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");


  • Ich glaube du verstehst mich nicht ganz.. die Funktion "printf" gibt einen Text in der Server Konsole aus, auch hier näher erklärt: http://wiki.sa-mp.com/wiki/Printf


    Dementsprechend müsstest du durch folgende Zeile:
    printf(endstring);
    (zu finden im 4. Quallcode im 1. Post, Zeile 217)


    Einen Text in der Konsole finden, welcher den Query wiederspiegelt, der an die Datenbank gesendet wird.
    Diesen würde ich dich bitten hier rein zu posten.


    Der Text wird natürlich auch nur erscheinen, wenn die PlayerUpdate Funktion auch aufgerufen wird, daher musst du sie (höchstwahrscheinlich durch ein und wieder ausloggen) einmal aufrufen lassen.


  • [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

  • 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.

  • 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?