Grizzly Hills: Support for quest 12027

Mr. Floppy's Perilous Adventure
Needs db support

--HG--
branch : trunk

3 files changed, 46 insertions, 0 deletions

diff --git a/sql/updates/7387_world_script_texts.sql b/sql/updates/7387_world_script_texts.sql
new file mode 100644
index 00000000000..57d8cbf0fe3
--- /dev/null
+++ b/sql/updates/7387_world_script_texts.sql
@@ -0,0 +1,15 @@
+DELETE FROM `script_texts` WHERE `npc_entry`=26588;
+INSERT INTO `script_texts` (`npc_entry`, `entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`, `sound`, `type`, `language`, `emote`, `comment`) VALUES
+(26588, -1800013, 'Thank you for helping me get back to the camp. Go tell Walter that I''m safe now!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, '12027'),
+(26588, -1800012, 'Are you ready, Mr. Floppy? Stay close to me and watch out for those wolves!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, '12027'),
+(26588, -1800011, 'The Ravenous Worg chomps down on Mr. Floppy', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 4, 0, 0, '12027'),
+(26588, -1800010, 'Mr. Floppy revives', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 4, 0, 0, '12027'),
+(26588, -1800009, 'I think I see the camp! We''re almost home, Mr. Floppy! Let''s go!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, '12027'),
+(26588, -1800008, 'Mr. Floppy, you''re ok! Thank you so much for saving Mr. Floppy!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, '12027'),
+(26588, -1800007, 'Don''t go toward the light, Mr. Floppy!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, '12027'),
+(26588, -1800006, 'Let''s get out of here before more wolves find us!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, '12027'),
+(26588, -1800005, 'There''s a big meanie attacking Mr. Floppy! Help! ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, '12027'),
+(26588, -1800004, 'He''s gonna eat Mr. Floppy! You gotta help Mr. Floppy! You just gotta!', 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'),
+(26588, -1800002, 'He''s going for Mr. Floppy! ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, '12027'),
+(26588, -1800001, 'Um... I think one of those wolves is back...', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, '12027');
diff --git a/sql/updates/7387_world_script_waypoints.sql b/sql/updates/7387_world_script_waypoints.sql
new file mode 100644
index 00000000000..be595a30389
--- /dev/null
+++ b/sql/updates/7387_world_script_waypoints.sql
@@ -0,0 +1,29 @@
+DELETE FROM `script_waypoint` wHERE `entry`=26588;
+INSERT INTO `script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`, `location_z`, `waittime`, `point_comment`) VALUES
+(26588, 1, 4333.18, -3688.4, 263.857, 0, '0'),
+(26588, 2, 4341.38, -3683.77, 257.422, 0, '0'),
+(26588, 3, 4342.67, -3683.21, 257.218, 0, '0'),
+(26588, 4, 4346.22, -3688.72, 257.065, 0, '0'),
+(26588, 5, 4343.8, -3695.27, 257.124, 0, '0'),
+(26588, 6, 4337.74, -3707.2, 257.628, 0, '0'),
+(26588, 7, 4317.58, -3722.8, 256.941, 0, '0'),
+(26588, 8, 4306.64, -3736.46, 258.304, 0, '0'),
+(26588, 9, 4299.96, -3760.02, 254.959, 0, '0'),
+(26588, 10, 4294.21, -3777.34, 249.139, 1000, '0'),
+(26588, 11, 4294.37, -3776.97, 249.259, 10000, '0'),
+(26588, 12, 4300.22, -3794.61, 240.107, 2000, '0'),
+(26588, 13, 4307.25, -3817.76, 231.414, 2000, '0'),
+(26588, 14, 4326.31, -3883.31, 208.457, 2000, '0'),
+(26588, 15, 4346.19, -3905.41, 198.805, 2000, '0'),
+(26588, 16, 4347.39, -3916.43, 196.716, 5000, '0'),
+(26588, 17, 4350.17, -3935.03, 191.824, 1000, '0'),
+(26588, 18, 4347.24, -3939.54, 191.445, 2000, '0'),
+(26588, 19, 4347.24, -3939.54, 191.445, 2000, '0'),
+(26588, 20, 4347.24, -3939.54, 191.445, 5000, '0'),
+(26588, 21, 4347.24, -3939.54, 191.445, 7000, '0'),
+(26588, 22, 4347.24, -3939.54, 191.445, 5000, '0'),
+(26588, 23, 4347.24, -3939.54, 191.445, 5000, '0'),
+(26588, 24, 4347.24, -3939.54, 191.445, 0, '0'),
+(26588, 25, 4353.72, -3965.61, 190.154, 0, '0'),
+(26588, 26, 4363.12, -3995.61, 183.327, 0, '0'),
+(26588, 27, 4371.99, -4010.97, 181.33, 0, '0');
diff --git a/sql/updates/7387_world_scriptname.sql b/sql/updates/7387_world_scriptname.sql
new file mode 100644
index 00000000000..2ea586552d2
--- /dev/null
+++ b/sql/updates/7387_world_scriptname.sql
@@ -0,0 +1,2 @@
+UPDATE `creature_template` SET `ScriptName` = 'npc_emily' WHERE `entry`=26588;
+UPDATE `creature_template` SET `ScriptName` = 'npc_mrfloppy' WHERE `entry`=26589;