vb.org Archive - Un-Activated User Management

Page 1 of 6

Last »

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)

- - Un-Activated User Management (https://vborg.vbsupport.ru/showthread.php?t=65845)

sabret00the

06-03-2004 10:00 PM

Un-Activated User Management

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

Quote:

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 :D

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

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

007	06-04-2004 10:12 PM

What's the downside to having a large amount of unactive members saved?

sabret00the

06-04-2004 10:15 PM

depends on what your board is trying to do with them users, but it's mostly taking up space it don't need to be.

i saw a post by someone the other day that said they had 200 members unconfirmed, to think something like this could've seduced em into completing their registration.

SaN-DeeP

06-04-2004 10:25 PM

Quote:

Originally Posted by sabret00the

nice hack i will install this.

i dunt like unactive members
its kinda waste or no use for board at all.

Sandy...

ImportPassion

06-05-2004 02:51 PM

you know this is already in vb3 right by default, right? albeit not exactly the same, but you could just hack the existing one.

sabret00the

06-05-2004 04:25 PM

yup, noticed last night and thought asked for it be removed, read their version and thought this would make a nice alternative as does remove the users after said amount of days

Boofo

06-05-2004 05:15 PM

Paul, I have this set up to use vB3's cron and it works great. PM me on my site and I will give you the updated file and what you need for this. ;)

Dan	06-05-2004 06:16 PM

Quote:

Originally Posted by Boofo

Paul, I have this set up to use vB3's cron and it works great. PM me on my site and I will give you the updated file and what you need for this. ;)

Nice :) I like the idea of this

lifesourcerec

06-05-2004 07:18 PM

Quote:

Originally Posted by Boofo

Paul, I have this set up to use vB3's cron and it works great. PM me on my site and I will give you the updated file and what you need for this. ;)

How do I do that?

PixelFx

06-05-2004 09:52 PM

very nice, *looks over at list of 400 new unchecked accounts* I think I could use this ;)

sabret00the

06-06-2004 03:17 AM

it's 5am, i'm still at work, but i'll talk to bob in the morning and update the neccessary files as soon as i wake up tomorrow.

lifesourcerec

06-06-2004 03:59 PM

Sounds good :)

Bryan Ex

06-06-2004 04:27 PM

If I install this (I'm really tired of pruning manually!) will it double up the activation reminders that are already being sent out by VB3?

sabret00the

06-06-2004 04:31 PM

if you install this, you're best to disable the one built into vbulletin, but i would wait a while cos i'm going to update this by end of weekend.

Bryan Ex

06-06-2004 04:33 PM

Perfect! Just out of curiousity... is the update for bug fixes ... or additions to what you've already posted?

Bryan Ex

06-07-2004 11:27 AM

Quote:

Originally Posted by sabret00the

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

Is this still the case and/or will it run off the VB cron?

sabret00the

06-07-2004 10:36 PM

just updated this upto version 2.2 thanks to Boofo, so please if you're gonna show gratitude, show it to both them.

to upgrade all you have to do is replace the managaActivation.php

anyhoo not to good at this whole release stuff so have fun with it :)

instructions on how to run under the vb cron system are in the installation file.

lifesourcerec

06-07-2004 11:05 PM

Where do you add the password at in this file?

sabret00the

06-07-2004 11:08 PM

you actually don't need to do that bit anymore, sorry should've removed that bit from the instructions

psico

06-08-2004 01:39 AM

Quote:

Originally Posted by sabret00the

you actually don't need to do that bit anymore, sorry should've removed that bit from the instructions

What happend if a user change his email and make a mistake? This user would lost his account in ten days??
I think this hack have to check if this user is a new registration or an email change, for obvious reasons ;)

Great hack dude!

sabret00the

06-08-2004 05:56 AM

Quote:

Originally Posted by psico

What happend if a user change his email and make a mistake? This user would lost his account in ten days??

sadly yes, however feel free to add the functionality you require.

PranK

06-08-2004 06:05 AM

Quote:

Originally Posted by sabret00the

i saw a post by someone the other day that said they had 200 members unconfirmed, to think something like this could've seduced em into completing their registration.

I got close to 1000... :(

Thanks heaps for this, its great!

Christian

Yahhoon23

06-08-2004 06:29 AM

Quote:

Originally Posted by psico

Anyone have any info on how to accomplish this. You are right that it should check, but my skills in vb aren't good enough to do this without help :(

sabret00the

06-08-2004 06:36 AM

at a quick glance you'd need to edit this

PHP Code:


		
			
    $userArray=$DB_site->query("

        SELECT username,user.userid,email,joindate,activationid 

        FROM user

        LEFT JOIN useractivation ON (user.userid=useractivation.userid)

        WHERE user.usergroupid=3

    ");

make it select the posts column as well and then include the clause to say

PHP Code:


		
			
        WHERE user.usergroupid=3

AND posts > 1

i'll take a proper loook when i wake up, as right now i need a little sleep

Bryan Ex

06-08-2004 06:38 AM

Maybe I'm not following the process here but would it not allow for 10 ten days for correction? While it's certainly possible to loose an occasional member, if they are even semi-active they will know they did not receive the activation notice, the usergroup permissions would not have changed to allow regular member access, plus they would have to make the same exact error in their email address twice to change it. Just seems like pretty slim odds to me.

Bryan Ex

06-14-2004 02:18 PM

User activationid's are not being included in the email notices for my board. Is this query correct as there is no activationid field in the user table;

PHP Code:


		
			
        SELECT username,user.userid,email,joindate,activationid 

        FROM user

        LEFT JOIN useractivation ON (user.userid=useractivation.userid)

        WHERE user.usergroupid=3

sabret00the

06-15-2004 07:04 AM

i'm looking into this now, the query is correct as it pulls the column correctly but it's just coming up null, i should have an update by the end of the day.

Bryan Ex

06-15-2004 07:43 AM

Okay... cool. The other thing I was wondering about is it doesn't seem to list in the cron log files unless I run it manually. It's certainly working as I have no unactivated accounts over the time limit... just no logs to indicate it. Anything that I would need to change to have it running from my includes/cron/ directory? I compared log_cron_action to another script that was being logged and they seem the same to me.

psico

07-21-2004 09:39 AM

Quote:

Originally Posted by Bryan Ex

User activationid's are not being included in the email notices for my board. Is this query correct as there is no activationid field in the user table;

PHP Code:


		
			
        SELECT username,user.userid,email,joindate,activationid 
        FROM user
        LEFT JOIN useractivation ON (user.userid=useractivation.userid)
        WHERE user.usergroupid=3

This is the solution for this problem, I?ve got it from activate.php:

IN manageActivation.php
Under this:

PHP Code:


		
			
         while ($user=$DB_site->fetch_array($userArray))
        {

Insert this code:

PHP Code:


		
			
        // make random number
        if (empty($user['activationid']))
        { //none exists so create one
                $user['activationid'] = vbrand(0, 100000000);
                $DB_site->query("
                        INSERT INTO " . TABLE_PREFIX . "useractivation
                        VALUES
                        (NULL , $user[userid], " . TIMENOW . ", $user[activationid], 0, 2)
                ");
                echo ("ActivationID created to ". $user[username]."<br>");
        }
        else
        {
                $user['activationid'] = vbrand(0, 100000000);
                $DB_site->query("
                        UPDATE " . TABLE_PREFIX . "useractivation SET
                        dateline = " . TIMENOW . ",
                        activationid = $user[activationid]
                        WHERE userid = $user[userid] AND type = 0
                ");
                echo ("ActivationID updated to ". $user[username]."<br>");
        }

There is another problem with this hack, if someone change the email address the account is deleted inmediatly because the registration date is more than 10 days old...this is CRITICAL!

So the quick solution to this is to change the query like this:

Code:

 SELECT username,user.userid,email,joindate,activationid

                                FROM user

                                LEFT JOIN useractivation ON (user.userid=useractivation.userid)

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

So if the user have 1 or more posts the account is not deleted.

See ya.

sabret00the

07-21-2004 10:05 AM

completely forgot about htis, i'll issue an update :) thank you psico :)

Oblivion Knight

07-21-2004 10:42 AM

Nice work.. I'll be installing this shortly. :)

Natch

07-21-2004 10:43 AM

Thanks for the update - installeD :)

-=Sniper=-

07-21-2004 11:26 AM

will install :) thanks

kall	07-21-2004 11:51 AM

Nice!

/me installs

psico

07-22-2004 12:45 AM

Quote:

Originally Posted by sabret00the

completely forgot about htis, i'll issue an update :) thank you psico :)

you welcome ;)

rinkrat

07-22-2004 05:17 PM

Shouldn't the manageActivation.php file go in includes/cron? Or does it matter?

sabret00the

07-22-2004 05:25 PM

Quote:

Originally Posted by rinkrat

Shouldn't the manageActivation.php file go in includes/cron? Or does it matter?

that's exactly where it should be, did i say it should be somewhere different, could you tell me where so i could correct it please.

rinkrat

07-22-2004 06:04 PM

It's not real clear for the noobs in the install.txt:

"1. upload manageActivation.php to your forum director."

sabret00the

07-22-2004 07:25 PM

oops i'll have to fix that.

sv1cec

07-23-2004 11:48 AM

Quote:

Originally Posted by sabret00the

oops i'll have to fix that.

Just installed it, but I am curious as to if the problems mentioned earlier by other members here, have been included in the installation files?

Hitting install. The hack just deleted my wife, who was a guinea pig account, not activated!!

Thanks

All times are GMT. The time now is 12:46 PM.

Page 1 of 6

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01541 seconds Memory Usage 1,855KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (8)bbcode_php_printable (13)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (40)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: