sql/updates/0.10/5121_mangos_spell_affect.sql

   1 DELETE FROM `spell_affect` WHERE `entry` IN (11071,12496);
   2 INSERT INTO `spell_affect` VALUES
   3  (11071,0,0,0,0,0,0,0x0000000000100000,0),
   4  (12496,0,0,0,0,0,0,0x0000000000100000,0);
   5
   6 DELETE FROM `spell_affect` WHERE `entry` IN (16578,16579,16580,16581,16582);
   7 INSERT INTO `spell_affect` VALUES
   8  (16578,0,0,0,0,0,0,0x0000000000000003,0),
   9  (16579,0,0,0,0,0,0,0x0000000000000003,0),
  10  (16580,0,0,0,0,0,0,0x0000000000000003,0),
  11  (16581,0,0,0,0,0,0,0x0000000000000003,0),
  12  (16582,0,0,0,0,0,0,0x0000000000000003,0);
  13
  14 DELETE FROM `spell_affect` WHERE `entry` IN (16194,16218,16219,16220,16221);
  15 INSERT INTO `spell_affect` VALUES
  16  (16194,0,0,0,0,0,0,0x00000000000001C3,0),
  17  (16218,0,0,0,0,0,0,0x00000000000001C3,0),
  18  (16219,0,0,0,0,0,0,0x00000000000001C3,0),
  19  (16220,0,0,0,0,0,0,0x00000000000001C3,0),
  20  (16221,0,0,0,0,0,0,0x00000000000001C3,0);
  21
  22 DELETE FROM spell_affect WHERE entry IN (16934,16935,16936,16937,16938);
  23 INSERT INTO `spell_affect` VALUES
  24  (16934,0,0,0,0,0,0,0x0010004000000800,0),
  25  (16934,1,0,0,0,0,0,0x0000040000001000,0),
  26  (16935,0,0,0,0,0,0,0x0010004000000800,0),
  27  (16935,1,0,0,0,0,0,0x0000040000001000,0),
  28  (16936,0,0,0,0,0,0,0x0010004000000800,0),
  29  (16936,1,0,0,0,0,0,0x0000040000001000,0),
  30  (16937,0,0,0,0,0,0,0x0010004000000800,0),
  31  (16937,1,0,0,0,0,0,0x0000040000001000,0),
  32  (16938,0,0,0,0,0,0,0x0010004000000800,0),
  33  (16938,1,0,0,0,0,0,0x0000040000001000,0);