API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 27th, 2012
85
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.53 KB | None | 0 0
raw download clone embed print report
  1. /*
  2. #Scipter: "Daejiv"
  3. #Bugdescription: "#1100"
  4. #Scriptnumber: "[W456]"
  5. #Fixdescription: "Attempt to fix some ZM scaling issues."
  6. */
  7.  
  8. -- Insert missing Gouge ranks.
  9. DELETE FROM `spell_ranks` WHERE `first_spell_id`=1776;
  10. INSERT INTO `spell_ranks` (`first_spell_id`, `spell_id`, `rank`) VALUES
  11. (1776, 1776 , 1),
  12. (1776, 1777 , 2),
  13. (1776, 8629 , 3),
  14. (1776, 11285, 4),
  15. (1776, 11286, 5),
  16. (1776, 38764, 6);
  17.  
  18. -- Druid
  19. -- 16857 no idea |Pounce|Pounce Bleed ranks
  20. DELETE FROM `spell_bonus_data` WHERE `entry` IN (1079, 9005, 9007,9824,9826,27007,49804, 16857, 22568, 62078);
  21. UPDATE `spell_bonus_data` SET `direct_bonus` = 0, `dot_bonus` = 0 WHERE `entry` IN (779, 1822);
  22. INSERT INTO `spell_bonus_data` (`entry`,`direct_bonus`,`dot_bonus`,`ap_bonus`,`ap_dot_bonus`,`comments`) VALUES
  23. (1079, 0, 0,-1,-1, 'Druid - Rip'),
  24. (9007, 0, 0,-1,-1, 'Druid - Pounce Bleed (Rank 1)'),
  25. (9824, 0, 0,-1,-1, 'Druid - Pounce Bleed (Rank 2)'),
  26. (9826, 0, 0,-1,-1, 'Druid - Pounce Bleed (Rank 3)'),
  27. (27007, 0, 0,-1,-1, 'Druid - Pounce Bleed (Rank 4)'),
  28. (49804, 0, 0,-1,-1, 'Druid - Pounce Bleed (Rank 5)'),
  29. (16857, 0, 0,-1,-1, 'Druid - Faerie Fire (Feral)'),
  30. (22568, 0, 0,-1,-1, 'Druid - Ferocious Bite');
  31.  
  32. -- Hunter
  33. -- 19386 no idea |Volley removal | Volley ranks | Immolation Trap ranks | Explosive Trap ranks
  34. DELETE FROM `spell_bonus_data` WHERE `entry` IN (1510, 13795, 13813, 19386, 42243,42244,42245,42234,58432,58433, 13797,14298,14299,14300,14301,27024,49053,49054, 13812,14314,14315,27026,49064,49065);
  35. UPDATE `spell_bonus_data` SET `direct_bonus` = 0, `dot_bonus` = 0 WHERE `entry` IN (1495, 1978, 3674, 19306);
  36. INSERT INTO `spell_bonus_data` (`entry`,`direct_bonus`,`dot_bonus`,`ap_bonus`,`ap_dot_bonus`,`comments`) VALUES
  37. (42243, 0, 0,-1,-1, 'Hunter - Volley (Rank 1)'),
  38. (42244, 0, 0,-1,-1, 'Hunter - Volley (Rank 2)'),
  39. (42245, 0, 0,-1,-1, 'Hunter - Volley (Rank 3)'),
  40. (42234, 0, 0,-1,-1, 'Hunter - Volley (Rank 4)'),
  41. (58432, 0, 0,-1,-1, 'Hunter - Volley (Rank 5)'),
  42. (58433, 0, 0,-1,-1, 'Hunter - Volley (Rank 6)'),
  43. (13797, 0, 0,-1,-1, 'Hunter - Immolation Trap (Rank 1)'),
  44. (14298, 0, 0,-1,-1, 'Hunter - Immolation Trap (Rank 2)'),
  45. (14299, 0, 0,-1,-1, 'Hunter - Immolation Trap (Rank 3)'),
  46. (14300, 0, 0,-1,-1, 'Hunter - Immolation Trap (Rank 4)'),
  47. (14301, 0, 0,-1,-1, 'Hunter - Immolation Trap (Rank 5)'),
  48. (27024, 0, 0,-1,-1, 'Hunter - Immolation Trap (Rank 6)'),
  49. (49053, 0, 0,-1,-1, 'Hunter - Immolation Trap (Rank 7)'),
  50. (49054, 0, 0,-1,-1, 'Hunter - Immolation Trap (Rank 8)'),
  51. (13812, 0, 0,-1,-1, 'Hunter - Explosive Trap (Rank 1)'),
  52. (14314, 0, 0,-1,-1, 'Hunter - Explosive Trap (Rank 2)'),
  53. (14315, 0, 0,-1,-1, 'Hunter - Explosive Trap (Rank 3)'),
  54. (27026, 0, 0,-1,-1, 'Hunter - Explosive Trap (Rank 4)'),
  55. (49064, 0, 0,-1,-1, 'Hunter - Explosive Trap (Rank 5)'),
  56. (49065, 0, 0,-1,-1, 'Hunter - Explosive Trap (Rank 6)'),
  57. (19386, 0, 0,-1,-1, 'Hunter - Wyvern Sting');
  58.  
  59. -- Rogue
  60. --
  61. DELETE FROM `spell_bonus_data` WHERE `entry` IN (1943, 2098, 32645);
  62. UPDATE `spell_bonus_data` SET `direct_bonus` = 0, `dot_bonus` = 0 WHERE `entry` IN (703, 1776);
  63. INSERT INTO `spell_bonus_data` (`entry`,`direct_bonus`,`dot_bonus`,`ap_bonus`,`ap_dot_bonus`,`comments`) VALUES
  64. (1943, 0, 0,-1,-1, 'Rogue - Rupture'),
  65. (2098, 0, 0,-1,-1, 'Rogue - Eviscerate'),
  66. (32645, 0, 0,-1,-1, 'Rogue - Envenom');
  67.  
  68. -- DK
  69. -- 47541 search for implementation
  70. -- 49158 search for implementation
  71. DELETE FROM `spell_bonus_data` WHERE `entry` IN (47541, 49158);
  72. UPDATE `spell_bonus_data` SET `direct_bonus` = 0, `dot_bonus` = 0 WHERE `entry` IN (49184);
  73. INSERT INTO `spell_bonus_data` (`entry`,`direct_bonus`,`dot_bonus`,`ap_bonus`,`ap_dot_bonus`,`comments`) VALUES
  74. (47541, 0, 0,-1,-1, 'Death Knight - Death Coil'),
  75. (49158, 0, 0,-1,-1, 'Death Knight - Corpse Explosion');
  76.  
  77. -- Warrior
  78. -- 57755 no idea
  79. -- 6343 no idea
  80. -- 5308 search for implementation
  81. -- 46968 no idea
  82. DELETE FROM `spell_bonus_data` WHERE `entry` IN (5308, 20252, 20253, 23881, 34428, 46968);
  83. UPDATE `spell_bonus_data` SET `direct_bonus` = 0, `dot_bonus` = 0 WHERE `entry` IN (6343, 6572, 57755, 64382);
  84. INSERT INTO `spell_bonus_data` (`entry`,`direct_bonus`,`dot_bonus`,`ap_bonus`,`ap_dot_bonus`,`comments`) VALUES
  85. (5308, 0, 0,-1,-1, 'Warrior - Execute'),
  86. (20253, 0, 0,-1,-1, 'Warrior - Intercept'),
  87. (23881, 0, 0,-1,-1, 'Warrior - Bloodthirst'),
  88. (34428, 0, 0,-1,-1, 'Warrior - Victory Rush'),
  89. (46968, 0, 0,-1,-1, 'Warrior - Shockwave');
  90.  
  91. -- Shaman
  92. --
  93. DELETE FROM `spell_bonus_data` WHERE `entry` IN (8024, 8033);
  94.  
  95. -- Item Spells
  96. --
  97. DELETE FROM `spell_bonus_data` WHERE `entry` IN (55736, 55756);
  98. INSERT INTO `spell_bonus_data` (`entry`,`direct_bonus`,`dot_bonus`,`ap_bonus`,`ap_dot_bonus`,`comments`) VALUES
  99. (55736, 0, 0, 0, 0, 'Item - Brunnhildar Bow'),
  100. (55756, 0, 0, 0, 0, 'Item - Brunnhildar Great Axe/Harpoon');-- Insert missing Gouge ranks.
  101. DELETE FROM `spell_ranks` WHERE `first_spell_id`=1776;
  102. INSERT INTO `spell_ranks` (`first_spell_id`, `spell_id`, `rank`) VALUES
  103. (1776, 1776 , 1),
  104. (1776, 1777 , 2),
  105. (1776, 8629 , 3),
  106. (1776, 11285, 4),
  107. (1776, 11286, 5),
  108. (1776, 38764, 6);
  109.  
  110. -- Druid
  111. -- 16857 no idea |Pounce|Pounce Bleed ranks
  112. DELETE FROM `spell_bonus_data` WHERE `entry` IN (1079, 9005, 9007,9824,9826,27007,49804, 16857, 22568, 62078);
  113. UPDATE `spell_bonus_data` SET `direct_bonus` = 0, `dot_bonus` = 0 WHERE `entry` IN (779, 1822);
  114. INSERT INTO `spell_bonus_data` (`entry`,`direct_bonus`,`dot_bonus`,`ap_bonus`,`ap_dot_bonus`,`comments`) VALUES
  115. (1079, 0, 0,-1,-1, 'Druid - Rip'),
  116. (9007, 0, 0,-1,-1, 'Druid - Pounce Bleed (Rank 1)'),
  117. (9824, 0, 0,-1,-1, 'Druid - Pounce Bleed (Rank 2)'),
  118. (9826, 0, 0,-1,-1, 'Druid - Pounce Bleed (Rank 3)'),
  119. (27007, 0, 0,-1,-1, 'Druid - Pounce Bleed (Rank 4)'),
  120. (49804, 0, 0,-1,-1, 'Druid - Pounce Bleed (Rank 5)'),
  121. (16857, 0, 0,-1,-1, 'Druid - Faerie Fire (Feral)'),
  122. (22568, 0, 0,-1,-1, 'Druid - Ferocious Bite');
  123.  
  124. -- Hunter
  125. -- 19386 no idea |Volley removal | Volley ranks | Immolation Trap ranks | Explosive Trap ranks
  126. DELETE FROM `spell_bonus_data` WHERE `entry` IN (1510, 13795, 13813, 19386, 42243,42244,42245,42234,58432,58433, 13797,14298,14299,14300,14301,27024,49053,49054, 13812,14314,14315,27026,49064,49065);
  127. UPDATE `spell_bonus_data` SET `direct_bonus` = 0, `dot_bonus` = 0 WHERE `entry` IN (1495, 1978, 3674, 19306);
  128. INSERT INTO `spell_bonus_data` (`entry`,`direct_bonus`,`dot_bonus`,`ap_bonus`,`ap_dot_bonus`,`comments`) VALUES
  129. (42243, 0, 0,-1,-1, 'Hunter - Volley (Rank 1)'),
  130. (42244, 0, 0,-1,-1, 'Hunter - Volley (Rank 2)'),
  131. (42245, 0, 0,-1,-1, 'Hunter - Volley (Rank 3)'),
  132. (42234, 0, 0,-1,-1, 'Hunter - Volley (Rank 4)'),
  133. (58432, 0, 0,-1,-1, 'Hunter - Volley (Rank 5)'),
  134. (58433, 0, 0,-1,-1, 'Hunter - Volley (Rank 6)'),
  135. (13797, 0, 0,-1,-1, 'Hunter - Immolation Trap (Rank 1)'),
  136. (14298, 0, 0,-1,-1, 'Hunter - Immolation Trap (Rank 2)'),
  137. (14299, 0, 0,-1,-1, 'Hunter - Immolation Trap (Rank 3)'),
  138. (14300, 0, 0,-1,-1, 'Hunter - Immolation Trap (Rank 4)'),
  139. (14301, 0, 0,-1,-1, 'Hunter - Immolation Trap (Rank 5)'),
  140. (27024, 0, 0,-1,-1, 'Hunter - Immolation Trap (Rank 6)'),
  141. (49053, 0, 0,-1,-1, 'Hunter - Immolation Trap (Rank 7)'),
  142. (49054, 0, 0,-1,-1, 'Hunter - Immolation Trap (Rank 8)'),
  143. (13812, 0, 0,-1,-1, 'Hunter - Explosive Trap (Rank 1)'),
  144. (14314, 0, 0,-1,-1, 'Hunter - Explosive Trap (Rank 2)'),
  145. (14315, 0, 0,-1,-1, 'Hunter - Explosive Trap (Rank 3)'),
  146. (27026, 0, 0,-1,-1, 'Hunter - Explosive Trap (Rank 4)'),
  147. (49064, 0, 0,-1,-1, 'Hunter - Explosive Trap (Rank 5)'),
  148. (49065, 0, 0,-1,-1, 'Hunter - Explosive Trap (Rank 6)'),
  149. (19386, 0, 0,-1,-1, 'Hunter - Wyvern Sting');
  150.  
  151. -- Rogue
  152. --
  153. DELETE FROM `spell_bonus_data` WHERE `entry` IN (1943, 2098, 32645);
  154. UPDATE `spell_bonus_data` SET `direct_bonus` = 0, `dot_bonus` = 0 WHERE `entry` IN (703, 1776);
  155. INSERT INTO `spell_bonus_data` (`entry`,`direct_bonus`,`dot_bonus`,`ap_bonus`,`ap_dot_bonus`,`comments`) VALUES
  156. (1943, 0, 0,-1,-1, 'Rogue - Rupture'),
  157. (2098, 0, 0,-1,-1, 'Rogue - Eviscerate'),
  158. (32645, 0, 0,-1,-1, 'Rogue - Envenom');
  159.  
  160. -- DK
  161. -- 47541 search for implementation
  162. -- 49158 search for implementation
  163. DELETE FROM `spell_bonus_data` WHERE `entry` IN (47541, 49158);
  164. UPDATE `spell_bonus_data` SET `direct_bonus` = 0, `dot_bonus` = 0 WHERE `entry` IN (49184);
  165. INSERT INTO `spell_bonus_data` (`entry`,`direct_bonus`,`dot_bonus`,`ap_bonus`,`ap_dot_bonus`,`comments`) VALUES
  166. (47541, 0, 0,-1,-1, 'Death Knight - Death Coil'),
  167. (49158, 0, 0,-1,-1, 'Death Knight - Corpse Explosion');
  168.  
  169. -- Warrior
  170. -- 57755 no idea
  171. -- 6343 no idea
  172. -- 5308 search for implementation
  173. -- 46968 no idea
  174. DELETE FROM `spell_bonus_data` WHERE `entry` IN (5308, 20252, 20253, 23881, 34428, 46968);
  175. UPDATE `spell_bonus_data` SET `direct_bonus` = 0, `dot_bonus` = 0 WHERE `entry` IN (6343, 6572, 57755, 64382);
  176. INSERT INTO `spell_bonus_data` (`entry`,`direct_bonus`,`dot_bonus`,`ap_bonus`,`ap_dot_bonus`,`comments`) VALUES
  177. (5308, 0, 0,-1,-1, 'Warrior - Execute'),
  178. (20253, 0, 0,-1,-1, 'Warrior - Intercept'),
  179. (23881, 0, 0,-1,-1, 'Warrior - Bloodthirst'),
  180. (34428, 0, 0,-1,-1, 'Warrior - Victory Rush'),
  181. (46968, 0, 0,-1,-1, 'Warrior - Shockwave');
  182.  
  183. -- Shaman
  184. --
  185. DELETE FROM `spell_bonus_data` WHERE `entry` IN (8024, 8033);
  186.  
  187. -- Item Spells
  188. --
  189. DELETE FROM `spell_bonus_data` WHERE `entry` IN (55736, 55756);
  190. INSERT INTO `spell_bonus_data` (`entry`,`direct_bonus`,`dot_bonus`,`ap_bonus`,`ap_dot_bonus`,`comments`) VALUES
  191. (55736, 0, 0, 0, 0, 'Item - Brunnhildar Bow'),
  192. (55756, 0, 0, 0, 0, 'Item - Brunnhildar Great Axe/Harpoon');
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!