sql/updates/0.10/5370_mangos_spell_affect.sql

   1 DELETE FROM spell_affect WHERE entry IN (14177);
   2 INSERT INTO spell_affect VALUES
   3  (14177,0,0,0,0,0,0,0x000000086012031E,0);
   4
   5 DELETE FROM spell_affect WHERE entry IN (14082,14083);
   6 INSERT INTO spell_affect VALUES
   7  (14082,0,0,0,0,0,0,0x0000000000000500,0),
   8  (14083,0,0,0,0,0,0,0x0000000000000500,0);
   9
  10 DELETE FROM spell_affect WHERE entry IN (14076,14094);
  11 INSERT INTO spell_affect VALUES
  12  (14076,0,0,0,0,0,0,0x0000000001000080,0),
  13  (14076,1,0,0,0,0,0,0x0000000001000080,0),
  14  (14094,0,0,0,0,0,0,0x0000000001000080,0),
  15  (14094,1,0,0,0,0,0,0x0000000001000080,0);
  16
  17 DELETE FROM spell_affect WHERE entry IN (37166);
  18 INSERT INTO spell_affect VALUES
  19  (37166,0,0,0,0,0,0,0x0000000000800000,0);
  20
  21 DELETE FROM spell_affect WHERE entry IN (31234,31235,31236,31237,31238);
  22 INSERT INTO spell_affect VALUES
  23  (31234,0,0,0,0,0,0,0x000001002612030F,0),
  24  (31234,1,0,0,0,0,0,0x0000000000100100,0),
  25  (31235,0,0,0,0,0,0,0x000001002612030F,0),
  26  (31235,1,0,0,0,0,0,0x0000000000100100,0),
  27  (31236,0,0,0,0,0,0,0x000001002612030F,0),
  28  (31236,1,0,0,0,0,0,0x0000000000100100,0),
  29  (31237,0,0,0,0,0,0,0x000001002612030F,0),
  30  (31237,1,0,0,0,0,0,0x0000000000100100,0),
  31  (31238,0,0,0,0,0,0,0x000001002612030F,0),
  32  (31238,1,0,0,0,0,0,0x0000000000100100,0);
  33
  34 DELETE FROM spell_affect WHERE entry IN (14128,14132,14135,14136,14137);
  35 INSERT INTO spell_affect VALUES
  36  (14128,0,0,0,0,0,0,0x000000062600000E,0),
  37  (14132,0,0,0,0,0,0,0x000000062600000E,0),
  38  (14135,0,0,0,0,0,0,0x000000062600000E,0),
  39  (14136,0,0,0,0,0,0,0x000000062600000E,0),
  40  (14137,0,0,0,0,0,0,0x000000062600000E,0);
  41
  42 DELETE FROM spell_affect WHERE entry IN (14057,14072,14073,14074,14075);
  43 INSERT INTO spell_affect VALUES
  44  (14057,0,0,0,0,0,0,0x0000000600000304,0),
  45  (14057,1,0,0,0,0,0,0x0000000000000100,0),
  46  (14072,0,0,0,0,0,0,0x0000000600000304,0),
  47  (14072,1,0,0,0,0,0,0x0000000000000100,0),
  48  (14073,0,0,0,0,0,0,0x0000000600000304,0),
  49  (14073,1,0,0,0,0,0,0x0000000000000100,0),
  50  (14074,0,0,0,0,0,0,0x0000000600000304,0),
  51  (14074,1,0,0,0,0,0,0x0000000000000100,0),
  52  (14075,0,0,0,0,0,0,0x0000000600000304,0),
  53  (14075,1,0,0,0,0,0,0x0000000000000100,0);
  54
  55 DELETE FROM spell_affect WHERE entry IN (14143,14149,14151);
  56 INSERT INTO spell_affect VALUES
  57  (14143,0,0,0,0,0,0,0x0000000606000206,0),
  58  (14149,0,0,0,0,0,0,0x0000000606000206,0),
  59  (14151,0,0,0,0,0,0,0x0000000606000206,0);
  60
  61 DELETE FROM spell_affect WHERE entry IN (28815);
  62 INSERT INTO spell_affect VALUES
  63  (28815,0,0,0,0,0,0,0x0000000002000006,0);
  64
  65 DELETE FROM spell_affect WHERE entry IN (36563);
  66 INSERT INTO spell_affect VALUES
  67  (36563,1,0,0,0,0,0,0x0000000000000204,0),
  68  (36563,2,0,0,0,0,0,0x0000000000000100,0);
  69
  70 DELETE FROM spell_affect WHERE entry IN (16513,16514,16515,16719,16720);
  71 INSERT INTO spell_affect VALUES
  72  (16513,0,0,0,0,0,0,0x000000080001E000,0),
  73  (16513,1,0,0,0,0,0,0x000000000001E000,0),
  74  (16513,2,0,0,0,0,0,0x000000000001E000,0),
  75  (16514,0,0,0,0,0,0,0x000000080001E000,0),
  76  (16514,1,0,0,0,0,0,0x000000000001E000,0),
  77  (16514,2,0,0,0,0,0,0x000000000001E000,0),
  78  (16515,0,0,0,0,0,0,0x000000080001E000,0),
  79  (16515,1,0,0,0,0,0,0x000000000001E000,0),
  80  (16515,2,0,0,0,0,0,0x000000000001E000,0),
  81  (16719,0,0,0,0,0,0,0x000000080001E000,0),
  82  (16719,1,0,0,0,0,0,0x000000000001E000,0),
  83  (16719,2,0,0,0,0,0,0x000000000001E000,0),
  84  (16720,0,0,0,0,0,0,0x000000080001E000,0),
  85  (16720,1,0,0,0,0,0,0x000000000001E000,0),
  86  (16720,2,0,0,0,0,0,0x000000000001E000,0);
  87