From bc230894a8a72be188445c7ff94f175e920302e3 Mon Sep 17 00:00:00 2001 From: Jildor Date: Tue, 1 Nov 2022 20:30:58 +0100 Subject: DB/Loot: Ulduar - Freya: Freya's Gift (2 Elder): Fix wrong id for loot of Fragment of Val'anyr Closes #28186 (cherry picked from commit 3667bcf38d4298bc28d521e54c30d50953cf1ff5) --- sql/updates/world/master/2023_01_12_12_world_2022_11_01_02_world.sql | 4 ++++ 1 file changed, 4 insertions(+) create mode 100644 sql/updates/world/master/2023_01_12_12_world_2022_11_01_02_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2023_01_12_12_world_2022_11_01_02_world.sql b/sql/updates/world/master/2023_01_12_12_world_2022_11_01_02_world.sql new file mode 100644 index 00000000000..5d5f4673e78 --- /dev/null +++ b/sql/updates/world/master/2023_01_12_12_world_2022_11_01_02_world.sql @@ -0,0 +1,4 @@ +-- Remove wrong Ulduar Recipes from Kologarn 10N Chest +DELETE FROM `gameobject_loot_template` WHERE `Entry`=27061 AND `Reference`=34154; +-- Ulduar - Freya: Freya's Gift 25 (2 Elder): Fix wrong id for loot of Fragment of Val'anyr +UPDATE `gameobject_loot_template` SET `Entry`=26961 WHERE `Entry`=27061 AND `Item`=45038; -- cgit v1.2.3