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