diff options
| author | tkrokli <tkrokli@hotmail.com> | 2015-04-03 17:10:44 +0200 |
|---|---|---|
| committer | DDuarte <dnpd.dd@gmail.com> | 2015-04-14 01:01:47 +0100 |
| commit | cfa0a32a1fff43bbd4546e7b903eae05d7b21d2f (patch) | |
| tree | 08a2e3468fb5e2987ce464155fdc66504db8dcff /sql | |
| parent | b7eb415049afb9ec5b9f004209210c0acc33e62c (diff) | |
[Quest] Kodo Roundup
by @pete318, closes #12811
Fixes the remaining bugs in the "Kodo Roundup" quest in Desolace:
- removes combat status from creature 11627, Tamed Kodo
- sets normal walking speed as the creature's follow speed
- makes the Tamed Kodo stop at Scrabblescrew's Camp
- enables quest objective count 0/5 -> 5/5, quest complete
- SQL (by @tkrokli) links the missing gossip text in the DB
(cherry picked from commit 1c8486e1a84c2d1ed4355d680418a3a2e73e37dd)
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2015_03_31_00_world.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/2015_03_31_00_world.sql b/sql/updates/world/2015_03_31_00_world.sql new file mode 100644 index 00000000000..e2f0d055e3b --- /dev/null +++ b/sql/updates/world/2015_03_31_00_world.sql @@ -0,0 +1,6 @@ +-- Fix for quest ID 5561, Kodo Roundup +-- Add the missing link between npc_text and gossip_menu_id : +DELETE FROM `gossip_menu` WHERE `entry`=3650 AND `text_id`=4449; +INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES (3650, 4449); +-- Link the npc_text from gossip_menu: +UPDATE `creature_template` SET `gossip_menu_id`=3650 WHERE `entry`=11627; |