Un-Activated User Management 3

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.

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.


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.


[high]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, so please if you install this should your gratitude in her direction as without her it would've been impossible.[/high]


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

UPDATED: now 3.6 compliant, though needs to be tested quickly to confirm this, it'll either work or it won't but it won't cause your system any problems. BUT IT DEFINATELY WORKS PROBLEM FREE ON ALL 3.5.X INSTALLATIONS. Also note new option for turning on the adminemail in the admincp vboptions bit.

[sabret00the]

what's the error for 3.6?

[jluerken]

Originally Posted by sabret00the

what's the error for 3.6?

If I run this with 3.6 everything seems to run normally

[RS_Jelle]

When I run it manually, the first part works good:

Un-Activated User Management
Sent 8 Day email to xxx
Sent 8 Day email to xxx

But then, there's the error:

Database error in vBulletin 3.6.0:

Invalid SQL:

INSERT INTO useractivation
VALUES
(NULL , 13188, 1154907330, 84391481, 0, 2);

MySQL Error : Column count doesn't match value count at row 1
Error Number : 1136
Date : Monday, August 7th 2006 @ 01:35:30 AM
Script : http://www.ivanhoejupiler.be/admincp...cron&cronid=24
Referrer : http://www.ivanhoejupiler.be/admincp....php?do=modify
IP Address : xx.xxx.xx.xxx
Username : Jelle
Classname : vb_database

Also check this bug report. So I think there's a missing 0 at the end of the INSERT query for vBulletin 3.6.0

[sabret00the]

Originally Posted by RS_Jelle

When I run it manually, the first part works good:

But then, there's the error:


Also check this bug report. So I think there's a missing 0 at the end of the INSERT query for vBulletin 3.6.0

thank you very much, i'll post a 3.6 complient version in the morning.

[bongwater]

the time specified -- is it the administrator's local time specified in the control panel, or is it the time on the host server?

-bongwater

[sabret00the]

Originally Posted by sabret00the

thank you very much, i'll post a 3.6 complient version in the morning.

oops totally forgot about this. tomorrow morning for sure. i'll sleep with this page on my monitor.

[crxrocks]

Thanks! This is one of my favorite hacks!

[crxrocks]

Whoops. It looks like I am having a problem. I uploaded the include .php file to the cron directory and imported the new product, overwriting the existing one. Here is the error

Prune Users Awaiting Confirmation
ActivationID created to xxxxx

Fatal error: Call to a member function on a non-object in /home/thezcres/public_html/forums/includes/cron/manageActivation.php on line 63

The line of code it is references is

$vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "post SET username = '" . $db->escape_string($user['username']) . "', userid = 0 WHERE userid = " . $user['userid']);

Any ideas?

I forgot to mention that this is a 3.6 install.

[crxrocks]

Nevermind. There are two copies of these files contained in the distribution a 3.6 version and a 3.6.0 version. I had originally uploaded the 3.6 version so I replaced it w/ the 3.6.0 version and it worked well.

Thanks!

Chris

[dtdesign]

Originally Posted by crxrocks

Nevermind. There are two copies of these files contained in the distribution a 3.6 version and a 3.6.0 version. I had originally uploaded the 3.6 version so I replaced it w/ the 3.6.0 version and it worked well.

Thanks!

Chris

Which is which ?