aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorJildor <Jildor@users.noreply.github.com>2022-11-01 20:30:58 +0100
committerKillyana <morphone1@gmail.com>2022-11-01 20:30:58 +0100
commit3667bcf38d4298bc28d521e54c30d50953cf1ff5 (patch)
treecaf2719dbd5f296676014fbdea351c8f388568a5
parent2620867bb30e92a115f60a1f5691948d940fa782 (diff)
DB/Loot: Ulduar - Freya: Freya's Gift (2 Elder): Fix wrong id for loot of Fragment of Val'anyr
Closes #28186
-rw-r--r--sql/updates/world/3.3.5/2022_11_01_02_world.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2022_11_01_02_world.sql b/sql/updates/world/3.3.5/2022_11_01_02_world.sql
new file mode 100644
index 00000000000..5d5f4673e78
--- /dev/null
+++ b/sql/updates/world/3.3.5/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;