Email Reminder for inactive users

[mailshuxin]

Chinese installation

Tested on vbulletin suite 4.0.4

[caciocode]

Great! Thanks. Just installed on this Programming forum (http://www.sheersoftware.com)

[caciocode]

Reapet* Bad connection

[Lostboyfan]

What a great mod. This will help my site alot

[domi681]

Hello, I downloaded and installed, but now I do not know how to modify the text that is sent to the user, I want to translate it into Spanish.

Help please.

Greetings.

[jakobility]

Any news about a version for vB 3.8.x? :)

[BadgerDog]

A heads up ... :)

I've been using this add-on for a few years, right through from v3 and it's great. Thanks for bringing it forward to v4 of vBulletin.

I've encountered my first SQL error with it... I've substituted X's for security...

Database error in vBulletin 4.0.4:

Invalid SQL:
INSERT INTO inactiveuserlog (username,userid,dateline,validemail,email)
VALUES ('Tester's MFG','xxxxx','1282997017','1','jay@xxxxxx.com');

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 's MFG','xxxxx','1282997017','1','jay@xxxxxx.com')' at line 2
Error Number : 1064
Request Date : Saturday, August 28th 2010 @ 08:03:37 AM
Error Date : Saturday, August 28th 2010 @ 08:03:38 AM
Script : http://www.xxxxxx.com/admincp/cronadmin.php?do=runcron&cronid=102
Referrer : http://www.xxxxxx.com/admincp/cronadmin.php?do=modify

I believe the problem is the apostrophe in the user name. I re-ran the cron job after changing the user name, simply eliminating the ' before the S and the cron job ran fine, although I'm not sure it actually processed this record a second time.

Am I correct in my assumptions? Why would vBulletin accept registration from a user with an apostrophe then this mod fail on the SQL insert?

Thanks for any feedback... :)

Regards,
Badger

[Mrdby]

does this work?

[djbaxter]

does this work?

No. Not at all. People just download it and install it and then it sits there doing nothing. It's a placebo. :rolleyes:

[Mrdby]

No. Not at all. People just download it and install it and then it sits there doing nothing. It's a placebo. :rolleyes:
AWESOME! NOW SCRAM!

[marinelife]

worked for me, check you scheduled tasks and see when it is going to run.

[BadgerDog]

does this work?

Works really well, but it crashes on usernames who have an apostrophe in them ... ;)

Other than that, I've been using it for years and it's really helpful ... :)

Regards,
Badger

[Mrdby]

Works really well, but it crashes on usernames who have an apostrophe in them ... ;)

Other than that, I've been using it for years and it's really helpful ... :)

Regards,
Badger

thanks!

[TalkVirginia]

Hi guys! Sorry I haven't updated this in a while. Life has not been very forgiving since the last release February 2010. My computer had a melt down and I just recently found a job full time last month. I've even had to take my own site (TalkVirginia) down temporarily. I am planning another release but I still have a few things on the priority list that I need to clear first. Thank you all for your patience and for enjoying this addon.

~ Jim

[TalkVirginia]

Works really well, but it crashes on usernames who have an apostrophe in them ... ;)

Other than that, I've been using it for years and it's really helpful ... :)

Regards,
Badger

It's still doing that? :confused: Ok, I'll have another look at that. Is there anyway you can PM me some examples of what it's crashing on?

Thanks

[TalkVirginia]

A heads up ... :)

I've been using this add-on for a few years, right through from v3 and it's great. Thanks for bringing it forward to v4 of vBulletin.

I've encountered my first SQL error with it... I've substituted X's for security...



I believe the problem is the apostrophe in the user name. I re-ran the cron job after changing the user name, simply eliminating the ' before the S and the cron job ran fine, although I'm not sure it actually processed this record a second time.

Am I correct in my assumptions? Why would vBulletin accept registration from a user with an apostrophe then this mod fail on the SQL insert?

Thanks for any feedback... :)

Regards,
Badger

Yes, you are correct in your assumptions.. I did suggest a manual fix for this though. Below is the link for it:

https://vborg.vbsupport.ru/showpost.php?p=2016892&postcount=164

Sorry it took so long for me to get back to you.

Thank you for asking about this Badger,
~Jim

[BadgerDog]

Y
Sorry it took so long for me to get back to you.

Thank you for asking about this Badger,
~Jim

No problem Jim ... :)

Thanks for following up back here and I do understand how real life gets in the way of our hobbies ... :D

This mod is probably the most valuable of any we use. It continually reinforces with our members that we're still here and we also use it as a tool update them on new additions to the board that might find of interest.

Thanks for keeping it alive and relevant through multiple iterations of vBulletin. :up:

The single most useful enhancement we could have to it (in my opinion) would be the automatic handling of bounced emails, that we now handle manually through this separate add-on mod in conjunction with yours.

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

Even though it's for v3, it still functions fine in v4.04 and it would be great if that author would give you permission to incorporate his code into yours here, as it would save us hours in manually dealing with bounced inactive email accounts.

Thanks again .. :)

Regards,
Badger

[ETDC]

Can anyone confirm this works ok on 3.8.6 ? :)

[TalkVirginia]

Can anyone confirm this works ok on 3.8.6 ? :)

Sorry, not at the moment, but I have been looking into making it work with that version.

[ETDC]

Thanks. :)

[sulasno]

Question 1;

Usergroups
Which usergroups do you want to monitor for inactivity?

Excluded User IDs
List the userids that you do not wish to send reminder email to here.

Must Excluded User IDs be part of Usergroups ?

Question 2;

Inactivity Emails: Receive Inactivity Reminder Email from Administrators

Members will receive an email if they have been inactive for more than 7 days. If you do not wish to receive these emails, you may optout by unchecking this option.

How do I change 7 days to 30 days ?
How do I remove this option ?

[mradlin]

Installed.

[Gene Steinberg]

Still flaky.

For example, the Unsubscribe feature appears to be non-functional.

For example, I got this letter today from one of our forum members:

i have unsubscribed already. i just tried again, and got the same message i told you about before:

"Our records indicate that your subscription to our mailing list has already been cancelled. Please contact an Administrator if you believe you've reached this message in error."

but i keep getting messages asking me to come back to the forums.

how am i supposed to make them stop if you can't remove my address?

That member isn't the only one. When will there be a fix?

Peace,
Gene

[asylum119]

Perfect

Installed and MOTM

thanks

----- EDIT -----

I wont be using this if the above post is true

Can-Spam act and inbox deliverability go hand in hand, They are both my friend

[adwolf1]

Tagged. As soon as that feature where it can detect bounces, flag the user & send a PM is ready, will install & PayPal a much deserved contribution :) (seriously, that final feature would be absolutely killer for those of us with larger forums.)

[onesexforum]

hi i uploaded the files in the upload folder into the root. But when i hjave to import the xml file there are 2 of them! they are:

bitfield_remindermail.xml and cpnav_remindermail.xml

Do you mean that we have to upload the other file that isn't in the upload folder and import that file, which is called:

product-remindermail.xml

bit unsure what to do here :S sorry bit of a novice!

[onesexforum]

ok sorry for being stupid done it now :D

[vBB-vietnam]

it have problem with special character like
~ ' ".......

[newz12]

Does it work on 4.08?

[jpbryan]

Installed > Does Great > Rated Excellent > Nominated for MOTM

Thanks,,

[Silencer Groans]

Is there a possibility to make it work with 3.8?

[XiTCLUB]

good work
working on 4.0.7

[Bob_R]

Will install when problem as per post #273 is fixed. :)

[sarangan]

In VB 4.0.8 emails are sent from "unknown sender" :( Please check and fix this issue.
Yes this happens for all emails that were send from my VB.. It was about 57809 emails to 57809 members.
See this screenshot:

[gurler]

hello!.
How can I include a RSS Feed or latest threads from forum to sent emails in HTML format. ?

It will increase the traffic i think.

or any other idea?
more users can donate like me if this option is available.

[sarangan]

hello!.
How can I include a RSS Feed or latest threads from forum to sent emails in HTML format. ?

It will increase the traffic i think.

or any other idea?
more users can donate like me if this option is available.

Why not use Feedbuner og services smiliar to that instead?

[gurler]

how ?

[sarangan]

how ?

Search in Google and findout.

[gurler]

how can feedburner know my users last login time ?

[DemoniK_AK]

great mod, use it for gaming site to ensure we maintain a set of active clan members

Just 1 Q
Is it possible to get a summary of how many reminders have gone to what users?
I've set it so users must post every 3weeks, if they don't the inactive reminder kicks in and will send the reminder 3 times with a gap of 3 days and it works really well..
What I now need is to identify those guys who have received the reminders and decide to either reset the reminders (if they were on hols for example) or delete their user accounts if they've received all 3 (even if email wasn't sent).

[kevbentz]

Looks like the extra quotes in the username are causing it. There are 2 places to change that should fix it. To fix this manually, do the following:

1. Open the reminderemail.php file in the {forumroot}/includes/cron folder
2. Scroll down and insert the following code after 361, just before the line where $sql = "INSERT INTO " is getting set:

$username = addslashes($username);

3. Save and close the file.

4. Open the inactivitylog.php file in your admincp folder
5. Scroll down to line 133 and replace it with the following line of code.

$username = stripslashes($log['username']);


That should do it. I'll upload a new zip with this fix this weekend.

I'm still getting this error and I believe it is because the value inserted into the database is $this _username and not $username:

$sql = "INSERT INTO " . TABLE_PREFIX . "inactiveuserlog (username,userid,dateline,validemail,email)
VALUES ('$this_username','$userid','". TIMENOW ."','$valid','$toemail')";

Error:

INSERT INTO inactiveuserlog (username,userid,dateline,validemail,email)
VALUES ('userna' me','xxx','xxxxxxxxxx','x','xxxxxxxxxxxxxxxxx');

[diabolicds]

Hi,

Working like charme with 4.08 thx installed

Cheers

[RollaJedi]

is it possible to send the contents of the email to a post each day for others to see who is missing? thank you

[creativepart]

I'm using the HTML mail and the 4 "icon" images are missing. They aren't in the download, and I can't locate them in older versions of this mod.

Anyone know the whereabouts of those images?

[creativepart]

Nevermind, I found some on the net. Here they are if anyone wants them. They may not be exactly the same as the originals, but they're close and named correctly. Put these in your forumroot/images/icons folder.

[iyama]

Members get a reminder already after 10 days.
Setting is on 120 days. :p

Using vb4.1 pl2

So i have uninstal it.

[S3Ponline]

Has anyone tried this on vb4.1 pl2? Does it work?

[fluidswork]

Really this will help me out ..........

[sulasno]

all of a sudden I am not getting the daily emails while in 4.0.8;
mail system is working

have updated to 4.1.0 PL2; do I need to reinstall this mod ?

[onehost]

another DOA mod?

How do i even know this works...

no test functions for admin?

[TalkVirginia]

My apologies to everyone for not staying on top of this mod for several months. Suffice it to say that life has had me busy in other areas. I think things are under some level of control at this point and I can safely say I'll be picking this mod back up in January 2011.

For more good news, I've asked for permission the author has given me their blessing to use the code from the previous ezBouncer mod (https://vborg.vbsupport.ru/showthread.php?t=138884) in this mod so it will be a bit easier now to track bounced reminders.

I'll be going back through the threads here and will address these issues in the next update. If you have any questions, please let me know and I'll do my best to answer them.

Thank you
Jim

[OldSchoolDSL]

My apologies to everyone for not staying on top of this mod for several months. Suffice it to say that life has had me busy in other areas. I think things are under some level of control at this point and I can safely say I'll be picking this mod back up in January 2011.

For more good news, I've asked for permission the author has given me their blessing to use the code from the previous ezBouncer mod (https://vborg.vbsupport.ru/showthread.php?t=138884) in this mod so it will be a bit easier now to track bounced reminders.

I'll be going back through the threads here and will address these issues in the next update. If you have any questions, please let me know and I'll do my best to answer them.

Thank you
Jim

I look forward to your updates and thank you for your continued support.

Happy Holidays :)

[ricardo-c]

It's not working correctly. I get mails from user reminder letting me know that it wasn't able to send mails to email addresses that I know for sure that are valid and can receive the notifications o reminders.

This is because one of them is my mailbox that I use with a test user that I created some time ago.

Is there a bug that doesn't let it work correctly?

[gamerzhut]

Waiting for your update!
Cheers

[demonfatal]

+1 waiting for an update working with last vB versions...

[The Rocketeer]

+1 waiting for an update working with last vB versions...

+1 waiting for a mod like you to come into my life..+1 waiting:erm:

[iyama]

How many days can a user go before they are considered inactive? = 80 days

Members geth mail after 8 days :D Maybe setup to 800 ?

[sarangan]

When I prune logs, forum sends me this error to my email:

Database error in vBulletin 4.1.1:

Invalid SQL:
DELETE FROM inactivitylog WHERE dateline < 1292315794;

MySQL Error : Table 'forum.inactivitylog' doesn't exist
Error Number : 1146
Request Date : Thursday, January 13th 2011 @ 09:36:37 AM
Error Date : Thursday, January 13th 2011 @ 09:36:37 AM
Script : http://www.*.com/admincp/inactivitylog.php?do=doprunelog
Referrer : http://www.*.com/admincp/inactivitylog.php?do=prunelog
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.0.51a-24+lenny4-log

[pantani]

Nice Mod
Thanks for it

Works ok here ;)

[MAdotcom]

Installed. Thanks!

[KittyWireless]

It seems, on our installation, that the outgoing email address in the headers of the outgoing messages is not set correctly. This is causing an issue with our mail server. How do we modify the outgoing email address on the message that is sent to the admin after processing?

[OldSchoolDSL]

Really hoping for an update on this..... (Please & thank you)

If no update, does this work on 4.1.1 ?

[MAdotcom]

For some reason no emails are showing up in the log and I have enabled the log feature...

[Gene Steinberg]

A key feature for me is to automatically place bounced emails in a separate, predefined, usergroup.

Also, the unsubscribe feature doesn't seem to work. We get complaints about that. Please fix.

Peace,
Gene

[erinys]

doesnt work on 4.1.1 .. gives mysql errors on execution.

[gsmlover4u]

need update for vb 4.1.1

[oddmud]

I'm getting this error when trying to reply to the email sent out:

Your message did not reach some or all of the intended recipients.

Subject: RE: Goalie Crease Network misses you Ron Veit!
Sent: 09/02/2011 9:35 AM

The following recipient(s) cannot be reached:

'Goalie Crease Network' on 09/02/2011 9:35 AM
Server error: 'Invalid recipient'


The from section of the email going out to the users looks like this:

admin@goaliecr ease.net; on behalf of; Goalie Crease Network <"Goalie CreaseNetwork"@ps27959.dreamhostps.com>

Shouldn't it just be from the admin@goaliecre ase.net ? (spaces added on purpose just for this forum)

[Mark4865]

Any plans for 4.1.1 update

[Fungsten]

Any plans for 4.1.1 update

Same here.

[Alibass]

Works well on my 4.1.1 site.

[TalkVirginia]

Any plans for 4.1.1 update

What errors are you running into?

[TalkVirginia]

I'm getting this error when trying to reply to the email sent out:

The from section of the email going out to the users looks like this:

Shouldn't it just be from the admin@goaliecre ase.net ? (spaces added on purpose just for this forum)

Yes it should. Will look into this.

Thanks

[Gene Steinberg]

A key feature for me is to automatically place bounced emails in a separate, predefined, usergroup.

Also, the unsubscribe feature doesn't seem to work. We get complaints about that. Please fix.

Peace,
Gene

Can you update me on this? I don't want to have spam complaints sent to my host or domain registrar.

Peace,
Gene Steinberg

[TalkVirginia]

Can you update me on this? I don't want to have spam complaints sent to my host or domain registrar.

Peace,
Gene Steinberg

I wish I had something definitive as far as a fix, but in all honesty, I was able to start working on the addon again within the last week or so. I had to take a break from it for many reasons including family, and work. In the mean time, while I'm working on fixes and new features, I'd recommend either turning the addon off or perhaps increase the amount of time inbetween when reminders go out. This weekend I am going to go through this thread and gather up all the issues everyone is currently having. I know some are still having issues with special characters in usernames. There are also some back end things I'd like to clean up too. Please let me know if you have any questions.

Thanks
Jim

[ifitsmedia]

Thanks for this mod, it sounds like a brilliant idea.

I am running 4.1.2... will it work for me?

[TalkVirginia]

Thanks for this mod, it sounds like a brilliant idea.

I am running 4.1.2... will it work for me?

It should work ok. Please let me know if you run into issues with it and I will look into it.

Thanks
Jim

[ifitsmedia]

Thanks. I installed it and have tested it to send mail to one of my own user accounts. It works great in 4.1.2 except for one thing - the "From" email that it sends from is blank. My forum sends emails and they show up from the webmaster email and have the site name on them, but this one sends them with no sender at all.

Also, for a future feature it would be nice to be able to send test messages right from the plugin settings page. Just enter an email to test it and send one right then.

[TalkVirginia]

Thanks. I installed it and have tested it to send mail to one of my own user accounts. It works great in 4.1.2 except for one thing - the "From" email that it sends from is blank. My forum sends emails and they show up from the webmaster email and have the site name on them, but this one sends them with no sender at all.

Also, for a future feature it would be nice to be able to send test messages right from the plugin settings page. Just enter an email to test it and send one right then.

Sounds good. Thanks for letting me know. I'll look into that this weekend.

[maineGuy72]

where can i get those icons that you have in your screen shots for html emails?

[TalkVirginia]

where can i get those icons that you have in your screen shots for html emails?

hmmm... I thought I had zipped them with the addon. Thanks for catching that. :)

I've attached them to this post.

[Footman]

Seems odd.

I'm getting the admin email that states who gets the reminder email and noticed a couple of members seem to be getting their reminder emails every day but no one else.

I'm running 4.1.2.

[TalkVirginia]

Seems odd.

I'm getting the admin email that states who gets the reminder email and noticed a couple of members seem to be getting their reminder emails every day but no one else.

I'm running 4.1.2.

This is a known error and one of the things I'm working on fixing. I'm hoping to have a new version soon. Just depends on how much "me" time I get.

[ifitsmedia]

Have a bit more info on the blank "from" email problem. Whenever this mod sends emails to a member the "from" is totally blank, and when it sends a report stating that it sent at least one email the "from" on that report email is also blank. However, if it does not send any emails to users then when it send the report stating it had no email to send it comes with the "from" filled in with my forum name.

Strange eh?

[TalkVirginia]

Have a bit more info on the blank "from" email problem. Whenever this mod sends emails to a member the "from" is totally blank, and when it sends a report stating that it sent at least one email the "from" on that report email is also blank. However, if it does not send any emails to users then when it send the report stating it had no email to send it comes with the "from" filled in with my forum name.

Strange eh?

Thanks for the info. Do you have the webmaster field in Vb options filled in? I don't have the code in front of me since I'm at work but if I remember correctly there is also an optional field under the addon settings. Do you have anything set there?

If you wouldn't mind and have a chance, could you provide some screen shots on how you have the addon configured? Hopefully I can reproduce the issue.

Thanks again :)

[Footman]

This is a known error and one of the things I'm working on fixing. I'm hoping to have a new version soon. Just depends on how much "me" time I get.

Ok cool. Appreciate it.

[It's Damn Real!]

Will this work for 4.1.2?

[GTX2]

Will this work for 4.1.2?

Yes, at least i got it working with 4.1.2 but uninstalled because i had huge number of bounces.... waiting for a fix to move bounced members into certain usergroup

[ifitsmedia]

Hi TalkVirginia,

Yes, I have the webmaster field filled in. As I stated earlier, when it doesn't have any inactive users to send me to, the report email looks fine and it comes "from" my forum name. It's only when it has inactive users that the "from" fields are send as blanks. If the name of my forum or wbmaster email were missing in my settings, I don't think it would ever have a "from" sender right?

As requested, here are some screenshots of my settings (one of them is altered for privacy, but you get the idea). If you need anything else let me know.

https://vborg.vbsupport.ru/external/2011/04/55.png

https://vborg.vbsupport.ru/external/2011/04/56.png

[TalkVirginia]

Hi TalkVirginia,

Yes, I have the webmaster field filled in. As I stated earlier, when it doesn't have any inactive users to send me to, the report email looks fine and it comes "from" my forum name. It's only when it has inactive users that the "from" fields are send as blanks. If the name of my forum or wbmaster email were missing in my settings, I don't think it would ever have a "from" sender right?

As requested, here are some screenshots of my settings (one of them is altered for privacy, but you get the idea). If you need anything else let me know.



Thanks for the info! That helps.

[ifitsmedia]

Any luck on finding the "blank sender" issue? I would love to use this mod but I'm holding off until that gets solved. Thanks for the help!

[Domenico]

I get the following error when running the cron:

Database error in vBulletin 4.1.3:

Invalid SQL:
SELECT * FROM user
WHERE lastactivity < '1298193385' AND
emailDate < '1300785385' AND emailCount < '1' AND options & 16 AND usergroupid IN ('2') LIMIT 0, 3;

MySQL Error : Unknown column 'emailDate' in 'where clause'
Error Number : 1054


And when I want to reset the reminders I get this:

Database error in vBulletin 4.1.3:

Invalid SQL:
UPDATE user
SET emailDate = '0',
emailCount = '0';

MySQL Error : Unknown column 'emailDate' in 'field list'
Error Number : 1054


EDIT: Nevermind!
I figured out this had something to do with the old install (after reading the thread) so I completely uninstalled and installed again and now it's working.

[TalkVirginia]

I get the following error when running the cron:

Database error in vBulletin 4.1.3:

Invalid SQL:
SELECT * FROM user
WHERE lastactivity < '1298193385' AND
emailDate < '1300785385' AND emailCount < '1' AND options & 16 AND usergroupid IN ('2') LIMIT 0, 3;

MySQL Error : Unknown column 'emailDate' in 'where clause'
Error Number : 1054


And when I want to reset the reminders I get this:

Database error in vBulletin 4.1.3:

Invalid SQL:
UPDATE user
SET emailDate = '0',
emailCount = '0';

MySQL Error : Unknown column 'emailDate' in 'field list'
Error Number : 1054


EDIT: Nevermind!
I figured out this had something to do with the old install (after reading the thread) so I completely uninstalled and installed again and now it's working.

Good Good! Glad to hear you were able to get it working. :)

[TalkVirginia]

Any luck on finding the "blank sender" issue? I would love to use this mod but I'm holding off until that gets solved. Thanks for the help!


I believe I should be able to release a fix for this and a few other issues in the next week. I've also reworked some of the logic for when reminders are sent out as well as a new reminder template manager.

I am working on adding the email bounce detection and I received the ok to reuse code from a couple addon's that some of you have PM'd me about. It's taking a bit longer to work that into the mix, but I believe it will be good once it gets in there.

[Alan_SP]

Excellent, I'm waiting for new version to start using your mod. :)

[ifitsmedia]

Fantastic, thanks for the update. Looking forward to the fixes. Cheers!

[Gene Steinberg]

I believe I should be able to release a fix for this and a few other issues in the next week. I've also reworked some of the logic for when reminders are sent out as well as a new reminder template manager.

I am working on adding the email bounce detection and I received the ok to reuse code from a couple addon's that some of you have PM'd me about. It's taking a bit longer to work that into the mix, but I believe it will be good once it gets in there.

Thank you. The problem with us is the fact that the ability to opt-out of the mailings is non-functional. I've had to make excuses, but we could get into trouble with that, because of CAN-SPAM requirements and such.

Peace,
Gene

[HMBeaty]

Tagged for now til a fix has been released. Also, could you make the option to receive the email as an on/off option in the AdminCP?

[TalkVirginia]

Thank you. The problem with us is the fact that the ability to opt-out of the mailings is non-functional. I've had to make excuses, but we could get into trouble with that, because of CAN-SPAM requirements and such.

Peace,
Gene

Tagged for now til a fix has been released. Also, could you make the option to receive the email as an on/off option in the AdminCP?

I have some time scheduled to work on these issues on Saturday, this weekend.

[HMBeaty]

I have some time scheduled to work on these issues on Saturday, this weekend.
Awesome! Thanks :)

[TalkVirginia]

Just a quick update before I head off to bed. :) I think I made some good progress on these fixes this weekend with it being Mother's day weekend. Will see how things go this week.

If something seems to not work with the addon or it's sending out too much reminders, please disable it until I can release a new version. I apologize for the inconvience. I'm specifically addressing the opt out issue right now.

Thanks again for your patience.

[S_E_A]

Hello TalkVirginia,

I'm looking forward to using this mod.

I'm slightly confused by your last post. I am relatively new to vbulletin so please bear with me.

Has the mod been updated from last Saturday?
Has the addon fixed previous problems?
Or will the new version (2.1.2) resolve problems plus an on/off option in the AdminCP?

Thank you.

[tintin74]

This is a great mod.

Talkvirginia, I think you could add the possibility to avoid to send email to "Banned Usergroups" or add "Some usergroups to exclude from sending email" ;-)

Thank you

[HMBeaty]

Hello TalkVirginia,

I'm looking forward to using this mod.

I'm slightly confused by your last post. I am relatively new to vbulletin so please bear with me.

Has the mod been updated from last Saturday?
Has the addon fixed previous problems?
Or will the new version (2.1.2) resolve problems plus an on/off option in the AdminCP?

Thank you.
No, this has not been updated yet.

[TalkVirginia]

Hello TalkVirginia,

I'm looking forward to using this mod.

I'm slightly confused by your last post. I am relatively new to vbulletin so please bear with me.

Has the mod been updated from last Saturday?
Has the addon fixed previous problems?
Or will the new version (2.1.2) resolve problems plus an on/off option in the AdminCP?

Thank you.

Thanks for asking. :) Actually I'm in the process of packaging up an update now and will be releasing it tonight.

EDIT: While testing on my live site I discovered a few critical flaws in my logic when querying inactive members. Please don't hate me too much. :( I figured I let you know now, rather than having you all find the bug and hate me later.

This is a great mod.

Talkvirginia, I think you could add the possibility to avoid to send email to "Banned Usergroups" or add "Some usergroups to exclude from sending email" ;-)

Thank you

That should be doable. :) I'll add that into the next version.

[Stefan118]

I received the folowing error:

Database error in vBulletin 4.1.3:

Invalid SQL:
INSERT INTO papegaaienforum_inactiveuserlog (username,userid,dateline,validemail,email)
VALUES ('Sophie'sElmo','1152','1305501022','1','sophietim mer@yahoo.com');

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 'sElmo','1152','1305501022','1','sophietimmer@yaho o.com')' at line 2
Error Number : 1064
Request Date : Monday, May 16th 2011 @ 01:10:22 AM
Error Date : Monday, May 16th 2011 @ 01:10:22 AM
Script : http://www.papegaaienforum.nl/admincp/cronadmin.php?do=runcron&cronid=60
Referrer : http://www.papegaaienforum.nl/admincp/cronadmin.php?do=modify
IP Address : 81.70.161.69
Username : Stefan118
Classname : vB_Database
MySQL Version : 5.0.67-community


I guess it is because the user name has a " ' " in it. (Sophie'sElmo)
Can this be solved?

[TalkVirginia]

I received the folowing error:

Database error in vBulletin 4.1.3:

Invalid SQL:
INSERT INTO papegaaienforum_inactiveuserlog (username,userid,dateline,validemail,email)
VALUES ('Sophie'sElmo','1152','1305501022','1','sophietim mer@yahoo.com');

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 'sElmo','1152','1305501022','1','sophietimmer@yaho o.com')' at line 2
Error Number : 1064
Request Date : Monday, May 16th 2011 @ 01:10:22 AM
Error Date : Monday, May 16th 2011 @ 01:10:22 AM
Script : http://www.papegaaienforum.nl/admincp/cronadmin.php?do=runcron&cronid=60
Referrer : http://www.papegaaienforum.nl/admincp/cronadmin.php?do=modify
IP Address : 81.70.161.69
Username : Stefan118
Classname : vB_Database
MySQL Version : 5.0.67-community


I guess it is because the user name has a " ' " in it. (Sophie'sElmo)
Can this be solved?

I just posted an update with a fix for this.

[TalkVirginia]

Ok everyone,

There it is.. finally after a year of waiting I thank you all very much and I very much appreciate your patience. Let me know how it works for you and if you run into anything. I'm going to start working on next release. :D

[TalkVirginia]

I'll be releasing another update in a day or so. :) Just a file fix.. so all you will need to do is drop in place.

[LOGECT]

Thanks, this is a great mod.
Please fix for this problem:

https://vborg.vbsupport.ru/attachment.php?attachmentid=129115&stc=1&d=1305539588

Thank you.

[TalkVirginia]

Thanks Logect

[Stefan118]

Thanks mate!
Update works great. (rated you exellent)
Yesterday it send 261 mails before it "crashed".
Today after the update it send another 89 mails.

Keep up the good work.
I got 11 active members back allready.

[TalkVirginia]

Thanks mate!
Update works great. (rated you exellent)
Yesterday it send 261 mails before it "crashed".
Today after the update it send another 89 mails.

Keep up the good work.
I got 11 active members back allready.

That's great! but... Crashed?! :eek: What happened? Did it send out too many emails at one time? Let me know if I need to tweak something. :up: :)

[Stefan118]

That's great! but... Crashed?! :eek: What happened? Did it send out too many emails at one time? Let me know if I need to tweak something. :up: :)

No...
With the "crash" i ment the database error i got becouse of the username with the " ' " in it.
After your update it works great!

[TalkVirginia]

No...
With the "crash" i ment the database error i got becouse of the username with the " ' " in it.
After your update it works great!

Awesome! :up: Glad to hear it! :)

[Brandon Sheley]

updated and it looks like it's working

thanks!

[doopz]

Hi!

I was wondering if it's possible to change the FROM: address ?
Right now it seems to be using the site title, but since my site title is rather long it seems to do strange things such as adding quotes and all. Is there an easy way to change the from adres? from: name <name@email.com>

thanks in advance

[TalkVirginia]

Hi!

I was wondering if it's possible to change the FROM: address ?
Right now it seems to be using the site title, but since my site title is rather long it seems to do strange things such as adding quotes and all. Is there an easy way to change the from adres? from: name <name@email.com>

thanks in advance

I'm not sure I understand your example of what you want or are asking.

[doopz]

I'm not sure I understand your example of what you want or are asking.


$uheaders .= "From: " . $vbulletin->options['bbtitle'] . " Reminder Service <" . $webmaster_email .">\r\n";



I don't want the from address to be the bbtitle, but a simple name + email adres.
The bbtitle is messing things up.

Wesley

[TalkVirginia]

$uheaders .= "From: " . $vbulletin->options['bbtitle'] . " Reminder Service <" . $webmaster_email .">\r\n";



I don't want the from address to be the bbtitle, but a simple name + email adres.
The bbtitle is messing things up.

Wesley

I'll try, but there seems to be an issue with changing the email headers in vBulletin or atleast I haven't been able to find info on how to do it. That line of code you're showing in the quote I took out for that reason because it wasn't changing it correctly. It was changing it to "From: Site Title <Site Title>" with quotes around the first Site Title. As soon as I removed the uheaders line it started working correctly. I'll try to work on that more.

[theoutlawed]

Thanks for a great mod, just applied the 2.1.5 update.

This is a great tool to pique the interest of people who may have stayed a week and wandered off, or for while your site is growing to remind people to come back and check things out again.

Bravo, job well done.

[Merenguista]

thanks man ..

[TalkVirginia]

You're very welcome! :)

[ndut]

installed, thank you

[TalkVirginia]

What type of email connection to host do most forum admins prefer? IMAP/POP3? SMTP? This is in regards to checking bounced email.

[doopz]

What type of email connection to host do most forum admins prefer? IMAP/POP3? SMTP? This is in regards to checking bounced email.

I personaly use SMTP as my mail servers are spread among several IP's causing less trouble from providers such as yahoo and hotmail who will block IP's when you're sending large amounts of mail.

But as for bounces I use a pop3 box.

[doobiefillin]

is the latest version 2.1.5 because I got the MySQL Error: 1064 with this version of the plugin.

Database error in vBulletin 4.1.3:

Invalid SQL:
UPDATE user SET rmEmailDate = UNIX_TIMESTAMP(), WHERE TIMESTAMPDIFF(DAY, FROM_UNIXTIME(lastvisit), FROM_UNIXTIME(UNIX_TIMESTAMP())) >= 30 AND TIMESTAMPDIFF(DAY, FROM_UNIXTIME(rmEmailDate), FROM_UNIXTIME(UNIX_TIMESTAMP())) = 30 AND options & 16 AND usergroupid IN ('6','2','') AND rmoptout = 0 LIMIT 10;;

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 'WHERE TIMESTAMPDIFF(DAY, FROM_UNIXTIME(lastvisit), FROM_UNIXTIME(UNIX_TIMESTAMP(' at line 1
Error Number : 1064
Request Date : Friday, May 20th 2011 @ 01:30:51 AM
Error Date : Friday, May 20th 2011 @ 01:30:51 AM
Script : http://www.xxxxxxxxxx.net/forums/cron.php?rand=1305869449
Referrer : http://www.xxxxxxxxxx.net/forums/showthread.php/1041-official-eurokracy-stache-procces!
IP Address : xx.xx.xx.xx
Username : Unregistered
Classname : vB_Database_MySQLi
MySQL Version :

[TalkVirginia]

is the latest version 2.1.5 because I got the MySQL Error: 1064 with this version of the plugin.

Database error in vBulletin 4.1.3:

Invalid SQL:
UPDATE user SET rmEmailDate = UNIX_TIMESTAMP(), WHERE TIMESTAMPDIFF(DAY, FROM_UNIXTIME(lastvisit), FROM_UNIXTIME(UNIX_TIMESTAMP())) >= 30 AND TIMESTAMPDIFF(DAY, FROM_UNIXTIME(rmEmailDate), FROM_UNIXTIME(UNIX_TIMESTAMP())) = 30 AND options & 16 AND usergroupid IN ('6','2','') AND rmoptout = 0 LIMIT 10;;

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 'WHERE TIMESTAMPDIFF(DAY, FROM_UNIXTIME(lastvisit), FROM_UNIXTIME(UNIX_TIMESTAMP(' at line 1
Error Number : 1064
Request Date : Friday, May 20th 2011 @ 01:30:51 AM
Error Date : Friday, May 20th 2011 @ 01:30:51 AM
Script : http://www.xxxxxxxxxx.net/forums/cron.php?rand=1305869449
Referrer : http://www.xxxxxxxxxx.net/forums/showthread.php/1041-official-eurokracy-stache-procces!
IP Address : xx.xx.xx.xx
Username : Unregistered
Classname : vB_Database_MySQLi
MySQL Version :


Thank you for the info - I'll look into this and post a fix as soon as I can.

EDIT: AH, Ok.. I see the problem. If you don't mind and feel like you can make the change yourself. Here's how you can do it.

1. Open the <forum>\includes\functions_remindermail.php
2. Find:

Lines 91 and 212.

"SET rmEmailDate = UNIX_TIMESTAMP(), ";


3. Remove the comma at the end of TIMESTAMP() on both lines.

4. Save the file and you should be good to go.

If you decide you don't want to edit it yourself, I've attached a fixed file to this post. Just drop it in your forum includes folder.

Let me know if you have any other issues.

Thanks,
Jim

[gamerzhut]

Installed & rated.

Thank you sir :)

[TalkVirginia]

Installed & rated.

Thank you sir :)

...and thank YOU! :) Hopefully rated well. :up: ;)

[gamerzhut]

...and thank YOU! :) Hopefully rated well. :up: ;)

RATED ***** :)

[TalkVirginia]

I wanted to post an idea I had for discussion. I was analyzing where inactivity is being based on last post date. Currently there is no other criteria being used so when grace period for inactivity is reached a member will start getting reminders the day after. Granted my plan is to adapt this add-on to something similar to the rules criteria for when notices are displayed, but for now I was thinking that the inactivity criteria should be opened up instead of basing it on one or the other.. (ie. Last Post Date, Last Visit date...) but have the option to base inactivity on last post date if the member's last visit was greater than or equal to whatever number of days you choose. Make sense? I'm open for input and would be interested to hear yours.

Thanks,
Jim

[gamerzhut]

I guess Inactive based on last visit is more than enough. Since it would be bugging out the members if we simply send out the emails. Correct me if i am wrong.

[TalkVirginia]

I guess Inactive based on last visit is more than enough. Since it would be bugging out the members if we simply send out the emails. Correct me if i am wrong.

You are correct. That being said, is there anyone basing inactivity on lastpost date? Would anyone like to see more criteria added similar to the notices? ... or would anyone like me to take lastpost date out all together.

[S_E_A]

Thank you for the info - I'll look into this and post a fix as soon as I can.

EDIT: AH, Ok.. I see the problem. If you don't mind and feel like you can make the change yourself. Here's how you can do it.

1. Open the <forum>\includes\functions_remindermail.php
2. Find:

Lines 91 and 212.

"SET rmEmailDate = UNIX_TIMESTAMP(), ";


3. Remove the comma at the end of TIMESTAMP() on both lines.

4. Save the file and you should be good to go.

If you decide you don't want to edit it yourself, I've attached a fixed file to this post. Just drop it in your forum includes folder.

Let me know if you have any other issues.

Thanks,
Jim

TalkVirginia, should we all make the suggested amendment?

Thank you for an excellent mod.

[TalkVirginia]

TalkVirginia, should we all make the suggested amendment?

Thank you for an excellent mod.

Yes, everyone that has v2.15 installed will need to do this.

[S_E_A]

Thank you :)

[Alan_SP]

You are correct. That being said, is there anyone basing inactivity on lastpost date? Would anyone like to see more criteria added similar to the notices? ... or would anyone like me to take lastpost date out all together.

I use it by last activity, but someone might (maybe even I) use it for both things. If you could as 2 in one, to remind those who didn't log in and didn't write anything in set period. With different messages, what would make it a very long list of settings.

Don't know, bothering users isn't best strategy. Maybe having last activity is enough?

[TalkVirginia]

I use it by last activity, but someone might (maybe even I) use it for both things. If you could as 2 in one, to remind those who didn't log in and didn't write anything in set period. With different messages, what would make it a very long list of settings.

Don't know, bothering users isn't best strategy. Maybe having last activity is enough?

Good points. Thank you for your input. :)

[Stefan118]

An other point.

I have set the inactivity to 60 days (2 months), and last night an user who has last signed in at april 8th got the reminder mail.
An other user has last logd in march 27, and also got an email last night.

Not that I bother, but how comes?

[TalkVirginia]

An other point.

I have set the inactivity to 60 days (2 months), and last night an user who has last signed in at april 8th got the reminder mail.
An other user has last logd in march 27, and also got an email last night.


Not that I bother, but how comes?

What year? :)

[CharlieDelta]

You are correct. That being said, is there anyone basing inactivity on lastpost date? Would anyone like to see more criteria added similar to the notices? ... or would anyone like me to take lastpost date out all together.

Yes. I would like to see more criteria. We would make great use out of both at our forums.

[Stefan118]

What year? :)

Member since december 18 2010 at 21:45
Last activety march 27 2011 at 00:51
last post: december 18 2010 at 22:01

And the other one:
Member since march 4 2011 at 18:45
last activety april 8 2011 at 18:40
last post april 8 2011 at 18:39

This is the setting I have:
Inactivity Grace Period
How many days before a user is considered inactive?
Default: 30 --> manualy set to 60

[TalkVirginia]

Member since december 18 2010 at 21:45
Last activety march 27 2011 at 00:51
last post: december 18 2010 at 22:01

And the other one:
Member since march 4 2011 at 18:45
last activety april 8 2011 at 18:40
last post april 8 2011 at 18:39

This is the setting I have:
Inactivity Grace Period
How many days before a user is considered inactive?
Default: 30 --> manualy set to 60

Is your inactivity grace period based on Last Post or Last Visit?
According to those dates:
If Last Activity is around the same date as Last Post it's been 409 days roughly.
otherwise it's been 56 days.

[Stefan118]

My setting is based on last activity, because my opinion is that you might bother members too often if you set it by last post.

march 27 to may 21 = 55 days
april 8 to may 21 = 43 days

[TalkVirginia]

My setting is based on last activity, because my opinion is that you might bother members too often if you set it by last post.

march 27 to may 21 = 55 days
april 8 to may 21 = 43 days

Agreed. Either Last Visit or Last Activity. Yeah, with 55 days and 43 days, reminders should not be going out that soon. Are you sure you don't have your mod set to be based on Last Post? That's the only way that they would be going out so soon. Make sure you save your mod settings at least once before actually using it. I've noticed that after it's first installed, it will used whatever is in memory at the time it was installed. So I recommend setting it how you want it to operate then click the submit button.

[cbiweb]

My apologies if this issue has already been addressed in this thread, but after reading 10 pages of replies my eyes were glazing over, lol.

I can't tell if it's working because none of my test accounts has received any reminders. They do have valid email addresses. I did receive the following email early this morning:
Members who have become inactive based on their last visit date and never received a reminder email:Emails sent to:
Nixon11,the_mask_lover,hithit,drvenom,MrsWrite,I also ran the cron job manually a few minutes ago, and got this:
Inactive User Reminder Emails
Looking for members who have become inactive (based on their last visit date) and never received a reminder email...

5 inactive members(s) found!
Sent To: ManilaGurL
Sent To: meerulfx
Sent To: Kailash
Sent To: surfville
Sent To: whitemusk

Looking for members who have become inactive (based on their last visit date) and
haven't received a reminder email in the last 45 days...

No inactive member(s) found based on last visit date!

DoneWhich also generated another email to me that said this:
Members who have become inactive based on their last visit date and never received a reminder email:Emails sent to:
ManilaGurL,meerulfx,Kailash,surfville,whitemusk, None of the above user names are test accounts, and shouldn't those be mentioned as well? How can tell if inactive users themselves are actually getting the reminders?

[Stefan118]

I have set the settings AGAIN to last visit date, and guess what...
last night it send another 4 SPAM mails.
SPAM, because it does not follow the settings i have given it.

This member has got a reminder mail last night!

Member since: march 29, 2010 at 9:01
Last visit: may 16, 2011 at 12:04
Last post: may 16, 2011 at 12:04

I am not crazy, my settings are based on last activety, inactive for 60 days.
I did pressed save again after your last post, just to be sure.
Now i'ts sending mail after 9 days!!!

1 more mistake of this program and i uninstall it.
This is spamming my members!

[TalkVirginia]

I have set the settings AGAIN to last visit date, and guess what...
last night it send another 4 SPAM mails.
SPAM, because it does not follow the settings i have given it.

This member has got a reminder mail last night!

Member since: march 29, 2010 at 9:01
Last visit: may 16, 2011 at 12:04
Last post: may 16, 2011 at 12:04

I am not crazy, my settings are based on last activety, inactive for 60 days.
I did pressed save again after your last post, just to be sure.
Now i'ts sending mail after 9 days!!!

1 more mistake of this program and i uninstall it.
This is spamming my members!

Sounds to me like you've already made up your mind. Sorry I couldn't be of further assistance.

[MrAd]

Great Mod, thanks again Jim, quick question will there be a 3.8.x fo this mod ?

[TalkVirginia]

Great Mod, thanks again Jim, quick question will there be a 3.8.x fo this mod ?

3.8.x release? Yes, I am planning to release one for 3.8.x. As for when, soon. I was hoping to release something this week. :erm:

[TalkVirginia]

I've decided to make things a bit easier with the mod so I'm planning on stripping out the logic that will base inactivity on last post and last visit. I'll be basing inactivity on last activity.

[doobiefillin]

Thank you for the info - I'll look into this and post a fix as soon as I can.

EDIT: AH, Ok.. I see the problem. If you don't mind and feel like you can make the change yourself. Here's how you can do it.

1. Open the <forum>\includes\functions_remindermail.php
2. Find:

Lines 91 and 212.

"SET rmEmailDate = UNIX_TIMESTAMP(), ";


3. Remove the comma at the end of TIMESTAMP() on both lines.

4. Save the file and you should be good to go.

If you decide you don't want to edit it yourself, I've attached a fixed file to this post. Just drop it in your forum includes folder.

Let me know if you have any other issues.

Thanks,
Jim

just uploaded the file, will let you know how it goes. thanks!

[TalkVirginia]

Uploaded a new version with the following changes/additions:

UpDate 2.2.0
=================
Removed logic to base inactivity on Last Post or Last Visit date. Inactivity is now based on Last Activity Date.
Removed option to select what to base inactivity on from the mod settings screen.
Fixed a couple typos in SQL update queries.
Exporting the following additional values which can be used in reminder email templates if desired:
$lastvisit - Formatted Date/Time Value - members last visit to the site.
$lastactivity - Formatted Date/Time Value - members last activity on the site.
$lastpost - Formatted Date/Time Value - members last post date on the site.
$lastreminder - Formatted Date/Time Value - Date member was sent last reminder email.
$days_since_lastpost - Number of days since member last posted.
$days_since_lastreminder - Number of days since last reminder was sent.Please let me know if you would like other values made available.

[Gene Steinberg]

We got one serious, serious problem with your new version.

This option:

Usergroups
Which usergroups do you want to monitor for inactivity?

It doesn't work. I've been manually moving bounced messages to another usergroup, since you don't seem to have a proper bounce management system. But that group, although not checked, was sent email anyway. So suddenly I've got hundreds of bounces.

Ouch.

The only group that I checked is Registered Users, by the way.

You gotta fix that one ASAP, and then handle bounce management somehow, such as automatically moving bounced messages to a different usergroup.

Peace,
Gene

P.S. I'm curious about your paranormal research since I happen to host a nationally syndicated radio show, The Paracast, which covers the subject. :)

[TalkVirginia]

Ok will jump on fixing that now. Thanks.

As far as the paranormal research goes... what would you like to know?

[TalkVirginia]

Ok.. give these a whirl. :) This should fix the monitored usergroups issue.


functions_remindermail.php => forumroot\includes folder
process_inactive_members.php => forumroot\includes\cron folder


Please let me know if you run into anything else. Thanks

[Gene Steinberg]

Thanks.

As to the paranormal stuff, I suppose we can take that to my forum. :)

Peace,
Gene

[Stefan118]

I have given this mod another try with the newest update. (2.2.0)

Regarding the problem I had...
Could it be an old bug?
I have read all the posts of this mod, and found 2 other people who had the same problem.
https://vborg.vbsupport.ru/showpost.php?p=2032164&postcount=194
https://vborg.vbsupport.ru/showpost.php?p=2130827&postcount=296

I also have a question.
I have set the "Only send once?" at Yes.

What happens if a inactive user reads the mail, decides to log in again and then in a while becomes inactive again?

Thanks,
Stefan.

P.S.
Might want to take a look at this...
All my members have ID 0?

[TalkVirginia]

I have given this mod another try with the new update.

Regarding the problem I had...
Could it be an old bug?
I have read all the posts of this mod, and found 2 other people who had the same problem.
https://vborg.vbsupport.ru/showpost.php?p=2032164&postcount=194
https://vborg.vbsupport.ru/showpost.php?p=2130827&postcount=296


Those errors should be fixed already. Also, did you drop in these fixed files?
https://vborg.vbsupport.ru/showpost.php?p=2200812&postcount=406


I also have a question...
I have set the "Only send once?" at Yes.

What happens if a inactive user reads the mail, decides to log in again and then in a while becomes inactive again?

Thanks,
Stefan.


They would get only one email regardless. Here's why:
If only sending once
Get members that have been inactive and have never received a inactive reminder.
else (Send emails more than once based on the following criteria)
Get members who have become inactive and have never received a reminder.
Get members who have been inactive and have not received an email since the last reminder was received. This is based on the number of days set in the frequency at which reminders go out ("How often should we send reminder email" setting.
SendReminders
If admin reminder report is enabled
Send Admin reminder reportThat's all there is to it. Any questions? :)

In other words...

If you set the grace period for them to become inactive 60 days from their last activity date. On their 61st day they should get a reminder if they've never received one. This will set a flag so that the next time they become inactive for 60 days they won't get anymore emails if the mod is set to send only one email.

If set to send more than one.. same as above except the mod will look to see if they received an email previously.. and how many days it's been. For instances. If they have been inactive for greater than 60 days, let's say they have been inactive for 150 days and you have the "How often should we send reminder emails" setting set to 30 days, they should recieve an email every 30 days within that 150 day period which would be 2 times (150 - 61 = 89 / 30 = 2.966).

Make sense?

[Stefan118]

Ok, thank you.

I did also upload the 2 modified files.

I modified my last post... you were just ahead of me with posting.

Whow...
Not only the ID is 0...
When I click their names, all the data is gone!!!

[TalkVirginia]

Ok, thank you.

I did also upload the 2 modified files.

I modified my last post... you were just ahead of me with posting.

Whow...
Not only the ID is 0...
When I click their names, all the data is gone!!!

Sorry I was adding a bit more of an example. :)

Ok.. need to give more info.. I don't know what ID you're referring to. What names are you clicking?

[Stefan118]

I added a thumbnail 4 posts up...

The data of the usernames is gone when I click them in the reminder mail log.

Edit:

Pfffff, luckely when i do a search of the email address, all the data of the user shows up.
So only when I click on their names in the log, I get an empty user info.
Exactly the same as when i manualy should add an user. That field I get.

[TalkVirginia]

I added a thumbnail 4 posts up...

The data of the usernames is gone when I click them in the reminder mail log.

Edit:

Pfffff, luckely when i do a search of the email address, all the data of the user shows up.
So only when I click on their names in the log, I get an empty user info.
Exactly the same as when i manualy should add an user. That field I get.

Easy fix... replace this file. upload and overwrite the existing one in your includes folder.

Originially I was doing a "SELECT * .... " in my queries... but I changed it to grab specific fields and forgot about the userid. Thank you for pointing that out. :)

I'll update the zip file now.

[Alan_SP]

If you set the grace period for them to become inactive 60 days from their last activity date. On their 61st day they should get a reminder if they've never received one. This will set a flag so that the next time they become inactive for 60 days they won't get anymore emails if the mod is set to send only one email.

If set to send more than one.. same as above except the mod will look to see if they received an email previously.. and how many days it's been. For instances. If they have been inactive for greater than 60 days, let's say they have been inactive for 150 days and you have the "How often should we send reminder emails" setting set to 30 days, they should recieve an email every 30 days within that 150 day period which would be 2 times (150 - 61 = 89 / 30 = 2.966).

If I understand correctly, mod will send only one email. Even if they return and become inactive again. Can you change this behavior? I'd like that this settings mean that my users are bothered whenever they become inactive after certain period of time I define.

If they come back, they are active. After some time they may become inactive and I want them to remind again.

[Stefan118]

I uploaded the new file...
However, the ID's still are 0, and still no data when I click names.
I even logged out and logged back in.

Anyway...
To improve this mod..

Maybee you can add this in a next update?

A member is inactive for 60 days.
He'll be send an email on day 61.
Member becomes active again.
---------
Member becomes inactive again after several months.
Member gets a reminder again.

That was what I ment a few posts ago.
I only want to send a member 1 reminder mail when they become inactive(I want to bother my members as less as possible)

[TalkVirginia]

Inactivity Log Bug:

When you go to prune the inactivity log, it can not find the
"pruned_inactivitylog_successfully" phrase. In addition, it is unable to locate the redirect page.

This has been fixed in the attached file. Upload the attached file to your AdminCP folder and overwrite. I'll update the product and update the zip in a later release.

To fix the phrase issue manually do this:

Note: It may be necessary to place your site in debug mode for this.

1: Go to Languages & Phrases....
2: Search in Phrases...
3: In the search form, leave all fields at there default except the following:

Search for Text: pruned_inactivitylog_successfully

Search in... Phrase Text and Phrase Variable Name

Click "Find"...

Click Edit in the Phrase Search Results

In the Phrase edit form, change the Phrase Type to "Error Messages".

Leave all other fields as they are.

Click "Save"

If you placed your site in debug mode, take your site out of debug mode now.

You're done.

[Stefan118]

Well done.
I uploaded (overwritten) the inactivitylog.php with the new file...

Pruned the log, and have send 10 mails again...

Thanks,
You fixed it! :up:

[TalkVirginia]

Well done.
I uploaded (overwritten) the inactivitylog.php with the new file...

Pruned the log, and have send 10 mails again...

Thanks,
You fixed it! :up:

Good to hear! :) Now on to the next feature set. ;) Detect bouncing emails :up:

[TalkVirginia]

If I understand correctly, mod will send only one email. Even if they return and become inactive again. Can you change this behavior? I'd like that this settings mean that my users are bothered whenever they become inactive after certain period of time I define.

If they come back, they are active. After some time they may become inactive and I want them to remind again.

Hi Alan,

You have the option to set the mod to send either a single reminder or if you want, you can send multiple reminders. There is also the option to set a maximum limit of reminders. For instance, you only want to send 20 reminders, and they member will not receive anymore after they get the 20th reminder. If the member becomes active, the mod will not reset the reminder count. In addition to this, the inactivity grace period or how long should a member be away from your site to be considered inactive? Some say 30 days, others say 60 days, or maybe 90 days. To completment this setting as I've mentioned in other posts the setting to define how often an member will receive a reminder after they have become inactive.

Does this answer your question?

[socialteenz]

Thank you ;)

Installed & *****

[barmen_1982]

Thank you master

[Charlie98902]

I'm getting this error after uploading all the files then I install the product:

Warning: require_once([path]/includes/functions_remindermail.php) [function.require-once]: failed to open stream: No such file or directory in [path]/includes/adminfunctions_plugin.php(931) : eval()'d code on line 2

Fatal error: require_once() [function.require]: Failed opening required '/home/dvdnextc/public_html/includes/functions_remindermail.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/dvdnextc/public_html/includes/adminfunctions_plugin.php(931) : eval()'d code on line 2

[Charlie98902]

nevermind I forgot one file.

[Alan_SP]

You have the option to set the mod to send either a single reminder or if you want, you can send multiple reminders. There is also the option to set a maximum limit of reminders. For instance, you only want to send 20 reminders, and they member will not receive anymore after they get the 20th reminder. If the member becomes active, the mod will not reset the reminder count. In addition to this, the inactivity grace period or how long should a member be away from your site to be considered inactive? Some say 30 days, others say 60 days, or maybe 90 days. To completment this setting as I've mentioned in other posts the setting to define how often an member will receive a reminder after they have become inactive.

Does this answer your question?

Ok, you confirmed what I thought you said previously.

Is it possible that you program your mod that if members become active that resets reminder count completely for him?

For example, if I set sending only one mail after 30 days of inactivity, member might get back and after some time again become inactive. But, with mod made this way, second time he becomes inactive he wouldn't receive any reminder emails. This isn't good in my opinion.

I think that every inactivity period should be considered separate from all others inactivity periods and treated as such.

You have it now programmed as only one inactivity period that could be interrupted with periods of activity. And this restricts how we can use this mod very much.

If I want to send 20 reminders, I want to send 20 reminders for every inactivity period my users make, not in total for this user.

[TalkVirginia]

Ok, you confirmed what I thought you said previously.

Is it possible that you program your mod that if members become active that resets reminder count completely for him?

For example, if I set sending only one mail after 30 days of inactivity, member might get back and after some time again become inactive. But, with mod made this way, second time he becomes inactive he wouldn't receive any reminder emails. This isn't good in my opinion.

I think that every inactivity period should be considered separate from all others inactivity periods and treated as such.

You have it now programmed as only one inactivity period that could be interrupted with periods of activity. And this restricts how we can use this mod very much.

If I want to send 20 reminders, I want to send 20 reminders for every inactivity period my users make, not in total for this user.

Agreed. Thank you for pointing this out and suggesting the change. I'll look into this.

[CharlieDelta]

I think that every inactivity period should be considered separate from all others inactivity periods and treated as such.

If I want to send 20 reminders, I want to send 20 reminders for every inactivity period my users make, not in total for this user.

This is a must for me as well. We often have users come back upon their first inactive email and then become inactive again.

[Alan_SP]

Agreed. Thank you for pointing this out and suggesting the change. I'll look into this.

Thanks. :up:

[TalkVirginia]

Agreed. Thank you for pointing this out and suggesting the change. I'll look into this.

This is a must for me as well. We often have users come back upon their first inactive email and then become inactive again.

Ok here is a new plugin. It will reset returning inactive members.

1. In your admincp, go to Plugins and Products -> Download/Upload Plugins
2. Scroll to the bottom of the main screen and browse for this plugin after saving it to your hard drive.
3. click Import

Done!

This will reset the reminder mail date and reminder mail count to zero when a returning member logs in.

Let me know if you have any questions or issues. I'll update the zip file as soon as I can.

Thanks

[CharlieDelta]

Ok here is a new plugin. It will reset returning inactive members.

1. In your admincp, go to Plugins and Products -> Download/Upload Plugins
2. Scroll to the bottom of the main screen and browse for this plugin after saving it to your hard drive.
3. click Import

Done!

This will reset the reminder mail date and reminder mail count to zero when a returning member logs in.

Let me know if you have any questions or issues. I'll update the zip file as soon as I can.

Thanks
Thanks Jim.:up:
Great work as always.

[cbiweb]

Could someone please answer my question in post #396 (https://vborg.vbsupport.ru/showpost.php?p=2199791&postcount=396)?

[TalkVirginia]

Could someone please answer my question in post #396 (https://vborg.vbsupport.ru/showpost.php?p=2199791&postcount=396)?

Hi cbi,

My apologies for missing your post. If I may ask, what version of vb are you using?

Both 3.8.x and 4.x.x versions are very similar in code however the difference is in how templates are rendered. I've also fixed some bugs in the mod so I would recommend updating to the current release if you haven't already.

Things to check on test accounts:
All inactivity now is based on last activity of the member.
Make sure they are able to receive emails from the administrator.

What I did when creating a test account is set the join date to like 1/01/2000
and last activity to 1/01/2005. Again, make sure the test account is set to accept emails from the administrators, then manually run the cron task. I'm pretty sure I have the criteria locked down and working at this point if you're using the current recent. Check the recent posts I've made since there are a few patches though and an additional plugin to reset inactive members when they return.

Try that and let me know if you have any more issues or questions.

[Stefan118]

Thank you for the update!

I hope it is working, the upload was very fast, and i couldn't see what happend :D

I will test it tomorrow.

[fwulfers]

For example, the Unsubscribe feature appears to be non-functional.

For example, I got this letter today from one of our forum members:

That member isn't the only one. When will there be a fix?

I am having the same issue and get this message when I click on the Unsubscribe link in the email:
Our records indicate that your subscription to our mailing list has already been cancelled. Please contact an Administrator if you believe you've reached this message in error.

It seems the User ID is missing in the Unsubscribe link in the email. Could that be the problem?

http://mysite.com/optout-reminders.php?u=&e=email@mysite.com

When I view the reports in the inactivity log, ID for all users is showing up as 0.

This is an awesome mod but the Unsubscribe feature needs to work.

[TalkVirginia]

I am having the same issue and get this message when I click on the Unsubscribe link in the email:


It seems the User ID is missing in the Unsubscribe link in the email. Could that be the problem?

http://mysite.com/optout-reminders.php?u=&e=email@mysite.com

When I view the reports in the inactivity log, ID for all users is showing up as 0.

This is an awesome mod but the Unsubscribe feature needs to work.

hmm, I thought I fixed this. I'll check the current zip otherwise I'll post a patch and update the zip.

[TalkVirginia]

The zip file is now updated with the correct files and new plugin to reset inactive members.

[TalkVirginia]

Please let me know if there are any other issues remaining that need to be fixed. Thanks

[fwulfers]

Thanks for the quick update Jim.

The zip file has some duplicate files and folder. It looks like the older .xml product file is still in there in addition to the new file modified yesterday. May be confusing for some.

I tried to update the Product with Add/Import product, tested again but that didn't fix the problem. Do I need to install the existing product first and then install the new one? The instructions for this mod mentions this for older versions only.

[Alan_SP]

I tried to use $lastactivity variable and it doesn't show in email. :( Not to big of a problem, I'll compose mail without it, but probably other variables also don't work.

Also, some emails do get bounced back, but it's not logged. Don't know how to set this up, I'm using qmail on my server (with Plesk CP).

[TalkVirginia]

Thanks for the quick update Jim.

The zip file has some duplicate files and folder. It looks like the older .xml product file is still in there in addition to the new file modified yesterday. May be confusing for some.

I tried to update the Product with Add/Import product, tested again but that didn't fix the problem. Do I need to install the existing product first and then install the new one? The instructions for this mod mentions this for older versions only.

OMG!!! :mad: Sometimes I really hate Windows 7. I've updated the zip again and will upload.
Import the product XML in the zip, and upload the files in the zip. Make sure you check the "overwrite" option on the import. Also if you have made any changes to the email template phrases, please back them up first. They will be overwritten. If this doesn't seem to work, uninstall it and reimport the product xml.

I tried to use $lastactivity variable and it doesn't show in email. :( Not to big of a problem, I'll compose mail without it, but probably other variables also don't work.

Also, some emails do get bounced back, but it's not logged. Don't know how to set this up, I'm using qmail on my server (with Plesk CP).

The others should work. Lastactivity wasn't being exported, so that is why. I'll add it to the last. If you want to make the edit yourself, you can do the following:

1. open the functions_remindermail.php in your forum's includes folder.
2. scroll down to line 163 and press enter to make a new line.
3. add the following line:



$lastactivity = $row['lastactivity'];



4. Save the file and upload to your forums includes folder.

Add the variable to your email template.

As for the bounced back emails, ignore that for now. I haven't put that functionality in yet. That will be in a future release.

[Alan_SP]

Thanks, but I found some inconsistencies with actual variables and those in manual.

Here, take a look:

In manual:

Exporting the following additional values which can be used in reminder email templates if desired:
$lastvisit - Formatted Date/Time Value - members last visit to the site.
$lastactivity - Formatted Date/Time Value - members last activity on the site.
$lastpost - Formatted Date/Time Value - members last post date on the site.
$lastreminder - Formatted Date/Time Value - Date member was sent last reminder email.
$days_since_lastpost - Number of days since member last posted.
$days_since_lastreminder - number of days since last reminder was sent.

And here's the code I see in php file:

$lastvisit = $row['lastvisit'];
$lastactivity = $row['lastactivity'];
$lastpost = $row['lastpost'];
$dayssincelastactivity = $row['days_since_lastactivity'];
$dayssincelastvisit = $row['days_since_lastvisit'];
$dayssincelastpost = $row['days_since_lastpost'];

You don't mention $dayssincelastactivity at all, and the spelling in manual is wrong (you use _ between the words in manual). Also $lastreminder is missing in code, or is created somewhere else (didn't checked other files for it, just it's not in this php file).

[TalkVirginia]

:eek: Ok. In the interest of making sure updates are correct going forward, I'm going to space out releases and pay closer attention to details. Recent updates have been too quick and I've over looked some things which has made quality in the product and support less than desireable. I'm going to look at the errors that are posted and determine the severity. If something is broken, and it's an easy fix and does not impact a lot, I'll try to get it out within a few days otherwise other fixes will be released as time permits so that I can properly evaluate and test each bug.

[cbiweb]

Hi Virginia, thanks for the reply; I've been quite busy as well, and just got around to trying your suggestions.

My apologies for missing your post. If I may ask, what version of vb are you using?4.1.3 PL1.


All inactivity now is based on last activity of the member.
What I did when creating a test account is set the join date to like 1/01/2000
and last activity to 1/01/2005.The test account I'm using has had no activity since March 3, 2010.


Make sure they are able to receive emails from the administrator.Yes, it is set that way.

So I ran the cron manually, and the next screen contained this info:

Inactive User Reminder Emails
Looking for members who have become inactive and never received a reminder email...

5 inactive members(s) found!
Sent To: lunasphaira
Sent To: clourleculp
Sent To: dhandaulat33
Sent To: rivesmerb
Sent To: thebeeststf

Looking for members who have become inactive and
haven't received a reminder email in the last 45 days...

No inactive member(s) found!

Done
My test account does not appear in that list. Is it because I've never posted with that account? If so, does that mean that all inactive members who have never posted will never receive a reminder?

[TalkVirginia]

Hi Virginia, thanks for the reply; I've been quite busy as well, and just got around to trying your suggestions.

4.1.3 PL1.


The test account I'm using has had no activity since March 3, 2010.


Yes, it is set that way.

So I ran the cron manually, and the next screen contained this info:

My test account does not appear in that list. Is it because I've never posted with that account? If so, does that mean that all inactive members who have never posted will never receive a reminder?

Can you email me a screen shot of your test account? From admincp. Something doesn't sound like it's set right. Also if you could email me a screen shot of your mod settings screen. jim@talkvirginia.net

Thanks Send me that and I'll look into it this evening.

[cravendale]

Hi,

I have the following settings...

Enable Inactive User Reminder Emails: yes
Only Send Once?: no
Maximum Email To Send: 0
Inactivity Grace Period: 20
Number of Reminder Emails to Send Per Batch: 80
How often should we send reminder email: 20
Usergroups: registered members
Excluded User IDs: none
Email Format: HTML
Enable Admin Email Report: yes
Enable Logging: yes
Inactivity Log Duration: 30

vB: 4.0.6 PL2
2.2.0 of Inactive users (upgraded today to latest Version)

I'm finding that the same members are being emailed pretty much daily from the reports I'm seeing and also one of the members I have registered myself but also inactive which is receiving emails.

Why is this?

[fwulfers]

OMG!!! :mad: Sometimes I really hate Windows 7. I've updated the zip again and will upload.
Import the product XML in the zip, and upload the files in the zip. Make sure you check the "overwrite" option on the import. Also if you have made any changes to the email template phrases, please back them up first. They will be overwritten. If this doesn't seem to work, uninstall it and reimport the product xml.I didn't re-upload all the files/folder in the Upload folder in the zip file so it is working now.

The ID numbers are now showing up in the log and email Unsubscribe link. But when I click the link, I am getting this message on my site: Could not find phrase 'error_unsubscribe_done'.

When I click on the link again, it shows the user already unsubscribed so it seems to be working fine, except for showing that error message.

[TalkVirginia]

Hi,

I have the following settings...

Enable Inactive User Reminder Emails: yes
Only Send Once?: no
Maximum Email To Send: 0
Inactivity Grace Period: 20
Number of Reminder Emails to Send Per Batch: 80
How often should we send reminder email: 20
Usergroups: registered members
Excluded User IDs: none
Email Format: HTML
Enable Admin Email Report: yes
Enable Logging: yes
Inactivity Log Duration: 30

vB: 4.0.6 PL2
2.2.0 of Inactive users (upgraded today to latest Version)

I'm finding that the same members are being emailed pretty much daily from the reports I'm seeing and also one of the members I have registered myself but also inactive which is receiving emails.

Why is this?

For starters, please check the Inactive Users Reminder Emails Cron Job and make sure it is executing the following php file:

process_inactive_members.php

If you have a file in the cron folder called remindermail.php or reminderemail.php, please remove it.

[cravendale]

For starters, please check the Inactive Users Reminder Emails Cron Job and make sure it is executing the following php file:

process_inactive_members.php

If you have a file in the cron folder called remindermail.php or reminderemail.php, please remove it.

Hi,

Thanks for your reply..

includes/cron...
I have reminder.php
but none of the ones you mentioned. I think I removed that previously.

When I go to edit the cron job it shows the following...

./includes/cron/process_inactive_members.php

[TalkVirginia]

Hi,

Thanks for your reply..

includes/cron...
I have reminder.php
but none of the ones you mentioned. I think I removed that previously.

When I go to edit the cron job it shows the following...

./includes/cron/process_inactive_members.php

Ok. I'll have to look into this when I get home this evening. I'm at work right now.

[cravendale]

Just to confirm.. someone on the list has had emails for the past week :|

[cbiweb]

Can you email me a screen shot of your test account? From admincp. ...Also if you could email me a screen shot of your mod settings screen.
Screenshots sent. :) Thanks again!

[Alan_SP]

:eek: Ok. In the interest of making sure updates are correct going forward, I'm going to space out releases and pay closer attention to details.

No problem, I just wanted to inform you and others about this differences.

An as a suggestion, can you make cron task hourly by default? It's now set as daily, but I think making it hourly is much better. I know that I can change that (and I did), but some people may not know how and where.

[TalkVirginia]

No problem, I just wanted to inform you and others about this differences.

An as a suggestion, can you make cron task hourly by default? It's now set as daily, but I think making it hourly is much better. I know that I can change that (and I did), but some people may not know how and where.

Ok. will do that.

[cravendale]

TalkVirginia, Did you manage to look into the problem I'd highlighted on my previous post?

Thanks

[TalkVirginia]

Also after testing recent errors on both my test site and my live site, everyone should make sure they have the latest files from the zip file on their site. For the moment, I'm unable to reproduce the errors mentioned.

I'm also working on a tool that will show all inactive members on a separate screen as a side check. It will allow you to set custom values as well as the option to use the same values from the mod settings screen.

[cravendale]

Ok. I'll have to look into this when I get home this evening. I'm at work right now.

Also after testing recent errors on both my test site and my live site, everyone should make sure they have the latest files from the zip file on their site. For the moment, I'm unable to reproduce the errors mentioned.

I'm also working on a tool that will show all inactive members on a separate screen as a side check. It will allow you to set custom values as well as the option to use the same values from the mod settings screen.

Sounds good.

Thank you for your time and hard work!!
:D

[thedvs]

is it possible to delete inactive users after a certain amount of inactivity. eg, user signs up, doesn't complete email confirmation... user is then deleted after a period of time auto.

[TalkVirginia]

is it possible to delete inactive users after a certain amount of inactivity. eg, user signs up, doesn't complete email confirmation... user is then deleted after a period of time auto.

Or the member becomes inactive and you send out 20 reminders, the member doesn't come back and is removed after the 20 reminder? I'll have to think about that one. :) Thanks for the idea! I'll add that to my to-do list and see if anyone else is interested in that.

I'd like to make sure that the current features are not giving anyone any additional issues first. Also I still need to add bouced email detection which I'm currently working on.

[hamedbia2]

Great ,
how this add on sends emails?automatically or manually?if manually please how?

[fwulfers]

I uploaded all the latest files, removed and installed the xml product file again and I am still getting this message when the Unsubscribe link in the email is clicked:

vBulletin Message: Could not find phrase 'error_unsubscribe_done'.

[TalkVirginia]

Great ,
how this add on sends emails?automatically or manually?if manually please how?

Automatically using the cron jobs/scheduled tasks.

[fwulfers]

I uploaded all the latest files, removed and installed the xml product file again and I am still getting this message when the Unsubscribe link in the email is clicked:

vBulletin Message: Could not find phrase 'error_unsubscribe_done'.I just added a phrase with this varname to the Phrase Manager. Seems to be working fine now.

[TalkVirginia]

I just added a phrase with this varname to the Phrase Manager. Seems to be working fine now.

Thank you for posting this. I was going to mention that it is actually already there however it's under the incorrect phrase type.

I was going to release another update along with the inactivity validation tool however I ran into some show stopper bugs I need to work on. :)

[Boofo]

Thank you for posting this. I was going to mention that it is actually already there however it's under the incorrect phrase type.

I was going to release another update along with the inactivity validation tool however I ran into some show stopper bugs I need to work on. :)

Glad I saw this post first. I was just about to download and install this. I will wait for the update.

[TalkVirginia]

Glad I saw this post first. I was just about to download and install this. I will wait for the update.

I was referring to the validation tool. There are some small issues in the main part of the mod, but nothing that would be a show stopper.

[Boofo]

I was referring to the validation tool. There are some small issues in the main part of the mod, but nothing that would be a show stopper.

Ok, now I'm officially confused. According to this post, you did run into some show-stopper bugs.

I was going to release another update along with the inactivity validation tool however I ran into some show stopper bugs I need to work on. :)

[TalkVirginia]

Ok, now I'm officially confused. According to this post, you did run into some show-stopper bugs.

Yes. In the version I'm currently working on... not what I've already posted.

[fwulfers]

Thank you for posting this. I was going to mention that it is actually already there however it's under the incorrect phrase type. I was too impatient to get started sending out emails so I actually thought about what the message said and the fix was an easy one. :)

Great mod and donation made. It's nice to see these mods being supported and improved over time. :up:

I added some different larger icons and my site logo to the html email and am very pleased with the results.
http://saabworld.net/f26/activity-saabworld-1889/index2.html#post10664

[TalkVirginia]

I was too impatient to get started sending out emails so I actually thought about what the message said and the fix was an easy one. :)

Great mod and donation made. It's nice to see these mods being supported and improved over time. :up:



Bless you my friend! Thank you very much! :D


I added some different larger icons and my site logo to the html email and am very pleased with the results.
http://saabworld.net/f26/activity-saabworld-1889/index2.html#post10664

:eek: That looks awesome! :up: :D

[deverill2010]

Is this working ok with 4.1.4? As I know 4.1.4 is quite a few issue with mods.

Can you please give the Ok so i cant install :)

[djbaxter]

Is this working ok with 4.1.4? As I know 4.1.4 is quite a few issue with mods.

Only true for add-ons that extended or modified the old editor. These obviously have to be reworked. Other add-ons like this one should be fine.

[TalkVirginia]

Is this working ok with 4.1.4? As I know 4.1.4 is quite a few issue with mods.

Can you please give the Ok so i cant install :)

I agree with dj. This addon doesn't use code for the previous editor so it should be fine.

[deverill2010]

Ace thank you! Just wanted to check :)

[S_E_A]

Hello TalkVirginia,

Version 2.1.5 is installed on my board and the comma has been removed from the below line.

"SET rmEmailDate = UNIX_TIMESTAMP(), ";

I am relatively new to vbulletin so please bear with me. From what I can gather the mod appears to be working fine, though I may have missed something.. Is an upgrade to 2.2.1 required?

[TalkVirginia]

Hello TalkVirginia,

Version 2.1.5 is installed on my board and the comma has been removed from the below line.

"SET rmEmailDate = UNIX_TIMESTAMP(), ";

I am relatively new to vbulletin so please bear with me. From what I can gather the mod appears to be working fine, though I may have missed something.. Is an upgrade to 2.2.1 required?

Are you running vbulletin 4? If so, then yes.

[S_E_A]

I think there may be a problem with pruning feature?

After pruning, the homepage of my website is loaded within admincp with my 404 error page. (Hope I've explained well enough)

homepage - www.mywebsite.com
forum - www.mywebsite.com/forum

[TalkVirginia]

I think there may be a problem with pruning feature?

After pruning, the homepage of my website is loaded within admincp with my 404 error page. (Hope I've explained well enough)

homepage - www.mywebsite.com
forum - www.mywebsite.com/forum

Sounds like all the files haven't uploaded. That's been fixed.

[S_E_A]

I have uploaded the files again and still receiving the same error?

[S_E_A]

Also, the custom message subject and message body was not over written when I updated. This may be nothing, but I thought it best to let you know what I can, TalkVirginia.

[TalkVirginia]

I've made the corrections in this file. I'll add it to the zip as soon as I can.

[S_E_A]

Thank you, TalkVirginia. The updated file has resolved the problem.

[cbiweb]

Can you email me a screen shot of your test account? From admincp. Something doesn't sound like it's set right. Also if you could email me a screen shot of your mod settings screen. jim@talkvirginia.net

Thanks Send me that and I'll look into it this evening.

Screenshots sent. :) Thanks again!

Did you receive my email with the screenshots?

[TalkVirginia]

Did you receive my email with the screenshots?

Yes. As a matter of fact I did. Everything there appears to be fine. I'll have to look at it again this evening when I get home. Do you have access to phpMyAdmin? Can you export the data for your test accounts only and email it to me?

Thanks

[threethrees]

Hi -
I love this mod, but my "sent from" email address gets output as blank and thus the email gets marked as spam. The subject and content text are fine.
Any suggestions?

[TalkVirginia]

Hi -
I love this mod, but my "sent from" email address gets output as blank and thus the email gets marked as spam. The subject and content text are fine.
Any suggestions?

Install the 2.2.1 version if you are running vb4.x.x. That bug has been fixed.

[Marv]

Hi TalkVirginia,

this is long needed mod and I thank you for that one. It does what it should do. But there is a major downside (in particular there are 2) in using it - and yesterday we´ve learned it the hard way, what it is about.

Our ISP forwarded us abuse notices they´d received after installing your mod. As most of the forums out there, since the launch on the edge of this century we have gained a large number of accounts in the database (~30k). In the meanwhile many of them have invalid email-adresses, since the accountholder deleted or changed his emailaccount.

On that basis the mailhosting companies noticed a bounce rate, which has reached the indication level for spam. AFAIR, the common treshhold is at 10%. For that reason hotmail was the first who dropped an abuse report to our ISP, a second one followed by a european hoster forced our ISP to shut down our server immediatly. That´s a responsible behaviour, so we don´t argue with em. They got in contact with us and we were able to explain what happend, deactivated the reminder mod and we were back online.

Your mod, like any other mod referring to email features, shows the lack of checking if a users mailaccount is still existing before sending and a bounce management. Nothing brings you and your forums closer to the spam blacklist, as sending out dozens of emails to not existing mailaccounts and sending these ones periodicly. That´s truly the best way to get your forums mailadresses and IP´s blocked.

What do you think? Could you implement at least a bounce management into this mod here? Something, that deactivates all email functionality for hard or softbounces and brings them to the usergroup for awaiting an email verification/activation? That could avoid a lot of trouble for forums with a userbase +10k.

[TalkVirginia]

Hi TalkVirginia,

this is long needed mod and I thank you for that one. It does what it should do. But there is a major downside (in particular there are 2) in using it - and yesterday we?ve learned it the hard way, what it is about.

Our ISP forwarded us abuse notices they?d received after installing your mod. As most of the forums out there, since the launch on the edge of this century we have gained a large number of accounts in the database (~30k). In the meanwhile many of them have invalid email-adresses, since the accountholder deleted or changed his emailaccount.

On that basis the mailhosting companies noticed a bounce rate, which has reached the indication level for spam. AFAIR, the common treshhold is at 10%. For that reason hotmail was the first who dropped an abuse report to our ISP, a second one followed by a european hoster forced our ISP to shut down our server immediatly. That?s a responsible behaviour, so we don?t argue with em. They got in contact with us and we were able to explain what happend, deactivated the reminder mod and we were back online.

Your mod, like any other mod referring to email features, shows the lack of checking if a users mailaccount is still existing before sending and a bounce management. Nothing brings you and your forums closer to the spam blacklist, as sending out dozens of emails to not existing mailaccounts and sending these ones periodicly. That?s truly the best way to get your forums mailadresses and IP?s blocked.

What do you think? Could you implement at least a bounce management into this mod here? Something, that deactivates all email functionality for hard or softbounces and brings them to the usergroup for awaiting an email verification/activation? That could avoid a lot of trouble for forums with a userbase +10k.

Hi Marv,

First, let me say that I apologize for the issues the mod has caused. Secondly, I am sure you will be pleased to know I am currently working on a bounced email manager for this mod. Unfortunately, my time to work on development is limited and I will do my best to get something out as soon as my time will allow.

EDIT: Marv, I did a little research on checking to see if an email address exists before sending an email. It looks like most email servers are denying this validation to protect users from spambots. However, the closest that we can get to is at least checking to verify that the domain name is a valid mail server and that "MX" or mail records do exist on that server. I'm currently testing this change locally. If you would like to try this out now as long as you feel comfortable making the change yourself.

1. Open the functions_remindermail.php file that resides in your forums includes folder in your favorite text editor (such as notepad++ or textpad).
2. Scroll down to or about line 100.

Below this line:


$email = $row['email']; // user email address



Insert:


list($junk, $maildomain) = explode('@', $email);



3. Now.... On or about line 131:

Change:


if(is_valid_email($toemail))
{



To:


if (checkdnsrr($maildomain, "MX"))
{



This should cut down on some of the invalid emails that go out. Let me know how this works for you, or if you have questions.

Thanks

[TalkVirginia]

Greetings fellow VB admins,

As I'm working on the bounced email detection for this mod, I've been thinking that I may release the bounce detection as a separate addon. Here's a couple reasons why:

1. I know in the past since I've been working on the reminders addon I've gotten responses that it's confusing. Adding additional functionality and settings may only add to the confusion.

2. With all the additional settings for the bounce detection the settings screen is scrolling about 2 - 3 screens. More could be added which would make it even longer.

Just some thoughts I'm throwing out there. What are your thoughts. Tonight I'll post a screen shot of the settings screen and you can see what I mean. :)

[Alan_SP]

How this will work together? This is main question. If it can work well together, no problem.

For example, if mail gets bounced, will user change his usergroup? This sometime would be good for me. I want just that users with bounced mail doesn't receive remainder mails.

[Marv]

Hi TalkVirginia,
somehow I must have missed your last post. I appreciate your fast response.

Your suggestion to check up on the domains seems to be a good effort, but wont get even close to what you are trying with the bounce manager now (based on EZ´s Bounce management?). The Domains will be there, yahoo, gmail, hotmail and all the other mailproviders. Guess that wont help much or is only the drop into the sea.

I´m looking forward to your newest announcement - or let me call it your new project. Personal I would recommend a seperate bounce mod. There are lot´s of email-mods and built-in vb functions which could benefit all from a sepereate one, in case someone don´t wants to install the email reminder.

Thumbs up, good to see you´re taking care of that.
Kudos.

[doopz]

Id go for a seperate bounce manager! and def. in need of one too :)

[TalkVirginia]

Thanks a bunch for the input guys! :) Much appreciated

[whitey92lx]

I had previously uploaded and installed version 2.2.0 and I was having some issues so I disabled it. It was sending reminder emails to the same people over and over again even though I had the count set at 1 email per user. I just uninstalled it and installed version 2.2.1. I hope it fixes the issue!

Thanks!

[TalkVirginia]

I had previously uploaded and installed version 2.2.0 and I was having some issues so I disabled it. It was sending reminder emails to the same people over and over again even though I had the count set at 1 email per user. I just uninstalled it and installed version 2.2.1. I hope it fixes the issue!

Thanks!

Should be fine. I've been running 2.2.1 on my live site for a while now and haven't had any trouble.

[TalkVirginia]

Regarding a separate bouncer addon.. it looks like someone else is working on updating the vBouncer addon.

https://vborg.vbsupport.ru/showpost.php?p=2183351&postcount=376

I'll continue with the way I was going and if the new developer decides not to follow through, it shouldn't be too hard to separate the addons here. Will see how it goes. :)

[Alan_SP]

I think your mod could be very useful. :up:

[Marv]

Regarding a separate bouncer addon.. it looks like someone else is working on updating the vBouncer addon.

https://vborg.vbsupport.ru/showpost.php?p=2183351&postcount=376

I'll continue with the way I was going and if the new developer decides not to follow through, it shouldn't be too hard to separate the addons here. Will see how it goes. :)

I?ve got in contact with Eric for other things the last days. I?ll check up on him how far he is with the bouncer and report back to you asap.

[TalkVirginia]

I?ve got in contact with Eric for other things the last days. I?ll check up on him how far he is with the bouncer and report back to you asap.

Thanks! :)

[whitey92lx]

Everything is working great!

[TalkVirginia]

Everything is working great!

Awesome! :D

[TalkVirginia]

Just an FYI... my computer died (yes, again.. ) however this time it wasn't just the power supply. Looks like the MB died. Not sure if it took out the video, processor and memory as well. I ordered ~$1200 worth of parts to rebuild it and they should be coming this week. I'll be spending my weekend working on that. :) I'll keep you all posted.