sql/updates/0.10/4916_mangos_spell_affect.sql

   1 DELETE FROM `spell_affect` WHERE `entry` IN (43857,43858,43859);
   2 INSERT INTO `spell_affect` VALUES
   3 (43857,0,0,0,0,0,0,0x0000001000000000,0),
   4 (43858,0,0,0,0,0,0,0x0000001000000000,0),
   5 (43859,0,0,0,0,0,0,0x0000001000000000,0);
   6
   7 DELETE FROM `spell_affect` WHERE `entry` IN (43860,43861,43862);
   8 INSERT INTO `spell_affect` VALUES
   9 (43860,0,0,0,0,0,0,0x0000000090100000,0),
  10 (43861,0,0,0,0,0,0,0x0000000090100000,0),
  11 (43862,0,0,0,0,0,0,0x0000000090100000,0);
  12
  13 DELETE FROM `spell_affect` WHERE `entry` IN (28787);
  14 INSERT INTO `spell_affect` VALUES
  15 (28787,0,0,0,0,0,0,0x0000000000001000,0);
  16
  17 DELETE FROM `spell_affect` WHERE `entry` IN (41042,43850,43851,43852);
  18 INSERT INTO `spell_affect` VALUES
  19 (41042,0,0,0,0,0,0,0x0000000000800000,0),
  20 (43850,0,0,0,0,0,0,0x0000000000800000,0),
  21 (43851,0,0,0,0,0,0,0x0000000000800000,0),
  22 (43852,0,0,0,0,0,0,0x0000000000800000,0);
  23
  24 DELETE FROM `spell_affect` WHERE `entry` IN (43854,43855,43856);
  25 INSERT INTO `spell_affect` VALUES
  26 (43854,0,0,0,0,0,0,0x0000004000000000,0),
  27 (43855,0,0,0,0,0,0,0x0000004000000000,0),
  28 (43856,0,0,0,0,0,0,0x0000004000000000,0);
  29
  30 DELETE FROM `spell_affect` WHERE `entry` IN (41037,43840,43842,43843);
  31 INSERT INTO `spell_affect` VALUES
  32 (41037,0,0,0,0,0,0,0x0000044000000000,0),
  33 (43840,0,0,0,0,0,0,0x0000044000000000,0),
  34 (43842,0,0,0,0,0,0,0x0000044000000000,0),
  35 (43843,0,0,0,0,0,0,0x0000044000000000,0);
  36
  37 DELETE FROM `spell_affect` WHERE `entry` IN (43841,43844,43845);
  38 INSERT INTO `spell_affect` VALUES
  39 (43841,0,0,0,0,0,0,0x0000000000000002,0),
  40 (43844,0,0,0,0,0,0,0x0000000000000002,0),
  41 (43845,0,0,0,0,0,0,0x0000000000000002,0);
  42
  43 DELETE FROM `spell_affect` WHERE `entry` IN (40460);
  44 INSERT INTO `spell_affect` VALUES
  45 (40460,0,0,0,0,0,0,0x00000009003E0000,0);
  46
  47 DELETE FROM `spell_affect` WHERE `entry` IN (28814);
  48 INSERT INTO `spell_affect` VALUES
  49 (28814,0,0,0,0,0,0,0x0000000000020000,0);
  50
  51 DELETE FROM `spell_affect` WHERE `entry` IN (17768);
  52 INSERT INTO `spell_affect` VALUES
  53 (17768,0,0,0,0,0,0,0x0000000040000000,0),
  54 (17768,1,0,0,0,0,0,0x0000000080000000,0);
  55
  56 DELETE FROM `spell_affect` WHERE `entry` IN (29836,29859);
  57 INSERT INTO `spell_affect` VALUES
  58 (29836,0,0,0,0,0,0,0x0000001000000020,0),
  59 (29859,0,0,0,0,0,0,0x0000001000000020,0);
  60