aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorModoX <moardox@gmail.com>2024-01-09 14:45:42 +0100
committerModoX <moardox@gmail.com>2024-01-09 14:46:47 +0100
commit12bf4b05c54edb33f324ebe2c9db1b356dd8b0ca (patch)
tree141349f1ad46e3ed93e991473af629c7e5f9d5ae
parentc3de2b4f1369d0c4f5268d9d400132385570f2cf (diff)
DB/Creature: Added more personal summons which should be removed on quest remove
-rw-r--r--sql/updates/world/master/2024_01_09_02_world.sql27
1 files changed, 27 insertions, 0 deletions
diff --git a/sql/updates/world/master/2024_01_09_02_world.sql b/sql/updates/world/master/2024_01_09_02_world.sql
new file mode 100644
index 00000000000..3b4b67a5e88
--- /dev/null
+++ b/sql/updates/world/master/2024_01_09_02_world.sql
@@ -0,0 +1,27 @@
+DELETE FROM `creature_summoned_data` WHERE `CreatureID` IN(154327, 166996, 120590, 93011, 98228, 98227, 98290, 98292, 99918, 94580, 98229, 98354, 99916, 94410, 99917, 94377, 93117, 94400, 93230);
+INSERT INTO `creature_summoned_data` (`CreatureID`, `DespawnOnQuestsRemoved`) VALUES
+-- Taming the Wilds
+(154327, '59342'), -- Austin Huxworth
+(166996, '59937'), -- Dawntracker
+-- Tides of War / Nation of Kul'Tiras
+(120590, '46727,46728'), -- Jaina
+-- Invasion Begins
+(93011, '40077'), -- Kayn Sunfury
+(98228, '40077'), -- Jayce Darkweaver
+(98227, '40077'), -- Allari the Souleater
+(98290, '40077'), -- Cyana Nightglaive
+(98292, '40077'), -- Korvas Bloodthorn
+(99918, '40077'), -- Sevis Brightflame
+(94580, '40077'), -- Wrath Warrior
+-- Enter the Illidari: Ashtongue
+(98229, '40378'), -- Kayn Sunfury
+(98354, '40378'), -- Korvas Bloodthorn
+(99916, '40378'), -- Sevis Brightflame
+(94410, '40378'), -- Allari Souleater
+-- Enter the Illidari: Coilskar
+(99917, '40379'), -- Sevis Brightflame
+-- Set them free
+(94377, '38759'), -- Cyana Nightglaive
+(93117, '38759'), -- Iyal Whitemoon
+(94400, '38759'), -- Belath Dawnblade
+(93230, '38759'); -- Mannethrel Darkstar