SHARE
TWEET

Untitled

a guest Feb 18th, 2020 64 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. UPDATE `players`
  2. SET
  3. `health` = 185 + 22 * 5,
  4. `healthmax` = 185 + 22 * 5,
  5. `mana` =  35 + 22 * 30,
  6. `manamax` = 35 + 22 * 30,
  7. `cap` = 470 + 22 * 10,
  8. `level` = 30,
  9. `experience` = 368300,
  10. `maglevel` = 30,
  11. `soul` = 100,
  12. `manaspent` = 0,
  13. `lookaddons` = 0,
  14. `posx` = 0,
  15. `posy` = 0,
  16. `posz` = 0,
  17. `conditions` = '',
  18. `skull` = 0,
  19. `skulltime` = 0,
  20. `blessings` = 0,
  21. `offlinetraining_time` = 43200,
  22. `offlinetraining_skill` = -1,
  23. `stamina` = 2520,
  24. `skill_fist` = 10,
  25. `skill_club` = 10,
  26. `skill_sword` = 10,
  27. `skill_axe` = 10,
  28. `skill_dist` = 10,
  29. `skill_shielding` = 10,
  30. `skill_fishing` = 10,
  31. `skill_fist_tries` = 0,
  32. `skill_club_tries` = 0,
  33. `skill_sword_tries` = 0,
  34. `skill_axe_tries` = 0,
  35. `skill_dist_tries` = 0,
  36. `skill_shielding_tries` = 0,
  37. `skill_fishing_tries` = 0
  38. WHERE `vocation` =  1 OR `vocation`= 5  OR `vocation`= 2 OR `vocation`= 6;
  39.  
  40. UPDATE `players`
  41. SET
  42. `health` = 185 + 22 * 10,
  43. `healthmax` = 185 + 22 * 10,
  44. `mana` =  35 + 22 * 15,
  45. `manamax` = 35 + 22 * 15,
  46. `cap` = 470 + 22 * 20,
  47. `level` = 30,
  48. `experience` = 368300,
  49. `maglevel` = 5,
  50. `soul` = 100,
  51. `manaspent` = 0,
  52. `lookaddons` = 0,
  53. `posx` = 0,
  54. `posy` = 0,
  55. `posz` = 0,
  56. `conditions` = '',
  57. `skull` = 0,
  58. `skulltime` = 0,
  59. `blessings` = 0,
  60. `offlinetraining_time` = 43200,
  61. `offlinetraining_skill` = -1,
  62. `stamina` = 2520,
  63. `skill_fist` = 10,
  64. `skill_club` = 10,
  65. `skill_sword` = 10,
  66. `skill_axe` = 10,
  67. `skill_dist` = 30,
  68. `skill_shielding` = 10,
  69. `skill_fishing` = 10,
  70. `skill_fist_tries` = 0,
  71. `skill_club_tries` = 0,
  72. `skill_sword_tries` = 0,
  73. `skill_axe_tries` = 0,
  74. `skill_dist_tries` = 0,
  75. `skill_shielding_tries` = 0,
  76. `skill_fishing_tries` = 0
  77. WHERE `vocation` =  3 OR `vocation`= 7;
  78.  
  79. UPDATE `players`
  80. SET
  81. `health` = 185 + 22 * 15,
  82. `healthmax` = 185 + 22 * 15,
  83. `mana` =  35 + 22 * 5,
  84. `manamax` = 35 + 22 * 5,
  85. `cap` = 470 + 22 * 25,
  86. `level` = 30,
  87. `experience` = 368300,
  88. `maglevel` = 2,
  89. `soul` = 100,
  90. `manaspent` = 0,
  91. `lookaddons` = 0,
  92. `posx` = 0,
  93. `posy` = 0,
  94. `posz` = 0,
  95. `conditions` = '',
  96. `skull` = 0,
  97. `skulltime` = 0,
  98. `blessings` = 0,
  99. `offlinetraining_time` = 43200,
  100. `offlinetraining_skill` = -1,
  101. `stamina` = 2520,
  102. `skill_fist` = 10,
  103. `skill_club` = 30,
  104. `skill_sword` = 30,
  105. `skill_axe` = 30,
  106. `skill_dist` = 10,
  107. `skill_shielding` = 10,
  108. `skill_fishing` = 10,
  109. `skill_fist_tries` = 0,
  110. `skill_club_tries` = 0,
  111. `skill_sword_tries` = 0,
  112. `skill_axe_tries` = 0,
  113. `skill_dist_tries` = 0,
  114. `skill_shielding_tries` = 0,
  115. `skill_fishing_tries` = 0
  116. WHERE `vocation` =  4 OR `vocation`= 8;
  117.  
  118. DELETE FROM `account_ban_history`;
  119. DELETE FROM `account_bans`;
  120. DELETE FROM `house_lists`;
  121. DELETE FROM `houses`;
  122. DELETE FROM `market_history`;
  123. DELETE FROM `market_offers`;
  124. DELETE FROM `player_deaths`;
  125. DELETE FROM `player_depotitems`;
  126. DELETE FROM `player_inboxitems`;
  127. DELETE FROM `player_items`;
  128. DELETE FROM `player_spells`;
  129. DELETE FROM `player_storage`;
  130. DELETE FROM `players_online`;
  131. DELETE FROM `tile_store`;
RAW Paste Data
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
Top