<?php


mysql_connect("localhost","root","");
mysql_select_db("final");
$c = mysql_real_escape_string($_GET['c']);
//To begin with ...
$q = mysql_query("SELECT c.ID_CAT, b.name AS BoardName, c.name AS CatName, b.ID_BOARD as BOARD_ID
        FROM categories AS c
        LEFT JOIN boards AS b ON (c.ID_CAT = b.ID_CAT)
        ");

$ilfn['categ'] = array();

while($milf = mysql_fetch_assoc($q))
{
    //Get gets Categories © MILF ...
    if(empty($ilfn['categ'][$milf['ID_CAT']]))
    {
        $ilfn['categ'][$milf['ID_CAT']] = array(
            "ID" => $milf['ID_CAT'],
            "NAME" => $milf['CatName'],
            "BOARDS" => array(),
            "NEW" => false
        );
        $ilfn['categ'][$milf['ID_CAT']]['url'] = '<a href="/forum/custom/'. $milf['ID_CAT'] .'/'. $milf['CatName'] .'">'. $milf['CatName'] .'"</a>';
    }

    $this_cat = &$ilfn['categ'][$milf['ID_CAT']]["BOARDS"];
    if (empty($row_board['ID_PARENT']))
    {
        if(!isset($this_cat[$milf['BOARD_ID']]))
        {
            //Lets get to boards © MILF.....
            $this_cat[$milf['ID_BOARD']] = array(
                "ID" => $milf['BOARD_ID'],
                "NAME" => $milf['BoardName'],
                "DESC" => $milf['description'],
                "MODERATORS" => array(),
                "LINK_MODERATORS" => array(),
                "NUM_TOPICS" => $milf['numTopics'],
                "NUM_POST" => $milf['numPosts'],
                "URL" => '<a href="/forum/board/'. $milf['BOARD_ID'] .'/'. $milf['BoardName'] .'">'. $milf['BoardName'] .'"</a>',
            );
        }
        if(!empty($milf['ID_MEMBER']))
        {
            $this_cat[$milf['BOARD_ID']]["MODERATORS"][$milf['ID_MEMBER']] = array(
            "ID" => $milf['ID_MEMBER'],
            "NAME" => $milf['MOD_NAME'],
            "URL" => '<a href="profil/'. $milf['ID_MEMBER'] .'/'. $milf['MOD_NAME'] .'">'.$milf['MOD_NAME'].'</a>',
            );
        }
    }

    foreach ($this_cat as $id => $board)
    {
        $parent_map[$row_board['ID_PARENT']] = array(&$this_category[$id], &$this_category[$id]['children'][$row_board['ID_PARENT']]);
        $parent_map[$row_board['ID_BOARD']] = array(&$this_category[$id], &$this_category[$id]['children'][$row_board['ID_PARENT']]);

        break;
    }


}

reset($ilfn['categ']);
while (list($key, $value) = each($ilfn['categ'])) {

echo $key

}
include "/templates/default/display.forum.php";





?>