Vergleich forumdisplay.php - 1.6.2 - 1.6.5

 * $Id: forumdisplay.php 5016 2010-06-12 00:24:02Z RyanGordon $

 * $Id: forumdisplay.php 5627 2011-10-06 07:52:01Z Tomm $

$templatelist .= ",forumdisplay_usersbrowsing_guests,forumdisplay_usersbrowsing_user,forumdisplay_usersbrowsing,forumdisplay_inlinemoderation,forumdisplay_thread_modbit,forumdisplay_inlinemoderation_col";

$templatelist .= ",forumdisplay_usersbrowsing_guests,forumdisplay_usersbrowsing_user,forumdisplay_usersbrowsing,forumdisplay_inlinemoderation,forumdisplay_thread_modbit,forumdisplay_inlinemoderation_col,forumdisplay_inlinemoderation_selectall";

	// Build a forum cache.
	$query = $db->query("
		SELECT *
		FROM ".TABLE_PREFIX."forums
		WHERE active != 0
		ORDER BY pid, disporder
	");
	

	// Cookie'd forum read time

	if(!is_array($forumsread))
	{
		$forumsread = array();
	}

	$query = $db->simple_select("forums", "*", "active != 0", array("order_by" => "pid, disporder"));

	// Build a forum cache.

	// Build a forum cache from the database

	if($mybb->user['uid'] == 0)

	if($mybb->user['uid'] == 0 && $forumsread[$forum['fid']])

		if($forumsread[$forum['fid']])
		{
			$forum['lastread'] = $forumsread[$forum['fid']];
		}

		$forum['lastread'] = $forumsread[$forum['fid']];

}

}

	if($datecut > 0 && $datecut != 9999)

	if($datecut > 0)

$limit = '';
$announcements = '';
if($mybb->settings['announcementlimit'])
{
	$limit = "LIMIT 0, ".$mybb->settings['announcementlimit'];
}

$sql = build_parent_list($fid, "fid", "OR", $parentlist);
$time = TIME_NOW;
$query = $db->query("
	SELECT a.*, u.username
	FROM ".TABLE_PREFIX."announcements a
	LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid=a.uid)
	WHERE a.startdate<='$time' AND (a.enddate>='$time' OR a.enddate='0') AND ($sql OR fid='-1')
	ORDER BY a.startdate DESC $limit
");
$bgcolor = alt_trow(true); // Reset the trow colors
while($announcement = $db->fetch_array($query))
{
	if($announcement['startdate'] > $mybb->user['lastvisit'])
	{
		$new_class = ' class="subject_new"';
		$folder = "newfolder";
	}
	else
	{
		$new_class = ' class="subject_old"';
		$folder = "folder";
	}

	$announcement['announcementlink'] = get_announcement_link($announcement['aid']);
	$announcement['subject'] = $parser->parse_badwords($announcement['subject']);
	$announcement['subject'] = htmlspecialchars_uni($announcement['subject']);
	$postdate = my_date($mybb->settings['dateformat'], $announcement['startdate']);
	$posttime = my_date($mybb->settings['timeformat'], $announcement['startdate']);
	$announcement['profilelink'] = build_profile_link($announcement['username'], $announcement['uid']);
	
	if($foruminfo['allowtratings'] != 0 && $fpermissions['canviewthreads'] != 0)
	{
		eval("\$rating = \"".$templates->get("forumdisplay_announcement_rating")."\";");
		$lpbackground = "trow2";
	}
	else
	{
		$rating = '';
		$lpbackground = "trow1";
	}
	
	if($ismod)

$forum_stats = $cache->read("forumsdisplay");

if(!is_array($forum_stats))
{
	$forum_stats = $cache->read("forumdisplay", true);

	if(is_array($forum_stats) && ($forum_stats[-1]['announcements'] || $forum_stats[$fid]['announcements']))

		eval("\$modann = \"".$templates->get("forumdisplay_announcements_announcement_modbit")."\";");
	}
	else
	{
		$modann = '';
	}
	
	$plugins->run_hooks("forumdisplay_announcement");
	eval("\$announcements .= \"".$templates->get("forumdisplay_announcements_announcement")."\";");
	$bgcolor = alt_trow();
}

		$limit = '';
		$announcements = '';
		if($mybb->settings['announcementlimit'])
		{
			$limit = "LIMIT 0, ".$mybb->settings['announcementlimit'];
		}

		$sql = build_parent_list($fid, "fid", "OR", $parentlist);
		$time = TIME_NOW;
		$query = $db->query("
			SELECT a.*, u.username
			FROM ".TABLE_PREFIX."announcements a
			LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid=a.uid)
			WHERE a.startdate<='$time' AND (a.enddate>='$time' OR a.enddate='0') AND ($sql OR fid='-1')
			ORDER BY a.startdate DESC $limit
		");

		// See if this announcement has been read in our announcement array
		$cookie = array();
		if(isset($mybb->cookies['mybb']['announcements']))
		{
			$cookie = unserialize(stripslashes($mybb->cookies['mybb']['announcements']));
		}

		$bgcolor = alt_trow(true); // Reset the trow colors
		while($announcement = $db->fetch_array($query))
		{
			if($announcement['startdate'] > $mybb->user['lastvisit'] && !$cookie[$announcement['aid']])
			{
				$new_class = ' class="subject_new"';
				$folder = "newfolder";
			}
			else
			{
				$new_class = ' class="subject_old"';
				$folder = "folder";
			}

			// Mmm, eat those announcement cookies if they're older than our last visit
			if($cookie[$announcement['aid']] < $mybb->user['lastvisit'])
			{
				unset($cookie[$announcement['aid']]);
			}

if($announcements)
{
	eval("\$announcementlist = \"".$templates->get("forumdisplay_announcements")."\";");
	$shownormalsep = true;
}

			$announcement['announcementlink'] = get_announcement_link($announcement['aid']);
			$announcement['subject'] = $parser->parse_badwords($announcement['subject']);
			$announcement['subject'] = htmlspecialchars_uni($announcement['subject']);
			$postdate = my_date($mybb->settings['dateformat'], $announcement['startdate']);
			$posttime = my_date($mybb->settings['timeformat'], $announcement['startdate']);
			$announcement['profilelink'] = build_profile_link($announcement['username'], $announcement['uid']);
	
			if($foruminfo['allowtratings'] != 0 && $fpermissions['canviewthreads'] != 0)
			{
				eval("\$rating = \"".$templates->get("forumdisplay_announcement_rating")."\";");
				$lpbackground = "trow2";
			}
			else
			{
				$rating = '';
				$lpbackground = "trow1";
			}
	
			if($ismod)
			{
				eval("\$modann = \"".$templates->get("forumdisplay_announcements_announcement_modbit")."\";");
			}
			else
			{
				$modann = '';
			}
	
			$plugins->run_hooks("forumdisplay_announcement");
			eval("\$announcements .= \"".$templates->get("forumdisplay_announcements_announcement")."\";");
			$bgcolor = alt_trow();
		}

		if($announcements)
		{
			eval("\$announcementlist = \"".$templates->get("forumdisplay_announcements")."\";");
			$shownormalsep = true;
		}

		if(empty($cookie))
		{
			// Clean up cookie crumbs
			my_setcookie('mybb[announcements]', 0, (TIME_NOW - (60*60*24*365)));
		}
		else if(!empty($cookie))
		{
			my_setcookie("mybb[announcements]", addslashes(serialize($cookie)), -1);
		}
	}
}

		SELECT t.*, p.displaystyle AS threadprefix, {$ratingadd}{$select_rating_user}t.username AS threadusername, u.username

		SELECT t.*, {$ratingadd}t.username AS threadusername, u.username

		LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid = t.uid){$select_voting}
		LEFT JOIN ".TABLE_PREFIX."threadprefixes p ON (p.pid = t.prefix)

		LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid = t.uid)

		{

		{

	$query = $db->simple_select("posts", "tid,uid", "uid='{$mybb->user['uid']}' AND tid IN ({$tids})");

	$query = $db->simple_select("posts", "tid,uid", "uid='{$mybb->user['uid']}' AND tid IN ({$tids}) {$visibleonly}");

		}

		}

		{
			$thread['threadprefix'] .= ' ';

		{
			$threadprefix = build_prefixes($thread['prefix']);
			$thread['threadprefix'] = $threadprefix['displaystyle'].' ';

		}

		}

		{

		{

		switch($db->type)

		if($forum_stats[-1]['modtools'] || $forum_stats[$fid]['modtools'])

			case "pgsql":
			case "sqlite":
				$query = $db->simple_select("modtools", 'tid, name', "(','||forums||',' LIKE '%,$fid,%' OR ','||forums||',' LIKE '%,-1,%' OR forums='') AND type = 't'");
				break;
			default:
				$query = $db->simple_select("modtools", 'tid, name', "(CONCAT(',',forums,',') LIKE '%,$fid,%' OR CONCAT(',',forums,',') LIKE '%,-1,%' OR forums='') AND type = 't'");

			switch($db->type)
			{
				case "pgsql":
				case "sqlite":
					$query = $db->simple_select("modtools", 'tid, name', "(','||forums||',' LIKE '%,$fid,%' OR ','||forums||',' LIKE '%,-1,%' OR forums='') AND type = 't'");
					break;
				default:
					$query = $db->simple_select("modtools", 'tid, name', "(CONCAT(',',forums,',') LIKE '%,$fid,%' OR CONCAT(',',forums,',') LIKE '%,-1,%' OR forums='') AND type = 't'");
			}

			while($tool = $db->fetch_array($query))
			{
				eval("\$customthreadtools .= \"".$templates->get("forumdisplay_inlinemoderation_custom_tool")."\";");
			}

		while($tool = $db->fetch_array($query))
		{
			eval("\$customthreadtools .= \"".$templates->get("forumdisplay_inlinemoderation_custom_tool")."\";");
		}
		
		if(!empty($customthreadtools))

		else

	}
}

	}
}

if(fetch_unread_count($fid) == 0 && $unread_forums == 0)

$unread_threads = fetch_unread_count($fid);
if($unread_threads !== false && $unread_threads == 0 && $unread_forums == 0)

}

}

$query = $db->simple_select("forumsubscriptions", "fid", "fid='".$fid."' AND uid='{$mybb->user['uid']}'", array('limit' => 1));
if($db->fetch_field($query, 'fid'))

$add_remove_subscription = 'add';
$add_remove_subscription_text = $lang->subscribe_forum;

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

	$add_remove_subscription = 'remove';
	$add_remove_subscription_text = $lang->unsubscribe_forum;

	$query = $db->simple_select("forumsubscriptions", "fid", "fid='".$fid."' AND uid='{$mybb->user['uid']}'", array('limit' => 1));

	if($db->fetch_field($query, 'fid'))
	{
		$add_remove_subscription = 'remove';
		$add_remove_subscription_text = $lang->unsubscribe_forum;
	}