diff options
| author | Teppic1 <Teppic1@users.noreply.github.com> | 2018-02-08 17:25:03 +0100 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2018-02-08 17:25:03 +0100 |
| commit | c49003ac8b64ca1ca27ee83b7bcd820c75a246b6 (patch) | |
| tree | c4806f15e29ebb87927ac75013e06cff26c6c461 | |
| parent | 31ad6358fb9088583142d108d2649d0c94b43358 (diff) | |
DB/Loot: Reference template 24060 corrections
Closes #21363
| -rw-r--r-- | sql/updates/world/3.3.5/2018_02_08_00_world_335.sql | 23 |
1 files changed, 23 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2018_02_08_00_world_335.sql b/sql/updates/world/3.3.5/2018_02_08_00_world_335.sql new file mode 100644 index 00000000000..5046c175235 --- /dev/null +++ b/sql/updates/world/3.3.5/2018_02_08_00_world_335.sql @@ -0,0 +1,23 @@ +-- Remove unique items from reference table 24060, as well as removing Agile Boots (4788) which is sold only and does not drop +DELETE FROM `reference_loot_template` WHERE `Entry`=24060 AND `Item` IN (1218, 1220, 1296, 1300, 1448, 1460, 1934, 2021, 2166, 2167, 2168, 3018, 3227, 4788, 4949, 5182, 5183); + +-- Add former items from reference table 24060 to their proper NPCs, as well as removing 4788 which is sold only and does not drop +DELETE FROM `creature_loot_template` WHERE `Item` IN (1218, 1220, 1296, 1300, 1448, 1460, 1934, 2021, 2166, 2167, 2168, 3018, 3227, 4788, 4949, 5182, 5183); +INSERT INTO `creature_loot_template` (`Entry`,`Item`,`Chance`,`GroupId`,`Comment`) VALUES +(445, 1218, 0.1, 0, "Redridge Alpha - Heavy Gnoll War Club"), +(580, 1220, 0.1, 0, "Redridge Drudger - Lupine Axe"), +(437, 1296, 0.1, 0, "Blackrock Renegade - Blackrock Mace"), +(4065, 1296, 0.1, 0, "Blackrock Sentry - Blackrock Mace"), +(436, 1300, 0.1, 0, "Blackrock Shadowcaster - Lesser Staff of the Spire"), +(485, 1448, 0.1, 0, "Blackrock Outrunner - Blackrock Gauntlets"), +(434, 1460, 0.1, 0, "Rabid Shadowhide Gnoll - Shadowhide Two-handed Sword"), +(636, 1934, 0.1, 0, "Defias Blackguard - Stonemason Trousers"), +(569, 2021, 0.1, 0, "Green Recluse - Green Carapace Shield"), +(626, 2166, 2, 2, "Foreman Thistlenettle - Foreman's Leggings"), +(626, 2167, 2, 2, "Foreman Thistlenettle - Foreman's Gloves"), +(626, 2168, 2, 2, "Foreman Thistlenettle - Foreman's Boots"), +(521, 3018, 2, 2, "Lupos - Hide of Lupos"), +(521, 3227, 2, 2, "Lupos - Nightbane Staff"), +(7170, 4949, 100, 0, "Thragomm - Orcish Cleaver"), +(3398, 5182, 2, 2, "Gesharahan - Shiver Blade"), +(3398, 5183, 2, 2, "Gesharahan - Pulsating Hydra Heart"); |