Advertisement
Guest User

Untitled

a guest
Jun 8th, 2018
136
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.75 KB | None | 0 0
  1. function UpdateVariable(playerid, varid) {
  2. new query[256];
  3. switch(varid) {
  4. case pStatusx: format(query, sizeof(query), "UPDATE `users` SET `Status`='%d' WHERE `ID`='%d'", PlayerInfo[playerid][pStatus], PlayerInfo[playerid][pID]);
  5. case pLevelx: format(query, sizeof(query), "UPDATE `users` SET `Level`='%d' WHERE `ID`='%d'", PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pID]);
  6. case pAdminx: format(query, sizeof(query), "UPDATE `users` SET `Admin`='%d' WHERE `ID`='%d'", PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][pID]);
  7. case pHelperx: format(query, sizeof(query), "UPDATE `users` SET `Helper`='%d' WHERE `ID`='%d'", PlayerInfo[playerid][pHelper], PlayerInfo[playerid][pID]);
  8. case pMoneyx: format(query, sizeof(query), "UPDATE `users` SET `Money`='%d' WHERE `ID`='%d'", PlayerInfo[playerid][pMoney], PlayerInfo[playerid][pID]);
  9. case pBankMoneyx: format(query, sizeof(query), "UPDATE `users` SET `BankMoney`='%d' WHERE `ID`='%d'", PlayerInfo[playerid][pBankMoney], PlayerInfo[playerid][pID]);
  10. case pHouseKeyx: format(query, sizeof(query), "UPDATE `users` SET `HouseKey`='%d' WHERE `ID`='%d'", PlayerInfo[playerid][pHouseKey], PlayerInfo[playerid][pID]);
  11. case pBusinessKeyx: format(query, sizeof(query), "UPDATE `users` SET `BusinessKey`='%d' WHERE `ID`='%d'", PlayerInfo[playerid][pBusinessKey], PlayerInfo[playerid][pID]);
  12. case pRentedHousex: format(query, sizeof(query), "UPDATE `users` SET `RentedHouse`='%d' WHERE `ID`='%d'", PlayerInfo[playerid][pRentedHouse], PlayerInfo[playerid][pID]);
  13. case pFactionx: format(query, sizeof(query), "UPDATE `users` SET `Faction`='%d' WHERE `ID`='%d'", PlayerInfo[playerid][pFaction], PlayerInfo[playerid][pID]);
  14. case pMemberx: format(query, sizeof(query), "UPDATE `users` SET `Member`='%d' WHERE `ID`='%d'", PlayerInfo[playerid][pMember], PlayerInfo[playerid][pID]);
  15. case pLeaderx: format(query, sizeof(query), "UPDATE `users` SET `Leader`='%d' WHERE `ID`='%d'", PlayerInfo[playerid][pLeader], PlayerInfo[playerid][pID]);
  16. case pRankx: format(query, sizeof(query), "UPDATE `users` SET `Rank`='%d' WHERE `ID`='%d'", PlayerInfo[playerid][pRank], PlayerInfo[playerid][pID]);
  17. case pFactionPunishx: format(query, sizeof(query), "UPDATE `users` SET `FactionPunish`='%d' WHERE `ID`='%d'", PlayerInfo[playerid][pFactionPunish], PlayerInfo[playerid][pID]);
  18. case pSexx: format(query, sizeof(query), "UPDATE `users` SET `Sex`='%d' WHERE `ID`='%d'", PlayerInfo[playerid][pSex], PlayerInfo[playerid][pID]);
  19. case pAgex: format(query, sizeof(query), "UPDATE `users` SET `Age`='%d' WHERE `ID`='%d'", PlayerInfo[playerid][pAge], PlayerInfo[playerid][pID]);
  20. case pMutedx: format(query, sizeof(query), "UPDATE `users` SET `Muted`='%d' WHERE `ID`='%d'", PlayerInfo[playerid][pMuted], PlayerInfo[playerid][pID]);
  21. case pMuteTimex: format(query, sizeof(query), "UPDATE `users` SET `MuteTime`='%d' WHERE `ID`='%d'", PlayerInfo[playerid][pMuteTime], PlayerInfo[playerid][pID]);
  22. case pJailedx: format(query, sizeof(query), "UPDATE `users` SET `Jailed`='%d' WHERE `ID`='%d'", PlayerInfo[playerid][pJailed], PlayerInfo[playerid][pID]);
  23. case pJailTimex: format(query, sizeof(query), "UPDATE `users` SET `JailTime`='%d' WHERE `ID`='%d'", PlayerInfo[playerid][pJailTime], PlayerInfo[playerid][pID]);
  24. case pWantedLevelx: format(query, sizeof(query), "UPDATE `users` SET `WantedLevel`='%d' WHERE `ID`='%d'", PlayerInfo[playerid][pWantedLevel], PlayerInfo[playerid][pID]);
  25. case pWantedReasonx: format(query, sizeof(query), "UPDATE `users` SET `WantedReason`='%s' WHERE `ID`='%d'", PlayerInfo[playerid][pWantedReason], PlayerInfo[playerid][pID]);
  26. case pWantedTimex: format(query, sizeof(query), "UPDATE `users` SET `WantedTime`='%s' WHERE `ID`='%d'", PlayerInfo[playerid][pWantedReason], PlayerInfo[playerid][pID]);
  27. case pEmailx: format(query, sizeof(query), "UPDATE `users` SET `Email`='%s' WHERE `ID`='%d'", PlayerInfo[playerid][pWantedTime], PlayerInfo[playerid][pID]);
  28. case pSkinx: format(query, sizeof(query), "UPDATE `users` SET `Skin`='%d' WHERE `ID`='%d'", PlayerInfo[playerid][pSkin], PlayerInfo[playerid][pID]);
  29.  
  30. case pContractx: format(query, sizeof(query), "UPDATE `users` SET `Contract`='%d' WHERE `ID`='%d'", PlayerInfo[playerid][pContract], PlayerInfo[playerid][pID]);
  31. case pContractValuex: format(query, sizeof(query), "UPDATE `users` SET `ContractValue`='%d' WHERE `ID`='%d'", PlayerInfo[playerid][pContractValue], PlayerInfo[playerid][pID]);
  32.  
  33. case pLanguagex: format(query, sizeof(query), "UPDATE `users` SET `Language`='%d' WHERE `ID`='%d'", PlayerInfo[playerid][pLanguage], PlayerInfo[playerid][pID]);
  34. case pBannedx: format(query, sizeof(query), "UPDATE `users` SET `Banned`='%d' WHERE `ID`='%d'", PlayerInfo[playerid][pBanned], PlayerInfo[playerid][pID]);
  35.  
  36. case pHUDx: format(query, sizeof(query), "UPDATE `users` SET `HUD`='%d' WHERE `ID`='%d'", PlayerInfo[playerid][pHUD], PlayerInfo[playerid][pID]);
  37. case pFPSx: format(query, sizeof(query), "UPDATE `users` SET `FPS`='%d' WHERE `ID`='%d'", PlayerInfo[playerid][pFPS], PlayerInfo[playerid][pID]);
  38.  
  39. case pPayDayx: format(query, sizeof(query), "UPDATE `users` SET `PayDay`='%d' WHERE `ID`='%d'", PlayerInfo[playerid][pPayDay], PlayerInfo[playerid][pID]);
  40. case pTimePayDayx: format(query, sizeof(query), "UPDATE `users` SET `TimePayDay`='%d' WHERE `ID`='%d'", PlayerInfo[playerid][pTimePayDay], PlayerInfo[playerid][pID]);
  41.  
  42. case pRespectTotalx: format(query, sizeof(query), "UPDATE `users` SET `RespectTotal`='%d' WHERE `ID`='%d'", PlayerInfo[playerid][pRespectTotal], PlayerInfo[playerid][pID]);
  43. case pRespectx: format(query, sizeof(query), "UPDATE `users` SET `Respect`='%d' WHERE `ID`='%d'", PlayerInfo[playerid][pRespect], PlayerInfo[playerid][pID]);
  44. }
  45. mysql_tquery(mysql, query, "", "");
  46. return 1;
  47. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement