From 91ebad0016d102ee9a10c5804ace08b41e6ac4e2 Mon Sep 17 00:00:00 2001
From: Shocker <none@none>
Date: Wed, 25 Aug 2010 21:23:28 +0300
Subject: * Add support for quest 1393 (Galen's Escape), original code by
 przemratajczak, port by McBitter, closes issue 3463 * Fix typo in
 AuctionHouseHandler, thanks GriffonHeart, fixes issue 3609 * Forgotten thanks

--HG--
branch : trunk
---
 sql/scripts/world_script_texts.sql         |  7 +++++++
 sql/scripts/world_script_waypoints.sql     | 26 ++++++++++++++++++++++++++
 sql/scripts/world_scripts_full.sql         |  1 +
 sql/updates/9591_world_script_texts.sql    | 10 ++++++++++
 sql/updates/9591_world_script_waypoint.sql | 25 +++++++++++++++++++++++++
 sql/updates/9591_world_scriptname.sql      |  2 ++
 6 files changed, 71 insertions(+)
 create mode 100644 sql/updates/9591_world_script_texts.sql
 create mode 100644 sql/updates/9591_world_script_waypoint.sql
 create mode 100644 sql/updates/9591_world_scriptname.sql

(limited to 'sql')

diff --git a/sql/scripts/world_script_texts.sql b/sql/scripts/world_script_texts.sql
index fab6a21b7bf..cc678861318 100644
--- a/sql/scripts/world_script_texts.sql
+++ b/sql/scripts/world_script_texts.sql
@@ -426,6 +426,13 @@ INSERT INTO `script_texts` (`npc_entry`,`entry`,`content_default`,`content_loc1`
    (17375, -1000474, '[Fulborg] The Stillpine furbolgs will not soon forget your bravery!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, 0, 0, 0, 0,'Stillpine Capitive free say text 1'),
    (17375, -1000475, '[Fulborg] Thank you, $N',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, 0, 0, 0, 0, 'Stillpine Capitive free say text 2'),
    (17375, -1000476, '[Fulborg] Those remaining at Stillpine Hold will welcome you as a hero!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, 0, 0, 0, 0, 'Stillpine Capitive free say text 3'),
+   (5391, -1000500, 'Help! Please, You must help me!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'Galen - periodic say'),
+   (5391, -1000501, 'Let us leave this place.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'Galen - quest accepted'),
+   (5391, -1000502, 'Look out! The $c attacks!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'Galen - aggro 1'),
+   (5391, -1000503, 'Help! I\'m under attack!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'Galen - aggro 2'),
+   (5391, -1000504, 'Thank you $N. I will remember you always. You can find my strongbox in my camp, north of Stonard.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'Galen - quest complete'),
+   (5391, -1000505, '%s whispers to $N the secret to opening his strongbox.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,2,0,0,'Galen - emote whisper'),
+   (5391, -1000506, '%s disappears into the swamp.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,2,0,0,'Galen - emote disappear'),
    (26588,-1800001, 'Um... I think one of those wolves is back...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0, '12027'),
    (26588,-1800002, 'He''s going for Mr. Floppy! ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0, '12027'),
    (26588,-1800003, 'Oh, no! Look, it''s another wolf, and it''s a biiiiiig one!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0, '12027'),
diff --git a/sql/scripts/world_script_waypoints.sql b/sql/scripts/world_script_waypoints.sql
index 3a5734d6d0e..473acfa0e88 100644
--- a/sql/scripts/world_script_waypoints.sql
+++ b/sql/scripts/world_script_waypoints.sql
@@ -2267,3 +2267,29 @@ INSERT INTO `script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`, `
 (33370, 4, 206.092, -34.7447, 409.801, 0, '0'),
 (33370, 5, 240.208, 1.10346, 409.802, 0, '0'),
 (33370, 6, 337.199, 11.7051, 409.802, 0, '0');
+
+-- Waypoints for Galen Goodward
+DELETE FROM `script_waypoint` WHERE `entry`=5391;
+INSERT INTO `script_waypoint` VALUES
+(5391, 0, -9901.12, -3727.29, 22.11, 3000, ''),
+(5391, 1, -9909.27, -3727.81, 23.25, 0, ''),
+(5391, 2, -9935.25, -3729.02, 22.11, 0, ''),
+(5391, 3, -9945.83, -3719.34, 21.68, 0, ''),
+(5391, 4, -9963.41, -3710.18, 21.71, 0, ''),
+(5391, 5, -9972.75, -3690.13, 21.68, 0, ''),
+(5391, 6, -9989.70, -3669.67, 21.67, 0, ''),
+(5391, 7, -9989.21, -3647.76, 23.00, 0, ''),
+(5391, 8, -9992.27, -3633.74, 21.67, 0, ''),
+(5391, 9,-10002.32, -3611.67, 22.26, 0, ''),
+(5391,10, -9999.25, -3586.33, 21.85, 0, ''),
+(5391,11,-10006.53, -3571.99, 21.67, 0, ''),
+(5391,12,-10014.30, -3545.24, 21.67, 0, ''),
+(5391,13,-10018.91, -3525.03, 21.68, 0, ''),
+(5391,14,-10030.22, -3514.77, 21.67, 0, ''),
+(5391,15,-10045.11, -3501.49, 21.67, 0, ''),
+(5391,16,-10052.91, -3479.13, 21.67, 0, ''),
+(5391,17,-10060.68, -3460.31, 21.67, 0, ''),
+(5391,18,-10074.68, -3436.85, 20.97, 0, ''),
+(5391,19,-10074.68, -3436.85, 20.97, 0, ''),
+(5391,20,-10072.86, -3408.92, 20.43, 15000, ''),
+(5391,21,-10108.01, -3406.05, 22.06, 0, '');
diff --git a/sql/scripts/world_scripts_full.sql b/sql/scripts/world_scripts_full.sql
index f4dfddc6152..08303c24cbf 100644
--- a/sql/scripts/world_scripts_full.sql
+++ b/sql/scripts/world_scripts_full.sql
@@ -1273,6 +1273,7 @@ UPDATE `gameobject_template` SET `ScriptName`='kalecgos_teleporter' WHERE `entry
 UPDATE `creature_template` SET `ScriptName`='npc_blackhole' WHERE `entry`=25855;
 
 /* SWAMP OF SORROWS */
+UPDATE `creature_template` SET `ScriptName`='npc_galen_goodward' WHERE `entry`=5391;
 
 /* TANARIS */
 UPDATE `creature_template` SET `ScriptName`='mob_aquementas' WHERE `entry`=9453;
diff --git a/sql/updates/9591_world_script_texts.sql b/sql/updates/9591_world_script_texts.sql
new file mode 100644
index 00000000000..3cc94032437
--- /dev/null
+++ b/sql/updates/9591_world_script_texts.sql
@@ -0,0 +1,10 @@
+DELETE FROM script_texts WHERE entry BETWEEN -1000506 AND -1000500;
+INSERT INTO script_texts (npc_entry,entry,content_default,sound,type,language,emote,comment) VALUES
+(5391, -1000500,'Help! Please, You must help me!',0,0,0,0,'Galen - periodic say'),
+(5391, -1000501,'Let us leave this place.',0,0,0,0,'Galen - quest accepted'),
+(5391, -1000502,'Look out! The $c attacks!',0,0,0,0,'Galen - aggro 1'),
+(5391, -1000503,'Help! I\'m under attack!',0,0,0,0,'Galen - aggro 2'),
+(5391, -1000504,'Thank you $N. I will remember you always. You can find my strongbox in my camp, north of Stonard.',0,0,0,0,'Galen - quest complete'),
+(5391, -1000505,'%s whispers to $N the secret to opening his strongbox.',0,2,0,0,'Galen - emote whisper'),
+(5391, -1000506,'%s disappears into the swamp.',0,2,0,0,'Galen - emote disapper');
+
diff --git a/sql/updates/9591_world_script_waypoint.sql b/sql/updates/9591_world_script_waypoint.sql
new file mode 100644
index 00000000000..31f69b62961
--- /dev/null
+++ b/sql/updates/9591_world_script_waypoint.sql
@@ -0,0 +1,25 @@
+DELETE FROM script_waypoint WHERE entry=5391;
+INSERT INTO script_waypoint VALUES
+(5391, 0, -9901.12, -3727.29, 22.11, 3000, ''),
+(5391, 1, -9909.27, -3727.81, 23.25, 0, ''),
+(5391, 2, -9935.25, -3729.02, 22.11, 0, ''),
+(5391, 3, -9945.83, -3719.34, 21.68, 0, ''),
+(5391, 4, -9963.41, -3710.18, 21.71, 0, ''),
+(5391, 5, -9972.75, -3690.13, 21.68, 0, ''),
+(5391, 6, -9989.70, -3669.67, 21.67, 0, ''),
+(5391, 7, -9989.21, -3647.76, 23.00, 0, ''),
+(5391, 8, -9992.27, -3633.74, 21.67, 0, ''),
+(5391, 9,-10002.32, -3611.67, 22.26, 0, ''),
+(5391,10, -9999.25, -3586.33, 21.85, 0, ''),
+(5391,11,-10006.53, -3571.99, 21.67, 0, ''),
+(5391,12,-10014.30, -3545.24, 21.67, 0, ''),
+(5391,13,-10018.91, -3525.03, 21.68, 0, ''),
+(5391,14,-10030.22, -3514.77, 21.67, 0, ''),
+(5391,15,-10045.11, -3501.49, 21.67, 0, ''),
+(5391,16,-10052.91, -3479.13, 21.67, 0, ''),
+(5391,17,-10060.68, -3460.31, 21.67, 0, ''),
+(5391,18,-10074.68, -3436.85, 20.97, 0, ''),
+(5391,19,-10074.68, -3436.85, 20.97, 0, ''),
+(5391,20,-10072.86, -3408.92, 20.43, 15000, ''),
+(5391,21,-10108.01, -3406.05, 22.06, 0, '');
+
diff --git a/sql/updates/9591_world_scriptname.sql b/sql/updates/9591_world_scriptname.sql
new file mode 100644
index 00000000000..e103b512376
--- /dev/null
+++ b/sql/updates/9591_world_scriptname.sql
@@ -0,0 +1,2 @@
+UPDATE creature_template SET ScriptName='npc_galen_goodward' WHERE entry=5391;
+
-- 
cgit v1.2.3