API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Aug 23rd, 2019
139
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.68 KB | None | 0 0
raw download clone embed print report
  1. function Update(playerid, type) {
  2. if(IsPlayerConnected(playerid)) {
  3. new var[356];
  4. switch(type) {
  5. case pCashx: format(var, sizeof(var), "UPDATE `users` SET `Money` = '%d' WHERE `ID` = '%d'", GetPlayerCash(playerid), PlayerInfo[playerid][pSQLID]);
  6. case pRP: format(var, sizeof(var), "UPDATE `users` SET `Respect`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pExp], PlayerInfo[playerid][pSQLID]);
  7. case pBank: format(var, sizeof(var), "UPDATE `users` SET `Bank`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pAccount], PlayerInfo[playerid][pSQLID]);
  8. case pCarLicTx: format(var, sizeof(var), "UPDATE `users` SET `CarLicT`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pCarLicT], PlayerInfo[playerid][pSQLID]);
  9. case pFlyLicTx: format(var, sizeof(var), "UPDATE `users` SET `FlyLicT`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pFlyLicT], PlayerInfo[playerid][pSQLID]);
  10. case pBoatLicTx: format(var, sizeof(var), "UPDATE `users` SET `BoatLicT`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pBoatLicT], PlayerInfo[playerid][pSQLID]);
  11. case pFishLicTx: format(var, sizeof(var), "UPDATE `users` SET `FishLicT`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pFishLicT], PlayerInfo[playerid][pSQLID]);
  12. case pGunLicTx: format(var, sizeof(var), "UPDATE `users` SET `GunLicT`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pGunLicT], PlayerInfo[playerid][pSQLID]);
  13. case pRobx: format(var, sizeof(var), "UPDATE `users` SET `Rob`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pRob], PlayerInfo[playerid][pSQLID]);
  14. case pFpunishx: format(var, sizeof(var), "UPDATE `users` SET `FPunish`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pFpunish], PlayerInfo[playerid][pSQLID]);
  15. case pLawyerx: format(var, sizeof(var), "UPDATE `users` SET `Acceptpoints`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pLawyer], PlayerInfo[playerid][pSQLID]);
  16. case pConnectTimex: format(var, sizeof(var), "UPDATE `users` SET `ConnectedTime`='%0.3f' WHERE `ID`='%d'",PlayerInfo[playerid][pConnectTime], PlayerInfo[playerid][pSQLID]);
  17. case pTowx: format(var, sizeof(var), "UPDATE `users` SET `Tow`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pTow], PlayerInfo[playerid][pSQLID]);
  18. case pPayDayHadx: format(var, sizeof(var), "UPDATE `users` SET `PayDayHad`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pPayDayHad], PlayerInfo[playerid][pSQLID]);
  19. case pPayDayx: format(var, sizeof(var), "UPDATE `users` SET `PayDay`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pPayDay], PlayerInfo[playerid][pSQLID]);
  20. case pPayCheckx: format(var, sizeof(var), "UPDATE `users` SET `Paycheck`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pPayCheck], PlayerInfo[playerid][pSQLID]);
  21. case pHousex: format(var, sizeof(var), "UPDATE `users` SET `House`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pHouse], PlayerInfo[playerid][pSQLID]);
  22. case pJailedx: format(var, sizeof(var), "UPDATE `users` SET `Jailed`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pJailed], PlayerInfo[playerid][pSQLID]);
  23. case pJailTimex: format(var, sizeof(var), "UPDATE `users` SET `JailTime`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pJailTime], PlayerInfo[playerid][pSQLID]);
  24. case pRadiox: format(var, sizeof(var), "UPDATE `users` SET `Radio2`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pMP3], PlayerInfo[playerid][pSQLID]);
  25. case pWantedLevelx: format(var, sizeof(var), "UPDATE `users` SET `WantedLevel`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pWantedLevel], PlayerInfo[playerid][pSQLID]);
  26. case pPhonex: format(var, sizeof(var), "UPDATE `users` SET `Phone`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pPhone], PlayerInfo[playerid][pSQLID]);
  27. case pMatsx: format(var, sizeof(var), "UPDATE `users` SET `Materials`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pMats], PlayerInfo[playerid][pSQLID]);
  28. case pFishesx: format(var, sizeof(var), "UPDATE `users` SET `Fishes`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pFishes], PlayerInfo[playerid][pSQLID]);
  29. case pFishSkillx: format(var, sizeof(var), "UPDATE `users` SET `FishSkill`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pFishSkill], PlayerInfo[playerid][pSQLID]);
  30. case pRobSkillx: format(var, sizeof(var), "UPDATE `users` SET `RobSkill`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pRobSkill], PlayerInfo[playerid][pSQLID]);
  31. case pReferralx: format(var, sizeof(var), "UPDATE `users` SET `referral`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pReferral], PlayerInfo[playerid][pSQLID]);
  32. case pLevelx: format(var, sizeof(var), "UPDATE `users` SET `Level`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pSQLID]);
  33. case pReferralPx: format(var, sizeof(var), "UPDATE `users` SET `referralp`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pReferralP], PlayerInfo[playerid][pSQLID]);
  34. case pPremiumAccountx: format(var, sizeof(var), "UPDATE `users` SET `Premium`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pPremiumAccount], PlayerInfo[playerid][pSQLID]);
  35. case pBizzx: format(var, sizeof(var), "UPDATE `users` SET `Bizz`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pBizz], PlayerInfo[playerid][pSQLID]);
  36. case pPnumberx: format(var, sizeof(var), "UPDATE `users` SET `PhoneNr`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pPhone], PlayerInfo[playerid][pSQLID]);
  37. case pRegx: format(var, sizeof(var), "UPDATE `users` SET `Registered`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pReg], PlayerInfo[playerid][pSQLID]);
  38. case pRegistredDatex: format(var, sizeof(var), "UPDATE `users` SET `RegisterDate`='%s' WHERE `ID`='%d'",PlayerInfo[playerid][pRegistredDate], PlayerInfo[playerid][pSQLID]);
  39. case pRentedx: format(var, sizeof(var), "UPDATE `users` SET `Rented`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pRented], PlayerInfo[playerid][pSQLID]);
  40. case pCrimesx: format(var, sizeof(var), "UPDATE `users` SET `Crimes`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pCrimes], PlayerInfo[playerid][pSQLID]);
  41. case pLaptopx: format(var, sizeof(var), "UPDATE `users` SET `Laptop`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pLaptop], PlayerInfo[playerid][pSQLID]);
  42. case pCrime1x: format(var, sizeof(var), "UPDATE `users` SET `Crime1`='%s' WHERE `ID`='%d'",PlayerInfo[playerid][pCrime1], PlayerInfo[playerid][pSQLID]);
  43. case pCrime2x: format(var, sizeof(var), "UPDATE `users` SET `Crime2`='%s' WHERE `ID`='%d'",PlayerInfo[playerid][pCrime2], PlayerInfo[playerid][pSQLID]);
  44. case pCrime3x: format(var, sizeof(var), "UPDATE `users` SET `Crime3`='%s' WHERE `ID`='%d'",PlayerInfo[playerid][pCrime3], PlayerInfo[playerid][pSQLID]);
  45. case pVictimx: format(var, sizeof(var), "UPDATE `users` SET `Victim`='%s' WHERE `ID`='%d'",PlayerInfo[playerid][pVictim], PlayerInfo[playerid][pSQLID]);
  46. case pAccusedx: format(var, sizeof(var), "UPDATE `users` SET `Accused`='%s' WHERE `ID`='%d'",PlayerInfo[playerid][pAccused], PlayerInfo[playerid][pSQLID]);
  47. case pEmailx: format(var, sizeof(var), "UPDATE `users` SET `Email`='%s' WHERE `ID`='%d'",PlayerInfo[playerid][pEmail], PlayerInfo[playerid][pSQLID]);
  48. case pBTempx: format(var, sizeof(var), "UPDATE `users` SET `BTemp`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pBTemp], PlayerInfo[playerid][pSQLID]);
  49. case pBYearx: format(var, sizeof(var), "UPDATE `users` SET `BYear`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pBYear], PlayerInfo[playerid][pSQLID]);
  50. case pBMonthx: format(var, sizeof(var), "UPDATE `users` SET `BMonth`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pBMonth], PlayerInfo[playerid][pSQLID]);
  51. case pBDayx: format(var, sizeof(var), "UPDATE `users` SET `BDay`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pBDay], PlayerInfo[playerid][pSQLID]);
  52. case pBByx: format(var, sizeof(var), "UPDATE `users` SET `BBy`='%s' WHERE `ID`='%d'",PlayerInfo[playerid][pBBy], PlayerInfo[playerid][pSQLID]);
  53. case pBReasonx: format(var, sizeof(var), "UPDATE `users` SET `BReason`='%s' WHERE `ID`='%d'",PlayerInfo[playerid][pBReason], PlayerInfo[playerid][pSQLID]);
  54. case pWarnsx: format(var, sizeof(var), "UPDATE `users` SET `Warnings`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pWarns], PlayerInfo[playerid][pSQLID]);
  55. case pTruckerSkillx: format(var, sizeof(var), "UPDATE `users` SET `TruckerSkill`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pTruckerSkill], PlayerInfo[playerid][pSQLID]);
  56. case pGarbageSkillx: format(var, sizeof(var), "UPDATE `users` SET `GarbageSkill`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pGarbageSkill], PlayerInfo[playerid][pSQLID]);
  57. case pShowJobx: format(var, sizeof(var), "UPDATE `users` SET `ShowJob`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pShowJob], PlayerInfo[playerid][pSQLID]);
  58. case pShowFPx: format(var, sizeof(var), "UPDATE `users` SET `ShowFP`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pShowFP], PlayerInfo[playerid][pSQLID]);
  59. case pShowLogox: format(var, sizeof(var), "UPDATE `users` SET `ShowLogo`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pShowLogo], PlayerInfo[playerid][pSQLID]);
  60. case pShowCeasx: format(var, sizeof(var), "UPDATE `users` SET `ShowCeas`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pShowCeas], PlayerInfo[playerid][pSQLID]);
  61. case pFarmerSkillx: format(var, sizeof(var), "UPDATE `users` SET `FarmerSkill`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pFarmerSkill], PlayerInfo[playerid][pSQLID]);
  62. case pPremiumPointsx: {
  63. format(var, sizeof(var), "UPDATE `users` SET `GoldPoints`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pPremiumPoints], PlayerInfo[playerid][pSQLID]);
  64. mysql_query(SQL, var);
  65. }
  66. case pShowFactionx: format(var, sizeof(var), "UPDATE `users` SET `ShowFaction`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pShowFaction], PlayerInfo[playerid][pSQLID]);
  67. case pGiftPointsx: format(var, sizeof(var), "UPDATE `users` SET `GiftPoints`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pGiftPoints], PlayerInfo[playerid][pSQLID]);
  68. case pNewbieMutex: format(var, sizeof(var), "UPDATE `users` SET `NewbieMute`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pNewbieMute], PlayerInfo[playerid][pSQLID]);
  69. case pReportTimex: format(var, sizeof(var), "UPDATE `users` SET `ReportTime`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pReportTime], PlayerInfo[playerid][pSQLID]);
  70. case pDailyMissionx: format(var, sizeof(var), "UPDATE `users` SET `DailyMission`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pDailyMission][0], PlayerInfo[playerid][pSQLID]);
  71. case pDailyMission2x: format(var, sizeof(var), "UPDATE `users` SET `DailyMission2`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pDailyMission][1], PlayerInfo[playerid][pSQLID]);
  72. case pProgressx: format(var, sizeof(var), "UPDATE `users` SET `Progress`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pProgress][0], PlayerInfo[playerid][pSQLID]);
  73. case pProgress2x: format(var, sizeof(var), "UPDATE `users` SET `Progress2`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pProgress][1], PlayerInfo[playerid][pSQLID]);
  74. case pPizzaSkillx: format(var, sizeof(var), "UPDATE `users` SET `PizzaSkill`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pPizzaSkill], PlayerInfo[playerid][pSQLID]);
  75. case pCurierSkillx: format(var, sizeof(var), "UPDATE `users` SET `CurierSkill`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pCurierSkill], PlayerInfo[playerid][pSQLID]);
  76. case pPilotSkillx: format(var, sizeof(var), "UPDATE `users` SET `PilotSkill`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pPilotSkill], PlayerInfo[playerid][pSQLID]);
  77. case pShowHPx: format(var, sizeof(var), "UPDATE `users` SET `ShowHP`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pShowHP], PlayerInfo[playerid][pSQLID]);
  78. case pShowAPx: format(var, sizeof(var), "UPDATE `users` SET `ShowAP`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pShowAP], PlayerInfo[playerid][pSQLID]);
  79. case pVipx: format(var, sizeof(var), "UPDATE `users` SET `Vip`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pVip], PlayerInfo[playerid][pSQLID]);
  80.  
  81. case pCarLicSx: format(var, sizeof(var), "UPDATE `users` SET `CarLicS`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pCarLicS], PlayerInfo[playerid][pSQLID]);
  82. case pGunLicSx: format(var, sizeof(var), "UPDATE `users` SET `GunLicS`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pGunLicS], PlayerInfo[playerid][pSQLID]);
  83. case pFlyLicSx: format(var, sizeof(var), "UPDATE `users` SET `FlyLicS`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pFlyLicS], PlayerInfo[playerid][pSQLID]);
  84. case pBoatLicSx: format(var, sizeof(var), "UPDATE `users` SET `BoatLicS`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pBoatLicS], PlayerInfo[playerid][pSQLID]);
  85. case pJackerSkillx: format(var, sizeof(var), "UPDATE `users` SET `IceSkill`='%d' WHERE `ID`='%d'",PlayerInfo[playerid][pJackerSkill], PlayerInfo[playerid][pSQLID]);
  86.  
  87.  
  88. }
  89. if(type != pPremiumPointsx) mysql_query(SQL, var);
  90. }
  91. return 1;
  92. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!