require($_SERVER['DOCUMENT_ROOT']."/_include_ru/global.inc"); include($_SERVER['DOCUMENT_ROOT']."/_include_ru/functions.inc"); $site_uri="http://www.ib-net.org/sp/"; InitPage(); function ShowTexts($query) { global $folder_id, $QUSER, $doc_type, $content, $db; if(!empty($query)) $query=" AND id ".$query; $db->query("select * from $doc_type where topic_id='$folder_id' and visible>='{$QUSER['show_visible']}' and publicated>='{$QUSER['show_publicated']}' and deleted='0'{$query} order by sort"); if($db->num_rows()>0) { $content.='
![]() | $pr_title $pr_header |
$pages_title";
if($pages_header!="") $content.="
$pages_header";
}
} else {
$db->query("select count(*) as count from $doc_type where topic_id='$folder_id' and visible>='{$QUSER['show_visible']}' and publicated>='{$QUSER['show_publicated']}' and deleted='0'");
$db->next_record();
if($db->Record["count"]==1) {
$db->query("select id from $doc_type where topic_id='$folder_id' and visible>='{$QUSER['show_visible']}' and publicated>='{$QUSER['show_publicated']}' and deleted='0'");
$db->next_record();
Header("Location: $doc_type.php?folder_id=$folder_id&mat_id=".$db->Record["id"]."&L=".$L."&S=".$S."&ss=".$ss);
exit;
} else {
$db->query("select * from topics where pid='$folder_id' and visible='1' order by sort");
if($db->next_record()) {
Header("Location: $doc_type.php?folder_id=".$db->Record["id"]);
exit;
}
}
/* if($db->Record["count"]>0) {
$db->query("select id, title from rubrics where topic_id='$folder_id' order by sort");
if($db->num_rows()>0) {
$db2 = new DB;
while($db->next_record()) {
$rubrics_list[$db->Record["id"]]=$db->Record["title"];
$db2->query("SELECT text_id FROM rubrics_links WHERE rubric_id='".$db->Record["id"]."'");
while($db2->next_record()) {
$text_ids[$db->Record["id"]][]=$db2->Record["text_id"];
}
if(sizeof($text_ids[$db->Record["id"]])>0) $text_id_list[$db->Record["id"]]=implode(', ',$text_ids[$db->Record["id"]]);
}
reset($rubrics_list);
$text_id_all_rubrics=implode(', ', $text_id_list);
ShowTexts('NOT IN ('.$text_id_all_rubrics.')');
while(list($rubric_id, $rubric_title) = each($rubrics_list)) {
if(sizeof($text_ids[$rubric_id])>0) {
$content.="