Email reminder for inactive users

[Amman-DJ.CoM]

Hey Man,

How i can delete this copyright ???

it makes the footer look like pig nose

i'll put ur copyright manually , just tell me how to fix this

[djbaxter]

Admin CP | vBulletin Options | Inactive Users Reminder Emails

[deezelpope]

A pig nose??? WHERE do you see that?????:confused::rolleyes: Utter nonsense.

[C Braithwaite]

lol

can be disabled in admincp options.

[djbaxter]

I have no idea what that meant either, deezelpope. I honestly cannot believe the amount of whining that people do about a simple credit to the author. And for anyone who actually bothers to read the instructions for the add-on, removing it is as easy as going into the Admin CP and checking the options. It's not rocket science.

Frankly, I think Chris has gone out of his way to be accommodating - I wouldn't have bothered.

[deezelpope]

I agree 100%! I have both enabled...the copyright and the credit...and I looked at the copyright, and I just don't get it!:mad: The way I see it, and like you said, Chris was nice enough to provide this for us, so I will GLADLY keep the copyright and credit right where they should be...PLUS, I don't think removal should even BE an option.:eek:

So, STOP the whining, PEEPS, cuz some of us grateful people are damn tired of it!:mad:

Ok, someone stick a fork in me, cuz I'm done.:rolleyes:

[C Braithwaite]

I'm just ignoring any complaints from now on - I got MOTM, so that says something about the hack doesn't it?

I had a crack at coding again today on latest version of vbulletin, but didn't get very far i'm sorry to say peeps...

[deezelpope]

Damn straight it does!:up: I agree...just ignore them.

Hey, you've nothing to be sorry for.:)

[flindersredclaw]

Thanks for the hack works well and gets the members to come back and say something lol.

One thing I noticed in the emailed report is it is all one line text so no formating at all. Says everyone it has sent an email to and it is all just bunched up. I am sure there must be a way to set the formating for this to be easier to read. Not high on the priorities though if you do have time can you please assist?

Paying it forward - thank you.

[deezelpope]

How odd...mine came formatted...have a look...

<p>Hello, $username!</p>
<p>We've noticed that you've not been active on $bbtitle for quite some time now,
and we miss you!</p>
<p>Could we not tempt you back?</p>
<p>If you don't remember your password, you can request it here: <a href="$forumurl/login.php?do=lostpw">$forumurl/login.php?do=lostpw</a></p>
<p>We hope to see you soon</p>
<p>&nbsp;</p>
<p>Kindest Regards</p>
$bbtitle
<p>&nbsp;</p>
<p>If you have received this email it is because you have elected to "allow this site to contact you via email. If you would like to opt out of future contact from this site, you can change your notification options here: <a href="$forumurl/profile.php?do=editoptions">$forumurl/profile.php?do=editoptions</a> and uncheck the box next to "Receive Email from Administrators." You must be logged in to change your options.</p>
<p><a href="$homeurl">$homeurl</a></p>

[C Braithwaite]

1.09 was html later versions were plain text.

[deezelpope]

<i>Ohhh...do you want me to remove my post?</i>

[C Braithwaite]

Ohhh...do you want me to remove my post?

nope, no need.

[deezelpope]

Okie dokie.:)

[Dekard]

I just installed on 3.6.7 pl1 and its working great right out of the box. I customized the message just a bit and dialed to wait 14 days then email again in 45 days. Its a great system and I think it will help with member retention quite a bit. Thanks again.

[tokenyank]

Interesting hack... Just wondering, could a usergroup 'change' be added?

So, if email is triggered 2x, on the 2nd trigger, members get moved to 'inactive members' for 2 reasons.

1) if they haven't come back after 2 pleading emails, chances are hey aren't coming back (or their emails are no longer valid)
2) I would be able to get a better idea of just how many inactive members I have at a glance.

[djbaxter]

Use this in conjunction with the EZ Bounce add-on and it will do what you ask.

[AtaPulja]

Install

[GFiSH]

Just installed this, looks pretty good.

One question though, is it possible to have a different rule per usergroup? For example In have tagged members who have to fulfil minimum requirements to stay tagged, would be nice to have one message and rule for that usergroup, and another simpler rule for other usergroups that could just get a default "come back soon" type message. Is this possible in a later version? Or would it beasier to install a second version of this?

[testebr]

Can you add a url checker version to our vbuletin admin in next version?

[C Braithwaite]

What do you mean?

[fpattberg]

Hi.

EDITED.

Thanks.

SOLVED. SORRY MATE. I SHOULD READ BEFORE POSTING! Nice hack!

[djbaxter]

Hi.

I have installed this hack but it also installs this after the copyright in the footer.

Inactive Reminders By Mished.co.uk

Was that intended? If yes will I uninstall, if not how can I remove it?

Thanks.

:rolleyes:

Please READ the first post in this thread. All your questions are answered there.

[bada_bing]

Does anyone know if this works on vb 3.5.x ?

[sunrise2006]

Thank you. It's a good way to invite the inactive members to activity.

[sunrise2006]

One question:

In comment there is this note:
a HTML email will be sent out with a custom message
But after I installed it I saw this pattern on Inactive User Reminder Emails Settings:
Your email body - accepts $username, $userid, $email. This email is plain text.)
Now I want to know can I use the HTML code in Email message or no?

Sorry, for my bad English!

[Greivog]

Hello

When I install, I get the following when I run the script

Inactive User Reminder Emails

db)) { exit; } error_reporting(E_ALL & ~E_NOTICE); if($vbulletin->options['reminder_active']){ $now = time(); $datetime = array(); $quantity = $vbulletin->options['quantity']; $datetime[lastpost] = $now - (60 * 60 * 24 * $vbulletin->options['inactivity']); $datetime[lastemail] = $now - (60 * 60 * 24 * $vbulletin->options['frequency']); $usergroups = explode(",",$vbulletin->options['usergroups']); if($vbulletin->options['reminder_posts']){ $result = $vbulletin->db->query_read("SELECT * FROM " . TABLE_PREFIX . "user WHERE lastpost < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' AND options & 16"); //print("SELECT * FROM " . TABLE_PREFIX . "user WHERE lastpost < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' AND options & 16
"); $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET emailDate = '$now' WHERE lastpost < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' AND options & 16"); //print("UPDATE " . TABLE_PREFIX . "user SET emailDate = '$now' WHERE lastpost < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' AND options & 16
"); } else { $result = $vbulletin->db->query_read("SELECT * FROM " . TABLE_PREFIX . "user WHERE lastactivity < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' AND options & 16"); //print("SELECT * FROM " . TABLE_PREFIX . "user WHERE lastactivity < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' AND options & 16
"); $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET emailDate = '$now' WHERE lastactivity < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' AND options & 16"); //print("UPDATE " . TABLE_PREFIX . "user SET emailDate = '$now' WHERE lastactivity < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' AND options & 16
"); } print("Found " . mysql_num_rows($result) . " Inactive Users.

"); while($row = $vbulletin->db->fetch_array($result)){ if(is_member_of($row, $usergroups)){ print("Sent To: $row[username]
"); $username = $row[username]; $toemail = $row[email]; $userid = $row[userid]; $bbtitle = $vbulletin->options['bbtitle']; $homeurl = $vbulletin->options['homeurl']; $forumurl = $vbulletin->options['bburl']; $hometitle = $vbulletin->options['hometitle']; eval('$message = "' . addslashes($vbulletin->options['message']) . '";'); $message = stripslashes($message); //$headers = "MIME-Version: 1.0" . "\r\nContent-type: text/html; charset=iso-8859-1" . "\r\n"; $uheaders .= "To: $username <$email>" . "\r\n"; $uheaders .= "From: " . $vbulletin->options['bbtitle'] . " Reminder Service <" . $vbulletin->options['webmasteremail'] . ">" . "\r\n"; eval('$subject = "' . addslashes($vbulletin->options['subject']) . '";'); $subject = stripslashes($subject); if($vbulletin->options['reminder_emailfooter']){ $message = $message . "Email Reminder System Provided By Mished.co.uk"; } /*if(@mail($email, $subject, $message, $headers)){ print("mailing $email (done)
"); } else { print("mailing $email (failed)
"); }*/ if(is_valid_email($toemail)){ $sentlist .= "$username "; vbmail($toemail, $subject, $message, $notsubscription = false, $from = $vbulletin->options['bbtitle'], $uheaders = '', $username = ''); } else { $failedlist .= "$username "; } } } if($sentlist == ""){ log_cron_action("No Emails to send", $nextitem); vbmail($vbulletin->options['webmasteremail'], "Inactive User Reminder Email Report", "This email shows that the product is installed and working as it should be.\n\n\nThere were no inactive users at this time.", $notsubscription = false, $from = $vbulletin->options['bbtitle'], $uheaders = "From: " . $vbulletin->options['bbtitle'] . " Reminder Service <" . $vbulletin->options['webmasteremail'] . ">" . "\r\n", $username = ''); } else { log_cron_action("Emails sent to:$sentlist. We tried to email the following users, but their email address was invalid:$failedlist", $nextitem); vbmail($vbulletin->options['webmasteremail'], "Inactive User Reminder Email Report", "This email shows that the product is installed and working as it should be.\n\n\nEmails sent to:" . $sentlist . ". We tried to email the following users, but their email address was invalid:" . $failedlist . "", $notsubscription = false, $from = $vbulletin->options['bbtitle'], $uheaders = "From: " . $vbulletin->options['bbtitle'] . " Reminder Service <" . $vbulletin->options['webmasteremail'] . ">" . "\r\n", $username = ''); } } else { print("Product is inactive at this time!"); } ?>
Done


The script dosnt sent out any emails if i run it myself or let it run itsself.

Any ideas?

Thanks

Paul

[raiderlax]

Looks good I'm going to install this now.

[mathias]

try to import I get this

XML Error: not well-formed (invalid token) at Line 1

[Greivog]

Has support finished on this mod?

[C Braithwaite]

Has support finished on this mod?

not really -i just dont have the time for it right now.. i read everything, but dont have time to look into things.

i have a stressful life..

[raiderlax]

Does it run on 3.6.7?

[cheat-master30]

Does it run on 3.6.7?

I am running it on 3.6.7 with no trouble at all.

[cheat-master30]

I would also like to thank the creator of this as this modification has caused many members on my forum to return after long periods of time not visiting the forum, some who did not visit for months beforehand.

[voclain]

I only send out emails to certain usergroups...can this be done????

I can't have the email going to everyone....I have thousands and thousands of NON PAYING members...and those who do not pay....do not get to do anything on my board.

Thus....it would be sending out emails all the time???

ANY SUGGESTIONS would be greatly appreciated.

Yours,

Kirk

[voclain]

I only send out emails to certain usergroups...can this be done????

I can't have the email going to everyone....I have thousands and thousands of NON PAYING members...and those who do not pay....do not get to do anything on my board.

Thus....it would be sending out emails all the time???

ANY SUGGESTIONS would be greatly appreciated.

Yours,

Kirk
WELL..that is what you get when you install HACK late at night...hungry...and under the influnece....HOW IN THE WORLD did I miss that line in the VBADMIN saying to choose only the usergroups you want to send emails too???

CRAZY...CRAZY I tell you.

Kirk

[fly]

Any way to change the email address that is sending out the email?

[yaoren]

**Installed**

Thanks.

3.6.7 no problems :)

[C Braithwaite]

Any way to change the email address that is sending out the email?

just change the main email address of your site

[BigDog56]

Installed the 1.11, seems ok so far. Thank you very much for a great mod!

[sola]

Is there a way to track responses to the emails sent out by this fine Mod?
Many users are responding, sure. But others don't.

It would be nice to be able to compile the list of non-respondents (for deletion or moving to a different usergroup).

Thanks.

[raiderlax]

Does it run on 3.6.8?

[dricho]

Just installed but still waiting to test...thank you so much though...very easyto install and very valuable to our forum.

[LukeFX]

This email shows that the product is installed and working as it should be.

Emails sent to: <BLANKED OUT> . We tried to email the following users, but their email address was invalid:

I only just installed and so far it has found 3 inactive users. All three seem to have invalid email addresses!

Help?!

[C Braithwaite]

Is there a way to track responses to the emails sent out by this fine Mod?
Many users are responding, sure. But others don't.

It would be nice to be able to compile the list of non-respondents (for deletion or moving to a different usergroup).

Thanks.

You should edit the email to include a link to click with tracking information maybe?

This email shows that the product is installed and working as it should be.


Emails sent to: <BLANKED OUT> . We tried to email the following users, but their email address was invalid:


I only just installed and so far it has found 3 inactive users. All three seem to have invalid email addresses!

Help?!

looking at that report, it indicates that emails were sent to <BLANKED OUT>, and as no invalid emails have been listed, it indicates that none of the emails were invalid.

[LukeFX]

Damn, I see it now, that is confusing,

We tried to email the following users, but their email address was invalid:

that should be on another line. How can I edit the email template?

Luke

[basketmen]

How odd...mine came formatted...have a look...

<p>Hello, $username!</p>
<p>We've noticed that you've not been active on $bbtitle for quite some time now,
and we miss you!</p>
<p>Could we not tempt you back?</p>
<p>If you don't remember your password, you can request it here: <a href="$forumurl/login.php?do=lostpw">$forumurl/login.php?do=lostpw</a></p>
<p>We hope to see you soon</p>
<p>&nbsp;</p>
<p>Kindest Regards</p>
$bbtitle
<p>&nbsp;</p>
<p>If you have received this email it is because you have elected to "allow this site to contact you via email. If you would like to opt out of future contact from this site, you can change your notification options here: <a href="$forumurl/profile.php?do=editoptions">$forumurl/profile.php?do=editoptions</a> and uncheck the box next to "Receive Email from Administrators." You must be logged in to change your options.</p>
<p><a href="$homeurl">$homeurl</a></p>


i am using this mod 1.11 ver but user still get code like this in email


am i miss some thing how to make the email to be html generally :confused:

[C Braithwaite]

i am using this mod 1.11 ver but user still get code like this in email


am i miss some thing how to make the email to be html generally :confused:

ver 1.11 is text only due to vbulletin's internal mailing system. i suggest a previous version if you wish to send html.

[USAMustangs.com]

I installed version 1.11 and I ran into a problem almost immediately.

I moved two old members into a test usergroup for the purposes of sending a test email. I manually ran the cron job in Scheduled Task and it showed 56 inactive members, then successfully sent the email to the two members in test usergroup. I then went and added my Registered Usergroup in the Admin CP options. I went back to manually run the cron job to send out emails to those 56 members and it said found 0 inactive users? Now it won't send out an email because it keeps saying it found 0 inactive members? So, I basically accomplished nothing.

I definitely need some help. Thanks in advance.

[USAMustangs.com]

Anyone have an idea how of what the problem could be?

Referring to my post above.

Really need some help with this.

[C Braithwaite]

I installed version 1.11 and I ran into a problem almost immediately.

I moved two old members into a test usergroup for the purposes of sending a test email. I manually ran the cron job in Scheduled Task and it showed 56 inactive members, then successfully sent the email to the two members in test usergroup. I then went and added my Registered Usergroup in the Admin CP options. I went back to manually run the cron job to send out emails to those 56 members and it said found 0 inactive users? Now it won't send out an email because it keeps saying it found 0 inactive members? So, I basically accomplished nothing.

I definitely need some help. Thanks in advance.

a quick guess would be that when you only chose the one usergroup to send the emails to it "marked" the rest of the users as "dealt with". if you reinstall the product it will reset the data, and will find all inactive members again.

i think that's what is happening without looking at the code.

[USAMustangs.com]

a quick guess would be that when you only chose the one usergroup to send the emails to it "marked" the rest of the users as "dealt with". if you reinstall the product it will reset the data, and will find all inactive members again.

i think that's what is happening without looking at the code.

good guess. that fixed it.

thanks for your help.

[towermatt]

I have installed the 1.09 version on my board with no problems.

A really weird thing happened when I read the entire thread before uploading.

It answered all my questions!!

Thank you for the great hack.

[deezelpope]

<i>DITTO! And well said, Towermatt!</i>

[Mr Italy!]

Very cool hack!

THanks! Installed!

[Zaiaku]

Used the updated version. thx great mod!

[Zaiaku]

Ok my test went ok but when I change the usergroup I get this

Emails sent to:Array. We tried to email the following users, but their email address was invalid:Array

I don't have a member called array so I know something is wrong. And the report is showing up with:

Reminders Sent: 0
Not Sent: 0
Total Inactive: 0

[Zaiaku]

Never mind I got it all working out now. Definitely a great mod!

[cheech47]

Looks good but just a few quick questions:
What email address does this registered as sent from?
And is there a way to change this if we wanted?

Cheers
Cheech47

[Rocko]

Why does this add on sent 5 emails to the users, even when I have set the email frequency to 1?

[djbaxter]

Looks good but just a few quick questions:
What email address does this registered as sent from?
And is there a way to change this if we wanted?

It's sent from the email address specified in your Admin CP as the forum email address.

Why does this add on sent 5 emails to the users, even when I have set the email frequency to 1?

Frequency = 1 means that it will send out additional emails after 1 day. See comment by towermatt below for more information:

I have installed the 1.09 version on my board with no problems.

A really weird thing happened when I read the entire thread before uploading.

It answered all my questions!!

Thank you for the great hack.

[tekguru]

Nice Mod, just installed it and ran it - it took a while but ended up sending out 7312 emails!

So far as well over 300 bounced emails back from addresses that no longer exist! I know there is a Mod which can take care of this but I beleive it is a manual operation. What we really need is a Mod which will read bounced emails and move the user into a 'bounced' usergroup.

I guess we have way too many inactive users! Heres hoping it makes a difference!

[C Braithwaite]

Ok my test went ok but when I change the usergroup I get this

Emails sent to:Array. We tried to email the following users, but their email address was invalid:Array

I don't have a member called array so I know something is wrong. And the report is showing up with:

Reminders Sent: 0
Not Sent: 0
Total Inactive: 0

Never mind I got it all working out now. Definitely a great mod!

glad you like the mod - what was the problem, and how did you fix it?


Frequency = 1 means that it will send out additional emails after 1 day. See comment by towermatt below for more information:

LOL!

Nice Mod, just installed it and ran it - it took a while but ended up sending out 7312 emails!

So far as well over 300 bounced emails back from addresses that no longer exist! I know there is a Mod which can take care of this but I beleive it is a manual operation. What we really need is a Mod which will read bounced emails and move the user into a 'bounced' usergroup.

I guess we have way too many inactive users! Heres hoping it makes a difference!

there is a mod - i cant remember what it's called - but djbaxter knows the name..

[blogtorank]

there is a mod - i cant remember what it's called - but djbaxter knows the name..

Kick arse mod:

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

[tekguru]

Cheers - I wish it was automatic, but grabbing a copy now!

[chrisbr]

I have a problem with this,

I have the email frequency set to 30 days, but it runs EVERY day!

How can i fix this?

[djbaxter]

Nice Mod, just installed it and ran it - it took a while but ended up sending out 7312 emails!

So far as well over 300 bounced emails back from addresses that no longer exist! I know there is a Mod which can take care of this but I beleive it is a manual operation. What we really need is a Mod which will read bounced emails and move the user into a 'bounced' usergroup.

I guess we have way too many inactive users! Heres hoping it makes a difference!

The other add-on is called EZ Bounce (https://vborg.vbsupport.ru/showthread.php?t=138884). It does require manual clicks on bounced emails so there will be some work to do for the first run through your database, but after that the maintenance is minimal.

I have a problem with this,

I have the email frequency set to 30 days, but it runs EVERY day!

How can i fix this?

Frequency = 30 days means that an individual member won't get a second reminder email for 30 days.

If you're using 1.09, the add-on will run as a scheduled task every day, sending out batches of emails to a limited number of inactive members and in that fashion gradually working through your member list.

[chrisbr]

Frequency = 30 days means that an individual member won't get a second reminder email for 30 days.

If you're using 1.09, the add-on will run as a scheduled task every day, sending out batches of emails to a limited number of inactive members and in that fashion gradually working through your member list.

is there anyway that I can just get it to run on a ccertain date? like every 30 days or whatever? Its pretty annpying to have an email every day saying this product is working properly bleh blah blah

[tekguru]

The other add-on is called EZ Bounce (https://vborg.vbsupport.ru/showthread.php?t=138884). It does require manual clicks on bounced emails so there will be some work to do for the first run through your database, but after that the maintenance is minimal..

Yep so I gathered, now installed and we'll see what happens in 30 days :)

[jkay]

Hi,

When I use this mod, when my vbulletin sends a email reminder to my members, it quotes the wrong username. Why is this so?

Also, I did not set the setting of the mod to YES, activate product. Yet it managed to send out 1 round of emails last night.

Can you please assist me thanks!

[LegolasTheElf]

Which version did you install? If it was 1.11, uninstall and install 1.09.
I was getting an error like: member function query_first().. I fixed it by disabling EZ Bounce.

[C Braithwaite]

is there anyway that I can just get it to run on a ccertain date? like every 30 days or whatever? Its pretty annpying to have an email every day saying this product is working properly bleh blah blah

either install 1.09 or edit the file removing the mail command that sends out the emails to yourself.

setting the thing to run once a month would not be a good idea, as it would increase server load unforgivably, and wouldn't send out emails accurately.

[MotMann]

I try to set the days, but its not working.

[C Braithwaite]

I try to set the days, but its not working.

please list all of your settings, and ill tell you what you are doing wrong.
also - what gives you the i ndication that it's not working?

[racingsolution]

I've installed it on 3.6.8 and its working fantastic... I've combined it with EZ Bounce and its definately helping to clean up the email stuff .. Thanks for the product!

[MotMann]

also - what gives you the i ndication that it's not working?
I have a testacount ;)

here my settings:

[ChrisTech]

Nice Mod, just installed it and ran it - it took a while but ended up sending out 7312 emails!

So far as well over 300 bounced emails back from addresses that no longer exist! I know there is a Mod which can take care of this but I beleive it is a manual operation. What we really need is a Mod which will read bounced emails and move the user into a 'bounced' usergroup.

I guess we have way too many inactive users! Heres hoping it makes a difference!

That is what has me right now. With over 4k users signed up, 4k emails would go out. I'm on a reseller account. That will more than likely get my account suspended. lol! Cool mod, I installed it, now just scared to use it.

[redtailboa]

I installed this mod yesterday. When the cron actually runs does it send out any report to the admin of the site? So far I have got nothing.

Does it use vbulletins mail system? I have my email options set to SMTP email because I do not run a local smtp server....could this be the problem?

[redtailboa]

I installed this on another server and confirmed that it will not work if you have SMTP Email set to yes in Vbulletin options.

Is there anyway to get around this for people who use the SMTP Email option in Vbulletin?

[Head Roller]

Fantastic Mod. THanks.

[cubenz]

Hi,

I am a vBulletin neophyte, and this is the first mod that I've installed, so please be kind to me.

I've read through the first 30% of this thread without finding the answer to my question, but it is obvious that the mod will work if conditions are right. I'll keep reading, but if someone could help me now, I would be very appreciative!

1. Using 'Run Now', the feedback indicates e-mails are being sent, but they are not received at the other end. I can send e-mails from AdminCP/Users/Send Emails without problem (with and without SMTP set!)

2. Information appears in the Scheduled Tasks log only if I use Run Now - there is no evidence that it is running via 'cron'. (How often is the cron list checked by vBulletin when browsing the messages in my Test board?)

3. In the early part of this thread, there is talk of a limit to the number of e-mails sent out in one go - the code doesn't seem to contain a limit, and I can't see one in the configuration. Is it still there? [Update - I see that it isn't - I'm sure why will be revealed soon...

Thanks

Quentin

[cubenz]

Hi,

I am a vBulletin neophyte, and this is the first mod that I've installed, so please be kind to me.

I've read through the first 30% of this thread without finding the answer to my question, but it is obvious that the mod will work if conditions are right. I'll keep reading, but if someone could help me now, I would be very appreciative!

1. Using 'Run Now', the feedback indicates e-mails are being sent, but they are not received at the other end. I can send e-mails from AdminCP/Users/Send Emails without problem (with and without SMTP set!)

2. Information appears in the Scheduled Tasks log only if I use Run Now - there is no evidence that it is running via 'cron'. (How often is the cron list checked by vBulletin when browsing the messages in my Test board?)

3. In the early part of this thread, there is talk of a limit to the number of e-mails sent out in one go - the code doesn't seem to contain a limit, and I can't see one in the configuration. Is it still there? [Update - I see that it isn't - I'm sure why will be revealed soon...]

Thanks

Quentin

OK, I uninstalled, and installed 1.0.9, and the mail is now being sent.

My guess is that I just don't understand the VB Mail Queue (I tried with and without that turned on).

Quentin

[tctransporter]

How do I know if it sent any out? I installed the newest version but I didn't see any option to tell it to run. I just edited the settings and saved it. Is there a way to tell if they was sent?

[djbaxter]

How do I know if it sent any out? I installed the newest version but I didn't see any option to tell it to run. I just edited the settings and saved it. Is there a way to tell if they was sent?

Assuming you are using version 1.09 (highly recommended), the add-on actually runs from a cron job. Go to Admin CP | Scheduled Tasks and try running it manually.

[6piston]

hi C Braithwaite

is there any way that i could check that the mod is working?
like tracking of emails sent and/or report of sent emails etc?

or any alternatives like where to roughly track the effectiveness of the mod?

thanks!
Tom

[Saint_ago]

It's sent from the email address specified in your Admin CP as the forum email address.

Doesn't work. In my board, the messages arrive with this sender address:

BFCentral: A Maior Comunidade de Battlefield da Am?rica Latina <BFCentral:A.Maior.Comunidade.de.Battlefield.da.Am? rica.Latina@sharedhosting2.oi.com.br>

Forum name:
BFCentral: A Maior Comunidade de Battlefield da Am?rica Latina

Email Address:
contato@bfcentral.com.br

Board URL:
http://bfcentral.oi.com.br

I'm using 3.6.5, with SMTP send mail set on NO. My PHP.INI:

sendmail_from admin@bfcentral.com.br
sendmail_path /usr/sbin/sendmail -t -i

Sometimes (depending on the mail client), the sender is just blank.

Plz help me, how can i change this "BFCentral:A.Maior.Comunidade.de.Battlefield.da.Am? rica.Latina@sharedhosting2.oi.com.br" to a valid address?

Thanks in advance

[kellogs]

just change the main email address of your site

The sender email address is wrong. on my forum, i have set the main address as me@abc.com but when it sent out to user it shows the following

"Singapore Motherhood and Parenting Forums" <Singapore Motherhood and Parenting Forums@mail.solone.net>

May i know how to fix it?

Everything else works great!

Thanks,
Edy

[C Braithwaite]

The sender email address is wrong. on my forum, i have set the main address as me@abc.com but when it sent out to user it shows the following

"Singapore Motherhood and Parenting Forums" <Singapore Motherhood and Parenting Forums@mail.solone.net>

May i know how to fix it?

Everything else works great!

Thanks,
Edy

whatever you have set your "Webmaster's Email" address to in your site options.

[fly]

whatever you have set your "Webmaster's Email" address to in your site options.

What he's saying is, that doesn't work. I have mine setup, and yet it sends out the reply address as "UF FORUMS"@SPIVEY.UF.COM

[ElForro]

OK. I really don't understand how this works... again...

I've set 60 days of inactivity... "Inactivity based on last post" set to "NO"

So... I did a User Search for users with last activity after "2007-06-22" AND before "2007-06-23"... The result was 400 users... Let's say, 400 users with last activity 60 days ago...

But when I run the cronjob, it says it found about 4.000 users...

I searched users only with last activity before "2007-06-23" (60 days ago) and it found like 50.000...

So, can anyone please tell me how this product search for the inactive users? Based on what?

Thanks!

Edit: Just made a test with a Test usergroup with TWO (2) users... Run the cron, and it said "Found 4 Inactive Users."... Now that's weird....

Edit 2: Besides all that.. The mails are not being sent... I really don't know what's happening...

[navjotjsingh]

I installed this on another server and confirmed that it will not work if you have SMTP Email set to yes in Vbulletin options.



I use SMTP option and it works fine. For the information I use Gmail SMTP Servers to send mails.

[induslady]

Wanted to know whether this mod works with vB 3.6.3?

[ElForro]

I've checked something else...

When I run the cron [with a Test group] the Cron Log says "No Emails to send". However, the "emailDate" field for that Test Group users change from "0" to "1187976610". So, it is updating the date as if sending the email, but no email is sent...

I've tried both, 1.09 and 1.1.1

I'm using VBulletin 3.6.8

Edit: i've changed "Inactivity based on last post" to YES, and it seems that now it is sending out emails... Must be something wrong with that option...

[cubenz]

Hi,

Great mod :installed:. (1.0.9)

I have modified it slightly to allow the addition of a few 'teasers' from recent, active threads from within the forum. As this is my first vB mod, I'm not sure what to do next with my changes.

What is the protocol here for offering my changes back to the community - do I send them to CB, and he can incorporate them in to the next release, or do I start a new mod?

Thanks

Quentin :)

[Delphiprogrammi]

What is the protocol here for offering my changes back to the community - do I send them to CB, and he can incorporate them in to the next release, or do I start a new mod?


ask the original author to include it within a next release.Do not start a new mod that's against the rules unless you have the original author permission

[raiderlax]

When I run it I get:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /includes/cron/remindermail.php on line 29

Please how do I fix this?

[Tact7626]

nice and nifty. installed today. easy to understand. i almost feel like testing it by going inactive myself but that's crazy. :p


btw. i'm assuming the instructions don't apply to the new one no more cause the instructions say .php but the file is now .xml. so...you should prolly update the instructions so poeple don't get confused and upload it the old way.

[MotMann]

Why does html not working?

[djbaxter]

Why does html not working?

1. If you installed version 1.11, uninstall that. Download version 1.09 and install that instead.

2. If you still can't get HTML emails to work, it may not be this add-on. It may be your mail server, or your email client. Can you normally receive HTML email from other sources? Are you able to send out HTML emails through your mail server from other programs like a newsletter?

[MotMann]

2) yes.. yes. yes ;)

[djbaxter]

Okay, if I understand your somewhat laconic reply, you caqn send out HTML emails from your server AND you can receive HTML emails from your server and/or ISP.

What about the version? Are you using version 1.09 of this add-on? If not, uninstall version 1.10 or 1.11 and download and install version 1.09.

[induslady]

Wanted to know whether this mod works with vB 3.6.3?

Does version1.0.9 work with vB 3.6.3?

Please let me know. I am interested in this mod.

[djbaxter]

It was developed when 3.6.4 was out, if I recall correctly, but I see no reason why it wouldn't work with 3.6.3 - give it a try.

[MotMann]

Are you using version 1.09 of this add-on? If not, uninstall version 1.10 or 1.11 and download and install version 1.09.
I test it...

[vertigo jones]

Hi,

Great mod :installed:. (1.0.9)

I have modified it slightly to allow the addition of a few 'teasers' from recent, active threads from within the forum. As this is my first vB mod, I'm not sure what to do next with my changes.

What is the protocol here for offering my changes back to the community - do I send them to CB, and he can incorporate them in to the next release, or do I start a new mod?

Thanks

Quentin :)

Could you PM this to me? I'd love it. Thanks.

[Fungsten]

Could you PM this to me? I'd love it. Thanks.

Me too!

[cubenz]

Me too!

Will do - I'll need a couple of days to update the documentation :o

A number of the recipients of the e-mails have commented that the HTML tags are visible, even using 1.0.9.

My testing does not show this, using Outlook Express, Outlook 2000, Gmail and Yahoo clients.

Of the ones that have been highlighted to me, the common thread seems to be that the message has been forwarded from the address to which it was sent to another address. Has anyone else experienced this, and is there anyway of making the headers robust enough to preserve the formatting even on forwarding.

Note that I have NOT been able to reproduce this problem, so it will need an e-mail guru to diagnose, IMO.

Thanks

Quentin

[djbaxter]

Hi,

Great mod :installed:. (1.0.9)

I have modified it slightly to allow the addition of a few 'teasers' from recent, active threads from within the forum. As this is my first vB mod, I'm not sure what to do next with my changes.

What is the protocol here for offering my changes back to the community - do I send them to CB, and he can incorporate them in to the next release, or do I start a new mod?

Thanks

Quentin :)

ask the original author to include it within a next release.Do not start a new mod that's against the rules unless you have the original author permission

Could you PM this to me? I'd love it. Thanks.

Me too!

Will do - I'll need a couple of days to update the documentation

Nothing wrong with customizing a mod for your own use or even passing along information about how it was done to others.

However, as has been noted, it's not good form to publish the changes as a new add-on, except where attempts to contact the original author have failed for some reason, and that6 doesn't apply in this case.

As a courtesy, I would suggest you also pass the information along to Chris in case it might be helpful to him in developing future versions.

[raiderlax]

When I run it I get:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /includes/cron/remindermail.php on line 29

Please how do I fix this?


anyone know the reason of this?

[cubenz]

anyone know the reason of this?

Hi,

It means that your query has failed for some reason, and no 'handle' to the query result has been returned.

If you haven't made any changes, then the most likely reasons are:

MySQL DB connection is not being made correctly (in which case, nothing would work)

Mod has not been installed correctly, and a new field emaildate is not present on the user table.

Quentin

[cubenz]

Nothing wrong with customizing a mod for your own use or even passing along information about how it was done to others.

However, as has been noted, it's not good form to publish the changes as a new add-on, except where attempts to contact the original author have failed for some reason, and that6 doesn't apply in this case.

As a courtesy, I would suggest you also pass the information along to Chris in case it might be helpful to him in developing future versions.

Hear what you say - I'll send to CB as well.

Quentin

[cubenz]

Here's an example of what is happening:

The email is coming out with no 'from', but the real 'from' is showing below the headers
Headers are included in message
HTML tags displayed.

Any clues appreciated!

-----Original Message-----
From:
Sent: Tuesday, 4 September 2007 8:33 p.m.
To: <removed for privacy>
Subject: campfire! We miss you!

Content-type: text/html; charset=iso-8859-1

To: campfire <removed>
From: PropertyTalk.com Reminder Service <removed>


<p>Hello, campfire!</p>

<p>We've noticed that you've not been active on PropertyTalk.com for quite
some time now,

and we miss you!</p>

<p>Could we not tempt you back? Here are a few of the things that have been
discussed on the forum recently....</p>

[snip]

[Delphiprogrammi]

hi,

To send that email you must send the content-type header.vBulletins vbmail(); functions uses plaintext by default(/includes/class_mail.php) so something like this

emailreminder.php find


$message = stripslashes($message);


add below


$headers = NULL;
$headers = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
$headers .= 'Content-Transfer-Encoding: 8bit' . "\r\n";
$headers .= 'To: $username <$toemail>' . "\r\n";
$headers .= 'From: ' . $vbulletin->options['bbtitle'] . ' Reminder Service <' . $vbulletin->options['webmasteremail'] . '>' . "\r\n";
$headers .= 'Reply-to:Webmaster <' . $vbulletin->options['webmasteremail'] . '>' . "\r\n";
$headers .='Content-Transfer-Encoding: 8bit' . "\r\n";
$headers .='X-Priority: 1' . "\r\n";

should do it


if it works feel free to use it if not don't yell at me :D

[cubenz]

Thanks

I'm using 1.0.9, which uses mail directly, not vb_mail.

I'll try the new headers, and see what happens.

Quentin

[bryanb]

I've been using this for a couple of months now, and it's been working great.

One problem - I have had a number of AOL spam complaints due to lazy AOL users who would report these mailings as spam instead of letting me know that they'd like to have their accounts deleted. I real PITA.

Is there any way to deselect AOL email addresses (or any email addresses for that matter) using wild cards? That would be great to add as a modification. In the meantime, I've had to shut this off. :(

[Codeman05]

Hello

When I install, I get the following when I run the script:

Inactive User Reminder Emails

db)) { exit; } error_reporting(E_ALL & ~E_NOTICE); if($vbulletin->options['reminder_active']){ $now = time(); $datetime = array(); $quantity = $vbulletin->options['quantity']; $datetime[lastpost] = $now - (60 * 60 * 24 * $vbulletin->options['inactivity']); $datetime[lastemail] = $now - (60 * 60 * 24 * $vbulletin->options['frequency']); $usergroups = explode(",",$vbulletin->options['usergroups']); if($vbulletin->options['reminder_posts']){ $result = $vbulletin->db->query_read("SELECT * FROM " . TABLE_PREFIX . "user WHERE lastpost < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' AND options & 16"); //print("SELECT * FROM " . TABLE_PREFIX . "user WHERE lastpost < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' AND options & 16
"); $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET emailDate = '$now' WHERE lastpost < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' AND options & 16"); //print("UPDATE " . TABLE_PREFIX . "user SET emailDate = '$now' WHERE lastpost < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' AND options & 16
"); } else { $result = $vbulletin->db->query_read("SELECT * FROM " . TABLE_PREFIX . "user WHERE lastactivity < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' AND options & 16"); //print("SELECT * FROM " . TABLE_PREFIX . "user WHERE lastactivity < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' AND options & 16
"); $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET emailDate = '$now' WHERE lastactivity < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' AND options & 16"); //print("UPDATE " . TABLE_PREFIX . "user SET emailDate = '$now' WHERE lastactivity < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' AND options & 16
"); } print("Found " . mysql_num_rows($result) . " Inactive Users.

"); while($row = $vbulletin->db->fetch_array($result)){ if(is_member_of($row, $usergroups)){ print("Sent To: $row[username]
"); $username = $row[username]; $toemail = $row[email]; $userid = $row[userid]; $bbtitle = $vbulletin->options['bbtitle']; $homeurl = $vbulletin->options['homeurl']; $forumurl = $vbulletin->options['bburl']; $hometitle = $vbulletin->options['hometitle']; eval('$message = "' . addslashes($vbulletin->options['message']) . '";'); $message = stripslashes($message); //$headers = "MIME-Version: 1.0" . "\r\nContent-type: text/html; charset=iso-8859-1" . "\r\n"; $uheaders .= "To: $username <$email>" . "\r\n"; $uheaders .= "From: " . $vbulletin->options['bbtitle'] . " Reminder Service <" . $vbulletin->options['webmasteremail'] . ">" . "\r\n"; eval('$subject = "' . addslashes($vbulletin->options['subject']) . '";'); $subject = stripslashes($subject); if($vbulletin->options['reminder_emailfooter']){ $message = $message . "Email Reminder System Provided By Mished.co.uk"; } /*if(@mail($email, $subject, $message, $headers)){ print("mailing $email (done)
"); } else { print("mailing $email (failed)
"); }*/ if(is_valid_email($toemail)){ $sentlist .= "$username "; vbmail($toemail, $subject, $message, $notsubscription = false, $from = $vbulletin->options['bbtitle'], $uheaders = '', $username = ''); } else { $failedlist .= "$username "; } } } if($sentlist == ""){ log_cron_action("No Emails to send", $nextitem); vbmail($vbulletin->options['webmasteremail'], "Inactive User Reminder Email Report", "This email shows that the product is installed and working as it should be.\n\n\nThere were no inactive users at this time.", $notsubscription = false, $from = $vbulletin->options['bbtitle'], $uheaders = "From: " . $vbulletin->options['bbtitle'] . " Reminder Service <" . $vbulletin->options['webmasteremail'] . ">" . "\r\n", $username = ''); } else { log_cron_action("Emails sent to:$sentlist. We tried to email the following users, but their email address was invalid:$failedlist", $nextitem); vbmail($vbulletin->options['webmasteremail'], "Inactive User Reminder Email Report", "This email shows that the product is installed and working as it should be.\n\n\nEmails sent to:" . $sentlist . ". We tried to email the following users, but their email address was invalid:" . $failedlist . "", $notsubscription = false, $from = $vbulletin->options['bbtitle'], $uheaders = "From: " . $vbulletin->options['bbtitle'] . " Reminder Service <" . $vbulletin->options['webmasteremail'] . ">" . "\r\n", $username = ''); } } else { print("Product is inactive at this time!"); } ?>
Done



The script dosnt sent out any emails if i run it myself or let it run itsself.

Any ideas?



I am having the same error, any thoughts??

[Delphiprogrammi]

phpmailer (http://phpmailer.sourceforge.net) will do just fine to


require_once(DIR . '/includes/class.phpmailer.php');
$mail = new PHPMailer();
$mail->isSendMail(true);
$mail->Priority = 1;
$mail->isHTML(true);
$mail->Encoding = "8bit";
$mail->CharSet = "iso-8859-1";
$mail->From = "";
$mail->FromName = "nobody";
$mail->AddReplyTo("","webmaster");
$mail->AddAddress("$toemail","$username");
$mail->Subject = "$subject";
$mail->Body = "$message";
$mail->AltBody = "";
$mail->WordWrap = 0;
if(!$mail->send());
{
echo "Mailer Error: " . $mail->ErrorInfo;
}


will send HTML email easy !

[dollster68]

Thank you, thank you, thank you for this nifty tool. Got it installed with the help of djbaxter (I'm a total novice that needed help with where to upload the .xml file).

Since there are a few versions being run of this mod I would like to suggest a FAQ on the front page. It took a long time to scroll through 50+ pages of this tread only to find that the answer to my question wasn't there. Also, the very first post stated that instructions were included, but I couldn't find any when I downloaded v. 1.09.

[bryanb]

...Is there any way to deselect AOL email addresses (or any email addresses for that matter) using wild cards? That would be great to add as a modification. In the meantime, I've had to shut this off. :(
Any ideas on how to do this? Thanks in advance!

[djbaxter]

Why did you need to "shut this off" because of AOL? I don't understand the problem. We all know that AOL filters email aggressively but so what?

[bryanb]

Why did you need to "shut this off" because of AOL? I don't understand the problem. We all know that AOL filters email aggressively but so what?
Because I have hundreds of newsletter subscribers and forum members who use AOL. If my server is receiving spam complaints from AOL, then that is a big issue for me. My domain could be blocked from AOL and that would not be a good thing.

I am hoping that someone could assist me in coming up with a solution for this. Thanks!

[djbaxter]

Because I have hundreds of newsletter subscribers and forum members who use AOL. If my server is receiving spam complaints from AOL, then that is a big issue for me. My domain could be blocked from AOL and that would not be a good thing.

I am hoping that someone could assist me in coming up with a solution for this. Thanks!

The solution is to include opt-out instructions in every email. Edit the message from your ACP to do so. Here's a sample:

Hello, $username!

<p>You are receiving this email because you previously registered at {name of your forum here} with the following information:</p>

<p>Member name: $username<br>
User number: $userid<br>
Email address: $email</p>

<p>It's been some time since your last visit to our community.</p>

<p>You might be interested in having another look. We have added several features and enhancements to the forums, and many new topics and new members are added every day.</p>

<p>If you don't remember your password, you can request it here: <a href="http://{forum URL here}/login.php?do=lostpw">http://{forum URL here}/login.php?do=lostpw</a>.</p>

<p>We hope to see you back soon.</p>

<p>If you do not wish to receive further emails of this nature, please log into your UserCP at <a href="http://{forum URL here}/profile.php?do=editoptions">http://{forum URL here}/profile.php?do=editoptions</a> and uncheck the box next to Receive Email from Administrators.</p>

<p>Administrator<br>
<a href="http://{forum URL here}">{forum name here}</a><br></p>

I include opt-out instructions in every email sent out by my forum. I've had notices a few times (I think 3 or 4) about my emails being blocked as spam at the ISP level. Each time, I hjave forwarded a copy of the email pointing out that only registered forum members ever receive the emails and that opt-out instructions are included - I have had the block removed every time.

[bryanb]

The solution is to include opt-out instructions in every email. Edit the message from your ACP to do so. Here's a sample:



I include opt-out instructions in every email sent out by my forum. I've had notices a few times (I think 3 or 4) about my emails being blocked as spam at the ISP level. Each time, I hjave forwarded a copy of the email pointing out that only registered forum members ever receive the emails and that opt-out instructions are included - I have had the block removed every time.
Thanks a million! I think that will do the trick :up:

[Job4Suprmn]

Not sure if anyone else experienced this. I saw people saying it sends e-mails to banned users. But on my board, banned users came back...unbanned.

Does this mod inadvertently un-ban people? Maybe when they click the link to change their password? I'm not sure how he got back, he just e-mailed me bragging saying that he got back because of the reminder e-mail.

[CMGU]

great .. thanks

[djbaxter]

Not sure if anyone else experienced this. I saw people saying it sends e-mails to banned users. But on my board, banned users came back...unbanned.

Does this mod inadvertently un-ban people? Maybe when they click the link to change their password? I'm not sure how he got back, he just e-mailed me bragging saying that he got back because of the reminder e-mail.

No, it doesn't unban banned members.

1. You can select which member groups to email in the ACP under vBulletin Options | Inactive Users Email | Usergroups:

Usergroups
List the usergroups that you wish to send the emails to here. (Seperate by commas) eg. 2,3,4,7

Make sure that banned members aren't included.

2. How was the member banned? I don't know whether it's yet fixed but in version 3.6.6, I believe, or eerlier, there was a vBulletin bugged where members banned via the infraction system were able to return after one of their infractions expired, even when one of the infractions resulted in a permanent ban.

3. You say he emailed you. Did he return to the forum and post anything? If no, he's probably yanking your chain.

[Fungsten]

I can't get it to work in 3.6.8.

[djbaxter]

I can't get it to work in 3.6.8.

It works fine in 3.6.8.

What happens when you install it? Which version are you installing? It helps if you provide a bit more information beyond just "this doesn't work".

[Fungsten]

It works fine in 3.6.8.

What happens when you install it? Which version are you installing? It helps if you provide a bit more information beyond just "this doesn't work".

Sorry. Using your latest version. When I ran it no reminders were sent out. Yes all the appropriate usergroups are added.

[djbaxter]

Version 1.11 should be labeled "Beta", in my opinion. Try uninstalling that version and installing 1.09.

[Fungsten]

Version 1.11 should be labeled "Beta", in my opinion. Try uninstalling that version and installing 1.09.

Didn't have to uninstall 1.11. Just installed 1.09 and it works.

[Job4Suprmn]

No, it doesn't unban banned members.

1. You can select which member groups to email in the ACP under vBulletin Options | Inactive Users Email | Usergroups:

Usergroups
List the usergroups that you wish to send the emails to here. (Seperate by commas) eg. 2,3,4,7

Make sure that banned members aren't included.

2. How was the member banned? I don't know whether it's yet fixed but in version 3.6.6, I believe, or eerlier, there was a vBulletin bugged where members banned via the infraction system were able to return after one of their infractions expired, even when one of the infractions resulted in a permanent ban.

3. You say he emailed you. Did he return to the forum and post anything? If no, he's probably yanking your chain.

Yes, he posted. He was banned originally on another forum software, so maybe something funky happened there. I'm not really sure. I'll let you know if anyone else seems to come back.

Thanks

[SaTaNaSsO]

great hack... it works very fine with 3.6.7 ... i will update to 3.6.8 soon and i will check...
:):cool:

[abhimation]

Installed ! How do i check if its working fine ?

[cheat-master30]

Your own email should get emails like this every day:

Inactive User Reminder Email Report

This email shows that the product is installed and working as it should be.


There were no inactive users at this time.

[yoyoyoyo]

I am running 3.6.8 - should the latest version still considered "beta" (as many people here have suggested) or is it safe to run? Are there any edits/changes I should make to the latest version to get it to run properly?

[djbaxter]

It is safe to install. It just may not work correctly on your forum - that's why I've been suggesting it be considered beta.

Try it if you wish. If it doesn't work, uninstall it and install 1.09.

[Fungsten]

I got it fully working on 3.6.8. What happened is the email address that show which members were the reminder was the webmaster's address; I hadn't re-added it when I changed servers. :erm:

[Phooey]

I don't know why I didn't do this sooner, but I finally installed it. Great hack, thanks!

[alfieuk]

Wish everything set up this easy :)

Awesome job

[xandizitxu]

This mod helped me a lot! Thanks!

[SuperTaz]

Very nice. Installed

[htscpl]

Great mod ! Thanks ** installs **

[Ribena88]

Thanks, great mod!

[ski diva]

Question: when this is made active, does it send an email out immediately? I have it set so that the email frequency is 90 days, if a user has been inactive for 90 days. Does this mean that it will be 90 days before the first email goes out? And how will I know if an email has been sent? Is there any notification process?

Thanks!

Edited the following day: Never mind -- I received notification. Another question, though -- is there any way I can see an actual copy of any of the emails that went out?

[Datc]

I also have a problem with the sender address. The "from address" host name is the servers host name which is totally wrong. I'm afraid it doesn't get the entered email address in VB. I need to solve this immediately. Please help !

[djbaxter]

I also have a problem with the sender address. The "from address" host name is the servers host name which is totally wrong. I'm afraid it doesn't get the entered email address in VB. I need to solve this immediately. Please help !

It would be helpful if you would post the version number you have installed.

How do you know that the From: address is incorrect? Have you looked at an actual email that was sent out? Or is this on the basis of a returned ("bounced") email?

[Datc]

Version is 1.1.1.

I had a user registered that was inactive. So I received the email also. Which comes to the point that there also must be something to test the system before it starts sending out. I was just lucky... But the from field is still wrong..

[djbaxter]

Version is 1.1.1.

I had a user registered that was inactive. So I received the email also. Which comes to the point that there also must be something to test the system before it starts sending out. I was just lucky... But the from field is still wrong..

So you received the email as a bounceback? If so, depending on your server, it would not contain the forum email as sender but rather the mail server - unless I'm missing something, that seems to have been what happened here.

[Datc]

No its not a bounceback. I had an inactive user. I received it just like everybody else received it.

Yes the part about the mail server email is right. It was like forumname<forumname@sub.servername.com> whereas is should have been webmaster@forumdomain.com .

[djbaxter]

No its not a bounceback. I had an inactive user. I received it just like everybody else received it.

Yes the part about the mail server email is right. It was like forumname<forumname@sub.servername.com> whereas is should have been webmaster@forumdomain.com .

Are you telling me that YOU were the inactive user?

[applyimage]

could somebody direct me specifically to where we edit the email reminder settings? thanks :)

edit: ignore! fantastic!

[XXP]

This is a great idea but, and please forgive me for being obtuse, where does the message go?

1. Where does the outbound message go?

2. Is there a way to test the outbound message -- for, e.g., making sure that it looks OK?

3. Is any HTML header/footer needed or can we just drop a block of formatted HTML into (wherever it is that the message goes)?

Thanks. :o

[energetic]

Thanks to sharing :)

[towermatt]

This is a great idea but, and please forgive me for being obtuse, where does the message go?

1. Where does the outbound message go?

2. Is there a way to test the outbound message -- for, e.g., making sure that it looks OK?

3. Is any HTML header/footer needed or can we just drop a block of formatted HTML into (wherever it is that the message goes)?

Thanks. :o

There is an example earlier in the thread. I used it because it included instructions on how to stop the email from being sent.

The outbound message goes to the member that has been inactive for the time set in the cron.

You can test the outbound message by activating it, then setting up a user and changing their "last active" date to something that would trigger it.

[Vi Tiểu Bảo]

Thank :) ! installed :) !

[Datc]

Are you telling me that YOU were the inactive user?

Exactly. That's how I saw the address was the servers host name.

[djbaxter]

Exactly. That's how I saw the address was the servers host name.

OK. I suggest you uninstall 1.11 and install 1.09.

[XXP]

You can test the outbound message by activating it, then setting up a user and changing their "last active" date to something that would trigger it.

No; that doesn't seem to be sending the mail out. NG for test also because you have to keep changing/defeating the settings to fool the plugin into firing.

So I do that and have now created a special user group just for it.... and it says it is sending the mail, but it isn't.

Weird.

[XXP]

OK. I suggest you uninstall 1.11 and install 1.09.

Please explain; why would that make a difference?

Thanks very much.

[XXP]

You can test the outbound message by activating it, then setting up a user and changing their "last active" date to something that would trigger it.

ALSO this is NG because "...Reminder" code works by putting mail in the VB mail queue. That means you either have to change its settings also or you have to wait for it to come around.

Not a good idea to change it's settings becaues at this point we're already 2 or 3 levels deep in changes for testing (that you have to remember to change back afterward), and with all this changing... something is going to get lost.

So, how about a test set up. A button to push that sends one copy of mail to specified address? That would be cool.

Thanks for your suggestions though; very much!

[quasan]

No its not a bounceback. I had an inactive user. I received it just like everybody else received it.

Yes the part about the mail server email is right. It was like forumname<forumname@sub.servername.com> whereas is should have been webmaster@forumdomain.com .

yop got the same problem too

[Zia]

hi..
we just got it installed - after install...i check schedule task log...there i found error..
see the SS bellow

https://vborg.vbsupport.ru/

plz note that- the mentioned user name have 50+ post, after they confirm there email activation mail, they started the post, so theres no chance -that there mail id is invalid.

confused...why the error msg & is it working?

[djbaxter]

Please explain; why would that make a difference?

Thanks very much.

Version 1.09 was a stable version for most people that did not use the built-in vBulletin email system.

Version 1.11 converted to send all emails through the vBulletin mail queue. This caused problems on some installations. I recommend that people install version 1.09 and consider 1.11 to be a beta.

[djbaxter]

hi..
we just got it installed - after install...i check schedule task log...there i found error..
see the SS bellow

http://img237.imageshack.us/img237/6654/errormo1.jpg

plz note that- the mentioned user name have 50+ post, after they confirm there email activation mail, they started the post, so theres no chance -that there mail id is invalid.

confused...why the error msg & is it working?

The fact that the email address was once valid doesn't mean that it's still valid. People change email addresses and abandon email addresses all the time. Also, last time I checked, if you didn't log in to Hotmail or Yahoo every 3 months, you lost that email address. Also, some times members will log in and change their email addresses to something invalid if they decide they no longer want to receive email from a forum.

What exactly WERE the addresses? Were they constructed properly?

[Zia]

logicaly ur point is okay.
but note that- kirbyx - still on my msn using the same id he registerd with.

fyr- msn/yahoo - non logged for 3months wont be lost/mite be inactive..yahoo duration is not 3months... its more...//

[redtailboa]

I am still having issues with this mod on 2 different servers.

Both servers use the SMTP option instead of a local sendmail server. Here is what the log says:

Emails sent to:test_account ILoveMyBoa4209 Brandon480 catesncboas . We tried to email the following users, but their email address was invalid:


I setup a test account and verified that the email did not send out. I also have confirmed that my SMTP server is working, my members are receiving emails from the board for new account setups, password resets etc.

Any clue what to do? I really want to use this mod

[djbaxter]

1. Is the account identified as invalid actually operational? Did it have the correct syntax?

2. what version are you using?

[redtailboa]

1. Is the account identified as invalid actually operational? Did it have the correct syntax?

2. what version are you using?

1) All the accounts it sends to it does this to. The first time I ran it it said this for over 3,000 members. In the example I showed, the account was valid.

2) Latest version. 1.1.1

[djbaxter]

As I have said many times, I personally consider version 1.11 to be a beta version. I know Chris was trying to work on this but my guess is real life got in the way to delay it.

Uninstall version 1.11 and install version 1.09.

[Zia]

Helo...

55216 Inactive User Reminder Emails 01:03, 11th Oct 2007 Emails sent to:sreshto GKing rizz HonestBoy gontobboheen Chonchola Horini moharaj noman_auleek maria Amski arifbarbhuiya mhasan . We tried to email the following users, but their email address was invalid:
its really weired
the nick Gking- we always use to same mail id (even this morning) i got mail from his id- why it says invalid mail id?

we are using v 1.1.1
whats the probs?

[djbaxter]

the nick Gking- we always use to same mail id (even this morning) i got mail from his id- why it says invalid mail id? whats the probs?

What version are you using? Does this help?:

As I have said many times, I personally consider version 1.11 to be a beta version. I know Chris was trying to work on this but my guess is real life got in the way to delay it.

Uninstall version 1.11 and install version 1.09.

[IRCMedya]

thank you, installed

[bazzup]

@zia and redtailboa

when it reports like this

55216 Inactive User Reminder Emails 01:03, 11th Oct 2007 Emails sent to:sreshto GKing rizz HonestBoy gontobboheen Chonchola Horini moharaj noman_auleek maria Amski arifbarbhuiya mhasan . We tried to email the following users, but their email address was invalid:

that means all the users got the email and there were no invalid emails

the bit you are looking for in the message is this

We tried to email the following users, but their email address was invalid:username

note on the posts you have made nobodys email was invalid because there where no usernames after the invalid bit

hope this makes sense

[PinkLiquorice]

Why is the footer text so big?! Do we have to have the copyright for a mod on it as it doesnt match the rest of the site... cant I make it smaller at least?!

[djbaxter]

Why is the footer text so big?!
cant I make it smaller at least?!

I don't think Chris cares how big it is as long as you leave the active link.

Do we have to have the copyright for a mod on it as it doesnt match the rest of the site...

Read the instructions in post #1.

[PinkLiquorice]

Ok will make it smaller. thank you

[vbuser99]

Recently I have installed version 1.11.

I have 150K members, installing this add-on for the first time may put server on its knees as it may try to send lots of emails at once. This also may cause your site marked as email spammer (or something like that) due to high number of emails per batch.

I figured I needed more options, like maximum number of emails per batch (cron) and maximum number of reminder emails per user, so users do not continue getting reminders after X number of reminders.

So I added said new options and optimized and corrected SQL code (there were some bugs) in the add-on, and now it is working great!

I would love to share this updated add-on but I do not really know where/how to post it.

Shall I post it as a new add-on on a new thread, or ...???

[BadgerDog]

Recently I have installed version 1.11.



You actually got v1.11 to work ... :eek:

Congratulations.... :D

I've stuck with v1.09 and it has been working fine, but your addtional options would be nice to add.

I'd love to see your fixes posted and tried by folks who couldn't get v1.11 to function. If it works, I might just upgrade to it with your mods.

Thanks for your work.... :up:

Regards,
Badger

[vbuser99]

You actually got v1.11 to work ... :eek:

Congratulations.... :D

I've stuck with v1.09 and it has been working fine, but your addtional options would be nice to add.

I'd love to see your fixes posted and tried by folks who couldn't get v1.11 to function. If it works, I might just upgrade to it with your mods.

Thanks for your work.... :up:

Regards,
Badger

Yes, it works and it is great, as SQL is optimized, it is fast too.

[djbaxter]

Recently I have installed version 1.11.

I have 150K members, installing this add-on for the first time may put server on its knees as it may try to send lots of emails at once. This also may cause your site marked as email spammer (or something like that) due to high number of emails per batch.

That's one of the reasons I prefer v1.09.

I figured I needed more options, like maximum number of emails per batch (cron) and maximum number of reminder emails per user, so users do not continue getting reminders after X number of reminders.

So I added said new options and optimized and corrected SQL code (there were some bugs) in the add-on, and now it is working great!

I would love to share this updated add-on but I do not really know where/how to post it.

Shall I post it as a new add-on on a new thread, or ...???

The author is Chris. Could you PM him and ask what his preference are? if you can't get an answer from him, I'd suggest uploading it here as an attachment, with a disclaimer that your version isn't currently supported - caveat emptor. :)

I've stuck with v1.09 and it has been working fine, but your addtional options would be nice to add.

I'd love to see your fixes posted and tried by folks who couldn't get v1.11 to function. If it works, I might just upgrade to it with your mods.

Thanks for your work.... :up:

Indeed. But bear in mind that the author can only support official versions. If you encounter a problem with an unofficial update, uninstall that version and go back to 1.09.

[vbuser99]

This is the unsupported updated version of Email reminder for inactive users add-on.
You need to uninstall previous versions (1.09 or 1.11) before installing version 1.20
Both product-remindermail.xml and remindermail.php has been updated.

Version 1.20 is updated and is the working and improved version of 1.11

Updates:
- Renamed emailDate field to reminderDate (user table) because it was too generic.
- Added reminderCount field (user table)
- Added limitperbatch option to limit number of emails sent to inactive users per batch (per cron run).
- Added limitperuser option to limit number of reminder emails sent to a user.
- Updated email message
- Pull only required data via SQL for better performance.
- This version ensures that updates to user table are done correctly, by updating only processed rows. Previous version was bulk updating user table before process started.

I am in the process of adding requested changes, will upload the finished product soon...

[XXP]

Thanks for these updates (both of you). These look like they're going to be quite helpful.

We installed 1.11 and ran it successfully last week. Have delivered around 5K reminders since.

Because you call for the old Reminder to be removed and because you mention changes to the database mechanism, I need to ask, please:

Will 1.2 honor the reminders already sent -- and thus NOT resend reminders to users who've already been invited to return?

Also:
What do we need to do to preserve our customized message before installing 1.2? Will it be preserved for us or should we explicitly back it up and reinstall it?

Is there a test mechanism in this version -- to send out a test copy of the email message for proofing? (Such as: send a test copy to Admin group only, regardless of activity; OR send a test copy to user(s) in list.)

Thanks again. This is a supper tool.

[vbuser99]

Thanks for these updates (both of you). These look like they're going to be quite helpful.

We installed 1.11 and ran it successfully last week. Have delivered around 5K reminders since.

Because you call for the old Reminder to be removed and because you mention changes to the database mechanism, I need to ask, please:

Will 1.2 honor the reminders already sent -- and thus NOT resend reminders to users who've already been invited to return?

Also:
What do we need to do to preserve our customized message before installing 1.2? Will it be preserved for us or should we explicitly back it up and reinstall it?

Is there a test mechanism in this version -- to send out a test copy of the email message for proofing? (Such as: send a test copy to Admin group only, regardless of activity; OR send a test copy to user(s) in list.)

Thanks again. This is a supper tool.

As I am quite new into code releasing, I did not think of this issue.
The attached version 1.20 will NOT preserve any data as UNINSTALL is required.

I will create a seperate upgrade version, which will keep your previous settings and will honor the reminders already sent.

I will also work on a test mechanism...

[frostyIntrepid]

I am sorry but did anyone get this to work on 3.6.8?

[Alibass]

Sure it works fine on 3.6.8 and PL1. I am using it and have been for quite awhile.

[lairnoc]

ok installed it. nou hope it will do its job :P

[pitzerwm]

First, Thanks for taking the time and energy to write this mod. It really provides a needed service.

I don't know if this is functioning right and/or I have it set up right.

I set it email people that hadn't been there in 15 days, 30 days between emails and 10 at a time. I set the schedule for Monday night at 1, looking at the log, on Monday night it started sending the emails and sent about 60 of them, 10 at a time, but then every minute or so, for hours it "cycled" and reported "no emails sent". Although a couple of times during that 22 hour time frame it would send 1 email out.

Is this the way it works? Is it working its way through the members 10 at a time, every minute or so? I have about 400 members.

Thanks

[Zia]

where to download v1.2 .

---
we are on v 1.11-- i just want to be sure its working-
in schedule task log its showing - No emails to send

any one can pls help me out

[jags2ooo]

I get a error when i attempt to run the task.

Fatal error: Maximum execution time of 30 seconds exceeded in /home2/ZZZZZ/public_html/XXXXXX/forums/includes/class_core.php on line 660

Overall Great mod i couldn't have gotten this in a better time.. 60k + users 13k active >.<

[birdie]

Installed 1.1.1 and set it up and got this error when went to scheduled tasks and hit run now:Inactive User Reminder Emails
Found 3927 Inactive Users.
Sent To: <removed name>

Fatal error: Call to a member function on a non-object in /home/po/pod/<forum name>/public/www/<forum name>/includes/class_mail.php(266) : eval()'d code on line 12Anyone know what it means. I do note the previous posts re 1.1.1 v 1.09 ...

[Phongvanlau]

Hi,

Sorry to ask this kind of question here, please fogive me, I am new to all of this. Do have have to change this $bbtitle, $homeurl, $forumurl/login.php?do=lostpw to anything.

[walidaly]

thanks for the hack
please do not use short php tags <? instead use the default <?php
thanks again ;)

[shepherdblake]

I have this installed on vbulletin 2.6.8 SP1. It runs fine (even manually), but doesn't actually send an email.

My scheduled task log looks like this:

658 Inactive User Reminder Emails 18:48, 5th Nov 2007 Emails sent to:John Hartsel . We tried to email the following users, but their email address was invalid:

that is my test user and I know I have his email address correct. that email account is able to receive other emails from the board.

How can I start troubleshooting this?

thanks!

[brvheart]

I get the below as well on 3.6.8, I have tried both versions....can someone help me please?

Originally Posted by Greivog View Post
Hello

When I install, I get the following when I run the script:

Inactive User Reminder Emails

db)) { exit; } error_reporting(E_ALL & ~E_NOTICE); if($vbulletin->options['reminder_active']){ $now = time(); $datetime = array(); $quantity = $vbulletin->options['quantity']; $datetime[lastpost] = $now - (60 * 60 * 24 * $vbulletin->options['inactivity']); $datetime[lastemail] = $now - (60 * 60 * 24 * $vbulletin->options['frequency']); $usergroups = explode(",",$vbulletin->options['usergroups']); if($vbulletin->options['reminder_posts']){ $result = $vbulletin->db->query_read("SELECT * FROM " . TABLE_PREFIX . "user WHERE lastpost < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' AND options & 16"); //print("SELECT * FROM " . TABLE_PREFIX . "user WHERE lastpost < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' AND options & 16
"); $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET emailDate = '$now' WHERE lastpost < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' AND options & 16"); //print("UPDATE " . TABLE_PREFIX . "user SET emailDate = '$now' WHERE lastpost < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' AND options & 16
"); } else { $result = $vbulletin->db->query_read("SELECT * FROM " . TABLE_PREFIX . "user WHERE lastactivity < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' AND options & 16"); //print("SELECT * FROM " . TABLE_PREFIX . "user WHERE lastactivity < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' AND options & 16
"); $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET emailDate = '$now' WHERE lastactivity < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' AND options & 16"); //print("UPDATE " . TABLE_PREFIX . "user SET emailDate = '$now' WHERE lastactivity < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' AND options & 16
"); } print("Found " . mysql_num_rows($result) . " Inactive Users.

"); while($row = $vbulletin->db->fetch_array($result)){ if(is_member_of($row, $usergroups)){ print("Sent To: $row[username]
"); $username = $row[username]; $toemail = $row[email]; $userid = $row[userid]; $bbtitle = $vbulletin->options['bbtitle']; $homeurl = $vbulletin->options['homeurl']; $forumurl = $vbulletin->options['bburl']; $hometitle = $vbulletin->options['hometitle']; eval('$message = "' . addslashes($vbulletin->options['message']) . '";'); $message = stripslashes($message); //$headers = "MIME-Version: 1.0" . "\r\nContent-type: text/html; charset=iso-8859-1" . "\r\n"; $uheaders .= "To: $username <$email>" . "\r\n"; $uheaders .= "From: " . $vbulletin->options['bbtitle'] . " Reminder Service <" . $vbulletin->options['webmasteremail'] . ">" . "\r\n"; eval('$subject = "' . addslashes($vbulletin->options['subject']) . '";'); $subject = stripslashes($subject); if($vbulletin->options['reminder_emailfooter']){ $message = $message . "Email Reminder System Provided By Mished.co.uk"; } /*if(@mail($email, $subject, $message, $headers)){ print("mailing $email (done)
"); } else { print("mailing $email (failed)
"); }*/ if(is_valid_email($toemail)){ $sentlist .= "$username "; vbmail($toemail, $subject, $message, $notsubscription = false, $from = $vbulletin->options['bbtitle'], $uheaders = '', $username = ''); } else { $failedlist .= "$username "; } } } if($sentlist == ""){ log_cron_action("No Emails to send", $nextitem); vbmail($vbulletin->options['webmasteremail'], "Inactive User Reminder Email Report", "This email shows that the product is installed and working as it should be.\n\n\nThere were no inactive users at this time.", $notsubscription = false, $from = $vbulletin->options['bbtitle'], $uheaders = "From: " . $vbulletin->options['bbtitle'] . " Reminder Service <" . $vbulletin->options['webmasteremail'] . ">" . "\r\n", $username = ''); } else { log_cron_action("Emails sent to:$sentlist. We tried to email the following users, but their email address was invalid:$failedlist", $nextitem); vbmail($vbulletin->options['webmasteremail'], "Inactive User Reminder Email Report", "This email shows that the product is installed and working as it should be.\n\n\nEmails sent to:" . $sentlist . ". We tried to email the following users, but their email address was invalid:" . $failedlist . "", $notsubscription = false, $from = $vbulletin->options['bbtitle'], $uheaders = "From: " . $vbulletin->options['bbtitle'] . " Reminder Service <" . $vbulletin->options['webmasteremail'] . ">" . "\r\n", $username = ''); } } else { print("Product is inactive at this time!"); } ?>
Done



The script dosnt sent out any emails if i run it myself or let it run itsself.

[brvheart]

Anyone?? This is a great mod, very useful...if I could just get it to work...

[mask31]

hi, on the email body, how do we skip lines?

when i receive the email everything is on one line, there's no line break. how do we do that?

thanks for your help

[djbaxter]

hi, on the email body, how do we skip lines?

when i receive the email everything is on one line, there's no line break. how do we do that?

thanks for your help

Use <p> and <br> or <br /> tags to separate paragraphs and insert line breaks respectively - standard HTML.

Here's a sample:

Hello, $username!

<p>You are receiving this email because you previously registered at {name of forum} with the following information:</p>

<p>Member name: $username<br>
User number: $userid<br>
Email address: $email</p>

<p>It's been some time since your last visit to our community.</p>

<p>You might be interested in having another look. We have added several features and enhancements to the forums, and many new topics and new members are added every day.</p>

<p>If you don't remember your password, you can request it here: <a href="http://{your forum URL}/login.php?do=lostpw">http://{your forum URL}/login.php?do=lostpw</a>.</p>

<p>You can now keep up to date with new topics at $bbtitle by subscribing to the Forum Newsletter. Click on your UserCP link (<a href="http://{your forum URL}/usercp.php">http://{your forum URL}/usercp</a>) in the top navigation bar of any forum page and select Edit Options ( <a href="http://{your forum URL}/profile.php?do=editoptions">http://{your forum URL}/profile.php?do=editoptions</a> ). Then scroll down to the Messaging & Notification section and check the box next to Subscribe to Forum Newsletter.</p>

<p>We hope to see you back soon.</p>

<p>If you do not wish to receive further emails of this nature, please log into your UserCP at <a href="http://{your forum URL}/profile.php?do=editoptions">http://{your forum URL}/profile.php?do=editoptions</a> and uncheck the box next to Receive Email from Administrators.</p>

<p>Administrator<br>
<a href="http://{your forum URL}">Name of Your Forum</a><br>
http://{your forum URL}</p>

[mask31]

thanks mate :)

[brvheart]

I get the below as well on 3.6.8, I have tried both versions....can someone help me please?

Anyone help me on 3.6.8 please?

[djbaxter]

Anyone help me on 3.6.8 please?

What happens when you try to install and/or run it? If you're getting an error message, what does it say?

[brvheart]

sorry, I posted it, and forgot to reference it:

https://vborg.vbsupport.ru/showpost.php?p=1376716&postcount=945

Originally Posted by Greivog View Post
Hello

When I install, I get the following when I run the script:

Inactive User Reminder Emails

db)) { exit; } error_reporting(E_ALL & ~E_NOTICE); if($vbulletin->options['reminder_active']){ $now = time(); $datetime = array(); $quantity = $vbulletin->options['quantity']; $datetime[lastpost] = $now - (60 * 60 * 24 * $vbulletin->options['inactivity']); $datetime[lastemail] = $now - (60 * 60 * 24 * $vbulletin->options['frequency']); $usergroups = explode(",",$vbulletin->options['usergroups']); if($vbulletin->options['reminder_posts']){ $result = $vbulletin->db->query_read("SELECT * FROM " . TABLE_PREFIX . "user WHERE lastpost < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' AND options & 16"); //print("SELECT * FROM " . TABLE_PREFIX . "user WHERE lastpost < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' AND options & 16
"); $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET emailDate = '$now' WHERE lastpost < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' AND options & 16"); //print("UPDATE " . TABLE_PREFIX . "user SET emailDate = '$now' WHERE lastpost < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' AND options & 16
"); } else { $result = $vbulletin->db->query_read("SELECT * FROM " . TABLE_PREFIX . "user WHERE lastactivity < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' AND options & 16"); //print("SELECT * FROM " . TABLE_PREFIX . "user WHERE lastactivity < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' AND options & 16
"); $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET emailDate = '$now' WHERE lastactivity < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' AND options & 16"); //print("UPDATE " . TABLE_PREFIX . "user SET emailDate = '$now' WHERE lastactivity < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' AND options & 16
"); } print("Found " . mysql_num_rows($result) . " Inactive Users.

"); while($row = $vbulletin->db->fetch_array($result)){ if(is_member_of($row, $usergroups)){ print("Sent To: $row[username]
"); $username = $row[username]; $toemail = $row[email]; $userid = $row[userid]; $bbtitle = $vbulletin->options['bbtitle']; $homeurl = $vbulletin->options['homeurl']; $forumurl = $vbulletin->options['bburl']; $hometitle = $vbulletin->options['hometitle']; eval('$message = "' . addslashes($vbulletin->options['message']) . '";'); $message = stripslashes($message); //$headers = "MIME-Version: 1.0" . "\r\nContent-type: text/html; charset=iso-8859-1" . "\r\n"; $uheaders .= "To: $username <$email>" . "\r\n"; $uheaders .= "From: " . $vbulletin->options['bbtitle'] . " Reminder Service <" . $vbulletin->options['webmasteremail'] . ">" . "\r\n"; eval('$subject = "' . addslashes($vbulletin->options['subject']) . '";'); $subject = stripslashes($subject); if($vbulletin->options['reminder_emailfooter']){ $message = $message . "Email Reminder System Provided By Mished.co.uk"; } /*if(@mail($email, $subject, $message, $headers)){ print("mailing $email (done)
"); } else { print("mailing $email (failed)
"); }*/ if(is_valid_email($toemail)){ $sentlist .= "$username "; vbmail($toemail, $subject, $message, $notsubscription = false, $from = $vbulletin->options['bbtitle'], $uheaders = '', $username = ''); } else { $failedlist .= "$username "; } } } if($sentlist == ""){ log_cron_action("No Emails to send", $nextitem); vbmail($vbulletin->options['webmasteremail'], "Inactive User Reminder Email Report", "This email shows that the product is installed and working as it should be.\n\n\nThere were no inactive users at this time.", $notsubscription = false, $from = $vbulletin->options['bbtitle'], $uheaders = "From: " . $vbulletin->options['bbtitle'] . " Reminder Service <" . $vbulletin->options['webmasteremail'] . ">" . "\r\n", $username = ''); } else { log_cron_action("Emails sent to:$sentlist. We tried to email the following users, but their email address was invalid:$failedlist", $nextitem); vbmail($vbulletin->options['webmasteremail'], "Inactive User Reminder Email Report", "This email shows that the product is installed and working as it should be.\n\n\nEmails sent to:" . $sentlist . ". We tried to email the following users, but their email address was invalid:" . $failedlist . "", $notsubscription = false, $from = $vbulletin->options['bbtitle'], $uheaders = "From: " . $vbulletin->options['bbtitle'] . " Reminder Service <" . $vbulletin->options['webmasteremail'] . ">" . "\r\n", $username = ''); } } else { print("Product is inactive at this time!"); } ?>
Done



The script dosnt sent out any emails if i run it myself or let it run itsself.

[djbaxter]

You get all that? When? When you try to install it?

[brvheart]

When I run the cron job, that is what it shows...

And no emails are sent....

[brvheart]

fixed, well the jiberish cron page that I was getting, the email still has not sent to the test user even though it said it did

in reminderemail.php find (first line at top:

<?

Change to:

<?php

[djbaxter]

I'll be damned. Sharp eyes!

By the way, my apologies. I wasn't ignoring you - I didn't get a notification that you had replied to my last question. Strange, because I got the notification for your latest post. :confused:

[brvheart]

no worries :)

And it did send the email, jsut delayed, all works perfect now!!! Clicking installed :)

You might want to update the zip file ;)

[djbaxter]

Only Chris can do that but I'll add them as attachments here.

Additionally, if you use the great EZBounce add-on for invalid (bounced) emails, you will find the lines to add the EZBounce headers in the attached remindermail.php files, commented out and ready for uncommenting at lines 51-54:

// add EZBounce headers - uncomment the following if you use EZBounce
// $bounceurl = $vbulletin->options['ezb_admincpurl'] . "/ezbounce.php?u=" . $userid;
// $bouncestring = "<a href=\"$bounceurl\" target=\"_blank\">$bounceurl</a>";
// $headers .= 'X-EZbouncer: ' . $bouncestring . $delimiter;

Please note that I have uploaded the files for version 1.09 and 1.11. Before uploading these to your ./includes/cron/ folder, make sure you rename the file to simply remindermail.php for the version you have installed.

[popowich]

From: Discuss New York <"Discuss New York"@mail.wnypoker.com>,
Discuss New York Reminder Service <fake-for-this-post@discussny.com>
To: fake-for-this-post@discussny.com
Subject: Inactive User Reminder Email Report

Hello,

I am getting duplicate from: links. Other e-mails directly from my server are OK. I have two sites with this product and only one of them has this behavior. For the Discuss New York it puts the title of my site @ the name of the mail server (it's tagged to my first domain). It's not like I'm trying to reply, but I'd like to know where it is looking or if it's on my end how to fix this. I'm also wondering if they are going out to inactive members that way or if it's just my report.

-Raymond

[BadgerDog]

I'll be damned. Sharp eyes!


I'm a little confused.... :confused:


I'm running v1.09 without any problems on v3.6.7pl1 of vBulletin....

My reminder.php says this on top two lines:

<?
if (!is_object($vbulletin->db))

Should I be changing it to:

<?php
if (!is_object($vbulletin->db))

Thanks ... :)

Regards,
Badger

[goddess_dix]

I'm running v1.09 without any problems on v3.6.7pl1 of vBulletin....


if it works with the short php tags, don't worry about it. some php configurations will require the longer tags. evidently yours doesn't. it would also work with the longer tags, too, so if you move servers, you might need to change it.

[brvheart]

if it works with the short php tags, don't worry about it. some php configurations will require the longer tags. evidently yours doesn't. it would also work with the longer tags, too, so if you move servers, you might need to change it.

exactly, it is just safer to have the long ones, as it works under all configurations as stated above....my config just would not use the short version....

I should have explained that in the post above, sorry about that.

[induslady]

This is the unsupported updated version of Email reminder for inactive users add-on.
You need to uninstall previous versions (1.09 or 1.11) before installing version 1.20
Both product-remindermail.xml and remindermail.php has been updated.

Version 1.20 is updated and is the working and improved version of 1.11

Updates:
- Renamed emailDate field to reminderDate (user table) because it was too generic.
- Added reminderCount field (user table)
- Added limitperbatch option to limit number of emails sent to inactive users per batch (per cron run).
- Added limitperuser option to limit number of reminder emails sent to a user.
- Updated email message
- Pull only required data via SQL for better performance.
- This version ensures that updates to user table are done correctly, by updating only processed rows. Previous version was bulk updating user table before process started.

I am in the process of adding requested changes, will upload the finished product soon...

Hello vbuser99

Is the version 1.2 ready and available for download. If yes, where can I download it?
Thanks.

[mpoorrajab]

installed ...

it was a good hack ...

[djbaxter]

I am getting duplicate from: links. Other e-mails directly from my server are OK. I have two sites with this product and only one of them has this behavior. For the Discuss New York it puts the title of my site @ the name of the mail server (it's tagged to my first domain). It's not like I'm trying to reply, but I'd like to know where it is looking or if it's on my end how to fix this. I'm also wondering if they are going out to inactive members that way or if it's just my report.

Is that what you see in the visible part of the email or is that from "properties"?

I'm running v1.09 without any problems on v3.6.7pl1 of vBulletin.... My reminder.php says this on top two lines:

<?
if (!is_object($vbulletin->db))

Should I be changing it to:

<?php
if (!is_object($vbulletin->db))

if it works with the short php tags, don't worry about it. some php configurations will require the longer tags. evidently yours doesn't. it would also work with the longer tags, too, so if you move servers, you might need to change it.

exactly, it is just safer to have the long ones, as it works under all configurations as stated above....my config just would not use the short version....

Exactly. It was working fine on my server too with the short form but some server configurations may reject it. Chris hasn't been here in a while but I did email him the link to the post where it was pointed out for future releases. You can add the "php" part yourself safely even if it's working okay without it.

[Fungsten]

I haven't read through all the posts but I have this question. I just got the Inactive users report, email, however it went straight to my junkmail folder. Upon clicking on the sender I noticed that there was and extra user name in the from field that shouldn't be there. The email said it was also sent from one of my members. Is anyone else having this where the email report is maybe getting sent to the junk mail folder or there is another address in the From field in the email?

Thank you.

On Edit: I might be having the same problem as the person in the above post.

[kiFF]

I just installed this a couple days ago, and I just got an email report telling me that all of my inactive users had "invalid" email addresses. I looked up those member's email addresses, and they were fine, so why is it saying this?

[djbaxter]

1. are you using version 1.09 or 1.11?

2. how do you know those email addresses are valid or invalid? how are you checking them?

[kiFF]

1. I'm using 1.11.

2. Well the thing is, the report said that ALL of my inactive users had invalid email addresses, which is unlikely.

I was just checking by looking for spelling errors in the email suffixes. But they should be valid, they have to confirm their email to register.

[ozmazdaclub]

Excellent Mod! Installed.

[Domenico]

What about a link for users to opt-out ? When they click on this link they will never get this email reminder again. That would be nice because no there is no way to disable this and users are complaining.

[djbaxter]

What about a link for users to opt-out ? When they click on this link they will never get this email reminder again. That would be nice because no there is no way to disable this and users are complaining.

Sure there is - and it's built right into their vBulletin UserCP - the "Receive email from Admins" checkbox.

Add that link into the message that goes out to your users. I've included it since I first installed this add-on and a number of former users have followed those instructions to opt out. Some of those who don't have emailed me and asked me to do it for them and I always comply with that.


Admin CP | vBulletin Options | vBulletin Options | Inactive User Reminder Emails

Scroll down to and edit Email message

Add the link in there somewhere


My email message looks like this (some portions specific to my forum deleted):

Hello, $username!

<p>You are receiving this email because you previously registered at the {name of your forum} with the following information:</p>

<p>Member name: $username<br>
User number: $userid<br>
Email address: $email</p>

<p>It's been some time since your last visit to our forum community.</p>

<p>You might be interested in having another look. We have added several features and enhancements to the forums, and many new topics and new members are added every day.</p>

<p>If you don't remember your password, you can request it here: <a href="http://{yourforum.com}/login.php?do=lostpw">http://{yourforum.com}/login.php?do=lostpw</a>.</p>

<p>We hope to see you back soon.</p>

<p>If you do not wish to receive further emails of this nature, please log into your UserCP at <a href="http://{yourforum.com}/profile.php?do=editoptions">http://{yourforum.com}/profile.php?do=editoptions</a> and uncheck the box next to Receive Email from Administrators.</p>

[sparky5693]

1. I'm using 1.11.

2. Well the thing is, the report said that ALL of my inactive users had invalid email addresses, which is unlikely.

I was just checking by looking for spelling errors in the email suffixes. But they should be valid, they have to confirm their email to register.

This modification had worked fine for some time, now all my users have invalid email addresses. I have this same problem.

[Icy]

Use 1.09. That one works fine for me so far. I had a similar problem with 1.11. So uninstalled it & reinstalled 1.09.

[kiFF]

Well this is probably something that should be fixed.

[zahool]

hello i am using version 1.09 and for some reason using the Scheduled Task Manager's RUN NOW only three emails are being send out each time.

I tested again - another three emails.

anyone knows how to tackle this prob?

[0tolerance]

Well... im finding something weird.. i have more than 6 innactive users, some that have been innactive for months, but its not picking them up in the scan for innactive.
its only picking up recently innactive members... people that have been viewing the forum, but not posting...

there has to be about 30 or more innactives that should ahve been on the list.

[pyd]

Super add-on!
Installed it and it seems to be just what I need!

Just one request though!
In the field where you select witch usergroups that this should be valid to, how about a dropdown-list or something like that to select them?

Not that it's a big issue to go into the usergroup-manager and see the id:s, but... just a thought!

[testebr]

I have a big problem with this mod.

My host reject all emails sent returning with this message:

Recipient address rejected: Policy Rejection:
--SENDER_QUOTA_REJECTION-- (in reply to RCPT TO command)

Can you please add one option to send xx emails per hour controled by cron job.

Example, in last time the mod tried to send 8k of emails at once only.

See: Cron Based E-Mail Sending (https://vborg.vbsupport.ru/showthread.php?t=133844)

Thank you.

[djbaxter]

hello i am using version 1.09 and for some reason using the Scheduled Task Manager's RUN NOW only three emails are being send out each time.

I tested again - another three emails.

anyone knows how to tackle this prob?

That's exactly what it's supposed to do - it limits the number of emails being sent out to avoid triggering your host's limits.

You can change it from 3 to another number if you wish in the vBulletin Options in your Admin CP, but keep it low.

I have a big problem with this mod.

My host reject all emails sent returning with this message:

Can you please add one option to send xx emails per hour controled by cron job.

Example, in last time the mod tried to send 8k of emails at once only.

See: Cron Based E-Mail Sending (https://vborg.vbsupport.ru/showthread.php?t=133844)

Thank you.

1. I think you're using version 1.11. Uninstall that and install version 1.09. If you're already using the Cron Based E-Mail Sending add-on, try disabling it.

[Millenium IT]

To be quite honest, I didnt think that this mod would, at all, have an effect, whatsoever. I would like to congradulate you on an epic release, and you can quote me saying that this really works. My forum was in a downwards spirl, but this mod brought everything back to life. My 'Users Online Today' went from 45+ all the way up to 75+ in one day!

[kiFF]

Should it be sending you an email report even if there are no inactive members? Because I unistalled 1.11 (because it kept saying my members' emails were invalid) and installed 1.09, and I haven't gotten an email report in a couple weeks...I don't think the emails are being sent.

[djbaxter]

Should it be sending you an email report even if there are no inactive members? Because I unistalled 1.11 (because it kept saying my members' emails were invalid) and installed 1.09, and I haven't gotten an email report in a couple weeks...I don't think the emails are being sent.


No. With 1.09, the only emails I get are occasionally from bounced/invalid email addresses. Otherwise, I don't get anything.

I do have a couple of extra "test" accounts, though, and I do get reminders for those sent to the appropriate email address, since they are rarely used.

[kiFF]

Okay, I checked the scheduled tasks log and it has been sending them out. Thanks.

[Alfa1]

When composing such mass emails, please review the anti spam policies of hotmail, yahoo, gmail, AOL, etc.

[sparky5693]

I downgraded to .09, and everything is fine again.

[baghdad4ever]

ok im confuse

which version may i install now??

plz help

[djbaxter]

I recommend you use version 1.09.

[testebr]

I will install the old version, but its better you update the mod.

[Andy Dean]

Hi, thanks for a top mod!

One question tho, i've installed 1.09 and everything is running as expected e-mails going out no problem, however the scheduled 'Inactive User Reminder Emails' task runs very randomly, some times as much as ten times in ten minutes, some times not for five hours. What triggers this task to run as m h D M DoW inthe Scheduled Task Manager are all "*" ?

Is this the way it's supposed to run? or should i be setting a time for the task to run in the Scheduled Task Manager?

Many Thanks!

[djbaxter]

Because of the way vBulletin handles cron jobs, the extact times that any cron job runs will vary (since it requires a page load to trigger the cron job).

Check how it's scheduled currently in "Scheduled Tasks". I have mine set to run as follows:

Day of the Month *
Hour *
Minute 37

i.e., every hour, every day of the month, at HH:37. I also have the number of emails sent out at a time set low (3), although for an initial run through the database I had it set a bit higher (I think 10).

That seems to work well for me.

[Andy Dean]

Ahhh, i think i'm with you, it's currently not scheduled in Scheduled Task Manager, all the fields are asterisks (*), that's how it was after i installed it. Does this mean the cron job is running everytime a page is loaded? It'd would be wise to set it up like you have yourself then?

[djbaxter]

Ahhh, i think i'm with you, it's currently not scheduled in Scheduled Task Manager, all the fields are asterisks (*), that's how it was after i installed it. Does this mean the cron job is running everytime a page is loaded? It'd would be wise to set it up like you have yourself then?

Yes. As it is now, your task runs every minute of every hour of every day - that's way too frequently.

[Andy Dean]

Yes. As it is now, your task runs every minute of every hour of every day - that's way too frequently.

Ahha! Thank you very much for the help! I wondered why it was running so randomly. I've set it to run once a day, that should be fine for a small forum like mine.

Thanks again :)

[Jdm Ej1 Coupe]

Ok I installed this Mod a while ago and have updated it as it comes out! It is working and the only problem I am having is that the emails are being sent from unknownsender@unknowndomain. because of this I do believe it is going into peoples spam folders and or getting deleted and I am not having the effect of the users coming back to the site like everyone else.

is there anyway for me to change from what email it gets sent from?

Thanks for a great product!

[djbaxter]

It uses whatever address it finds in Admin CP | vBulletin Options | vBulletin Options | Site Name / URL / Contact Details.

Scroll down to:

Webmaster's Email
Email address of the webmaster.

and check that you have a valid email address in there.

[frostyIntrepid]

I do have the same problem and checked the settings.

All the fields are filled up properly.

[Jdm Ej1 Coupe]

It uses whatever address it finds in Admin CP | vBulletin Options | vBulletin Options | Site Name / URL / Contact Details.

Scroll down to:



and check that you have a valid email address in there.

I checked it and my address is valid there. still having the same issue.

Thanks

[djbaxter]

It is working and the only problem I am having is that the emails are being sent from unknownsender@unknowndomain

Where and when do you see that email address? Is this only seen on returned/bounced emails?

[Jdm Ej1 Coupe]

Where and when do you see that email address? Is this only seen on returned/bounced emails?

I created a username for this mod and it goes to one of my emails

Thanks