function SaveStatusToDB($i)
{
    global $messageid;
    if ($i % 10 != 0) {
        return;
    }
    $count = $_REQUEST['startLimit'] + $i;
    $conn = dbConnect();
    $body = mysql_real_escape_string($_REQUEST['titleEmail'], $conn);
    mysql_query("UPDATE fb_messages SET count={$count} WHERE id={$messageid}", $conn);
    echo mysql_error($conn);
    mysql_close($conn);
    PrintStatus($i);
}
Example #2
0
function PageCodeMassmailer()
{
    global $sActionResult, $action;
    return array('page_code_status' => PrintStatus($sActionResult), 'page_code_new_message' => getEmailMessage($action), 'page_code_preview_message' => $action == 'preview' && $_POST['body'] ? PreviewMessage() : '', 'page_code_all_messages' => getAllMessagesBox(), 'page_code_queue_message' => getQueueMessage());
}
    }
}
if (!$demo_mode && $action == 'empty') {
    if (EmptyQueue()) {
        $action_result .= "Queue empty.<br>";
    } else {
        $action_result .= "Queue emptying failed.<br>";
    }
}
if (!$demo_mode && $action == 'queue' && $_POST['msgs_id']) {
    $action_result .= QueueMessage();
}
if (strlen($action_result)) {
    echo "<br><center><div class=\"err\">{$action_result}</div></center><br>\n";
}
PrintStatus();
// Print combobox with all messages
?>
	<form name="form_messages" method="POST" action="<?php 
echo $_SERVER['PHP_SELF'];
?>
">
		<input type="hidden" name="action" value="view">
		<center class="text">Messages:&nbsp;
			<select name=msgs_id onChange="javascript: document.forms['form_messages'].submit();">
				<option value=0>NONE</option>
<?php 
$res_msgs = db_res("SELECT `ID`, `Subj`, `Text`, `HTML`, (`ID` = " . (int) $_POST['msgs_id'] . " OR `Subj` = '" . process_db_input($_POST['subj']) . "' ) AS `Selected` FROM `NotifyMsgs`");
while ($arr_msgs = mysql_fetch_array($res_msgs)) {
    $sel = $arr_msgs['Selected'] ? "selected" : "";
    echo "\n\t\t\t\t<option value=\"{$arr_msgs['ID']}\" {$sel}>{$arr_msgs['Subj']}</option>";
Example #4
0
}
if ($_POST['add_message']) {
    $action = 'add';
}
if ($_POST['delete_message'] && $_POST['msgs_id']) {
    $sActionResult = DeleteMessage() ? _t('_adm_mmail_Message_was_deleted') : _t('_adm_mmail_Message_was_not_deleted');
}
if ($_POST['preview_message'] && $_POST['msgs_id']) {
    $action = 'preview';
}
if (bx_get('action') == 'empty') {
    $sActionResult = EmptyQueue() ? _t('_adm_mmail_Queue_empty') : _t('_adm_mmail_Queue_emptying_failed');
}
$iNameIndex = 13;
$_page = array('name_index' => $iNameIndex, 'css_name' => array('forms_adv.css'), 'header' => _t('_adm_mmail_title'));
$_page_cont[$iNameIndex] = array('page_code_status' => PrintStatus($sActionResult), 'page_code_new_message' => getEmailMessage($action), 'page_code_preview_message' => $action == 'preview' && strlen($_POST['body']) ? PreviewMessage() : '', 'page_code_all_messages' => getAllMessagesBox(), 'page_code_queue_message' => getQueueMessage());
PageCodeAdmin();
function PrintStatus($sActionResult)
{
    $sSubjC = _t('_Subject');
    $sEmailsC = _t('_adm_mmail_emails');
    $sEmptyQueueC = _t('_adm_mmail_Empty_Queue');
    $sCupidStatusC = _t('_adm_mmail_Cupid_mails_status');
    $sSingleEmailsTRs = '';
    // Select count of emails in queue per one message
    $iCount = (int) $GLOBALS['MySQL']->getOne("SELECT COUNT(`id`) AS `count` FROM `sys_sbs_queue`");
    if ($iCount <= 0) {
        $sSingleEmailsTRs .= "<tr><td align=center><b><font color=red>" . _t('_adm_mmail_no_emails_in_queue') . "</font></b></td></tr>";
    } else {
        $sSingleEmailsTRs .= "<tr><td align=center>" . _t('_adm_mmail_mails_in_queue', $iCount) . "</td></tr>";
    }