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

[SloppyGoat]

This has done nothing except email the same 3 verification notices. One on the 6th, 8th, and 12th. The user hasn't been deleted yet. What's wrong with it?

[coffee]

On my side it's working perfectly (3.6.3 here), and deleted more than 50ppl emailed some 15 others ..

The olny thing I did was this: https://vborg.vbsupport.ru/showpost....7&postcount=54 (Thanks to Team17).

[SloppyGoat]

Ok, I believe it's going to work now, but how do I stop it from emailing me everytime it runs? I can look at the logs. I don't need a daily email. Or maybe just have it email me when it actually deletes someone.

It's that crazy scheduling that makes this kind of goofy.

[NiTRoN]

Originally Posted by SloppyGoat

Ok, I believe it's going to work now, but how do I stop it from emailing me everytime it runs? I can look at the logs. I don't need a daily email. Or maybe just have it email me when it actually deletes someone.

It's that crazy scheduling that makes this kind of goofy.

goto VBULLETIN OPTIONS/Un-Activated.... and turn it off

[HellRazor]

You should add an option for it to only send an email to you when there were emails sent to unregistered users (so you don't receive a notification when there were no unregistered users to notify).

[coffee]

HellRazor, Find This:

PHP Code:

if ($vbulletin->options['uac_notifyadmin'])
{
        vbmail("" . $vbulletin->options['webmasteremail'] . "","Activation Reminder Report (Activation Notification)", $logmessage, "From: \"" . $vbulletin->options['bbtitle'] . " Mailer\" <" . $vbulletin->options['webmasteremail'] . ">");
} 


Replace with the next:

PHP Code:

$testemailvars =  $threedayemail . $fivedayemail . $eightdayemail . $deletedusers;
if ($testemailvars<>'NoneNoneNoneNone')
{
        if ($vbulletin->options['uac_notifyadmin'])
        {
                vbmail("" . $vbulletin->options['webmasteremail'] . "","Activation Reminder Report (Activation Notification)", $logmessage, "From: \"" . $vbulletin->options['bbtitle'] . " Mailer\" <" . $vbulletin->options['webmasteremail'] . ">");
        }
} 


[SloppyGoat]

Originally Posted by NiTRoN

goto VBULLETIN OPTIONS/Un-Activated.... and turn it off

HAHA!!! Ok, I'm on medication! Nobody laugh!!! There it was all the time. Thanks! I got it it working now. Great hack! *goes to click install*

[perfphysio]

since upgrading the 3.6.3 I have encontered the following error

Database error in vBulletin 3.6.3:

Invalid SQL:

SELECT u.username, u.userid, u.email, u.joindate, ua.activationid, u.languageid
FROM vb_user u
LEFT JOIN vb_useractivation ua ON (u.userid = ua.userid)
WHERE u.usergroupid = 3 AND u.posts = 0;

MySQL Error : Can't open file: 'vb_useractivation.MYI'. (errno: 145)
Error Number : 1016
Date : Friday, November 24th 2006 @ 04:30:40 AM
Script : http://www.physiobob.com/forum/admin...ncron&cronid=9
Referrer : http://www.physiobob.com/forum/admin....php?do=modify
IP Address : 81.149.142.220
Username : physiobob
Classname : vb_database


Any ideas

[sabret00the]

Originally Posted by perfphysio

since upgrading the 3.6.3 I have encontered the following error

Database error in vBulletin 3.6.3:

Invalid SQL:

SELECT u.username, u.userid, u.email, u.joindate, ua.activationid, u.languageid
FROM vb_user u
LEFT JOIN vb_useractivation ua ON (u.userid = ua.userid)
WHERE u.usergroupid = 3 AND u.posts = 0;

MySQL Error : Can't open file: 'vb_useractivation.MYI'. (errno: 145)
Error Number : 1016
Date : Friday, November 24th 2006 @ 04:30:40 AM
Script : http://www.physiobob.com/forum/admin...ncron&cronid=9
Referrer : http://www.physiobob.com/forum/admin....php?do=modify
IP Address : 81.149.142.220
Username : physiobob
Classname : vb_database


Any ideas

Run a repair on your useractivation table.

[HellRazor]

Originally Posted by coffee

HellRazor, Find This:

PHP Code:

if ($vbulletin->options['uac_notifyadmin'])
{
        vbmail("" . $vbulletin->options['webmasteremail'] . "","Activation Reminder Report (Activation Notification)", $logmessage, "From: \"" . $vbulletin->options['bbtitle'] . " Mailer\" <" . $vbulletin->options['webmasteremail'] . ">");
} 


Replace with the next:

PHP Code:

$testemailvars =  $threedayemail . $fivedayemail . $eightdayemail . $deletedusers;
if ($testemailvars<>'NoneNoneNoneNone')
{
        if ($vbulletin->options['uac_notifyadmin'])
        {
                vbmail("" . $vbulletin->options['webmasteremail'] . "","Activation Reminder Report (Activation Notification)", $logmessage, "From: \"" . $vbulletin->options['bbtitle'] . " Mailer\" <" . $vbulletin->options['webmasteremail'] . ">");
        }
} 


Awesome, thank you!