sql/updates/06528_mangos_spell_proc_event.sql

   1 ALTER TABLE spell_proc_event
   2   ADD COLUMN cooldown int(10) unsigned NOT NULL default '0';
   3
   4 DELETE FROM spell_proc_event WHERE entry IN (324,325,905,945,974,8134,10431,10432,16620,18137,
   5 19308,19309,19310,19311,19312,21185,23552,24398,24932,25469,25472,25477,29441,29444,29445,29446,
   6 29447,30881,30883,30884,30885,30886,32593,32594,32734,32837,33736,33746,33757,33759,34355,34935,
   7 34938,34939,34827,35077,35080,35083,35086,37173,37189,37197,37227,37655,38334,39027,39958,40899,
   8 41260,41262,42135,42136,43737,45054,45057,45354,45481,45482,45483,45484,46569);
   9
  10 INSERT INTO spell_proc_event (entry, SchoolMask, Category, SkillID, SpellFamilyName, SpellFamilyMask, procFlags, ppmRate, cooldown) VALUES
  11 (324,0,0,0,0,0x0000000000000000,0x00100402,0,3),
  12 (325,0,0,0,0,0x0000000000000000,0x00100402,0,3),
  13 (905,0,0,0,0,0x0000000000000000,0x00100402,0,3),
  14 (945,0,0,0,0,0x0000000000000000,0x00100402,0,3),
  15 (974,0,0,0,0,0x0000000000000000,0x00100402,0,3),
  16 (8134,0,0,0,0,0x0000000000000000,0x00100402,0,3),
  17 (10431,0,0,0,0,0x0000000000000000,0x00100402,0,3),
  18 (10432,0,0,0,0,0x0000000000000000,0x00100402,0,3),
  19 (16620,0,0,0,0,0x0000000000000000,0x00100402,0,30),
  20 (18137,0,0,0,0,0x0000000000000000,0x00100402,0,3),
  21 (19308,0,0,0,0,0x0000000000000000,0x00100402,0,3),
  22 (19309,0,0,0,0,0x0000000000000000,0x00100402,0,3),
  23 (19310,0,0,0,0,0x0000000000000000,0x00100402,0,3),
  24 (19311,0,0,0,0,0x0000000000000000,0x00100402,0,3),
  25 (19312,0,0,0,0,0x0000000000000000,0x00100402,0,3),
  26 (21185,0,0,0,0,0x0000000000000000,0x00000004,0,10),
  27 (23552,0,0,0,0,0x0000000000000000,0x00100402,0,3),
  28 (24398,0,0,0,0,0x0000000000000000,0x00100402,0,3),
  29 (24932,0,0,0,0,0x0000000000000000,0x00001000,0,6),
  30 (25469,0,0,0,0,0x0000000000000000,0x00100402,0,3),
  31 (25472,0,0,0,0,0x0000000000000000,0x00100402,0,3),
  32 (25477,0,0,0,0,0x0000000000000000,0x00100402,0,3),
  33 (29441,0,0,0,0,0x0000000000000000,0x01000000,0,1),
  34 (29444,0,0,0,0,0x0000000000000000,0x01000000,0,1),
  35 (29445,0,0,0,0,0x0000000000000000,0x01000000,0,1),
  36 (29446,0,0,0,0,0x0000000000000000,0x01000000,0,1),
  37 (29447,0,0,0,0,0x0000000000000000,0x01000000,0,1),
  38 (30881,0,0,0,0,0x0000000000000000,0x00008000,0,5),
  39 (30883,0,0,0,0,0x0000000000000000,0x00008000,0,5),
  40 (30884,0,0,0,0,0x0000000000000000,0x00008000,0,5),
  41 (30885,0,0,0,0,0x0000000000000000,0x00008000,0,5),
  42 (30886,0,0,0,0,0x0000000000000000,0x00008000,0,5),
  43 (32593,0,0,0,0,0x0000000000000000,0x00100402,0,3),
  44 (32594,0,0,0,0,0x0000000000000000,0x00100402,0,3),
  45 (32734,0,0,0,0,0x0000000000000000,0x00000002,0,3),
  46 (32837,0,0,0,0,0x0000000000000000,0x00004000,0,45),
  47 (33736,0,0,0,0,0x0000000000000000,0x00100402,0,3),
  48 (33746,0,0,0,0,0x0000000000000000,0x00000004,0,10),
  49 (33757,0,0,0,0,0x0000000000000000,0x00000001,0,3),
  50 (33759,0,0,0,0,0x0000000000000000,0x00000004,0,10),
  51 (34355,0,0,0,0,0x0000000000000000,0x00100402,0,3),
  52 (34935,0,0,0,0,0x0000000000000000,0x00000002,0,8),
  53 (34938,0,0,0,0,0x0000000000000000,0x00000002,0,8),
  54 (34939,0,0,0,0,0x0000000000000000,0x00000002,0,8),
  55 (34827,0,0,0,0,0x0000000000000000,0x00100402,0,3),
  56 (35077,0,0,0,0,0x0000000000000000,0x00008000,0,60),
  57 (35080,0,0,0,0,0x0000000000000000,0x00000001,0,60),
  58 (35083,0,0,0,0,0x0000000000000000,0x00020000,0,60),
  59 (35086,0,0,0,0,0x0000000000000000,0x08020000,0,60),
  60 (37173,0,0,0,8,0x000001062CBC0598,0x000A0001,0,30),
  61 (37189,0,0,0,10,0x0000000000006000,0x10000000,0,60),
  62 (37197,0,0,0,0,0x0000000000000000,0x00004000,0,45),
  63 (37227,0,0,0,11,0x00000000000001C0,0x10000000,0,60),
  64 (37655,0,0,0,0,0x0000000000000000,0x00004000,0,60),
  65 (38334,0,0,0,0,0x0000000000000000,0x00004000,0,60),
  66 (39027,0,0,0,0,0x0000000000000000,0x00100402,0,3),
  67 (39958,0,0,0,0,0x0000000000000000,0x00000001,0.7,40),
  68 (40899,0,0,0,0,0x0000000000000000,0x00000001,0,3),
  69 (41260,0,0,0,0,0x0000000000000000,0x00000004,0,10),
  70 (41262,0,0,0,0,0x0000000000000000,0x00000004,0,10),
  71 (42135,0,0,0,7,0x0000044000000000,0x00100402,0,90),
  72 (42136,0,0,0,7,0x0000044000000000,0x00100402,0,90),
  73 (43737,0,0,0,7,0x0000044000000000,0x00000001,0,10),
  74 (45054,0,0,0,0,0x0000000000000000,0x00020000,0,15),
  75 (45057,0,0,0,0,0x0000000000000000,0x00000002,0,30),
  76 (45354,0,0,0,0,0x0000000000000000,0x00000001,0,45),
  77 (45481,0,0,0,0,0x0000000000000000,0x08020000,0,45),
  78 (45482,0,0,0,0,0x0000000000000000,0x00080001,0,45),
  79 (45483,0,0,0,0,0x0000000000000000,0x00080001,0,45),
  80 (45484,0,0,0,0,0x0000000000000000,0x08000000,0,45),
  81 (46569,0,0,0,0,0x0000000000000000,0x00004000,0,45);
  82
  83 DELETE FROM spell_proc_event WHERE entry IN (43741);
  84 INSERT INTO spell_proc_event (entry, SchoolMask, Category, SkillID, SpellFamilyName, SpellFamilyMask, procFlags, ppmRate, cooldown) VALUES
  85 (43741,0,0,0,10,0x0000000080000000,0x00004000,0,0);