aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorJildor <Jildor@users.noreply.github.com>2022-11-01 20:30:58 +0100
committerShauren <shauren.trinity@gmail.com>2023-01-12 22:55:16 +0100
commitbc230894a8a72be188445c7ff94f175e920302e3 (patch)
tree18483ddcf781f35ee5bcaecd0b9eeda23a013046 /sql
parentae3071c35887bf697c45b8c1ccef84e84bf3c530 (diff)
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)
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/master/2023_01_12_12_world_2022_11_01_02_world.sql4
1 files changed, 4 insertions, 0 deletions
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;