void DatabaseCleaner::CleanCharacters()
{
set<uint32> chr_guids;
set<uint32> chr_guilds;
set<uint32> chr_charters;
Log.Notice("DatabaseCleaner", "Loading guids...");
QueryResult* result = CharacterDatabase.Query("SELECT guid, guildid, charterId FROM characters");
if (result)
{
do
{
chr_guids.insert(result->Fetch()[0].GetUInt32());
if (result->Fetch()[1].GetUInt32() != 0)
chr_guilds.insert(result->Fetch()[1].GetUInt32());
if (result->Fetch()[2].GetUInt32() != 0)
chr_guilds.insert(result->Fetch()[2].GetUInt32());
} while (result->NextRow());
delete result;
}
Log.Notice("DatabaseCleaner", "Got %u guids.", chr_guids.size());
Log.Notice("DatabaseCleaner", "Cleaning playeritems...");
result = CharacterDatabase.Query("SELECT ownerguid, guid FROM playeritems");
vector<uint64> tokill_items;
if (result)
{
do
{
if (result->Fetch()[0].GetUInt32() != 0 && chr_guids.find(result->Fetch()[0].GetUInt32()) == chr_guids.end())
{
tokill_items.push_back(result->Fetch()[1].GetUInt64());
}
} while (result->NextRow());
delete result;
}
for (vector<uint64>::iterator itr = tokill_items.begin(); itr != tokill_items.end(); ++itr)
{
CharacterDatabase.WaitExecute("DELETE FROM playeritems WHERE guid = " I64FMTD, *itr);
}
Log.Notice("DatabaseCleaner", "Deleted %u item instances.", tokill_items.size());
Log.Notice("DatabaseCleaner", "Cleaning questlog...");
result = CharacterDatabase.Query("SELECT index, player_guid FROM questlog");
vector<uint32> tokill_quests;
if (result)
{
do
{
if (chr_guids.find(result->Fetch()[1].GetUInt32()) == chr_guids.end())
tokill_quests.push_back(result->Fetch()[0].GetUInt32());
} while (result->NextRow());
delete result;
}
for (vector<uint32>::iterator itr = tokill_quests.begin(); itr != tokill_quests.end(); ++itr)
CharacterDatabase.WaitExecute("DELETE FROM questlog WHERE index = %u", *itr);
Log.Notice("DatabaseCleaner", "Deleted %u questlog entries.", tokill_quests.size());
Log.Notice("DatabaseCleaner", "Cleaning corpses...");
vector<uint32> tokill_corpses;
result = CharacterDatabase.Query("SELECT * FROM corpses");
if (result)
{
do
{
Corpse* pCorpse = new Corpse(0, result->Fetch()[0].GetUInt32());
pCorpse->LoadValues(result->Fetch()[8].GetString());
pCorpse->SetLowGUID(0);
if (pCorpse->GetDisplayId() == 0 ||
GET_LOWGUID_PART(pCorpse->GetOwner()) == 0 ||
chr_guids.find(GET_LOWGUID_PART(pCorpse->GetOwner())) == chr_guids.end())
{
tokill_corpses.push_back(pCorpse->GetLowGUID());
}
delete pCorpse;
} while (result->NextRow());
delete result;
}
for (vector<uint32>::iterator itr = tokill_corpses.begin(); itr != tokill_corpses.end(); ++itr)
CharacterDatabase.WaitExecute("DELETE FROM corpses WHERE guid = %u", *itr);
Log.Notice("DatabaseCleaner", "Removed %u corpses.", tokill_corpses.size());
Log.Notice("DatabaseCleaner", "Cleaning mailbox...");
result = CharacterDatabase.Query("SELECT message_id, player_guid FROM mailbox");
vector<uint32> tokill_mail;
if (result)
{
do
{
if (chr_guids.find(result->Fetch()[1].GetUInt32()) == chr_guids.end())
tokill_mail.push_back(result->Fetch()[0].GetUInt32());
} while (result->NextRow());
delete result;
}
for (vector<uint32>::iterator itr = tokill_mail.begin(); itr != tokill_mail.end(); ++itr)
CharacterDatabase.WaitExecute("DELETE FROM mailbox WHERE message_id = %u", *itr);
Log.Notice("DatabaseCleaner", "Deleted %u mail messages.", tokill_mail.size());
Log.Notice("DatabaseCleaner", "Cleaning guilds table...");
result = CharacterDatabase.Query("SELECT guildId FROM guilds");
vector<uint32> tokill_guilds;
if (result)
{
do
{
if (chr_guilds.find(result->Fetch()[0].GetUInt32()) == chr_guilds.end())
{
tokill_guilds.push_back(result->Fetch()[0].GetUInt32());
}
} while (result->NextRow());
delete result;
}
for (vector<uint32>::iterator itr = tokill_guilds.begin(); itr != tokill_guilds.end(); ++itr)
CharacterDatabase.WaitExecute("DELETE FROM guilds WHERE guildId = %u", *itr);
Log.Notice("DatabaseCleaner", "Deleted %u guilds.", tokill_guilds.size());
Log.Notice("DatabaseCleaner", "Cleaning guild_ranks table...");
result = CharacterDatabase.Query("SELECT guildId FROM guild_ranks");
set<uint32> tokill_guildranks;
if (result)
{
do
{
if (chr_guilds.find(result->Fetch()[0].GetUInt32()) == chr_guilds.end())
{
tokill_guildranks.insert(result->Fetch()[0].GetUInt32());
}
} while (result->NextRow());
delete result;
}
for (set<uint32>::iterator itr = tokill_guildranks.begin(); itr != tokill_guildranks.end(); ++itr)
CharacterDatabase.WaitExecute("DELETE FROM guild_ranks WHERE guildId = %u", *itr);
Log.Notice("DatabaseCleaner", "Deleted %u guild rank rows.", tokill_guildranks.size());
Log.Notice("DatabaseCleaner", "Cleaning social table...");
result = CharacterDatabase.Query("SELECT * FROM social");
vector<pair<uint32, uint32> > tokill_social;
if (result)
{
do
{
uint32 g1 = result->Fetch()[0].GetUInt32();
uint32 g2 = result->Fetch()[1].GetUInt32();
if (chr_guids.find(g1) == chr_guids.end() || chr_guids.find(g2) == chr_guids.end())
{
pair<uint32, uint32> x;
x.first = g1;
x.second = g2;
tokill_social.push_back(x);
}
} while (result->NextRow());
delete result;
}
for (vector<pair<uint32, uint32> >::iterator itr = tokill_social.begin(); itr != tokill_social.end(); ++itr)
{
CharacterDatabase.WaitExecute("DELETE FROM social WHERE guid = %u and socialguid = %u", itr->first, itr->second);
}
Log.Notice("DatabaseCleaner", "Deleted %u social entries.", tokill_social.size());
Log.Notice("DatabaseCleaner", "Cleaning cooldown tables...");
set<uint32> tokill_cool;
vector<pair<uint32, uint32> > tokill_cool2;
result = CharacterDatabase.Query("SELECT OwnerGuid, CooldownTimeStamp FROM playercooldownitems");
if (result)
{
uint32 t = getMSTime();
do
{
uint32 guid = result->Fetch()[0].GetUInt32();
uint32 cool = result->Fetch()[1].GetUInt32();
if (chr_guids.find(guid) == chr_guids.end())
tokill_cool.insert(guid);
else if (t >= cool)
tokill_cool2.push_back(make_pair(guid, cool));
} while (result->NextRow());
delete result;
}
for (vector<pair<uint32, uint32> >::iterator itr = tokill_cool2.begin(); itr != tokill_cool2.end(); ++itr)
CharacterDatabase.WaitExecute("DELETE FROM playercooldownitems WHERE OwnerGuid = %u AND CooldownTimeStamp = %u", itr->first, itr->second);
for (set<uint32>::iterator itr = tokill_cool.begin(); itr != tokill_cool.end(); ++itr)
CharacterDatabase.WaitExecute("DELETE FROM playercooldownitems WHERE OwnerGuid = %u", *itr);
Log.Notice("DatabaseCleaner", "Deleted %u playercooldownitems.", tokill_cool.size() + tokill_cool2.size());
tokill_cool.clear();
tokill_cool2.clear();
result = CharacterDatabase.Query("SELECT OwnerGuid, TimeStamp FROM playercooldownsecurity");
if (result)
{
uint32 t = getMSTime();
do
{
uint32 guid = result->Fetch()[0].GetUInt32();
uint32 cool = result->Fetch()[1].GetUInt32();
if (chr_guids.find(guid) == chr_guids.end())
tokill_cool.insert(guid);
else if (t >= cool)
tokill_cool2.push_back(make_pair(guid, cool));
} while (result->NextRow());
delete result;
}
for (vector<pair<uint32, uint32> >::iterator itr = tokill_cool2.begin(); itr != tokill_cool2.end(); ++itr)
CharacterDatabase.WaitExecute("DELETE FROM playercooldownsecurity WHERE OwnerGuid = %u AND TimeStamp = %u", itr->first, itr->second);
for (set<uint32>::iterator itr = tokill_cool.begin(); itr != tokill_cool.end(); ++itr)
CharacterDatabase.WaitExecute("DELETE FROM playercooldownsecurity WHERE OwnerGuid = %u", *itr);
Log.Notice("DatabaseCleaner", "Deleted %u playercooldownsecurities.", tokill_cool.size() + tokill_cool2.size());
Log.Notice("DatabaseCleaner", "Cleaning tutorials...");
vector<uint32> tokill_tutorials;
result = CharacterDatabase.Query("SELECT playerId FROM tutorials");
if (result)
{
do
{
uint32 pi = result->Fetch()[0].GetUInt32();
if (chr_guids.find(pi) == chr_guids.end())
tokill_tutorials.push_back(pi);
} while (result->NextRow());
delete result;
}
for (vector<uint32>::iterator itr = tokill_tutorials.begin(); itr != tokill_tutorials.end(); ++itr)
CharacterDatabase.WaitExecute("DELETE FROM tutorials WHERE playerId = %u", *itr);
Log.Notice("DatabaseCleaner", "Deleted %u tutorials.", tokill_tutorials.size());
Log.Notice("DatabaseCleaner", "Cleaning playerpets...");
set<uint32> tokill_pet;
result = CharacterDatabase.Query("SELECT ownerguid, petnumber FROM playerpets");
if (result)
{
do
{
if (chr_guids.find(result->Fetch()[0].GetUInt32()) == chr_guids.end())
tokill_pet.insert(result->Fetch()[0].GetUInt32());
} while (result->NextRow());
delete result;
}
for (set<uint32>::iterator itr = tokill_pet.begin(); itr != tokill_pet.end(); ++itr)
CharacterDatabase.WaitExecute("DELETE FROM playerpets WHERE ownerguid = %u", *itr);
Log.Notice("DatabaseCleaner", "Deleted %u pets.", tokill_pet.size());
Log.Notice("DatabaseCleaner", "Cleaning playersummonspells...");
set<uint32> tokill_ss;
result = CharacterDatabase.Query("SELECT ownerguid FROM playersummonspells");
if (result)
{
do
{
if (chr_guids.find(result->Fetch()[0].GetUInt32()) == chr_guids.end())
tokill_ss.insert(result->Fetch()[0].GetUInt32());
} while (result->NextRow());
delete result;
}
for (set<uint32>::iterator itr = tokill_ss.begin(); itr != tokill_ss.end(); ++itr)
CharacterDatabase.WaitExecute("DELETE FROM playersummonspells WHERE ownerguid = %u", *itr);
Log.Notice("DatabaseCleaner", "Deleted %u summonspells.", tokill_ss.size());
Log.Notice("DatabaseCleaner", "Cleaning playerpetspells...");
set<uint32> tokill_ps;
result = CharacterDatabase.Query("SELECT ownerguid FROM playerpetspells");
if (result)
{
do
{
if (chr_guids.find(result->Fetch()[0].GetUInt32()) == chr_guids.end())
tokill_ps.insert(result->Fetch()[0].GetUInt32());
} while (result->NextRow());
delete result;
}
for (set<uint32>::iterator itr = tokill_ps.begin(); itr != tokill_ps.end(); ++itr)
CharacterDatabase.WaitExecute("DELETE FROM playerpetspells WHERE ownerguid = %u", *itr);
Log.Notice("DatabaseCleaner", "Deleted %u petspells.", tokill_ps.size());
Log.Notice("DatabaseCleaner", "Cleaning gm_tickets...");
set<uint32> tokill_gm;
result = CharacterDatabase.Query("SELECT guid FROM gm_tickets");
if (result)
{
do
{
if (chr_guids.find(result->Fetch()[0].GetUInt32()) == chr_guids.end())
tokill_gm.insert(result->Fetch()[0].GetUInt32());
} while (result->NextRow());
delete result;
}
for (set<uint32>::iterator itr = tokill_gm.begin(); itr != tokill_gm.end(); ++itr)
CharacterDatabase.WaitExecute("DELETE FROM gm_tickets WHERE guid = %u", *itr);
Log.Notice("DatabaseCleaner", "Deleted %u gm tickets.", tokill_gm.size());
Log.Notice("DatabaseCleaner", "Cleaning charters...");
vector<uint32> tokill_charters;
result = CharacterDatabase.Query("SELECT * FROM charters");
if (result)
{
do
{
if (chr_charters.find(result->Fetch()[0].GetUInt32()) == chr_charters.end() ||
chr_guids.find(result->Fetch()[1].GetUInt32()) == chr_guids.end())
{
tokill_charters.push_back(result->Fetch()[0].GetUInt32());
}
} while (result->NextRow());
delete result;
}
for (vector<uint32>::iterator itr = tokill_charters.begin(); itr != tokill_charters.end(); ++itr)
CharacterDatabase.WaitExecute("DELETE FROM charters WHERE charterId = %u", *itr);
Log.Notice("DatabaseCleaner", "Deleted %u charters.", tokill_charters.size());
Log.Notice("DatabaseCleaner", "Cleaning charters...");
result = CharacterDatabase.Query("SELECT auctionId, owner FROM auctions");
vector<uint32> tokill_auct;
if (result)
{
do
{
if (chr_guids.find(result->Fetch()[1].GetUInt32()) == chr_guids.end())
tokill_auct.push_back(result->Fetch()[0].GetUInt32());
} while (result->NextRow());
delete result;
}
for (vector<uint32>::iterator itr = tokill_auct.begin(); itr != tokill_auct.end(); ++itr)
CharacterDatabase.WaitExecute("DELETE FROM auctions WHERE auctionId = %u", *itr);
Log.Notice("DatabaseCleaner", "Deleted %u auctions.", tokill_auct.size());
Log.Notice("DatabaseCleaner", "Ending...");
}
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;
}
