diff options
| author | Killyana <morphone1@gmail.com> | 2020-05-01 13:10:14 +0200 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2020-05-01 13:10:14 +0200 |
| commit | c3981f09d399ce44234417f3851bf323368a36a2 (patch) | |
| tree | 9d390df9ebd1b09a7168f559b243a7c63a2055b8 | |
| parent | d3578c34743fe1016bf657d9c13d509534ff2c7b (diff) | |
DB/Fishing: Update fishing skills level and loots in Molten Core, Blackrock Spire, Blackrock Depths, Blackrock Mountain and Burning Steppes
| -rw-r--r-- | sql/updates/world/3.3.5/2020_05_01_00_world_335.sql | 26 |
1 files changed, 26 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2020_05_01_00_world_335.sql b/sql/updates/world/3.3.5/2020_05_01_00_world_335.sql new file mode 100644 index 00000000000..356d38d69b3 --- /dev/null +++ b/sql/updates/world/3.3.5/2020_05_01_00_world_335.sql @@ -0,0 +1,26 @@ +-- +DELETE FROM `fishing_loot_template` WHERE `entry` IN (46,25,249,1584,2717,1583); +INSERT INTO `fishing_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`) VALUES +(249, 11010,11010,100,1,1,1,1), +(25, 3857, 0, 95, 1, 0, 1, 1), +(25, 6297, 0, 100, 32768, 0, 1, 1), +(25, 7078, 0, 5, 1, 0, 1, 1), +(46, 3857, 0, 95, 1, 0, 1, 1), +(46, 6297, 0, 100, 32768, 0, 1, 1), +(46, 7078, 0, 5, 1, 0, 1, 1), +(1584, 3857, 0, 95, 1, 0, 1, 1), +(1584, 6297, 0, 100, 32768, 0, 1, 1), +(1584, 7078, 0, 5, 1, 0, 1, 1), +(2717, 3857, 0, 95, 1, 0, 1, 1), +(2717, 6297, 0, 100, 32768, 0, 1, 1), +(2717, 7078, 0, 5, 1, 0, 1, 1), +(1583, 3857, 0, 95, 1, 0, 1, 1), +(1583, 6297, 0, 100, 32768, 0, 1, 1), +(1583, 7078, 0, 5, 1, 0, 1, 1); + +DELETE FROM `skill_fishing_base_level` WHERE `entry` IN (25,1584,2717,1583); +INSERT INTO `skill_fishing_base_level` (`entry`, `skill`) VALUES +(25, 425), +(1584, 425), +(2717, 425), +(1583, 425); |