Root Admin Muratus del Mur Posted June 27, 2009 Root Admin Report Share Posted June 27, 2009 Today (its running while i write this actualy) i deleted old inactive accounts. I am sad to tell that it was a huge number of accounts removed, 121000 out of about 156000. I checked several times to make sure i am not deleting the wrong accounts. The accounts along with the associated data, creatures, docs, messages, etc, were transfered to a backup table and they will remain there untill the next cleanup that will be probably done in two/three month or so. Tehnicaly they can be recovered but i do not have a way yet to do that easily. I hope everything went right and then there is no need to recover anything, but if somehow i deleted IMPORTANT accounts, please post here and i will conduct an investigation and recove whatever i can from them. Do not bother me for alts that are 10-20 days old. Once i will finish a system to recover these accounts automaticaly, you will see this option when trying to register or login with such a disabled account, but untill then its dificult, but possible, to recover them if realy needed. The rules used to determine the inactive accounts are these: - More than 2 month since last login and less than 5 active days and no valid email confirmed - More than 4 month since last login and less than 10 active days - More than 6 month since last login and less than 40 active days - More than 8 month since last login - All rules filter out also NPC and RPC accounts (but not PWR) Please let me know if you consider there is a problem with these rules. Important note, the avatars of such disabled accounts will go back in the avatar gallery and will be available for anyone to get. There are over 400 avatars in game right now but in time many accounts become inactive so their avatars go wasted without good reason. I will update you as soon as the process is finished, right now its still running and seems to be very very slow. I hope that after this the database will be much faster. The player table alone had over 1Gb in size. Link to comment Share on other sites More sharing options...
Root Admin Muratus del Mur Posted June 28, 2009 Author Root Admin Report Share Posted June 28, 2009 seems the cleanup query is very heavy, it runs for some time now, one of them failed due to lost connection, but if i stay one more minute i sleep on the keyboard. I let it run untill tomorow, no MD untill then. Link to comment Share on other sites More sharing options...
Fenrir Greycloth Posted June 28, 2009 Report Share Posted June 28, 2009 When does Mur wake up?! I want to be on five minutes before he does... Link to comment Share on other sites More sharing options...
Grido Posted June 28, 2009 Report Share Posted June 28, 2009 well it's 5.15am for him now...normal day might mean in 4 hours i'd think that it might be ~6 hours before MD is up and running again though Death Bell, Grido and Granos 1 2 Link to comment Share on other sites More sharing options...
Fawe Posted June 28, 2009 Report Share Posted June 28, 2009 Hmm... I hope it isn't too long until this is finished. I, not to mention hundreds of others, might explode of boredom. By the way, thanks for letting me become an author in MDA. I'm working on an MDA Article while I'm waiting. Link to comment Share on other sites More sharing options...
Fenrir Greycloth Posted June 28, 2009 Report Share Posted June 28, 2009 (edited) Fawe, does that mean you can edit it yourself? You don't need anyone else to do it for you? I think the query should be enlarged a bit. I think inactivity for 6 months period should be gone. If you haven't played MD for 6 months(Not even a check up), you are not coming back. Edited June 28, 2009 by Fenrir Greycloth Link to comment Share on other sites More sharing options...
Fawe Posted June 28, 2009 Report Share Posted June 28, 2009 Yes, Fenrir, it does. I can not only edit, but I can create my own article, which is what I'm doing. It might be finished by tomorrow, because it's quite long. I posted a new topic, by the way. Does anyone care to tell me whether or not the diamond that appears to veteran's profiles ends on a different color for a reason? Link to comment Share on other sites More sharing options...
Root Admin Chewett Posted June 28, 2009 Root Admin Report Share Posted June 28, 2009 6 months is actually quite a short period if you think about it. I spent 6 months away from the game and wouldnt have liked to have my account deleted (well it was reset but thats not the point) I personally think its too harsh since some games i drift in and out of then happily seeing my char hasnt been deleted. Link to comment Share on other sites More sharing options...
Fawe Posted June 28, 2009 Report Share Posted June 28, 2009 I agree with Chewett. Also, you never know when reality calls you and you have more impt. things to do besides playing a game at the moment. Link to comment Share on other sites More sharing options...
Fenrir Greycloth Posted June 28, 2009 Report Share Posted June 28, 2009 Most people do not come back after six months though, Chewett. If you have were reasonably far, you would still check in every now and then. Not just stop completely. Link to comment Share on other sites More sharing options...
Root Admin Chewett Posted June 28, 2009 Root Admin Report Share Posted June 28, 2009 But for example everyone remember Glaistig? *gasp* not him i hear you say. He thinks he will come back once he has sorted his life and this will be a year + so if he comes back he will come back to his account deleted. Link to comment Share on other sites More sharing options...
Fenrir Greycloth Posted June 28, 2009 Report Share Posted June 28, 2009 And will it be that much different from starting out at MP3 though? He is incredibly far behind compared to normal MP5s, because a year ago many things were not implemented and he is better off without his old account and trying to fix it. Link to comment Share on other sites More sharing options...
dst Posted June 28, 2009 Report Share Posted June 28, 2009 Glai is not a good example. She left cause she was angry about the game Yami is the one who left cause of lack of time and personal issues. Link to comment Share on other sites More sharing options...
MRD Posted June 28, 2009 Report Share Posted June 28, 2009 i get home from driving 8 hours home from a horendous vacation and find no MD. my life sucks.... Link to comment Share on other sites More sharing options...
Grido Posted June 28, 2009 Report Share Posted June 28, 2009 (edited) the accounts are not deleted in the common sense, they are transfered to another place, if someone comes back and asks for their account back, then it *can* be resurrected Edited June 28, 2009 by Grido Death Bell, Grido and Granos 1 2 Link to comment Share on other sites More sharing options...
Akasha Posted June 28, 2009 Report Share Posted June 28, 2009 I personally think that half a year means a lot to MD and a lot of things happen during that period. So if, for more then 6 month you don't log in or keep connection to the game, you can be removed. Also think at the alts made (hmm Lib entered with all the libs in last 6 months ?) and that are forgotten out there. In 6 month if you hit 1 log in you are safe from the delete button. Plus, anything can happen in 6 month .i mean..it is half a year , your role will be lost and only few of us will remember that, mostly the veterans, that if you are not an RPC and you survive the delete button for that reason, but even as an RPC you are forgotten. If someone really wants to come back later will hit the log in at least 1 per week, if not daily for the active days. *points at the veterans that does not play but get the active days* LE: As an adding to what Grido said: [quote]The accounts along with the associate data, creatures, docs, messages, etc, were transfered to a backup table and they will remain there until the next cleanup that will be probably done in two/three month or so.[/quote] So, only after 8-9 month your account will be deleted complete and with no option to resurrect it. I personally think this is more then reasonable. Link to comment Share on other sites More sharing options...
Poppi Chullo Posted June 28, 2009 Report Share Posted June 28, 2009 [quote name='Chewett' post='35358' date='Jun 28 2009, 09:00 AM']6 months is actually quite a short period if you think about it. I spent 6 months away from the game and wouldnt have liked to have my account deleted (well it was reset but thats not the point) I personally think its too harsh since some games i drift in and out of then happily seeing my char hasnt been deleted.[/quote] well..u dont have to be "come back".. just log in then log out back..it'll reset u'r inactive days counter it probably take 5 minutes only... Link to comment Share on other sites More sharing options...
Death Bell Posted June 28, 2009 Report Share Posted June 28, 2009 OMG i am going MAD.... here at home I WANT MD I WANT MD.... I am going crazy guys... some1 stop me before i hurt sum1 else in my house.. Link to comment Share on other sites More sharing options...
Akasha Posted June 28, 2009 Report Share Posted June 28, 2009 It seems there is a problem with the procedure . Link to comment Share on other sites More sharing options...
Death Bell Posted June 28, 2009 Report Share Posted June 28, 2009 omg don't tell that.. all of our accounts are transferred hehe any rough estimated time when it will get back? i wanna have some sleep Link to comment Share on other sites More sharing options...
Fawe Posted June 28, 2009 Report Share Posted June 28, 2009 What's the problem? Death Bell's post or Mur's absence? Link to comment Share on other sites More sharing options...
Akasha Posted June 28, 2009 Report Share Posted June 28, 2009 I have to pack We are going to Bahamas for an unlimited period of time . Link to comment Share on other sites More sharing options...
Root Admin Chewett Posted June 28, 2009 Root Admin Report Share Posted June 28, 2009 just imagine everyones accounts being lost. Let the panic begin Link to comment Share on other sites More sharing options...
Fawe Posted June 28, 2009 Report Share Posted June 28, 2009 *is panicking* not! I'll just make a new account. That way, I'll be more successful than I was before. And my e-mail accounts will be free to use. (Hehehe, sorry. I'm what you call an over-optimist.) Link to comment Share on other sites More sharing options...
Death Bell Posted June 28, 2009 Report Share Posted June 28, 2009 since this problem is too high.... can i go out and kill people for fun.... since killing is FUN... :spiteful: WELL I CAN ONLY SAY ONE THING... DON'T EVER [b]ASSUME[/b] ANYTHING: let me explain When you [b]ASSUME[/b] you usually make a [b]ASS[/b] out of [b]U[/b] and [b]ME[/b] hehe hope u all got it Link to comment Share on other sites More sharing options...
Recommended Posts