Un-Activated User Management 3

[sabret00the]

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.


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.


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]

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

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

[sabret00the]

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]

Screenshots?

[sabret00the]

Screenshots?

you're joking right?

[jugo]

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

Thanks Sabret00the....

[reteep]

Useful, thanks!

[Snake]

you're joking right?

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

[sabret00the]

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]

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]

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

[Man1c M0g]

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:


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]

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]

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]

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/cronadmin.php?do=runcron&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]

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?).

i'll get to working on the fix

[sabret00the]

I get this

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

[kadafi_alive]

Any news sabretoothe?

Regards

[sabret00the]

Any news sabretoothe?

Regards

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

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

[Man1c M0g]

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]

Any news sabretooth?

[sabret00the]

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]

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]

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

[sabret00the]

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]

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

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

[ZGeek]

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]

running v3b2, i get this:

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]

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?
Sounds like you didn't set the minutes in the cron job, so it's running every minute.

[sabret00the]

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/cronadmin.php?do=runcron&cronid=21
Referrer : http://www.turkonline.tv/v6/admincp/cronadmin.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]

nice one, i can fix it :)

Any improvement ?

[ikastara]

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 ;

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

Should be this ;

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

:)

[Lapsetur]

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

In the manageActivation.php file

This line ;

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

Should be this ;

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

:)


WoooW It's working now. Tanx alot.

[Lapsetur]

Question deleted. Sorry

I gotit. I changed the hour to 9 now it shows up next day.

[kadafi_alive]

Lapsetur, can you confirm if it's sending e-mails (with content)?

[Lapsetur]

Here is an example from today's action.

manageActivation Complete;
3 Day Reminder Sent To: canavar, amocan, redmone, avukat02, hhhh, runo35, bracket, kimim1, otstick, M16, akca, ekrem14, hendenoğlu, S@L!H, seremana, burakaksu76, southstar20, atacam.

5 Day Reminder Sent To: erkandokuyucu, ahmetgulacar, harbiye55, MAVİDERTYILDIZI, mehmetdev, saidkibar, Nahır?n?, han, muratkaya43, afs, cemix, aybuge, aşks?rg?n?, husrin.

8 Day Reminder Sent To: shinein mohd, orhan ylberi, armefe, gokhanonal, smdsk23, odogan, bulent.genc, yağızosman, JEFFY, uyduuyudu, uyelik269, asimavi.

Users Deleted: almora, figo_mzy, pireilhan, SEZZ.

And it works, some people came back to finish their activation.

[sabret00the]

ok here's a new beta version, however it really needs a hacker to check on it, as this is the first ever product and i'm not sure if i done it right or not.

hint: paul m ;) ;)

just for the record the cron doesn't reflect the xml file as i'm not efven sure it works, however i'm working on that as we speak to hopefully b4 should look more like an RC

scrap that, here's beta4

[Lapsetur]

If we install this one shall we delete the templates we have created from previous MOD.

[sabret00the]

If we install this one shall we delete the templates we have created from previous MOD.

not yet.

[Lapsetur]

Well the before one is just working fine for me at the moment.

I think I'll wait for the comments and final results

In "product-u_a_m_sabret00the" same warnings available

[sabret00the]

thanks, i'm trying to get everything sorted out now.

[hardgainer]

Is the new version uploaded here yet because I am still getting this error:

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 'Body text = 'a:3:{s:23:\"ActivationEmail_v3_Day3\";s:1135:\"Dea
Error Number : 1064
Date : Wednesday, November 16th 2005 @ 04:24:25 PM
Script : http://www.hardgainer.co.uk/*******/plugin.php
Referrer : http://www.hardgainer.co.uk/******/plugin.php?do=productadd
IP Address : 195.*.*.*
Username : ********
Classname : *******

[sabret00the]

new stable version up: beta5, should remove all errors :)

(only thing i'm not sure about is the emails being sent)

[Snake]

Thanks for the update...

[admin0]

Hi,

Is it possible NOT to delete accounts, but just send them emails ?
Perhaps every X days ? for now ;)

[sabret00the]

Hi,

Is it possible NOT to delete accounts, but just send them emails ?
Perhaps every X days ? for now ;)

that's kinda already a feature as stock but stops before this one i think
you could make this send em up until the 8th day then not at all, anything else would require another hack.

[Paul M]

new stable version up: beta5, should remove all errors :)

(only thing i'm not sure about is the emails being sent)
Working fine on my test system.

[sabret00the]

Working fine on my test system.

thanks paul, so emails being sent now too?

[Paul M]

thanks paul, so emails being sent now too?The e-mails were always being sent, the problem was that they had no subject or body, which means many isp's would block them as spam. They now have the correct body/subject.

[sabret00the]

The e-mails were always being sent, the problem was that they had no subject or body, which means many isp's would block them as spam. They now have the correct body/subject.

ah ok, nice one. so i can remove the beta tick now then?

btw thank you, you've been a great help with the support you've offered in here :)

[admin0]

what about users older than 10 days? will it auto delete ?

I am looking for sending emails x number of days to have them activate their account.

[sabret00the]

it sends an email on the 3rd day, the 5th day then 8th day and then deletes users on the 10th day.

[Man1c M0g]

ah ok, nice one. so i can remove the beta tick now then?

It now works an utter charm! Many thanks Sabret00the! :D

[Paul M]

ah ok, nice one. so i can remove the beta tick now then?I would think so, not that you need permission.

btw thank you, you've been a great help with the support you've offered in here :)Always happy to help with things we actually use, this being one of them.

[Lapsetur]

Shall I delete the old one's templates before installing this new one

[sabret00the]

Shall I delete the old one's templates before installing this new one

no need to do so before, but they will need deleting at some point.

[jluerken]

Hey sabret00the,

what about an option in the admincp to NOT delete the users after 10 days but to MOVE them into another usergroup?

[admin0]

Yeah.

Would like not to delete them, but give them a chance to click their activation email.

Cheers,

[Paul M]

Yeah.

Would like not to delete them, but give them a chance to click their activation email.

Cheers,If they haven't done this after 3 reminder emails, and 10 days, they probably never will. Besides which in our experience, 90% plus of those that fail at the 10 day point are because they supplied an invalid e-mail address, so they never get any e-mails, hence will never activate. :)

[kadafi_alive]

But won't this provide a problem to longtime users who recently changed their e-mail but supplied an incorrect e-mail.

For example, a member with 1000 posts changes his e-mail but forgots to add that extra letter. He will be automatically moved to usergroup 3 (awaiting email..) till he confirms his e-mail but what if he never receives his e-mail due a type and assumes that everything is okay. Won't his account be deleted after 10 days?

[sabret00the]

But won't this provide a problem to longtime users who recently changed their e-mail but supplied an incorrect e-mail.

For example, a member with 1000 posts changes his e-mail but forgots to add that extra letter. He will be automatically moved to usergroup 3 (awaiting email..) till he confirms his e-mail but what if he never receives his e-mail due a type and assumes that everything is okay. Won't his account be deleted after 10 days?

nope, it only deals with users with 0 posts

[poolking]

Going to remove the beta tick? ;)

[sabret00the]

Going to remove the beta tick? ;)

oops forgot about that. done.

[Paul M]

I have noticed one problem with the e-mails ;


.
.
.
Please to be sure not to add extra spaces. You will need to type in your username and activation number on the page that appears when you click on our copy the above link in your browser.

Your Username is: xxxxxx
Your Activation ID is: 16725952



If you are still having problems signing up please contact a member of our support staff at

Thanks very much,
Cable Forum TeamYou will notice that the e-mail address for support contact is missing.

[djr]

Thanks, installed!
You will notice that the e-mail address for support contact is missing.$webmasteremail needs to be replaced with $vboptions[webmasteremail]

[Paul M]

Ah cheers, that'll save me looking at it. :up:

[bspiller82]

I have yet to get any emails. I've had this installed for about a month now and nothing.

[sabret00the]

Thanks, installed!
$webmasteremail needs to be replaced with $vboptions[webmasteremail]

nice one, i'll fix that.

I have yet to get any emails. I've had this installed for about a month now and nothing.

they're not going into junk or anything like that?

[WNxWakko]

I dont want to get the email telling me who was deleted and notified. How do I turn that off?

[bspiller82]

they're not going into junk or anything like that?

No, no junk folders. I also have a registered user who has yet to activiate his account from Nov. 8th, 2005 and he has yet to be deleted.

[sabret00the]

I dont want to get the email telling me who was deleted and notified. How do I turn that off?

comment out line 161

[sabret00the]

No, no junk folders. I also have a registered user who has yet to activiate his account from Nov. 8th, 2005 and he has yet to be deleted.

uninstall then reinstall the hack.

[loonytune15]

OK If i install this today, will it delete any users who are already been unactivated for over the 10 days. Had my forum open for a fair while and wanted to know if i am about to lose 100 members in one hit?

[sabret00the]

OK If i install this today, will it delete any users who are already been unactivated for over the 10 days. Had my forum open for a fair while and wanted to know if i am about to lose 100 members in one hit?

yes it will.

[loonytune15]

hmm I might have to think about that one.
Is there a way to have it so when they activate they account they then post as well?

[sabret00the]

hmm I might have to think about that one.
Is there a way to have it so when they activate they account they then post as well?

like make it automatically make a post for them?

[Paul M]

OK If i install this today, will it delete any users who are already been unactivated for over the 10 days. Had my forum open for a fair while and wanted to know if i am about to lose 100 members in one hit?If they haven't activated then they aren't really members are they, just wasted database space ....

[loonytune15]

like make it automatically make a post for them?

No, this might have to be a seperate hack but still goes along the same lines, basically to email non-posting members that they need to post.

My forum is setup so when you posts once the rest of the forum becomes active to them.
I have a number of registered users just a lot of non posters.

[bspiller82]

uninstall then reinstall the hack.

Looks like the product was never installed. I imported it and we will see if I get emails now :).

[Ramsesx]

Before I will install, only one question, it's 100% impossible this hack deletes by an error all members of my board? Thanks

[sabret00the]

Before I will install, only one question, it's 100% impossible this hack deletes by an error all members of my board? Thanks

it's 100% impossible it deletes anyone who's not in the "currently awaiting email" usergroup and even then they need 0 posts.

[Ramsesx]

Ok thanks sabret, installed.
But have one more question, I have a german language board, does it send the normal reminder email or need I do some translations? If no, where can I translate it and is it possible to use phrases?
And, need I manually set up the cron job or does it automatically, if no how I need to do the settings because I am not so familiar with cron job things.
Thanks a lot, very useful and timesaving hack.

[AWI]

Installed on 3.5.2....thanks

[lanc3lot]

Hey sabret00the,

what about an option in the admincp to NOT delete the users after 10 days but to MOVE them into another usergroup?


Hello, great hack, it will save me a lot of work:)

I searched the thread, and havent found a reply on this one, can this been done? Yes i know that it maybe a waste of db if u keep them, but i need this :)

Thnx in advance

[Tefra]

thanks great plugin saves me a lot of time

[sabret00the]

Ok thanks sabret, installed.
But have one more question, I have a german language board, does it send the normal reminder email or need I do some translations? If no, where can I translate it and is it possible to use phrases?
And, need I manually set up the cron job or does it automatically, if no how I need to do the settings because I am not so familiar with cron job things.
Thanks a lot, very useful and timesaving hack.

sorry had no idea that you posted this. it was before my christmas break.

anyway it's done by phrases :)

and you need to manually set the cron up

[sabret00the]

Hello, great hack, it will save me a lot of work:)

I searched the thread, and havent found a reply on this one, can this been done? Yes i know that it maybe a waste of db if u keep them, but i need this :)

Thnx in advance

i didn't reply to that? i thought i did. sadly it's outside of the scope of my desires for this hack, especially regarding supporting the hack. the hack can be hacked to acheive that quite easily.

[Ramsesx]

sorry had no idea that you posted this. it was before my christmas break.

anyway it's done by phrases :)

and you need to manually set the cron up
Thanks sabret, no prob I could get it running and so far it saves me know a lot of annoying work.
Happy new year.

[lanc3lot]

i didn't reply to that? i thought i did. sadly it's outside of the scope of my desires for this hack, especially regarding supporting the hack. the hack can be hacked to acheive that quite easily.


Damn, if its easy for you, can u release it on a thread, so i can do it?

Have no idea how to fix this, and its very usefull for me:( Hope u find little time and just tell :)

[lanc3lot]

Can someone plz tell me how i set up the cron job?

[DF-inside]

Can someone plz tell me how i set up the cron job?
I think it should be done this way
http://www.action-inside.com/images/atomic/manage-activation.jpg

Can someone validate it that the above picture is filled in with correct information?

[Paul M]

No - you need to set the minutes to something as well.

[lanc3lot]

Ok is working just fine.

One question though, can someone tell me what is the title of the email that send you after the notifications are sent to the users (the sum up i mean).
So i can find it phrase and translate it too :)

[DF-inside]

No - you need to set the minutes to something as well.
Indeed, I was getting mails since hour 23 was at the forums.
But then, when I set:

http://www.action-inside.com/images/atomic/manage-activation-2.jpg

Doesn't it send out mails every day at 23:25h then?

maybe someone who can make a correct screenshot of the cron setup?

[Paul M]

Doesn't it send out mails every day at 23:25h then?Yes. Once a day.

[Brother]

How about the users whom waiting active from Mods ?

and is there any way to disable deleting?

[vietfancy]

great hack, it will save me a lot of work

[Paul M]

How about the users whom waiting active from Mods ?

and is there any way to disable deleting?If you have users waiting to be moderated after three days then you should probably review your working methods.

[Xplorer4x4]

I really suggest informing users on how to set up the cron job, or taking this to the next level and having the product add the cronjob automaticlly.

Also setting the cron job to Hour 23 and minuetes to 0(the first box on the left) doesnt this run the cron job every day? The hack is supposed to do this only X days so how is it possible that this operates the way stated?

[catalin8]

I believe there might be another problem with the script. I have installed it yesterday and it has deleted about 1000 of my members. Everything looks good in the Usergroups > Usergroup Manager, from the 1000 Users Awaiting Email now there are only 56.

The problem is on the forum's main page at Site Statistics. There, the number of members hasn't been changed. Maybe you could look into this. And in the mean time somebody tell me what's the table db vbulletin fetches the Site Statistics from, so I can adjust members number there

thank you

[Xplorer4x4]

Use the update counters function in the matience menu of the admin cp and update counters. Use the Update usernmaes or perhaps rebuild the forum ststaistics.

[EasyTarget]

* EasyTarget installs
I believe there might be another problem with the script. I have installed it yesterday and it has deleted about 1000 of my members. Everything looks good in the Usergroups > Usergroup Manager, from the 1000 Users Awaiting Email now there are only 56.

The problem is on the forum's main page at Site Statistics. There, the number of members hasn't been changed. Maybe you could look into this. And in the mean time somebody tell me what's the table db vbulletin fetches the Site Statistics from, so I can adjust members number there

thank youit doesn't count unactivated users as members does it? if that's the case you wouldn't need to change anything.

[RS_Jelle]

Any word about a vBulletin 3.6 version? :)

It gives a database error when running the task with it (vB 3.6).

[sabret00the]

what's the error for 3.6?

[jluerken]

what's the error for 3.6?

If I run this with 3.6 everything seems to run normally

[RS_Jelle]

When I run it manually, the first part works good:
Un-Activated User Management
Sent 8 Day email to xxx
Sent 8 Day email to xxx
But then, there's the error:
Database error in vBulletin 3.6.0:

Invalid SQL:

INSERT INTO useractivation
VALUES
(NULL , 13188, 1154907330, 84391481, 0, 2);

MySQL Error : Column count doesn't match value count at row 1
Error Number : 1136
Date : Monday, August 7th 2006 @ 01:35:30 AM
Script : http://www.ivanhoejupiler.be/admincp/cronadmin.php?do=runcron&cronid=24
Referrer : http://www.ivanhoejupiler.be/admincp/cronadmin.php?do=modify
IP Address : xx.xxx.xx.xxx
Username : Jelle
Classname : vb_database

Also check this bug report (http://www.vbulletin.com/forum/bugs36.php?do=view&bugid=639). So I think there's a missing 0 at the end of the INSERT query for vBulletin 3.6.0 :)

[sabret00the]

When I run it manually, the first part works good:

But then, there's the error:


Also check this bug report (http://www.vbulletin.com/forum/bugs36.php?do=view&bugid=639). So I think there's a missing 0 at the end of the INSERT query for vBulletin 3.6.0 :)
thank you very much, i'll post a 3.6 complient version in the morning.

[bongwater]

the time specified -- is it the administrator's local time specified in the control panel, or is it the time on the host server?

-bongwater

[sabret00the]

thank you very much, i'll post a 3.6 complient version in the morning.
oops totally forgot about this. tomorrow morning for sure. i'll sleep with this page on my monitor.

[crxrocks]

Thanks! This is one of my favorite hacks!

[crxrocks]

Whoops. It looks like I am having a problem. I uploaded the include .php file to the cron directory and imported the new product, overwriting the existing one. Here is the error
Prune Users Awaiting Confirmation
ActivationID created to xxxxx

Fatal error: Call to a member function on a non-object in /home/thezcres/public_html/forums/includes/cron/manageActivation.php on line 63

The line of code it is references is

$vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "post SET username = '" . $db->escape_string($user['username']) . "', userid = 0 WHERE userid = " . $user['userid']);

Any ideas?

I forgot to mention that this is a 3.6 install.

[crxrocks]

Nevermind. There are two copies of these files contained in the distribution a 3.6 version and a 3.6.0 version. I had originally uploaded the 3.6 version so I replaced it w/ the 3.6.0 version and it worked well.

Thanks!

Chris

[dtdesign]

Nevermind. There are two copies of these files contained in the distribution a 3.6 version and a 3.6.0 version. I had originally uploaded the 3.6 version so I replaced it w/ the 3.6.0 version and it worked well.

Thanks!

Chris

Which is which ?

[sabret00the]

attachment updated, removes duplicate directories.

[dtdesign]

Wow ! that's what I call fast response - thanks dude !

[dtdesign]

Actually odd question my daily cron job points to ./includes/cron/activate.php should it not point to ./includes/cron/manageActivation.php ?

[sabret00the]

it should indeed. you only need either one or the other, either vBulletin's default cron reminder "activate.php" or this one "manageActivation.php".

[dtdesign]

Sweet ! And back working as per usual - thanks for a great hack !

[Hornstar]

Just wondering if this is possible in this aleady, if not maybe a simple request for someone to help me with.

I would like to only delete the account if they have not visitied the site in 100 days, and have not activated their account and they have 0 posts.

the reason why this is, some of my active members have not activated their accounts, but because they became premium members, they didnt have too, because they ended up having permission to post and all the rest.

I have had members not come to the site for several months, and then start posting again, thus why I only want to delete people with 0 post count as well.

so if this is possible I would love it as I would change it to email them 3 days, 1 month, 2 month, 3 month, 4th month delete if those conditions applied, or something like that.

Thanks.

[perfphysio]

Can you please provide a screen shot of what the scheduled task settings would look like to have this setup to run once a day? Many thanks

[SloppyGoat]

I find it annoying to receive an email each day, even if nobody was even deleted, so I removed the email notification. I hope it still works.

Would it be just this part I remove?

vbmail("" . $vbulletin->options['webmasteremail'] . "","Activation Reminder Report (Activation Notification)", $logmessage, "From: \"" . $vbulletin->options['bbtitle'] . " Mailer\" <" . $vbulletin->options['webmasteremail'] . ">");
}

Here, I think, is the file with no daily email update. Someone correct me if it's wrong.

[perfphysio]

Some of my user still are having problem getting the activation reminder links to work.

Often they get the following message

"Invalid User specified. If you followed a valid link, please notify the administrator "

Can anyone shed some light on how this might occur?

[perfphysio]

I find it annoying to receive an email each day, even if nobody was even deleted, so I removed the email notification. I hope it still works.

Would it be just this part I remove?

vbmail("" . $vbulletin->options['webmasteremail'] . "","Activation Reminder Report (Activation Notification)", $logmessage, "From: \"" . $vbulletin->options['bbtitle'] . " Mailer\" <" . $vbulletin->options['webmasteremail'] . ">");
}

Here, I think, is the file with no daily email update. Someone correct me if it's wrong.

Maybe they can have an option to turn this on or off? Or to select a specific email to send it two rather than admin for archival purposes? I find it very useful just to know that it is working consistently. Also to see the group in the 3 day reminder shrink by the deleted day list of people.

:)

[home9000]

Is it working in 3.6.5 ?

[blackvborg]

and in 3.6.7?

is it possible to customize the emails sent to the users? or it just send again the standard confirmation email?

[tintin74]

I've upload the file in the cron directory, I've import the product but nothing appear on Crontab section.

I'm using 3.6.8

[GTX2]

still supported this mod?

I need to know if this hack works on 3.6.4 and if does not conflict with Email reminder for inactive users hack, Version: 1.11 here: https://vborg.vbsupport.ru/showthread.php?t=138946

thanks

[BirdOPrey5]

Any chance anyone is running this on 3.8?