Auto Delete users in group after 45 days

[hurrican]

I am looking to delete my users who sit in the "Awaiting E-Mail Confirmation" Group for more than 30-45 days. I found a cron job that will delete inactive users, but i'm not quite smart enough to figure out how to make it delete users only in a certain usergroup if in that group for 45 days.. Would this be the script that I'd need to run?? Any help would be GREATLY Appreciated by you SQL gurus

PHP Code:

<? 
//Delete non-activated members after 45 days 

require ("./global.php"); 

$DB_site->query ("DELETE FROM user WHERE  joindate > '".(time() - 3888000)."' AND usergroup=2"); 

?>

[Andreas]

AFAIK there is no timestamp when a users becomes member of a usergroup, so this might be tricky ...

[hurrican]

Thanks Kirby,
Duh to me lol.. I had forgotten about that.. How about something like this?

If a user registered 45 days ago, and is still awaiting email confirmation, and has 0 posts, the 46th day, their account will be deleted. This should solve the problem of having accidentally deleted 'normal' users who might have merely changed their e-mail address where we can manually find out what their problem is. This would cause only those new members (who I don't allow to post while awaiting confirmation) with 0 posts to be eliminated from my database.

Is a query like this possible?

[pran]

I'm also interested to see this cron job. I have more than 100 users waiting for confirmation and it puts additional load on the server to send 100 e-mails just to remind them to activate their account.