| Zeile 6 | Zeile 6 |
|---|
* Website: http://mybb.com
* License: http://mybb.com/about/license
*
|
* Website: http://mybb.com
* License: http://mybb.com/about/license
*
|
* $Id: maillogs.php 5380 2011-02-21 12:04:43Z Tomm $
| * $Id$
|
*/
// Disallow direct access to this file for security reasons
| */
// Disallow direct access to this file for security reasons
|
| Zeile 22 | Zeile 22 |
|---|
if($mybb->input['action'] == "prune" && $mybb->request_method == "post")
{
$plugins->run_hooks("admin_tools_maillogs_prune");
|
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();
|
if($mybb->input['delete_all'])
{
$db->delete_query("maillogs");
$num_deleted = $db->affected_rows();
|
|
|
$plugins->run_hooks("admin_tools_maillogs_prune_delete_all_commit");
|
$plugins->run_hooks("admin_tools_maillogs_prune_delete_all_commit");
|
|
|
// Log admin action
log_admin_action($num_deleted);
|
// Log admin action
log_admin_action($num_deleted);
|
|
|
flash_message($lang->all_logs_deleted, 'success');
admin_redirect("index.php?module=tools-maillogs");
|
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']));
| else if(is_array($mybb->input['log']))
{
$log_ids = implode(",", array_map("intval", $mybb->input['log']));
|
| Zeile 45 | Zeile 45 |
|---|
$num_deleted = $db->affected_rows();
}
}
|
$num_deleted = $db->affected_rows();
}
}
|
|
|
$plugins->run_hooks("admin_tools_mailerrors_prune_commit");
|
$plugins->run_hooks("admin_tools_mailerrors_prune_commit");
|
|
|
// Log admin action
log_admin_action($num_deleted);
|
// Log admin action
log_admin_action($num_deleted);
|
|
|
flash_message($lang->selected_logs_deleted, 'success');
admin_redirect("index.php?module=tools-maillogs");
}
| flash_message($lang->selected_logs_deleted, 'success');
admin_redirect("index.php?module=tools-maillogs");
}
|
| Zeile 58 | Zeile 58 |
|---|
if($mybb->input['action'] == "view")
{
$plugins->run_hooks("admin_tools_maillogs_view");
|
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;
|
$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['toemail'] = htmlspecialchars_uni($log['toemail']);
$log['fromemail'] = htmlspecialchars_uni($log['fromemail']);
$log['subject'] = htmlspecialchars_uni($log['subject']);
|
| Zeile 131 | Zeile 131 |
|---|
if(!$mybb->input['action'])
{
$plugins->run_hooks("admin_tools_maillogs_start");
|
if(!$mybb->input['action'])
{
$plugins->run_hooks("admin_tools_maillogs_start");
|
$per_page = 20;
|
$per_page = $mybb->settings['threadsperpage'];
if(!$per_page)
{
$per_page = 20;
}
|
if($mybb->input['page'] && $mybb->input['page'] > 1)
{
|
if($mybb->input['page'] && $mybb->input['page'] > 1)
{
|
| Zeile 168 | Zeile 173 |
|---|
$mybb->input['toemail'] = $mybb->input['to_value'];
}
}
|
$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'])
|
// Begin criteria filtering
if($mybb->input['subject'])
|
{
$additional_sql_criteria .= " AND l.subject LIKE '%".$db->escape_string($mybb->input['subject'])."%'";
$additional_criteria[] = "subject='".htmlspecialchars_uni($mybb->input['subject'])."'";
}
| {
$additional_sql_criteria .= " AND l.subject LIKE '%{$subject}%'";
$additional_criteria[] = "subject=".urlencode($mybb->input['subject']);
}
|
if($mybb->input['fromuid'])
|
if($mybb->input['fromuid'])
|
{
$query = $db->simple_select("users", "uid, username", "uid='".intval($mybb->input['fromuid'])."'");
$user = $db->fetch_array($query);
$from_filter = $user['username'];
$additional_sql_criteria .= " AND l.fromuid='".intval($mybb->input['fromuid'])."'";
$additional_criteria[] = "fromuid='".intval($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'])
{
|
else if($mybb->input['fromname'])
{
|
$query = $db->simple_select("users", "uid, username", "LOWER(username)='".my_strtolower($mybb->input['fromname'])."'");
| $query = $db->simple_select("users", "uid, username", "LOWER(username) = '{$fromname}'");
|
$user = $db->fetch_array($query);
$from_filter = $user['username'];
|
$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");
|
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']}";
|
$additional_sql_criteria .= "AND l.fromuid = '{$user['uid']}'";
$additional_criteria[] = "fromuid={$user['uid']}";
|
}
if($mybb->input['fromemail'])
{
|
}
if($mybb->input['fromemail'])
{
|
$additional_sql_criteria .= " AND l.fromemail LIKE '%".$db->escape_string($mybb->input['fromemail'])."%'";
| $additional_sql_criteria .= " AND l.fromemail LIKE '%{$fromemail}%'";
|
$additional_criteria[] = "fromemail=".urlencode($mybb->input['fromemail']);
$from_filter = $mybb->input['fromemail'];
|
$additional_criteria[] = "fromemail=".urlencode($mybb->input['fromemail']);
$from_filter = $mybb->input['fromemail'];
|
}
| }
|
if($mybb->input['touid'])
|
if($mybb->input['touid'])
|
{
$query = $db->simple_select("users", "uid, username", "uid='".intval($mybb->input['touid'])."'");
$user = $db->fetch_array($query);
| {
$query = $db->simple_select("users", "uid, username", "uid = '{$touid}'");
$user = $db->fetch_array($query);
|
$to_filter = $user['username'];
|
$to_filter = $user['username'];
|
$additional_sql_criteria .= " AND l.touid='".intval($mybb->input['touid'])."'";
$additional_criteria[] = "touid='".intval($mybb->input['touid'])."'";
|
$additional_sql_criteria .= " AND l.touid = '{$touid}'";
$additional_criteria[] = "touid={$touid}";
|
}
else if($mybb->input['toname'])
{
|
}
else if($mybb->input['toname'])
{
|
$query = $db->simple_select("users", "uid, username", "LOWER(username)='".my_strtolower($mybb->input['toname'])."'");
| $query = $db->simple_select("users", "uid, username", "LOWER(username)='".my_strtolower($toname)."'");
|
$user = $db->fetch_array($query);
$to_filter = $user['username'];
| $user = $db->fetch_array($query);
$to_filter = $user['username'];
|
| Zeile 225 | Zeile 243 |
|---|
flash_message($lang->error_invalid_user, 'error');
admin_redirect("index.php?module=tools-maillogs");
}
|
flash_message($lang->error_invalid_user, 'error');
admin_redirect("index.php?module=tools-maillogs");
}
|
| |
|
$additional_sql_criteria .= "AND l.touid='{$user['uid']}'";
|
$additional_sql_criteria .= "AND l.touid='{$user['uid']}'";
|
$additional_criteria = "touid='{$user['uid']}'";
| $additional_criteria[] = "touid={$user['uid']}";
|
}
if($mybb->input['toemail'])
{
|
}
if($mybb->input['toemail'])
{
|
$additional_sql_criteria .= " AND l.toemail LIKE '%".$db->escape_string($mybb->input['toemail'])."%'";
$additional_criteria[] = "toemail='".urlencode($mybb->input['toemail'])."'";
| $additional_sql_criteria .= " AND l.toemail LIKE '%{$toemail}%'";
$additional_criteria[] = "toemail=".urlencode($mybb->input['toemail']);
|
$to_filter = $mybb->input['toemail'];
}
|
$to_filter = $mybb->input['toemail'];
}
|
if($additional_criteria)
| if(!empty($additional_criteria))
|
{
$additional_criteria = "&".implode("&", $additional_criteria);
|
{
$additional_criteria = "&".implode("&", $additional_criteria);
|
| | }
else
{
$additional_criteria = '';
|
}
$page->output_header($lang->user_email_log);
|
}
$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
);
|
$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');
|
$page->output_nav_tabs($sub_tabs, 'maillogs');
|
|
|
$form = new Form("index.php?module=tools-maillogs&action=prune", "post");
$table = new Table;
| $form = new Form("index.php?module=tools-maillogs&action=prune", "post");
$table = new Table;
|
| Zeile 307 | Zeile 330 |
|---|
$table->construct_cell("<a href=\"javascript:MyBB.popupWindow('index.php?module=tools-maillogs&action=view&mid={$log['mid']}', 'log_entry', 450, 450);\">{$log['subject']}</a>");
$find_from = "<div class=\"float_right\"><a href=\"index.php?module=tools-maillogs&fromuid={$log['fromuid']}\"><img src=\"styles/{$page->style}/images/icons/find.gif\" title=\"{$lang->find_emails_by_user}\" alt=\"{$lang->find}\" /></a></div>";
if(!$log['from_username'])
|
$table->construct_cell("<a href=\"javascript:MyBB.popupWindow('index.php?module=tools-maillogs&action=view&mid={$log['mid']}', 'log_entry', 450, 450);\">{$log['subject']}</a>");
$find_from = "<div class=\"float_right\"><a href=\"index.php?module=tools-maillogs&fromuid={$log['fromuid']}\"><img src=\"styles/{$page->style}/images/icons/find.gif\" title=\"{$lang->find_emails_by_user}\" alt=\"{$lang->find}\" /></a></div>";
if(!$log['from_username'])
|
{
| {
|
$table->construct_cell("{$find_from}<div>{$lang->deleted_user}</div>");
}
else
{
$table->construct_cell("{$find_from}<div><a href=\"../".get_profile_link($log['fromuid'])."\">{$log['from_username']}</a></div>");
}
|
$table->construct_cell("{$find_from}<div>{$lang->deleted_user}</div>");
}
else
{
$table->construct_cell("{$find_from}<div><a href=\"../".get_profile_link($log['fromuid'])."\">{$log['from_username']}</a></div>");
}
|
$find_to = "<div class=\"float_right\"><a href=\"index.php?module=tools-maillogs&touid={$log['touid']}\"><img src=\"styles/{$page->style}/images/icons/find.gif\" title=\"{$lang->find_emails_to_user}\" alt=\"{$lang->find}\" /></a></div>";
| $find_to = "<div class=\"float_right\"><a href=\"index.php?module=tools-maillogs&touid={$log['touid']}\"><img src=\"styles/{$page->style}/images/icons/find.gif\" title=\"{$lang->find_emails_to_user}\" alt=\"{$lang->find}\" /></a></div>";
|
if(!$log['to_username'])
{
$table->construct_cell("{$find_to}<div>{$lang->deleted_user}</div>");
| if(!$log['to_username'])
{
$table->construct_cell("{$find_to}<div>{$lang->deleted_user}</div>");
|
| Zeile 325 | Zeile 348 |
|---|
}
$table->construct_cell($log['dateline'], array("class" => "align_center"));
}
|
}
$table->construct_cell($log['dateline'], array("class" => "align_center"));
}
|
$table->construct_row();
}
| $table->construct_row();
}
|
if($table->num_rows() == 0)
{
$table->construct_cell($lang->no_logs, array("colspan" => "6"));
$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);
| $table->output($lang->user_email_log);
|
}
else
{
| }
else
{
|
| Zeile 341 | Zeile 364 |
|---|
$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);
}
|
$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();
|
$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");
|
$query = $db->simple_select("maillogs l", "COUNT(l.mid) as logs", "1=1 {$additional_sql_criteria}");
$total_rows = $db->fetch_field($query, "logs");
|
|
|
echo "<br />".draw_admin_pagination($mybb->input['page'], $per_page, $total_rows, "index.php?module=tools-maillogs&page={page}{$additional_criteria}");
|
echo "<br />".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 = 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');
| $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";
| if($from_username)
{
$from_type = "user";
|