diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2016-12-06 08:10:41 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2016-12-06 08:10:41 +0100 |
| commit | 784d70af7b77674373a355a9f60f37931451d3b2 (patch) | |
| tree | 37e82078a2ccab68859e8edf492327401eae80be /sql | |
| parent | c856a058b50e9f9844a4eb4b63e3786de69e6678 (diff) | |
DB/Quest: loot for "Franks and Beans" (ID 26506)
Closes #18408 by Edreisantafe
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2016_12_06_00_world.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/master/2016_12_06_00_world.sql b/sql/updates/world/master/2016_12_06_00_world.sql new file mode 100644 index 00000000000..aa9c6329fc3 --- /dev/null +++ b/sql/updates/world/master/2016_12_06_00_world.sql @@ -0,0 +1,9 @@ +-- +DELETE FROM `creature_loot_template` WHERE `item`= 58891 AND `entry`= 442; +DELETE FROM `creature_loot_template` WHERE `item`= 58892 AND `entry`= 428; +DELETE FROM `creature_loot_template` WHERE `item`= 58893 AND `entry`= 547; +INSERT INTO `creature_loot_template` (`entry`,`item`,`Reference`,`Chance`,`QuestRequired`,`LootMode`,`GroupId`,`MinCount`,`MaxCount`,`Comment`) VALUES +(442, 58891, 0, 72, 1, 1, 0, 1, 1, NULL), -- Tarantula Eyes (58891) / Tarantula (442) +(428, 58892, 0, 85, 1, 1, 0, 1, 1, NULL), -- Condor Giblets (58892) / Dire Condor (428) +(547, 58893, 0, 51, 1, 1, 0, 1, 1, NULL); -- Goretusk Kidney (58893) / Great Goretusk (547) +-- |