init();
$tid = intval($_GET['tid']);
$cid = intval($_GET['cid']);
$topic = 'pre_keke_doc_topic';
$chapter = 'pre_keke_doc_topic_chapter';
$relation = 'pre_keke_doc_topic_relation';
$doc = 'pre_keke_doc';
$th = DB::fetch_first("SELECT * FROM $topic WHERE id='$tid'");
$chapters = DB::fetch_all("
SELECT c.*, COUNT(r.doc_id) AS doc_count
FROM $chapter c
LEFT JOIN $relation r ON c.id = r.chapter_id
WHERE c.topic_id = '$tid'
GROUP BY c.id
ORDER BY doc_count DESC, c.sort ASC
");
if($cid) {
$docs = DB::fetch_all("
SELECT d.id, d.title, d.view, d.down, d.page
FROM $doc d
JOIN $relation r ON d.id = r.doc_id
WHERE r.topic_id='$tid' AND r.chapter_id='$cid'
ORDER BY d.view DESC
");
} else {
$docs = DB::fetch_all("
SELECT DISTINCT d.id, d.title, d.view, d.down, d.page
FROM $doc d
JOIN $relation r ON d.id = r.doc_id
WHERE r.topic_id='$tid'
ORDER BY d.view DESC
");
}
include template('common/header');
?>