diff options
| author | megamage <none@none> | 2009-08-24 19:23:31 -0500 |
|---|---|---|
| committer | megamage <none@none> | 2009-08-24 19:23:31 -0500 |
| commit | 6e8009446dd364fada37152e347216a4c1718dd9 (patch) | |
| tree | 5cce0b97bc86f3687048c1758896f97545920c79 /src/game/Player.cpp | |
| parent | ab8b1d803905d5ac6b9f16bbc810cf9a7e179a27 (diff) | |
[8402] Optimalized guild_eventlog and guild_bank_eventlog loading from database.
Added config options to set count of eventlog records stored in DB.
Attached SQL files will DROP existing and create new tables. Make sure you create backup (if you need old data).
Renamed few variables in Guild class.
Signed-off-by: Triply <triply@getmangos.com>
*Note: existing guild bank log will be removed.
--HG--
branch : trunk
Diffstat (limited to 'src/game/Player.cpp')
| -rw-r--r-- | src/game/Player.cpp | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/src/game/Player.cpp b/src/game/Player.cpp index f3270e640bd..6e362a8571e 100644 --- a/src/game/Player.cpp +++ b/src/game/Player.cpp @@ -4246,6 +4246,9 @@ void Player::DeleteFromDB(uint64 playerguid, uint32 accountId, bool updateRealmC CharacterDatabase.PExecute("DELETE FROM character_achievement WHERE guid = '%u'",guid); CharacterDatabase.PExecute("DELETE FROM character_achievement_progress WHERE guid = '%u'",guid); CharacterDatabase.PExecute("DELETE FROM character_equipmentsets WHERE guid = '%u'",guid); + CharacterDatabase.PExecute("DELETE FROM guild_eventlog WHERE PlayerGuid1 = '%u'",guid); + CharacterDatabase.PExecute("DELETE FROM guild_eventlog WHERE PlayerGuid2 = '%u'",guid); + CharacterDatabase.PExecute("DELETE FROM guild_bank_eventlog WHERE PlayerGuid = '%u'",guid); CharacterDatabase.CommitTransaction(); //loginDatabase.PExecute("UPDATE realmcharacters SET numchars = numchars - 1 WHERE acctid = %d AND realmid = %d", accountId, realmID); |