aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/6277_world.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/6277_world.sql b/sql/updates/6277_world.sql
new file mode 100644
index 00000000000..e89b87bdbd9
--- /dev/null
+++ b/sql/updates/6277_world.sql
@@ -0,0 +1,8 @@
+
+UPDATE `creature_template` SET `ScriptName`='npc_mageguard_dalaran' WHERE `entry` IN (29254,29255);
+
+-- positions for Dalaran 'Trespasser!' spell
+DELETE FROM `spell_target_position` WHERE `id` IN (54028,54029);
+INSERT INTO `spell_target_position` (`id`, `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`) VALUES
+(54028, 571, 5758.79, 678.359, 642.726, 5.572);
+(54029, 571, 5849.16, 602.093, 651.13, 2.364);