New Email » '; } printHeader("Email", 1); require_once 'email.inc'; clearstatcache(); $commentSeparator = "\n***************************************************************\n"; // author comments separator $specialIndexAR = array(); // tracks which DB col to use for special var handling function showAddresses($recipient, $sql) { $r = ocsql_query($sql) or err("Unable to retrieve emails " . ocsql_errno()); if (ocsql_num_rows($r) == 0) { print '

No email addresses available for ' . safeHTMLstr($recipient) . '

'; } else { print '

Email addresses for ' . safeHTMLstr($recipient) . ':

'; while ($l = ocsql_fetch_array($r)){ print safeHTMLstr($l['email']) . "
\n"; } } } function specialValue($a1, $a2) { global $specialIndexAR, $l; $varName = $a1 . $a2; if (!empty($varName) && isset($specialIndexAR[$varName]) && isset($l[$specialIndexAR[$varName]]) && isset($GLOBALS[$varName][$l[$specialIndexAR[$varName]]])) { return($GLOBALS[$varName][$l[$specialIndexAR[$varName]]]); } else { return(''); } } function queueMessage(&$queueAR, $date) { $q = "INSERT INTO `" . OCC_TABLE_EMAIL_QUEUE . "` (`queued`, `to`, `subject`, `body`) VALUES " . implode(', ', $queueAR); if ( ! ocsql_query($q)) { $err = 'Unable to queue messages (' . ocsql_errno() . '). You may want to try again or have the administrator check the error logs. '; if (ocsql_query("DELETE FROM `" . OCC_TABLE_EMAIL_QUEUE . "` WHERE `datetime`='" . $date . "'")) { $err .= 'Messages just queued for delivered have been deleted'; } else { $err .= 'We were unable to remove messages queued for delivery; for reference, their time stamp is ' . $date . '.'; } err($err); } } if (isset($_POST['submit'])) { // Check for valid submission if (!validToken('chair')) { warn('Invalid submission'); } // Verify recipient if (!isset($_POST['recipient']) || !isset($recipients[$_POST['recipient']])) { warn("Recipient(s) must be selected"); } // Verify template if (!empty($_POST['template']) && !in_array($_POST['template'], array_keys($templateAR))) { err("Invalid template"); } // Which message should we use? if (isset($_POST['message'])) { $subject = stripslashes($_POST['subject']); $message = stripslashes($_POST['message']); // YMMV wrt below $message = preg_replace("/\r/","",$message); // Save template? if (!empty($_POST['template']) && isset($_POST['save']) && ($_POST['save'] == "yes")) { saveTemplate($subject, $message, $_POST['template']); } } elseif (!empty($_POST['template'])) { // retrieve template list($subject, $message) = oc_getTemplate($_POST['template']); } else { $message = ''; $subject = ''; } // Which submit? // List Email addresses if ($_POST['submit'] == "List Email Addresses") { showAddresses($recipientAR[$_POST['recipient']]['text'], $recipientAR[$_POST['recipient']]['sql']); } // Send Email elseif ($_POST['submit'] == "Send Message") { $q = $recipientAR[$_POST['recipient']]['sql']; // Individual recipients? $recipientList = array(); if (isset($_POST['select_recipients']) && ($_POST['select_recipients'] == 1)) { if (! isset($_POST['selected_recipients']) || empty($_POST['selected_recipients'])) { warn('No recipients selected'); } $selectRecipients = true; foreach ($_POST['selected_recipients'] as $recip) { list($id, $email) = explode('/', $recip); if (!preg_match("/^\d+$/", $id)) { continue; } $recipientList[$id] = $email; } $q = preg_replace("/ WHERE /", " WHERE " . $recipientAR[$_POST['recipient']]['id'] . " IN (" . safeSQLstr(implode(',', array_keys($recipientList))) . ") AND ", $q); } else { $selectRecipients = false; } $r = ocsql_query($q) or err("Unable to retrieve information to email"); $recipientTotal = ocsql_num_rows($r); if ($recipientTotal == 0) { err("No email addresses found (send)"); } elseif ($selectRecipients && ($recipientTotal != count($_POST['selected_recipients']))) { // This may mean that the recipientAR SELECT statement does not contain a WHERE clause, resulting the preg_replace above failing warn("Recipient mismatch - contact your OpenConf administrator"); } // Special var handling if (isset($recipientAR[$_POST['recipient']]['special']) && is_file($recipientAR[$_POST['recipient']]['special'])) { require_once $recipientAR[$_POST['recipient']]['special']; } // Log it $date = safeSQLstr(gmdate('Y-m-d H:i:s')); // set fixed time for log & so messages in queue are grouped together $logq = "INSERT INTO `" . OCC_TABLE_LOG . "` SET `datetime`='" . $date . "', `type`='email', `entry`='Email sent to "; if ($selectRecipients) { $logq .= safeSQLstr($extra = implode(", ", $recipientList)); } else { $logq .= safeSQLstr($extra = $recipientAR[$_POST['recipient']]['text']); } $extra .= "\nSubject: " . $subject . "\n\n" . $message; $logq .= "', `extra`='To: " . safeSQLstr($extra) . "'"; ocsql_query($logq); // Send out emails $to = $tmpmessage = $tmpsubject = ''; $queueAR = array(); $queue_date = gmdate('Y-m-d H:i:s'); if ($OC_configAR['OC_queueEmails']) { // queue messages? $queueMessages = true; print '

Messages are being queued for delivery. Once queued, this page will refresh and the message sent out. If the page does not refresh, you must click the link that will appear at the bottom of the page, and is also available on the ' . OCC_WORD_CHAIR . ' home page.

'; } else { $queueMessages = false; } ob_end_flush(); flush(); ob_start(); while ($l = ocsql_fetch_array($r)) { if (empty($l['email'])) { continue; } $tmpsubject = oc_replaceVariables($subject, $l); $tmpmessage = oc_replaceVariables($message, $l); // Replace special vars (\w-\w) if (isset($recipientAR[$_POST['recipient']]['special'])) { $tmpmessage = preg_replace_callback( "/\[:(\w+)-(\w+):\]/", function ($matches) { return specialValue($matches[1], $matches[2]); }, $tmpmessage ); } // YMMV wrt below $tmpmessage = preg_replace("/\r/","",$tmpmessage); $to = $l['email']; // req'd for OC_mailCopyLast code block below print 'emailing ' . safeHTMLstr($l['email'] . ' (' . $l[0] . ') ... '); ob_flush(); flush(); if ($queueMessages) { $queueAR[] = "('" . $date . "', '" . safeSQLstr($l['email']) . "', '" . safeSQLstr($tmpsubject) . "', '" . safeSQLstr($tmpmessage) . "')"; print "queued
\n"; if (count($queueAR) >= 10) { // store messages as a group to save on DB calls queueMessage($queueAR, $date); $queueAR = array(); // reset queue array } } elseif (oc_mail($l['email'], $tmpsubject, $tmpmessage)) { // deliver instantly print "sent
\n"; } else { print "FAILED!!!
\n"; } } ob_end_flush(); flush(); // Any remaining messages for queue storage? if ($queueMessages && (count($queueAR) > 0)) { queueMessage($queueAR, $date); } // Email chair a copy of last email sent if ($OC_configAR['OC_mailCopyLast']) { $msg = "To: " . $to . "\nSubject: " . $tmpsubject . "\n\n" . $tmpmessage . "\n"; if (sendEmail($OC_configAR['OC_confirmmail'], 'Copy of last email sent', $msg)) { print '

A copy of the last message ' . ($queueMessages ? 'queued' : 'sent') . ' has been forwarded to ' . $OC_configAR['OC_confirmmail'] . '.

'; } else { print '

The system was unable to forward a copy of the last message ' . ($queueMessages ? 'queued' : 'sent') . ' to ' . $OC_configAR['OC_confirmmail'] . '.

'; } } // attempt javascript redirect if ($queueMessages) { print '

Your messages have been queued. If this page does not refresh automatically and your browser does not look like it is doing something, please follow this link to send them out now, or visit the ' . OCC_WORD_CHAIR . ' home page to send them out later.

'; } } // Preview Email elseif ($_POST['submit'] == "Preview Message") { $q = $recipientAR[$_POST['recipient']]['sql'] . " LIMIT 1"; if (isset($_POST['selected_recipients']) && !empty($_POST['selected_recipients'])) { $q = preg_replace("/ WHERE /", " WHERE " . $recipientAR[$_POST['recipient']]['id'] . "='" . safeSQLstr(substr($_POST['selected_recipients'][0], 0, strpos($_POST['selected_recipients'][0], '/'))) . "' AND ", $q); } $r = ocsql_query($q) or err("Unable to retrieve information to preview"); if (ocsql_num_rows($r) == 0) { err("No email addresses found (preview)"); } $l = ocsql_fetch_array($r); // Special var handling if (isset($recipientAR[$_POST['recipient']]['special']) && is_file($recipientAR[$_POST['recipient']]['special'])) { require_once $recipientAR[$_POST['recipient']]['special']; } print '
'; if (isset($_POST['select_recipients']) && ($_POST['select_recipients'] == 1)) { print ''; if (isset($_POST['selected_recipients'])) { foreach ($_POST['selected_recipients'] as $selected_recipient) { print ''; } } } print '      
';		

		$tmpsubject = oc_replaceVariables($subject, $l);
		$tmpmessage = oc_replaceVariables($message, $l);

		// Replace special vars (\w-\w)
		if (isset($recipientAR[$_POST['recipient']]['special'])) {
			$tmpmessage = preg_replace_callback( 
				"/\[:(\w+)-(\w+):\]/",
				function ($matches) {
					return specialValue($matches[1], $matches[2]);
				},
				$tmpmessage
			);
		}
		
		// strip extra returns from headers
		$headers = safeHTMLstr(preg_replace("/[\r\n]+/","\n", $OC_configAR['OC_mailHeaders']));
		// Show headers & msg
		print preg_replace("/([\w-]+\:)/","$1",$headers) . "\n";
		print 'To: ';
		if (isset($_POST['select_recipients']) && ($_POST['select_recipients'] == 1)) {
			if (! isset($_POST['selected_recipients']) || empty($_POST['selected_recipients'])) {
				warn('No recipients selected');
			} elseif (count($_POST['selected_recipients']) == 1) {
				list($id, $email) = explode("/", $_POST['selected_recipients'][0]);
				print safeHTMLstr($email . ' (ID: ' . $id . ')');
			} else {
				foreach ($_POST['selected_recipients'] as $recip) {
					list($id, $email) = explode("/", $recip);
					print "\n    " . safeHTMLstr($email . ' (ID: ' . $id . ')');
				}
			}
		} else {
			print safeHTMLstr($l['email']);
		}
		print "\n";
		print 'Subject: ' . safeHTMLstr($tmpsubject) . "\n\n";
		print safeHTMLstr(wordwrap($tmpmessage, $OC_configAR['OC_emailWrap'])) . "\n
\n"; } // Write Email elseif (($_POST['submit'] == "Write Email Online") || ($_POST['submit'] == "Edit Message")) { // Valid recipient? if (!isset($_POST['recipient']) || !isset($recipients[$_POST['recipient']])) { err("Unknown recipient group selected"); } // Any addresses $r = ocsql_query($recipientAR[$_POST['recipient']]['sql']) or err("Unable to retrieve email addresses " . ocsql_errno()); if (ocsql_num_rows($r) == 0) { print '

No email addresses available for ' . safeHTMLstr($recipientAR[$_POST['recipient']]['text']) . '

'; } else { print '
'; // Save template? if (!empty($_POST['template'])) { print ''; } print '
From:' . safeHTMLstr($OC_configAR['OC_pcemail']) . ' 
To:'; if (isset($_POST['select_recipients']) && ($_POST['select_recipients'] == 1)) { print ''; } else { print safeHTMLstr($recipientAR[$_POST['recipient']]['text']); } print ' 
 
[:variables:]

'; foreach ($OC_emailVarAR['general'] as $vkey => $vval) { print ''; } foreach ($recipientAR[$_POST['recipient']]['vars'] as $vkey => $vval) { print ''; } print '
[:' . safeHTMLstr($vkey) . ':]' . safeHTMLstr($vval) . '
[:' . safeHTMLstr($vkey) . ':]' . safeHTMLstr($vval) . '


     

The variables appearing next to the message field may be used in your email by enclosing each instance in [:variable:] . These will be substituted for their value prior to the email being sent. For example, to include the conference (short) name in your message use [:OC_confName:] . Some variables are only available for certain recipient groups. The [:review-fields:] variable, available when emailing author acceptance notices, includes the review form fields designated to "show author" in the Custom Forms module; the default is to only show the reviewer Comments to Author.

'; } // if Any emails } // end submit write } // end submit // Not a submit - select recipient/template else { print '

Select the recipient group you would like to email:

For "' . OCC_WORD_AUTHOR . 's -", ' . (($OC_configAR['OC_emailAuthorRecipients'] == 0) ? ('only the contact ' . oc_strtolower(OCC_WORD_AUTHOR)) : ('all ' . oc_strtolower(OCC_WORD_AUTHOR) . 's')) . ' of a submission will be emailed

Select an email template to use: (edit)


     
'; } // else not a submit printFooter(); ?>