diff options
| author | Teppic1 <Teppic1@users.noreply.github.com> | 2018-02-04 14:26:34 +0100 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2018-02-04 14:26:34 +0100 |
| commit | 0f3c30e0a4f815cb059385526372f9952836af33 (patch) | |
| tree | c8181a0874564e8cb8e69e8493e39121f6983e0c | |
| parent | aefc25482f79e07e1237cc0a6c01e7064fd745be (diff) | |
DB/Loot: Redo Prowler table and remove exploit
Closes #21341
| -rw-r--r-- | sql/updates/world/3.3.5/2018_02_04_00_world_335.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2018_02_04_00_world_335.sql b/sql/updates/world/3.3.5/2018_02_04_00_world_335.sql new file mode 100644 index 00000000000..68427c0650a --- /dev/null +++ b/sql/updates/world/3.3.5/2018_02_04_00_world_335.sql @@ -0,0 +1,11 @@ +-- +DELETE FROM `creature_loot_template` WHERE `Entry`=118; +INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(118, 777, 0, 25, 0, 1, 1, 1, 1, "Prowler teeth"), -- Prowler teeth +(118, 2672, 0, 85, 0, 1, 0, 1, 1, "Stringy wolf meat"), -- Stringy wolf meat +(118, 3299, 0, 15, 0, 1, 1, 1, 1, "Fractured canine"), -- Fractured canine +(118, 3300, 0, 25, 0, 1, 1, 1, 1, "Rabbit's foot"), -- Rabbit's foot +(118, 24073, 24073, 2, 0, 1, 2, 1, 1, "Junk"), -- Junk +(118, 24074, 24074, 1, 0, 1, 2, 1, 1, "Greens ilvl 10-11"), -- Greens ilvl 10-11 +(118, 24075, 24075, 0.5, 0, 1, 2, 1, 1, "Greens ilvl 12-13"), -- Greens ilvl 12-13 +(118, 11111, 11111, 0.1, 0, 1, 0, 1, 1, "Bags"); -- Bags |