sql/updates/7988_03_mangos_spell_chain.sql

   1 ALTER TABLE db_version CHANGE COLUMN required_7988_01_mangos_item_template required_7988_03_mangos_spell_chain bit;
   2
   3 DELETE FROM spell_chain WHERE first_spell IN (
   4   704,   /* Curse of Recklessness removed */
   5   770,   /* Faerie Fire non ranked now */
   6   16857, /* Faerie Fire (Feral) non ranked now */
   7   17962, /* Conflagrate non ranked now */
   8   18265, /* Siphon Life removed (replaced by different talent */
   9   26090, /* Thunderstomp non ranked now (rank 6 only O.o) */
  10   49184, /* Howling Blast skip old rank 2 */
  11   49224  /* Magic Suppression lost 2 ranks */
  12 );
  13
  14 INSERT INTO spell_chain VALUES
  15 /*------------------
  16 --(8)Fire
  17 ------------------*/
  18 /*Fiery Payback*/
  19 (64353,0,64353,1,0),
  20 (64357,64353,64353,2,0),
  21 /*------------------
  22 -- (56) Holy (Priest)
  23 ------------------*/
  24 /*Body and Soul*/
  25 (64127,0,64127,1,0),
  26 (64129,64127,64127,2,0),
  27 /*Empowered Renew*/
  28 (63534,0,63534,1,0),
  29 (63542,63534,63534,2,0),
  30 (63543,63542,63534,3,0),
  31 /*Serendipity*/
  32 (63730,0,63730,1,0),
  33 (63733,63730,63730,2,0),
  34 (63737,63733,63730,3,0),
  35 /*------------------
  36 -- (78) Shadow Magic
  37 ------------------*/
  38 /*Improved Devouring Plague*/
  39 (63625,0,63625,1,0),
  40 (63626,63625,63625,2,0),
  41 (63627,63626,63625,3,0),
  42 /*------------------
  43 -- (267) Protection (Paladin)
  44 ------------------*/
  45 /*Divinity*/
  46 (63646,0,63646,1,0),
  47 (63647,63646,63646,2,0),
  48 (63648,63647,63646,3,0),
  49 (63649,63648,63646,4,0),
  50 (63650,63649,63646,5,0),
  51 /*------------------
  52 --(270)Pet-GenericHunter
  53 ------------------*/
  54 /*Shark Attack*/
  55 (62759,0,62759,1,0),
  56 (62760,62759,62759,2,0),
  57 /*Silverback*/
  58 (62764,0,62764,1,0),
  59 (62765,62764,62764,2,0),
  60 /*Wild Hunt*/
  61 (62758,0,62758,1,0),
  62 (62762,62758,62758,2,0),
  63 /*------------------
  64 --(354)Demonology
  65 ------------------*/
  66 /*Decimation*/
  67 (63156,0,63156,1,0),
  68 (63158,63156,63156,2,0),
  69 /*Nemesis*/
  70 (63117,0,63117,1,0),
  71 (63121,63117,63117,2,0),
  72 (63123,63121,63117,3,0),
  73 /*------------------
  74 --(373) Enhancement
  75 ------------------*/
  76 /*Frozen Power*/
  77 (63373,0,63373,1,0),
  78 (63374,63373,63373,2,0),
  79 /*------------------
  80 -- (375) Elemental Combat
  81 ------------------*/
  82 /*Booming Echoes*/
  83 (63370,0,63370,1,0),
  84 (63372,63370,63370,2,0),
  85 /*------------------
  86 --(573)Restoration
  87 ------------------*/
  88 /*Improved Barkskin*/
  89 (63410,0,63410,1,0),
  90 (63411,63410,63410,2,0),
  91 /*------------------
  92 --(593)Destruction
  93 ------------------*/
  94 /*Molten Skin*/
  95 (63349,0,63349,1,0),
  96 (63350,63349,63349,2,0),
  97 (63351,63350,63349,3,0),
  98 /*------------------
  99 --(613)Discipline
 100 ------------------*/
 101 /*Improved Flash Heal*/
 102 (63504,0,63504,1,0),
 103 (63505,63504,63504,2,0),
 104 (63506,63505,63504,3,0),
 105 /*------------------
 106 --(770)Blood
 107 ------------------*/
 108 /*Death Coil*/
 109 (62900,0,62900,1,0),
 110 (62901,62900,62900,2,0),
 111 (62902,62901,62900,3,0),
 112 (62903,62902,62900,4,0),
 113 (62904,62903,62900,5,0),
 114 /*Improved Blood Presence*/
 115 (50365,0,50365,1,0),
 116 (50371,50365,50365,2,0),
 117 /*Improved Death Strike*/
 118 (62905,0,62905,1,0),
 119 (62908,62905,62905,2,0),
 120 /*------------------
 121 --(771)Frost
 122 ------------------*/
 123 /*Howling Blast*/
 124 (49184,0,49184,1,0),
 125 (51409,49184,49184,2,0),
 126 (51410,51409,49184,3,0),
 127 (51411,51410,49184,4,0),
 128 /*Improved Frost Presence*/
 129 (50384,0,50384,1,0),
 130 (50385,50384,50384,2,0),
 131 /*------------------
 132 --(772)Unholy
 133 ------------------*/
 134 /*Improved Unholy Presence*/
 135 (50391,0,50391,1,0),
 136 (50392,50391,50391,2,0),
 137 /*Magic Suppression*/
 138 (49224,0,49224,1,0),
 139 (49610,49224,49224,2,0),
 140 (49611,49610,49224,3,0);