From 042971e7ffdfe8848b2aa837da6bc06d1e3e8776 Mon Sep 17 00:00:00 2001
From: John Holiver <none@none>
Date: Wed, 2 Jun 2010 20:27:18 -0300
Subject: * Fix Banner of Victory, Abyssal Rune, The Black Heart 45 ICD. *
 Fixes some name standards also.

--HG--
branch : trunk
rename : sql/updates/8371_spell_bonus_data.sql => sql/updates/8371_world_spell_bonus_data.sql
rename : sql/updates/8372_spell_proc_event.sql => sql/updates/8372_world_spell_proc_event.sql
rename : sql/updates/8373_spell_proc_event.sql => sql/updates/8373_world_spell_proc_event.sql
rename : sql/updates/8374_spell_proc_event.sql => sql/updates/8374_world_spell_proc_event.sql
---
 sql/updates/8371_spell_bonus_data.sql       | 6 ------
 sql/updates/8371_world_spell_bonus_data.sql | 6 ++++++
 sql/updates/8372_spell_proc_event.sql       | 3 ---
 sql/updates/8372_world_spell_proc_event.sql | 3 +++
 sql/updates/8373_spell_proc_event.sql       | 3 ---
 sql/updates/8373_world_spell_proc_event.sql | 3 +++
 sql/updates/8374_spell_proc_event.sql       | 4 ----
 sql/updates/8374_world_spell_proc_event.sql | 4 ++++
 sql/updates/8375_world_spell_proc_event.sql | 5 +++++
 9 files changed, 21 insertions(+), 16 deletions(-)
 delete mode 100644 sql/updates/8371_spell_bonus_data.sql
 create mode 100644 sql/updates/8371_world_spell_bonus_data.sql
 delete mode 100644 sql/updates/8372_spell_proc_event.sql
 create mode 100644 sql/updates/8372_world_spell_proc_event.sql
 delete mode 100644 sql/updates/8373_spell_proc_event.sql
 create mode 100644 sql/updates/8373_world_spell_proc_event.sql
 delete mode 100644 sql/updates/8374_spell_proc_event.sql
 create mode 100644 sql/updates/8374_world_spell_proc_event.sql
 create mode 100644 sql/updates/8375_world_spell_proc_event.sql

(limited to 'sql/updates')

diff --git a/sql/updates/8371_spell_bonus_data.sql b/sql/updates/8371_spell_bonus_data.sql
deleted file mode 100644
index 5b72884b34c..00000000000
--- a/sql/updates/8371_spell_bonus_data.sql
+++ /dev/null
@@ -1,6 +0,0 @@
-DELETE FROM `spell_bonus_data` WHERE `entry` IN (56131,56160,52725,55533);
-INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`, `ap_dot_bonus`, `comments`) VALUES
-(56131, 0, 0, 0, 0, 'Priest - Glyph of Dispel Magic'),
-(56160, 0, 0, 0, 0, 'Priest - Glyph of Power Word: Shield'),
-(52752, 0, 0, 0, 0, 'Ancestral Awakening'),
-(55533, 0, 0, 0, 0, 'Shaman - Glyph of Healing Wave');
diff --git a/sql/updates/8371_world_spell_bonus_data.sql b/sql/updates/8371_world_spell_bonus_data.sql
new file mode 100644
index 00000000000..5b72884b34c
--- /dev/null
+++ b/sql/updates/8371_world_spell_bonus_data.sql
@@ -0,0 +1,6 @@
+DELETE FROM `spell_bonus_data` WHERE `entry` IN (56131,56160,52725,55533);
+INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`, `ap_dot_bonus`, `comments`) VALUES
+(56131, 0, 0, 0, 0, 'Priest - Glyph of Dispel Magic'),
+(56160, 0, 0, 0, 0, 'Priest - Glyph of Power Word: Shield'),
+(52752, 0, 0, 0, 0, 'Ancestral Awakening'),
+(55533, 0, 0, 0, 0, 'Shaman - Glyph of Healing Wave');
diff --git a/sql/updates/8372_spell_proc_event.sql b/sql/updates/8372_spell_proc_event.sql
deleted file mode 100644
index 0f072328d27..00000000000
--- a/sql/updates/8372_spell_proc_event.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-DELETE FROM `spell_proc_event` WHERE `entry` IN (57870);
-INSERT INTO `spell_proc_event` (`entry`,`SchoolMask`,`SpellFamilyName`,`SpellFamilyMask0`,`SpellFamilyMask1`,`SpellFamilyMask2`,`procFlags`,`procEx`,`ppmRate`,`CustomChance`,`Cooldown`) VALUES
-( 57870, 0x00,   9, 0x00800000, 0x00000000, 0x00000000, 0x00040000, 0x00000000,   0,   0,   0); -- Glyph of Mend Pet
diff --git a/sql/updates/8372_world_spell_proc_event.sql b/sql/updates/8372_world_spell_proc_event.sql
new file mode 100644
index 00000000000..0f072328d27
--- /dev/null
+++ b/sql/updates/8372_world_spell_proc_event.sql
@@ -0,0 +1,3 @@
+DELETE FROM `spell_proc_event` WHERE `entry` IN (57870);
+INSERT INTO `spell_proc_event` (`entry`,`SchoolMask`,`SpellFamilyName`,`SpellFamilyMask0`,`SpellFamilyMask1`,`SpellFamilyMask2`,`procFlags`,`procEx`,`ppmRate`,`CustomChance`,`Cooldown`) VALUES
+( 57870, 0x00,   9, 0x00800000, 0x00000000, 0x00000000, 0x00040000, 0x00000000,   0,   0,   0); -- Glyph of Mend Pet
diff --git a/sql/updates/8373_spell_proc_event.sql b/sql/updates/8373_spell_proc_event.sql
deleted file mode 100644
index 20f87b3f1f9..00000000000
--- a/sql/updates/8373_spell_proc_event.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-DELETE FROM `spell_proc_event` WHERE `entry` IN (70807);
-INSERT INTO `spell_proc_event` (`entry`,`SchoolMask`,`SpellFamilyName`,`SpellFamilyMask0`,`SpellFamilyMask1`,`SpellFamilyMask2`,`procFlags`,`procEx`,`ppmRate`,`CustomChance`,`Cooldown`) VALUES 
-( 70807,    0,  11, 0x00000000, 0x00000000, 0x00000010, 0x00000000, 0x00000000,   0, 100,   0); -- Item - Shaman T10 Restoration 2P Bonus
diff --git a/sql/updates/8373_world_spell_proc_event.sql b/sql/updates/8373_world_spell_proc_event.sql
new file mode 100644
index 00000000000..20f87b3f1f9
--- /dev/null
+++ b/sql/updates/8373_world_spell_proc_event.sql
@@ -0,0 +1,3 @@
+DELETE FROM `spell_proc_event` WHERE `entry` IN (70807);
+INSERT INTO `spell_proc_event` (`entry`,`SchoolMask`,`SpellFamilyName`,`SpellFamilyMask0`,`SpellFamilyMask1`,`SpellFamilyMask2`,`procFlags`,`procEx`,`ppmRate`,`CustomChance`,`Cooldown`) VALUES 
+( 70807,    0,  11, 0x00000000, 0x00000000, 0x00000010, 0x00000000, 0x00000000,   0, 100,   0); -- Item - Shaman T10 Restoration 2P Bonus
diff --git a/sql/updates/8374_spell_proc_event.sql b/sql/updates/8374_spell_proc_event.sql
deleted file mode 100644
index 5882a028546..00000000000
--- a/sql/updates/8374_spell_proc_event.sql
+++ /dev/null
@@ -1,4 +0,0 @@
-DELETE FROM `spell_proc_event` WHERE `entry` IN (67667);
-INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES
-( 67667, 0x00,   0, 0x00000000, 0x00000000, 0x00000000, 0x00004000, 0x00000000,   0,   0,  45); -- Item - Coliseum Healer Trinket 5men
-
diff --git a/sql/updates/8374_world_spell_proc_event.sql b/sql/updates/8374_world_spell_proc_event.sql
new file mode 100644
index 00000000000..5882a028546
--- /dev/null
+++ b/sql/updates/8374_world_spell_proc_event.sql
@@ -0,0 +1,4 @@
+DELETE FROM `spell_proc_event` WHERE `entry` IN (67667);
+INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES
+( 67667, 0x00,   0, 0x00000000, 0x00000000, 0x00000000, 0x00004000, 0x00000000,   0,   0,  45); -- Item - Coliseum Healer Trinket 5men
+
diff --git a/sql/updates/8375_world_spell_proc_event.sql b/sql/updates/8375_world_spell_proc_event.sql
new file mode 100644
index 00000000000..62700485066
--- /dev/null
+++ b/sql/updates/8375_world_spell_proc_event.sql
@@ -0,0 +1,5 @@
+DELETE FROM `spell_proc_event` WHERE `entry` IN (67672,67670,67653);
+INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES
+( 67672, 0x00,   0, 0x00000000, 0x00000000, 0x00000000, 0x00800154, 0x00000000,   0,   0,  45), -- Item - Coliseum Melee Trinket 5men
+( 67670, 0x00,   0, 0x00000000, 0x00000000, 0x00000000, 0x00010000, 0x00000000,   0,   0,  45), -- Item - Coliseum Caster Trinket 5men
+( 67653, 0x00,   0, 0x00000000, 0x00000000, 0x00000000, 0x00400028, 0x00000000,   0,   0,  45); -- Item - Coliseum Tank Trinket 5men
-- 
cgit v1.2.3