void WorldSession::HandleCharDeleteOpcode( WorldPacket & recv_data )
{
CHECK_PACKET_SIZE(recv_data, 8);
uint8 fail = CHAR_DELETE_SUCCESS;
uint64 guid;
recv_data >> guid;
if( objmgr.GetPlayer( (uint32)guid) != NULL )
{
fail = CHAR_DELETE_FAILED;
} else {
PlayerInfo * inf = objmgr.GetPlayerInfo((uint32)guid);
if( inf != NULL && inf->m_loggedInPlayer == NULL )
{
QueryResult * result = CharacterDatabase.Query("SELECT name FROM characters WHERE guid = %u AND acct = %u", (uint32)guid, _accountId);
if(!result)
return;
if(inf->guild)
{
if(inf->guild->GetGuildLeader()==inf->guid)
inf->guild->Disband();
else
inf->guild->RemoveGuildMember(inf,NULL);
}
string name = result->Fetch()[0].GetString();
delete result;
for(int i = 0; i < NUM_CHARTER_TYPES; ++i)
{
Charter * c = objmgr.GetCharterByGuid(guid, (CharterTypes)i);
if(c != NULL)
c->RemoveSignature((uint32)guid);
}
for(int i = 0; i < NUM_ARENA_TEAM_TYPES; ++i)
{
ArenaTeam * t = objmgr.GetArenaTeamByGuid((uint32)guid, i);
if(t != NULL)
t->RemoveMember(inf);
}
/*if( _socket != NULL )
sPlrLog.write("Account: %s | IP: %s >> Deleted player %s", GetAccountName().c_str(), GetSocket()->GetRemoteIP().c_str(), name.c_str());*/
sPlrLog.writefromsession(this, "deleted character %s (GUID: %u)", name.c_str(), (uint32)guid);
CharacterDatabase.WaitExecute("DELETE FROM characters WHERE guid = %u", (uint32)guid);
Corpse * c=objmgr.GetCorpseByOwner((uint32)guid);
if(c)
CharacterDatabase.Execute("DELETE FROM corpses WHERE guid = %u", c->GetLowGUID());
CharacterDatabase.Execute("DELETE FROM playeritems WHERE ownerguid=%u",(uint32)guid);
CharacterDatabase.Execute("DELETE FROM gm_tickets WHERE playerGuid = %u", (uint32)guid);
CharacterDatabase.Execute("DELETE FROM playerpets WHERE ownerguid = %u", (uint32)guid);
CharacterDatabase.Execute("DELETE FROM playerpetspells WHERE ownerguid = %u", (uint32)guid);
CharacterDatabase.Execute("DELETE FROM tutorials WHERE playerId = %u", (uint32)guid);
CharacterDatabase.Execute("DELETE FROM questlog WHERE player_guid = %u", (uint32)guid);
CharacterDatabase.Execute("DELETE FROM playercooldowns WHERE player_guid = %u", (uint32)guid);
CharacterDatabase.Execute("DELETE FROM mailbox WHERE player_guid = %u", (uint32)guid);
CharacterDatabase.Execute("DELETE FROM social_friends WHERE character_guid = %u OR friend_guid = %u", (uint32)guid, (uint32)guid);
CharacterDatabase.Execute("DELETE FROM social_ignores WHERE character_guid = %u OR ignore_guid = %u", (uint32)guid, (uint32)guid);
/* remove player info */
objmgr.DeletePlayerInfo((uint32)guid);
}
else
fail = CHAR_DELETE_FAILED;
_side = -1; // ceberwow added it
}
OutPacket(SMSG_CHAR_DELETE, 1, &fail);
}
uint8 WorldSession::DeleteCharacter(uint32 guid)
{
PlayerInfo * inf = objmgr.GetPlayerInfo(guid);
if( inf != NULL && inf->m_loggedInPlayer == NULL )
{
QueryResult * result = CharacterDatabase.Query("SELECT name FROM characters WHERE guid = %u AND acct = %u", (uint32)guid, _accountId);
if(!result)
return CHAR_DELETE_FAILED;
if(inf->GuildId)
{
GuildMember* gMember = guildmgr.GetGuildMember(inf->guid);
if(gMember->pRank->iId == 0)
return CHAR_DELETE_FAILED_GUILD_LEADER;
else
guildmgr.RemoveMember(NULL, inf);
}
string name = result->Fetch()[0].GetString();
delete result;
for(int i = 0; i < NUM_CHARTER_TYPES; i++)
{
if( inf->charterId[i] != 0 )
{
Charter *pCharter = guildmgr.GetCharter(inf->charterId[i], (CharterTypes)i);
if( pCharter->LeaderGuid == inf->guid )
pCharter->Destroy();
else
pCharter->RemoveSignature(inf->guid);
}
}
for(int i = 0; i < NUM_ARENA_TEAM_TYPES; i++)
{
if( inf->arenaTeam[i] != NULL )
{
if( inf->arenaTeam[i]->m_leader == guid )
return CHAR_DELETE_FAILED_ARENA_CAPTAIN;
else
inf->arenaTeam[i]->RemoveMember(inf);
}
}
/*if( _socket != NULL )
sPlrsLog.write("Account: %s | IP: %s >> Deleted player %s", GetAccountName().c_str(), GetSocket()->GetRemoteIP().c_str(), name.c_str());*/
sWorld.LogPlayer(this, "deleted character %s (GUID: %u)", name.c_str(), (uint32)guid);
/* if ( sWorld.char_restore_enabled )
{
//insert data into "deleted" tables
CharacterDatabase.WaitExecute("INSERT INTO characters_deleted SELECT UNIX_TIMESTAMP(NOW()),characters.* FROM characters WHERE guid = %u", (uint32)guid);
CharacterDatabase.WaitExecute("INSERT INTO playerglyphs_deleted SELECT playerglyphs.* FROM playerglyphs WHERE guid = %u", (uint32)guid);
CharacterDatabase.WaitExecute("INSERT INTO playeritems_deleted SELECT playeritems.* FROM playeritems WHERE ownerguid = %u", (uint32)guid);
CharacterDatabase.WaitExecute("INSERT INTO playerskills_deleted SELECT playerskills.* FROM playerskills WHERE player_guid = %u", (uint32)guid);
CharacterDatabase.WaitExecute("INSERT INTO playerspells_deleted SELECT playerspells.* FROM playerspells WHERE guid = %u", (uint32)guid);
CharacterDatabase.WaitExecute("INSERT INTO playertalents_deleted SELECT playertalents.* FROM playertalents WHERE guid = %u", (uint32)guid);
CharacterDatabase.WaitExecute("INSERT INTO questlog_deleted SELECT questlog.* FROM questlog WHERE player_guid = %u", (uint32)guid);
}*/
CharacterDatabase.WaitExecute("DELETE FROM characters WHERE guid = %u", (uint32)guid);
Corpse* c=objmgr.GetCorpseByOwner((uint32)guid);
if(c)
CharacterDatabase.Execute("DELETE FROM corpses WHERE guid = %u", c->GetLowGUID());
CharacterDatabase.Execute("DELETE FROM achievements WHERE player = %u", (uint32)guid);
CharacterDatabase.Execute("DELETE FROM auctions WHERE owner = %u", (uint32)guid);
CharacterDatabase.Execute("DELETE FROM charters WHERE leaderGuid = %u", (uint32)guid);
CharacterDatabase.Execute("DELETE FROM gm_tickets WHERE guid = %u", (uint32)guid);
CharacterDatabase.Execute("DELETE FROM guild_data WHERE playerid = %u", (uint32)guid);
CharacterDatabase.Execute("DELETE FROM instances WHERE creator_guid = %u", (uint32)guid);
CharacterDatabase.Execute("DELETE FROM mailbox WHERE player_guid = %u", (uint32)guid);
CharacterDatabase.Execute("DELETE FROM playercooldowns WHERE player_guid = %u", (uint32)guid);
CharacterDatabase.Execute("DELETE FROM playerglyphs WHERE guid = %u", (uint32)guid);
CharacterDatabase.Execute("DELETE FROM playeritems WHERE ownerguid=%u",(uint32)guid);
CharacterDatabase.Execute("DELETE FROM playerpets WHERE ownerguid = %u", (uint32)guid);
CharacterDatabase.Execute("DELETE FROM playerpetspells WHERE ownerguid = %u", (uint32)guid);
CharacterDatabase.Execute("DELETE FROM playerskills WHERE player_guid = %u", (uint32)guid);
CharacterDatabase.Execute("DELETE FROM playerspells WHERE guid = %u", (uint32)guid);
CharacterDatabase.Execute("DELETE FROM playersummonspells WHERE ownerguid = %u", (uint32)guid);
CharacterDatabase.Execute("DELETE FROM playertalents WHERE guid = %u", (uint32)guid);
CharacterDatabase.Execute("DELETE FROM questlog WHERE player_guid = %u", (uint32)guid);
CharacterDatabase.Execute("DELETE FROM social_friends WHERE character_guid = %u OR friend_guid = %u", (uint32)guid, (uint32)guid);
CharacterDatabase.Execute("DELETE FROM social_ignores WHERE character_guid = %u OR ignore_guid = %u", (uint32)guid, (uint32)guid);
CharacterDatabase.Execute("DELETE FROM tutorials WHERE playerId = %u", (uint32)guid);
/* remove player info */
objmgr.DeletePlayerInfo((uint32)guid);
return CHAR_DELETE_SUCCESS;
}
return CHAR_DELETE_FAILED;
}
uint8 WorldSession::DeleteCharacter(uint32 guid)
{
PlayerInfo* inf = objmgr.GetPlayerInfo(guid);
if (inf != NULL && inf->m_loggedInPlayer == NULL)
{
QueryResult* result = CharacterDatabase.Query("SELECT name FROM characters WHERE guid = %u AND acct = %u", (uint32)guid, _accountId);
if (!result)
return E_CHAR_DELETE_FAILED;
string name = result->Fetch()[0].GetString();
delete result;
if (inf->guild)
{
if (inf->guild->GetGuildLeader() == inf->guid)
return E_CHAR_DELETE_FAILED_GUILD_LEADER;
else
inf->guild->RemoveGuildMember(inf, NULL);
}
for (int i = 0; i < NUM_CHARTER_TYPES; ++i)
{
Charter* c = objmgr.GetCharterByGuid(guid, (CharterTypes)i);
if (c != NULL)
c->RemoveSignature((uint32)guid);
}
for (int i = 0; i < NUM_ARENA_TEAM_TYPES; ++i)
{
ArenaTeam* t = objmgr.GetArenaTeamByGuid((uint32)guid, i);
if (t != NULL && t->m_leader == guid)
return E_CHAR_DELETE_FAILED_ARENA_CAPTAIN;
if (t != NULL)
t->RemoveMember(inf);
}
/*if( _socket != NULL )
sPlrLog.write("Account: %s | IP: %s >> Deleted player %s", GetAccountName().c_str(), GetSocket()->GetRemoteIP().c_str(), name.c_str());*/
sPlrLog.writefromsession(this, "deleted character %s (GUID: %u)", name.c_str(), (uint32)guid);
CharacterDatabase.WaitExecute("DELETE FROM characters WHERE guid = %u", (uint32)guid);
Corpse* c = objmgr.GetCorpseByOwner((uint32)guid);
if (c)
CharacterDatabase.Execute("DELETE FROM corpses WHERE guid = %u", c->GetLowGUID());
CharacterDatabase.Execute("DELETE FROM playeritems WHERE ownerguid=%u", (uint32)guid);
CharacterDatabase.Execute("DELETE FROM gm_tickets WHERE playerguid = %u", (uint32)guid);
CharacterDatabase.Execute("DELETE FROM playerpets WHERE ownerguid = %u", (uint32)guid);
CharacterDatabase.Execute("DELETE FROM playerpetspells WHERE ownerguid = %u", (uint32)guid);
CharacterDatabase.Execute("DELETE FROM tutorials WHERE playerId = %u", (uint32)guid);
CharacterDatabase.Execute("DELETE FROM questlog WHERE player_guid = %u", (uint32)guid);
CharacterDatabase.Execute("DELETE FROM playercooldowns WHERE player_guid = %u", (uint32)guid);
CharacterDatabase.Execute("DELETE FROM mailbox WHERE player_guid = %u", (uint32)guid);
CharacterDatabase.Execute("DELETE FROM social_friends WHERE character_guid = %u OR friend_guid = %u", (uint32)guid, (uint32)guid);
CharacterDatabase.Execute("DELETE FROM social_ignores WHERE character_guid = %u OR ignore_guid = %u", (uint32)guid, (uint32)guid);
CharacterDatabase.Execute("DELETE FROM character_achievement WHERE guid = '%u' AND achievement NOT IN (457, 467, 466, 465, 464, 463, 462, 461, 460, 459, 458, 1404, 1405, 1406, 1407, 1408, 1409, 1410, 1411, 1412, 1413, 1415, 1414, 1416, 1417, 1418, 1419, 1420, 1421, 1422, 1423, 1424, 1425, 1426, 1427, 1463, 1400, 456, 1402)", (uint32)guid);
CharacterDatabase.Execute("DELETE FROM character_achievement_progress WHERE guid = '%u'", (uint32)guid);
CharacterDatabase.Execute("DELETE FROM playerspells WHERE GUID = '%u'", guid);
CharacterDatabase.Execute("DELETE FROM playerdeletedspells WHERE GUID = '%u'", guid);
CharacterDatabase.Execute("DELETE FROM playerreputations WHERE guid = '%u'", guid);
CharacterDatabase.Execute("DELETE FROM playerskills WHERE GUID = '%u'", guid);
/* remove player info */
objmgr.DeletePlayerInfo((uint32)guid);
return E_CHAR_DELETE_SUCCESS;
}
return E_CHAR_DELETE_FAILED;
}