Zeile 11 | Zeile 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"; $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"; $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,postbit_offline"; $templatelist .= ",forumjump_advanced,forumjump_special,forumjump_bit,postbit_quickdelete,postbit_attachments,postbit_attachments_attachment,postbit_attachments_thumbnails,postbit_attachments_images_image,postbit_attachments_images,showthread_quickreply_options_stick,showthread_classic_header"; $templatelist .= ",postbit_inlinecheck,showthread_inlinemoderation,postbit_attachments_thumbnails_thumbnail,postbit_ignored,postbit_groupimage,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,showthread_threadnotes,postbit_reputation"; $templatelist .= ",showthread_moderationoptions_openclose,showthread_moderationoptions_stickunstick,showthread_moderationoptions_delete,showthread_moderationoptions_threadnotes,showthread_moderationoptions_manage,showthread_moderationoptions_deletepoll,showthread_poll_results,postbit_classic"; $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,showthread_poll_resultbit"; $templatelist .= ",showthread_moderationoptions_softdelete,showthread_moderationoptions_restore,post_captcha,post_captcha_recaptcha,post_captcha_nocaptcha,showthread_moderationoptions,showthread_inlinemoderation_standard,showthread_threadedbox,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,showthread_search,postbit_warn"; $templatelist .= ",showthread_moderationoptions_approve,showthread_moderationoptions_unapprove,showthread_inlinemoderation_delete,showthread_moderationoptions_standard,showthread_quickreply_options_close,showthread_inlinemoderation_custom,showthread_threadnotes_viewnotes,postbit_away";
| $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 54 | Zeile 56 |
---|
// post does not exist --> show corresponding error error($lang->error_invalidpost); }
|
// post does not exist --> show corresponding error error($lang->error_invalidpost); }
|
|
|
$mybb->input['tid'] = $post['tid']; } }
| $mybb->input['tid'] = $post['tid']; } }
|
Zeile 97 | Zeile 99 |
---|
$thread['username'] = $lang->guest; } $thread['username'] = htmlspecialchars_uni($thread['username']);
|
$thread['username'] = $lang->guest; } $thread['username'] = htmlspecialchars_uni($thread['username']);
|
| $forumpermissions = forum_permissions($thread['fid']);
// Set here to fetch only approved/deleted posts (and then below for a moderator we change this). if($forumpermissions['canviewdeletionnotice'] != 0) { $visibleonly = " AND visible IN (-1,1)"; $visibleonly2 = "AND p.visible IN (-1,1) AND t.visible IN (-1,1)"; } else { $visibleonly = " AND visible=1"; $visibleonly2 = "AND p.visible=1 AND t.visible=1"; }
|
// Is the currently logged in user a moderator of this forum? if(is_moderator($fid))
| // Is the currently logged in user a moderator of this forum? if(is_moderator($fid))
|
Zeile 124 | Zeile 140 |
---|
else { $ismod = false;
|
else { $ismod = false;
|
$visibleonly = " AND visible=1"; $visibleonly2 = "AND p.visible=1 AND t.visible=1"; }
| }
|
// Make sure we are looking at a real thread here. if(($thread['visible'] != 1 && $ismod == false) || ($thread['visible'] == 0 && !is_moderator($fid, "canviewunapprove")) || ($thread['visible'] == -1 && !is_moderator($fid, "canviewdeleted")))
|
// Make sure we are looking at a real thread here. if(($thread['visible'] != 1 && $ismod == false) || ($thread['visible'] == 0 && !is_moderator($fid, "canviewunapprove")) || ($thread['visible'] == -1 && !is_moderator($fid, "canviewdeleted")))
|
{ error($lang->error_invalidthread); }
$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(); }
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(); }
| error_no_permission(); }
|
Zeile 187 | Zeile 203 |
---|
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 { $forum_read = (int)my_get_array_cookie("forumread", $fid);
| else { $forum_read = (int)my_get_array_cookie("forumread", $fid);
|
Zeile 230 | Zeile 246 |
---|
}
// Next, find the proper pid to link to.
|
}
// Next, find the proper pid to link to.
|
$options = array( "limit_start" => 0, "limit" => 1, "order_by" => "dateline",
| $options = array( "limit_start" => 0, "limit" => 1, "order_by" => "dateline",
|
"order_dir" => "asc" );
|
"order_dir" => "asc" );
|
|
|
$lastread = (int)$lastread; $query = $db->simple_select("posts", "pid", "tid='{$tid}' AND dateline > '{$lastread}' {$visibleonly}", $options); $newpost = $db->fetch_array($query);
| $lastread = (int)$lastread; $query = $db->simple_select("posts", "pid", "tid='{$tid}' AND dateline > '{$lastread}' {$visibleonly}", $options); $newpost = $db->fetch_array($query);
|
Zeile 251 | Zeile 267 |
---|
{ $string = "?"; }
|
{ $string = "?"; }
|
|
|
$highlight = $string."highlight=".$mybb->get_input('highlight'); }
header("Location: ".htmlspecialchars_decode(get_post_link($newpost['pid'], $tid)).$highlight."#pid{$newpost['pid']}");
|
$highlight = $string."highlight=".$mybb->get_input('highlight'); }
header("Location: ".htmlspecialchars_decode(get_post_link($newpost['pid'], $tid)).$highlight."#pid{$newpost['pid']}");
|
}
| }
|
else
|
else
|
{
| {
|
// show them to the last post $mybb->input['action'] = "lastpost";
|
// show them to the last post $mybb->input['action'] = "lastpost";
|
}
| }
|
}
// Jump to the last post.
| }
// Jump to the last post.
|
Zeile 277 | Zeile 293 |
---|
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 301 | Zeile 317 |
---|
"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? if(!$nextthread['tid']) {
| // Are there actually next newest posts? if(!$nextthread['tid']) {
|
Zeile 317 | Zeile 333 |
---|
"order_dir" => "desc" ); $query = $db->simple_select('posts', 'pid', "tid='{$nextthread['tid']}'", $options);
|
"order_dir" => "desc" ); $query = $db->simple_select('posts', 'pid', "tid='{$nextthread['tid']}'", $options);
|
// Redirect to the proper page. $pid = $db->fetch_field($query, "pid"); header("Location: ".htmlspecialchars_decode(get_post_link($pid, $nextthread['tid']))."#pid{$pid}"); 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; }
|
// Jump to the next oldest posts. if($mybb->input['action'] == "nextoldest") {
| // Jump to the next oldest posts. if($mybb->input['action'] == "nextoldest") {
|
Zeile 367 | Zeile 383 |
---|
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) { $threadcount += $forum_threads['unapprovedthreads']; }
|
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['deletedthreads']; }
|
// Limit to only our own threads $uid_only = ''; if(isset($forumpermissions['canonlyviewownthreads']) && $forumpermissions['canonlyviewownthreads'] == 1) { $uid_only = " AND uid = '".$mybb->user['uid']."'";
|
// Limit to only our own threads $uid_only = ''; if(isset($forumpermissions['canonlyviewownthreads']) && $forumpermissions['canonlyviewownthreads'] == 1) { $uid_only = " AND uid = '".$mybb->user['uid']."'";
|
$query = $db->simple_select("threads", "COUNT(tid) AS threads", "fid = '$fid' $visibleonly $uid_only", array('limit' => 1)); $threadcount = $db->fetch_field($query, "threads");
| $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 we have 0 threads double check there aren't any "moved" threads
|
Zeile 393 | Zeile 421 |
---|
{ $query = $db->simple_select("threads", "COUNT(tid) AS threads", "fid = '$fid' $visibleonly $uid_only", array('limit' => 1)); $threadcount = $db->fetch_field($query, "threads");
|
{ $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 = " OR sticky=1"; if($thread['sticky'] == 1)
|
Zeile 415 | Zeile 443 |
---|
break; default: $query = $db->simple_select("threads", "COUNT(tid) as threads", "fid = '$fid' AND (lastpost >= '".(int)$thread['lastpost']."'{$stickybit}) {$visibleonly} {$uid_only}", array('order_by' => 'lastpost', 'order_dir' => 'desc'));
|
break; default: $query = $db->simple_select("threads", "COUNT(tid) as threads", "fid = '$fid' AND (lastpost >= '".(int)$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']));
| $thread_position = $db->fetch_field($query, "threads"); $thread_page = ceil(($thread_position/$mybb->settings['threadsperpage']));
|
Zeile 425 | Zeile 453 |
---|
"current_page" => $thread_page ); }
|
"current_page" => $thread_page ); }
|
|
|
// Build the navigation. build_forum_breadcrumb($fid, $breadcrumb_multipage); add_breadcrumb($thread['displayprefix'].$thread['subject'], get_thread_link($thread['tid']));
| // Build the navigation. build_forum_breadcrumb($fid, $breadcrumb_multipage); add_breadcrumb($thread['displayprefix'].$thread['subject'], get_thread_link($thread['tid']));
|
Zeile 435 | Zeile 463 |
---|
// Show the entire thread (taking into account pagination). if($mybb->input['action'] == "thread") {
|
// Show the entire thread (taking into account pagination). if($mybb->input['action'] == "thread") {
|
if($thread['firstpost'] == 0) {
| // This is a workaround to fix threads which data may get "corrupted" due to lag or other still unknown reasons if($thread['firstpost'] == 0 || $thread['dateline'] == 0) {
|
update_first_post($tid); }
| update_first_post($tid); }
|
Zeile 453 | Zeile 482 |
---|
$now = TIME_NOW;
// If the poll or the thread is closed or if the poll is expired, show the results.
|
$now = TIME_NOW;
// If the poll or the thread is closed or if the poll is expired, show the results.
|
if($poll['closed'] == 1 || $thread['closed'] == 1 || ($expiretime < $now && $poll['timeout'] > 0))
| if($poll['closed'] == 1 || $thread['closed'] == 1 || ($expiretime < $now && $poll['timeout'] > 0) || $forumpermissions['canvotepolls'] != 1)
|
{ $showresults = 1; }
|
{ $showresults = 1; }
|
// If the user is not a guest, check if he already voted. if($mybb->user['uid'] != 0) { $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; } }
| if($forumpermissions['canvotepolls'] != 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']);
| $optionsarray = explode("||~|~||", $poll['options']); $votesarray = explode("||~|~||", $poll['votes']); $poll['question'] = htmlspecialchars_uni($poll['question']);
|
Zeile 485 | Zeile 519 |
---|
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];
|
}
| }
|
// Loop through the poll options. for($i = 1; $i <= $poll['numoptions']; ++$i)
| // Loop through the poll options. for($i = 1; $i <= $poll['numoptions']; ++$i)
|
Zeile 525 | Zeile 559 |
---|
{ $optionbg = "trow1"; $votestar = "";
|
{ $optionbg = "trow1"; $votestar = "";
|
}
| }
|
// If the user already voted or if the results need to be shown, do so; else show voting screen. if(isset($alreadyvoted) || isset($showresults))
| // If the user already voted or if the results need to be shown, do so; else show voting screen. if(isset($alreadyvoted) || isset($showresults))
|
Zeile 572 | Zeile 606 |
---|
}
// 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) { $pollstatus = $lang->already_voted;
|
{ if($alreadyvoted) { $pollstatus = $lang->already_voted;
|
| $undovote = '';
|
if($mybb->usergroup['canundovotes'] == 1) {
|
if($mybb->usergroup['canundovotes'] == 1) {
|
eval("\$pollstatus .= \"".$templates->get("showthread_poll_undovote")."\";");
| eval("\$undovote = \"".$templates->get("showthread_poll_undovote")."\";");
|
}
|
}
|
| } elseif($nopermission) { $pollstatus = $lang->no_voting_permission;
|
} else { $pollstatus = $lang->poll_closed; }
|
} else { $pollstatus = $lang->poll_closed; }
|
|
|
$lang->total_votes = $lang->sprintf($lang->total_votes, $totalvotes); eval("\$pollbox = \"".$templates->get("showthread_poll_results")."\";"); $plugins->run_hooks("showthread_poll_results");
| $lang->total_votes = $lang->sprintf($lang->total_votes, $totalvotes); eval("\$pollbox = \"".$templates->get("showthread_poll_results")."\";"); $plugins->run_hooks("showthread_poll_results");
|
Zeile 743 | Zeile 783 |
---|
elseif($ismod && is_moderator($fid, "canviewdeleted") == true && is_moderator($fid, "canviewunapprove") == true) { $visible = "AND p.visible IN (-1,0,1)";
|
elseif($ismod && is_moderator($fid, "canviewdeleted") == true && is_moderator($fid, "canviewunapprove") == true) { $visible = "AND p.visible IN (-1,0,1)";
|
| } elseif($forumpermissions['canviewdeletionnotice'] != 0 && $ismod == false) { $visible = "AND p.visible IN (-1,1)";
|
} else {
| } else {
|
Zeile 818 | Zeile 862 |
---|
$where = " ORDER BY dateline LIMIT 0, 1"; } $query = $db->query("
|
$where = " ORDER BY dateline LIMIT 0, 1"; } $query = $db->query("
|
SELECT u.*, u.username AS userusername, p.*, f.*, eu.username AS editusername
| SELECT u.*, u.username AS userusername, p.*, f.*, r.reporters, eu.username AS editusername
|
FROM ".TABLE_PREFIX."posts p
|
FROM ".TABLE_PREFIX."posts p
|
| LEFT JOIN ".TABLE_PREFIX."reportedcontent r ON (r.id=p.pid AND r.type='post' AND r.reportstatus != 1)
|
LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid=p.uid) LEFT JOIN ".TABLE_PREFIX."userfields f ON (f.ufid=u.uid) LEFT JOIN ".TABLE_PREFIX."users eu ON (eu.uid=p.edituid)
| LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid=p.uid) LEFT JOIN ".TABLE_PREFIX."userfields f ON (f.ufid=u.uid) LEFT JOIN ".TABLE_PREFIX."users eu ON (eu.uid=p.edituid)
|
Zeile 850 | Zeile 895 |
---|
} }
|
} }
|
// Build the threaded post display tree. $query = $db->query("
| // Build the threaded post display tree. $query = $db->query("
|
SELECT p.username, p.uid, p.pid, p.replyto, p.subject, p.dateline FROM ".TABLE_PREFIX."posts p WHERE p.tid='$tid' $visible ORDER BY p.dateline ");
|
SELECT p.username, p.uid, p.pid, p.replyto, p.subject, p.dateline FROM ".TABLE_PREFIX."posts p WHERE p.tid='$tid' $visible ORDER BY p.dateline ");
|
| if(!is_array($postsdone)) { $postsdone = array(); }
|
while($post = $db->fetch_array($query)) { if(!$postsdone[$post['pid']])
| while($post = $db->fetch_array($query)) { if(!$postsdone[$post['pid']])
|
Zeile 894 | Zeile 943 |
---|
}
if(!empty($mybb->input['pid']))
|
}
if(!empty($mybb->input['pid']))
|
{
| {
|
$post = get_post($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'))) { $footer .= '<script type="text/javascript">$(document).ready(function() { $.jGrowl(\''.$lang->error_invalidpost.'\', {theme: \'jgrowl_error\'}); });</script>';
| if(empty($post) || ($post['visible'] == 0 && !is_moderator($post['fid'], 'canviewunapprove')) || ($post['visible'] == -1 && !is_moderator($post['fid'], 'canviewdeleted') && $forumpermissions['canviewdeletionnotice'] == 0)) { $footer .= '<script type="text/javascript">$(function() { $.jGrowl(\''.$lang->error_invalidpost.'\', {theme: \'jgrowl_error\'}); });</script>';
|
} else {
| } else {
|
Zeile 910 | Zeile 959 |
---|
"); $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 = $result / $perpage; } else
|
Zeile 920 | Zeile 969 |
---|
} }
|
} }
|
// Recount replies if user is a moderator to take into account unapproved posts. if($ismod)
| // Recount replies if user is a moderator or can see the deletion notice to take into account unapproved/deleted posts. if($ismod || $forumpermissions['canviewdeletionnotice'] != 0)
|
{ $query = $db->simple_select("posts p", "COUNT(*) AS replies", "p.tid='$tid' $visible"); $cached_replies = $thread['replies']+$thread['unapprovedposts']+$thread['deletedposts'];
| { $query = $db->simple_select("posts p", "COUNT(*) AS replies", "p.tid='$tid' $visible"); $cached_replies = $thread['replies']+$thread['unapprovedposts']+$thread['deletedposts'];
|
Zeile 935 | Zeile 984 |
---|
rebuild_thread_counters($thread['tid']); } }
|
rebuild_thread_counters($thread['tid']); } }
|
| elseif($forumpermissions['canviewdeletionnotice'] != 0) { $thread['replies'] += $thread['deletedposts']; }
|
$postcount = (int)$thread['replies']+1; $pages = $postcount / $perpage; $pages = ceil($pages);
if($mybb->get_input('page') == "last")
|
$postcount = (int)$thread['replies']+1; $pages = $postcount / $perpage; $pages = ceil($pages);
if($mybb->get_input('page') == "last")
|
{
| {
|
$page = $pages; }
| $page = $pages; }
|
Zeile 969 | Zeile 1022 |
---|
if($mybb->get_input('highlight')) { $highlight = "?highlight=".urlencode($mybb->get_input('highlight'));
|
if($mybb->get_input('highlight')) { $highlight = "?highlight=".urlencode($mybb->get_input('highlight'));
|
}
| }
|
if($defaultmode != "linear") { if($mybb->get_input('highlight'))
| if($defaultmode != "linear") { if($mybb->get_input('highlight'))
|
Zeile 988 | Zeile 1041 |
---|
if(!empty($mybb->input['highlight'])) { if(is_array($mybb->input['highlight']))
|
if(!empty($mybb->input['highlight'])) { if(is_array($mybb->input['highlight']))
|
{
| {
|
foreach($mybb->input['highlight'] as $highlight_word) { $highlight .= "&highlight[]=".urlencode($highlight_word); }
|
foreach($mybb->input['highlight'] as $highlight_word) { $highlight .= "&highlight[]=".urlencode($highlight_word); }
|
}
| }
|
else { $highlight = "&highlight=".urlencode($mybb->get_input('highlight'));
| else { $highlight = "&highlight=".urlencode($mybb->get_input('highlight'));
|
Zeile 1007 | Zeile 1060 |
---|
}
$multipage = multipage($postcount, $perpage, $page, str_replace("{tid}", $tid, THREAD_URL_PAGED.$highlight.$threadmode));
|
}
$multipage = multipage($postcount, $perpage, $page, str_replace("{tid}", $tid, THREAD_URL_PAGED.$highlight.$threadmode));
|
| // Allow originator to see own unapproved posts if($mybb->user['uid'] && $mybb->settings['showownunapproved']) { $visible .= " OR (p.tid='$tid' AND p.visible='0' AND p.uid=".$mybb->user['uid'].")"; }
|
// Lets get the pids of the posts on this page. $pids = "";
| // Lets get the pids of the posts on this page. $pids = "";
|
Zeile 1049 | Zeile 1108 |
---|
// Get the actual posts from the database here. $posts = ''; $query = $db->query("
|
// Get the actual posts from the database here. $posts = ''; $query = $db->query("
|
SELECT u.*, u.username AS userusername, p.*, f.*, eu.username AS editusername
| SELECT u.*, u.username AS userusername, p.*, f.*, r.reporters, eu.username AS editusername
|
FROM ".TABLE_PREFIX."posts p
|
FROM ".TABLE_PREFIX."posts p
|
| LEFT JOIN ".TABLE_PREFIX."reportedcontent r ON (r.id=p.pid AND r.type='post' AND r.reportstatus != 1)
|
LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid=p.uid) LEFT JOIN ".TABLE_PREFIX."userfields f ON (f.ufid=u.uid) LEFT JOIN ".TABLE_PREFIX."users eu ON (eu.uid=p.edituid)
| LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid=p.uid) LEFT JOIN ".TABLE_PREFIX."userfields f ON (f.ufid=u.uid) LEFT JOIN ".TABLE_PREFIX."users eu ON (eu.uid=p.edituid)
|
Zeile 1221 | Zeile 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 1229 | Zeile 1289 |
---|
} }
|
} }
|
$posthash = md5($mybb->user['uid'].random_str());
| $posthash = md5($mybb->user['uid'].random_str()); $expaltext = (in_array("quickreply", $collapse)) ? "[+]" : "[-]";
|
eval("\$quickreply = \"".$templates->get("showthread_quickreply")."\";"); }
| eval("\$quickreply = \"".$templates->get("showthread_quickreply")."\";"); }
|
Zeile 1249 | Zeile 1310 |
---|
{ eval("\$viewnotes = \"".$templates->get("showthread_threadnotes_viewnotes")."\";"); $thread['notes'] = my_substr($thread['notes'], 0, 200)."... {$viewnotes}";
|
{ eval("\$viewnotes = \"".$templates->get("showthread_threadnotes_viewnotes")."\";"); $thread['notes'] = my_substr($thread['notes'], 0, 200)."... {$viewnotes}";
|
}
| }
$expaltext = (in_array("threadnotes", $collapse)) ? "[+]" : "[-]";
|
eval("\$threadnotesbox = \"".$templates->get("showthread_threadnotes")."\";"); }
| eval("\$threadnotesbox = \"".$templates->get("showthread_threadnotes")."\";"); }
|
Zeile 1263 | Zeile 1325 |
---|
{ case "pgsql": case "sqlite":
|
{ case "pgsql": case "sqlite":
|
foreach($gids as $gid) {
| foreach($gids as $gid) {
|
$gid = (int)$gid; $gidswhere .= " OR ','||groups||',' LIKE '%,{$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})");
|
$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;
| break;
|
default: foreach($gids as $gid) { $gid = (int)$gid;
|
default: foreach($gids as $gid) { $gid = (int)$gid;
|
$gidswhere .= " OR CONCAT(',',groups,',') LIKE '%,{$gid},%'";
| $gidswhere .= " OR CONCAT(',',`groups`,',') LIKE '%,{$gid},%'";
|
}
|
}
|
$query = $db->simple_select("modtools", 'tid, name, type', "(CONCAT(',',forums,',') LIKE '%,$fid,%' OR CONCAT(',',forums,',') LIKE '%,-1,%' OR forums='') AND (groups='' OR CONCAT(',',groups,',') LIKE '%,-1,%'{$gidswhere})");
| $query = $db->simple_select("modtools", 'tid, name, type', "(CONCAT(',',forums,',') LIKE '%,$fid,%' OR CONCAT(',',forums,',') LIKE '%,-1,%' OR forums='') AND (`groups`='' OR CONCAT(',',`groups`,',') LIKE '%,-1,%'{$gidswhere})");
|
break;
|
break;
|
}
| }
|
while($tool = $db->fetch_array($query)) {
|
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 1319 | Zeile 1382 |
---|
if(is_moderator($forum['fid'], "canmanagethreads")) { eval("\$inlinemodmanage = \"".$templates->get("showthread_inlinemoderation_manage")."\";");
|
if(is_moderator($forum['fid'], "canmanagethreads")) { eval("\$inlinemodmanage = \"".$templates->get("showthread_inlinemoderation_manage")."\";");
|
}
| }
|
if(is_moderator($forum['fid'], "canapproveunapproveposts"))
|
if(is_moderator($forum['fid'], "canapproveunapproveposts"))
|
{
| {
|
eval("\$inlinemodapprove = \"".$templates->get("showthread_inlinemoderation_approve")."\";");
|
eval("\$inlinemodapprove = \"".$templates->get("showthread_inlinemoderation_approve")."\";");
|
}
| }
|
if(!empty($inlinemodsoftdelete) || !empty($inlinemodrestore) || !empty($inlinemoddelete) || !empty($inlinemodmanage) || !empty($inlinemodapprove)) { eval("\$standardposttools = \"".$templates->get("showthread_inlinemoderation_standard")."\";");
| if(!empty($inlinemodsoftdelete) || !empty($inlinemodrestore) || !empty($inlinemoddelete) || !empty($inlinemodmanage) || !empty($inlinemodapprove)) { eval("\$standardposttools = \"".$templates->get("showthread_inlinemoderation_standard")."\";");
|
Zeile 1333 | Zeile 1396 |
---|
// Only show inline mod menu if there's options to show if(!empty($standardposttools) || !empty($customposttools))
|
// Only show inline mod menu if there's options to show if(!empty($standardposttools) || !empty($customposttools))
|
{
| {
|
eval("\$inlinemod = \"".$templates->get("showthread_inlinemoderation")."\";");
|
eval("\$inlinemod = \"".$templates->get("showthread_inlinemoderation")."\";");
|
}
| }
|
// Build thread moderation dropdown if(!empty($customthreadtools))
|
// Build thread moderation dropdown if(!empty($customthreadtools))
|
{
| {
|
eval("\$customthreadtools = \"".$templates->get("showthread_moderationoptions_custom")."\";");
|
eval("\$customthreadtools = \"".$templates->get("showthread_moderationoptions_custom")."\";");
|
}
| }
|
$openclosethread = $stickunstickthread = $deletethread = $threadnotes = $managethread = $adminpolloptions = $approveunapprovethread = $softdeletethread = '';
if(is_moderator($forum['fid'], "canopenclosethreads")) { eval("\$openclosethread = \"".$templates->get("showthread_moderationoptions_openclose")."\";");
|
$openclosethread = $stickunstickthread = $deletethread = $threadnotes = $managethread = $adminpolloptions = $approveunapprovethread = $softdeletethread = '';
if(is_moderator($forum['fid'], "canopenclosethreads")) { eval("\$openclosethread = \"".$templates->get("showthread_moderationoptions_openclose")."\";");
|
}
| }
|
if(is_moderator($forum['fid'], "canstickunstickthreads")) {
| if(is_moderator($forum['fid'], "canstickunstickthreads")) {
|
Zeile 1356 | Zeile 1419 |
---|
}
if(is_moderator($forum['fid'], "candeletethreads"))
|
}
if(is_moderator($forum['fid'], "candeletethreads"))
|
{
| {
|
eval("\$deletethread = \"".$templates->get("showthread_moderationoptions_delete")."\";");
|
eval("\$deletethread = \"".$templates->get("showthread_moderationoptions_delete")."\";");
|
}
| }
|
if(is_moderator($forum['fid'], "canmanagethreads")) { eval("\$threadnotes = \"".$templates->get("showthread_moderationoptions_threadnotes")."\";"); eval("\$managethread = \"".$templates->get("showthread_moderationoptions_manage")."\";");
|
if(is_moderator($forum['fid'], "canmanagethreads")) { eval("\$threadnotes = \"".$templates->get("showthread_moderationoptions_threadnotes")."\";"); eval("\$managethread = \"".$templates->get("showthread_moderationoptions_manage")."\";");
|
}
| }
|
if($pollbox && is_moderator($forum['fid'], "canmanagepolls"))
|
if($pollbox && is_moderator($forum['fid'], "canmanagepolls"))
|
{
| {
|
eval("\$adminpolloptions = \"".$templates->get("showthread_moderationoptions_deletepoll")."\";"); }
| eval("\$adminpolloptions = \"".$templates->get("showthread_moderationoptions_deletepoll")."\";"); }
|
Zeile 1378 | Zeile 1441 |
---|
eval("\$approveunapprovethread = \"".$templates->get("showthread_moderationoptions_approve")."\";"); } else
|
eval("\$approveunapprovethread = \"".$templates->get("showthread_moderationoptions_approve")."\";"); } else
|
{
| {
|
eval("\$approveunapprovethread = \"".$templates->get("showthread_moderationoptions_unapprove")."\";"); }
|
eval("\$approveunapprovethread = \"".$templates->get("showthread_moderationoptions_unapprove")."\";"); }
|
}
| }
|
if(is_moderator($forum['fid'], "cansoftdeletethreads") && $thread['visible'] != -1)
|
if(is_moderator($forum['fid'], "cansoftdeletethreads") && $thread['visible'] != -1)
|
{
| {
|
eval("\$softdeletethread = \"".$templates->get("showthread_moderationoptions_softdelete")."\";"); } elseif(is_moderator($forum['fid'], "canrestorethreads") && $thread['visible'] == -1) { eval("\$softdeletethread = \"".$templates->get("showthread_moderationoptions_restore")."\";");
|
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))
|
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 1401 | Zeile 1464 |
---|
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 1432 | Zeile 1497 |
---|
$add_remove_subscription = 'remove'; $add_remove_subscription_text = $lang->unsubscribe_thread; }
|
$add_remove_subscription = 'remove'; $add_remove_subscription_text = $lang->unsubscribe_thread; }
|
| eval("\$addremovesubscription = \"".$templates->get("showthread_subscription")."\";");
|
}
$classic_header = '';
| }
$classic_header = '';
|
Zeile 1451 | Zeile 1518 |
---|
$inviscount = 0; $onlinemembers = ''; $doneusers = array();
|
$inviscount = 0; $onlinemembers = ''; $doneusers = array();
|
| $query = $db->simple_select("sessions", "COUNT(DISTINCT ip) AS guestcount", "uid = 0 AND time > $timecut AND location2 = $tid AND nopermission != 1"); $guestcount = $db->fetch_field($query, 'guestcount');
|
$query = $db->query("
|
$query = $db->query("
|
SELECT s.ip, s.uid, s.time, u.username, u.invisible, u.usergroup, u.displaygroup FROM ".TABLE_PREFIX."sessions s LEFT JOIN ".TABLE_PREFIX."users u ON (s.uid=u.uid) WHERE s.time > '$timecut' AND location2='$tid' AND nopermission != 1
| SELECT s.ip, s.uid, s.time, u.username, u.invisible, u.usergroup, u.displaygroup FROM ".TABLE_PREFIX."sessions s LEFT JOIN ".TABLE_PREFIX."users u ON (s.uid=u.uid) WHERE s.uid != 0 AND s.time > '$timecut' AND location2='$tid' AND nopermission != 1
|
ORDER BY u.username ASC, s.time DESC ");
while($user = $db->fetch_array($query)) {
|
ORDER BY u.username ASC, s.time DESC ");
while($user = $db->fetch_array($query)) {
|
if($user['uid'] == 0) { ++$guestcount; } else if(empty($doneusers[$user['uid']]) || $doneusers[$user['uid']] < $user['time'])
| if(empty($doneusers[$user['uid']]) || $doneusers[$user['uid']] < $user['time'])
|
{ ++$membercount; $doneusers[$user['uid']] = $user['time'];
| { ++$membercount; $doneusers[$user['uid']] = $user['time'];
|
Zeile 1512 | Zeile 1580 |
---|
{ $onlinesep = $lang->comma; }
|
{ $onlinesep = $lang->comma; }
|
|
|
$onlinesep2 = ''; if($invisonline != '' && $guestcount || $onlinemembers && $guestcount) { $onlinesep2 = $lang->comma; }
|
$onlinesep2 = ''; if($invisonline != '' && $guestcount || $onlinemembers && $guestcount) { $onlinesep2 = $lang->comma; }
|
|
|
eval("\$usersbrowsing = \"".$templates->get("showthread_usersbrowsing")."\";");
|
eval("\$usersbrowsing = \"".$templates->get("showthread_usersbrowsing")."\";");
|
| }
if($thread['visible'] == -1 ) { $thread_deleted = 1;
|
}
$plugins->run_hooks("showthread_end");
| }
$plugins->run_hooks("showthread_end");
|