From 0be7096b240e9d285e3e47bb4f28e04a341ef8b8 Mon Sep 17 00:00:00 2001 From: ModoX Date: Tue, 4 Oct 2022 23:28:39 +0200 Subject: Core/Groups: Removed group_instance row deletion of empty groups * table does no longer exist ref 9b924522d0549dd67b10e2cbdfc20297dd21e182 Closes #28331 --- src/server/game/Groups/GroupMgr.cpp | 3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) (limited to 'src') diff --git a/src/server/game/Groups/GroupMgr.cpp b/src/server/game/Groups/GroupMgr.cpp index 69fbe8e4d21..3b0e79a09cf 100644 --- a/src/server/game/Groups/GroupMgr.cpp +++ b/src/server/game/Groups/GroupMgr.cpp @@ -135,9 +135,8 @@ void GroupMgr::LoadGroups() CharacterDatabase.DirectExecute("DELETE FROM `groups` WHERE leaderGuid NOT IN (SELECT guid FROM characters)"); // Delete all groups with less than 2 members CharacterDatabase.DirectExecute("DELETE FROM `groups` WHERE guid NOT IN (SELECT guid FROM group_member GROUP BY guid HAVING COUNT(guid) > 1)"); - // Delete all rows from group_member or group_instance with no group + // Delete all rows from group_member with no group CharacterDatabase.DirectExecute("DELETE FROM group_member WHERE guid NOT IN (SELECT guid FROM `groups`)"); - CharacterDatabase.DirectExecute("DELETE FROM group_instance WHERE guid NOT IN (SELECT guid FROM `groups`)"); // 0 1 2 3 4 5 6 7 8 9 QueryResult result = CharacterDatabase.Query("SELECT g.leaderGuid, g.lootMethod, g.looterGuid, g.lootThreshold, g.icon1, g.icon2, g.icon3, g.icon4, g.icon5, g.icon6" -- cgit v1.2.3