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

[jackalz]

At first, thanks.

I want to not delete but move usergroup(e.g. banned usergroup).
What can I do?

[sabret00the]

Originally Posted by jackalz

I want to not delete but move usergroup(e.g. banned usergroup).
What can I do?

this is untested but in the manageActivation.php find:

PHP Code:

        $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "post SET username = '" . $db->escape_string($user['username']) . "', userid = 0 WHERE userid = " . $user['userid']);
        $vbulletin->db->query_write("DELETE FROM " . TABLE_PREFIX . "user WHERE userid = " . $user['userid']);
        $vbulletin->db->query_write("DELETE FROM " . TABLE_PREFIX . "userfield WHERE userid = " . $user['userid']);
        $vbulletin->db->query_write("DELETE FROM " . TABLE_PREFIX . "usertextfield WHERE userid = " . $user['userid']);
        $vbulletin->db->query_write("DELETE FROM " . TABLE_PREFIX . "access WHERE userid = " . $user['userid']);
        $vbulletin->db->query_write("DELETE FROM " . TABLE_PREFIX . "customavatar WHERE userid = " . $user['userid']);
        $vbulletin->db->query_write("DELETE FROM " . TABLE_PREFIX . "moderator WHERE userid = " . $user['userid']);
        $vbulletin->db->query_write("DELETE FROM " . TABLE_PREFIX . "pm WHERE userid = " . $user['userid']);
        $vbulletin->db->query_write("DELETE FROM " . TABLE_PREFIX . "subscribeforum WHERE userid = " . $user['userid']);
        $vbulletin->db->query_write("DELETE FROM " . TABLE_PREFIX . "subscribethread WHERE userid = " . $user['userid']);
        $vbulletin->db->query_write("DELETE FROM " . TABLE_PREFIX . "session WHERE userid = " . $user['userid']); 


and replace with

PHP Code:

$vbulletin->query_first("UPDATE " . TABLE_PREFIX . "user SET usergroupid = 11 WHERE userid = " . $user['userid']); 


however consider this whole post unsupported, i.e. any problems arrise i won't solve them.

[RS_Jelle]

[high]* RS_Jelle clicks install for this one and uninstall for the old one [/high]

[RS_Jelle]

It gives a fatal error when running the task, but it's easy to fix:
FIND (line 63)

PHP Code:

$db->escape_string 


REPLACE WITH

PHP Code:

$vbulletin->db->escape_string 


[sabret00the]

Fixed

[RS_Jelle]

Originally Posted by sabret00the

Fixed

There are two folders now in the zip file

Edit: maybe you can add a url tag to the product (that's easy to manage your products in vB 3.6):

<url>https://vborg.vbsupport.ru/showthread.php?t=124530</url>

[sabret00the]

i'll add that sometime this evening

[imported_pmay68]

I know this is probably a stupid question but what is the varname in the cron setup?

Can someone give me in lamers terms how to set the cron up.. Hehehe Stupid here needs to know

[RS_Jelle]

Originally Posted by imported_pmay68

I know this is probably a stupid question but what is the varname in the cron setup?

Can someone give me in lamers terms how to set the cron up.. Hehehe Stupid here needs to know

I'm to lame to type it, so here is a screenshot of it



You can give it a description and other junk, but I added it before vB 3.6 (and I'm to lame to add one). It works fine, so it's ok for me