CMS  Version 3.9
send_daily_digest.inc File Reference

Go to the source code of this file.

Variables

 $today = now()
 
 $yesterday = date('Y/m/d H:i:s', mktime(date("H"), date("i"), date("s"), date("m"), date("d")-1, date("y")))
 
 $messages = groupedQuery(ForumMessage, "WHERE last_modified BETWEEN '$yesterday' AND '$today' ORDER BY last_modified", "topic_id")
 
if(count($messages)==0) $topics = indexedQuery(ForumTopic, "", "topic_id")
 
global $config
 
if(count($messages) > 0) $forumKeys = implode(",", array_keys(reindexList($messages, "forum_id")))
 
 $forums = indexedQuery(Forum, "WHERE forum_id IN ($forumKeys)", "forum_id")
 
 $forumSubscribers = groupedQuery(ForumSubscription, "WHERE forum_id IN ($forumKeys) AND subscription_type = ".subscription_daily_digest, "forum_id")
 
 $forumTopics = reindexList($topics, "forum_id")
 
if(count($forumSubscribers) > 0) $mgr = new UserManager()
 
 $userClass = $mgr->getUserClass()
 
 $emailField = $mgr->getEmailField()
 
 $userClassObj = new $userClass()
 
 $pk = $userClassObj->getPrimaryKey()
 
 $subscribers = indexedQuery($userClass, "WHERE $pk IN (SELECT user_id FROM forum_subscription)", $pk)
 
 $subject = $config["sitename"] . " Daily Forum Digest"
 
 $messageFooter = SubscriptionManager::formatUnsubscribeMessageFooter()
 

Variable Documentation

◆ $config

global $config

Definition at line 42 of file send_daily_digest.inc.

◆ $emailField

$emailField = $mgr->getEmailField()

Definition at line 125 of file send_daily_digest.inc.

◆ $forumKeys

if (count( $messages) > 0) $forumKeys = implode(",", array_keys(reindexList($messages, "forum_id")))

Definition at line 79 of file send_daily_digest.inc.

◆ $forums

$forums = indexedQuery(Forum, "WHERE forum_id IN ($forumKeys)", "forum_id")

Definition at line 80 of file send_daily_digest.inc.

◆ $forumSubscribers

$forumSubscribers = groupedQuery(ForumSubscription, "WHERE forum_id IN ($forumKeys) AND subscription_type = ".subscription_daily_digest, "forum_id")

Definition at line 81 of file send_daily_digest.inc.

◆ $forumTopics

$forumTopics = reindexList($topics, "forum_id")

Definition at line 83 of file send_daily_digest.inc.

◆ $messageFooter

Definition at line 130 of file send_daily_digest.inc.

◆ $messages

$messages = groupedQuery(ForumMessage, "WHERE last_modified BETWEEN '$yesterday' AND '$today' ORDER BY last_modified", "topic_id")

Definition at line 32 of file send_daily_digest.inc.

◆ $mgr

if (count( $forumSubscribers) > 0) $mgr = new UserManager()

Definition at line 123 of file send_daily_digest.inc.

◆ $pk

$pk = $userClassObj->getPrimaryKey()

Definition at line 127 of file send_daily_digest.inc.

◆ $subject

$subject = $config["sitename"] . " Daily Forum Digest"

Definition at line 129 of file send_daily_digest.inc.

◆ $subscribers

$subscribers = indexedQuery($userClass, "WHERE $pk IN (SELECT user_id FROM forum_subscription)", $pk)

Definition at line 128 of file send_daily_digest.inc.

◆ $today

$today = now()

Definition at line 29 of file send_daily_digest.inc.

◆ $topics

if (count( $messages)==0) $topics = indexedQuery(ForumTopic, "", "topic_id")

Definition at line 40 of file send_daily_digest.inc.

◆ $userClass

$userClass = $mgr->getUserClass()

Definition at line 124 of file send_daily_digest.inc.

◆ $userClassObj

$userClassObj = new $userClass()

Definition at line 126 of file send_daily_digest.inc.

◆ $yesterday

$yesterday = date('Y/m/d H:i:s', mktime(date("H"), date("i"), date("s"), date("m"), date("d")-1, date("y")))

Definition at line 30 of file send_daily_digest.inc.