sql/updates/0.9/4793_mangos_spell_affect.sql

   1 DELETE FROM `spell_affect` WHERE `entry` IN (37441);
   2 INSERT INTO `spell_affect` VALUES
   3 (37441,0,0,0,0,0,0,0x0000000020000000,0),
   4 (37441,1,0,0,0,0,0,0x0000000020000000,0);
   5
   6 DELETE FROM `spell_affect` WHERE `entry` IN (33421,33713,33714);
   7 INSERT INTO `spell_affect` VALUES
   8 (33421,0,0,0,0,0,0,0x0000000200000000,0),
   9 (33713,0,0,0,0,0,0,0x0000000200000000,0),
  10 (33714,0,0,0,0,0,0,0x0000000200000000,0);
  11
  12 DELETE FROM `spell_affect` WHERE `entry` IN (11222,12839,12840,12841,12842);
  13 INSERT INTO `spell_affect` VALUES
  14 (11222,0,0,0,0,0,0,0x0000000020001800,0),
  15 (12839,0,0,0,0,0,0,0x0000000020001800,0),
  16 (12840,0,0,0,0,0,0,0x0000000020001800,0),
  17 (12841,0,0,0,0,0,0,0x0000000020001800,0),
  18 (12842,0,0,0,0,0,0,0x0000000020001800,0);
  19
  20 DELETE FROM `spell_affect` WHERE `entry` IN (11242,12467,12469);
  21 INSERT INTO `spell_affect` VALUES
  22 (11242,0,0,0,0,0,0,0x0000000020001000,0),
  23 (12467,0,0,0,0,0,0,0x0000000020001000,0),
  24 (12469,0,0,0,0,0,0,0x0000000020001000,0);
  25
  26 DELETE FROM `spell_affect` WHERE `entry` IN (12042);
  27 INSERT INTO `spell_affect` VALUES
  28 (12042,0,0,0,0,0,0,0x0000000020E01AF7,0),
  29 (12042,1,0,0,0,0,0,0x0000000020E01AF7,0),
  30 (12042,2,0,0,0,0,0,0x0000000020E01AF7,0);
  31
  32 DELETE FROM `spell_affect` WHERE `entry` IN (11083,12351);
  33 INSERT INTO `spell_affect` VALUES
  34 (11083,0,0,0,0,0,0,0x0000000000C20017,0),
  35 (12351,0,0,0,0,0,0,0x0000000000C20017,0);
  36
  37 DELETE FROM `spell_affect` WHERE `entry` IN (12536);
  38 INSERT INTO `spell_affect` VALUES
  39 (12536,0,0,0,0,0,0,0x0000000020C01AF7,0);
  40
  41 DELETE FROM `spell_affect` WHERE `entry` IN (28682);
  42 INSERT INTO `spell_affect` VALUES
  43 (28682,0,0,0,0,0,0,0x0000004008C20017,0);
  44
  45 DELETE FROM `spell_affect` WHERE `entry` IN (37439);
  46 INSERT INTO `spell_affect` VALUES
  47 (37439,0,0,0,0,0,0,0x0000002000000000,0),
  48 (37439,1,0,0,0,0,0,0x0000004000000000,0),
  49 (37439,2,0,0,0,0,0,0x0000008000000000,0);
  50
  51 DELETE FROM `spell_affect` WHERE `entry` IN (29438,29439,29440);
  52 INSERT INTO `spell_affect` VALUES
  53 (29438,0,0,0,0,0,0,0x0000000000D000D7,0),
  54 (29439,0,0,0,0,0,0,0x0000000000D000D7,0),
  55 (29440,0,0,0,0,0,0,0x0000000000D000D7,0);
  56
  57 DELETE FROM `spell_affect` WHERE `entry` IN (31685);
  58 INSERT INTO `spell_affect` VALUES
  59 (31685,0,0,0,0,0,0,0x0000000000000020,0),
  60 (31685,1,0,0,0,0,0,0x0000000000000020,0);
  61
  62 DELETE FROM `spell_affect` WHERE `entry` IN (11124,12378,12398,12399,12400);
  63 INSERT INTO `spell_affect` VALUES
  64 (11124,0,0,0,0,0,0,0x0000000008C20017,0),
  65 (12378,0,0,0,0,0,0,0x0000000008C20017,0),
  66 (12398,0,0,0,0,0,0,0x0000000008C20017,0),
  67 (12399,0,0,0,0,0,0,0x0000000008C20017,0),
  68 (12400,0,0,0,0,0,0,0x0000000008C20017,0);
  69
  70 DELETE FROM `spell_affect` WHERE `entry` IN (11160,12518,12519);
  71 INSERT INTO `spell_affect` VALUES
  72 (11160,0,0,0,0,0,0,0x00000001020003E0,0),
  73 (12518,0,0,0,0,0,0,0x00000001020003E0,0),
  74 (12519,0,0,0,0,0,0,0x00000001020003E0,0);
  75
  76 DELETE FROM `spell_affect` WHERE `entry` IN (11207,12672,15047,15052,15053);
  77 INSERT INTO `spell_affect` VALUES
  78 (11207,0,0,0,0,0,0,0x00000000000002E0,0),
  79 (12672,0,0,0,0,0,0,0x00000000000002E0,0),
  80 (15047,0,0,0,0,0,0,0x00000000000002E0,0),
  81 (15052,0,0,0,0,0,0,0x00000000000002E0,0),
  82 (15053,0,0,0,0,0,0,0x00000000000002E0,0);
  83
  84 DELETE FROM `spell_affect` WHERE `entry` IN (24429);
  85 INSERT INTO `spell_affect` VALUES
  86 (24429,0,0,0,0,0,0,0x0000000000004000,0);
  87
  88 DELETE FROM `spell_affect` WHERE `entry` IN (22008);
  89 INSERT INTO `spell_affect` VALUES
  90 (22008,0,0,0,0,0,0,0x0000000021400035,1);
  91
  92 DELETE FROM `spell_affect` WHERE `entry` IN (11151,12952,12953,12954,12957);
  93 INSERT INTO `spell_affect` VALUES
  94 (11151,0,0,0,0,0,0,0x00000000000002E0,0),
  95 (12952,0,0,0,0,0,0,0x00000000000002E0,0),
  96 (12953,0,0,0,0,0,0,0x00000000000002E0,0),
  97 (12954,0,0,0,0,0,0,0x00000000000002E0,0),
  98 (12957,0,0,0,0,0,0,0x00000000000002E0,0);
  99
 100 DELETE FROM `spell_affect` WHERE `entry` IN (12043,29976);
 101 INSERT INTO `spell_affect` VALUES
 102 (12043,0,0,0,0,0,0,0x0000000021400035,0),
 103 (29976,0,0,0,0,0,0,0x0000000021400035,0);
 104
 105 DELETE FROM `spell_affect` WHERE `entry` IN (35578,35581);
 106 INSERT INTO `spell_affect` VALUES
 107 (35578,0,0,0,0,0,0,0x0000000028C21AF7,0),
 108 (35581,0,0,0,0,0,0,0x0000000028C21AF7,0);
 109