Vergleich showthread.php - 1.6.6 - 1.6.15

  Keine Änderungen   Hinzugefügt   Modifiziert   Entfernt
Zeile 6Zeile 6
 * Website: http://mybb.com
* License: http://mybb.com/about/license
*

 * Website: http://mybb.com
* License: http://mybb.com/about/license
*

 * $Id: showthread.php 5639 2011-10-26 09:16:47Z Tomm $

 * $Id$

 */

define("IN_MYBB", 1);
define('THIS_SCRIPT', 'showthread.php');


 */

define("IN_MYBB", 1);
define('THIS_SCRIPT', 'showthread.php');


$templatelist = "showthread,postbit,postbit_author_user,postbit_author_guest,showthread_newthread,showthread_newreply,showthread_newreply_closed,postbit_sig,showthread_newpoll,postbit_avatar,postbit_profile,postbit_find,postbit_pm,postbit_www,postbit_email,postbit_edit,postbit_quote,postbit_report,postbit_signature, postbit_online,postbit_offline,postbit_away,postbit_gotopost,showthread_ratethread,showthread_inline_ratethread,showthread_moderationoptions";

$templatelist = "showthread,postbit,postbit_author_user,postbit_author_guest,showthread_newthread,showthread_newreply,showthread_newreply_closed,postbit_avatar,postbit_find,postbit_pm,postbit_www,postbit_email,postbit_edit,postbit_quote,postbit_report,postbit_signature,postbit_online,postbit_offline,postbit_away,postbit_gotopost,showthread_ratethread,showthread_moderationoptions";

$templatelist .= ",multipage_prevpage,multipage_nextpage,multipage_page_current,multipage_page,multipage_start,multipage_end,multipage";
$templatelist .= ",postbit_editedby,showthread_similarthreads,showthread_similarthreads_bit,postbit_iplogged_show,postbit_iplogged_hiden,showthread_quickreply";

$templatelist .= ",multipage_prevpage,multipage_nextpage,multipage_page_current,multipage_page,multipage_start,multipage_end,multipage";
$templatelist .= ",postbit_editedby,showthread_similarthreads,showthread_similarthreads_bit,postbit_iplogged_show,postbit_iplogged_hiden,showthread_quickreply";

$templatelist .= ",forumjump_advanced,forumjump_special,forumjump_bit,showthread_multipage,postbit_reputation,postbit_quickdelete,postbit_attachments,thumbnails_thumbnail,postbit_attachments_attachment,postbit_attachments_thumbnails,postbit_attachments_images_image,postbit_attachments_images,postbit_posturl,postbit_rep_button";
$templatelist .= ",postbit_inlinecheck,showthread_inlinemoderation,postbit_attachments_thumbnails_thumbnail,postbit_quickquote,postbit_qqmessage,postbit_ignored,postbit_groupimage,postbit_multiquote,showthread_search,postbit_warn,postbit_warninglevel,showthread_moderationoptions_custom_tool,showthread_moderationoptions_custom,showthread_inlinemoderation_custom_tool,showthread_inlinemoderation_custom,postbit_classic,showthread_classic_header,showthread_poll_resultbit,showthread_poll_results";
$templatelist .= ",showthread_usersbrowsing,showthread_usersbrowsing_user,multipage_page_link_current,multipage_breadcrumb";

$templatelist .= ",forumjump_advanced,forumjump_special,forumjump_bit,showthread_multipage,postbit_reputation,postbit_quickdelete,postbit_attachments,postbit_attachments_attachment,postbit_attachments_thumbnails,postbit_attachments_images_image,postbit_attachments_images,postbit_posturl,postbit_rep_button";
$templatelist .= ",postbit_inlinecheck,showthread_inlinemoderation,postbit_attachments_thumbnails_thumbnail,postbit_ignored,postbit_groupimage,postbit_multiquote,showthread_search,postbit_warn,postbit_warninglevel,showthread_moderationoptions_custom_tool,showthread_moderationoptions_custom,showthread_inlinemoderation_custom_tool,showthread_inlinemoderation_custom,postbit_classic,showthread_classic_header,showthread_poll_resultbit,showthread_poll_results";
$templatelist .= ",showthread_usersbrowsing,showthread_usersbrowsing_user,multipage_page_link_current,multipage_breadcrumb,showthread_poll_option_multiple,showthread_poll_option,showthread_poll,showthread_threadedbox,showthread_quickreply_options_signature,showthread_threaded_bitactive,showthread_threaded_bit,postbit_attachments_attachment_unapproved,forumdisplay_password_wrongpass,forumdisplay_password";


require_once "./global.php";
require_once MYBB_ROOT."inc/functions_post.php";


require_once "./global.php";
require_once MYBB_ROOT."inc/functions_post.php";

require_once MYBB_ROOT."/inc/functions_indicators.php";

require_once MYBB_ROOT."inc/functions_indicators.php";

require_once MYBB_ROOT."inc/class_parser.php";
$parser = new postParser;


require_once MYBB_ROOT."inc/class_parser.php";
$parser = new postParser;


Zeile 29Zeile 29
$lang->load("showthread");

// If there is no tid but a pid, trick the system into thinking there was a tid anyway.

$lang->load("showthread");

// If there is no tid but a pid, trick the system into thinking there was a tid anyway.

if($mybb->input['pid'] && !$mybb->input['tid'])

if(!empty($mybb->input['pid']) && !$mybb->input['tid'])

{
// see if we already have the post information
if(isset($style) && $style['pid'] == $mybb->input['pid'] && $style['tid'])

{
// see if we already have the post information
if(isset($style) && $style['pid'] == $mybb->input['pid'] && $style['tid'])

Zeile 44Zeile 44
		);
$query = $db->simple_select("posts", "tid", "pid=".$mybb->input['pid'], $options);
$post = $db->fetch_array($query);

		);
$query = $db->simple_select("posts", "tid", "pid=".$mybb->input['pid'], $options);
$post = $db->fetch_array($query);

 
		
if(empty($post))
{
// post does not exist --> show error message
error($lang->error_invalidpost);
}


		$mybb->input['tid'] = $post['tid'];
}
}

// Get the thread details from the database.
$thread = get_thread($mybb->input['tid']);

		$mybb->input['tid'] = $post['tid'];
}
}

// Get the thread details from the database.
$thread = get_thread($mybb->input['tid']);

 

if(!$thread || substr($thread['closed'], 0, 6) == "moved|")
{
error($lang->error_invalidthread);
}


// Get thread prefix if there is one.
$thread['threadprefix'] = '';


// Get thread prefix if there is one.
$thread['threadprefix'] = '';

Zeile 62Zeile 74
	{
$thread['threadprefix'] = $threadprefix['prefix'].' ';
$thread['displayprefix'] = $threadprefix['displaystyle'].' ';

	{
$thread['threadprefix'] = $threadprefix['prefix'].' ';
$thread['displayprefix'] = $threadprefix['displaystyle'].' ';

	}
}

if(substr($thread['closed'], 0, 6) == "moved|")
{
$thread['tid'] = 0;




	}
}

$reply_subject = $parser->parse_badwords($thread['subject']);
$thread['subject'] = htmlspecialchars_uni($reply_subject);
// Subject too long? Shorten it to avoid error message
if(my_strlen($reply_subject) > 85)
{
$reply_subject = my_substr($reply_subject, 0, 82).'...';

}

}


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

$reply_subject = htmlspecialchars_uni($reply_subject);


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

if(!$thread['username'])
{
$thread['username'] = $lang->guest;

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

if(!$thread['username'])
{
$thread['username'] = $lang->guest;

}

}


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


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

 
$visibleonly2 = "AND p.visible='1' AND t.visible='1'";


// Is the currently logged in user a moderator of this forum?
if(is_moderator($fid))
{
$visibleonly = " AND (visible='1' OR visible='0')";


// Is the currently logged in user a moderator of this forum?
if(is_moderator($fid))
{
$visibleonly = " AND (visible='1' OR visible='0')";

 
	$visibleonly2 = "AND (p.visible='1' OR p.visible='0') AND (t.visible='1' OR t.visible='0')";

	$ismod = true;
}
else

	$ismod = true;
}
else

Zeile 93Zeile 109
}

// Make sure we are looking at a real thread here.

}

// Make sure we are looking at a real thread here.

if(!$thread['tid'] || ($thread['visible'] == 0 && $ismod == false) || ($thread['visible'] > 1 && $ismod == true))

if(($thread['visible'] != 1 && $ismod == false) || ($thread['visible'] > 1 && $ismod == true))

{
error($lang->error_invalidthread);

{
error($lang->error_invalidthread);

}

$forumpermissions = forum_permissions($thread['fid']);

}

$forumpermissions = forum_permissions($thread['fid']);


// Does the user have permission to view this thread?
if($forumpermissions['canview'] != 1 || $forumpermissions['canviewthreads'] != 1)


// Does the user have permission to view this thread?
if($forumpermissions['canview'] != 1 || $forumpermissions['canviewthreads'] != 1)

{
error_no_permission();
}

if($forumpermissions['canonlyviewownthreads'] == 1 && $thread['uid'] != $mybb->user['uid'])
{
error_no_permission();
}

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


{
error_no_permission();
}

if(isset($forumpermissions['canonlyviewownthreads']) && $forumpermissions['canonlyviewownthreads'] == 1 && $thread['uid'] != $mybb->user['uid'])
{
error_no_permission();
}

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


// Does the thread belong to a valid forum?
$forum = get_forum($fid);
if(!$forum || $forum['type'] != "f")

// Does the thread belong to a valid forum?
$forum = get_forum($fid);
if(!$forum || $forum['type'] != "f")

{

{

	error($lang->error_invalidforum);
}

	error($lang->error_invalidforum);
}


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

if(!is_array($forum_stats))
{
// Attempt to rebuild it?
$forum_stats = $cache->read("forumdisplay", true);

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

$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 the navigation.
build_forum_breadcrumb($fid, $breadcrumb_multipage);
add_breadcrumb($thread['displayprefix'].$thread['subject'], get_thread_link($thread['tid']));

 

// Check if this forum is password protected and we have a valid password
check_forum_password($forum['fid']);

// If there is no specific action, we must be looking at the thread.


// Check if this forum is password protected and we have a valid password
check_forum_password($forum['fid']);

// If there is no specific action, we must be looking at the thread.

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

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

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

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

Zeile 280Zeile 212
	);

$lastread = intval($lastread);

	);

$lastread = intval($lastread);

	$query = $db->simple_select("posts", "pid", "tid='{$tid}' AND dateline > '{$lastread}'", $options);

	$query = $db->simple_select("posts", "pid", "tid='{$tid}' AND dateline > '{$lastread}' {$visibleonly}", $options);

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

if($newpost['pid'] && $lastread)

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

if($newpost['pid'] && $lastread)

Zeile 315Zeile 247
			SELECT p.pid
FROM ".TABLE_PREFIX."posts p
LEFT JOIN ".TABLE_PREFIX."threads t ON(p.tid=t.tid)

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

			WHERE t.fid='".$thread['fid']."' AND t.closed NOT LIKE 'moved|%'

			WHERE t.fid='".$thread['fid']."' AND t.closed NOT LIKE 'moved|%' {$visibleonly2}

			ORDER BY p.dateline DESC
LIMIT 1
");

			ORDER BY p.dateline DESC
LIMIT 1
");

Zeile 329Zeile 261
			'limit_start' => 0,
'limit' => 1
);

			'limit_start' => 0,
'limit' => 1
);

		$query = $db->simple_select('posts', 'pid', "tid={$tid}", $options);

		$query = $db->simple_select('posts', 'pid', "tid={$tid} {$visibleonly}", $options);

		$pid = $db->fetch_field($query, "pid");
}
header("Location: ".htmlspecialchars_decode(get_post_link($pid, $tid))."#pid{$pid}");

		$pid = $db->fetch_field($query, "pid");
}
header("Location: ".htmlspecialchars_decode(get_post_link($pid, $tid))."#pid{$pid}");

Zeile 344Zeile 276
		"limit" => 1,
"order_by" => "lastpost"
);

		"limit" => 1,
"order_by" => "lastpost"
);

	$query = $db->simple_select('threads', '*', "fid={$thread['fid']} AND lastpost > {$thread['lastpost']} AND visible=1 AND closed NOT LIKE 'moved|%'", $options);

	$query = $db->simple_select('threads', '*', "fid={$thread['fid']} AND lastpost > {$thread['lastpost']} {$visibleonly} AND closed NOT LIKE 'moved|%'", $options);

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

// Are there actually next newest posts?

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

// Are there actually next newest posts?

Zeile 375Zeile 307
		"order_by" => "lastpost",
"order_dir" => "desc"
);

		"order_by" => "lastpost",
"order_dir" => "desc"
);

	$query = $db->simple_select("threads", "*", "fid=".$thread['fid']." AND lastpost < ".$thread['lastpost']." AND visible=1 AND closed NOT LIKE 'moved|%'", $options);

	$query = $db->simple_select("threads", "*", "fid=".$thread['fid']." AND lastpost < ".$thread['lastpost']." {$visibleonly} AND closed NOT LIKE 'moved|%'", $options);

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

// Are there actually next oldest posts?

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

// Are there actually next oldest posts?

Zeile 397Zeile 329
	exit;
}


	exit;
}


if($mybb->input['pid'])

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

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

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

 

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

$breadcrumb_multipage = array();
if($mybb->settings['showforumpagesbreadcrumb'])
{
// How many pages are there?
if(!$mybb->settings['threadsperpage'] || (int)$mybb->settings['threadsperpage'] < 1)
{
$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(isset($forumpermissions['canonlyviewownthreads']) && $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 the navigation.
build_forum_breadcrumb($fid, $breadcrumb_multipage);
add_breadcrumb($thread['displayprefix'].$thread['subject'], get_thread_link($thread['tid']));


$plugins->run_hooks("showthread_start");



$plugins->run_hooks("showthread_start");


Zeile 423Zeile 428
		$poll['timeout'] = $poll['timeout']*60*60*24;
$expiretime = $poll['dateline'] + $poll['timeout'];
$now = TIME_NOW;

		$poll['timeout'] = $poll['timeout']*60*60*24;
$expiretime = $poll['dateline'] + $poll['timeout'];
$now = TIME_NOW;





		// If the poll or the thread is closed or if the poll is expired, show the results.
if($poll['closed'] == 1 || $thread['closed'] == 1 || ($expiretime < $now && $poll['timeout'] > 0))
{

		// If the poll or the thread is closed or if the poll is expired, show the results.
if($poll['closed'] == 1 || $thread['closed'] == 1 || ($expiretime < $now && $poll['timeout'] > 0))
{

Zeile 486Zeile 491
			{
$optionbg = "trow1";
$votestar = "";

			{
$optionbg = "trow1";
$votestar = "";

			}

			}


// If the user already voted or if the results need to be shown, do so; else show voting screen.
if($alreadyvoted || $showresults)


// If the user already voted or if the results need to be shown, do so; else show voting screen.
if($alreadyvoted || $showresults)

Zeile 530Zeile 535
		if(!is_moderator($fid, 'caneditposts'))
{
$edit_poll = '';

		if(!is_moderator($fid, 'caneditposts'))
{
$edit_poll = '';

		}
else

		}
else

		{
$edit_poll = " | <a href=\"polls.php?action=editpoll&amp;pid={$poll['pid']}\">{$lang->edit_poll}</a>";
}

		{
$edit_poll = " | <a href=\"polls.php?action=editpoll&amp;pid={$poll['pid']}\">{$lang->edit_poll}</a>";
}

Zeile 575Zeile 580

// Create the forum jump dropdown box.
if($mybb->settings['enableforumjump'] != 0)


// Create the forum jump dropdown box.
if($mybb->settings['enableforumjump'] != 0)

	{

	{

		$forumjump = build_forum_jump("", $fid, 1);
}


		$forumjump = build_forum_jump("", $fid, 1);
}


Zeile 590Zeile 595
	if($forum['open'] != 0)
{
eval("\$newthread = \"".$templates->get("showthread_newthread")."\";");

	if($forum['open'] != 0)
{
eval("\$newthread = \"".$templates->get("showthread_newthread")."\";");





		// Show the appropriate reply button if this thread is open or closed
if($thread['closed'] == 1)
{

		// Show the appropriate reply button if this thread is open or closed
if($thread['closed'] == 1)
{

Zeile 601Zeile 606
			eval("\$newreply = \"".$templates->get("showthread_newreply")."\";");
}
}

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





	// Create the admin tools dropdown box.
if($ismod == true)
{

	// Create the admin tools dropdown box.
if($ismod == true)
{

 
		$adminpolloptions = $closelinkch = $stickch = '';


		if($pollbox)
{
$adminpolloptions = "<option value=\"deletepoll\">".$lang->delete_poll."</option>";

		if($pollbox)
{
$adminpolloptions = "<option value=\"deletepoll\">".$lang->delete_poll."</option>";

Zeile 650Zeile 657

// Work out the thread rating for this thread.
$rating = '';


// Work out the thread rating for this thread.
$rating = '';

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

	if($mybb->settings['allowthreadratings'] != 0 && $forum['allowtratings'] != 0)

	{
$rated = 0;
$lang->load("ratethread");

	{
$rated = 0;
$lang->load("ratethread");

Zeile 768Zeile 775
		}

$attachcache = array();

		}

$attachcache = array();

		if($thread['attachmentcount'] > 0)

		if($thread['attachmentcount'] > 0 || is_moderator($fid, 'caneditposts'))

		{
// Get the attachments for this post.
$query = $db->simple_select("attachments", "*", "pid=".$mybb->input['pid']);

		{
// Get the attachments for this post.
$query = $db->simple_select("attachments", "*", "pid=".$mybb->input['pid']);

Zeile 807Zeile 814
	}
else // Linear display
{

	}
else // Linear display
{

		if(!$mybb->settings['postsperpage'])


		$threadexbox = '';
if(!$mybb->settings['postsperpage'] || (int)$mybb->settings['postsperpage'] < 1)

		{

		{

			$mybb->settings['postperpage'] = 20;

			$mybb->settings['postsperpage'] = 20;

		}

// Figure out if we need to display multiple pages.

		}

// Figure out if we need to display multiple pages.

 
		$page = 1;

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

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

		if($mybb->input['page'] != "last")

		if(isset($mybb->input['page']) && $mybb->input['page'] != "last")

		{
$page = intval($mybb->input['page']);
}

		{
$page = intval($mybb->input['page']);
}

		if($mybb->input['pid'])



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

		{
$post = get_post($mybb->input['pid']);

		{
$post = get_post($mybb->input['pid']);

			$query = $db->query("
SELECT COUNT(p.dateline) AS count FROM ".TABLE_PREFIX."posts p
WHERE p.tid='$tid'
AND p.dateline <= '".$post['dateline']."'
$visible
");
$result = $db->fetch_field($query, "count");
if(($result % $perpage) == 0)
{
$page = $result / $perpage;
}
else
{
$page = intval($result / $perpage) + 1;




			if($post)
{
$query = $db->query("
SELECT COUNT(p.dateline) AS count FROM ".TABLE_PREFIX."posts p
WHERE p.tid = '{$tid}'
AND p.dateline <= '{$post['dateline']}'
{$visible}
");
$result = $db->fetch_field($query, "count");
if(($result % $perpage) == 0)
{
$page = $result / $perpage;
}
else
{
$page = intval($result / $perpage) + 1;
}

			}

			}

		}


		}


		// Recount replies if user is a moderator to take into account unapproved posts.
if($ismod)
{
$query = $db->simple_select("posts p", "COUNT(*) AS replies", "p.tid='$tid' $visible");

		// Recount replies if user is a moderator to take into account unapproved posts.
if($ismod)
{
$query = $db->simple_select("posts p", "COUNT(*) AS replies", "p.tid='$tid' $visible");

 
			$cached_replies = $thread['replies']+$thread['unapprovedposts'];

			$thread['replies'] = $db->fetch_field($query, 'replies')-1;

			$thread['replies'] = $db->fetch_field($query, 'replies')-1;

 
			
// The counters are wrong? Rebuild them
// This doesn't cover all cases however it is a good addition to the manual rebuild function
if($thread['replies'] != $cached_replies)
{
require_once MYBB_ROOT."/inc/functions_rebuild.php";
rebuild_thread_counters($thread['tid']);
}

		}

		}

 


		$postcount = intval($thread['replies'])+1;
$pages = $postcount / $perpage;
$pages = ceil($pages);


		$postcount = intval($thread['replies'])+1;
$pages = $postcount / $perpage;
$pages = ceil($pages);


		if($mybb->input['page'] == "last")

		if(isset($mybb->input['page']) && $mybb->input['page'] == "last")

		{
$page = $pages;
}

		{
$page = $pages;
}

Zeile 871Zeile 895
		// Work out if we have terms to highlight
$highlight = "";
$threadmode = "";

		// Work out if we have terms to highlight
$highlight = "";
$threadmode = "";

        if($mybb->settings['seourls'] == "yes" || ($mybb->settings['seourls'] == "auto" && $_SERVER['SEO_SUPPORT'] == 1))

        if($mybb->settings['seourls'] == "yes" || ($mybb->settings['seourls'] == "auto" && isset($_SERVER['SEO_SUPPORT']) && $_SERVER['SEO_SUPPORT'] == 1))

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

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

Zeile 892Zeile 916
        }
else
{

        }
else
{

			if($mybb->input['highlight'])

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

			{
if(is_array($mybb->input['highlight']))
{

			{
if(is_array($mybb->input['highlight']))
{

Zeile 928Zeile 952
			// Set the ID of the first post on page to $pid if it doesn't hold any value
// to allow this value to be used for Thread Mode/Linear Mode links
// and ensure the user lands on the correct page after changing view mode

			// Set the ID of the first post on page to $pid if it doesn't hold any value
// to allow this value to be used for Thread Mode/Linear Mode links
// and ensure the user lands on the correct page after changing view mode

			if(!$pid)

			if(empty($pid))

			{
$pid = $getid['pid'];
}

			{
$pid = $getid['pid'];
}

Zeile 941Zeile 965
			$pids = "pid IN($pids)";

$attachcache = array();

			$pids = "pid IN($pids)";

$attachcache = array();

			if($thread['attachmentcount'] > 0)

			if($thread['attachmentcount'] > 0 || is_moderator($fid, 'caneditposts'))

			{
// Now lets fetch all of the attachments for these posts.
$query = $db->simple_select("attachments", "*", $pids);

			{
// Now lets fetch all of the attachments for these posts.
$query = $db->simple_select("attachments", "*", $pids);

Zeile 981Zeile 1005
	}

// Show the similar threads table if wanted.

	}

// Show the similar threads table if wanted.

 
	$similarthreads = '';

	if($mybb->settings['showsimilarthreads'] != 0)
{

	if($mybb->settings['showsimilarthreads'] != 0)
{

 
		$own_perm = '';
if($forumpermissions['canonlyviewownthreads'] == 1)
{
$own_perm = " AND t.uid={$mybb->user['uid']}";
}


		switch($db->type)
{
case "pgsql":

		switch($db->type)
{
case "pgsql":

Zeile 990Zeile 1021
					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

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

					WHERE t.fid='{$thread['fid']}' AND t.tid!='{$thread['tid']}' AND t.visible='1' AND t.closed NOT LIKE 'moved|%' AND t.subject @@ query{$own_perm}

					ORDER BY t.lastpost DESC
OFFSET 0 LIMIT {$mybb->settings['similarlimit']}
");

					ORDER BY t.lastpost DESC
OFFSET 0 LIMIT {$mybb->settings['similarlimit']}
");

Zeile 1000Zeile 1031
					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)

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

					WHERE t.fid='{$thread['fid']}' AND t.tid!='{$thread['tid']}' AND t.visible='1' AND t.closed NOT LIKE 'moved|%'{$own_perm} AND MATCH (t.subject) AGAINST ('".$db->escape_string($thread['subject'])."') >= '{$mybb->settings['similarityrating']}'

					ORDER BY t.lastpost DESC
LIMIT 0, {$mybb->settings['similarlimit']}
");

					ORDER BY t.lastpost DESC
LIMIT 0, {$mybb->settings['similarlimit']}
");

Zeile 1069Zeile 1100
	}

// Decide whether or not to show quick reply.

	}

// Decide whether or not to show quick reply.

 
	$quickreply = '';

	if($forumpermissions['canpostreplys'] != 0 && $mybb->user['suspendposting'] != 1 && ($thread['closed'] != 1 || is_moderator($fid)) && $mybb->settings['quickreply'] != 0 && $mybb->user['showquickreply'] != '0' && $forum['open'] != 0)
{
$query = $db->simple_select("posts", "pid", "tid='{$tid}'", array("order_by" => "pid", "order_dir" => "desc", "limit" => 1));
$last_pid = $db->fetch_field($query, "pid");

// Show captcha image for guests if enabled

	if($forumpermissions['canpostreplys'] != 0 && $mybb->user['suspendposting'] != 1 && ($thread['closed'] != 1 || is_moderator($fid)) && $mybb->settings['quickreply'] != 0 && $mybb->user['showquickreply'] != '0' && $forum['open'] != 0)
{
$query = $db->simple_select("posts", "pid", "tid='{$tid}'", array("order_by" => "pid", "order_dir" => "desc", "limit" => 1));
$last_pid = $db->fetch_field($query, "pid");

// Show captcha image for guests if enabled

 
		$captcha = '';

		if($mybb->settings['captchaimage'] && !$mybb->user['uid'])
{
require_once MYBB_ROOT.'inc/class_captcha.php';

		if($mybb->settings['captchaimage'] && !$mybb->user['uid'])
{
require_once MYBB_ROOT.'inc/class_captcha.php';

Zeile 1085Zeile 1118
				$captcha = $post_captcha->html;
}
}

				$captcha = $post_captcha->html;
}
}

 

$postoptionschecked = array('signature' => '', 'emailnotify' => '');

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

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

		{

		{

			$postoptionschecked['signature'] = 'checked="checked"';

			$postoptionschecked['signature'] = 'checked="checked"';

		}
if($mybb->user['emailnotify'] == 1)









		}

// Hide signature option if no permission
$option_signature = '';
if($mybb->usergroup['canusesig'] && !$mybb->user['suspendsignature'])
{
eval("\$option_signature = \"".$templates->get('showthread_quickreply_options_signature')."\";");
}

if(isset($mybb->user['emailnotify']) && $mybb->user['emailnotify'] == 1)

		{
$postoptionschecked['emailnotify'] = 'checked="checked"';
}

		{
$postoptionschecked['emailnotify'] = 'checked="checked"';
}

 


	    $posthash = md5($mybb->user['uid'].random_str());

	    $posthash = md5($mybb->user['uid'].random_str());

		

 
		eval("\$quickreply = \"".$templates->get("showthread_quickreply")."\";");

		eval("\$quickreply = \"".$templates->get("showthread_quickreply")."\";");

	}
else
{
$quickreply = "";

 
	}

// If the user is a moderator, show the moderation tools.
if($ismod)
{

	}

// If the user is a moderator, show the moderation tools.
if($ismod)
{

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



		$customthreadtools = $customposttools = '';

if(is_moderator($forum['fid'], "canusecustomtools") && (!empty($forum_stats[-1]['modtools']) || !empty($forum_stats[$forum['fid']]['modtools'])))

		{

		{

			$customthreadtools = $customposttools = '';


 
			switch($db->type)

			switch($db->type)

			{

			{

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

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

Zeile 1118Zeile 1157
				default:
$query = $db->simple_select("modtools", "tid, name, type", "CONCAT(',',forums,',') LIKE '%,$fid,%' OR CONCAT(',',forums,',') LIKE '%,-1,%' OR forums=''");
}

				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))

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

			{

			{

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

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

Zeile 1129Zeile 1168
				{
eval("\$customthreadtools .= \"".$templates->get("showthread_moderationoptions_custom_tool")."\";");
}

				{
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")."\";");

			}
}

			}
}


eval("\$inlinemod = \"".$templates->get("showthread_inlinemoderation")."\";");



eval("\$inlinemod = \"".$templates->get("showthread_inlinemoderation")."\";");


Zeile 1145Zeile 1184
		{
eval("\$customthreadtools = \"".$templates->get("showthread_moderationoptions_custom")."\";");
}

		{
eval("\$customthreadtools = \"".$templates->get("showthread_moderationoptions_custom")."\";");
}

 


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

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

 

if(!isset($lang->newthread_in))
{
$lang->newthread_in = '';
}


	$lang->newthread_in = $lang->sprintf($lang->newthread_in, $forum['name']);

// Subscription status
$add_remove_subscription = 'add';
$add_remove_subscription_text = $lang->subscribe_thread;

	$lang->newthread_in = $lang->sprintf($lang->newthread_in, $forum['name']);

// Subscription status
$add_remove_subscription = 'add';
$add_remove_subscription_text = $lang->subscribe_thread;





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

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

Zeile 1164Zeile 1210
		}
}


		}
}


 
	$classic_header = '';

	if($mybb->settings['postlayout'] == "classic")
{
eval("\$classic_header = \"".$templates->get("showthread_classic_header")."\";");

	if($mybb->settings['postlayout'] == "classic")
{
eval("\$classic_header = \"".$templates->get("showthread_classic_header")."\";");

Zeile 1195Zeile 1242
			{
++$guestcount;
}

			{
++$guestcount;
}

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

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

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

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

Zeile 1218Zeile 1265
				}
}
}

				}
}
}

 

$guestsonline = '';


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



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


 
		$onlinesep = '';

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

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

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


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


 
		$onlinesep2 = '';

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

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