diff options
| author | Ovahlord <dreadkiller@gmx.de> | 2024-12-14 22:04:22 +0100 |
|---|---|---|
| committer | Ovahlord <dreadkiller@gmx.de> | 2024-12-16 16:43:28 +0100 |
| commit | 0bf3ca2a18054f13775cd7a163c4879270aef973 (patch) | |
| tree | cd8eaa0e58b34096cad99f65a5fddcf7cb5aa33e | |
| parent | 4566661d75c01db1a30c1b0e50974c1e03b019e9 (diff) | |
Core/Quests: assign a unique alias to ID fields loaded from quest_visual_effect
| -rw-r--r-- | src/server/game/Globals/ObjectMgr.cpp | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/server/game/Globals/ObjectMgr.cpp b/src/server/game/Globals/ObjectMgr.cpp index 919030967d0..5b2066d22a1 100644 --- a/src/server/game/Globals/ObjectMgr.cpp +++ b/src/server/game/Globals/ObjectMgr.cpp @@ -4413,8 +4413,8 @@ void ObjectMgr::LoadQuests() } // Load `quest_visual_effect` join table with quest_objectives because visual effects are based on objective ID (core stores objectives by their index in quest) - // 0 1 2 3 4 - result = WorldDatabase.Query("SELECT v.ID, o.ID, o.QuestID, v.Index, v.VisualEffect FROM quest_visual_effect AS v LEFT JOIN quest_objectives AS o ON v.ID = o.ID ORDER BY v.Index DESC"); + // 0 1 2 3 4 + result = WorldDatabase.Query("SELECT v.ID AS vID, o.ID AS oID, o.QuestID, v.Index, v.VisualEffect FROM quest_visual_effect AS v LEFT JOIN quest_objectives AS o ON v.ID = o.ID ORDER BY v.Index DESC"); if (!result) { |