Vergleich forumdisplay.php - 1.6.2 - 1.6.12

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

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

 * $Id: 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_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 54Zeile 59
	{
header("Location: ".$location);
exit;

	{
header("Location: ".$location);
exit;

	}
}


	}
}


// Get forum info
$foruminfo = get_forum($fid);
if(!$foruminfo)

// Get forum info
$foruminfo = get_forum($fid);
if(!$foruminfo)

Zeile 72Zeile 77

// To validate, turn & to & but support unicode
$foruminfo['name'] = preg_replace("#&(?!\#[0-9]+;)#si", "&", $foruminfo['name']);


// To validate, turn & to & but support unicode
$foruminfo['name'] = preg_replace("#&(?!\#[0-9]+;)#si", "&", $foruminfo['name']);





$forumpermissions = forum_permissions();
$fpermissions = $forumpermissions[$fid];

if($fpermissions['canview'] != 1)
{
error_no_permission();

$forumpermissions = forum_permissions();
$fpermissions = $forumpermissions[$fid];

if($fpermissions['canview'] != 1)
{
error_no_permission();

}


}


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

if(!is_array($forumsread))
{
$forumsread = array();
}
}
else
{
// Build a forum cache.



	// Cookie'd forum read time
$forumsread = my_unserialize($mybb->cookies['mybb']['forumread']);

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 from the database

	$query = $db->query("
SELECT f.*, fr.dateline AS lastread
FROM ".TABLE_PREFIX."forums f

	$query = $db->query("
SELECT f.*, fr.dateline AS lastread
FROM ".TABLE_PREFIX."forums f

Zeile 109Zeile 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;

}

}


// Get the forum moderators if the setting is enabled.
if($mybb->settings['modlist'] != 0)


// Get the forum moderators if the setting is enabled.
if($mybb->settings['modlist'] != 0)

{

{

	$moderatorcache = $cache->read("moderators");

	$moderatorcache = $cache->read("moderators");

}

}


$bgcolor = "trow1";
if($mybb->settings['subforumsindex'] != 0)


$bgcolor = "trow1";
if($mybb->settings['subforumsindex'] != 0)

Zeile 133Zeile 139
	$showdepth = 3;
}
else

	$showdepth = 3;
}
else

{

{

	$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 164Zeile 173
if($foruminfo['type'] == "f" && $foruminfo['open'] != 0)
{
eval("\$newthread = \"".$templates->get("forumdisplay_newthread")."\";");

if($foruminfo['type'] == "f" && $foruminfo['open'] != 0)
{
eval("\$newthread = \"".$templates->get("forumdisplay_newthread")."\";");

}


}


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 206Zeile 236
					$done_moderators['users'][] = $moderator['id'];
}
$comma = $lang->comma;

					$done_moderators['users'][] = $moderator['id'];
}
$comma = $lang->comma;

			}
}
}
}






			}
}
}

if(!empty($forum_stats[$mfid]['announcements']))
{
$has_announcements = true;
}
}

$comma = '';

// If we have a moderators list, load the template

$comma = '';

// If we have a moderators list, load the template

Zeile 232Zeile 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 239Zeile 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)

Zeile 247Zeile 285
		}
else
{

		}
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 260Zeile 298
				{
$invisiblemark = '';
}

				{
$invisiblemark = '';
}

				



				if($user['invisible'] != 1 || $mybb->usergroup['canviewwolinvis'] == 1 || $user['uid'] == $mybb->user['uid'])
{
$user['username'] = format_name($user['username'], $user['usergroup'], $user['displaygroup']);

				if($user['invisible'] != 1 || $mybb->usergroup['canviewwolinvis'] == 1 || $user['uid'] == $mybb->user['uid'])
{
$user['username'] = format_name($user['username'], $user['usergroup'], $user['displaygroup']);

Zeile 271Zeile 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 303Zeile 344
	{
$foruminfo['rulestitle'] = $lang->sprintf($lang->forum_rules, $foruminfo['name']);
}

	{
$foruminfo['rulestitle'] = $lang->sprintf($lang->forum_rules, $foruminfo['name']);
}

	



	$rules_parser = array(
"allow_html" => 1,
"allow_mycode" => 1,

	$rules_parser = array(
"allow_html" => 1,
"allow_mycode" => 1,

Zeile 312Zeile 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")."\";");
}
else if($foruminfo['rulestype'] == 2)
{
eval("\$rules = \"".$templates->get("forumdisplay_rules_link")."\";");

	{
eval("\$rules = \"".$templates->get("forumdisplay_rules")."\";");
}
else if($foruminfo['rulestype'] == 2)
{
eval("\$rules = \"".$templates->get("forumdisplay_rules_link")."\";");

	}

	}

}

$bgcolor = "trow1";

}

$bgcolor = "trow1";

Zeile 347Zeile 388
if(is_moderator($fid, "caneditposts") || $fpermissions['caneditposts'] == 1)
{
$can_edit_titles = 1;

if(is_moderator($fid, "caneditposts") || $fpermissions['caneditposts'] == 1)
{
$can_edit_titles = 1;

}
else
{

}
else
{

	$can_edit_titles = 0;
}


	$can_edit_titles = 0;
}


Zeile 358Zeile 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'])
{
$datecut = $mybb->user['daysprune'];

{
// If the user manually set a date cut, use it.
if($mybb->user['daysprune'])
{
$datecut = $mybb->user['daysprune'];

	}

	}

	else
{
// If the forum has a non-default date cut, use it.

	else
{
// If the forum has a non-default date cut, use it.

Zeile 378Zeile 419
else
{
$datecut = intval($mybb->input['datecut']);

else
{
$datecut = intval($mybb->input['datecut']);

}


}


$datecut = intval($datecut);
$datecutsel[$datecut] = "selected=\"selected\"";
if($datecut > 0 && $datecut != 9999)

$datecut = intval($datecut);
$datecutsel[$datecut] = "selected=\"selected\"";
if($datecut > 0 && $datecut != 9999)

Zeile 400Zeile 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']))
{

Zeile 425Zeile 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 456Zeile 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 477Zeile 535
{
$sorturl = get_forum_link($fid).$string."datecut=$datecut";
}

{
$sorturl = get_forum_link($fid).$string."datecut=$datecut";
}

eval("\$orderarrow['$sortby'] = \"".$templates->get("forumdisplay_orderarrow")."\";");





// 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 = "";


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

if($fpermissions['canviewthreads'] != 0)

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

if($fpermissions['canviewthreads'] != 0)

{


{


	// 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 505Zeile 566
		{
$threadcount += $forum_threads['unapprovedthreads'];
}

		{
$threadcount += $forum_threads['unapprovedthreads'];
}

		



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

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

	}
}


	}
}


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

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

{

{

	$mybb->settings['threadsperpage'] = 20;

	$mybb->settings['threadsperpage'] = 20;

}

$perpage = $mybb->settings['threadsperpage'];

if(intval($mybb->input['page']) > 0)
{

}

$perpage = $mybb->settings['threadsperpage'];

if(isset($mybb->input['page']) && intval($mybb->input['page']) > 0)
{

	$page = intval($mybb->input['page']);
$start = ($page-1) * $perpage;
$pages = $threadcount / $perpage;

	$page = intval($mybb->input['page']);
$start = ($page-1) * $perpage;
$pages = $threadcount / $perpage;

Zeile 552Zeile 613

// Assemble page URL
if($mybb->input['sortby'] || $mybb->input['order'] || $mybb->input['datecut']) // Ugly URL


// Assemble page URL
if($mybb->input['sortby'] || $mybb->input['order'] || $mybb->input['datecut']) // Ugly URL

{	

{

	$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 = '';

	}

	}

	else
{

	else
{

		$q = '';
$and = "&";
}

if($sortby != "lastpost")
{

		$q = '';
$and = "&";
}

if((!empty($foruminfo['defaultsortby']) && $sortby != $foruminfo['defaultsortby']) || (empty($foruminfo['defaultsortby']) && $sortby != "lastpost"))
{

		$page_url .= "{$q}{$and}sortby={$sortby}";
$q = '';
$and = "&";
}

		$page_url .= "{$q}{$and}sortby={$sortby}";
$q = '';
$and = "&";
}

	



	if($sortordernow != "desc")
{
$page_url .= "{$q}{$and}order={$sortordernow}";
$q = '';
$and = "&";
}

	if($sortordernow != "desc")
{
$page_url .= "{$q}{$and}order={$sortordernow}";
$q = '';
$and = "&";
}

	
if($datecut > 0 && $datecut != 9999)


if($datecut > 0)

	{
$page_url .= "{$q}{$and}datecut={$datecut}";
}

	{
$page_url .= "{$q}{$and}datecut={$datecut}";
}

}

}

else

else

{

{

	$page_url = str_replace("{fid}", $fid, FORUM_URL_PAGED);
}
$multipage = multipage($threadcount, $perpage, $page, $page_url);


	$page_url = str_replace("{fid}", $fid, FORUM_URL_PAGED);
}
$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)

	switch($db->type)

	{

	{

		case "pgsql":
$ratingadd = "CASE WHEN t.numratings=0 THEN 0 ELSE t.totalratings/t.numratings::numeric END AS averagerating, ";
break;
default:
$ratingadd = "(t.totalratings/t.numratings) AS averagerating, ";
}

		case "pgsql":
$ratingadd = "CASE WHEN t.numratings=0 THEN 0 ELSE t.totalratings/t.numratings::numeric END AS averagerating, ";
break;
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
{

}
else
{



	if($sortfield == "averagerating")
{
$t = "t.";

	if($sortfield == "averagerating")
{
$t = "t.";

Zeile 627Zeile 688
}

// Get Announcements

}

// 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($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;
}

if(empty($cookie))
{
// Clean up cookie crumbs
my_setcookie('mybb[announcements]', 0, (TIME_NOW - (60*60*24*365)));

	}

	}

	
if($ismod)

	else if(!empty($cookie))


	{

	{

		eval("\$modann = \"".$templates->get("forumdisplay_announcements_announcement_modbit")."\";");

		my_setcookie("mybb[announcements]", addslashes(serialize($cookie)), -1);

	}

	}

	else
{
$modann = '';
}

$plugins->run_hooks("forumdisplay_announcement");
eval("\$announcements .= \"".$templates->get("forumdisplay_announcements_announcement")."\";");
$bgcolor = alt_trow();
}

if($announcements)

}
else










{

{

	eval("\$announcementlist = \"".$templates->get("forumdisplay_announcements")."\";");
$shownormalsep = true;

	$announcementlist = '';


}


}


 
$tids = $threadcache = array();

$icon_cache = $cache->read("posticons");

if($fpermissions['canviewthreads'] != 0)
{
// Start Getting Threads
$query = $db->query("

$icon_cache = $cache->read("posticons");

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

	while($thread = $db->fetch_array($query))

	{		

	{

		$threadcache[$thread['tid']] = $thread;

		$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 728Zeile 828
		else
{
$tids[$thread['tid']] = $thread['tid'];

		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 user has moderation tools available, prepare the Select All feature

}

// If user has moderation tools available, prepare the Select All feature

Zeile 750Zeile 846
	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 773Zeile 869
}

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

	$query = $db->simple_select("threadsread", "*", "uid='{$mybb->user['uid']}' AND tid IN ({$tids})");

	while($readthread = $db->fetch_array($query))
{

	while($readthread = $db->fetch_array($query))
{

		if($moved_threads[$readthread['tid']]) 
{
$readthread['tid'] = $moved_threads[$readthread['tid']];

		if(!empty($moved_threads[$readthread['tid']]))
{
$readthread['tid'] = $moved_threads[$readthread['tid']];

	 	}
if($threadcache[$readthread['tid']])
{

	 	}
if($threadcache[$readthread['tid']])
{

	 		$threadcache[$readthread['tid']]['lastread'] = $readthread['dateline']; 

	 		$threadcache[$readthread['tid']]['lastread'] = $readthread['dateline'];

		}
}
}

		}
}
}

Zeile 796Zeile 892

$read_cutoff = TIME_NOW-$mybb->settings['threadreadcut']*60*60*24;
if($forum_read == 0 || $forum_read < $read_cutoff)


$read_cutoff = TIME_NOW-$mybb->settings['threadreadcut']*60*60*24;
if($forum_read == 0 || $forum_read < $read_cutoff)

	{

	{

		$forum_read = $read_cutoff;

		$forum_read = $read_cutoff;

	}
}

	}
}

else

else

{

{

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

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

	foreach($threadcache as $thread)
{
$plugins->run_hooks("forumdisplay_thread");

Zeile 824Zeile 935
		{
$bgcolor = alt_trow();
}

		{
$bgcolor = alt_trow();
}

		



		if($thread['sticky'] == 1)
{
$thread_type_class = " forumdisplay_sticky";

		if($thread['sticky'] == 1)
{
$thread_type_class = " forumdisplay_sticky";

		}
else

		}
else

		{
$thread_type_class = " forumdisplay_regular";

		{
$thread_type_class = " forumdisplay_regular";

		}


		}


		$folder = '';
$prefix = '';


		$folder = '';
$prefix = '';


Zeile 842Zeile 953
		{
$thread['username'] = $thread['threadusername'];
$thread['profilelink'] = $thread['threadusername'];

		{
$thread['username'] = $thread['threadusername'];
$thread['profilelink'] = $thread['threadusername'];

		}
else

		}
else

		{
$thread['profilelink'] = build_profile_link($thread['username'], $thread['uid']);
}

		{
$thread['profilelink'] = build_profile_link($thread['username'], $thread['uid']);
}

		



		// If this thread has a prefix, insert a space between prefix and subject

		// 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'] .= '&nbsp;';


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

		}

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

		}

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

Zeile 879Zeile 992
			$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 899Zeile 1012
				$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';
}

$ratingvotesav = $lang->sprintf($lang->rating_votes_average, $thread['numratings'], $thread['averagerating']);
eval("\$rating = \"".$templates->get("forumdisplay_thread_rating")."\";");

				{
$not_rated = ' star_rating_notrated';
}

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


if($thread['unapprovedposts'] > 0 && $ismod)
{

Zeile 930Zeile 1038
			$thread['pages'] = $thread['posts'] / $mybb->settings['postsperpage'];
$thread['pages'] = ceil($thread['pages']);


			$thread['pages'] = $thread['posts'] / $mybb->settings['postsperpage'];
$thread['pages'] = ceil($thread['pages']);


			if($thread['pages'] > 5)

			if($thread['pages'] > $mybb->settings['maxmultipagelinks'])

			{

			{

				$pagesstop = 4;

				$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 958Zeile 1066

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 1132Zeile 1240
	$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")."\";");
}
}

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

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






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

}

}

else
{
$add_remove_subscription = 'add';
$add_remove_subscription_text = $lang->subscribe_forum;
}


 

// Is this a real forum with threads?
if($foruminfo['type'] != "c")


// Is this a real forum with threads?
if($foruminfo['type'] != "c")

Zeile 1184Zeile 1299
		eval("\$threads = \"".$templates->get("forumdisplay_nothreads")."\";");
}


		eval("\$threads = \"".$templates->get("forumdisplay_nothreads")."\";");
}


 
	$clearstoredpass = '';

	if($foruminfo['password'] != '')
{
eval("\$clearstoredpass = \"".$templates->get("forumdisplay_threadlist_clearpass")."\";");

	if($foruminfo['password'] != '')
{
eval("\$clearstoredpass = \"".$templates->get("forumdisplay_threadlist_clearpass")."\";");

Zeile 1192Zeile 1308
	if($load_inline_edit_js == 1)
{
eval("\$inline_edit_js = \"".$templates->get("forumdisplay_threadlist_inlineedit_js")."\";");

	if($load_inline_edit_js == 1)
{
eval("\$inline_edit_js = \"".$templates->get("forumdisplay_threadlist_inlineedit_js")."\";");

 
	}

$post_code_string = '';
if($mybb->user['uid'])
{
$post_code_string = "&amp;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'])));