vb.org Archive - Un-Activated User Management 3

Page 1 of 4

Last »

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

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

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

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

sabret00the

10-27-2005 10:00 PM

Un-Activated User Management 3

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.

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.

Oblivion Knight

10-28-2005 01:22 PM

https://vborg.vbsupport.ru/showthread.php?t=99132

Perhaps with this you could include the add-on for the final product? ;)

sabret00the

10-28-2005 01:23 PM

Quote:

Originally Posted by Oblivion Knight

https://vborg.vbsupport.ru/showthread.php?t=99132

Perhaps with this you could include the add-on for the final product? ;)

nice one, should've checked for that.

Snake

10-28-2005 02:11 PM

Screenshots?

sabret00the

10-28-2005 02:13 PM

Quote:

Originally Posted by Aftermath

Screenshots?

you're joking right?

jugo	10-28-2005 03:02 PM

n00bs...lol...Just kidding...

Thanks Sabret00the....

reteep

10-28-2005 03:05 PM

Useful, thanks!

Snake

10-28-2005 03:47 PM

Quote:

Originally Posted by sabret00the

you're joking right?

Nope I'm not. What's there to joke here?

sabret00the

10-28-2005 03:53 PM

Quote:

Originally Posted by Aftermath

Nope I'm not. What's there to joke here?

it's a cron job, if i gave you a screenshot it would be of the admincp and i'm sure you can just log in to check that yourself, this does all of it's work behinds the scenes so theirs nothing to see.

Jenta

10-28-2005 04:46 PM

Quote:

Originally Posted by Oblivion Knight

https://vborg.vbsupport.ru/showthread.php?t=99132

Perhaps with this you could include the add-on for the final product? ;)

also the templates themselves :)

sabret00the

10-28-2005 06:13 PM

anyone managed to get me some feeback on the emails yet?

Man1c M0g

10-28-2005 08:30 PM

Quote:

Originally Posted by sabret00the

anyone managed to get me some feeback on the emails yet?

Well, the admin e-mails seem to work just fine. Here's an example of the output I got:

Quote:

manageActivation Complete;
3 Day Reminder Sent To: riggzy, Purpose, shireen_ashr, Phantasia, hammer1973, iocrisro, boscopoll, thebears, kitty666, 147258, dukkareddi, Xander_Max, Pondy, spiriteddragon, n64man120, BricolaJeador, kaesone, alaitoc, jlpun.

5 Day Reminder Sent To: yo111, latte, thedevildk, Mover&Shaker, CBR, solutionair, nightwisper, c9ine, Sassa, al-anood, kewl cat, supergirl, xecrYpt2k, hiimscammell, davieschoots, joseph, m_07k_x, aaaaa.

8 Day Reminder Sent To: HopeHacker, shaker, marcelberlin, doks, geo, edobe, wisp, tgraphic, PhoenixJones, solar91, basker_bsk, nonicked, cjava, nizki, batangmanila, every2ndibleed, roseenglish, Cribbson.

Users Deleted: Redbrother.

sabret00the

10-28-2005 08:45 PM

Quote:

Originally Posted by Man1c M0g

Well, the admin e-mails seem to work just fine. Here's an example of the output I got:

nice one, what about the ones that are sent to members?

Man1c M0g

10-29-2005 05:59 AM

Quote:

Originally Posted by sabret00the

nice one, what about the ones that are sent to members?

Hmmmm... it doesnt seem to have sent them. Its working in all other respects (i.e. deletes unregistered users over 10 days old, sends e-mails to me, etc), but it isn't sending reminders to the members. I've definately followed your instructions to the letter, added all the templates, etc (well, all except your 'addon' - is this bit essential? What exactly does it do?).

Mr Chad

10-29-2005 08:01 AM

Quote:

Database error in vBulletin 3.5.0:

Invalid SQL:

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

MySQL Error : Unknown table 'DB_user' in where clause
Error Number : 1109
Date : Saturday, October 29th 2005 @ 05:00:43 AM
Script : http://www.Site.com/admincp/cronadmi...cron&cronid=18
Referrer : http://www.Site.com/admincp/cronadmin.php?do=modify
IP Address : 24.126.252.18
Username : Name
Classname : vb_database

I get this

sabret00the

10-29-2005 09:33 AM

Quote:

Originally Posted by Man1c M0g

i'll get to working on the fix

sabret00the

10-29-2005 09:33 AM

Quote:

Originally Posted by chatbum

I get this

ok i'll fix that at the same time as i upload the other fix

kadafi_alive

11-01-2005 06:52 AM

Any news sabretoothe?

Regards

sabret00the

11-01-2005 08:10 AM

Quote:

Originally Posted by kadafi_alive

Any news sabretoothe?

Regards

t'was the weekend, i'll get to fixing it today :)

sabret00the

11-01-2005 11:37 AM

ok newest beta is out, could someone let me know if the emails are being sent now or not please, they should be but i need to check :)

Man1c M0g

11-01-2005 06:33 PM

Quote:

Originally Posted by sabret00the

ok newest beta is out, could someone let me know if the emails are being sent now or not please, they should be but i need to check :)

It now sends the e-mails just fine... but I'm not getting any contents in the actual e-mail... its firing blanks! LOL!

kadafi_alive

11-05-2005 06:28 AM

Any news sabretooth?

sabret00the

11-05-2005 07:47 AM

Quote:

Originally Posted by kadafi_alive

Any news sabretooth?

sorry been a hectic week with other work, as soon as time allows i'm gonna get rid of the templates and use the phrase system instead.

Bellinis

11-05-2005 11:00 AM

Sounds like a very usefull extension! Thanks so far sabretooth.
I'll keep an eye on this one and install it as soon as it's more stable ;)

Paul M

11-06-2005 01:05 PM

While you are fixing things, please make this into a product so that the templates (or phrases) are created automatically. :)

sabret00the

11-06-2005 01:10 PM

Quote:

Originally Posted by Paul M

While you are fixing things, please make this into a product so that the templates (or phrases) are created automatically. :)

gotta learn how to do that, but i'll try.

Boofo

11-06-2005 01:22 PM

Quote:

Originally Posted by sabret00the

gotta learn how to do that, but i'll try.

IM me and I will walk you through it. ;)

ZGeek

11-06-2005 09:27 PM

I've just installed this on my board. I set up a user thats unactivated and set the registered day back 3 days and ran the cron job.

Now it keeps sending emails repeatedly to this user, one every minute or so.
I set the cron to run every 23 hours.

Any ideas on this?

ikastara

11-09-2005 07:23 AM

running v3b2, i get this:

Quote:

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;

any idea what i did wrong ??

Paul M

11-09-2005 07:26 AM

Quote:

Originally Posted by ZGeek

Sounds like you didn't set the minutes in the cron job, so it's running every minute.

sabret00the

11-09-2005 08:06 AM

Quote:

Originally Posted by ikastara

running v3b2, i get this:

any idea what i did wrong ??

i'm gonna need the error number.

Lapsetur

11-09-2005 09:04 AM

I also get this error

Quote:

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

11-09-2005 09:07 AM

nice one, i can fix it :)

Lapsetur

11-09-2005 09:13 AM

I am just waiting for you here :lol:

Lapsetur

11-09-2005 10:44 AM

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

Quote:

vb3_user.posts = 0;

Flow Fusion

11-09-2005 11:25 AM

Great hack. Thanks.

Lapsetur

11-12-2005 05:44 AM

Quote:

Originally Posted by sabret00the

nice one, i can fix it :)

Any improvement ?

ikastara

11-12-2005 12:37 PM

Quote:

Originally Posted by sabret00the

i'm gonna need the error number.

exact same arror as Lapsetur
any improvements ?

Paul M

11-12-2005 12:43 PM

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

11-12-2005 01:42 PM

Quote:

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.

All times are GMT. The time now is 02:59 AM.

Page 1 of 4

Last »

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01451 seconds Memory Usage 1,837KB 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 (4)bbcode_php_printable (26)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: