diff options
| author | Shocker <none@none> | 2010-08-25 21:23:28 +0300 |
|---|---|---|
| committer | Shocker <none@none> | 2010-08-25 21:23:28 +0300 |
| commit | 91ebad0016d102ee9a10c5804ace08b41e6ac4e2 (patch) | |
| tree | 6bcfaafed4e2b66efa76a9f928b4955b25a47486 /sql/updates | |
| parent | e8a7a53bfa26c3809d3540cfeae81efd04a3ae5d (diff) | |
* 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
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/9591_world_script_texts.sql | 10 | ||||
| -rw-r--r-- | sql/updates/9591_world_script_waypoint.sql | 25 | ||||
| -rw-r--r-- | sql/updates/9591_world_scriptname.sql | 2 |
3 files changed, 37 insertions, 0 deletions
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; + |