aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorEdder <d.rosenauer@googlemail.com>2021-04-25 11:36:54 +0200
committerShauren <shauren.trinity@gmail.com>2022-03-09 00:42:48 +0100
commit8202dc28c2dae613c14a52ef4e84932d8c1c9e39 (patch)
tree774199b2874026e52f2b7e1b85b882b0029d94a6 /sql
parent9845fe92bb414e05cc5dff4fed507f30f39ca0db (diff)
Core/Quest: Threat From Above (#26468)
* [Quest] Threat From Above #26355 * [Quest] Threat From Above TrinityCore#26355 * Core/Quest: Threat From Above #26468 - modified sql according to guidelines; added override keyword * Rename 2021_04_24_00_world.sql to 2021_04_25_00_world.sql Co-authored-by: Edder <d.rosenauer@gmail.com> Co-authored-by: Giacomo Pozzoni <giacomopoz@gmail.com> (cherry picked from commit 3e407c7d1c79cc94bf932880ee0eb68058d139fd)
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/master/2022_03_08_08_world_2021_04_25_00_world.sql13
1 files changed, 13 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_03_08_08_world_2021_04_25_00_world.sql b/sql/updates/world/master/2022_03_08_08_world_2021_04_25_00_world.sql
new file mode 100644
index 00000000000..567676f5185
--- /dev/null
+++ b/sql/updates/world/master/2022_03_08_08_world_2021_04_25_00_world.sql
@@ -0,0 +1,13 @@
+-- delete non generic spell script for npc_wild_wyrm
+DELETE FROM `spell_script_names` WHERE `ScriptName`= 'spell_eject_passenger_wild_wyrm';
+
+-- add "special" generic spell script for "Eject Passenger 1"
+-- the spell script "spell_eject_passenger_wild_wyrm" used this spell too
+DELETE FROM `spell_script_names` WHERE `ScriptName`= 'spell_gen_eject_passenger_1';
+INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES
+(60603, 'spell_gen_eject_passenger_1');
+
+-- add "special" generic spell script for "Eject Passenger 3"
+DELETE FROM `spell_script_names` WHERE `ScriptName`= 'spell_gen_eject_passenger_3';
+INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES
+(52205, 'spell_gen_eject_passenger_3');