Zeile 6 | Zeile 6 |
---|
* Website: http://mybb.com * License: http://mybb.com/about/license *
|
* Website: http://mybb.com * License: http://mybb.com/about/license *
|
* $Id: forumdisplay.php 5016 2010-06-12 00:24:02Z RyanGordon $
| * $Id$
|
*/
define("IN_MYBB", 1); define('THIS_SCRIPT', 'forumdisplay.php');
|
*/
define("IN_MYBB", 1); define('THIS_SCRIPT', 'forumdisplay.php');
|
$templatelist = "forumdisplay,forumdisplay_thread,breadcrumb_bit,forumbit_depth1_cat,forumbit_depth1_forum,forumbit_depth2_cat,forumbit_depth2_forum,forumdisplay_subforums,forumdisplay_threadlist,forumdisplay_moderatedby_moderator,forumdisplay_moderatedby,forumdisplay_newthread,forumdisplay_searchforum,forumdisplay_orderarrow,forumdisplay_thread_rating,forumdisplay_announcement,forumdisplay_threadlist_rating,forumdisplay_threadlist_sortrating,forumdisplay_subforums_modcolumn,forumbit_moderators,forumbit_subforums,forumbit_depth2_forum_lastpost";
| $templatelist = "forumdisplay,forumdisplay_thread,forumbit_depth1_cat,forumbit_depth1_forum,forumbit_depth2_cat,forumbit_depth2_forum,forumdisplay_subforums,forumdisplay_threadlist,forumdisplay_moderatedby,forumdisplay_newthread,forumdisplay_searchforum,forumdisplay_orderarrow,forumdisplay_thread_rating,forumdisplay_threadlist_rating,forumdisplay_threadlist_sortrating,forumbit_moderators,forumbit_subforums,forumbit_depth2_forum_lastpost";
|
$templatelist .= ",forumbit_depth1_forum_lastpost,forumdisplay_thread_multipage_page,forumdisplay_thread_multipage,forumdisplay_thread_multipage_more"; $templatelist .= ",multipage_prevpage,multipage_nextpage,multipage_page_current,multipage_page,multipage_start,multipage_end,multipage";
|
$templatelist .= ",forumbit_depth1_forum_lastpost,forumdisplay_thread_multipage_page,forumdisplay_thread_multipage,forumdisplay_thread_multipage_more"; $templatelist .= ",multipage_prevpage,multipage_nextpage,multipage_page_current,multipage_page,multipage_start,multipage_end,multipage";
|
$templatelist .= ",forumjump_advanced,forumjump_special,forumjump_bit"; $templatelist .= ",forumdisplay_usersbrowsing_guests,forumdisplay_usersbrowsing_user,forumdisplay_usersbrowsing,forumdisplay_inlinemoderation,forumdisplay_thread_modbit,forumdisplay_inlinemoderation_col";
| $templatelist .= ",forumjump_advanced,forumjump_special,forumjump_bit,forumdisplay_password_wrongpass,forumdisplay_password"; $templatelist .= ",forumdisplay_usersbrowsing_user,forumdisplay_usersbrowsing,forumdisplay_inlinemoderation,forumdisplay_thread_modbit,forumdisplay_inlinemoderation_col,forumdisplay_inlinemoderation_selectall,forumdisplay_threadlist_clearpass";
|
$templatelist .= ",forumdisplay_announcements_announcement,forumdisplay_announcements,forumdisplay_threads_sep,forumbit_depth3_statusicon,forumbit_depth3,forumdisplay_sticky_sep,forumdisplay_thread_attachment_count,forumdisplay_threadlist_inlineedit_js,forumdisplay_rssdiscovery,forumdisplay_announcement_rating,forumdisplay_announcements_announcement_modbit,forumdisplay_rules,forumdisplay_rules_link,forumdisplay_thread_gotounread,forumdisplay_nothreads,forumdisplay_inlinemoderation_custom_tool,forumdisplay_inlinemoderation_custom"; require_once "./global.php"; require_once MYBB_ROOT."inc/functions_post.php"; require_once MYBB_ROOT."inc/functions_forumlist.php"; require_once MYBB_ROOT."inc/class_parser.php"; $parser = new postParser;
|
$templatelist .= ",forumdisplay_announcements_announcement,forumdisplay_announcements,forumdisplay_threads_sep,forumbit_depth3_statusicon,forumbit_depth3,forumdisplay_sticky_sep,forumdisplay_thread_attachment_count,forumdisplay_threadlist_inlineedit_js,forumdisplay_rssdiscovery,forumdisplay_announcement_rating,forumdisplay_announcements_announcement_modbit,forumdisplay_rules,forumdisplay_rules_link,forumdisplay_thread_gotounread,forumdisplay_nothreads,forumdisplay_inlinemoderation_custom_tool,forumdisplay_inlinemoderation_custom"; require_once "./global.php"; require_once MYBB_ROOT."inc/functions_post.php"; require_once MYBB_ROOT."inc/functions_forumlist.php"; require_once MYBB_ROOT."inc/class_parser.php"; $parser = new postParser;
|
| $orderarrow = $sortsel = array('rating' => '', 'subject' => '', 'starter' => '', 'started' => '', 'replies' => '', 'views' => ''); $ordersel = array('asc' => '', 'desc' => ''); $datecutsel = array(1 => '', 5 => '', 10 => '', 20 => '', 50 => '', 75 => '', 100 => '', 365 => '', 9999 => ''); $rules = '';
|
// Load global language phrases $lang->load("forumdisplay");
| // Load global language phrases $lang->load("forumdisplay");
|
Zeile 83 | Zeile 88 |
---|
if($mybb->user['uid'] == 0) {
|
if($mybb->user['uid'] == 0) {
|
// Build a forum cache. $query = $db->query(" SELECT * FROM ".TABLE_PREFIX."forums WHERE active != 0 ORDER BY pid, disporder "); $forumsread = unserialize($mybb->cookies['mybb']['forumread']);
| // Cookie'd forum read time $forumsread = my_unserialize($mybb->cookies['mybb']['forumread']);
|
|
|
if(!is_array($forumsread)) { $forumsread = array(); }
| if(is_array($forumsread) && empty($forumsread)) { if($mybb->cookies['mybb']['readallforums']) { $forumsread[$fid] = $mybb->cookies['mybb']['lastvisit']; } else { $forumsread = array(); } }
$query = $db->simple_select("forums", "*", "active != 0", array("order_by" => "pid, disporder"));
|
}
|
}
|
else { // Build a forum cache. $query = $db->query("
| else { // Build a forum cache from the database $query = $db->query("
|
SELECT f.*, fr.dateline AS lastread FROM ".TABLE_PREFIX."forums f LEFT JOIN ".TABLE_PREFIX."forumsread fr ON (fr.fid=f.fid AND fr.uid='{$mybb->user['uid']}')
| SELECT f.*, fr.dateline AS lastread FROM ".TABLE_PREFIX."forums f LEFT JOIN ".TABLE_PREFIX."forumsread fr ON (fr.fid=f.fid AND fr.uid='{$mybb->user['uid']}')
|
Zeile 109 | Zeile 116 |
---|
ORDER BY pid, disporder "); }
|
ORDER BY pid, disporder "); }
|
|
|
while($forum = $db->fetch_array($query)) {
|
while($forum = $db->fetch_array($query)) {
|
if($mybb->user['uid'] == 0)
| if($mybb->user['uid'] == 0 && $forumsread[$forum['fid']])
|
{
|
{
|
if($forumsread[$forum['fid']]) { $forum['lastread'] = $forumsread[$forum['fid']]; }
| $forum['lastread'] = $forumsread[$forum['fid']];
|
}
|
}
|
|
|
$fcache[$forum['pid']][$forum['disporder']][$forum['fid']] = $forum; }
| $fcache[$forum['pid']][$forum['disporder']][$forum['fid']] = $forum; }
|
Zeile 136 | Zeile 142 |
---|
{ $showdepth = 2; }
|
{ $showdepth = 2; }
|
| $subforums = '';
|
$child_forums = build_forumbits($fid, 2); $forums = $child_forums['forum_list'];
|
$child_forums = build_forumbits($fid, 2); $forums = $child_forums['forum_list'];
|
|
|
if($forums) { $lang->sub_forums_in = $lang->sprintf($lang->sub_forums_in, $foruminfo['name']);
| if($forums) { $lang->sub_forums_in = $lang->sprintf($lang->sub_forums_in, $foruminfo['name']);
|
Zeile 167 | Zeile 176 |
---|
}
if($fpermissions['cansearch'] != 0 && $foruminfo['type'] == "f")
|
}
if($fpermissions['cansearch'] != 0 && $foruminfo['type'] == "f")
|
{
| {
|
eval("\$searchforum = \"".$templates->get("forumdisplay_searchforum")."\";"); }
|
eval("\$searchforum = \"".$templates->get("forumdisplay_searchforum")."\";"); }
|
| // Gather forum stats $has_announcements = $has_modtools = false; $forum_stats = $cache->read("forumsdisplay");
if(is_array($forum_stats)) { if(!empty($forum_stats[-1]['modtools']) || !empty($forum_stats[$fid]['modtools'])) { // Mod tools are specific to forums, not parents $has_modtools = true; }
if(!empty($forum_stats[-1]['announcements']) || !empty($forum_stats[$fid]['announcements'])) { // Global or forum-specific announcements $has_announcements = true; } }
|
$done_moderators = array( "users" => array(), "groups" => array() );
|
$done_moderators = array( "users" => array(), "groups" => array() );
|
|
|
$moderators = ''; $parentlistexploded = explode(",", $parentlist);
|
$moderators = ''; $parentlistexploded = explode(",", $parentlist);
|
|
|
foreach($parentlistexploded as $mfid) { // This forum has moderators
| foreach($parentlistexploded as $mfid) { // This forum has moderators
|
Zeile 195 | Zeile 225 |
---|
} $moderators .= $comma.htmlspecialchars_uni($moderator['title']); $done_moderators['groups'][] = $moderator['id'];
|
} $moderators .= $comma.htmlspecialchars_uni($moderator['title']); $done_moderators['groups'][] = $moderator['id'];
|
} else {
| } else {
|
if(in_array($moderator['id'], $done_moderators['users'])) { continue;
| if(in_array($moderator['id'], $done_moderators['users'])) { continue;
|
Zeile 208 | Zeile 238 |
---|
$comma = $lang->comma; } }
|
$comma = $lang->comma; } }
|
| }
if(!empty($forum_stats[$mfid]['announcements'])) { $has_announcements = true;
|
} } $comma = '';
| } } $comma = '';
|
Zeile 232 | Zeile 267 |
---|
$membercount = 0; $inviscount = 0; $onlinemembers = '';
|
$membercount = 0; $inviscount = 0; $onlinemembers = '';
|
| $doneusers = array();
|
$query = $db->query(" SELECT s.ip, s.uid, u.username, s.time, u.invisible, u.usergroup, u.usergroup, u.displaygroup FROM ".TABLE_PREFIX."sessions s
| $query = $db->query(" SELECT s.ip, s.uid, u.username, s.time, u.invisible, u.usergroup, u.usergroup, u.displaygroup FROM ".TABLE_PREFIX."sessions s
|
Zeile 239 | Zeile 276 |
---|
WHERE s.time > '$timecut' AND location1='$fid' AND nopermission != 1 ORDER BY u.username ASC, s.time DESC ");
|
WHERE s.time > '$timecut' AND location1='$fid' AND nopermission != 1 ORDER BY u.username ASC, s.time DESC ");
|
|
|
while($user = $db->fetch_array($query)) { if($user['uid'] == 0)
|
while($user = $db->fetch_array($query)) { if($user['uid'] == 0)
|
{
| {
|
++$guestcount; } else {
|
++$guestcount; } else {
|
if($doneusers[$user['uid']] < $user['time'] || !$doneusers[$user['uid']])
| if(empty($doneusers[$user['uid']]) || $doneusers[$user['uid']] < $user['time'])
|
{ $doneusers[$user['uid']] = $user['time']; ++$membercount;
| { $doneusers[$user['uid']] = $user['time']; ++$membercount;
|
Zeile 271 | Zeile 309 |
---|
} } }
|
} } }
|
| $guestsonline = '';
|
if($guestcount)
|
if($guestcount)
|
{
| {
|
$guestsonline = $lang->sprintf($lang->users_browsing_forum_guests, $guestcount);
|
$guestsonline = $lang->sprintf($lang->users_browsing_forum_guests, $guestcount);
|
}
| }
$onlinesep = '';
|
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_forum_invis, $inviscount); }
|
$invisonline = ''; if($inviscount && $mybb->usergroup['canviewwolinvis'] != 1 && ($inviscount != 1 && $mybb->user['invisible'] != 1)) { $invisonline = $lang->sprintf($lang->users_browsing_forum_invis, $inviscount); }
|
| $onlinesep2 = '';
|
if($invisonline != '' && $guestcount) { $onlinesep2 = $lang->comma;
| if($invisonline != '' && $guestcount) { $onlinesep2 = $lang->comma;
|
Zeile 312 | Zeile 353 |
---|
);
$foruminfo['rules'] = $parser->parse_message($foruminfo['rules'], $rules_parser);
|
);
$foruminfo['rules'] = $parser->parse_message($foruminfo['rules'], $rules_parser);
|
if($foruminfo['rulestype'] == 1)
| if($foruminfo['rulestype'] == 1 || $foruminfo['rulestype'] == 3)
|
{ eval("\$rules = \"".$templates->get("forumdisplay_rules")."\";"); }
| { eval("\$rules = \"".$templates->get("forumdisplay_rules")."\";"); }
|
Zeile 358 | Zeile 399 |
---|
// Pick out some sorting options. // First, the date cut for the threads. $datecut = 0;
|
// Pick out some sorting options. // First, the date cut for the threads. $datecut = 0;
|
if(!$mybb->input['datecut'])
| if(empty($mybb->input['datecut']))
|
{ // If the user manually set a date cut, use it. if($mybb->user['daysprune'])
| { // If the user manually set a date cut, use it. if($mybb->user['daysprune'])
|
Zeile 400 | Zeile 441 |
---|
$mybb->input['order'] = $foruminfo['defaultsortorder']; }
|
$mybb->input['order'] = $foruminfo['defaultsortorder']; }
|
$mybb->input['order'] = htmlspecialchars($mybb->input['order']);
| if(!empty($mybb->input['order'])) { $mybb->input['order'] = htmlspecialchars_uni($mybb->input['order']); } else { $mybb->input['order'] = ''; }
|
switch(my_strtolower($mybb->input['order']))
|
switch(my_strtolower($mybb->input['order']))
|
{
| {
|
case "asc": $sortordernow = "asc"; $ordersel['asc'] = "selected=\"selected\""; $oppsort = $lang->desc; $oppsortnext = "desc";
|
case "asc": $sortordernow = "asc"; $ordersel['asc'] = "selected=\"selected\""; $oppsort = $lang->desc; $oppsortnext = "desc";
|
break;
| break;
|
default: $sortordernow = "desc"; $ordersel['desc'] = "selected=\"selected\"";
| default: $sortordernow = "desc"; $ordersel['desc'] = "selected=\"selected\"";
|
Zeile 425 | Zeile 473 |
---|
}
$t = "t.";
|
}
$t = "t.";
|
| $sortfield2 = '';
if(!empty($mybb->input['sortby'])) { $sortby = htmlspecialchars_uni($mybb->input['sortby']); } else { $mybb->input['sortby'] = ''; }
|
|
|
$sortby = htmlspecialchars($mybb->input['sortby']);
| |
switch($mybb->input['sortby']) { case "subject":
| switch($mybb->input['sortby']) { case "subject":
|
Zeile 456 | Zeile 513 |
---|
break; }
|
break; }
|
| $sortsel['rating'] = ''; // Needs to be initialized in order to speed-up things. Fixes #2031
|
$sortsel[$mybb->input['sortby']] = "selected=\"selected\"";
// Pick the right string to join the sort URL
|
$sortsel[$mybb->input['sortby']] = "selected=\"selected\"";
// Pick the right string to join the sort URL
|
if($mybb->settings['seourls'] == "yes" || ($mybb->settings['seourls'] == "auto" && $_SERVER['SEO_SUPPORT'] == 1))
| if($mybb->settings['seourls'] == "yes" || ($mybb->settings['seourls'] == "auto" && isset($_SERVER['SEO_SUPPORT']) && $_SERVER['SEO_SUPPORT'] == 1))
|
{ $string = "?"; }
| { $string = "?"; }
|
Zeile 477 | Zeile 535 |
---|
{ $sorturl = get_forum_link($fid).$string."datecut=$datecut"; }
|
{ $sorturl = get_forum_link($fid).$string."datecut=$datecut"; }
|
| // Needs to be initialized in order to speed-up things. Fixes #2031 $orderarrow = array('rating'=>'', 'subject'=>'', 'starter'=>'', 'replies'=>'', 'views'=>'');
|
eval("\$orderarrow['$sortby'] = \"".$templates->get("forumdisplay_orderarrow")."\";");
$threadcount = 0; $useronly = $tuseronly = "";
|
eval("\$orderarrow['$sortby'] = \"".$templates->get("forumdisplay_orderarrow")."\";");
$threadcount = 0; $useronly = $tuseronly = "";
|
if($fpermissions['canonlyviewownthreads'] == 1)
| if(isset($fpermissions['canonlyviewownthreads']) && $fpermissions['canonlyviewownthreads'] == 1)
|
{ $useronly = "AND uid={$mybb->user['uid']}"; $tuseronly = "AND t.uid={$mybb->user['uid']}";
| { $useronly = "AND uid={$mybb->user['uid']}"; $tuseronly = "AND t.uid={$mybb->user['uid']}";
|
Zeile 491 | Zeile 552 |
---|
{ // How many posts are there?
|
{ // How many posts are there?
|
if($datecut > 0 || $fpermissions['canonlyviewownthreads'] == 1)
| if($datecut > 0 || isset($fpermissions['canonlyviewownthreads']) && $fpermissions['canonlyviewownthreads'] == 1)
|
{ $query = $db->simple_select("threads", "COUNT(tid) AS threads", "fid = '$fid' $useronly $visibleonly $datecutsql"); $threadcount = $db->fetch_field($query, "threads");
| { $query = $db->simple_select("threads", "COUNT(tid) AS threads", "fid = '$fid' $useronly $visibleonly $datecutsql"); $threadcount = $db->fetch_field($query, "threads");
|
Zeile 523 | Zeile 584 |
---|
$perpage = $mybb->settings['threadsperpage'];
|
$perpage = $mybb->settings['threadsperpage'];
|
if(intval($mybb->input['page']) > 0)
| if(isset($mybb->input['page']) && intval($mybb->input['page']) > 0)
|
{ $page = intval($mybb->input['page']); $start = ($page-1) * $perpage;
| { $page = intval($mybb->input['page']); $start = ($page-1) * $perpage;
|
Zeile 555 | Zeile 616 |
---|
{ $page_url = str_replace("{fid}", $fid, FORUM_URL_PAGED);
|
{ $page_url = str_replace("{fid}", $fid, FORUM_URL_PAGED);
|
if($mybb->settings['seourls'] == "yes" || ($mybb->settings['seourls'] == "auto" && $_SERVER['SEO_SUPPORT'] == 1))
| if($mybb->settings['seourls'] == "yes" || ($mybb->settings['seourls'] == "auto" && isset($_SERVER['SEO_SUPPORT']) && $_SERVER['SEO_SUPPORT'] == 1))
|
{ $q = "?"; $and = '';
| { $q = "?"; $and = '';
|
Zeile 566 | Zeile 627 |
---|
$and = "&"; }
|
$and = "&"; }
|
if($sortby != "lastpost")
| if((!empty($foruminfo['defaultsortby']) && $sortby != $foruminfo['defaultsortby']) || (empty($foruminfo['defaultsortby']) && $sortby != "lastpost"))
|
{ $page_url .= "{$q}{$and}sortby={$sortby}"; $q = '';
| { $page_url .= "{$q}{$and}sortby={$sortby}"; $q = '';
|
Zeile 580 | Zeile 641 |
---|
$and = "&"; }
|
$and = "&"; }
|
if($datecut > 0 && $datecut != 9999)
| if($datecut > 0)
|
{ $page_url .= "{$q}{$and}datecut={$datecut}"; }
| { $page_url .= "{$q}{$and}datecut={$datecut}"; }
|
Zeile 591 | Zeile 652 |
---|
} $multipage = multipage($threadcount, $perpage, $page, $page_url);
|
} $multipage = multipage($threadcount, $perpage, $page, $page_url);
|
if($foruminfo['allowtratings'] != 0 && $fpermissions['canviewthreads'] != 0)
| if($mybb->settings['allowthreadratings'] != 0 && $foruminfo['allowtratings'] != 0 && $fpermissions['canviewthreads'] != 0)
|
{ $lang->load("ratethread");
|
{ $lang->load("ratethread");
|
|
|
switch($db->type) { case "pgsql":
| switch($db->type) { case "pgsql":
|
Zeile 602 | Zeile 664 |
---|
default: $ratingadd = "(t.totalratings/t.numratings) AS averagerating, "; }
|
default: $ratingadd = "(t.totalratings/t.numratings) AS averagerating, "; }
|
|
|
$lpbackground = "trow2"; eval("\$ratingcol = \"".$templates->get("forumdisplay_threadlist_rating")."\";"); eval("\$ratingsort = \"".$templates->get("forumdisplay_threadlist_sortrating")."\";"); $colspan = "7";
|
$lpbackground = "trow2"; eval("\$ratingcol = \"".$templates->get("forumdisplay_threadlist_rating")."\";"); eval("\$ratingsort = \"".$templates->get("forumdisplay_threadlist_sortrating")."\";"); $colspan = "7";
|
$select_voting = "\nLEFT JOIN ".TABLE_PREFIX."threadratings r ON(r.tid=t.tid AND r.uid='{$mybb->user['uid']}')"; $select_rating_user = "r.uid AS rated, "; }
| }
|
else { if($sortfield == "averagerating")
| else { if($sortfield == "averagerating")
|
Zeile 619 | Zeile 680 |
---|
$ratingadd = ''; $lpbackground = "trow1"; $colspan = "6";
|
$ratingadd = ''; $lpbackground = "trow1"; $colspan = "6";
|
}
| }
|
if($ismod)
|
if($ismod)
|
{
| {
|
++$colspan; }
|
++$colspan; }
|
// Get Announcements $limit = ''; $announcements = ''; if($mybb->settings['announcementlimit']) { $limit = "LIMIT 0, ".$mybb->settings['announcementlimit']; }
$sql = build_parent_list($fid, "fid", "OR", $parentlist); $time = TIME_NOW; $query = $db->query(" SELECT a.*, u.username FROM ".TABLE_PREFIX."announcements a LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid=a.uid) WHERE a.startdate<='$time' AND (a.enddate>='$time' OR a.enddate='0') AND ($sql OR fid='-1') ORDER BY a.startdate DESC $limit "); $bgcolor = alt_trow(true); // Reset the trow colors while($announcement = $db->fetch_array($query)) { if($announcement['startdate'] > $mybb->user['lastvisit']) { $new_class = ' class="subject_new"'; $folder = "newfolder"; } else { $new_class = ' class="subject_old"'; $folder = "folder"; }
$announcement['announcementlink'] = get_announcement_link($announcement['aid']); $announcement['subject'] = $parser->parse_badwords($announcement['subject']); $announcement['subject'] = htmlspecialchars_uni($announcement['subject']); $postdate = my_date($mybb->settings['dateformat'], $announcement['startdate']); $posttime = my_date($mybb->settings['timeformat'], $announcement['startdate']); $announcement['profilelink'] = build_profile_link($announcement['username'], $announcement['uid']); if($foruminfo['allowtratings'] != 0 && $fpermissions['canviewthreads'] != 0) { eval("\$rating = \"".$templates->get("forumdisplay_announcement_rating")."\";"); $lpbackground = "trow2"; } else { $rating = ''; $lpbackground = "trow1"; } if($ismod) { eval("\$modann = \"".$templates->get("forumdisplay_announcements_announcement_modbit")."\";"); } else { $modann = '';
| // Get Announcements if($has_announcements == true) { $limit = ''; $announcements = ''; if($mybb->settings['announcementlimit']) { $limit = "LIMIT 0, ".$mybb->settings['announcementlimit']; }
$sql = build_parent_list($fid, "fid", "OR", $parentlist); $time = TIME_NOW; $query = $db->query(" SELECT a.*, u.username FROM ".TABLE_PREFIX."announcements a LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid=a.uid) WHERE a.startdate<='$time' AND (a.enddate>='$time' OR a.enddate='0') AND ($sql OR fid='-1') ORDER BY a.startdate DESC $limit ");
// See if this announcement has been read in our announcement array $cookie = array(); if(isset($mybb->cookies['mybb']['announcements'])) { $cookie = my_unserialize(stripslashes($mybb->cookies['mybb']['announcements'])); }
$announcementlist = ''; $bgcolor = alt_trow(true); // Reset the trow colors while($announcement = $db->fetch_array($query)) { if($announcement['startdate'] > $mybb->user['lastvisit'] && !$cookie[$announcement['aid']]) { $new_class = ' class="subject_new"'; $folder = "newfolder"; } else { $new_class = ' class="subject_old"'; $folder = "folder"; }
// Mmm, eat those announcement cookies if they're older than our last visit if($cookie[$announcement['aid']] < $mybb->user['lastvisit']) { unset($cookie[$announcement['aid']]); }
$announcement['announcementlink'] = get_announcement_link($announcement['aid']); $announcement['subject'] = $parser->parse_badwords($announcement['subject']); $announcement['subject'] = htmlspecialchars_uni($announcement['subject']); $postdate = my_date($mybb->settings['dateformat'], $announcement['startdate']); $posttime = my_date($mybb->settings['timeformat'], $announcement['startdate']); $announcement['profilelink'] = build_profile_link($announcement['username'], $announcement['uid']);
if($mybb->settings['allowthreadratings'] != 0 && $foruminfo['allowtratings'] != 0 && $fpermissions['canviewthreads'] != 0) { eval("\$rating = \"".$templates->get("forumdisplay_announcement_rating")."\";"); $lpbackground = "trow2"; } else { $rating = ''; $lpbackground = "trow1"; }
if($ismod) { eval("\$modann = \"".$templates->get("forumdisplay_announcements_announcement_modbit")."\";"); } else { $modann = ''; }
$plugins->run_hooks("forumdisplay_announcement"); eval("\$announcements .= \"".$templates->get("forumdisplay_announcements_announcement")."\";"); $bgcolor = alt_trow(); }
if($announcements) { eval("\$announcementlist = \"".$templates->get("forumdisplay_announcements")."\";"); $shownormalsep = true;
|
}
|
}
|
$plugins->run_hooks("forumdisplay_announcement"); eval("\$announcements .= \"".$templates->get("forumdisplay_announcements_announcement")."\";"); $bgcolor = alt_trow(); }
| |
|
|
if($announcements) { eval("\$announcementlist = \"".$templates->get("forumdisplay_announcements")."\";"); $shownormalsep = true; }
$icon_cache = $cache->read("posticons");
| if(empty($cookie)) { // Clean up cookie crumbs my_setcookie('mybb[announcements]', 0, (TIME_NOW - (60*60*24*365))); } else if(!empty($cookie)) { my_setcookie("mybb[announcements]", addslashes(serialize($cookie)), -1); } } else { $announcementlist = ''; }
$tids = $threadcache = array(); $icon_cache = $cache->read("posticons");
|
if($fpermissions['canviewthreads'] != 0) { // Start Getting Threads $query = $db->query("
|
if($fpermissions['canviewthreads'] != 0) { // Start Getting Threads $query = $db->query("
|
SELECT t.*, p.displaystyle AS threadprefix, {$ratingadd}{$select_rating_user}t.username AS threadusername, u.username
| SELECT t.*, {$ratingadd}t.username AS threadusername, u.username
|
FROM ".TABLE_PREFIX."threads t
|
FROM ".TABLE_PREFIX."threads t
|
LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid = t.uid){$select_voting} 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='$fid' $tuseronly $tvisibleonly $datecutsql2
|
WHERE t.fid='$fid' $tuseronly $tvisibleonly $datecutsql2
|
GROUP BY t.tid
| |
ORDER BY t.sticky DESC, {$t}{$sortfield} $sortordernow $sortfield2 LIMIT $start, $perpage ");
|
ORDER BY t.sticky DESC, {$t}{$sortfield} $sortordernow $sortfield2 LIMIT $start, $perpage ");
|
| $ratings = false; $moved_threads = array();
|
while($thread = $db->fetch_array($query)) { $threadcache[$thread['tid']] = $thread;
|
while($thread = $db->fetch_array($query)) { $threadcache[$thread['tid']] = $thread;
|
| if($thread['numratings'] > 0 && $ratings == false) { $ratings = true; // Looks for ratings in the forum }
|
// If this is a moved thread - set the tid for participation marking and thread read marking to that of the moved thread if(substr($thread['closed'], 0, 5) == "moved")
| // If this is a moved thread - set the tid for participation marking and thread read marking to that of the moved thread if(substr($thread['closed'], 0, 5) == "moved")
|
Zeile 722 | Zeile 822 |
---|
{ $moved_threads[$tid] = $thread['tid']; $tids[$thread['tid']] = $tid;
|
{ $moved_threads[$tid] = $thread['tid']; $tids[$thread['tid']] = $tid;
|
}
| }
|
} // Otherwise - set it to the plain thread ID else { $tids[$thread['tid']] = $thread['tid'];
|
} // Otherwise - set it to the plain thread ID else { $tids[$thread['tid']] = $thread['tid'];
|
if($moved_threads[$tid])
| if(isset($moved_threads[$thread['tid']]))
|
{
|
{
|
unset($moved_threads[$tid]);
| unset($moved_threads[$thread['tid']]);
|
} } }
|
} } }
|
} else { $threadcache = $tids = null;
| if($mybb->settings['allowthreadratings'] != 0 && $foruminfo['allowtratings'] != 0 && $mybb->user['uid'] && !empty($tids) && $ratings == true) { // Check if we've rated threads on this page // Guests get the pleasure of not being ID'd, but will be checked when they try and rate $imp = implode(",", $tids); $query = $db->simple_select("threadratings", "tid, uid", "tid IN ({$imp}) AND uid = '{$mybb->user['uid']}'");
while($rating = $db->fetch_array($query)) { $threadcache[$rating['tid']]['rated'] = 1; } }
|
}
// If user has moderation tools available, prepare the Select All feature
| }
// If user has moderation tools available, prepare the Select All feature
|
Zeile 750 | Zeile 859 |
---|
eval("\$selectall = \"".$templates->get("forumdisplay_inlinemoderation_selectall")."\";"); }
|
eval("\$selectall = \"".$templates->get("forumdisplay_inlinemoderation_selectall")."\";"); }
|
if($tids)
| if(!empty($tids))
|
{ $tids = implode(",", $tids); }
// Check participation by the current user in any of these threads - for 'dot' folder icons
|
{ $tids = implode(",", $tids); }
// Check participation by the current user in any of these threads - for 'dot' folder icons
|
if($mybb->settings['dotfolders'] != 0 && $mybb->user['uid'] && $threadcache)
| if($mybb->settings['dotfolders'] != 0 && $mybb->user['uid'] && !empty($threadcache))
|
{
|
{
|
$query = $db->simple_select("posts", "tid,uid", "uid='{$mybb->user['uid']}' AND tid IN ({$tids})");
| $query = $db->simple_select("posts", "tid,uid", "uid='{$mybb->user['uid']}' AND tid IN ({$tids}) {$visibleonly}");
|
while($post = $db->fetch_array($query)) {
|
while($post = $db->fetch_array($query)) {
|
if($moved_threads[$post['tid']])
| if(!empty($moved_threads[$post['tid']]))
|
{ $post['tid'] = $moved_threads[$post['tid']]; }
| { $post['tid'] = $moved_threads[$post['tid']]; }
|
Zeile 773 | Zeile 882 |
---|
}
// Read threads
|
}
// Read threads
|
if($mybb->user['uid'] && $mybb->settings['threadreadcut'] > 0 && $threadcache)
| if($mybb->user['uid'] && $mybb->settings['threadreadcut'] > 0 && !empty($threadcache))
|
{ $query = $db->simple_select("threadsread", "*", "uid='{$mybb->user['uid']}' AND tid IN ({$tids})"); while($readthread = $db->fetch_array($query)) {
|
{ $query = $db->simple_select("threadsread", "*", "uid='{$mybb->user['uid']}' AND tid IN ({$tids})"); while($readthread = $db->fetch_array($query)) {
|
if($moved_threads[$readthread['tid']])
| if(!empty($moved_threads[$readthread['tid']]))
|
{ $readthread['tid'] = $moved_threads[$readthread['tid']]; }
| { $readthread['tid'] = $moved_threads[$readthread['tid']]; }
|
Zeile 803 | Zeile 912 |
---|
else { $forum_read = my_get_array_cookie("forumread", $fid);
|
else { $forum_read = my_get_array_cookie("forumread", $fid);
|
}
| if($mybb->cookies['mybb']['readallforums'] && !$forum_read) { $forum_read = $mybb->cookies['mybb']['lastvisit']; } }
|
$unreadpost = 0; $threads = ''; $load_inline_edit_js = 0;
|
$unreadpost = 0; $threads = ''; $load_inline_edit_js = 0;
|
if(is_array($threadcache))
| if(!empty($threadcache))
|
{
|
{
|
| if(!$mybb->settings['maxmultipagelinks']) { $mybb->settings['maxmultipagelinks'] = 5; }
if(!$mybb->settings['postsperpage']) { $mybb->settings['postperpage'] = 20; }
|
foreach($threadcache as $thread) { $plugins->run_hooks("forumdisplay_thread");
$moved = explode("|", $thread['closed']);
|
foreach($threadcache as $thread) { $plugins->run_hooks("forumdisplay_thread");
$moved = explode("|", $thread['closed']);
|
|
|
if($thread['visible'] == 0) { $bgcolor = "trow_shaded";
| if($thread['visible'] == 0) { $bgcolor = "trow_shaded";
|
Zeile 839 | Zeile 963 |
---|
$thread['author'] = $thread['uid']; if(!$thread['username'])
|
$thread['author'] = $thread['uid']; if(!$thread['username'])
|
{
| {
|
$thread['username'] = $thread['threadusername']; $thread['profilelink'] = $thread['threadusername']; } else
|
$thread['username'] = $thread['threadusername']; $thread['profilelink'] = $thread['threadusername']; } else
|
{
| {
|
$thread['profilelink'] = build_profile_link($thread['username'], $thread['uid']); } // If this thread has a prefix, insert a space between prefix and subject
|
$thread['profilelink'] = build_profile_link($thread['username'], $thread['uid']); } // If this thread has a prefix, insert a space between prefix and subject
|
| $thread['threadprefix'] = $threadprefix = '';
|
if($thread['prefix'] != 0)
|
if($thread['prefix'] != 0)
|
{ $thread['threadprefix'] .= ' '; }
| { $threadprefix = build_prefixes($thread['prefix']); $thread['threadprefix'] = $threadprefix['displaystyle'].' '; }
|
$thread['subject'] = $parser->parse_badwords($thread['subject']); $thread['subject'] = htmlspecialchars_uni($thread['subject']);
| $thread['subject'] = $parser->parse_badwords($thread['subject']); $thread['subject'] = htmlspecialchars_uni($thread['subject']);
|
Zeile 879 | Zeile 1005 |
---|
$shownormalsep = true; $donestickysep = true; }
|
$shownormalsep = true; $donestickysep = true; }
|
else if($thread['sticky'] == 0 && $shownormalsep)
| else if($thread['sticky'] == 0 && !empty($shownormalsep))
|
{ eval("\$threads .= \"".$templates->get("forumdisplay_threads_sep")."\";"); $shownormalsep = false; }
$rating = '';
|
{ eval("\$threads .= \"".$templates->get("forumdisplay_threads_sep")."\";"); $shownormalsep = false; }
$rating = '';
|
if($foruminfo['allowtratings'] != 0)
| if($mybb->settings['allowthreadratings'] != 0 && $foruminfo['allowtratings'] != 0)
|
{ if($moved[0] == "moved") {
| { if($moved[0] == "moved") {
|
Zeile 899 | Zeile 1025 |
---|
$thread['numratings'] = intval($thread['numratings']);
$not_rated = '';
|
$thread['numratings'] = intval($thread['numratings']);
$not_rated = '';
|
if(!$thread['rated'])
| if(!isset($thread['rated']) || empty($thread['rated']))
|
{ $not_rated = ' star_rating_notrated'; }
|
{ $not_rated = ' star_rating_notrated'; }
|
|
|
$ratingvotesav = $lang->sprintf($lang->rating_votes_average, $thread['numratings'], $thread['averagerating']); eval("\$rating = \"".$templates->get("forumdisplay_thread_rating")."\";"); }
|
$ratingvotesav = $lang->sprintf($lang->rating_votes_average, $thread['numratings'], $thread['averagerating']); eval("\$rating = \"".$templates->get("forumdisplay_thread_rating")."\";"); }
|
}
| }
|
$thread['pages'] = 0; $thread['multipage'] = ''; $threadpages = ''; $morelink = ''; $thread['posts'] = $thread['replies'] + 1;
|
$thread['pages'] = 0; $thread['multipage'] = ''; $threadpages = ''; $morelink = ''; $thread['posts'] = $thread['replies'] + 1;
|
if(!$mybb->settings['postsperpage']) { $mybb->settings['postperpage'] = 20; }
| |
if($thread['unapprovedposts'] > 0 && $ismod) { $thread['posts'] += $thread['unapprovedposts'];
|
if($thread['unapprovedposts'] > 0 && $ismod) { $thread['posts'] += $thread['unapprovedposts'];
|
}
| }
|
if($thread['posts'] > $mybb->settings['postsperpage']) { $thread['pages'] = $thread['posts'] / $mybb->settings['postsperpage']; $thread['pages'] = ceil($thread['pages']);
|
if($thread['posts'] > $mybb->settings['postsperpage']) { $thread['pages'] = $thread['posts'] / $mybb->settings['postsperpage']; $thread['pages'] = ceil($thread['pages']);
|
if($thread['pages'] > 5) { $pagesstop = 4;
| if($thread['pages'] > $mybb->settings['maxmultipagelinks']) { $pagesstop = $mybb->settings['maxmultipagelinks'] - 1;
|
$page_link = get_thread_link($thread['tid'], $thread['pages']); eval("\$morelink = \"".$templates->get("forumdisplay_thread_multipage_more")."\";"); }
| $page_link = get_thread_link($thread['tid'], $thread['pages']); eval("\$morelink = \"".$templates->get("forumdisplay_thread_multipage_more")."\";"); }
|
Zeile 942 | Zeile 1063 |
---|
}
for($i = 1; $i <= $pagesstop; ++$i)
|
}
for($i = 1; $i <= $pagesstop; ++$i)
|
{
| {
|
$page_link = get_thread_link($thread['tid'], $i); eval("\$threadpages .= \"".$templates->get("forumdisplay_thread_multipage_page")."\";"); }
| $page_link = get_thread_link($thread['tid'], $i); eval("\$threadpages .= \"".$templates->get("forumdisplay_thread_multipage_page")."\";"); }
|
Zeile 957 | Zeile 1078 |
---|
}
if($ismod)
|
}
if($ismod)
|
{ if(my_strpos($mybb->cookies[$inlinecookie], "|{$thread['tid']}|")) {
| { if(isset($mybb->cookies[$inlinecookie]) && my_strpos($mybb->cookies[$inlinecookie], "|{$thread['tid']}|")) {
|
$inlinecheck = "checked=\"checked\""; ++$inlinecount; }
| $inlinecheck = "checked=\"checked\""; ++$inlinecount; }
|
Zeile 967 | Zeile 1088 |
---|
{ $inlinecheck = ''; }
|
{ $inlinecheck = ''; }
|
|
|
$multitid = $thread['tid']; eval("\$modbit = \"".$templates->get("forumdisplay_thread_modbit")."\";"); } else { $modbit = '';
|
$multitid = $thread['tid']; eval("\$modbit = \"".$templates->get("forumdisplay_thread_modbit")."\";"); } else { $modbit = '';
|
}
| }
|
if($moved[0] == "moved") { $prefix = $lang->moved_prefix;
| if($moved[0] == "moved") { $prefix = $lang->moved_prefix;
|
Zeile 986 | Zeile 1107 |
---|
$thread['threadlink'] = get_thread_link($thread['tid']); $thread['lastpostlink'] = get_thread_link($thread['tid'], 0, "lastpost");
|
$thread['threadlink'] = get_thread_link($thread['tid']); $thread['lastpostlink'] = get_thread_link($thread['tid'], 0, "lastpost");
|
|
|
// Determine the folder $folder = ''; $folder_label = '';
if($thread['doticon'])
|
// Determine the folder $folder = ''; $folder_label = '';
if($thread['doticon'])
|
{
| {
|
$folder = "dot_"; $folder_label .= $lang->icon_dot; }
| $folder = "dot_"; $folder_label .= $lang->icon_dot; }
|
Zeile 1041 | Zeile 1162 |
---|
{ $folder .= "hot"; $folder_label .= $lang->icon_hot;
|
{ $folder .= "hot"; $folder_label .= $lang->icon_hot;
|
}
| }
|
if($thread['closed'] == 1)
|
if($thread['closed'] == 1)
|
{
| {
|
$folder .= "lock"; $folder_label .= $lang->icon_lock;
|
$folder .= "lock"; $folder_label .= $lang->icon_lock;
|
}
| }
|
if($moved[0] == "moved") { $folder = "move"; $gotounread = ''; }
|
if($moved[0] == "moved") { $folder = "move"; $gotounread = ''; }
|
|
|
$folder .= "folder";
$inline_edit_tid = $thread['tid'];
|
$folder .= "folder";
$inline_edit_tid = $thread['tid'];
|
|
|
// If this user is the author of the thread and it is not closed or they are a moderator, they can edit if(($thread['uid'] == $mybb->user['uid'] && $thread['closed'] != 1 && $mybb->user['uid'] != 0 && $can_edit_titles == 1) || $ismod == true) {
| // If this user is the author of the thread and it is not closed or they are a moderator, they can edit if(($thread['uid'] == $mybb->user['uid'] && $thread['closed'] != 1 && $mybb->user['uid'] != 0 && $can_edit_titles == 1) || $ismod == true) {
|
Zeile 1074 | Zeile 1195 |
---|
$lastposttime = my_date($mybb->settings['timeformat'], $thread['lastpost']); $lastposter = $thread['lastposter']; $lastposteruid = $thread['lastposteruid'];
|
$lastposttime = my_date($mybb->settings['timeformat'], $thread['lastpost']); $lastposter = $thread['lastposter']; $lastposteruid = $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 1124 | Zeile 1245 |
---|
else { $attachment_count = '';
|
else { $attachment_count = '';
|
}
| }
|
eval("\$threads .= \"".$templates->get("forumdisplay_thread")."\";"); }
|
eval("\$threads .= \"".$templates->get("forumdisplay_thread")."\";"); }
|
|
|
$customthreadtools = ''; if($ismod) {
|
$customthreadtools = ''; if($ismod) {
|
switch($db->type)
| if(is_moderator($fid, "canusecustomtools") && $has_modtools == true)
|
{
|
{
|
case "pgsql": case "sqlite": $query = $db->simple_select("modtools", 'tid, name', "(','||forums||',' LIKE '%,$fid,%' OR ','||forums||',' LIKE '%,-1,%' OR forums='') AND type = 't'"); break; default: $query = $db->simple_select("modtools", 'tid, name', "(CONCAT(',',forums,',') LIKE '%,$fid,%' OR CONCAT(',',forums,',') LIKE '%,-1,%' OR forums='') AND type = 't'"); } while($tool = $db->fetch_array($query)) { eval("\$customthreadtools .= \"".$templates->get("forumdisplay_inlinemoderation_custom_tool")."\";"); } if(!empty($customthreadtools)) { eval("\$customthreadtools = \"".$templates->get("forumdisplay_inlinemoderation_custom")."\";");
| switch($db->type) { case "pgsql": case "sqlite": $query = $db->simple_select("modtools", 'tid, name', "(','||forums||',' LIKE '%,$fid,%' OR ','||forums||',' LIKE '%,-1,%' OR forums='') AND type = 't'"); break; default: $query = $db->simple_select("modtools", 'tid, name', "(CONCAT(',',forums,',') LIKE '%,$fid,%' OR CONCAT(',',forums,',') LIKE '%,-1,%' OR forums='') AND type = 't'"); }
while($tool = $db->fetch_array($query)) { eval("\$customthreadtools .= \"".$templates->get("forumdisplay_inlinemoderation_custom_tool")."\";"); } if($customthreadtools) { eval("\$customthreadtools = \"".$templates->get("forumdisplay_inlinemoderation_custom")."\";"); }
|
}
|
}
|
|
|
eval("\$inlinemod = \"".$templates->get("forumdisplay_inlinemoderation")."\";");
|
eval("\$inlinemod = \"".$templates->get("forumdisplay_inlinemoderation")."\";");
|
}
| }
|
}
// If there are no unread threads in this forum and no unread child forums - mark it as read require_once MYBB_ROOT."inc/functions_indicators.php";
|
}
// If there are no unread threads in this forum and no unread child forums - mark it as read require_once MYBB_ROOT."inc/functions_indicators.php";
|
if(fetch_unread_count($fid) == 0 && $unread_forums == 0) {
| $unread_threads = fetch_unread_count($fid); if($unread_threads !== false && $unread_threads == 0 && empty($unread_forums)) {
|
mark_forum_read($fid);
|
mark_forum_read($fid);
|
}
| }
|
// Subscription status
|
// Subscription status
|
$query = $db->simple_select("forumsubscriptions", "fid", "fid='".$fid."' AND uid='{$mybb->user['uid']}'", array('limit' => 1)); if($db->fetch_field($query, 'fid'))
| $add_remove_subscription = 'add'; $add_remove_subscription_text = $lang->subscribe_forum;
if($mybb->user['uid'])
|
{
|
{
|
$add_remove_subscription = 'remove'; $add_remove_subscription_text = $lang->unsubscribe_forum; } else { $add_remove_subscription = 'add'; $add_remove_subscription_text = $lang->subscribe_forum; }
| $query = $db->simple_select("forumsubscriptions", "fid", "fid='".$fid."' AND uid='{$mybb->user['uid']}'", array('limit' => 1));
if($db->fetch_field($query, 'fid')) { $add_remove_subscription = 'remove'; $add_remove_subscription_text = $lang->unsubscribe_forum; } }
|
// Is this a real forum with threads? if($foruminfo['type'] != "c")
| // Is this a real forum with threads? if($foruminfo['type'] != "c")
|
Zeile 1182 | Zeile 1310 |
---|
if(!$threadcount) { eval("\$threads = \"".$templates->get("forumdisplay_nothreads")."\";");
|
if(!$threadcount) { eval("\$threads = \"".$templates->get("forumdisplay_nothreads")."\";");
|
}
| }
$clearstoredpass = '';
|
if($foruminfo['password'] != '')
|
if($foruminfo['password'] != '')
|
{
| {
|
eval("\$clearstoredpass = \"".$templates->get("forumdisplay_threadlist_clearpass")."\";"); }
|
eval("\$clearstoredpass = \"".$templates->get("forumdisplay_threadlist_clearpass")."\";"); }
|
if($load_inline_edit_js == 1)
| if($load_inline_edit_js == 1) { eval("\$inline_edit_js = \"".$templates->get("forumdisplay_threadlist_inlineedit_js")."\";"); }
$post_code_string = ''; if($mybb->user['uid'])
|
{
|
{
|
eval("\$inline_edit_js = \"".$templates->get("forumdisplay_threadlist_inlineedit_js")."\";");
| $post_code_string = "&my_post_key=".$mybb->post_code;
|
}
$lang->rss_discovery_forum = $lang->sprintf($lang->rss_discovery_forum, htmlspecialchars_uni(strip_tags($foruminfo['name'])));
| }
$lang->rss_discovery_forum = $lang->sprintf($lang->rss_discovery_forum, htmlspecialchars_uni(strip_tags($foruminfo['name'])));
|