Email reminder for inactive users

[technom8t]

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.

PLEASE NOTE I HAD SOME PROBLEMS WITH THE LAST RELEASE SO BASICALLY THIS IS A CARRY ON FROM - https://vborg.vbsupport.ru/showthread.php?t=138946

[chuchukuttie]

Thank you, will install.

[iogames]

I have no problems with mine :(

[SpArKs85]

I have no problems with mine :(

Yet, so glum ;)

Install! Working great, no problems so far. One minor though. The link in the products page in the admincp points to the 3.6.4 version of this hack. :)

Thanks!

[oicyu8chu]

Nice! Thanks man.

[Hornstar]

Thanks, what do most people like to say to inactive members? Just tell them about some of the new stuff on the site they can enjoy? and some of the fun they are missing out on :p What do you guys usually say to them?

[bokmade]

Thanks, what do most people like to say to inactive members? Just tell them about some of the new stuff on the site they can enjoy? and some of the fun they are missing out on :p What do you guys usually say to them?

One Day I Received Email From Site I Never Visited Since 2004 Almost Three Years They told Me We Will Gonna To Del You Account :p..

Nothing Just Inform Them About The Forum Again With New Thread ..

Just Keep In Mind Remind Them With There User Name ;)..

[yahoooh]

how to upgrade from previous version?

[projectego]

Fantastic. Thank you. :)

[Lea Verou]

Is it possible with this mod to only send the mail once to each user during his whole lifetime as a member?

[rwoscott]

how to upgrade from previous version?
Yeh, I'm on 1.1.1 of the other version, how do you upgrade??

[corbis]

i was wondering of you could add a option to change who the email is sent from, not just the webmaster or w/e Thanks, great mod!

[popowich]

Date: 25 Dec 2007 11:20:45 -0000
From: Discuss New York <"Discuss New York"@mail.wnypoker.com>,
Discuss New York Reminder Service <forums@discussny.com>
To: forums@discussny.com
Subject: Inactive User Reminder Email Report



Hello,

How can I fix the double "from:" ?

All of the other e-mails from the server are OK.

Do I have English someplace in my admincp where an e-mail address should be?

-Raymond

[MikeHolohan]

Installed, checking it out now...

[Keyser S?ze]

this is great mod i have had alot of old members return thanks to it, i just wish i could turn off the one that comes to me each night

i have n need for that, possible?

[dirtycrow]

is this going to be ported for 3.7?

[raubin]

I have seen this on loads of other forum sites and wondered where the hell they had got this from, should have known ah!

All installed, lets see if it works....

[Alibass]

I am running 3.6.8PL2 and MySQLi and I am getting this error when running cron job:

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

[Alibass]

I see this hack was released Dec 2007 and almost 2 months later and 2 pages of posts there has been no replies from the author. I thought this hack was supported? I guess then I shouldn't count on a answer or reply to my post! :(

[TheInsaneManiac]

Is this your modification and you changed your name or are you just modifying C Braithwaite's modification?

[Alibass]

The only version I have ever got to work is C. Braithwaite's v1.09
Even his 1.11 never worked right. I was hoping this 1.11 would and also work on 3.7 when released. From the looks of things this wont happen! :(

[Alibass]

**Uninstalled** No support :mad:

[piraterevival]

Just installed, hope it works OK : |

[msamm]

Thank you

[Hannan]

This one is works! thanks dude!

[Martin-TMGRS]

I've just installed this and when i run the cron job I get this come up. Any help would be great please.

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

[trilogy33]

Installed. Thank you.

[ovnnet]

Use at your own risk. I used this mod six month ago, my forum was unable to access because all server performance was used for email. I did'nt find out the problem until i saw more than 60k email in emailqueue table. That's why my forum cannot run. Before find out this problem i had to buy new host (Because i think the problem is the server). Hope everyone understand and use carefully. Thank you