sql/updates/0.8/4248_spell_proc_event.sql

   1 /* fix scholl mask */
   2 DELETE FROM `spell_proc_event` WHERE `entry` IN (11103,11119,11120,11129,11180,11255,12357,12358,12359,12360,12598,12846,12847,12848,14892,15268,15286,15323,15324,15325,15326,15362,15363,16164,17793,17796,17801,17802,17803,18073,18096,19407,19412,19413,19414,19415,20234,20235,23551,23572,23721,28592,28593,28594,28595,28719,28809,28823,28847,28849,29074,29075,29076,34914,34916,34917);
   3 INSERT INTO `spell_proc_event` (entry, SchoolMask, Category, SkillID, SpellFamilyName, SpellFamilyMask, procFlags, ppmRate) VALUES
   4 (11103,4,0,0,0,0,131072,0),
   5 (11119,4,0,0,0,0,65536,0),
   6 (11120,4,0,0,0,0,65536,0),
   7 (11129,4,0,0,0,0,131072,0),
   8 (11180,16,0,0,0,0,131072,0),
   9 (11255,64,0,0,3,0,16384,0),
  10 (12357,4,0,0,0,0,131072,0),
  11 (12358,4,0,0,0,0,131072,0),
  12 (12359,4,0,0,0,0,131072,0),
  13 (12360,4,0,0,0,0,131072,0),
  14 (12598,64,0,0,3,0,16384,0),
  15 (12846,4,0,0,0,0,65536,0),
  16 (12847,4,0,0,0,0,65536,0),
  17 (12848,4,0,0,0,0,65536,0),
  18 (14892,2,0,56,0,7680,268435456,0),
  19 (15268,32,0,0,0,0,131072,0),
  20 (15286,32,0,0,0,0,32768,0),
  21 (15323,32,0,0,0,0,131072,0),
  22 (15324,32,0,0,0,0,131072,0),
  23 (15325,32,0,0,0,0,131072,0),
  24 (15326,32,0,0,0,0,131072,0),
  25 (15362,2,0,56,0,7680,268435456,0),
  26 (15363,2,0,56,0,7680,268435456,0),
  27 (16164,28,0,0,0,0,65536,0),
  28 (17793,32,0,593,0,1,65536,0),
  29 (17796,32,0,593,0,1,65536,0),
  30 (17801,32,0,593,0,1,65536,0),
  31 (17802,32,0,593,0,1,65536,0),
  32 (17803,32,0,593,0,1,65536,0),
  33 (18073,4,0,0,0,96,131072,0),
  34 (18096,4,0,0,0,96,131072,0),
  35 (19407,64,0,0,0,512,131072,0),
  36 (19412,64,0,0,0,512,131072,0),
  37 (19413,64,0,0,0,512,131072,0),
  38 (19414,64,0,0,0,512,131072,0),
  39 (19415,64,0,0,0,512,131072,0),
  40 (20234,2,0,0,0,32768,131072,0),
  41 (20235,2,0,0,0,32768,131072,0),
  42 (23551,8,0,0,0,192,16384,0),
  43 (23572,8,0,0,0,192,16384,0),
  44 (23721,64,0,163,0,2048,131072,0),
  45 (28592,16,0,0,0,0,131072,0),
  46 (28593,16,0,0,0,0,131072,0),
  47 (28594,16,0,0,0,0,131072,0),
  48 (28595,16,0,0,0,0,131072,0),
  49 (28719,8,0,0,0,32,268435456,0),
  50 (28809,2,0,56,0,4096,268435456,0),
  51 (28823,8,0,374,0,192,134217728,0),
  52 (28847,8,0,573,0,32,16384,0),
  53 (28849,8,0,374,0,128,16384,0),
  54 (29074,20,0,0,0,0,65536,0),
  55 (29075,20,0,0,0,0,65536,0),
  56 (29076,20,0,0,0,0,65536,0),
  57 (34914,32,0,0,0,0,32768,0),
  58 (34916,32,0,0,0,0,32768,0),
  59 (34917,32,0,0,0,0,32768,0);
  60
  61 DELETE FROM `spell_proc_event` WHERE `entry` IN (6866,18189);
  62 INSERT INTO `spell_proc_event` (entry, SchoolMask, Category, SkillID, SpellFamilyName, SpellFamilyMask, procFlags, ppmRate) VALUES
  63 (6866,0,0,0,0,0,114,0),
  64 (18189,0,0,0,0,0,131072,0);
  65
  66
  67 DELETE FROM `spell_proc_event` WHERE `entry` IN (37377,39437);
  68 INSERT INTO `spell_proc_event` (entry, SchoolMask, Category, SkillID, SpellFamilyName, SpellFamilyMask, procFlags, ppmRate) VALUES
  69 (37377,32,0,0,0,0,16384,0),
  70 (39437,4,0,0,0,0,16384,0);