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/include/functions/ |
<?php
function related_manga($arr_genres,$truyen_id,$limit=4){
global $DB;
$where = " AND truyen_active_status='Active' AND truyen_sochuong is not NULL AND truyen_id!='$truyen_id' ";
$list = '';
if(!empty($arr_genres)){
$txt_genres = implode(',',$arr_genres);
$query = $DB->query("SELECT * FROM tb_truyen WHERE 1 ".$where." AND truyen_id IN (SELECT truyen_id FROM tb_menus_pages WHERE menus_id IN (".$txt_genres.") ) ORDER BY rand() LIMIT 0,4");
while ($row = $DB->fetch_row($query)){
$list .= '<div class="col-lg-3 col-md-4 col-sm-4 col-6 video position-relative mb-2">
<div class="card">
<div class="view clearfix">
<span class="pull-left">
<i class="far fa-eye">
</i> '.shortNumber($row['truyen_hit']).' <i class="far fa-comment"></i> '.shortNumber($row['truyen_hitcomment']).' <i class="far fa-heart"></i> '.shortNumber($row['truyen_theodoi']).' </span>
</div>
<a href="/'.$row['truyen_fname'].'-'.$row['truyen_id'].'/"><img src="'.$row['truyen_thumb'].'" class="jtip card-img-top" alt="'.$row['truyen_name'].'" data-jtip="#manga-tooltip-'.$row['truyen_id'].'"></a>
<div class="card-body list-left-8-manga">
<p class="card-text title-manga"><a href="/'.$row['truyen_fname'].'-'.$row['truyen_id'].'/" class="jtip text-body" data-jtip="#manga-tooltip-'.$row['truyen_id'].'">'.$row['truyen_name'].'</a></p>
</div>
</div>
</div>';
}
}
return $list;
}
function check_have_new_chap_in_follow(){
global $DB,$ob_user;
if(isset($ob_user->user_id) and intval($ob_user->user_id)>0){
$where = " b.user_id='".intval($ob_user->user_id)."' ";
$q_follow = $DB->query("
SELECT a.truyen_id,a.chuong_id,max(a.chuong_pos) as chuong_pos_max,b.chuong_pos as chuong_pos_follow FROM tb_chuong a, tb_follow b WHERE ".$where." AND a.truyen_id = b.truyen_id GROUP BY b.truyen_id HAVING chuong_pos_max>chuong_pos_follow;
");
while($r_follow = $DB->fetch_row($q_follow)){
if($r_follow['chuong_pos_max']>$r_follow['chuong_pos_follow']){
return 1;
}
}
}
return 0;
}
function follow_manga($limit=5){
global $DB,$func,$ob_user,$ip,$memcache;
$where = " a.follow_ip='".$ip."' ";
if(isset($ob_user->user_id) and intval($ob_user->user_id)>0){
$where = " (a.user_id='".intval($ob_user->user_id)."') ";
}else{
return '';
}
$key_follow = "SELECT DISTINCT a.truyen_id, a.chuong_id as chuong_follow_id, b.*
FROM tb_follow a LEFT JOIN tb_truyen b ON a.truyen_id=b.truyen_id
WHERE ".$where."
ORDER BY b.time_update DESC LIMIT 0,$limit";
$cache_follow = $memcache->get($key_follow); // Memcached object
if($cache_follow){
$list = $cache_follow;
}else {
$q_follow = $DB->query("
SELECT DISTINCT a.truyen_id, a.chuong_id as chuong_follow_id, b.*
FROM tb_follow a LEFT JOIN tb_truyen b ON a.truyen_id=b.truyen_id
WHERE " . $where . "
ORDER BY b.time_update DESC LIMIT 0,$limit
");
$list = '';
while ($r_follow = $DB->fetch_row($q_follow)) {
$list .= '<article class="w_item_b" id="li_hitory_manga_' . $row['truyen_id'] . '">
<div class="image"><a href="/' . $row['truyen_fname'] . '-' . $row['truyen_id'] . '/' . $row['truyen_chuong_moinhat_fname'] . '-' . $row['truyen_chuong_moinhat_id'] . '/"><img src="'.$INFO['remote_url'] . $row['truyen_thumb'] . '" alt="' . $row['truyen_name'] . '" /></a></div>
<div class="data">
<h3><a href="/' . $row['truyen_fname'] . '-' . $row['truyen_id'] . '/">' . $row['truyen_name'] . '</a></h3>
<div class="dt_wb"><a href="/' . $row['truyen_fname'] . '-' . $row['truyen_id'] . '/' . $row['truyen_chuong_moinhat_fname'] . '-' . $row['truyen_chuong_moinhat_id'] . '/" title="' . $row['truyen_chuong_moinhat_name'] . '">' . $row['truyen_chuong_moinhat_name'] . '</a></div>
<div class="wextra"><i class="far fa-clock"></i> ' . $func->time_ago(strtotime($r_follow['time_update'])) . '</div>
</div>
</article>';
}
$memcache->set($key_follow, $list, MEMCACHE_COMPRESSED, 30);
}
return $list;
}
function history_manga($limit=5){
global $INFO,$DB,$ob_user,$ip,$memcache;
$where = " a.hit_ip='".$ip."' ";
if(isset($ob_user->user_id) and intval($ob_user->user_id)>0){
$where = " (a.user_id='".intval($ob_user->user_id)."' OR a.hit_ip='".$ip."') ";
}
$key_cache_history_manga = md5("
SELECT DISTINCT a.hit_id,a.truyen_id,a.hit_time, a.chuong_id as chuong_hit_id,a.user_id, b.truyen_id, b.truyen_fname, b.truyen_name, b.truyen_thumb, b.truyen_chuong_moinhat_id, b.truyen_chuong_moinhat_name, b.truyen_chuong_moinhat_fname, b.time_update
FROM tb_hit a LEFT JOIN tb_truyen b ON a.truyen_id=b.truyen_id
WHERE ".$where."
GROUP BY a.truyen_id
ORDER BY a.hit_time DESC LIMIT 1,$limit
");
$list = '';
if($memcache->get($key_cache_history_manga)){
$list = $memcache->get($key_cache_history_manga);
}else {
$q_follow = $DB->query("
SELECT DISTINCT a.hit_id,a.truyen_id,a.hit_time, a.chuong_id as chuong_hit_id,a.user_id, b.truyen_id, b.truyen_fname, b.truyen_name, b.truyen_thumb, b.truyen_chuong_moinhat_id, b.truyen_chuong_moinhat_name, b.truyen_chuong_moinhat_fname, b.time_update
FROM tb_hit a LEFT JOIN tb_truyen b ON a.truyen_id=b.truyen_id
WHERE " . $where . "
GROUP BY a.truyen_id
ORDER BY a.hit_time DESC LIMIT 0,$limit
");
while ($row = $DB->fetch_row($q_follow)) {
$list .= '<article class="w_item_b" id="li_hitory_manga_' . $row['truyen_id'] . '">
<div class="image"><a href="/' . $row['truyen_fname'] . '-' . $row['truyen_id'] . '/' . $row['truyen_chuong_moinhat_fname'] . '-' . $row['truyen_chuong_moinhat_id'] . '/"><img src="'.$INFO['remote_url'] . $row['truyen_thumb'] . '" alt="' . $row['truyen_name'] . '" /></a></div>
<div class="data">
<h3><a href="/' . $row['truyen_fname'] . '-' . $row['truyen_id'] . '/">' . $row['truyen_name'] . '</a></h3>
<div class="dt_wb"><a href="/' . $row['truyen_fname'] . '-' . $row['truyen_id'] . '/' . $row['truyen_chuong_moinhat_fname'] . '-' . $row['truyen_chuong_moinhat_id'] . '/" title="' . $row['truyen_chuong_moinhat_name'] . '">' . $row['truyen_chuong_moinhat_name'] . '</a></div>
<div class="wextra"><a href="javascript:void(0);" onclick="deleteHistory(' . $row['truyen_chuong_moinhat_id'] . ');"><i class="far fa-trash-alt"></i> Delete</span></a></div>
</div>
</article>';
}
$memcache->set($key_cache_history_manga,$list,MEMCACHE_COMPRESSED, 60);
}
return $list;
}
function top_manga_month($limit=5){
global $INFO,$DB,$memcache;
$key_cache_top_manga_month = md5('top_manga_month_2_'.$limit);
$list_top_manga_month = $memcache->get($key_cache_top_manga_month);
if($list_top_manga_month){
$list = $list_top_manga_month;
}else{
$q_hitthang = $DB->query("
SELECT a.*,b.*
FROM tb_truyen a LEFT JOIN tb_chuong b ON a.truyen_id=b.truyen_id
WHERE a.truyen_active_status='Active' AND a.truyen_sochuong>0 AND b.chuong_pos=(SELECT MAX(chuong_pos) FROM tb_chuong WHERE truyen_id=a.truyen_id)
GROUP BY a.truyen_id
ORDER BY a.truyen_hitthang DESC LIMIT 0,$limit
");
$i = 1;
$list = '';
while($r_hitthang = $DB->fetch_row($q_hitthang)){
$list .= '<li class="list-group-item list-group-item-action d-flex justify-content-between align-items-center" id="manga_topmonth_'.$r_hitthang['truyen_id'].'">
<div class="flex-column title-right-top-manga">
<a href="/'.$r_hitthang['truyen_fname'].'-'.$r_hitthang['truyen_id'].'/" title="'.$r_hitthang['truyen_name'].'" class="manga-text-right top-title-'.$i.'">'.$i.') '.$r_hitthang['truyen_name'].'</a>
<p class="chap-box-text-view"><small><a href="/'.$r_hitthang['truyen_fname'].'-'.$r_hitthang['truyen_id'].'/'.$r_hitthang['chuong_fname'].'-'.$r_hitthang['chuong_id'].'/" class="manga-read-more">Read more '.$r_hitthang['chuong_name'].'</a></small></p>
<span class="manga-text-view"><i class="far fa-eye"></i> '.$r_hitthang['truyen_hit'].'</span>
</div>
<div class="image-parent">
<a href="/'.$r_hitthang['truyen_fname'].'-'.$r_hitthang['truyen_id'].'/" title="'.$r_hitthang['truyen_name'].'"><img src="'.$INFO['remote_url'].$r_hitthang['truyen_thumb'].'" class="img-fluid" alt="'.$r_hitthang['truyen_name'].'"></a>
</div>
</li>';
$i++;
}
$memcache->set($key_cache_top_manga_month, $list, MEMCACHE_COMPRESSED, 600);
}
return $list;
}
function top_manga_week($limit=5){
global $INFO,$DB,$memcache;
$key_cache_manga_week = md5('top_manga_week_1_'.$limit);
$list_top_manga_week = $memcache->get($key_cache_manga_week);
if($list_top_manga_week){
$list = $list_top_manga_week;
}else {
$q_hitweek = $DB->query("
SELECT a.*,b.*
FROM tb_truyen a LEFT JOIN tb_chuong b ON a.truyen_id=b.truyen_id
WHERE a.truyen_active_status='Active' AND a.truyen_sochuong>0 AND b.chuong_pos=(SELECT MAX(chuong_pos) FROM tb_chuong WHERE truyen_id=a.truyen_id)
GROUP BY a.truyen_id
ORDER BY a.truyen_hittuan DESC LIMIT 0,$limit
");
$i = 1;
$list = '';
while ($r_hitthang = $DB->fetch_row($q_hitweek)) {
$list .= '<li class="list-group-item list-group-item-action d-flex justify-content-between align-items-center" id="manga_topmonth_' . $r_hitthang['truyen_id'] . '">
<div class="flex-column title-right-top-manga">
<a href="/' . $r_hitthang['truyen_fname'] . '-' . $r_hitthang['truyen_id'] . '/" title="' . $r_hitthang['truyen_name'] . '" class="manga-text-right top-title-' . $i . '">' . $i . ') ' . $r_hitthang['truyen_name'] . '</a>
<p class="chap-box-text-view"><small><a href="/' . $r_hitthang['truyen_fname'] . '-' . $r_hitthang['truyen_id'] . '/' . $r_hitthang['chuong_fname'] . '-' . $r_hitthang['chuong_id'] . '/" class="manga-read-more">Read more ' . $r_hitthang['chuong_name'] . '</a></small></p>
<span class="manga-text-view"><i class="far fa-eye"></i> ' . $r_hitthang['truyen_hit'] . '</span>
</div>
<div class="image-parent">
<a href="/' . $r_hitthang['truyen_fname'] . '-' . $r_hitthang['truyen_id'] . '/" title="' . $r_hitthang['truyen_name'] . '"><img src="' .$INFO['remote_url']. $r_hitthang['truyen_thumb'] . '" class="img-fluid" alt="' . $r_hitthang['truyen_name'] . '"></a>
</div>
</li>';
$i++;
}
$memcache->set($key_cache_manga_week, $list, MEMCACHE_COMPRESSED, 600);
}
return $list;
}
function top_manga_date($limit=5){
global $INFO,$DB,$memcache;
$key_cache_manga_date = md5('top_manga_date_1_'.$limit);
$list_top_manga_date = $memcache->get($key_cache_manga_date);
if($list_top_manga_date){
$list = $list_top_manga_date;
}else {
$q_hitdate = $DB->query("
SELECT a.*,b.*
FROM tb_truyen a LEFT JOIN tb_chuong b ON a.truyen_id=b.truyen_id
WHERE a.truyen_active_status='Active' AND a.truyen_sochuong>0 AND b.chuong_pos=(SELECT MAX(chuong_pos) FROM tb_chuong WHERE truyen_id=a.truyen_id)
GROUP BY a.truyen_id
ORDER BY a.truyen_hitngay DESC LIMIT 0,$limit
");
$i = 1;
$list = '';
while ($r_hitthang = $DB->fetch_row($q_hitdate)) {
$list .= '<li class="list-group-item list-group-item-action d-flex justify-content-between align-items-center" id="manga_topmonth_' . $r_hitthang['truyen_id'] . '">
<div class="flex-column title-right-top-manga">
<a href="/' . $r_hitthang['truyen_fname'] . '-' . $r_hitthang['truyen_id'] . '/" title="' . $r_hitthang['truyen_name'] . '" class="manga-text-right top-title-' . $i . '">' . $i . ') ' . $r_hitthang['truyen_name'] . '</a>
<p class="chap-box-text-view"><small><a href="/' . $r_hitthang['truyen_fname'] . '-' . $r_hitthang['truyen_id'] . '/' . $r_hitthang['chuong_fname'] . '-' . $r_hitthang['chuong_id'] . '/" class="manga-read-more">Read more ' . $r_hitthang['chuong_name'] . '</a></small></p>
<span class="manga-text-view"><i class="far fa-eye"></i> ' . $r_hitthang['truyen_hit'] . '</span>
</div>
<div class="image-parent">
<a href="/' . $r_hitthang['truyen_fname'] . '-' . $r_hitthang['truyen_id'] . '/" title="' . $r_hitthang['truyen_name'] . '"><img src="' .$INFO['remote_url']. $r_hitthang['truyen_thumb'] . '" class="img-fluid" alt="' . $r_hitthang['truyen_name'] . '"></a>
</div>
</li>';
$i++;
}
$memcache->set($key_cache_manga_date, $list, MEMCACHE_COMPRESSED, 600);
}
return $list;
}
?>