<?
include ("../_xcms/classes/phplib/prepend.php");
echo "var file_exts = new Array();";

$db2 = new DB__("select count(type.id_type) as amount, type_category.name from type 
left join type_category on type_category.id=type.id_type 
group by type.id_type");
while($db2->next_record())
{
     echo "file_exts['".$db2->f('name')."']=new Array(2); ";
     echo "file_exts['".$db2->f('name')."'][0]=new Array(".$db2->f('amount').");";
     echo "file_exts['".$db2->f('name')."'][1]=new Array(".$db2->f('amount')."); ";
}

$db = new DB__("select type.*, type_category.name as kind from type 
left join type_category on type_category.id=type.id_type 
group by type.id 
order by type_category.name, type.name");
$next = 0;
if($db->nf())
{

     while($db->next_record())
     {
                echo "file_exts['".$db->f('kind')."'][0][$next]='".$db->f('name')."';";
                echo "file_exts['".$db->f('kind')."'][1][$next]='".$db->f('ico')."';";
                $next++;
     }
}
?>