Please make sure IN_MYBB is defined.");
}
$page->add_breadcrumb_item($lang->user_email_log, "index.php?module=tools-maillogs");
$plugins->run_hooks("admin_tools_maillogs_begin");
if($mybb->input['action'] == "prune" && $mybb->request_method == "post")
{
$plugins->run_hooks("admin_tools_maillogs_prune");
if($mybb->input['delete_all'])
{
$db->delete_query("maillogs");
$num_deleted = $db->affected_rows();
$plugins->run_hooks("admin_tools_maillogs_prune_delete_all_commit");
// Log admin action
log_admin_action($num_deleted);
flash_message($lang->all_logs_deleted, 'success');
admin_redirect("index.php?module=tools-maillogs");
}
else if(is_array($mybb->input['log']))
{
$log_ids = implode(",", array_map("intval", $mybb->input['log']));
if($log_ids)
{
$db->delete_query("maillogs", "mid IN ({$log_ids})");
$num_deleted = $db->affected_rows();
}
}
$plugins->run_hooks("admin_tools_mailerrors_prune_commit");
// Log admin action
log_admin_action($num_deleted);
flash_message($lang->selected_logs_deleted, 'success');
admin_redirect("index.php?module=tools-maillogs");
}
if($mybb->input['action'] == "view")
{
$plugins->run_hooks("admin_tools_maillogs_view");
$query = $db->simple_select("maillogs", "*", "mid='".intval($mybb->input['mid'])."'");
$log = $db->fetch_array($query);
if(!$log['mid'])
{
exit;
}
$log['toemail'] = htmlspecialchars_uni($log['toemail']);
$log['fromemail'] = htmlspecialchars_uni($log['fromemail']);
$log['subject'] = htmlspecialchars_uni($log['subject']);
$log['dateline'] = date($mybb->settings['dateformat'], $log['dateline']).", ".date($mybb->settings['timeformat'], $log['dateline']);
if($mybb->settings['mail_logging'] == 1)
{
$log['message'] = $lang->na;
}
else
{
$log['message'] = nl2br(htmlspecialchars_uni($log['message']));
}
?>
<?php echo $lang->user_email_log_viewer; ?>
input['action'])
{
$plugins->run_hooks("admin_tools_maillogs_start");
$per_page = $mybb->settings['threadsperpage'];
if(!$per_page)
{
$per_page = 20;
}
if($mybb->input['page'] && $mybb->input['page'] > 1)
{
$mybb->input['page'] = intval($mybb->input['page']);
$start = ($mybb->input['page']*$per_page)-$per_page;
}
else
{
$mybb->input['page'] = 1;
$start = 0;
}
$additional_criteria = array();
// Filter form was submitted - play around with the values
if($mybb->request_method == "post")
{
if($mybb->input['from_type'] == "user")
{
$mybb->input['fromname'] = $mybb->input['from_value'];
}
else if($mybb->input['from_type'] == "email")
{
$mybb->input['fromemail'] = $mybb->input['from_value'];
}
if($mybb->input['to_type'] == "user")
{
$mybb->input['toname'] = $mybb->input['to_value'];
}
else if($mybb->input['to_type'] == "email")
{
$mybb->input['toemail'] = $mybb->input['to_value'];
}
}
$touid = intval($mybb->input['touid']);
$toname = $db->escape_string($mybb->input['toname']);
$toemail = $db->escape_string_like($mybb->input['toemail']);
$fromuid = intval($mybb->input['fromuid']);
$fromname = $db->escape_string($mybb->input['fromname']);
$fromemail = $db->escape_string_like($mybb->input['fromemail']);
$subject = $db->escape_string_like($mybb->input['subject']);
// Begin criteria filtering
if($mybb->input['subject'])
{
$additional_sql_criteria .= " AND l.subject LIKE '%{$subject}%'";
$additional_criteria[] = "subject=".urlencode($mybb->input['subject']);
}
if($mybb->input['fromuid'])
{
$query = $db->simple_select("users", "uid, username", "uid = '{$fromuid}'");
$user = $db->fetch_array($query);
$from_filter = $user['username'];
$additional_sql_criteria .= " AND l.fromuid = '{$fromuid}'";
$additional_criteria[] = "fromuid={$fromuid}";
}
else if($mybb->input['fromname'])
{
$query = $db->simple_select("users", "uid, username", "LOWER(username) = '{$fromname}'");
$user = $db->fetch_array($query);
$from_filter = $user['username'];
if(!$user['uid'])
{
flash_message($lang->error_invalid_user, 'error');
admin_redirect("index.php?module=tools-maillogs");
}
$additional_sql_criteria .= "AND l.fromuid = '{$user['uid']}'";
$additional_criteria[] = "fromuid={$user['uid']}";
}
if($mybb->input['fromemail'])
{
$additional_sql_criteria .= " AND l.fromemail LIKE '%{$fromemail}%'";
$additional_criteria[] = "fromemail=".urlencode($mybb->input['fromemail']);
$from_filter = $mybb->input['fromemail'];
}
if($mybb->input['touid'])
{
$query = $db->simple_select("users", "uid, username", "uid = '{$touid}'");
$user = $db->fetch_array($query);
$to_filter = $user['username'];
$additional_sql_criteria .= " AND l.touid = '{$touid}'";
$additional_criteria[] = "touid={$touid}";
}
else if($mybb->input['toname'])
{
$query = $db->simple_select("users", "uid, username", "LOWER(username)='".my_strtolower($toname)."'");
$user = $db->fetch_array($query);
$to_filter = $user['username'];
if(!$user['uid'])
{
flash_message($lang->error_invalid_user, 'error');
admin_redirect("index.php?module=tools-maillogs");
}
$additional_sql_criteria .= "AND l.touid='{$user['uid']}'";
$additional_criteria[] = "touid={$user['uid']}";
}
if($mybb->input['toemail'])
{
$additional_sql_criteria .= " AND l.toemail LIKE '%{$toemail}%'";
$additional_criteria[] = "toemail=".urlencode($mybb->input['toemail']);
$to_filter = $mybb->input['toemail'];
}
if(!empty($additional_criteria))
{
$additional_criteria = "&".implode("&", $additional_criteria);
}
else
{
$additional_criteria = '';
}
$page->output_header($lang->user_email_log);
$sub_tabs['maillogs'] = array(
'title' => $lang->user_email_log,
'link' => "index.php?module=tools-maillogs",
'description' => $lang->user_email_log_desc
);
$page->output_nav_tabs($sub_tabs, 'maillogs');
$form = new Form("index.php?module=tools-maillogs&action=prune", "post");
$table = new Table;
$table->construct_header($form->generate_check_box("checkall", 1, '', array('class' => 'checkall')));
$table->construct_header($lang->subject, array("colspan" => 2));
$table->construct_header($lang->from, array("class" => "align_center", "width" => "20%"));
$table->construct_header($lang->to, array("class" => "align_center", "width" => "20%"));
$table->construct_header($lang->date_sent, array("class" => "align_center", "width" => "20%"));
$query = $db->query("
SELECT l.*, r.username AS to_username, f.username AS from_username, t.subject AS thread_subject
FROM ".TABLE_PREFIX."maillogs l
LEFT JOIN ".TABLE_PREFIX."users r ON (r.uid=l.touid)
LEFT JOIN ".TABLE_PREFIX."users f ON (f.uid=l.fromuid)
LEFT JOIN ".TABLE_PREFIX."threads t ON (t.tid=l.tid)
WHERE 1=1 {$additional_sql_criteria}
ORDER BY l.dateline DESC
LIMIT {$start}, {$per_page}
");
while($log = $db->fetch_array($query))
{
$table->construct_cell($form->generate_check_box("log[{$log['mid']}]", $log['mid'], ''));
$log['subject'] = htmlspecialchars_uni($log['subject']);
$log['dateline'] = date($mybb->settings['dateformat'], $log['dateline']).", ".date($mybb->settings['timeformat'], $log['dateline']);
if($log['tid'] > 0)
{
if($log['thread_subject'])
{
$log['thread_subject'] = htmlspecialchars_uni($log['thread_subject']);
$thread_link = "".$log['thread_subject']."";
}
else
{
$thread_link = $lang->deleted;
}
$table->construct_cell("![](\"styles/{$page-)
style}/images/icons/maillogs_thread.gif\" title=\"{$lang->sent_using_send_thread_feature}\" alt=\"\" />", array("width" => 1));
$table->construct_cell("{$log['subject']}
{$lang->thread} {$thread_link}");
$find_from = "";
if(!$log['from_username'])
{
$table->construct_cell("{$find_from}{$lang->deleted_user}
");
}
else
{
$table->construct_cell("{$find_from}");
}
$log['toemail'] = htmlspecialchars_uni($log['toemail']);
$table->construct_cell($log['toemail']);
$table->construct_cell($log['dateline'], array("class" => "align_center"));
}
else
{
$table->construct_cell("style}/images/icons/maillogs_user.gif\" title=\"{$lang->email_sent_to_user}\" alt=\"\" />", array("width" => 1));
$table->construct_cell("{$log['subject']}");
$find_from = "";
if(!$log['from_username'])
{
$table->construct_cell("{$find_from}{$lang->deleted_user}
");
}
else
{
$table->construct_cell("{$find_from}");
}
$find_to = "";
if(!$log['to_username'])
{
$table->construct_cell("{$find_to}{$lang->deleted_user}
");
}
else
{
$table->construct_cell("{$find_to}");
}
$table->construct_cell($log['dateline'], array("class" => "align_center"));
}
$table->construct_row();
}
if($table->num_rows() == 0)
{
$table->construct_cell($lang->no_logs, array("colspan" => "6"));
$table->construct_row();
$table->output($lang->user_email_log);
}
else
{
$table->output($lang->user_email_log);
$buttons[] = $form->generate_submit_button($lang->delete_selected, array('onclick' => "return confirm('{$lang->confirm_delete_logs}');"));
$buttons[] = $form->generate_submit_button($lang->delete_all, array('name' => 'delete_all', 'onclick' => "return confirm('{$lang->confirm_delete_all_logs}');"));
$form->output_submit_wrapper($buttons);
}
$form->end();
$query = $db->simple_select("maillogs l", "COUNT(l.mid) as logs", "1=1 {$additional_sql_criteria}");
$total_rows = $db->fetch_field($query, "logs");
echo "
".draw_admin_pagination($mybb->input['page'], $per_page, $total_rows, "index.php?module=tools-maillogs&page={page}{$additional_criteria}");
$form = new Form("index.php?module=tools-maillogs", "post");
$form_container = new FormContainer($lang->filter_user_email_log);
$user_email = array(
"user" => $lang->username_is,
"email" => $lang->email_contains
);
$form_container->output_row($lang->subject_contains, "", $form->generate_text_box('subject', $mybb->input['subject'], array('id' => 'subject')), 'subject');
if($from_username)
{
$from_type = "user";
}
else if($mybb->input['fromemail'])
{
$from_type = "email";
}
$form_container->output_row($lang->from, "", $form->generate_select_box('from_type', $user_email, $from_type)." ".$form->generate_text_box('from_value', $from_filter, array('id' => 'from_value')), 'from_value');
if($to_username)
{
$to_type = "user";
}
else if($mybb->input['toemail'])
{
$to_type = "email";
}
$form_container->output_row($lang->to, "", $form->generate_select_box('to_type', $user_email, $to_type)." ".$form->generate_text_box('to_value', $to_filter, array('id' => 'to_value')), 'to_value');
$form_container->end();
$buttons[] = $form->generate_submit_button($lang->filter_user_email_log);
$form->output_submit_wrapper($buttons);
$form->end();
$page->output_footer();
}
?>