Administrative and Maintenance Tools - Un-Activated User Management 3.1

this was a fantastic vb2 hack and was made with blood, sweat and tears by Amy, she deserves all the credit for doing a fantastic job and then giving me permission to release this. If you install this you should show your gratitude in her direction as without her it wouldn't have been possible.


if you got a big board you can't live without this, it stops the crap from piling up.

anything messes up, i can't take responsibility i'm afraid so back up before you try it.

Originally Posted by AmyKhar

This hack will email a warning to members who have not activated their account and then delete them. It can run via cron, and is a pretty darn easy hack to install.

Features:
1. Emails users after 3 days and reminds them to activate their accounts.

2. Emails users after 5 days and lets them know their account will be deleted if they do not activate.

3. Emails users after 8 days with a final warning.

4. Deletes un-activated members after 10 days.

It still does exactly the same but this time for vb3

oh yeah, it emails you to tell you who was deleted, emailed so you're always informed.


and now like the days of our youth where everything was free and our mum would have dinner on the table for us, you're done.

v2.x Contributors Include: Boofo, psico, sv1cec and jlurken
v3.x Contributors Include: Paul M

UPDATED: now 3.6 compliant.

Arabic version thanks to Almotmaiz.Net

[Ramsesx]

Originally Posted by sabret00the

he had zero posts?

I think he had zero post but I'm not sure. I'll try to do a test with my test account.

[hilfe-forum]

Originally Posted by Ramsesx

I think he had zero post but I'm not sure. I'll try to do a test with my test account.

Und gehts?

[djbaxter]

I've just checked the script myself and it clearly requires zero posts before anyone is deleted:

	SELECT u.username, u.userid, u.email, u.joindate, ua.activationid, u.languageid  
	FROM " . TABLE_PREFIX . "user u
	LEFT JOIN " . TABLE_PREFIX . "useractivation ua ON (u.userid = ua.userid)
	WHERE u.usergroupid = 3 AND u.posts = 0

Any user with zero posts who is deleted by changing an email address faces the minor inconvenience of re-registering. Not a big deal, in my opinion. The main worry I had (setting all the member's posts to "Guest") cannot occur, as far as I can see.

[Ramsesx]

Users Deleted: Tester. This was my testaccount, registered since two years, yesterday I wrote a post with this one and after I changed the email adress and and 8 hours later my testaccount was gone.

[djbaxter]

Originally Posted by Ramsesx

Users Deleted: Tester. This was my testaccount, registered since two years, yesterday I wrote a post with this one and after I changed the email adress and and 8 hours later my testaccount was gone.

Was the post in a forum where post counts would be incremented?

[Ramsesx]

Originally Posted by djbaxter

Was the post in a forum where post counts would be incremented?

No, was in a testforum where posts are not counted.

[djbaxter]

Originally Posted by Ramsesx

No, was in a testforum where posts are not counted.

That's the reason then: The post count was still zero.

[Ramsesx]

Originally Posted by djbaxter

That's the reason then: The post count was still zero.

Maybe, but this script should not do that. I have some paying members and I think they will not understand why they get deleted.

[djbaxter]

Originally Posted by Ramsesx

Maybe, but this script should not do that. I have some paying members and I think they will not understand why they get deleted.

I think it unlikely that anyone would have paying members with zero posts - and if they do, there's something wrong (or at least very odd) with the configuration of your forum. Maybe rethink the number of forums that do not count toward post counts?

[Ramsesx]

Originally Posted by djbaxter

Maybe rethink the number of forums that do not count toward post counts?

This may be an idea to solve this problem, but it would be better if the hack could check the registration date too.