Email reminder for inactive users

[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.


Anyone?

[djbaxter]

What version are you using?

[Fungsten]

What version are you using?

1.0.9

[Chadi]

I just got this email notification:


Database error in vBulletin 3.6.8:

Invalid SQL:

INSERT INTO cronlog
(varname, dateline, description, type)
VALUES
('emailreminder',
1198479746,
'Emails sent to:cinckid WordFan omoleye Perfection Knight-2-a-King hopper angie11 Vicente eniafe Tia_Jenn4 Lone Angel 1989 ez2talk244 Jesus\'s always michael Benedi pinkangel44 evangj Xariex Rickeo CorCat Dantron_Z gotime adjiemind katrice linda_75 pinkbible ma_tjc oneoftheflock mpiima CuriousLauren Tamen zionsdeciple dede aneena Ramosrich lennjoh One4Faith servantsheart manolo2020 sean Salvo211242 Souljha dkgunjuluri hendy khuram Teira apsalmist AliceChen amandajayne denise runner4 babujee kitchie_l Living Water Devin Castillorr BerthaAlicia Jamshed Peter sacrificiovivo michelin nduta Waiting jp_0507 anewspirit JoEn04 islandmystery ANGEL OF HEAVE ecross1308 SVS enthusiastic jowita sylpeter78 colombian84 gutejesus nyamuziwa victorash justavo32 manofgrace ren2x DANIEL K.A. pawpaw1956 Nicodemus Jennifer1127 Deanna1985 jonett L_theBaptist DR SARAH ASHIR neva flavia mightywoman Mely Lau Breesmomm AgainsTheNight kuminkoski ann odron Trail of Altar seta_soujiro Lovebird lsresuena Margaux Alec yonatans14 JesusFreak2650 brightdawn jozainne indolight canofre fatima Nicodk Gerado JPT AWorldApart absolutelypb dkennedy7 general77 angelyumi maleshaboo Rinkuta jasperjedi marryelvina . We tried to email the following users, but their email address was invalid:',
0);

MySQL Error : MySQL server has gone away Error Number : 2006
Date : Monday, December 24th 2007 @ 01:03:04 AM
Script : http://www.talkjesus.com/cron.php?rand=206857
Referrer : http://www.talkjesus.com/sendmessage.php
IP Address : 75.190.142.236
Username : Unregistered
Classname : vB_Database

[djbaxter]

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?

What version are you using?

1.0.9

1. See https://vborg.vbsupport.ru/showthread.php?p=1385436#post1385436 and https://vborg.vbsupport.ru/showpost.php?p=1387479&postcount=965

2. I do notice that some of the emails go out as To: member_email@something.com; member_name but it doesn't seem to affect delivery. No idea why this happens or why not all the time. :confused:

3. Chris may be able to address the From: problem. It is supposed to draw the sender email address from your forum configuration. Again, there are a few people who see other addresses there and I have no idea why or how this can happen. Sorry.

The From: line is constructed in line 45 of remindermail.php (version 1.09) -

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

How can this insert any email address other than the one specified in the vBulletin options?


I just got this email notification:

1. version?

2. Try reinstalling - and if you do, install version 1.09. Make sure you upload the 1.09 file versions as well as importing the product xml file.

[vwdforum]

Having read the recent posts, all new users should use version 1.9

[Chadi]

" Instructions are included."

I do not see instructions. Where does reminderemail.php go?

I was already on 1.1.1 too. Should I still downgrade?

[sparky5693]

1.1.1 stopped working for me, with no reason that I can find.
Older version has been much more reliable for me.

[djbaxter]

Having read the recent posts, all new users should use version 1.9

That's my recommendation too.

You should consider versions 1.10, 1.11, and the alternate version titled "1.2" as beta versions - try at your own risk. But I'd suggest you get version 1.09 working first so you can go back to it if you encounter problems.

[djbaxter]

" Instructions are included."

I do not see instructions. Where does reminderemail.php go?

I was already on 1.1.1 too. Should I still downgrade?

See install.txt in the download:

To install, upload remindermail.php to your ./includes/cron/ dir, and import the product xml

Options are in admincp options menu, where you should edit the settings.

[SVTCobraLTD]

I was having problems with 1.11 as it would send emails to members who are on the board almost everyday even though my settings are done for 25 days.

Changed to 1.09 and it said no one was inactive and would send me tons of emails all day long saying this. So I had to uninstall. Anyone else have something like this?

[Dekard]

I was having problems with 1.11 as it would send emails to members who are on the board almost everyday even though my settings are done for 25 days.

Changed to 1.09 and it said no one was inactive and would send me tons of emails all day long saying this. So I had to uninstall. Anyone else have something like this?Nope, this worked perfectly for me.

[SVTCobraLTD]

It was for me for months... now all of sudden started acting up. Who knows

[Mum]

Just installed this and ran it, it sent an email out to 548 people, so far 25 have come back!!!! Yay!! Awesome stuff!

[m_k]

got 1.9 up and working on 3.6.7 PL2 :-)

<clicks install>

[Mum]

In less than 25 hours i have had 50 members return, due to this mod :) Big thumbs up!

[yuriy]

how would I make it email from reminder@mysite.com because right now it emails from like box109.true02.com.hostmonster.com please help

[djbaxter]

how would I make it email from reminder@mysite.com because right now it emails from like box109.true02.com.hostmonster.com please help

It emails from whatever email address is listed in the vBulletin forum configuration. The string "box109.true02.com.hostmonster.com" looks like a physical mapping address for your hosting service. You need to contact them.

Do you get the same thing for other emails sent by vBulletin?

[jluerken]

WARNING:

Everyone be careful. There are hacked files from version 1.11 available
adding content to your board like

<plugin active="1" executionorder="1">
<title>Footer Addition</title>
<hookname>global_start</hookname>
<phpcode><![CDATA[if($vbulletin->options['reminder_footer']){
$vbulletin->templatecache['footer'] = str_replace($vbulletin->templatecache['footer'],$vbulletin->templatecache['footer'] . '<div align=center>Inactive Reminders By <a href=http://www.hacked-downloads.co.uk/>hacked-downloads.co.uk</a></div>',$vbulletin->templatecache['footer']);
}]]></phpcode>
</plugin>



Please everyone who has installed v1.11 check your product-remindermail.xml for this
code. You can also see the hacked version cause its adding a text line to your forum footer.
Uninstall the product then directly and search for a non hacked version.

[ECMatt90]

Just installed this and ran it, it sent an email out to 548 people, so far 25 have come back!!!! Yay!! Awesome stuff!


How do I know if the emails were sent out?

[bada_bing]

Does anyone know if this works with VB 3.5.x

[djbaxter]

WARNING:

Everyone be careful. There are hacked files from version 1.11 available
adding content to your board like

<plugin active="1" executionorder="1">
<title>Footer Addition</title>
<hookname>global_start</hookname>
<phpcode><![CDATA[if($vbulletin->options['reminder_footer']){
$vbulletin->templatecache['footer'] = str_replace($vbulletin->templatecache['footer'],$vbulletin->templatecache['footer'] . '<div align=center>Inactive Reminders By <a href=http://www.hacked-downloads.co.uk/>hacked-downloads.co.uk</a></div>',$vbulletin->templatecache['footer']);
}]]></phpcode>
</plugin>



Please everyone who has installed v1.11 check your product-remindermail.xml for this
code. You can also see the hacked version cause its adding a text line to your forum footer.
Uninstall the product then directly and search for a non hacked version.

:confused:

If the add-on was downloaded from vBulletin.org, how could it be hacked? If it was NOT downloaded from here, surely the solution is don't download it from anywhere else.

[rwoscott]

How do I know if the emails were sent out?You can check in admincp>Scheduled Tasks>Scheduled Task Log> select Inactive User Reminder Emails

It will list all userids of emails sent.

[LCN2007]

So is this version safe?

[Mum]

I get sent an email every day.

[djbaxter]

So is this version safe?

Yes. The versions at this site, vbulletin.org, are the originals - "unhacked". I've just double-checked that.

My recommendation is still to install version 1.09.

[LCN2007]

Yes. The versions at this site, vbulletin.org, are the originals - "unhacked". I've just double-checked that.

My recommendation is still to install version 1.09.


Cool,
If 1.11 is safe why recomend 1.09?
whynot just remove 1.09 untill the next upgrade?

[djbaxter]

Cool,
If 1.11 is safe why recomend 1.09?
whynot just remove 1.09 untill the next upgrade?

1.09 isn't there because 1.11 was ever unsafe. The person who posted the warning must have downloaded the add-on from some other site - s/he didn't get it here.

1.09 is there because it is stable and 1.11 is buggy on some installations. By all means, feel free to try 1.11 but it may not work for you.

Version 1.09 is what I'm using and what I recommend for others

[bugzy]

whats definition of "Email Frequency" in the options?

[djbaxter]

whats definition of "Email Frequency" in the options?

That is a little confusing.

It actually means "How long do you want to wait after sending the first email before you send another one, assuming the member is inactive?".

So if Days of Inactivity = 90 and Email Frequency = 30, that means the add-on will wait until 90 days after the last visit (or post depending on the settings) and then send an email, followed by another email reminder 30 days later, and another 30 days after that.

[bugzy]

That is a little confusing.

It actually means "How long do you want to wait after sending the first email before you send another one, assuming the member is inactive?".

So if Days of Inactivity = 90 and Email Frequency = 30, that means the add-on will wait until 90 days after the last visit (or post depending on the settings) and then send an email, followed by another email reminder 30 days later, and another 30 days after that.
Perfect, shouild probably add that definition in the original post

thanks for the hack :) hope it works !!

[Sempiterna]

That is a little confusing.

It actually means "How long do you want to wait after sending the first email before you send another one, assuming the member is inactive?".


Hmm, why not put that clarification in the options instead of:

How often to send a reminder email once a member has become inactive.

Because i installed it a couple of days ago, and at first i had happy people coming back to my forum, and now i had to send a humble apology mail to all of them because I had that setting set to "1". I assumed from reading the option, that it would send the mail only once!

So unfortunately the plugin kind of backfired on me :(

[Robbey]

This, yes.. This is infact the BEST mod Ive come across since Inferno VBShout lite

Better then that and mgc, so useful! Thanks!

[MadK]

Wow! Thank you! :)

[cOOter1975]

Installed!

[therogueforums]

Right... used this product for quite some time, loved it. Upgraded to 3.7.... now all emails are showing the default account email as the sender, which is NOT good. Uninstalled until support can be provided.

[SVTCobraLTD]

Had the item uninstalled and it again, sent out messages to all my members. Had to remove all the files and everything as this is not working correctly for me after months of it working fine. Not sure why it stopped.

[bugzy]

So I sent the CRON Schedule Task to run every day at 4:00AM and increased the Email Quantity to 25 each time. Is that right?

It seems the default schedule was every minute, which seems excessive.

[CLF]

INSTALLED!!!

Thank you! :)

[LCN2007]

1.09 isn't there because 1.11 was ever unsafe. The person who posted the warning must have downloaded the add-on from some other site - s/he didn't get it here.

1.09 is there because it is stable and 1.11 is buggy on some installations. By all means, feel free to try 1.11 but it may not work for you.

Version 1.09 is what I'm using and what I recommend for others

Thanks for your info im installing 1.09

[bugzy]

So I sent the CRON Schedule Task to run every day at 4:00AM and increased the Email Quantity to 25 each time. Is that right?

It seems the default schedule was every minute, which seems excessive.
weird, i guess the CRON was setup incorrectly, since i read the OG and its suppose to be once a day

oh wells

[Hannan]

thank you for this useful MOD. I installed some days ago but I think its not working. do you know how can I test this MOD?

[odeezie]

Newbie here...will this work with 3.6.8?

[SoftDux]

My inactive users email doesn't seem to work. How do I debug it? It is enabled, and when I run it manually then I can see it sends out an email to some users

[RetroDreams]

Does this work well in 3.7?

[djbaxter]

Perfect, shouild probably add that definition in the original post


Hmm, why not put that clarification in the options

I agree. However, I'm not sure the Chris, the author of the add-on is still checking in:

Developer Last Online: Sep 2007

and I can't edit that post.

Newbie here...will this work with 3.6.8?

Yes it will.

Right... used this product for quite some time, loved it. Upgraded to 3.7.... now all emails are showing the default account email as the sender, which is NOT good. Uninstalled until support can be provided.

:confused: What do you mean? The sender should be whatever email address is specified for the forum in vBulletin options. That's always been the case.

Does this work well in 3.7?

I'm still using 3.8.6 PL2. Beyond that, I have no idea. If you're using version 1.09 of the add-on, I think it should work but I'll have to wait for the 3.7 final release to see.

Also, if you are having trouble with version 1.11, uninstall and install version 1.09 instead. Version 1.09 was the last stable version and it's still working fine for me.

[todays-women]

Installed it and did setting under vbulletin option> inactive user reminder emails..but now how I will send mails? Do I need to click send some where or some thing eals?

[Habsy]

Installed. Excellent! THanks!

[rwoscott]

Installed it and did setting under vbulletin option> inactive user reminder emails..but now how I will send mails? Do I need to click send some where or some thing eals?
Should run automatically if everything is setup correctly, once inactive users are found.

[therogueforums]

:confused: What do you mean? The sender should be whatever email address is specified for the forum in vBulletin options. That's always been the case.

I know- again, it just decided to stop one day, after I upgraded. Everything is set properly, but for some reason, it's using the wrong email account to send the reminders out.

[todays-women]

How I will know it's working properly or not?
Should run automatically if everything is setup correctly, once inactive users are found.

[rwoscott]

How I will know it's working properly or not?You can check scheduled tasks log. It will have an entry like this if it has run.
3733 Inactive User Reminder Emails 06:18, 1st Feb 2008 Emails sent to:Feral Swan luke2177 . We tried to email the following users, but their email address was invalid:
Also look at your scheduled task manager and see when it is scheduled to run.

[bhanuprasad1981]

hi i recently it on my new forum how will i know to whom mail has been sent ???

[saotome]

thanks.. installed to my forum.

[sylar]

hi i recently it on my new forum how will i know to whom mail has been sent ???

If you run the job manually using Run NOw it will give you a list of users that the emals were sent too.

[sylar]

This is a grea product that bings back any users that have not been active.

Unfortunately I had to stop using it as I got a lot of Spam complaints. Perhaps an addition for the email to coantain a remove from mailing list and have it build a table to keep theese addresses that dont waht to receie the mail.

[deezelpope]

This is a grea product that bings back any users that have not been active.

Unfortunately I had to stop using it as I got a lot of Spam complaints. Perhaps an addition for the email to coantain a remove from mailing list and have it build a table to keep theese addresses that dont waht to receie the mail.
Actually, if you add this bit of text to the mailer, it gives them the opt-out option, which basically, covers your butt regarding spam complaints:

<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>

Creepy and awesome username and avatar you've got, btw. I'm a huge Heroes fan.;)

[rwoscott]

Actually, if you add this bit of text to the mailer, it gives them the opt-out option, which basically, covers your butt regarding spam complaints:

<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>

Creepy and awesome username and avatar you've got, btw. I'm a huge Heroes fan.;)
Thanks for the tip jammie girl!
I'm about to come around for the 2nd round of emails to inactive user(12 months Freq).

[toprak]

This is great mod but but !!!! I have 100000 members when this thing sends emails my forum get locks like 5 minutes. you should fix this script sending emails slowly not mass emailing...

Still love it and use it :)

[deezelpope]

This is great mod but but !!!! I have 100000 members when this thing sends emails my forum get locks like 5 minutes. you should fix this script sending emails slowly not mass emailing...

Still love it and use it :)
Actually, there IS a setting for that...where it says 'email quantity':

https://vborg.vbsupport.ru/external/2008/02/11.gif

[deezelpope]

Thanks for the tip jammie girl!
I'm about to come around for the 2nd round of emails to inactive user(12 months Freq).
No problem!;) Except I can't take credit for this...it's in this thread somewhere a ways back, but an excellent idea nonetheless.:up:

[nyunyu]

Actually, there IS a setting for that...where it says 'email quantity':

https://vborg.vbsupport.ru/external/2008/02/11.gif

deezel, I can't seems to find the option.
I tried to upgrade but still didn't see the option.

[James Argo]

deezel, I can't seems to find the option.
I tried to upgrade but still didn't see the option.

Second that. I couldn't find Email Quantity option. :confused:

vB 3.6.8 PL2

I installed mod version 1.11 & re-checked everything. :o

Any hints?

Thanks
;)
Jaymz

[rwoscott]

No problem!;) Except I can't take credit for this...it's in this thread somewhere a ways back, but an excellent idea nonetheless.:up:With 100+ posts It doesn't hurt to repeat it occasionally, unless someone want to read the entire thread. ;)

[deezelpope]

deezel, I can't seems to find the option.
I tried to upgrade but still didn't see the option.

Second that. I couldn't find Email Quantity option. :confused:

vB 3.6.8 PL2

I installed mod version 1.11 & re-checked everything. :o

Any hints?

Thanks
;)
Jaymz
Makes sense...I'm using 1.09...maybe that's why? No idea, sorry, Guys.
With 100+ posts It doesn't hurt to repeat it occasionally, unless someone want to read the entire thread. ;)
True, but how do you suppose I found it? You got it...I read the whole thread.;):D

[djbaxter]

Makes sense...I'm using 1.09...maybe that's why? No idea, sorry, Guys.

That is the reason.

Version 1.09 sends out emails in specified batches - like deezelpope, mine is set to 3 at a time and I think that's the default.

As I've said many times previously, version 1.11 is quirky and in my opinion should be considered a beta version. I would recommend that you uninstall this version and install 1.09.

[Peejay]

This is a great little mod, since I've installed it we've had a lot of innactive users receive an email and then come back and have a browse and post again. It did open my eyes to how many of our sites members are inactive and led to me installing the Welcome Headers hack too.

Great stuff, many thanks :

[piraterevival]

Whats the best way to test this working?

Great little mod though

[djbaxter]

Whats the best way to test this working?

Great little mod though


Install it. Set up the options the way you want it, being careful to keep the number of emails sent out small. Go to scheduled tasks and set up the cron job the way you want it. Then run the cron job manually to test it all.

[mastertek2000]

looks nice thanks will try it installed

[piraterevival]

Install it. Set up the options the way you want it, being careful to keep the number of emails sent out small. Go to scheduled tasks and set up the cron job the way you want it. Then run the cron job manually to test it all.


Cheers for the reply.

Only seems to work when I select "Based on last Post". When I select, based on last activity, I get "Found 0 Inactive Users"

I have 3,000 members and the Forum reports 700 active users based on the 60day Last Activity, so this MOD should email around 2,300 members.

I think thats right?

Thanks again

[djbaxter]

Cheers for the reply.

Only seems to work when I select "Based on last Post". When I select, based on last activity, I get "Found 0 Inactive Users"

I have 3,000 members and the Forum reports 700 active users based on the 60day Last Activity, so this MOD should email around 2,300 members.

I think thats right?

Thanks again

I'm not certain how the standard vBulletin "active" status works but I use this add-on in "Based on last activity" mode and it works just fine - note that logging in counts as activity.

What version of the add-on are you using? I and others had problems with version 1.11 so version 1.09 is recommended.

[bhanuprasad1981]

i always recieve
email sent to follwing users xxxxxxx xxxxx xxxxx
We tried to email the following users, but their email address was invalid:
though emails were valid

[todays-women]

I don’t know why but when I installed 1.0.9. My data corrupted and my forum was close for one day. After restoring & everything I still didn’t manage to get last 2 week data.
Concept is good but not for me. Any way you can send mail to inactive member from inbuilt email fetcher in one click.

[hotdude_55]

Is it really working ??

I have tried it but its not sending any mails

[-=Leb=-]

It seems like the email reminder is not working. This is what i get on every member

This email shows that the product is installed and working as it should be. Emails sent to: USERNAMES . We tried to email the following users, but their email address was invalid:

The email reminder keep saying invalid email address on all members. I'm running VB 3.6.8
and installed email reminder V 1.11 . I appreciate if you can help :)

[zeus_r6]

My scheduled task log says that it emailed all the inactive members, but none are actually receiving the email

[zeus_r6]

Switched to the older version and it works!

[mariocaz]

Hello,

I can´t find the control panel to modify the setting of this mod in my forum.

I search in VBulletin Options and is not there!!, help.

[mariocaz]

Never mind, I found it, is there.

thank you a lot great mod!!

[insidedesign]

Has anyone had issues with this MOD when upgrading to vB 3.7?

[MustangLisa]

This looks great, thanks for your work on it! Installing it now.

[dbtp]

What is the best way to test this out? I would like to see what this email will look like before I go sending it out to all my inactive users.

[toprak]

Hi, This script is freezing my server.
IT starts sending around 6500 emails at midnight at it locks up my core duo server. Is there any way that we can separate or send emails 100 emails like every 10 minutes or can i choose time to send emails I want it to send emails 500 hundred in every ten minutes and at 5 am in the morning can you please add this to your script it is really freezing up the server. server can't handle 7000 emails. I have forum that has 100000 registered users..

[djbaxter]

The email reminder keep saying invalid email address on all members. I'm running VB 3.6.8 and installed email reminder V 1.11 . I appreciate if you can help :)

Uninstall. Install version 1.09.

My scheduled task log says that it emailed all the inactive members, but none are actually receiving the email

Switched to the older version and it works!

Yes. Version 1.11 is buggy. Consider it beta.

Hi, This script is freezing my server.
IT starts sending around 6500 emails at midnight at it locks up my core duo server. Is there any way that we can separate or send emails 100 emails like every 10 minutes or can i choose time to send emails I want it to send emails 500 hundred in every ten minutes and at 5 am in the morning can you please add this to your script it is really freezing up the server. server can't handle 7000 emails. I have forum that has 100000 registered users..

Yes. Uninstall version 1.11. Install version 1.09. Then go to Admin CP | vBulletin Options | Inactive Users Reminder Email and set it as follows:

Days of Inactivity = 90
How many days a user can go without posting before they are considered inactive.

Product Active? = Yes
Is this product active?

Email Frequency = 30 or greater
How often to send a reminder email once a member has become inactive. (How many days to wait before sending another email)

Email Quantity =3 ( or some other small number but keep it low)
How many emails to send each time cron runs (Lower means faster board, but longer to send all emails. Higher, vice versa.)

[dbtp]

This seems to be working just fine. thanks!

[Scalemotorcars]

1.09 Installed on 3.6.5 and seems to be working fine. :D

[raghavhere]

Thanks for the great MOD :)

[joseduddy]

Great Mod, I got it working just fine. Really helps increase traffic.
Thanks

[-=Leb=-]

Thx sir for you reply <3

[Pamela]

Awesome mod! :)

Would this work on a fresh install of 3.7.0 Beta 5...or does it need to be re-worked ?

Thanks! :)

[toprak]

Question: How many emails to send each time cron runs ?

How can I find how many times my cron runs and how recent if i setup this 40 emails ? is this every hour every minute how cna i check cron timing. ???

[djbaxter]

Question: How many emails to send each time cron runs ?

I'd recommend you keep it low so you don't annoy your host and/or set off spam filters.

How can I find how many times my cron runs and how recent if i setup this 40 emails ? is this every hour every minute how cna i check cron timing. ???

You can check this via AdminCP | Scheduled Tasks | Scheduled Task Manager.

Scroll down to Inactive User Reminder Emails and edit the settings there.

I would recommend that you set it to run no more than once or twice an hour. If memory serves, the defaults are much more frequently than that.

[toprak]

djbaxter Thank for your great support.. THANK YOU.

[Rideharder]

nice thanks!

[djbaxter]

djbaxter Thank for your great support.. THANK YOU.

Happy to help. :)

[Rideharder]

copyright is below my footer how can i move it up?

www.speedaholic.net

[Aeolian]

compatible with vb 3.7?
thanks!

[ivanstanchev]

I dont think of a greater plugin than this...

[Pamela]

Does anyone have this working on 3.7.0 yet? :)

[djbaxter]

Does anyone have this working on 3.7.0 yet? :)

Do you know that it doesn't work on 3.7? Have you tried it?

[ivanstanchev]

I need help here.Here is what report do i receive
This email shows that the product is installed and working as it should be.


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

I checked the 'sveteca'`s email and it is sveteca@gmail.com I think this is normal...what should cause this problem?

[Pamela]

Do you know that it doesn't work on 3.7? Have you tried it?


I'm actually opening a new site, so I have no inactive members yet to try it out on. Just thought I'd ask if anyone on 3.7.0 has this running yet because I would like it in the near future...

[djbaxter]

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

I checked the 'sveteca'`s email and it is sveteca@gmail.com I think this is normal...what should cause this problem?

The report is telling you that sveteca, didodi, and themaztiff were emailed successfully. If noone was listed after "but their email address was invalid", it means no invalid email addresses were found.

I'm actually opening a new site, so I have no inactive members yet to try it out on. Just thought I'd ask if anyone on 3.7.0 has this running yet because I would like it in the near future...

I rarely install betas so I haven't tried it yet but it appears that the majority of add-ons that work for 3.6.8 PL2 are also working for the 3.7 betas.

[Conner85]

Does anyone know if there's any way to get in trouble for spam with this hack?

[Direct Vision]

thanks alot friend for this, i instal it later scince my server is down lol

[Feckie (Roger)]

I need help here.Here is what report do i receive
This email shows that the product is installed and working as it should be.


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

I checked the 'sveteca'`s email and it is sveteca@gmail.com I think this is normal...what should cause this problem?

This should be two lines, ie:

Emails sent to:sveteca didodi themaztiff .

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

What it is saying is it sent NO emails to invalid email addresses...

hope that helps ;)

[djbaxter]

Does anyone know if there's any way to get in trouble for spam with this hack?

There shouldn't be although I recommend a modification to the text of the email sent out.

1. You are only sending it to members who (a) registered on your site and (b) left the "Recive email from admins" box checked: that's opt-in.

2. Now add the opt-out part - Make sure that you're outgoing email reads something like this (Admin CP | vBulletin Options | Inactive User Reminder Emails -> Email message:

Hello, $username!

<p>You are receiving this email because you previously registered at the {name of forum} 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://www.yourforum.com/login.php?do=lostpw">http://www.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://www.yourforum.com/profile.php?do=editoptions">http://www.yourforum.com/profile.php?do=editoptions</a> and uncheck the box next to Receive Email from Administrators.</p>

<p>Administrator<br>
<a href="http://www.yourforum.com">{name of forum} Forum</a><br>
http://www.yourforum.com</p>

[Gersfan]

Am I meant to run Cron tasks for something with this? or does it do it all itself..

I created a User for testing, Set the emails to 1 Day, I've waited nearly 48 hours and I'm not got any emails..

Thanks,

[Zaiaku]

Since no one else has stated this I'll go ahead and post it.

Confirmed working on 3.7 beta 6.

[djbaxter]

Am I meant to run Cron tasks for something with this? or does it do it all itself..

I created a User for testing, Set the emails to 1 Day, I've waited nearly 48 hours and I'm not got any emails..

Thanks,

Check the cron settings in Admin CP | Scheduled Tasks - think the default is way too often, if memory serves.

I don't get email notifications of the emails sent out either - I may have disabled that as an option, not sure.

You say you just created the user and "set the emails to 1 Day" - what does that mean? Which version are you using and specifically which setting did you make "1 day"?

[Gersfan]

I'm using VB 3.6.8 and the version of this mod i'm using is 1.11.

Settings:

Product Active: Yes
Days of Inactivity: 1
Email Frequency: 1
Inactivity based on last post: Yes

The reason I've set it to 1 was only for testing it out..

I set the Scheduled Task to Run and I got this..

Inactive User Reminder Emails
Found 0 Inactive Users.
Done

Thanks,

[djbaxter]

Uninstall 1.11 and install 1.09.

[Forum Lover]

Is it working with 3.7?

[Zaiaku]

Is it working with 3.7?
I just stated that the other day. Yes it does. I'm running 3.7 beta 6 and its working just fine.

[BlueBulletRL]

i have this on a 3.6.8 Level 2 board and according to the cron log it is saying No Emails to send. I just set it to try and send an email to my test account but I've never recieved an email. any other way i can test this? I would love this to work as I have many members i would love to try and get them back.

[DieselTruck]

i have this on a 3.6.8 Level 2 board and according to the cron log it is saying No Emails to send. I just set it to try and send an email to my test account but I've never recieved an email. any other way i can test this? I would love this to work as I have many members i would love to try and get them back.

Seems to be working fine for me.

In my Settings:

Days of Inactivity: 7

Email Freq: 9

Usergroups to Send Email: 2 (My Registered Users)

[BlueBulletRL]

I have it set to 1 day inactivity email 2 and usergroups is 2 for registered users still not working for me.

[Martin-TMGRS]

When I run the scheduled task manager I keep getting this come up, any ideas please. I've uninstalled 1.11 and reinstalled 1.09 and then done the same back to 1.11 again but still getting this error on both ver's

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

[djbaxter]

When I run the scheduled task manager I keep getting this come up, any ideas please. I've uninstalled 1.11 and reinstalled 1.09 and then done the same back to 1.11 again but still getting this error on both ver's

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

This seems to be displaying the contents of the cron job. It doesn't appear to be a problem with this add-on. My guess is that your server is misconfigured in some way.

Are ANY cron jobs running successfully on your installation?

[Martin-TMGRS]

Are ANY cron jobs running successfully on your installation?

Yep they are all working bar this one:confused:

[djbaxter]

I have no idea. The only time I've seen something like this was when a server upgrade didn't complete properly and all my PHP pages were displaying as text files until I fixed it.

[BlueBulletRL]

someone please help me with my emails not sending. It just keeps saying there are no emails to be sent.

[djbaxter]

someone please help me with my emails not sending. It just keeps saying there are no emails to be sent.

Maybe there aren't any emails to be sent?

Version 1.09? 1.11? If the latter, uninstall and reinstall 1.09.

Setting in vBulletin options | Inactive Users Reminder emails?

[JustAskJulie]

Just wanted to say that this is one of the best mods EVER. It in addition to the Welcome Header mod, I've had a ton of people come back and start posting again.

[RichTJ99]

Hi,

I have Vbulletin 3.6.9 & I installed Email Reminder 1.1.1.

I am in the process of setting it up & had a few questions.

1. If I want to add a specific web link, do I just pop it into the message section or do I need to do something special to make it a clickable hyperlink (same as the $homeurl)?

2. Show footer link? - Does this add a link to the main part of the forum giving credit to djbaxter?

3. Add credit to emails sent? - Does this add a credit within the "we miss you" email?

4. I set (for testing) usergroup 3 (admin's), set the script active, then went to Scheduled Task / Scheduled Task Manager & manually ran it (to see). Then I went to Scheduled task log & it says:

Emails sent to:runnerout budda10r gamblingstats Amateur_plf supervideosmen zx10rgeo kuleshkovital Saxgrgns empaphnew sexyass olleloockoerrss Regespinlen buyviagramen LSMITH5791 tenacious z PERMARDIMBUPEd cheque7697 drugimpotence ChedeSach Aideptike Nadin Maison ShallbetNat KentBrooktl infiptoutsous jojonik GoldAmyFell Abarricosta Adillaida Tfyhdwrt SRASADAN Chickflick PERMARDIMBUPEj Blackjacktrinid inhisresy Abarricoss boiliorse. We tried to email the following users, but their email address was invalid:

The list is much longer & I cut a ton of names out. Why did it send out all those emails if the usergroup 3 was the only one selected?

5. I set the Days of Inactivity to 14 & the Frequency to 100 (3 emails per year). Will that only send 3 emails per year?

6. This might be unrelated but... I did get a test message from one of my non admin accounts (an inactive one of mine). The message came from: Kawasaki ZX-10R.net ["Kawasaki ZX-10R.net"@123485-app2.xxxxxxx.com] (I removed some of it). Why does it look so funky (the email return address)?

7. I got an email from my site saying: This email shows that the product is installed and working as it should be. There were no inactive users at this time.. The strange thing is I did get an email (to a non admin test account). How can I tell if it sent emails or didnt?


Thanks,
Rich

[djbaxter]

I have Vbulletin 3.6.9 & I installed Email Reminder 1.1.1.

I recommend you uninstall this and install version 1.09. 1.11 is buggy.

1. If I want to add a specific web link, do I just pop it into the message section or do I need to do something special to make it a clickable hyperlink (same as the $homeurl)?

You can use standard HTML as well as vBulletin variables. My personalized message looks like this:

Hello, $username!

<p>You are receiving this email because you previously registered at {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://www.yourforum.com/login.php?do=lostpw">http://www.yourforum.com/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://www.yourforum.com/usercp.php">http://www.yourforum.com/usercp</a> ) in the top navigation bar of any forum page and select Edit Options ( <a href="http://www.yourforum.com/profile.php?do=editoptions">http://www.yourforum.com/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://www.yourforum.com/profile.php?do=editoptions">http://www.yourforum.com/profile.php?do=editoptions</a> and uncheck the box next to Receive Email from Administrators.</p>

<p>Administrator<br>
<a href="http://www.yourforum.com">{forum}</a><br>
http://www.yourforum.com</p>

Substitute the name of your forum for {forum} and your actual URL for www.yourforum.com.

2. Show footer link? - Does this add a link to the main part of the forum giving credit to djbaxter?

No, to Chris (he wrote the add-on, I just help out with support), or more specifically it adds

Inactive Reminders By Mished.co.uk

3. Add credit to emails sent? - Does this add a credit within the "we miss you" email?

It adds the link to Mished.co.uk to the bottom of the email instead of to the forum footer.

4. I set (for testing) usergroup 3 (admin's), set the script active, then went to Scheduled Task / Scheduled Task Manager & manually ran it (to see). Then I went to Scheduled task log & it says:

Emails sent to:runnerout budda10r gamblingstats Amateur_plf supervideosmen zx10rgeo kuleshkovital Saxgrgns empaphnew sexyass olleloockoerrss Regespinlen buyviagramen LSMITH5791 tenacious z PERMARDIMBUPEd cheque7697 drugimpotence ChedeSach Aideptike Nadin Maison ShallbetNat KentBrooktl infiptoutsous jojonik GoldAmyFell Abarricosta Adillaida Tfyhdwrt SRASADAN Chickflick PERMARDIMBUPEj Blackjacktrinid inhisresy Abarricoss boiliorse. We tried to email the following users, but their email address was invalid:

The list is much longer & I cut a ton of names out. Why did it send out all those emails if the usergroup 3 was the only one selected?

I'm not sure. As I said, version 1.11 is buggy.

5. I set the Days of Inactivity to 14 & the Frequency to 100 (3 emails per year). Will that only send 3 emails per year?

Your settings mean that after 2 weeks of no activity, an email will be sent out and that this will be repeated every 100 days for that member.

6. This might be unrelated but... I did get a test message from one of my non admin accounts (an inactive one of mine). The message came from: Kawasaki ZX-10R.net ["Kawasaki ZX-10R.net"@123485-app2.xxxxxxx.com] (I removed some of it). Why does it look so funky (the email return address)?

The return address is the one you've set for your forum. Anything else is a server issue.

7. I got an email from my site saying: This email shows that the product is installed and working as it should be. There were no inactive users at this time.. The strange thing is I did get an email (to a non admin test account). How can I tell if it sent emails or didnt?

You can check the cron (scheduled task) log for this add-on.

[RichTJ99]

6. This might be unrelated but... I did get a test message from one of my non admin accounts (an inactive one of mine). The message came from: Kawasaki ZX-10R.net ["Kawasaki ZX-10R.net"@123485-app2.xxxxxxx.com] (I removed some of it). Why does it look so funky (the email return address)?
The return address is the one you've set for your forum. Anything else is a server issue..

The strange thing is that my forum sends emails from the correct address (for password resets, thread notifications, etc). This program is the only thing that sends from that 123485 address.


[QUOTE=djbaxter;1483442]7. I got an email from my site saying: This email shows that the product is installed and working as it should be. There were no inactive users at this time.. The strange thing is I did get an email (to a non admin test account). How can I tell if it sent emails or didnt?
You can check the cron (scheduled task) log for this add-onQUOTE]


The weird thing is I got a second one saying it sent out everything to the usergroup (#3) which is not my admin (like i thought) but it is actually my users awaiting confirmation (why it sent out all those things).

Thanks,
Rich

[fesih]

teşekürler gözüm

[RichTJ99]

6. This might be unrelated but... I did get a test message from one of my non admin accounts (an inactive one of mine). The message came from: Kawasaki ZX-10R.net ["Kawasaki ZX-10R.net"@123485-app2.xxxxxxx.com] (I removed some of it). Why does it look so funky (the email return address)?
The return address is the one you've set for your forum. Anything else is a server issue..

The strange thing is that my forum sends emails from the correct address (for password resets, thread notifications, etc). This program is the only thing that sends from that 123485 address.

Thanks,
Rich[/QUOTE]

My other issues are resolved. Any ideas why this keeps sending out that funky email address? The other Vbulletin items (password reset, registration, etc) do not have that email. Only the reminder software.

Would the older version fix that? If so, how do I uninstall 1.1.1?

Thanks,
Rich

[BlueBulletRL]

Maybe there aren't any emails to be sent?

Version 1.09? 1.11? If the latter, uninstall and reinstall 1.09.

Setting in vBulletin options | Inactive Users Reminder emails?

I do have 1.09, I only installed that one because I've read the thread before installing this hack. As stated before I have it set to 1 day inactivity email 2 and usergroups is 2 for registered users still not working for me. According to my log it says there is no emails to send out.

[RichTJ99]

I have the same issue. No emails to send when I have plenty of users that are inactive. I also set it for 1 day & 1 email per day.

I also set on of my guest accounts to be inactive for more than a day (for testing).

[BlueBulletRL]

Same thing I have a ton of inactive accounts. I appreciate the help you can give as I would really LOVE to use this mod on my forum. Thanks

[b6gm6n]

Is this the mode that kills servers? i have many members and regardless it'll send a billion emails saying "come back...we miss you" then your host says NO - STOP! - then you disable it

[djbaxter]

Is this the mode that kills servers? i have many members and regardless it'll send a billion emails saying "come back...we miss you" then your host says NO - STOP! - then you disable it

Not if you configure use version 1.09 and it correctly.

[b6gm6n]

Yes it is this one... i was just about to remove it, kills me every time... turned it on once 2 days ago and my email system used it's 1000 a day quota and tons of returned emails since because of this... I have 1.1.1, you would think instead of being retrogressive and going back a version it would have the ability not to jam your email system... I have a 1000 email limit per day, my host contacted me last time about this mod, then i wonder why normal emails are being returned today... (limit reached), I've set the thing for 6 months, whats it trying to do email everyone ? i have setup this thing correctly and I'm not too sure it's my error, i have a lot of members, you would hope it wouldn't kill your server... cron is set to 1 hour, setting correct, user groups correct, should i set my cron to every 2 days? at least when it tries to send out thousands and thousands of emails I'll have one day at least to play with...

ahh i dunno, don't think it's right some how

[djbaxter]

Yes it is this one... i was just about to remove it, kills me every time... turned it on once 2 days ago and my email system used it's 1000 a day quota and tons of returned emails since because of this... I have 1.1.1, you would think instead of being retrogressive and going back a version it would have the ability not to jam your email system... I have a 1000 email limit per day, my host contacted me last time about this mod, then i wonder why normal emails are being returned today... (limit reached), I've set the thing for 6 months, whats it trying to do email everyone ? i have setup this thing correctly and I'm not too sure it's my error, i have a lot of members, you would hope it wouldn't kill your server... cron is set to 1 hour, setting correct, user groups correct, should i set my cron to every 2 days? at least when it tries to send out thousands and thousands of emails I'll have one day at least to play with...

ahh i dunno, don't think it's right some how

*sigh*

Try reading the damn thread. I'm not the creator of this add-on (Chris is) but I've said many times that you should consider version 1.11 a beta version and 1.09 as the stable version. Use 1.09 and you won't have that problem.

[LoreleiWeb]

thanks for the awesome mod, just installed it!

just a techniqal q, since my server limits the amount of emails i can send per hour / day - i installed it today and my forum has about 11k members, half of them are inactive. will it send emails to all the 6k at once now, or after 30 days on inactivity (these are my settings) to ALL the members that were not active over the past month, or just the ones that will be active and then leave?

if it;s one of the first 2 options, is there any way to throttle these emails somehow? thanks!

[djbaxter]

thanks for the awesome mod, just installed it!

just a techniqal q, since my server limits the amount of emails i can send per hour / day - i installed it today and my forum has about 11k members, half of them are inactive. will it send emails to all the 6k at once now, or after 30 days on inactivity (these are my settings) to ALL the members that were not active over the past month, or just the ones that will be active and then leave?

if it;s one of the first 2 options, is there any way to throttle these emails somehow? thanks!

1. Make sure you installed version 1.09, NOT 1.11

2. Set the options in vBulletin Options | Inactive user reminder emails to reasonable values:

Days of Inactivity = 90
How many days a user can go without posting before they are considered inactive.

Email Frequency = 30
How often to send a reminder email once a member has become inactive.

Email Quantity = 3
How many emails to send each time cron runs (Lower means faster board, but longer to send all emails. Higher, vice versa.)

[b6gm6n]

*sigh*

Try reading the damn thread. I'm not the creator of this add-on (Chris is) but I've said many times that you should consider version 1.11 a beta version and 1.09 as the stable version. Use 1.09 and you won't have that problem.

thank you, i will

[MindstateNL]

Sorry, i´m a total newbie to this. Just bought Vbulletin after working with other forums.

The readme is ok, but for a new one like me, it´s not descriptive enough.:
It says:

To install, upload remindermail.php to your ./includes/cron/ dir, and import the product xml

Options are in admincp options menu, where you should edit the settings.
------
So no, i uploaded remindermail.php to the directory but what to do with the product xml? And where is `Options`, i can´t find it!

[djbaxter]

So no, i uploaded remindermail.php to the directory but what to do with the product xml?

1. go to Admin CP | Plugins & Products | Manage Products

2. scroll down to [Add/Import Product]

3. follow instructions in the next screen

And where is `Options`, i can?t find it!

Once you have imported the product XML file:

1. Admin CP | vBulletin Options | vBulletin Options

2. scroll down to Inactive User Reminder Emails

[MindstateNL]

Oh thanks a lot! This sure helps me out!

[TROLL]

very useful mod...

one suggestion for the future: i'd love to have an option added to set a total number of times to email a user, just so its not sending them emails until the end of time which is unnecessary for the forum and annoying to the user. either that, or if its possible to include a link in the email that says "if you wish to stop receiving emails about this, please follow this link: __________" where they can unsubscribe.
i do want to try to get users back on the forum, but i don't want to aggravate anyone or invade their privacy without them being able to ever stop it.
thanks,
bryan

[deezelpope]

You can use standard HTML as well as vBulletin variables. My personalized message looks like this:

Hello, $username!

<p>You are receiving this email because you previously registered at {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://www.yourforum.com/login.php?do=lostpw">http://www.yourforum.com/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://www.yourforum.com/usercp.php">http://www.yourforum.com/usercp</a> ) in the top navigation bar of any forum page and select Edit Options ( <a href="http://www.yourforum.com/profile.php?do=editoptions">http://www.yourforum.com/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://www.yourforum.com/profile.php?do=editoptions">http://www.yourforum.com/profile.php?do=editoptions</a> and uncheck the box next to Receive Email from Administrators.</p>

<p>Administrator<br>
<a href="http://www.yourforum.com">{forum}</a><br>
http://www.yourforum.com</p>

Substitute the name of your forum for {forum} and your actual URL for www.yourforum.com (http://www.yourforum.com).





very useful mod...

one suggestion for the future: i'd love to have an option added to set a total number of times to email a user, just so its not sending them emails until the end of time which is unnecessary for the forum and annoying to the user. either that, or if its possible to include a link in the email that says "if you wish to stop receiving emails about this, please follow this link: __________" where they can unsubscribe.
i do want to try to get users back on the forum, but i don't want to aggravate anyone or invade their privacy without them being able to ever stop it.
thanks,
bryan
I quoted DJ Baxter's post...I use some text similar. Hope this helps.:)

[1quick1]

Hi I have this installed and it's working great. No issues there.

My question is is this going to be 3.7 compatible or will there be a new version released?

[TROLL]

thanks... just added that to my email as well so users have the option of unsubscribing.
i have to admit that i've gotten a few disgruntled responses to this email and some of there are kind of amusing though, haha.

[b6gm6n]

Just To Let You All Know, If You Use This Mod You And Have A High Amount Of Members You Will Be Banned From Yahoo, Hotmail Domains And Many Other As This Mod Regardless Of Settings Will Jam Your Server And Mark Your Own Domain As A Spamming Domain, I Have Tried Over & Over Again To Warn People About This...use At Your Own Risk

[b6gm6n]

my host has disabled my account due to this mod for safety... thanks mate, thanks very ***kin much, i will warn people about this mod on my providers forums... also, i was using the version the maker said... whatever.whatever... once an hour... 20 emails max.... exceeded my limit by 1000 every hour mate....DOESN'T WORK!!!!!!!!!

[b6gm6n]

If there's anything you would like to do to get my domain back in yahoo's good books then please tell us...cheers

[goddess_dix]

i'd love to have an option added to set a total number of times to email a user, just so its not sending them emails until the end of time which is unnecessary for the forum and annoying to the user. either that, or if its possible to include a link in the email that says "if you wish to stop receiving emails about this, please follow this link: __________" where they can unsubscribe.
i do want to try to get users back on the forum, but i don't want to aggravate anyone or invade their privacy without them being able to ever stop it.


i think that's a great idea...i'll be you could pretty easily change the templates yourself to do that by looking at the phrases in the emails for susbcribed threads, which has an option to disable further site email if i'm not mistaken. that will also keep you more sypatico with established practices if a spam question comes up.

i also have the mod installed to manage bouncing email addys-lots of bounced emails does hurt your "email rep", so weeding them out as i go is part of my overall site email management plan...

[TROLL]

what email bouncing mod are you talking about?

and i have a question about how many emails it sends at a time and how often it sends... i have mine set up to send 10 at a time, but how often does it do this? after looking into it i see that it only takes my setup about 20 minutes to send 4000 emails :eek:
how can i go about slowing this down properly?

and the yahoo/hotmail spam thing concerns me... is there a way around this at all? for all i know i've already been flagged (have had this running for about a week now)

[WEBDosser]

**REMOVED** just in case.

[djbaxter]

Just To Let You All Know, If You Use This Mod You And Have A High Amount Of Members You Will Be Banned From Yahoo, Hotmail Domains And Many Other As This Mod Regardless Of Settings Will Jam Your Server And Mark Your Own Domain As A Spamming Domain, I Have Tried Over & Over Again To Warn People About This...use At Your Own Risk

my host has disabled my account due to this mod for safety... thanks mate, thanks very ***kin much, i will warn people about this mod on my providers forums... also, i was using the version the maker said... whatever.whatever... once an hour... 20 emails max.... exceeded my limit by 1000 every hour mate....DOESN'T WORK!!!!!!!!!

If there's anything you would like to do to get my domain back in yahoo's good books then please tell us...cheers

And you could have avoided all of that if you had:

1. read the thread

2. installed version 1.09, NOT 1.11

3. set the options using a bit of intelligence

4. added instructions for opting out of future emails in the options for the add-on

5. known what you were doing before randomly installing add-ons

But thanks for your very insightful and mature input. :rolleyes:

[goddess_dix]

what email bouncing mod are you talking about?

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

note- you have to check for yahoo's soft bounces before you manage them, info in the thread about it.

and i have a question about how many emails it sends at a time and how often it sends... i have mine set up to send 10 at a time, but how often does it do this? after looking into it i see that it only takes my setup about 20 minutes to send 4000 emails :eek:

look and see how often the cron is set to run in your "scheduled tasks" of the admincp. you can adjust the frequency there, i imagine.

and the yahoo/hotmail spam thing concerns me... is there a way around this at all? for all i know i've already been flagged (have had this running for about a week now)

anytime you send bulk email, you have to deal with this. do you have a dedicated server, i guess? it would be a good idea to get yourself signed on for the feedback loops for those places that have them to help monitor. (for example, i'm on the aol feedback loop, so if anybody reports any email coming from my server as spam, i get notified.) yahoo doesn't as far as i know; they have a terrible practice of "soft bouncing" messages with the thinking that spammers don't retry, but real mail transport agents will. and if you host clients on your box, that's another good reason to get signed up.

honestly, i think that staying informed, making sure your emails have clear unsub instructions, and using some common sense will go a long way. when you get reported as spam, that generally means a person looks at your email from my understanding. so make sure it doesn't look like spam. make sure it says who you are, that they have agreed to get admin emails, and how to stop them...

while managing your email rep is actually a valid concern, i consder the stuff b6gm6n wrote to be straight trolling. (also found it ironic that your username is "troll" but you ain't the biggest troll in the room.)

[Codeman05]

Hi,

I just installed this mod and when I run the CRON manually, I get this nice error:


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!"); } ?>

Running version 1.1.1 on VB 3.6.6

Any thoughts?

[djbaxter]

Running version 1.1.1 on VB 3.6.6

Any thoughts?

Yes. Uninstall version 1.11. Install version 1.09.

[Codeman05]

Unfortunately that seems to have made no difference.
Deleted the old cron file and uninstalled 1.1.1, uploaded and reinstalled 1.0.9, same error.

[FinalX-TeaM]

thanks...:)

[Code Monkey]

Hi,

I just installed this mod and when I run the CRON manually, I get this nice error:



Running version 1.1.1 on VB 3.6.6

Any thoughts?

For some odd reason he is using short tags. Just go to the first line of remindermail.php and change <? to <?php and that will go away.

[BlueBulletRL]

Hey so I was still having issues but went ahead and found the one file in here that does the array and it worked. Not sure what the difference is however I have a question. I noticed that in the database in the cronlog when the job is run it is showing a type of 0 and everything else in there is a 1. Is this a reason why I could be having issues in the first place or no? Someone please help this ones driving me crazy.

[djbaxter]

I really don't know why it's not working for you, BlueBullet. You had your options set to a very short interval (1 day) and selected only 1 group - try altering these, adding a comma at the end of that group ID number or adding a second group. If fiddling with the options doesn't make a difference, take a look at other add-ons which may be interfering with it and disable those for testing purposes.

Try these settings:

Days of Inactivity = 90
How many days a user can go without posting before they are considered inactive.

Product Active?
Is this product active? Yes

Email Frequency = 30
How often to send a reminder email once a member has become inactive.

Email Quantity = 3
How many emails to send each time cron runs (Lower means faster board, but longer to send all emails

[Codeman05]

For some odd reason he is using short tags. Just go to the first line of remindermail.php and change <? to <?php and that will go away.

You sir, are the man. I did not think to check that at all, you were exactly right.

[Joe1967]

Installed - thank you for this mod!

[islamicvd]

Is it running on 3.6.10?

[djbaxter]

Is it running on 3.6.10?

Yes it is.

[CoffeeToki]

Please forgive me if this has already been answered. I did try searching for the answer, but I couldn't find it. Will it run on 3.7.0 Gold version?

[pericolosogr]

Is it working with 3.7?

I just stated that the other day. Yes it does. I'm running 3.7 beta 6 and its working just fine.

Just remember to install 1.09

[Mrdby]

the final release? i just updated to 3.7.0

[goldendox]

it worked till the 3.7 gold install. now i get "there were no inactive users at this time" emails when there are lots of inactive users.

[djbaxter]

it worked till the 3.7 gold install. now i get "there were no inactive users at this time" emails when there are lots of inactive users.

I have it still working with 3.6.8.10 - haven't tried the 3.7 upgrade yet.

Have you tried reinstalling?

Can anyone else confirm a problem with 3.7?

[tekguru]

v1.1.1 is still working for me with 3.7.0.

[djbaxter]

v1.1.1 is still working for me with 3.7.0.

Thanks. Good to know. :)

[keyness]

Waiting for version of this great hack for vb3.7.0. Thanks in advance. :up:

[djbaxter]

Waiting for version of this great hack for vb3.7.0. Thanks in advance. :up:

Apparently it's working on 3.70 already.

[viper357]

I have had this installed for a while and is working perfectly although I am no longer receiving the email reports. Any idea what could be wrong?

[keyness]

Apparently it's working on 3.70 already.

I didn't remove/disable the product, but it's not working for me. Should I re-install?

[djbaxter]

It's worth a try. I haven't yet upgraded to vB 3.7 but it works fine on 3.6.10 (add-on version 1.09).

[Gersfan]

It's working on 3.7 for me no problems.

[Artes_Marciales]

Thanks!!! : )

[losedude]

Well, I must say i'm a bit confused so i'm posting a message here and I hope someone can help me out.

I have Vbulletin 3.7.0 Gold, I have a LOT of inactive users and I'm hoping this plug in will help get my forum more active.

Now as I have a lot of inactive users, I don't want my server going into overdrive because this script starts sending out loads of emails all at once, so my question is :

Should I be installing 1.09 or 1.11 to limit the amount of emails sent out per hour / day.

Thanks for your time, I'm hoping the effects of this mod will show as said in your quotes :)

[djbaxter]

Start with 1.09.

[losedude]

Well just a bit of feedback. This mod works GREAT, my forum has become a lot more active and a lot of previously inactive members have started posting again.

Great mod !

[mayanks]

By any chance, can i set some kind of restrictions that the script does not send more than 250 emails per hour? My ISP has restricted emails to 300/hour. Lemme know.

thanks in advance.

[fancominc]

I just enabled the product and set the frequency to 1, how long does it take to send out the first batch of emails?

Thanks!

[mikesharp]

I have installed the version 1.09 and even though i definately have inactive users it says no emails sent when i run it manually :(

any ideas? im running vBulletin v3.7.2

[djbaxter]

Install version 1.13 - see https://vborg.vbsupport.ru/showthread.php?t=180025

[C Braithwaite]

Hi - not been able to focus on things like this in the past <god knows> months. I'm going to be making updates to this modification soon to improve it's performance and reduce it's annoyance.

Click install to make sure you receive updates!

[Chimpie]

So you've done the update or you're going to update it?

And it says that you are reverting back to ver. 1.0.9. Does this mean that the features, like the report, are gone now?

[SoftDux]

I like this plugin, it's very handy :)

I want to make a suggestion though, if it's not too much trouble. How about having an option to have an intro for the last 5 posts in the email as well?

[Brandon Sheley]

sounds great
but I get this error

XML Error: XML_WAR_UNKNOWN_VERSION at Line 146

[djbaxter]

Chris, your add-on has been updated for vBulletin 3.7x as version 1.13 at https://vborg.vbsupport.ru/showthread.php?t=180025

I'm using that version now and it seems to work well for me, although others are finding glitches. Perhaps you and robertjandreu (https://vborg.vbsupport.ru/member.php?u=230904) should collaborate on any future updates.

[abrecher]

I just ran the latest version and received the following error:

Database error in vBulletin 3.7.2:

Invalid SQL:
SELECT * FROM user WHERE lastactivity < '1216091182' AND emailDate < '1216091182' AND reminders < 3 AND options & 16 LIMIT 3;

MySQL Error : Unknown column 'reminders' in 'where clause'
Error Number : 1054
Request Date : Wednesday, August 13th 2008 @ 11:06:22 PM
Error Date : Wednesday, August 13th 2008 @ 11:06:22 PM
Script : http://www.domain.com/admincp/cronadmin.php?do=runcron&cronid=89
Referrer : http://www.domain.com/admincp/index.php
IP Address : hidden
Username : hidden
Classname : vB_Database
MySQL Version : 5.0.51-log following error:

[abrecher]

I just ran the latest version and received the following error:

Database error in vBulletin 3.7.2:

Invalid SQL:
SELECT * FROM user WHERE lastactivity < '1216091182' AND emailDate < '1216091182' AND reminders < 3 AND options & 16 LIMIT 3;

MySQL Error : Unknown column 'reminders' in 'where clause'
Error Number : 1054
Request Date : Wednesday, August 13th 2008 @ 11:06:22 PM
Error Date : Wednesday, August 13th 2008 @ 11:06:22 PM
Script : http://www.domain.com/admincp/cronadmin.php?do=runcron&cronid=89
Referrer : http://www.domain.com/admincp/index.php
IP Address : hidden
Username : hidden
Classname : vB_Database
MySQL Version : 5.0.51-log following error:

I had to completely uninstall the mod and reinstall for it to work correctly again. All is good now!

[PoetJA-1975]

Hi - Thanx for the update CHRIS - I too was gonna mention that your modification has been updated by another Member - It would nice if you could possibly release an "official" version for the 3.7.x series. Would love to see the the updates/improvements added ;)

Thanx,

Jacquii.

[C Braithwaite]

So you've done the update or you're going to update it?

And it says that you are reverting back to ver. 1.0.9. Does this mean that the features, like the report, are gone now?

I have just release a tiny update last night which does limit the number of emails that the product will send.

Chris, your add-on has been updated for vBulletin 3.7x as version 1.13 at https://vborg.vbsupport.ru/showthread.php?t=180025

I'm using that version now and it seems to work well for me, although others are finding glitches. Perhaps you and robertjandreu (https://vborg.vbsupport.ru/member.php?u=230904) should collaborate on any future updates.

Im going to soon overhaull the entire code and release a version for 3.7x I just need to sort a few things out - read through all of these posts making a note of all suggestions and errors etc.

Hi - Thanx for the update CHRIS - I too was gonna mention that your modification has been updated by another Member - It would nice if you could possibly release an "official" version for the 3.7.x series. Would love to see the the updates/improvements added ;)

Thanx,

Jacquii.

Thanks for all the support and feedback everyone. I will get you all a fully functioning awesome plugin that is supported by as many versions as possible.

[reteep]

Working great, thanks for the update!

[RedTrinity]

Just tried to import the new 1.1.2 xml file in my ACP and got the following error...

XML Error: XML_WAR_UNKNOWN_VERSION at Line 146

Forum version is 3.7.2 :confused:

[Leo Brazil]

I'm using your previous version on 3.7.2 PL1 and working fine so far.

The only problem I'm facing is the e-mails sent to users are not sent using admin e-mail address just like regular Vb notifications. It tooks the sender as origin path of my system like directions for admin mail box. The e-mails are sent anyway but e-mails systems like Yahoo, Hotmail, Gmail put them as spam.

I tried to find in your code a reason for this but no lucky so far. Any tips ?

Tks

[C Braithwaite]

I'm using your previous version on 3.7.2 PL1 and working fine so far.

The only problem I'm facing is the e-mails sent to users are not sent using admin e-mail address just like regular Vb notifications. It tooks the sender as origin path of my system like directions for admin mail box. The e-mails are sent anyway but e-mails systems like Yahoo, Hotmail, Gmail put them as spam.

I tried to find in your code a reason for this but no lucky so far. Any tips ?

Tks

I shall look into this for you. Watch this space.

[C Braithwaite]

the only thing i can think of is that the way 3.7x handles options/settings are different... ?

[tekguru]

Thie definitely needs tying back with the revised version that has been produced so there is only one version of this Mod around!

[C Braithwaite]

Thie definitely needs tying back with the revised version that has been produced so there is only one version of this Mod around!

as I have said, im going to fully revise the code and iron out all the bugs as I can. I need to optimize the code also.

lets see what the weekend brings....

[C Braithwaite]

ive been up since about 4am working on this - almost 8 hours later im done. very tired, but done.

[Fraik]

Ive downloaded the new version 1.2, but I dont see the options anywhere... was the location changed?

[SimonVlc]

Ive downloaded the new version 1.2, but I dont see the options anywhere... was the location changed?

Same here. Thanks a lot for the work anyway ;).

[C Braithwaite]

Maybe you need to uninstall the old one and then install the new one?

And the option group is "Reminder Emails"

[Fraik]

I did that exactly, and I dont see the options,

[OnyxChase]

Thanks for your work C Braithwaite! I will keep an eye out until you say the 1.2 version is fully tested and bug free. :)

Any upgrade instructions?

[C Braithwaite]

most unusual that you can't find the settings. ill double check things when I get home...

hopefully i've coded a bug free version first time..

[CPB123]

I'm actually using 1.0.9 on 3.7.2 pl 1 and it works great. However I installed it while I was using 3.6.x so this may be why it works.

What are the advantages of 1.2 over 1.0.9? Does 1.2 have a daily report? Currently I have to check my scheduled task log for "Inactive User Reminder Emails" entries to see who messages were sent to.

[Charlie98902]

So, do we just remove the old files and use the plug in now?

[C Braithwaite]

I'm actually using 1.0.9 on 3.7.2 pl 1 and it works great. However I installed it while I was using 3.6.x so this may be why it works.

What are the advantages of 1.2 over 1.0.9? Does 1.2 have a daily report? Currently I have to check my scheduled task log for "Inactive User Reminder Emails" entries to see who messages were sent to.

The main thing is that it should work with the most recent version of vbulletin.
It's been coded from scratch and designed to be more efficient - it uses the vbulletin mailqueue system and can send HTML emails also. The emails are more evenly distributed to ensure maximum speed. I am going to create a report system next which will show which members that have been contacted, how many times, and what %age of people actually return.

So, do we just remove the old files and use the plug in now?

Yes, That would be best. I should have mentioned that.



Are there any reports of working code as of yet? or bugs maybe?

[CPB123]

I am going to create a report system next which will show which members that have been contacted, how many times, and what %age of people actually return?Excellent, looking forward to this. In the meantime I'll stick with 1.0.9 since its working well and I don't need HTML e-mails sent, plaintext is fine with me since I've already formatted a custom message for my inactive users.

Thanks for all your hard work!

[SimonVlc]

Maybe you need to uninstall the old one and then install the new one?

Just that,

personally I think it needs to be addressed with a readme file or a greater font in the mod description.

Any solution in that case?

[Charlie98902]

How will one configure the email sent? I seen the message header but no body to it? Or do we leave the remindermail.php intact?

[C Braithwaite]

How will one configure the email sent? I seen the message header but no body to it? Or do we leave the remindermail.php intact?
there should be a settings in the options, but for some reason when i exported the product it for some reason only exported the phrases... not quite sure why. im just working on re-building the settings.

[C Braithwaite]

there should be a settings in the options, but for some reason when i exported the product it for some reason only exported the phrases... not quite sure why. im just working on re-building the settings.

Fixed and updated file. please overwrite.

[Charlie98902]

Installed the update plugin and don't have the email.php in the includes and I get this:

Parse error: syntax error, unexpected T_STRING in /home/dvdnextc/public_html/includes/init.php(293) : eval()'d code(189) : eval()'d code on line 7

Parse error: syntax error, unexpected T_STRING in /home/dvdnextc/public_html/includes/init.php(293) : eval()'d code(189) : eval()'d code on line 7

Parse error: syntax error, unexpected T_STRING in /home/dvdnextc/public_html/includes/init.php(293) : eval()'d code(189) : eval()'d code on line 7

Parse error: syntax error, unexpected T_STRING in /home/dvdnextc/public_html/includes/init.php(293) : eval()'d code(189) : eval()'d code on line 7

Parse error: syntax error, unexpected T_STRING in /home/dvdnextc/public_html/includes/init.php(293) : eval()'d code(189) : eval()'d code on line 7

Parse error: syntax error, unexpected T_STRING in /home/dvdnextc/public_html/includes/init.php(293) : eval()'d code(189) : eval()'d code on line 7

Parse error: syntax error, unexpected T_STRING in /home/dvdnextc/public_html/includes/init.php(293) : eval()'d code(189) : eval()'d code on line 7

Parse error: syntax error, unexpected T_STRING in /home/dvdnextc/public_html/includes/init.php(293) : eval()'d code(189) : eval()'d code on line 7

Parse error: syntax error, unexpected T_STRING in /home/dvdnextc/public_html/includes/init.php(293) : eval()'d code(189) : eval()'d code on line 7

Parse error: syntax error, unexpected T_STRING in /home/dvdnextc/public_html/includes/init.php(293) : eval()'d code(189) : eval()'d code on line 7

[C Braithwaite]

Installed the update plugin and don't have the email.php in the includes and I get this:

Parse error: syntax error, unexpected T_STRING in /home/dvdnextc/public_html/includes/init.php(293) : eval()'d code(189) : eval()'d code on line 7

Parse error: syntax error, unexpected T_STRING in /home/dvdnextc/public_html/includes/init.php(293) : eval()'d code(189) : eval()'d code on line 7

Parse error: syntax error, unexpected T_STRING in /home/dvdnextc/public_html/includes/init.php(293) : eval()'d code(189) : eval()'d code on line 7

Parse error: syntax error, unexpected T_STRING in /home/dvdnextc/public_html/includes/init.php(293) : eval()'d code(189) : eval()'d code on line 7

Parse error: syntax error, unexpected T_STRING in /home/dvdnextc/public_html/includes/init.php(293) : eval()'d code(189) : eval()'d code on line 7

Parse error: syntax error, unexpected T_STRING in /home/dvdnextc/public_html/includes/init.php(293) : eval()'d code(189) : eval()'d code on line 7

Parse error: syntax error, unexpected T_STRING in /home/dvdnextc/public_html/includes/init.php(293) : eval()'d code(189) : eval()'d code on line 7

Parse error: syntax error, unexpected T_STRING in /home/dvdnextc/public_html/includes/init.php(293) : eval()'d code(189) : eval()'d code on line 7

Parse error: syntax error, unexpected T_STRING in /home/dvdnextc/public_html/includes/init.php(293) : eval()'d code(189) : eval()'d code on line 7

Parse error: syntax error, unexpected T_STRING in /home/dvdnextc/public_html/includes/init.php(293) : eval()'d code(189) : eval()'d code on line 7

Re-download, uninstall, install file again. should fix. I hope. sorry for the inconvinience.

[Charlie98902]

Do we need to edit this accordingly?

YourWebsite's Admin
<a href="http://www.yoururl.com">yoururl.com</a></p>

[C Braithwaite]

Do we need to edit this accordingly?

YourWebsite's Admin
<a href="http://www.yoururl.com">yoururl.com</a></p>

Yeah - you can have whatever you wish...that was just my quick example ;)

please do let me know if the product works (currently i dont have reports, but if you can check the mailqueue table you should see the emails waiting to be sent out)

[Charlie98902]

OK sorry I meat in the YourWebsite's Admin Will it auto place your name and on the URL part will it auto replace yoururl.com & yoururl.com to the correct URL or does those need editing?

[C Braithwaite]

OK sorry I meat in the YourWebsite's Admin Will it auto place your name and on the URL part will it auto replace yoururl.com & yoururl.com to the correct URL or does those need editing?


no, sorry it wont auto replace..
it is entirely up to you ..

[Charlie98902]

Thanks

[Charlie98902]

When I go into looking at Who's Online I get a DB error, looking at forum home is ok.

[C Braithwaite]

When I go into looking at Who's Online I get a DB error, looking at forum home is ok.

What error do you get? im not having any problems with it at the moment...?

[Charlie98902]

Database error in vBulletin 3.7.2:

Invalid SQL:

SELECT userid, username, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM user AS user
WHERE userid IN (02341','2344','363','2345','2342','1508','1380',' 2348','2288','1897);

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '','2344','363','2345','2342','1508','1380','2348' ,'2288','1897)' at line 3
Error Number : 1064
Request Date : Saturday, August 16th 2008 @ 06:15:54 PM
Error Date : Saturday, August 16th 2008 @ 06:15:54 PM
Script : http://www.dvdnextcopysupportforum.com/online.php?order=asc&sort=username&pp=20&page=1&who=members
Referrer : http://www.dvdnextcopysupportforum.com/online.php?order=asc&sort=username&pp=20&page=1&who=members
IP Address : 75.165.141.69
Username : Charlie
Classname : vB_Database
MySQL Version : 5.0.51a-community-log

That's what I get when I click on Currently Active Users to watch what everyones doing.

[C Braithwaite]

Database error in vBulletin 3.7.2:

Invalid SQL:

SELECT userid, username, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM user AS user
WHERE userid IN (02341','2344','363','2345','2342','1508','1380',' 2348','2288','1897);

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '','2344','363','2345','2342','1508','1380','2348' ,'2288','1897)' at line 3
Error Number : 1064
Request Date : Saturday, August 16th 2008 @ 06:15:54 PM
Error Date : Saturday, August 16th 2008 @ 06:15:54 PM
Script : http://www.dvdnextcopysupportforum.com/online.php?order=asc&sort=username&pp=20&page=1&who=members
Referrer : http://www.dvdnextcopysupportforum.com/online.php?order=asc&sort=username&pp=20&page=1&who=members
IP Address : 75.165.141.69
Username : Charlie
Classname : vB_Database
MySQL Version : 5.0.51a-community-log

That's what I get when I click on Currently Active Users to watch what everyones doing.

Sorry to say - that's not my code im afraid..unless one of my variables isconflicting with another plugin ?

[Charlie98902]

It's OK I don't really need it but was just a want for future things. Good job though on making just a plugin.

[RedTrinity]

Hi CBraithwaite,

Just imported the new 2.1 xml plugin and all seems to be well, however I have noticed whenever I tick the usergroup boxes ie. "Which usergroups do you want to monitor for inactivity?" and then submit, it goes through successfully - but then all boxes become unticked again after it returns to the options?

Not sure if this is a bug or not :D

Also how does this run, is it by scheduled task? I can't seem to find an entry in there for this plugin, tis all :confused:

Thanks in advance for your help :)

[Fraik]

After installing the updated 1.2, I am getting a database error on all of my forum pages :(

[Osama11]

I have installed inactive email reminder..but its sending a email from my host email adresss..how can i changed the email adresss...

can some 1 plzz tell me...

[C Braithwaite]

Hi CBraithwaite,

Just imported the new 2.1 xml plugin and all seems to be well, however I have noticed whenever I tick the usergroup boxes ie. "Which usergroups do you want to monitor for inactivity?" and then submit, it goes through successfully - but then all boxes become unticked again after it returns to the options?

Not sure if this is a bug or not :D

Also how does this run, is it by scheduled task? I can't seem to find an entry in there for this plugin, tis all :confused:

Thanks in advance for your help :)

it is a slight bug, however its not a real issue - the settings do get saved, but it doesnt load them up again properly! i have fixed it, but it didnt seem worth it to upload and notify just for that. it will be in next update.

it uses init_startup to process.

After installing the updated 1.2, I am getting a database error on all of my forum pages :(
what is the error? if you are having problems removing the plugin due to the error, delete the pluginlist entry from the datastore table directly from your databse.
I have installed inactive email reminder..but its sending a email from my host email adresss..how can i changed the email adresss...

can some 1 plzz tell me...
it uses the $vbulletin->options['webmasteremail']; setting, and is sent using the vbulletin built in mail queue setting - do you the same issue when you send other emails? is it likely that you did not specify an email address on your vbulletin install?

[RedTrinity]

it is a slight bug, however its not a real issue - the settings do get saved, but it doesnt load them up again properly! i have fixed it, but it didnt seem worth it to upload and notify just for that. it will be in next update.

it uses init_startup to process.

Ok thanks for that information :)

So how do I check what members it has emailed reminders to, and that they have all gone out successfully? Ie. A log of all activity by this plugin? Generally this is done by the scheduled task log if its a timed task, but obviously its not the case this time round :)

Thanks in advance.

[suvari1794]

After installing the updated 1.2, I am getting a database error on all of my forum pages :(
I am too :(

Database error in vBulletin 3.7.2:

Invalid SQL:

INSERT INTO mailqueue (dateline,toemail,fromemail,subject,message,header ) VALUES ('1218968479','caginsan@gmail.com','admin@amaney.c om','Merhaba $username!','<p>Merhaba _-'CaGo'-_!</p>
<p>Baya?? bir zamand?r forumumuzda sizi g?remiyoruz. Forumumuza tekrar g?zatmak istemez misiniz?</p>
<p>E?er ?ifrenizi unuttuysan?z , buradan ?ifre talep edebilirsiniz:
<a
href="/login.php?do=lostpw">/login.php?do=lostpw</a></p>
<p>Sizi
yeniden aram?zda g?rmek dile?iyle...</p>
<p>&nbsp;</p>

<p><a href=""></a></p>
<p>&nbsp;</p>
E?er bu e-postalardan bir daha almak istemiyorsan?z sitemize ?yeli?inizle giri? yapmal?s?n?z ve kontrol panelinizdeki ayarlar?n?zdan "Administrat?rler Bilgi E-Mailleri G?ndersinler" se?ene?ini kald?rmal?s?n?z.','MIME-Version: 1.0
Content-type: text/html; charset=iso-8859-1
To: _-'CaGo'-_ <caginsan@gmail.com>
From: Amaney.com Reminder Service <admin@amaney.com>
');

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CaGo'-_!</p>
<p>Baya?? bir zamand?r forumumuzda sizi g?remiyoruz. Forumumuza te' at line 1
Error Number : 1064

Request Date : Sunday, August 17th 2008 @ 01:21:19 PM
Error Date : Sunday, August 17th 2008 @ 01:21:19 PM
Script : http://www.amaney.com/forum/komik-yazilar/40137-kapa-ceneni-yeni-mesaj.html
Referrer : http://www.amaney.com/forum/

IP Address : ****
- Alıntı metni gizle -
Username :
Classname : vB_Database
MySQL Version :

[C Braithwaite]

Ok thanks for that information :)

So how do I check what members it has emailed reminders to, and that they have all gone out successfully? Ie. A log of all activity by this plugin? Generally this is done by the scheduled task log if its a timed task, but obviously its not the case this time round :)

Thanks in advance.

i have just updated the plugin to fix some bugs. I've also added some reports (see screenshots)

I am too :(

Database error in vBulletin 3.7.2:

Invalid SQL:

INSERT INTO mailqueue (dateline,toemail,fromemail,subject,message,header ) VALUES ('1218968479','caginsan@gmail.com','admin@amaney.c om','Merhaba $username!','<p>Merhaba _-'CaGo'-_!</p>
<p>Baya?? bir zamand?r forumumuzda sizi g?remiyoruz. Forumumuza tekrar g?zatmak istemez misiniz?</p>
<p>E?er ?ifrenizi unuttuysan?z , buradan ?ifre talep edebilirsiniz:
<a
href="/login.php?do=lostpw">/login.php?do=lostpw</a></p>
<p>Sizi
yeniden aram?zda g?rmek dile?iyle...</p>
<p>&nbsp;</p>

<p><a href=""></a></p>
<p>&nbsp;</p>
E?er bu e-postalardan bir daha almak istemiyorsan?z sitemize ?yeli?inizle giri? yapmal?s?n?z ve kontrol panelinizdeki ayarlar?n?zdan "Administrat?rler Bilgi E-Mailleri G?ndersinler" se?ene?ini kald?rmal?s?n?z.','MIME-Version: 1.0
Content-type: text/html; charset=iso-8859-1
To: _-'CaGo'-_ <caginsan@gmail.com>
From: Amaney.com Reminder Service <admin@amaney.com>
');

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CaGo'-_!</p>
<p>Baya?? bir zamand?r forumumuzda sizi g?remiyoruz. Forumumuza te' at line 1
Error Number : 1064

Request Date : Sunday, August 17th 2008 @ 01:21:19 PM
Error Date : Sunday, August 17th 2008 @ 01:21:19 PM
Script : http://www.amaney.com/forum/komik-yazilar/40137-kapa-ceneni-yeni-mesaj.html
Referrer : http://www.amaney.com/forum/

IP Address : ****
- Alıntı metni gizle -
Username :
Classname : vB_Database
MySQL Version :




sorry about that - update the plugin and the bug should have been removed.

[Fraik]

I will try the plugin again later today :)

[RedPoint]

Old plugin deinstalled, new installed, setting, run
Thank you CBraithwaite for this plugin

Regards

[EagleNick]

I'm running version 1.1.1 on vB 3.7.2PL1 and it's working fine.

I see that some other members are having errors with your later updates...?

I think I'm just going to stay put. I don't want it to break.

[C Braithwaite]

I'm running version 1.1.1 on vB 3.7.2PL1 and it's working fine.

I see that some other members are having errors with your later updates...?

I think I'm just going to stay put. I don't want it to break.

whichever works best for you really - i only decided to update this because of some people having issues. :)

[C Braithwaite]

Old plugin deinstalled, new installed, setting, run
Thank you CBraithwaite for this plugin

Regards

you are more than welcome - any feedback on the performance would be great!

[Chimpie]

It looks nice, but as soon as I make the mod active I get a database error:

Database error in vBulletin 3.7.2:

Invalid SQL:

SELECT userid, username, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM user AS user
WHERE userid IN (0252','259','260,1070);

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '','259','260,1070)' at line 3
Error Number : 1064
Request Date : Sunday, August 17th 2008 @ 07:43:25 AM
Error Date : Sunday, August 17th 2008 @ 07:43:25 AM
Script : http://www.skywarnonline.com/forums/online.php?sort=time&order=desc
Referrer : http://www.skywarnonline.com/forums/online.php?order=desc&sort=time&pp=20&page=1
IP Address : **********
Username : Dave
Classname : vB_Database
MySQL Version : 5.0.51a-community

[Artes_Marciales]

Thanks foro the update!! : )

¿work on vb 3.7.2??

[djbaxter]

I'm currently using 1.13 which is working well for me. I like the option to email the reports of who was sent an email and any invalid addresses. Could you inlcude that option in the next update?

[ezurick]

i have just updated the plugin to fix some bugs. I've also added some reports (see screenshots)



sorry about that - update the plugin and the bug should have been removed.

Ummm.. the last I checked, this forum is for 3.6 Mods and add-ons.. this is NOT 3.7!!!! I tried to update your lastest version and it states the product is for 3.7 and not compatible to 3.6... I am running 3.6 and refuse to upgrade... PLEASE move this mod to 3.7 and kill it here... or support the 3.6....

[RedTrinity]

Ok updated again and looking good!

This may sound silly, but how do you make it run? :confused::o I want to send out my first lot of reminder emails now but don't know how to initiate the process lol. Otherwise, is there a set time when it runs automatically (each day for example)?

Cheers again :)

[RedPoint]

sorry guys,
i mean by me its running, but here:
Warning: Unexpected character in input: '\' (ASCII=92) state=1 in /forum/includes/cron/remindermail.php on line 82 Parse error: syntax error, unexpected T_STRING in /forum/includes/cron/remindermail.php on line 82

What is that guys?

Regards

[frostyIntrepid]

Hmm, may I know from where can I view the log entries that store where the emails are sent to?

[djbaxter]

Ok updated again and looking good!

This may sound silly, but how do you make it run? :confused::o I want to send out my first lot of reminder emails now but don't know how to initiate the process lol. Otherwise, is there a set time when it runs automatically (each day for example)?

Cheers again :)


Go to Admin CP | Scheduled Tasks | Scheduled Task Manager
Scroll down to find Inactive User Reminder Emails
Edit to set when you want the cron job to execute
Click on Run Now to execute the task im mediately