aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
Diffstat
-rw-r--r--sql/updates/7854_world_spell_goup.sql1
-rw-r--r--sql/updates/7854_world_spell_proc_event.sql1
-rw-r--r--sql/updates/7854_world_spell_ranks.sql1
-rw-r--r--sql/world.sql37
4 files changed, 3 insertions, 37 deletions
diff --git a/sql/updates/7854_world_spell_goup.sql b/sql/updates/7854_world_spell_goup.sql
new file mode 100644
index 00000000000..5d663eff11e
--- /dev/null
+++ b/sql/updates/7854_world_spell_goup.sql
@@ -0,0 +1 @@
+DELETE FROM `spell_group` WHERE `spell_id` IN (61417, 61418);
diff --git a/sql/updates/7854_world_spell_proc_event.sql b/sql/updates/7854_world_spell_proc_event.sql
new file mode 100644
index 00000000000..b50127bd540
--- /dev/null
+++ b/sql/updates/7854_world_spell_proc_event.sql
@@ -0,0 +1 @@
+DELETE FROM `spell_proc_event` WHERE `entry` IN (58642, 58676, 61433, 61434, 33174, 33182, 51470, 44396, 29801, 30802, 30803, 30804, 30805, 30808, 30809, 49137, 49657, 51466, 53137, 53138, 44394, 44395, 44396, 34457);
diff --git a/sql/updates/7854_world_spell_ranks.sql b/sql/updates/7854_world_spell_ranks.sql
new file mode 100644
index 00000000000..60c44cd39b1
--- /dev/null
+++ b/sql/updates/7854_world_spell_ranks.sql
@@ -0,0 +1 @@
+DELETE FROM `spell_ranks` WHERE `first_spell_id` IN (30803, 33174, 61417, 9736, 15742); \ No newline at end of file
diff --git a/sql/world.sql b/sql/world.sql
index 8cda40b82e2..b2bab728ed3 100644
--- a/sql/world.sql
+++ b/sql/world.sql
@@ -5974,8 +5974,6 @@ INSERT INTO `spell_linked_spell` (`spell_trigger`,`spell_effect`,`type`,`comment
( 34471, 24397, 2, 'The Beast Within'),
( 34471, 26592, 2, 'The Beast Within'),
(-59907, 7, 0, 'Lightwell Charges - Suicide'),
-( 26022, 61417, 2, 'Pursuit of Justice'),
-( 26023, 61418, 2, 'Pursuit of Justice'),
( 19263, 67801, 2, 'Deterrence'),
-- Quest
( 40214, 40216, 2, 'Dragonmaw Illusion'),
@@ -6414,7 +6412,6 @@ INSERT INTO `spell_proc_event` (`entry`,`SchoolMask`,`SpellFamilyName`,`SpellFam
( 29635, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 3, 0, 0), -- Flaming Shell
( 29636, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 3, 0, 0), -- Venom Shot
( 29637, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 3, 0, 0), -- Keeper's Sting
-( 29801, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0, 0, 0), -- Rampage (Rank 1)
( 29834, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00010000, 0, 0, 0), -- Second Wind (Rank 1)
( 29838, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00010000, 0, 0, 0), -- Second Wind (Rank 2)
( 29977, 0x00, 3, 0x00C00017, 0x00000040, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Combustion
@@ -6431,12 +6428,6 @@ INSERT INTO `spell_proc_event` (`entry`,`SchoolMask`,`SpellFamilyName`,`SpellFam
( 30679, 0x00, 11, 0x00000003, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Lightning Overload (Rank 3)
( 30701, 0x1C, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Elemental Absorption (Rank 1)
( 30705, 0x1C, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Elemental Absorption (Rank 5)
-( 30802, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0, 0, 0), -- Unleashed Rage (Rank 1)
-( 30803, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0, 0, 0), -- Unleashed Rage (Rank 1)
-( 30804, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0, 0, 0), -- Unleashed Rage (Rank 2)
-( 30805, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0, 0, 0), -- Unleashed Rage (Rank 3)
-( 30808, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0, 0, 0), -- Unleashed Rage (Rank 2)
-( 30809, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0, 0, 0), -- Unleashed Rage (Rank 3)
( 30823, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 10., 0, 0), -- Shamanistic Rage
( 30881, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 5), -- Nature's Guardian (Rank 1)
( 30883, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 5), -- Nature's Guardian (Rank 2)
@@ -6493,8 +6484,6 @@ INSERT INTO `spell_proc_event` (`entry`,`SchoolMask`,`SpellFamilyName`,`SpellFam
( 33150, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0, 0, 0), -- Surge of Light (Rank 1)
( 33151, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0, 0, 0), -- Surge of Light (Rank 1)
( 33154, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0, 0, 0), -- Surge of Light (Rank 2)
-( 33174, 0x00, 6, 0x00000020, 0x00000000, 0x00000000, 0x00004000, 0x00000000, 0, 0, 0), -- Improved Divine Spirit (Rank 1)
-( 33182, 0x00, 6, 0x00000020, 0x00000000, 0x00000000, 0x00004000, 0x00000000, 0, 0, 0), -- Improved Divine Spirit (Rank 2)
( 33191, 0x00, 6, 0x00808000, 0x00000400, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Misery (Rank 1)
( 33192, 0x00, 6, 0x00808000, 0x00000400, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Misery (Rank 2)
( 33193, 0x00, 6, 0x00808000, 0x00000400, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Misery (Rank 3)
@@ -6519,7 +6508,6 @@ INSERT INTO `spell_proc_event` (`entry`,`SchoolMask`,`SpellFamilyName`,`SpellFam
( 34262, 0x00, 10, 0x00800000, 0x00000000, 0x00000000, 0x00000000, 0x00040000, 0, 0, 0), -- Mercy
( 34320, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0, 0, 45), -- Call of the Nexus
( 34355, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 3), -- Poison Shield
-( 34457, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0, 0, 0), -- Ferocious Inspiration (Rank 1)
( 34497, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0, 0, 0), -- Thrill of the Hunt (Rank 1)
( 34498, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0, 0, 0), -- Thrill of the Hunt (Rank 2)
( 34499, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0, 0, 0), -- Thrill of the Hunt (Rank 3)
@@ -6646,9 +6634,6 @@ INSERT INTO `spell_proc_event` (`entry`,`SchoolMask`,`SpellFamilyName`,`SpellFam
( 43748, 0x00, 11, 0x90100000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Elemental Strength
( 43750, 0x00, 11, 0x00000001, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Energized
( 43819, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00010000, 0, 0, 0), -- Lucidity
-( 44394, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000400, 0, 0, 0), -- Incanter's Absorption (Rank 1)
-( 44395, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000400, 0, 0, 0), -- Incanter's Absorption (Rank 2)
-( 44396, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000400, 0, 0, 0), -- Incanter's Absorption (Rank 3)
( 44404, 0x00, 3, 0x20000021, 0x00009000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Missile Barrage (Rank 1)
( 44442, 0x00, 3, 0x00800000, 0x00000040, 0x00000000, 0x00000000, 0x00010000, 0, 0, 1), -- Firestarter (Rank 1)
( 44443, 0x00, 3, 0x00800000, 0x00000040, 0x00000000, 0x00000000, 0x00010000, 0, 0, 1), -- Firestarter (Rank 2)
@@ -6784,8 +6769,6 @@ INSERT INTO `spell_proc_event` (`entry`,`SchoolMask`,`SpellFamilyName`,`SpellFam
( 51352, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 10), -- Venture Company Beatdown!
( 51359, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 10), -- Venture Company Beatdown
( 51414, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 45), -- Venomous Breath Aura
-( 51466, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0, 0, 0), -- Elemental Oath (Rank 1)
-( 51470, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0, 0, 0), -- Elemental Oath (Rank 2)
( 51474, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00010000, 0, 0, 0), -- Astral Shift (Rank 1)
( 51478, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00010000, 0, 0, 0), -- Astral Shift (Rank 2)
( 51479, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00010000, 0, 0, 0), -- Astral Shift (Rank 3)
@@ -6852,8 +6835,6 @@ INSERT INTO `spell_proc_event` (`entry`,`SchoolMask`,`SpellFamilyName`,`SpellFam
( 52799, 0x00, 6, 0x00000001, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Borrowed Time (Rank 4)
( 52800, 0x00, 6, 0x00000001, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Borrowed Time (Rank 5)
( 52898, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0, 0, 0), -- Spell Damping
-( 53137, 0x00, 15, 0x01400000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Abomination's Might (Rank 1)
-( 53138, 0x00, 15, 0x01400000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Abomination's Might (Rank 2)
( 53215, 0x00, 9, 0x00000001, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Wild Quiver (Rank 1)
( 53216, 0x00, 9, 0x00000001, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Wild Quiver (Rank 2)
( 53217, 0x00, 9, 0x00000001, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Wild Quiver (Rank 3)
@@ -7094,8 +7075,6 @@ INSERT INTO `spell_proc_event` (`entry`,`SchoolMask`,`SpellFamilyName`,`SpellFam
( 49217, 0x00, 15, 0x00000000, 0x00000000, 0x00000002, 0x00000000, 0x00000000, 0, 0, 1), -- Wandering Plague
( 49654, 0x00, 15, 0x00000000, 0x00000000, 0x00000002, 0x00000000, 0x00000000, 0, 0, 1), -- Wandering Plague
( 49655, 0x00, 15, 0x00000000, 0x00000000, 0x00000002, 0x00000000, 0x00000000, 0, 0, 1), -- Wandering Plague
-( 49137, 0x00, 15, 0x00000004, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Endless Winter
-( 49657, 0x00, 15, 0x00000004, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Endless Winter
( 58620, 0x00, 15, 0x00000004, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Glyph of Chains of Ice
( 56342, 0x00, 9, 0x00000018, 0x08000000, 0x00024000, 0x00000000, 0x00000000, 0, 0, 0), -- Lock and Load
( 56343, 0x00, 9, 0x00000018, 0x08000000, 0x00024000, 0x00000000, 0x00000000, 0, 0, 0), -- Lock and Load
@@ -7113,8 +7092,6 @@ INSERT INTO `spell_proc_event` (`entry`,`SchoolMask`,`SpellFamilyName`,`SpellFam
( 54639, 0x00, 15, 0x00400000, 0x00010000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Blood of the north
( 54638, 0x00, 15, 0x00400000, 0x00010000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Blood of the north
( 54637, 0x00, 15, 0x00400000, 0x00010000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Blood of the north
-( 61433, 0x00, 15, 0x00400000, 0x00010000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Blood of the north
-( 61434, 0x00, 15, 0x00400000, 0x00010000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Blood of the north
( 49467, 0x00, 15, 0x00000010, 0x00020000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Death Rune Mastery
( 50033, 0x00, 15, 0x00000010, 0x00020000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Death Rune Mastery
( 50034, 0x00, 15, 0x00000010, 0x00020000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Death Rune Mastery
@@ -10047,9 +10024,6 @@ INSERT INTO spell_ranks (`first_spell_id`, `spell_id`, `rank`) VALUES
-- Improved Disciplines
(12312, 12312, 1),
(12312, 12803, 2),
- -- Improved Divine Spirit
-(33174, 33174, 1),
-(33174, 33182, 2),
-- Improved Drain Soul
(18213, 18213, 1),
(18213, 18372, 2),
@@ -11425,9 +11399,6 @@ INSERT INTO spell_ranks (`first_spell_id`, `spell_id`, `rank`) VALUES
(31825, 31825, 1),
(31825, 31826, 2),
-- Pursuit of Justice
-(61417, 61417, 1),
-(61417, 61418, 2),
- -- Pursuit of Justice
(26022, 26022, 1),
(26022, 26023, 2),
-- Pyroblast
@@ -13621,10 +13592,6 @@ INSERT INTO spell_ranks (`first_spell_id`, `spell_id`, `rank`) VALUES
(30802, 30802, 1),
(30802, 30808, 2),
(30802, 30809, 3),
- -- Unleashed Rage
-(30803, 30803, 1),
-(30803, 30804, 2),
-(30803, 30805, 3),
-- Vindication
(9452, 9452, 1),
(9452, 26016, 2),
@@ -13660,8 +13627,6 @@ INSERT INTO spell_ranks (`first_spell_id`, `spell_id`, `rank`) VALUES
(19386, 27068, 4),
(19386, 49011, 5),
(19386, 49012, 6),
- -- Arantir's Deception
-(9736, 9736, 1),
-- First Aid
(746, 746, 1),
(746, 1159, 2),
@@ -13737,8 +13702,6 @@ INSERT INTO spell_ranks (`first_spell_id`, `spell_id`, `rank`) VALUES
(8072, 25507, 8),
(8072, 58752, 9),
(8072, 58754, 10),
- -- Ashcrombe's Teleport
-(15742, 15742, 1),
-- Attack
(3606, 3606, 1),
(3606, 6350, 2),