DB/Fishing: The Obsidian Sanctum

(cherry picked from commit 0adfda655178d5e6a2162461a9239972d65a2d35)

1 files changed, 9 insertions, 0 deletions

diff --git a/sql/updates/world/master/2021_11_26_19_world_2019_04_07_05_world.sql b/sql/updates/world/master/2021_11_26_19_world_2019_04_07_05_world.sql
new file mode 100644
index 00000000000..50d39950c69
--- /dev/null
+++ b/sql/updates/world/master/2021_11_26_19_world_2019_04_07_05_world.sql
@@ -0,0 +1,9 @@
+-- 
+DELETE FROM `skill_fishing_base_level` WHERE `entry`=4493;
+INSERT INTO `skill_fishing_base_level` (`entry`,`skill`) VALUES
+(4493,550);
+DELETE FROM `fishing_loot_template` WHERE `entry`=4493;
+INSERT INTO `fishing_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES 
+(4493, 7078, 0, 4, 0, 1, 0, 1, 1, "The Obsidian Sanctum"),
+(4493, 6297, 0, 100, 0, 32768, 0, 1, 1, "The Obsidian Sanctum"),
+(4493, 3857, 0, 96, 0, 1, 0, 1, 1, "The Obsidian Sanctum");