* ", $lang->subject_desc, $form->generate_text_box('subject', $input['subject'], array('id' => 'subject')), 'subject');
if($input['type'] == 0)
{
$type_email_checked = true;
$type_pm_checked = false;
}
else if($input['type'] == 1)
{
$type_email_checked = false;
$type_pm_checked = true;
}
$type_options = array(
$form->generate_radio_button("type", 0, $lang->send_via_email, array("id" => "type_email", "checked" => $type_email_checked)),
$form->generate_radio_button("type", 1, $lang->send_via_pm, array("id" => "type_pm", "checked" => $type_pm_checked))
);
$form_container->output_row("{$lang->message_type}: * ", "", implode("{$month} \n";
}
else
{
$enddatemonth .= "{$month} \n";
}
}
$enddateday = "";
// Construct option list for days
for($i = 1; $i <= 31; ++$i)
{
if($i == $input['enddateday'])
{
$enddateday .= "{$i} \n";
}
else
{
$enddateday .= "{$i} \n";
}
}
$actions = "
{$lang->deliver_immediately} {$lang->deliver_specific}
";
$form_container->output_row("{$lang->delivery_date}: * ", $lang->delivery_date_desc, $actions);
$form_container->output_row("{$lang->per_page}: * ", $lang->per_page_desc, $form->generate_text_box('perpage', $input['perpage'], array('id' => 'perpage')), 'perpage');
$format_options = array(
0 => $lang->plain_text_only,
1 => $lang->html_only,
2 => $lang->html_and_plain_text
);
$form_container->output_row("{$lang->message_format}: * ", "", $form->generate_select_box('format', $format_options, $input['format'], array('id' => 'format')), 'format', null, array("id" => "format_container"));
$form_container->end();
if($input['format'] == 2)
{
if($input['automatic_text'] && !$email['mid'])
{
$automatic_text_check = true;
$text_display = 'display: none';
$automatic_display = 'display: none;';
}
}
else if($input['format'] == 1 && $input['type'] != 1)
{
$text_display = 'display: none;';
}
else if($input['format'] == 0 || $input['type'] == 1)
{
$html_display = 'display: none';
}
echo "";
$form_container = new FormContainer("{$lang->edit_mass_mail}: {$lang->define_html_message}");
$form_container->output_row("{$lang->define_html_message_desc}:", $html_personalisation, $form->generate_text_area('htmlmessage', $input['htmlmessage'], array('id' => 'htmlmessage', 'rows' => 15, 'cols '=> 70, 'style' => 'width: 95%'))."
".$form->generate_check_box('automatic_text', 1, $lang->auto_gen_plain_text, array('checked' => $automatic_text_check, "id" => "automatic_text"))."
");
$form_container->end();
echo "
";
$form_container = new FormContainer("{$lang->edit_mass_mail}: {$lang->define_text_version}");
$form_container->output_row("{$lang->define_text_version_desc}:", $text_personalisation, $form->generate_text_area('message', $input['message'], array('id' => 'message', 'rows' => 15, 'cols '=> 70, 'style' => 'width: 95%')));
$form_container->end();
echo "
";
echo "
";
$form_container = new FormContainer("{$lang->edit_mass_mail}: {$lang->define_the_recipients}");
$form_container->output_row($lang->username_contains, "", $form->generate_text_box('conditions[username]', $input['conditions']['username'], array('id' => 'username')), 'username');
$form_container->output_row($lang->email_addr_contains, "", $form->generate_text_box('conditions[email]', $input['conditions']['email'], array('id' => 'email')), 'email');
$query = $db->simple_select("usergroups", "gid, title", "gid != '1'", array('order_by' => 'title'));
while($usergroup = $db->fetch_array($query))
{
$options[$usergroup['gid']] = $usergroup['title'];
}
$form_container->output_row($lang->members_of, $lang->additional_user_groups_desc, $form->generate_select_box('conditions[usergroup][]', $options, $input['conditions']['usergroup'], array('id' => 'usergroups', 'multiple' => true, 'size' => 5)), 'usergroups');
$greater_options = array(
"greater_than" => $lang->greater_than,
"is_exactly" => $lang->is_exactly,
"less_than" => $lang->less_than
);
$form_container->output_row($lang->post_count_is, "", $form->generate_select_box('conditions[postnum_dir]', $greater_options, $input['conditions']['postnum_dir'], array('id' => 'numposts_dir'))." ".$form->generate_text_box('conditions[postnum]', $input['conditions']['numposts'], array('id' => 'numposts')), 'numposts');
// Need to do reg date & last visit periods. FIGURE OUT HOW TO HANDLE/DISPLAY (Do the same as StoreSuite)
$form_container->end();
$buttons[] = $form->generate_submit_button($lang->save_mass_mail);
$form->output_submit_wrapper($buttons);
$form->end();
$page->output_footer();
}
if($mybb->input['action'] == "send")
{
$page->add_breadcrumb_item($lang->send_mass_mail);
if($mybb->input['step'])
{
$query = $db->simple_select("massemails", "*", "status=0 and mid='".intval($mybb->input['mid'])."'");
$email = $db->fetch_array($query);
if(!$email['mid'] && $mybb->input['step'] != 1)
{
flash_message($lang->error_invalid_mid, 'error');
admin_redirect("index.php?module=user-mass_mail");
}
}
$replacement_fields = array(
"{username}" => $lang->username,
"{email}" => $lang->email_addr,
"{bbname}" => $lang->board_name,
"{bburl}" => $lang->board_url
);
$html_personalisation = $text_personalisation = "\n";
$text_personalisation = substr($text_personalisation, 0, -2)."');\n// -->\n";
if($mybb->input['step'] == 4)
{
// All done here
if($mybb->request_method == "post")
{
// Sending this message now
if($mybb->input['delivery_type'] == "now")
{
$delivery_date = TIME_NOW;
}
// Delivering in the future
else
{
if(strstr($mybb->input['deliverytime_time'], "pm"))
{
$mybb->input['deliveryhour'] += 12;
}
$exploded = explode(':', $mybb->input['endtime_time']);
$mybb->input['deliveryhour'] = intval($exploded[0]);
$exploded = explode(' ', $exploded[1]);
$mybb->input['deliveryminute'] = intval($exploded[0]);
$delivery_date = gmmktime($mybb->input['deliveryhour'], $mybb->input['deliveryminute'], 0, $mybb->input['endtime_month'], $mybb->input['endtime_day'], $mybb->input['endtime_year']) + $mybb->user['timezone']*3600;
if($delivery_date <= TIME_NOW)
{
$errors[] = $lang->error_only_in_future;
}
}
if(!$errors)
{
// Mark as queued for delivery
$updated_email = array(
"status" => 1,
"senddate" => $delivery_date
);
$db->update_query("massemails", $updated_email, "mid='{$email['mid']}'");
flash_message($lang->success_mass_mail_saved, 'success');
admin_redirect("index.php?module=user-mass_mail");
}
}
// Show summary of the mass email we've just been creating and allow the user to specify the delivery date
$page->output_header("{$lang->send_mass_mail}: {$lang->step_four}");
$page->output_nav_tabs($sub_tabs, 'send_mass_mail');
// If we have any error messages, show them
if($errors)
{
$page->output_inline_error($errors);
$input = $mybb->input;
}
else
{
$input = array();
if($email['senddate'] != 0)
{
if($email['senddate'] <= TIME_NOW)
{
$input['delivery_type'] = "now";
$delivery_type_checked['now'] = " checked=\"checked\"";
}
else
{
$input['delivery_type'] = "future";
$time = date("d-n-Y-h-i-a", $email['senddate']);
$time = explode('-', $time);
$input['deliveryhour'] = (int)$time[3];
$input['deliveryminute'] = (int)$time[4];
$input['deliverymonth'] = (int)$time[1];
$input['deliveryday'] = (int)$time[0];
$input['deliveryyear'] = (int)$time[2];
$input['deliverymeridiem'] = $time[5];
$delivery_type_checked['future'] = " checked=\"checked\"";
}
}
else
{
$input['delivery_type'] = "now";
$delivery_type_checked['now'] = " checked=\"checked\"";
}
}
$table = new Table;
$table->construct_cell("{$lang->delivery_method}: ", array('width' => '25%'));
if($email['type'] == 1)
{
$delivery_type = $lang->private_message;
}
else if($email['type'] == 0)
{
$delivery_type = $lang->email;
}
$table->construct_cell($delivery_type);
$table->construct_row();
$table->construct_cell("{$lang->subject}: ");
$table->construct_cell(htmlspecialchars_uni($email['subject']));
$table->construct_row();
$table->construct_cell("{$lang->message}: ");
$format_preview = '';
if($email['format'] == 0 || $email['format'] == 2)
{
$format_preview .= "{$lang->text_based} - {$lang->preview} ";
}
if($email['format'] == 2)
{
$format_preview .= " {$lang->and} {$lang->preview} ";
}
$table->construct_cell($format_preview);
$table->construct_row();
// Recipient counts & details
$table->construct_cell("{$lang->total_recipients}: ");
$table->construct_cell(my_number_format($email['totalcount'])." - {$lang->change_recipient_conds} ");
$table->construct_row();
$table->output("{$lang->send_mass_mail}: {$lang->step_four} - {$lang->review_message}");
if($input['deliveryhour'])
{
$input['endtime_time'] = intval($input['deliveryhour']).":";
}
else
{
$input['endtime_time'] = "12:";
}
if($input['deliveryminute'])
{
$input['endtime_time'] .= intval($input['deliveryminute'])." ";
}
else
{
$input['endtime_time'] .= "00 ";
}
if($input['deliverymeridiem'])
{
$input['endtime_time'] .= $input['deliverymeridiem'];
}
else
{
$input['endtime_time'] .= "am";
}
if(!$input['deliveryyear'])
{
$enddateyear = gmdate('Y', TIME_NOW);
}
else
{
$enddateyear = intval($input['deliveryyear']);
}
if(!$input['deliverymonth'])
{
$input['enddatemonth'] = gmdate('n', TIME_NOW);
}
else
{
$input['enddatemonth'] = intval($input['deliverymonth']);
}
if(!$input['deliveryday'])
{
$input['enddateday'] = gmdate('j', TIME_NOW);
}
else
{
$input['enddateday'] = intval($input['deliveryday']);
}
$monthnames = array(
"offset",
$lang->january,
$lang->february,
$lang->march,
$lang->april,
$lang->may,
$lang->june,
$lang->july,
$lang->august,
$lang->september,
$lang->october,
$lang->november,
$lang->december,
);
$enddatemonth = "";
foreach($monthnames as $key => $month)
{
if($month == "offset")
{
continue;
}
if($key == $input['enddatemonth'])
{
$enddatemonth .= "{$month} \n";
}
else
{
$enddatemonth .= "{$month} \n";
}
}
$enddateday = "";
// Construct option list for days
for($i = 1; $i <= 31; ++$i)
{
if($i == $input['enddateday'])
{
$enddateday .= "{$i} \n";
}
else
{
$enddateday .= "{$i} \n";
}
}
$form = new Form("index.php?module=user-mass_mail&action=send&step=4&mid={$email['mid']}", "post");
$form_container = new FormContainer("{$lang->send_mass_mail}: {$lang->step_four} - {$lang->define_delivery_date}");
$actions = "
{$lang->deliver_immediately} {$lang->deliver_specific}
";
$form_container->output_row("{$lang->delivery_date}: * ", $lang->delivery_date_desc, $actions);
$form_container->end();
$buttons[] = $form->generate_submit_button($lang->schedule_for_delivery);
$form->output_submit_wrapper($buttons);
$form->end();
$page->output_footer();
}
if($mybb->input['step'] == 3)
{
// Define the recipients/conditions
if($mybb->request_method == "post")
{
// Need to perform the search to fetch the number of users we're emailing
$member_query = build_mass_mail_query($mybb->input['conditions']);
$query = $db->simple_select("users u", "COUNT(uid) AS num", $member_query);
$num = $db->fetch_field($query, "num");
if($num == 0)
{
$errors[] = $lang->error_no_users;
}
// Got one or more results
else
{
$updated_email = array(
"totalcount" => $num,
"conditions" => $db->escape_string(serialize($mybb->input['conditions']))
);
$db->update_query("massemails", $updated_email, "mid='{$email['mid']}'");
// Take the user to the next step
admin_redirect("index.php?module=user-mass_mail&action=send&step=4&mid={$email['mid']}");
}
}
$page->output_header("{$lang->send_mass_mail}: {$lang->step_three}");
$form = new Form("index.php?module=user-mass_mail&action=send&step=3&mid={$email['mid']}", "post");
$page->output_nav_tabs($sub_tabs, 'send_mass_mail');
// If we have any error messages, show them
if($errors)
{
$page->output_inline_error($errors);
$input = $mybb->input;
}
else
{
if($email['conditions'] != '')
{
$input = array(
"conditions" => unserialize($email['conditions'])
);
}
else
{
$input = array();
}
}
$options = array(
'username', 'email', 'postnum_dir', 'numposts'
);
foreach($options as $option)
{
if(!isset($input['conditions'][$option]))
{
$input['conditions'][$option] = '';
}
}
if(!isset($input['conditions']['usergroup']) || !is_array($input['conditions']['usergroup']))
{
$input['conditions']['usergroup'] = array();
}
$form_container = new FormContainer("{$lang->send_mass_mail}: {$lang->step_three} - {$lang->define_the_recipients}");
$form_container->output_row($lang->username_contains, "", $form->generate_text_box('conditions[username]', $input['conditions']['username'], array('id' => 'username')), 'username');
$form_container->output_row($lang->email_addr_contains, "", $form->generate_text_box('conditions[email]', $input['conditions']['email'], array('id' => 'email')), 'email');
$options = array();
$query = $db->simple_select("usergroups", "gid, title", "gid != '1'", array('order_by' => 'title'));
while($usergroup = $db->fetch_array($query))
{
$options[$usergroup['gid']] = $usergroup['title'];
}
$form_container->output_row($lang->members_of, $lang->additional_user_groups_desc, $form->generate_select_box('conditions[usergroup][]', $options, $input['conditions']['usergroup'], array('id' => 'usergroups', 'multiple' => true, 'size' => 5)), 'usergroups');
$greater_options = array(
"greater_than" => $lang->greater_than,
"is_exactly" => $lang->is_exactly,
"less_than" => $lang->less_than
);
$form_container->output_row($lang->post_count_is, "", $form->generate_select_box('conditions[postnum_dir]', $greater_options, $input['conditions']['postnum_dir'], array('id' => 'numposts_dir'))." ".$form->generate_text_box('conditions[postnum]', $input['conditions']['numposts'], array('id' => 'numposts')), 'numposts');
// Need to do reg date & last visit periods. FIGURE OUT HOW TO HANDLE/DISPLAY (Do the same as StoreSuite)
$form_container->end();
$buttons[] = $form->generate_submit_button($lang->next_step);
$form->output_submit_wrapper($buttons);
$form->end();
$page->output_footer();
}
// Reviewing the automatic text based version of the message.
if($mybb->input['step'] == 2)
{
// Update text based version
if($mybb->request_method == "post")
{
if(!trim($mybb->input['message']))
{
$errors[] = $lang->error_missing_plain_text;
}
else
{
$updated_email = array(
"message" => $db->escape_string($mybb->input['message'])
);
$db->update_query("massemails", $updated_email, "mid='{$email['mid']}'");
// Take the user to the next step
admin_redirect("index.php?module=user-mass_mail&action=send&step=3&mid={$email['mid']}");
}
}
$page->output_header("{$lang->send_mass_mail}: {$lang->step_two}");
$form = new Form("index.php?module=user-mass_mail&action=send&step=2&mid={$email['mid']}", "post");
$page->output_nav_tabs($sub_tabs, 'send_mass_mail');
// If we have any error messages, show them
if($errors)
{
$page->output_inline_error($errors);
}
$form_container = new FormContainer("{$lang->send_mass_mail}: {$lang->step_two} - {$lang->review_text_version}");
$form_container->output_row("{$lang->review_text_version_desc}:", $text_personalisation, $form->generate_text_area('message', $email['message'], array('id' => 'message', 'rows' => 15, 'cols '=> 70, 'style' => 'width: 95%')));
$form_container->end();
$buttons[] = $form->generate_submit_button($lang->next_step);
$form->output_submit_wrapper($buttons);
$form->end();
$page->output_footer();
}
if(!$mybb->input['step'] || $mybb->input['step'] == 1)
{
if($mybb->request_method == "post")
{
if(!trim($mybb->input['subject']))
{
$errors[] = $lang->error_missing_subject;
}
if($mybb->input['type'] == 1)
{
if(!$mybb->input['message'])
{
$errors[] = $lang->error_missing_message;
}
}
else
{
if($mybb->input['format'] == 2 && $mybb->input['automatic_text'] == 0 && !$mybb->input['message'])
{
$errors[] = $lang->error_missing_plain_text;
}
if(($mybb->input['format'] == 1 || $mybb->input['format'] == 2) && !$mybb->input['htmlmessage'])
{
$errors[] = $lang->error_missing_html;
}
else if($mybb->input['format'] == 0 && !$mybb->input['message'])
{
$errors[] = $lang->error_missing_plain_text;
}
}
// No errors, insert away
if(!$errors)
{
if(!$new_email['mid'])
{
// Sending via a PM
if($mybb->input['type'] == 1)
{
$mybb->input['format'] = 0;
$mybb->input['htmlmessage'] = '';
}
// Sending via email
else
{
// Do we need to generate a text based version?
if($mybb->input['format'] == 2 && $mybb->input['automatic_text'])
{
$mybb->input['message'] = create_text_message($mybb->input['htmlmessage']);
}
else if($mybb->input['format'] == 1)
{
$mybb->input['message'] = '';
}
else if($mybb->input['format'] == 0)
{
$mybb->input['htmlmessage'] = '';
}
}
$new_email = array(
"uid" => $mybb->user['uid'],
"subject" => $db->escape_string($mybb->input['subject']),
"message" => $db->escape_string($mybb->input['message']),
"htmlmessage" => $db->escape_string($mybb->input['htmlmessage']),
"format" => intval($mybb->input['format']),
"type" => intval($mybb->input['type']),
"dateline" => TIME_NOW,
"senddate" => 0,
"status" => 0,
"sentcount" => 0,
"totalcount" => 0,
"conditions" => "",
"perpage" => intval($mybb->input['perpage'])
);
$mid = $db->insert_query("massemails", $new_email);
}
// Updating an existing one
else
{
$updated_email = array(
"subject" => $db->escape_string($mybb->input['subject']),
"message" => $db->escape_string($mybb->input['message']),
"htmlmessage" => $db->escape_string($mybb->input['htmlmessage']),
"format" => intval($mybb->input['format']),
"type" => intval($mybb->input['type']),
"perpage" => intval($mybb->input['perpage'])
);
$db->update_query("massemails", $updated_email, "mid='{$email['mid']}'");
$mid = $email['mid'];
}
if($mybb->input['format'] == 2 && $mybb->input['automatic_text'] == 1)
{
$next = 2;
}
else
{
$next = 3;
}
admin_redirect("index.php?module=user-mass_mail&action=send&step={$next}&mid={$mid}");
}
}
$page->output_header("{$lang->send_mass_mail}: {$lang->step_one}");
$mid_add = '';
if($email['mid'])
{
$mid_add = "&mid={$email['mid']}";
}
$form = new Form("index.php?module=user-mass_mail&action=send{$mid_add}", "post");
$page->output_nav_tabs($sub_tabs, 'send_mass_mail');
// If we have any error messages, show them
if($errors)
{
$page->output_inline_error($errors);
$input = $mybb->input;
}
else if(!$email)
{
$input = array(
"type" => 0,
"format" => 2,
"automatic_text" => 1,
"perpage" => 50,
);
}
else
{
$input = $email;
}
$form_container = new FormContainer("{$lang->send_mass_mail}: {$lang->step_one} - {$lang->message_settings}");
$form_container->output_row("{$lang->subject}: * ", $lang->subject_desc, $form->generate_text_box('subject', $input['subject'], array('id' => 'subject')), 'subject');
if($mybb->input['type'] == 0)
{
$type_email_checked = true;
$type_pm_checked = false;
}
else if($mybb->input['type'] == 1)
{
$type_email_checked = false;
$type_pm_checked = true;
}
$type_options = array(
$form->generate_radio_button("type", 0, $lang->send_via_email, array("id" => "type_email", "checked" => $type_email_checked)),
$form->generate_radio_button("type", 1, $lang->send_via_pm, array("id" => "type_pm", "checked" => $type_pm_checked))
);
$form_container->output_row("{$lang->message_type}:", "", implode("* ", $lang->per_page_desc, $form->generate_text_box('perpage', $input['perpage'], array('id' => 'perpage')), 'perpage');
$form_container->end();
if($mybb->input['format'] == 2)
{
if($mybb->input['automatic_text'] && !$email['mid'])
{
$automatic_text_check = true;
$text_display = 'display: none';
$automatic_display = 'display: none;';
}
}
else if($mybb->input['format'] == 1 && $mybb->input['type'] != 1)
{
$text_display = 'display: none;';
}
else if($mybb->input['format'] == 0 || $mybb->input['type'] == 1)
{
$html_display = 'display: none';
}
echo "";
$form_container = new FormContainer("{$lang->send_mass_mail}: {$lang->step_one} - {$lang->define_html_message}");
$form_container->output_row("{$lang->define_html_message_desc}:", $html_personalisation, $form->generate_text_area('htmlmessage', $input['htmlmessage'], array('id' => 'htmlmessage', 'rows' => 15, 'cols '=> 70, 'style' => 'width: 95%'))."
".$form->generate_check_box('automatic_text', 1, $lang->auto_gen_plain_text, array('checked' => $automatic_text_check, "id" => "automatic_text"))."
");
$form_container->end();
echo "
";
$form_container = new FormContainer("{$lang->send_mass_mail}: {$lang->step_one} - {$lang->define_text_version}");
$form_container->output_row("{$lang->define_text_version_desc}:", $text_personalisation, $form->generate_text_area('message', $input['message'], array('id' => 'message', 'rows' => 15, 'cols '=> 70, 'style' => 'width: 95%')));
$form_container->end();
echo "
";
echo "
";
$buttons[] = $form->generate_submit_button($lang->next_step);
$form->output_submit_wrapper($buttons);
$form->end();
$page->output_footer();
}
}
if($mybb->input['action'] == "delete")
{
$query = $db->simple_select("massemails", "*", "mid='".intval($mybb->input['mid'])."'");
$mass_email = $db->fetch_array($query);
if(!$mass_email['mid'])
{
flash_message($lang->error_delete_invalid_mid, 'error');
admin_redirect("index.php?module=user-mass_mail");
}
// User clicked no
if($mybb->input['no'])
{
admin_redirect("index.php?module=user-mass_mail");
}
if($mybb->request_method == "post")
{
$db->delete_query("massemails", "mid='{$mass_email['mid']}'");
$plugins->run_hooks("admin_user_mass_email_delete_commit");
// Log admin action
log_admin_action($mass_email['mid'], $mass_email['subject']);
if($mybb->input['archive'] == 1)
{
flash_message($lang->success_mass_mail_deleted, 'success');
admin_redirect("index.php?module=user-mass_mail&action=archive");
}
else
{
flash_message($lang->success_mass_mail_deleted, 'success');
admin_redirect("index.php?module=user-mass_mail");
}
}
else
{
if($mybb->input['archive'] == 1)
{
$page->output_confirm_action("index.php?module=user-mass_mail&action=delete&mid={$mass_email['mid']}&archive=1", $lang->mass_mail_deletion_confirmation);
}
else
{
$page->output_confirm_action("index.php?module=user-mass_mail&action=delete&mid={$mass_email['mid']}", $lang->mass_mail_deletion_confirmation);
}
}
}
if($mybb->input['action'] == "preview")
{
$query = $db->simple_select("massemails", "*", "mid='".intval($mybb->input['mid'])."'");
$mass_email = $db->fetch_array($query);
if(!$mass_email['mid'])
{
flash_message($lang->error_invalid_mid, 'error');
admin_redirect("index.php?module=user-mass_mail");
}
?>
Mass Email Preview
{$email['subject']} ");
}
if($email['status'] == 3)
{
$status = $lang->delivered;
}
else if($email['status'] == 4)
{
$status = $lang->canceled;
}
$table->construct_cell($status, array("class" => "align_center"));
$delivery_date = my_date($mybb->settings['dateformat'], $email['senddate']);
$table->construct_cell($delivery_date, array("class" => "align_center"));
$table->construct_cell(my_number_format($email['totalcount']), array("class" => "align_center"));
$table->construct_cell("{$lang->resend} ", array("width" => 100, "class" => "align_center"));
$table->construct_cell("post_code}&archive=1\" onclick=\"return AdminCP.deleteConfirmation(this, '{$lang->mass_mail_deletion_confirmation}')\">{$lang->delete} ", array("width" => 100, "class" => "align_center"));
$table->construct_row();
}
if($table->num_rows() == 0)
{
$table->construct_cell($lang->no_archived_messages, array('colspan' => 6));
$table->construct_row();
$no_results = true;
}
$table->output($lang->mass_mail_archive);
$page->output_footer();
}
if(!$mybb->input['action'])
{
$page->output_header($lang->mass_mail_queue);
$page->output_nav_tabs($sub_tabs, 'mail_queue');
$table = new Table;
$table->construct_header($lang->subject);
$table->construct_header($lang->status, array('width' => '130', 'class' => 'align_center'));
$table->construct_header($lang->delivery_date, array('width' => '130', 'class' => 'align_center'));
$table->construct_header($lang->recipients, array('width' => '130', 'class' => 'align_center'));
$table->construct_header($lang->controls, array("class" => "align_center", "colspan" => 2, "width" => 200));
$query = $db->simple_select("massemails", "*", "status IN (0, 1, 2)", array('order_by' => 'senddate'));
while($email = $db->fetch_array($query))
{
$email['subject'] = htmlspecialchars_uni($email['subject']);
if(TIME_NOW >= $email['senddate'] && $email['status'] > 1)
{
$table->construct_cell("{$email['subject']} {$email['subject']} ");
}
if($email['status'] == 0)
{
$status = $lang->draft;
}
else if($email['status'] == 1)
{
$status = $lang->queued;
}
else if($email['status'] == 2)
{
$progress = ceil($email['sentcount']/$email['totalcount']*100);
if($progress > 100)
{
$progress = 100;
}
$status = "{$lang->delivering} ({$progress}%)";
}
$table->construct_cell($status, array("class" => "align_center"));
if($email['status'] != 0)
{
$delivery_date = my_date($mybb->settings['dateformat'], $email['senddate']);
}
else
{
$delivery_date = $lang->na;
}
$table->construct_cell($delivery_date, array("class" => "align_center"));
$table->construct_cell(my_number_format($email['totalcount']), array("class" => "align_center"));
if(TIME_NOW >= $email['senddate'] && $email['status'] > 1)
{
$table->construct_cell("post_code}\" onclick=\"return AdminCP.deleteConfirmation(this, '{$lang->mass_mail_cancel_confirmation}')\">{$lang->cancel} ", array("width" => 100, "colspan" => 2, "class" => "align_center"));
}
else
{
$table->construct_cell("{$lang->edit} ", array("width" => 100, "class" => "align_center"));
$table->construct_cell("post_code}\" onclick=\"return AdminCP.deleteConfirmation(this, '{$lang->mass_mail_deletion_confirmation}')\">{$lang->delete} ", array("width" => 100, "class" => "align_center"));
}
$table->construct_row();
}
if($table->num_rows() == 0)
{
$table->construct_cell($lang->no_unsent_messages, array('colspan' => 6));
$table->construct_row();
$no_results = true;
}
$table->output($lang->mass_mail_queue);
$page->output_footer();
}
?>