sql/updates/0.10/5466_mangos_spell_affect.sql

   1 DELETE FROM `spell_affect` WHERE `entry` IN (12295,12676,12677);
   2 INSERT INTO `spell_affect` VALUES
   3  (12295,1,0,0,0,0,0,0x0000000002000000,0),
   4  (12295,2,0,0,0,0,0,0x0000040000000000,0),
   5  (12676,1,0,0,0,0,0,0x0000000002000000,0),
   6  (12676,2,0,0,0,0,0,0x0000040000000000,0),
   7  (12677,1,0,0,0,0,0,0x0000000002000000,0),
   8  (12677,2,0,0,0,0,0,0x0000040000000000,0);
   9
  10 DELETE FROM `spell_affect` WHERE `entry` IN (12308,12810,12811);
  11 INSERT INTO `spell_affect` VALUES
  12  (12308,0,0,0,0,0,0,0x0000000000004000,0),
  13  (12810,0,0,0,0,0,0,0x0000000000004000,0),
  14  (12811,0,0,0,0,0,0,0x0000000000004000,0);
  15
  16 DELETE FROM `spell_affect` WHERE `entry` IN (13981,14066);
  17 INSERT INTO `spell_affect` VALUES
  18  (13981,0,0,0,0,0,0,0x0000000001000000,0),
  19  (13981,1,0,0,0,0,0,0x0000000000000800,0),
  20  (14066,0,0,0,0,0,0,0x0000000001000000,0),
  21  (14066,1,0,0,0,0,0,0x0000000000000800,0);
  22
  23 DELETE FROM `spell_affect` WHERE `entry` IN (14523,14784,14785,14786,14787);
  24 INSERT INTO `spell_affect` VALUES
  25  (14523,1,0,0,0,0,0,0x000000208030016B,0),
  26  (14523,2,0,0,0,0,0,0x000000208030016B,0),
  27  (14784,1,0,0,0,0,0,0x000000208030016B,0),
  28  (14784,2,0,0,0,0,0,0x000000208030016B,0),
  29  (14785,1,0,0,0,0,0,0x000000208030016B,0),
  30  (14785,2,0,0,0,0,0,0x000000208030016B,0),
  31  (14786,1,0,0,0,0,0,0x000000208030016B,0),
  32  (14786,2,0,0,0,0,0,0x000000208030016B,0),
  33  (14787,1,0,0,0,0,0,0x000000208030016B,0),
  34  (14787,2,0,0,0,0,0,0x000000208030016B,0);
  35
  36 DELETE FROM `spell_affect` WHERE `entry` IN (29759,29760,29761,29762,29763);
  37 INSERT INTO `spell_affect` VALUES
  38  (29759,1,0,0,0,0,0,0x0000075D6E6ECEEF,0),
  39  (29760,1,0,0,0,0,0,0x0000075D6E6ECEEF,0),
  40  (29761,1,0,0,0,0,0,0x0000075D6E6ECEEF,0),
  41  (29762,1,0,0,0,0,0,0x0000075D6E6ECEEF,0),
  42  (29763,1,0,0,0,0,0,0x0000075D6E6ECEEF,0);
  43
  44 DELETE FROM `spell_affect` WHERE `entry` IN (34466,34467,34468,34469,34470);
  45 INSERT INTO `spell_affect` VALUES
  46  (34466,1,0,0,0,0,0,0x0000001000000000,0),
  47  (34467,1,0,0,0,0,0,0x0000001000000000,0),
  48  (34468,1,0,0,0,0,0,0x0000001000000000,0),
  49  (34469,1,0,0,0,0,0,0x0000001000000000,0),
  50  (34470,1,0,0,0,0,0,0x0000001000000000,0);
  51
  52 DELETE FROM `spell_affect` WHERE `entry` IN (34318,37209);
  53 INSERT INTO `spell_affect` VALUES
  54  (34318,0,0,0,0,0,0,0x0000000000000400,0),
  55  (34318,1,0,0,0,0,0,0x0000002000000000,0),
  56  (37209,0,0,0,0,0,0,0x0000000000000400,0),
  57  (37209,1,0,0,0,0,0,0x0000002000000000,0);
  58
  59 DELETE FROM `spell_affect` WHERE `entry` IN (44301,44302);
  60 INSERT INTO `spell_affect` VALUES
  61  (44301,0,0,0,0,0,0,0x0000000001000000,0),
  62  (44302,0,0,0,0,0,0,0x0000000001000000,0);
  63
  64 DELETE FROM `spell_affect` WHERE `entry` IN (37424);
  65 INSERT INTO `spell_affect` VALUES
  66  (37424,0,0,0,0,0,0,0x0000000000008000,0);
  67