vb.org Archive - Mini Mods - Email reminder for inactive users

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)

- - Mini Mods - Email reminder for inactive users (https://vborg.vbsupport.ru/showthread.php?t=165317)

Email reminder for inactive users

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

Thank you, will install.

I have no problems with mine :(

Quote:

Originally Posted by iogames (Post 1402363)

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!

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?

Quote:

Originally Posted by hornstar1337 (Post 1402466)

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 ;)..

how to upgrade from previous version?

Fantastic. Thank you. :)

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

Quote:

Originally Posted by yahoooh (Post 1402699)

how to upgrade from previous version?

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

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!

Quote:

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

Installed, checking it out now...

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?

is this going to be ported for 3.7?

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

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

Code:

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

Found  Inactive Users.

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! :(

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

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! :(

**Uninstalled** No support :mad:

Just installed, hope it works OK : |

This one is works! thanks dude!

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

Code:

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

Installed. Thank you.

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

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02669 seconds Memory Usage 1,807KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (28)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: