Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // PLAYER SAVE
- public Update(playerid, type)
- {
- if(IsPlayerConnected(playerid) && gPlayerLogged[ playerid ] )
- {
- new var[356];
- {
- switch(type)
- {
- case pCashx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Money`='%d' WHERE `name`='%s'",GetPlayerCash(playerid), PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pRP:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Respect`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pExp], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pBank:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Bank`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pAccount], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pCarLicTx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `CarLicT`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pCarLicT], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pFlyLicTx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `FlyLicT`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pFlyLicT], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pBoatLicTx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `BoatLicT`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pBoatLicT], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pGunLicTx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `GunLicT`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pGunLicT], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pRobx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Rob`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pRob], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pFpunishx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `FPunish`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pFpunish], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pLawyerx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Acceptpoints`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pLawyer], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pConnectTimex:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `ConnectedTime`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pConnectTime], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pPayDayHadx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `PayDayHad`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pPayDayHad], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pPayDayx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `PayDay`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pPayDay], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pPayCheckx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Paycheck`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pPayCheck], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pPhousekeyx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `House`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pPhousekey], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pJailedx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Jailed`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pJailed], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pJailTimex:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `JailTime`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pJailTime], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pRadiox:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Radio2`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pRadio], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pWantedLevelx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `WantedLevel`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pWantedLevel], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pPhonex:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Phone`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pPhone], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pMatsx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Materials`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pMats], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pFishesx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Fishes`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pFishes], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pFishSkillx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `FishSkill`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pFishSkill], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pSpawnChangex:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `SpawnChange`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pSpawnChange], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pRobSkillx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `RobSkill`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pRobSkill], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pTruckSkillx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `TruckSkill`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pTruckSkill], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pTruckTimesx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `TruckTimes`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pTruckTimes], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pTruckRemx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `TruckRem`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pTruckRem], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pFarmSkillx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `FarmSkill`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pFarmSkill], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pFarmTimesx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `FarmTimes`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pFarmTimes], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pFarmRemx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `FarmRem`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pFarmRem], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pFishTimesx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `FishTimes`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pFishTimes], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pFishRemx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `FishRem`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pFishRem], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pRobRemx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `RobRem`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pRobRem], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pRobTimesx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `RobTimes`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pRobTimes], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pLevelx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Level`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pPremiumAccountx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Premium`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pPremiumAccount], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pPremiumPointsx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `PremiumPoints`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pPremiumPoints], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- /*case pGiftPointsx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `GiftPoints`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pGiftPoints], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }*/
- case pTutx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Tutorial`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pTut], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pPlusSlot1x:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `PlusSlot1`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pPlusSlot1], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pPlusSlot2x:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `PlusSlot2`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pPlusSlot2], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pPbiskeyx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Bizz`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pPbiskey], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pPnumberx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `PhoneNr`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pPnumber], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pRegx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Registered`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pReg], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pRegistredDatex:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `RegisterDate`='%s' WHERE `name`='%s'",PlayerInfo[playerid][pRegistredDate], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pPcarkeyx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Carkey`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pPcarkey], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pmotokeyx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `motokey`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pmotokey], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pprcarkey2x:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `prcarkey2`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pprcarkey2], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pPPluscarkeyx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `pluscarkey`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pPPluscarkey], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pPPluscarkey2x:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `pluscarkey2`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pPPluscarkey2], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case phelikeyx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `helikey`='%d' WHERE `name`='%s'",PlayerInfo[playerid][phelikey], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pprcarkeyx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `prcarkey`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pprcarkey], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pRentedx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Rented`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pRented], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pCrimesx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Crimes`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pCrimes], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pCrime1x:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Crime1`='%s' WHERE `name`='%s'",PlayerInfo[playerid][pCrime1], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pCrime2x:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Crime2`='%s' WHERE `name`='%s'",PlayerInfo[playerid][pCrime2], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pCrime3x:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Crime3`='%s' WHERE `name`='%s'",PlayerInfo[playerid][pCrime3], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pVictimx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Victim`='%s' WHERE `name`='%s'",PlayerInfo[playerid][pVictim], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pAccusedx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Accused`='%s' WHERE `name`='%s'",PlayerInfo[playerid][pAccused], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pFWorksx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `FWorks`='%s' WHERE `name`='%s'",PlayerInfo[playerid][pFWorks], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pEmailx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Email`='%s' WHERE `name`='%s'",PlayerInfo[playerid][pEmail], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pBTempx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `BTemp`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pBTemp], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pBYearx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `BYear`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pBYear], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pBMonthx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `BMonth`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pBMonth], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pBDayx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `BDay`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pBDay], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pBByx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `BBy`='%s' WHERE `name`='%s'",PlayerInfo[playerid][pBBy], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pBReasonx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `BReason`='%s' WHERE `name`='%s'",PlayerInfo[playerid][pBReason], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pWarnsx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Warnings`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pWarns], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pLanguagex:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Language`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pLanguage], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pVirtualPDx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `VirtualPD`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pVirtualPD], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pGlassesx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Glasses`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pGlasses], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pHatsx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `Hats`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pHats], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pFactionTimex:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `FactionTime`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pFactionTime], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pCreditsx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `CreditsF`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pCredits], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pNMutedx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `NMuted`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pNMuted], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- case pHelpedPlayersx:
- {
- mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `HelpedPlayers`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pHelpedPlayers], PlayerInfo[playerid][pNormalName]);
- mysql_tquery(SQL,var,"","");
- }
- }
- }
- }
- return 1;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement