From 0097fd95b65a57c0e246b8250920edddebdb0e0c Mon Sep 17 00:00:00 2001
From: offl <11556157+offl@users.noreply.github.com>
Date: Wed, 1 Dec 2021 02:52:31 +0200
Subject: Scripts/Spells: Generic spell script for quest portals (#27305)

(cherry picked from commit 251304b19c2fc42ee330b9a533b54f7b80df5d4a)
---
 .../master/2022_03_23_03_world_2021_12_01_04_world.sql    | 15 +++++++++++++++
 1 file changed, 15 insertions(+)
 create mode 100644 sql/updates/world/master/2022_03_23_03_world_2021_12_01_04_world.sql

(limited to 'sql/updates')

diff --git a/sql/updates/world/master/2022_03_23_03_world_2021_12_01_04_world.sql b/sql/updates/world/master/2022_03_23_03_world_2021_12_01_04_world.sql
new file mode 100644
index 00000000000..207f29d83fc
--- /dev/null
+++ b/sql/updates/world/master/2022_03_23_03_world_2021_12_01_04_world.sql
@@ -0,0 +1,15 @@
+--
+DELETE FROM `spell_scripts` WHERE `id` = 53099;
+
+DELETE FROM `spell_script_names` WHERE `ScriptName` IN ('spell_teleport_leaders_blessing','spell_59064_59439_portals');
+DELETE FROM `spell_script_names` WHERE `spell_id` IN (53099,57896,58418,58420,59064,59065,59439,60900,60940) AND `ScriptName` = 'spell_quest_portal_with_condition';
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
+(53099,'spell_quest_portal_with_condition'),
+(57896,'spell_quest_portal_with_condition'),
+(58418,'spell_quest_portal_with_condition'),
+(58420,'spell_quest_portal_with_condition'),
+(59064,'spell_quest_portal_with_condition'),
+(59065,'spell_quest_portal_with_condition'),
+(59439,'spell_quest_portal_with_condition'),
+(60900,'spell_quest_portal_with_condition'),
+(60940,'spell_quest_portal_with_condition');
-- 
cgit v1.2.3