From cfa0a32a1fff43bbd4546e7b903eae05d7b21d2f Mon Sep 17 00:00:00 2001 From: tkrokli Date: Fri, 3 Apr 2015 17:10:44 +0200 Subject: [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) --- sql/updates/world/2015_03_31_00_world.sql | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 sql/updates/world/2015_03_31_00_world.sql (limited to 'sql/updates') 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; -- cgit v1.2.3