Mini Mods - Email reminder for inactive users 1.1.3

Hey Guys I've been using this mod quite a while and got a bit depressed after not seeing any updates to the mod. So I figured why not making my own modifications and help the people that had requests out a bit. I'm someone that is against spam. This mod becomes fast a annoyance to users that are inactive for a long time. That's why I will be making this mod more functional than before. Look into my to do list for new additions that will come.

Updates:
1 Email Only Function:
This function will limit the total emails send to 1. So if this email is send once they will never get a "miss you" email anymore. So people will get less anoyed and won't rate you as spam right away.

Todo:
Edit number of emails send totally
Not only 1 message but multiple messages possible and chosen with a random

If a user has not posted in x number of days, a HTML email will be sent out with a custom message.

Ive updated the mod so all the settings are editable in the AdminCP

Instructions are included.

I must insist that anyone pre 1.1.2 upgrades asap.

Update 1.1.3 (22/5/08)

* Bugfix for New Registers


Update 1.1.2 (21/5/08)

* Added 1 Email only Function


Update 1.1.1

* Edited default templates
* Added daily report


Update 1.1.0

* Changed the way that emails are sent out by adding the emails to vbulletin's mail queue
* Default cron settings now changed to once per day

To upgrade you need to overwrite the remindermail.php file in the cron directory, and ideally import the product again. The new code will work with the old product file, however I have removed one of the settings in the options as it was no longer needed. as i say it will still run with this there but the quantity setting is now no longer used.

Update 1.0.9

* Cron Log Now Working.
Update by uploading remindermail.php


Update 1.0.8

* Updated code to to exclude users who have chose not to receive admin emails.
Upgrade by uploading PHP file only.

Thanks to djbaxter for help with this.


Update 1.0.7

* Fixed "Sending to new users" bug
* Amended installation code


Update 1.0.6 (14/02/07)

* Added option to turn plugin on or off
* Added option to specify inactivity triggered by lastpost or lastactivity
* Added options to show credit to author or not. (due to some ungrateful, complaining bum squirts that have not made the effort to learn to code themselves and lean on others to make plugins for them)


Uninstall / Reinstall w/ overwrite.

Please note - This plugin adds a link in your footer, however it can be disabled via the AdminCP

Please, if you find this useful, don't disable this option.

[jrap]

Installed, thanks!

[Sadikb]

Hello Everyone. I installed this MOD and it's great.

A few pointers

1. Works absolutely perfectly with VB 3.8.1 PL1
2. For those who are complaining about the author's links, there is an option in AdminCP where you can turn links off..
3. You can make this MOD to send emails through the webmaster's email instead of the site's mail address. This is what you need to do.

Open remindermail.php in any editor.

Find the following CODE

if(is_valid_email($toemail)){				
	$sentlist .= "$username ";
	vbmail($toemail, $subject, $message, $notsubscription = false, $from = $vbulletin->options['bbtitle'], $uheaders = '', $username = '');

Replace it by

if(is_valid_email($toemail)){				
	$sentlist .= "$username ";
	vbmail($toemail, $subject, $message, $notsubscription = false, $from = $vbulletin->options['webmasteremail'], $uheaders = '', $username = '');

So basically instead of $from = $vbulletin->options['bbtitle'], you have to use $from = $vbulletin->options['webmasteremail']. This will sent email from the Webmaster's email address instead of the site/host email.

4. Some people were bothered by the daily mails it sends to the webmaster when it has mailed the inactive users. To prevent this MOD from emailing the webmaster every time, again open remindermail.php.

There at the end you will find an if-else condition:

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 = '');
	}

In the code above you have to comment out the vbmail function. So replace above code by

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 = '');*/
	}

You can still see whom the MOD has emailed by going to AdminCP-->Scheduled Task-->Scheduled Task Log and selecting "Inactive User reminder Emails" from the drop down, since this MOD still is logging.

Hope this helps out everyone.

Cheers

[Saviour]

Does anyone have this working on vB 3.8.2?

[Saviour]

Update...

Installed and seems to be working fine on vB 3.8.2.

[Sworm]

There's some knowed incompatibility with Cron based Email sending?
https://vborg.vbsupport.ru/showthread.php?t=201318

[Sworm]

Nobody support this hack?

[robertjandreu]

I check from time to tiime but I don't offer support anymore since there are already known new versions of this mod.

I was making a new stable version but got sidetracked by my VB --> WP bridge. If someone offers to help me out with this mod I'm open for help.

Robert-Jan de Dreu

[Sascha108]

What new versions are out there? Where do I find them?

After Install I get the following problem via mail:

-------------------

Database error in vBulletin 3.8.2:

Invalid SQL:
SELECT * FROM user WHERE lastactivity < '0' AND reminder_reminders = 0 AND options & 16 AND usergroupid IN('');

MySQL Error : Unknown column 'reminder_reminders' in 'where clause'
Error Number : 1054
Request Date : Monday, May 4th 2009 @ 04:22:52 PM
Error Date : Monday, May 4th 2009 @ 04:22:52 PM
Script : http://xyz.org/admincp/remindermail.php
Referrer : http://xyz.org/admincp/index.php?do=nav
IP Address : 80.136.94.51
Username : xxxxx
Classname : vB_Database
MySQL Version : 5.0.67-community

-----------------------

Any idea on how to fix that?

[Rakehel]

I'd like to know about "known new versions" too. This one doesn't seem to work consistently anymore. It worked great for months but I'm thinking the vB versions overtook it, or have all the inactive users tagged us as spam?

[jejuarez8]

anyone know why I am getting this message when an email is trying to be sent to a user?

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

It happens every time, even my own emails.