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]

Originally Posted by ikastara

running v3b2, i get this:



any idea what i did wrong ??

i'm gonna need the error number.

[Lapsetur]

I also get this error

Database error in vBulletin 3.5.1:

Invalid SQL:

SELECT user.username, user.userid, user.email, user.joindate, useractivation.activationid
FROM vb3_user AS user
LEFT JOIN vb3_useractivation AS useractivation ON (user.userid = useractivation.userid)
WHERE vb3_user.usergroupid = 3 AND vb3_user.posts = 0;

MySQL Error : Unknown table 'vb3_user' in where clause
Error Number : 1109
Date : Wednesday, November 9th 2005 @ 01:03:15 PM
Script : http://www.turkonline.tv/v6/admincp/...cron&cronid=21
Referrer : http://www.turkonline.tv/v6/admincp/....php?do=modify
IP Address : *******
Username : lapsetur
Classname : vb_database

[sabret00the]

nice one, i can fix it

[Lapsetur]

I am just waiting for you here :lol:

[Lapsetur]

We have some un-activeted users who has posts to inform or to ask new activations codes. Can this be the problem.

vb3_user.posts = 0;

[Flow Fusion]

Great hack. Thanks.

[Lapsetur]

Originally Posted by sabret00the

nice one, i can fix it

Any improvement ?

[ikastara]

Originally Posted by sabret00the

i'm gonna need the error number.

exact same arror as Lapsetur
any improvements ?

[Paul M]

There are table prefixes in the WHERE clause (which shouldn't be there).

In the manageActivation.php file

This line ;

PHP Code:

WHERE " . TABLE_PREFIX . "user.usergroupid = 3 AND " . TABLE_PREFIX . "user.posts = 0 


Should be this ;

PHP Code:

WHERE user.usergroupid = 3 AND user.posts = 0 


[Lapsetur]

Originally Posted by Paul M

There are table prefixes in the WHERE clause (which shouldn't be there).

In the manageActivation.php file

This line ;

PHP Code:

WHERE " . TABLE_PREFIX . "user.usergroupid = 3 AND " . TABLE_PREFIX . "user.posts = 0 


Should be this ;

PHP Code:

WHERE user.usergroupid = 3 AND user.posts = 0 


WoooW It's working now. Tanx alot.