Vergleich modcp.php - 1.8.4 - 1.8.37

  Keine Änderungen   Hinzugefügt   Modifiziert   Entfernt
Zeile 11Zeile 11
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,modcp_reports_allreports,modcp_modlogs_multipage,modcp_announcements_delete,modcp_announcements_edit,modcp_awaitingmoderation,modcp_banuser_bangroups_hidden";
$templatelist .= ",modcp_reports_allnoreports,modcp_reports_noreports,modcp_banning,modcp_banning_ban,modcp_announcements_announcement_global,modcp_no_announcements_forum,modcp_modqueue_threads_thread,modcp_awaitingthreads,modcp_banuser_bangroups";
$templatelist .= ",modcp_banning_nobanned,modcp_modqueue_threads_empty,modcp_modqueue_masscontrols,modcp_modqueue_threads,modcp_modqueue_posts_post,modcp_modqueue_posts_empty,modcp_awaitingposts,modcp_nav_editprofile";

$templatelist = "modcp_reports,modcp_reports_report,modcp_reports_selectall,modcp_reports_multipage,modcp_reports_allreport,modcp_reports_allreports,modcp_modlogs_multipage,modcp_announcements_delete,modcp_announcements_edit,modcp_awaitingmoderation";
$templatelist .= ",modcp_reports_allnoreports,modcp_reports_noreports,modcp_banning,modcp_banning_ban,modcp_announcements_announcement_global,modcp_no_announcements_forum,modcp_modqueue_threads_thread,modcp_awaitingthreads,preview";
$templatelist .= ",modcp_banning_nobanned,modcp_modqueue_threads_empty,modcp_modqueue_masscontrols,modcp_modqueue_threads,modcp_modqueue_posts_post,modcp_modqueue_posts_empty,modcp_awaitingposts,modcp_nav_editprofile,modcp_nav_banning";

$templatelist .= ",modcp_nav,modcp_modlogs_noresults,modcp_modlogs_nologs,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, modcp_nav_forums_posts";

$templatelist .= ",modcp_nav,modcp_modlogs_noresults,modcp_modlogs_nologs,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, modcp_nav_forums_posts";

$templatelist .= ",codebuttons,smilieinsert,modcp_announcements_new,modcp_modqueue_empty,forumjump_bit,forumjump_special,modcp_warninglogs_warning_revoked,modcp_warninglogs_warning,modcp_ipsearch_result,modcp_nav_modqueue,modcp_banuser_liftlist";

$templatelist .= ",codebuttons,modcp_announcements_new,modcp_modqueue_empty,forumjump_bit,forumjump_special,modcp_warninglogs_warning_revoked,modcp_warninglogs_warning,modcp_ipsearch_result,modcp_nav_modqueue,modcp_banuser_liftlist";

$templatelist .= ",modcp_modlogs,modcp_finduser_user,modcp_finduser,usercp_profile_customfield,usercp_profile_profilefields,modcp_ipsearch_noresults,modcp_ipsearch_results,modcp_ipsearch_misc_info,modcp_nav_announcements,modcp_modqueue_post_link";
$templatelist .= ",modcp_editprofile,modcp_ipsearch,modcp_banuser_addusername,modcp_banuser,modcp_warninglogs_nologs,modcp_banuser_editusername,modcp_lastattachment,modcp_lastpost,modcp_lastthread,modcp_nobanned,modcp_modqueue_thread_link";

$templatelist .= ",modcp_modlogs,modcp_finduser_user,modcp_finduser,usercp_profile_customfield,usercp_profile_profilefields,modcp_ipsearch_noresults,modcp_ipsearch_results,modcp_ipsearch_misc_info,modcp_nav_announcements,modcp_modqueue_post_link";
$templatelist .= ",modcp_editprofile,modcp_ipsearch,modcp_banuser_addusername,modcp_banuser,modcp_warninglogs_nologs,modcp_banuser_editusername,modcp_lastattachment,modcp_lastpost,modcp_lastthread,modcp_nobanned,modcp_modqueue_thread_link";

$templatelist .= ",modcp_warninglogs,modcp_modlogs_result,modcp_editprofile_signature,forumjump_advanced,smilieinsert_getmore,smilieinsert_smilie,smilieinsert_smilie_empty,modcp_announcements_forum_nomod,modcp_announcements_announcement";
$templatelist .= ",multipage,multipage_end,multipage_jump_page,multipage_nextpage,multipage_page,multipage_page_current,multipage_page_link_current,multipage_prevpage,multipage_start,modcp_editprofile_away,modcp_awaitingattachments,modcp_modqueue_attachment_link,modcp_latestfivemodactions,modcp_nav_banning";
$templatelist .= ",postbit_groupimage,postbit_userstar,postbit_online,postbit_offline,postbit_away,postbit_avatar,postbit_find,postbit_pm,postbit_email,postbit_www,postbit_author_user,announcement_edit,announcement_quickdelete,postbit,preview,postmodcp_nav_announcements,modcp_nav_reportcenter,modcp_nav_modlogs";
$templatelist .= ",modcp_awaitingmoderation_none,modcp_banning_edit,modcp_banuser_bangroups_group,modcp_banuser_lift,modcp_modlogs_result_announcement,modcp_modlogs_result_forum,modcp_modlogs_result_post,modcp_modlogs_result_thread,modcp_modlogs_user";

$templatelist .= ",modcp_warninglogs,modcp_modlogs_result,modcp_editprofile_signature,forumjump_advanced,modcp_announcements_forum_nomod,modcp_announcements_announcement,usercp_profile_away,modcp_modlogs_user,modcp_editprofile_away";
$templatelist .= ",multipage,multipage_end,multipage_jump_page,multipage_nextpage,multipage_page,multipage_page_current,multipage_page_link_current,multipage_prevpage,multipage_start,modcp_awaitingattachments,modcp_modqueue_attachment_link";
$templatelist .= ",postbit_groupimage,postbit_userstar,postbit_online,postbit_offline,postbit_away,postbit_avatar,postbit_find,postbit_pm,postbit_email,postbit_www,postbit_author_user,announcement_edit,announcement_quickdelete";
$templatelist .= ",modcp_awaitingmoderation_none,modcp_banning_edit,modcp_banuser_bangroups_group,modcp_banuser_lift,modcp_modlogs_result_announcement,modcp_modlogs_result_forum,modcp_modlogs_result_post,modcp_modlogs_result_thread";

$templatelist .= ",modcp_nav_warninglogs,modcp_nav_ipsearch,modcp_nav_users,modcp_announcements_day,modcp_announcements_month_start,modcp_announcements_month_end,modcp_announcements_announcement_expired,modcp_announcements_announcement_active";

$templatelist .= ",modcp_nav_warninglogs,modcp_nav_ipsearch,modcp_nav_users,modcp_announcements_day,modcp_announcements_month_start,modcp_announcements_month_end,modcp_announcements_announcement_expired,modcp_announcements_announcement_active";

$templatelist .= ",modcp_modqueue_link_forum,modcp_modqueue_link_thread,usercp_profile_day,usercp_profile_away,modcp_ipsearch_result_regip,modcp_ipsearch_result_lastip,modcp_ipsearch_result_post,modcp_ipsearch_results_information,usercp_profile_profilefields_text";
$templatelist .= ",usercp_profile_profilefields_select_option,usercp_profile_profilefields_multiselect,usercp_profile_profilefields_select,usercp_profile_profilefields_textarea,usercp_profile_profilefields_radio,usercp_profile_profilefields_checkbox";


$templatelist .= ",modcp_modqueue_link_forum,modcp_modqueue_link_thread,usercp_profile_day,modcp_ipsearch_result_regip,modcp_ipsearch_result_lastip,modcp_ipsearch_result_post,modcp_ipsearch_results_information,usercp_profile_profilefields_text";
$templatelist .= ",usercp_profile_profilefields_select_option,usercp_profile_profilefields_multiselect,usercp_profile_profilefields_select,usercp_profile_profilefields_textarea,usercp_profile_profilefields_radio,postbit";
$templatelist .= ",modcp_banning_remaining,postmodcp_nav_announcements,modcp_nav_reportcenter,modcp_nav_modlogs,modcp_latestfivemodactions,modcp_banuser_bangroups_hidden,modcp_banuser_bangroups,usercp_profile_profilefields_checkbox";


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 55Zeile 56
$flist_queue_attach = $wflist_reports = $tflist_reports = $flist_reports = $tflist_modlog = $flist_modlog = $errors = '';
// SQL for fetching items only related to forums this user moderates
$moderated_forums = array();

$flist_queue_attach = $wflist_reports = $tflist_reports = $flist_reports = $tflist_modlog = $flist_modlog = $errors = '';
// SQL for fetching items only related to forums this user moderates
$moderated_forums = array();

 
$numannouncements = $nummodqueuethreads = $nummodqueueposts = $nummodqueueattach = $numreportedposts = $nummodlogs = 0;

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

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

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











	$query = $db->simple_select("moderators", "*", "(id='{$mybb->user['uid']}' AND isgroup = '0') OR (id IN ({$mybb->usergroup['all_usergroups']}) AND isgroup = '1')");
while($forum = $db->fetch_array($query))
{
$moderated_forums[] = $forum['fid'];
$children = get_child_list($forum['fid']);
if(is_array($children))
{
$moderated_forums = array_merge($moderated_forums, $children);
}
}
$moderated_forums = array_unique($moderated_forums);


$numannouncements = $nummodqueuethreads = $nummodqueueposts = $nummodqueueattach = $numreportedposts = $nummodlogs = 0;


$numannouncements = $nummodqueuethreads = $nummodqueueposts = $nummodqueueattach = $numreportedposts = $nummodlogs = 0;

	while($forum = $db->fetch_array($query))
{
// For Announcements
if($forum['canmanageannouncements'] == 1)
{
++$numannouncements;
}


	foreach($moderated_forums as $moderated_forum)
{
// For Announcements
if(is_moderator($moderated_forum, 'canmanageannouncements'))
{
++$numannouncements;
}


		// For the Mod Queues

		// For the Mod Queues

		if($forum['canapproveunapprovethreads'] == 1)

		if(is_moderator($moderated_forum, 'canapproveunapprovethreads'))

		{

		{

			$flist_queue_threads .= ",'{$forum['fid']}'";



			$flist_queue_threads .= ",'{$moderated_forum}'";
++$nummodqueuethreads;
}





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

if($forum['canapproveunapproveposts'] == 1)
{
$flist_queue_posts .= ",'{$forum['fid']}'";

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

		if(is_moderator($moderated_forum, 'canapproveunapproveposts'))
{
$flist_queue_posts .= ",'{$moderated_forum}'";















			++$nummodqueueposts;
}

			++$nummodqueueposts;
}


if($forum['canapproveunapproveattachs'] == 1)


if(is_moderator($moderated_forum, 'canapproveunapproveattachs'))

		{

		{

			$flist_queue_attach .= ",'{$forum['fid']}'";

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

			$flist_queue_attach .= ",'{$moderated_forum}'";
++$nummodqueueattach;
}








// For Reported posts


// For Reported posts

		if($forum['canmanagereportedposts'] == 1)

		if(is_moderator($moderated_forum, 'canmanagereportedposts'))

		{

		{

			$flist_reports .= ",'{$forum['fid']}'";

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

			$flist_reports .= ",'{$moderated_forum}'";







			++$numreportedposts;
}

// For the Mod Log

			++$numreportedposts;
}

// For the Mod Log

		if($forum['canviewmodlog'] == 1)
{
$flist_modlog .= ",'{$forum['fid']}'";

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

		if(is_moderator($moderated_forum, 'canviewmodlog'))
{
$flist_modlog .= ",'{$moderated_forum}'";







			++$nummodlogs;

			++$nummodlogs;

		}

$flist .= ",'{$forum['fid']}'";

		}







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

		$flist .= ",'{$moderated_forum}'";






	}
if($flist_queue_threads)
{

	}
if($flist_queue_threads)
{

Zeile 149Zeile 124
	{
$tflist_queue_posts = " AND t.fid IN (0{$flist_queue_posts})";
$flist_queue_posts = " AND fid IN (0{$flist_queue_posts})";

	{
$tflist_queue_posts = " AND t.fid IN (0{$flist_queue_posts})";
$flist_queue_posts = " AND fid IN (0{$flist_queue_posts})";

	}

	}

	if($flist_queue_attach)

	if($flist_queue_attach)

	{

	{

		$tflist_queue_attach = " AND t.fid IN (0{$flist_queue_attach})";
$flist_queue_attach = " AND fid IN (0{$flist_queue_attach})";
}
if($flist_reports)

		$tflist_queue_attach = " AND t.fid IN (0{$flist_queue_attach})";
$flist_queue_attach = " AND fid IN (0{$flist_queue_attach})";
}
if($flist_reports)

	{

	{

		$wflist_reports = "WHERE r.id3 IN (0{$flist_reports})";
$tflist_reports = " AND r.id3 IN (0{$flist_reports})";
$flist_reports = " AND id3 IN (0{$flist_reports})";

		$wflist_reports = "WHERE r.id3 IN (0{$flist_reports})";
$tflist_reports = " AND r.id3 IN (0{$flist_reports})";
$flist_reports = " AND id3 IN (0{$flist_reports})";

Zeile 262Zeile 237

if(!empty($nav_announcements) || !empty($nav_modqueue) || !empty($nav_reportcenter) || !empty($nav_modlogs))
{


if(!empty($nav_announcements) || !empty($nav_modqueue) || !empty($nav_reportcenter) || !empty($nav_modlogs))
{

 
	$expaltext = (in_array("modcpforums", $collapse)) ? $lang->expcol_expand : $lang->expcol_collapse;

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

if(!empty($nav_editprofile) || !empty($nav_banning) || !empty($nav_warninglogs) || !empty($nav_ipsearch))
{

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

if(!empty($nav_editprofile) || !empty($nav_banning) || !empty($nav_warninglogs) || !empty($nav_ipsearch))
{

 
	$expaltext = (in_array("modcpusers", $collapse)) ? $lang->expcol_expand : $lang->expcol_collapse;

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


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


Zeile 284Zeile 261
	verify_post_check($mybb->get_input('my_post_key'));

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

	verify_post_check($mybb->get_input('my_post_key'));

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

	if(empty($mybb->input['reports']))

	if(empty($mybb->input['reports']) && empty($mybb->cookies['inlinereports']))

	{
error($lang->error_noselected_reports);
}


	{
error($lang->error_noselected_reports);
}


	$sql = '1=1';
if(empty($mybb->input['allbox']))






























	$message = $lang->redirect_reportsmarked;

if(isset($mybb->cookies['inlinereports']))
{
if($mybb->cookies['inlinereports'] == '|ALL|') {
$message = $lang->redirect_allreportsmarked;
$sql = "1=1";
if(isset($mybb->cookies['inlinereports_removed']))
{
$inlinereportremovedlist = explode("|", $mybb->cookies['inlinereports_removed']);
$reports = array_map("intval", $inlinereportremovedlist);
$rids = implode("','", $reports);
$sql = "rid NOT IN ('0','{$rids}')";
}
}
else
{
$inlinereportlist = explode("|", $mybb->cookies['inlinereports']);
$reports = array_map("intval", $inlinereportlist);

if(!count($reports))
{
error($lang->error_noselected_reports);
}

$rids = implode("','", $reports);

$sql = "rid IN ('0','{$rids}')";
}
}
else

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

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

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

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

	}

$plugins->run_hooks("modcp_do_reports");

	}

$plugins->run_hooks("modcp_do_reports");


$db->update_query("reportedcontent", array('reportstatus' => 1), "{$sql}{$flist_reports}");
$cache->update_reportedcontent();


$db->update_query("reportedcontent", array('reportstatus' => 1), "{$sql}{$flist_reports}");
$cache->update_reportedcontent();


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

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





my_unsetcookie('inlinereports');
my_unsetcookie('inlinereports_removed');

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

redirect("modcp.php?action=reports&page={$page}", $message);
}


if($mybb->input['action'] == "reports")
{
if($mybb->usergroup['canmanagereportedcontent'] == 0)


if($mybb->input['action'] == "reports")
{
if($mybb->usergroup['canmanagereportedcontent'] == 0)

	{

	{

		error_no_permission();
}

if($numreportedposts == 0 && $mybb->usergroup['issupermod'] != 1)

		error_no_permission();
}

if($numreportedposts == 0 && $mybb->usergroup['issupermod'] != 1)

	{

	{

		error($lang->you_cannot_view_reported_posts);
}

		error($lang->you_cannot_view_reported_posts);
}





	$lang->load('report');
add_breadcrumb($lang->mcp_nav_report_center, "modcp.php?action=reports");

	$lang->load('report');
add_breadcrumb($lang->mcp_nav_report_center, "modcp.php?action=reports");





	$perpage = $mybb->settings['threadsperpage'];
if(!$perpage)
{
$perpage = 20;

	$perpage = $mybb->settings['threadsperpage'];
if(!$perpage)
{
$perpage = 20;

	}

	}


// Multipage
if($mybb->usergroup['cancp'] || $mybb->usergroup['issupermod'])


// Multipage
if($mybb->usergroup['cancp'] || $mybb->usergroup['issupermod'])

Zeile 338Zeile 347
	else
{
$query = $db->simple_select('reportedcontent', 'id3', "reportstatus='0' AND (type = 'post' OR type = '')");

	else
{
$query = $db->simple_select('reportedcontent', 'id3', "reportstatus='0' AND (type = 'post' OR type = '')");


$report_count = 0;
while($fid = $db->fetch_field($query, 'id3'))
{
if(is_moderator($fid, "canmanagereportedposts"))
{
++$report_count;
}
}
unset($fid);
}

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

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

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

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


$report_count = 0;
while($fid = $db->fetch_field($query, 'id3'))
{
if(is_moderator($fid, "canmanagereportedposts"))
{
++$report_count;
}
}
unset($fid);
}

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

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

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

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

	}

$multipage = $reportspages = '';

	}

$multipage = $reportspages = '';

Zeile 376Zeile 385
	{
$multipage = multipage($postcount, $perpage, $page, "modcp.php?action=reports");
eval("\$reportspages = \"".$templates->get("modcp_reports_multipage")."\";");

	{
$multipage = multipage($postcount, $perpage, $page, "modcp.php?action=reports");
eval("\$reportspages = \"".$templates->get("modcp_reports_multipage")."\";");

	}


	}


	$plugins->run_hooks("modcp_reports_start");

	$plugins->run_hooks("modcp_reports_start");





	// Reports

	// Reports

	$reports = '';



	$reports = $selectall = '';
$inlinecount = 0;


	$query = $db->query("

	$query = $db->query("

		SELECT r.*, u.username

		SELECT r.*, u.username, rr.title

		FROM ".TABLE_PREFIX."reportedcontent r
LEFT JOIN ".TABLE_PREFIX."users u ON (r.uid = u.uid)

		FROM ".TABLE_PREFIX."reportedcontent r
LEFT JOIN ".TABLE_PREFIX."users u ON (r.uid = u.uid)

 
		LEFT JOIN ".TABLE_PREFIX."reportreasons rr ON (r.reasonid = rr.rid)

		WHERE r.reportstatus = '0'{$tflist_reports}
ORDER BY r.reports DESC
LIMIT {$start}, {$perpage}

		WHERE r.reportstatus = '0'{$tflist_reports}
ORDER BY r.reports DESC
LIMIT {$start}, {$perpage}

Zeile 440Zeile 452
			}

if($report['reporters'])

			}

if($report['reporters'])

			{

			{

				$reporters = my_unserialize($report['reporters']);

if(is_array($reporters))

				$reporters = my_unserialize($report['reporters']);

if(is_array($reporters))

Zeile 452Zeile 464
			if(!isset($usercache[$lastposter]))
{
$usercache[$lastposter] = $lastposter;

			if(!isset($usercache[$lastposter]))
{
$usercache[$lastposter] = $lastposter;

			}

			}


$report['lastreporter'] = $lastposter;
$reportcache[] = $report;


$report['lastreporter'] = $lastposter;
$reportcache[] = $report;

Zeile 464Zeile 476
		{
$sql = implode(',', array_keys($usercache));
$query = $db->simple_select("users", "uid, username", "uid IN ({$sql})");

		{
$sql = implode(',', array_keys($usercache));
$query = $db->simple_select("users", "uid, username", "uid IN ({$sql})");





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

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

			}
}


			}
}


		// Messy * 2
// Find out post information for our reported posts
if(!empty($postcache))

		// Messy * 2
// Find out post information for our reported posts
if(!empty($postcache))

Zeile 482Zeile 494
				LEFT JOIN ".TABLE_PREFIX."threads t ON (p.tid = t.tid)
WHERE p.pid IN ({$sql})
");

				LEFT JOIN ".TABLE_PREFIX."threads t ON (p.tid = t.tid)
WHERE p.pid IN ({$sql})
");





			while($post = $db->fetch_array($query))
{
$postcache[$post['pid']] = $post;
}
}

			while($post = $db->fetch_array($query))
{
$postcache[$post['pid']] = $post;
}
}

 

$lang->page_selected = $lang->sprintf($lang->page_selected, count($reportcache));
$lang->select_all = $lang->sprintf($lang->select_all, (int)$report_count);
$lang->all_selected = $lang->sprintf($lang->all_selected, (int)$report_count);
eval("\$selectall = \"".$templates->get("modcp_reports_selectall")."\";");


$plugins->run_hooks('modcp_reports_intermediate');



$plugins->run_hooks('modcp_reports_intermediate');


Zeile 509Zeile 526
			{
case 'post':
$post = get_post_link($report['id'])."#pid{$report['id']}";

			{
case 'post':
$post = get_post_link($report['id'])."#pid{$report['id']}";

					$user = build_profile_link($postcache[$report['id']]['username'], $postcache[$report['id']]['uid']);

					$user = build_profile_link(htmlspecialchars_uni($postcache[$report['id']]['username']), $postcache[$report['id']]['uid']);

					$report_data['content'] = $lang->sprintf($lang->report_info_post, $post, $user);

$thread_link = get_thread_link($postcache[$report['id']]['tid']);

					$report_data['content'] = $lang->sprintf($lang->report_info_post, $post, $user);

$thread_link = get_thread_link($postcache[$report['id']]['tid']);

					$thread_subject = htmlspecialchars_uni($postcache[$report['id']]['subject']);

					$thread_subject = htmlspecialchars_uni($parser->parse_badwords($postcache[$report['id']]['subject']));

					$report_data['content'] .= $lang->sprintf($lang->report_info_post_thread, $thread_link, $thread_subject);

break;
case 'profile':

					$report_data['content'] .= $lang->sprintf($lang->report_info_post_thread, $thread_link, $thread_subject);

break;
case 'profile':

					$user = build_profile_link($usercache[$report['id']]['username'], $usercache[$report['id']]['uid']);

					$user = build_profile_link(htmlspecialchars_uni($usercache[$report['id']]['username']), $usercache[$report['id']]['uid']);

					$report_data['content'] = $lang->sprintf($lang->report_info_profile, $user);
break;
case 'reputation':
$reputation_link = "reputation.php?uid={$usercache[$report['id3']]['uid']}#rid{$report['id']}";

					$report_data['content'] = $lang->sprintf($lang->report_info_profile, $user);
break;
case 'reputation':
$reputation_link = "reputation.php?uid={$usercache[$report['id3']]['uid']}#rid{$report['id']}";

					$bad_user = build_profile_link($usercache[$report['id2']]['username'], $usercache[$report['id2']]['uid']);

					$bad_user = build_profile_link(htmlspecialchars_uni($usercache[$report['id2']]['username']), $usercache[$report['id2']]['uid']);

					$report_data['content'] = $lang->sprintf($lang->report_info_reputation, $reputation_link, $bad_user);


					$report_data['content'] = $lang->sprintf($lang->report_info_reputation, $reputation_link, $bad_user);


					$good_user = build_profile_link($usercache[$report['id3']]['username'], $usercache[$report['id3']]['uid']);

					$good_user = build_profile_link(htmlspecialchars_uni($usercache[$report['id3']]['username']), $usercache[$report['id3']]['uid']);

					$report_data['content'] .= $lang->sprintf($lang->report_info_rep_profile, $good_user);
break;
}

// Report reason and comment

					$report_data['content'] .= $lang->sprintf($lang->report_info_rep_profile, $good_user);
break;
}

// Report reason and comment

			$report_data['comment'] = $lang->na;
$report_string = "report_reason_{$report['reason']}";

if(isset($lang->$report_string))

			if($report['reasonid'] > 0)




			{

			{

				$report_data['comment'] = $lang->$report_string;











				$reason = htmlspecialchars_uni($lang->parse($report['title']));

if(empty($report['reason']))
{
eval("\$report_data['comment'] = \"".$templates->get("modcp_reports_report_comment")."\";");
}
else
{
$comment = htmlspecialchars_uni($report['reason']);
eval("\$report_data['comment'] = \"".$templates->get("modcp_reports_report_comment_extra")."\";");
}

			}

			}

			else if(!empty($report['reason']))

			else

			{

			{

				$report_data['comment'] = htmlspecialchars_uni($report['reason']);

				$report_data['comment'] = $lang->na;

			}

$report_reports = 1;

			}

$report_reports = 1;

Zeile 551Zeile 575
			}

if($report['lastreporter'])

			}

if($report['lastreporter'])

			{

			{

				if(is_array($usercache[$report['lastreporter']]))
{

				if(is_array($usercache[$report['lastreporter']]))
{

					$lastreport_user = build_profile_link($usercache[$report['lastreporter']]['username'], $report['lastreporter']);

					$lastreport_user = build_profile_link(htmlspecialchars_uni($usercache[$report['lastreporter']]['username']), $report['lastreporter']);

				}
elseif($usercache[$report['lastreporter']] > 0)
{

				}
elseif($usercache[$report['lastreporter']] > 0)
{

					$lastreport_user = $lang->na_deleted;

					$lastreport_user = htmlspecialchars_uni($lang->na_deleted);

				}

$lastreport_date = my_date('relative', $report['lastreport']);
$report_data['lastreporter'] = $lang->sprintf($lang->report_info_lastreporter, $lastreport_date, $lastreport_user);

				}

$lastreport_date = my_date('relative', $report['lastreport']);
$report_data['lastreporter'] = $lang->sprintf($lang->report_info_lastreporter, $lastreport_date, $lastreport_user);

 
			}

$inlinecheck = '';
if(isset($mybb->cookies['inlinereports']) && my_strpos($mybb->cookies['inlinereports'], "|{$report['rid']}|") !== false)
{
$inlinecheck = " checked=\"checked\"";
++$inlinecount;

			}

$plugins->run_hooks("modcp_reports_report");

			}

$plugins->run_hooks("modcp_reports_report");

Zeile 579Zeile 610
if($mybb->input['action'] == "allreports")
{
if($mybb->usergroup['canmanagereportedcontent'] == 0)

if($mybb->input['action'] == "allreports")
{
if($mybb->usergroup['canmanagereportedcontent'] == 0)

	{

	{

		error_no_permission();
}


		error_no_permission();
}


Zeile 591Zeile 622
	if(!$mybb->settings['threadsperpage'])
{
$mybb->settings['threadsperpage'] = 20;

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

	}


	}


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

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

Zeile 601Zeile 632
	}

if($mybb->usergroup['cancp'] || $mybb->usergroup['issupermod'])

	}

if($mybb->usergroup['cancp'] || $mybb->usergroup['issupermod'])

	{

	{

		$query = $db->simple_select("reportedcontent", "COUNT(rid) AS count");
$report_count = $db->fetch_field($query, "count");
}

		$query = $db->simple_select("reportedcontent", "COUNT(rid) AS count");
$report_count = $db->fetch_field($query, "count");
}

Zeile 618Zeile 649
			}
}
unset($fid);

			}
}
unset($fid);

	}

	}


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


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

Zeile 644Zeile 675
	}

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

	}

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

	{

	{

		$page = 1;
}


		$page = 1;
}


Zeile 661Zeile 692

$multipage = multipage($postcount, $perpage, $page, "modcp.php?action=allreports");
$allreportspages = '';


$multipage = multipage($postcount, $perpage, $page, "modcp.php?action=allreports");
$allreportspages = '';

	if($postcount > $perpage)

	if($postcount > $perpage)

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

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

Zeile 669Zeile 700
	$plugins->run_hooks("modcp_allreports_start");

$query = $db->query("

	$plugins->run_hooks("modcp_allreports_start");

$query = $db->query("

		SELECT r.*, u.username, p.username AS postusername, up.uid AS postuid, t.subject AS threadsubject, prrep.username AS repusername, pr.username AS profileusername

		SELECT r.*, u.username, p.username AS postusername, up.uid AS postuid, t.subject AS threadsubject, prrep.username AS repusername, pr.username AS profileusername, rr.title

		FROM ".TABLE_PREFIX."reportedcontent r
LEFT JOIN ".TABLE_PREFIX."posts p ON (r.id=p.pid)
LEFT JOIN ".TABLE_PREFIX."threads t ON (p.tid=t.tid)

		FROM ".TABLE_PREFIX."reportedcontent r
LEFT JOIN ".TABLE_PREFIX."posts p ON (r.id=p.pid)
LEFT JOIN ".TABLE_PREFIX."threads t ON (p.tid=t.tid)

Zeile 677Zeile 708
		LEFT JOIN ".TABLE_PREFIX."users up ON (p.uid=up.uid)
LEFT JOIN ".TABLE_PREFIX."users pr ON (pr.uid=r.id)
LEFT JOIN ".TABLE_PREFIX."users prrep ON (prrep.uid=r.id2)

		LEFT JOIN ".TABLE_PREFIX."users up ON (p.uid=up.uid)
LEFT JOIN ".TABLE_PREFIX."users pr ON (pr.uid=r.id)
LEFT JOIN ".TABLE_PREFIX."users prrep ON (prrep.uid=r.id2)

 
		LEFT JOIN ".TABLE_PREFIX."reportreasons rr ON (r.reasonid = rr.rid)

		{$wflist_reports}
ORDER BY r.dateline DESC
LIMIT {$start}, {$perpage}

		{$wflist_reports}
ORDER BY r.dateline DESC
LIMIT {$start}, {$perpage}

Zeile 696Zeile 728
			if($report['type'] == 'post')
{
$post = get_post_link($report['id'])."#pid{$report['id']}";

			if($report['type'] == 'post')
{
$post = get_post_link($report['id'])."#pid{$report['id']}";

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

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

				$report_data['content'] = $lang->sprintf($lang->report_info_post, $post, $user);

				$report_data['content'] = $lang->sprintf($lang->report_info_post, $post, $user);





				$thread_link = get_thread_link($report['id2']);

				$thread_link = get_thread_link($report['id2']);

				$thread_subject = htmlspecialchars_uni($report['threadsubject']);

				$thread_subject = htmlspecialchars_uni($parser->parse_badwords($report['threadsubject']));

				$report_data['content'] .= $lang->sprintf($lang->report_info_post_thread, $thread_link, $thread_subject);
}
else if($report['type'] == 'profile')
{

				$report_data['content'] .= $lang->sprintf($lang->report_info_post_thread, $thread_link, $thread_subject);
}
else if($report['type'] == 'profile')
{

				$user = build_profile_link($report['profileusername'], $report['id']);

				$user = build_profile_link(htmlspecialchars_uni($report['profileusername']), $report['id']);

				$report_data['content'] = $lang->sprintf($lang->report_info_profile, $user);

				$report_data['content'] = $lang->sprintf($lang->report_info_profile, $user);

			}

			}

			else if($report['type'] == 'reputation')
{

			else if($report['type'] == 'reputation')
{

				$user = build_profile_link($report['repusername'], $report['id2']);

				$user = build_profile_link(htmlspecialchars_uni($report['repusername']), $report['id2']);

				$reputation_link = "reputation.php?uid={$report['id3']}#rid{$report['id']}";
$report_data['content'] = $lang->sprintf($lang->report_info_reputation, $reputation_link, $user);
}

// Report reason and comment

				$reputation_link = "reputation.php?uid={$report['id3']}#rid{$report['id']}";
$report_data['content'] = $lang->sprintf($lang->report_info_reputation, $reputation_link, $user);
}

// Report reason and comment

			$report_data['comment'] = $lang->na;
$report_string = "report_reason_{$report['reason']}";

















			if($report['reasonid'] > 0)
{
$reason = htmlspecialchars_uni($lang->parse($report['title']));

if(empty($report['reason']))
{
eval("\$report_data['comment'] = \"".$templates->get("modcp_reports_report_comment")."\";");
}
else
{
$comment = htmlspecialchars_uni($report['reason']);
eval("\$report_data['comment'] = \"".$templates->get("modcp_reports_report_comment_extra")."\";");
}
}
else
{
$report_data['comment'] = $lang->na;
}


$report['reporterlink'] = get_profile_link($report['uid']);
if(!$report['username'])
{
$report['username'] = $lang->na_deleted;
$report['reporterlink'] = $post;


$report['reporterlink'] = get_profile_link($report['uid']);
if(!$report['username'])
{
$report['username'] = $lang->na_deleted;
$report['reporterlink'] = $post;

			}

if(isset($lang->$report_string))
{
$report_data['comment'] = $lang->$report_string;
}
else if(!empty($report['reason']))
{
$report_data['comment'] = htmlspecialchars_uni($report['reason']);
}

			}
$report['username'] = htmlspecialchars_uni($report['username']);










$report_data['reports'] = my_number_format($report['reports']);
$report_data['time'] = my_date('relative', $report['dateline']);


$report_data['reports'] = my_number_format($report['reports']);
$report_data['time'] = my_date('relative', $report['dateline']);

Zeile 889Zeile 929
		$logitem['action'] = htmlspecialchars_uni($logitem['action']);
$log_date = my_date('relative', $logitem['dateline']);
$trow = alt_trow();

		$logitem['action'] = htmlspecialchars_uni($logitem['action']);
$log_date = my_date('relative', $logitem['dateline']);
$trow = alt_trow();

		$username = format_name($logitem['username'], $logitem['usergroup'], $logitem['displaygroup']);
$logitem['profilelink'] = build_profile_link($username, $logitem['uid']);









		if($logitem['username'])
{
$logitem['username'] = htmlspecialchars_uni($logitem['username']);
$username = format_name($logitem['username'], $logitem['usergroup'], $logitem['displaygroup']);
$logitem['profilelink'] = build_profile_link($username, $logitem['uid']);
}
else
{
$username = $logitem['profilelink'] = $logitem['username'] = htmlspecialchars_uni($lang->na_deleted);
}

		$logitem['ipaddress'] = my_inet_ntop($db->unescape_binary($logitem['ipaddress']));

if($logitem['tsubject'])
{

		$logitem['ipaddress'] = my_inet_ntop($db->unescape_binary($logitem['ipaddress']));

if($logitem['tsubject'])
{

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

			$logitem['tsubject'] = htmlspecialchars_uni($parser->parse_badwords($logitem['tsubject']));

			$logitem['thread'] = get_thread_link($logitem['tid']);
eval("\$information .= \"".$templates->get("modcp_modlogs_result_thread")."\";");
}

			$logitem['thread'] = get_thread_link($logitem['tid']);
eval("\$information .= \"".$templates->get("modcp_modlogs_result_thread")."\";");
}

Zeile 905Zeile 953
			eval("\$information .= \"".$templates->get("modcp_modlogs_result_forum")."\";");
}
if($logitem['psubject'])

			eval("\$information .= \"".$templates->get("modcp_modlogs_result_forum")."\";");
}
if($logitem['psubject'])

		{
$logitem['psubject'] = htmlspecialchars_uni($logitem['psubject']);

		{
$logitem['psubject'] = htmlspecialchars_uni($parser->parse_badwords($logitem['psubject']));

			$logitem['post'] = get_post_link($logitem['pid']);
eval("\$information .= \"".$templates->get("modcp_modlogs_result_post")."\";");
}

			$logitem['post'] = get_post_link($logitem['pid']);
eval("\$information .= \"".$templates->get("modcp_modlogs_result_post")."\";");
}

Zeile 916Zeile 964
		{
$data = my_unserialize($logitem['data']);
if(!empty($data['uid']))

		{
$data = my_unserialize($logitem['data']);
if(!empty($data['uid']))

			{


			{
$data['username'] = htmlspecialchars_uni($data['username']);

				$information = $lang->sprintf($lang->edited_user_info, htmlspecialchars_uni($data['username']), get_profile_link($data['uid']));
}
if(!empty($data['aid']))
{

				$information = $lang->sprintf($lang->edited_user_info, htmlspecialchars_uni($data['username']), get_profile_link($data['uid']));
}
if(!empty($data['aid']))
{

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

				$data['subject'] = htmlspecialchars_uni($parser->parse_badwords($data['subject']));

				$data['announcement'] = get_announcement_link($data['aid']);
eval("\$information .= \"".$templates->get("modcp_modlogs_result_announcement")."\";");
}
}

				$data['announcement'] = get_announcement_link($data['aid']);
eval("\$information .= \"".$templates->get("modcp_modlogs_result_announcement")."\";");
}
}






$plugins->run_hooks("modcp_modlogs_result");


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

if(!$results)

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

if(!$results)

	{

	{

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


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


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

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

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

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

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

	$announcement['subject'] = htmlspecialchars_uni($parser->parse_badwords($announcement['subject']));


if(!$announcement)
{


if(!$announcement)
{

Zeile 1099Zeile 1150
		$mybb->input['starttime_month'] = '01';
}


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


	$startdate = gmmktime((int)$startdate[0], (int)$startdate[1], 0, $mybb->get_input('starttime_month', MyBB::INPUT_INT), $mybb->get_input('starttime_day', MyBB::INPUT_INT), $mybb->get_input('starttime_year', MyBB::INPUT_INT));



	$localized_time_offset = (float)$mybb->user['timezone']*3600 + $mybb->user['dst']*3600;

$startdate = gmmktime((int)$startdate[0], (int)$startdate[1], 0, $mybb->get_input('starttime_month', MyBB::INPUT_INT), $mybb->get_input('starttime_day', MyBB::INPUT_INT), $mybb->get_input('starttime_year', MyBB::INPUT_INT)) - $localized_time_offset;

	if(!checkdate($mybb->get_input('starttime_month', MyBB::INPUT_INT), $mybb->get_input('starttime_day', MyBB::INPUT_INT), $mybb->get_input('starttime_year', MyBB::INPUT_INT)) || $startdate < 0 || $startdate == false)
{
$errors[] = $lang->error_invalid_start_date;

	if(!checkdate($mybb->get_input('starttime_month', MyBB::INPUT_INT), $mybb->get_input('starttime_day', MyBB::INPUT_INT), $mybb->get_input('starttime_year', MyBB::INPUT_INT)) || $startdate < 0 || $startdate == false)
{
$errors[] = $lang->error_invalid_start_date;

	}

	}


if($mybb->get_input('endtime_type', MyBB::INPUT_INT) == 2)
{
$enddate = '0';
$mybb->input['endtime_month'] = '01';


if($mybb->get_input('endtime_type', MyBB::INPUT_INT) == 2)
{
$enddate = '0';
$mybb->input['endtime_month'] = '01';

	}
else
{

	}
else
{

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

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

		{

		{

			$mybb->input['endtime_month'] = '01';
}

			$mybb->input['endtime_month'] = '01';
}

		$enddate = gmmktime((int)$enddate[0], (int)$enddate[1], 0, $mybb->get_input('endtime_month', MyBB::INPUT_INT), $mybb->get_input('endtime_day', MyBB::INPUT_INT), $mybb->get_input('endtime_year', MyBB::INPUT_INT));

		$enddate = gmmktime((int)$enddate[0], (int)$enddate[1], 0, $mybb->get_input('endtime_month', MyBB::INPUT_INT), $mybb->get_input('endtime_day', MyBB::INPUT_INT), $mybb->get_input('endtime_year', MyBB::INPUT_INT)) - $localized_time_offset;

		if(!checkdate($mybb->get_input('endtime_month', MyBB::INPUT_INT), $mybb->get_input('endtime_day', MyBB::INPUT_INT), $mybb->get_input('endtime_year', MyBB::INPUT_INT)) || $enddate < 0 || $enddate == false)

		if(!checkdate($mybb->get_input('endtime_month', MyBB::INPUT_INT), $mybb->get_input('endtime_day', MyBB::INPUT_INT), $mybb->get_input('endtime_year', MyBB::INPUT_INT)) || $enddate < 0 || $enddate == false)

		{

		{

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


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


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

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

	}

	}





	if($mybb->get_input('allowhtml', MyBB::INPUT_INT) == 1)
{

	if($mybb->settings['announcementshtml'] && $mybb->get_input('allowhtml', MyBB::INPUT_INT) == 1)
{

		$allowhtml = 1;

		$allowhtml = 1;

	}
else
{
$allowhtml = 0;
}

	}
else
{
$allowhtml = 0;
}

	if($mybb->get_input('allowmycode', MyBB::INPUT_INT) == 1)
{
$allowmycode = 1;

	if($mybb->get_input('allowmycode', MyBB::INPUT_INT) == 1)
{
$allowmycode = 1;

Zeile 1152Zeile 1205
	else
{
$allowsmilies = 0;

	else
{
$allowsmilies = 0;

	}


	}


	$plugins->run_hooks("modcp_do_new_announcement_start");

if(!$errors)

	$plugins->run_hooks("modcp_do_new_announcement_start");

if(!$errors)

Zeile 1162Zeile 1215
		{
$preview = array();
$mybb->input['action'] = 'new_announcement';

		{
$preview = array();
$mybb->input['action'] = 'new_announcement';

		}

		}

		else
{
$insert_announcement = array(

		else
{
$insert_announcement = array(

Zeile 1177Zeile 1230
				'allowsmilies' => $allowsmilies
);
$aid = $db->insert_query("announcements", $insert_announcement);

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


log_moderator_action(array("aid" => $aid, "subject" => $db->escape_string($mybb->input['title'])), $lang->announcement_added);



log_moderator_action(array("aid" => $aid, "subject" => $mybb->input['title']), $lang->announcement_added);


			$plugins->run_hooks("modcp_do_new_announcement_end");

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

			$plugins->run_hooks("modcp_do_new_announcement_end");

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

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

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

	}
}

if($mybb->input['action'] == "new_announcement")
{
if($mybb->usergroup['canmanageannounce'] == 0)

	}
}

if($mybb->input['action'] == "new_announcement")
{
if($mybb->usergroup['canmanageannounce'] == 0)

	{
error_no_permission();
}


	{
error_no_permission();
}


	add_breadcrumb($lang->mcp_nav_announcements, "modcp.php?action=announcements");
add_breadcrumb($lang->add_announcement, "modcp.php?action=new_announcements");

	add_breadcrumb($lang->mcp_nav_announcements, "modcp.php?action=announcements");
add_breadcrumb($lang->add_announcement, "modcp.php?action=new_announcements");





	$announcement_fid = $mybb->get_input('fid', MyBB::INPUT_INT);

	$announcement_fid = $mybb->get_input('fid', MyBB::INPUT_INT);





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

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

		error_no_permission();
}

// Deal with inline errors
if(!empty($errors) || isset($preview))
{
if(!empty($errors))
{
$errors = inline_error($errors);
}
else
{
$errors = '';
}

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

$startmonth = $mybb->input['starttime_month'];
$startdateyear = htmlspecialchars_uni($mybb->input['starttime_year']);
$startday = $mybb->get_input('starttime_day', MyBB::INPUT_INT);
$starttime_time = htmlspecialchars_uni($mybb->input['starttime_time']);
$endmonth = $mybb->input['endtime_month'];
$enddateyear = htmlspecialchars_uni($mybb->input['endtime_year']);
$endday = $mybb->get_input('endtime_day', MyBB::INPUT_INT);
$endtime_time = htmlspecialchars_uni($mybb->input['endtime_time']);
}
else
{
// Note: dates are in GMT timezone
$starttime_time = gmdate("g:i a", TIME_NOW);
$endtime_time = gmdate("g:i a", TIME_NOW);
$startday = $endday = gmdate("j", TIME_NOW);
$startmonth = $endmonth = gmdate("m", TIME_NOW);
$startdateyear = gmdate("Y", TIME_NOW);


		error_no_permission();
}

// Deal with inline errors
if(!empty($errors) || isset($preview))
{
if(!empty($errors))
{
$errors = inline_error($errors);
}
else
{
$errors = '';
}

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

$startmonth = $mybb->input['starttime_month'];
$startdateyear = htmlspecialchars_uni($mybb->input['starttime_year']);
$startday = $mybb->get_input('starttime_day', MyBB::INPUT_INT);
$starttime_time = htmlspecialchars_uni($mybb->input['starttime_time']);
$endmonth = $mybb->input['endtime_month'];
$enddateyear = htmlspecialchars_uni($mybb->input['endtime_year']);
$endday = $mybb->get_input('endtime_day', MyBB::INPUT_INT);
$endtime_time = htmlspecialchars_uni($mybb->input['endtime_time']);
}
else
{
$localized_time = TIME_NOW + (float)$mybb->user['timezone']*3600 + $mybb->user['dst']*3600;

$starttime_time = gmdate($mybb->settings['timeformat'], $localized_time);
$endtime_time = gmdate($mybb->settings['timeformat'], $localized_time);
$startday = $endday = gmdate("j", $localized_time);
$startmonth = $endmonth = gmdate("m", $localized_time);
$startdateyear = gmdate("Y", $localized_time);


$announcement = array(
'subject' => '',
'message' => '',


$announcement = array(
'subject' => '',
'message' => '',

			'allowhtml' => 1,

			'allowhtml' => 0,

			'allowmycode' => 1,
'allowsmilies' => 1
);

$enddateyear = $startdateyear+1;

			'allowmycode' => 1,
'allowsmilies' => 1
);

$enddateyear = $startdateyear+1;

	}

// Generate form elements
$startdateday = $enddateday = '';
for($day = 1; $day <= 31; ++$day)
{
if($startday == $day)
{
$selected = " selected=\"selected\"";
eval("\$startdateday .= \"".$templates->get("modcp_announcements_day")."\";");
}
else
{
$selected = '';
eval("\$startdateday .= \"".$templates->get("modcp_announcements_day")."\";");
}

if($endday == $day)
{
$selected = " selected=\"selected\"";
eval("\$enddateday .= \"".$templates->get("modcp_announcements_day")."\";");
}
else
{
$selected = '';
eval("\$enddateday .= \"".$templates->get("modcp_announcements_day")."\";");
}
}

$startmonthsel = $endmonthsel = array();
foreach(array('01', '02', '03', '04', '05', '06', '07', '08', '09', '10', '11', '12') as $month)
{
$startmonthsel[$month] = '';
$endmonthsel[$month] = '';
}
$startmonthsel[$startmonth] = "selected=\"selected\"";
$endmonthsel[$endmonth] = "selected=\"selected\"";

$startdatemonth = $enddatemonth = '';

eval("\$startdatemonth .= \"".$templates->get("modcp_announcements_month_start")."\";");
eval("\$enddatemonth .= \"".$templates->get("modcp_announcements_month_end")."\";");

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

$html_sel = $mycode_sel = $smilies_sel = array('yes' => '', 'no' => '');
if($announcement['allowhtml'])
{
$html_sel['yes'] = ' checked="checked"';
}
else
{
$html_sel['no'] = ' checked="checked"';
}

if($announcement['allowmycode'])
{
$mycode_sel['yes'] = ' checked="checked"';
}
else
{
$mycode_sel['no'] = ' checked="checked"';
}











	}

// Generate form elements
$startdateday = $enddateday = '';
for($day = 1; $day <= 31; ++$day)
{
if($startday == $day)
{
$selected = " selected=\"selected\"";
eval("\$startdateday .= \"".$templates->get("modcp_announcements_day")."\";");
}
else
{
$selected = '';
eval("\$startdateday .= \"".$templates->get("modcp_announcements_day")."\";");
}

if($endday == $day)
{
$selected = " selected=\"selected\"";
eval("\$enddateday .= \"".$templates->get("modcp_announcements_day")."\";");
}
else
{
$selected = '';
eval("\$enddateday .= \"".$templates->get("modcp_announcements_day")."\";");
}
}

$startmonthsel = $endmonthsel = array();
foreach(array('01', '02', '03', '04', '05', '06', '07', '08', '09', '10', '11', '12') as $month)
{
$startmonthsel[$month] = '';
$endmonthsel[$month] = '';
}
$startmonthsel[$startmonth] = "selected=\"selected\"";
$endmonthsel[$endmonth] = "selected=\"selected\"";

$startdatemonth = $enddatemonth = '';

eval("\$startdatemonth .= \"".$templates->get("modcp_announcements_month_start")."\";");
eval("\$enddatemonth .= \"".$templates->get("modcp_announcements_month_end")."\";");

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

$html_sel = $mycode_sel = $smilies_sel = array('yes' => '', 'no' => '');

if($mybb->settings['announcementshtml'])
{
if($announcement['allowhtml'])
{
$html_sel['yes'] = ' checked="checked"';
}
else
{
$html_sel['no'] = ' checked="checked"';
}

eval("\$allow_html = \"".$templates->get("modcp_announcements_allowhtml")."\";");
}
else
{
$allow_html = '';
}

if($announcement['allowmycode'])
{
$mycode_sel['yes'] = ' checked="checked"';
}
else
{
$mycode_sel['no'] = ' checked="checked"';
}


if($announcement['allowsmilies'])


if($announcement['allowsmilies'])

	{

	{

		$smilies_sel['yes'] = ' checked="checked"';
}
else
{
$smilies_sel['no'] = ' checked="checked"';

		$smilies_sel['yes'] = ' checked="checked"';
}
else
{
$smilies_sel['no'] = ' checked="checked"';

	}

	}


$end_type_sel = array('infinite' => '', 'finite' => '');
if(!isset($mybb->input['endtime_type']) || $mybb->input['endtime_type'] == 2)


$end_type_sel = array('infinite' => '', 'finite' => '');
if(!isset($mybb->input['endtime_type']) || $mybb->input['endtime_type'] == 2)

Zeile 1348Zeile 1412
		$announcementarray = array(
'aid' => 0,
'fid' => $announcement_fid,

		$announcementarray = array(
'aid' => 0,
'fid' => $announcement_fid,

			'uid' => $mybb->user['uid'],
'subject' => $mybb->input['title'],
'message' => $mybb->input['message'],
'allowhtml' => $mybb->get_input('allowhtml', MyBB::INPUT_INT),
'allowmycode' => $mybb->get_input('allowmycode', MyBB::INPUT_INT),
'allowsmilies' => $mybb->get_input('allowsmilies', MyBB::INPUT_INT),
'dateline' => TIME_NOW,
'userusername' => $mybb->user['username'],
);

$array = $mybb->user;
foreach($array as $key => $element)
{
$announcementarray[$key] = $element;
}

// Gather usergroup data from the cache
// Field => Array Key
$data_key = array(
'title' => 'grouptitle',
'usertitle' => 'groupusertitle',
'stars' => 'groupstars',
'starimage' => 'groupstarimage',
'image' => 'groupimage',
'namestyle' => 'namestyle',
'usereputationsystem' => 'usereputationsystem'
);

foreach($data_key as $field => $key)
{
$announcementarray[$key] = $groupscache[$announcementarray['usergroup']][$field];
}

require_once MYBB_ROOT."inc/functions_post.php";
$postbit = build_postbit($announcementarray, 3);
eval("\$preview = \"".$templates->get("previewpost")."\";");
}
else
{
$preview = '';
}

			'uid' => $mybb->user['uid'],
'subject' => $mybb->input['title'],
'message' => $mybb->input['message'],
'allowhtml' => $mybb->settings['announcementshtml'] && $mybb->get_input('allowhtml', MyBB::INPUT_INT),
'allowmycode' => $mybb->get_input('allowmycode', MyBB::INPUT_INT),
'allowsmilies' => $mybb->get_input('allowsmilies', MyBB::INPUT_INT),
'dateline' => TIME_NOW,
'userusername' => $mybb->user['username'],
);

$array = $mybb->user;
foreach($array as $key => $element)
{
$announcementarray[$key] = $element;
}

// Gather usergroup data from the cache
// Field => Array Key
$data_key = array(
'title' => 'grouptitle',
'usertitle' => 'groupusertitle',
'stars' => 'groupstars',
'starimage' => 'groupstarimage',
'image' => 'groupimage',
'namestyle' => 'namestyle',
'usereputationsystem' => 'usereputationsystem'
);

foreach($data_key as $field => $key)
{
$announcementarray[$key] = $groupscache[$announcementarray['usergroup']][$field];
}

require_once MYBB_ROOT."inc/functions_post.php";
$postbit = build_postbit($announcementarray, 3);
eval("\$preview = \"".$templates->get("previewpost")."\";");
}
else
{
$preview = '';
}


$plugins->run_hooks("modcp_new_announcement");



$plugins->run_hooks("modcp_new_announcement");


Zeile 1414Zeile 1478
	if(!$announcement)
{
error($lang->error_invalid_announcement);

	if(!$announcement)
{
error($lang->error_invalid_announcement);

	}


	}


	// Mod has permissions to edit this announcement
if(($mybb->usergroup['issupermod'] != 1 && $announcement['fid'] == -1) || ($announcement['fid'] != -1 && !is_moderator($announcement['fid'], "canmanageannouncements")) || ($unviewableforums && in_array($announcement['fid'], $unviewableforums)))
{
error_no_permission();

	// Mod has permissions to edit this announcement
if(($mybb->usergroup['issupermod'] != 1 && $announcement['fid'] == -1) || ($announcement['fid'] != -1 && !is_moderator($announcement['fid'], "canmanageannouncements")) || ($unviewableforums && in_array($announcement['fid'], $unviewableforums)))
{
error_no_permission();

	}

$errors = array();


	}

$errors = array();


	// Basic error checking
$mybb->input['title'] = $mybb->get_input('title');
if(!trim($mybb->input['title']))

	// Basic error checking
$mybb->input['title'] = $mybb->get_input('title');
if(!trim($mybb->input['title']))

Zeile 1456Zeile 1520
	if(stristr($mybb->input['endtime_time'], "pm"))
{
$enddate[0] = 12+$enddate[0];

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

		if($enddate[0] >= 24)
{
$enddate[0] = "00";

		if($enddate[0] >= 24)
{
$enddate[0] = "00";

		}

		}

	}


	}


	$mybb->input['starttime_month'] = $mybb->get_input('starttime_month');
$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'] = $mybb->get_input('starttime_month');
$months = array('01', '02', '03', '04', '05', '06', '07', '08', '09', '10', '11', '12');
if(!in_array($mybb->input['starttime_month'], $months))

Zeile 1469Zeile 1533
		$mybb->input['starttime_month'] = '01';
}


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


	$startdate = gmmktime((int)$startdate[0], (int)$startdate[1], 0, $mybb->get_input('starttime_month', MyBB::INPUT_INT), $mybb->get_input('starttime_day', MyBB::INPUT_INT), $mybb->get_input('starttime_year', MyBB::INPUT_INT));



	$localized_time_offset = (float)$mybb->user['timezone']*3600 + $mybb->user['dst']*3600;

$startdate = gmmktime((int)$startdate[0], (int)$startdate[1], 0, $mybb->get_input('starttime_month', MyBB::INPUT_INT), $mybb->get_input('starttime_day', MyBB::INPUT_INT), $mybb->get_input('starttime_year', MyBB::INPUT_INT)) - $localized_time_offset;

	if(!checkdate($mybb->get_input('starttime_month', MyBB::INPUT_INT), $mybb->get_input('starttime_day', MyBB::INPUT_INT), $mybb->get_input('starttime_year', MyBB::INPUT_INT)) || $startdate < 0 || $startdate == false)
{
$errors[] = $lang->error_invalid_start_date;

	if(!checkdate($mybb->get_input('starttime_month', MyBB::INPUT_INT), $mybb->get_input('starttime_day', MyBB::INPUT_INT), $mybb->get_input('starttime_year', MyBB::INPUT_INT)) || $startdate < 0 || $startdate == false)
{
$errors[] = $lang->error_invalid_start_date;

Zeile 1487Zeile 1553
		{
$mybb->input['endtime_month'] = '01';
}

		{
$mybb->input['endtime_month'] = '01';
}

		$enddate = gmmktime((int)$enddate[0], (int)$enddate[1], 0, $mybb->get_input('endtime_month', MyBB::INPUT_INT), $mybb->get_input('endtime_day', MyBB::INPUT_INT), $mybb->get_input('endtime_year', MyBB::INPUT_INT));

		$enddate = gmmktime((int)$enddate[0], (int)$enddate[1], 0, $mybb->get_input('endtime_month', MyBB::INPUT_INT), $mybb->get_input('endtime_day', MyBB::INPUT_INT), $mybb->get_input('endtime_year', MyBB::INPUT_INT)) - $localized_time_offset;

		if(!checkdate($mybb->get_input('endtime_month', MyBB::INPUT_INT), $mybb->get_input('endtime_day', MyBB::INPUT_INT), $mybb->get_input('endtime_year', MyBB::INPUT_INT)) || $enddate < 0 || $enddate == false)
{
$errors[] = $lang->error_invalid_end_date;

		if(!checkdate($mybb->get_input('endtime_month', MyBB::INPUT_INT), $mybb->get_input('endtime_day', MyBB::INPUT_INT), $mybb->get_input('endtime_year', MyBB::INPUT_INT)) || $enddate < 0 || $enddate == false)
{
$errors[] = $lang->error_invalid_end_date;

Zeile 1498Zeile 1564
		}
}


		}
}


	if($mybb->get_input('allowhtml', MyBB::INPUT_INT) == 1)

	if($mybb->settings['announcementshtml'] && $mybb->get_input('allowhtml', MyBB::INPUT_INT) == 1)

	{
$allowhtml = 1;
}

	{
$allowhtml = 1;
}

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


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


			log_moderator_action(array("aid" => $announcement['aid'], "subject" => $db->escape_string($mybb->input['title'])), $lang->announcement_edited);

			log_moderator_action(array("aid" => $announcement['aid'], "subject" => $mybb->input['title']), $lang->announcement_edited);


$plugins->run_hooks("modcp_do_edit_announcement_end");



$plugins->run_hooks("modcp_do_edit_announcement_end");


Zeile 1574Zeile 1640
	add_breadcrumb($lang->edit_announcement, "modcp.php?action=edit_announcements&amp;aid={$aid}");

// Get announcement

	add_breadcrumb($lang->edit_announcement, "modcp.php?action=edit_announcements&amp;aid={$aid}");

// Get announcement

	if(!isset($announcement))

	if(!isset($announcement) || $mybb->request_method != 'post')

	{
$query = $db->simple_select("announcements", "*", "aid='{$aid}'");
$announcement = $db->fetch_array($query);

	{
$query = $db->simple_select("announcements", "*", "aid='{$aid}'");
$announcement = $db->fetch_array($query);

Zeile 1601Zeile 1667
		$makeshift_end = true;
$makeshift_time = TIME_NOW;
if($announcement['startdate'])

		$makeshift_end = true;
$makeshift_time = TIME_NOW;
if($announcement['startdate'])

		{

		{

			$makeshift_time = $announcement['startdate'];
}


			$makeshift_time = $announcement['startdate'];
}


Zeile 1611Zeile 1677

// Deal with inline errors
if(!empty($errors) || isset($preview))


// Deal with inline errors
if(!empty($errors) || isset($preview))

	{

	{

		if(!empty($errors))
{
$errors = inline_error($errors);

		if(!empty($errors))
{
$errors = inline_error($errors);

Zeile 1636Zeile 1702
		$enddateyear = htmlspecialchars_uni($mybb->input['endtime_year']);
$endday = $mybb->get_input('endtime_day', MyBB::INPUT_INT);
$endtime_time = htmlspecialchars_uni($mybb->input['endtime_time']);

		$enddateyear = htmlspecialchars_uni($mybb->input['endtime_year']);
$endday = $mybb->get_input('endtime_day', MyBB::INPUT_INT);
$endtime_time = htmlspecialchars_uni($mybb->input['endtime_time']);





		$errored = true;
}
else
{

		$errored = true;
}
else
{

		// Note: dates are in GMT timezone
$starttime_time = gmdate('g:i a', $announcement['startdate']);
$endtime_time = gmdate('g:i a', $announcement['enddate']);



		$localized_time_startdate = $announcement['startdate'] + (float)$mybb->user['timezone']*3600 + $mybb->user['dst']*3600;
$localized_time_enddate = $announcement['enddate'] + (float)$mybb->user['timezone']*3600 + $mybb->user['dst']*3600;

$starttime_time = gmdate($mybb->settings['timeformat'], $localized_time_startdate);
$endtime_time = gmdate($mybb->settings['timeformat'], $localized_time_enddate);





		$startday = gmdate('j', $announcement['startdate']);
$endday = gmdate('j', $announcement['enddate']);

		$startday = gmdate('j', $localized_time_startdate);
$endday = gmdate('j', $localized_time_enddate);





		$startmonth = gmdate('m', $announcement['startdate']);
$endmonth = gmdate('m', $announcement['enddate']);

		$startmonth = gmdate('m', $localized_time_startdate);
$endmonth = gmdate('m', $localized_time_enddate);





		$startdateyear = gmdate('Y', $announcement['startdate']);
$enddateyear = gmdate('Y', $announcement['enddate']);

		$startdateyear = gmdate('Y', $localized_time_startdate);
$enddateyear = gmdate('Y', $localized_time_enddate);


$errored = false;
}


$errored = false;
}

Zeile 1702Zeile 1770
	$message = htmlspecialchars_uni($announcement['message']);

$html_sel = $mycode_sel = $smilies_sel = array('yes' => '', 'no' => '');

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

$html_sel = $mycode_sel = $smilies_sel = array('yes' => '', 'no' => '');

	if($announcement['allowhtml'])



if($mybb->settings['announcementshtml'])

	{

	{

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










		if($announcement['allowhtml'])
{
$html_sel['yes'] = ' checked="checked"';
}
else
{
$html_sel['no'] = ' checked="checked"';
}

eval("\$allow_html = \"".$templates->get("modcp_announcements_allowhtml")."\";");

	}
else
{

	}
else
{

		$html_sel['no'] = ' checked="checked"';

		$allow_html = '';

	}

if($announcement['allowmycode'])

	}

if($announcement['allowmycode'])

Zeile 1751Zeile 1829
			'uid' => $mybb->user['uid'],
'subject' => $mybb->input['title'],
'message' => $mybb->input['message'],

			'uid' => $mybb->user['uid'],
'subject' => $mybb->input['title'],
'message' => $mybb->input['message'],

			'allowhtml' => $mybb->get_input('allowhtml', MyBB::INPUT_INT),

			'allowhtml' => $mybb->settings['announcementshtml'] && $mybb->get_input('allowhtml', MyBB::INPUT_INT),

			'allowmycode' => $mybb->get_input('allowmycode', MyBB::INPUT_INT),
'allowsmilies' => $mybb->get_input('allowsmilies', MyBB::INPUT_INT),
'dateline' => TIME_NOW,

			'allowmycode' => $mybb->get_input('allowmycode', MyBB::INPUT_INT),
'allowsmilies' => $mybb->get_input('allowsmilies', MyBB::INPUT_INT),
'dateline' => TIME_NOW,

Zeile 1821Zeile 1899
			continue;
}
$announcements[$announcement['fid']][$announcement['aid']] = $announcement;

			continue;
}
$announcements[$announcement['fid']][$announcement['aid']] = $announcement;

	}


	}


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

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

Zeile 1832Zeile 1910
			foreach($global_announcements as $aid => $announcement)
{
$trow = alt_trow();

			foreach($global_announcements as $aid => $announcement)
{
$trow = alt_trow();

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

				if((isset($announcement['startdate']) && $announcement['startdate'] > TIME_NOW) || (isset($announcement['enddate']) && $announcement['enddate'] < TIME_NOW && $announcement['enddate'] != 0))

				{
eval("\$icon = \"".$templates->get("modcp_announcements_announcement_expired")."\";");
}

				{
eval("\$icon = \"".$templates->get("modcp_announcements_announcement_expired")."\";");
}

Zeile 1841Zeile 1919
					eval("\$icon = \"".$templates->get("modcp_announcements_announcement_active")."\";");
}


					eval("\$icon = \"".$templates->get("modcp_announcements_announcement_active")."\";");
}


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

				$subject = htmlspecialchars_uni($parser->parse_badwords($announcement['subject']));


eval("\$announcements_global .= \"".$templates->get("modcp_announcements_announcement_global")."\";");
}


eval("\$announcements_global .= \"".$templates->get("modcp_announcements_announcement_global")."\";");
}

Zeile 1986Zeile 2064
	{
$attachments = array_map("intval", array_keys($mybb->input['attachments']));
$query = $db->query("

	{
$attachments = array_map("intval", array_keys($mybb->input['attachments']));
$query = $db->query("

			SELECT a.pid, a.aid

			SELECT a.pid, a.aid, t.tid

			FROM  ".TABLE_PREFIX."attachments a
LEFT JOIN ".TABLE_PREFIX."posts p ON (a.pid=p.pid)
LEFT JOIN ".TABLE_PREFIX."threads t ON (t.tid=p.tid)

			FROM  ".TABLE_PREFIX."attachments a
LEFT JOIN ".TABLE_PREFIX."posts p ON (a.pid=p.pid)
LEFT JOIN ".TABLE_PREFIX."threads t ON (t.tid=p.tid)

Zeile 2002Zeile 2080
			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']}'");

 
				if(isset($attachment['tid']))
{
update_thread_counters((int)$attachment['tid'], array("attachmentcount" => "+1"));
}

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

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

 
				if(isset($attachment['tid']))
{
update_thread_counters((int)$attachment['tid'], array("attachmentcount" => "-1"));
}

			}
}

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





if($mybb->input['action'] == "modqueue")
{
$navsep = '';

if($mybb->input['action'] == "modqueue")
{
$navsep = '';





	if($mybb->usergroup['canmanagemodqueue'] == 0)
{
error_no_permission();

	if($mybb->usergroup['canmanagemodqueue'] == 0)
{
error_no_permission();

	}

	}


if($nummodqueuethreads == 0 && $nummodqueueposts == 0 && $nummodqueueattach == 0 && $mybb->usergroup['issupermod'] != 1)
{


if($nummodqueuethreads == 0 && $nummodqueueposts == 0 && $nummodqueueattach == 0 && $mybb->usergroup['issupermod'] != 1)
{

Zeile 2034Zeile 2120
	if($mybb->input['type'] == "threads" || !$mybb->input['type'] && ($nummodqueuethreads > 0 || $mybb->usergroup['issupermod'] == 1))
{
if($nummodqueuethreads == 0 && $mybb->usergroup['issupermod'] != 1)

	if($mybb->input['type'] == "threads" || !$mybb->input['type'] && ($nummodqueuethreads > 0 || $mybb->usergroup['issupermod'] == 1))
{
if($nummodqueuethreads == 0 && $mybb->usergroup['issupermod'] != 1)

		{

		{

			error($lang->you_cannot_moderate_threads);
}

			error($lang->you_cannot_moderate_threads);
}





		$forum_cache = $cache->read("forums");

		$forum_cache = $cache->read("forums");





		$query = $db->simple_select("threads", "COUNT(tid) AS unapprovedthreads", "visible='0' {$flist_queue_threads}");
$unapproved_threads = $db->fetch_field($query, "unapprovedthreads");

		$query = $db->simple_select("threads", "COUNT(tid) AS unapprovedthreads", "visible='0' {$flist_queue_threads}");
$unapproved_threads = $db->fetch_field($query, "unapprovedthreads");





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

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

Zeile 2066Zeile 2152
		if($page)
{
$start = ($page-1) * $perpage;

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

		}

		}

		else
{
$start = 0;
$page = 1;
}

		else
{
$start = 0;
$page = 1;
}





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

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





		$query = $db->query("
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

		$query = $db->query("
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

Zeile 2098Zeile 2184
			{
if($thread['threadusername'] != "")
{

			{
if($thread['threadusername'] != "")
{

 
					$thread['threadusername'] = htmlspecialchars_uni($thread['threadusername']);

					$profile_link = $thread['threadusername'];

					$profile_link = $thread['threadusername'];

				}
else
{
$profile_link = $lang->guest;
}

				}
else
{
$profile_link = $lang->guest;
}

			}
else
{

			}
else
{

 
				$thread['username'] = htmlspecialchars_uni($thread['username']);

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


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


Zeile 2121Zeile 2209
		}

if($threads)

		}

if($threads)

		{

		{

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

$plugins->run_hooks("modcp_modqueue_threads_end");

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

$plugins->run_hooks("modcp_modqueue_threads_end");

Zeile 2170Zeile 2258

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


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

		$pages = ceil($pages);

if($mybb->get_input('page') == "last")

		$pages = ceil($pages);

if($mybb->get_input('page') == "last")

		{
$page = $pages;
}

		{
$page = $pages;
}

Zeile 2200Zeile 2288
			LEFT JOIN ".TABLE_PREFIX."threads t ON (t.tid=p.tid)
LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid=p.uid)
WHERE p.visible='0' {$tflist_queue_posts} AND t.firstpost != p.pid

			LEFT JOIN ".TABLE_PREFIX."threads t ON (t.tid=p.tid)
LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid=p.uid)
WHERE p.visible='0' {$tflist_queue_posts} AND t.firstpost != p.pid

			ORDER BY p.dateline DESC

			ORDER BY p.dateline DESC, p.pid DESC

			LIMIT {$start}, {$perpage}
");
$posts = '';

			LIMIT {$start}, {$perpage}
");
$posts = '';

Zeile 2208Zeile 2296
		{
$altbg = alt_trow();
$post['threadsubject'] = htmlspecialchars_uni($parser->parse_badwords($post['threadsubject']));

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

 
			$post['subject'] = htmlspecialchars_uni($parser->parse_badwords($post['subject']));

			$post['threadlink'] = get_thread_link($post['tid']);
$post['postlink'] = get_post_link($post['pid'], $post['tid']);
$forum_link = get_forum_link($post['fid']);

			$post['threadlink'] = get_thread_link($post['tid']);
$post['postlink'] = get_post_link($post['pid'], $post['tid']);
$forum_link = get_forum_link($post['fid']);

Zeile 2218Zeile 2307
			{
if($post['postusername'] != "")
{

			{
if($post['postusername'] != "")
{

 
					$post['postusername'] = htmlspecialchars_uni($post['postusername']);

					$profile_link = $post['postusername'];
}
else

					$profile_link = $post['postusername'];
}
else

Zeile 2227Zeile 2317
			}
else
{

			}
else
{

 
				$post['username'] = htmlspecialchars_uni($post['username']);

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


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


Zeile 2340Zeile 2431

$attachdate = my_date('relative', $attachment['dateuploaded']);



$attachdate = my_date('relative', $attachment['dateuploaded']);


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

			$attachment['postsubject'] = htmlspecialchars_uni($parser->parse_badwords($attachment['postsubject']));

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

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

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

			$attachment['threadsubject'] = htmlspecialchars_uni($parser->parse_badwords($attachment['threadsubject']));

			$attachment['filesize'] = get_friendly_size($attachment['filesize']);

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

			$attachment['filesize'] = get_friendly_size($attachment['filesize']);

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

 
			$attachment['username'] = htmlspecialchars_uni($attachment['username']);

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

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

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

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

Zeile 2383Zeile 2475

// Still nothing? All queues are empty! :-D
if(!$threadqueue && !$postqueue && !$attachmentqueue)


// Still nothing? All queues are empty! :-D
if(!$threadqueue && !$postqueue && !$attachmentqueue)

	{

	{

		add_breadcrumb($lang->mcp_nav_modqueue, "modcp.php?action=modqueue");

$plugins->run_hooks("modcp_modqueue_end");

		add_breadcrumb($lang->mcp_nav_modqueue, "modcp.php?action=modqueue");

$plugins->run_hooks("modcp_modqueue_end");

Zeile 2396Zeile 2488
if($mybb->input['action'] == "do_editprofile")
{
// Verify incoming POST request

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

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

	verify_post_check($mybb->get_input('my_post_key'));


if($mybb->usergroup['caneditprofiles'] == 0)


if($mybb->usergroup['caneditprofiles'] == 0)

	{

	{

		error_no_permission();
}


		error_no_permission();
}


Zeile 2428Zeile 2520
				$mybb->input['awaymonth'] = my_date('n', $awaydate);
}
if(!$mybb->get_input('awayyear', MyBB::INPUT_INT))

				$mybb->input['awaymonth'] = my_date('n', $awaydate);
}
if(!$mybb->get_input('awayyear', MyBB::INPUT_INT))

			{

			{

				$mybb->input['awayyear'] = my_date('Y', $awaydate);
}


				$mybb->input['awayyear'] = my_date('Y', $awaydate);
}


Zeile 2442Zeile 2534
			if($return_year < my_date('Y', $awaydate) || ($returntimestamp < $awaytimestamp && $return_year == my_date('Y', $awaydate)))
{
error($lang->error_modcp_return_date_past);

			if($return_year < my_date('Y', $awaydate) || ($returntimestamp < $awaytimestamp && $return_year == my_date('Y', $awaydate)))
{
error($lang->error_modcp_return_date_past);

			}

			}


$returndate = "{$return_day}-{$return_month}-{$return_year}";
}


$returndate = "{$return_day}-{$return_month}-{$return_year}";
}

Zeile 2455Zeile 2547
			"date" => $awaydate,
"returndate" => $returndate,
"awayreason" => $mybb->get_input('awayreason')

			"date" => $awaydate,
"returndate" => $returndate,
"awayreason" => $mybb->get_input('awayreason')

		);

		);

	}
else
{

	}
else
{

Zeile 2478Zeile 2570
		"profile_fields_editable" => true,
"website" => $mybb->get_input('website'),
"icq" => $mybb->get_input('icq'),

		"profile_fields_editable" => true,
"website" => $mybb->get_input('website'),
"icq" => $mybb->get_input('icq'),

		"aim" => $mybb->get_input('aim'),
"yahoo" => $mybb->get_input('yahoo'),

 
		"skype" => $mybb->get_input('skype'),
"google" => $mybb->get_input('google'),
"signature" => $mybb->get_input('signature'),
"usernotes" => $mybb->get_input('usernotes'),
"away" => $away

		"skype" => $mybb->get_input('skype'),
"google" => $mybb->get_input('google'),
"signature" => $mybb->get_input('signature'),
"usernotes" => $mybb->get_input('usernotes'),
"away" => $away

	);


	);


	$updated_user['birthday'] = array(
"day" => $mybb->get_input('birthday_day', MyBB::INPUT_INT),
"month" => $mybb->get_input('birthday_month', MyBB::INPUT_INT),
"year" => $mybb->get_input('birthday_year', MyBB::INPUT_INT)
);

	$updated_user['birthday'] = array(
"day" => $mybb->get_input('birthday_day', MyBB::INPUT_INT),
"month" => $mybb->get_input('birthday_month', MyBB::INPUT_INT),
"year" => $mybb->get_input('birthday_year', MyBB::INPUT_INT)
);





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

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

	{

	{

		$updated_user['usertitle'] = $mybb->get_input('usertitle');

		$updated_user['usertitle'] = $mybb->get_input('usertitle');

	}

	}

	else if(!empty($mybb->input['reverttitle']))
{
$updated_user['usertitle'] = '';

	else if(!empty($mybb->input['reverttitle']))
{
$updated_user['usertitle'] = '';

	}


	}


	if(!empty($mybb->input['remove_avatar']))
{
$updated_user['avatarurl'] = '';

	if(!empty($mybb->input['remove_avatar']))
{
$updated_user['avatarurl'] = '';

Zeile 2509Zeile 2599

// Set the data of the user in the datahandler.
$userhandler->set_data($updated_user);


// Set the data of the user in the datahandler.
$userhandler->set_data($updated_user);

	$errors = '';


	$errors = array();


	// Validate the user and get any errors that might have occurred.
if(!$userhandler->validate_user())
{

	// Validate the user and get any errors that might have occurred.
if(!$userhandler->validate_user())
{

Zeile 2558Zeile 2648
		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']] = $mybb->get_input($option['time'], MyBB::INPUT_INT);

			${$option['time']} = $mybb->get_input($option['time'], MyBB::INPUT_INT);

			$mybb->input[$option['period']] = $mybb->get_input($option['period']);
if(empty($mybb->input[$option['action']]))

			$mybb->input[$option['period']] = $mybb->get_input($option['period']);
if(empty($mybb->input[$option['action']]))

			{

			{

				if($user[$option['update_field']] == 1)
{
// We're revoking the suspension

				if($user[$option['update_field']] == 1)
{
// We're revoking the suspension

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

			else
{
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";
$errors[] = $lang->$string;
}

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


if(!is_array($errors))

				else


				{
$suspend_length = fetch_time_length((int)$mybb->input[$option['time']], $mybb->input[$option['period']]);


				{
$suspend_length = fetch_time_length((int)$mybb->input[$option['time']], $mybb->input[$option['period']]);


Zeile 2597Zeile 2686
						elseif($suspend_length && $suspend_length != "-1")
{
// Temporary ban on action

						elseif($suspend_length && $suspend_length != "-1")
{
// Temporary ban on action

							$extra_user_updates[$option['update_length']] = TIME_NOW + $suspend_length;
}

							$extra_user_updates[$option['update_length']] = TIME_NOW + $suspend_length;
}

					}
elseif(!$user[$option['update_field']])
{
// New suspension for this user... bad user!
$extra_user_updates[$option['update_field']] = 1;
if($suspend_length == "-1")

					}
elseif(!$user[$option['update_field']])
{
// New suspension for this user... bad user!
$extra_user_updates[$option['update_field']] = 1;
if($suspend_length == "-1")

						{

						{

							$extra_user_updates[$option['update_length']] = 0;
}
else

							$extra_user_updates[$option['update_length']] = 0;
}
else

Zeile 2619Zeile 2708

// Those with javascript turned off will be able to select both - cheeky!
// Check to make sure we're not moderating AND suspending posting


// Those with javascript turned off will be able to select both - cheeky!
// Check to make sure we're not moderating AND suspending posting

		if(isset($extra_user_updates) && $extra_user_updates['moderateposts'] && $extra_user_updates['suspendposting'])
{

		if(isset($extra_user_updates) && !empty($extra_user_updates['moderateposts']) && !empty($extra_user_updates['suspendposting']))
{

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


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


		if(is_array($errors))

		if(is_array($errors) && !empty($errors))

		{
$mybb->input['action'] = "editprofile";

		{
$mybb->input['action'] = "editprofile";

		}

		}

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

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

Zeile 2650Zeile 2739
if($mybb->input['action'] == "editprofile")
{
if($mybb->usergroup['caneditprofiles'] == 0)

if($mybb->input['action'] == "editprofile")
{
if($mybb->usergroup['caneditprofiles'] == 0)

	{
error_no_permission();
}

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

	{
error_no_permission();
}

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


$user = get_user($mybb->get_input('uid', MyBB::INPUT_INT));
if(!$user)
{
error($lang->error_nomember);


$user = get_user($mybb->get_input('uid', MyBB::INPUT_INT));
if(!$user)
{
error($lang->error_nomember);

	}


	}


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

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

	{

	{

		error_no_permission();
}


		error_no_permission();
}


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

















	$userperms = user_permissions($user['uid']);

// Set display group
$displaygroupfields = array("title", "description", "namestyle", "usertitle", "stars", "starimage", "image");

if(!$user['displaygroup'])
{
$user['displaygroup'] = $user['usergroup'];
}

$display_group = usergroup_displaygroup($user['displaygroup']);
if(is_array($display_group))
{
$userperms = array_merge($userperms, $display_group);
}

if(!my_validate_url($user['website']))

	{

	{

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

		$user['website'] = '';

	}

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

	}

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

Zeile 2698Zeile 2803
	}

// Sanitize all input

	}

// Sanitize all input

	foreach(array('usertitle', 'website', 'icq', 'aim', 'yahoo', 'skype', 'google', 'signature', 'birthday_day', 'birthday_month', 'birthday_year') as $field)

	foreach(array('usertitle', 'website', 'icq', 'skype', 'google', 'signature', 'birthday_day', 'birthday_month', 'birthday_year') as $field)

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


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


	// 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']))

	// Custom user title
if(!empty($userperms['usertitle']))









	{

	{

		$defaulttitle = htmlspecialchars_uni($display_group['usertitle']);

		$defaulttitle = htmlspecialchars_uni($userperms['usertitle']);

	}
else

	}
else

	{

	{

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

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





		foreach($usertitles as $title)
{

		foreach($usertitles as $title)
{

			if($title['posts'] <= $mybb->user['postnum'])

			if($title['posts'] <= $user['postnum'])

			{

			{

				$defaulttitle = $title['title'];


				$defaulttitle = htmlspecialchars_uni($title['title']);
break;

			}

			}

		}
}

		}
}


$user['usertitle'] = htmlspecialchars_uni($user['usertitle']);



$user['usertitle'] = htmlspecialchars_uni($user['usertitle']);


Zeile 2743Zeile 2841
		if($mybb->input['birthday_day'] == $day)
{
$selected = "selected=\"selected\"";

		if($mybb->input['birthday_day'] == $day)
{
$selected = "selected=\"selected\"";

		}
else
{

		}
else
{

			$selected = '';
}


			$selected = '';
}


Zeile 2758Zeile 2856
		$bdaymonthsel[$month] = '';
}
$bdaymonthsel[$mybb->input['birthday_month']] = 'selected="selected"';

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

 

$awaysection = '';


if($mybb->settings['allowaway'] != 0)
{
$awaycheck = array('', '');
if($errors)


if($mybb->settings['allowaway'] != 0)
{
$awaycheck = array('', '');
if($errors)

		{
if($user['away'] == 1)
{
$awaycheck[1] = "checked=\"checked\"";
}

		{
if($user['away'] == 1)
{
$awaycheck[1] = "checked=\"checked\"";
}

			else
{
$awaycheck[0] = "checked=\"checked\"";

			else
{
$awaycheck[0] = "checked=\"checked\"";

Zeile 2786Zeile 2886
				$awaydate = my_date($mybb->settings['dateformat'], $user['awaydate']);
$awaycheck[1] = "checked=\"checked\"";
$awaynotice = $lang->sprintf($lang->away_notice_away, $awaydate);

				$awaydate = my_date($mybb->settings['dateformat'], $user['awaydate']);
$awaycheck[1] = "checked=\"checked\"";
$awaynotice = $lang->sprintf($lang->away_notice_away, $awaydate);

			}
else
{

			}
else
{

				$awaynotice = $lang->away_notice;
$awaycheck[0] = "checked=\"checked\"";
}

				$awaynotice = $lang->away_notice;
$awaycheck[0] = "checked=\"checked\"";
}

Zeile 2802Zeile 2902
				$selected = "selected=\"selected\"";
}
else

				$selected = "selected=\"selected\"";
}
else

			{

			{

				$selected = '';
}


				$selected = '';
}


Zeile 2817Zeile 2917
		if(isset($returndate[1]))
{
$returndatemonthsel[$returndate[1]] = " selected=\"selected\"";

		if(isset($returndate[1]))
{
$returndatemonthsel[$returndate[1]] = " selected=\"selected\"";

		}

		}


if(!isset($returndate[2]))
{


if(!isset($returndate[2]))
{

Zeile 2830Zeile 2930
	$plugins->run_hooks("modcp_editprofile_start");

// Fetch profile fields

	$plugins->run_hooks("modcp_editprofile_start");

// Fetch profile fields

 
	$user_fields = array();

	$query = $db->simple_select("userfields", "*", "ufid='{$user['uid']}'");

	$query = $db->simple_select("userfields", "*", "ufid='{$user['uid']}'");

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





	if($db->num_rows($query) > 0)
{
$user_fields = $db->fetch_array($query);
}


	$requiredfields = '';
$customfields = '';
$mybb->input['profile_fields'] = $mybb->get_input('profile_fields', MyBB::INPUT_ARRAY);

	$requiredfields = '';
$customfields = '';
$mybb->input['profile_fields'] = $mybb->get_input('profile_fields', MyBB::INPUT_ARRAY);

Zeile 2843Zeile 2947
	{
foreach($pfcache as $profilefield)
{

	{
foreach($pfcache as $profilefield)
{

			$userfield = $code = $select = $val = $options = $expoptions = $useropts = $seloptions = '';


			$userfield = $code = $select = $val = $options = $expoptions = $useropts = '';
$seloptions = array();

			$profilefield['type'] = htmlspecialchars_uni($profilefield['type']);
$profilefield['name'] = htmlspecialchars_uni($profilefield['name']);
$profilefield['description'] = htmlspecialchars_uni($profilefield['description']);

			$profilefield['type'] = htmlspecialchars_uni($profilefield['type']);
$profilefield['name'] = htmlspecialchars_uni($profilefield['name']);
$profilefield['description'] = htmlspecialchars_uni($profilefield['description']);

Zeile 2861Zeile 2966
					$userfield = $mybb->input['profile_fields'][$field];
}
}

					$userfield = $mybb->input['profile_fields'][$field];
}
}

			else

			elseif(isset($user_fields[$field]))

			{
$userfield = $user_fields[$field];
}

			{
$userfield = $user_fields[$field];
}

Zeile 2891Zeile 2996
						$val = str_replace("\n", "\\n", $val);

$sel = "";

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

$sel = "";

						if($val == $seloptions[$val])

						if(isset($seloptions[$val]) && $val == $seloptions[$val])

						{
$sel = " selected=\"selected\"";
}

						{
$sel = " selected=\"selected\"";
}

Zeile 2971Zeile 3076
					foreach($expoptions as $key => $val)
{
$checked = "";

					foreach($expoptions as $key => $val)
{
$checked = "";

						if($val == $seloptions[$val])

						if(isset($seloptions[$val]) && $val == $seloptions[$val])

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

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

Zeile 3013Zeile 3118
		eval("\$customfields = \"".$templates->get("usercp_profile_profilefields")."\";");
}


		eval("\$customfields = \"".$templates->get("usercp_profile_profilefields")."\";");
}


 
	$user['username'] = htmlspecialchars_uni($user['username']);

	$lang->edit_profile = $lang->sprintf($lang->edit_profile, $user['username']);
$profile_link = build_profile_link(format_name($user['username'], $user['usergroup'], $user['displaygroup']), $user['uid']);


	$lang->edit_profile = $lang->sprintf($lang->edit_profile, $user['username']);
$profile_link = build_profile_link(format_name($user['username'], $user['usergroup'], $user['displaygroup']), $user['uid']);


 
	$user['signature'] = htmlspecialchars_uni($user['signature']);

	$codebuttons = build_mycode_inserter("signature");

// Do we mark the suspend signature box?

	$codebuttons = build_mycode_inserter("signature");

// Do we mark the suspend signature box?

Zeile 3088Zeile 3195

$suspendsignature_info = $moderateposts_info = $suspendposting_info = '';
$action_options = $modpost_options = $suspost_options = '';


$suspendsignature_info = $moderateposts_info = $suspendposting_info = '';
$action_options = $modpost_options = $suspost_options = '';

 
	$modopts = array();

	foreach($moderator_options as $option)
{

	foreach($moderator_options as $option)
{

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

		${$option['time']} = $mybb->get_input($option['time'], MyBB::INPUT_INT);

		// 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 3155Zeile 3263
	}

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

	}

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

 

$user['usernotes'] = htmlspecialchars_uni($user['usernotes']);


if(!isset($newtitle))
{
$newtitle = '';
}


if(!isset($newtitle))
{
$newtitle = '';
}

 

$birthday_year = $mybb->input['birthday_year'];
$user_website = $mybb->input['website'];
$user_icq = $mybb->input['icq'];
$user_skype = $mybb->input['skype'];
$user_google = $mybb->input['google'];


$plugins->run_hooks("modcp_editprofile_end");



$plugins->run_hooks("modcp_editprofile_end");


Zeile 3257Zeile 3373
	$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)
{

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

 
		if(!empty($mybb->input[$field]))
{
$page_url .= "&amp;{$field}=".$mybb->input[$field];

		if(!empty($mybb->input[$field]))
{
$page_url .= "&amp;{$field}=".$mybb->input[$field];

Zeile 3276Zeile 3391
	while($user = $db->fetch_array($query))
{
$alt_row = alt_trow();

	while($user = $db->fetch_array($query))
{
$alt_row = alt_trow();

 
		$user['username'] = htmlspecialchars_uni($user['username']);

		$user['username'] = format_name($user['username'], $user['usergroup'], $user['displaygroup']);
$user['postnum'] = my_number_format($user['postnum']);
$regdate = my_date('relative', $user['regdate']);

		$user['username'] = format_name($user['username'], $user['usergroup'], $user['displaygroup']);
$user['postnum'] = my_number_format($user['postnum']);
$regdate = my_date('relative', $user['regdate']);

Zeile 3307Zeile 3423

$plugins->run_hooks("modcp_finduser_end");



$plugins->run_hooks("modcp_finduser_end");


 
	$username = htmlspecialchars_uni($mybb->get_input('username'));

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

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

Zeile 3447Zeile 3564
		$per_page = (int)$mybb->input['filter']['per_page'];
}
$start = ($page-1) * $per_page;

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

 
	$pages = ceil($total_warnings / $per_page);
if($page > $pages)
{
$start = 0;
$page = 1;
}

	// Build the base URL for pagination links
$url = 'modcp.php?action=warninglogs';
if(is_array($mybb->input['filter']) && count($mybb->input['filter']))

	// Build the base URL for pagination links
$url = 'modcp.php?action=warninglogs';
if(is_array($mybb->input['filter']) && count($mybb->input['filter']))

Zeile 3482Zeile 3605
	while($row = $db->fetch_array($query))
{
$trow = alt_trow();

	while($row = $db->fetch_array($query))
{
$trow = alt_trow();

 
		$row['username'] = htmlspecialchars_uni($row['username']);

		$username = format_name($row['username'], $row['usergroup'], $row['displaygroup']);
$username_link = build_profile_link($username, $row['uid']);

		$username = format_name($row['username'], $row['usergroup'], $row['displaygroup']);
$username_link = build_profile_link($username, $row['uid']);

 
		$row['mod_username'] = htmlspecialchars_uni($row['mod_username']);

		$mod_username = format_name($row['mod_username'], $row['mod_usergroup'], $row['mod_displaygroup']);
$mod_username_link = build_profile_link($mod_username, $row['mod_uid']);

		$mod_username = format_name($row['mod_username'], $row['mod_usergroup'], $row['mod_displaygroup']);
$mod_username_link = build_profile_link($mod_username, $row['mod_uid']);

		$issued_date = my_date($mybb->settings['dateformat'], $row['dateline']).' '.my_date($mybb->settings['timeformat'], $row['dateline']);

		$issued_date = my_date('normal', $row['dateline']);

		$revoked_text = '';
if($row['daterevoked'] > 0)
{

		$revoked_text = '';
if($row['daterevoked'] > 0)
{

Zeile 3495Zeile 3620
		}
if($row['expires'] > 0)
{

		}
if($row['expires'] > 0)
{

			$expire_date = my_date('relative', $row['expires'], '', 2);

			$expire_date = nice_time($row['expires']-TIME_NOW);

		}
else
{

		}
else
{

Zeile 3518Zeile 3643
	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");

	$plugins->run_hooks("modcp_warninglogs_end");

 

$filter_username = $mybb->input['filter']['username'];
$filter_modusername = $mybb->input['filter']['mod_username'];
$filter_reason = $mybb->input['filter']['reason'];


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


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

Zeile 3535Zeile 3664

add_breadcrumb($lang->mcp_nav_ipsearch, "modcp.php?action=ipsearch");



add_breadcrumb($lang->mcp_nav_ipsearch, "modcp.php?action=ipsearch");


 
	$ipsearch_results = $ipaddressvalue = '';

	$mybb->input['ipaddress'] = $mybb->get_input('ipaddress');
if($mybb->input['ipaddress'])
{
if(!is_array($groupscache))
{
$groupscache = $cache->read("usergroups");

	$mybb->input['ipaddress'] = $mybb->get_input('ipaddress');
if($mybb->input['ipaddress'])
{
if(!is_array($groupscache))
{
$groupscache = $cache->read("usergroups");

		}

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


		}

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


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

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





		$post_results = $user_results = 0;

// Searching post IP addresses
if(isset($mybb->input['search_posts']))

		$post_results = $user_results = 0;

// Searching post IP addresses
if(isset($mybb->input['search_posts']))

		{
if($ip_range)
{
if(!is_array($ip_range))
{
$post_ip_sql = "ipaddress=".$db->escape_binary($ip_range);
}
else
{
$post_ip_sql = "ipaddress BETWEEN ".$db->escape_binary($ip_range[0])." AND ".$db->escape_binary($ip_range[1]);
}
}



		{
$post_ip_sql = '';
if($ip_range)
{
if(!is_array($ip_range))
{
$post_ip_sql = "p.ipaddress=".$db->escape_binary($ip_range);
}
else
{
$post_ip_sql = "p.ipaddress BETWEEN ".$db->escape_binary($ip_range[0])." AND ".$db->escape_binary($ip_range[1]);
}
}


			$plugins->run_hooks("modcp_ipsearch_posts_start");

			$plugins->run_hooks("modcp_ipsearch_posts_start");





			if($post_ip_sql)
{

			if($post_ip_sql)
{

				$query = $db->simple_select('posts', 'COUNT(pid) AS count', "$post_ip_sql AND visible >= -1");







































































				$where_sql = '';

$unviewable_forums = get_unviewable_forums(true);

if($unviewable_forums)
{
$where_sql .= " AND p.fid NOT IN ({$unviewable_forums})";
}

if($inactiveforums)
{
$where_sql .= " AND p.fid NOT IN ({$inactiveforums})";
}

// Check group permissions if we can't view threads not started by us
$onlyusfids = array();
$group_permissions = forum_permissions();
foreach($group_permissions as $fid => $forumpermissions)
{
if(isset($forumpermissions['canonlyviewownthreads']) && $forumpermissions['canonlyviewownthreads'] == 1)
{
$onlyusfids[] = $fid;
}
}

if(!empty($onlyusfids))
{
$where_sql .= " AND ((t.fid IN(".implode(',', $onlyusfids).") AND t.uid='{$mybb->user['uid']}') OR t.fid NOT IN(".implode(',', $onlyusfids)."))";
}

// Moderators can view unapproved/deleted posts
if($mybb->usergroup['issupermod'] != 1)
{
$unapprove_forums = array();
$deleted_forums = array();
$visible_sql = " AND (p.visible = 1 AND t.visible = 1)";
$query = $db->simple_select("moderators", "fid, canviewunapprove, canviewdeleted", "(id='{$mybb->user['uid']}' AND isgroup='0') OR (id='{$mybb->user['usergroup']}' AND isgroup='1')");
while($moderator = $db->fetch_array($query))
{
if($moderator['canviewunapprove'] == 1)
{
$unapprove_forums[] = $moderator['fid'];
}

if($moderator['canviewdeleted'] == 1)
{
$deleted_forums[] = $moderator['fid'];
}
}

if(!empty($unapprove_forums))
{
$visible_sql .= " OR (p.visible = 0 AND p.fid IN(".implode(',', $unapprove_forums).")) OR (t.visible = 0 AND t.fid IN(".implode(',', $unapprove_forums)."))";
}
if(!empty($deleted_forums))
{
$visible_sql .= " OR (p.visible = -1 AND p.fid IN(".implode(',', $deleted_forums).")) OR (t.visible = -1 AND t.fid IN(".implode(',', $deleted_forums)."))";
}
}
else
{
// Super moderators (and admins)
$visible_sql = " AND p.visible >= -1";
}

$query = $db->query("
SELECT COUNT(p.pid) AS count
FROM ".TABLE_PREFIX."posts p
LEFT JOIN ".TABLE_PREFIX."threads t ON (t.tid = p.tid)
WHERE {$post_ip_sql}{$where_sql}{$visible_sql}
");

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

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

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

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

 
			$user_ip_sql = '';

			if($ip_range)
{
if(!is_array($ip_range))

			if($ip_range)
{
if(!is_array($ip_range))

Zeile 3585Zeile 3787
				else
{
$user_ip_sql = "regip BETWEEN ".$db->escape_binary($ip_range[0])." AND ".$db->escape_binary($ip_range[1])." OR lastip BETWEEN ".$db->escape_binary($ip_range[0])." AND ".$db->escape_binary($ip_range[1]);

				else
{
$user_ip_sql = "regip BETWEEN ".$db->escape_binary($ip_range[0])." AND ".$db->escape_binary($ip_range[1])." OR lastip BETWEEN ".$db->escape_binary($ip_range[0])." AND ".$db->escape_binary($ip_range[1]);

				}
}

$plugins->run_hooks("modcp_ipsearch_users_start");

				}
}

$plugins->run_hooks("modcp_ipsearch_users_start");


if($user_ip_sql)
{


if($user_ip_sql)
{

Zeile 3657Zeile 3859
		{
$query = $db->simple_select('users', 'username, uid, regip, lastip', $user_ip_sql,
array('order_by' => 'regdate', 'order_dir' => 'DESC', 'limit_start' => $start, 'limit' => $perpage));

		{
$query = $db->simple_select('users', 'username, uid, regip, lastip', $user_ip_sql,
array('order_by' => 'regdate', 'order_dir' => 'DESC', 'limit_start' => $start, 'limit' => $perpage));

			



			while($ipaddress = $db->fetch_array($query))
{
$result = false;

			while($ipaddress = $db->fetch_array($query))
{
$result = false;

 
				$ipaddress['username'] = htmlspecialchars_uni($ipaddress['username']);

				$profile_link = build_profile_link($ipaddress['username'], $ipaddress['uid']);
$trow = alt_trow();
$ip = false;
if(is_array($ip_range))

				$profile_link = build_profile_link($ipaddress['username'], $ipaddress['uid']);
$trow = alt_trow();
$ip = false;
if(is_array($ip_range))

				{

				{

					if(strcmp($ip_range[0], $ipaddress['regip']) <= 0 && strcmp($ip_range[1], $ipaddress['regip']) >= 0)
{
eval("\$subject = \"".$templates->get("modcp_ipsearch_result_regip")."\";");

					if(strcmp($ip_range[0], $ipaddress['regip']) <= 0 && strcmp($ip_range[1], $ipaddress['regip']) >= 0)
{
eval("\$subject = \"".$templates->get("modcp_ipsearch_result_regip")."\";");

Zeile 3681Zeile 3884
				{
eval("\$subject = \"".$templates->get("modcp_ipsearch_result_regip")."\";");
$ip = my_inet_ntop($db->unescape_binary($ipaddress['regip']));

				{
eval("\$subject = \"".$templates->get("modcp_ipsearch_result_regip")."\";");
$ip = my_inet_ntop($db->unescape_binary($ipaddress['regip']));

				}

				}

				elseif($ipaddress['lastip'] == $ip_range)
{
eval("\$subject = \"".$templates->get("modcp_ipsearch_result_lastip")."\";");
$ip = my_inet_ntop($db->unescape_binary($ipaddress['lastip']));
}
if($ip)

				elseif($ipaddress['lastip'] == $ip_range)
{
eval("\$subject = \"".$templates->get("modcp_ipsearch_result_lastip")."\";");
$ip = my_inet_ntop($db->unescape_binary($ipaddress['lastip']));
}
if($ip)

				{

				{

					eval("\$results .= \"".$templates->get("modcp_ipsearch_result")."\";");
$result = true;

					eval("\$results .= \"".$templates->get("modcp_ipsearch_result")."\";");
$result = true;

				}

				}

				if($result)
{
--$post_limit;
}

				if($result)
{
--$post_limit;
}

			}

			}

		}
$post_start = 0;
if($total_results > $user_results && $post_limit)

		}
$post_start = 0;
if($total_results > $user_results && $post_limit)

Zeile 3710Zeile 3913
		if(isset($mybb->input['search_posts']) && $post_results && (!isset($mybb->input['search_users']) || (isset($mybb->input['search_users']) && $post_limit > 0)))
{
$ipaddresses = $tids = $uids = array();

		if(isset($mybb->input['search_posts']) && $post_results && (!isset($mybb->input['search_users']) || (isset($mybb->input['search_users']) && $post_limit > 0)))
{
$ipaddresses = $tids = $uids = array();

			
$query = $db->simple_select('posts', 'username AS postusername, uid, subject, pid, tid, ipaddress', "$post_ip_sql AND visible >= -1",
array('order_by' => 'dateline', 'order_dir' => 'DESC', 'limit_start' => $post_start, 'limit' => $post_limit));

 




 
			$query = $db->query("
SELECT p.username AS postusername, p.uid, p.subject, p.pid, p.tid, p.ipaddress
FROM ".TABLE_PREFIX."posts p
LEFT JOIN ".TABLE_PREFIX."threads t ON (t.tid = p.tid)
WHERE {$post_ip_sql}{$where_sql}{$visible_sql}
ORDER BY p.dateline DESC, p.pid DESC
LIMIT {$post_start}, {$post_limit}
");

			while($ipaddress = $db->fetch_array($query))
{
$tids[$ipaddress['tid']] = $ipaddress['pid'];

			while($ipaddress = $db->fetch_array($query))
{
$tids[$ipaddress['tid']] = $ipaddress['pid'];

Zeile 3722Zeile 3930
			}

if(!empty($ipaddresses))

			}

if(!empty($ipaddresses))

			{

			{

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

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

Zeile 3740Zeile 3948
				foreach($ipaddresses as $ipaddress)
{
$ip = my_inet_ntop($db->unescape_binary($ipaddress['ipaddress']));

				foreach($ipaddresses as $ipaddress)
{
$ip = my_inet_ntop($db->unescape_binary($ipaddress['ipaddress']));

					if(!$ipaddress['username']) $ipaddress['username'] = $ipaddress['postusername']; // Guest username support





					if(empty($ipaddress['username']))
{
$ipaddress['username'] = $ipaddress['postusername']; // Guest username support
}
$ipaddress['username'] = htmlspecialchars_uni($ipaddress['username']);

					$trow = alt_trow();

					$trow = alt_trow();

					if(!$ipaddress['subject'])

					if(empty($ipaddress['subject']))

					{
$ipaddress['subject'] = "RE: {$ipaddress['threadsubject']}";
}

$ipaddress['postlink'] = get_post_link($ipaddress['pid'], $ipaddress['tid']);

					{
$ipaddress['subject'] = "RE: {$ipaddress['threadsubject']}";
}

$ipaddress['postlink'] = get_post_link($ipaddress['pid'], $ipaddress['tid']);

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

					$ipaddress['subject'] = htmlspecialchars_uni($parser->parse_badwords($ipaddress['subject']));

					$ipaddress['profilelink'] = build_profile_link($ipaddress['username'], $ipaddress['uid']);

					$ipaddress['profilelink'] = build_profile_link($ipaddress['username'], $ipaddress['uid']);





					eval("\$subject = \"".$templates->get("modcp_ipsearch_result_post")."\";");
eval("\$results .= \"".$templates->get("modcp_ipsearch_result")."\";");
}

					eval("\$subject = \"".$templates->get("modcp_ipsearch_result_post")."\";");
eval("\$results .= \"".$templates->get("modcp_ipsearch_result")."\";");
}

Zeile 3758Zeile 3970
		}

if(!$results)

		}

if(!$results)

		{

		{

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


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


Zeile 3790Zeile 4002
	}
$usersearchselect = $postsearchselect = '';
if(isset($mybb->input['search_posts']))

	}
$usersearchselect = $postsearchselect = '';
if(isset($mybb->input['search_posts']))

	{

	{

		$postsearchselect = "checked=\"checked\"";

		$postsearchselect = "checked=\"checked\"";

	}

	}

	if(isset($mybb->input['search_users']))
{
$usersearchselect = "checked=\"checked\"";

	if(isset($mybb->input['search_users']))
{
$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 3839Zeile 4051
		{
$ipaddress_host_name = $lang->na;
}

		{
$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', 1, 0)."\";");
echo($iplookup);
exit;
}

	eval("\$iplookup = \"".$templates->get('modcp_ipsearch_misc_info', 1, 0)."\";");
echo($iplookup);
exit;
}





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

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

{
if($mybb->usergroup['canbanusers'] == 0)
{
error_no_permission();
}

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

{
if($mybb->usergroup['canbanusers'] == 0)
{
error_no_permission();
}

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


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


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

Zeile 3914Zeile 4126
	$bannedusers = '';
while($banned = $db->fetch_array($query))
{

	$bannedusers = '';
while($banned = $db->fetch_array($query))
{

 
		$banned['username'] = htmlspecialchars_uni($banned['username']);

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

// Only show the edit & lift links if current user created ban, or is super mod/admin

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

// Only show the edit & lift links if current user created ban, or is super mod/admin

Zeile 3923Zeile 4136
			eval("\$edit_link = \"".$templates->get("modcp_banning_edit")."\";");
}


			eval("\$edit_link = \"".$templates->get("modcp_banning_edit")."\";");
}


		$admin_profile = build_profile_link($banned['adminuser'], $banned['admin']);

		$admin_profile = build_profile_link(htmlspecialchars_uni($banned['adminuser']), $banned['admin']);


$trow = alt_trow();



$trow = alt_trow();


Zeile 3948Zeile 4161

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



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


			if($remaining < 3600)




			$banned_class = '';
$ban_remaining = "{$timeremaining} {$lang->ban_remaining}";

if($remaining <= 0)

			{

			{

				$timeremaining = "<span style=\"color: red;\">({$timeremaining} {$lang->ban_remaining})</span>";
}
else if($remaining < 86400)


				$banned_class = "imminent_banned";
$ban_remaining = $lang->ban_ending_imminently;
}
if($remaining < 3600)

			{

			{

				$timeremaining = "<span style=\"color: maroon;\">({$timeremaining} {$lang->ban_remaining})</span>";
}
else if($remaining < 604800)

				$banned_class = "high_banned";
}
else if($remaining < 86400)

			{

			{

				$timeremaining = "<span style=\"color: green;\">({$timeremaining} {$lang->ban_remaining})</span>";
}





				$banned_class = "moderate_banned";
}
else if($remaining < 604800)
{
$banned_class = "low_banned";
}

			else
{

			else
{

				$timeremaining = "({$timeremaining} {$lang->ban_remaining})";

				$banned_class = "normal_banned";

			}

			}

 

eval('$timeremaining = "'.$templates->get('modcp_banning_remaining').'";');

		}

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

		}

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

Zeile 4011Zeile 4234

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


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

		'additionalgroups' => $ban['oldadditionalgroups'],

		'additionalgroups' => $db->escape_string($ban['oldadditionalgroups']),

		'displaygroup' => $ban['olddisplaygroup']
);
$db->update_query("users", $updated_group, "uid='{$ban['uid']}'");
$db->delete_query("banned", "uid='{$ban['uid']}'");


		'displaygroup' => $ban['olddisplaygroup']
);
$db->update_query("users", $updated_group, "uid='{$ban['uid']}'");
$db->delete_query("banned", "uid='{$ban['uid']}'");


	$cache->update_banned();

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


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


Zeile 4037Zeile 4259
	}

// Editing an existing ban

	}

// Editing an existing ban

 
	$existing_ban = false;

	if($mybb->get_input('uid', MyBB::INPUT_INT))
{
// Get the users info from their uid

	if($mybb->get_input('uid', MyBB::INPUT_INT))
{
// Get the users info from their uid

Zeile 4048Zeile 4271
		");
$user = $db->fetch_array($query);


		");
$user = $db->fetch_array($query);


		$existing_ban = false;
if($user['uid'])

		if($user)


		{
$existing_ban = true;
}

		{
$existing_ban = true;
}

Zeile 4060Zeile 4282
			error_no_permission();
}
}

			error_no_permission();
}
}

 

$errors = array();


// Creating a new ban
if(!$existing_ban)


// Creating a new ban
if(!$existing_ban)

Zeile 4071Zeile 4295

$user = get_user_by_username($mybb->input['username'], $options);



$user = get_user_by_username($mybb->input['username'], $options);


		if(!$user['uid'])

		if(!$user)

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

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

Zeile 4096Zeile 4320

// Check banned group
$usergroups_cache = $cache->read('usergroups');


// Check banned group
$usergroups_cache = $cache->read('usergroups');

	$usergroup = $usergroups_cache[$mybb->get_input('usergroup', MyBB::INPUT_INT)];
$query = $db->simple_select("usergroups", "gid", "isbannedgroup=1 AND gid='".$mybb->get_input('usergroup', MyBB::INPUT_INT)."'");



	if(isset($usergroups_cache[$mybb->get_input('usergroup', MyBB::INPUT_INT)]))
{
$usergroup = $usergroups_cache[$mybb->get_input('usergroup', MyBB::INPUT_INT)];
}





	if(empty($usergroup['gid']) || empty($usergroup['isbannedgroup']))

	if(!isset($usergroup) || empty($usergroup['isbannedgroup']))

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

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

Zeile 4107Zeile 4333
	// If this is a new ban, we check the user isn't already part of a banned group
if(!$existing_ban && $user['uid'])
{

	// If this is a new ban, we check the user isn't already part of a banned group
if(!$existing_ban && $user['uid'])
{

		$query = $db->simple_select("banned", "uid", "uid='{$user['uid']}'");
if($db->fetch_field($query, "uid"))

		$query = $db->simple_select("banned", "uid", "uid='{$user['uid']}'", array('limit' => 1));
if($db->num_rows($query) > 0)

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

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

Zeile 4153Zeile 4379
				'uid' => $user['uid'],
'gid' => $mybb->get_input('usergroup', MyBB::INPUT_INT),
'oldgroup' => (int)$user['usergroup'],

				'uid' => $user['uid'],
'gid' => $mybb->get_input('usergroup', MyBB::INPUT_INT),
'oldgroup' => (int)$user['usergroup'],

				'oldadditionalgroups' => (string)$user['additionalgroups'],

				'oldadditionalgroups' => $db->escape_string($user['additionalgroups']),

				'olddisplaygroup' => (int)$user['displaygroup'],
'admin' => (int)$mybb->user['uid'],
'dateline' => TIME_NOW,

				'olddisplaygroup' => (int)$user['displaygroup'],
'admin' => (int)$mybb->user['uid'],
'dateline' => TIME_NOW,

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

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


$cache->update_banned();

 

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


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

		}
else

		}
else

		{
log_moderator_action(array("uid" => $user['uid'], "username" => $user['username']), $lang->banned_user);

		{
log_moderator_action(array("uid" => $user['uid'], "username" => $user['username']), $lang->banned_user);

		}

$plugins->run_hooks("modcp_do_banuser_end");


		}

$plugins->run_hooks("modcp_do_banuser_end");


		if($existing_ban)
{
redirect("modcp.php?action=banning", $lang->redirect_banuser_updated);

		if($existing_ban)
{
redirect("modcp.php?action=banning", $lang->redirect_banuser_updated);

Zeile 4197Zeile 4421
		}
}
// Otherwise has errors, throw back to ban page

		}
}
// Otherwise has errors, throw back to ban page

	else

	else

	{
$mybb->input['action'] = "banuser";
}

	{
$mybb->input['action'] = "banuser";
}

Zeile 4208Zeile 4432
	add_breadcrumb($lang->mcp_nav_banning, "modcp.php?action=banning");

if($mybb->usergroup['canbanusers'] == 0)

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

if($mybb->usergroup['canbanusers'] == 0)

	{

	{

		error_no_permission();
}

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

		error_no_permission();
}

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

	{
add_breadcrumb($lang->mcp_nav_ban_user);

	{
add_breadcrumb($lang->mcp_nav_editing_ban);

	}
else
{

	}
else
{

		add_breadcrumb($lang->mcp_nav_editing_ban);

		add_breadcrumb($lang->mcp_nav_ban_user);

	}

$plugins->run_hooks("modcp_banuser_start");

	}

$plugins->run_hooks("modcp_banuser_start");

Zeile 4237Zeile 4461
			WHERE b.uid='{$mybb->input['uid']}'
");
$banned = $db->fetch_array($query);

			WHERE b.uid='{$mybb->input['uid']}'
");
$banned = $db->fetch_array($query);

		if($banned['username'])

		if(!empty($banned['username']))

		{

		{

			$username = htmlspecialchars_uni($banned['username']);

			$username = $banned['username'] = htmlspecialchars_uni($banned['username']);

			$banreason = htmlspecialchars_uni($banned['reason']);
$uid = $mybb->input['uid'];
$user = get_user($banned['uid']);

			$banreason = htmlspecialchars_uni($banned['reason']);
$uid = $mybb->input['uid'];
$user = get_user($banned['uid']);

Zeile 4249Zeile 4473
	}

// Permission to edit this ban?

	}

// Permission to edit this ban?

	if($banned['uid'] && $mybb->user['uid'] != $banned['admin'] && $mybb->usergroup['issupermod'] != 1 && $mybb->usergroup['cancp'] != 1)

	if(!empty($banned) && $banned['uid'] && $mybb->user['uid'] != $banned['admin'] && $mybb->usergroup['issupermod'] != 1 && $mybb->usergroup['cancp'] != 1)

	{
error_no_permission();
}

	{
error_no_permission();
}

Zeile 4260Zeile 4484
		if($mybb->input['uid'])
{
$user = get_user($mybb->input['uid']);

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

 
			$user['username'] = htmlspecialchars_uni($user['username']);

			$username = $user['username'];
}
else

			$username = $user['username'];
}
else

Zeile 4300Zeile 4525
				$dateline = $banned['dateline'];
}


				$dateline = $banned['dateline'];
}


			$thatime = my_date("D, jS M Y @ g:ia", ban_date2timestamp($time, $dateline));

			$thatime = my_date("D, jS M Y @ {$mybb->settings['timeformat']}", ban_date2timestamp($time, $dateline));

			$thattime = " ({$thatime})";
}


			$thattime = " ({$thatime})";
}


Zeile 4314Zeile 4539
	foreach($groupscache as $key => $group)
{
if($group['isbannedgroup'])

	foreach($groupscache as $key => $group)
{
if($group['isbannedgroup'])

		{

		{

			$selected = "";
if(isset($banned['gid']) && $banned['gid'] == $group['gid'])
{

			$selected = "";
if(isset($banned['gid']) && $banned['gid'] == $group['gid'])
{

Zeile 4339Zeile 4564
	else
{
eval("\$bangroups = \"".$templates->get("modcp_banuser_bangroups_hidden")."\";");

	else
{
eval("\$bangroups = \"".$templates->get("modcp_banuser_bangroups_hidden")."\";");

	}


	}


	if(!empty($banned['uid']))
{
eval("\$lift_link = \"".$templates->get("modcp_banuser_lift")."\";");

	if(!empty($banned['uid']))
{
eval("\$lift_link = \"".$templates->get("modcp_banuser_lift")."\";");

Zeile 4375Zeile 4600

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


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





if(!$mybb->input['action'])
{
$awaitingattachments = $awaitingposts = $awaitingthreads = $awaitingmoderation = '';

if(!$mybb->input['action'])
{
$awaitingattachments = $awaitingposts = $awaitingthreads = $awaitingmoderation = '';

Zeile 4383Zeile 4608
	if($mybb->usergroup['canmanagemodqueue'] == 1)
{
if($mybb->settings['enableattachments'] == 1 && ($nummodqueueattach > 0 || $mybb->usergroup['issupermod'] == 1))

	if($mybb->usergroup['canmanagemodqueue'] == 1)
{
if($mybb->settings['enableattachments'] == 1 && ($nummodqueueattach > 0 || $mybb->usergroup['issupermod'] == 1))

		{

		{

			if($nummodqueueposts > 0 || $mybb->usergroup['issupermod'] == 1)
{
$bgcolor = "trow1";

			if($nummodqueueposts > 0 || $mybb->usergroup['issupermod'] == 1)
{
$bgcolor = "trow1";

Zeile 4415Zeile 4640
				");
$attachment = $db->fetch_array($query);
$attachment['date'] = my_date('relative', $attachment['dateuploaded']);

				");
$attachment = $db->fetch_array($query);
$attachment['date'] = my_date('relative', $attachment['dateuploaded']);

 
				$attachment['username'] = htmlspecialchars_uni($attachment['username']);

				$attachment['profilelink'] = build_profile_link($attachment['username'], $attachment['uid']);
$attachment['link'] = get_post_link($attachment['pid'], $attachment['tid']);
$attachment['filename'] = htmlspecialchars_uni($attachment['filename']);

				$attachment['profilelink'] = build_profile_link($attachment['username'], $attachment['uid']);
$attachment['link'] = get_post_link($attachment['pid'], $attachment['tid']);
$attachment['filename'] = htmlspecialchars_uni($attachment['filename']);

Zeile 4447Zeile 4673
					FROM  ".TABLE_PREFIX."posts p
LEFT JOIN ".TABLE_PREFIX."threads t ON (t.tid=p.tid)
WHERE p.visible='0' {$tflist} AND t.firstpost != p.pid

					FROM  ".TABLE_PREFIX."posts p
LEFT JOIN ".TABLE_PREFIX."threads t ON (t.tid=p.tid)
WHERE p.visible='0' {$tflist} AND t.firstpost != p.pid

					ORDER BY p.dateline DESC

					ORDER BY p.dateline DESC, p.pid DESC

					LIMIT 1
");
$post = $db->fetch_array($query);
$post['date'] = my_date('relative', $post['dateline']);

					LIMIT 1
");
$post = $db->fetch_array($query);
$post['date'] = my_date('relative', $post['dateline']);

 
				$post['username'] = htmlspecialchars_uni($post['username']);

				$post['profilelink'] = build_profile_link($post['username'], $post['uid']);
$post['link'] = get_post_link($post['pid'], $post['tid']);
$post['subject'] = $post['fullsubject'] = $parser->parse_badwords($post['subject']);

				$post['profilelink'] = build_profile_link($post['username'], $post['uid']);
$post['link'] = get_post_link($post['pid'], $post['tid']);
$post['subject'] = $post['fullsubject'] = $parser->parse_badwords($post['subject']);

Zeile 4483Zeile 4710
				$query = $db->simple_select("threads", "tid, subject, uid, username, dateline", "visible='0' {$flist_queue_threads}", array('order_by' =>  'dateline', 'order_dir' => 'DESC', 'limit' => 1));
$thread = $db->fetch_array($query);
$thread['date'] = my_date('relative', $thread['dateline']);

				$query = $db->simple_select("threads", "tid, subject, uid, username, dateline", "visible='0' {$flist_queue_threads}", array('order_by' =>  'dateline', 'order_dir' => 'DESC', 'limit' => 1));
$thread = $db->fetch_array($query);
$thread['date'] = my_date('relative', $thread['dateline']);

 
				$thread['username'] = htmlspecialchars_uni($thread['username']);

				$thread['profilelink'] = build_profile_link($thread['username'], $thread['uid']);
$thread['link'] = get_thread_link($thread['tid']);
$thread['subject'] = $thread['fullsubject'] = $parser->parse_badwords($thread['subject']);

				$thread['profilelink'] = build_profile_link($thread['username'], $thread['uid']);
$thread['link'] = get_thread_link($thread['tid']);
$thread['subject'] = $thread['fullsubject'] = $parser->parse_badwords($thread['subject']);

Zeile 4516Zeile 4744
		$where = '';
if($tflist_modlog)
{

		$where = '';
if($tflist_modlog)
{

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

			$where = "WHERE (t.fid <> 0 {$tflist_modlog}) OR (l.fid <> 0)";

		}

$query = $db->query("

		}

$query = $db->query("

Zeile 4538Zeile 4766
			$logitem['action'] = htmlspecialchars_uni($logitem['action']);
$log_date = my_date('relative', $logitem['dateline']);
$trow = alt_trow();

			$logitem['action'] = htmlspecialchars_uni($logitem['action']);
$log_date = my_date('relative', $logitem['dateline']);
$trow = alt_trow();

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

			$username = format_name($logitem['username'], $logitem['usergroup'], $logitem['displaygroup']);
$logitem['profilelink'] = build_profile_link($username, $logitem['uid']);
$logitem['ipaddress'] = my_inet_ntop($db->unescape_binary($logitem['ipaddress']));

if($logitem['tsubject'])
{

			$username = format_name($logitem['username'], $logitem['usergroup'], $logitem['displaygroup']);
$logitem['profilelink'] = build_profile_link($username, $logitem['uid']);
$logitem['ipaddress'] = my_inet_ntop($db->unescape_binary($logitem['ipaddress']));

if($logitem['tsubject'])
{

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

				$logitem['tsubject'] = htmlspecialchars_uni($parser->parse_badwords($logitem['tsubject']));

				$logitem['thread'] = get_thread_link($logitem['tid']);
eval("\$information .= \"".$templates->get("modcp_modlogs_result_thread")."\";");
}

				$logitem['thread'] = get_thread_link($logitem['tid']);
eval("\$information .= \"".$templates->get("modcp_modlogs_result_thread")."\";");
}

Zeile 4555Zeile 4784
			}
if($logitem['psubject'])
{

			}
if($logitem['psubject'])
{

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

				$logitem['psubject'] = htmlspecialchars_uni($parser->parse_badwords($logitem['psubject']));

				$logitem['post'] = get_post_link($logitem['pid']);
eval("\$information .= \"".$templates->get("modcp_modlogs_result_post")."\";");
}

				$logitem['post'] = get_post_link($logitem['pid']);
eval("\$information .= \"".$templates->get("modcp_modlogs_result_post")."\";");
}

Zeile 4564Zeile 4793
			if(!$logitem['tsubject'] || !$logitem['fname'] || !$logitem['psubject'])
{
$data = my_unserialize($logitem['data']);

			if(!$logitem['tsubject'] || !$logitem['fname'] || !$logitem['psubject'])
{
$data = my_unserialize($logitem['data']);

				if($data['uid'])

				if(isset($data['uid']))

				{
$information = $lang->sprintf($lang->edited_user_info, htmlspecialchars_uni($data['username']), get_profile_link($data['uid']));
}

				{
$information = $lang->sprintf($lang->edited_user_info, htmlspecialchars_uni($data['username']), get_profile_link($data['uid']));
}

				if($data['aid'])

				if(isset($data['aid']))

				{

				{

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

					$data['subject'] = htmlspecialchars_uni($parser->parse_badwords($data['subject']));

					$data['announcement'] = get_announcement_link($data['aid']);
eval("\$information .= \"".$templates->get("modcp_modlogs_result_announcement")."\";");
}
}

					$data['announcement'] = get_announcement_link($data['aid']);
eval("\$information .= \"".$templates->get("modcp_modlogs_result_announcement")."\";");
}
}

 

$plugins->run_hooks("modcp_modlogs_result");


eval("\$modlogresults .= \"".$templates->get("modcp_modlogs_result")."\";");
}


eval("\$modlogresults .= \"".$templates->get("modcp_modlogs_result")."\";");
}

Zeile 4610Zeile 4841
	$bannedusers = '';
foreach($banned_cache as $banned)
{

	$bannedusers = '';
foreach($banned_cache as $banned)
{

 
		$banned['username'] = htmlspecialchars_uni($banned['username']);

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

// Only show the edit & lift links if current user created ban, or is super mod/admin

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

// Only show the edit & lift links if current user created ban, or is super mod/admin

Zeile 4619Zeile 4851
			eval("\$edit_link = \"".$templates->get("modcp_banning_edit")."\";");
}


			eval("\$edit_link = \"".$templates->get("modcp_banning_edit")."\";");
}


		$admin_profile = build_profile_link($banned['adminuser'], $banned['admin']);

		$admin_profile = build_profile_link(htmlspecialchars_uni($banned['adminuser']), $banned['admin']);


$trow = alt_trow();



$trow = alt_trow();


Zeile 4643Zeile 4875
			$remaining = $banned['remaining'];

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

			$remaining = $banned['remaining'];

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

 

$banned_class = '';
$ban_remaining = "{$timeremaining} {$lang->ban_remaining}";


if($remaining <= 0)
{


if($remaining <= 0)
{

				$timeremaining = "<span style=\"color: red;\">({$lang->ban_ending_imminently})</span>";


				$banned_class = "imminent_banned";
$ban_remaining = $lang->ban_ending_imminently;

			}
else if($remaining < 3600)
{

			}
else if($remaining < 3600)
{

				$timeremaining = "<span style=\"color: red;\">({$timeremaining} {$lang->ban_remaining})</span>";

				$banned_class = "high_banned";

			}
else if($remaining < 86400)
{

			}
else if($remaining < 86400)
{

				$timeremaining = "<span style=\"color: maroon;\">({$timeremaining} {$lang->ban_remaining})</span>";

				$banned_class = "moderate_banned";

			}
else if($remaining < 604800)
{

			}
else if($remaining < 604800)
{

				$timeremaining = "<span style=\"color: green;\">({$timeremaining} {$lang->ban_remaining})</span>";

				$banned_class = "low_banned";

			}
else
{

			}
else
{

				$timeremaining = "({$timeremaining} {$lang->ban_remaining})";

				$banned_class = "normal_banned";

			}

			}

 

eval('$timeremaining = "'.$templates->get('modcp_banning_remaining').'";');

		}

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

		}

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

	}

	}


if(!$bannedusers)


if(!$bannedusers)

	{

	{

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

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

	}

	}





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





	$modnotes = '';
$modnotes_cache = $cache->read("modnotes");
if($modnotes_cache !== false)
{
$modnotes = htmlspecialchars_uni($modnotes_cache['modmessage']);
}


$plugins->run_hooks("modcp_end");



$plugins->run_hooks("modcp_end");