From 7f4039269c2ea46ada468f75f847acf19293144b Mon Sep 17 00:00:00 2001 From: Shocker Date: Fri, 5 Nov 2010 00:54:17 +0200 Subject: Core/Groups: Fix issue with raid-leader being removed from group on relog/server restart. Updates issue 3142 --HG-- branch : trunk --- src/server/game/Groups/Group.cpp | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'src/server/game/Groups/Group.cpp') diff --git a/src/server/game/Groups/Group.cpp b/src/server/game/Groups/Group.cpp index 1448b88bdfe..54a4779e06f 100755 --- a/src/server/game/Groups/Group.cpp +++ b/src/server/game/Groups/Group.cpp @@ -119,7 +119,8 @@ bool Group::Create(const uint64 &guid, const char * name) // store group in database SQLTransaction trans = CharacterDatabase.BeginTransaction(); trans->PAppend("DELETE FROM groups WHERE guid ='%u'", lowguid); - trans->PAppend("DELETE FROM group_member WHERE guid ='%u'", lowguid); + trans->PAppend("DELETE FROM group_member WHERE guid = %u OR memberGuid = %u", lowguid, GUID_LOPART(guid)); + trans->PAppend("INSERT INTO group_member (guid, memberGuid, subgroup) VALUES (%u, %u, 0)", lowguid, GUID_LOPART(guid)); trans->PAppend("INSERT INTO groups (guid,leaderGuid,lootMethod,looterGuid,lootThreshold,icon1,icon2,icon3,icon4,icon5,icon6,icon7,icon8,groupType,difficulty,raiddifficulty) " "VALUES ('%u','%u','%u','%u','%u','" UI64FMTD "','" UI64FMTD "','" UI64FMTD "','" UI64FMTD "','" UI64FMTD "','" UI64FMTD "','" UI64FMTD "','" UI64FMTD "','%u','%u','%u')", lowguid, GUID_LOPART(m_leaderGuid), uint32(m_lootMethod), -- cgit v1.2.3