Greetings,
We will be doing a "minor" prune/purge on the upcoming days.
Accounts which fit the following criteria will be purged:
Less than 2 logins, AND
Older than five days
Also, any storage or bank account without owner will be deleted.
Additionally, any account which did not login after 2019-01-01 will have a bunch of variables removed.
Most of these variables have been deprecated since 2011 and were automatically being removed as players logged in, but because I want to reduce the database size "here and now", we'll be running all of that once, against the whole player database.
List of removed variables:
Code: Select all
'QUEST_xmas07_state', 'QUEST_xmas07_milk', 'QUEST_xmas07_cookies', 'QUEST_xmas07_presents',
'QUEST_Halloween07_state',
'XMASQUEST1', 'XMASQUEST2', 'XMASQUEST3', 'XMASQUEST4', 'XMASQUEST5', 'XMASQUEST6', 'XMASQUEST7', 'XMASQUEST8', 'XMASQUEST9', 'XMASQUEST10', 'XMASQUEST11', 'XMASQUEST12', 'XMASQUEST13', 'XMASQUEST14', 'XMASQUEST15', 'XMASQUEST16', 'XMASQUEST17', 'XMASQUEST18', 'XMASQUEST19', 'XMASQUEST20',
'HWQUEST1', 'HWQUEST2', 'HWQUEST3', 'HWQUEST4', 'HWQUEST5', 'HWQUEST6', 'HWQUEST7', 'HWQUEST8', 'HWQUEST9', 'HWQUEST10', 'HWQUEST11', 'HWQUEST12', 'HWQUEST13', 'HWQUEST14', 'HWQUEST15', 'HWQUEST16', 'HWQUEST17', 'HWQUEST18', 'HWQUEST19', 'HWQUEST20',
'EasterQuest', 'QUEST_Easter08_state', 'Halloween08', 'QUEST_xmas08_state',
'QUEST_Easter09', 'QUEST_Easter09_slots', 'Candyman', 'QUEST_Christmas09_state',
'Easter_2010_QuestState', 'Easter_2010_EggState1', 'Easter_2010_EggState2', 'Easter_2010_EggState3', 'Easter_2010_EggState4', 'Easter_2010_EggState5',
'hween10', 'hween10_collect_canpump', 'hween10_credits', 'hween10_collect', 'hween10_collect_mmallow', 'hween10_collect_jelskul', 'hween10_bonecount', 'hween10_collect_tondel', 'hween10_paid',
'hween16', 'hween16_collect_canpump', 'hween16_credits', 'hween16_collect', 'hween16_collect_mmallow', 'hween16_collect_jelskul', 'hween16_bonecount', 'hween16_collect_tondel', 'hween16_paid',
'Count_Yellow', 'Count_White', 'Maze', 'Yellow', 'White', 'Xmas2010', 'Golbenez_Inn_Cost', 'QUEST_Easter11', 'hw2011', 'xmas2011', 'QUEST_Easter12', 'xmas2012',
'QUEST_clothdyer_angus', 'QUEST_clothdyer_state',
'Death_Kill', 'Scorp', 'Bugleg', 'KatzeBeenOutside', 'LastHiss', 'CaveSnakeLamp', 'MAGIC_CAST_TICK',
'sorfina', 'tanisha', 'hasan', 'kaan'
We just reached 86,000 chars the other day and we are way past 105,000 accounts.
The char file have 50.5 Mb and the account file, 12.8 Mb.
This "small" purge will remove accounts which did not play or gave up on playing, as well as artifacts from partly deleted accounts. This will free to us some more variables slots on TMWA, which in turn, allow us to develop new quests.
Server will be offline during 5 minutes while the purge script run.
It'll also take slightly longer to start while it cleans up the parties accordingly.
Expected Results
→ 52,898 accounts will be deleted
→ 23,872 characters will be deleted
→ 47,425 accounts will be checked for outdated variables
→ 36,508 variables will be effectively deleted (avg 0.77/user)
→ 6,278 accounts will have their variables updated
→ 3,164 orphan storage accounts filled with items will be destroyed
→ 3,890 bank accounts with no owner will be closed
→ 7 Mb reduction on char and account files
→ 200 Mb saved on RAM memory
→ No player, active or inactive, will lose their accounts or chars.
In the attachments, you can find the projected log about the upcoming purge. "Cleaning" should be harmless.
Backups will be kept for at least a month in case anything goes wrong, but I tested with a local copy of player data and the purge did not cause any major issues.
However, ManaMarket and Guilds were not tested, and while I highly doubt an account which only logged in once would be on either of those, you never know 
