Beiträge von Killer_NatorTV

    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;
    }

    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

    //---------------------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;
    }

    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 ;