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/luckymerchan/include/functions/ |
<?php
function recommendation($limit=50){
global $DB,$func;
$where = " AND truyen_active_status='Active' AND truyen_sochuong is not NULL ";
$query = $DB->query("
SELECT truyen_id,truyen_name,truyen_fname,truyen_thumb,truyen_chuong_moinhat_id,truyen_chuong_moinhat_name,truyen_chuong_moinhat_fname,truyen_chuong_moinhat_isnew,truyen_chuong_moinhat_time
FROM tb_truyen
WHERE 1 ".$where."
ORDER BY time_post DESC LIMIT 0,$limit
");
$list = '';
while ($row = $DB->fetch_row($query)){
$list .= '<div class="item">
<a href="/'.$row['truyen_fname'].'-'.$row['truyen_id'].'/" title="'.$row['truyen_name'].'">
<img class="lazyOwl center" src="'.$row['truyen_thumb'].'" alt="'.$row['truyen_name'].'">
</a>
<div class="slide-caption">
<h3>
<a href="/'.$row['truyen_fname'].'-'.$row['truyen_id'].'/" title="'.$row['truyen_name'].'">'.$row['truyen_name'].'</a>
</h3>
<a href="/'.$row['truyen_fname'].'-'.$row['truyen_id'].'/'.$row['truyen_chuong_moinhat_fname'].'-'.$row['truyen_chuong_moinhat_id'].'/" title="'.$row['truyen_name'].'-'.$row['truyen_chuong_moinhat_name'].'">'.$row['truyen_chuong_moinhat_name'].'</a>
<span class="time">
<i class="far fa-clock"></i> '.$func->time_site($row['truyen_chuong_moinhat_time']).'</span>
</div>
</div>';
}
return $list;
}
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,$func,$ob_user,$ip;
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 ORDER BY a.chuong_pos DESC,b.chuong_pos DESC;
");
while($r_follow = $DB->fetch_row($q_follow)){
if($r_follow['chuong_pos_max']>$r_follow['chuong_pos_follow']){
return 1;
}
}
}
return 0;
}
function delete_follow_and_his_after_login(){
global $DB,$ip;
$DB->query("DELETE FROM tb_follow WHERE follow_ip='$ip' AND user_id='0' ");
//$DB->query("UPDATE tb_hit WHERE follow_ip='$ip' AND user_id='0' ");
}
function follow_manga($limit=5){
global $DB,$func,$ob_user,$ip;
$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 '';
exit();
}
$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 .= '<li class="clearfix">
<div class="t-item comic-item" data-id="17696">
<a class="thumb" title="'.$r_follow['truyen_name'].'" href="/'.$r_follow['truyen_fname'].'-'.$r_follow['truyen_id'].'/'.$r_follow['truyen_chuong_moinhat_fname'].'-'.$r_follow['truyen_chuong_moinhat_id'].'/">
<img class="lazy center" src="'.$r_follow['truyen_thumb'].'" alt="'.$r_follow['truyen_name'].'">
</a>
<h3 class="title">
<a href="/'.$r_follow['truyen_fname'].'-'.$r_follow['truyen_id'].'/">'.$r_follow['truyen_name'].'</a>
</h3>
<p class="chapter top">
<a data-id="'.$r_follow['truyen_chuong_moinhat_id'].'" href="/'.$r_follow['truyen_fname'].'-'.$r_follow['truyen_id'].'/'.$r_follow['truyen_chuong_moinhat_fname'].'-'.$r_follow['truyen_chuong_moinhat_id'].'/" title="'.$r_follow['truyen_chuong_moinhat_name'].'">'.$r_follow['truyen_chuong_moinhat_name'].'</a>
<span class="view-top-right pull-right">
<i class="far fa-clock"></i> '.$func->time_ago(strtotime($r_follow['time_update'])).'</span>
</p>
</div>
</li>';
}
return $list;
}
function history_manga($limit=5){
global $DB,$ob_user,$ip;
$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."') ";
}
$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
");
$list = '';
while($row = $DB->fetch_row($q_follow)){
$list .= '
<li class="clearfix" id="li_hitory_manga_'.$row['truyen_id'].'">
<div class="t-item comic-item" data-id="'.$row['truyen_id'].'">
<a class="thumb" title="'.$row['truyen_name'].'" href="/'.$row['truyen_fname'].'-'.$row['truyen_id'].'/'.$row['truyen_chuong_moinhat_fname'].'-'.$row['truyen_chuong_moinhat_id'].'/">
<img class="lazy center" src="'.$row['truyen_thumb'].'" alt="'.$row['truyen_name'].'">
</a>
<h3 class="title">
<a href="/'.$row['truyen_fname'].'-'.$row['truyen_id'].'/">'.$row['truyen_name'].'</a>
</h3>
<p class="chapter top">
<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>
<span class="view-top-right pull-right">
<a href="javascript:void(0);" onclick="deleteHistory('.$row['truyen_chuong_moinhat_id'].');"><i class="far fa-trash-alt"></i> Delete</span></a>
</p>
</div>
</li>';
}
return $list;
}
function top_manga_month($limit=5){
global $DB,$memcache;
$key_cache_top_manga_month = md5('top_manga_month_1_'.$limit);
$list_top_manga_month = $memcache->get($key_cache_top_manga_month);
if($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="'.$r_hitthang['truyen_thumb'].'" class="img-fluid" alt="'.$r_hitthang['truyen_name'].'"></a>
</div>
</li>';
$i++;
}
$list_top_manga_month = $list;
$memcache->set($key_cache_top_manga_month, $list_top_manga_month, MEMCACHE_COMPRESSED, 1200);
}
return $list_top_manga_month;
}
function top_manga_week($limit=5){
global $DB,$memcache;
$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="'.$r_hitthang['truyen_thumb'].'" class="img-fluid" alt="'.$r_hitthang['truyen_name'].'"></a>
</div>
</li>';
$i++;
}
return $list;
}
function top_manga_date($limit=5){
global $DB,$memcache;
$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="'.$r_hitthang['truyen_thumb'].'" class="img-fluid" alt="'.$r_hitthang['truyen_name'].'"></a>
</div>
</li>';
$i++;
}
return $list;
}
?>