sql/updates/0.8/4603_spell_affect.sql

   1 DELETE FROM `spell_affect` WHERE `entry` IN (34453,34454);
   2 INSERT INTO `spell_affect` VALUES
   3 (34453,1,0,0,0,0,0,0x0000000400000000,0),
   4 (34454,1,0,0,0,0,0,0x0000000400000000,0);
   5
   6 DELETE FROM `spell_affect` WHERE `entry` IN (24348);
   7 INSERT INTO `spell_affect` VALUES
   8 (24348,0,0,0,0,0,0,0x0000000000200000,0);
   9
  10 DELETE FROM `spell_affect` WHERE `entry` IN (34462,34464,34465);
  11 INSERT INTO `spell_affect` VALUES
  12 (34462,1,0,0,0,0,0,0x0000000800000000,0),
  13 (34464,1,0,0,0,0,0,0x0000000800000000,0),
  14 (34465,1,0,0,0,0,0,0x0000000800000000,0);
  15
  16 DELETE FROM `spell_affect` WHERE `entry` IN (19239,19245);
  17 INSERT INTO `spell_affect` VALUES
  18 (19239,0,0,0,0,0,0,0x0000000000000018,0),
  19 (19239,1,0,0,0,0,0,0x0000000000000004,0),
  20 (19245,0,0,0,0,0,0,0x0000000000000018,0),
  21 (19245,1,0,0,0,0,0,0x0000000000000004,0);
  22
  23 DELETE FROM `spell_affect` WHERE `entry` IN (19416,19417,19418,19419,19420);
  24 INSERT INTO `spell_affect` VALUES
  25 (19416,0,0,0,0,0,0,0x000010810007DA00,0),
  26 (19417,0,0,0,0,0,0,0x000010810007DA00,0),
  27 (19418,0,0,0,0,0,0,0x000010810007DA00,0),
  28 (19419,0,0,0,0,0,0,0x000010810007DA00,0),
  29 (19420,0,0,0,0,0,0,0x000010810007DA00,0);
  30
  31 DELETE FROM `spell_affect` WHERE `entry` IN (34455,34459,34460);
  32 INSERT INTO `spell_affect` VALUES
  33 (34455,0,0,0,0,0,0,0x0000002000000000,0),
  34 (34455,1,0,0,0,0,0,0x0000004000000000,0),
  35 (34459,0,0,0,0,0,0,0x0000002000000000,0),
  36 (34459,1,0,0,0,0,0,0x0000004000000000,0),
  37 (34460,0,0,0,0,0,0,0x0000002000000000,0),
  38 (34460,1,0,0,0,0,0,0x0000004000000000,0);
  39
  40 DELETE FROM `spell_affect` WHERE `entry` IN (35029,35030);
  41 INSERT INTO `spell_affect` VALUES
  42 (35029,1,0,0,0,0,0,0x0000080000000000,0),
  43 (35030,1,0,0,0,0,0,0x0000080000000000,0);
  44
  45 DELETE FROM `spell_affect` WHERE `entry` IN (19572,19573);
  46 INSERT INTO `spell_affect` VALUES
  47 (19572,1,0,0,0,0,0,0x0000000000800000,0),
  48 (19573,1,0,0,0,0,0,0x0000000000800000,0);
  49
  50 DELETE FROM `spell_affect` WHERE `entry` IN (19464,19465,19466,19467,19468);
  51 INSERT INTO `spell_affect` VALUES
  52 (19464,0,0,0,0,0,0,0x0000010000004000,0),
  53 (19464,1,0,0,0,0,0,0x0000008000000000,0),
  54 (19464,2,0,0,0,0,0,0x000011800000C000,0),
  55 (19465,0,0,0,0,0,0,0x0000010000004000,0),
  56 (19465,1,0,0,0,0,0,0x0000008000000000,0),
  57 (19465,2,0,0,0,0,0,0x000011800000C000,0),
  58 (19466,0,0,0,0,0,0,0x0000010000004000,0),
  59 (19466,1,0,0,0,0,0,0x0000008000000000,0),
  60 (19466,2,0,0,0,0,0,0x000011800000C000,0),
  61 (19467,0,0,0,0,0,0,0x0000010000004000,0),
  62 (19467,1,0,0,0,0,0,0x0000008000000000,0),
  63 (19467,2,0,0,0,0,0,0x000011800000C000,0),
  64 (19468,0,0,0,0,0,0,0x0000010000004000,0),
  65 (19468,1,0,0,0,0,0,0x0000008000000000,0),
  66 (19468,2,0,0,0,0,0,0x000011800000C000,0);
  67
  68 DELETE FROM `spell_affect` WHERE `entry` IN (19485,19487,19488,19489,19490);
  69 INSERT INTO `spell_affect` VALUES
  70 (19485,0,0,0,0,0,0,0x0000000000000001,0),
  71 (19487,0,0,0,0,0,0,0x0000000000000001,0),
  72 (19488,0,0,0,0,0,0,0x0000000000000001,0),
  73 (19489,0,0,0,0,0,0,0x0000000000000001,0),
  74 (19490,0,0,0,0,0,0,0x0000000000000001,0);
  75
  76 DELETE FROM `spell_affect` WHERE `entry` IN (32203,41660);
  77 INSERT INTO `spell_affect` VALUES
  78 (32203,1,0,0,0,0,0,0x0001100001C22000,0),
  79 (41660,1,0,0,0,0,0,0x0001100001C22000,0);
  80
  81 DELETE FROM `spell_affect` WHERE `entry` IN (37508);
  82 INSERT INTO `spell_affect` VALUES
  83 (37508,0,0,0,0,0,0,0x0000000100061800,0);