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/FULL/world_scripts_full.sql | 7 +++++--
 sql/FULL/world_spell_full.sql   | 8 +++++++-
 sql/updates/6277_world.sql      | 8 ++++++++
 3 files changed, 20 insertions(+), 3 deletions(-)
 create mode 100644 sql/updates/6277_world.sql

(limited to 'sql')

diff --git a/sql/FULL/world_scripts_full.sql b/sql/FULL/world_scripts_full.sql
index e6200bbb7d1..47ab1e12e81 100644
--- a/sql/FULL/world_scripts_full.sql
+++ b/sql/FULL/world_scripts_full.sql
@@ -375,9 +375,7 @@ UPDATE `item_template` SET `ScriptName`='item_pile_fake_furs' WHERE `entry`=3512
 /* BURNING STEPPES */
 UPDATE `creature_template` SET `ScriptName`='npc_ragged_john' WHERE `entry`=9563;
 
-/*  */
 /* CAVERNS OF TIME */
-/*  */
 
 /* MT. HYJAL */
 UPDATE `instance_template` SET `script`='instance_hyjal' WHERE `map`=534;
@@ -473,6 +471,11 @@ UPDATE `creature_template` SET `ScriptName`='mob_coilfang_strider' WHERE `entry`
 UPDATE `creature_template` SET `ScriptName`='mob_toxic_sporebat' WHERE `entry`=22140;
 UPDATE `creature_template` SET `ScriptName`='mob_shield_generator_channel' WHERE `entry`=19870;
 
+/* CRYSTALSONG FOREST */
+
+/* DALARAN */
+UPDATE `creature_template` SET `ScriptName`='npc_mageguard_dalaran' WHERE `entry` IN (29254,29255);
+
 /* DARKSHORE */
 UPDATE `creature_template` SET `ScriptName`='npc_kerlonian' WHERE `entry`=11218;
 UPDATE `creature_template` SET `ScriptName`='npc_threshwackonator' WHERE `entry`=6669;
diff --git a/sql/FULL/world_spell_full.sql b/sql/FULL/world_spell_full.sql
index 716ec6ef46f..67ebd0749fc 100644
--- a/sql/FULL/world_spell_full.sql
+++ b/sql/FULL/world_spell_full.sql
@@ -527,7 +527,7 @@ INSERT INTO `spell_script_target` VALUES
 -- POSITION
 -- --------
 DELETE FROM spell_target_position WHERE `id` IN (46019, 46020, 53360);
-INSERT INTO spell_target_position () VALUES
+INSERT INTO spell_target_position (`id`, `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`) VALUES
 (46019, 580, 1704.34, 928.17, -74.558, 0),
 (46020, 580, 1704.34, 928.17, 53.079, 0),
 (53360, 571, 5807.829, 587.960, 660.939, 1.663);
@@ -538,6 +538,12 @@ INSERT INTO `spell_target_position` (`id`, `target_map`, `target_position_x`, `t
 (54744, 0, 2418.67, -5621.41, 420.644, 3.89597),
 (54746, 0, 2402.15, -5633.74, 377.021, 3.65249);
 
+-- 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);
+
 -- --------
 -- MISC
 -- --------
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