<?php

/**

* MyBB 1.6

* Copyright 2010 MyBB Group, All Rights Reserved

*

* Website: http://mybb.com

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

*

* $Id$

*/

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_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 .= ",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 MYBB_ROOT."inc/functions_indicators.php";

require_once MYBB_ROOT."inc/class_parser.php";

$parser = new postParser;

// Load global language phrases

$lang->load("showthread");

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

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

{

$mybb->input['tid'] = $style['tid'];

unset($style['tid']); // stop the thread caching code from being tricked

}

else

{

$options = array(

"limit" => 1

);

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

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

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

}

}

// Get the thread details from the database.

$thread = get_thread($mybb->input['tid']);

// Get thread prefix if there is one.

$thread['threadprefix'] = '';

$thread['displayprefix'] = '';

if($thread['prefix'] != 0)

{

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

if($threadprefix['prefix'])

{

$thread['threadprefix'] = $threadprefix['prefix'].'&nbsp;';

$thread['displayprefix'] = $threadprefix['displaystyle'].'&nbsp;';

}

}

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).'...';

}

$reply_subject = htmlspecialchars_uni($reply_subject);

$tid = $thread['tid'];

$fid = $thread['fid'];

if(!$thread['username'])

{

$thread['username'] = $lang->guest;

}

$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')";

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

$ismod = true;

}

else

{

$ismod = false;

}

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

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

{

error($lang->error_invalidthread);

}

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

// Does the user have permission to view this thread?

if($forumpermissions['canview'] != 1 || $forumpermissions['canviewthreads'] != 1)

{

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

{

error($lang->error_invalidforum);

}

// 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(empty($mybb->input['action']))

{

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

}

// Jump to the unread posts.

if($mybb->input['action'] == "newpost")

{

// First, figure out what time the thread or forum were last read

$query = $db->simple_select("threadsread", "dateline", "uid='{$mybb->user['uid']}' AND tid='{$thread['tid']}'");

$thread_read = $db->fetch_field($query, "dateline");

if($mybb->settings['threadreadcut'] > 0 && $mybb->user['uid'])

{

$query = $db->simple_select("forumsread", "dateline", "fid='{$fid}' AND uid='{$mybb->user['uid']}'");

$forum_read = $db->fetch_field($query, "dateline");

$read_cutoff = TIME_NOW-$mybb->settings['threadreadcut']*60*60*24;

if($forum_read == 0 || $forum_read < $read_cutoff)

{

$forum_read = $read_cutoff;

}

}

else

{

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

}

if($mybb->settings['threadreadcut'] > 0 && $mybb->user['uid'] && $thread['lastpost'] > $forum_read)

{

$cutoff = TIME_NOW-$mybb->settings['threadreadcut']*60*60*24;

if($thread['lastpost'] > $cutoff)

{

if($thread_read)

{

$lastread = $thread_read;

}

else

{

// Set $lastread to zero to make sure 'lastpost' is invoked in the last IF

$lastread = 0;

}

}

}

if(!$lastread)

{

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

if($readcookie > $forum_read)

{

$lastread = $readcookie;

}

else

{

$lastread = $forum_read;

}

}

if($cutoff && $lastread < $cutoff)

{

$lastread = $cutoff;

}

// Next, find the proper pid to link to.

$options = array(

"limit_start" => 0,

"limit" => 1,

"order_by" => "dateline",

"order_dir" => "asc"

);

$lastread = intval($lastread);

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

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

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

{

$highlight = '';

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

{

$string = "&";

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

{

$string = "?";

}

$highlight = $string."highlight=".$mybb->input['highlight'];

}

header("Location: ".htmlspecialchars_decode(get_post_link($newpost['pid'], $tid)).$highlight."#pid{$newpost['pid']}");

}

else

{

// show them to the last post

$mybb->input['action'] = "lastpost";

}

}

// Jump to the last post.

if($mybb->input['action'] == "lastpost")

{

if(my_strpos($thread['closed'], "moved|"))

{

$query = $db->query("

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|%' {$visibleonly2}

ORDER BY p.dateline DESC

LIMIT 1

");

$pid = $db->fetch_field($query, "pid");

}

else

{

$options = array(

'order_by' => 'dateline',

'order_dir' => 'desc',

'limit_start' => 0,

'limit' => 1

);

$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}");

exit;

}

// Jump to the next newest posts.

if($mybb->input['action'] == "nextnewest")

{

$options = array(

"limit_start" => 0,

"limit" => 1,

"order_by" => "lastpost"

);

$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?

if(!$nextthread['tid'])

{

error($lang->error_nonextnewest);

}

$options = array(

"limit_start" => 0,

"limit" => 1,

"order_by" => "dateline",

"order_dir" => "desc"

);

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

// Redirect to the proper page.

$pid = $db->fetch_field($query, "pid");

header("Location: ".htmlspecialchars_decode(get_post_link($pid, $nextthread['tid']))."#pid{$pid}");

exit;

}

// Jump to the next oldest posts.

if($mybb->input['action'] == "nextoldest")

{

$options = array(

"limit" => 1,

"limit_start" => 0,

"order_by" => "lastpost",

"order_dir" => "desc"

);

$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?

if(!$nextthread['tid'])

{

error($lang->error_nonextoldest);

}

$options = array(

"limit_start" => 0,

"limit" => 1,

"order_by" => "dateline",

"order_dir" => "desc"

);

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

// Redirect to the proper page.

$pid = $db->fetch_field($query, "pid");

header("Location: ".htmlspecialchars_decode(get_post_link($pid, $nextthread['tid']))."#pid{$pid}");

exit;

}

if(!empty($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'])

{

$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");

// Show the entire thread (taking into account pagination).

if($mybb->input['action'] == "thread")

{

if($thread['firstpost'] == 0)

{

update_first_post($tid);

}

// Does this thread have a poll?

if($thread['poll'])

{

$options = array(

"limit" => 1

);

$query = $db->simple_select("polls", "*", "pid='".$thread['poll']."'", $options);

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

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

{

$showresults = 1;

}

// If the user is not a guest, check if he already voted.

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

{

$query = $db->simple_select("pollvotes", "*", "uid='".$mybb->user['uid']."' AND pid='".$poll['pid']."'");

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

{

$alreadyvoted = 1;

$votedfor[$votecheck['voteoption']] = 1;

}

}

else

{

if(isset($mybb->cookies['pollvotes'][$poll['pid']]) && $mybb->cookies['pollvotes'][$poll['pid']] !== "")

{

$alreadyvoted = 1;

}

}

$optionsarray = explode("||~|~||", $poll['options']);

$votesarray = explode("||~|~||", $poll['votes']);

$poll['question'] = htmlspecialchars_uni($poll['question']);

$polloptions = '';

$totalvotes = 0;

for($i = 1; $i <= $poll['numoptions']; ++$i)

{

$poll['totvotes'] = $poll['totvotes'] + $votesarray[$i-1];

}

// Loop through the poll options.

for($i = 1; $i <= $poll['numoptions']; ++$i)

{

// Set up the parser options.

$parser_options = array(

"allow_html" => $forum['allowhtml'],

"allow_mycode" => $forum['allowmycode'],

"allow_smilies" => $forum['allowsmilies'],

"allow_imgcode" => $forum['allowimgcode'],

"allow_videocode" => $forum['allowvideocode'],

"filter_badwords" => 1

);

$option = $parser->parse_message($optionsarray[$i-1], $parser_options);

$votes = $votesarray[$i-1];

$totalvotes += $votes;

$number = $i;

// Mark the option the user voted for.

if($votedfor[$number])

{

$optionbg = "trow2";

$votestar = "*";

}

else

{

$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(intval($votes) == "0")

{

$percent = "0";

}

else

{

$percent = number_format($votes / $poll['totvotes'] * 100, 2);

}

$imagewidth = round(($percent/3) * 5);

$imagerowwidth = $imagewidth + 10;

eval("\$polloptions .= \"".$templates->get("showthread_poll_resultbit")."\";");

}

else

{

if($poll['multiple'] == 1)

{

eval("\$polloptions .= \"".$templates->get("showthread_poll_option_multiple")."\";");

}

else

{

eval("\$polloptions .= \"".$templates->get("showthread_poll_option")."\";");

}

}

}

// If there are any votes at all, all votes together will be 100%; if there are no votes, all votes together will be 0%.

if($poll['totvotes'])

{

$totpercent = "100%";

}

else

{

$totpercent = "0%";

}

// Check if user is allowed to edit posts; if so, show "edit poll" link.

if(!is_moderator($fid, 'caneditposts'))

{

$edit_poll = '';

}

else

{

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

}

// Decide what poll status to show depending on the status of the poll and whether or not the user voted already.

if($alreadyvoted || $showresults)

{

if($alreadyvoted)

{

$pollstatus = $lang->already_voted;

if($mybb->usergroup['canundovotes'] == 1)

{

$pollstatus .= " [<a href=\"polls.php?action=do_undovote&amp;pid={$poll['pid']}&amp;my_post_key={$mybb->post_code}\">{$lang->undo_vote}</a>]";

}

}

else

{

$pollstatus = $lang->poll_closed;

}

$lang->total_votes = $lang->sprintf($lang->total_votes, $totalvotes);

eval("\$pollbox = \"".$templates->get("showthread_poll_results")."\";");

$plugins->run_hooks("showthread_poll_results");

}

else

{

$publicnote = '&nbsp;';

if($poll['public'] == 1)

{

$publicnote = $lang->public_note;

}

eval("\$pollbox = \"".$templates->get("showthread_poll")."\";");

$plugins->run_hooks("showthread_poll");

}

}

else

{

$pollbox = "";

}

// Create the forum jump dropdown box.

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

{

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

}

// Fetch some links

$next_oldest_link = get_thread_link($tid, 0, "nextoldest");

$next_newest_link = get_thread_link($tid, 0, "nextnewest");

// Mark this thread as read

mark_thread_read($tid, $fid);

// If the forum is not open, show closed newreply button unless the user is a moderator of this forum.

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)

{

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

}

else

{

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

}

}

// Create the admin tools dropdown box.

if($ismod == true)

{

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

if($pollbox)

{

$adminpolloptions = "<option value=\"deletepoll\">".$lang->delete_poll."</option>";

}

if($thread['visible'] != 1)

{

$approveunapprovethread = "<option value=\"approvethread\">".$lang->approve_thread."</option>";

}

else

{

$approveunapprovethread = "<option value=\"unapprovethread\">".$lang->unapprove_thread."</option>";

}

if($thread['closed'] == 1)

{

$closelinkch = ' checked="checked"';

}

if($thread['sticky'])

{

$stickch = ' checked="checked"';

}

$closeoption = "<br /><label><input type=\"checkbox\" class=\"checkbox\" name=\"modoptions[closethread]\" value=\"1\"{$closelinkch} />&nbsp;<strong>".$lang->close_thread."</strong></label>";

$closeoption .= "<br /><label><input type=\"checkbox\" class=\"checkbox\" name=\"modoptions[stickthread]\" value=\"1\"{$stickch} />&nbsp;<strong>".$lang->stick_thread."</strong></label>";

$inlinecount = "0";

$inlinecookie = "inlinemod_thread".$tid;

$plugins->run_hooks("showthread_ismod");

}

else

{

$modoptions = "&nbsp;";

$inlinemod = "";

}

// Increment the thread view.

if($mybb->settings['delayedthreadviews'] == 1)

{

$db->shutdown_query("INSERT INTO ".TABLE_PREFIX."threadviews (tid) VALUES('{$tid}')");

}

else

{

$db->shutdown_query("UPDATE ".TABLE_PREFIX."threads SET views=views+1 WHERE tid='{$tid}'");

}

++$thread['views'];

// Work out the thread rating for this thread.

$rating = '';

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

{

$rated = 0;

$lang->load("ratethread");

if($thread['numratings'] <= 0)

{

$thread['width'] = 0;

$thread['averagerating'] = 0;

$thread['numratings'] = 0;

}

else

{

$thread['averagerating'] = floatval(round($thread['totalratings']/$thread['numratings'], 2));

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

$thread['numratings'] = intval($thread['numratings']);

}

if($thread['numratings'])

{

// 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');

}

$not_rated = '';

if(!$rated)

{

$not_rated = ' star_rating_notrated';

}

$ratingvotesav = $lang->sprintf($lang->rating_average, $thread['numratings'], $thread['averagerating']);

eval("\$ratethread = \"".$templates->get("showthread_ratethread")."\";");

}

// Work out if we are showing unapproved posts as well (if the user is a moderator etc.)

if($ismod)

{

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

}

else

{

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

}

// Can this user perform searches? If so, we can show them the "Search thread" form

if($forumpermissions['cansearch'] != 0)

{

eval("\$search_thread = \"".$templates->get("showthread_search")."\";");

}

// Fetch the ignore list for the current user if they have one

$ignored_users = array();

if($mybb->user['uid'] > 0 && $mybb->user['ignorelist'] != "")

{

$ignore_list = explode(',', $mybb->user['ignorelist']);

foreach($ignore_list as $uid)

{

$ignored_users[$uid] = 1;

}

}

// Which thread mode is our user using by default?

if(!empty($mybb->user['threadmode']))

{

$defaultmode = $mybb->user['threadmode'];

}

else if($mybb->settings['threadusenetstyle'] == 1)

{

$defaultmode = 'threaded';

}

else

{

$defaultmode = 'linear';

}

// If mode is unset, set the default mode

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

{

$mybb->input['mode'] = $defaultmode;

}

// Threaded or linear display?

if($mybb->input['mode'] == 'threaded')

{

$isfirst = 1;

// Are we linked to a specific pid?

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

{

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

}

else

{

$where = " ORDER BY dateline LIMIT 0, 1";

}

$query = $db->query("

SELECT u.*, u.username AS userusername, p.*, f.*, eu.username AS editusername

FROM ".TABLE_PREFIX."posts p

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

LEFT JOIN ".TABLE_PREFIX."userfields f ON (f.ufid=u.uid)

LEFT JOIN ".TABLE_PREFIX."users eu ON (eu.uid=p.edituid)

WHERE p.tid='$tid' $visible $where

");

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

// Choose what pid to display.

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

{

$mybb->input['pid'] = $showpost['pid'];

}

// Is there actually a pid to display?

if(!$showpost['pid'])

{

error($lang->error_invalidpost);

}

$attachcache = array();

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

{

// Get the attachments for this post.

$query = $db->simple_select("attachments", "*", "pid=".$mybb->input['pid']);

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

{

$attachcache[$attachment['pid']][$attachment['aid']] = $attachment;

}

}

// Build the threaded post display tree.

$query = $db->query("

SELECT p.username, p.uid, p.pid, p.replyto, p.subject, p.dateline

FROM ".TABLE_PREFIX."posts p

WHERE p.tid='$tid'

$visible

ORDER BY p.dateline

");

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

{

if(!$postsdone[$post['pid']])

{

if($post['pid'] == $mybb->input['pid'] || ($isfirst && !$mybb->input['pid']))

{

$postcounter = count($postsdone);

$isfirst = 0;

}

$tree[$post['replyto']][$post['pid']] = $post;

$postsdone[$post['pid']] = 1;

}

}

$threadedbits = buildtree();

$posts = build_postbit($showpost);

eval("\$threadexbox = \"".$templates->get("showthread_threadedbox")."\";");

$plugins->run_hooks("showthread_threaded");

}

else // Linear display

{

$threadexbox = '';

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

{

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

}

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

$page = 1;

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

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

{

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

}

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

{

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

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

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

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

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

{

$page = $pages;

}

if($page > $pages || $page <= 0)

{

$page = 1;

}

if($page)

{

$start = ($page-1) * $perpage;

}

else

{

$start = 0;

$page = 1;

}

$upper = $start+$perpage;

// Work out if we have terms to highlight

$highlight = "";

$threadmode = "";

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

{

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

{

$highlight = "?highlight=".urlencode($mybb->input['highlight']);

}

if($defaultmode != "linear")

{

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

{

$threadmode = "&amp;mode=linear";

}

else

{

$threadmode = "?mode=linear";

}

}

}

else

{

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

{

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

{

foreach($mybb->input['highlight'] as $highlight_word)

{

$highlight .= "&amp;highlight[]=".urlencode($highlight_word);

}

}

else

{

$highlight = "&amp;highlight=".urlencode($mybb->input['highlight']);

}

}

if($defaultmode != "linear")

{

$threadmode = "&amp;mode=linear";

}

}

$multipage = multipage($postcount, $perpage, $page, str_replace("{tid}", $tid, THREAD_URL_PAGED.$highlight.$threadmode));

if($postcount > $perpage)

{

eval("\$threadpages = \"".$templates->get("showthread_multipage")."\";");

}

// Lets get the pids of the posts on this page.

$pids = "";

$comma = '';

$query = $db->simple_select("posts p", "p.pid", "p.tid='$tid' $visible", array('order_by' => 'p.dateline', 'limit_start' => $start, 'limit' => $perpage));

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

{

// 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(empty($pid))

{

$pid = $getid['pid'];

}

// Gather a comma separated list of post IDs

$pids .= "$comma'{$getid['pid']}'";

$comma = ",";

}

if($pids)

{

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

$attachcache = array();

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

{

// Now lets fetch all of the attachments for these posts.

$query = $db->simple_select("attachments", "*", $pids);

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

{

$attachcache[$attachment['pid']][$attachment['aid']] = $attachment;

}

}

}

else

{

// If there are no pid's the thread is probably awaiting approval.

error($lang->error_invalidthread);

}

// Get the actual posts from the database here.

$posts = '';

$query = $db->query("

SELECT u.*, u.username AS userusername, p.*, f.*, eu.username AS editusername

FROM ".TABLE_PREFIX."posts p

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

LEFT JOIN ".TABLE_PREFIX."userfields f ON (f.ufid=u.uid)

LEFT JOIN ".TABLE_PREFIX."users eu ON (eu.uid=p.edituid)

WHERE $pids

ORDER BY p.dateline

");

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

{

if($thread['firstpost'] == $post['pid'] && $thread['visible'] == 0)

{

$post['visible'] = 0;

}

$posts .= build_postbit($post);

$post = '';

}

$plugins->run_hooks("showthread_linear");

}

// Show the similar threads table if wanted.