$aForums[$aSQLResult[0]][DESCRIPTION] = $aSQLResult[2];
$aForums[$aSQLResult[0]][PARENT] = $aSQLResult[4];
$aForums[$aSQLResult[0]][LPOST] = $aSQLResult[5];
$aForums[$aSQLResult[0]][LPOSTER] = $aSQLResult[6];
$aForums[$aSQLResult[0]][LTHREAD] = $aSQLResult[7];
$aForums[$aSQLResult[0]][LTHREADPCOUNT] = $aSQLResult[8];
$aForums[$aSQLResult[0]][POSTCOUNT] = $aSQLResult[9];
$aForums[$aSQLResult[0]][THREADCOUNT] = $aSQLResult[10];
break;
}
}
// Free memory.
unset($aSQLResult);
// Display the forum.
if (isset($aCategories[$iForumID])) {
DisplayCategory($iForumID, $aCategories[$iForumID]);
} else {
if (isset($aForums[$iForumID])) {
DisplayForum($iForumID, $aForums[$iForumID]);
}
}
// They didn't specify a valid forum ID.
Msg("Invalid forum specified.{$CFG['msg']['invalidlink']}");
// *************************************************************************** \\
// Renders the regular forum display.
function DisplayForum($iForumID, $aForum)
{
global $CFG, $dbConn, $aViewedThreads, $aCategories, $aForums, $aPostIcons;
$aUsers = array();
// Get the name of the forum's parent.
$aForum[PARENTNAME] = $aCategories[$aForum[PARENT]][NAME];
$DB = new DB($C['db_hostname'], $C['db_username'], $C['db_password'], $C['db_name']);
switch ($_GET['c']) {
case '':
DisplayIndex();
break;
case $C['page_new']:
DisplayNew();
break;
case $C['page_top']:
DisplayTopRated();
break;
case $C['page_popular']:
DisplayPopular();
break;
default:
DisplayCategory();
break;
}
function &GetNews(&$attrs)
{
global $DB;
$DB->Connect();
$limit_clause = empty($attrs['amount']) ? '' : "LIMIT {$attrs['amount']}";
$news = array();
$result = $DB->Query("SELECT * FROM lx_news ORDER BY date_added DESC {$limit_clause}");
while ($item = $DB->NextRow($result)) {
$item['date'] = $item['date_added'] = strtotime($item['date_added']);
$news[] = $item;
}
$DB->Free($result);
return $news;
