sql/updates/0.10/5036_mangos_spell_affect.sql

   1 DELETE FROM `spell_affect` WHERE `entry` IN (12945);
   2 INSERT INTO `spell_affect` VALUES
   3  (12945,0,0,0,0,0,0,0x0000000000001000,0),
   4  (12945,1,0,0,0,0,0,0x0000000000001000,0);
   5
   6 DELETE FROM `spell_affect` WHERE `entry` IN (29787,29790,29792);
   7 INSERT INTO `spell_affect` VALUES
   8  (29787,0,0,0,0,0,0,0x0000036C2A764EEF,0),
   9  (29790,0,0,0,0,0,0,0x0000036C2A764EEF,0),
  10  (29792,0,0,0,0,0,0,0x0000036C2A764EEF,0);
  11
  12 DELETE FROM `spell_affect` WHERE `entry` IN (21887);
  13 INSERT INTO `spell_affect` VALUES
  14  (21887,0,0,0,0,0,0,0x0000036C2A764EEF,0);
  15
  16 DELETE FROM `spell_affect` WHERE `entry` IN (16493,16494);
  17 INSERT INTO `spell_affect` VALUES
  18  (16493,0,0,0,0,0,0,0x0000014D2A600CEF,0),
  19  (16494,0,0,0,0,0,0,0x0000014D2A600CEF,0);
  20
  21 DELETE FROM `spell_affect` WHERE `entry` IN (37517);
  22 INSERT INTO `spell_affect` VALUES
  23  (37517,0,0,0,0,0,0,0x0000014D2A600CEF,0);
  24
  25 DELETE FROM `spell_affect` WHERE `entry` IN (12866,12865,12864,12863,12325);
  26 INSERT INTO `spell_affect` VALUES
  27  (12866,0,0,0,0,0,0,0x0000000000000000,0),
  28  (12865,0,0,0,0,0,0,0x0000000000000000,0),
  29  (12864,0,0,0,0,0,0,0x0000000000000000,0),
  30  (12863,0,0,0,0,0,0,0x0000000000000000,0),
  31  (12325,0,0,0,0,0,0,0x0000000000000000,0);
  32
  33 DELETE FROM `spell_affect` WHERE `entry` IN (35446,35448,35449,35450,35451);
  34 INSERT INTO `spell_affect` VALUES
  35  (35446,0,0,0,0,0,0,0x0000000002000000,0),
  36  (35446,1,0,0,0,0,0,0x0000000002000000,0),
  37  (35448,0,0,0,0,0,0,0x0000000002000000,0),
  38  (35448,1,0,0,0,0,0,0x0000000002000000,0),
  39  (35449,0,0,0,0,0,0,0x0000000002000000,0),
  40  (35449,1,0,0,0,0,0,0x0000000002000000,0),
  41  (35450,0,0,0,0,0,0,0x0000000002000000,0),
  42  (35450,1,0,0,0,0,0,0x0000000002000000,0),
  43  (35451,0,0,0,0,0,0,0x0000000002000000,0),
  44  (35451,1,0,0,0,0,0,0x0000000002000000,0);
  45
  46 DELETE FROM `spell_affect` WHERE `entry` IN (38407);
  47 INSERT INTO `spell_affect` VALUES
  48  (38407,0,0,0,0,0,0,0x0000000100000000,0);
  49
  50 DELETE FROM `spell_affect` WHERE `entry` IN (28842);
  51 INSERT INTO `spell_affect` VALUES
  52  (28842,0,0,0,0,0,0,0x0000000100004440,0);