Vergleich showthread.php - 1.6.0 - 1.6.5

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

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

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

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

 */

define("IN_MYBB", 1);

 */

define("IN_MYBB", 1);

Zeile 17Zeile 17
$templatelist .= ",postbit_editedby,showthread_similarthreads,showthread_similarthreads_bit,postbit_iplogged_show,postbit_iplogged_hiden,showthread_quickreply";
$templatelist .= ",forumjump_advanced,forumjump_special,forumjump_bit,showthread_multipage,postbit_reputation,postbit_quickdelete,postbit_attachments,thumbnails_thumbnail,postbit_attachments_attachment,postbit_attachments_thumbnails,postbit_attachments_images_image,postbit_attachments_images,postbit_posturl,postbit_rep_button";
$templatelist .= ",postbit_inlinecheck,showthread_inlinemoderation,postbit_attachments_thumbnails_thumbnail,postbit_quickquote,postbit_qqmessage,postbit_ignored,postbit_groupimage,postbit_multiquote,showthread_search,postbit_warn,postbit_warninglevel,showthread_moderationoptions_custom_tool,showthread_moderationoptions_custom,showthread_inlinemoderation_custom_tool,showthread_inlinemoderation_custom,postbit_classic,showthread_classic_header,showthread_poll_resultbit,showthread_poll_results";

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

$templatelist .= ",showthread_usersbrowsing,showthread_usersbrowsing_user";

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


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 56Zeile 56
$thread['displayprefix'] = '';
if($thread['prefix'] != 0)
{

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

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

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




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

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


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

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

{

{

	$thread['tid'] = 0;
}


	$thread['tid'] = 0;
}


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

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

}

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

}

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


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


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

}

}

else
{
$ismod = false;

else
{
$ismod = false;

Zeile 92Zeile 94

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


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

{

{

	error($lang->error_invalidthread);

	error($lang->error_invalidthread);

 
}

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

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

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

}

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

}

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

Zeile 105Zeile 120
	error($lang->error_invalidforum);
}


	error($lang->error_invalidforum);
}


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

$query = $db->simple_select("forums", "threads, unapprovedthreads", "fid = '{$fid}'", array('limit' => 1));
$forum_threads = $db->fetch_array($query);
$threadcount = $forum_threads['threads'];
if($ismod == true)
{
$threadcount += $forum_threads['unapprovedthreads'];
}

// If we have 0 threads double check there aren't any "moved" threads
if($threadcount == 0)
{
$query = $db->simple_select("threads", "COUNT(tid) AS threads", "fid = '$fid' $visibleonly", array('limit' => 1));
$threadcount = $db->fetch_field($query, "threads");
}

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

// Figure out what page the thread is actually on
switch($db->type)

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

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

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

$breadcrumb_multipage = array();
if($mybb->settings['showforumpagesbreadcrumb'])














{

{

	case "pgsql":
$query = $db->query("
SELECT COUNT(tid) as threads
FROM ".TABLE_PREFIX."threads
WHERE fid = '$fid' AND (lastpost >= '".intval($thread['lastpost'])."'{$stickybit}) {$visibleonly}
GROUP BY lastpost
ORDER BY lastpost DESC
");
break;
default:
$query = $db->simple_select("threads", "COUNT(tid) as threads", "fid = '$fid' AND (lastpost >= '".intval($thread['lastpost'])."'{$stickybit}) {$visibleonly}", array('order_by' => 'lastpost', 'order_dir' => 'desc'));



















































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

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

if($ismod == true)
{
$threadcount += $forum_threads['unapprovedthreads'];
}

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

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

// If we have 0 threads double check there aren't any "moved" threads
if($threadcount == 0)
{
$query = $db->simple_select("threads", "COUNT(tid) AS threads", "fid = '$fid' $visibleonly $uid_only", array('limit' => 1));
$threadcount = $db->fetch_field($query, "threads");
}

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

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

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

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

}

}


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

 

// Build the navigation.


// Build the navigation.

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

// Does the user have permission to view this thread?
$forumpermissions = forum_permissions($forum['fid']);

if($forumpermissions['canview'] != 1 || $forumpermissions['canviewthreads'] != 1)
{
error_no_permission();
}

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


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















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

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





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

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

{

{

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

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



 

// Jump to the unread posts.
if($mybb->input['action'] == "newpost")


// Jump to the unread posts.
if($mybb->input['action'] == "newpost")

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

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

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

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

	{

	{

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


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


Zeile 198Zeile 233
	}
else
{

	}
else
{

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

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

	}

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

	}

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

Zeile 219Zeile 254
	}

if(!$lastread)

	}

if(!$lastread)

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

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

		if($readcookie > $forum_read)
{
$lastread = $readcookie;

		if($readcookie > $forum_read)
{
$lastread = $readcookie;

Zeile 237Zeile 272
   }

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

   }

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

	$options = array(

	$options = array(

		"limit_start" => 0,
"limit" => 1,
"order_by" => "dateline",
"order_dir" => "asc"
);

		"limit_start" => 0,
"limit" => 1,
"order_by" => "dateline",
"order_dir" => "asc"
);

 

$lastread = intval($lastread);

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

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

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

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

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













	{
$highlight = '';
if($mybb->input['highlight'])
{
$string = "&";
if($mybb->settings['seourls'] == "yes" || ($mybb->settings['seourls'] == "auto" && $_SERVER['SEO_SUPPORT'] == 1))
{
$string = "?";
}

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

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

	}
else
{
// show them to the last post
$mybb->input['action'] = "lastpost";

	}
else
{
// show them to the last post
$mybb->input['action'] = "lastpost";

	}

	}

}

// Jump to the last post.

}

// Jump to the last post.

Zeile 270Zeile 319
			ORDER BY p.dateline DESC
LIMIT 1
");

			ORDER BY p.dateline DESC
LIMIT 1
");

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

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

	else
{
$options = array(

	else
{
$options = array(

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

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

	exit;
}


	exit;
}


// Jump to the next newest posts.
if($mybb->input['action'] == "nextnewest")
{

// Jump to the next newest posts.
if($mybb->input['action'] == "nextnewest")
{

Zeile 302Zeile 351
	if(!$nextthread['tid'])
{
error($lang->error_nonextnewest);

	if(!$nextthread['tid'])
{
error($lang->error_nonextnewest);

	}

	}

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

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

Zeile 310Zeile 359
		"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;

}

// Jump to the next oldest posts.
if($mybb->input['action'] == "nextoldest")

}

// Jump to the next oldest posts.
if($mybb->input['action'] == "nextoldest")

{

{

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

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

Zeile 344Zeile 394
	// 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;
}


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


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





$plugins->run_hooks("showthread_start");

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

$plugins->run_hooks("showthread_start");

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

Zeile 601Zeile 652
	$rating = '';
if($forum['allowtratings'] != 0)
{

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

 
		$rated = 0;

		$lang->load("ratethread");
if($thread['numratings'] <= 0)
{
$thread['width'] = 0;
$thread['averagerating'] = 0;
$thread['numratings'] = 0;

		$lang->load("ratethread");
if($thread['numratings'] <= 0)
{
$thread['width'] = 0;
$thread['averagerating'] = 0;
$thread['numratings'] = 0;

		}

		}

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

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

Zeile 615Zeile 667
			$thread['numratings'] = intval($thread['numratings']);
}


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


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





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


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


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

		}


		}


		$ratingvotesav = $lang->sprintf($lang->rating_average, $thread['numratings'], $thread['averagerating']);
eval("\$ratethread = \"".$templates->get("showthread_ratethread")."\";");
}
// Work out if we are showing unapproved posts as well (if the user is a moderator etc.)
if($ismod)

		$ratingvotesav = $lang->sprintf($lang->rating_average, $thread['numratings'], $thread['averagerating']);
eval("\$ratethread = \"".$templates->get("showthread_ratethread")."\";");
}
// Work out if we are showing unapproved posts as well (if the user is a moderator etc.)
if($ismod)

	{

	{

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

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

	}

	}

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

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

	}

	}

	
// Can this user perform searches? If so, we can show them the "Search thread" form
if($forumpermissions['cansearch'] != 0)

	
// Can this user perform searches? If so, we can show them the "Search thread" form
if($forumpermissions['cansearch'] != 0)

Zeile 647Zeile 703
	// Fetch the ignore list for the current user if they have one
$ignored_users = array();
if($mybb->user['uid'] > 0 && $mybb->user['ignorelist'] != "")

	// Fetch the ignore list for the current user if they have one
$ignored_users = array();
if($mybb->user['uid'] > 0 && $mybb->user['ignorelist'] != "")

	{

	{

		$ignore_list = explode(',', $mybb->user['ignorelist']);
foreach($ignore_list as $uid)
{
$ignored_users[$uid] = 1;
}

		$ignore_list = explode(',', $mybb->user['ignorelist']);
foreach($ignore_list as $uid)
{
$ignored_users[$uid] = 1;
}

	}// Which thread mode is our user using by default?
if(!empty($mybb->user['threadmode']))
{
$defaultmode = $mybb->user['threadmode'];
}
else if($mybb->settings['threadusenetstyle'] == 1)
{
$defaultmode = 'threaded';
}
else
{
$defaultmode = 'linear';
}

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

 
	}

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

	}

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

Zeile 782Zeile 820
		}
if($mybb->input['pid'])
{

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

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

			$query = $db->query("

			$query = $db->query("

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

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

				WHERE p.tid='$tid'

				WHERE p.tid='$tid'

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

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

				$visible
");
$result = $db->fetch_field($query, "count");

				$visible
");
$result = $db->fetch_field($query, "count");

Zeile 853Zeile 892
        }
else
{

        }
else
{

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











			if($mybb->input['highlight'])
{
if(is_array($mybb->input['highlight']))
{
foreach($mybb->input['highlight'] as $highlight_word)
{
$highlight .= "&amp;highlight[]=".urlencode($highlight_word);
}
}
else
{
$highlight = "&amp;highlight=".urlencode($mybb->input['highlight']);
}
}

            
if($defaultmode != "linear")
{

            
if($defaultmode != "linear")
{

Zeile 936Zeile 985
	{
switch($db->type)
{

	{
switch($db->type)
{

			case "sqlite":

 
			case "pgsql":

			case "pgsql":

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

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


			default:

			default:

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

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


		}

		}

		



		$count = 0;
$similarthreadbits = '';
$icon_cache = $cache->read("posticons");

		$count = 0;
$similarthreadbits = '';
$icon_cache = $cache->read("posticons");

Zeile 984Zeile 1030
			else
{
$similar_thread['profilelink'] = build_profile_link($similar_thread['username'], $similar_thread['uid']);

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

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


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

			}

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

			}

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

Zeile 1016Zeile 1063
			eval("\$similarthreadbits .= \"".$templates->get("showthread_similarthreads_bit")."\";");
}
if($count)

			eval("\$similarthreadbits .= \"".$templates->get("showthread_similarthreads_bit")."\";");
}
if($count)

		{

		{

			eval("\$similarthreads = \"".$templates->get("showthread_similarthreads")."\";");

			eval("\$similarthreads = \"".$templates->get("showthread_similarthreads")."\";");

		}

		}

	}

	}





	// Decide whether or not to show quick reply.
if($forumpermissions['canpostreplys'] != 0 && $mybb->user['suspendposting'] != 1 && ($thread['closed'] != 1 || is_moderator($fid)) && $mybb->settings['quickreply'] != 0 && $mybb->user['showquickreply'] != '0' && $forum['open'] != 0)
{

	// Decide whether or not to show quick reply.
if($forumpermissions['canpostreplys'] != 0 && $mybb->user['suspendposting'] != 1 && ($thread['closed'] != 1 || is_moderator($fid)) && $mybb->settings['quickreply'] != 0 && $mybb->user['showquickreply'] != '0' && $forum['open'] != 0)
{

Zeile 1028Zeile 1075
		$last_pid = $db->fetch_field($query, "pid");

// Show captcha image for guests if enabled

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

// Show captcha image for guests if enabled

		if($mybb->settings['captchaimage'] == 1 && function_exists("imagepng") && !$mybb->user['uid'])

		if($mybb->settings['captchaimage'] && !$mybb->user['uid'])

		{

		{

			$randomstr = random_str(5);
$imagehash = md5(random_str(12));
$imagearray = array(
"imagehash" => $imagehash,
"imagestring" => $randomstr,
"dateline" => TIME_NOW
);
$db->insert_query("captcha", $imagearray);
eval("\$captcha = \"".$templates->get("post_captcha")."\";");

			require_once MYBB_ROOT.'inc/class_captcha.php';
$post_captcha = new captcha(true, "post_captcha");

if($post_captcha->html)
{
$captcha = $post_captcha->html;
}



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

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

		{

		{

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

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

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

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

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

while($tool = $db->fetch_array($query))
{
if($tool['type'] == 'p')
{
eval("\$customposttools .= \"".$templates->get("showthread_inlinemoderation_custom_tool")."\";");
}
else
{
eval("\$customthreadtools .= \"".$templates->get("showthread_moderationoptions_custom_tool")."\";");
}
}
// Build inline moderation dropdown
if(!empty($customposttools))
{
eval("\$customposttools = \"".$templates->get("showthread_inlinemoderation_custom")."\";");
}







	{
if($forum_stats[-1]['modtools'] || $forum_stats[$forum['fid']]['modtools'])
{
$customthreadtools = $customposttools = '';

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

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

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


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

// Build thread moderation dropdown

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

// Build thread moderation dropdown

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

// Subscription status

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

// Subscription status

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

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



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

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

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

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

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

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

Zeile 1122Zeile 1175
		$timecut = TIME_NOW - $mybb->settings['wolcutoff'];

$comma = '';

		$timecut = TIME_NOW - $mybb->settings['wolcutoff'];

$comma = '';

		$onlinemembers = '';

 
		$guestcount = 0;
$membercount = 0;
$inviscount = 0;

		$guestcount = 0;
$membercount = 0;
$inviscount = 0;

 
		$onlinemembers = '';
$doneusers = array();


		$query = $db->query("

		$query = $db->query("

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

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

			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
ORDER BY u.username ASC, s.time DESC
");

			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
ORDER BY u.username ASC, s.time DESC
");

 


		while($user = $db->fetch_array($query))
{
if($user['uid'] == 0)
{
++$guestcount;

		while($user = $db->fetch_array($query))
{
if($user['uid'] == 0)
{
++$guestcount;

			}
else

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

			{

			{

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





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

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

				{

				{

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

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

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

if($user['invisible'] != 1 || $mybb->usergroup['canviewwolinvis'] == 1 || $user['uid'] == $mybb->user['uid'])
{
$user['profilelink'] = get_profile_link($user['uid']);
$user['username'] = format_name($user['username'], $user['usergroup'], $user['displaygroup']);
$user['reading'] = my_date($mybb->settings['timeformat'], $user['time']);

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









				}
}

				}
}

		}


		}


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

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

		}


		}


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

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

		}


		}


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

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

		}


		}


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

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

 


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


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