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/netphim/code/manga/ |
<?php
global $DB,$CORE,$func,$memcache,$ip;
$truyen_id = $CORE->input['id'] ?? 0;
$chuong_id = $CORE->input['chap_id'] ?? 0;
$truyen_id = $CORE->input['id'] ?? 0;
$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: index.html');
}
$v_tmp_user_id=0;
if(isset($ob_user->user_id) and intval($ob_user->user_id)>0){
$v_tmp_user_id=intval($ob_user->user_id);
}
$txt_li_genres = $txt_list_genres = '';
$key_menu_page = md5(" 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 ");
$txt_li_genres = $memcache->get($key_menu_page);
$arr_list_genres = $memcache->get($key_menu_page.'_arr');
if($txt_li_genres){
}else {
$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>';
}
$memcache->set($key_menu_page, $txt_li_genres, MEMCACHE_COMPRESSED, 86400);
$memcache->set($key_menu_page.'_arr', $arr_list_genres, MEMCACHE_COMPRESSED, 86400);
}
$txt_list_genres = implode(' - ',$arr_list_genres);
//detail chap
$row_chuong = $DB->fetch_row($DB->query("SELECT * FROM tb_chuong WHERE chuong_id='$chuong_id'"));
//list server
$txt_list_server = '';
$q_server = $DB->query("SELECT * FROM tb_server WHERE server_status='Active' ORDER BY server_pos ");
$i = 1;
$server_id = 0;
$server_domain = '';
while ($r_server = $DB->fetch_row($q_server)) {
$class = 'btn-info';
if ($r_server['server_id'] == $row_check['server_id']) {
$class = 'btn-success';
$server_id = $r_server['server_id'];
$server_domain = $r_server['server_link'];
}
$txt_list_server .= ' <a rel="nofollow" href="javascript:void(0);" data-id="' . $r_server['server_id'] . '" data-link="' . $r_server['server_link'] . '" data-position="' . $i . '" class="loadchapter btn btn-sm ' . $class . ' mb-1" id="a_loadchapter_' . $r_server['server_id'] . '"><i class="fas fa-server"></i> ' . $r_server['server_name'] . '</a>';
$i++;
}
//ads
$arr_ads = list_ads();
//sensitive_chap
$txt_sensitive_chap_id = $txt_sensitive_chap = $url_img_rand='';
if($row_chuong['sensitive_chap_id']!=''){
$arr_sensitive_chap_id = explode('@',$row_chuong['sensitive_chap_id']);
$arr_sensitive_chap_id_new = array();
foreach($arr_sensitive_chap_id as $val){
if(intval($val)>0){
$arr_sensitive_chap_id_new[] = $val;
}
}
$txt_sensitive_chap_id = implode(',',$arr_sensitive_chap_id_new);
$q_sensitive_chap = $DB->query("SELECT sensitive_chap_name FROM tb_sensitive_chap WHERE sensitive_chap_id IN (".$txt_sensitive_chap_id.") ");
$arr_sensitive_chap_name = array();
while($r_sensitive_chap = $DB->fetch_row($q_sensitive_chap)){
$txt_sensitive_chap .= '<li>'.$r_sensitive_chap['sensitive_chap_name'].'</li>';
}
$r_img_rand = $DB->fetch_row($DB->query("SELECT domain,url_dir,file_name FROM tb_chuong_img WHERE chuong_id='".$chuong_id."' ORDER BY rand() LIMIT 1 "));
$url_img_rand = $r_img_rand['domain'].'/'.$r_img_rand['url_dir'].'/'.$r_img_rand['file_name'];
}
//next chap
$r_next_chuong = $DB->fetch_row($DB->query("SELECT * FROM tb_chuong WHERE truyen_id='$truyen_id' AND round(chuong_pos,1)>'".$row_chuong['chuong_pos']."' ORDER BY chuong_pos ASC LIMIT 1 "));
$r_prev_chuong = $DB->fetch_row($DB->query("SELECT * FROM tb_chuong WHERE truyen_id='$truyen_id' AND round(chuong_pos,1)<'".$row_chuong['chuong_pos']."' ORDER BY chuong_pos DESC LIMIT 1 "));
//update user follow
if(!$r_next_chuong){
if(isset($ob_user->user_id) and intval($ob_user->user_id)>0) {
$DB->query("UPDATE tb_follow SET chuong_id='" . $row_chuong['chuong_id'] . "',chuong_pos='" . $row_chuong['chuong_pos'] . "' WHERE user_id='" . intval($ob_user->user_id) . "' AND truyen_id='" . $truyen_id . "' ");
}else{
$DB->query("UPDATE tb_follow SET chuong_id='" . $row_chuong['chuong_id'] . "',chuong_pos='" . $row_chuong['chuong_pos'] . "' WHERE follow_ip='" . $ip . "' AND truyen_id='" . $truyen_id . "' ");
}
}
//list chap modal
$where = " AND t1.truyen_id='$truyen_id' ";
$pageSize = 51;
$t = $DB->fetch_row($DB->query("SELECT count(*) as total FROM tb_chuong t1 WHERE 1 ".$where));
$total = $t['total'];
$totalPage = ceil($total / $pageSize);
$r_chuong_num_to = $DB->fetch_row($DB->query("SELECT count(*) as total_to_chap FROM tb_chuong WHERE truyen_id='$truyen_id' AND round(chuong_pos,1)>='".$row_chuong['chuong_pos']."' "));
$pageNum = ceil($r_chuong_num_to['total_to_chap'] / $pageSize);
$from = (($pageNum * $pageSize) - $pageSize);
if($from<0){
$from=0;
}
/*echo $ip;
if($ip=='139.59.136.107'){
echo "SELECT count(*) as total_to_chap FROM tb_chuong WHERE truyen_id='$truyen_id' AND chuong_pos>='".$row_chuong['chuong_pos']."' ";
exit();
}*/
$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_active = '';
if($chuong_id==$row['chuong_id']){
$txt_active = 'active';
}
$list_chap .= '<li class="wp-manga-chapter '.$txt_active.'" id="chapter_' . $row['chuong_id'] . '"><a href="/' . $row_check['truyen_fname'] . '-' . $row_check['truyen_id'] . '/' . $row['chuong_fname'] . '-' . $row['chuong_id'] . '/">' . $row['chuong_name'] . '</a></li>';
}
$nav = $keyword = '';
if($totalPage>6) {
if($pageNum>1) {
$nav .= '<li class=""><span class="current prev" href="javascript:void(0);" onclick="load_list_chapter_modal('.$truyen_id.',' . ($pageNum - 1) . ',\''.$keyword.'\','.$chuong_id.');"><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_modal('.$truyen_id.',1,\''.$keyword.'\','.$chuong_id.');">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_modal('.$truyen_id.',' . $i . ',\''.$keyword.'\','.$chuong_id.');">' . $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_modal('.$truyen_id.',' . $i . ',\''.$keyword.'\','.$chuong_id.');">' . $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_modal('.$truyen_id.',' . $i . ',\''.$keyword.'\','.$chuong_id.');">' . $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_modal('.$truyen_id.',' . $i . ',\''.$keyword.'\','.$chuong_id.');">' . $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_modal('.$truyen_id.',' . $totalPage . ',\''.$keyword.'\','.$chuong_id.');">' . $totalPage . '</a></li>';
}
if($pageNum<$totalPage){
$nav .= '<li><a href="javascript:void(0);" class="page-link next" onclick="load_list_chapter_modal('.$truyen_id.',' . ($pageNum + 1) . ',\''.$keyword.'\','.$chuong_id.');"><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_modal('.$truyen_id.',' . ($pageNum - 1) . ',\''.$keyword.'\','.$chuong_id.');"><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_modal('.$truyen_id.',' . $i . ',\''.$keyword.'\','.$chuong_id.');">' . $i . '</a></li>';
}
}
if($pageNum<$totalPage){
$nav .= '<li><a href="javascript:void(0);" class="page-link next" onclick="load_list_chapter_modal('.$truyen_id.',' . ($pageNum + 1) . ',\''.$keyword.'\','.$chuong_id.');"><span>Next</span><i class="icon ion-md-arrow-forward"></i></a></li>';
}
}
//follow
$where_follow = " follow_ip='".$ip."' ";
if(isset($ob_user->user_id) and intval($ob_user->user_id)>0){
$where_follow = " user_id='".intval($ob_user->user_id)."' ";
}
$r_follow = $DB->fetch_row($DB->query("SELECT * FROM tb_follow WHERE truyen_id='$truyen_id' AND ".$where_follow." LIMIT 1 "));
//update hit
$hit_device = $func->Detect_Mobile_Browser();
$arr_hit = array('truyen_id'=>$truyen_id,'chuong_id'=>$chuong_id,'hit_ip'=>$ip,'hit_browser'=>'','hit_device'=>$hit_device,'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 chuong_id='$chuong_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 chuong_id='$chuong_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' ");
$row_count_hit_chuong = $DB->fetch_row($DB->query("SELECT count(*) as total FROM tb_hit WHERE chuong_id='$chuong_id' "));
$DB->query("UPDATE tb_chuong SET chuong_hit = '".$row_count_hit_chuong['total']."' WHERE chuong_id='$chuong_id' ");
//update guest hit
if($v_tmp_user_id>0){
$arr_insert = array('user_id'=>$ob_user->user_id,'truyen_id'=>$truyen_id,'chuong_id'=>$chuong_id,'chuong_point'=>$row_chuong['chuong_point'],'hit_date'=>date('Y-m-d'),'hit_time'=>time());
$row_check_hit_guest = $DB->fetch_row($DB->query("SELECT * FROM tb_guest_hitchap WHERE user_id='".$ob_user->user_id."' AND truyen_id='$truyen_id' AND chuong_id='$chuong_id' LIMIT 1 "));
if(!$row_check_hit_guest){
$DB->do_insert('tb_guest_hitchap',$arr_insert);
}
$row_count_hit_guest = $DB->fetch_row($DB->query("SELECT count(*) as total_hit, sum(chuong_point) as total_point FROM tb_guest_hitchap WHERE user_id='".$ob_user->user_id."'"));
$r_level = $DB->fetch_row($DB->query("SELECT * FROM tb_guestpoint WHERE guestpoint_value<='".intval($row_count_hit_guest['total_point'])."' ORDER BY guestpoint_value DESC LIMIT 1 "));
$r_level_next = $DB->fetch_row($DB->query("SELECT * FROM tb_guestpoint WHERE guestpoint_value>'".intval($row_count_hit_guest['total_point'])."' ORDER BY guestpoint_value LIMIT 1 "));
if(!$r_level_next){//max level
$guest_next_level = $r_level['guestpoint_value'];
$guest_next_level_name = $r_level['guestpoint_level'];
}else{
$guest_next_level = $r_level_next['guestpoint_value'];
$guest_next_level_name = $r_level_next['guestpoint_level'];
}
$total_hit=$total_point=$guestpoint_value=0;
$guestpoint_level='';
if($row_count_hit_guest){
$total_hit = $row_count_hit_guest['total_hit'];
$total_point = $row_count_hit_guest['total_point'];
}
if($r_level){
$guestpoint_value= $r_level['guestpoint_value'];
$guestpoint_level = $r_level['guestpoint_level'];
}
$DB->query("UPDATE tb_guest SET guest_hitchap='".$total_hit."',guest_point='".intval($total_point)."',guest_level='".intval($guestpoint_value)."',guest_next_level='".intval($guest_next_level)."',guest_level_name='".$guestpoint_level."',guest_next_level_name='".$guest_next_level_name."' WHERE user_id='".$ob_user->user_id."' ");
}
//header seo
$CORE->title_page = str_replace('"',"'",$row_check['truyen_name']).' '.$row_chuong['chuong_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'];
?>