Script/Quest: The Lonesome Watcher (12877)

Closes: #9185
See: http://www.youtube.com/watch?v=ylZRMu9CIMw

4 files changed, 23 insertions, 0 deletions

diff --git a/sql/updates/world/2013_02_24_01_world_areatrigger_scripts.sql b/sql/updates/world/2013_02_24_01_world_areatrigger_scripts.sql
new file mode 100644
index 00000000000..2aebe1d2edd
--- /dev/null
+++ b/sql/updates/world/2013_02_24_01_world_areatrigger_scripts.sql
@@ -0,0 +1,3 @@
+DELETE FROM `areatrigger_scripts` WHERE `entry`=5173;
+INSERT INTO `areatrigger_scripts`(`entry`,`ScriptName`) VALUE
+(5173,'at_frostgrips_hollow');
diff --git a/sql/updates/world/2013_02_24_02_world_smart_scripts.sql b/sql/updates/world/2013_02_24_02_world_smart_scripts.sql
new file mode 100644
index 00000000000..7b41c82b6fa
--- /dev/null
+++ b/sql/updates/world/2013_02_24_02_world_smart_scripts.sql
@@ -0,0 +1,7 @@
+DELETE FROM `smart_scripts` WHERE `entryorguid`=29861 AND `source_type`=0;
+INSERT INTO `smart_scripts`(`entryorguid`,`source_type`,`event_type`,`action_type`,`action_param1`,`action_param2`,`target_type`,`comment`) VALUES
+(29861,0,54,80,2986100,2,1,'Stormforged Eradictor - Just summoned - Call timed actionlist 2986100');
+
+DELETE FROM `smart_scripts` WHERE `entryorguid`=2986100 AND `source_type`=9;
+INSERT INTO `smart_scripts`(`entryorguid`,`source_type`,`id`,`event_param1`,`event_param2`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`target_type`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUE
+(2986100,9,0,10000,10000,12,29729,4,10000,8,6972.13,14.24,805.79,3.349,'Stormforged Eradictor - Timed actionlist - Summon Frostborn Axemaster');
diff --git a/sql/updates/world/2013_02_24_03_world_waypoint_data.sql b/sql/updates/world/2013_02_24_03_world_waypoint_data.sql
new file mode 100644
index 00000000000..e97f0758304
--- /dev/null
+++ b/sql/updates/world/2013_02_24_03_world_waypoint_data.sql
@@ -0,0 +1,11 @@
+DELETE FROM `waypoint_data` WHERE `id`=2986200;
+INSERT INTO `waypoint_data`(`id`,`point`,`position_x`,`position_y`,`position_z`) VALUES
+(2986200,0,6963.95,45.65,818.71),
+(2986200,1,6965.09,39.67,820.15),
+(2986200,2,6963.56,21.14,805.79);
+
+DELETE FROM `waypoint_data` WHERE `id`=2986100;
+INSERT INTO `waypoint_data`(`id`,`point`,`position_x`,`position_y`,`position_z`) VALUES
+(2986100,0,6983.18,7.150,806.33),
+(2986100,1,6975.37,16.73,804.98),
+(2986100,2,6967.15,13.27,806.56);
diff --git a/sql/updates/world/2013_02_24_04_world_creature_template.sql b/sql/updates/world/2013_02_24_04_world_creature_template.sql
new file mode 100644
index 00000000000..c9acc0d2a1a
--- /dev/null
+++ b/sql/updates/world/2013_02_24_04_world_creature_template.sql
@@ -0,0 +1,2 @@
+UPDATE `creature_template` SET `faction_A`=1954,`faction_H`=1954,`AIName`='SmartAI' WHERE `entry`=29861;
+UPDATE `creature_template` SET `faction_A`=1954,`faction_H`=1954 WHERE `entry`=29862;