From 71ef353004882fa212edac77b6f509286a620224 Mon Sep 17 00:00:00 2001 From: TCKiper Date: Mon, 7 Feb 2011 21:20:27 +0100 Subject: DB/Quest: Set creature_questrelation for quest You've Been Served (14488) and also add item_loot info for this quest --- .../world/2011_02_07_1_world_creature_questrelation.sql | 11 +++++++++++ 1 file changed, 11 insertions(+) create mode 100644 sql/updates/world/2011_02_07_1_world_creature_questrelation.sql (limited to 'sql') diff --git a/sql/updates/world/2011_02_07_1_world_creature_questrelation.sql b/sql/updates/world/2011_02_07_1_world_creature_questrelation.sql new file mode 100644 index 00000000000..c0f93b24ced --- /dev/null +++ b/sql/updates/world/2011_02_07_1_world_creature_questrelation.sql @@ -0,0 +1,11 @@ +-- Missing relation for quest You've Been Served +INSERT INTO `creature_questrelation`(`id`,`quest`) VALUES +(38208,14488); +INSERT INTO `creature_involvedrelation`(`id`,`quest`) VALUES +(36296,14488); + +-- Missing loot form Standard Apothecary Serving Kit request for quest You've Been Served + INSERT INTO `item_loot_template`(`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES +(49631,49352,100,1,0,1,1), +(49631,49351,100,1,0,1,1), +(49631,49635,100,1,0,1,1); -- cgit v1.2.3