new query[3000]; mysql_format(handle, query, sizeof(query), "UPDATE Benutzer SET Level = '%d', AdminLevel = '%d', Supporter = '%d', DonateRank = '%d', UpgradePoints = '%d', Spielzeit = '%d', Registered = '%d', Geschlecht = '%d', Age = '%d', Herkunft = '%d', CK = '%d', Muted = '%d', Respect = '%d', Money = '%d', Bank = '%d', Kredit = '%d', KreditDauer = '%d', Crimes = '%d', Kills = '%d', Deaths = '%d', Arrested = '%d', ", PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][pSupporter], PlayerInfo[playerid][pDonateRank], PlayerInfo[playerid][gPupgrade], PlayerInfo[playerid][pConnectTime], PlayerInfo[playerid][pReg], PlayerInfo[playerid][pSex], PlayerInfo[playerid][pAge], PlayerInfo[playerid][pOrigin], PlayerInfo[playerid][pCK], PlayerInfo[playerid][pMuted], PlayerInfo[playerid][pExp], PlayerInfo[playerid][pCash], PlayerInfo[playerid][pAccount], PlayerInfo[playerid][pPlayerKredit], PlayerInfo[playerid][pPlayerKreditDauer], PlayerInfo[playerid][pCrimes], PlayerInfo[playerid][pKills], PlayerInfo[playerid][pDeaths], PlayerInfo[playerid][pArrested]);
mysql_format(handle, query, sizeof(query), "WantedDeaths = '%d', Phonebook = '%d', LottoNr = '%d', Fishes = '%d', BiggestFish = '%d', Job = '%d', HeadValue = '%d', Jailed = '%d', GangJailed = '%d', Mauled = '%d', JailTime = '%d', Materials = '%d', Drugs = '%d', BoxMaterials = '%d', BoxDrugs = '%d', FightingStyle = '%d', Leader = '%d', Member = '%d', FMember = '%d', Rank = '%d', ", query, PlayerInfo[playerid][pWantedDeaths], PlayerInfo[playerid][pPhoneBook], PlayerInfo[playerid][pLottoNr], PlayerInfo[playerid][pFishes], PlayerInfo[playerid][pBiggestFish], PlayerInfo[playerid][pJob], PlayerInfo[playerid][pHeadValue], PlayerInfo[playerid][pJailed], PlayerInfo[playerid][pGangJailed], PlayerInfo[playerid][pMauled], PlayerInfo[playerid][pJailTime], PlayerInfo[playerid][pMats], PlayerInfo[playerid][pDrugs], PlayerInfo[playerid][pBoxMats], PlayerInfo[playerid][pBoxDrugs], GetPlayerFightingStyle(playerid), PlayerInfo[playerid][pLeader], PlayerInfo[playerid][pMember], PlayerInfo[playerid][pFMember], PlayerInfo[playerid][pRank]);
mysql_format(handle, query, sizeof(query), "Skin = '%d', ContractTime = '%d', DetSkill = '%d', SexSkill = '%d', BoxSkill = '%d', LawSkill = '%d', MechSkill = '%d', JackSkill = '%d', CarSkill = '%d', NewsSkill = '%d', DrugsSkill = '%d', CookSkill = '%d', FishSkill = '%d', pSHealth = '%f', pHealth = '%f', Interior = '%d', Local = '%d', Team = '%d', Model = '%d', PhoneNr = '%d', ", query, PlayerInfo[playerid][pChar], PlayerInfo[playerid][pContractTime], PlayerInfo[playerid][pDetSkill], PlayerInfo[playerid][pSexSkill], PlayerInfo[playerid][pBoxSkill], PlayerInfo[playerid][pLawSkill], PlayerInfo[playerid][pMechSkill], PlayerInfo[playerid][pJackSkill], PlayerInfo[playerid][pCarSkill], PlayerInfo[playerid][pNewsSkill], PlayerInfo[playerid][pDrugsSkill], PlayerInfo[playerid][pCookSkill], PlayerInfo[playerid][pFishSkill], PlayerInfo[playerid][pSHealth], PlayerInfo[playerid][pHealth], PlayerInfo[playerid][pInt], PlayerInfo[playerid][pLocal], PlayerInfo[playerid][pTeam], PlayerInfo[playerid][pModel], PlayerInfo[playerid][pPnumber]);
mysql_format(handle, query, sizeof(query), "House = '%d', Bizz = '%d', HandyGeld = '%d', HandyVer = '%d', Pos_x = '%f', Pos_y = '%f', Pos_z = '%f', CarLic = '%d', NewLic = '%d', FlyLic = '%d', BoatLic = '%d', FishLic = '%d', GunLic = '%d', LKWLic = '%d', RollerLic = '%d', MotoLic = '%d', Zig = '%d', Kekse = '%d', ZigSucht = '%d', Gun1 = '%d', ", query, PlayerInfo[playerid][pPhousekey], PlayerInfo[playerid][pPbiskey], PlayerInfo[playerid][pHandyGeld], PlayerInfo[playerid][pHandyVer], PlayerInfo[playerid][pPos_x], PlayerInfo[playerid][pPos_y], PlayerInfo[playerid][pPos_z], PlayerInfo[playerid][pCarLic], PlayerInfo[playerid][pNewLic], PlayerInfo[playerid][pFlyLic], PlayerInfo[playerid][pBoatLic], PlayerInfo[playerid][pFishLic], PlayerInfo[playerid][pGunLic], PlayerInfo[playerid][pLKWLic], PlayerInfo[playerid][pRollerLic], PlayerInfo[playerid][pMotoLic], PlayerInfo[playerid][pZig], PlayerInfo[playerid][pKekse], PlayerInfo[playerid][pZigSucht], PlayerInfo[playerid][pGun1]);
mysql_format(handle, query, sizeof(query), "Gun2 = '%d', Gun3 = '%d', Gun4 = '%d', Ammo1 = '%d', Ammo2 = '%d', Ammo3 = '%d', Ammo4 = '%d', CarTime = '%d', Mulltime = '%d', PayDay = '%d', PayDayHad = '%d', CDPlayer = '%d', Wins = '%d', Loses = '%d', AlcoholPerk = '%d', DrugPerk = '%d', MiserPerk = '%d', PainPerk = '%d', TraderPerk = '%d', Tutorial = '%d', Warnings = '%d', ", query, PlayerInfo[playerid][pGun2], PlayerInfo[playerid][pGun3], PlayerInfo[playerid][pGun4], PlayerInfo[playerid][pAmmo1], PlayerInfo[playerid][pAmmo2], PlayerInfo[playerid][pAmmo3], PlayerInfo[playerid][pAmmo4], PlayerInfo[playerid][pCarTime], PlayerInfo[playerid][pMulltime], PlayerInfo[playerid][pPayDay], PlayerInfo[playerid][pPayDayHad], PlayerInfo[playerid][pCDPlayer], PlayerInfo[playerid][pWins], PlayerInfo[playerid][pLoses], PlayerInfo[playerid][pAlcoholPerk], PlayerInfo[playerid][pDrugPerk], PlayerInfo[playerid][pMiserPerk], PlayerInfo[playerid][pPainPerk], PlayerInfo[playerid][pTraderPerk], PlayerInfo[playerid][pTut], PlayerInfo[playerid][pWarns]);
mysql_format(handle, query, sizeof(query), "Adjustable = '%d', Fuel = '%d', Married = '%d', MarriedTo = '%e', SpawnChange = '%d', WantedLevel = '%d', WantedPoints = '%d', PlayMinutes = '%d', GesamtMinutes = '%d', MinutesSinceAn = '%d', SFPASS = '%d', LVPASS = '%d', Offflucht = '%d', Knast = '%d', Uhr = '%d', Handy = '%d', KnastTime = '%d', Perso = '%d', FrakSperre = '%d', Gehalt = '%d', ", query, PlayerInfo[playerid][pAdjustable], PlayerInfo[playerid][pFuel], PlayerInfo[playerid][pMarried], PlayerInfo[playerid][pMarriedTo], SpawnChange[playerid], WantedLevel[playerid], WantedPoints[playerid], PlayerInfo[playerid][pPlayMinutes], PlayerInfo[playerid][pGesamtMinutes], PlayerInfo[playerid][pMinutesSinceAn], PlayerInfo[playerid][pSFPASS], PlayerInfo[playerid][pLVPASS], OfflineFlucht[playerid], Knast[playerid], PlayerInfo[playerid][pUhrID], PlayerInfo[playerid][pHandyID], KnastTime[playerid], PlayerInfo[playerid][pOwnPerso], PlayerInfo[playerid][pFrakSperre], PlayerInfo[playerid][pGehalt]);
mysql_format(handle, query, sizeof(query), "InvWeapon = '%d', InvAmmo = '%d', InvWeapon2 = '%d', InvAmmo2 = '%d', InvMats = '%d', InvDrugs = '%d', FlugTime = '%d', FarmTime = '%d', GDeaths = '%d', GKills = '%d', Meldung = '%d', Tanke = '%d', Zollpass = '%d', ZollpassTime = '%d', Gesperrt = '%d', ", query, PlayerInfo[playerid][pInvWeapon], PlayerInfo[playerid][pInvAmmo], PlayerInfo[playerid][pInvWeapon2], PlayerInfo[playerid][pInvAmmo2], PlayerInfo[playerid][pInvMats], PlayerInfo[playerid][pInvDrugs], PlayerInfo[playerid][pFlugTime], PlayerInfo[playerid][pFarmTime], PlayerInfo[playerid][pGDeaths], PlayerInfo[playerid][pGKills], PlayerInfo[playerid][pMeldung], PlayerInfo[playerid][pPtankekey], PlayerInfo[playerid][pZollPass], PlayerInfo[playerid][pZollPassTime], PlayerInfo[playerid][pGesperrt]);
mysql_format(handle, query, sizeof(query), "waffenslot1 = '%d', waffenslot2 = '%d', waffenslot3 = '%d', waffenslot4 = '%d', waffenslot5 = '%d', waffenslot6 = '%d', waffenslot7 = '%d', waffenslot8 = '%d', waffenslot9 = '%d', waffenslot10 = '%d', waffenslot11 = '%d', waffenslot12 = '%d', waffenslot13 = '%d', ", query, Weapons25[0], Weapons25[1], Weapons25[2], Weapons25[3], Weapons25[4], Weapons25[5], Weapons25[6], Weapons25[7], Weapons25[8], Weapons25[9], Weapons25[10], Weapons25[11], Weapons25[12]);
mysql_format(handle, query, sizeof(query), "ammoslot1 = '%d', ammoslot2 = '%d', ammoslot3 = '%d', ammoslot4 = '%d', ammoslot5 = '%d', ammoslot6 = '%d', ammoslot7 = '%d', ammoslot8 = '%d', ammoslot9 = '%d', ammoslot10 = '%d', ammoslot11 = '%d', ammoslot12 = '%d', ammoslot13 = '%d' WHERE id = '%d'", query, Ammo25[0], Ammo25[1], Ammo25[2], Ammo25[3], Ammo25[4], Ammo25[5], Ammo25[6], Ammo25[7], Ammo25[8], Ammo25[9], Ammo25[10], Ammo25[11], Ammo25[12], PlayerInfo[playerid][pDB_ID]); mysql_pquery(handle, query, "", "");
Alles anzeigen