sql/updates/8251_01_mangos_spell_chain.sql

   1 ALTER TABLE db_version CHANGE COLUMN required_8250_01_mangos_spell_threat required_8251_01_mangos_spell_chain bit;
   2
   3 DELETE FROM `spell_chain` WHERE `spell_id` IN (
   4   7268,7269,7270,8419,8418,10273,10274,25346,27076,38700,38703,42844,42845,
   5   42208,42209,42210,42211,42212,42213,42198,42937,42938,
   6   34913,43043,43044,
   7   25912,25911,25902,27176,33073,48822,48823,
   8   25914,25913,25903,27175,33074,48820,48821,
   9   23455,23458,23459,27803,27804,27805,25329,
  10   49821,53022,
  11   8443,8504,8505,11310,11311,25538,25539,61651,61660,
  12   8026,8028,8029,10445,16343,16344,25488,58786,58787,58788,
  13   26364,26365,26366,26367,26369,26370,26363,26371,26372,49278,49279,
  14   8188,10582,10583,10584,25551,58733,58736,
  15   3606,6350,6351,6352,10435,10436,25530,58700,58701,58702,
  16   5857,11681,11682,27214,47822,
  17   42223,42224,42225,42226,42218,47817,47818
  18 );
  19
  20 INSERT INTO `spell_chain` (`spell_id`, `prev_spell`, `first_spell`, `rank`, `req_spell`) VALUES
  21 /* Arcane Missiles Triggered Spell */
  22 (7268,0,7268,1,0),
  23 (7269,7268,7268,2,0),
  24 (7270,7269,7268,3,0),
  25 (8419,7270,7268,4,0),
  26 (8418,8419,7268,5,0),
  27 (10273,8418,7268,6,0),
  28 (10274,10273,7268,7,0),
  29 (25346,10274,7268,8,0),
  30 (27076,25346,7268,9,0),
  31 (38700,27076,7268,10,0),
  32 (38703,38700,7268,11,0),
  33 (42844,38703,7268,12,0),
  34 (42845,42844,7268,13,0),
  35 /* Blizzard Triggered Spell */
  36 (42208,0,42208,1,0),
  37 (42209,42208,42208,2,0),
  38 (42210,42209,42208,3,0),
  39 (42211,42210,42208,4,0),
  40 (42212,42211,42208,5,0),
  41 (42213,42212,42208,6,0),
  42 (42198,42213,42208,7,0),
  43 (42937,42198,42208,8,0),
  44 (42938,42937,42208,9,0),
  45 /* Molten Armor Triggered */
  46 (34913,0,34913,1,0),
  47 (43043,34913,34913,2,0),
  48 (43044,43043,34913,3,0),
  49 /* Holy Shock Triggered Hurt */
  50 (25912,0,25912,1,0),
  51 (25911,25912,25912,2,0),
  52 (25902,25911,25912,3,0),
  53 (27176,25902,25912,4,0),
  54 (33073,27176,25912,5,0),
  55 (48822,33073,25912,6,0),
  56 (48823,48822,25912,7,0),
  57 /* Holy Shock Triggered Heal */
  58 (25914,0,25914,1,0),
  59 (25913,25914,25914,2,0),
  60 (25903,25913,25914,3,0),
  61 (27175,25903,25914,4,0),
  62 (33074,27175,25914,5,0),
  63 (48820,33074,25914,6,0),
  64 (48821,48820,25914,7,0),
  65 /* Holy Nova Heal */
  66 (23455,0,23455,1,0),
  67 (23458,23455,23455,2,0),
  68 (23459,23458,23455,3,0),
  69 (27803,23459,23455,4,0),
  70 (27804,27803,23455,5,0),
  71 (27805,27804,23455,6,0),
  72 (25329,27805,23455,7,0),
  73 /* Mind Sear Trigger */
  74 (49821,0,49821,1,0),
  75 (53022,49821,49821,2,0),
  76 /* Fire Nova Totem Casted by Totem */
  77 (8443,0,8443,1,0),
  78 (8504,8443,8443,2,0),
  79 (8505,8504,8443,3,0),
  80 (11310,8505,8443,4,0),
  81 (11311,11310,8443,5,0),
  82 (25538,11311,8443,6,0),
  83 (25539,25538,8443,7,0),
  84 (61651,25539,8443,8,0),
  85 (61660,61651,8443,9,0),
  86 /* Flametongue Weapon Proc */
  87 (8026,0,8026,1,0),
  88 (8028,8026,8026,2,0),
  89 (8029,8028,8026,3,0),
  90 (10445,8029,8026,4,0),
  91 (16343,10445,8026,5,0),
  92 (16344,16343,8026,6,0),
  93 (25488,16344,8026,7,0),
  94 (58786,25488,8026,8,0),
  95 (58787,58786,8026,9,0),
  96 (58788,58787,8026,10,0),
  97 /* Lightning Shield Proc */
  98 (26364,0,26364,1,0),
  99 (26365,26364,26364,2,0),
 100 (26366,26365,26364,3,0),
 101 (26367,26366,26364,4,0),
 102 (26369,26367,26364,5,0),
 103 (26370,26369,26364,6,0),
 104 (26363,26370,26364,7,0),
 105 (26371,26363,26364,8,0),
 106 (26372,26371,26364,9,0),
 107 (49278,26372,26364,10,0),
 108 (49279,49278,26364,11,0),
 109 /* Magma Totam Passive */
 110 (8188,0,8188,1,0),
 111 (10582,8188,8188,2,0),
 112 (10583,10582,8188,3,0),
 113 (10584,10583,8188,4,0),
 114 (25551,10584,8188,5,0),
 115 (58733,25551,8188,6,0),
 116 (58736,58733,8188,7,0),
 117 /* Searing Totem Attack */
 118 (3606,0,3606,1,0),
 119 (6350,3606,3606,2,0),
 120 (6351,6350,3606,3,0),
 121 (6352,6351,3606,4,0),
 122 (10435,6352,3606,5,0),
 123 (10436,10435,3606,6,0),
 124 (25530,10436,3606,7,0),
 125 (58700,25530,3606,8,0),
 126 (58701,58700,3606,9,0),
 127 (58702,58701,3606,10,0),
 128 /* Hellfire Effect on Enemy */
 129 (5857,0,5857,1,0),
 130 (11681,5857,5857,2,0),
 131 (11682,11681,5857,3,0),
 132 (27214,11682,5857,4,0),
 133 (47822,27214,5857,5,0),
 134 /* Rain of Fire Triggered */
 135 (42223,0,42223,1,0),
 136 (42224,42223,42223,2,0),
 137 (42225,42224,42223,3,0),
 138 (42226,42225,42223,4,0),
 139 (42218,42226,42223,5,0),
 140 (47817,42218,42223,6,0),
 141 (47818,47817,42223,7,0);