I just randomly got an account expiration notice from Quake Live. Apparently after 90 days of inactivity they're closing accounts now. Probably a good idea considering I haven't played in over 2 or 3 years.
edit: I would really like to know the ratio of inactive accounts to active ones on popular services like Facebook, World of Warcraft, Myspace, Twitter. Even GAF. Couldn't be that hard, just check if the last time logged in was within the last month, if it is, add 1 to active, if not, add one to inactive.
editedit: fuck in SQL databases it's even easier. just
Code:
SELECT COUNT(*) FROM `Table` WHERE LastLoggedIn BETWEEN '20120201 AND '20120101';
which would return the number of matched rows.
but that wouldnt return the number of inactive accounts. just remove COUNT(*) and put a * and it'd return all the rows, which you could iterate off of.
..i really need to stop doing these sorts of posts.