DB/Loot: Fix fishing loots for some areas

Closes #11251

(cherry picked from commit c7476f335fa467cdab4540bcaa673cbe6cdd9647)

1 files changed, 55 insertions, 0 deletions

diff --git a/sql/updates/world/master/2021_06_19_04_world_2018_02_04_02_world.sql b/sql/updates/world/master/2021_06_19_04_world_2018_02_04_02_world.sql
new file mode 100644
index 00000000000..014a52c7783
--- /dev/null
+++ b/sql/updates/world/master/2021_06_19_04_world_2018_02_04_02_world.sql
@@ -0,0 +1,55 @@
+-- 
+DELETE FROM `reference_loot_template` WHERE `entry`=11001;
+INSERT INTO `reference_loot_template` (`Entry`, `Item`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`) VALUES
+(11001, 118, 0.5  , 0, 1, 1, 1, 1),
+(11001, 159, 0.1  , 0, 1, 1, 1, 1),
+(11001, 774, 0.1  , 0, 1, 1, 1, 1),
+(11001, 1423, 0.1 , 0, 1, 1, 1, 1),
+(11001, 2407, 0.1 , 0, 1, 1, 1, 1),
+(11001, 2455, 0.5 , 0, 1, 1, 1, 1),
+(11001, 2589, 0.5 , 0, 1, 1, 1, 1),
+(11001, 4540, 0.1 , 0, 1, 1, 1, 1),
+(11001, 4565, 0.1 , 0, 1, 1, 1, 1),
+(11001, 4757, 0.1 , 0, 1, 1, 1, 1),
+(11001, 4775, 0.1 , 0, 1, 1, 1, 1),
+(11001, 4814, 0.1 , 0, 1, 1, 1, 1),
+(11001, 5523, 0.1 , 0, 1, 1, 1, 1),
+(11001, 6289, 30  , 0, 1, 1, 1, 1),
+(11001, 6291, 36  , 0, 1, 1, 1, 1),
+(11001, 6292, 0.5 , 0, 1, 1, 1, 1),
+(11001, 6294, 0.5 , 0, 1, 1, 1, 1),
+(11001, 6295, 0.1 , 0, 1, 1, 1, 1),
+(11001, 6303, 15  , 0, 1, 1, 1, 1),
+(11001, 6308, 0.5 , 0, 1, 1, 1, 1),
+(11001, 6356, 2 , 0, 1, 1, 1, 1),
+(11001, 6358, 0.1 , 0, 1, 1, 1, 1),
+(11001, 6361, 0.1 , 0, 1, 1, 1, 1),
+(11001, 6643, 0.1 , 0, 1, 1, 1, 1),
+(11001, 6889, 0.1 , 0, 1, 1, 1, 1),
+(11001, 7096, 0.1 , 0, 1, 1, 1, 1),
+(11001, 7097, 0.1 , 0, 1, 1, 1, 1),
+(11001, 20812, 0.1, 0, 1, 1, 1, 1),
+(11001, 20813, 0.1, 0, 1, 1, 1, 1),
+(11001, 20847, 0.1, 0, 1, 1, 1, 1),
+(11001, 20848, 0.1, 0, 1, 1, 1, 1),
+(11001, 21002, 0.1, 0, 1, 1, 1, 1),
+(11001, 21004, 0.1, 0, 1, 1, 1, 1),
+(11001, 21006, 0.1, 0, 1, 1, 1, 1),
+(11001, 21008, 0.1, 0, 1, 1, 1, 1),
+(11001, 21009, 0.1, 0, 1, 1, 1, 1),
+(11001, 21011, 0.1, 0, 1, 1, 1, 1),
+(11001, 21013, 0.1, 0, 1, 1, 1, 1),
+(11001, 21014, 0.1, 0, 1, 1, 1, 1),
+(11001, 21019, 0.1, 0, 1, 1, 1, 1),
+(11001, 23333, 0.1, 0, 1, 1, 1, 1),
+(11001, 27668, 0.1, 0, 1, 1, 1, 1),
+(11001, 45190, 2  , 0, 1, 1, 1, 1),
+(11001, 45194, 2  , 0, 1, 1, 1, 1),
+(11001, 45195, 0.1, 0, 1, 1, 1, 1),
+(11001, 45196, 2  , 0, 1, 1, 1, 1),
+(11001, 45197, 0.1, 0, 1, 1, 1, 1),
+(11001, 45198, 2  , 0, 1, 1, 1, 1),
+(11001, 45199, 0.1, 0, 1, 1, 1, 1),
+(11001, 45200, 2  , 0, 1, 1, 1, 1),
+(11001, 45201, 0.1, 0, 1, 1, 1, 1),
+(11001, 45202, 0.1, 0, 1, 1, 1, 1);