vb.org Archive - Administrative and Maintenance Tools

Page 1 of 6

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

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

- vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)

- - Administrative and Maintenance Tools - Un-Activated User Management 3.1 (https://vborg.vbsupport.ru/showthread.php?t=124530)

sabret00the

08-20-2006 10:00 PM

Un-Activated User Management 3.1

1 Attachment(s)

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.

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.

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

08-21-2006 10:42 AM

At first, thanks.

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

sabret00the

08-21-2006 10:47 AM

Quote:

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

08-21-2006 10:53 AM

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

RS_Jelle

08-21-2006 11:01 AM

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

08-21-2006 11:09 AM

Fixed

RS_Jelle

08-21-2006 11:12 AM

Quote:

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

Code:

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

sabret00the

08-21-2006 12:12 PM

i'll add that sometime this evening :)

imported_pmay68

08-21-2006 02:29 PM

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

08-21-2006 03:26 PM

Quote:

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

http://img77.imageshack.us/img77/306...reenhh8.th.png

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

bchertov

08-22-2006 04:11 AM

Is there any support for check when an un activated user logs on?
That would be a great time to get them to activate!

Also I'd hate to delete users how have logged on since their registration, but failed to activate.

Barry

sabret00the

08-22-2006 12:48 PM

Quote:

Originally Posted by bchertov

nope, afraid not, this just goes off of days.

Snake

08-22-2006 12:54 PM

Sweet!

BETIServices

08-22-2006 08:19 PM

A Life saver ... is getting better and beter here :D

DruidToolz

08-23-2006 03:48 PM

Ok this might be a dumb thing to say but what your saying is that this delete those that are in the "Users Awaiting Email Confirmation" after so many days if not activated.. if this is the case I will install this onto my board.. :)

sabret00the

08-23-2006 03:50 PM

Quote:

Originally Posted by DruidToolz

that is indeed what i am saying.

DruidToolz

08-23-2006 03:51 PM

awesome.. :) Clicks installs..

Ok i installed it.. Wondering if i should follow that image that was shown above.. if so then i did everything right.. :)

DementedMindz

08-23-2006 10:34 PM

sabret00the thanks and nice work.

Neal-UK

08-24-2006 03:27 PM

I get about 3 e-mails when it sends the e-mail reminder and information.

Will my users get all these too?

I've set it for once a day, at 12 via cron

Neal-UK

08-25-2006 03:54 AM

had to remove this, sending e-mails when it wants and about 10 now each time!

sabret00the

08-25-2006 08:56 AM

three emails, you have set the cron job up correctly right?

Neal-UK

08-25-2006 02:34 PM

Yeah, set to once a day.

This is an excellent hack, can you show us how you have set up your cron job as I really want and need this.

sabret00the

08-25-2006 02:50 PM

Personally i edit the "Activation Reminder Email" cronjob and just change the url from "activate.php" to "manageActivate.php" and that's it.

Neal-UK

08-25-2006 03:01 PM

Ok, i will try that and see what happens.

Is there a similar mod for those who have not posted?

sabret00the

08-25-2006 03:06 PM

sadly, not by me.

Neal-UK

08-25-2006 03:06 PM

Did that and get this when I ran it:

Quote:

Warning: main(/***/****/*****/****/***/**/****/forum/./includes/cron/manageActivate.php) [function.main]: failed to open stream: No such file or directory in /admincp/cronadmin.php on line 108

Warning: main() [function.include]: Failed opening '/****/***/***/****/***/**/******/forum/./includes/cron/manageActivate.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /admincp/cronadmin.php on line 108

Ninth Dimension

08-25-2006 06:32 PM

Nice hack, thank you
/install

DruidToolz

08-26-2006 11:38 PM

Quote:

Originally Posted by Neal-UK

Did that and get this when I ran it:

Did you physically upload manageActivate.php from your FTP client to your cron folder on your web server.. If you haven't that error that you got might be the result of not uploading it.. Also make sure you have the settings correct in your Scheduled Tasks.. I'm not an expert on these things like most of these people, but the directions they give seem to work for me.. :)

Black Tiger

08-26-2006 11:54 PM

This is great, I was looking for something like this already. Thanks to everybody who made this possible.
And I clicked "installed this hack" ofcourse.:)

Ninth Dimension

08-27-2006 02:01 PM

I've just signed-up a dummy account on my site and left it un-activated to test this mod out... I'm not saying that it doesn't work or anything, I'm just curious :)

sabret00the

08-27-2006 04:40 PM

Quote:

Originally Posted by Neal-UK

Did that and get this when I ran it:

seems like you got the filename wrong, change it to "./includes/cron/manageActivation.php".

Kihon Kata

08-28-2006 04:27 PM

UPdated mine! seems to work when I run it manually

DruidToolz

08-28-2006 11:51 PM

mine works.. everyday i get an email on who has not activated there account and how many days they have left, etc.. Which is good since i don't have to run it manually :)

thedvs

08-29-2006 06:41 PM

great mod thank you very much! thanks amy too!

aciurczak

09-05-2006 12:24 PM

Seems to work fine for me; great addition!

aciurczak

09-06-2006 11:04 AM

Doh! I set it up in the cron at a specified hour, but left the minutes at *. This means it sent it out every minute until I caught it and fixed it.

Also noticed in there that stock vB is sending out reminders at 1 days and 5 days already, are folks disabling that stock reminder when using this one?

Darat

09-06-2006 11:47 AM

Just want to check something about this mod.

If I install this and I have a member who changes their email address (we verify email addresses so their usergroup gets set to "Users Awaiting Email Confirmation" until they've "re-activated" their account) and they don't confirm their new address this won't delete their account will it?

sabret00the

09-06-2006 01:09 PM

Quote:

Originally Posted by Darat

nope this only deletes users with zero posts.

sabret00the

09-06-2006 01:10 PM

Quote:

Originally Posted by aciurczak

personally i just change the stock vB activation cronjob to point to this one.

Darat

09-06-2006 02:27 PM

Quote:

Originally Posted by sabret00the

nope this only deletes users with zero posts.

That's great - thanks very much for this hack - saved me some housekeeping.

All times are GMT. The time now is 06:11 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.01524 seconds Memory Usage 1,844KB 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 (4)bbcode_php_printable (12)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: