Un-Activated User Management

although i know this works manually, it's untested via cron

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.

#########################################
Add-On:
#########################################
if you like your templates in your admin cp neat then do this:
in "includes/adminfunctions_template.php" find

PHP Code:

    'subscription' => $vbphrase['group_paid_subscriptions'], 


add below

PHP Code:

    'activationemail' => ActivationEmail, 


now save and close cos you're done :cheeky: :bored:

[high]wol stuff been removed due to the fact this should now be in the cron directory and thus won't show up anyway[/high]

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.

the two critical bugs that a/ it wasn't sending the activationid and b/ it was deleting users who didn't change their email correctly, have been squashed by Psico[/high]

v2.1: Boofo killed 2 bugs
v2.2: more bugs killed by Boofo
v2.3: bugs killed by psico
v2.3a: bugs killed by sv1cec
v2.4: changed activation code when one exists already removed (sv1cec)
v2.4: better cron logging (me)
v2.4: table prefix bug found by jlurken, fixed by moi
v2.5: email reminder sent to your inbox thanks to sv1vec, improved logging, removed redundant code.
v2.5.2: fixed table prefixes.

[high]YOU WILL NOW NEED TO EDIT THE FILE TO MAKE SURE IT WORKS, IT'S CLEARLY MARKED ON LINE 21[/high]

[Kaishi]

marcho your code got me this error, did i copy something wrong?

PHP Code:

Database error in vBulletin 3.0.7:

Invalid SQL: 
        SELECT username,user.userid,email,joindate,activationid
            FROM useractivation AS useractivation
            LEFT JOIN user AS user ON(user.userid=useractivation.userid)
            WHERE dateline =
                (select MAX(dateline) FROM useractivation AS ua2 WHERE ua2.userid = useractivation.userid)
            AND user.usergroupid=3 AND user.posts = 0    
mysql error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'select MAX(dateline) FROM useractivation AS ua2 WHERE ua2.useri

mysql error number: 1064 


[Marco van Herwaarden]

What MySQL version are you using?

[Kaishi]

Originally Posted by MarcoH64

What MySQL version are you using?

4.0.22-standard

[Marco van Herwaarden]

Hmm not sure, will look if there are any clauses used that where not allowed in 4.0 a litle bit later.

[Marco van Herwaarden]

Just checked this subquery is not allowed in MySQL 4.0.

Will have to rewrite it using LEFT JOINs. Will be a tough one. Will try if i can have a look this weekend.

[Kaishi]

Originally Posted by MarcoH64

Just checked this subquery is not allowed in MySQL 4.0.

Will have to rewrite it using LEFT JOINs. Will be a tough one. Will try if i can have a look this weekend.

i really appreciate it! thanks alot in advance. i love this vb.org community, i couldn't get help with stuff anywhere else for some reason.

[Kaishi]

i hope you guys didn't forget about me

[Marco van Herwaarden]

Originally Posted by Kaishi

i hope you guys didn't forget about me

Actually i did.

Is a bit hectic these days and i can't spend as much time as i would like on vB. Will try to find some time to have a look at your problem in the next days i hope.

[Kaishi]

ok

[Kaishi]

another problem kinda. sometimes it would send a 3/5/8 day reminder to someone, then the next day it would send the same reminder again. for example, today user x got a 3 day reminder, tomorrow, he gets a 3 day reminder again.