sql/updates/0.8/4595_spell_affect.sql

   1 DELETE FROM `spell_affect` WHERE `entry` IN (21873,38314);
   2 INSERT INTO `spell_affect` VALUES
   3 (21873,0,0,0,0,0,0,0x0000E000E2000000,0), -- ?? rare druid armor
   4 (38314,0,0,0,0,0,0,0x0000E000E2000000,0); -- for item 31334
   5
   6 DELETE FROM `spell_affect` WHERE `entry` IN (16870);
   7 INSERT INTO `spell_affect` VALUES
   8 (16870,0,0,0,0,0,0,0x001007F100E3FEFF,0);
   9
  10 DELETE FROM `spell_affect` WHERE `entry` IN (16947,16948,16949);
  11 INSERT INTO `spell_affect` VALUES
  12 (16947,1,0,0,0,0,0,0x0000000002000000,0),
  13 (16948,1,0,0,0,0,0,0x0000000002000000,0),
  14 (16949,1,0,0,0,0,0,0x0000000002000000,0);
  15
  16 DELETE FROM `spell_affect` WHERE `entry` IN (17104,24943,24944,24945,24946);
  17 INSERT INTO `spell_affect` VALUES
  18 (17104,0,0,0,0,0,0,0x00000010000000F0,0),
  19 (17104,1,0,0,0,0,0,0x00000010000000F0,0),
  20 (24943,0,0,0,0,0,0,0x00000010000000F0,0),
  21 (24943,1,0,0,0,0,0,0x00000010000000F0,0),
  22 (24944,0,0,0,0,0,0,0x00000010000000F0,0),
  23 (24944,1,0,0,0,0,0,0x00000010000000F0,0),
  24 (24945,0,0,0,0,0,0,0x00000010000000F0,0),
  25 (24945,1,0,0,0,0,0,0x00000010000000F0,0),
  26 (24946,0,0,0,0,0,0,0x00000010000000F0,0),
  27 (24946,1,0,0,0,0,0,0x00000010000000F0,0);
  28
  29 DELETE FROM `spell_affect` WHERE `entry` IN (37721);
  30 INSERT INTO `spell_affect` VALUES
  31 (37721,0,0,0,0,0,0,0x00000010000000F0,1); -- not used in 2.3.0
  32
  33 DELETE FROM `spell_affect` WHERE `entry` IN (42367);
  34 INSERT INTO `spell_affect` VALUES
  35 (42367,0,0,0,0,0,0,0x0000001000000000,0); -- not used in 2.3.0 (?)
  36
  37 DELETE FROM `spell_affect` WHERE `entry` IN (38447);
  38 INSERT INTO `spell_affect` VALUES
  39 (38447,0,0,0,0,0,0,0x0000040000000000,0),
  40 (38447,1,0,0,0,0,0,0x0000004000000000,0);
  41
  42 DELETE FROM `spell_affect` WHERE `entry` IN (37292);
  43 INSERT INTO `spell_affect` VALUES
  44 (37292,0,0,0,0,0,0,0x0008000000000000,0);
  45
  46 DELETE FROM `spell_affect` WHERE `entry` IN (39926);
  47 INSERT INTO `spell_affect` VALUES
  48 (39926,1,0,0,0,0,0,0x0000080000000000,0),
  49 (39926,2,0,0,0,0,0,0x0000200000000000,0);
  50
  51 DELETE FROM `spell_affect` WHERE `entry` IN (38416);
  52 INSERT INTO `spell_affect` VALUES
  53 (38416,0,0,0,0,0,0,0x0010000000800000,0),
  54 (38416,1,0,0,0,0,0,0x0010000000800000,0);
  55
  56 DELETE FROM `spell_affect` WHERE `entry` IN (37736);
  57 INSERT INTO `spell_affect` VALUES
  58 (37736,0,0,0,0,0,0,0x0000040000000000,0),
  59 (37736,1,0,0,0,0,0,0x0000004000000000,0);
  60
  61 DELETE FROM `spell_affect` WHERE `entry` IN (28855);
  62 INSERT INTO `spell_affect` VALUES
  63 (28855,0,0,0,0,0,0,0x0000000000000800,0),
  64 (28855,1,0,0,0,0,0,0x0010000000000000,0);
  65
  66 DELETE FROM `spell_affect` WHERE `entry` IN (23724);
  67 INSERT INTO `spell_affect` VALUES
  68 (23724,0,0,0,0,0,0,0x0000E000E2000000,0);
  69
  70 DELETE FROM `spell_affect` WHERE `entry` IN (16833,16834,16835);
  71 INSERT INTO `spell_affect` VALUES
  72 (16833,0,0,0,0,0,0,0x0000E000E2000000,0),
  73 (16834,0,0,0,0,0,0,0x0000E000E2000000,0),
  74 (16835,0,0,0,0,0,0,0x0000E000E2000000,0);
  75
  76 DELETE FROM `spell_affect` WHERE `entry` IN (16886);
  77 INSERT INTO `spell_affect` VALUES
  78 (16886,0,0,0,0,0,0,0x0000000001000265,1);
  79
  80 DELETE FROM `spell_affect` WHERE `entry` IN (16819,16820);
  81 INSERT INTO `spell_affect` VALUES
  82 (16819,0,0,0,0,0,0,0x0002122000600707,0),
  83 (16820,0,0,0,0,0,0,0x0002122000600707,0);
  84
  85 DELETE FROM `spell_affect` WHERE `entry` IN (17116,38466);
  86 INSERT INTO `spell_affect` VALUES
  87 (17116,0,0,0,0,0,0,0x0002002010000261,0),
  88 (38466,0,0,0,0,0,0,0x0008000000000000,0);
  89
  90 DELETE FROM `spell_affect` WHERE `entry` IN (37287);
  91 INSERT INTO `spell_affect` VALUES
  92 (37287,0,0,0,0,0,0,0x0000E000E2000000,0);
  93
  94 DELETE FROM `spell_affect` WHERE `entry` IN (17118,17119,17120,17121,17122);
  95 INSERT INTO `spell_affect` VALUES
  96 (17118,0,0,0,0,0,0,0x001005D000E193F7,0),
  97 (17118,1,0,0,0,0,0,0x0004103000340750,0),
  98 (17119,0,0,0,0,0,0,0x001005D000E193F7,0),
  99 (17119,1,0,0,0,0,0,0x0004103000340750,0),
 100 (17120,0,0,0,0,0,0,0x001005D000E193F7,0),
 101 (17120,1,0,0,0,0,0,0x0004103000340750,0),
 102 (17121,0,0,0,0,0,0,0x001005D000E193F7,0),
 103 (17121,1,0,0,0,0,0,0x0004103000340750,0),
 104 (17122,0,0,0,0,0,0,0x001005D000E193F7,0),
 105 (17122,1,0,0,0,0,0,0x0004103000340750,0);