Thanks for your input Paco, that's the reason why I put up the code here: always better if some more pair of eyes take look over it - no offence if you are a pirate :arrgh!: ;)

I am not sure though if Datediff works if the dates are stored as a timestamp and not in date format, without having to convert it - otherwise Datediff is certainly more elegant!

Chinese Prisoners Allegedly Forced to Play 'World of Warcraft' :har:


Don't get any ideas!


Yeah, we got the query working, weeded out almost 1000 spam accounts, probably another 3000 to go.

You SQL guys are all a like ... for all we know you could be the same men in black that show up after UFO sightings :yep:

All this talk about squirrels makes me hungry.
http://www.strangecosmos.com/images/content/15912.jpg

Ssssshhhhhh! Sql will get the spammers.
 

:Kaleun_Salivating:Well, after the big spam purge, 3 days away from 60,000

5,000 gone:yeah: boy you did some big time house cleaning :up:

Magic

I just looked at the first member listed in the captains roster, joined 2009 last activity 2009, posts 0, shouldn't this type be deleted as well or hasn't it been done yet? reading Neal's last post can be taken either way!:hmmm:

No, we're not taking out inactive members. As long as they are not spammers, they stay. Most likely, they will never return, and if they do, they are locked out of their account because they forgot their password and the email is old and no longer accessible. But a small percentage of them may wander back round, and we may as well leave their account available. I can think of many forums I joined years ago, and from time to time, I visit them. Glad to have my username intact and unmolested.

:Kaleun_Wink: