/sql/old/3.3.5a/2011_09_03_06_world_spell_threat.sql

http://github.com/TrinityCore/TrinityCore · SQL · 134 lines · 117 code · 1 blank · 16 comment · 0 complexity · d6752aacb4d933566d7f17c9c9805de2 MD5 · raw file 

    

  1. -- ----------
    2. 

  2. -- Tank Class Passive Threat
    3. 

  3. -- ----------
    4. 

  4. DELETE FROM spell_linked_spell WHERE spell_effect IN (57340, 57339);
    5. 

  5. INSERT INTO spell_linked_spell VALUES
    6. 

  6.     (7376,  57339, 2, 'Defensive Stance Passive - Tank Class Passive Threat'),
    7. 

  7.     (21178, 57339, 2, 'Bear Form (Passive2) - Tank Class Passive Threat'),
    8. 

  8.     (25780, 57340, 2, 'Righteous Fury - Tank Class Passive Threat'),
    9. 

  9.     (48263, 57340, 2, 'Frost Presence - Tank Class Passive Threat');
    10. 

  10. 

  11. -- ----------
    12. 

  12. -- restructure spell_threat
    13. 

  13. -- ----------
    14. 

  14. TRUNCATE TABLE `spell_threat`;
    15. 

  15. ALTER    TABLE `spell_threat` CHANGE `Threat` `flatMod` int(6);
    16. 

  16. ALTER    TABLE `spell_threat` ADD COLUMN `pctMod`   FLOAT NOT NULL DEFAULT 1.0 COMMENT 'threat multiplier for damage/healing' AFTER `flatMod`;
    17. 

  17. ALTER    TABLE `spell_threat` ADD COLUMN `apPctMod` FLOAT NOT NULL DEFAULT 0.0 COMMENT 'additional threat bonus from attack power' AFTER `pctMod`;
    18. 

  18. INSERT INTO `spell_threat` VALUES
    19. 

  19. -- Other
    20. 

  20. -- Src: SELECT id, SpellNameEN, RankEN FROM `Spell` WHERE `DescriptionEN` LIKE '%threat%' AND `SpellFamilyName` <> '0' AND NOT (Attributes & 0x40) GROUP BY SpellNameEN ORDER BY RankEN DESC;
    21. 

  21.     (5676,  0,   2.00, 0.0),  -- Searing Pain (Rank 1) (Warlock)
    22. 

  22.     (28176, 0,   0.00, 0.0),  -- Fel Armor - Heal (Rank 1) (Warlock) [Assumption]
    23. 

  23.     (8056,  0,   2.00, 0.0),  -- Frost Shock (Rank 1) (Shaman) [Assumption]
    24. 

  24.     (26688, 0,   0.00, 0.0),  -- Anesthetic Poison - Proc (Rank 1) (Rogue)
    25. 

  25.     (15237, 0,   0.00, 0.0),  -- Holy Nova - Heal (Rank 1) (Priest)
    26. 

  26.     (23455, 0,   0.00, 0.0),  -- Holy Nova - Damage (Rank 1) (Priest)
    27. 

  27.     (32546, 0,   0.50, 0.0),  -- Binding Heal (Rank 1) (Priest) [Assumption]
    28. 

  28.     (33619, 0,   0.00, 0.0),  -- Reflective Shield - Proc (Priest)
    29. 

  29.     (2139,  180, 1.00, 0.0),  -- Counterspell (Mage) [Assumption]
    30. 

  30. -- Death Knight
    31. 

  31. -- Src: http://www.tankspot.com/showthread.php?40485-Death-Knight-threat-values&p=113584#post113584
    32. 

  32.     (63611, 0,   0.00, 0.0),  -- Blood Presence - Heal
    33. 

  33.     (45524, 240, 1.00, 0.0),  -- Chains of Ice
    34. 

  34.     (43265, 0,   1.90, 0.0),  -- Death and Decay
    35. 

  35.     (49576, 110, 1.00, 0.0),  -- Death Grip
    36. 

  36.     (48743, 0,   0.00, 0.0),  -- Death Pact
    37. 

  37.     (65142, 0,   0.00, 0.0),  -- Ebon Plague
    38. 

  38.     (47568, 0,   0.00, 0.0),  -- Empower Rune Weapon
    39. 

  39.     (51209, 112, 1.00, 0.0),  -- Hungering Cold
    40. 

  40.     (49039, 110, 1.00, 0.0),  -- Lichborn
    41. 

  41.     (56815, 0,   1.75, 0.0),  -- Rune Strike
    42. 

  42.     (50422, 0,   0.00, 0.0),  -- Scent of Blood - Proc
    43. 

  43.     (55090, 51,  1.00, 0.0),  -- Scourge Strike (Rank 1)
    44. 

  44.     (55265, 63,  1.00, 0.0),  -- Scourge Strike (Rank 2)
    45. 

  45.     (55270, 98,  1.00, 0.0),  -- Scourge Strike (Rank 3)
    46. 

  46.     (55271, 120, 1.00, 0.0),  -- Scourge Strike (Rank 4)
    47. 

  47.     (49916, 138, 1.00, 0.0),  -- Strangulate
    48. 

  48.     (50181, 0,   0.00, 0.0),  -- Vendetta - Proc
    49. 

  49. -- Druid
    50. 

  50. -- Src: http://www.tankspot.com/showthread.php?47813-WOTLK-Bear-Threat-Values&p=200948#post200948
    51. 

  51.     (17057, 0,   0.00, 0.0),  -- Furor - Proc
    52. 

  52.     (5211,  53,  1.00, 0.0),  -- Bash (Rank 3)
    53. 

  53.     (6798,  105, 1.00, 0.0),  -- Bash (Rank 2)
    54. 

  54.     (8983,  158, 1.00, 0.0),  -- Bash (Rank 1)
    55. 

  55.     (45334, 40,  1.00, 0.0),  -- Feral Charge (Bear) - Root
    56. 

  56.     (19675, 80,  1.00, 0.0),  -- Feral Charge (Bear) - Interrupt
    57. 

  57.     (34299, 0,   0.00, 0.0),  -- Improved Leader of the Pack - Heal
    58. 

  58.     (6807,  13,  1.00, 0.0),  -- Maul (Rank 1)
    59. 

  59.     (6808,  20,  1.00, 0.0),  -- Maul (Rank 2)
    60. 

  60.     (6809,  27,  1.00, 0.0),  -- Maul (Rank 3)
    61. 

  61.     (8972,  47,  1.00, 0.0),  -- Maul (Rank 4)
    62. 

  62.     (9745,  75,  1.00, 0.0),  -- Maul (Rank 5)
    63. 

  63.     (9880,  106, 1.00, 0.0),  -- Maul (Rank 6)
    64. 

  64.     (9881,  140, 1.00, 0.0),  -- Maul (Rank 7)
    65. 

  65.     (26996, 212, 1.00, 0.0),  -- Maul (Rank 8)
    66. 

  66.     (48479, 345, 1.00, 0.0),  -- Maul (Rank 9)
    67. 

  67.     (48480, 422, 1.00, 0.0),  -- Maul (Rank 10)
    68. 

  68.     (60089, 638, 1.00, 0.0),  -- Faerie Fire (Feral) - Proc
    69. 

  69.     (33745, 182, 0.50, 0.0),  -- Lacerate (Rank 1)
    70. 

  70.     (48567, 409, 0.50, 0.0),  -- Lacerate (Rank 2)
    71. 

  71.     (48568, 515, 0.50, 0.0),  -- Lacerate (Rank 3)
    72. 

  72.     (779,   0,   1.50, 0.0),  -- Swipe (Bear) (Rank 1)
    73. 

  73.     (5209,  98,  1.00, 0.0),  -- Challenging Roar
    74. 

  74.     (29166, 0,   10.0, 0.0),  -- Innervate [base is 5 per 1 mana]
    75. 

  75. -- Paladin
    76. 

  76. -- Src: http://www.tankspot.com/showthread.php?39761-Paladin-Threat-Values-(Updated-for-3.2.2)&p=103813#post103813
    77. 

  77.     (7294,  0,   2.00, 0.0),  -- Retribution Aura
    78. 

  78.     (20185, 0,   0.00, 0.0),  -- Judgement of Light
    79. 

  79.     (19742, 0,   0.00, 0.0),  -- Blessing of Wisdom (Rank 1)
    80. 

  80.     (25894, 0,   0.00, 0.0),  -- Greater Blessing of Wisdom (Rank 1)
    81. 

  81.     (20470, 0,   0.00, 0.0),  -- Righteous Fury
    82. 

  82.     (498,   0,   0.00, 0.0),  -- Divine Protection
    83. 

  83. -- Warrior
    84. 

  84. -- Src: http://www.tankspot.com/showthread.php?39775-WoW-3.0-Threat-Values-(Warrior)&p=103972#post103972
    85. 

  85.     (845,   8,   1.00, 0.0),  -- Cleave (Rank 1)
    86. 

  86.     (7369,  15,  1.00, 0.0),  -- Cleave (Rank 2)
    87. 

  87.     (11608, 25,  1.00, 0.0),  -- Cleave (Rank 3)
    88. 

  88.     (11609, 35,  1.00, 0.0),  -- Cleave (Rank 4)
    89. 

  89.     (20569, 48,  1.00, 0.0),  -- Cleave (Rank 5)
    90. 

  90.     (25231, 68,  1.00, 0.0),  -- Cleave (Rank 6)
    91. 

  91.     (47519, 95,  1.00, 0.0),  -- Cleave (Rank 7)
    92. 

  92.     (47520, 112, 1.00, 0.0),  -- Cleave (Rank 8)
    93. 

  93.     (78,    5,   1.00, 0.0),  -- Heroic Strike (Rank 1)
    94. 

  94.     (284,   10,  1.00, 0.0),  -- Heroic Strike (Rank 2)
    95. 

  95.     (285,   16,  1.00, 0.0),  -- Heroic Strike (Rank 3)
    96. 

  96.     (1608,  22,  1.00, 0.0),  -- Heroic Strike (Rank 4)
    97. 

  97.     (11564, 31,  1.00, 0.0),  -- Heroic Strike (Rank 5)
    98. 

  98.     (11565, 48,  1.00, 0.0),  -- Heroic Strike (Rank 6)
    99. 

  99.     (11566, 70,  1.00, 0.0),  -- Heroic Strike (Rank 7)
    100. 

  100.     (11567, 92,  1.00, 0.0),  -- Heroic Strike (Rank 8)
    101. 

  101.     (25286, 104, 1.00, 0.0),  -- Heroic Strike (Rank 9)
    102. 

  102.     (29707, 121, 1.00, 0.0),  -- Heroic Strike (Rank 10)
    103. 

  103.     (30324, 164, 1.00, 0.0),  -- Heroic Strike (Rank 11)
    104. 

  104.     (47449, 224, 1.00, 0.0),  -- Heroic Strike (Rank 12)
    105. 

  105.     (47450, 259, 1.00, 0.0),  -- Heroic Strike (Rank 13)
    106. 

  106.     (57755, 0,   1.50, 0.0),  -- Heroic Throw
    107. 

  107.     (6572,  7,   1.00, 0.0),  -- Revenge (Rank 1)
    108. 

  108.     (6574,  11,  1.00, 0.0),  -- Revenge (Rank 2)
    109. 

  109.     (7379,  15,  1.00, 0.0),  -- Revenge (Rank 3)
    110. 

  110.     (11600, 27,  1.00, 0.0),  -- Revenge (Rank 4)
    111. 

  111.     (11601, 41,  1.00, 0.0),  -- Revenge (Rank 5)
    112. 

  112.     (25288, 53,  1.00, 0.0),  -- Revenge (Rank 6)
    113. 

  113.     (25269, 58,  1.00, 0.0),  -- Revenge (Rank 7)
    114. 

  114.     (30357, 71,  1.00, 0.0),  -- Revenge (Rank 8)
    115. 

  115.     (57823, 121, 1.00, 0.0),  -- Revenge (Rank 9)
    116. 

  116.     (23922, 228, 1.00, 0.0),  -- Shield Slam (Rank 1)
    117. 

  117.     (23923, 268, 1.00, 0.0),  -- Shield Slam (Rank 2)
    118. 

  118.     (23924, 307, 1.00, 0.0),  -- Shield Slam (Rank 3)
    119. 

  119.     (23925, 347, 1.00, 0.0),  -- Shield Slam (Rank 4)
    120. 

  120.     (25258, 387, 1.00, 0.0),  -- Shield Slam (Rank 5)
    121. 

  121.     (30356, 426, 1.00, 0.0),  -- Shield Slam (Rank 6)
    122. 

  122.     (47487, 650, 1.00, 0.0),  -- Shield Slam (Rank 7)
    123. 

  123.     (47488, 770, 1.00, 0.0),  -- Shield Slam (Rank 8)
    124. 

  124.     (1464,  18,  1.00, 0.0),  -- Slam (Rank 1)
    125. 

  125.     (8820,  24,  1.00, 0.0),  -- Slam (Rank 2)
    126. 

  126.     (11604, 38,  1.00, 0.0),  -- Slam (Rank 3)
    127. 

  127.     (11605, 49,  1.00, 0.0),  -- Slam (Rank 4)
    128. 

  128.     (25241, 59,  1.00, 0.0),  -- Slam (Rank 5)
    129. 

  129.     (25242, 78,  1.00, 0.0),  -- Slam (Rank 6)
    130. 

  130.     (47474, 123, 1.00, 0.0),  -- Slam (Rank 7)
    131. 

  131.     (47475, 140, 1.00, 0.0),  -- Slam (Rank 8)
    132. 

  132.     (7386,  345, 1.00, 0.05), -- Sunder Armor
    133. 

  133.     (20243, 0,   1.00, 0.05), -- Devastate (Rank 1)
    134. 

  134.     (6343,  0,   1.85, 0.0);  -- Thunder Clap (Rank 1)
    135.