Vergleich showthread.php - 1.8.7 - 1.8.23

  Keine Änderungen   Hinzugefügt   Modifiziert   Entfernt
Zeile 11Zeile 11
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_avatar,postbit_find,postbit_pm,postbit_www,postbit_email,postbit_edit,postbit_quote,postbit_report,postbit_signature,postbit_online,postbit_offline,postbit_away,showthread_ratethread";
$templatelist .= ",multipage,multipage_breadcrumb,multipage_end,multipage_jump_page,multipage_nextpage,multipage_page,multipage_page_current,multipage_page_link_current,multipage_prevpage,multipage_start,showthread_inlinemoderation_softdelete,showthread_inlinemoderation_restore,showthread_inlinemoderation_delete,postbit_posturl,postbit_icon";
$templatelist .= ",postbit_editedby,showthread_similarthreads,showthread_similarthreads_bit,postbit_iplogged_show,postbit_iplogged_hiden,postbit_profilefield,showthread_quickreply,showthread_add_poll,showthread_send_thread,showthread_poll_editpoll,showthread_poll_undovote,showthread_moderationoptions_standard,postbit_editedby_editreason";
$templatelist .= ",forumjump_advanced,forumjump_special,forumjump_bit,postbit_reputation,postbit_quickdelete,postbit_attachments,postbit_attachments_attachment,postbit_attachments_thumbnails,postbit_attachments_images_image,postbit_attachments_images,showthread_quickreply_options_stick,showthread_quickreply_options_close,attachment_icon";
$templatelist .= ",postbit_inlinecheck,showthread_inlinemoderation,postbit_attachments_thumbnails_thumbnail,postbit_ignored,postbit_groupimage,postbit_multiquote,showthread_search,showthread_moderationoptions_custom_tool,showthread_moderationoptions_custom,showthread_inlinemoderation_custom_tool,showthread_inlinemoderation_custom";
$templatelist .= ",showthread_usersbrowsing,showthread_usersbrowsing_user,showthread_poll_option_multiple,showthread_poll_option,showthread_poll,showthread_quickreply_options_signature,showthread_threaded_bitactive,showthread_threaded_bit,postbit_attachments_attachment_unapproved,showthread_threadnotes,showthread_threadnotes_viewnotes";
$templatelist .= ",showthread_moderationoptions_openclose,showthread_moderationoptions_stickunstick,showthread_moderationoptions_delete,showthread_moderationoptions_threadnotes,showthread_moderationoptions_manage,showthread_moderationoptions_deletepoll,showthread_threadnoteslink,showthread_poll_results,showthread_classic_header,postbit_warn";
$templatelist .= ",postbit_userstar,postbit_reputation_formatted_link,postbit_warninglevel_formatted,postbit_quickrestore,forumdisplay_password,forumdisplay_password_wrongpass,postbit_classic,postbit_purgespammer,showthread_inlinemoderation_approve,forumdisplay_thread_icon,showthread_poll_resultbit,postbit_warninglevel,postbit_gotopost";
$templatelist .= ",showthread_moderationoptions_softdelete,showthread_moderationoptions_restore,post_captcha,post_captcha_recaptcha,post_captcha_nocaptcha,showthread_moderationoptions,showthread_inlinemoderation_standard,showthread_threadedbox,postbit_rep_button,showthread_inlinemoderation_manage,global_moderation_notice";





$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";
$templatelist .= ",multipage,multipage_breadcrumb,multipage_end,multipage_jump_page,multipage_nextpage,multipage_page,multipage_page_current,multipage_page_link_current,multipage_prevpage,multipage_start,showthread_inlinemoderation_softdelete,showthread_poll_editpoll";
$templatelist .= ",postbit_editedby,showthread_similarthreads,showthread_similarthreads_bit,postbit_iplogged_show,postbit_iplogged_hiden,postbit_profilefield,showthread_quickreply,showthread_printthread,showthread_add_poll,showthread_send_thread,showthread_inlinemoderation_restore";
$templatelist .= ",forumjump_advanced,forumjump_special,forumjump_bit,postbit_attachments,postbit_attachments_attachment,postbit_attachments_thumbnails,postbit_attachments_images_image,postbit_attachments_images,showthread_quickreply_options_stick,postbit_status";
$templatelist .= ",postbit_inlinecheck,showthread_inlinemoderation,postbit_attachments_thumbnails_thumbnail,postbit_ignored,postbit_multiquote,showthread_moderationoptions_custom_tool,showthread_moderationoptions_custom,showthread_inlinemoderation_custom_tool";
$templatelist .= ",showthread_usersbrowsing,showthread_usersbrowsing_user,showthread_poll_option,showthread_poll,showthread_quickreply_options_signature,showthread_threaded_bitactive,showthread_threaded_bit,postbit_attachments_attachment_unapproved";
$templatelist .= ",showthread_moderationoptions_openclose,showthread_moderationoptions_stickunstick,showthread_moderationoptions_delete,showthread_moderationoptions_threadnotes,showthread_moderationoptions_manage,showthread_moderationoptions_deletepoll";
$templatelist .= ",postbit_userstar,postbit_reputation_formatted_link,postbit_warninglevel_formatted,postbit_quickrestore,forumdisplay_password,forumdisplay_password_wrongpass,postbit_purgespammer,showthread_inlinemoderation_approve,forumdisplay_thread_icon";
$templatelist .= ",showthread_moderationoptions_softdelete,showthread_moderationoptions_restore,post_captcha,post_captcha_recaptcha_invisible,post_captcha_nocaptcha,post_captcha_hcaptcha_invisible,post_captcha_hcaptcha,showthread_moderationoptions,showthread_inlinemoderation_standard,showthread_inlinemoderation_manage";
$templatelist .= ",showthread_ratethread,postbit_posturl,postbit_icon,postbit_editedby_editreason,attachment_icon,global_moderation_notice,showthread_poll_option_multiple,postbit_gotopost,postbit_rep_button,postbit_warninglevel,showthread_threadnoteslink";
$templatelist .= ",showthread_moderationoptions_approve,showthread_moderationoptions_unapprove,showthread_inlinemoderation_delete,showthread_moderationoptions_standard,showthread_quickreply_options_close,showthread_inlinemoderation_custom,showthread_search";
$templatelist .= ",postbit_profilefield_multiselect_value,postbit_profilefield_multiselect,showthread_subscription,postbit_deleted_member,postbit_away,postbit_warn,postbit_classic,postbit_reputation,postbit_deleted,postbit_offline,postbit_online,postbit_signature";
$templatelist .= ",postbit_editreason,postbit_quickdelete,showthread_threadnotes_viewnotes,showthread_threadedbox,showthread_poll_resultbit,showthread_poll_results,showthread_threadnotes,showthread_classic_header,showthread_poll_undovote,postbit_groupimage";


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


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

Zeile 52Zeile 56
			// post does not exist --> show corresponding error
error($lang->error_invalidpost);
}

			// post does not exist --> show corresponding error
error($lang->error_invalidpost);
}

		



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

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

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

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

 
}
$thread['username'] = htmlspecialchars_uni($thread['username']);

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

// Set here to fetch only approved/deleted posts (and then below for a moderator we change this).
if($forumpermissions['canviewdeletionnotice'] != 0)
{
$visibleonly = " AND visible IN (-1,1)";
$visibleonly2 = "AND p.visible IN (-1,1) AND t.visible IN (-1,1)";
}
else
{
$visibleonly = " AND visible=1";
$visibleonly2 = "AND p.visible=1 AND t.visible=1";

}

// Is the currently logged in user a moderator of this forum?

}

// Is the currently logged in user a moderator of this forum?

Zeile 119Zeile 138
	}
}
else

	}
}
else

{

{

	$ismod = false;

	$ismod = false;

	$visibleonly = " AND visible=1";
$visibleonly2 = "AND p.visible=1 AND t.visible=1";
}


}




// Make sure we are looking at a real thread here.
if(($thread['visible'] != 1 && $ismod == false) || ($thread['visible'] == 0 && !is_moderator($fid, "canviewunapprove")) || ($thread['visible'] == -1 && !is_moderator($fid, "canviewdeleted")))
{

// Make sure we are looking at a real thread here.
if(($thread['visible'] != 1 && $ismod == false) || ($thread['visible'] == 0 && !is_moderator($fid, "canviewunapprove")) || ($thread['visible'] == -1 && !is_moderator($fid, "canviewdeleted")))
{

	error($lang->error_invalidthread);





	// Allow viewing own unapproved thread
if (!($mybb->user['uid'] && $mybb->settings['showownunapproved'] && $thread['visible'] == 0 && ($thread['uid'] == $mybb->user['uid'])))
{
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)


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

Zeile 227Zeile 246
   }

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

   }

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

	$options = array(
"limit_start" => 0,
"limit" => 1,
"order_by" => "dateline",

	$options = array(
"limit_start" => 0,
"limit" => 1,
"order_by" => "dateline",

		"order_dir" => "asc"
);

		"order_dir" => "asc"
);





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

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

Zeile 248Zeile 267
			{
$string = "?";
}

			{
$string = "?";
}





			$highlight = $string."highlight=".$mybb->get_input('highlight');
}

			$highlight = $string."highlight=".$mybb->get_input('highlight');
}





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

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

	}

	}

	else
{
// show them to the last post

	else
{
// show them to the last post

Zeile 265Zeile 284
if($mybb->input['action'] == "lastpost")
{
if(my_strpos($thread['closed'], "moved|"))

if($mybb->input['action'] == "lastpost")
{
if(my_strpos($thread['closed'], "moved|"))

	{

	{

		$query = $db->query("
SELECT p.pid
FROM ".TABLE_PREFIX."posts p

		$query = $db->query("
SELECT p.pid
FROM ".TABLE_PREFIX."posts p

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

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


// Redirect to the proper page.
$pid = $db->fetch_field($query, "pid");
header("Location: ".htmlspecialchars_decode(get_post_link($pid, $nextthread['tid']))."#pid{$pid}");

	exit;
}


	exit;
}


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

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





$pid = $mybb->input['pid'] = $mybb->get_input('pid', MyBB::INPUT_INT);

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

$pid = $mybb->input['pid'] = $mybb->get_input('pid', MyBB::INPUT_INT);

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

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

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

	}

	}





	$query = $db->simple_select("forums", "threads, unapprovedthreads", "fid = '{$fid}'", array('limit' => 1));

	$query = $db->simple_select("forums", "threads, unapprovedthreads, deletedthreads", "fid = '{$fid}'", array('limit' => 1));

	$forum_threads = $db->fetch_array($query);
$threadcount = $forum_threads['threads'];


	$forum_threads = $db->fetch_array($query);
$threadcount = $forum_threads['threads'];


	if(is_moderator($fid, "canviewunapprove") == true)














if(is_moderator($fid, "canviewdeleted") == true || is_moderator($fid, "canviewunapprove") == true)
{
if(is_moderator($fid, "canviewdeleted") == true)
{
$threadcount += $forum_threads['deletedthreads'];
}
if(is_moderator($fid, "canviewunapprove") == true)
{
$threadcount += $forum_threads['unapprovedthreads'];
}
}
elseif($forumpermissions['canviewdeletionnotice'] != 0)

	{

	{

		$threadcount += $forum_threads['unapprovedthreads'];

		$threadcount += $forum_threads['deletedthreads'];

	}

// Limit to only our own threads

	}

// Limit to only our own threads

Zeile 432Zeile 463
// Show the entire thread (taking into account pagination).
if($mybb->input['action'] == "thread")
{

// Show the entire thread (taking into account pagination).
if($mybb->input['action'] == "thread")
{

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


	// This is a workaround to fix threads which data may get "corrupted" due to lag or other still unknown reasons
if($thread['firstpost'] == 0 || $thread['dateline'] == 0)

	{
update_first_post($tid);
}

	{
update_first_post($tid);
}

Zeile 450Zeile 482
		$now = TIME_NOW;

// If the poll or the thread is closed or if the poll is expired, show the results.

		$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($poll['closed'] == 1 || $thread['closed'] == 1 || ($expiretime < $now && $poll['timeout'] > 0) || $forumpermissions['canvotepolls'] != 1)

		{
$showresults = 1;
}


		{
$showresults = 1;
}


		// If the user is not a guest, check if he already voted.
if($mybb->user['uid'] != 0)

		if($forumpermissions['canvotepolls'] != 1)


		{

		{

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


			$nopermission = 1;
}

// Check if the user has voted before...
if($mybb->user['uid'])
{
$user_check = "uid='{$mybb->user['uid']}'";

		}
else
{

		}
else
{

			if(isset($mybb->cookies['pollvotes'][$poll['pid']]) && $mybb->cookies['pollvotes'][$poll['pid']] !== "")
{
$alreadyvoted = 1;
}





			$user_check = "uid='0' AND ipaddress=".$db->escape_binary($session->packedip);
}

$query = $db->simple_select("pollvotes", "*", "{$user_check} AND pid='".$poll['pid']."'");
while($votecheck = $db->fetch_array($query))
{
$alreadyvoted = 1;
$votedfor[$votecheck['voteoption']] = 1;

		}

		}

 


		$optionsarray = explode("||~|~||", $poll['options']);
$votesarray = explode("||~|~||", $poll['votes']);
$poll['question'] = htmlspecialchars_uni($poll['question']);
$polloptions = '';
$totalvotes = 0;
$poll['totvotes'] = 0;

		$optionsarray = explode("||~|~||", $poll['options']);
$votesarray = explode("||~|~||", $poll['votes']);
$poll['question'] = htmlspecialchars_uni($poll['question']);
$polloptions = '';
$totalvotes = 0;
$poll['totvotes'] = 0;





		for($i = 1; $i <= $poll['numoptions']; ++$i)
{
$poll['totvotes'] = $poll['totvotes'] + $votesarray[$i-1];

		for($i = 1; $i <= $poll['numoptions']; ++$i)
{
$poll['totvotes'] = $poll['totvotes'] + $votesarray[$i-1];

Zeile 522Zeile 559
			{
$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(isset($alreadyvoted) || isset($showresults))
{
if((int)$votes == "0")


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

				{

				{

					$percent = "0";

					$percent = "0";

				}

				}

				else
{
$percent = number_format($votes / $poll['totvotes'] * 100, 2);
}
$imagewidth = round($percent);
eval("\$polloptions .= \"".$templates->get("showthread_poll_resultbit")."\";");

				else
{
$percent = number_format($votes / $poll['totvotes'] * 100, 2);
}
$imagewidth = round($percent);
eval("\$polloptions .= \"".$templates->get("showthread_poll_resultbit")."\";");

			}

			}

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

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

Zeile 567Zeile 604
		{
eval("\$edit_poll = \"".$templates->get("showthread_poll_editpoll")."\";");
}

		{
eval("\$edit_poll = \"".$templates->get("showthread_poll_editpoll")."\";");
}





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

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

		if(isset($alreadyvoted) || isset($showresults))

		if(isset($alreadyvoted) || isset($showresults) || isset($nopermission))

		{
if($alreadyvoted)

		{
if($alreadyvoted)

			{

			{

				$pollstatus = $lang->already_voted;

				$pollstatus = $lang->already_voted;





$undovote = '';

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

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

					eval("\$pollstatus .= \"".$templates->get("showthread_poll_undovote")."\";");

					eval("\$undovote = \"".$templates->get("showthread_poll_undovote")."\";");

				}

				}

 
			}
elseif($nopermission)
{
$pollstatus = $lang->no_voting_permission;

			}
else
{
$pollstatus = $lang->poll_closed;
}

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

			$lang->total_votes = $lang->sprintf($lang->total_votes, $totalvotes);
eval("\$pollbox = \"".$templates->get("showthread_poll_results")."\";");
$plugins->run_hooks("showthread_poll_results");

Zeile 740Zeile 783
	elseif($ismod && is_moderator($fid, "canviewdeleted") == true && is_moderator($fid, "canviewunapprove") == true)
{
$visible = "AND p.visible IN (-1,0,1)";

	elseif($ismod && is_moderator($fid, "canviewdeleted") == true && is_moderator($fid, "canviewunapprove") == true)
{
$visible = "AND p.visible IN (-1,0,1)";

 
	}
elseif($forumpermissions['canviewdeletionnotice'] != 0 && $ismod == false)
{
$visible = "AND p.visible IN (-1,1)";

	}
else
{

	}
else
{

Zeile 815Zeile 862
			$where = " ORDER BY dateline LIMIT 0, 1";
}
$query = $db->query("

			$where = " ORDER BY dateline LIMIT 0, 1";
}
$query = $db->query("

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

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

			FROM ".TABLE_PREFIX."posts p

			FROM ".TABLE_PREFIX."posts p

 
			LEFT JOIN ".TABLE_PREFIX."reportedcontent r ON (r.id=p.pid AND r.type='post' AND r.reportstatus != 1)

			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)

			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)

Zeile 847Zeile 895
			}
}


			}
}


		// Build the threaded post display tree.
$query = $db->query("

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

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

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

        while($post = $db->fetch_array($query))
{
if(!$postsdone[$post['pid']])

        while($post = $db->fetch_array($query))
{
if(!$postsdone[$post['pid']])

Zeile 893Zeile 945
		if(!empty($mybb->input['pid']))
{
$post = get_post($mybb->input['pid']);

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

			if(empty($post) || ($post['visible'] == 0 && !is_moderator($post['fid'], 'canviewunapprove')) || ($post['visible'] == -1 && !is_moderator($post['fid'], 'canviewdeleted')))

			if(empty($post) || ($post['visible'] == 0 && !is_moderator($post['fid'], 'canviewunapprove')) || ($post['visible'] == -1 && !is_moderator($post['fid'], 'canviewdeleted') && $forumpermissions['canviewdeletionnotice'] == 0))

			{

			{

				$footer .= '<script type="text/javascript">$(document).ready(function() { $.jGrowl(\''.$lang->error_invalidpost.'\', {theme: \'jgrowl_error\'}); });</script>';

				$footer .= '<script type="text/javascript">$(function() { $.jGrowl(\''.$lang->error_invalidpost.'\', {theme: \'jgrowl_error\'}); });</script>';

			}
else
{

			}
else
{

Zeile 917Zeile 969
			}
}


			}
}


		// Recount replies if user is a moderator to take into account unapproved posts.
if($ismod)

		// Recount replies if user is a moderator or can see the deletion notice to take into account unapproved/deleted posts.
if($ismod || $forumpermissions['canviewdeletionnotice'] != 0)

		{
$query = $db->simple_select("posts p", "COUNT(*) AS replies", "p.tid='$tid' $visible");
$cached_replies = $thread['replies']+$thread['unapprovedposts']+$thread['deletedposts'];

		{
$query = $db->simple_select("posts p", "COUNT(*) AS replies", "p.tid='$tid' $visible");
$cached_replies = $thread['replies']+$thread['unapprovedposts']+$thread['deletedposts'];

Zeile 931Zeile 983
				require_once MYBB_ROOT."/inc/functions_rebuild.php";
rebuild_thread_counters($thread['tid']);
}

				require_once MYBB_ROOT."/inc/functions_rebuild.php";
rebuild_thread_counters($thread['tid']);
}

 
		}
elseif($forumpermissions['canviewdeletionnotice'] != 0)
{
$thread['replies'] += $thread['deletedposts'];

		}

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

		}

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





		if($mybb->get_input('page') == "last")
{
$page = $pages;

		if($mybb->get_input('page') == "last")
{
$page = $pages;

Zeile 964Zeile 1020
        if($mybb->seo_support == true)
{
if($mybb->get_input('highlight'))

        if($mybb->seo_support == true)
{
if($mybb->get_input('highlight'))

            {

            {

                $highlight = "?highlight=".urlencode($mybb->get_input('highlight'));
}


                $highlight = "?highlight=".urlencode($mybb->get_input('highlight'));
}


Zeile 1004Zeile 1060
        }

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

        }

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

 
		
// Allow originator to see own unapproved posts
if($mybb->user['uid'] && $mybb->settings['showownunapproved'])
{
$visible .= " OR (p.tid='$tid' AND p.visible='0' AND p.uid=".$mybb->user['uid'].")";
}


// Lets get the pids of the posts on this page.
$pids = "";


// Lets get the pids of the posts on this page.
$pids = "";

Zeile 1032Zeile 1094
				// Now lets fetch all of the attachments for these posts.
$query = $db->simple_select("attachments", "*", $pids);
while($attachment = $db->fetch_array($query))

				// 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;
}
}

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

Zeile 1046Zeile 1108
		// Get the actual posts from the database here.
$posts = '';
$query = $db->query("

		// Get the actual posts from the database here.
$posts = '';
$query = $db->query("

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

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

			FROM ".TABLE_PREFIX."posts p

			FROM ".TABLE_PREFIX."posts p

 
			LEFT JOIN ".TABLE_PREFIX."reportedcontent r ON (r.id=p.pid AND r.type='post' AND r.reportstatus != 1)

			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)

			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)

Zeile 1055Zeile 1118
			ORDER BY p.dateline
");
while($post = $db->fetch_array($query))

			ORDER BY p.dateline
");
while($post = $db->fetch_array($query))

		{

		{

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

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

Zeile 1077Zeile 1140
		}

switch($db->type)

		}

switch($db->type)

		{

		{

			case "pgsql":
$query = $db->query("
SELECT t.*, t.username AS threadusername, u.username

			case "pgsql":
$query = $db->query("
SELECT t.*, t.username AS threadusername, u.username

Zeile 1120Zeile 1183
			}
if(!$similar_thread['username'])
{

			}
if(!$similar_thread['username'])
{

				$similar_thread['username'] = $similar_thread['threadusername'];
$similar_thread['profilelink'] = $similar_thread['threadusername'];

				$similar_thread['username'] = $similar_thread['profilelink'] = htmlspecialchars_uni($similar_thread['threadusername']);


			}
else

			}
else

			{


			{
$similar_thread['username'] = htmlspecialchars_uni($similar_thread['username']);

				$similar_thread['profilelink'] = build_profile_link($similar_thread['username'], $similar_thread['uid']);

				$similar_thread['profilelink'] = build_profile_link($similar_thread['username'], $similar_thread['uid']);

			}


			}


			// If this thread has a prefix, insert a space between prefix and subject
if($similar_thread['prefix'] != 0)
{

			// If this thread has a prefix, insert a space between prefix and subject
if($similar_thread['prefix'] != 0)
{

Zeile 1146Zeile 1209
			$lastpostdate = my_date('relative', $similar_thread['lastpost']);
$lastposter = $similar_thread['lastposter'];
$lastposteruid = $similar_thread['lastposteruid'];

			$lastpostdate = my_date('relative', $similar_thread['lastpost']);
$lastposter = $similar_thread['lastposter'];
$lastposteruid = $similar_thread['lastposteruid'];





			// Don't link to guest's profiles (they have no profile).
if($lastposteruid == 0)

			// Don't link to guest's profiles (they have no profile).
if($lastposteruid == 0)

			{

			{

				$lastposterlink = $lastposter;
}
else
{
$lastposterlink = build_profile_link($lastposter, $lastposteruid);

				$lastposterlink = $lastposter;
}
else
{
$lastposterlink = build_profile_link($lastposter, $lastposteruid);

			}

			}

			$similar_thread['replies'] = my_number_format($similar_thread['replies']);
$similar_thread['views'] = my_number_format($similar_thread['views']);
eval("\$similarthreadbits .= \"".$templates->get("showthread_similarthreads_bit")."\";");

			$similar_thread['replies'] = my_number_format($similar_thread['replies']);
$similar_thread['views'] = my_number_format($similar_thread['views']);
eval("\$similarthreadbits .= \"".$templates->get("showthread_similarthreads_bit")."\";");

Zeile 1190Zeile 1253
		if($mybb->user['signature'])
{
$postoptionschecked['signature'] = 'checked="checked"';

		if($mybb->user['signature'])
{
$postoptionschecked['signature'] = 'checked="checked"';

		}


		}


		// Hide signature option if no permission
$option_signature = '';
if($mybb->usergroup['canusesig'] && !$mybb->user['suspendsignature'])

		// Hide signature option if no permission
$option_signature = '';
if($mybb->usergroup['canusesig'] && !$mybb->user['suspendsignature'])

Zeile 1200Zeile 1263
		}

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

		}

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

		{

		{

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

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

		}

		}


$trow = alt_trow();
if($thread['closed'] == 1)
{
$trow = 'trow_shaded';
}


$trow = alt_trow();
if($thread['closed'] == 1)
{
$trow = 'trow_shaded';
}





		$moderation_notice = '';
if(!is_moderator($forum['fid'], "canapproveunapproveposts"))
{

		$moderation_notice = '';
if(!is_moderator($forum['fid'], "canapproveunapproveposts"))
{

Zeile 1218Zeile 1281
				$moderation_text = $lang->moderation_forum_posts;
eval('$moderation_notice = "'.$templates->get('global_moderation_notice').'";');
}

				$moderation_text = $lang->moderation_forum_posts;
eval('$moderation_notice = "'.$templates->get('global_moderation_notice').'";');
}

			



			if($mybb->user['moderateposts'] == 1)
{
$moderation_text = $lang->moderation_user_posts;

			if($mybb->user['moderateposts'] == 1)
{
$moderation_text = $lang->moderation_user_posts;

Zeile 1226Zeile 1289
			}
}


			}
}


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


	    	$posthash = md5($mybb->user['uid'].random_str());
$expaltext = (in_array("quickreply", $collapse)) ? "[+]" : "[-]";

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


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


Zeile 1248Zeile 1312
				$thread['notes'] = my_substr($thread['notes'], 0, 200)."... {$viewnotes}";
}


				$thread['notes'] = my_substr($thread['notes'], 0, 200)."... {$viewnotes}";
}


 
			$expaltext = (in_array("threadnotes", $collapse)) ? "[+]" : "[-]";

			eval("\$threadnotesbox = \"".$templates->get("showthread_threadnotes")."\";");
}


			eval("\$threadnotesbox = \"".$templates->get("showthread_threadnotes")."\";");
}


Zeile 1271Zeile 1336
					foreach($gids as $gid)
{
$gid = (int)$gid;

					foreach($gids as $gid)
{
$gid = (int)$gid;

						$gidswhere .= " OR CONCAT(',',groups,',') LIKE '%,{$gid},%'";

						$gidswhere .= " OR CONCAT(',',`groups`,',') LIKE '%,{$gid},%'";

					}

					}

					$query = $db->simple_select("modtools", 'tid, name, type', "(CONCAT(',',forums,',') LIKE '%,$fid,%' OR CONCAT(',',forums,',') LIKE '%,-1,%' OR forums='') AND (groups='' OR CONCAT(',',groups,',') LIKE '%,-1,%'{$gidswhere})");

					$query = $db->simple_select("modtools", 'tid, name, type', "(CONCAT(',',forums,',') LIKE '%,$fid,%' OR CONCAT(',',forums,',') LIKE '%,-1,%' OR forums='') AND (`groups`='' OR CONCAT(',',`groups`,',') LIKE '%,-1,%'{$gidswhere})");

					break;
}

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

					break;
}

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

 
				$tool['name'] = htmlspecialchars_uni($tool['name']);

				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 1372Zeile 1438
		{
if($thread['visible'] == 0)
{

		{
if($thread['visible'] == 0)
{

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

				eval("\$approveunapprovethread = \"".$templates->get("showthread_moderationoptions_approve")."\";");

			}
else
{

			}
else
{

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

				eval("\$approveunapprovethread = \"".$templates->get("showthread_moderationoptions_unapprove")."\";");

			}
}


			}
}


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

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

 

eval("\$printthread = \"".$templates->get("showthread_printthread")."\";");


// Display 'send thread' link if permissions allow
$sendthread = '';
if($mybb->usergroup['cansendemail'] == 1)


// Display 'send thread' link if permissions allow
$sendthread = '';
if($mybb->usergroup['cansendemail'] == 1)

	{

	{

		eval("\$sendthread = \"".$templates->get("showthread_send_thread")."\";");
}


		eval("\$sendthread = \"".$templates->get("showthread_send_thread")."\";");
}


Zeile 1414Zeile 1482
	if(!$thread['poll'] && ($thread['uid'] == $mybb->user['uid'] || $ismod == true) && $forumpermissions['canpostpolls'] == 1 && $forum['open'] != 0 && $thread['closed'] != 1 && ($ismod == true || $thread['dateline'] > ($time-($mybb->settings['polltimelimit']*60*60)) || $mybb->settings['polltimelimit'] == 0))
{
eval("\$addpoll = \"".$templates->get("showthread_add_poll")."\";");

	if(!$thread['poll'] && ($thread['uid'] == $mybb->user['uid'] || $ismod == true) && $forumpermissions['canpostpolls'] == 1 && $forum['open'] != 0 && $thread['closed'] != 1 && ($ismod == true || $thread['dateline'] > ($time-($mybb->settings['polltimelimit']*60*60)) || $mybb->settings['polltimelimit'] == 0))
{
eval("\$addpoll = \"".$templates->get("showthread_add_poll")."\";");

	}

	}


// Subscription status
$add_remove_subscription = 'add';


// Subscription status
$add_remove_subscription = 'add';

Zeile 1429Zeile 1497
			$add_remove_subscription = 'remove';
$add_remove_subscription_text = $lang->unsubscribe_thread;
}

			$add_remove_subscription = 'remove';
$add_remove_subscription_text = $lang->unsubscribe_thread;
}

	}





eval("\$addremovesubscription = \"".$templates->get("showthread_subscription")."\";");
}


	$classic_header = '';
if($mybb->settings['postlayout'] == "classic")

	$classic_header = '';
if($mybb->settings['postlayout'] == "classic")

	{

	{

		eval("\$classic_header = \"".$templates->get("showthread_classic_header")."\";");
}


		eval("\$classic_header = \"".$templates->get("showthread_classic_header")."\";");
}


Zeile 1441Zeile 1511
	if($mybb->settings['browsingthisthread'] != 0)
{
$timecut = TIME_NOW - $mybb->settings['wolcutoff'];

	if($mybb->settings['browsingthisthread'] != 0)
{
$timecut = TIME_NOW - $mybb->settings['wolcutoff'];





		$comma = '';
$guestcount = 0;
$membercount = 0;
$inviscount = 0;
$onlinemembers = '';
$doneusers = array();

		$comma = '';
$guestcount = 0;
$membercount = 0;
$inviscount = 0;
$onlinemembers = '';
$doneusers = array();







$query = $db->simple_select("sessions", "COUNT(DISTINCT ip) AS guestcount", "uid = 0 AND time > $timecut AND location2 = $tid AND nopermission != 1");
$guestcount = $db->fetch_field($query, 'guestcount');


		$query = $db->query("

		$query = $db->query("

			SELECT s.ip, s.uid, s.time, u.username, u.invisible, u.usergroup, u.displaygroup
FROM ".TABLE_PREFIX."sessions s
LEFT JOIN ".TABLE_PREFIX."users u ON (s.uid=u.uid)
WHERE s.time > '$timecut' AND location2='$tid' AND nopermission != 1



			SELECT
s.ip, s.uid, s.time, u.username, u.invisible, u.usergroup, u.displaygroup
FROM
".TABLE_PREFIX."sessions s
LEFT JOIN ".TABLE_PREFIX."users u ON (s.uid=u.uid)
WHERE s.uid != 0 AND s.time > '$timecut' AND location2='$tid' AND nopermission != 1

			ORDER BY u.username ASC, s.time DESC
");

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

			ORDER BY u.username ASC, s.time DESC
");

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

		{
if($user['uid'] == 0)
{
++$guestcount;
}
else if(empty($doneusers[$user['uid']]) || $doneusers[$user['uid']] < $user['time'])

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





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

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

Zeile 1478Zeile 1549
				if($user['invisible'] != 1 || $mybb->usergroup['canviewwolinvis'] == 1 || $user['uid'] == $mybb->user['uid'])
{
$user['profilelink'] = get_profile_link($user['uid']);

				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['username'] = format_name(htmlspecialchars_uni($user['username']), $user['usergroup'], $user['displaygroup']);

					$user['reading'] = my_date($mybb->settings['timeformat'], $user['time']);

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

					$user['reading'] = my_date($mybb->settings['timeformat'], $user['time']);

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

Zeile 1489Zeile 1560

$guestsonline = '';
if($guestcount)


$guestsonline = '';
if($guestcount)

		{

		{

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

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

		}


		}


		$invisonline = '';
if($mybb->user['invisible'] == 1)

		$invisonline = '';
if($mybb->user['invisible'] == 1)

		{

		{

			// the user was counted as invisible user --> correct the inviscount
$inviscount -= 1;

			// the user was counted as invisible user --> correct the inviscount
$inviscount -= 1;

		}

		}

		if($inviscount && $mybb->usergroup['canviewwolinvis'] != 1)
{
$invisonline = $lang->sprintf($lang->users_browsing_forum_invis, $inviscount);

		if($inviscount && $mybb->usergroup['canviewwolinvis'] != 1)
{
$invisonline = $lang->sprintf($lang->users_browsing_forum_invis, $inviscount);

		}


		}


		$onlinesep = '';
if($invisonline != '' && $onlinemembers)
{
$onlinesep = $lang->comma;

		$onlinesep = '';
if($invisonline != '' && $onlinemembers)
{
$onlinesep = $lang->comma;

		}


		}


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

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





		eval("\$usersbrowsing = \"".$templates->get("showthread_usersbrowsing")."\";");

		eval("\$usersbrowsing = \"".$templates->get("showthread_usersbrowsing")."\";");

 
	}

if($thread['visible'] == -1 )
{
$thread_deleted = 1;

	}

$plugins->run_hooks("showthread_end");

	}

$plugins->run_hooks("showthread_end");

Zeile 1552Zeile 1628
				$post['subject'] = "[".$lang->no_subject."]";
}


				$post['subject'] = "[".$lang->no_subject."]";
}


 
			$post['username'] = htmlspecialchars_uni($post['username']);

			$post['profilelink'] = build_profile_link($post['username'], $post['uid']);

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

			$post['profilelink'] = build_profile_link($post['username'], $post['uid']);

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