| Zeile 51 | Zeile 51 |
|---|
$query = $db->simple_select("posts", "fid,tid,visible", "pid=".$mybb->get_input('pid', MyBB::INPUT_INT), $options);
$post = $db->fetch_array($query);
|
$query = $db->simple_select("posts", "fid,tid,visible", "pid=".$mybb->get_input('pid', MyBB::INPUT_INT), $options);
$post = $db->fetch_array($query);
|
if(empty($post) || ($post['visible'] == 0 && !is_moderator($post['fid'], 'canviewunapprove')) || ($post['visible'] == -1 && !is_moderator($post['fid'], 'canviewdeleted')))
| if(
empty($post) ||
(
$post['visible'] == 0 && !(
is_moderator($post['fid'], 'canviewunapprove') ||
($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);
|
| Zeile 103 | Zeile 112 |
|---|
$forumpermissions = forum_permissions($thread['fid']);
// Set here to fetch only approved/deleted posts (and then below for a moderator we change this).
|
$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)
{
|
if($forumpermissions['canviewdeletionnotice'] != 0)
{
|
$visibleonly = " AND visible IN (-1,1)";
$visibleonly2 = "AND p.visible IN (-1,1) AND t.visible IN (-1,1)";
}
else
{
$visibleonly = " AND visible=1";
$visibleonly2 = "AND p.visible=1 AND t.visible=1";
}
// Is the currently logged in user a moderator of this forum?
if(is_moderator($fid))
{
| $visible_states[] = "-1";
}
// Is the currently logged in user a moderator of this forum?
if(is_moderator($fid))
{
|
$ismod = true;
|
$ismod = true;
|
if(is_moderator($fid, "canviewdeleted") == true || is_moderator($fid, "canviewunapprove") == true)
| if(is_moderator($fid, "canviewdeleted") == true)
{
$visible_states[] = "-1";
}
if(is_moderator($fid, "canviewunapprove") == 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[] = "0";
|
}
}
else
{
|
}
}
else
{
|
$ismod = false;
| $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.
| }
// Make sure we are looking at a real thread here.
|
| Zeile 191 | Zeile 204 |
|---|
if($mybb->input['action'] == "newpost")
{
// First, figure out what time the thread or forum were last read
|
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");
|
| Zeile 249 | Zeile 263 |
|---|
$options = array(
"limit_start" => 0,
"limit" => 1,
|
$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 289 | Zeile 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 298 | Zeile 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 322 | Zeile 334 |
|---|
$nextthread = $db->fetch_array($query);
// Are there actually next newest posts?
|
$nextthread = $db->fetch_array($query);
// 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);
|
| Zeile 343 | Zeile 354 |
|---|
// 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,
| $options = array(
"limit" => 1,
|
"limit_start" => 0,
"order_by" => "lastpost",
"order_dir" => "desc"
| "limit_start" => 0,
"order_by" => "lastpost",
"order_dir" => "desc"
|
| Zeile 353 | Zeile 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);
|
| Zeile 534 | Zeile 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 552 | Zeile 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
| $votestar = "*";
}
else
|
| Zeile 603 | Zeile 613 |
|---|
if(is_moderator($fid, 'canmanagepolls'))
{
eval("\$edit_poll = \"".$templates->get("showthread_poll_editpoll")."\";");
|
if(is_moderator($fid, 'canmanagepolls'))
{
eval("\$edit_poll = \"".$templates->get("showthread_poll_editpoll")."\";");
|
}
| }
|
// Decide what poll status to show depending on the status of the poll and whether or not the user voted already.
if(isset($alreadyvoted) || isset($showresults) || isset($nopermission))
{
|
// 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) || isset($nopermission))
{
|
if($alreadyvoted)
| $undovote = '';
if(isset($alreadyvoted))
|
{
$pollstatus = $lang->already_voted;
|
{
$pollstatus = $lang->already_voted;
|
$undovote = '';
| |
if($mybb->usergroup['canundovotes'] == 1)
{
eval("\$undovote = \"".$templates->get("showthread_poll_undovote")."\";");
}
}
|
if($mybb->usergroup['canundovotes'] == 1)
{
eval("\$undovote = \"".$templates->get("showthread_poll_undovote")."\";");
}
}
|
elseif($nopermission)
| elseif(isset($nopermission))
|
{
$pollstatus = $lang->no_voting_permission;
}
| {
$pollstatus = $lang->no_voting_permission;
}
|
| Zeile 647 | Zeile 658 |
|---|
eval("\$pollbox = \"".$templates->get("showthread_poll")."\";");
$plugins->run_hooks("showthread_poll");
|
eval("\$pollbox = \"".$templates->get("showthread_poll")."\";");
$plugins->run_hooks("showthread_poll");
|
}
| }
|
}
else
|
}
else
|
| Zeile 656 | Zeile 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);
}
|
|
|
// Fetch some links
$next_oldest_link = get_thread_link($tid, 0, "nextoldest");
$next_newest_link = get_thread_link($tid, 0, "nextnewest");
// Mark this thread as read
mark_thread_read($tid, $fid);
|
// Fetch some links
$next_oldest_link = get_thread_link($tid, 0, "nextoldest");
$next_newest_link = get_thread_link($tid, 0, "nextnewest");
// Mark this thread as read
mark_thread_read($tid, $fid);
|
|
|
// If the forum is not open, show closed newreply button unless the user is a moderator of this forum.
$newthread = $newreply = '';
if($forum['open'] != 0 && $forum['type'] == "f")
{
if($forumpermissions['canpostthreads'] != 0 && $mybb->user['suspendposting'] != 1)
|
// If the forum is not open, show closed newreply button unless the user is a moderator of this forum.
$newthread = $newreply = '';
if($forum['open'] != 0 && $forum['type'] == "f")
{
if($forumpermissions['canpostthreads'] != 0 && $mybb->user['suspendposting'] != 1)
|
{
| {
|
eval("\$newthread = \"".$templates->get("showthread_newthread")."\";");
|
eval("\$newthread = \"".$templates->get("showthread_newthread")."\";");
|
}
| }
|
// 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")."\";");
}
elseif($thread['closed'] == 1)
{
eval("\$newreply = \"".$templates->get("showthread_newreply_closed")."\";");
|
{
eval("\$newreply = \"".$templates->get("showthread_newreply")."\";");
}
elseif($thread['closed'] == 1)
{
eval("\$newreply = \"".$templates->get("showthread_newreply_closed")."\";");
|
}
}
| }
}
|
// 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 725 | Zeile 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}')");
| 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'];
|
}
|
}
|
else
{
$db->shutdown_query("UPDATE ".TABLE_PREFIX."threads SET views=views+1 WHERE tid='{$tid}'");
}
++$thread['views'];
| |
// Work out the thread rating for this thread.
|
// 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 752 | Zeile 779 |
|---|
$thread['averagerating'] = (float)round($thread['totalratings']/$thread['numratings'], 2);
$thread['width'] = (int)round($thread['averagerating'])*20;
$thread['numratings'] = (int)$thread['numratings'];
|
$thread['averagerating'] = (float)round($thread['totalratings']/$thread['numratings'], 2);
$thread['width'] = (int)round($thread['averagerating'])*20;
$thread['numratings'] = (int)$thread['numratings'];
|
}
| }
|
if($thread['numratings'])
{
// At least >someone< has rated this thread, was it me?
// Check if we have already voted on this thread - it won't show hover effect then.
$query = $db->simple_select("threadratings", "uid", "tid='{$tid}' AND uid='{$mybb->user['uid']}'");
$rated = $db->fetch_field($query, 'uid');
|
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 = '';
if(!$rated)
|
| Zeile 770 | Zeile 797 |
|---|
$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)";
}
elseif($forumpermissions['canviewdeletionnotice'] != 0 && $ismod == false)
{
$visible = "AND p.visible IN (-1,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)
|
if($forumpermissions['cansearch'] != 0)
|
{
| {
|
eval("\$search_thread = \"".$templates->get("showthread_search")."\";");
}
| eval("\$search_thread = \"".$templates->get("showthread_search")."\";");
}
|
| Zeile 807 | Zeile 814 |
|---|
foreach($ignore_list as $uid)
{
$ignored_users[$uid] = 1;
|
foreach($ignore_list as $uid)
{
$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']))
{
|
| Zeile 850 | Zeile 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?
| $isfirst = 1;
// Are we linked to a specific pid?
|
| Zeile 859 | Zeile 851 |
|---|
}
else
{
|
}
else
{
|
$where = " ORDER BY dateline LIMIT 0, 1";
| $where = " ORDER BY dateline, pid LIMIT 0, 1";
|
}
$query = $db->query("
SELECT u.*, u.username AS userusername, p.*, f.*, r.reporters, eu.username AS editusername
| }
$query = $db->query("
SELECT u.*, u.username AS userusername, p.*, f.*, r.reporters, eu.username AS editusername
|
| Zeile 868 | Zeile 860 |
|---|
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();
if($mybb->settings['enableattachments'] == 1 && $thread['attachmentcount'] > 0 || is_moderator($fid, 'caneditposts'))
{
// Get the attachments for this post.
$query = $db->simple_select("attachments", "*", "pid=".$mybb->input['pid']);
while($attachment = $db->fetch_array($query))
|
$attachcache = array();
if($mybb->settings['enableattachments'] == 1 && $thread['attachmentcount'] > 0 || is_moderator($fid, 'caneditposts'))
{
// Get the attachments for this post.
$query = $db->simple_select("attachments", "*", "pid=".$mybb->input['pid']);
while($attachment = $db->fetch_array($query))
|
{
| {
|
$attachcache[$attachment['pid']][$attachment['aid']] = $attachment;
|
$attachcache[$attachment['pid']][$attachment['aid']] = $attachment;
|
}
}
// Build the threaded post display tree.
$query = $db->query("
SELECT p.username, p.uid, p.pid, p.replyto, p.subject, p.dateline
FROM ".TABLE_PREFIX."posts p
WHERE p.tid='$tid'
$visible
ORDER BY p.dateline
");
if(!is_array($postsdone))
{
$postsdone = array();
}
while($post = $db->fetch_array($query))
{
if(!$postsdone[$post['pid']])
{
if($post['pid'] == $mybb->input['pid'] || ($isfirst && !$mybb->input['pid']))
{
$postcounter = count($postsdone);
$isfirst = 0;
}
$tree[$post['replyto']][$post['pid']] = $post;
$postsdone[$post['pid']] = 1;
}
}
| }
}
$multipage = '';
// 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'
$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);
$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 928 | Zeile 919 |
|---|
}
else // Linear display
{
|
}
else // Linear display
{
|
| | $thread_toggle = 'threaded';
|
$threadexbox = '';
if(!$mybb->settings['postsperpage'] || (int)$mybb->settings['postsperpage'] < 1)
{
$mybb->settings['postsperpage'] = 20;
|
$threadexbox = '';
if(!$mybb->settings['postsperpage'] || (int)$mybb->settings['postsperpage'] < 1)
{
$mybb->settings['postsperpage'] = 20;
|
}
| }
|
// 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'];
|
| Zeile 945 | Zeile 937 |
|---|
if(!empty($mybb->input['pid']))
{
$post = get_post($mybb->input['pid']);
|
if(!empty($mybb->input['pid']))
{
$post = get_post($mybb->input['pid']);
|
if(empty($post) || ($post['visible'] == 0 && !is_moderator($post['fid'], 'canviewunapprove')) || ($post['visible'] == -1 && !is_moderator($post['fid'], 'canviewdeleted') && $forumpermissions['canviewdeletionnotice'] == 0))
| 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>';
}
| {
$footer .= '<script type="text/javascript">$(function() { $.jGrowl(\''.$lang->error_invalidpost.'\', {theme: \'jgrowl_error\'}); });</script>';
}
|
| Zeile 955 | Zeile 956 |
|---|
SELECT COUNT(p.dateline) AS count FROM ".TABLE_PREFIX."posts p
WHERE p.tid = '{$tid}'
AND p.dateline <= '{$post['dateline']}'
|
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)
|
| Zeile 970 | Zeile 971 |
|---|
}
// Recount replies if user is a moderator or can see the deletion notice to take into account unapproved/deleted posts.
|
}
// Recount replies if user is a moderator or can see the deletion notice to take into account unapproved/deleted posts.
|
if($ismod || $forumpermissions['canviewdeletionnotice'] != 0)
| 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'];
|
$thread['replies'] = $db->fetch_field($query, 'replies')-1;
// The counters are wrong? Rebuild them
// This doesn't cover all cases however it is a good addition to the manual rebuild function
if($thread['replies'] != $cached_replies)
{
require_once MYBB_ROOT."/inc/functions_rebuild.php";
rebuild_thread_counters($thread['tid']);
}
}
elseif($forumpermissions['canviewdeletionnotice'] != 0)
{
$thread['replies'] += $thread['deletedposts'];
|
$query = $db->simple_select("posts p", "COUNT(*) AS replies", "p.tid='$tid' $visibleonly_p");
$thread['replies'] = $db->fetch_field($query, 'replies')-1;
if(in_array('-1', $visible_states) && in_array('0', $visible_states))
{
// 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;
| }
$postcount = (int)$thread['replies']+1;
|
| Zeile 1015 | Zeile 1016 |
|---|
$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 = "&mode=linear";
}
else
{
$threadmode = "?mode=linear";
}
| if($mybb->get_input('highlight'))
{
$threadmode = "&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 1053 | Zeile 1054 |
|---|
}
}
|
}
}
|
if($defaultmode != "linear")
{
$threadmode = "&mode=linear";
}
}
$multipage = multipage($postcount, $perpage, $page, str_replace("{tid}", $tid, THREAD_URL_PAGED.$highlight.$threadmode));
// Allow originator to see own unapproved posts
if($mybb->user['uid'] && $mybb->settings['showownunapproved'])
{
$visible .= " OR (p.tid='$tid' AND p.visible='0' AND p.uid=".$mybb->user['uid'].")";
| if($defaultmode != "linear")
{
$threadmode = "&mode=linear";
}
|
}
|
}
|
| |
$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 1115 | Zeile 1110 |
|---|
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."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 1128 | Zeile 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']}";
|
}
| }
|
switch($db->type)
{
|
switch($db->type)
{
|
| Zeile 1176 | Zeile 1172 |
|---|
$icon['path'] = htmlspecialchars_uni($icon['path']);
$icon['name'] = htmlspecialchars_uni($icon['name']);
eval("\$icon = \"".$templates->get("forumdisplay_thread_icon")."\";");
|
$icon['path'] = htmlspecialchars_uni($icon['path']);
$icon['name'] = htmlspecialchars_uni($icon['name']);
eval("\$icon = \"".$templates->get("forumdisplay_thread_icon")."\";");
|
}
| }
|
else
{
$icon = " ";
| else
{
$icon = " ";
|
| Zeile 1193 | Zeile 1189 |
|---|
// 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'].' ';
}
|
$prefix = build_prefixes($similar_thread['prefix']);
if(!empty($prefix))
{
$similar_thread['threadprefix'] = $prefix['displaystyle'].' ';
}
|
| | }
else
{
$similar_thread['threadprefix'] = '';
|
}
$similar_thread['subject'] = $parser->parse_badwords($similar_thread['subject']);
| }
$similar_thread['subject'] = $parser->parse_badwords($similar_thread['subject']);
|
| Zeile 1209 | Zeile 1209 |
|---|
$lastpostdate = my_date('relative', $similar_thread['lastpost']);
$lastposter = $similar_thread['lastposter'];
$lastposteruid = $similar_thread['lastposteruid'];
|
$lastpostdate = my_date('relative', $similar_thread['lastpost']);
$lastposter = $similar_thread['lastposter'];
$lastposteruid = $similar_thread['lastposteruid'];
|
|
|
// Don't link to guest's profiles (they have no profile).
if($lastposteruid == 0)
{
| // Don't link to guest's profiles (they have no profile).
if($lastposteruid == 0)
{
|
| Zeile 1231 | Zeile 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 1242 | Zeile 1242 |
|---|
{
require_once MYBB_ROOT.'inc/class_captcha.php';
$post_captcha = new captcha(true, "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($post_captcha->html)
{
$captcha = $post_captcha->html;
}
|
}
| }
|
$postoptionschecked = array('signature' => '', 'emailnotify' => '');
if($mybb->user['signature'])
{
| $postoptionschecked = array('signature' => '', 'emailnotify' => '');
if($mybb->user['signature'])
{
|
| Zeile 1258 | Zeile 1258 |
|---|
// Hide signature option if no permission
$option_signature = '';
if($mybb->usergroup['canusesig'] && !$mybb->user['suspendsignature'])
|
// Hide signature option if no permission
$option_signature = '';
if($mybb->usergroup['canusesig'] && !$mybb->user['suspendsignature'])
|
{
| {
|
eval("\$option_signature = \"".$templates->get('showthread_quickreply_options_signature')."\";");
}
| eval("\$option_signature = \"".$templates->get('showthread_quickreply_options_signature')."\";");
}
|
| Zeile 1289 | Zeile 1289 |
|---|
}
}
|
}
}
|
$posthash = md5($mybb->user['uid'].random_str());
$expaltext = (in_array("quickreply", $collapse)) ? "[+]" : "[-]";
| $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 1312 | Zeile 1326 |
|---|
$thread['notes'] = my_substr($thread['notes'], 0, 200)."... {$viewnotes}";
}
|
$thread['notes'] = my_substr($thread['notes'], 0, 200)."... {$viewnotes}";
}
|
$expaltext = (in_array("threadnotes", $collapse)) ? "[+]" : "[-]";
| 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")."\";");
}
|
| Zeile 1321 | Zeile 1348 |
|---|
$gids = explode(',', $mybb->user['additionalgroups']);
$gids[] = $mybb->user['usergroup'];
$gids = array_filter(array_unique($gids));
|
$gids = explode(',', $mybb->user['additionalgroups']);
$gids[] = $mybb->user['usergroup'];
$gids = array_filter(array_unique($gids));
|
| | $gidswhere = '';
|
switch($db->type)
{
case "pgsql":
| switch($db->type)
{
case "pgsql":
|
| Zeile 1410 | Zeile 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 1453 | Zeile 1497 |
|---|
elseif(is_moderator($forum['fid'], "canrestorethreads") && $thread['visible'] == -1)
{
eval("\$softdeletethread = \"".$templates->get("showthread_moderationoptions_restore")."\";");
|
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))
|
if(!empty($openclosethread) || !empty($stickunstickthread) || !empty($deletethread) || !empty($managethread) || !empty($adminpolloptions) || !empty($approveunapprovethread) || !empty($softdeletethread))
|
{
| {
|
eval("\$standardthreadtools = \"".$templates->get("showthread_moderationoptions_standard")."\";");
}
| eval("\$standardthreadtools = \"".$templates->get("showthread_moderationoptions_standard")."\";");
}
|
| Zeile 1464 | Zeile 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")."\";");
| }
}
eval("\$printthread = \"".$templates->get("showthread_printthread")."\";");
|
// Display 'send thread' link if permissions allow
$sendthread = '';
if($mybb->usergroup['cansendemail'] == 1)
{
eval("\$sendthread = \"".$templates->get("showthread_send_thread")."\";");
|
// Display 'send thread' link if permissions allow
$sendthread = '';
if($mybb->usergroup['cansendemail'] == 1)
{
eval("\$sendthread = \"".$templates->get("showthread_send_thread")."\";");
|
}
| }
|
// Display 'add poll' link to thread creator (or mods) if thread doesn't have a poll already
$addpoll = '';
$time = TIME_NOW;
| // Display 'add poll' link to thread creator (or mods) if thread doesn't have a poll already
$addpoll = '';
$time = TIME_NOW;
|
| Zeile 1492 | Zeile 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;
}
eval("\$addremovesubscription = \"".$templates->get("showthread_subscription")."\";");
|
{
$add_remove_subscription = 'remove';
$add_remove_subscription_text = $lang->unsubscribe_thread;
}
eval("\$addremovesubscription = \"".$templates->get("showthread_subscription")."\";");
|
| | }
else
{
$addremovesubscription = '';
|
}
$classic_header = '';
| }
$classic_header = '';
|
| Zeile 1508 | Zeile 1556 |
|---|
}
// 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'];
|
| Zeile 1572 | Zeile 1621 |
|---|
}
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 = '';
| }
$onlinesep = '';
|
| Zeile 1590 | Zeile 1639 |
|---|
eval("\$usersbrowsing = \"".$templates->get("showthread_usersbrowsing")."\";");
}
|
eval("\$usersbrowsing = \"".$templates->get("showthread_usersbrowsing")."\";");
}
|
if($thread['visible'] == -1 )
| $thread_deleted = 0;
if($thread['visible'] == -1)
|
{
$thread_deleted = 1;
}
| {
$thread_deleted = 1;
}
|
| Zeile 1640 | Zeile 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);
}
|