MySQL Speichert paar Variablen nicht

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 Abend, neuerdings Speichert unser Script einige Vars nicht mehr (Accounts). Unteranderem werden der OnDutySkin sowie die ClientIP nicht mehr gespeichert. Hat da vielleicht jemand eine Idee? Freue mich über jede Hilfe! Hier PlayerUpdate(playerid):


    Code
    public PlayerUpdate(playerid)
    {
    if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))
    {
    new playername[MAX_PLAYER_NAME];
    GetPlayerName(playerid, playername, sizeof(playername));
    new endstring[5000];
    new var[129];
    format(endstring, sizeof(endstring), "UPDATE `users` SET ");
    format(var, sizeof(var), "`Key`=MD5('%s'), ", PlayerInfo[playerid][pKey]); strcat(endstring, var, sizeof(endstring));
    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), "`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), "`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), "`Klingelton`='%d', ", PlayerInfo[playerid][pKlingelton]); strcat(endstring, var, sizeof(endstring));

    Code
    format(var, sizeof(var), "`sTx`='%f', ", PlayerInfo[playerid][sTx]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`sTy`='%f', ", PlayerInfo[playerid][sTy]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`sTz`='%f', ", PlayerInfo[playerid][sTz]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`wmspawn`='%d', ", PlayerInfo[playerid][wmspawn]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`Coints`='%d', ", PlayerInfo[playerid][pCoints]);strcat(endstring, var, sizeof(endstring));

    Code
    format(var, sizeof(var), "`wgs`='%d', ", PlayerInfo[playerid][pwgs]); 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));

    Code
    format(var, sizeof(var), "`HeadValue`='%d', ", PlayerInfo[playerid][pHeadValue]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`Jailed`='%d', ", PlayerInfo[playerid][pJailed]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`JailTime`='%d', ", PlayerInfo[playerid][pJailTime]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`AdminJailed`='%d', ", PlayerInfo[playerid][pAdminJailed]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`AdminJailChckp`='%d', ", PlayerInfo[playerid][pAdminJailChckp]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`Leader`='%d', ", PlayerInfo[playerid][pLeader]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`Member`='%d', ", PlayerInfo[playerid][pMember]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`Rank`='%d', ", PlayerInfo[playerid][pRank]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`Skin`='%d', ", PlayerInfo[playerid][pChar]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`Vertragszeit`='%d', ", PlayerInfo[playerid][pVertragszeit]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`DetSkill`='%d', ", PlayerInfo[playerid][pDetSkill]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`SexSkill`='%d', ", PlayerInfo[playerid][pSexSkill]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`LawSkill`='%d', ", PlayerInfo[playerid][pAnwaltSkill]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`MechSkill`='%d', ", PlayerInfo[playerid][pMechSkill]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`JackSkill`='%d', ", PlayerInfo[playerid][pJackSkill]); strcat(endstring, var, sizeof(endstring));

    Code
    format(var, sizeof(var), "`CarSkill`='%d', ", PlayerInfo[playerid][pCarSkill]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`NewsSkill`='%d', ", PlayerInfo[playerid][pNewsSkill]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`DrugsSkill`='%d', ", PlayerInfo[playerid][pDrugsSkill]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`CookSkill`='%d', ", PlayerInfo[playerid][pCookSkill]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`FishSkill`='%d', ", PlayerInfo[playerid][pFishSkill]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`pSHealth`='%.1f', ", PlayerInfo[playerid][pSHealth]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`PhoneNr`='%d', ", PlayerInfo[playerid][pNummer]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`House`='%d', ", PlayerInfo[playerid][pPhousekey]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`Biz`='%d', ", PlayerInfo[playerid][pBizKey]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`CarLic`='%d', ", PlayerInfo[playerid][pCarLic]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`FlyLic`='%d', ", PlayerInfo[playerid][pFlyLic]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`BoatLic`='%d', ", PlayerInfo[playerid][pBoatLic]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`FishLic`='%d', ", PlayerInfo[playerid][pFishLic]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`GunLic`='%d', ", PlayerInfo[playerid][pGunLic]); strcat(endstring, var, sizeof(endstring));

    Code
    format(var, sizeof(var), "`Gun1`='%d', ", PlayerInfo[playerid][pGun1]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`Gun2`='%d', ", PlayerInfo[playerid][pGun2]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`Gun3`='%d', ", PlayerInfo[playerid][pGun3]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`Gun4`='%d', ", PlayerInfo[playerid][pGun4]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`Ammo1`='%d', ", PlayerInfo[playerid][pAmmo1]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`Ammo2`='%d', ", PlayerInfo[playerid][pAmmo2]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`Ammo3`='%d', ", PlayerInfo[playerid][pAmmo3]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`Ammo4`='%d', ", PlayerInfo[playerid][pAmmo4]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`CarTime`='%d', ", PlayerInfo[playerid][pCarTime]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`PayDay`='%d', ", PlayerInfo[playerid][pPayDay]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`PayDayHad`='%d', ", PlayerInfo[playerid][pPayDayHad]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`CDPlayer`='%d', ", PlayerInfo[playerid][pCDPlayer]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`AlcoholPerk`='%d', ", PlayerInfo[playerid][pAlcoholPerk]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`PainKillerPerk`='%d', ", PlayerInfo[playerid][pPainKillerPerk]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`DrugPerk`='%d', ", PlayerInfo[playerid][pDrugPerk]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`MiserPerk`='%d', ", PlayerInfo[playerid][pMiserPerk]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`TraderPerk`='%d', ", PlayerInfo[playerid][pTraderPerk]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`Tutorial`='%d', ", PlayerInfo[playerid][pTut]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`Warnings`='%d', ", PlayerInfo[playerid][pWarns]); strcat(endstring, var, sizeof(endstring));

    Code
    format(var, sizeof(var), "`Fuel`='%d', ", PlayerInfo[playerid][pFuel]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`Married`='%d', ", PlayerInfo[playerid][pMarried]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`MarriedTo`='%s', ", PlayerInfo[playerid][pMarriedTo]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`WantedLevel`='%d', ", PlayerInfo[playerid][pWantedLevel]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`Spawn`='%d', ", PlayerInfo[playerid][pSpawn]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`SavedMaterials`='%d', ", PlayerInfo[playerid][pSaveMats]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`SaveDrugs`='%d', ", PlayerInfo[playerid][pSaveDrugs]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`SaveCodes`='%d', ", PlayerInfo[playerid][pSaveCodes]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`BikeLic`='%d', ", PlayerInfo[playerid][pBikeLic]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`LKWLic`='%d', ", PlayerInfo[playerid][pLKWLic]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`DonatorTime`='%d', ", PlayerInfo[playerid][pDonatorZeit]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`WerberName`='%s', ", PlayerInfo[playerid][pWerberName]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`FightingStyle`='%d', ", PlayerInfo[playerid][pFightingStyle]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`Handy`='%d', ", PlayerInfo[playerid][pHandy]); strcat(endstring, var, sizeof(endstring));

    Code
    format(var, sizeof(var), "`OnDutySkin`='%d', ", PlayerInfo[playerid][pOnDutySkin]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`CarLicPoints`='%d', ", PlayerInfo[playerid][pCarLicPoints]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`LKWLicPoints`='%d', ", PlayerInfo[playerid][pLKWLicPoints]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`BikeLicPoints`='%d', ", PlayerInfo[playerid][pBikeLicPoints]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`InviteSperre`='%d', ", PlayerInfo[playerid][pInviteSperre]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`warntime1`='%d', ", PlayerInfo[playerid][pWarnTime1]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`warntime2`='%d', ", PlayerInfo[playerid][pWarnTime2]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`Ticketsopen`='%d', ", PlayerInfo[playerid][pTicketsopen]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`DonatorTime`='%d', ", PlayerInfo[playerid][pDonatorZeit]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`OldName`='%s', ", PlayerInfo[playerid][pOldName]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`ClientIP`='%s', ", PlayerInfo[playerid][pUserIP]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`OrgMember`='%d', ", PlayerInfo[playerid][pOrgaID]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`OrgLeader`='%d', ", PlayerInfo[playerid][pOrgaLeader]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`OrgManager`='%d', ", PlayerInfo[playerid][pOrgaManager]); strcat(endstring, var, sizeof(endstring));

    Code
    format(var, sizeof(var), "`krankenkasse`='%d', ", PlayerInfo[playerid][pKrankenkasse]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`krankenkassezeit`='%d', ", PlayerInfo[playerid][pKrankenkasseTime]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`kreditkarte`='%d', ", PlayerInfo[playerid][pKreditkarte]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`kreditkartebenutzen`='%d', ", PlayerInfo[playerid][pKreditkarteBenutzen]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`forum`='%d', ", PlayerInfo[playerid][pForum]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`OrgName`='%s' ", PlayerInfo[playerid][pOrgaName]); strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), " WHERE `Name`='%s'", playername);
    strcat(endstring, var, sizeof(endstring));
    mysql_query(endstring);
    }
    return 1;
    }


    Beste Grüße

  • Füge bitte vor:
    mysql_query(endstring);
    das hier ein:
    printf("endstring = %s", endstring);


    Schalte außerdem den MySQL Debug Modus an und poste dann was im Server Log und was im MySQL Log steht, wenn du diesen Code ausführst.
    Wie du den Debug Modus an machst siehst du hier: Tipps: Scripting-Probleme richtig erklären (Kapitel 1.4)


    Serverlog: http://pastebin.com/bpw9iFjr
    mysql_log: http://pastebin.com/8ZEzPZNQ


    Edit: Kleiner Fail von mir, WHERE steht ein anderer Name, weil ich den mit "crontec" ersetzt habe^^
    Edit 2: Accounts werden jetzt (seit mysql_debug) auch nicht geladen (liegt das an MySQL Debug?

  • Laut Log können die Funktionen nicht ausgeführt werden, da keine Verbindung zur Datenbank besteht.
    Bist du dir sicher, dass da alles passt und deine Login Daten stimmen? Hast du mal versucht alles neuzustarten?

    MySQL Daten sind 100%ig korrekt (Server läuft seit einigen Wochen, an den Daten wurde nichts geändert und das Problem besteht erst seit ein paar Tagen, also bin mir was die Daten angeht sicher. Einen kompletten Server Restart habe ich über das Nitrado CP durchgeführt.


    Edit: Das keine Verbindung zur Datenbank aufgebaut werden konnte, liegt am Debug Modus (warum auch immer?). Habs ausgeschaltet und in der Serverlog steht:


    Code
    [01:57:47] [MySQL] Connected (0) to 'ni767_3_DB'@'127.0.0.1 via TCP/IP'.
    [01:57:47] [MySQL] Server Version 5.6.24.



    Allgerdings wird beim Disconnecten vom Server kein print mit dem endstring ausgegeben, also wird PlayerUpdate garnicht erst ausgeführt?


    Edit: endstring: http://pastebin.com/Hezwruwv - Mit Debug, keine Verbindung, was nun? .. :/  Jeffry:



    Letzter Edit: Fragt mich nicht wieso oder warum, aber es funktioniert nun wieder. Vielen Dank trotzdem an Jeffry!

    7 Mal editiert, zuletzt von varrez ()