diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2014-10-12 01:17:54 +0200 |
|---|---|---|
| committer | Aokromes <Aokromes@users.noreply.github.com> | 2014-10-12 01:17:54 +0200 |
| commit | 1e2f49082eef7056a8b067b4f1da357eabed8689 (patch) | |
| tree | b1c1234b62acd762ba47c0295c0749301fc3b8d3 /sql | |
| parent | 753affc591524c05c2db6f88b518e510d36f829c (diff) | |
DB/Creature: Fix Brazie Gatz
By Exodius, closes #13237
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2014_11_12_01_world.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/sql/updates/world/2014_11_12_01_world.sql b/sql/updates/world/2014_11_12_01_world.sql new file mode 100644 index 00000000000..d34ce5b4dbf --- /dev/null +++ b/sql/updates/world/2014_11_12_01_world.sql @@ -0,0 +1,12 @@ +-- Insert "Brazie's Black Book of Secrets" into Brazie Getz's vendor table +DELETE FROM `npc_vendor` WHERE `entry`=37904 AND `item`=49926; +INSERT INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `VerifiedBuild`) VALUES +(37904, 49926, 0, 0, 0, 0); +-- Add various Brazie's "guides" inside "Brazie's Black Book of Secrets" +DELETE FROM `item_loot_template` WHERE `Entry`=49926 AND `Item` IN (49918, 49922, 49923, 49924, 49925); +INSERT INTO `item_loot_template` (`Entry`, `Item`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`) VALUES +(49926, 49918, 100, 0, 1, 0, 1, 1), -- Brazie's Guide to Getting Good with Gnomish Girls +(49926, 49922, 100, 0, 1, 0, 1, 1), -- Brazie's Dictionary of Devilish Draenei Damsels +(49926, 49923, 100, 0, 1, 0, 1, 1), -- Brazie's Document on Dwarven Dates in Dun Morogh +(49926, 49924, 100, 0, 1, 0, 1, 1), -- Brazie's Notes on Naughty Night Elves +(49926, 49925, 100, 0, 1, 0, 1, 1); -- Brazie's Handbook to Handling Human Hunnies |