$sql = 'SELECT c.id AS cid, categoryName, f.id AS fid, f.*
		FROM categories AS c
		INNER JOIN forums AS f ON c.id = f.categoryID
		ORDER BY c.position, c.id, f.position';

$result = $DB->query($sql);
$categories = array();

//Set the current category to 'nothing'
$category = NULL;
$totalPosts = 0;
$totalThreads = 0;

while($row = $result->fetch_assoc())
{
	$cid = $row['cid'];

	//New category since last iteration?
	if ($category != $cid)
	{
		$categories[$cid]['name'] = $row['categoryName'];
		$categories[$cid]['forums'] = array();
		$category = $cid; //Change the current category
	}

    $icon = array('img' => 'none-l', 'alt' => 'No new posts');
    if ($userinfo->loggedIn AND $row['lastPost'] > $userinfo->f_lastVisit)
        $icon = array('img' => 'new-posts-l', 'alt' => 'New posts'); 
        
	//Push the forum onto the current category
	$categories[$cid]['forums'][] = array(
		'id'			=> $row['fid'],
		'name'			=> $row['forumName'],
		'desc'			=> $row['forumDesc'],
		'numThreads'	=> $row['numThreads'],
		'numPosts'		=> $row['numPosts'],
		'lastPost'		=> formatTime($row['lastPost']),
		'lastPostID'	=> $row['lastPostID'],
		'lastPoster'	=> $row['lastPoster'],
		'lastPosterID'	=> $row['lastPosterID'],
        'icon'          => $icon
	);
    
    
    $totalPosts += $row['numPosts'];
    $totalThreads += $row['numThreads'];

}

//Destroy the result and free up the memory used by it
$result->close();

$inner->set_vars(array(
    'categories'    => $categories,
    'totalPosts'    => $totalPosts,
    'totalThreads'  => $totalThreads
));

$row = $DB->queryFirst('SELECT count(id) AS total FROM account');
$inner->set('totalAccounts', $row->total);

$row = $DB->queryFirst('SELECT id, name FROM account ORDER BY datecreated DESC LIMIT 0, 1');
$inner->set_vars(array('latestMember' => $row->name, 'latestMemberID' => $row->id));

$totalGuests = 0;
$users = array();

$result = $DB->query('SELECT a.name, a.permissionLevel, s.aid FROM session AS s LEFT JOIN account AS a ON s.aid = a.id WHERE f_lastActivity IS NOT NULL');
while ($user = $result->fetch_assoc())
{
    if ($user['aid'] != 0)
    {
        if ($user['permissionLevel'] >= 3)
            $users[] = '<a href="?v=viewprofile&amp;aid='.$user['aid'].'"><span class="sysop">'.$user['name'].'</span></a>';
        
        elseif ($user['permissionLevel'] == 2)
            $users[] = '<a href="?v=viewprofile&amp;aid='.$user['aid'].'"><span class="smod">'.$user['name'].'</span></a>';
            
        elseif ($user['permissionLevel'] == 1)
            $users[] = '<a href="?v=viewprofile&amp;aid='.$user['aid'].'"><span class="mod">'.$user['name'].'</span></a>';        
        
        else
            $users[] = '<a href="?v=viewprofile&amp;aid='.$user['aid'].'">'.$user['name'].'</a>';

    } 

    else
        ++$totalGuests;
}

$inner->set_vars(array(
    'totalGuests'   => $totalGuests,
    'totalUsers'    => sizeof($users),
    'totalOnline'   => $totalGuests+sizeof($users),
    'users'         => implode(", ", $users)
));

////////////////////////////////////////////////////////////////

$outer->set('pageTitle', 'Forum Index');
$outer->set('body', $inner->fetch('forumindex.tpl'));