From e650402a5e6d27dbe1bcaa088f7ce529cc7e9403 Mon Sep 17 00:00:00 2001 From: Killyana Date: Mon, 8 Apr 2019 00:55:20 +0200 Subject: DB/Fishing: The Obsidian Sanctum (cherry picked from commit 0adfda655178d5e6a2162461a9239972d65a2d35) --- .../world/master/2021_11_26_19_world_2019_04_07_05_world.sql | 9 +++++++++ 1 file changed, 9 insertions(+) create mode 100644 sql/updates/world/master/2021_11_26_19_world_2019_04_07_05_world.sql (limited to 'sql') 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"); -- cgit v1.2.3