sql/updates/0.10/5130_mangos_spell_proc_event.sql

   1 DELETE FROM `spell_proc_event` WHERE `entry` IN (21063,27539,28764,33493,38196);
   2 INSERT INTO `spell_proc_event` VALUES
   3  (21063,0,0,0,0,0x0000000000000000,0x00008000,0),
   4  (27539,0,0,0,0,0x0000000000000000,0x00100000,0),
   5  (28764,0,0,0,0,0x0000000000000000,0x00100000,0),
   6  (33493,0,0,0,0,0x0000000000000000,0x00000002,0),
   7  (38196,0,0,0,0,0x0000000000000000,0x00000001,0);
   8
   9 DELETE FROM `spell_proc_event` WHERE `entry` IN (29441,29444,29445,29446,29447);
  10 INSERT INTO `spell_proc_event` VALUES
  11  (29441,0,0,0,0,0x0000000000000000,0x01000000,0),
  12  (29444,0,0,0,0,0x0000000000000000,0x01000000,0),
  13  (29445,0,0,0,0,0x0000000000000000,0x01000000,0),
  14  (29446,0,0,0,0,0x0000000000000000,0x01000000,0),
  15  (29447,0,0,0,0,0x0000000000000000,0x01000000,0);
  16
  17
  18 DELETE FROM `spell_proc_event` WHERE `entry` IN (27243);
  19 INSERT INTO `spell_proc_event` VALUES
  20  (27243,0,0,0,0,0x0000000000000000,0x00008000,0);
  21
  22 DELETE FROM `spell_proc_event` WHERE `entry` IN (40438);
  23 INSERT INTO `spell_proc_event` VALUES
  24  (40438,0,0,0,6,0x0000000000008010,0x08020000,0);
  25
  26 DELETE FROM `spell_proc_event` WHERE `entry` IN (26169);
  27 INSERT INTO `spell_proc_event` VALUES
  28  (26169,0,0,0,0,0x0000000000000000,0x08000000,0);
  29
  30 DELETE FROM `spell_proc_event` WHERE `entry` IN (40442);
  31 INSERT INTO `spell_proc_event` VALUES
  32  (40442,0,0,0,7,0x0000044000000014,0x00004000,0);
  33
  34 DELETE FROM `spell_proc_event` WHERE `entry` IN (28719);
  35 INSERT INTO `spell_proc_event` VALUES
  36  (28719,0,0,0,7,0x0000000000000020,0x10000000,0);
  37
  38 DELETE FROM `spell_proc_event` WHERE `entry` IN (28847);
  39 INSERT INTO `spell_proc_event` VALUES
  40  (28847,0,0,0,7,0x0000000000000020,0x00004000,0);
  41
  42 DELETE FROM `spell_proc_event` WHERE `entry` IN (37288,37295);
  43 INSERT INTO `spell_proc_event` VALUES
  44  (37288,0,0,0,0,0x0000000000000000,0x08000000,0),
  45  (37295,0,0,0,0,0x0000000000000000,0x00020000,0);
  46
  47 DELETE FROM `spell_proc_event` WHERE `entry` IN (31892);
  48 INSERT INTO `spell_proc_event` VALUES
  49  (31892,0,0,0,0,0x0000000000000000,0x00000001,0);
  50
  51 DELETE FROM `spell_proc_event` WHERE `entry` IN (40470);
  52 INSERT INTO `spell_proc_event` VALUES
  53  (40470,0,0,0,10,0x0000000000806000,0x00004000,0);