aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authoroffl <11556157+offl@users.noreply.github.com>2021-08-10 11:18:28 +0300
committerShauren <shauren.trinity@gmail.com>2022-03-12 14:48:03 +0100
commitac82e23fa3d2649ca2d0160ac477c9b0510d8200 (patch)
tree1b62e78a69b0174d3042c473b8f8fc11fff40bc2 /sql
parent20c8698bc467d493463c5afbced910d11d3b71b3 (diff)
Scripts/Spells: Fix support for 'Teleport This!' (10857) (#26789)
Co-authored-by: offl <offl@users.noreply.github.com> (cherry picked from commit 8186e6deca7a42403db8b45b341c655cec9c8a73)
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/master/2022_03_12_01_world_2021_08_10_00_world.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_03_12_01_world_2021_08_10_00_world.sql b/sql/updates/world/master/2022_03_12_01_world_2021_08_10_00_world.sql
new file mode 100644
index 00000000000..b496ad82055
--- /dev/null
+++ b/sql/updates/world/master/2022_03_12_01_world_2021_08_10_00_world.sql
@@ -0,0 +1,8 @@
+--
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (16943,20928) AND `source_type` = 0 AND `id` IN (3,4,5);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (22348,22350,22351) AND `source_type` = 0;
+UPDATE `creature_template` SET `AIName` = '' WHERE `entry` IN (22348,22350,22351);
+
+DELETE FROM `spell_script_names` WHERE `spell_id` = 38920 AND `ScriptName` = 'spell_detonate_teleporter';
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
+(38920,'spell_detonate_teleporter');