DB/Fishing: Update fishing skills level and loots in Molten Core, Blackrock Spire, Blackrock Depths, Blackrock Mountain and Burning Steppes

(cherry picked from commit c3981f09d399ce44234417f3851bf323368a36a2)

1 files changed, 26 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_01_01_41_world_2020_05_01_00_world_335.sql b/sql/updates/world/master/2022_01_01_41_world_2020_05_01_00_world_335.sql
new file mode 100644
index 00000000000..356d38d69b3
--- /dev/null
+++ b/sql/updates/world/master/2022_01_01_41_world_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);