Vergleich showthread.php - 1.8.2 - 1.8.38

  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,postbit_gotopost,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,showthread_inlinemoderation_manage";
$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,postbit_warninglevel";
$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_inlinemoderation_standard,showthread_quickreply_options_stick,showthread_quickreply_options_close";
$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,postbit_posturl,postbit_rep_button";
$templatelist .= ",showthread_usersbrowsing,showthread_usersbrowsing_user,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,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,showthread_moderationoptions,forumdisplay_thread_icon,showthread_poll_resultbit,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 33Zeile 38
if(!empty($mybb->input['pid']) && !isset($mybb->input['tid']))
{
// see if we already have the post information

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

	if(isset($style) && $style['pid'] == $mybb->get_input('pid', 1) && $style['tid'])

	if(isset($style) && $style['pid'] == $mybb->get_input('pid', MyBB::INPUT_INT) && $style['tid'])

	{
$mybb->input['tid'] = $style['tid'];
unset($style['tid']); // stop the thread caching code from being tricked

	{
$mybb->input['tid'] = $style['tid'];
unset($style['tid']); // stop the thread caching code from being tricked

Zeile 43Zeile 48
		$options = array(
"limit" => 1
);

		$options = array(
"limit" => 1
);

		$query = $db->simple_select("posts", "tid", "pid=".$mybb->get_input('pid', 1), $options);

		$query = $db->simple_select("posts", "fid,tid,visible", "pid=".$mybb->get_input('pid', MyBB::INPUT_INT), $options);

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

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

		
if(empty($post))











if(
empty($post) ||
(
$post['visible'] == 0 && !(
is_moderator($post['fid'], 'canviewunapprove') ||
($mybb->user['uid'] && $post['uid'] == $mybb->user['uid'] && $mybb->settings['showownunapproved'])
)
) ||
($post['visible'] == -1 && !is_moderator($post['fid'], 'canviewdeleted'))
)

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

// Get the thread details from the database.

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

// Get the thread details from the database.

$thread = get_thread($mybb->get_input('tid', 1));

$thread = get_thread($mybb->get_input('tid', MyBB::INPUT_INT));


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


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

Zeile 73Zeile 87

if(!empty($threadprefix['prefix']))
{


if(!empty($threadprefix['prefix']))
{

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

		$thread['threadprefix'] = htmlspecialchars_uni($threadprefix['prefix']).' ';

		$thread['displayprefix'] = $threadprefix['displaystyle'].' ';
}
}

		$thread['displayprefix'] = $threadprefix['displaystyle'].' ';
}
}

Zeile 92Zeile 106
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).
$visible_states = array("1");

if($forumpermissions['canviewdeletionnotice'] != 0)
{
$visible_states[] = "-1";

}

// Is the currently logged in user a moderator of this forum?
if(is_moderator($fid))
{
$ismod = true;

}

// Is the currently logged in user a moderator of this forum?
if(is_moderator($fid))
{
$ismod = true;

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

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

	{

	{

		if(is_moderator($fid, "canviewunapprove") == true && is_moderator($fid, "canviewdeleted") == false)
{
$visibleonly = " AND visible IN (0,1)";
$visibleonly2 = "AND p.visible IN (0,1) AND t.visible IN (0,1)";
}
elseif(is_moderator($fid, "canviewdeleted") == true && is_moderator($fid, "canviewunapprove") == false)
{
$visibleonly = " AND visible IN (-1,1)";
$visibleonly2 = "AND p.visible IN (-1,1) AND t.visible IN (-1,1)";
}
else
{
$visibleonly = " AND visible IN (-1,0,1)";
$visibleonly2 = "AND p.visible IN (-1,0,1) AND t.visible IN (-1,0,1)";
}

		$visible_states[] = "-1";
}
if(is_moderator($fid, "canviewunapprove") == true)
{
$visible_states[] = "0";











	}
}
else
{
$ismod = false;

	}
}
else
{
$ismod = false;

 
}

$visible_condition = "visible IN (".implode(',', array_unique($visible_states)).")";

// Allow viewing own unapproved threads for logged in users
if($mybb->user['uid'] && $mybb->settings['showownunapproved'])
{
$own_unapproved = ' AND (%1$s'.$visible_condition.' OR (%1$svisible=0 AND %1$suid='.(int)$mybb->user['uid'].'))';

$visibleonly = sprintf($own_unapproved, null);
$visibleonly_p = sprintf($own_unapproved, 'p.');
$visibleonly_p_t = sprintf($own_unapproved, 'p.').sprintf($own_unapproved, 't.');
}
else
{
$visibleonly = " AND ".$visible_condition;
$visibleonly_p = " AND p.".$visible_condition;
$visibleonly_p_t = "AND p.".$visible_condition." AND t.".$visible_condition;

}

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

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



{
// Allow viewing own unapproved thread
if (!($mybb->user['uid'] && $mybb->settings['showownunapproved'] && $thread['visible'] == 0 && ($thread['uid'] == $mybb->user['uid'])))
{
error($lang->error_invalidthread);
}
}


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

{
error_no_permission();

}

if(isset($forumpermissions['canonlyviewownthreads']) && $forumpermissions['canonlyviewownthreads'] == 1 && $thread['uid'] != $mybb->user['uid'])
{
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")

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

	error($lang->error_invalidforum);

}

}


$threadnoteslink = '';
if(is_moderator($fid, "canmanagethreads") && !empty($thread['notes']))


$threadnoteslink = '';
if(is_moderator($fid, "canmanagethreads") && !empty($thread['notes']))

Zeile 161Zeile 196

// If there is no specific action, we must be looking at the thread.
if(!$mybb->get_input('action'))


// If there is no specific action, we must be looking at the thread.
if(!$mybb->get_input('action'))

{

{

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

	$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

// Jump to the unread posts.
if($mybb->input['action'] == "newpost")
{
// First, figure out what time the thread or forum were last read

 
	$lastread = $cutoff = 0;

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

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

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

Zeile 181Zeile 217
		if($forum_read == 0 || $forum_read < $read_cutoff)
{
$forum_read = $read_cutoff;

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

		}

		}

	}
else

	}
else

	{

	{

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


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


Zeile 202Zeile 238
				// Set $lastread to zero to make sure 'lastpost' is invoked in the last IF
$lastread = 0;
}

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

		}

		}

	}

if(!$lastread)

	}

if(!$lastread)

Zeile 222Zeile 258
   {
$lastread = $cutoff;
}

   {
$lastread = $cutoff;
}





	// Next, find the proper pid to link to.
$options = array(
"limit_start" => 0,
"limit" => 1,

	// Next, find the proper pid to link to.
$options = array(
"limit_start" => 0,
"limit" => 1,

		"order_by" => "dateline",
"order_dir" => "asc"

		"order_by" => "dateline, pid",


	);

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


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

	if($newpost && $lastread)

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

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

Zeile 267Zeile 302
			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|%' {$visibleonly2}
ORDER BY p.dateline DESC

			WHERE t.fid='".$thread['fid']."' AND t.closed NOT LIKE 'moved|%' {$visibleonly_p_t}
ORDER BY p.dateline DESC, p.pid DESC

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

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

Zeile 276Zeile 311
	else
{
$options = array(

	else
{
$options = array(

			'order_by' => 'dateline',
'order_dir' => 'desc',

			'order_by' => 'dateline DESC, pid DESC',


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

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

Zeile 295Zeile 329
		"limit_start" => 0,
"limit" => 1,
"order_by" => "lastpost"

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

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

	// Are there actually next newest posts?

	if(!$nextthread['tid'])

	if(!$nextthread)

	{
error($lang->error_nonextnewest);
}
$options = array(
"limit_start" => 0,
"limit" => 1,

	{
error($lang->error_nonextnewest);
}
$options = array(
"limit_start" => 0,
"limit" => 1,

		"order_by" => "dateline",
"order_dir" => "desc"

		"order_by" => "dateline DESC, pid DESC",


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

	);
$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 331Zeile 364
	$nextthread = $db->fetch_array($query);

// Are there actually next oldest posts?

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

// Are there actually next oldest posts?

	if(!$nextthread['tid'])

	if(!$nextthread)

	{
error($lang->error_nonextoldest);
}
$options = array(
"limit_start" => 0,
"limit" => 1,

	{
error($lang->error_nonextoldest);
}
$options = array(
"limit_start" => 0,
"limit" => 1,

		"order_by" => "dateline",
"order_dir" => "desc"

		"order_by" => "dateline DESC, pid DESC",


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

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

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


$pid = $mybb->input['pid'] = $mybb->get_input('pid', 1);



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


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


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


Zeile 361Zeile 393
	if(!$mybb->settings['threadsperpage'] || (int)$mybb->settings['threadsperpage'] < 1)
{
$mybb->settings['threadsperpage'] = 20;

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

	}

$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 429Zeile 473
// 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 447Zeile 492
		$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 494Zeile 544
				"filter_badwords" => 1
);


				"filter_badwords" => 1
);


			if($mybb->user['showimages'] != 1 && $mybb->user['uid'] != 0 || $mybb->settings['guestimages'] != 1 && $mybb->user['uid'] == 0)

			if($mybb->user['uid'] != 0 && $mybb->user['showimages'] != 1 || $mybb->settings['guestimages'] != 1 && $mybb->user['uid'] == 0)

			{
$parser_options['allow_imgcode'] = 0;
}


			{
$parser_options['allow_imgcode'] = 0;
}


			if($mybb->user['showvideos'] != 1 && $mybb->user['uid'] != 0 || $mybb->settings['guestvideos'] != 1 && $mybb->user['uid'] == 0)

			if($mybb->user['uid'] != 0 && $mybb->user['showvideos'] != 1 || $mybb->settings['guestvideos'] != 1 && $mybb->user['uid'] == 0)

			{
$parser_options['allow_videocode'] = 0;
}

			{
$parser_options['allow_videocode'] = 0;
}

Zeile 512Zeile 562
			// Mark the option the user voted for.
if(!empty($votedfor[$number]))
{

			// Mark the option the user voted for.
if(!empty($votedfor[$number]))
{

				$optionbg = "trow2";

				$optionbg = "trow2 poll_votedfor";

				$votestar = "*";
}
else
{
$optionbg = "trow1";
$votestar = "";

				$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(isset($alreadyvoted) || isset($showresults))
{

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

Zeile 534Zeile 584
				}
$imagewidth = round($percent);
eval("\$polloptions .= \"".$templates->get("showthread_poll_resultbit")."\";");

				}
$imagewidth = round($percent);
eval("\$polloptions .= \"".$templates->get("showthread_poll_resultbit")."\";");

			}
else

			}
else

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

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

Zeile 566Zeile 616
		}

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



			$undovote = '';

if(isset($alreadyvoted))

			{
$pollstatus = $lang->already_voted;

			{
$pollstatus = $lang->already_voted;





				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(isset($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 610Zeile 667
	}

// Create the forum jump dropdown box.

	}

// Create the forum jump dropdown box.

 
	$forumjump = '';

	if($mybb->settings['enableforumjump'] != 0)
{
$forumjump = build_forum_jump("", $fid, 1);

	if($mybb->settings['enableforumjump'] != 0)
{
$forumjump = build_forum_jump("", $fid, 1);

Zeile 632Zeile 690
		}

// Show the appropriate reply button if this thread is open or closed

		}

// Show the appropriate reply button if this thread is open or closed

		if($forumpermissions['canpostreplys'] != 0 && $mybb->user['suspendposting'] != 1 && ($thread['closed'] != 1 || is_moderator($fid, "canpostclosedthreads")) && ($thread['uid'] == $mybb->user['uid'] || $forumpermissions['canonlyreplyownthreads'] != 1))

		if($forumpermissions['canpostreplys'] != 0 && $mybb->user['suspendposting'] != 1 && ($thread['closed'] != 1 || is_moderator($fid, "canpostclosedthreads")) && ($thread['uid'] == $mybb->user['uid'] || empty($forumpermissions['canonlyreplyownthreads'])))

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

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

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

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

		$closelinkch = $stickch = '';

		$closeoption = $closelinkch = $stickch = '';


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


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

Zeile 679Zeile 737
	}

// Increment the thread view.

	}

// Increment the thread view.

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













	if(
(
$mybb->user['uid'] == 0 &&
(
($session->is_spider == true && $mybb->settings['threadviews_countspiders'] == 1) ||
($session->is_spider == false && $mybb->settings['threadviews_countguests'] == 1)
)
) ||
(
$mybb->user['uid'] != 0 &&
($mybb->settings['threadviews_countthreadauthor'] == 1 || $mybb->user['uid'] != $thread['uid'])
)
)

	{

	{

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





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

	}

	}

	++$thread['views'];

 

// Work out the thread rating for this thread.


// Work out the thread rating for this thread.

	$rating = '';

	$rating = $ratethread = '';

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

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

Zeile 718Zeile 791

$not_rated = '';
if(!$rated)


$not_rated = '';
if(!$rated)

		{

		{

			$not_rated = ' star_rating_notrated';
}

			$not_rated = ' star_rating_notrated';
}





		$ratingvotesav = $lang->sprintf($lang->rating_average, $thread['numratings'], $thread['averagerating']);
eval("\$ratethread = \"".$templates->get("showthread_ratethread")."\";");

		$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 && is_moderator($fid, "canviewdeleted") == true && is_moderator($fid, "canviewunapprove") == false)
{
$visible = "AND p.visible IN (-1,1)";
}
elseif($ismod && is_moderator($fid, "canviewdeleted") == false && is_moderator($fid, "canviewunapprove") == true)
{
$visible = "AND p.visible IN (0,1)";
}
elseif($ismod && is_moderator($fid, "canviewdeleted") == true && is_moderator($fid, "canviewunapprove") == true)
{
$visible = "AND p.visible IN (-1,0,1)";
}
else
{
$visible = "AND p.visible='1'";
}


	}



















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

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

 
	$search_thread='';

	if($forumpermissions['cansearch'] != 0)
{
eval("\$search_thread = \"".$templates->get("showthread_search")."\";");

	if($forumpermissions['cansearch'] != 0)
{
eval("\$search_thread = \"".$templates->get("showthread_search")."\";");

Zeile 758Zeile 815
		{
$ignored_users[$uid] = 1;
}

		{
$ignored_users[$uid] = 1;
}

	}

// Fetch profile fields to display on postbit
$pfcache = $cache->read('profilefields');

if(is_array($pfcache))
{
foreach($pfcache as $profilefield)
{
if($profilefield['postbit'] != 1)
{
continue;
}

$profile_fields[$profilefield['fid']] = $profilefield;
}
}

	}


















// Which thread mode is our user using by default?
if(!empty($mybb->user['threadmode']))


// Which thread mode is our user using by default?
if(!empty($mybb->user['threadmode']))

	{

	{

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

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

	}

	}

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

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

	{

	{

		$defaultmode = 'threaded';

		$defaultmode = 'threaded';

	}

	}

	else
{
$defaultmode = 'linear';

	else
{
$defaultmode = 'linear';

	}

	}


// If mode is unset, set the default mode
if(!isset($mybb->input['mode']))


// If mode is unset, set the default mode
if(!isset($mybb->input['mode']))

	{

	{

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


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


Zeile 800Zeile 841
	$threadexbox = '';
if($mybb->get_input('mode') == 'threaded')
{

	$threadexbox = '';
if($mybb->get_input('mode') == 'threaded')
{

 
		$thread_toggle = 'linear';

		$isfirst = 1;

// Are we linked to a specific pid?
if($mybb->input['pid'])
{
$where = "AND p.pid='".$mybb->input['pid']."'";

		$isfirst = 1;

// Are we linked to a specific pid?
if($mybb->input['pid'])
{
$where = "AND p.pid='".$mybb->input['pid']."'";

		}
else

		}
else

		{

		{

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

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

		}
$query = $db->query("

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

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

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

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

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

 

// Is there actually a pid to display?
if(!$showpost)
{
error($lang->error_invalidpost);
}


// Choose what pid to display.
if(!$mybb->input['pid'])
{
$mybb->input['pid'] = $showpost['pid'];


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

		}

$attachcache = array();

Zeile 843Zeile 886
				$attachcache[$attachment['pid']][$attachment['aid']] = $attachment;
}
}

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

 

$multipage = '';


// 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
");
while($post = $db->fetch_array($query))
{
if(!$postsdone[$post['pid']])
{
if($post['pid'] == $mybb->input['pid'] || ($isfirst && !$mybb->input['pid']))
{


			SELECT p.username, p.uid, p.pid, p.replyto, p.subject, p.dateline
FROM ".TABLE_PREFIX."posts p
WHERE p.tid='$tid'
$visibleonly_p
ORDER BY p.dateline, p.pid
");
$postsdone = array();
while($post = $db->fetch_array($query))
{
if(empty($postsdone[$post['pid']]))
{
if($post['pid'] == $mybb->input['pid'] || ($isfirst && !$mybb->input['pid']))
{

					$postcounter = count($postsdone);

					$postcounter = count($postsdone);

                    $isfirst = 0;
}
$tree[$post['replyto']][$post['pid']] = $post;
$postsdone[$post['pid']] = 1;
}
}

					$isfirst = 0;
}
$tree[$post['replyto']][$post['pid']] = $post;
$postsdone[$post['pid']] = 1;
}
}


$threadedbits = buildtree();
$posts = build_postbit($showpost);


$threadedbits = buildtree();
$posts = build_postbit($showpost);

Zeile 873Zeile 919
	}
else // Linear display
{

	}
else // Linear display
{

 
		$thread_toggle = 'threaded';

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

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

Zeile 882Zeile 929
		// Figure out if we need to display multiple pages.
$page = 1;
$perpage = $mybb->settings['postsperpage'];

		// Figure out if we need to display multiple pages.
$page = 1;
$perpage = $mybb->settings['postsperpage'];

		if($mybb->get_input('page', 1) && $mybb->get_input('page') != "last")

		if($mybb->get_input('page', MyBB::INPUT_INT) && $mybb->get_input('page') != "last")

		{

		{

			$page = $mybb->get_input('page', 1);

			$page = $mybb->get_input('page', MyBB::INPUT_INT);

		}

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

		}

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

		{

		{

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

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

			if($post)














			if(
empty($post) ||
(
$post['visible'] == 0 && !(
is_moderator($post['fid'], 'canviewunapprove') ||
($mybb->user['uid'] && $post['uid'] == $mybb->user['uid'] && $mybb->settings['showownunapproved'])
)
) ||
($post['visible'] == -1 && !is_moderator($post['fid'], 'canviewdeleted') && $forumpermissions['canviewdeletionnotice'] == 0)
)
{
$footer .= '<script type="text/javascript">$(function() { $.jGrowl(\''.$lang->error_invalidpost.'\', {theme: \'jgrowl_error\'}); });</script>';
}
else

			{
$query = $db->query("
SELECT COUNT(p.dateline) AS count FROM ".TABLE_PREFIX."posts p
WHERE p.tid = '{$tid}'
AND p.dateline <= '{$post['dateline']}'

			{
$query = $db->query("
SELECT COUNT(p.dateline) AS count FROM ".TABLE_PREFIX."posts p
WHERE p.tid = '{$tid}'
AND p.dateline <= '{$post['dateline']}'

					{$visible}

					{$visibleonly_p}

				");
$result = $db->fetch_field($query, "count");
if(($result % $perpage) == 0)

				");
$result = $db->fetch_field($query, "count");
if(($result % $perpage) == 0)

				{

				{

					$page = $result / $perpage;
}
else
{
$page = (int)($result / $perpage) + 1;

					$page = $result / $perpage;
}
else
{
$page = (int)($result / $perpage) + 1;

				}
}
}

// 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($visible_states != array("1"))

		{

		{

			$query = $db->simple_select("posts p", "COUNT(*) AS replies", "p.tid='$tid' $visible");

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

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

 

$query = $db->simple_select("posts p", "COUNT(*) AS replies", "p.tid='$tid' $visibleonly_p");

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

			if(in_array('-1', $visible_states) && in_array('0', $visible_states))



			{

			{

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






				// 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 = (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 937Zeile 1001

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


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

			$page = 1;
}

if($page)
{

			$page = 1;
}

if($page)
{

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

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

		}
else

		}
else

		{
$start = 0;
$page = 1;

		{
$start = 0;
$page = 1;

		}

		}

		$upper = $start+$perpage;

// Work out if we have terms to highlight

		$upper = $start+$perpage;

// Work out if we have terms to highlight

        $highlight = "";
$threadmode = "";
if($mybb->seo_support == true)
{
if($mybb->get_input('highlight'))
{
$highlight = "?highlight=".urlencode($mybb->get_input('highlight'));
}

		$highlight = "";
$threadmode = "";
if($mybb->seo_support == true)
{
if($mybb->get_input('highlight'))
{
$highlight = "?highlight=".urlencode($mybb->get_input('highlight'));
}


if($defaultmode != "linear")
{


if($defaultmode != "linear")
{

	            if($mybb->get_input('highlight'))
{
$threadmode = "&amp;mode=linear";
}
else
{
$threadmode = "?mode=linear";
}

				if($mybb->get_input('highlight'))
{
$threadmode = "&amp;mode=linear";
}
else
{
$threadmode = "?mode=linear";
}

			}

			}

        }
else
{

		}
else
{

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

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

Zeile 990Zeile 1054
				}
}


				}
}


            if($defaultmode != "linear")
{
$threadmode = "&amp;mode=linear";
}
}

			if($defaultmode != "linear")
{
$threadmode = "&amp;mode=linear";
}
}





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


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


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

		$query = $db->simple_select("posts p", "p.pid", "p.tid='$tid' $visibleonly_p", array('order_by' => 'p.dateline, p.pid', '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

		while($getid = $db->fetch_array($query))
{
// Set the ID of the first post on page to $pid if it doesn't hold any value

Zeile 1027Zeile 1091
				while($attachment = $db->fetch_array($query))
{
$attachcache[$attachment['pid']][$attachment['aid']] = $attachment;

				while($attachment = $db->fetch_array($query))
{
$attachcache[$attachment['pid']][$attachment['aid']] = $attachment;

				}

				}

			}
}
else

			}
}
else

Zeile 1039Zeile 1103
		// 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)
WHERE $pids

			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

			ORDER BY p.dateline, p.pid

		");
while($post = $db->fetch_array($query))
{

		");
while($post = $db->fetch_array($query))
{

Zeile 1058Zeile 1123
		}
$plugins->run_hooks("showthread_linear");
}

		}
$plugins->run_hooks("showthread_linear");
}

 
	$lang->thread_toggle = $lang->{$thread_toggle};


// Show the similar threads table if wanted.
$similarthreads = '';
if($mybb->settings['showsimilarthreads'] != 0)
{
$own_perm = '';


// Show the similar threads table if wanted.
$similarthreads = '';
if($mybb->settings['showsimilarthreads'] != 0)
{
$own_perm = '';

		if($forumpermissions['canonlyviewownthreads'] == 1)

		if(isset($forumpermissions['canonlyviewownthreads']) && $forumpermissions['canonlyviewownthreads'] == 1)

		{
$own_perm = " AND t.uid={$mybb->user['uid']}";
}

		{
$own_perm = " AND t.uid={$mybb->user['uid']}";
}

Zeile 1077Zeile 1143
					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{$own_perm}

					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{$own_perm}

					ORDER BY t.lastpost DESC

					ORDER BY t.lastpost DESC

					OFFSET 0 LIMIT {$mybb->settings['similarlimit']}
");
break;

					OFFSET 0 LIMIT {$mybb->settings['similarlimit']}
");
break;

Zeile 1102Zeile 1168
			if($similar_thread['icon'] > 0 && $icon_cache[$similar_thread['icon']])
{
$icon = $icon_cache[$similar_thread['icon']];

			if($similar_thread['icon'] > 0 && $icon_cache[$similar_thread['icon']])
{
$icon = $icon_cache[$similar_thread['icon']];

 
				$icon['path'] = str_replace("{theme}", $theme['imgdir'], $icon['path']);
$icon['path'] = htmlspecialchars_uni($icon['path']);
$icon['name'] = htmlspecialchars_uni($icon['name']);

				eval("\$icon = \"".$templates->get("forumdisplay_thread_icon")."\";");
}
else
{
$icon = "&nbsp;";
}

				eval("\$icon = \"".$templates->get("forumdisplay_thread_icon")."\";");
}
else
{
$icon = "&nbsp;";
}

			if(!$similar_thread['username'])
{
$similar_thread['username'] = $similar_thread['threadusername'];
$similar_thread['profilelink'] = $similar_thread['threadusername'];
}
else
{
$similar_thread['profilelink'] = build_profile_link($similar_thread['username'], $similar_thread['uid']);
}

			if(!$similar_thread['username'])
{
$similar_thread['username'] = $similar_thread['profilelink'] = htmlspecialchars_uni($similar_thread['threadusername']);
}
else
{
$similar_thread['username'] = htmlspecialchars_uni($similar_thread['username']);
$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)

			{

			{

				$prefix = build_prefixes($similar_thread['prefix']);
if(!empty($prefix))
{
$similar_thread['threadprefix'] = $prefix['displaystyle'].'&nbsp;';
}

				$prefix = build_prefixes($similar_thread['prefix']);
if(!empty($prefix))
{
$similar_thread['threadprefix'] = $prefix['displaystyle'].'&nbsp;';
}

 
			}
else
{
$similar_thread['threadprefix'] = '';

			}

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

			}

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

Zeile 1158Zeile 1231

// Decide whether or not to show quick reply.
$quickreply = '';


// Decide whether or not to show quick reply.
$quickreply = '';

	if($forumpermissions['canpostreplys'] != 0 && $mybb->user['suspendposting'] != 1 && ($thread['closed'] != 1 || is_moderator($fid, "canpostclosedthreads")) && $mybb->settings['quickreply'] != 0 && $mybb->user['showquickreply'] != '0' && $forum['open'] != 0 && ($thread['uid'] == $mybb->user['uid'] || $forumpermissions['canonlyreplyownthreads'] != 1))

	if($forumpermissions['canpostreplys'] != 0 && $mybb->user['suspendposting'] != 1 && ($thread['closed'] != 1 || is_moderator($fid, "canpostclosedthreads")) && $mybb->settings['quickreply'] != 0 && $mybb->user['showquickreply'] != '0' && $forum['open'] != 0 && ($thread['uid'] == $mybb->user['uid'] || empty($forumpermissions['canonlyreplyownthreads'])))

	{
$query = $db->simple_select("posts", "pid", "tid='{$tid}'", array("order_by" => "pid", "order_dir" => "desc", "limit" => 1));
$last_pid = $db->fetch_field($query, "pid");

	{
$query = $db->simple_select("posts", "pid", "tid='{$tid}'", array("order_by" => "pid", "order_dir" => "desc", "limit" => 1));
$last_pid = $db->fetch_field($query, "pid");

Zeile 1208Zeile 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 1216Zeile 1289
			}
}


			}
}


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
















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

if(!isset($collapsedthead['quickreply']))
{
$collapsedthead['quickreply'] = '';
}
if(!isset($collapsedimg['quickreply']))
{
$collapsedimg['quickreply'] = '';
}
if(!isset($collapsed['quickreply_e']))
{
$collapsed['quickreply_e'] = '';
}

$expaltext = (in_array("quickreply", $collapse)) ? $lang->expcol_expand : $lang->expcol_collapse;

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

$moderationoptions = '';

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

$moderationoptions = '';

 
	$threadnotesbox = $viewnotes = '';


// If the user is a moderator, show the moderation tools.
if($ismod)
{
$customthreadtools = $customposttools = $standardthreadtools = $standardposttools = '';



// If the user is a moderator, show the moderation tools.
if($ismod)
{
$customthreadtools = $customposttools = $standardthreadtools = $standardposttools = '';


		$threadnotesbox = $viewnotes = '';

 
		if(!empty($thread['notes']))
{
$thread['notes'] = nl2br(htmlspecialchars_uni($thread['notes']));

		if(!empty($thread['notes']))
{
$thread['notes'] = nl2br(htmlspecialchars_uni($thread['notes']));

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


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


 
			if(!isset($collapsedthead['threadnotes']))
{
$collapsedthead['threadnotes'] = '';
}
if(!isset($collapsedimg['threadnotes']))
{
$collapsedimg['threadnotes'] = '';
}
if(!isset($collapsed['threadnotes_e']))
{
$collapsed['threadnotes_e'] = '';
}

$expaltext = (in_array("threadnotes", $collapse)) ? $lang->expcol_expand : $lang->expcol_collapse;

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

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

		}

		}


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


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

 
			$gids = explode(',', $mybb->user['additionalgroups']);
$gids[] = $mybb->user['usergroup'];
$gids = array_filter(array_unique($gids));
$gidswhere = '';

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

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

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






					foreach($gids as $gid)
{
$gid = (int)$gid;
$gidswhere .= " OR ','||groups||',' LIKE '%,{$gid},%'";
}
$query = $db->simple_select("modtools", 'tid, name, type', "(','||forums||',' LIKE '%,$fid,%' OR ','||forums||',' LIKE '%,-1,%' OR forums='') AND (groups='' OR ','||groups||',' LIKE '%,-1,%'{$gidswhere})");

					break;
default:

					break;
default:

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






					foreach($gids as $gid)
{
$gid = (int)$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})");

					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 1283Zeile 1400
		if(is_moderator($forum['fid'], "canrestoreposts"))
{
eval("\$inlinemodrestore = \"".$templates->get("showthread_inlinemoderation_restore")."\";");

		if(is_moderator($forum['fid'], "canrestoreposts"))
{
eval("\$inlinemodrestore = \"".$templates->get("showthread_inlinemoderation_restore")."\";");

		}

		}


if(is_moderator($forum['fid'], "candeleteposts"))
{


if(is_moderator($forum['fid'], "candeleteposts"))
{

Zeile 1321Zeile 1438

if(is_moderator($forum['fid'], "canopenclosethreads"))
{


if(is_moderator($forum['fid'], "canopenclosethreads"))
{

 
			if($thread['closed'])
{
$lang->open_close_thread = $lang->open_thread;
}
else
{
$lang->open_close_thread = $lang->close_thread;
}

			eval("\$openclosethread = \"".$templates->get("showthread_moderationoptions_openclose")."\";");
}

if(is_moderator($forum['fid'], "canstickunstickthreads"))
{

			eval("\$openclosethread = \"".$templates->get("showthread_moderationoptions_openclose")."\";");
}

if(is_moderator($forum['fid'], "canstickunstickthreads"))
{

 
			if($thread['sticky'])
{
$lang->stick_unstick_thread = $lang->unstick_thread;
}
else
{
$lang->stick_unstick_thread = $lang->stick_thread;
}

			eval("\$stickunstickthread = \"".$templates->get("showthread_moderationoptions_stickunstick")."\";");
}


			eval("\$stickunstickthread = \"".$templates->get("showthread_moderationoptions_stickunstick")."\";");
}


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

			}
}


			}
}


		if(is_moderator($forum['fid'], "cansoftdeletethreads"))

		if(is_moderator($forum['fid'], "cansoftdeletethreads") && $thread['visible'] != -1)

		{

		{

			if($thread['visible'] == -1)
{
$softdeletethread = "<option value=\"restorethread\">".$lang->restore_thread."</option>";
}
else
{
$softdeletethread = "<option value=\"softdeletethread\">".$lang->soft_delete_thread."</option>";
}
}


			eval("\$softdeletethread = \"".$templates->get("showthread_moderationoptions_softdelete")."\";");
}
elseif(is_moderator($forum['fid'], "canrestorethreads") && $thread['visible'] == -1)
{
eval("\$softdeletethread = \"".$templates->get("showthread_moderationoptions_restore")."\";");
}





		if(!empty($openclosethread) || !empty($stickunstickthread) || !empty($deletethread) || !empty($managethread) || !empty($adminpolloptions) || !empty($approveunapprovethread) || !empty($softdeletethread))
{
eval("\$standardthreadtools = \"".$templates->get("showthread_moderationoptions_standard")."\";");

		if(!empty($openclosethread) || !empty($stickunstickthread) || !empty($deletethread) || !empty($managethread) || !empty($adminpolloptions) || !empty($approveunapprovethread) || !empty($softdeletethread))
{
eval("\$standardthreadtools = \"".$templates->get("showthread_moderationoptions_standard")."\";");

Zeile 1378Zeile 1508
		if(!empty($standardthreadtools) || !empty($customthreadtools))
{
eval("\$moderationoptions = \"".$templates->get("showthread_moderationoptions")."\";");

		if(!empty($standardthreadtools) || !empty($customthreadtools))
{
eval("\$moderationoptions = \"".$templates->get("showthread_moderationoptions")."\";");

		}
}



		}
}

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


// Display 'send thread' link if permissions allow
$sendthread = '';


// Display 'send thread' link if permissions allow
$sendthread = '';

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


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


		if($db->fetch_field($query, 'tid'))

		if($db->num_rows($query) > 0)

		{
$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")."\";");
}
else
{
$addremovesubscription = '';

	}

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

	}

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

	}


	}


	// Get users viewing this thread

	// Get users viewing this thread

 
	$usersbrowsing='';

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

$invisiblemark = '';
if($user['invisible'] == 1)

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

$invisiblemark = '';
if($user['invisible'] == 1)

				{

				{

					$invisiblemark = "*";
++$inviscount;
}

					$invisiblemark = "*";
++$inviscount;
}





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

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





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

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

		}

		}


$guestsonline = '';
if($guestcount)


$guestsonline = '';
if($guestcount)

		{

		{

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


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


Zeile 1478Zeile 1618
		{
// 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)

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

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

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


$onlinesep = '';
if($invisonline != '' && $onlinemembers)


$onlinesep = '';
if($invisonline != '' && $onlinemembers)

		{

		{

			$onlinesep = $lang->comma;

			$onlinesep = $lang->comma;

		}


		}


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

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

Zeile 1497Zeile 1637
		}

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

		}

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

 
	}

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

	}

$plugins->run_hooks("showthread_end");

	}

$plugins->run_hooks("showthread_end");

Zeile 1504Zeile 1650
	eval("\$showthread = \"".$templates->get("showthread")."\";");
output_page($showthread);
}

	eval("\$showthread = \"".$templates->get("showthread")."\";");
output_page($showthread);
}





/**
* Build a navigation tree for threaded display.
*

/**
* Build a navigation tree for threaded display.
*

 * @param unknown_type $replyto
* @param unknown_type $indent
* @return unknown

 * @param int $replyto
* @param int $indent
* @return string

 */

 */

function buildtree($replyto="0", $indent="0")

function buildtree($replyto=0, $indent=0)

{

{

	global $tree, $mybb, $theme, $mybb, $pid, $tid, $templates, $parser;

	global $tree, $mybb, $theme, $mybb, $pid, $tid, $templates, $parser, $lang;





	if($indent)
{
$indentsize = 13 * $indent;
}
else
{
$indentsize = 0;
}

	$indentsize = 13 * $indent;









++$indent;


++$indent;

 
	$posts = '';

	if(is_array($tree[$replyto]))
{
foreach($tree[$replyto] as $key => $post)

	if(is_array($tree[$replyto]))
{
foreach($tree[$replyto] as $key => $post)

Zeile 1538Zeile 1678
				$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'])

Zeile 1549Zeile 1690
				eval("\$posts .= \"".$templates->get("showthread_threaded_bit")."\";");
}


				eval("\$posts .= \"".$templates->get("showthread_threaded_bit")."\";");
}


			if($tree[$post['pid']])

			if(!empty($tree[$post['pid']]))

			{
$posts .= buildtree($post['pid'], $indent);
}

			{
$posts .= buildtree($post['pid'], $indent);
}