Jan 05
Un-Activated User Management 3.1
xn--vcsx75gvhj1xc.comif 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.
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 (http://www.vbulletin.org/forum/member.php?u=73578)
I want to not delete but move usergroup(e.g. banned usergroup).
What can I do?
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?
personally i just change the stock vB activation cronjob to point to this one.
It's that crazy scheduling that makes this kind of goofy.
The vB control panel is only showing one account for that membername. How would I go about checking the database and fixing it if indeed that's the problem?
Thanks in advance for any help that you guys can provide.
Like many others, I never let anyone in UAEC to post :) They can't post before they activate their account. My board has been running for years, it has thousands member. Half of them had never activated their account after registration. I installed this hack in January 2008 to encourage them to activate their account. This hack sent emails to members in UAEC after 3,5,8 days. Even UAEC member before I installed this hack got the email. It's all good.
But in my case, this hack doesn't delete them after 10 days. In my database, I can see I still have thousands UAEC member who registered since begining of the site. That's what I'm trying to say... :)
Any hints? Thanks :)
;)
Jaymz
Ok, I solved my problem. I don't know about others, but I had to rename the manageActivation.php to manageactivation.php <-- No uppercase "A" on "activation" and edit the scheduled task .php name to reflect my change (all lowercase). It works now... :) :up:
The olny thing I did was this: http://www.vbulletin.org/forum/showpost.php?p=1088327&postcount=54 (Thanks to Team17).
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?
/install
Is there a similar mod for those who have not posted?
Are you certain the member didn't do something odd or forget to do something (e.g., hit the "Save" button after changing the email address)?
The user registered on 25.07.2007 and was a regular and activated member, changed the email address on 10.10.2007 and got deleted yesterday. So this script seems only to compare two values, the registration time and the status of activation.
This means if a long time member changes the email and doesn't activate before the cronjob start than this member will be deleted. In the Activation Reminder Report mail, this user is listed too as deleted user.
Yes it does work with 3.6, such as Version 3.6.8 latest
Stop debating and install it - great add-on which saves a lot of admin time. I've had it installed for some time now over three or four upgrades at least. No problems with it at all and no conflicts with any other add-ons.
Exactly. I figured it would stop working after an upgrade or two but it just keep doing what it is meant to do - great mod.
That's the reason then: The post count was still zero.
Can someone give me in lamers terms how to set the cron up.. Hehehe Stupid here needs to know :)
can someone explain it to me thanks
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:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
Thank you.
Ok i installed it.. Wondering if i should follow that image that was shown above.. if so then i did everything right.. :)
manageActivation Complete;
3 Day Reminder Sent To: FlaTroN, FlaTroN, dna bg, dna bg, tony de sousa, tony de sousa.
5 Day Reminder Sent To: senteniel, senteniel, sandu_chirita, sandu_chirita.
8 Day Reminder Sent To: None.
Users Deleted: Denver474.
Inactivity based on last post = No
You must have been talking about this mod, right?
http://www.vbulletin.org/forum/showthread.php?t=138946
:)
BTW, I had a little problem here. I clean installed the mod, it sends email to members who haven't activated their account as stated. But after 2 months installed, it seems never delete any single member from the database... any clue? :erm:
I'd guess that the majority of non-activated users for many forums, including mine, are invalid email addresses. In the "tech support" section, we have a post explaining how to avoid filters using the address book or whitelist.
If they haven't activated their memberships, they won't be able to read their PMs. That's why email is used.
I wouldn't give unactivated members access to PMs. That's just begging for PM spam, especially since the spammer doesn't even have to provide a valid email address in order to be able to access the forum members.
I see. It would be good to to override that. The EZbounced email hack overrides this, so it must be possible to add this feature. I think this would be very effective in helping with unactivated user management.
:confused: Overiride what? The Ez Bounce add-on doesn't send PMs.
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
Replace with the next:
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
Awesome, thank you!
Database error in vBulletin 3.6.3:
Invalid SQL:
SELECT u.username, u.userid, u.email, u.joindate, ua.activationid, u.languageid
FROM vb_user u
LEFT JOIN vb_useractivation ua ON (u.userid = ua.userid)
WHERE u.usergroupid = 3 AND u.posts = 0;
MySQL Error : Can't open file: 'vb_useractivation.MYI'. (errno: 145)
Error Number : 1016
Date : Friday, November 24th 2006 @ 04:30:40 AM
Script : http://www.physiobob.com/forum/admincp/cronadmin.php?do=runcron&cronid=9
Referrer : http://www.physiobob.com/forum/admincp/cronadmin.php?do=modify
IP Address : 81.149.142.220
Username : physiobob
Classname : vb_database
Any ideas
This means if a long time member changes the email and doesn't activate before the cronjob start than this member will be deleted. In the Activation Reminder Report mail, this user is listed too as deleted user.
he had zero posts?
Thank you.
I read all the posts on this, and seen there was some questions by others that wasn't really answered correctly.
This is what I did.
1) upload manageActivation.php to the forums/includes/cron folder
2) in my control panel I added this product product-uam3_sabret00the.xml
3) I setup a cron job, "varname" was an issue, see my pic
http://www.ickie.net/varname.jpg
4) turn on this plugin, see pic
http://www.ickie.net/look.jpg
I hope this helps
Big-Up :) to you for doing the screenshots, without the screenshots I would not have installed this hack.
clicks install :D
The majority of inactivated users are caused by spam filters.
If they haven't activated their memberships, they won't be able to read their PMs. That's why email is used.
I've installed this hack and on my test account I get the 3 day warning on the 3rd and 4th days, the 5 day on the 5th and 6th etc. I've made some modifications to the script, I hope they are useful to others:
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
This casts $day to an integer (rounding .5 up and anything under down)
I think before I was getting a mail when $day was 2.5 and when it was 3.5.
Additionally I've changed the if commands to the form:
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
since they will now be exact numbers.
Database error in vBulletin 3.6.3:
Invalid SQL:
SELECT u.username, u.userid, u.email, u.joindate, ua.activationid, u.languageid
FROM vb_user u
LEFT JOIN vb_useractivation ua ON (u.userid = ua.userid)
WHERE u.usergroupid = 3 AND u.posts = 0;
MySQL Error : Can't open file: 'vb_useractivation.MYI'. (errno: 145)
Error Number : 1016
Date : Friday, November 24th 2006 @ 04:30:40 AM
Script : http://www.physiobob.com/forum/admincp/cronadmin.php?do=runcron&cronid=9
Referrer : http://www.physiobob.com/forum/admincp/cronadmin.php?do=modify
IP Address : 81.149.142.220
Username : physiobob
Classname : vb_database
Any ideas
Run a repair on your useractivation table.
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?
nope this only deletes users with zero posts.
Set up your cron job to run the script once a day using vBulletin's default system "Scheduled Tasks"
please tell me step and step
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
Any user with zero posts who is deleted by changing an email address faces the minor inconvenience of re-registering. Not a big deal, in my opinion. The main worry I had (setting all the member's posts to "Guest") cannot occur, as far as I can see.
Not as far as I know, no.
Ez bounce turns all email notification off, so sending out more emails is no issue.
I definitely still get bounce-backs regarding the "PM full" or "PM almost full" emails so it is an issue.
And I know I used to get additional bounce-backs for notifications - I suppose that may have been in an earlier version.
But that said, this is the Un-Activated User Management Thread. Perhaps further discussion about EZ Bounce should continue in that thread.
But for those that you want to install it just read the readme file and you will be able to install it with no problem.. Just try not to change things that you don't understand how it works etc.. If you do you will get DB errors (like some people here are getting).. But anyhow this hack works great for me and it has been working for awhile now.. ^.^ But on a side note to those that do install it.. Remember once the list of "Users Awaiting Email Confirmation" runs out this hack stops working until you get more people that haven't activated there accounts, then u will see the email again..:) Good luck to everyone
The majority of inactivated users are caused by spam filters.
The fact that EZ Bounce sends that PM is actually a bit annoying. If the member's registration email address is invalid, and the member is close to the limit for stored PMs or has PM email notification turned on, EZ Bounce generates 2 or 3 bounced emails instead of just the original. It's a little like the problem of autoreplies, where you get emails bouncing all over accomplishing nothing useful.
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?
Was the post in a forum where post counts would be incremented?
Inactivity based on last post = No
I feel daft now as I didnt look hard enough.
Thanks for your help!
VinylJunky
Cheers
Thanks for the info
ARABIC Lang in Attachment
:up:
We approve all new account registrations and that means when someone changes an email address we have to re-approve the account. And that can take 24 hours or more and we've never had one instance when a member who has made posts has had their account deleted.
So if this is the case it can only happen to accounts with zero posts so it's not going to be a very serious in practice problem. (Since it will only delete an account with zero posts so that member would have the slight inconvenience of having to re-register but they could use the same user-name, email address and so on, again in practice not much more work than changing an email address.)
So this hack is great!
seems like you got the filename wrong, change it to "./includes/cron/manageActivation.php".
Inactivity based on last post = No
Set the inactivity based on the last post made by the user. If set to no, the inactivity will be set by the last activity field (ie, when the member last visited)
That's what it supossed to be :) One of it's job is to delete certain member after registration, if they don't activate their account after 10 days. Right?
I don't understand what you mean about single members.:confused:
If you allow posts in UAEC group the hack will not delete them.
Like many others, I never let anyone in UAEC to post :) They can't post before they activate their account. My board has been running for years, it has thousands member. Half of them had never activated their account after registration. I installed this hack in January 2008 to encourage them to activate their account. This hack sent emails to members in UAEC after 3,5,8 days. Even UAEC member before I installed this hack got the email. It's all good.
But in my case, this hack doesn't delete them after 10 days. In my database, I can see I still have thousands UAEC member who registered since begining of the site. That's what I'm trying to say... :)
Any hints? Thanks :)
;)
Jaymz
I have around 10 000 UAEC, Will this hack "once installed" consider them as new accounts and does this :
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
OR : since it's been more than 10 days that the accounts were created, it will Delete them automatically ?
You'd need to modify the code a bit for 20 days.
The way it works now is it sends reminder emails at 3, 5, and 8 days after registration. After that, if the member hasn't validated the registration by 10 days, he or she is deleted.
Can someone give me in lamers terms how to set the cron up.. Hehehe Stupid here needs to know :)
vB Version 3.6.7
???????????????
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
Replace with the next:
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
HAHA!!! Ok, I'm on medication! Nobody laugh!!! There it was all the time. :confused: Thanks! I got it it working now. Great hack! *goes to click install*
That's not the purpose of this add-on. This only affects members who register but never validate their accounts by following the activation link in the email verification message. Some of those are likely bogus email addresses; others may have changed their minds about joining. But either way, they are not going to be posting.
I see. It would be good to to override that. The EZbounced email hack overrides this, so it must be possible to add this feature. I think this would be very effective in helping with unactivated user management.
sabret00the, can you confirm that the add-on also checks for zero posts? I have temporarily disabled this on two forums until I can verify that it won't delete a member who has posted.
Excuse me DJBaxter, I did not intent to focus the discussion on EZBounce. I only mentioned specific functions to illustrate functional possibilities for your hack, not in order to compare. Un-Activated User Management is something different and should not be compared.
This is an excellent hack, can you show us how you have set up your cron job as I really want and need this.
r
Same problem. Is there any solution to this?
Good thing i guess...
I think he had zero post but I'm not sure. I'll try to do a test with my test account.
Und gehts?
Yes, indeed. Can someone fix this?
that is indeed what i am saying.
Maybe, but this script should not do that. I have some paying members and I think they will not understand why they get deleted.
This may be an idea to solve this problem, but it would be better if the hack could check the registration date too.
I have long time members that have never posted. They come to my site to download quizzes and play games. To me they are valuable as they keep coming back and hence see my Google Ads.
This is a great mod but I agree that it needs to check the registration date :rolleyes:
Any chance this can be coded in?
Thanks
VinylJunky
So do I. You have the option of setting the add-on to check for last activity instead of last post, which is what I've done. If they log-in, even if all they do is play games, that updates last activity so they'll won't receive an email.
FIND (line 63)
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
REPLACE WITH
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
Actually, this is sabert00the's add-on, not mine, so it would be up to him. :)
That said, I wouldn't want a PM solution for this add-on personally. If it were added as an extra option (email and/or PM), I suppose that would work because I'd just turn off the option for PMs.
That's great - thanks very much for this hack - saved me some housekeeping.
No, was in a testforum where posts are not counted.
What can I do?
this is untested but in the manageActivation.php find:
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
and replace with
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
however consider this whole post unsupported, i.e. any problems arrise i won't solve them.
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.. :)
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/3065/unactivatedusersvbmanagerscreenhh8.th.png (http://img77.imageshack.us/my.php?image=unactivatedusersvbmanagerscreenhh8.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 :)
Unable to solve the fatal error issue. vBulletin support says there's something wrong with the mods and they can't help.
Anyway, thanks to the author for the effort ... :)
Email users to remind them to activate account
ActivationID created to 7018
Deleted 7018
ActivationID created to G. W. Gill
Deleted G. W. Gill
Fatal error: Call to a member function query_first() on a non-object in XXXX/includes/class_mail.php(266) : eval()'d code on line 4
Regards,
Badger
People who have several thousand posts should not have their accounts deleted simply because they have gone on holiday before they could reactivate their account.
And where in the hack instructions does it say it doesn't delete members with > 0 posts?
If this is the case (and I hope it is since it's a good thing) then it should certainly say so in the instructions.
thanks
Patrick
www.phonexpo.ie
I've been using this through several upgrades now and I've never seen that happen. In fact, the add-on sends out emails daily listing who got the 3-day, 5-day, and 8-day warnings so I can't even imagine how anyone would be deleted by the add-on after one day.
Are you certain the member didn't do something odd or forget to do something (e.g., hit the "Save" button after changing the email address)?
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
will phrase the cronlog ?
This mod would be really helpful to me if I could get it working.... :)
Any suggestions would be appreciated.....
BTW, I run v1.09 of the Inactive Users Email mod, the Manage Bounced Email mod, plus all of the standard vBulletin email sending processes and they work fine, so I know my system can handle the sending of emails.
Line 4 in class_mail.php is just the start of the module and it's comments only, so I don't understand why this mod has a fatal error there? :confused:
Regards,
Badger
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
you didnt do something right I have had this installed since they released it with no errors at all.
And I clicked "installed this hack" ofcourse.:)
It's that crazy scheduling that makes this kind of goofy.
goto VBULLETIN OPTIONS/Un-Activated.... and turn it off
However, recently the reports are showing that one user in particular is receiving an e-mail twice. The membername is listed twice in the reports each time, even though obviously this person only has one account.
Is there anything that can be done to fix this?
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
nope, afraid not, this just goes off of days.
Thank you.
I read all the posts on this, and seen there was some questions by others that wasn't really answered correctly.
This is what I did.
1) upload manageActivation.php to the forums/includes/cron folder
2) in my control panel I added this product product-uam3_sabret00the.xml
3) I setup a cron job, "varname" was an issue, see my pic
http://www.ickie.net/varname.jpg
4) turn on this plugin, see pic
http://www.ickie.net/look.jpg
I hope this helps
1. The notification emails are being sent every day rather than on the 3rd, 5th, 8th and 10th day. Is there any way to manipulate/fix this? I have created a test account and confirmed that the 3rd day email was sent on days 3 and 4, the 5th day email sent on days 5, 6, and 7, etc...
2. How can I edit/customize the email text?
vB Version 3.6.7
Yes. It works fine on 3.6.7 and 3.6.8.
Might install this, still debating it ...
Stop debating and install it - great add-on which saves a lot of admin time. I've had it installed for some time now over three or four upgrades at least. No problems with it at all and no conflicts with any other add-ons.
This means if a long time member changes the email and doesn't activate before the cronjob start than this member will be deleted. In the Activation Reminder Report mail, this user is listed too as deleted user.
If this is confirmed, that's a serious problem with this add-on. :eek:
Thank you, sabret00the.
www.azadiwelat.org
Interestingly, in the earlier scenario I posted about a few days ago, when the 5-day report was sent to the previous 3-day duplicate member, he was only shown once in the 5-day report.
Will my users get all these too?
I've set it for once a day, at 12 via cron
This may be an idea to solve this problem, but it would be better if the hack could check the registration date too.
I first thought there was a phrase missing. Maybe you can phrase it?
A bug: it deletes members who set a new email address and don't confirm it by reactivating their account (after one day already).
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
See this post: right here. (http://www.vbulletin.org/forum/showpost.php?p=1069238&postcount=38)
Not sure if it is in the hack's original instructions or not.
Thats great! What do I need to change?
Many Thanks
VinylJunky
PM is sent to Member notifying them of bounced email & asking them to update email address
Got this message below on the screen when it ran, but never received an email, so... anyone help me out as to the problem?
Also, I assume the good news is that it deleted two users who had never validated their email link and it was more than 10 days ago?
Email users to remind them to activate account
ActivationID created to 7018
Deleted 7018
ActivationID created to G. W. Gill
Deleted G. W. Gill
Fatal error: Call to a member function query_first() on a non-object in XXXX/includes/class_mail.php(266) : eval()'d code on line 4
I XXXX'd out some link data for privacy..
Thanks ... :)
Regards,
Badger
I think it unlikely that anyone would have paying members with zero posts - and if they do, there's something wrong (or at least very odd) with the configuration of your forum. Maybe rethink the number of forums that do not count toward post counts?
Ez bounce turns all email notification off, so sending out more emails is no issue.
I don't understand what you mean about single members.:confused:
If you allow posts in UAEC group the hack will not delete them.
#If you have any other info about this subject , Please add it free.# |