Vergleich forumdisplay.php - 1.4.1 - 1.4.11

 * $Id: forumdisplay.php 4081 2008-08-08 01:47:02Z Tikitiki $

 * $Id: forumdisplay.php 4536 2009-11-25 06:34:47Z RyanGordon $

{

{

// Build a forum cache.
$query = $db->query("
	SELECT f.*, fr.dateline AS lastread
	FROM ".TABLE_PREFIX."forums f
	LEFT JOIN ".TABLE_PREFIX."forumsread fr ON (fr.fid=f.fid AND fr.uid='{$mybb->user['uid']}')
	WHERE f.active != 0
	ORDER BY pid, disporder
");

if($mybb->user['uid'] == 0)
{
	// Build a forum cache.
	$query = $db->query("
		SELECT *
		FROM ".TABLE_PREFIX."forums
		WHERE active != 0
		ORDER BY pid, disporder
	");
	
	$forumsread = unserialize($mybb->cookies['mybb']['forumread']);
}
else
{
	// Build a forum cache.
	$query = $db->query("
		SELECT f.*, fr.dateline AS lastread
		FROM ".TABLE_PREFIX."forums f
		LEFT JOIN ".TABLE_PREFIX."forumsread fr ON (fr.fid=f.fid AND fr.uid='{$mybb->user['uid']}')
		WHERE f.active != 0
		ORDER BY pid, disporder
	");
}

	if($invisonline != '' && $guestcount)

	if($invisonline != '' && ($guestcount || $onlinemembers))

// How many posts are there?
if($datecut > 0)
{
	$query = $db->simple_select("threads", "COUNT(tid) AS threads", "fid = '$fid' $visibleonly $datecutsql");
	$threadcount = $db->fetch_field($query, "threads");
}
else
{
	$query = $db->simple_select("forums", "threads, unapprovedthreads", "fid = '{$fid}'", array('limit' => 1));
	$forum_threads = $db->fetch_array($query);
	$threadcount = $forum_threads['threads'];
	if($ismod == true)
	{
		$threadcount += $forum_threads['unapprovedthreads'];
	}
	
	// If we have 0 threads double check there aren't any "moved" threads
	if($threadcount == 0)
	{
		$query = $db->simple_select("threads", "COUNT(tid) AS threads", "fid = '$fid' $visibleonly", array('limit' => 1));
		$threadcount = $db->fetch_field($query, "threads");
	}
}

$threadcount = 0;

if($fpermissions['canviewthreads'] != 0)
{
	// How many posts are there?
	if($datecut > 0)
	{
		$query = $db->simple_select("threads", "COUNT(tid) AS threads", "fid = '$fid' $visibleonly $datecutsql");
		$threadcount = $db->fetch_field($query, "threads");
	}
	else
	{
		$query = $db->simple_select("forums", "threads, unapprovedthreads", "fid = '{$fid}'", array('limit' => 1));
		$forum_threads = $db->fetch_array($query);
		$threadcount = $forum_threads['threads'];
		if($ismod == true)
		{
			$threadcount += $forum_threads['unapprovedthreads'];
		}
		
		// If we have 0 threads double check there aren't any "moved" threads
		if($threadcount == 0)
		{
			$query = $db->simple_select("threads", "COUNT(tid) AS threads", "fid = '$fid' $visibleonly", array('limit' => 1));
			$threadcount = $db->fetch_field($query, "threads");
		}
	}
}

}

}

	{

	{

	}

	}

	}

	}

if($foruminfo['allowtratings'] != 0)

if($foruminfo['allowtratings'] != 0 && $fpermissions['canviewthreads'] != 0)

			$ratingadd = '';
			$query = $db->query("
				SELECT t.numratings, t.totalratings, t.tid
				FROM ".TABLE_PREFIX."threads t
				WHERE t.fid='$fid' $tvisibleonly $datecutsql2
				ORDER BY t.sticky DESC, t.$sortfield $sortordernow $sortfield2
				LIMIT $start, $perpage
			");
			while($thread = $db->fetch_array($query))
			{
				if($thread['totalratings'] == 0)
				{
					$rating = 0;
				}
				else				
				{
					$rating = $thread['totalratings'] / $thread['numratings'];
				}

				$avaragerating[$thread['tid']] = $rating;
			}

			$ratingadd = "CASE WHEN t.numratings=0 THEN 0 ELSE t.totalratings/t.numratings::numeric END AS averagerating, ";

// Start Getting Threads
$query = $db->query("
	SELECT t.*, {$ratingadd}{$select_rating_user}t.username AS threadusername, u.username
	FROM ".TABLE_PREFIX."threads t
	LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid = t.uid){$select_voting}
	WHERE t.fid='$fid' $tvisibleonly $datecutsql2
	ORDER BY t.sticky DESC, {$t}{$sortfield} $sortordernow $sortfield2
	LIMIT $start, $perpage
");
while($thread = $db->fetch_array($query))

if($fpermissions['canviewthreads'] != 0)

	if($db->type == "pgsql")

	// Start Getting Threads
	$query = $db->query("
		SELECT t.*, {$ratingadd}{$select_rating_user}t.username AS threadusername, u.username
		FROM ".TABLE_PREFIX."threads t
		LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid = t.uid){$select_voting}
		WHERE t.fid='$fid' $tvisibleonly $datecutsql2
		ORDER BY t.sticky DESC, {$t}{$sortfield} $sortordernow $sortfield2
		LIMIT $start, $perpage
	");
	while($thread = $db->fetch_array($query))

		$thread['averagerating'] = $averagerating[$thread['tid']];
	}

		$threadcache[$thread['tid']] = $thread;

	$threadcache[$thread['tid']] = $thread;

	// If this is a moved thread - set the tid for participation marking and thread read marking to that of the moved thread
	if(substr($thread['closed'], 0, 5) == "moved")
	{
		$tid = substr($thread['closed'], 6);
		if(!$tids[$tid])

		// If this is a moved thread - set the tid for participation marking and thread read marking to that of the moved thread
		if(substr($thread['closed'], 0, 5) == "moved")

			$moved_threads[$tid] = $thread['tid'];
			$tids[$thread['tid']] = $tid;
		}
	}
	// Otherwise - set it to the plain thread ID
	else
	{
		$tids[$thread['tid']] = $thread['tid'];
		if($moved_threads[$tid])
		{
			unset($moved_threads[$tid]);

			$tid = substr($thread['closed'], 6);
			if(!$tids[$tid])
			{
				$moved_threads[$tid] = $thread['tid'];
				$tids[$thread['tid']] = $tid;
			}
		}
		// Otherwise - set it to the plain thread ID
		else
		{
			$tids[$thread['tid']] = $thread['tid'];
			if($moved_threads[$tid])
			{
				unset($moved_threads[$tid]);
			}

				$thread['averagerating'] = intval(round($thread['averagerating'], 2));
				$thread['width'] = $thread['averagerating']*20;

				$thread['averagerating'] = floatval(round($thread['averagerating'], 2));
				$thread['width'] = intval(round($thread['averagerating']))*20;