sql/updates/0.10/4937_mangos_spell_affect.sql

   1 DELETE FROM `spell_affect` WHERE `entry` IN (11069,12338,12339,12340,12341);
   2 INSERT INTO `spell_affect` VALUES
   3  (11069,0,0,0,0,0,0,0x0000000000000001,0),
   4  (12338,0,0,0,0,0,0,0x0000000000000001,0),
   5  (12339,0,0,0,0,0,0,0x0000000000000001,0),
   6  (12340,0,0,0,0,0,0,0x0000000000000001,0),
   7  (12341,0,0,0,0,0,0,0x0000000000000001,0);
   8
   9 DELETE FROM `spell_affect` WHERE `entry` IN (11070,12473,16763,16765,16766);
  10 INSERT INTO `spell_affect` VALUES
  11  (11070,0,0,0,0,0,0,0x0000000000000020,0),
  12  (12473,0,0,0,0,0,0,0x0000000000000020,0),
  13  (16763,0,0,0,0,0,0,0x0000000000000020,0),
  14  (16765,0,0,0,0,0,0,0x0000000000000020,0),
  15  (16766,0,0,0,0,0,0,0x0000000000000020,0);
  16
  17 DELETE FROM `spell_affect` WHERE `entry` IN (17941);
  18 INSERT INTO `spell_affect` VALUES
  19  (17941,0,0,0,0,0,0,0x0000000000000001,1);
  20
  21 DELETE FROM `spell_affect` WHERE `entry` IN (20335,20336,20337);
  22 INSERT INTO `spell_affect` VALUES
  23  (20335,0,0,0,0,0,0,0x0000000020000000,0),
  24  (20336,0,0,0,0,0,0,0x0000000020000000,0),
  25  (20337,0,0,0,0,0,0,0x0000000020000000,0);
  26
  27 DELETE FROM `spell_affect` WHERE `entry` IN (32043,35396,35397);
  28 INSERT INTO `spell_affect` VALUES
  29  (32043,1,0,0,0,0,0,0x0000040008000000,0),
  30  (35396,1,0,0,0,0,0,0x0000040008000000,0),
  31  (35397,1,0,0,0,0,0,0x0000040008000000,0);
  32
  33 DELETE FROM `spell_affect` WHERE `entry` IN (36591);
  34
  35 DELETE FROM `spell_affect` WHERE `entry` IN (28176);
  36
  37 DELETE FROM `spell_affect` WHERE `entry` IN (28189);
  38
  39 DELETE FROM `spell_affect` WHERE `entry` IN (31842);
  40
  41 DELETE FROM `spell_affect` WHERE `entry` IN (38390);
  42
  43 DELETE FROM `spell_affect` WHERE `entry` IN (37188);
  44 DELETE FROM `spell_affect` WHERE `entry` IN (37189);
  45 DELETE FROM `spell_affect` WHERE `entry` IN (37227);
  46
  47 DELETE FROM `spell_affect` WHERE `entry` IN (43837);
  48 INSERT INTO `spell_affect` VALUES
  49  (43837,0,0,0,0,0,0,0x0000000080000000,0);
  50
  51 DELETE FROM `spell_affect` WHERE `entry` IN (39950);
  52 INSERT INTO `spell_affect` VALUES
  53  (39950,0,0,0,0,0,0,0x0000000000000040,0);
  54
  55
  56