diff options
| author | Teppic1 <Teppic1@users.noreply.github.com> | 2019-06-24 17:48:15 +0200 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2019-06-24 17:48:15 +0200 |
| commit | ab7665e93f91db316f028613bacfdc3a69a436ac (patch) | |
| tree | 0e8abbc3093ea45846a5646e96b8dfc4fa656e00 | |
| parent | 86b5b1b8685eb4ec26d2e479df8c7b4e91b9b4b7 (diff) | |
DB/loot: Crag Boar
Closes #23389
| -rw-r--r-- | sql/updates/world/3.3.5/2019_06_24_01_world_335.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2019_06_24_01_world_335.sql b/sql/updates/world/3.3.5/2019_06_24_01_world_335.sql new file mode 100644 index 00000000000..15db2bd6e46 --- /dev/null +++ b/sql/updates/world/3.3.5/2019_06_24_01_world_335.sql @@ -0,0 +1,12 @@ +-- Crag boar +DELETE FROM `creature_loot_template` WHERE `Entry`=1125; +INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(1125, 2886, 0, 45, 0, 1, 1, 1, 1, "Crag Boar Rib"), +(1125, 769, 0, 35, 0, 1, 1, 1, 1, "Chunk of Boar Meat"), +(1125, 117, 0, 10, 0, 1, 1, 1, 1, "Tough Jerky"), +(1125, 771, 0, 35, 0, 1, 0, 1, 1, "Chipped Boar Tusk"), +(1125, 3171, 0, 35, 0, 1, 0, 1, 1, "Broken Boar Tusk"), +(1125, 24073, 24073, 2.5, 0, 1, 2, 1, 1, "Junk gear"), +(1125, 24700, 24700, 1, 0 ,1, 2, 1, 1, "Patterns"), +(1125, 24701, 24701, 1, 0 ,1, 2, 1, 1, "Patterns"), +(1125, 11111, 11111, 0.1, 0, 1, 3, 1, 1, "Bags"); |