/**
* Send an email to the buyer
*
* @param string $status Order status (pending, paid, etc.)
* @param string $msg Optional message to include with email
*/
public function Notify($status = '', $gw_msg = '')
{
global $_CONF, $_PP_CONF, $_TABLES;
// Check if we're supposed to send a notification
if ($this->uid != 1 && $_PP_CONF['purch_email_user'] || $this->uid == 1 && $_PP_CONF['purch_email_anon']) {
PAYPAL_debug("Sending email to " . $this->uid);
// setup templates
$message = new Template(PAYPAL_PI_PATH . '/templates');
$message->set_file(array('subject' => 'purchase_email_subject.txt', 'msg_admin' => 'purchase_email_admin.txt', 'msg_user' => 'purchase_email_user.txt', 'msg_body' => 'purchase_email_body.txt'));
// Add all the items to the message
$total = (double) 0;
// Track total purchase value
$files = array();
// Array of filenames, for attachments
$num_format = "%5.2f";
$item_total = 0;
$have_physical = 0;
// Assume no physical items.
$dl_links = '';
// Start with empty download links
USES_paypal_class_product();
foreach ($this->items as $id => $item) {
if (!PAYPAL_is_plugin_item($item['product_id'])) {
$P = new Product($item['product_id']);
if ($P->prod_type & PP_PROD_PHYSICAL == PP_PROD_PHYSICAL) {
$have_physical = 1;
}
// Add the file to the filename array, if any. Download
// links are only included if the order status is 'paid'
$file = $P->file;
if (!empty($file) && $this->status == 'paid') {
$files[] = $file;
$dl_url = PAYPAL_URL . '/download.php?';
// There should always be a token, but fall back to the
// product ID if there isn't
if (!empty($item['token'])) {
$dl_url .= 'token=' . urlencode($item['token']);
} else {
$dl_url .= 'id=' . $item['item_number'];
}
$dl_links .= "<a href=\"{$dl_url}\">{$dl_url}</a><br />";
}
}
$ext = (double) $item['quantity'] * (double) $item['price'];
$item_total += $ext;
$item_descr = isset($item['description']) ? $item['description'] : $item['descrip'];
//$message->set_block('message', 'ItemList', 'List');
$opts = json_decode($item['options_text'], true);
if ($opts) {
foreach ($opts as $opt_text) {
$options_text .= " -- {$opt_text}<br />";
}
}
$message->set_block('msg_body', 'ItemList', 'List');
$message->set_var(array('qty' => $item['quantity'], 'price' => sprintf($num_format, $item['price']), 'ext' => sprintf($num_format, $ext), 'name' => $item_descr, 'options_text' => $options_text));
//PAYPAL_debug("Qty: {$item['quantity']} : Amount: {$item['price']} : Name: {$item['name']}", 'debug_ipn');
$message->parse('List', 'ItemList', true);
}
// Determine if files will be attached to this message based on
// global config and whether there are actually any files to
// attach. Affects the 'files' flag in the email template and
// which email function is used.
if ((is_numeric($this->uid) && $this->uid != 1 && $_PP_CONF['purch_email_user_attach'] || (!is_numeric($this->uid) || $this->uid == 1) && $_PP_CONF['purch_email_anon_attach']) && count($files) > 0) {
$do_send_attachments = true;
} else {
$do_send_attachments = false;
}
$total_amount = $item_total + $this->tax + $this->shipping + $this->handling;
$user_name = COM_getDisplayName($this->uid);
if ($this->billto_name == '') {
$this->billto_name = $user_name;
}
$message->set_var(array('payment_gross' => sprintf($num_format, $total_amount), 'payment_items' => sprintf($num_format, $item_total), 'tax' => sprintf($num_format, $this->tax), 'shipping' => sprintf($num_format, $this->shipping), 'handling' => sprintf($num_format, $this->handling), 'payment_date' => $_PP_CONF['now']->toMySQL(true), 'payer_email' => $this->buyer_email, 'payer_name' => $this->billto_name, 'site_name' => $_CONF['site_name'], 'txn_id' => $this->pmt_txn_id, 'pi_url' => PAYPAL_URL, 'pi_admin_url' => PAYPAL_ADMIN_URL, 'dl_links' => $dl_links, 'files' => $do_send_attachments ? 'true' : '', 'buyer_uid' => $this->uid, 'user_name' => $user_name, 'gateway_name' => $this->pmt_method, 'pending' => $this->status == 'pending' ? 'true' : '', 'gw_msg' => $gw_msg, 'status' => $this->status, 'order_instr' => $this->instructions));
// parse templates for subject/text
$subject = trim($message->parse('output', 'subject'));
$message->set_var('purchase_details', $message->parse('detail', 'msg_body'));
$user_text = $message->parse('user_out', 'msg_user');
$admin_text = $message->parse('admin_out', 'msg_admin');
if ($this->buyer_email != '') {
// if specified to mail attachment, do so, otherwise skip
// attachment
if ($do_send_attachments) {
// Make sure plugin functions are available
USES_paypal_functions();
PAYPAL_mailAttachment($this->buyer_email, $subject, $user_text, $_CONF['site_email'], true, 0, '', '', $files);
} else {
// Otherwise send a standard notification
COM_emailNotification(array('to' => array($this->buyer_email), 'from' => $_CONF['site_mail'], 'htmlmessage' => $user_text, 'subject' => $subject));
}
}
// Send a notification to the administrator, new purchases only
if ($status == '') {
if ($_PP_CONF['purch_email_admin'] == 2 || $have_physical && $_PP_CONF['purch_email_admin'] == 1) {
PAYPAL_debug('Sending email to Admin');
$email_addr = empty($_PP_CONF['admin_email_addr']) ? $_CONF['site_mail'] : $_PP_CONF['admin_email_addr'];
COM_emailNotification(array('to' => array($email_addr), 'from' => $_CONF['noreply_mail'], 'htmlmessage' => $admin_text, 'subject' => $subject));
}
}
}
}
/**
* User request for a new password - send email with a link and request id
*
* @param username string name of user who requested the new password
* @param msg int index of message to display (if any)
* @return string form or meta redirect
*
*/
function requestpassword($username, $msg = 0)
{
global $_CONF, $_TABLES, $LANG04;
$retval = '';
// no remote users!
$username = DB_escapeString($username);
$result = DB_query("SELECT uid,email,passwd,status FROM {$_TABLES['users']} WHERE username = '******' AND (account_type & " . LOCAL_USER . ")");
$nrows = DB_numRows($result);
if ($nrows == 1) {
$A = DB_fetchArray($result);
if ($_CONF['usersubmission'] == 1 && $A['status'] == USER_ACCOUNT_AWAITING_APPROVAL) {
echo COM_refresh($_CONF['site_url'] . '/index.php?msg=48');
}
$reqid = substr(md5(uniqid(rand(), 1)), 1, 16);
DB_change($_TABLES['users'], 'pwrequestid', "{$reqid}", 'uid', (int) $A['uid']);
$T = new Template($_CONF['path_layout'] . 'email/');
$T->set_file(array('html_msg' => 'mailtemplate_html.thtml', 'text_msg' => 'mailtemplate_text.thtml'));
$T->set_block('html_msg', 'content', 'contentblock');
$T->set_block('text_msg', 'contenttext', 'contenttextblock');
$T->set_var('content_text', sprintf($LANG04[88], $username));
$T->parse('contentblock', 'content', true);
$T->parse('contenttextblock', 'contenttext', true);
$T->set_var('url', $_CONF['site_url'] . '/users.php?mode=newpwd&uid=' . $A['uid'] . '&rid=' . $reqid);
$T->set_var('button_text', $LANG04[91]);
$T->parse('contentblock', 'content', true);
$T->parse('contenttextblock', 'contenttext', true);
$T->unset_var('button_text');
$T->set_var('content_text', $LANG04[89]);
$T->parse('contentblock', 'content', true);
$T->parse('contenttextblock', 'contenttext', true);
$T->set_var('site_url', $_CONF['site_url']);
$T->set_var('site_name', $_CONF['site_name']);
$T->set_var('title', $_CONF['site_name'] . ': ' . $LANG04[16]);
$T->parse('output', 'html_msg');
$mailhtml = $T->finish($T->get_var('output'));
$T->parse('textoutput', 'text_msg');
$mailtext = $T->finish($T->get_var('textoutput'));
$msgData['htmlmessage'] = $mailhtml;
$msgData['textmessage'] = $mailtext;
$msgData['subject'] = $_CONF['site_name'] . ': ' . $LANG04[16];
$msgData['from']['name'] = $_CONF['site_name'];
$msgData['from']['email'] = $_CONF['noreply_mail'];
$msgData['to']['email'] = $A['email'];
$msgData['to']['name'] = $username;
COM_emailNotification($msgData);
COM_updateSpeedlimit('password');
if ($msg) {
echo COM_refresh($_CONF['site_url'] . "/index.php?msg={$msg}");
} else {
echo COM_refresh($_CONF['site_url'] . '/index.php');
}
} else {
COM_updateSpeedlimit('password');
echo COM_refresh($_CONF['site_url'] . '/users.php?mode=getpassword');
exit;
}
return $retval;
}
/**
* Send new item notification emails
*
* @param string $type plugin name or comment
* @param string $category category type (i.e.; for comment it would contain
filemgmt, article, etc.)
* @param string $track_id id of item being tracked
* @param string $post_id id of new item posted (i.e.; comment id, media_id, etc.)
* @param int $post_uid user who posted item
* @return boolean true on succes, false on fail
* @since glFusion v1.3.0
*
*/
function PLG_sendSubscriptionNotification($type, $category, $track_id, $post_id, $post_uid)
{
global $_CONF, $_TABLES, $LANG04;
USES_lib_html2text();
$function = 'plugin_subscription_email_format_' . $type;
if (function_exists($function)) {
$args[1] = $category;
$args[2] = $track_id;
$args[3] = $post_id;
$args[4] = $post_uid;
list($htmlmsg, $textmsg, $imageData) = PLG_callFunctionForOnePlugin($function, $args);
} else {
COM_errorLog("PLG_sendSubscriptionNotification() - No plugin_subscription_email_format_ defined");
return false;
}
if ($track_id == 0) {
$sql = "SELECT {$_TABLES['subscriptions']}.uid,email,id FROM {$_TABLES['subscriptions']} LEFT JOIN {$_TABLES['users']} ON {$_TABLES['subscriptions']}.uid={$_TABLES['users']}.uid" . " WHERE {$_TABLES['users']}.status=" . USER_ACCOUNT_ACTIVE . " AND category='" . DB_escapeString($category) . "'" . " AND type='" . DB_escapeString($type) . "'";
} else {
$sql = "SELECT {$_TABLES['subscriptions']}.uid,email,id FROM {$_TABLES['subscriptions']} LEFT JOIN {$_TABLES['users']} ON {$_TABLES['subscriptions']}.uid={$_TABLES['users']}.uid" . " WHERE {$_TABLES['users']}.status=" . USER_ACCOUNT_ACTIVE . " AND category='" . DB_escapeString($category) . "'" . " AND id='" . DB_escapeString($track_id) . "'" . " AND type='" . DB_escapeString($type) . "'";
}
$result = DB_query($sql);
$nrows = DB_numRows($result);
$messageData = array();
$messageData['subject'] = $LANG04[184];
$messageData['from'] = $_CONF['noreply_mail'];
$messageData['htmlmessage'] = $htmlmsg;
$messageData['textmessage'] = $textmsg;
if (is_array($imageData) && count($imageData) > 0) {
$messageData['embeddedImage'] = $imageData;
}
$to = array();
while (($S = DB_fetchArray($result)) != NULL) {
if ($S['uid'] == $post_uid) {
// skip author
continue;
}
if ($S['id'] < 0) {
// allows exclude records...
continue;
}
$to[] = $S['email'];
}
$messageData['to'] = $to;
COM_emailNotification($messageData);
return true;
}
function MG_sendPostCard()
{
global $MG_albums, $_MG_CONF, $_CONF, $_TABLES, $_USER, $LANG_MG00, $LANG_MG02, $LANG_MG03, $LANG_ACCESS, $_POST;
global $LANG_DIRECTION, $LANG_CHARSET;
$mid = COM_sanitizeID(COM_applyFilter($_POST['mid'], true));
$toname = COM_applyFilter($_POST['toname']);
$toemail = COM_applyFilter($_POST['toemail']);
$fromname = COM_applyFilter($_POST['fromname']);
$fromemail = COM_applyFilter($_POST['fromemail']);
$subject = strip_tags(COM_checkWords($_POST['subject']));
$message = htmlspecialchars(strip_tags(COM_checkWords($_POST['message'])));
$ccself = isset($_POST['ccself']) ? 1 : 0;
$errCount = 0;
$msg = '';
if (!COM_isEmail($toemail)) {
$errCount++;
}
if (!COM_isEmail($fromemail)) {
$errCount++;
}
if (empty($subject)) {
$errCount++;
}
if (empty($message)) {
$errCount++;
}
$captchaString = isset($_POST['captcha']) ? $_POST['captcha'] : '';
$msg = PLG_itemPreSave('mediagallery', $captchaString);
if ($msg != '') {
$errCount++;
}
if ($errCount > 0) {
return MG_editPostCard('edit', $mid, $msg);
}
$retval = '';
$aid = DB_getItem($_TABLES['mg_media_albums'], 'album_id', 'media_id="' . DB_escapeString($mid) . '"');
if ($MG_albums[$aid]->access == 0 || $MG_albums[$aid]->enable_postcard == 0 || COM_isAnonUser() && $MG_albums[$aid]->enable_postcard != 2) {
$retval = MG_siteHeader();
$retval .= COM_showMessageText($LANG_MG00['access_denied_msg'], $LANG_ACCESS['accessdenied'], true);
$retval .= MG_siteFooter();
echo $retval;
exit;
}
$sql = "SELECT * FROM {$_TABLES['mg_media_albums']} as ma LEFT JOIN " . $_TABLES['mg_media'] . " as m " . " ON ma.media_id=m.media_id WHERE m.media_id='" . DB_escapeString($mid) . "'";
$result = DB_query($sql);
$nRows = DB_numRows($result);
if ($nRows < 1) {
$retval = MG_siteHeader();
$retval .= COM_showMessageText($LANG_MG00['access_denied_msg'], $LANG_ACCESS['accessdenied'], true);
$retval .= MG_siteFooter();
echo $retval;
exit;
}
$M = DB_fetchArray($result);
// trim the database
$purgeDate = time() - $_MG_CONF['postcard_retention'] * 86400;
DB_query("DELETE FROM {$_TABLES['mg_postcard']} WHERE pc_time < " . $purgeDate);
// save this one in the database
$newsubject = DB_escapeString($subject);
$newmessage = DB_escapeString($message);
$pcId = COM_makesid();
$pc_time = time();
if (COM_isAnonUser()) {
$uid = 1;
} else {
$uid = (int) $_USER['uid'];
}
$sql = "INSERT INTO {$_TABLES['mg_postcard']} (pc_id,mid,to_name,to_email,from_name,from_email,subject,message,pc_time,uid) VALUES ('{$pcId}','" . DB_escapeString($mid) . "','" . DB_escapeString($toname) . "','" . DB_escapeString($toemail) . "','" . DB_escapeString($fromname) . "','" . DB_escapeString($fromemail) . "','{$newsubject}','{$newmessage}',{$pc_time},{$uid})";
$result = DB_query($sql);
if (DB_error()) {
COM_errorLog("Media Gallery: Error saving postcard");
}
COM_clearSpeedlimit($_CONF['commentspeedlimit'], 'mgpostcard');
$last = COM_checkSpeedlimit('mgpostcard');
if ($last > 0) {
$msg = sprintf($LANG_MG02['postcard_speedlimit'], $last);
return MG_errorHandler($msg);
}
$alternate_link = $_MG_CONF['site_url'] . '/getcard.php?id=' . $pcId;
// build the template...
$T = new Template(MG_getTemplatePath($aid));
$T->set_file('postcard', 'postcard.thtml');
$media_size = @getimagesize($_MG_CONF['path_mediaobjects'] . 'tn/' . $M['media_filename'][0] . '/' . $M['media_filename'] . '.jpg');
if (empty($LANG_DIRECTION)) {
// default to left-to-right
$direction = 'ltr';
} else {
$direction = $LANG_DIRECTION;
}
if (empty($LANG_CHARSET)) {
$charset = $_CONF['default_charset'];
if (empty($charset)) {
$charset = 'iso-8859-1';
}
} else {
$charset = $LANG_CHARSET;
}
$T->set_var(array('s_form_action' => $_MG_CONF['site_url'] . '/postcard.php', 'direction' => $direction, 'charset' => $charset, 'mid' => $mid, 'media_title' => $M['media_title'], 'alt_media_title' => htmlspecialchars(strip_tags($M['media_title'])), 'media_description' => isset($M['media_description']) ? $M['media_description'] : '', 'media_url' => $_MG_CONF['site_url'] . '/media.php?s=' . $mid, 'media_image' => $_MG_CONF['mediaobjects_url'] . '/disp/' . $M['media_filename'][0] . '/' . $M['media_filename'] . '.jpg', 'site_url' => $_MG_CONF['site_url'] . '/', 'postcard_subject' => $subject, 'postcard_message' => nl2br($message), 'from_email' => $fromemail, 'site_name' => $_CONF['site_name'], 'site_slogan' => $_CONF['site_slogan'], 'to_name' => $toname, 'from_name' => $fromname, 'pc_id' => $pcId, 'lang_to_name' => $LANG_MG03['to_name'], 'lang_to_email' => $LANG_MG03['to_email'], 'lang_from_name' => $LANG_MG03['from_name'], 'lang_from_email' => $LANG_MG03['from_email'], 'lang_subject' => $LANG_MG03['subject'], 'lang_send' => $LANG_MG03['send'], 'lang_cancel' => $LANG_MG03['cancel'], 'lang_preview' => $LANG_MG03['preview'], 'lang_unable_view' => $LANG_MG03['unable_to_view_postcard'], 'lang_postcard_from' => $LANG_MG03['postcard_from'], 'lang_to' => $LANG_MG03['to'], 'lang_from' => $LANG_MG03['from'], 'lang_visit' => $LANG_MG03['visit']));
$T->parse('output', 'postcard');
$retval .= $T->finish($T->get_var('output'));
$msgData['subject'] = htmlspecialchars($subject);
$msgData['htmlmessage'] = $retval;
$msgData['textmessage'] = sprintf($LANG_MG03['text_body_email'], $fromname, $alternate_link);
$msgData['from']['email'] = $fromemail;
$msgData['from']['name'] = $fromname;
$msgData['to'][] = array('email' => $toemail, 'name' => $toname);
if ($ccself) {
$msgData['to'][] = array('email' => $fromemail, 'name' => $fromname);
}
foreach ($_MG_CONF['validExtensions'] as $tnext) {
if (file_exists($_MG_CONF['path_mediaobjects'] . 'disp/' . $M['media_filename'][0] . '/' . $M['media_filename'] . $tnext)) {
$msgData['embeddedImage'][] = array('file' => $_MG_CONF['path_mediaobjects'] . 'disp/' . $M['media_filename'][0] . '/' . $M['media_filename'] . $tnext, 'name' => "pc-image", 'filename' => $M['media_original_filename'], 'encoding' => 'base64', 'mime' => $M['mime_type']);
}
}
$msgData['embeddedImage'][] = array('file' => MG_getImageFilePath('stamp.gif'), 'name' => "stamp", 'filename' => 'stamp.gif', 'encoding' => 'base64', 'mime' => 'image/gif');
COM_emailNotification($msgData);
$msgNo = 8;
// update the sent post card database...Or maybe just log it in an error log?
$logentry = $fromname . " sent a postcard to " . $toname . " (" . $toemail . ") using media id " . $mid;
MG_postcardLog($logentry);
COM_updateSpeedlimit('mgpostcard');
header("Location: " . $_MG_CONF['site_url'] . '/media.php?msg=' . $msgNo . '&s=' . $mid);
exit;
}
function FM_notifyAdmins($filename, $file_user_id, $description)
{
global $LANG_DIRECTION, $LANG_CHARSET, $LANG_FM00, $_USER, $_FM_CONF, $_CONF, $_TABLES;
$html = false;
$altBody = '';
$to = array();
$body = '';
$description = stripslashes($description);
// already escaped for db
if (empty($LANG_DIRECTION)) {
// default to left-to-right
$direction = 'ltr';
} else {
$direction = $LANG_DIRECTION;
}
if (empty($LANG_CHARSET)) {
$charset = $_CONF['default_charset'];
if (empty($charset)) {
$charset = 'iso-8859-1';
}
} else {
$charset = $LANG_CHARSET;
}
COM_clearSpeedlimit(300, 'fmnotify');
$last = COM_checkSpeedlimit('fmnotify');
if ($last == 0) {
$html = true;
$subject = $LANG_FM00['new_upload'] . $_CONF['site_name'];
if (!isset($file_user_id) || $file_user_id < 2) {
$uname = 'Anonymous';
} else {
$uname = DB_getItem($_TABLES['users'], 'username', 'uid=' . intval($file_user_id));
}
// build the template...
$T = new Template($_CONF['path'] . 'plugins/filemgmt/templates');
$T->set_file('email', 'notifyemail.thtml');
$T->set_var(array('direction' => $direction, 'charset' => $charset, 'lang_new_upload' => $LANG_FM00['new_upload_body'], 'lang_details' => $LANG_FM00['details'], 'lang_filename' => $LANG_FM00['filename'], 'lang_uploaded_by' => $LANG_FM00['uploaded_by'], 'username' => $uname, 'filename' => $filename, 'description' => $description, 'url_moderate' => '<a href="' . $_CONF['site_admin_url'] . '/plugins/filemgmt/index.php?op=listNewDownloads">Click here to view</a>', 'site_name' => $_CONF['site_name'] . ' - ' . $_CONF['site_slogan'], 'site_url' => $_CONF['site_url']));
$T->parse('output', 'email');
$body .= $T->finish($T->get_var('output'));
$altbody = $LANG_FM00['new_upload_body'] . $_CONF['site_name'];
$altbody .= "\n\r\n\r";
$altbody .= $LANG_FM00['details'];
$altbody .= "\n\r";
$altbody .= $LANG_FM00['filename'] . ' ' . $filename . "\n\r";
$altbody .= "\n\r";
$altbody .= $description . "\n\r";
$altbody .= "\n\r";
$altbody .= $LANG_FM00['uploaded_by'] . ' ' . $uname . "\n\r";
$altbody .= "\n\r\n\r";
$altbody .= $_CONF['site_name'] . "\n\r";
$altbody .= $_CONF['site_url'] . "\n\r";
$group_id = DB_getItem($_TABLES['groups'], 'grp_id', 'grp_name="filemgmt Admin"');
$groups = FM_getGroupList($group_id);
if (count($groups) == 0) {
$groupList = '1';
} else {
$groupList = implode(',', $groups);
}
$sql = "SELECT DISTINCT {$_TABLES['users']}.uid,username,fullname,email " . "FROM {$_TABLES['group_assignments']},{$_TABLES['users']} " . "WHERE {$_TABLES['users']}.uid > 1 " . "AND {$_TABLES['users']}.uid = {$_TABLES['group_assignments']}.ug_uid " . "AND ({$_TABLES['group_assignments']}.ug_main_grp_id IN ({$groupList}))";
$result = DB_query($sql);
$nRows = DB_numRows($result);
$toCount = 0;
for ($i = 0; $i < $nRows; $i++) {
$row = DB_fetchArray($result);
if ($row['email'] != '') {
COM_errorLog("FileMgmt Upload: Sending notification email to: " . $row['email'] . " - " . $row['username']);
$toCount++;
$to[] = array('email' => $row['email'], 'name' => $row['username']);
}
}
if ($toCount > 0) {
$msgData['htmlmessage'] = $body;
$msgData['textmessage'] = $altBody;
$msgData['subject'] = $subject;
$msgData['from']['email'] = $_CONF['site_mail'];
$msgData['from']['name'] = $_CONF['site_name'];
$msgData['to'] = $to;
COM_emailNotification($msgData);
} else {
COM_errorLog("FileMgmt Upload: Error - Did not find any administrators to email");
}
COM_updateSpeedlimit('fmnotify');
}
return true;
}
function _ff_chknotifications($forumid, $topicid, $userid, $type = 'topic')
{
global $_TABLES, $LANG_GF01, $LANG_GF02, $_CONF, $_FF_CONF;
$msgData = array();
if (!$_FF_CONF['allow_notification']) {
return;
}
$pid = DB_getItem($_TABLES['ff_topic'], 'pid', 'id=' . (int) $topicid);
if ($pid == 0 || $pid == '') {
$pid = $topicid;
}
$grp_id = DB_getItem($_TABLES['ff_forums'], 'grp_id', 'forum_id=' . (int) $forumid);
if ($grp_id == 0 || $grp_id == '') {
$grp_id = 1;
}
$sql = "SELECT * FROM {$_TABLES['subscriptions']} WHERE type='forum' AND ((category=" . (int) $forumid . " AND id=" . (int) $pid . ") OR (category=" . (int) $forumid . " AND id=0 )) GROUP BY uid";
$sqlresult = DB_query($sql);
$postername = COM_getDisplayName($userid);
$nrows = DB_numRows($sqlresult);
$messageBody = '';
if ($nrows > 0) {
// we have some subscription records, build the emails
$topicrec = DB_query("SELECT subject,name,forum,last_reply_rec FROM {$_TABLES['ff_topic']} WHERE id=" . (int) $pid);
$A = DB_fetchArray($topicrec);
$forum_name = DB_getItem($_TABLES['ff_forums'], 'forum_name', "forum_id=" . (int) $forumid);
if ($type == 'forum') {
$digestSubject = $forum_name;
$digestSubject .= ": ";
$digestSubject .= $A['subject'];
$messageBody .= sprintf($LANG_GF02['msg23a'], $A['subject'], $postername, $A['name'], $_CONF['site_name']);
$last_reply_rec = DB_getItem($_TABLES['ff_forums'], 'last_post_rec', "forum_id=" . (int) $forumid);
} else {
if ($A['last_reply_rec'] != '' && $A['last_reply_rec'] != 0) {
$last_reply_rec = $A['last_reply_rec'];
} else {
$last_reply_rec = $topicid;
}
$digestSubject = $forum_name;
$digestSubject .= ": RE: ";
$digestSubject .= $A['subject'];
$messageBody .= sprintf($LANG_GF02['msg23b'], $A['subject'], $A['name'], $forum_name, $_CONF['site_name'], $_CONF['site_url'], $pid);
// $messageBody .= sprintf($LANG_GF02['msg23a'],$A['subject'],$postername, $A['name'],$_CONF['site_name']);
$messageBody .= sprintf($LANG_GF02['msg23c'], $_CONF['site_url'], $pid, $last_reply_rec);
}
$messageBody .= $LANG_GF02['msg26'];
$messageBody .= sprintf($LANG_GF02['msg27'], "{$_CONF['site_url']}/forum/notify.php");
$messageBody .= "{$LANG_GF02['msg25']}{$_CONF['site_name']} {$LANG_GF01['ADMIN']}\n";
list($digestMessage, $digestMessageText) = gfm_getoutput($last_reply_rec);
} else {
return;
}
$msgDataDigest['subject'] = $digestSubject;
$msgDataDigest['from'] = $_CONF['noreply_mail'];
$msgDataDigest['htmlmessage'] = $digestMessage;
$msgDataDigest['textmessage'] = $digestMessageText;
$toDigest = array();
$msgDataNotify['subject'] = "{$_CONF['site_name']} {$LANG_GF02['msg22']}";
$msgDataNotify['from'] = $_CONF['noreply_mail'];
$msgDataNotify['textmessage'] = $messageBody;
$toNotify = array();
for ($i = 1; $i <= $nrows; $i++) {
$N = DB_fetchArray($sqlresult);
// Don't need to send a notification to the user that posted this message and users with NOTIFY disabled
if ($N['uid'] > 1 and $N['uid'] != $userid) {
// if the topic_id is 0 for this record - user has subscribed to complete forum. Check if they have opted out of this forum topic.
if (DB_count($_TABLES['subscriptions'], array('type', 'uid', 'category', 'id'), array('forum', $N['uid'], $forumid, -$topicid)) == 0) {
// Check if user does not want to receive multiple notifications for same topic and already has been notified
$userNotifyOnceOption = DB_getItem($_TABLES['ff_userprefs'], 'notify_once', "uid=" . (int) $N['uid']);
// Retrieve the log record for this user if it exists then check if user has viewed this topic yet
// The logtime value may be 0 which indicates the user has not yet viewed the topic
$lsql = DB_query("SELECT time FROM {$_TABLES['ff_log']} WHERE uid=" . (int) $N['uid'] . " AND forum=" . (int) $forumid . " AND topic=" . (int) $topicid);
if (DB_numRows($lsql) == 1) {
$nologRecord = false;
list($logtime) = DB_fetchArray($lsql);
} else {
$nologRecord = true;
$logtime = 0;
}
if ($userNotifyOnceOption == 0 or $userNotifyOnceOption == 1 and ($nologRecord or $logtime != 0)) {
$userrec = DB_query("SELECT username,email,status FROM {$_TABLES['users']} WHERE uid=" . (int) $N['uid']);
$B = DB_fetchArray($userrec);
if ($B['status'] == USER_ACCOUNT_ACTIVE && SEC_inGroup($grp_id, (int) $N['uid'])) {
if ($nologRecord and $userNotifyOnceOption == 1) {
DB_query("INSERT INTO {$_TABLES['ff_log']} (uid,forum,topic,time) VALUES (" . (int) $N['uid'] . ", " . (int) $forumid . ", " . (int) $topicid . ",'0') ");
}
$notifyfull = DB_getItem($_TABLES['ff_userprefs'], 'notify_full', "uid=" . (int) $N['uid']);
if ($notifyfull) {
$toDigest[] = $B['email'];
} else {
$toNotify[] = $B['email'];
}
} else {
// remove the watch entry since this user can no longer access the forum.
DB_query("DELETE FROM {$_TABLES['subscriptions']} WHERE type='forum' AND uid=" . $N['uid'] . " AND ((id=" . (int) $pid . ") OR ((category=" . (int) $forumid . ") AND (id=0) ))");
}
}
}
}
}
$msgDataDigest['to'] = $toDigest;
$msgDataNotify['to'] = $toNotify;
COM_emailNotification($msgDataDigest);
COM_emailNotification($msgDataNotify);
}
function MG_notifyModerators($aid)
{
global $LANG_DIRECTION, $LANG_CHARSET, $_USER, $MG_albums, $_MG_CONF, $_CONF, $_TABLES, $LANG_MG01;
$to = array();
if ($MG_albums[$aid]->moderate != 1 || $MG_albums[0]->owner_id) {
return true;
}
$body = '';
$media_user_id = $_USER['uid'];
if (empty($LANG_DIRECTION)) {
// default to left-to-right
$direction = 'ltr';
} else {
$direction = $LANG_DIRECTION;
}
if (empty($LANG_CHARSET)) {
$charset = $_CONF['default_charset'];
if (empty($charset)) {
$charset = 'iso-8859-1';
}
} else {
$charset = $LANG_CHARSET;
}
COM_clearSpeedlimit(600, 'mgnotify');
$last = COM_checkSpeedlimit('mgnotify');
if ($last == 0) {
$subject = $LANG_MG01['new_upload_subject'] . $_CONF['site_name'];
if (COM_isAnonUser()) {
$uname = 'Anonymous';
} else {
$uname = DB_getItem($_TABLES['users'], 'username', 'uid=' . $media_user_id);
}
// build the template...
$T = new Template(MG_getTemplatePath($aid));
$T->set_file('email', 'modemail.thtml');
$T->set_var(array('direction' => $direction, 'charset' => $charset, 'lang_new_upload' => $LANG_MG01['new_upload_body'], 'lang_details' => $LANG_MG01['details'], 'lang_album_title' => 'Album', 'lang_uploaded_by' => $LANG_MG01['uploaded_by'], 'username' => $uname, 'album_title' => strip_tags($MG_albums[$aid]->title), 'url_moderate' => '<a href="' . $_MG_CONF['site_url'] . '/admin.php?album_id=' . $aid . '&mode=moderate">Click here to view</a>', 'site_name' => $_CONF['site_name'] . ' - ' . $_CONF['site_slogan'], 'site_url' => $_CONF['site_url']));
$T->parse('output', 'email');
$body .= $T->finish($T->get_var('output'));
$altbody = $LANG_MG01['new_upload_body'] . $MG_albums[$aid]->title;
$altbody .= "\n\r\n\r";
$altbody .= $LANG_MG01['details'];
$altbody .= "\n\r";
$altbody .= $LANG_MG01['uploaded_by'] . ' ' . $uname . "\n\r";
$altbody .= "\n\r\n\r";
$altbody .= $_CONF['site_name'] . "\n\r";
$altbody .= $_CONF['site_url'] . "\n\r";
$groups = MG_getGroupList($MG_albums[$aid]->mod_group_id);
$groupList = implode(',', $groups);
$sql = "SELECT DISTINCT {$_TABLES['users']}.uid,username,fullname,email " . "FROM {$_TABLES['group_assignments']},{$_TABLES['users']} " . "WHERE {$_TABLES['users']}.uid > 1 " . "AND {$_TABLES['users']}.uid = {$_TABLES['group_assignments']}.ug_uid " . "AND ({$_TABLES['group_assignments']}.ug_main_grp_id IN ({$groupList}))";
$result = DB_query($sql);
$nRows = DB_numRows($result);
$toCount = 0;
for ($i = 0; $i < $nRows; $i++) {
$row = DB_fetchArray($result);
if ($row['email'] != '') {
if ($_MG_CONF['verbose']) {
COM_errorLog("MG Upload: Sending notification email to: " . $row['email'] . " - " . $row['username']);
}
$toCount++;
$to[] = array('email' => $row['email'], 'name' => $row['username']);
}
}
if ($toCount > 0) {
$msgData['htmlmessage'] = $body;
$msgData['textmessage'] = $altBody;
$msgData['subject'] = $subject;
$msgData['from']['email'] = $_CONF['site_mail'];
$msgData['from']['name'] = $_CONF['site_name'];
$msgData['to'] = $to;
COM_emailNotification($msgData);
} else {
COM_errorLog("MG Upload: Error - Did not find any moderators to email");
}
COM_updateSpeedlimit('mgnotify');
}
return true;
}
