Hilfe Accounts werden nicht gespeichert [MySQL]

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
  • MEinst du das


    -- --------------------------------------------------------


    --
    -- Tabellenstruktur für Tabelle `users_backup`
    --


    CREATE TABLE IF NOT EXISTS `users_backup` (
    `SQLid` int(11) NOT NULL AUTO_INCREMENT,
    `Name` varchar(24) NOT NULL,
    `Password` varchar(32) NOT NULL,
    `keyConfirmKey` varchar(10) NOT NULL DEFAULT '0',
    `Level` int(11) NOT NULL DEFAULT '0',
    `AdminLevel` int(11) NOT NULL DEFAULT '0',
    `krankenkasse` int(11) NOT NULL DEFAULT '0',
    `krankenzeit` int(11) NOT NULL DEFAULT '0',
    `DonateRank` int(11) NOT NULL DEFAULT '0',
    `UpgradePoints` int(11) NOT NULL DEFAULT '0',
    `ConnectedTime` int(11) NOT NULL DEFAULT '0',
    `Registered` int(11) NOT NULL DEFAULT '0',
    `Sex` int(11) NOT NULL DEFAULT '0',
    `Age` int(11) NOT NULL DEFAULT '0',
    `Origin` int(11) NOT NULL DEFAULT '0',
    `Muted` int(11) NOT NULL DEFAULT '0',
    `Respect` int(11) NOT NULL DEFAULT '0',
    `Money` int(11) NOT NULL DEFAULT '0',
    `Bank` int(11) NOT NULL DEFAULT '0',
    `Crimes` int(11) NOT NULL DEFAULT '0',
    `Kills` int(11) NOT NULL DEFAULT '0',
    `sKills` int(11) NOT NULL DEFAULT '0',
    `Deaths` int(11) NOT NULL DEFAULT '0',
    `Arrested` int(11) NOT NULL DEFAULT '0',
    `ArrestTime` int(11) NOT NULL DEFAULT '0',
    `PhoneBook` int(11) NOT NULL DEFAULT '0',
    `LottoNr` int(11) NOT NULL DEFAULT '0',
    `Fishes` int(11) NOT NULL DEFAULT '0',
    `BiggestFish` int(11) NOT NULL DEFAULT '0',
    `Job` int(11) NOT NULL DEFAULT '0',
    `Paycheck` int(11) NOT NULL DEFAULT '0',
    `HeadValue` int(11) NOT NULL DEFAULT '0',
    `Jailed` int(11) NOT NULL DEFAULT '0',
    `JailTime` int(11) NOT NULL DEFAULT '0',
    `Materials` int(11) NOT NULL DEFAULT '0',
    `Drugs` int(11) NOT NULL DEFAULT '0',
    `Leader` int(11) NOT NULL DEFAULT '0',
    `Member` int(11) NOT NULL DEFAULT '0',
    `Rank` int(11) NOT NULL DEFAULT '0',
    `Char` int(11) NOT NULL DEFAULT '0',
    `Vertragszeit` int(11) NOT NULL DEFAULT '0',
    `DetSkill` int(11) NOT NULL DEFAULT '0',
    `SexSkill` int(11) NOT NULL DEFAULT '0',
    `LawSkill` int(11) NOT NULL DEFAULT '0',
    `MechSkill` int(11) NOT NULL DEFAULT '0',
    `JackSkill` int(11) NOT NULL DEFAULT '0',
    `CarSkill` int(11) NOT NULL DEFAULT '0',
    `NewsSkill` int(11) NOT NULL DEFAULT '0',
    `DrugsSkill` int(11) NOT NULL DEFAULT '0',
    `CookSkill` int(11) NOT NULL DEFAULT '0',
    `FishSkill` int(11) NOT NULL DEFAULT '0',
    `pSHealth` float NOT NULL DEFAULT '0',
    `pHealth` float NOT NULL DEFAULT '0',
    `PhoneNr` int(11) NOT NULL DEFAULT '0',
    `House` int(11) NOT NULL DEFAULT '0',
    `Biz` int(11) NOT NULL DEFAULT '0',
    `CarLic` int(11) NOT NULL DEFAULT '0',
    `FlyLic` int(11) NOT NULL DEFAULT '0',
    `BoatLic` int(11) NOT NULL DEFAULT '0',
    `FishLic` int(11) NOT NULL DEFAULT '0',
    `GunLic` int(11) NOT NULL DEFAULT '0',
    `Zollpass` int(11) NOT NULL DEFAULT '0',
    `Gun1` int(11) NOT NULL DEFAULT '0',
    `Gun2` int(11) NOT NULL DEFAULT '0',
    `Gun3` int(11) NOT NULL DEFAULT '0',
    `Gun4` int(11) NOT NULL DEFAULT '0',
    `Ammo1` int(11) NOT NULL DEFAULT '0',
    `Ammo2` int(11) NOT NULL DEFAULT '0',
    `Ammo3` int(11) NOT NULL DEFAULT '0',
    `Ammo4` int(11) NOT NULL DEFAULT '0',
    `CarTime` int(11) NOT NULL DEFAULT '0',
    `PayDay` int(11) NOT NULL DEFAULT '0',
    `PayDayHad` int(11) NOT NULL DEFAULT '0',
    `CDPlayer` int(11) NOT NULL DEFAULT '0',
    `AlcoholPerk` int(11) NOT NULL DEFAULT '0',
    `DrugPerk` int(11) NOT NULL DEFAULT '0',
    `MiserPerk` int(11) NOT NULL DEFAULT '0',
    `TraderPerk` int(11) NOT NULL DEFAULT '0',
    `Tutorial` int(11) NOT NULL DEFAULT '0',
    `Mission` int(11) NOT NULL DEFAULT '0',
    `Warnings` int(11) NOT NULL DEFAULT '0',
    `Fuel` int(11) NOT NULL DEFAULT '0',
    `Married` int(11) NOT NULL DEFAULT '0',
    `MarriedTo` text NOT NULL,
    `WantedLevel` int(11) NOT NULL DEFAULT '0',
    `FamilySpawn` int(11) NOT NULL DEFAULT '0',
    `Spawn` int(11) NOT NULL DEFAULT '0',
    `SavedMaterials` int(11) NOT NULL DEFAULT '0',
    `SavedDrugs` int(11) NOT NULL DEFAULT '0',
    `BikeLic` int(11) NOT NULL DEFAULT '0',
    `LKWLic` int(11) NOT NULL DEFAULT '0',
    `DonatorTime` int(11) NOT NULL DEFAULT '0',
    `WerberName` text NOT NULL,
    `FightingStyle` int(11) NOT NULL DEFAULT '0',
    `Handy` int(11) NOT NULL DEFAULT '0',
    `OnDutySkin` int(11) NOT NULL DEFAULT '0',
    `CarLicPoints` int(11) NOT NULL DEFAULT '0',
    `BikeLicPoints` int(11) NOT NULL DEFAULT '0',
    `InviteSperre` int(11) NOT NULL DEFAULT '0',
    `warntime1` int(11) NOT NULL DEFAULT '0',
    `warntime2` int(11) NOT NULL DEFAULT '0',
    `Ticketsopen` int(11) NOT NULL DEFAULT '0',
    `Banned` int(11) NOT NULL DEFAULT '0',
    `Skin` int(11) NOT NULL DEFAULT '0',
    `OldName` text,
    `StudioLeiter` int(11) NOT NULL DEFAULT '0',
    `PainKillerPerk` int(11) NOT NULL DEFAULT '0',
    `ClientIP` varchar(32) NOT NULL DEFAULT '0.0.0.0',
    `OrgLeader` int(11) NOT NULL DEFAULT '-1',
    `OrgMember` int(11) NOT NULL DEFAULT '-1',
    `OrgName` varchar(156) NOT NULL DEFAULT 'Keine',
    `SaveCodes` int(11) NOT NULL,
    `DeleteDatum` int(11) NOT NULL DEFAULT '0',
    `LastLoginDatum` int(11) NOT NULL DEFAULT '0',
    `RegisterDatum` int(11) NOT NULL DEFAULT '0',
    `InviteDatum` int(11) NOT NULL DEFAULT '0',
    `eMail` varchar(100) NOT NULL DEFAULT '0',
    `eMailConfirmKey` varchar(10) NOT NULL DEFAULT '0',
    `TeamspeakRegistered` int(1) NOT NULL DEFAULT '0',
    `TeamspeakDBID` int(5) NOT NULL DEFAULT '0',
    `TeamspeakUID` varchar(100) NOT NULL DEFAULT '0',
    `TeamspeakSupporter` int(1) NOT NULL DEFAULT '0',
    `TeamspeakChannelAdmin` int(5) NOT NULL DEFAULT '0',
    `TeamspeakBanned` int(1) NOT NULL DEFAULT '0',
    `ComplainModerator` int(1) NOT NULL DEFAULT '0',
    `ForumRegistered` int(5) NOT NULL DEFAULT '0',
    `ForumModerator` int(5) NOT NULL DEFAULT '0',
    `ForumGroupLeader` int(4) NOT NULL DEFAULT '0',
    `ForumDonator` int(1) NOT NULL DEFAULT '0',
    `ControlPanelBanned` int(1) NOT NULL DEFAULT '0',
    `OPBeschwerden` int(2) NOT NULL DEFAULT '0',
    `Timestamp` bigint(20) DEFAULT '0',
    `Allowed` int(11) DEFAULT '0',
    PRIMARY KEY (`SQLid`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

  • Du hast doch einen Ordner in dem die samp-server.exe liegt. Öffne diesen Ordner, dann gehe in den gamemodes Order und öffne die .pwn Datei die da drin ist. Dann suche in dem Code den Teil, der den Spieler speichert.


    Wenn du allerdings überhaupt nicht weißt was du wo machen musst, dann rate ich dir auf deinen Bruder zu warten, der soll dir dann helfen.

  • //---------------------Save's------------------------//
    public LoadStuff()
    {
    if(SaveServerMySQL == 1)
    {
    StuffInfo[sSteuern] = mysql_GetInttoo("stuff", "Steuern", "DatensatzID");
    StuffInfo[sSteuerkasse] = mysql_GetInttoo("stuff", "Steuerkasse", "DatensatzID");
    StuffInfo[sJackpot] = mysql_GetInttoo("stuff", "Jackpot", "DatensatzID");
    StuffInfo[sVerfuegbareDrogen] = mysql_GetInttoo("stuff", "VerfuegbareDrogen", "DatensatzID");
    StuffInfo[sDrogenBank] = mysql_GetInttoo("stuff", "DrogenBank", "DatensatzID");
    StuffInfo[sAktuellesWetter] = mysql_GetInttoo("stuff", "AktuellesWetter", "DatensatzID");
    StuffInfo[sWetterVorhersage] = mysql_GetInttoo("stuff", "WetterVorhersage", "DatensatzID");
    StuffInfo[sUserRekord] = mysql_GetInttoo("stuff", "UserRekord", "DatensatzID");
    StuffInfo[sLastNumber] = mysql_GetInttoo("stuff", "LastNumber", "DatensatzID");
    StuffInfo[sToteUser] = mysql_GetInttoo("stuff", "Tode", "DatensatzID");
    StuffInfo[sSendSMS] = mysql_GetInttoo("stuff", "SMS", "DatensatzID");
    StuffInfo[sSchrotCars] = mysql_GetInttoo("stuff", "CarsDead", "DatensatzID");
    StuffInfo[sCommands] = mysql_GetInttoo("stuff", "Commands", "DatensatzID");
    StuffInfo[sNeuUser] = mysql_GetInttoo("stuff", "NeueUser", "DatensatzID");
    StuffInfo[sVerbrechen] = mysql_GetInttoo("stuff", "Verbrechen", "DatensatzID");
    StuffInfo[sLoggins] = mysql_GetInttoo("stuff", "Loggins", "DatensatzID");
    StuffInfo[sWeaponPreis] = mysql_GetInttoo("stuff", "Waffen", "DatensatzID");
    StuffInfo[sEinnahmen] = mysql_GetInttoo("stuff", "Einnahmen", "DatensatzID");
    StuffInfo[sAusgaben] = mysql_GetInttoo("stuff", "Ausgaben", "DatensatzID");
    StuffInfo[sEventKasse] = mysql_GetInttoo("stuff", "EventKasse", "DatensatzID");
    StuffInfo[slogzeile] = mysql_GetInttoo("stuff", "logzeile", "DatensatzID");
    StuffInfo[sCasinoMoney] = mysql_GetInttoo("stuff", "CasinoMoney", "DatensatzID");
    StuffInfo[LastOrgaID] = mysql_GetInttoo("stuff", "LastOrgaID", "DatensatzID");
    StuffInfo[Produkte] = mysql_GetInttoo("stuff", "Produkte", "DatensatzID");
    StuffInfo[sFahrschulpreise] = mysql_GetInttoo("stuff", "Fahrschulpreise", "DatensatzID");
    StuffInfo[sKreditkartenpreise] = mysql_GetInttoo("stuff","Kreditkartenpreise","DatensatzID");
    }
    return 1;
    }

  • public SavePlayers()
    {
    ForAllPlayers(i){
    if(IsPlayerConnected(i) && gPlayerLogged[i] && !IsPlayerNPC(i)){
    if(strcmp(PlayerInfo[i][pForceName], "Niemand", true) != 0)
    {
    SetPlayerName(i,PlayerInfo[i][pForceName]);
    SetPlayerScore(i, PlayerInfo[i][pLevel]);
    }
    PlayerUpdate(i);
    PlayerCarUpdate(i);
    }
    }
    return 1;


    Den habe ich jetzt nur noch gefunden

  • public PlayerUpdate(playerid)
    {
    if(IsPlayerConnected(playerid))
    {
    if(IsPlayerNPC(playerid))
    {
    return 1;
    }
    new playername[MAX_PLAYER_NAME];
    GetPlayerName(playerid, playername, sizeof(playername));
    new endstring[1600];
    new var[129];
    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), "`Password`='%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), "`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), "`TeamRadar`='%d', ", TeamRadar[playerid]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`BNDRadar`='%d', ", BNDRadar[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), "`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), " WHERE `Name`='%s'", playername);
    strcat(endstring, var, sizeof(endstring));
    self_mysql_queryEx(endstring);



    format(endstring, sizeof(endstring), "UPDATE `users` SET ");
    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), "`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));
    format(var, sizeof(var), " WHERE `Name`='%s'", playername);
    strcat(endstring, var, sizeof(endstring));
    self_mysql_queryEx(endstring);


    format(endstring, sizeof(endstring), "UPDATE `users` SET ");
    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), "`Hotel`='%d', ", PlayerInfo[playerid][pPhotelkey]);
    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));
    format(var, sizeof(var), "`Zollpass`='%d'", PlayerInfo[playerid][pZollpass]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), " WHERE `Name`='%s'", playername);
    strcat(endstring, var, sizeof(endstring));
    self_mysql_queryEx(endstring);



    format(endstring, sizeof(endstring), "UPDATE `users` SET ");
    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), "`PistolSkill`='%d', ", PlayerInfo[playerid][pPistolSkill]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`MaschinePistolSkill`='%d', ", PlayerInfo[playerid][pMaschinePistolSkill]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`SturmgewehrPistolSkill`='%d', ", PlayerInfo[playerid][pSturmgewehrPistolSkill]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`ShotGunSkill`='%d', ", PlayerInfo[playerid][pShotGunSkill]);
    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));
    format(var, sizeof(var), " WHERE `Name`='%s'", playername);
    strcat(endstring, var, sizeof(endstring));
    self_mysql_queryEx(endstring);



    format(endstring, sizeof(endstring), "UPDATE `users` SET ");
    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), "`SavedDrugs`='%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));
    format(var, sizeof(var), " WHERE `Name`='%s'", playername);
    strcat(endstring, var, sizeof(endstring));
    self_mysql_queryEx(endstring);


    format(endstring, sizeof(endstring), "UPDATE `users` SET ");
    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), "`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));
    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));
    self_mysql_queryEx(endstring);
    }
    return 1;
    }

  • Dann mach doch bitte das was ich dir gesagt habe. Der MySQL Log ist hier sehr wichtig, da man in diesen hunderten Zeilen den Fehler so gut wie nicht finden kann, außer durch Zufall, oder ewiges Suchen.


    Also schalte bitte den MySQL Log an und poste was darin steht, wenn du den Spieler speicherst.

  • Ich habe es auf dem Link bereits ausführlich erklärt, in Kapitel 1.4 (4. Bei MySQL-Problemen → Debug Modus nutzen).
    Link öffnen => STRG+F => "Debug Modus nutzen" eingeben => Und schon bist du da wo du lesen sollst. Das wirst du doch sicher hinbekommen.


    Dort steht es für alle gängigen MySQL Plugins, was du machen sollst.