Intellect Board — cистема управления сайтом

[q]

function ct_list() {
global $link;
ad_ct_list_start();

$sql = "SELECT ct_id,ct_name,ct_sortfield, f_title, f_id, f_sortfield, f_parent, tp_container, tp_title ".
"FROM ".$GLOBALS['DBprefix']."Category ct, ".$GLOBALS['DBprefix']."Forum f, ".$GLOBALS['DBprefix']."ForumType ".
"WHERE f_tpid=tp_id AND ct_id=f_ctid ORDER BY ct_sortfield";
$res=db_query($sql,$link);
$oldcat = "";
$forums=array();
while ($fdata=db_fetch_array($res)) {
$forums[]=$fdata;
}
$forums=sort_forums_recurse($forums);
$oldcat=0;
for ($i=0, $count=count($forums); $i<$count; $i++) {
if ($oldcat!=$forums[$i]['ct_id']) {
ad_ct_entry($forums[$i]);
$oldcat=$forums[$i]['ct_id'];
}
ad_f_entry($forums[$i]);
}

ad_ct_list_end();
}

[/q]