sql/updates/0.10/5462_mangos_spell_affect.sql

   1 DELETE FROM `spell_affect` WHERE `entry` IN (17778,17779,17780,17781,17782);
   2 INSERT INTO `spell_affect` VALUES
   3  (17778,0,0,0,0,0,0,0x000010C0000003E5,0),
   4  (17779,0,0,0,0,0,0,0x000010C0000003E5,0),
   5  (17780,0,0,0,0,0,0,0x000010C0000003E5,0),
   6  (17781,0,0,0,0,0,0,0x000010C0000003E5,0),
   7  (17782,0,0,0,0,0,0,0x000010C0000003E5,0);
   8
   9 DELETE FROM `spell_affect` WHERE `entry` IN (23555);
  10 INSERT INTO `spell_affect` VALUES
  11  (23555,0,0,0,0,0,0,0x000010C0000003E5,0);
  12
  13
  14 DELETE FROM `spell_affect` WHERE `entry` IN (18130,18131,18132,18133,18134);
  15 INSERT INTO `spell_affect` VALUES
  16  (18130,0,0,0,0,0,0,0x000010C0000003E5,0),
  17  (18131,0,0,0,0,0,0,0x000010C0000003E5,0),
  18  (18132,0,0,0,0,0,0,0x000010C0000003E5,0),
  19  (18133,0,0,0,0,0,0,0x000010C0000003E5,0),
  20  (18134,0,0,0,0,0,0,0x000010C0000003E5,0);
  21
  22 DELETE FROM `spell_affect` WHERE `entry` IN (18135,18136);
  23 INSERT INTO `spell_affect` VALUES
  24  (18135,0,0,0,0,0,0,0x000010C0000003E5,0),
  25  (18136,0,0,0,0,0,0,0x000010C0000003E5,0);
  26
  27 DELETE FROM `spell_affect` WHERE `entry` IN (17959);
  28 INSERT INTO `spell_affect` VALUES
  29  (17959,0,0,0,0,0,0,0x000010C0000003E5,0);
  30
  31 DELETE FROM `spell_affect` WHERE `entry` IN (17917,17918);
  32 INSERT INTO `spell_affect` VALUES
  33  (17917,0,0,0,0,0,0,0x000010C0000003A5,0),
  34  (17917,1,0,0,0,0,0,0x000010C0000003E5,0),
  35  (17918,0,0,0,0,0,0,0x000010C0000003A5,0),
  36  (17918,1,0,0,0,0,0,0x000010C0000003E5,0);
  37
  38 DELETE FROM `spell_affect` WHERE `entry` IN (30060,30061,30062,30063,30064);
  39 INSERT INTO `spell_affect` VALUES
  40  (30060,0,0,0,0,0,0,0x0000001000000402,0),
  41  (30060,1,0,0,0,0,0,0x0000001000000402,0),
  42  (30060,2,0,0,0,0,0,0x0000871B804CC41A,0),
  43  (30061,0,0,0,0,0,0,0x0000001000000402,0),
  44  (30061,1,0,0,0,0,0,0x0000001000000402,0),
  45  (30061,2,0,0,0,0,0,0x0000871B804CC41A,0),
  46  (30062,0,0,0,0,0,0,0x0000001000000402,0),
  47  (30062,1,0,0,0,0,0,0x0000001000000402,0),
  48  (30062,2,0,0,0,0,0,0x0000871B804CC41A,0),
  49  (30063,0,0,0,0,0,0,0x0000001000000402,0),
  50  (30063,1,0,0,0,0,0,0x0000001000000402,0),
  51  (30063,2,0,0,0,0,0,0x0000871B804CC41A,0),
  52  (30064,0,0,0,0,0,0,0x0000001000000402,0),
  53  (30064,1,0,0,0,0,0,0x0000001000000402,0),
  54  (30064,2,0,0,0,0,0,0x0000871B804CC41A,0);
  55
  56 DELETE FROM `spell_affect` WHERE `entry` IN (18218,18219);
  57 INSERT INTO `spell_affect` VALUES
  58  (18218,0,0,0,0,0,0,0x000007138048C41A,0),
  59  (18219,0,0,0,0,0,0,0x000007138048C41A,0);
  60
  61 DELETE FROM `spell_affect` WHERE `entry` IN (30085,30086);
  62 INSERT INTO `spell_affect` VALUES
  63  (30085,0,0,0,0,0,0,0x0000071B804CC41A,0),
  64  (30085,1,0,0,0,0,0,0x0000000000000400,0),
  65  (30085,2,0,0,0,0,0,0x0000000000000002,0),
  66  (30086,0,0,0,0,0,0,0x0000071B804CC41A,0),
  67  (30086,1,0,0,0,0,0,0x0000000000000400,0),
  68  (30086,2,0,0,0,0,0,0x0000000000000002,0);
  69
  70 DELETE FROM `spell_affect` WHERE `entry` IN (18174,18175,18176,18177,18178);
  71 INSERT INTO `spell_affect` VALUES
  72  (18174,0,0,0,0,0,0,0x0000071B804CC41A,0),
  73  (18175,0,0,0,0,0,0,0x0000071B804CC41A,0),
  74  (18176,0,0,0,0,0,0,0x0000071B804CC41A,0),
  75  (18177,0,0,0,0,0,0,0x0000071B804CC41A,0),
  76  (18178,0,0,0,0,0,0,0x0000071B804CC41A,0);
  77
  78 DELETE FROM `spell_affect` WHERE `entry` IN (30143,30144,30145);
  79 INSERT INTO `spell_affect` VALUES
  80  (30143,0,0,0,0,0,0,0x0000002000000000,0),
  81  (30144,0,0,0,0,0,0,0x0000002000000000,0),
  82  (30145,0,0,0,0,0,0,0x0000002000000000,0);
  83
  84 DELETE FROM `spell_affect` WHERE `entry` IN (30319,30320,30321);
  85 INSERT INTO `spell_affect` VALUES
  86  (30319,1,0,0,0,0,0,0x0000400000000000,0),
  87  (30320,1,0,0,0,0,0,0x0000400000000000,0),
  88  (30321,1,0,0,0,0,0,0x0000400000000000,0);
  89
  90 DELETE FROM `spell_affect` WHERE `entry` IN (33063);
  91 INSERT INTO `spell_affect` VALUES
  92  (33063,0,0,0,0,0,0,0x0000040000000000,0);
  93
  94 DELETE FROM `spell_affect` WHERE `entry` IN (30242,30245,30246,30247,30248);
  95 INSERT INTO `spell_affect` VALUES
  96  (30242,0,0,0,0,0,0,0x0000200000000000,0),
  97  (30245,0,0,0,0,0,0,0x0000200000000000,0),
  98  (30246,0,0,0,0,0,0,0x0000200000000000,0),
  99  (30247,0,0,0,0,0,0,0x0000200000000000,0),
 100  (30248,0,0,0,0,0,0,0x0000200000000000,0);
 101
 102 DELETE FROM `spell_affect` WHERE `entry` IN (32477,32483,32484);
 103 INSERT INTO `spell_affect` VALUES
 104  (32477,0,0,0,0,0,0,0x0000020000000000,0),
 105  (32483,0,0,0,0,0,0,0x0000020000000000,0),
 106  (32484,0,0,0,0,0,0,0x0000020000000000,0);
 107
 108 DELETE FROM `spell_affect` WHERE `entry` IN (30251,30256);
 109 INSERT INTO `spell_affect` VALUES
 110  (30251,0,0,0,0,0,0,0x000010C000000125,0),
 111  (30256,0,0,0,0,0,0,0x000010C000000125,0);
 112
 113 DELETE FROM `spell_affect` WHERE `entry` IN (17954,17955,17956,17957,17958);
 114 INSERT INTO `spell_affect` VALUES
 115  (17954,0,0,0,0,0,0,0x000000C000001364,0),
 116  (17954,1,0,0,0,0,0,0x000000C000001364,0),
 117  (17955,0,0,0,0,0,0,0x000000C000001364,0),
 118  (17955,1,0,0,0,0,0,0x000000C000001364,0),
 119  (17956,0,0,0,0,0,0,0x000000C000001364,0),
 120  (17956,1,0,0,0,0,0,0x000000C000001364,0),
 121  (17957,0,0,0,0,0,0,0x000000C000001364,0),
 122  (17957,1,0,0,0,0,0,0x000000C000001364,0),
 123  (17958,0,0,0,0,0,0,0x000000C000001364,0),
 124  (17958,1,0,0,0,0,0,0x000000C000001364,0);
 125
 126 DELETE FROM `spell_affect` WHERE `entry` IN (18213,18372);
 127 INSERT INTO `spell_affect` VALUES
 128  (18213,0,0,0,0,0,0,0x0000000000004000,0),
 129  (18213,1,0,0,0,0,0,0x0000871B804CC41A,0),
 130  (18372,0,0,0,0,0,0,0x0000000000004000,0),
 131  (18372,1,0,0,0,0,0,0x0000871B804CC41A,0);
 132
 133 DELETE FROM `spell_affect` WHERE `entry` IN (18271,18272,18273,18274,18275);
 134 INSERT INTO `spell_affect` VALUES
 135  (18271,0,0,0,0,0,0,0x000011130008A48B,0),
 136  (18271,1,0,0,0,0,0,0x000011130008A48B,0),
 137  (18272,0,0,0,0,0,0,0x000011130008A48B,0),
 138  (18272,1,0,0,0,0,0,0x000011130008A48B,0),
 139  (18273,0,0,0,0,0,0,0x000011130008A48B,0),
 140  (18273,1,0,0,0,0,0,0x000011130008A48B,0),
 141  (18274,0,0,0,0,0,0,0x000011130008A48B,0),
 142  (18274,1,0,0,0,0,0,0x000011130008A48B,0),
 143  (18275,0,0,0,0,0,0,0x000011130008A48B,0),
 144  (18275,1,0,0,0,0,0,0x000011130008A48B,0);