Vergleich modcp.php - 1.6.1 - 1.6.13

  Keine Änderungen   Hinzugefügt   Modifiziert   Entfernt
Zeile 6Zeile 6
 * Website: http://mybb.com
* License: http://mybb.com/about/license
*

 * Website: http://mybb.com
* License: http://mybb.com/about/license
*

 * $Id: modcp.php 5120 2010-07-26 20:10:05Z RyanGordon $

 * $Id$

 */

define("IN_MYBB", 1);
define('THIS_SCRIPT', 'modcp.php');


 */

define("IN_MYBB", 1);
define('THIS_SCRIPT', 'modcp.php');


$templatelist = "modcp_reports,modcp_reports_report,modcp_reports_multipage,modcp_reports_allreport";
$templatelist .= ",modcp_reports_allnoreports,modcp_reports_noreports,modcp_banning,modcp_banning_ban";
$templatelist .= ",modcp_banning_multipage,modcp_banning_nobanned,modcp_banning_auser,modcp_banning_error";
$templatelist .= ",modcp_banning_edit,modcp_banning_banned_user,modcp_nav,modcp_modlogs_noresults,modcp";
$templatelist .= ",modcp_no_announcements_global,modcp_announcements_global,modcp_announcements_forum,modcp_announcements";
$templatelist .= ",codebuttons,smilieinsert,modcp_announcements_new,modcp_modqueue_empty,forumjump_bit,forumjump_special";
$templatelist .= ",modcp_modlogs,modcp_finduser_user,modcp_finduser,usercp_profile_customfield,usercp_profile_profilefields";
$templatelist .= ",modcp_editprofile,modcp_ipsearch,modcp_banuser_addusername,modcp_banuser,modcp_warninglogs_nologs";
$templatelist .= ",modcp_warninglogs,modcp_modlogs_result,modcp_editprofile_signature_info,modcp_editprofile_signature_options,modcp_editprofile_signature";


$templatelist = "modcp_reports,modcp_reports_report,modcp_reports_multipage,modcp_reports_allreport,modcp_reports_allreports,modcp_modlogs_multipage,modcp_announcements_delete,modcp_announcements_edit";
$templatelist .= ",modcp_reports_allnoreports,modcp_reports_noreports,modcp_banning,modcp_banning_ban,modcp_announcements_announcement_global,modcp_no_announcements_forum,modcp_modqueue_threads_thread";
$templatelist .= ",modcp_banning_multipage,modcp_banning_nobanned,modcp_modqueue_threads_empty,modcp_modqueue_masscontrols,modcp_modqueue_threads,modcp_modqueue_posts_post,modcp_modqueue_posts_empty";
$templatelist .= ",modcp_nav,modcp_modlogs_noresults,modcp,modcp_modqueue_posts,modcp_modqueue_attachments_attachment,modcp_modqueue_attachments_empty,modcp_modqueue_attachments,modcp_editprofile_suspensions_info";
$templatelist .= ",modcp_no_announcements_global,modcp_announcements_global,modcp_announcements_forum,modcp_announcements,modcp_editprofile_select_option,modcp_editprofile_select,modcp_finduser_noresults";
$templatelist .= ",codebuttons,smilieinsert,modcp_announcements_new,modcp_modqueue_empty,forumjump_bit,forumjump_special,modcp_warninglogs_warning_revoked,modcp_warninglogs_warning,modcp_ipsearch_result";
$templatelist .= ",modcp_modlogs,modcp_finduser_user,modcp_finduser,usercp_profile_customfield,usercp_profile_profilefields,modcp_ipsearch_noresults,modcp_ipsearch_results,modcp_ipsearch_misc_info";
$templatelist .= ",modcp_editprofile,modcp_ipsearch,modcp_banuser_addusername,modcp_banuser,modcp_warninglogs_nologs,modcp_banuser_editusername,modcp_lastattachment,modcp_lastpost,modcp_lastthread,modcp_nobanned";
$templatelist .= ",modcp_warninglogs,modcp_modlogs_result,modcp_editprofile_signature,forumjump_advanced,smilieinsert_getmore,modcp_announcements_forum_nomod,modcp_announcements_announcement,multipage_prevpage";
$templatelist .= ",multipage_start,multipage_page_current,multipage_page,multipage_end,multipage_nextpage,multipage";


require_once "./global.php";
require_once MYBB_ROOT."inc/functions_user.php";


require_once "./global.php";
require_once MYBB_ROOT."inc/functions_user.php";

Zeile 46Zeile 47
$moderated_forums = array();
if($mybb->usergroup['issupermod'] != 1)
{

$moderated_forums = array();
if($mybb->usergroup['issupermod'] != 1)
{

	$query = $db->simple_select("moderators", "*", "id='{$mybb->user['uid']}' AND isgroup = '0'");

	$query = $db->simple_select("moderators", "*", "(id='{$mybb->user['uid']}' AND isgroup = '0') OR (id='{$mybb->user['usergroup']}' AND isgroup = '1')");

	while($forum = $db->fetch_array($query))
{
$flist .= ",'{$forum['fid']}'";

	while($forum = $db->fetch_array($query))
{
$flist .= ",'{$forum['fid']}'";

		



		$children = get_child_list($forum['fid']);
if(!empty($children))
{
$flist .= ",'".implode("','", $children)."'";
}
$moderated_forums[] = $forum['fid'];

		$children = get_child_list($forum['fid']);
if(!empty($children))
{
$flist .= ",'".implode("','", $children)."'";
}
$moderated_forums[] = $forum['fid'];

	}

	}

	if($flist)
{
$tflist = " AND t.fid IN (0{$flist})";
$flist = " AND fid IN (0{$flist})";

	if($flist)
{
$tflist = " AND t.fid IN (0{$flist})";
$flist = " AND fid IN (0{$flist})";

	}
}

















	}
}
else
{
$flist = $tflist = '';
}

// Retrieve a list of unviewable forums
$unviewableforums = get_unviewable_forums();

if($unviewableforums && !is_super_admin($mybb->user['uid']))
{
$flist .= " AND fid NOT IN ({$unviewableforums})";
$tflist .= " AND t.fid NOT IN ({$unviewableforums})";

$unviewableforums = str_replace("'", '', $unviewableforums);
$unviewableforums = explode(',', $unviewableforums);
}

else
{

else
{

	$flist = $tflist = '';

	$unviewableforums = array();

}

// Fetch the Mod CP menu

}

// Fetch the Mod CP menu

Zeile 87Zeile 104
		error($lang->error_noselected_reports);
}


		error($lang->error_noselected_reports);
}


	$mybb->input['reports'] = array_map("intval", $mybb->input['reports']);
$rids = implode($mybb->input['reports'], "','");
$rids = "'0','{$rids}'";







	$sql = '1=1';
if(!$mybb->input['allbox'])
{
$mybb->input['reports'] = array_map("intval", $mybb->input['reports']);
$rids = implode($mybb->input['reports'], "','");
$rids = "'0','{$rids}'";

$sql = "rid IN ({$rids})";
}


$plugins->run_hooks("modcp_do_reports");



$plugins->run_hooks("modcp_do_reports");


	$db->update_query("reportedposts", array('reportstatus' => 1), "rid IN ({$rids}){$flist}");

	$db->update_query("reportedposts", array('reportstatus' => 1), "{$sql}{$flist}");

	$cache->update_reportedposts();

	$cache->update_reportedposts();

	



	$page = intval($mybb->input['page']);

	$page = intval($mybb->input['page']);

	



	redirect("modcp.php?action=reports&page={$page}", $lang->redirect_reportsmarked);
}

if($mybb->input['action'] == "reports")
{
add_breadcrumb($lang->mcp_nav_reported_posts, "modcp.php?action=reports");

	redirect("modcp.php?action=reports&page={$page}", $lang->redirect_reportsmarked);
}

if($mybb->input['action'] == "reports")
{
add_breadcrumb($lang->mcp_nav_reported_posts, "modcp.php?action=reports");


if(!$mybb->settings['threadsperpage'])
{


if(!$mybb->settings['threadsperpage'])
{

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

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

	}


	}


	// Figure out if we need to display multiple pages.
$perpage = $mybb->settings['threadsperpage'];
if($mybb->input['page'] != "last")
{
$page = intval($mybb->input['page']);

	// Figure out if we need to display multiple pages.
$perpage = $mybb->settings['threadsperpage'];
if($mybb->input['page'] != "last")
{
$page = intval($mybb->input['page']);

	}


	}


	$query = $db->simple_select("reportedposts", "COUNT(rid) AS count", "reportstatus ='0'");
$report_count = $db->fetch_field($query, "count");

	$query = $db->simple_select("reportedposts", "COUNT(rid) AS count", "reportstatus ='0'");
$report_count = $db->fetch_field($query, "count");





	$mybb->input['rid'] = intval($mybb->input['rid']);

	$mybb->input['rid'] = intval($mybb->input['rid']);





	if($mybb->input['rid'])
{
$query = $db->simple_select("reportedposts", "COUNT(rid) AS count", "rid <= '".$mybb->input['rid']."'");

	if($mybb->input['rid'])
{
$query = $db->simple_select("reportedposts", "COUNT(rid) AS count", "rid <= '".$mybb->input['rid']."'");

Zeile 138Zeile 161
	$postcount = intval($report_count);
$pages = $postcount / $perpage;
$pages = ceil($pages);

	$postcount = intval($report_count);
$pages = $postcount / $perpage;
$pages = ceil($pages);





	if($mybb->input['page'] == "last")
{
$page = $pages;

	if($mybb->input['page'] == "last")
{
$page = $pages;

Zeile 150Zeile 173
	}

if($page && $page > 0)

	}

if($page && $page > 0)

	{
$start = ($page-1) * $perpage;
}
else
{
$start = 0;
$page = 1;

	{
$start = ($page-1) * $perpage;
}
else
{
$start = 0;
$page = 1;

	}
$upper = $start+$perpage;


	}
$upper = $start+$perpage;


Zeile 164Zeile 187
	if($postcount > $perpage)
{
eval("\$reportspages = \"".$templates->get("modcp_reports_multipage")."\";");

	if($postcount > $perpage)
{
eval("\$reportspages = \"".$templates->get("modcp_reports_multipage")."\";");

	}


	}


	$query = $db->simple_select("forums", "fid, name");
while($forum = $db->fetch_array($query))
{
$forums[$forum['fid']] = $forum['name'];

	$query = $db->simple_select("forums", "fid, name");
while($forum = $db->fetch_array($query))
{
$forums[$forum['fid']] = $forum['name'];

	}


	}


	$plugins->run_hooks("modcp_reports_start");

$reports = '';

	$plugins->run_hooks("modcp_reports_start");

$reports = '';

Zeile 186Zeile 209
		ORDER BY r.dateline DESC
LIMIT {$start}, {$perpage}
");

		ORDER BY r.dateline DESC
LIMIT {$start}, {$perpage}
");

	while($report = $db->fetch_array($query))







if(!$db->num_rows($query))
{
eval("\$reports = \"".$templates->get("modcp_reports_noreports")."\";");
}
else

	{

	{

		$trow = alt_trow();
if(is_moderator($report['fid']))

		while($report = $db->fetch_array($query))


		{

		{

			$trow = 'trow_shaded';















			$trow = alt_trow();
if(is_moderator($report['fid']))
{
$trow = 'trow_shaded';
}

$report['postlink'] = get_post_link($report['pid'], $report['tid']);
$report['threadlink'] = get_thread_link($report['tid']);
$report['posterlink'] = get_profile_link($report['postuid']);
$report['reporterlink'] = get_profile_link($report['uid']);
$reportdate = my_date($mybb->settings['dateformat'], $report['dateline']);
$reporttime = my_date($mybb->settings['timeformat'], $report['dateline']);
$report['threadsubject'] = htmlspecialchars_uni($parser->parse_badwords($report['threadsubject']));

eval("\$reports .= \"".$templates->get("modcp_reports_report")."\";");

		}

		}

		$report['postlink'] = get_post_link($report['pid'], $report['tid']);
$report['threadlink'] = get_thread_link($report['tid']);
$report['posterlink'] = get_profile_link($report['postuid']);
$report['reporterlink'] = get_profile_link($report['uid']);
$reportdate = my_date($mybb->settings['dateformat'], $report['dateline']);
$reporttime = my_date($mybb->settings['timeformat'], $report['dateline']);
$report['threadsubject'] = htmlspecialchars_uni($parser->parse_badwords($report['threadsubject']));
eval("\$reports .= \"".$templates->get("modcp_reports_report")."\";");
}
if(!$reports)
{
eval("\$reports = \"".$templates->get("modcp_reports_noreports")."\";");

 
	}


	}


	$plugins->run_hooks("modcp_reports");

	$plugins->run_hooks("modcp_reports_end");


eval("\$reportedposts = \"".$templates->get("modcp_reports")."\";");
output_page($reportedposts);


eval("\$reportedposts = \"".$templates->get("modcp_reports")."\";");
output_page($reportedposts);

Zeile 277Zeile 306
		eval("\$allreportspages = \"".$templates->get("modcp_reports_multipage")."\";");
}


		eval("\$allreportspages = \"".$templates->get("modcp_reports_multipage")."\";");
}


	$query = $db->simple_select("forums", "fid, name");
while($forum = $db->fetch_array($query))
{
$forums[$forum['fid']] = $forum['name'];
}


 
	$plugins->run_hooks("modcp_allreports_start");

	$plugins->run_hooks("modcp_allreports_start");


$reports = '';




	$query = $db->query("
SELECT r.*, u.username, up.username AS postusername, up.uid AS postuid, t.subject AS threadsubject
FROM ".TABLE_PREFIX."reportedposts r

	$query = $db->query("
SELECT r.*, u.username, up.username AS postusername, up.uid AS postuid, t.subject AS threadsubject
FROM ".TABLE_PREFIX."reportedposts r

Zeile 294Zeile 316
		LEFT JOIN ".TABLE_PREFIX."users u ON (r.uid=u.uid)
LEFT JOIN ".TABLE_PREFIX."users up ON (p.uid=up.uid)
ORDER BY r.dateline DESC

		LEFT JOIN ".TABLE_PREFIX."users u ON (r.uid=u.uid)
LEFT JOIN ".TABLE_PREFIX."users up ON (p.uid=up.uid)
ORDER BY r.dateline DESC

		LIMIT $start, $perpage

		LIMIT {$start}, {$perpage}

	");

	");

	while($report = $db->fetch_array($query))
{
$report['postlink'] = get_post_link($report['pid'], $report['tid']);
$report['threadlink'] = get_thread_link($report['tid']);
$report['posterlink'] = get_profile_link($report['postuid']);
$report['reporterlink'] = get_profile_link($report['uid']);

$reportdate = my_date($mybb->settings['dateformat'], $report['dateline']);
$reporttime = my_date($mybb->settings['timeformat'], $report['dateline']);

if($report['reportstatus'] == 0)
{
$trow = "trow_shaded";
}
else
{
$trow = alt_trow();
}

$report['postusername'] = build_profile_link($report['postusername'], $report['postuid']);

if($report['threadsubject'])
{
$report['threadsubject'] = htmlspecialchars_uni($parser->parse_badwords($report['threadsubject']));
$report['threadsubject'] = "<a href=\"".get_thread_link($report['tid'])."\" target=\"_blank\">{$report['threadsubject']}</a>";
}
else
{
$report['threadsubject'] = $lang->na;
}

eval("\$allreports .= \"".$templates->get("modcp_reports_allreport")."\";");
}

 




	if(!$allreports)


	$allreports = '';
if(!$db->num_rows($query))

	{
eval("\$allreports = \"".$templates->get("modcp_reports_allnoreports")."\";");

	{
eval("\$allreports = \"".$templates->get("modcp_reports_allnoreports")."\";");

	}

$plugins->run_hooks("modcp_reports");







































	}
else
{
while($report = $db->fetch_array($query))
{
$trow = alt_trow();

$report['threadlink'] = get_thread_link($report['tid']);

$report['posterlink'] = get_profile_link($report['postuid']);
$report['postlink'] = get_post_link($report['pid'], $report['tid']);
$report['postusername'] = build_profile_link($report['postusername'], $report['postuid']);
$report['reporterlink'] = get_profile_link($report['uid']);

$reportdate = my_date($mybb->settings['dateformat'], $report['dateline']);
$reporttime = my_date($mybb->settings['timeformat'], $report['dateline']);

if($report['reportstatus'] == 0)
{
$trow = "trow_shaded";
}

// No subject? Set it to N/A
if($report['threadsubject'] == '')
{
$report['threadsubject'] = $lang->na;
}
else
{
// Only parse bad words and sanitize subject if there is one...
$report['threadsubject'] = htmlspecialchars_uni($parser->parse_badwords($report['threadsubject']));
}

$report['threadsubject'] = "<a href=\"".get_thread_link($report['tid'])."\" target=\"_blank\">{$report['threadsubject']}</a>";

eval("\$allreports .= \"".$templates->get("modcp_reports_allreport")."\";");
}
}

$plugins->run_hooks("modcp_allreports_end");


	eval("\$allreportedposts = \"".$templates->get("modcp_reports_allreports")."\";");
output_page($allreportedposts);
}

	eval("\$allreportedposts = \"".$templates->get("modcp_reports_allreports")."\";");
output_page($allreportedposts);
}

Zeile 385Zeile 412
	{
$order = "desc";
}

	{
$order = "desc";
}

	



	$plugins->run_hooks("modcp_modlogs_start");

$query = $db->query("

	$plugins->run_hooks("modcp_modlogs_start");

$query = $db->query("

Zeile 393Zeile 420
		FROM ".TABLE_PREFIX."moderatorlog l
LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid=l.uid)
LEFT JOIN ".TABLE_PREFIX."threads t ON (t.tid=l.tid)

		FROM ".TABLE_PREFIX."moderatorlog l
LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid=l.uid)
LEFT JOIN ".TABLE_PREFIX."threads t ON (t.tid=l.tid)

		WHERE 1=1 {$where}

		WHERE 1=1 {$where}{$tflist}

	");
$rescount = $db->fetch_field($query, "count");


	");
$rescount = $db->fetch_field($query, "count");


Zeile 439Zeile 466
		LEFT JOIN ".TABLE_PREFIX."threads t ON (t.tid=l.tid)
LEFT JOIN ".TABLE_PREFIX."forums f ON (f.fid=l.fid)
LEFT JOIN ".TABLE_PREFIX."posts p ON (p.pid=l.pid)

		LEFT JOIN ".TABLE_PREFIX."threads t ON (t.tid=l.tid)
LEFT JOIN ".TABLE_PREFIX."forums f ON (f.fid=l.fid)
LEFT JOIN ".TABLE_PREFIX."posts p ON (p.pid=l.pid)

		WHERE 1=1 {$where}

		WHERE 1=1 {$where}{$tflist}

		ORDER BY {$sortby} {$order}
LIMIT {$start}, {$perpage}
");
while($logitem = $db->fetch_array($query))
{
$information = '';

		ORDER BY {$sortby} {$order}
LIMIT {$start}, {$perpage}
");
while($logitem = $db->fetch_array($query))
{
$information = '';

 
		$logitem['action'] = htmlspecialchars_uni($logitem['action']);

		$log_date = my_date($mybb->settings['dateformat'], $logitem['dateline']);
$log_time = my_date($mybb->settings['timeformat'], $logitem['dateline']);
$trow = alt_trow();

		$log_date = my_date($mybb->settings['dateformat'], $logitem['dateline']);
$log_time = my_date($mybb->settings['timeformat'], $logitem['dateline']);
$trow = alt_trow();

Zeile 481Zeile 509
	{
eval("\$results = \"".$templates->get("modcp_modlogs_noresults")."\";");
}

	{
eval("\$results = \"".$templates->get("modcp_modlogs_noresults")."\";");
}

	



	$plugins->run_hooks("modcp_modlogs_filter");

// Fetch filter options
$sortbysel[$mybb->input['sortby']] = "selected=\"selected\"";
$ordersel[$mybb->input['order']] = "selected=\"selected\"";

	$plugins->run_hooks("modcp_modlogs_filter");

// Fetch filter options
$sortbysel[$mybb->input['sortby']] = "selected=\"selected\"";
$ordersel[$mybb->input['order']] = "selected=\"selected\"";

	$query = $db->query("
SELECT DISTINCT l.uid, u.username

	$query = $db->query("
SELECT DISTINCT l.uid, u.username

		FROM ".TABLE_PREFIX."moderatorlog l
LEFT JOIN ".TABLE_PREFIX."users u ON (l.uid=u.uid)
ORDER BY u.username ASC

		FROM ".TABLE_PREFIX."moderatorlog l
LEFT JOIN ".TABLE_PREFIX."users u ON (l.uid=u.uid)
ORDER BY u.username ASC

Zeile 500Zeile 528
		{
$user['username'] = $lang->na_deleted;
}

		{
$user['username'] = $lang->na_deleted;
}

		



		$selected = '';
if($mybb->input['uid'] == $user['uid'])
{
$selected = " selected=\"selected\"";
}
$user_options .= "<option value=\"{$user['uid']}\"{$selected}>".htmlspecialchars_uni($user['username'])."</option>\n";

		$selected = '';
if($mybb->input['uid'] == $user['uid'])
{
$selected = " selected=\"selected\"";
}
$user_options .= "<option value=\"{$user['uid']}\"{$selected}>".htmlspecialchars_uni($user['username'])."</option>\n";

	}


	}


	$forum_select = build_forum_jump("", $mybb->input['fid'], 1, '', 0, true, '', "fid");

eval("\$modlogs = \"".$templates->get("modcp_modlogs")."\";");
output_page($modlogs);

	$forum_select = build_forum_jump("", $mybb->input['fid'], 1, '', 0, true, '', "fid");

eval("\$modlogs = \"".$templates->get("modcp_modlogs")."\";");
output_page($modlogs);

}


}


if($mybb->input['action'] == "do_delete_announcement")
{
verify_post_check($mybb->input['my_post_key']);

if($mybb->input['action'] == "do_delete_announcement")
{
verify_post_check($mybb->input['my_post_key']);

Zeile 527Zeile 555
	{
error($lang->error_invalid_announcement);
}

	{
error($lang->error_invalid_announcement);
}

	if(($mybb->usergroup['issupermod'] != 1 && $announcement['fid'] == -1) || ($announcement['fid'] != -1 && !is_moderator($announcement['fid'])))

	if(($mybb->usergroup['issupermod'] != 1 && $announcement['fid'] == -1) || ($announcement['fid'] != -1 && !is_moderator($announcement['fid'])) || ($unviewableforums && in_array($announcement['fid'], $unviewableforums)))

	{
error_no_permission();
}

	{
error_no_permission();
}

	



	$plugins->run_hooks("modcp_do_delete_announcement");

$db->delete_query("announcements", "aid='{$aid}'");

	$plugins->run_hooks("modcp_do_delete_announcement");

$db->delete_query("announcements", "aid='{$aid}'");




	$cache->update_forumsdisplay();


	redirect("modcp.php?action=announcements", $lang->redirect_delete_announcement);
}

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

	redirect("modcp.php?action=announcements", $lang->redirect_delete_announcement);
}

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

{
$aid = intval($mybb->input['aid']);

{
$aid = intval($mybb->input['aid']);

	$query = $db->simple_select("announcements", "aid, subject, fid", "aid='{$aid}'");

	$query = $db->simple_select("announcements", "aid, subject, fid", "aid='{$aid}'");

 


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

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




	$announcement['subject'] = htmlspecialchars_uni($announcement['subject']);


	if(!$announcement['aid'])
{
error($lang->error_invalid_announcement);

	if(!$announcement['aid'])
{
error($lang->error_invalid_announcement);

	}
if(($mybb->usergroup['issupermod'] != 1 && $announcement['fid'] == -1) || ($announcement['fid'] != -1 && !is_moderator($announcement['fid'])))
{
error_no_permission();
}

$plugins->run_hooks("modcp_delete_announcement");



	}

if(($mybb->usergroup['issupermod'] != 1 && $announcement['fid'] == -1) || ($announcement['fid'] != -1 && !is_moderator($announcement['fid'])) || ($unviewableforums && in_array($announcement['fid'], $unviewableforums)))
{
error_no_permission();
}

$plugins->run_hooks("modcp_delete_announcement");


	eval("\$announcements = \"".$templates->get("modcp_announcements_delete")."\";");
output_page($announcements);
}

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

	eval("\$announcements = \"".$templates->get("modcp_announcements_delete")."\";");
output_page($announcements);
}

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

{
verify_post_check($mybb->input['my_post_key']);

$announcement_fid = intval($mybb->input['fid']);
if(($mybb->usergroup['issupermod'] != 1 && $announcement_fid == -1) || ($announcement_fid != -1 && !is_moderator($announcement_fid)))
{
error_no_permission();
}

if(!trim($mybb->input['title']))
{
$errors[] = $lang->error_missing_title;
}

if(!trim($mybb->input['message']))
{
$errors[] = $lang->error_missing_message;
}

if(!trim($mybb->input['fid']))
{
$errors[] = $lang->error_missing_forum;
}

$startdate = @explode(" ", $mybb->input['starttime_time']);
$startdate = @explode(":", $startdate[0]);
$enddate = @explode(" ", $mybb->input['endtime_time']);
$enddate = @explode(":", $enddate[0]);

if(stristr($mybb->input['starttime_time'], "pm"))
{
$startdate[0] = 12+$startdate[0];
if($startdate[0] >= 24)
{

{
verify_post_check($mybb->input['my_post_key']);

$announcement_fid = intval($mybb->input['fid']);
if(($mybb->usergroup['issupermod'] != 1 && $announcement_fid == -1) || ($announcement_fid != -1 && !is_moderator($announcement_fid)) || ($unviewableforums && in_array($announcement['fid'], $unviewableforums)))
{
error_no_permission();
}

if(!trim($mybb->input['title']))
{
$errors[] = $lang->error_missing_title;
}

if(!trim($mybb->input['message']))
{
$errors[] = $lang->error_missing_message;
}

if(!trim($mybb->input['fid']))
{
$errors[] = $lang->error_missing_forum;
}

$startdate = @explode(" ", $mybb->input['starttime_time']);
$startdate = @explode(":", $startdate[0]);
$enddate = @explode(" ", $mybb->input['endtime_time']);
$enddate = @explode(":", $enddate[0]);

if(stristr($mybb->input['starttime_time'], "pm"))
{
$startdate[0] = 12+$startdate[0];
if($startdate[0] >= 24)
{

			$startdate[0] = "00";
}
}

			$startdate[0] = "00";
}
}

Zeile 607Zeile 639
			$enddate[0] = "00";
}
}

			$enddate[0] = "00";
}
}

	
$months = array('01', '02', '03', '04', '05', '06', '07', '08', '09', '10', '11', '12');


$months = array('01', '02', '03', '04', '05', '06', '07', '08', '09', '10', '11', '12');

	if(!in_array($mybb->input['starttime_month'], $months))
{
$mybb->input['starttime_month'] = 1;
}

$startdate = gmmktime(intval($startdate[0]), intval($startdate[1]), 0, (int)$mybb->input['starttime_month'], intval($mybb->input['starttime_day']), intval($mybb->input['starttime_year']));

	if(!in_array($mybb->input['starttime_month'], $months))
{
$mybb->input['starttime_month'] = 1;
}

$startdate = gmmktime(intval($startdate[0]), intval($startdate[1]), 0, (int)$mybb->input['starttime_month'], intval($mybb->input['starttime_day']), intval($mybb->input['starttime_year']));

	
if($startdate < 0 || $startdate == false)

	if(!checkdate(intval($mybb->input['starttime_month']), intval($mybb->input['starttime_day']), intval($mybb->input['starttime_year'])) || $startdate < 0 || $startdate == false)


	{
$errors[] = $lang->error_invalid_start_date;
}

	{
$errors[] = $lang->error_invalid_start_date;
}

Zeile 628Zeile 659
	else
{
if(!in_array($mybb->input['endtime_month'], $months))

	else
{
if(!in_array($mybb->input['endtime_month'], $months))

		{

		{

			$mybb->input['endtime_month'] = 1;
}
$enddate = gmmktime(intval($enddate[0]), intval($enddate[1]), 0, (int)$mybb->input['endtime_month'], intval($mybb->input['endtime_day']), intval($mybb->input['endtime_year']));

			$mybb->input['endtime_month'] = 1;
}
$enddate = gmmktime(intval($enddate[0]), intval($enddate[1]), 0, (int)$mybb->input['endtime_month'], intval($mybb->input['endtime_day']), intval($mybb->input['endtime_year']));

		if($enddate < 0 || $enddate == false)

		if(!checkdate(intval($mybb->input['endtime_month']), intval($mybb->input['endtime_day']), intval($mybb->input['endtime_year'])) || $enddate < 0 || $enddate == false)

		{
$errors[] = $lang->error_invalid_end_date;
}

		{
$errors[] = $lang->error_invalid_end_date;
}

		elseif($enddate < $startdate)

		if($enddate <= $startdate)

		{
$errors[] = $lang->error_end_before_start;
}
}

		{
$errors[] = $lang->error_end_before_start;
}
}

	



	$plugins->run_hooks("modcp_do_new_announcement_start");

if(!$errors)

	$plugins->run_hooks("modcp_do_new_announcement_start");

if(!$errors)

Zeile 659Zeile 690
		);

$aid = $db->insert_query("announcements", $insert_announcement);

		);

$aid = $db->insert_query("announcements", $insert_announcement);

		



		$plugins->run_hooks("modcp_do_new_announcement_end");

		$plugins->run_hooks("modcp_do_new_announcement_end");

		



$cache->update_forumsdisplay();

		redirect("modcp.php?action=announcements", $lang->redirect_add_announcement);
}
else

		redirect("modcp.php?action=announcements", $lang->redirect_add_announcement);
}
else

	{

	{

		$mybb->input['action'] = 'new_announcement';
}
}

		$mybb->input['action'] = 'new_announcement';
}
}

Zeile 677Zeile 709

$announcement_fid = intval($mybb->input['fid']);



$announcement_fid = intval($mybb->input['fid']);


	if(($mybb->usergroup['issupermod'] != 1 && $announcement_fid == -1) || ($announcement_fid != -1 && !is_moderator($announcement_fid)))

	if(($mybb->usergroup['issupermod'] != 1 && $announcement_fid == -1) || ($announcement_fid != -1 && !is_moderator($announcement_fid)) || ($unviewableforums && in_array($announcement['fid'], $unviewableforums)))

	{
error_no_permission();
}

	{
error_no_permission();
}

Zeile 686Zeile 718
	if(is_array($errors))
{
$errors = inline_error($errors);

	if(is_array($errors))
{
$errors = inline_error($errors);

		



		// Set $announcement to input stuff
$announcement['subject'] = $mybb->input['title'];
$announcement['message'] = $mybb->input['message'];
$announcement['allowhtml'] = $mybb->input['allowhtml'];
$announcement['allowmycode'] = $mybb->input['allowmycode'];
$announcement['allowsmilies'] = $mybb->input['allowsmilies'];

		// Set $announcement to input stuff
$announcement['subject'] = $mybb->input['title'];
$announcement['message'] = $mybb->input['message'];
$announcement['allowhtml'] = $mybb->input['allowhtml'];
$announcement['allowmycode'] = $mybb->input['allowmycode'];
$announcement['allowsmilies'] = $mybb->input['allowsmilies'];

		
$months = array('01', '02', '03', '04', '05', '06', '07', '08', '09', '10', '11', '12');


$months = array('01', '02', '03', '04', '05', '06', '07', '08', '09', '10', '11', '12');

		if(!in_array($mybb->input['starttime_month'], $months))
{
$mybb->input['starttime_month'] = 1;

		if(!in_array($mybb->input['starttime_month'], $months))
{
$mybb->input['starttime_month'] = 1;

		}


		}


		if(!in_array($mybb->input['endtime_month'], $months))
{
$mybb->input['endtime_month'] = 1;
}

		if(!in_array($mybb->input['endtime_month'], $months))
{
$mybb->input['endtime_month'] = 1;
}

		



		$startmonth = $mybb->input['starttime_month'];
$startdateyear = htmlspecialchars_uni($mybb->input['starttime_year']);
$startday = intval($mybb->input['starttime_day']);

		$startmonth = $mybb->input['starttime_month'];
$startdateyear = htmlspecialchars_uni($mybb->input['starttime_year']);
$startday = intval($mybb->input['starttime_day']);

		$starttime_time = htmlspecialchars($mybb->input['starttime_time']);

		$starttime_time = htmlspecialchars_uni($mybb->input['starttime_time']);

		$endmonth = $mybb->input['endtime_month'];
$enddateyear = htmlspecialchars_uni($mybb->input['endtime_year']);
$endday = intval($mybb->input['endtime_day']);

		$endmonth = $mybb->input['endtime_month'];
$enddateyear = htmlspecialchars_uni($mybb->input['endtime_year']);
$endday = intval($mybb->input['endtime_day']);

		$endtime_time = htmlspecialchars($mybb->input['endtime_time']);

		$endtime_time = htmlspecialchars_uni($mybb->input['endtime_time']);

	}
else
{

	}
else
{

Zeile 809Zeile 841
	}

if($mybb->input['endtime_type'] == 2 || !isset($mybb->input['endtime_type']))

	}

if($mybb->input['endtime_type'] == 2 || !isset($mybb->input['endtime_type']))

	{

	{

		$end_type_sel['infinite'] = ' checked="checked"';

		$end_type_sel['infinite'] = ' checked="checked"';

	}

	}

	else
{
$end_type_sel['finite'] = ' checked="checked"';
}

	else
{
$end_type_sel['finite'] = ' checked="checked"';
}





	// MyCode editor
$codebuttons = build_mycode_inserter();
$smilieinserter = build_clickable_smilies();

	// MyCode editor
$codebuttons = build_mycode_inserter();
$smilieinserter = build_clickable_smilies();

	



	$plugins->run_hooks("modcp_new_announcement");

eval("\$announcements = \"".$templates->get("modcp_announcements_new")."\";");

	$plugins->run_hooks("modcp_new_announcement");

eval("\$announcements = \"".$templates->get("modcp_announcements_new")."\";");

Zeile 843Zeile 875
	}

// Mod has permissions to edit this announcement

	}

// Mod has permissions to edit this announcement

	if(($mybb->usergroup['issupermod'] != 1 && $announcement['fid'] == -1) || ($announcement['fid'] != -1 && !is_moderator($announcement['fid'])))

	if(($mybb->usergroup['issupermod'] != 1 && $announcement['fid'] == -1) || ($announcement['fid'] != -1 && !is_moderator($announcement['fid'])) || ($unviewableforums && in_array($announcement['fid'], $unviewableforums)))

	{
error_no_permission();
}

	{
error_no_permission();
}

Zeile 887Zeile 919
		}
}


		}
}


	$months = array('01', '02', '03', '04', '05', '06', '07', '08', '09', '10', '11', '12');			

	$months = array('01', '02', '03', '04', '05', '06', '07', '08', '09', '10', '11', '12');

	if(!in_array($mybb->input['starttime_month'], $months))
{
$mybb->input['starttime_month'] = 1;
}

$startdate = gmmktime(intval($startdate[0]), intval($startdate[1]), 0, (int)$mybb->input['starttime_month'], intval($mybb->input['starttime_day']), intval($mybb->input['starttime_year']));

	if(!in_array($mybb->input['starttime_month'], $months))
{
$mybb->input['starttime_month'] = 1;
}

$startdate = gmmktime(intval($startdate[0]), intval($startdate[1]), 0, (int)$mybb->input['starttime_month'], intval($mybb->input['starttime_day']), intval($mybb->input['starttime_year']));

	if($startdate < 0 || $startdate == false)

	if(!checkdate(intval($mybb->input['starttime_month']), intval($mybb->input['starttime_day']), intval($mybb->input['starttime_year'])) || $startdate < 0 || $startdate == false)

	{
$errors[] = $lang->error_invalid_start_date;

	{
$errors[] = $lang->error_invalid_start_date;

	}

if($mybb->input['endtime_type'] == "2")
{
$enddate = '0';
}
else
{
if(!in_array($mybb->input['endtime_month'], $months))
{
$mybb->input['endtime_month'] = 1;
}
$enddate = gmmktime(intval($enddate[0]), intval($enddate[1]), 0, (int)$mybb->input['endtime_month'], intval($mybb->input['endtime_day']), intval($mybb->input['endtime_year']));
if($enddate < 0 || $enddate == false)
{
$errors[] = $lang->error_invalid_end_date;
}
elseif($enddate < $startdate)
{

	}

if($mybb->input['endtime_type'] == "2")
{
$enddate = '0';
}
else
{
if(!in_array($mybb->input['endtime_month'], $months))
{
$mybb->input['endtime_month'] = 1;
}
$enddate = gmmktime(intval($enddate[0]), intval($enddate[1]), 0, (int)$mybb->input['endtime_month'], intval($mybb->input['endtime_day']), intval($mybb->input['endtime_year']));
if(!checkdate(intval($mybb->input['endtime_month']), intval($mybb->input['endtime_day']), intval($mybb->input['endtime_year'])) || $enddate < 0 || $enddate == false)
{
$errors[] = $lang->error_invalid_end_date;
}
elseif($enddate <= $startdate)
{

			$errors[] = $lang->error_end_before_start;
}
}

			$errors[] = $lang->error_end_before_start;
}
}

	



	$plugins->run_hooks("modcp_do_edit_announcement_start");

// Proceed to update if no errors

	$plugins->run_hooks("modcp_do_edit_announcement_start");

// Proceed to update if no errors

Zeile 937Zeile 969
		);

$db->update_query("announcements", $update_announcement, "aid='{$aid}'");

		);

$db->update_query("announcements", $update_announcement, "aid='{$aid}'");

		



		$plugins->run_hooks("modcp_do_edit_announcement_end");

		$plugins->run_hooks("modcp_do_edit_announcement_end");

		



$cache->update_forumsdisplay();

		redirect("modcp.php?action=announcements", $lang->redirect_edit_announcement);
}
else

		redirect("modcp.php?action=announcements", $lang->redirect_edit_announcement);
}
else

Zeile 961Zeile 994
	$announcement = $db->fetch_array($query);

if(!$announcement['fid'])

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

if(!$announcement['fid'])

	{

	{

		error($lang->error_invalid_announcement);
}

		error($lang->error_invalid_announcement);
}

	if(($mybb->usergroup['issupermod'] != 1 && $announcement['fid'] == -1) || ($announcement['fid'] != -1 && !is_moderator($announcement['fid'])))

	if(($mybb->usergroup['issupermod'] != 1 && $announcement['fid'] == -1) || ($announcement['fid'] != -1 && !is_moderator($announcement['fid'])) || ($unviewableforums && in_array($announcement['fid'], $unviewableforums)))

	{
error_no_permission();

	{
error_no_permission();

 
	}

if(!$announcement['startdate'])
{
// No start date? Make it now.
$announcement['startdate'] = TIME_NOW;
}

$makeshift_end = false;
if(!$announcement['enddate'])
{
$makeshift_end = true;
$makeshift_time = TIME_NOW;
if($announcement['startdate'])
{
$makeshift_time = $announcement['startdate'];
}

// No end date? Make it a year from now.
$announcement['enddate'] = $makeshift_time + (60 * 60 * 24 * 366);

	}

// Deal with inline errors

	}

// Deal with inline errors

Zeile 980Zeile 1033
		$announcement['allowhtml'] = $mybb->input['allowhtml'];
$announcement['allowmycode'] = $mybb->input['allowmycode'];
$announcement['allowsmilies'] = $mybb->input['allowsmilies'];

		$announcement['allowhtml'] = $mybb->input['allowhtml'];
$announcement['allowmycode'] = $mybb->input['allowmycode'];
$announcement['allowsmilies'] = $mybb->input['allowsmilies'];

		
$months = array('01', '02', '03', '04', '05', '06', '07', '08', '09', '10', '11', '12');


$months = array('01', '02', '03', '04', '05', '06', '07', '08', '09', '10', '11', '12');

		if(!in_array($mybb->input['starttime_month'], $months))

		if(!in_array($mybb->input['starttime_month'], $months))

		{

		{

			$mybb->input['starttime_month'] = 1;
}

			$mybb->input['starttime_month'] = 1;
}

		



		if(!in_array($mybb->input['endtime_month'], $months))
{
$mybb->input['endtime_month'] = 1;
}

		if(!in_array($mybb->input['endtime_month'], $months))
{
$mybb->input['endtime_month'] = 1;
}

		



		$startmonth = $mybb->input['starttime_month'];
$startdateyear = htmlspecialchars_uni($mybb->input['starttime_year']);
$startday = intval($mybb->input['starttime_day']);

		$startmonth = $mybb->input['starttime_month'];
$startdateyear = htmlspecialchars_uni($mybb->input['starttime_year']);
$startday = intval($mybb->input['starttime_day']);

		$starttime_time = htmlspecialchars($mybb->input['starttime_time']);

		$starttime_time = htmlspecialchars_uni($mybb->input['starttime_time']);

		$endmonth = $mybb->input['endtime_month'];
$enddateyear = htmlspecialchars_uni($mybb->input['endtime_year']);
$endday = intval($mybb->input['endtime_day']);

		$endmonth = $mybb->input['endtime_month'];
$enddateyear = htmlspecialchars_uni($mybb->input['endtime_year']);
$endday = intval($mybb->input['endtime_day']);

		$endtime_time = htmlspecialchars($mybb->input['endtime_time']);

		$endtime_time = htmlspecialchars_uni($mybb->input['endtime_time']);


$errored = true;
}


$errored = true;
}

Zeile 1095Zeile 1148
	}

if($announcement['allowsmilies'])

	}

if($announcement['allowsmilies'])

	{

	{

		$smilies_sel['yes'] = ' checked="checked"';

		$smilies_sel['yes'] = ' checked="checked"';

	}
else

	}
else

	{
$smilies_sel['no'] = ' checked="checked"';

	{
$smilies_sel['no'] = ' checked="checked"';

	}

if(($errored && $mybb->input['endtime_type'] == 2) || (!$errored && intval($announcement['enddate']) == 0))

	}

if(($errored && $mybb->input['endtime_type'] == 2) || (!$errored && intval($announcement['enddate']) == 0) || $makeshift_end == true)

	{
$end_type_sel['infinite'] = ' checked="checked"';
}

	{
$end_type_sel['infinite'] = ' checked="checked"';
}

Zeile 1115Zeile 1168
	// MyCode editor
$codebuttons = build_mycode_inserter();
$smilieinserter = build_clickable_smilies();

	// MyCode editor
$codebuttons = build_mycode_inserter();
$smilieinserter = build_clickable_smilies();

	



	$plugins->run_hooks("modcp_edit_announcement");

eval("\$announcements = \"".$templates->get("modcp_announcements_edit")."\";");

	$plugins->run_hooks("modcp_edit_announcement");

eval("\$announcements = \"".$templates->get("modcp_announcements_edit")."\";");

Zeile 1148Zeile 1201
				$trow = alt_trow();
if($announcement['startdate'] > TIME_NOW || ($announcement['enddate'] < TIME_NOW && $announcement['enddate'] != 0))
{

				$trow = alt_trow();
if($announcement['startdate'] > TIME_NOW || ($announcement['enddate'] < TIME_NOW && $announcement['enddate'] != 0))
{

					$icon = "<img src=\"images/minioff.gif\" alt=\"({$lang->expired})\" title=\"{$lang->expired_announcement}\"  style=\"vertical-align: middle;\" /> ";

					$icon = "<img src=\"{$theme['imgdir']}/minioff.gif\" alt=\"({$lang->expired})\" title=\"{$lang->expired_announcement}\"  style=\"vertical-align: middle;\" /> ";

				}
else
{

				}
else
{

					$icon = "<img src=\"images/minion.gif\" alt=\"({$lang->active})\" title=\"{$lang->active_announcement}\"  style=\"vertical-align: middle;\" /> ";

					$icon = "<img src=\"{$theme['imgdir']}/minion.gif\" alt=\"({$lang->active})\" title=\"{$lang->active_announcement}\"  style=\"vertical-align: middle;\" /> ";

				}

$subject = htmlspecialchars_uni($announcement['subject']);

				}

$subject = htmlspecialchars_uni($announcement['subject']);

Zeile 1179Zeile 1232
	{
eval("\$announcements_forum = \"".$templates->get("modcp_no_announcements_forum")."\";");
}

	{
eval("\$announcements_forum = \"".$templates->get("modcp_no_announcements_forum")."\";");
}

	



	$plugins->run_hooks("modcp_announcements");

	$plugins->run_hooks("modcp_announcements");

	



	eval("\$announcements = \"".$templates->get("modcp_announcements")."\";");
output_page($announcements);
}

	eval("\$announcements = \"".$templates->get("modcp_announcements")."\";");
output_page($announcements);
}

Zeile 1193Zeile 1246

// Verify incoming POST request
verify_post_check($mybb->input['my_post_key']);


// Verify incoming POST request
verify_post_check($mybb->input['my_post_key']);

	



	$plugins->run_hooks("modcp_do_modqueue_start");

if(is_array($mybb->input['threads']))

	$plugins->run_hooks("modcp_do_modqueue_start");

if(is_array($mybb->input['threads']))

Zeile 1201Zeile 1254
		// Fetch threads
$query = $db->simple_select("threads", "tid", "tid IN (".implode(",", array_map("intval", array_keys($mybb->input['threads'])))."){$flist}");
while($thread = $db->fetch_array($query))

		// Fetch threads
$query = $db->simple_select("threads", "tid", "tid IN (".implode(",", array_map("intval", array_keys($mybb->input['threads'])))."){$flist}");
while($thread = $db->fetch_array($query))

		{

		{

			$action = $mybb->input['threads'][$thread['tid']];
if($action == "approve")
{

			$action = $mybb->input['threads'][$thread['tid']];
if($action == "approve")
{

Zeile 1213Zeile 1266
			}
}
if(!empty($threads_to_approve))

			}
}
if(!empty($threads_to_approve))

		{

		{

			$moderation->approve_threads($threads_to_approve);
log_moderator_action(array('tids' => $threads_to_approve), $lang->multi_approve_threads);
}

			$moderation->approve_threads($threads_to_approve);
log_moderator_action(array('tids' => $threads_to_approve), $lang->multi_approve_threads);
}

Zeile 1221Zeile 1274
		{
foreach($threads_to_delete as $tid)
{

		{
foreach($threads_to_delete as $tid)
{

				$moderation->delete_thread($thread['tid']);

				$moderation->delete_thread($tid);

			}
log_moderator_action(array('tids' => $threads_to_delete), $lang->multi_delete_threads);
}

			}
log_moderator_action(array('tids' => $threads_to_delete), $lang->multi_delete_threads);
}

		



		$plugins->run_hooks("modcp_do_modqueue_end");

		$plugins->run_hooks("modcp_do_modqueue_end");

		



		redirect("modcp.php?action=modqueue", $lang->redirect_threadsmoderated);
}
else if(is_array($mybb->input['posts']))

		redirect("modcp.php?action=modqueue", $lang->redirect_threadsmoderated);
}
else if(is_array($mybb->input['posts']))

Zeile 1251Zeile 1304
			$moderation->approve_posts($posts_to_approve);
}
log_moderator_action(array('pids' => $posts_to_approve), $lang->multi_approve_posts);

			$moderation->approve_posts($posts_to_approve);
}
log_moderator_action(array('pids' => $posts_to_approve), $lang->multi_approve_posts);

		



		$plugins->run_hooks("modcp_do_modqueue_end");

		$plugins->run_hooks("modcp_do_modqueue_end");

		



		redirect("modcp.php?action=modqueue&type=posts", $lang->redirect_postsmoderated);
}
else if(is_array($mybb->input['attachments']))

		redirect("modcp.php?action=modqueue&type=posts", $lang->redirect_postsmoderated);
}
else if(is_array($mybb->input['attachments']))

Zeile 1271Zeile 1324
			if($action == "approve")
{
$db->update_query("attachments", array("visible" => 1), "aid='{$attachment['aid']}'");

			if($action == "approve")
{
$db->update_query("attachments", array("visible" => 1), "aid='{$attachment['aid']}'");

			}

			}

			else if($action == "delete")
{
remove_attachment($attachment['pid'], '', $attachment['aid']);
}
}

			else if($action == "delete")
{
remove_attachment($attachment['pid'], '', $attachment['aid']);
}
}

		



		$plugins->run_hooks("modcp_do_modqueue_end");

		$plugins->run_hooks("modcp_do_modqueue_end");

		



		redirect("modcp.php?action=modqueue&type=attachments", $lang->redirect_attachmentsmoderated);
}
}

		redirect("modcp.php?action=modqueue&type=attachments", $lang->redirect_attachmentsmoderated);
}
}

Zeile 1323Zeile 1376
			$page = 1;
}


			$page = 1;
}


		$multipage = multipage($pages, $perpage, $page, "modcp.php?action=modqueue&amp;type=threads");

		$multipage = multipage($unapproved_threads, $perpage, $page, "modcp.php?action=modqueue&type=threads");


$query = $db->query("


$query = $db->query("

			SELECT t.tid, t.dateline, t.fid, t.subject, p.message AS postmessage, u.username AS username, t.uid

			SELECT t.tid, t.dateline, t.fid, t.subject, t.username AS threadusername, p.message AS postmessage, u.username AS username, t.uid

			FROM ".TABLE_PREFIX."threads t
LEFT JOIN ".TABLE_PREFIX."posts p ON (p.pid=t.firstpost)
LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid=t.uid)

			FROM ".TABLE_PREFIX."threads t
LEFT JOIN ".TABLE_PREFIX."posts p ON (p.pid=t.firstpost)
LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid=t.uid)

Zeile 1343Zeile 1396
			$forum_name = $forum_cache[$thread['fid']]['name'];
$threaddate = my_date($mybb->settings['dateformat'], $thread['dateline']);
$threadtime = my_date($mybb->settings['timeformat'], $thread['dateline']);

			$forum_name = $forum_cache[$thread['fid']]['name'];
$threaddate = my_date($mybb->settings['dateformat'], $thread['dateline']);
$threadtime = my_date($mybb->settings['timeformat'], $thread['dateline']);

			$profile_link = build_profile_link($thread['username'], $thread['uid']);


















if($thread['username'] == "")
{
if($thread['threadusername'] != "")
{
$profile_link = $thread['threadusername'];
}
else
{
$profile_link = $lang->guest;
}
}
else
{
$profile_link = build_profile_link($thread['username'], $thread['uid']);
}


			$thread['postmessage'] = nl2br(htmlspecialchars_uni($thread['postmessage']));
$forum = "<strong>{$lang->meta_forum} <a href=\"{$thread['forumlink']}\">{$forum_name}</a></strong>";
eval("\$threads .= \"".$templates->get("modcp_modqueue_threads_thread")."\";");
}

if(!$threads && $mybb->input['type'] == "threads")

			$thread['postmessage'] = nl2br(htmlspecialchars_uni($thread['postmessage']));
$forum = "<strong>{$lang->meta_forum} <a href=\"{$thread['forumlink']}\">{$forum_name}</a></strong>";
eval("\$threads .= \"".$templates->get("modcp_modqueue_threads_thread")."\";");
}

if(!$threads && $mybb->input['type'] == "threads")

		{

		{

			eval("\$threads = \"".$templates->get("modcp_modqueue_threads_empty")."\";");
}

if($threads)
{
add_breadcrumb($lang->mcp_nav_modqueue_threads, "modcp.php?action=modqueue&amp;type=threads");

			eval("\$threads = \"".$templates->get("modcp_modqueue_threads_empty")."\";");
}

if($threads)
{
add_breadcrumb($lang->mcp_nav_modqueue_threads, "modcp.php?action=modqueue&amp;type=threads");

			



			$plugins->run_hooks("modcp_modqueue_threads_end");

			$plugins->run_hooks("modcp_modqueue_threads_end");

			



			eval("\$mass_controls = \"".$templates->get("modcp_modqueue_masscontrols")."\";");
eval("\$threadqueue = \"".$templates->get("modcp_modqueue_threads")."\";");
output_page($threadqueue);

			eval("\$mass_controls = \"".$templates->get("modcp_modqueue_masscontrols")."\";");
eval("\$threadqueue = \"".$templates->get("modcp_modqueue_threads")."\";");
output_page($threadqueue);

Zeile 1370Zeile 1439
	if($mybb->input['type'] == "posts" || (!$mybb->input['type'] && !$threadqueue))
{
$forum_cache = $cache->read("forums");

	if($mybb->input['type'] == "posts" || (!$mybb->input['type'] && !$threadqueue))
{
$forum_cache = $cache->read("forums");





		$query = $db->query("
SELECT COUNT(pid) AS unapprovedposts
FROM ".TABLE_PREFIX."posts p

		$query = $db->query("
SELECT COUNT(pid) AS unapprovedposts
FROM ".TABLE_PREFIX."posts p

Zeile 1387Zeile 1456

$perpage = $mybb->settings['postsperpage'];
$pages = $unapproved_posts / $perpage;


$perpage = $mybb->settings['postsperpage'];
$pages = $unapproved_posts / $perpage;

		$pages = ceil($pages);

if($mybb->input['page'] == "last")
{
$page = $pages;
}

if($page > $pages || $page <= 0)
{

		$pages = ceil($pages);

if($mybb->input['page'] == "last")
{
$page = $pages;
}

if($page > $pages || $page <= 0)
{

			$page = 1;
}


			$page = 1;
}


Zeile 1407Zeile 1476
		{
$start = 0;
$page = 1;

		{
$start = 0;
$page = 1;

		}

		}





		$multipage = multipage($pages, $perpage, $page, "modcp.php?action=modqueue&amp;type=posts");

		$multipage = multipage($unapproved_posts, $perpage, $page, "modcp.php?action=modqueue&amp;type=posts");


$query = $db->query("


$query = $db->query("

			SELECT p.pid, p.subject, p.message, t.subject AS threadsubject, t.tid, u.username, p.uid, t.fid, p.dateline

			SELECT p.pid, p.subject, p.message, p.username AS postusername, t.subject AS threadsubject, t.tid, u.username, p.uid, t.fid, p.dateline

			FROM  ".TABLE_PREFIX."posts p
LEFT JOIN ".TABLE_PREFIX."threads t ON (t.tid=p.tid)
LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid=p.uid)

			FROM  ".TABLE_PREFIX."posts p
LEFT JOIN ".TABLE_PREFIX."threads t ON (t.tid=p.tid)
LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid=p.uid)

Zeile 1421Zeile 1490
			LIMIT {$start}, {$perpage}
");
while($post = $db->fetch_array($query))

			LIMIT {$start}, {$perpage}
");
while($post = $db->fetch_array($query))

		{

		{

			$altbg = alt_trow();
$post['threadsubject'] = htmlspecialchars_uni($parser->parse_badwords($post['threadsubject']));
$post['threadlink'] = get_thread_link($post['tid']);

			$altbg = alt_trow();
$post['threadsubject'] = htmlspecialchars_uni($parser->parse_badwords($post['threadsubject']));
$post['threadlink'] = get_thread_link($post['tid']);

Zeile 1430Zeile 1499
			$forum_name = $forum_cache[$post['fid']]['name'];
$postdate = my_date($mybb->settings['dateformat'], $post['dateline']);
$posttime = my_date($mybb->settings['timeformat'], $post['dateline']);

			$forum_name = $forum_cache[$post['fid']]['name'];
$postdate = my_date($mybb->settings['dateformat'], $post['dateline']);
$posttime = my_date($mybb->settings['timeformat'], $post['dateline']);

			$profile_link = build_profile_link($post['username'], $post['uid']);


















if($post['username'] == "")
{
if($post['postusername'] != "")
{
$profile_link = $post['postusername'];
}
else
{
$profile_link = $lang->guest;
}
}
else
{
$profile_link = build_profile_link($post['username'], $post['uid']);
}


			$thread = "<strong>{$lang->meta_thread} <a href=\"{$post['threadlink']}\">{$post['threadsubject']}</a></strong>";
$forum = "<strong>{$lang->meta_forum} <a href=\"{$post['forumlink']}\">{$forum_name}</a></strong><br />";
$post['message'] = nl2br(htmlspecialchars_uni($post['message']));

			$thread = "<strong>{$lang->meta_thread} <a href=\"{$post['threadlink']}\">{$post['threadsubject']}</a></strong>";
$forum = "<strong>{$lang->meta_forum} <a href=\"{$post['forumlink']}\">{$forum_name}</a></strong><br />";
$post['message'] = nl2br(htmlspecialchars_uni($post['message']));

Zeile 1445Zeile 1530
		if($posts)
{
add_breadcrumb($lang->mcp_nav_modqueue_posts, "modcp.php?action=modqueue&amp;type=posts");

		if($posts)
{
add_breadcrumb($lang->mcp_nav_modqueue_posts, "modcp.php?action=modqueue&amp;type=posts");

			



			$plugins->run_hooks("modcp_modqueue_posts_end");

			$plugins->run_hooks("modcp_modqueue_posts_end");

			



			eval("\$mass_controls = \"".$templates->get("modcp_modqueue_masscontrols")."\";");
eval("\$postqueue = \"".$templates->get("modcp_modqueue_posts")."\";");
output_page($postqueue);

			eval("\$mass_controls = \"".$templates->get("modcp_modqueue_masscontrols")."\";");
eval("\$postqueue = \"".$templates->get("modcp_modqueue_posts")."\";");
output_page($postqueue);

Zeile 1495Zeile 1580
			$page = 1;
}


			$page = 1;
}


		$multipage = multipage($pages, $perpage, $page, "modcp.php?action=modqueue&amp;type=attachments");

		$multipage = multipage($unapproved_attachments, $perpage, $page, "modcp.php?action=modqueue&amp;type=attachments");


$query = $db->query("
SELECT a.*, p.subject AS postsubject, p.dateline, p.uid, u.username, t.tid, t.subject AS threadsubject


$query = $db->query("
SELECT a.*, p.subject AS postsubject, p.dateline, p.uid, u.username, t.tid, t.subject AS threadsubject

Zeile 1515Zeile 1600
			{
$attachment['dateuploaded'] = $attachment['dateline'];
}

			{
$attachment['dateuploaded'] = $attachment['dateline'];
}

			



			$attachdate = my_date($mybb->settings['dateformat'], $attachment['dateuploaded']);
$attachtime = my_date($mybb->settings['timeformat'], $attachment['dateuploaded']);

			$attachdate = my_date($mybb->settings['dateformat'], $attachment['dateuploaded']);
$attachtime = my_date($mybb->settings['timeformat'], $attachment['dateuploaded']);





			$attachment['postsubject'] = htmlspecialchars_uni($attachment['postsubject']);
$attachment['filename'] = htmlspecialchars_uni($attachment['filename']);
$attachment['threadsubject'] = htmlspecialchars_uni($attachment['threadsubject']);

			$attachment['postsubject'] = htmlspecialchars_uni($attachment['postsubject']);
$attachment['filename'] = htmlspecialchars_uni($attachment['filename']);
$attachment['threadsubject'] = htmlspecialchars_uni($attachment['threadsubject']);

Zeile 1527Zeile 1612
			$link = get_post_link($attachment['pid'], $attachment['tid']) . "#pid{$attachment['pid']}";
$thread_link = get_thread_link($attachment['tid']);
$profile_link = build_profile_link($attachment['username'], $attachment['uid']);

			$link = get_post_link($attachment['pid'], $attachment['tid']) . "#pid{$attachment['pid']}";
$thread_link = get_thread_link($attachment['tid']);
$profile_link = build_profile_link($attachment['username'], $attachment['uid']);





			eval("\$attachments .= \"".$templates->get("modcp_modqueue_attachments_attachment")."\";");

			eval("\$attachments .= \"".$templates->get("modcp_modqueue_attachments_attachment")."\";");

		}


		}


		if(!$attachments && $mybb->input['type'] == "attachments")
{
eval("\$attachments = \"".$templates->get("modcp_modqueue_attachments_empty")."\";");

		if(!$attachments && $mybb->input['type'] == "attachments")
{
eval("\$attachments = \"".$templates->get("modcp_modqueue_attachments_empty")."\";");

Zeile 1539Zeile 1624
		if($attachments)
{
add_breadcrumb($lang->mcp_nav_modqueue_attachments, "modcp.php?action=modqueue&amp;type=attachments");

		if($attachments)
{
add_breadcrumb($lang->mcp_nav_modqueue_attachments, "modcp.php?action=modqueue&amp;type=attachments");

			



			$plugins->run_hooks("modcp_modqueue_attachments_end");

			$plugins->run_hooks("modcp_modqueue_attachments_end");

			



			eval("\$mass_controls = \"".$templates->get("modcp_modqueue_masscontrols")."\";");
eval("\$attachmentqueue = \"".$templates->get("modcp_modqueue_attachments")."\";");
output_page($attachmentqueue);

			eval("\$mass_controls = \"".$templates->get("modcp_modqueue_masscontrols")."\";");
eval("\$attachmentqueue = \"".$templates->get("modcp_modqueue_attachments")."\";");
output_page($attachmentqueue);

Zeile 1552Zeile 1637
	if(!$threadqueue && !$postqueue && !$attachmentqueue)
{
add_breadcrumb($lang->mcp_nav_modqueue, "modcp.php?action=modqueue");

	if(!$threadqueue && !$postqueue && !$attachmentqueue)
{
add_breadcrumb($lang->mcp_nav_modqueue, "modcp.php?action=modqueue");

		



		$plugins->run_hooks("modcp_modqueue_end");

		$plugins->run_hooks("modcp_modqueue_end");

		



		eval("\$queue = \"".$templates->get("modcp_modqueue_empty")."\";");
output_page($queue);
}
}

		eval("\$queue = \"".$templates->get("modcp_modqueue_empty")."\";");
output_page($queue);
}
}





if($mybb->input['action'] == "do_editprofile")
{
// Verify incoming POST request
verify_post_check($mybb->input['my_post_key']);

if($mybb->input['action'] == "do_editprofile")
{
// Verify incoming POST request
verify_post_check($mybb->input['my_post_key']);





	$user = get_user($mybb->input['uid']);
if(!$user['uid'])

	$user = get_user($mybb->input['uid']);
if(!$user['uid'])

	{

	{

		error($lang->invalid_user);

		error($lang->invalid_user);

	}


	}


	// Check if the current user has permission to edit this user
if(!modcp_can_manage_user($user['uid']))
{
error_no_permission();
}

	// Check if the current user has permission to edit this user
if(!modcp_can_manage_user($user['uid']))
{
error_no_permission();
}

	



	$plugins->run_hooks("modcp_do_editprofile_start");

// Set up user handler.

	$plugins->run_hooks("modcp_do_editprofile_start");

// Set up user handler.

Zeile 1622Zeile 1707
	$errors = '';

// Validate the user and get any errors that might have occurred.

	$errors = '';

// Validate the user and get any errors that might have occurred.

	$userhandler->admin_override = true;

 
	if(!$userhandler->validate_user())
{
$errors = $userhandler->get_friendly_errors();

	if(!$userhandler->validate_user())
{
$errors = $userhandler->get_friendly_errors();

Zeile 1669Zeile 1753
		require_once MYBB_ROOT."inc/functions_warnings.php";
foreach($moderator_options as $option)
{

		require_once MYBB_ROOT."inc/functions_warnings.php";
foreach($moderator_options as $option)
{

 
			$mybb->input[$option['time']] = intval($mybb->input[$option['time']]);

			if(!$mybb->input[$option['action']])
{
if($user[$option['update_field']] == 1)

			if(!$mybb->input[$option['action']])
{
if($user[$option['update_field']] == 1)

Zeile 1684Zeile 1769

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


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

				if(intval($mybb->input[$option['time']]) == 0 && $mybb->input[$option['period']] != "never" && $user[$option['update_field']] != 1)

				if($mybb->input[$option['time']] == 0 && $mybb->input[$option['period']] != "never" && $user[$option['update_field']] != 1)

				{
// User has selected a type of ban, but not entered a valid time frame
$string = $option['action']."_error";

				{
// User has selected a type of ban, but not entered a valid time frame
$string = $option['action']."_error";

Zeile 1712Zeile 1797
					elseif(!$user[$option['update_field']])
{
// New suspension for this user... bad user!

					elseif(!$user[$option['update_field']])
{
// New suspension for this user... bad user!

						$extra_user_updates[$option['update_field']] = 1;				

						$extra_user_updates[$option['update_field']] = 1;

						if($suspend_length == "-1")
{
$extra_user_updates[$option['update_length']] = 0;

						if($suspend_length == "-1")
{
$extra_user_updates[$option['update_length']] = 0;

Zeile 1740Zeile 1825
		else
{
$plugins->run_hooks("modcp_do_editprofile_update");

		else
{
$plugins->run_hooks("modcp_do_editprofile_update");

			



			// Continue with the update if there is no errors
$user_info = $userhandler->update_user();
$db->update_query("users", $extra_user_updates, "uid='{$user['uid']}'");
log_moderator_action(array("uid" => $user['uid'], "username" => $user['username']), $lang->edited_user);

			// Continue with the update if there is no errors
$user_info = $userhandler->update_user();
$db->update_query("users", $extra_user_updates, "uid='{$user['uid']}'");
log_moderator_action(array("uid" => $user['uid'], "username" => $user['username']), $lang->edited_user);

			



			$plugins->run_hooks("modcp_do_editprofile_end");

			$plugins->run_hooks("modcp_do_editprofile_end");

			



			redirect("modcp.php?action=finduser", $lang->redirect_user_updated);
}
}
}

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

			redirect("modcp.php?action=finduser", $lang->redirect_user_updated);
}
}
}

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

{
add_breadcrumb($lang->mcp_nav_editprofile, "modcp.php?action=editprofile");


{
add_breadcrumb($lang->mcp_nav_editprofile, "modcp.php?action=editprofile");


	$user = get_user($mybb->input['uid']);
if(!$user['uid'])

	$user = get_user($mybb->input['uid']);
if(!$user['uid'])

	{

	{

		error($lang->invalid_user);
}


		error($lang->invalid_user);
}


Zeile 1770Zeile 1855
	}

if($user['website'] == "" || $user['website'] == "http://")

	}

if($user['website'] == "" || $user['website'] == "http://")

	{

	{

		$user['website'] = "http://";
}

if($user['icq'] != "0")

		$user['website'] = "http://";
}

if($user['icq'] != "0")

	{

	{

		$user['icq'] = intval($user['icq']);
}
if($user['icq'] == 0)

		$user['icq'] = intval($user['icq']);
}
if($user['icq'] == 0)

Zeile 1791Zeile 1876
	else
{
$errors = inline_error($errors);

	else
{
$errors = inline_error($errors);

	}


	}


	// Sanitize all input
foreach(array('usertitle', 'website', 'icq', 'aim', 'yahoo', 'msn', 'signature', 'birthday_day', 'birthday_month', 'birthday_year') as $field)

	// Sanitize all input
foreach(array('usertitle', 'website', 'icq', 'aim', 'yahoo', 'msn', 'signature', 'birthday_day', 'birthday_month', 'birthday_year') as $field)

	{

	{

		$mybb->input[$field] = htmlspecialchars_uni($mybb->input[$field]);

		$mybb->input[$field] = htmlspecialchars_uni($mybb->input[$field]);

	}

if($user['usertitle'] == "")
{
$query = $db->simple_select("usertitles", "*", "posts <='".$user['postnum']."'", array('order_by' => 'posts', 'order_dir' => 'DESC', 'limit' => 1));
$utitle = $db->fetch_array($query);
$defaulttitle = $utitle['title'];
}
else
{
if(!$user['displaygroup'])
{
$user['displaygroup'] = $user['usergroup'];
}

$displaygroupfields = array(
"usertitle"
);
$display_group = usergroup_displaygroup($user['displaygroup']);

	}

// Custom user title, check to see if we have a default group title
if(!$user['displaygroup'])
{
$user['displaygroup'] = $user['usergroup'];
}

$displaygroupfields = array('usertitle');
$display_group = usergroup_displaygroup($user['displaygroup']);

if(!empty($display_group['usertitle']))
{







		$defaulttitle = $display_group['usertitle'];
}

		$defaulttitle = $display_group['usertitle'];
}

 
	else
{
// Go for post count title if a group default isn't set
$usertitles = $cache->read('usertitles');

foreach($usertitles as $title)
{
if($title['posts'] <= $mybb->user['postnum'])
{
$defaulttitle = $title['title'];
}
}
}


	if(empty($user['usertitle']))
{
$lang->current_custom_usertitle = '';

	if(empty($user['usertitle']))
{
$lang->current_custom_usertitle = '';

	}


	}


	$bdaysel = '';
for($i = 1; $i <= 31; ++$i)
{

	$bdaysel = '';
for($i = 1; $i <= 31; ++$i)
{

Zeile 1836Zeile 1929
		}
}
$bdaymonthsel[$mybb->input['birthday_month']] = 'selected="selected"';

		}
}
$bdaymonthsel[$mybb->input['birthday_month']] = 'selected="selected"';

	



	$plugins->run_hooks("modcp_editprofile_start");

// Fetch profile fields

	$plugins->run_hooks("modcp_editprofile_start");

// Fetch profile fields

Zeile 1864Zeile 1957
			$userfield = $user_fields[$field];
}
if($type == "multiselect")

			$userfield = $user_fields[$field];
}
if($type == "multiselect")

		{
if($errors)
{

		{
if($errors)
{

				$useropts = $userfield;
}
else

				$useropts = $userfield;
}
else

Zeile 1878Zeile 1971
				foreach($useropts as $key => $val)
{
$seloptions[$val] = $val;

				foreach($useropts as $key => $val)
{
$seloptions[$val] = $val;

				}
}
$expoptions = explode("\n", $options);
if(is_array($expoptions))

				}
}
$expoptions = explode("\n", $options);
if(is_array($expoptions))

			{
foreach($expoptions as $key => $val)
{

			{
foreach($expoptions as $key => $val)
{

Zeile 1912Zeile 2005
					$val = trim($val);
$val = str_replace("\n", "\\n", $val);
$sel = "";

					$val = trim($val);
$val = str_replace("\n", "\\n", $val);
$sel = "";

					if($val == $userfield)
{
$sel = " selected=\"selected\"";
}

					if($val == $userfield)
{
$sel = " selected=\"selected\"";
}

					$select .= "<option value=\"$val\"$sel>$val</option>";
}
if(!$profilefield['length'])

					$select .= "<option value=\"$val\"$sel>$val</option>";
}
if(!$profilefield['length'])

Zeile 2051Zeile 2144
		1 => array(
"action" => "suspendsignature", // The input action for this option
"option" => "suspendsignature", // The field in the database that this option relates to

		1 => array(
"action" => "suspendsignature", // The input action for this option
"option" => "suspendsignature", // The field in the database that this option relates to

 
			"time" => "action_time", // The time we've entered

			"length" => "suspendsigtime", // The length of suspension field in the database
"select_option" => "action" // The name of the select box of this option
),
2 => array(
"action" => "moderateposting",
"option" => "moderateposts",

			"length" => "suspendsigtime", // The length of suspension field in the database
"select_option" => "action" // The name of the select box of this option
),
2 => array(
"action" => "moderateposting",
"option" => "moderateposts",

 
			"time" => "modpost_time",

			"length" => "moderationtime",
"select_option" => "modpost"
),
3 => array(
"action" => "suspendposting",
"option" => "suspendposting",

			"length" => "moderationtime",
"select_option" => "modpost"
),
3 => array(
"action" => "suspendposting",
"option" => "suspendposting",

 
			"time" => "suspost_time",

			"length" => "suspensiontime",
"select_option" => "suspost"
)

			"length" => "suspensiontime",
"select_option" => "suspost"
)

Zeile 2078Zeile 2174

foreach($moderator_options as $option)
{


foreach($moderator_options as $option)
{

 
		$mybb->input[$option['time']] = intval($mybb->input[$option['time']]);

		// Display the suspension info, if this user has this option suspended
if($user[$option['option']])
{

		// Display the suspension info, if this user has this option suspended
if($user[$option['option']])
{

Zeile 2143Zeile 2240
	}

eval("\$suspend_signature = \"".$templates->get("modcp_editprofile_signature")."\";");

	}

eval("\$suspend_signature = \"".$templates->get("modcp_editprofile_signature")."\";");

	



	$plugins->run_hooks("modcp_editprofile_end");

eval("\$edituser = \"".$templates->get("modcp_editprofile")."\";");
output_page($edituser);
}

	$plugins->run_hooks("modcp_editprofile_end");

eval("\$edituser = \"".$templates->get("modcp_editprofile")."\";");
output_page($edituser);
}





if($mybb->input['action'] == "finduser")
{
add_breadcrumb($lang->mcp_nav_users, "modcp.php?action=finduser");

if($mybb->input['action'] == "finduser")
{
add_breadcrumb($lang->mcp_nav_users, "modcp.php?action=finduser");

	



	$perpage = intval($mybb->input['perpage']);
if(!$perpage || $perpage <= 0)
{

	$perpage = intval($mybb->input['perpage']);
if(!$perpage || $perpage <= 0)
{

Zeile 2164Zeile 2261
	if($mybb->input['username'])
{
$where = " AND LOWER(username) LIKE '%".my_strtolower($db->escape_string_like($mybb->input['username']))."%'";

	if($mybb->input['username'])
{
$where = " AND LOWER(username) LIKE '%".my_strtolower($db->escape_string_like($mybb->input['username']))."%'";

	}


	}


	// Sort order & direction
switch($mybb->input['sortby'])
{

	// Sort order & direction
switch($mybb->input['sortby'])
{

Zeile 2174Zeile 2271
			break;
case "postnum":
$sortby = "postnum";

			break;
case "postnum":
$sortby = "postnum";

			break;

			break;

		case "username":
$sortby = "username";
break;

		case "username":
$sortby = "username";
break;

Zeile 2189Zeile 2286

$query = $db->simple_select("users", "COUNT(uid) AS count", "1=1 {$where}");
$user_count = $db->fetch_field($query, "count");


$query = $db->simple_select("users", "COUNT(uid) AS count", "1=1 {$where}");
$user_count = $db->fetch_field($query, "count");





	// Figure out if we need to display multiple pages.
if($mybb->input['page'] != "last")
{
$page = intval($mybb->input['page']);

	// Figure out if we need to display multiple pages.
if($mybb->input['page'] != "last")
{
$page = intval($mybb->input['page']);

	}

	}


$pages = $user_count / $perpage;
$pages = ceil($pages);


$pages = $user_count / $perpage;
$pages = ceil($pages);

Zeile 2205Zeile 2302
	}

if($page > $pages || $page <= 0)

	}

if($page > $pages || $page <= 0)

	{
$page = 1;
}

	{
$page = 1;
}

	if($page)
{
$start = ($page-1) * $perpage;
}
else

	if($page)
{
$start = ($page-1) * $perpage;
}
else

	{

	{

		$start = 0;
$page = 1;

		$start = 0;
$page = 1;

	}

	}


$page_url = 'modcp.php?action=finduser';
foreach(array('username', 'sortby', 'order') as $field)


$page_url = 'modcp.php?action=finduser';
foreach(array('username', 'sortby', 'order') as $field)

Zeile 2231Zeile 2328
	$multipage = multipage($user_count, $perpage, $page, $page_url);

$usergroups_cache = $cache->read("usergroups");

	$multipage = multipage($user_count, $perpage, $page, $page_url);

$usergroups_cache = $cache->read("usergroups");

	



	$plugins->run_hooks("modcp_finduser_start");

// Fetch out results

	$plugins->run_hooks("modcp_finduser_start");

// Fetch out results

Zeile 2254Zeile 2351
	{
eval("\$users = \"".$templates->get("modcp_finduser_noresults")."\";");
}

	{
eval("\$users = \"".$templates->get("modcp_finduser_noresults")."\";");
}

	



	$plugins->run_hooks("modcp_finduser_end");

eval("\$finduser = \"".$templates->get("modcp_finduser")."\";");

	$plugins->run_hooks("modcp_finduser_end");

eval("\$finduser = \"".$templates->get("modcp_finduser")."\";");

Zeile 2273Zeile 2370
		$query = $db->simple_select("users", "uid", "username='{$search['username']}'");
$mybb->input['filter']['uid'] = $db->fetch_field($query, "uid");
$mybb->input['filter']['username'] = htmlspecialchars_uni($mybb->input['filter']['username']);

		$query = $db->simple_select("users", "uid", "username='{$search['username']}'");
$mybb->input['filter']['uid'] = $db->fetch_field($query, "uid");
$mybb->input['filter']['username'] = htmlspecialchars_uni($mybb->input['filter']['username']);

	}

	}

	if($mybb->input['filter']['uid'])
{
$search['uid'] = intval($mybb->input['filter']['uid']);

	if($mybb->input['filter']['uid'])
{
$search['uid'] = intval($mybb->input['filter']['uid']);

Zeile 2283Zeile 2380
			$user = get_user($mybb->input['search']['uid']);
$mybb->input['search']['username'] = htmlspecialchars_uni($user['username']);
}

			$user = get_user($mybb->input['search']['uid']);
$mybb->input['search']['username'] = htmlspecialchars_uni($user['username']);
}

	}

	}

	if($mybb->input['filter']['mod_username'])
{
$search['mod_username'] = $db->escape_string($mybb->input['filter']['mod_username']);

	if($mybb->input['filter']['mod_username'])
{
$search['mod_username'] = $db->escape_string($mybb->input['filter']['mod_username']);

Zeile 2292Zeile 2389
		$mybb->input['filter']['mod_username'] = htmlspecialchars_uni($mybb->input['filter']['mod_username']);
}
if($mybb->input['filter']['mod_uid'])

		$mybb->input['filter']['mod_username'] = htmlspecialchars_uni($mybb->input['filter']['mod_username']);
}
if($mybb->input['filter']['mod_uid'])

	{

	{

		$search['mod_uid'] = intval($mybb->input['filter']['mod_uid']);
$where_sql .= " AND w.issuedby='{$search['mod_uid']}'";
if(!isset($mybb->input['search']['mod_username']))

		$search['mod_uid'] = intval($mybb->input['filter']['mod_uid']);
$where_sql .= " AND w.issuedby='{$search['mod_uid']}'";
if(!isset($mybb->input['search']['mod_username']))

Zeile 2303Zeile 2400
	}
if($mybb->input['filter']['reason'])
{

	}
if($mybb->input['filter']['reason'])
{

		$search['reason'] = $db->escape_string($mybb->input['filter']['reason']);

		$search['reason'] = $db->escape_string_like($mybb->input['filter']['reason']);

		$where_sql .= " AND (w.notes LIKE '%{$search['reason']}%' OR t.title LIKE '%{$search['reason']}%' OR w.title LIKE '%{$search['reason']}%')";
$mybb->input['filter']['reason'] = htmlspecialchars_uni($mybb->input['filter']['reason']);
}
$sortbysel = array();
switch($mybb->input['filter']['sortby'])

		$where_sql .= " AND (w.notes LIKE '%{$search['reason']}%' OR t.title LIKE '%{$search['reason']}%' OR w.title LIKE '%{$search['reason']}%')";
$mybb->input['filter']['reason'] = htmlspecialchars_uni($mybb->input['filter']['reason']);
}
$sortbysel = array();
switch($mybb->input['filter']['sortby'])

	{

	{

		case "username":
$sortby = "u.username";
$sortbysel['username'] = ' selected="selected"';

		case "username":
$sortby = "u.username";
$sortbysel['username'] = ' selected="selected"';

Zeile 2334Zeile 2431
		$ordersel['desc'] = ' selected="selected"';
}
else

		$ordersel['desc'] = ' selected="selected"';
}
else

	{

	{

		$ordersel['asc'] = ' selected="selected"';
}

		$ordersel['asc'] = ' selected="selected"';
}

	



	$plugins->run_hooks("modcp_warninglogs_start");

// Pagination stuff

	$plugins->run_hooks("modcp_warninglogs_start");

// Pagination stuff

Zeile 2418Zeile 2515
		}
$title = $row['title'];
if(empty($row['title']))

		}
$title = $row['title'];
if(empty($row['title']))

		{

		{

			$title = $row['custom_title'];
}
$title = htmlspecialchars_uni($title);

			$title = $row['custom_title'];
}
$title = htmlspecialchars_uni($title);

Zeile 2428Zeile 2525
		}

eval("\$warning_list .= \"".$templates->get("modcp_warninglogs_warning")."\";");

		}

eval("\$warning_list .= \"".$templates->get("modcp_warninglogs_warning")."\";");

	}


	}


	if(!$warning_list)
{
eval("\$warning_list = \"".$templates->get("modcp_warninglogs_nologs")."\";");
}

	if(!$warning_list)
{
eval("\$warning_list = \"".$templates->get("modcp_warninglogs_nologs")."\";");
}

	



	$plugins->run_hooks("modcp_warninglogs_end");

eval("\$warninglogs = \"".$templates->get("modcp_warninglogs")."\";");
output_page($warninglogs);
}

	$plugins->run_hooks("modcp_warninglogs_end");

eval("\$warninglogs = \"".$templates->get("modcp_warninglogs")."\";");
output_page($warninglogs);
}





if($mybb->input['action'] == "ipsearch")
{
add_breadcrumb($lang->mcp_nav_ipsearch, "modcp.php?action=ipsearch");

if($mybb->input['action'] == "ipsearch")
{
add_breadcrumb($lang->mcp_nav_ipsearch, "modcp.php?action=ipsearch");

Zeile 2451Zeile 2548
		{
$groupscache = $cache->read("usergroups");
}

		{
$groupscache = $cache->read("usergroups");
}





		$ipaddressvalue = htmlspecialchars_uni($mybb->input['ipaddress']);

// Searching post IP addresses

		$ipaddressvalue = htmlspecialchars_uni($mybb->input['ipaddress']);

// Searching post IP addresses

Zeile 2461Zeile 2558
			if(strpos($mybb->input['ipaddress'], ":") !== false)
{
$post_ip_sql = "ipaddress LIKE '".$db->escape_string(str_replace("*", "%", $mybb->input['ipaddress']))."'";

			if(strpos($mybb->input['ipaddress'], ":") !== false)
{
$post_ip_sql = "ipaddress LIKE '".$db->escape_string(str_replace("*", "%", $mybb->input['ipaddress']))."'";

			}
else
{
$ip_range = fetch_longipv4_range($mybb->input['ipaddress']);
if(!is_array($ip_range))
{
$post_ip_sql = "longipaddress='{$ip_range}'";
}
else

			}
else
{
$ip_range = fetch_longipv4_range($mybb->input['ipaddress']);

if($ip_range)




				{

				{

					$post_ip_sql = "longipaddress > '{$ip_range[0]}' AND longipaddress < '{$ip_range[1]}'";








					if(!is_array($ip_range))
{
$post_ip_sql = "longipaddress='{$ip_range}'";
}
else
{
$post_ip_sql = "longipaddress > '{$ip_range[0]}' AND longipaddress < '{$ip_range[1]}'";
}

				}
}

				}
}

 


			$plugins->run_hooks("modcp_ipsearch_posts_start");

			$plugins->run_hooks("modcp_ipsearch_posts_start");

			$query = $db->query("
SELECT COUNT(pid) AS count
FROM ".TABLE_PREFIX."posts
WHERE {$post_ip_sql}
");
$post_results = $db->fetch_field($query, "count");
}








if($post_ip_sql)
{
$query = $db->query("
SELECT COUNT(pid) AS count
FROM ".TABLE_PREFIX."posts
WHERE {$post_ip_sql}
");

$post_results = $db->fetch_field($query, "count");
}
}


		// Searching user IP addresses
if($mybb->input['search_users'])
{

		// Searching user IP addresses
if($mybb->input['search_users'])
{

Zeile 2492Zeile 2599
				$user_ip_sql = "regip LIKE '".$db->escape_string(str_replace("*", "%", $mybb->input['ipaddress']))."' OR lastip LIKE '".$db->escape_string(str_replace("*", "%", $mybb->input['ipaddress']))."'";
}
else

				$user_ip_sql = "regip LIKE '".$db->escape_string(str_replace("*", "%", $mybb->input['ipaddress']))."' OR lastip LIKE '".$db->escape_string(str_replace("*", "%", $mybb->input['ipaddress']))."'";
}
else

			{

			{

				$ip_range = fetch_longipv4_range($mybb->input['ipaddress']);

				$ip_range = fetch_longipv4_range($mybb->input['ipaddress']);

				if(!is_array($ip_range))



if($ip_range)

				{

				{

					$user_ip_sql = "longregip='{$ip_range}' OR longlastip='{$ip_range}'";
}
else
{
$user_ip_sql = "(longregip > '{$ip_range[0]}' AND longregip < '{$ip_range[1]}') OR (longlastip > '{$ip_range[0]}' AND longlastip < '{$ip_range[1]}')";




					if(!is_array($ip_range))
{
$user_ip_sql = "longregip='{$ip_range}' OR longlastip='{$ip_range}'";
}
else
{
$user_ip_sql = "(longregip > '{$ip_range[0]}' AND longregip < '{$ip_range[1]}') OR (longlastip > '{$ip_range[0]}' AND longlastip < '{$ip_range[1]}')";
}

				}
}

				}
}

 


			$plugins->run_hooks("modcp_ipsearch_users_start");

			$plugins->run_hooks("modcp_ipsearch_users_start");

			$query = $db->query("
SELECT COUNT(uid) AS count
FROM ".TABLE_PREFIX."users
WHERE {$user_ip_sql}
");
$user_results = $db->fetch_field($query, "count");
}








if($user_ip_sql)
{
$query = $db->query("
SELECT COUNT(uid) AS count
FROM ".TABLE_PREFIX."users
WHERE {$user_ip_sql}
");

$user_results = $db->fetch_field($query, "count");
}
}


		$total_results = $post_results+$user_results;

		$total_results = $post_results+$user_results;

 

if(!$total_results)
{
$total_results = 1;
}


// Now we have the result counts, paginate
$perpage = intval($mybb->input['perpage']);


// Now we have the result counts, paginate
$perpage = intval($mybb->input['perpage']);

Zeile 2559Zeile 2681
		$multipage = multipage($total_results, $perpage, $page, $page_url);

$post_limit = $perpage;

		$multipage = multipage($total_results, $perpage, $page, $page_url);

$post_limit = $perpage;

		if($mybb->input['search_users'] && $start <= $user_results)

		if($mybb->input['search_users'] && $user_results && $start <= $user_results)

		{
$query = $db->query("
SELECT username, uid, regip, lastip

		{
$query = $db->query("
SELECT username, uid, regip, lastip

Zeile 2606Zeile 2728
				$post_start = 0;
}
}

				$post_start = 0;
}
}

		if($mybb->input['search_posts'] && (!$mybb->input['search_users'] || ($mybb->input['search_users'] && $post_limit > 0)))

		if($mybb->input['search_posts'] && $post_results && (!$mybb->input['search_users'] || ($mybb->input['search_users'] && $post_limit > 0)))

		{
$ipaddresses = $tids = $uids = array();
$query = $db->query("

		{
$ipaddresses = $tids = $uids = array();
$query = $db->query("

Zeile 2622Zeile 2744
				$uids[$ipaddress['uid']] = $ipaddress['pid'];
$ipaddresses[$ipaddress['pid']] = $ipaddress;
}

				$uids[$ipaddress['uid']] = $ipaddress['pid'];
$ipaddresses[$ipaddress['pid']] = $ipaddress;
}

			



			if(!empty($ipaddresses))
{
$query = $db->simple_select("threads", "subject, tid", "tid IN(".implode(',', array_keys($tids)).")");
while($thread = $db->fetch_array($query))

			if(!empty($ipaddresses))
{
$query = $db->simple_select("threads", "subject, tid", "tid IN(".implode(',', array_keys($tids)).")");
while($thread = $db->fetch_array($query))

				{

				{

					$ipaddresses[$tids[$thread['tid']]]['threadsubject'] = $thread['subject'];
}
unset($tids);

					$ipaddresses[$tids[$thread['tid']]]['threadsubject'] = $thread['subject'];
}
unset($tids);

				



				$query = $db->simple_select("users", "username, uid", "uid IN(".implode(',', array_keys($uids)).")");
while($user = $db->fetch_array($query))
{
$ipaddresses[$uids[$user['uid']]]['username'] = $user['username'];
}
unset($uids);

				$query = $db->simple_select("users", "username, uid", "uid IN(".implode(',', array_keys($uids)).")");
while($user = $db->fetch_array($query))
{
$ipaddresses[$uids[$user['uid']]]['username'] = $user['username'];
}
unset($uids);

				



				foreach($ipaddresses as $ipaddress)
{
$ip = $ipaddress['ipaddress'];

				foreach($ipaddresses as $ipaddress)
{
$ip = $ipaddress['ipaddress'];

Zeile 2660Zeile 2782
		}

if($ipaddressvalue)

		}

if($ipaddressvalue)

		{

		{

			$lang->ipsearch_results = $lang->sprintf($lang->ipsearch_results, $ipaddressvalue);

			$lang->ipsearch_results = $lang->sprintf($lang->ipsearch_results, $ipaddressvalue);

		}

		}

		else

		else

		{

		{

			$lang->ipsearch_results = $lang->ipsearch;

			$lang->ipsearch_results = $lang->ipsearch;

		}

if(!strstr($mybb->input['ipaddress'], "*") && !strstr($mybb->input['ipaddress'], ":"))
{
$misc_info_link = "<div class=\"float_right\">(<a href=\"modcp.php?action=iplookup&ipaddress=".htmlspecialchars_uni($mybb->input['ipaddress'])."\" onclick=\"MyBB.popupWindow('{$mybb->settings['bburl']}/modcp.php?action=iplookup&ipaddress=".htmlspecialchars_uni($mybb->input['ipaddress'])."', 'iplookup', 500, 250); return false;\">{$lang->info_on_ip}</a>)</div>";
}

		}

if(!strstr($mybb->input['ipaddress'], "*") && !strstr($mybb->input['ipaddress'], ":"))
{
$misc_info_link = "<div class=\"float_right\">(<a href=\"modcp.php?action=iplookup&ipaddress=".htmlspecialchars_uni($mybb->input['ipaddress'])."\" onclick=\"MyBB.popupWindow('{$mybb->settings['bburl']}/modcp.php?action=iplookup&ipaddress=".urlencode($mybb->input['ipaddress'])."', 'iplookup', 500, 250); return false;\">{$lang->info_on_ip}</a>)</div>";
}


eval("\$ipsearch_results = \"".$templates->get("modcp_ipsearch_results")."\";");
}


eval("\$ipsearch_results = \"".$templates->get("modcp_ipsearch_results")."\";");
}

Zeile 2690Zeile 2812
	{
$usersearchselect = "checked=\"checked\"";
}

	{
$usersearchselect = "checked=\"checked\"";
}

	



	$plugins->run_hooks("modcp_ipsearch_end");

eval("\$ipsearch = \"".$templates->get("modcp_ipsearch")."\";");

	$plugins->run_hooks("modcp_ipsearch_end");

eval("\$ipsearch = \"".$templates->get("modcp_ipsearch")."\";");

Zeile 2711Zeile 2833
			$ip_record = @geoip_record_by_name($mybb->input['ipaddress']);
if($ip_record)
{

			$ip_record = @geoip_record_by_name($mybb->input['ipaddress']);
if($ip_record)
{

				$ipaddress_location = htmlspecialchars_uni($ip_record['country_name']);

				$ipaddress_location = htmlspecialchars_uni(utf8_encode($ip_record['country_name']));

				if($ip_record['city'])
{

				if($ip_record['city'])
{

					$ipaddress_location .= $lang->comma.htmlspecialchars_uni($ip_record['city']);

					$ipaddress_location .= $lang->comma.htmlspecialchars_uni(utf8_encode($ip_record['city']));

				}
}
}

				}
}
}

		



		$ipaddress_host_name = htmlspecialchars_uni(@gethostbyaddr($mybb->input['ipaddress']));

		$ipaddress_host_name = htmlspecialchars_uni(@gethostbyaddr($mybb->input['ipaddress']));

		



		// gethostbyaddr returns the same ip on failure
if($ipaddress_host_name == $mybb->input['ipaddress'])
{
$ipaddress_host_name = $lang->na;
}
}

		// gethostbyaddr returns the same ip on failure
if($ipaddress_host_name == $mybb->input['ipaddress'])
{
$ipaddress_host_name = $lang->na;
}
}

	



	$plugins->run_hooks("modcp_iplookup_end");

	$plugins->run_hooks("modcp_iplookup_end");

	



	eval("\$iplookup = \"".$templates->get('modcp_ipsearch_misc_info')."\";");
output_page($iplookup);
}

	eval("\$iplookup = \"".$templates->get('modcp_ipsearch_misc_info')."\";");
output_page($iplookup);
}

Zeile 2783Zeile 2905
	{
eval("\$allbannedpages = \"".$templates->get("modcp_banning_multipage")."\";");
}

	{
eval("\$allbannedpages = \"".$templates->get("modcp_banning_multipage")."\";");
}

	



	$plugins->run_hooks("modcp_banning_start");

$query = $db->query("

	$plugins->run_hooks("modcp_banning_start");

$query = $db->query("

Zeile 2794Zeile 2916
		ORDER BY lifted ASC
LIMIT {$start}, {$perpage}
");

		ORDER BY lifted ASC
LIMIT {$start}, {$perpage}
");





	// Get the banned users
while($banned = $db->fetch_array($query))
{

	// Get the banned users
while($banned = $db->fetch_array($query))
{

Zeile 2812Zeile 2934
		$trow = alt_trow();

if($banned['reason'])

		$trow = alt_trow();

if($banned['reason'])

		{

		{

			$banned['reason'] = htmlspecialchars_uni($parser->parse_badwords($banned['reason']));
}
else
{
$banned['reason'] = $lang->na;

			$banned['reason'] = htmlspecialchars_uni($parser->parse_badwords($banned['reason']));
}
else
{
$banned['reason'] = $lang->na;

		}

		}


if($banned['lifted'] == 'perm' || $banned['lifted'] == '' || $banned['bantime'] == 'perm' || $banned['bantime'] == '---')
{


if($banned['lifted'] == 'perm' || $banned['lifted'] == '' || $banned['bantime'] == 'perm' || $banned['bantime'] == '---')
{

Zeile 2829Zeile 2951
		{
$banlength = $bantimes[$banned['bantime']];
$remaining = $banned['lifted']-TIME_NOW;

		{
$banlength = $bantimes[$banned['bantime']];
$remaining = $banned['lifted']-TIME_NOW;





			$timeremaining = nice_time($remaining, array('short' => 1, 'seconds' => false))."";

if($remaining < 3600)

			$timeremaining = nice_time($remaining, array('short' => 1, 'seconds' => false))."";

if($remaining < 3600)

Zeile 2856Zeile 2978
	if(!$bannedusers)
{
eval("\$bannedusers = \"".$templates->get("modcp_banning_nobanned")."\";");

	if(!$bannedusers)
{
eval("\$bannedusers = \"".$templates->get("modcp_banning_nobanned")."\";");

	}

	}


$plugins->run_hooks("modcp_banning");



$plugins->run_hooks("modcp_banning");


Zeile 2875Zeile 2997
	if(!$ban['uid'])
{
error($lang->error_invalidban);

	if(!$ban['uid'])
{
error($lang->error_invalidban);

	}

	}


// Permission to edit this ban?
if($mybb->user['uid'] != $ban['admin'] && $mybb->usergroup['issupermod'] != 1 && $mybb->usergroup['cancp'] != 1)
{
error_no_permission();
}


// Permission to edit this ban?
if($mybb->user['uid'] != $ban['admin'] && $mybb->usergroup['issupermod'] != 1 && $mybb->usergroup['cancp'] != 1)
{
error_no_permission();
}

	



	$plugins->run_hooks("modcp_liftban_start");

	$plugins->run_hooks("modcp_liftban_start");

 

$query = $db->simple_select("users", "username", "uid = '{$ban['uid']}'");
$username = $db->fetch_field($query, "username");


$updated_group = array(
'usergroup' => $ban['oldgroup'],


$updated_group = array(
'usergroup' => $ban['oldgroup'],

Zeile 2895Zeile 3020

$cache->update_banned();
$cache->update_moderators();


$cache->update_banned();
$cache->update_moderators();

	


	log_moderator_action(array("uid" => $ban['uid'], "username" => $username), $lang->lifted_ban);


	$plugins->run_hooks("modcp_liftban_end");

redirect("modcp.php?action=banning", $lang->redirect_banlifted);

	$plugins->run_hooks("modcp_liftban_end");

redirect("modcp.php?action=banning", $lang->redirect_banlifted);

Zeile 2932Zeile 3058
	else
{
// Get the users info from their Username

	else
{
// Get the users info from their Username

		$query = $db->simple_select("users", "uid, usergroup, additionalgroups, displaygroup", "username = '".$db->escape_string($mybb->input['username'])."'", array('limit' => 1));

		$query = $db->simple_select("users", "uid, username, usergroup, additionalgroups, displaygroup", "username = '".$db->escape_string($mybb->input['username'])."'", array('limit' => 1));

		$user = $db->fetch_array($query);
if(!$user['uid'])
{

		$user = $db->fetch_array($query);
if(!$user['uid'])
{

Zeile 2973Zeile 3099
			$errors[] = $lang->error_useralreadybanned;
}
}

			$errors[] = $lang->error_useralreadybanned;
}
}

	



	$plugins->run_hooks("modcp_do_banuser_start");

	$plugins->run_hooks("modcp_do_banuser_start");





	// Still no errors? Ban the user
if(!$errors)
{

	// Still no errors? Ban the user
if(!$errors)
{

Zeile 2991Zeile 3117

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


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

 
			$username_select = $db->simple_select('users', 'username', "uid='" . (int)$mybb->input['uid'] . "'");
$user['username'] = $db->fetch_field($username_select, 'username');

			$update_array = array(

			$update_array = array(

				'gid' => intval($mybb->input['usergroup']),
'admin' => intval($mybb->user['uid']),
'dateline' => TIME_NOW,
'bantime' => $db->escape_string($mybb->input['liftafter']),
'lifted' => $db->escape_string($lifted),
'reason' => $db->escape_string($mybb->input['banreason'])
);

				'gid' => intval($mybb->input['usergroup']),
'admin' => intval($mybb->user['uid']),
'dateline' => TIME_NOW,
'bantime' => $db->escape_string($mybb->input['liftafter']),
'lifted' => $db->escape_string($lifted),
'reason' => $db->escape_string($mybb->input['banreason'])
);


$db->update_query('banned', $update_array, "uid='{$user['uid']}'");


$db->update_query('banned', $update_array, "uid='{$user['uid']}'");

		}
else

		}
else

		{
$insert_array = array(
'uid' => $user['uid'],

		{
$insert_array = array(
'uid' => $user['uid'],

Zeile 3029Zeile 3157
		$db->update_query('users', $update_array, "uid = {$user['uid']}");

$cache->update_banned();

		$db->update_query('users', $update_array, "uid = {$user['uid']}");

$cache->update_banned();

		












// Log edit or add ban
if($mybb->input['uid'])
{
log_moderator_action(array("uid" => $user['uid'], "username" => $user['username']), $lang->edited_user_ban);
}
else
{
log_moderator_action(array("uid" => $user['uid'], "username" => $user['username']), $lang->banned_user);
}


		$plugins->run_hooks("modcp_do_banuser_end");

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

		$plugins->run_hooks("modcp_do_banuser_end");

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

Zeile 3060Zeile 3198
	{
add_breadcrumb($lang->mcp_nav_editing_ban);
}

	{
add_breadcrumb($lang->mcp_nav_editing_ban);
}

	



	$plugins->run_hooks("modcp_banuser_start");

// If incoming user ID, we are editing a ban
if($mybb->input['uid'])

	$plugins->run_hooks("modcp_banuser_start");

// If incoming user ID, we are editing a ban
if($mybb->input['uid'])

	{

	{

		$query = $db->query("
SELECT b.*, u.username, u.uid
FROM ".TABLE_PREFIX."banned b

		$query = $db->query("
SELECT b.*, u.username, u.uid
FROM ".TABLE_PREFIX."banned b

Zeile 3083Zeile 3221
			eval("\$banuser_username = \"".$templates->get("modcp_banuser_editusername")."\";");
}
}

			eval("\$banuser_username = \"".$templates->get("modcp_banuser_editusername")."\";");
}
}

	



	// New ban!
if(!$banuser_username)
{

	// New ban!
if(!$banuser_username)
{

Zeile 3095Zeile 3233
		else
{
$username = htmlspecialchars_uni($mybb->input['username']);

		else
{
$username = htmlspecialchars_uni($mybb->input['username']);

		}

		}

		eval("\$banuser_username = \"".$templates->get("modcp_banuser_addusername")."\";");
}


		eval("\$banuser_username = \"".$templates->get("modcp_banuser_addusername")."\";");
}


Zeile 3127Zeile 3265
		else
{
$liftlist .= ">{$title} ({$thatime})</option>\n";

		else
{
$liftlist .= ">{$title} ({$thatime})</option>\n";

		}

		}

	}

	}

	



	$bangroups = '';
$query = $db->simple_select("usergroups", "gid, title", "isbannedgroup=1");
while($item = $db->fetch_array($query))

	$bangroups = '';
$query = $db->simple_select("usergroups", "gid, title", "isbannedgroup=1");
while($item = $db->fetch_array($query))

Zeile 3141Zeile 3279
		}
$bangroups .= "<option value=\"{$item['gid']}\"{$selected}>".htmlspecialchars_uni($item['title'])."</option>\n";
}

		}
$bangroups .= "<option value=\"{$item['gid']}\"{$selected}>".htmlspecialchars_uni($item['title'])."</option>\n";
}

	



	$lift_link = "<div class=\"float_right\"><a href=\"modcp.php?action=liftban&amp;uid={$user['uid']}&amp;my_post_key={$mybb->post_code}\">{$lang->lift_ban}</a></div>";

	$lift_link = "<div class=\"float_right\"><a href=\"modcp.php?action=liftban&amp;uid={$user['uid']}&amp;my_post_key={$mybb->post_code}\">{$lang->lift_ban}</a></div>";

	



	$plugins->run_hooks("modcp_banuser_end");

	$plugins->run_hooks("modcp_banuser_end");

	



	eval("\$banuser = \"".$templates->get("modcp_banuser")."\";");
output_page($banuser);

	eval("\$banuser = \"".$templates->get("modcp_banuser")."\";");
output_page($banuser);

}


}


if($mybb->input['action'] == "do_modnotes")
{
// Verify incoming POST request
verify_post_check($mybb->input['my_post_key']);

if($mybb->input['action'] == "do_modnotes")
{
// Verify incoming POST request
verify_post_check($mybb->input['my_post_key']);

	



	$plugins->run_hooks("modcp_do_modnotes_start");

	$plugins->run_hooks("modcp_do_modnotes_start");

	



	// Update Moderator Notes cache
$update_cache = array(
"modmessage" => $mybb->input['modnotes']
);
$cache->update("modnotes", $update_cache);

	// Update Moderator Notes cache
$update_cache = array(
"modmessage" => $mybb->input['modnotes']
);
$cache->update("modnotes", $update_cache);

	



	$plugins->run_hooks("modcp_do_modnotes_end");

	$plugins->run_hooks("modcp_do_modnotes_end");

	



	redirect("modcp.php", $lang->redirect_modnotes);
}


	redirect("modcp.php", $lang->redirect_modnotes);
}


Zeile 3178Zeile 3316
		WHERE a.visible='0' {$tflist}
");
$unapproved_attachments = $db->fetch_field($query, "unapprovedattachments");

		WHERE a.visible='0' {$tflist}
");
$unapproved_attachments = $db->fetch_field($query, "unapprovedattachments");





	if($unapproved_attachments > 0)
{
$query = $db->query("

	if($unapproved_attachments > 0)
{
$query = $db->query("

Zeile 3202Zeile 3340
	else
{
$latest_attachment = "<span style=\"text-align: center;\">{$lang->lastpost_never}</span>";

	else
{
$latest_attachment = "<span style=\"text-align: center;\">{$lang->lastpost_never}</span>";

	}

	}


$query = $db->query("
SELECT COUNT(pid) AS unapprovedposts


$query = $db->query("
SELECT COUNT(pid) AS unapprovedposts

Zeile 3266Zeile 3404
	else
{
$latest_thread = "<span style=\"text-align: center;\">{$lang->lastpost_never}</span>";

	else
{
$latest_thread = "<span style=\"text-align: center;\">{$lang->lastpost_never}</span>";

 
	}

$where = '';
if($tflist)
{
$where = "WHERE (t.fid <> 0 {$tflist}) OR (!l.fid)";

	}

$query = $db->query("

	}

$query = $db->query("

Zeile 3275Zeile 3419
		LEFT JOIN ".TABLE_PREFIX."threads t ON (t.tid=l.tid)
LEFT JOIN ".TABLE_PREFIX."forums f ON (f.fid=l.fid)
LEFT JOIN ".TABLE_PREFIX."posts p ON (p.pid=l.pid)

		LEFT JOIN ".TABLE_PREFIX."threads t ON (t.tid=l.tid)
LEFT JOIN ".TABLE_PREFIX."forums f ON (f.fid=l.fid)
LEFT JOIN ".TABLE_PREFIX."posts p ON (p.pid=l.pid)

 
		{$where}

		ORDER BY l.dateline DESC
LIMIT 5
");

		ORDER BY l.dateline DESC
LIMIT 5
");

 


	while($logitem = $db->fetch_array($query))
{
$information = '';

	while($logitem = $db->fetch_array($query))
{
$information = '';

 
		$logitem['action'] = htmlspecialchars_uni($logitem['action']);

		$log_date = my_date($mybb->settings['dateformat'], $logitem['dateline']);
$log_time = my_date($mybb->settings['timeformat'], $logitem['dateline']);
$trow = alt_trow();

		$log_date = my_date($mybb->settings['dateformat'], $logitem['dateline']);
$log_time = my_date($mybb->settings['timeformat'], $logitem['dateline']);
$trow = alt_trow();

Zeile 3298Zeile 3445
		{
$information .= "<strong>{$lang->post}</strong> <a href=\"".get_post_link($logitem['pid'])."#pid{$logitem['pid']}\">".htmlspecialchars_uni($logitem['psubject'])."</a>";
}

		{
$information .= "<strong>{$lang->post}</strong> <a href=\"".get_post_link($logitem['pid'])."#pid{$logitem['pid']}\">".htmlspecialchars_uni($logitem['psubject'])."</a>";
}

		



		// Edited a user?
if(!$logitem['tsubject'] || !$logitem['fname'] || !$logitem['psubject'])
{

		// Edited a user?
if(!$logitem['tsubject'] || !$logitem['fname'] || !$logitem['psubject'])
{

Zeile 3391Zeile 3538

if(!$bannedusers)
{


if(!$bannedusers)
{

		eval("\$bannedusers = \"".$templates->get("modcp_banning_nobanned")."\";");

		eval("\$bannedusers = \"".$templates->get("modcp_nobanned")."\";");

	}

	}





	$modnotes = $cache->read("modnotes");
$modnotes = htmlspecialchars_uni($modnotes['modmessage']);

	$modnotes = $cache->read("modnotes");
$modnotes = htmlspecialchars_uni($modnotes['modmessage']);

	



	$plugins->run_hooks("modcp_end");

	$plugins->run_hooks("modcp_end");





	eval("\$modcp = \"".$templates->get("modcp")."\";");
output_page($modcp);
}

	eval("\$modcp = \"".$templates->get("modcp")."\";");
output_page($modcp);
}



 
?>

?>