Server : Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/7.4.20 System : Linux st2.domain.com 3.10.0-1127.10.1.el7.x86_64 #1 SMP Wed Jun 3 14:28:03 UTC 2020 x86_64 User : apache ( 48) PHP Version : 7.4.20 Disable Function : NONE Directory : /var/www/html/lnovel/code/manga/ |
<?php
global $DB,$CORE,$func,$INFO;
$truyen_id = $CORE->input['id'] ?? 0;
$key_row_check = md5("SELECT * FROM tb_truyen WHERE truyen_id='$truyen_id' AND truyen_active_status='Active'");
if(!$memcache->get($key_row_check)) {
$row_check = $DB->fetch_row($DB->query("SELECT * FROM tb_truyen WHERE truyen_id='$truyen_id' AND truyen_active_status='Active'"));
if (!$row_check) {
header('Location: ' . $INFO['home_url']);
}
$memcache->set($key_row_check, $row_check, MEMCACHE_COMPRESSED, 300);
}else{
$row_check = $memcache->get($key_row_check);
}
//follow
$where_follow = " follow_ip='".$ip."' ";
$v_tmp_user_id=0;
if(isset($ob_user->user_id) and intval($ob_user->user_id)>0){
$where_follow = " user_id='".intval($ob_user->user_id)."' ";
$v_tmp_user_id=intval($ob_user->user_id);
}
$key_follow = md5("SELECT * FROM tb_follow WHERE truyen_id='$truyen_id' AND ".$where_follow." LIMIT 1 ");
if(!$memcache->get($key_follow)) {
$r_follow = $DB->fetch_row($DB->query("SELECT * FROM tb_follow WHERE truyen_id='$truyen_id' AND " . $where_follow . " LIMIT 1 "));
$memcache->set($key_follow, $r_follow, MEMCACHE_COMPRESSED, 5);
}else{
$r_follow = $memcache->get($key_follow);
}
//header seo
$CORE->title_page = str_replace('"',"'",$row_check['truyen_name']);
$cur_url = $func->current_url();
$arr_option['share_image_website'] = $row_check['truyen_thumb'];
$arr_option['blogdescription'] = str_replace('"',"'",strip_tags(html_entity_decode($row_check['truyen_noidung'])));
$arr_option['keyword_homepage'] .= $arr_option['keyword_homepage'].$row_check['truyen_tags'];
//show chap
$q_f_l_chap = $DB->query("
(select chuong_id,chuong_name,chuong_fname from tb_chuong WHERE truyen_id='$truyen_id' ORDER BY chuong_pos LIMIT 1)
union all
(select chuong_id,chuong_name,chuong_fname from tb_chuong WHERE truyen_id='$truyen_id' ORDER BY chuong_pos DESC LIMIT 1);
");
$i=0;$txt_chap_f=$txt_chap_l='';
$txt_chuong_l = 0;
$v_chuong_first = 0;
while($r_f_l_chap = $DB->fetch_row($q_f_l_chap)){
if($i==0) {
$txt_chap_f = '<a class="btn btn-sm btn-info text-white mb-2" href="/' . $row_check['truyen_fname'] . '-' . $row_check['truyen_id'] . '/' . $r_f_l_chap['chuong_fname'] . '-' . $r_f_l_chap['chuong_id'] . '/"> Read first <i class="fa-solid fa-arrow-right"></i></a>';
$v_chuong_first = $r_f_l_chap['chuong_id'];
}
if($i==1) {
$txt_chap_l = '<a class="btn btn-sm btn-info text-white mb-2" href="/' . $row_check['truyen_fname'] . '-' . $row_check['truyen_id'] . '/' . $r_f_l_chap['chuong_fname'] . '-' . $r_f_l_chap['chuong_id'] . '/"><i class="fa-solid fa-arrow-left"></i> Read last</a>';
$txt_chuong_l = $r_f_l_chap['chuong_id'];
}
$i++;
}
//update hit
$arr_hit = array('truyen_id'=>$truyen_id,'chuong_id'=>$v_chuong_first,'hit_ip'=>$ip,'hit_browser'=>
'','hit_device'=>$func->Detect_Mobile_Browser(),'user_id'=>$v_tmp_user_id,'hit_date'=>date('Y-m-d'),'hit_time'=>time());
if(!isset($ob_user->user_id) or intval($ob_user->user_id)==0){
$row_check_hit = $DB->fetch_row($DB->query("SELECT * FROM tb_hit WHERE truyen_id='$truyen_id' AND hit_ip='".$ip."' ORDER BY hit_time DESC LIMIT 1 "));
}else{
$row_check_hit = $DB->fetch_row($DB->query("SELECT * FROM tb_hit WHERE truyen_id='$truyen_id' AND user_id='".intval($ob_user->user_id)."' ORDER BY hit_time DESC LIMIT 1 "));
}
if(!$row_check_hit){
$DB->do_insert('tb_hit',$arr_hit);
}
$date_ngay = time()-(24*60*60);
$date_tuan = time()-(7*24*60*60);
$date_thang = time()-(30*24*60*60);
$q_count_hit = $DB->query("SELECT count(*) as truyen_hit FROM tb_hit WHERE truyen_id='$truyen_id'
UNION ALL
SELECT count(*) FROM tb_hit WHERE truyen_id='$truyen_id' AND hit_time>'".$date_ngay."'
UNION ALL
SELECT count(*) FROM tb_hit WHERE truyen_id='$truyen_id' AND hit_time>'".$date_tuan."'
UNION ALL
SELECT count(*) FROM tb_hit WHERE truyen_id='$truyen_id' AND hit_time>'".$date_thang."'
");
$hit_total = $hit_ngay = $hit_tuan = $hit_thang = 0;
$i = 1;
while($r_count_hit = $DB->fetch_row($q_count_hit)){
if($i==1){
$hit_total = $r_count_hit['truyen_hit'];
}
if($i==2){
$hit_ngay = $r_count_hit['truyen_hit'];
}
if($i==3){
$hit_tuan = $r_count_hit['truyen_hit'];
}
if($i==4){
$hit_thang = $r_count_hit['truyen_hit'];
}
$i++;
}
$DB->query("UPDATE tb_truyen SET truyen_hit = '$hit_total',truyen_hitngay='$hit_ngay',truyen_hittuan='$hit_tuan',truyen_hitthang='$hit_thang' WHERE truyen_id='$truyen_id' ");
//continue read
//show detail
$txt_tacgia = '';
if($row_check['truyen_tacgia']!=''){
$arr_tac_gia = explode('@',$row_check['truyen_tacgia']);
$txt_tacgia = implode("','",$arr_tac_gia);
$q_tg = $DB->query("SELECT * FROM tb_author WHERE author_fname IN ('".$txt_tacgia."')");
while($r_tg = $DB->fetch_row($q_tg)){
$arr_author[] = '<a href="/author/'.$r_tg['author_fname'].'/">'.$r_tg['author_name'].'</a>';
}
}
$txt_author = 'Updating';
if(!empty($arr_author)){
$txt_author = implode(', ',$arr_author);
}
$txt_li_genres = $txt_list_genres = '';
$q_menu_page = $DB->query(" SELECT a.menus_id,a.menus_name,a.menus_fname FROM tb_menus a LEFT JOIN tb_menus_pages b ON a.menus_id=b.menus_id WHERE b.truyen_id='".$truyen_id."' AND a.menus_parentid!=0 ");
while ($r_menu_page = $DB->fetch_row($q_menu_page)){
$txt_li_genres .= '<li class="breadcrumb-item"><a href="/genres/'.$r_menu_page['menus_fname'].'/">'.$r_menu_page['menus_name'].'</a></li>';
$arr_list_genres[] = '<a href="/genres/'.$r_menu_page['menus_fname'].'/">'.$r_menu_page['menus_name'].'</a>';
$arr_genres_id[]=$r_menu_page['menus_id'];
}
$txt_list_genres = implode(' - ',$arr_list_genres);
//list chap
$chuong_lasted_read_id=0;
if($v_tmp_user_id>0){
$r_guest_hitchap = $DB->fetch_row($DB->query("SELECT chuong_id FROM tb_guest_hitchap WHERE truyen_id='$truyen_id' AND user_id='$v_tmp_user_id' ORDER BY hit_time DESC LIMIT 1 "));
if($r_guest_hitchap){
$chuong_lasted_read_id = $r_guest_hitchap['chuong_id'];
}
}
$where = " AND t1.truyen_id='$truyen_id' ";
$pageNum = isset($_GET['pageNum']) ? intval($_GET['pageNum']) : 1;
$pageSize = 51;
$from = (($pageNum * $pageSize) - $pageSize);
$t = $DB->fetch_row($DB->query("SELECT count(*) as total FROM tb_chuong t1 WHERE 1 ".$where));
$total = $t['total'];
$totalPage = ceil($total / $pageSize);
$query = $DB->query("select distinct t1.* from tb_chuong t1 WHERE 1 ".$where." ORDER BY t1.chuong_pos DESC LIMIT $from, $pageSize");
$list_chap = '';
while ($row = $DB->fetch_row($query)){
$txt_time = '<i>'.$func->time_site($row['time_post']).'</i>';
if($row['chuong_id'] == $chuong_lasted_read_id){
$txt_time = '<i class="fas fa-book-reader"></i>';
}
if(!empty($row['lock_to_date']) and strtotime($row['lock_to_date'])>time()){
$txt_time = '<span class="text-warning"><i class="fas fa-crown"></i></span>';
}
$list_chap .= '<li class="wp-manga-chapter"><a href="/' . $row_check['truyen_fname'] . '-' . $row_check['truyen_id'] . '/' . $row['chuong_fname'] . '-' . $row['chuong_id'] . '/">' . $row['chuong_name'] . '</a><span class="chapter-release-date">' . $txt_time . '</span></li>';
}
$nav = '';
if($totalPage>6) {
if($pageNum>1) {
$nav .= '<li class=""><span class="current prev" href="javascript:void(0);" onclick="load_list_chapter(' . ($pageNum - 1) . ');"><i class="icon ion-md-arrow-back"></i><span>Prev</span></span></li>';
}
if ($pageNum==1) {
$nav .= '<li class="active"><span class="current">1</span></li>';
} else {
$nav .= '<li><a href="javascript:void(0);" class="page-link" onclick="load_list_chapter(1);">1</a></li>';
}
if($pageNum==1){
for($i=2;$i<=3;$i++) {
if($i>=$totalPage){
continue;
}
if ($i == $pageNum) {
$nav .= '<li class="active"><span class="current">' . $i . '</span></li>';
} else {
$nav .= '<li><a href="javascript:void(0);" class="page-link" onclick="load_list_chapter(' . $i . ');">' . $i . '</a></li>';
}
}
$nav .= '<li>...</li>';
}
if($pageNum>1 and $pageNum<$totalPage-3){
if($pageNum>4) {
$nav .= '<li>...</li>';
}
for($i=$pageNum-2;$i<=$pageNum+2;$i++) {
if($i<2 or $i>=$totalPage){
continue;
}
if ($i == $pageNum) {
$nav .= '<li class="active"><span class="current">' . $i . '</span></li>';
} else {
$nav .= '<li><a href="javascript:void(0);" class="page-link" onclick="load_list_chapter(' . $i . ');">' . $i . '</a></li>';
}
}
$nav .= '<li>...</li>';
}
if($pageNum>=$totalPage-3 and $pageNum<$totalPage){
$nav .= '<li>...</li>';
for($i=$pageNum-2;$i<=$pageNum+2;$i++) {
if($i<0 or $i>=$totalPage){
continue;
}
if ($i == $pageNum) {
$nav .= '<li class="active"><span class="current">' . $i . '</span></li>';
} else {
$nav .= '<li><a href="javascript:void(0);" class="page-link" onclick="load_list_chapter(' . $i . ');">' . $i . '</a></li>';
}
}
}
if ($totalPage == $pageNum) {
$nav .= '<li>...</li>';
for($i=$totalPage-3;$i<=$totalPage-1;$i++) {
if($i>=$totalPage){
continue;
}
if ($i == $pageNum) {
$nav .= '<li class="active"><span class="current">' . $i . '</span></li>';
} else {
$nav .= '<li><a href="javascript:void(0);" class="page-link" onclick="load_list_chapter(' . $i . ');">' . $i . '</a></li>';
}
}
$nav .= '<li class="active"><span class="current">' . $totalPage . '</span></li>';
} else {
$nav .= '<li><a href="javascript:void(0);" class="page-link" onclick="load_list_chapter(' . $totalPage . ');">' . $totalPage . '</a></li>';
}
if($pageNum<$totalPage){
$nav .= '<li><a href="javascript:void(0);" class="page-link next" onclick="load_list_chapter(' . ($pageNum + 1) . ');"><span>Next</span><i class="icon ion-md-arrow-forward"></i></a></li>';
}
}
if($totalPage>1 and $totalPage<=6){
if($pageNum>1) {
$nav .= '<li class=""><span class="current prev" href="javascript:void(0);" onclick="load_list_chapter(' . ($pageNum - 1) . ');"><i class="icon ion-md-arrow-back"></i><span>Prev</span></span></li>';
}
for($i=1;$i<=$totalPage;$i++){
if ($i == $pageNum) {
$nav .= '<li class="active"><span class="current">' . $i . '</span></li>';
} else {
$nav .= '<li><a href="javascript:void(0);" class="page-link" onclick="load_list_chapter(' . $i . ');">' . $i . '</a></li>';
}
}
if($pageNum<$totalPage){
$nav .= '<li><a href="javascript:void(0);" class="page-link next" onclick="load_list_chapter(' . ($pageNum + 1) . ');"><span>Next</span><i class="icon ion-md-arrow-forward"></i></a></li>';
}
}
?>