diff options
| author | TCKiper <kiperek@o2.pl> | 2011-02-07 21:20:27 +0100 |
|---|---|---|
| committer | ZxBiohazardZx <zxbiohazardzx@gmail.com> | 2011-02-07 21:20:27 +0100 |
| commit | 71ef353004882fa212edac77b6f509286a620224 (patch) | |
| tree | 681d6f3005e8f0b5deb9ea0bbaeaed8d57582081 | |
| parent | 9c3e841c94b589fb54fceb5af12f8682737a20e6 (diff) | |
DB/Quest: Set creature_questrelation for quest You've Been Served (14488) and also add item_loot info for this quest
| -rw-r--r-- | sql/updates/world/2011_02_07_1_world_creature_questrelation.sql | 11 |
1 files changed, 11 insertions, 0 deletions
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); |