Warcraft II Forum

Warcraft II => Server.War2.ru => Topic started by: iL on January 13, 2015, 06:21:48 PM

Title: freed accounts
Post by: iL on January 13, 2015, 06:21:48 PM
Just deleted old accounts in state "Awaiting Activation":

ouin
BHC-ICE..
nickifrascellafid
Warrenvazy
ericrenzisjz
woofy
coraleeaus2om
cYhNaKvXnF
Michaeljoms
bentonjoostenpa8
Vicentecix
troggy
Mauricefrog
AlbertRord
Tester
MichaelEl

You can recreate your account for different email if you had problems with activation
Title: Re: freed accounts
Post by: I hate naggers on January 13, 2015, 07:27:50 PM
how about server account wipe? less than 20 games + no game in last 365 dayzzzz?
Title: Re: freed accounts
Post by: GaNzTheLegend on January 13, 2015, 07:33:47 PM
how about server account wipe? less than 20 games + no game in last 365 dayzzzz?

/agree
Title: Re: freed accounts
Post by: RipE[Eur0] on January 13, 2015, 08:34:12 PM
how about one nick/player?
Title: Re: freed accounts
Post by: iL on January 13, 2015, 11:54:47 PM
ess than 20 games + no game in last 365 dayzzzz?
last time i wiped less than 3 games+no game in last 3 months, deleted 2/3 of player database...
Accounts could also be used to collect stats, so, i'll think about it...
Title: Re: freed accounts
Post by: {Lance} on January 14, 2015, 07:39:49 PM
Deletion is not a term in Big Data.  Archived is however an option.  Getting rid of old data is always a bad idea especially for investigative type of tasks.
Title: Re: freed accounts
Post by: iL on January 15, 2015, 04:44:40 AM
Deletion is not a term in Big Data.  Archived is however an option.  Getting rid of old data is always a bad idea especially for investigative type of tasks.
Agree, and proper archiving is not so easy task also. I mean need to keep some kind of analytics possible for that archieved data
Title: Re: freed accounts
Post by: I hate naggers on January 15, 2015, 07:04:08 AM
Really? Deleting a bunch of old, abandoned and unused accounts may serve an investigative purpose? what kind?
Title: Re: freed accounts
Post by: {Lance} on January 15, 2015, 03:02:18 PM
Simple.  IP History.  It also gives habit history as well.  There are many other uses for old unused data that you couldnt possibly fathom obviously, which is why you're not a sysadmin/dba/developer/security analyst or a decent one anyway.
Title: Re: freed accounts
Post by: I hate naggers on January 15, 2015, 03:42:34 PM
keeping thousands of unused akas in case any of it might be useful for its ip at one point? in what universe would an IP match with a 0-0-0 account from 2 years ago amount to anything?
Title: Re: freed accounts
Post by: Player on January 15, 2015, 08:02:49 PM
teach
Title: Re: freed accounts
Post by: {Lance} on January 15, 2015, 08:45:06 PM
keeping thousands of unused akas in case any of it might be useful for its ip at one point? in what universe would an IP match with a 0-0-0 account from 2 years ago amount to anything?

Like I said, it's to obvious for your intelligence.  Trying to explain it to someone that is lacking in intelligence would be futile.  If it's not abundantly obvious to you now, it never will be.
Title: Re: freed accounts
Post by: chayliss on January 15, 2015, 09:04:15 PM
sorry player lance cant teach he isn't that good
Title: Re: freed accounts
Post by: iL on January 16, 2015, 04:18:18 AM
keeping thousands of unused akas in case any of it might be useful for its ip at one point? in what universe would an IP match with a 0-0-0 account from 2 years ago amount to anything?
Let me try to explain:
Deletion is not a term in Big Data.  Archived is however an option.
It's just a term, not the only guide to action.
I also prefer to archive data, not to delete it. I mean data could be useful for investigation for future. BNET record data is.
Example: you can definitely know several cheaters (like dellam) create tons of accounts every day. Collecting that history today can help to find some patterns for future. It's not only ip addresses, it's also account creation time, last login time, etc.

It's just an example applied to Big Data philosophy. It may be not our case: i just deleted about 80k accounts and don't care of that. Because it was the easiest way to free the accounts from the database and decrease the database size.
And i definitely know i will never have time to make any smart investigation patterns for them.
But as for serious example, like social networks - i'm pretty sure they never delete any records about users once created in their databases...