query('select NAME_'.strtoupper($l).' AS CNAME,FILE from '.$dbt['menu'].' where VISIBLE=1 AND ID=\''.$idc.'\' LIMIT 1'); $FMenu=$db->fetchRow(); } ?>


query('select ID,AUXFILE,NAME_'.strtoupper($l).' as CNAME from '.$dbt['menu2'].' where FKEY=\'fd\' AND VISIBLE=1 '.(isset($idc) && trim($idc)!=''?'AND ID_PARENT=\''.$idc.'\' ORDER BY ':'ORDER BY ID_PARENT,').' ORD ASC'); $SMenu=$db->getResult(); $db->query('select ID from '.$dbt['types'].' where FKEY=\'fd\' limit 1'); $idt=$db->fetchRow(); for($i=0;$iquery('select ID, ITEMTYPE, TYPE_'.strtoupper($l).' AS TYPE, HEADLINE_'.strtoupper($l).' AS HEADLINE from '.$dbt['tppub'].' WHERE VISIBLE=1 AND ID_CAT='.$SMenu[$i]['ID'].' AND IDT='.$idt['ID'].' ORDER by ORD ASC'); $Items=$db->getResult(); ?>