Vergleich admin/modules/tools/maillogs.php - 1.8.1 - 1.8.30

  Keine Änderungen   Hinzugefügt   Modifiziert   Entfernt
Zeile 43Zeile 43
			$db->delete_query("maillogs", "mid IN ({$log_ids})");
$num_deleted = $db->affected_rows();
}

			$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);
}





	// Log admin action
log_admin_action($num_deleted);

	$plugins->run_hooks("admin_tools_maillogs_prune_commit");



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 56Zeile 56

if($mybb->input['action'] == "view")
{


if($mybb->input['action'] == "view")
{

	$query = $db->simple_select("maillogs", "*", "mid='".$mybb->get_input('mid', 1)."'");

	$query = $db->simple_select("maillogs", "*", "mid='".$mybb->get_input('mid', MyBB::INPUT_INT)."'");

	$log = $db->fetch_array($query);

if(!$log['mid'])

	$log = $db->fetch_array($query);

if(!$log['mid'])

	{

	{

		exit;

		exit;

	}

$plugins->run_hooks("admin_tools_maillogs_view");


	}

$plugins->run_hooks("admin_tools_maillogs_view");


	$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']);

	$log['dateline'] = date($mybb->settings['dateformat'], $log['dateline']).", ".date($mybb->settings['timeformat'], $log['dateline']);

	$log['dateline'] = my_date('relative', $log['dateline']);

	if($mybb->settings['mail_logging'] == 1)

	if($mybb->settings['mail_logging'] == 1)

	{

	{

		$log['message'] = $lang->na;
}
else

		$log['message'] = $lang->na;
}
else

Zeile 85Zeile 85

<?php
$table = new Table();


<?php
$table = new Table();





	$table->construct_cell($lang->to.":");
$table->construct_cell("<a href=\"mailto:{$log['toemail']}\">{$log['toemail']}</a>");
$table->construct_row();


	$table->construct_cell($lang->to.":");
$table->construct_cell("<a href=\"mailto:{$log['toemail']}\">{$log['toemail']}</a>");
$table->construct_row();


	$table->construct_cell($lang->from.":");
$table->construct_cell("<a href=\"mailto:{$log['fromemail']}\">{$log['fromemail']}</a>");
$table->construct_row();


	$table->construct_cell($lang->from.":");
$table->construct_cell("<a href=\"mailto:{$log['fromemail']}\">{$log['fromemail']}</a>");
$table->construct_row();


	$table->construct_cell($lang->ip_address.":");
$table->construct_cell(my_inet_ntop($db->unescape_binary($log['ipaddress'])));
$table->construct_row();

	$table->construct_cell($lang->ip_address.":");
$table->construct_cell(my_inet_ntop($db->unescape_binary($log['ipaddress'])));
$table->construct_row();

Zeile 119Zeile 119

if(!$mybb->input['action'])
{


if(!$mybb->input['action'])
{

 
	$query = $db->simple_select("maillogs l", "COUNT(l.mid) as logs");
$total_rows = $db->fetch_field($query, "logs");


	if(!$mybb->settings['threadsperpage'] || (int)$mybb->settings['threadsperpage'] < 1)

	if(!$mybb->settings['threadsperpage'] || (int)$mybb->settings['threadsperpage'] < 1)

	{

	{

		$mybb->settings['threadsperpage'] = 20;

		$mybb->settings['threadsperpage'] = 20;

	}

$per_page = $mybb->settings['threadsperpage'];

	}

$per_page = $mybb->settings['threadsperpage'];


if(!$per_page)
{
$per_page = 20;
}



if(!$per_page)
{
$per_page = 20;
}


	if($mybb->input['page'] && $mybb->input['page'] > 1)

	if(!empty($mybb->input['page']) && $mybb->input['page'] > 1)

	{

	{

		$mybb->input['page'] = $mybb->get_input('page', 1);

		$mybb->input['page'] = $mybb->get_input('page', MyBB::INPUT_INT);

		$start = ($mybb->input['page']*$per_page)-$per_page;

		$start = ($mybb->input['page']*$per_page)-$per_page;

 
		$pages = ceil($total_rows / $per_page);
if($mybb->input['page'] > $pages)
{
$mybb->input['page'] = 1;
$start = 0;
}

	}
else
{

	}
else
{

Zeile 168Zeile 177
		}
}


		}
}


	$touid = (int)$mybb->input['touid'];
$toname = $db->escape_string($mybb->input['toname']);
$toemail = $db->escape_string_like($mybb->input['toemail']);

	$touid = $mybb->get_input('touid', MyBB::INPUT_INT);
$toname = $db->escape_string($mybb->get_input('toname'));
$toemail = $db->escape_string_like($mybb->get_input('toemail'));





	$fromuid = (int)$mybb->input['fromuid'];
$fromname = $db->escape_string($mybb->input['fromname']);
$fromemail = $db->escape_string_like($mybb->input['fromemail']);

	$fromuid = $mybb->get_input('fromuid', MyBB::INPUT_INT);
$fromemail = $db->escape_string_like($mybb->get_input('fromemail'));






	$subject = $db->escape_string_like($mybb->input['subject']);

	$subject = $db->escape_string_like($mybb->get_input('subject'));


// Begin criteria filtering


// Begin criteria filtering

	if($mybb->input['subject'])


	$additional_sql_criteria = '';
if(!empty($mybb->input['subject']))

	{
$additional_sql_criteria .= " AND l.subject LIKE '%{$subject}%'";
$additional_criteria[] = "subject=".urlencode($mybb->input['subject']);
}


	{
$additional_sql_criteria .= " AND l.subject LIKE '%{$subject}%'";
$additional_criteria[] = "subject=".urlencode($mybb->input['subject']);
}


	if($mybb->input['fromuid'])


	$from_filter = '';
if(!empty($mybb->input['fromuid']))

	{
$query = $db->simple_select("users", "uid, username", "uid = '{$fromuid}'");
$user = $db->fetch_array($query);

	{
$query = $db->simple_select("users", "uid, username", "uid = '{$fromuid}'");
$user = $db->fetch_array($query);

Zeile 194Zeile 204
		$additional_sql_criteria .= " AND l.fromuid = '{$fromuid}'";
$additional_criteria[] = "fromuid={$fromuid}";
}

		$additional_sql_criteria .= " AND l.fromuid = '{$fromuid}'";
$additional_criteria[] = "fromuid={$fromuid}";
}

	else if($mybb->input['fromname'])

	else if(!empty($mybb->input['fromname']))

	{

	{

		$query = $db->simple_select("users", "uid, username", "LOWER(username) = '{$fromname}'");
$user = $db->fetch_array($query);

		$user = get_user_by_username($mybb->input['fromname'], array('fields' => 'uid, username'));


		$from_filter = $user['username'];

if(!$user['uid'])

		$from_filter = $user['username'];

if(!$user['uid'])

Zeile 209Zeile 218
		$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'])

	else if(!empty($mybb->input['fromemail']))


	{
$additional_sql_criteria .= " AND l.fromemail LIKE '%{$fromemail}%'";
$additional_criteria[] = "fromemail=".urlencode($mybb->input['fromemail']);
$from_filter = $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'])
{


	}

$to_filter = '';
if(!empty($mybb->input['touid']))
{

		$query = $db->simple_select("users", "uid, username", "uid = '{$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 = '{$touid}'";
$additional_criteria[] = "touid={$touid}";

		$additional_sql_criteria .= " AND l.touid = '{$touid}'";
$additional_criteria[] = "touid={$touid}";

	}
else if($mybb->input['toname'])

	}
else if(!empty($mybb->input['toname']))

	{
$user = get_user_by_username($toname, array('fields' => 'username'));
$to_filter = $user['username'];

	{
$user = get_user_by_username($toname, array('fields' => 'username'));
$to_filter = $user['username'];

Zeile 236Zeile 245
			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_criteria[] = "touid={$user['uid']}";
}

		$additional_sql_criteria .= "AND l.touid='{$user['uid']}'";
$additional_criteria[] = "touid={$user['uid']}";
}


if($mybb->input['toemail'])

	else if(!empty($mybb->input['toemail']))


	{
$additional_sql_criteria .= " AND l.toemail LIKE '%{$toemail}%'";
$additional_criteria[] = "toemail=".urlencode($mybb->input['toemail']);

	{
$additional_sql_criteria .= " AND l.toemail LIKE '%{$toemail}%'";
$additional_criteria[] = "toemail=".urlencode($mybb->input['toemail']);

Zeile 270Zeile 278
	$form = new Form("index.php?module=tools-maillogs&amp;action=prune", "post");

$table = new Table;

	$form = new Form("index.php?module=tools-maillogs&amp;action=prune", "post");

$table = new Table;

	$table->construct_header($form->generate_check_box("checkall", 1, '', array('class' => 'checkall')));

	$table->construct_header($form->generate_check_box("allbox", 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->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%"));

Zeile 291Zeile 299
	{
$table->construct_cell($form->generate_check_box("log[{$log['mid']}]", $log['mid'], ''), array("width" => 1));
$log['subject'] = htmlspecialchars_uni($log['subject']);

	{
$table->construct_cell($form->generate_check_box("log[{$log['mid']}]", $log['mid'], ''), array("width" => 1));
$log['subject'] = htmlspecialchars_uni($log['subject']);

		$log['dateline'] = date($mybb->settings['dateformat'], $log['dateline']).", ".date($mybb->settings['timeformat'], $log['dateline']);

		$log['dateline'] = my_date('relative', $log['dateline']);





		if($log['type'] == 2)








		$plugins->run_hooks("admin_tools_maillogs_log");

if($log['type'] == 1)
{
$table->construct_cell("<img src=\"styles/{$page->style}/images/icons/maillogs_user.png\" title=\"{$lang->email_sent_to_user}\" alt=\"\" />", array("width" => 1));
$table->construct_cell("<a href=\"javascript:MyBB.popupWindow('index.php?module=tools-maillogs&amp;action=view&amp;mid={$log['mid']}', null, true);\">{$log['subject']}</a>");
}
elseif($log['type'] == 2)

		{
if($log['thread_subject'])
{

		{
if($log['thread_subject'])
{

Zeile 306Zeile 321
			}
$table->construct_cell("<img src=\"styles/{$page->style}/images/icons/maillogs_thread.png\" title=\"{$lang->sent_using_send_thread_feature}\" alt=\"\" />", array("width" => 1));
$table->construct_cell("<a href=\"javascript:MyBB.popupWindow('index.php?module=tools-maillogs&amp;action=view&amp;mid={$log['mid']}', null, true);\">{$log['subject']}</a><br /><small>{$lang->thread} {$thread_link}</small>");

			}
$table->construct_cell("<img src=\"styles/{$page->style}/images/icons/maillogs_thread.png\" title=\"{$lang->sent_using_send_thread_feature}\" alt=\"\" />", array("width" => 1));
$table->construct_cell("<a href=\"javascript:MyBB.popupWindow('index.php?module=tools-maillogs&amp;action=view&amp;mid={$log['mid']}', null, true);\">{$log['subject']}</a><br /><small>{$lang->thread} {$thread_link}</small>");


if($log['fromuid'] > 0)
{
$find_from = "<div class=\"float_right\"><a href=\"index.php?module=tools-maillogs&amp;fromuid={$log['fromuid']}\"><img src=\"styles/{$page->style}/images/icons/find.png\" title=\"{$lang->find_emails_by_user}\" alt=\"{$lang->find}\" /></a></div>";
}

if(!$log['from_username'] && $log['fromuid'] > 0)
{
$table->construct_cell("{$find_from}<div>{$lang->deleted_user}</div>");
}
elseif($log['fromuid'] == 0)
{
$log['fromemail'] = htmlspecialchars_uni($log['fromemail']);
$table->construct_cell("{$find_from}<div>{$log['fromemail']}</div>");
}
else
{
$table->construct_cell("{$find_from}<div><a href=\"../".get_profile_link($log['fromuid'])."\">{$log['from_username']}</a></div>");
}

$log['toemail'] = htmlspecialchars_uni($log['toemail']);
$table->construct_cell($log['toemail']);
}
elseif($log['type'] == 1)
{
$table->construct_cell("<img src=\"styles/{$page->style}/images/icons/maillogs_user.png\" title=\"{$lang->email_sent_to_user}\" alt=\"\" />", array("width" => 1));
$table->construct_cell("<a href=\"javascript:MyBB.popupWindow('index.php?module=tools-maillogs&amp;action=view&amp;mid={$log['mid']}', null, true);\">{$log['subject']}</a>");

if($log['fromuid'] > 0)
{
$find_from = "<div class=\"float_right\"><a href=\"index.php?module=tools-maillogs&amp;fromuid={$log['fromuid']}\"><img src=\"styles/{$page->style}/images/icons/find.png\" title=\"{$lang->find_emails_by_user}\" alt=\"{$lang->find}\" /></a></div>";
}

if(!$log['from_username'] && $log['fromuid'] > 0)
{
$table->construct_cell("{$find_from}<div>{$lang->deleted_user}</div>");
}
elseif($log['fromuid'] == 0)
{
$log['fromemail'] = htmlspecialchars_uni($log['fromemail']);
$table->construct_cell("{$find_from}<div>{$log['fromemail']}</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&amp;touid={$log['touid']}\"><img src=\"styles/{$page->style}/images/icons/find.png\" 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>");
}
else
{
$table->construct_cell("{$find_to}<div><a href=\"../".get_profile_link($log['touid'])."\">{$log['to_username']}</a></div>");
}

 
		}
elseif($log['type'] == 3)
{
$table->construct_cell("<img src=\"styles/{$page->style}/images/icons/maillogs_contact.png\" title=\"{$lang->email_sent_using_contact_form}\" alt=\"\" />", array("width" => 1));
$table->construct_cell("<a href=\"javascript:MyBB.popupWindow('index.php?module=tools-maillogs&amp;action=view&amp;mid={$log['mid']}', null, true);\">{$log['subject']}</a>");

		}
elseif($log['type'] == 3)
{
$table->construct_cell("<img src=\"styles/{$page->style}/images/icons/maillogs_contact.png\" title=\"{$lang->email_sent_using_contact_form}\" alt=\"\" />", array("width" => 1));
$table->construct_cell("<a href=\"javascript:MyBB.popupWindow('index.php?module=tools-maillogs&amp;action=view&amp;mid={$log['mid']}', null, true);\">{$log['subject']}</a>");

 
		}
else
{
$table->construct_cell("<img src=\"styles/{$page->style}/images/icons/default.png\" title=\"{$lang->email}\" alt=\"\" />", array("width" => 1));
$table->construct_cell("<a href=\"javascript:MyBB.popupWindow('index.php?module=tools-maillogs&amp;action=view&amp;mid={$log['mid']}', null, true);\">{$log['subject']}</a>");
}

if($log['fromuid'] > 0)
{
$log['find_from'] = "<div class=\"float_right\"><a href=\"index.php?module=tools-maillogs&amp;fromuid={$log['fromuid']}\"><img src=\"styles/{$page->style}/images/icons/find.png\" title=\"{$lang->find_emails_by_user}\" alt=\"{$lang->find}\" /></a></div>";
}
else
{
$log['find_from'] = '';
}

if(!$log['from_username'] && $log['fromuid'] > 0)
{
$table->construct_cell("{$log['find_from']}<div>{$lang->deleted_user}</div>");
}
elseif($log['fromuid'] == 0)
{
$log['fromemail'] = htmlspecialchars_uni($log['fromemail']);
$table->construct_cell("{$log['find_from']}<div>{$log['fromemail']}</div>");
}
else
{
$table->construct_cell("{$log['find_from']}<div><a href=\"../".get_profile_link($log['fromuid'])."\">{$log['from_username']}</a></div>");
}

if($log['touid'] > 0)
{
$log['find_to'] = "<div class=\"float_right\"><a href=\"index.php?module=tools-maillogs&amp;touid={$log['touid']}\"><img src=\"styles/{$page->style}/images/icons/find.png\" title=\"{$lang->find_emails_to_user}\" alt=\"{$lang->find}\" /></a></div>";
}
else
{
$log['find_to'] = '';
}





			if($log['fromuid'] > 0)
{
$find_from = "<div class=\"float_right\"><a href=\"index.php?module=tools-maillogs&amp;fromuid={$log['fromuid']}\"><img src=\"styles/{$page->style}/images/icons/find.png\" title=\"{$lang->find_emails_by_user}\" alt=\"{$lang->find}\" /></a></div>";
}

if(!$log['from_username'] && $log['fromuid'] > 0)
{
$table->construct_cell("{$find_from}<div>{$lang->deleted_user}</div>");
}
elseif($log['fromuid'] == 0)
{
$log['fromemail'] = htmlspecialchars_uni($log['fromemail']);
$table->construct_cell("{$find_from}<div>{$log['fromemail']}</div>");
}
else
{
$table->construct_cell("{$find_from}<div><a href=\"../".get_profile_link($log['fromuid'])."\">{$log['from_username']}</a></div>");
}


		if(!$log['to_username'] && $log['touid'] > 0)
{
$table->construct_cell("{$log['find_to']}<div>{$lang->deleted_user}</div>");
}
elseif($log['touid'] == 0)
{














			$log['toemail'] = htmlspecialchars_uni($log['toemail']);

			$log['toemail'] = htmlspecialchars_uni($log['toemail']);

			$table->construct_cell($log['toemail']);





			$table->construct_cell("{$log['find_to']}<div>{$log['toemail']}</div>");
}
else
{
$table->construct_cell("{$log['find_to']}<div><a href=\"../".get_profile_link($log['touid'])."\">{$log['to_username']}</a></div>");

		}

$table->construct_cell($log['dateline'], array("class" => "align_center"));
$table->construct_cell(my_inet_ntop($db->unescape_binary($log['ipaddress'])), array("class" => "align_center"));

		}

$table->construct_cell($log['dateline'], array("class" => "align_center"));
$table->construct_cell(my_inet_ntop($db->unescape_binary($log['ipaddress'])), array("class" => "align_center"));

		$table->construct_row();
}

		$table->construct_row();
}


if($table->num_rows() == 0)
{


if($table->num_rows() == 0)
{

Zeile 412Zeile 400

$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&amp;page={page}{$additional_criteria}");

	echo "<br />".draw_admin_pagination($mybb->get_input('page'), $per_page, $total_rows, "index.php?module=tools-maillogs&amp;page={page}{$additional_criteria}");





$form = new Form("index.php?module=tools-maillogs", "post");
$form_container = new FormContainer($lang->filter_user_email_log);


$form = new Form("index.php?module=tools-maillogs", "post");
$form_container = new FormContainer($lang->filter_user_email_log);

Zeile 423Zeile 408
		"user" => $lang->username_is,
"email" => $lang->email_contains
);

		"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)


	$form_container->output_row($lang->subject_contains, "", $form->generate_text_box('subject', $mybb->get_input('subject'), array('id' => 'subject')), 'subject');
$from_type = '';
if($mybb->get_input('fromname'))

	{
$from_type = "user";
}

	{
$from_type = "user";
}

	else if($mybb->input['fromemail'])

	else if($mybb->get_input('fromemail'))

	{
$from_type = "email";
}

	{
$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)


	$form_container->output_row($lang->from, "", $form->generate_select_box('from_type', $user_email, $from_type)." ".$form->generate_text_box('from_value', htmlspecialchars_uni($from_filter), array('id' => 'from_value')), 'from_value');
$to_type = '';
if($mybb->get_input('toname'))

	{
$to_type = "user";
}

	{
$to_type = "user";
}

	else if($mybb->input['toemail'])

	else if($mybb->get_input('toemail'))

	{
$to_type = "email";
}

	{
$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->output_row($lang->to, "", $form->generate_select_box('to_type', $user_email, $to_type)." ".$form->generate_text_box('to_value', htmlspecialchars_uni($to_filter), array('id' => 'to_value')), 'to_value');

	$form_container->end();
$buttons = array();
$buttons[] = $form->generate_submit_button($lang->filter_user_email_log);

	$form_container->end();
$buttons = array();
$buttons[] = $form->generate_submit_button($lang->filter_user_email_log);

Zeile 450Zeile 437

$page->output_footer();
}


$page->output_footer();
}

?>