View Full Version : Email update for every post
Chimpie
05-14-2012, 12:46 PM
I have a client that wants an email update to be sent out for every new post in a thread someone subscribes to, not just a single email with the quote, "There may also be other replies, but you will not receive any more notifications until you visit the forum again."
I've Googled and searched on here but can't find anything for members, just for Mods/Admins.
Am I missing it?
This is for vB 3.8.x.
Thanks,
Chimpie
There is no option to do that, you'd have to modify the code.
Chimpie
05-14-2012, 01:03 PM
Thanks (as always) KH.
Can you say what code I need to change?
Well the notices are sent from includes/functions_newpost.php around line 1401 (in vb3.8.7 PL2, but it's probably almost the same in other versions). There's this query:
//If the target user's location is the same as the current user, then don't send them
//a notification.
$useremails = $vbulletin->db->query_read_slave("
SELECT user.*, subscribethread.emailupdate, subscribethread.subscribethreadid
FROM " . TABLE_PREFIX . "subscribethread AS subscribethread
INNER JOIN " . TABLE_PREFIX . "user AS user ON (subscribethread.userid = user.userid)
LEFT JOIN " . TABLE_PREFIX . "usergroup AS usergroup ON (usergroup.usergroupid = user.usergroupid)
LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON (usertextfield.userid = user.userid)
WHERE subscribethread.threadid = $threadid AND
subscribethread.emailupdate IN (1, 4) AND
subscribethread.canview = 1 AND
" . ($userid ? "CONCAT(' ', IF(usertextfield.ignorelist IS NULL, '', usertextfield.ignorelist), ' ') NOT LIKE '% " . intval($userid) . " %' AND" : '') . "
user.usergroupid <> 3 AND
user.userid <> " . intval($userid) . " AND
user.lastactivity >= " . intval($lastposttime['dateline']) . " AND
(usergroup.genericoptions & " . $vbulletin->bf_ugp_genericoptions['isnotbannedgroup'] . ")
");
I think if you take out the line in red it will send an email for every reply.
Probably it was done that way to avoid sending many emails (as you can imagine, a popular thread with a lot of activity could require quite a few). But I guess you probably realize that and understand what you're getting in to.
There's also a daily summary that you can subscribe to, but I assumed that you knew that and you don't want once a day emails. But another approach might be to try to modify that to happen more often, like every 5 or 10 minutes. (I haven't looked in to that at all).
Chimpie
05-14-2012, 06:59 PM
Probably it was done that way to avoid sending many emails (as you can imagine, a popular thread with a lot of activity could require quite a few). But I guess you probably realize that and understand what you're getting in to.
There's also a daily summary that you can subscribe to, but I assumed that you knew that and you don't want once a day emails. But another approach might be to try to modify that to happen more often, like every 5 or 10 minutes. (I haven't looked in to that at all).
Thanks. Yeah, I know what I'm getting into. I'm just afraid that the client doesn't.
That's part of the job though.... education.
--------------- Added 1337041266 at 1337041266 ---------------
Deleting that line does allow emails to be sent out every time a post is made. Thanks.
Chimpie
05-16-2012, 03:14 PM
Okay, the client has changed their mind. He now wants to change the look of the Forum Digest.
Instead of just breaking it down into two sections, new threads and updated threads, he wants the content of the threads to be posted as well. So it will look like:
The following threads are new:
********
Thread title
Link
Started by
Post content
Posted by
Post content
Posted by
Post content
********
(next new thread)
Thread title
Link
Started by
Post content
Posted by
Post content
Posted by
Post content
The following threads are updated:
********
Thread title
Link
Started by
Post content
Posted by
Post content
Posted by
Post content
Repeated
I'm thinking I need to add $postbits and/or $pagetext some place, but I'm just not sure.
Thoughts?
vBulletin® v3.8.12 by vBS, Copyright ©2000-2025, vBulletin Solutions Inc.