From d2fbb9f91930e1201f9030e22f377b7c71bcccfe Mon Sep 17 00:00:00 2001
From: maximius <none@none>
Date: Wed, 18 Nov 2009 00:47:31 -0800
Subject: *Implement Dalaran Mageguards, by WarHead. Closes #43 *f6e09e1d71d4
 16062b31dba9 df7b6c79c44a and 420160897950 were by MetaphysicalDrama. Closes
 #153, #146, #147, #123

--HG--
branch : trunk
---
 sql/updates/6277_world.sql | 8 ++++++++
 1 file changed, 8 insertions(+)
 create mode 100644 sql/updates/6277_world.sql

(limited to 'sql/updates')

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);
-- 
cgit v1.2.3