aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authormaximius <none@none>2009-11-18 00:47:31 -0800
committermaximius <none@none>2009-11-18 00:47:31 -0800
commitd2fbb9f91930e1201f9030e22f377b7c71bcccfe (patch)
tree320ae299e6d29efe1e9eaeded313e4865207d88b /sql/updates
parent2582fa289c0bf0d2ef26848de13b5144f82b2476 (diff)
*Implement Dalaran Mageguards, by WarHead. Closes #43
*f6e09e1d71d4 16062b31dba9 df7b6c79c44a and 420160897950 were by MetaphysicalDrama. Closes #153, #146, #147, #123 --HG-- branch : trunk
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);