address."/".$CFG->selectedLanguage."/404/"); } $db_title = new db(); if(isset($_GET["page"]) && $_GET["page"] !== "") { $page = $db_title->escape($_GET["page"]); $title_whereClause = "AND c.catCode = '$page' "; $fileLimit = null; } else { $title_whereClause = null; $fileLimit = "LIMIT 0, 5"; } $db_title->make_query("SELECT c.categoryID, c.name as category, c.catCode " . "FROM categories c " . "LEFT JOIN languages AS l ON(l.languageID = c.language) " . "WHERE c.type = 'documents' " .$title_whereClause. "AND l.shortName = '$CFG->selectedLanguage' " . "ORDER BY c.name "); if($db_title->numRows() !== 0) { while($pg = $db_title->fetchRows()) { ?>

category;?>

make_query("SELECT d.file, d.description, c.catCode AS category " . "FROM documents d " . "LEFT JOIN languages AS l ON(l.languageID = d.language) " . "LEFT JOIN categories AS c ON(c.categoryID = d.category) " . "WHERE d.visability = 'published' " . "AND d.deleted = 'false' " . "AND d.category = '$pg->categoryID' " . "AND l.shortName = '$CFG->selectedLanguage' " . "ORDER BY description ".$fileLimit); if($db->numRows() !== 0) { ?> close(); } } else { redirect($CFG->address."/".$CFG->selectedLanguage."/error/404/"); } ?>