From 2b9dfe7299267752f0fb909bcd5fdf94e4994689 Mon Sep 17 00:00:00 2001 From: Machiavelli Date: Sun, 6 Dec 2009 20:07:08 +0100 Subject: Do not delete realm first achievements from character_achievement in Player::DeleteFromDB. NOTE: These achievements have flags & 256 in DBC. The IDs are currently excluded in the SQL delete query, hard coded. Might be room for improvement down the road. --HG-- branch : trunk --- src/game/Player.cpp | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) (limited to 'src') diff --git a/src/game/Player.cpp b/src/game/Player.cpp index 885b69515fd..1c99089e9c3 100644 --- a/src/game/Player.cpp +++ b/src/game/Player.cpp @@ -4237,7 +4237,10 @@ void Player::DeleteFromDB(uint64 playerguid, uint32 accountId, bool updateRealmC CharacterDatabase.PExecute("DELETE FROM mail_items WHERE receiver = '%u'",guid); CharacterDatabase.PExecute("DELETE FROM character_pet WHERE owner = '%u'",guid); CharacterDatabase.PExecute("DELETE FROM character_pet_declinedname WHERE owner = '%u'",guid); - CharacterDatabase.PExecute("DELETE FROM character_achievement WHERE guid = '%u'",guid); + CharacterDatabase.PExecute("DELETE FROM character_achievement WHERE guid = '%u' " // NOTE: These achievements have flags & 256 in DBC. + "AND achievement NOT BETWEEN '456' AND '467' " // Realm First Level 80 + "AND achievement NOT BETWEEN '1400' AND '1427' " // Realm First Raid Achievements + "AND achievement NOT IN(1463, 3117, 3259) ", guid); // Realm First Northen Vanguard + Raid Achievements 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); -- cgit v1.2.3