Vergleich showthread.php - 1.6.1 - 1.6.4

 * $Id: showthread.php 5125 2010-07-27 07:28:03Z RyanGordon $

 * $Id: showthread.php 5473 2011-06-23 11:12:10Z Tomm $

$templatelist .= ",showthread_usersbrowsing,showthread_usersbrowsing_user";

$templatelist .= ",showthread_usersbrowsing,showthread_usersbrowsing_user,multipage_page_link_current,multipage_breadcrumb";

	$query = $db->simple_select('threadprefixes', 'prefix, displaystyle', "pid='{$thread['prefix']}'");
	$threadprefix = $db->fetch_array($query);
	
	$thread['threadprefix'] = $threadprefix['prefix'].' ';
	$thread['displayprefix'] = $threadprefix['displaystyle'].' ';
}

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

	if($threadprefix['prefix'])
	{
		$thread['threadprefix'] = $threadprefix['prefix'].' ';
		$thread['displayprefix'] = $threadprefix['displaystyle'].' ';
	}
}

{

{

}

$visibleonly = "AND visible='1'";

}

$visibleonly = "AND visible='1'";

{

{

{

{

}

// Make sure we are looking at a real thread here.
if(!$thread['tid'] || ($thread['visible'] == 0 && $ismod == false) || ($thread['visible'] > 1 && $ismod == true))
{
	error($lang->error_invalidthread);
}

$archive_url = build_archive_link("thread", $tid);

}

$archive_url = build_archive_link("thread", $tid);

	error($lang->error_invalidforum);
}

// How many pages are there?
if(!$mybb->settings['threadsperpage'])
{
	$mybb->settings['threadsperpage'] = 20;
}

$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'];
}

// Limit to only our own threads
$uid_only = '';
if($forumpermissions['canonlyviewownthreads'] == 1)
{
	$uid_only = " AND uid = '".$mybb->user['uid']."'";

	$query = $db->simple_select("threads", "COUNT(tid) AS threads", "fid = '$fid' $visibleonly $uid_only", array('limit' => 1));
	$threadcount = $db->fetch_field($query, "threads");
}

// 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 $uid_only", array('limit' => 1));
	$threadcount = $db->fetch_field($query, "threads");
}

$stickybit = " OR sticky=1";
if($thread['sticky'] == 1)
{
	$stickybit = " AND sticky=1";
}

// Figure out what page the thread is actually on
switch($db->type)
{
	case "pgsql":
		$query = $db->query("
			SELECT COUNT(tid) as threads
			FROM ".TABLE_PREFIX."threads
			WHERE fid = '$fid' AND (lastpost >= '".intval($thread['lastpost'])."'{$stickybit}) {$visibleonly} {$uid_only}
			GROUP BY lastpost
			ORDER BY lastpost DESC
		");
		break;
	default:
		$query = $db->simple_select("threads", "COUNT(tid) as threads", "fid = '$fid' AND (lastpost >= '".intval($thread['lastpost'])."'{$stickybit}) {$visibleonly} {$uid_only}", array('order_by' => 'lastpost', 'order_dir' => 'desc'));

	error($lang->error_invalidforum);
}

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

$breadcrumb_multipage = array();
if($mybb->settings['showforumpagesbreadcrumb'])
{
	// How many pages are there?
	if(!$mybb->settings['threadsperpage'])
	{
		$mybb->settings['threadsperpage'] = 20;
	}

	$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'];
	}

	// Limit to only our own threads
	$uid_only = '';
	if($forumpermissions['canonlyviewownthreads'] == 1)
	{
		$uid_only = " AND uid = '".$mybb->user['uid']."'";

		$query = $db->simple_select("threads", "COUNT(tid) AS threads", "fid = '$fid' $visibleonly $uid_only", array('limit' => 1));
		$threadcount = $db->fetch_field($query, "threads");
	}

	// 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 $uid_only", array('limit' => 1));
		$threadcount = $db->fetch_field($query, "threads");
	}

	$stickybit = " OR sticky=1";
	if($thread['sticky'] == 1)
	{
		$stickybit = " AND sticky=1";
	}

	// Figure out what page the thread is actually on
	switch($db->type)
	{
		case "pgsql":
			$query = $db->query("
				SELECT COUNT(tid) as threads
				FROM ".TABLE_PREFIX."threads
				WHERE fid = '$fid' AND (lastpost >= '".intval($thread['lastpost'])."'{$stickybit}) {$visibleonly} {$uid_only}
				GROUP BY lastpost
				ORDER BY lastpost DESC
			");
			break;
		default:
			$query = $db->simple_select("threads", "COUNT(tid) as threads", "fid = '$fid' AND (lastpost >= '".intval($thread['lastpost'])."'{$stickybit}) {$visibleonly} {$uid_only}", array('order_by' => 'lastpost', 'order_dir' => 'desc'));
	}

	$thread_position = $db->fetch_field($query, "threads");
	$thread_page = ceil(($thread_position/$mybb->settings['threadsperpage']));

	$breadcrumb_multipage = array(
		"num_threads" => $threadcount,
		"current_page" => $thread_page
	);

build_forum_breadcrumb($fid, array('num_threads' => $threadcount, 'current_page' => $thread_page));
add_breadcrumb($thread['displayprefix'].$thread['subject'], get_thread_link($thread['tid']));

build_forum_breadcrumb($fid, $breadcrumb_multipage);
add_breadcrumb($thread['displayprefix'].$thread['subject'], get_thread_link($thread['tid']));

		$forum_read = my_get_array_cookie("forumread", $fid);

		$forum_read = intval(my_get_array_cookie("forumread", $fid));

			}
		}
	}
	

			}
		}
	}
	

		$readcookie = $threadread = my_get_array_cookie("threadread", $thread['tid']);

		$readcookie = $threadread = intval(my_get_array_cookie("threadread", $thread['tid']));

	{

	{

		{

		{

		}

		}

			}

			}

		{

		{

		// Check if we have already voted on this thread - it won't show hover effect then.
		$query = $db->simple_select("threadratings", "uid", "tid='{$tid}' AND uid='{$mybb->user['uid']}'");
		$rated = $db->fetch_field($query, 'uid');

		if($thread['num_ratings'])
		{
			// At least >someone< has rated this thread, was it me?
			// Check if we have already voted on this thread - it won't show hover effect then.
			$query = $db->simple_select("threadratings", "uid", "tid='{$tid}' AND uid='{$mybb->user['uid']}'");
			$rated = $db->fetch_field($query, 'uid');
		}

				SELECT COUNT(p.pid) AS count FROM ".TABLE_PREFIX."posts p

				SELECT COUNT(p.dateline) AS count FROM ".TABLE_PREFIX."posts p

				AND p.pid <= '".$mybb->input['pid']."'

				AND p.dateline <= '".$post['dateline']."'

			}

			}

			}
		}

			}
		}

			$query = $db->query("
				SELECT t.*, t.username AS threadusername, p.displaystyle AS threadprefix, u.username, MATCH (t.subject) AGAINST ('".$db->escape_string($thread['subject'])."') AS relevance
				FROM ".TABLE_PREFIX."threads t
				LEFT JOIN ".TABLE_PREFIX."threadprefixes p ON (p.pid = t.prefix)
				LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid = t.uid)
				WHERE t.fid='{$thread['fid']}' AND t.tid!='{$thread['tid']}' AND t.visible='1' AND t.closed NOT LIKE 'moved|%' AND MATCH (t.subject) AGAINST ('".$db->escape_string($thread['subject'])."') >= '{$mybb->settings['similarityrating']}'
				ORDER BY t.lastpost DESC
				LIMIT 0, {$mybb->settings['similarlimit']}
			");
			break;

				$query = $db->query("
					SELECT t.*, t.username AS threadusername, u.username
					FROM ".TABLE_PREFIX."threads t
					LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid = t.uid), plainto_tsquery ('".$db->escape_string($thread['subject'])."') AS query
					WHERE t.fid='{$thread['fid']}' AND t.tid!='{$thread['tid']}' AND t.visible='1' AND t.closed NOT LIKE 'moved|%' AND t.subject @@ query AND ts_rank_cd(to_tsvector('english',t.subject), query ) >= '{$mybb->settings['similarityrating']}'
					ORDER BY t.lastpost DESC
					OFFSET 0 LIMIT {$mybb->settings['similarlimit']}
				");
				break;

			$query = $db->query("
				SELECT t.*, t.username AS threadusername, p.displaystyle AS threadprefix, u.username, MATCH (t.subject) AGAINST ('".$db->escape_string($thread['subject'])."') AS relevance
				FROM ".TABLE_PREFIX."threads t
				LEFT JOIN ".TABLE_PREFIX."threadprefixes p ON (p.pid = t.prefix)
				LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid = t.uid)
				WHERE t.fid='{$thread['fid']}' AND t.tid!='{$thread['tid']}' AND t.visible='1' AND t.closed NOT LIKE 'moved|%' AND MATCH (t.subject) AGAINST ('".$db->escape_string($thread['subject'])."') >= '{$mybb->settings['similarityrating']}'
				ORDER BY t.lastpost DESC
				LIMIT 0, {$mybb->settings['similarlimit']}
			");

				$query = $db->query("
					SELECT t.*, t.username AS threadusername, u.username, MATCH (t.subject) AGAINST ('".$db->escape_string($thread['subject'])."') AS relevance
					FROM ".TABLE_PREFIX."threads t
					LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid = t.uid)
					WHERE t.fid='{$thread['fid']}' AND t.tid!='{$thread['tid']}' AND t.visible='1' AND t.closed NOT LIKE 'moved|%' AND MATCH (t.subject) AGAINST ('".$db->escape_string($thread['subject'])."') >= '{$mybb->settings['similarityrating']}'
					ORDER BY t.lastpost DESC
					LIMIT 0, {$mybb->settings['similarlimit']}
				");

				$similar_thread['threadprefix'] .= ' ';

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

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

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

			if($tool['type'] == 'p')

			$customthreadtools = $customposttools = '';
	
			switch($db->type)

				eval("\$customposttools .= \"".$templates->get("showthread_inlinemoderation_custom_tool")."\";");

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

			else

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

				eval("\$customthreadtools .= \"".$templates->get("showthread_moderationoptions_custom_tool")."\";");

				if($tool['type'] == 'p')
				{
					eval("\$customposttools .= \"".$templates->get("showthread_inlinemoderation_custom_tool")."\";");
				}
				else
				{
					eval("\$customthreadtools .= \"".$templates->get("showthread_moderationoptions_custom_tool")."\";");
				}
			}

			// Build inline moderation dropdown
			if(!empty($customposttools))
			{
				eval("\$customposttools = \"".$templates->get("showthread_inlinemoderation_custom")."\";");

		// Build inline moderation dropdown
		if(!empty($customposttools))
		{
			eval("\$customposttools = \"".$templates->get("showthread_inlinemoderation_custom")."\";");
		}

	$query = $db->simple_select("threadsubscriptions", "tid", "tid='".intval($tid)."' AND uid='".intval($mybb->user['uid'])."'", array('limit' => 1));
	if($db->fetch_field($query, 'tid'))
	{
		$add_remove_subscription = 'remove';
		$add_remove_subscription_text = $lang->unsubscribe_thread;
	}
	else

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

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

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

		$query = $db->simple_select("threadsubscriptions", "tid", "tid='".intval($tid)."' AND uid='".intval($mybb->user['uid'])."'", array('limit' => 1));

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

			SELECT s.ip, s.uid, s.time, u.username, u.invisible, u.usergroup, u.usergroup, u.displaygroup

			SELECT s.ip, s.uid, s.time, u.username, u.invisible, u.usergroup, u.displaygroup

			else

			else if($doneusers[$user['uid']] < $user['time'] || !$doneusers[$user['uid']])

				if($doneusers[$user['uid']] < $user['time'] || !$doneusers[$user['uid']])

				++$membercount;
				$doneusers[$user['uid']] = $user['time'];

				$invisiblemark = '';
				if($user['invisible'] == 1)
				{
					$invisiblemark = "*";
					++$inviscount;
				}

				if($user['invisible'] != 1 || $mybb->usergroup['canviewwolinvis'] == 1 || $user['uid'] == $mybb->user['uid'])

					$doneusers[$user['uid']] = $user['time'];
					++$membercount;
					if($user['invisible'] == 1)
					{
						$invisiblemark = "*";

						if($user['uid'] != $mybb->user['uid'])
						{
							++$inviscount;
						}
					}
					else
					{
						$invisiblemark = '';
					}
					
					if($user['invisible'] != 1 || $mybb->usergroup['canviewwolinvis'] == 1 || $user['uid'] == $mybb->user['uid'])
					{
						$user['profilelink'] = get_profile_link($user['uid']);
						$user['username'] = format_name($user['username'], $user['usergroup'], $user['displaygroup']);
						$user['reading'] = my_date($mybb->settings['timeformat'], $user['time']);
						eval("\$onlinemembers .= \"".$templates->get("showthread_usersbrowsing_user", 1, 0)."\";");
						$comma = $lang->comma;
					}

					$user['profilelink'] = get_profile_link($user['uid']);
					$user['username'] = format_name($user['username'], $user['usergroup'], $user['displaygroup']);
					$user['reading'] = my_date($mybb->settings['timeformat'], $user['time']);

					eval("\$onlinemembers .= \"".$templates->get("showthread_usersbrowsing_user", 1, 0)."\";");
					$comma = $lang->comma;

		if($guestcount)
		{
			$guestsonline = $lang->sprintf($lang->users_browsing_thread_guests, $guestcount);
		}

		if($guestcount && $onlinemembers)
		{
			$onlinesep = $lang->comma;
		}

		$onlinesep2 = $onlinesep = '';
		if($inviscount && $mybb->usergroup['canviewwolinvis'] != 1)

		if($inviscount && $mybb->usergroup['canviewwolinvis'] != 1 && ($inviscount != 1 && $mybb->user['invisible'] != 1))

			if($onlinemembers)
			{
				$onlinesep = $lang->comma;
			}

 			$invisonline = $lang->sprintf($lang->users_browsing_thread_invis, $inviscount);
 		}

		if($guestcount)
 		{
			if($onlinemembers)
			{
				$onlinesep2 = $lang->comma;
			}

			$invisonline = $lang->sprintf($lang->users_browsing_thread_invis, $inviscount);
		}

			$guestsonline = $lang->sprintf($lang->users_browsing_thread_guests, $guestcount);
 		}

		if($invisonline != '' && $guestcount)
		{
			$onlinesep2 = $lang->comma;
		}