"; echo "

$res_title

"; echo "

"; //书名 echo "

《{$book_name[$book][0]}》

"; echo "

{$book_name[$book][1]}

"; echo "

"; PDO_Connect("sqlite:"._FILE_DB_RESRES_INDEX_); $query = "select resindex.id,resindex.title,resindex.type,resindex.album,author.name from 'index' as resindex LEFT JOIN author ON resindex.author = author.id where resindex.book='$book' and resindex.paragraph=$paragraph and resindex.type<>7 group by resindex.album"; $Fetch = PDO_FetchAll($query); $iFetch=count($Fetch); if($iFetch>0){ $res_title=$Fetch[0]["title"]; //可用资源 echo "

可用资源
"; echo "{$media_type_short[$album_type]}{$one_album["title"]}"; echo "
{$one_album["name"]}"; echo "

"; } //查共享文档 PDO_Connect("sqlite:"._FILE_DB_FILEINDEX_); $query = "select * from fileindex where book='$book' and paragraph=$paragraph and status>0 and share>0 order by create_time"; $Fetch = PDO_FetchAll($query); $iFetch=count($Fetch); if($iFetch>0){ echo "

共享文档
".$one_file["title"]."-".$one_file["user_id"]."

"; } //目录 $db_file =_FILE_DB_PALITEXT_; PDO_Connect("sqlite:$db_file"); $query = "select * from 'pali_text' where book = '{$book}' and level>'0' and level<8 and paragraph>=$paragraph "; $Fetch_Toc = PDO_FetchAll($query); $iFetchToc=count($Fetch_Toc); if($iFetchToc>1){ if($Fetch_Toc[1]["level"]>$Fetch_Toc[0]["level"]){ echo "

章节
"; echo "{$toc_title}"; echo "
2"; echo "

"; } } //目录结束 } } else{ //查专辑 if($paragraph==-1){ //查整张专辑 $query = "select album.id,album.title,album.file,album.guid,album.type, author.name from album LEFT JOIN author ON album.author = author.id where album.id='$album' "; //$query = "select * from 'album' where id='$album'"; $Fetch = PDO_FetchAll($query); $iFetch=count($Fetch); if($iFetch>0){ echo "

"; //标题 $res_title=$Fetch[0]["title"]; $album_file_name=$Fetch[0]["file"]; $album_guid=$Fetch[0]["guid"]; $album_type=$Fetch[0]["type"]; echo "

$res_title

"; echo "

"; //标题 echo "

".$res_title."

"; //echo "

".$Fetch[0]["c1"]." ".$Fetch[0]["c2"]."

"; echo "

".$Fetch[0]["name"]."

"; echo "

".$media_type[$Fetch[0]["type"]]."

"; echo "

"; $read_link="reader.php?book=$book&album=$album¶graph=$paragraph"; echo "

阅读
在线阅读

"; //下载 echo "

下载

下载

".$one_ebook["format"]."".format_file_size($one_ebook["file_size"])."$ebook_download_link

"; //相关专辑 echo "

相关专辑
{$media_type[$one_album["type"]]}{$one_album["title"]}{$one_album["name"]}

"; //相关专辑结束 echo "

"; //目录 switch($album_type){ case 1: case 2: case 6: $db_file = _FILE_DB_PALITEXT_; PDO_Connect("sqlite:$db_file"); $query = "select * from 'pali_text' where book = '{$book}' and level>'0' and level<8 "; break; case 3: $db_file = '../'.$album_file_name; echo "db album:{$db_file}"; PDO_Connect("sqlite:$db_file"); $query = "select * from 'album' where guid='$album_guid'"; $Fetch_album = PDO_FetchAll($query); $this_album_id=$Fetch_album[0]["id"]; $query = "select * from 'data' where level>'0' and level<8 and album=$this_album_id "; break; } $Fetch_Toc = PDO_FetchAll($query); $iFetchToc=count($Fetch_Toc); if($iFetchToc>0){ $aLevel=array(); foreach($Fetch_Toc as $one_title){ $level=$one_title["level"]; if(isset($aLevel["{$level}"])){ $aLevel["{$level}"]++; } else{ $aLevel["{$level}"]=1; } } ksort($aLevel); //找出不是一个的最大层级 foreach($aLevel as $x=>$x_value){ $maxLevel=$x; if($x_value>1){ break; } } echo "

章节
"; echo "{$toc_title}"; echo "
2"; echo "

"; } //目录结束 } } else{ //查专辑中的一个段 $query = "select * from 'index' where album='$album' and paragraph=$paragraph"; $Fetch = PDO_FetchAll($query); $iFetch=count($Fetch); if($iFetch>0){ //标题 $res_title=$Fetch[0]["title"]; echo "

$res_title

"; echo "

"; //出自专辑标题 $query = "select album.id,album.title,album.type,album.file,album.guid, author.name from album LEFT JOIN author ON album.author = author.id where album.id='$album' "; $FetchAlbum = PDO_FetchAll($query); if(count($FetchAlbum)>0){ $album_type=$FetchAlbum[0]["type"]; $album_file_name=$FetchAlbum[0]["file"]; $album_guid=$FetchAlbum[0]["guid"]; //专辑标题 $info_link="index_render_res_list($book,$album,-1)"; echo "

".$FetchAlbum[0]["title"]."

"; } echo "

".$FetchAlbum[0]["name"]."

"; echo "

".$media_type[$FetchAlbum[0]["type"]]."

"; echo "

"; //在线阅读 $read_link="reader.php?book=$book&album=$album¶graph=$paragraph"; echo "

阅读
在线阅读

"; //相关段落 //$query = "select album.id,album.title,album.file,album.guid,album.type, author.name from album LEFT JOIN author ON album.author = author.id where album.book='$book' and album.id != $album "; $query = "select idx.id , idx.title , idx.album , idx.type , author.name FROM 'index' as idx LEFT JOIN author ON idx.author = author.id WHERE idx.book='$book' and idx.paragraph=$paragraph and idx.album!=$album and idx.type!=7"; $Fetch_ather = PDO_FetchAll($query); $iFetchAther=count($Fetch_ather); if($iFetchAther>0){ echo "

相关资源
"; echo "{$media_type[$one_album["type"]]}"; echo "{$one_album["title"]}{$one_album["name"]}

"; } //目录 switch($album_type){ case 1: case 2: case 6: $db_file =_FILE_DB_PALITEXT_; PDO_Connect("sqlite:$db_file"); $query = "select * from 'pali_text' where book = '{$book}' and level>'0' and level<8 and paragraph>=$paragraph "; break; case 3: $db_file = "../{$album_file_name}"; PDO_Connect("sqlite:$db_file"); $query = "select * from 'album' where guid='$album_guid'"; $Fetch_album = PDO_FetchAll($query); $this_album_id=$Fetch_album[0]["id"]; $query = "select * from 'data' where level>'0' and level<8 and paragraph>=$paragraph and album=$this_album_id "; break; } $Fetch_Toc = PDO_FetchAll($query); $iFetchToc=count($Fetch_Toc); if($iFetchToc>1){ if($Fetch_Toc[1]["level"]>$Fetch_Toc[0]["level"]){ echo "

章节
"; echo "{$toc_title}"; echo "
2"; echo "

"; } } //目录结束 } } } ?>