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 5764 2012-03-27 08:54:58Z 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"); } else if(is_array($mybb->input['log']))
|
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) {
| $log_ids = implode(",", array_map("intval", $mybb->input['log'])); if($log_ids) {
|
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 105 | Zeile 105 |
---|
$table->construct_cell($lang->ip_address.":"); $table->construct_cell($log['ipaddress']);
|
$table->construct_cell($lang->ip_address.":"); $table->construct_cell($log['ipaddress']);
|
$table->construct_row();
| $table->construct_row();
|
$table->construct_cell($lang->subject.":"); $table->construct_cell($log['subject']);
|
$table->construct_cell($lang->subject.":"); $table->construct_cell($log['subject']);
|
$table->construct_row();
| $table->construct_row();
|
$table->construct_cell($lang->date.":"); $table->construct_cell($log['dateline']);
| $table->construct_cell($lang->date.":"); $table->construct_cell($log['dateline']);
|
Zeile 127 | Zeile 127 |
---|
</html> <?php }
|
</html> <?php }
|
|
|
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) { if(!$mybb->settings['threadsperpage'] || (int)$mybb->settings['threadsperpage'] < 1) { $mybb->settings['threadsperpage'] = 20; } $per_page = 20; }
|
if($mybb->input['page'] && $mybb->input['page'] > 1) {
| if($mybb->input['page'] && $mybb->input['page'] > 1) {
|
Zeile 171 | Zeile 181 |
---|
$touid = intval($mybb->input['touid']); $toname = $db->escape_string($mybb->input['toname']);
|
$touid = intval($mybb->input['touid']); $toname = $db->escape_string($mybb->input['toname']);
|
$toemail = $db->escape_string($mybb->input['toemail']);
| $toemail = $db->escape_string_like($mybb->input['toemail']);
|
$fromuid = intval($mybb->input['fromuid']); $fromname = $db->escape_string($mybb->input['fromname']);
|
$fromuid = intval($mybb->input['fromuid']); $fromname = $db->escape_string($mybb->input['fromname']);
|
$fromemail = $db->escape_string($mybb->input['fromemail']);
| $fromemail = $db->escape_string_like($mybb->input['fromemail']);
|
|
|
$subject = $db->escape_string($mybb->input['subject']);
| $subject = $db->escape_string_like($mybb->input['subject']);
|
// Begin criteria filtering if($mybb->input['subject']) { $additional_sql_criteria .= " AND l.subject LIKE '%{$subject}%'";
|
// Begin criteria filtering if($mybb->input['subject']) { $additional_sql_criteria .= " AND l.subject LIKE '%{$subject}%'";
|
$additional_criteria[] = "subject='".htmlspecialchars_uni($mybb->input['subject'])."'";
| $additional_criteria[] = "subject=".urlencode($mybb->input['subject']);
|
}
if($mybb->input['fromuid']) { $query = $db->simple_select("users", "uid, username", "uid = '{$fromuid}'");
|
}
if($mybb->input['fromuid']) { $query = $db->simple_select("users", "uid, username", "uid = '{$fromuid}'");
|
$user = $db->fetch_array($query); $from_filter = $user['username'];
| $user = $db->fetch_array($query); $from_filter = $user['username'];
|
$additional_sql_criteria .= " AND l.fromuid = '{$fromuid}'";
|
$additional_sql_criteria .= " AND l.fromuid = '{$fromuid}'";
|
$additional_criteria[] = "fromuid='{$fromuid}'";
| $additional_criteria[] = "fromuid={$fromuid}";
|
} else if($mybb->input['fromname']) {
| } else if($mybb->input['fromname']) {
|
Zeile 208 | Zeile 218 |
---|
}
$additional_sql_criteria .= "AND l.fromuid = '{$user['uid']}'";
|
}
$additional_sql_criteria .= "AND l.fromuid = '{$user['uid']}'";
|
$additional_criteria = "fromuid={$user['uid']}";
| $additional_criteria[] = "fromuid={$user['uid']}";
|
}
if($mybb->input['fromemail'])
| }
if($mybb->input['fromemail'])
|
Zeile 221 | Zeile 231 |
---|
if($mybb->input['touid']) { $query = $db->simple_select("users", "uid, username", "uid = '{$touid}'");
|
if($mybb->input['touid']) { $query = $db->simple_select("users", "uid, username", "uid = '{$touid}'");
|
$user = $db->fetch_array($query); $to_filter = $user['username'];
| $user = $db->fetch_array($query); $to_filter = $user['username'];
|
$additional_sql_criteria .= " AND l.touid = '{$touid}'";
|
$additional_sql_criteria .= " AND l.touid = '{$touid}'";
|
$additional_criteria[] = "touid='{$touid}'";
| $additional_criteria[] = "touid={$touid}";
|
} else if($mybb->input['toname']) {
| } else if($mybb->input['toname']) {
|
Zeile 234 | Zeile 244 |
---|
$to_filter = $user['username'];
if(!$user['uid'])
|
$to_filter = $user['username'];
if(!$user['uid'])
|
{
| {
|
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']) { $additional_sql_criteria .= " AND l.toemail LIKE '%{$toemail}%'";
|
if($mybb->input['toemail']) { $additional_sql_criteria .= " AND l.toemail LIKE '%{$toemail}%'";
|
$additional_criteria[] = "toemail='".urlencode($mybb->input['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",
| $sub_tabs['maillogs'] = array( 'title' => $lang->user_email_log, 'link' => "index.php?module=tools-maillogs",
|
Zeile 264 | Zeile 278 |
---|
);
$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 328 | Zeile 342 |
---|
{ $table->construct_cell("{$find_from}<div><a href=\"../".get_profile_link($log['fromuid'])."\">{$log['from_username']}</a></div>"); }
|
{ $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 341 | Zeile 355 |
---|
} $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 355 | Zeile 369 |
---|
$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");
echo "<br />".draw_admin_pagination($mybb->input['page'], $per_page, $total_rows, "index.php?module=tools-maillogs&page={page}{$additional_criteria}");
|
$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}");
|
|
|
$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";
|