Vergleich inc/functions_modcp.php - 1.8.0 - 1.8.14

 * @param int The user ID to perform the action on.

 * @param int $uid The user ID to perform the action on.

 * @param int (Optional) The parent forum ID
 * @param int (Optional) The depth from parent forum the moderator can manage to

 * @param int $pid (Optional) The parent forum ID
 * @param int $depth (Optional) The depth from parent forum the moderator can manage to

	global $mybb, $db, $lang, $theme, $announcements, $templates, $announcements_forum, $moderated_forums, $unviewableforums;

	global $mybb, $db, $lang, $theme, $announcements, $templates, $announcements_forum, $moderated_forums, $unviewableforums, $parser;

			if($forum['linkto'] || ($unviewableforums && in_array($forum['fid'], $unviewableforums)))

			if($forum['linkto'] || (is_array($unviewableforums) && in_array($forum['fid'], $unviewableforums)))

				if(in_array($forum['fid'], $parent_forums))

				if(is_array($parent_forums) && in_array($forum['fid'], $parent_forums))

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

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

 * @param array Array of reported content
 * @return bool True if PM sent

 * @param array $report Array of reported content
 * @param string $report_type Type of content being reported
 * @return bool|array PM Information or false

function send_report($report)

function send_report($report, $report_type='post')

	global $db, $lang, $forum, $mybb, $post, $thread;

	global $db, $lang, $forum, $mybb, $post, $thread, $reputation, $user, $plugins;

	$query = $db->query("
		SELECT DISTINCT u.username, u.email, u.receivepms, u.uid
		FROM ".TABLE_PREFIX."moderators m
		LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid=m.id)
		WHERE m.fid IN (".$forum['parentlist'].") AND m.isgroup = '0'
	");

	$nummods = $db->num_rows($query);

	if(!$nummods)

	$report_reason = '';
	if($report['reasonid'])

		unset($query);
		switch($db->type)
		{
			case "pgsql":
			case "sqlite":
				$query = $db->query("
					SELECT u.username, u.email, u.receivepms, u.uid
					FROM ".TABLE_PREFIX."users u
					LEFT JOIN ".TABLE_PREFIX."usergroups g ON (((','|| u.additionalgroups|| ',' LIKE '%,'|| g.gid|| ',%') OR u.usergroup = g.gid))
					WHERE (g.cancp=1 OR g.issupermod=1)
				");
				break;
			default:
				$query = $db->query("
					SELECT u.username, u.email, u.receivepms, u.uid
					FROM ".TABLE_PREFIX."users u
					LEFT JOIN ".TABLE_PREFIX."usergroups g ON (((CONCAT(',', u.additionalgroups, ',') LIKE CONCAT('%,', g.gid, ',%')) OR u.usergroup = g.gid))
					WHERE (g.cancp=1 OR g.issupermod=1)
				");
		}
	}

		$query = $db->simple_select("reportreasons", "title", "rid = '".(int)$report['reasonid']."'", array('limit' => 1));
		$reason = $db->fetch_array($query);

		$lang->load('report');

		$report_reason = $lang->parse($reason['title']);
	}

	if($report['reason'])
	{
		$report_reason = $lang->sprintf($lang->email_report_comment_extra, $report_reason, $report['reason']);
	}

	$modsjoin = $modswhere = '';
	if(!empty($forum['parentlist']))
	{
		$modswhere = "m.fid IN ({$forum['parentlist']}) OR ";

		if($db->type == 'pgsql' || $db->type == 'sqlite')
		{
			$modsjoin = "LEFT JOIN {$db->table_prefix}moderators m ON (m.id = u.uid AND m.isgroup = 0) OR ((m.id = u.usergroup OR ',' || u.additionalgroups || ',' LIKE '%,' || m.id || ',%') AND m.isgroup = 1)";
		}
		else
		{
			$modsjoin = "LEFT JOIN {$db->table_prefix}moderators m ON (m.id = u.uid AND m.isgroup = 0) OR ((m.id = u.usergroup OR CONCAT(',', u.additionalgroups, ',') LIKE CONCAT('%,', m.id, ',%')) AND m.isgroup = 1)";
		}
	}

	switch($db->type)
	{
		case "pgsql":
		case "sqlite":
			$query = $db->query("
				SELECT DISTINCT u.username, u.email, u.receivepms, u.uid
				FROM {$db->table_prefix}users u
				{$modsjoin}
				LEFT JOIN {$db->table_prefix}usergroups g ON (',' || u.additionalgroups || ',' LIKE '%,' || g.gid || ',%' OR g.gid = u.usergroup)
				WHERE {$modswhere}g.cancp = 1 OR g.issupermod = 1
			");
			break;
		default:
			$query = $db->query("
				SELECT DISTINCT u.username, u.email, u.receivepms, u.uid
				FROM {$db->table_prefix}users u
				{$modsjoin}
				LEFT JOIN {$db->table_prefix}usergroups g ON (CONCAT(',', u.additionalgroups, ',') LIKE CONCAT('%,', g.gid, ',%') OR g.gid = u.usergroup)
				WHERE {$modswhere}g.cancp = 1 OR g.issupermod = 1
			");
	}

	$lang_string_subject = "emailsubject_report{$report_type}";
	$lang_string_message = "email_report{$report_type}";

	if(empty($lang->$lang_string_subject) || empty($lang->$lang_string_message))
	{
		return false;
	}

	global $send_report_subject, $send_report_url;

	switch($report_type)
	{
		case 'post':
			$send_report_subject = $post['subject'];
			$send_report_url = str_replace('&', '&', get_post_link($post['pid'], $thread['tid'])."#pid".$post['pid']);
			break;
		case 'profile':
			$send_report_subject = $user['username'];
			$send_report_url = str_replace('&', '&', get_profile_link($user['uid']));
			break;
		case 'reputation':
			$from_user = get_user($reputation['adduid']);
			$send_report_subject = $from_user['username'];
			$send_report_url = "reputation.php?uid={$reputation['uid']}#rid{$reputation['rid']}";
			break;
	}

	$plugins->run_hooks("send_report_report_type");

	$emailsubject = $lang->sprintf($lang->$lang_string_subject, $mybb->settings['bbname']);
	$emailmessage = $lang->sprintf($lang->$lang_string_message, $mybb->user['username'], $mybb->settings['bbname'], $send_report_subject, $mybb->settings['bburl'], $send_report_url, $report_reason);

	{
		$emailsubject = $lang->sprintf($lang->emailsubject_reportpost, $mybb->settings['bbname']);
		$emailmessage = $lang->sprintf($lang->email_reportpost, $mybb->user['username'], $mybb->settings['bbname'], $post['subject'], $mybb->settings['bburl'], str_replace('&', '&', get_post_link($post['pid'], $thread['tid'])."#pid".$post['pid']), $thread['subject'], $report['reason']);

	{

		{

		{

			"ipaddress" => $session->packedip

			"ipaddress" => $mybb->session->packedip

 * @param array Array of reported content
 * @param string Type of content being reported

 * @param array $report Array of reported content
 * @param string $type Type of content being reported

		'reporters' => $db->escape_string(serialize(array($report['uid'])))

		'reporters' => $db->escape_string(my_serialize(array($report['uid'])))

		return send_report($report);

		send_report($report, $type);

 * @param array Array of reported content
 * @return bool

 * @param array $report Array of reported content
 * @return bool true

		'reporters' => $db->escape_string(serialize($report['reporters']))

		'reporters' => $db->escape_string(my_serialize($report['reporters']))