diff options
| -rw-r--r-- | sql/updates/3.3.3a_old/7893_characters_item_instance.sql (renamed from sql/updates/3.3.3a_old/7893_characters_characters.sql) | 0 | ||||
| -rw-r--r-- | sql/updates/7980_world_spell_area.sql | 4 | ||||
| -rw-r--r-- | sql/updates/7982_world_spell_proc_event.sql | 4 | ||||
| -rw-r--r-- | sql/world.sql | 5 |
4 files changed, 8 insertions, 5 deletions
diff --git a/sql/updates/3.3.3a_old/7893_characters_characters.sql b/sql/updates/3.3.3a_old/7893_characters_item_instance.sql index 3dea7f98e27..3dea7f98e27 100644 --- a/sql/updates/3.3.3a_old/7893_characters_characters.sql +++ b/sql/updates/3.3.3a_old/7893_characters_item_instance.sql diff --git a/sql/updates/7980_world_spell_area.sql b/sql/updates/7980_world_spell_area.sql deleted file mode 100644 index cabf39f6d62..00000000000 --- a/sql/updates/7980_world_spell_area.sql +++ /dev/null @@ -1,4 +0,0 @@ -INSERT IGNORE INTO spell_area (spell, area, quest_start, quest_start_active, quest_end, aura_spell, racemask, gender, autocast) VALUES -(74411, 3358, 0, 0, 0, 0, 0, 2, 1),(74411, 2597, 0, 0, 0, 0, 0, 2, 1),(74411, 4384, 0, 0, 0, 0, 0, 2, 1),(74411, 3277, 0, 0, 0, 0, 0, 2, 1), -(74411, 3820, 0, 0, 0, 0, 0, 2, 1),(74411, 4710, 0, 0, 0, 0, 0, 2, 1),(74411, 4197, 0, 0, 0, 0, 0, 2, 1),(74410, 4378, 0, 0, 0, 0, 0, 2, 1), -(74410, 4406, 0, 0, 0, 0, 0, 2, 1),(74410, 3968, 0, 0, 0, 0, 0, 2, 1),(74410, 3702, 0, 0, 0, 0, 0, 2, 1),(74410, 3698, 0, 0, 0, 0, 0, 2, 1); diff --git a/sql/updates/7982_world_spell_proc_event.sql b/sql/updates/7982_world_spell_proc_event.sql new file mode 100644 index 00000000000..0f21c884c75 --- /dev/null +++ b/sql/updates/7982_world_spell_proc_event.sql @@ -0,0 +1,4 @@ +-- Make Divine Guardian proc on Divine Sacrifice only +DELETE FROM `spell_proc_event` WHERE `entry`=53530; +INSERT INTO `spell_proc_event` (`entry`,`SchoolMask`,`SpellFamilyName`,`SpellFamilyMask0`,`SpellFamilyMask1`,`SpellFamilyMask2`,`procFlags`,`procEx`,`ppmRate`,`CustomChance`,`Cooldown`) VALUES +(53530,1,10,0x0000,0x0000,0x0004,0x0400,0x0001,0,100,0); diff --git a/sql/world.sql b/sql/world.sql index 1129e9596e4..6fdf7173557 100644 --- a/sql/world.sql +++ b/sql/world.sql @@ -6478,6 +6478,7 @@ INSERT INTO `spell_proc_event` (`entry`,`SchoolMask`,`SpellFamilyName`,`SpellFam ( 31836, 0x00, 10, 0x80000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Light's Grace (Rank 3) ( 31871, 0x00, 10, 0x00000010, 0x00000000, 0x00000000, 0x00004000, 0x00000000, 0, 0, 0), -- Divine Purpose (Rank 1) ( 31872, 0x00, 10, 0x00000010, 0x00000000, 0x00000000, 0x00004000, 0x00000000, 0, 0, 0), -- Divine Purpose (Rank 2) +( 53530, 1, 10, 0x00000000, 0x00000000, 0x0004, 0x0400, 0x0001, 0, 100, 0), -- Divine Guardian ( 31876, 0x00, 10, 0x00800000, 0x00000000, 0x00000000, 0x00000000, 0x00040000, 0, 0, 0), -- Judgements of the Wise (Rank 1) ( 31877, 0x00, 10, 0x00800000, 0x00000000, 0x00000000, 0x00000000, 0x00040000, 0, 0, 0), -- Judgements of the Wise (Rank 2) ( 31878, 0x00, 10, 0x00800000, 0x00000000, 0x00000000, 0x00000000, 0x00040000, 0, 0, 0), -- Judgements of the Wise (Rank 3) @@ -7135,7 +7136,9 @@ INSERT INTO `spell_proc_event` (`entry`,`SchoolMask`,`SpellFamilyName`,`SpellFam ( 58375, 0x00, 4, 0x00000000, 0x00000200, 0x00000000, 0x00000010, 0x00000000, 0, 0, 0), -- Glyph of Blocking ( 58387, 0x00, 4, 0x00004000, 0x00000040, 0x00000000, 0x00000010, 0x00000000, 0, 0, 0), -- Glyph of Sunder Armor ( 54925, 0x02, 10, 0x00000000, 0x00000208, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Glyph of Seal of Command -( 67356, 0x08, 7, 0x00000010, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0); -- Item - Druid T9 Restoration Relic (Rejuvenation) +( 67356, 0x08, 7, 0x00000010, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Item - Druid T9 Restoration Relic (Rejuvenation) +( 67771, 1, 0, 0x00000000, 0x00000000, 0x00000000, 0x0851154, 0x03, 0, 35, 45), -- Item - Coliseum Melee Trinket 10men +( 67702, 1, 0, 0x00000000, 0x00000000, 0x00000000, 0x0851154, 0x03, 0, 35, 45); -- Item - Coliseum Melee Trinket 25men /*!40000 ALTER TABLE `spell_proc_event` ENABLE KEYS */; UNLOCK TABLES; |