sql/updates/0.10/4948_mangos_spell_affect.sql

   1 DELETE FROM `spell_affect` WHERE `entry` IN (11095,12872,12873);
   2 INSERT INTO `spell_affect` VALUES
   3  (11095,0,0,0,0,0,0,0x0000000000000010,0),
   4  (12872,0,0,0,0,0,0,0x0000000000000010,0),
   5  (12873,0,0,0,0,0,0,0x0000000000000010,0);
   6
   7 DELETE FROM `spell_affect` WHERE `entry` IN (31821);
   8 INSERT INTO `spell_affect` VALUES
   9  (31821,0,0,0,0,0,0,0x0000000004020048,0);
  10
  11 DELETE FROM `spell_affect` WHERE `entry` IN (23565);
  12 INSERT INTO `spell_affect` VALUES
  13  (23565,0,0,0,0,0,0,0x0000000004020048,0);
  14
  15 DELETE FROM `spell_affect` WHERE `entry` IN (26130);
  16 INSERT INTO `spell_affect` VALUES
  17  (26130,0,0,0,0,0,0,0x0000000820180000,0);
  18
  19 DELETE FROM `spell_affect` WHERE `entry` IN (20101,20102,20103,20104,20105);
  20 INSERT INTO `spell_affect` VALUES
  21  (20101,0,0,0,0,0,0,0x000004000A000200,0),
  22  (20102,0,0,0,0,0,0,0x000004000A000200,0),
  23  (20103,0,0,0,0,0,0,0x000004000A000200,0),
  24  (20104,0,0,0,0,0,0,0x000004000A000200,0),
  25  (20105,0,0,0,0,0,0,0x000004000A000200,0);
  26
  27 DELETE FROM `spell_affect` WHERE `entry` IN (27848);
  28 INSERT INTO `spell_affect` VALUES
  29  (27848,0,0,0,0,0,0,0x000004000A000200,0);
  30
  31 DELETE FROM `spell_affect` WHERE `entry` IN (33695);
  32 INSERT INTO `spell_affect` VALUES
  33  (33695,0,0,0,0,0,0,0x0000000200000000,0);
  34
  35 DELETE FROM `spell_affect` WHERE `entry` IN (31879,31880,31881,31882,31883);
  36 INSERT INTO `spell_affect` VALUES
  37  (31879,0,0,0,0,0,0,0x0000000800000400,0),
  38  (31880,0,0,0,0,0,0,0x0000000800000400,0),
  39  (31881,0,0,0,0,0,0,0x0000000800000400,0),
  40  (31882,0,0,0,0,0,0,0x0000000800000400,0),
  41  (31883,0,0,0,0,0,0,0x0000000800000400,0);
  42
  43 DELETE FROM `spell_affect` WHERE `entry` IN (38426);
  44 INSERT INTO `spell_affect` VALUES
  45  (38426,0,0,0,0,0,0,0x0000000080000000,0);
  46
  47 DELETE FROM `spell_affect` WHERE `entry` IN (37189);
  48
  49 DELETE FROM `spell_affect` WHERE `entry` IN (37739);
  50 INSERT INTO `spell_affect` VALUES
  51  (37739,0,0,0,0,0,0,0x0000000080000000,0);
  52
  53 DELETE FROM `spell_affect` WHERE `entry` IN (20359,20360,20361);
  54 INSERT INTO `spell_affect` VALUES
  55  (20359,0,0,0,0,0,0,0x0000000080000000,0),
  56  (20360,0,0,0,0,0,0,0x0000000080000000,0),
  57  (20361,0,0,0,0,0,0,0x0000000080000000,0);
  58
  59 DELETE FROM `spell_affect` WHERE `entry` IN (20237,20238,20239);
  60 INSERT INTO `spell_affect` VALUES
  61  (20237,0,0,0,0,0,0,0x00000000C0000000,0),
  62  (20238,0,0,0,0,0,0,0x00000000C0000000,0),
  63  (20239,0,0,0,0,0,0,0x00000000C0000000,0);
  64
  65 DELETE FROM `spell_affect` WHERE `entry` IN (37723);
  66 INSERT INTO `spell_affect` VALUES
  67  (37723,0,0,0,0,0,0,0x00000000C0000000,0);
  68
  69 DELETE FROM `spell_affect` WHERE `entry` IN (38425,20249,20250,20251);
  70 INSERT INTO `spell_affect` VALUES
  71  (38425,0,0,0,0,0,0,0x0000000040000000,0),
  72  (20249,0,0,0,0,0,0,0x0000000040000000,0),
  73  (20250,0,0,0,0,0,0,0x0000000040000000,0),
  74  (20251,0,0,0,0,0,0,0x0000000040000000,0);
  75
  76 DELETE FROM `spell_affect` WHERE `entry` IN (38522);
  77 INSERT INTO `spell_affect` VALUES
  78  (38522,0,0,0,0,0,0,0x0000000040000000,0);
  79
  80 DELETE FROM `spell_affect` WHERE `entry` IN (34129);
  81 INSERT INTO `spell_affect` VALUES
  82  (34129,0,0,0,0,0,0,0x0000000040000000,0),
  83  (34129,1,0,0,0,0,0,0x0000000040000000,0);
  84
  85 DELETE FROM `spell_affect` WHERE `entry` IN (24460);
  86 INSERT INTO `spell_affect` VALUES
  87  (24460,0,0,0,0,0,0,0x0000000010000180,0);
  88
  89 DELETE FROM `spell_affect` WHERE `entry` IN (21744);
  90 INSERT INTO `spell_affect` VALUES
  91  (21744,0,0,0,0,0,0,0x0000000010000180,0);
  92
  93 DELETE FROM `spell_affect` WHERE `entry` IN (20254,20255,20256);
  94 INSERT INTO `spell_affect` VALUES
  95  (20254,0,0,0,0,0,0,0x0000000000020000,0),
  96  (20254,1,0,0,0,0,0,0x0000000000020000,0),
  97  (20254,2,0,0,0,0,0,0x0000000000020000,0),
  98  (20255,0,0,0,0,0,0,0x0000000000020000,0),
  99  (20255,1,0,0,0,0,0,0x0000000000020000,0),
 100  (20255,2,0,0,0,0,0,0x0000000000020000,0),
 101  (20256,0,0,0,0,0,0,0x0000000000020000,0),
 102  (20256,1,0,0,0,0,0,0x0000000000020000,0),
 103  (20256,2,0,0,0,0,0,0x0000000000020000,0);
 104
 105 DELETE FROM `spell_affect` WHERE `entry` IN (38424);
 106 INSERT INTO `spell_affect` VALUES
 107  (38424,0,0,0,0,0,0,0x0000008000000000,0);
 108
 109 DELETE FROM `spell_affect` WHERE `entry` IN (41021,41026);
 110 INSERT INTO `spell_affect` VALUES
 111  (41021,0,0,0,0,0,0,0x0000004000000000,0),
 112  (41021,1,0,0,0,0,0,0x0000004000000000,0),
 113  (41026,0,0,0,0,0,0,0x0000004000000000,0),
 114  (41026,1,0,0,0,0,0,0x0000004000000000,0);
 115
 116 DELETE FROM `spell_affect` WHERE `entry` IN (38421);
 117 INSERT INTO `spell_affect` VALUES
 118  (38421,0,0,0,0,0,0,0x0000100000000000,0);
 119
 120 DELETE FROM `spell_affect` WHERE `entry` IN (37187);
 121 INSERT INTO `spell_affect` VALUES
 122  (37187,0,0,0,0,0,0,0x0000020000000000,0);
 123
 124 DELETE FROM `spell_affect` WHERE `entry` IN (37182);
 125 INSERT INTO `spell_affect` VALUES
 126  (37182,0,0,0,0,0,0,0x0000000100000000,0);
 127
 128 DELETE FROM `spell_affect` WHERE `entry` IN (28775);
 129 INSERT INTO `spell_affect` VALUES
 130  (28775,0,0,0,0,0,0,0x0000000100000000,0);
 131
 132 DELETE FROM `spell_affect` WHERE `entry` IN (37184);
 133 INSERT INTO `spell_affect` VALUES
 134  (37184,0,0,0,0,0,0,0x0000040008000000,0),
 135  (37184,1,0,0,0,0,0,0x0000040008000000,0);
 136
 137 DELETE FROM `spell_affect` WHERE `entry` IN (31825,31826);
 138 INSERT INTO `spell_affect` VALUES
 139  (31825,0,0,0,0,0,0,0x0000000000001020,0),
 140  (31825,1,0,0,0,0,0,0x0000000200000000,0),
 141  (31826,0,0,0,0,0,0,0x0000000000001020,0),
 142  (31826,1,0,0,0,0,0,0x0000000200000000,0);
 143
 144 DELETE FROM `spell_affect` WHERE `entry` IN (31844,31845);
 145 INSERT INTO `spell_affect` VALUES
 146  (31844,1,0,0,0,0,0,0x000005401A00038C,0),
 147  (31845,1,0,0,0,0,0,0x000005401A00038C,0);