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
$CORE->title_page = 'Manga reading history';
$type = $CORE->input['type'] ?? 'list';
$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)."') ";
}
$pageNum = isset($_GET['pageNum']) ? intval($_GET['pageNum']) : 1;
$pageSize = 36;
$from = (($pageNum * $pageSize) - $pageSize);
$t = $DB->fetch_row($DB->query("
SELECT COUNT(*)
FROM
(
SELECT COUNT(*)
FROM tb_hit a LEFT JOIN tb_truyen b ON a.truyen_id=b.truyen_id
WHERE ".$where."
GROUP BY a.truyen_id
) total
"
));
$total = $t['COUNT(*)'];
$totalPage = ceil($total / $pageSize);
$q_history = $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 b.time_update DESC LIMIT $from,$pageSize
");
$list = $list_account = '';
while($row = $DB->fetch_row($q_history)){
$txt_new = $func->time_site($row['time_update']);
$chuong_id = $row['chuong_hit_id'];
$read = '<span><i class="far fa-clock"></i> '.$func->time_ago($row['hit_time']).'</span>';
if(isset($ob_user->user_id) and intval($ob_user->user_id)>0 and $row['user_id']==intval($ob_user->user_id)){
$list_account .= '<div class="col-lg-3 col-md-4 col-sm-4 col-6 video position-relative mb-2" id="li_hitory_manga_'.$row['truyen_id'].'">
<div class="card">
<a href="/'.$row['truyen_fname'].'-'.$row['truyen_id'].'/"><img src="'.$row['truyen_thumb'].'" class="card-img-top" alt="'.$row['truyen_name'].'"></a>
<div class="card-body list-left-8-manga">
<div class="follow-action clearfix">
'.$read.'
<a href="javascript:void(0);" class="history-delete" onclick="deleteHistory('.$row['truyen_chuong_moinhat_id'].')"><i class="fas fa-trash-alt"></i> Delete</a>
</div>
<p class="card-text title-manga"><a href="/'.$row['truyen_fname'].'-'.$row['truyen_id'].'/" class=" text-body" >'.$row['truyen_name'].'</a></p>
</div>
<ul class="list-group list-group-flush" style="font-size: 12px;">
<li class="list-group-item-custom list-group-item"><a href="/'.$row['truyen_fname'].'-'.$row['truyen_id'].'/'.$row['truyen_chuong_moinhat_fname'].'-'.$row['truyen_chuong_moinhat_id'].'/" class="text-secondary list-2-chap" title="'.$row['truyen_chuong_moinhat_name'].'">'.$row['truyen_chuong_moinhat_name'].'</a> <span class="blockquote-footer"><cite title="'.$row['truyen_name'].'">'.$txt_new.'</cite></span></li>
</ul>
</div>
</div>';
}
$list .= '<div class="col-lg-3 col-md-4 col-sm-4 col-6 video position-relative mb-2" id="li_hitory_manga_'.$row['truyen_id'].'">
<div class="card">
<a href="/'.$row['truyen_fname'].'-'.$row['truyen_id'].'/"><img src="'.$row['truyen_thumb'].'" class="card-img-top" alt="'.$row['truyen_name'].'"></a>
<div class="card-body list-left-8-manga">
<div class="follow-action clearfix">
'.$read.'
<a href="javascript:void(0);" class="history-delete" onclick="deleteHistory('.$row['truyen_chuong_moinhat_id'].')"><i class="fas fa-trash-alt"></i> Delete</a>
</div>
<p class="card-text title-manga"><a href="/'.$row['truyen_fname'].'-'.$row['truyen_id'].'/" class=" text-body" >'.$row['truyen_name'].'</a></p>
</div>
<ul class="list-group list-group-flush" style="font-size: 12px;">
<li class="list-group-item-custom list-group-item"><a href="/'.$row['truyen_fname'].'-'.$row['truyen_id'].'/'.$row['truyen_chuong_moinhat_fname'].'-'.$row['truyen_chuong_moinhat_id'].'/" class="text-secondary list-2-chap" title="'.$row['truyen_chuong_moinhat_name'].'">'.$row['truyen_chuong_moinhat_name'].'</a> <span class="blockquote-footer"><cite title="'.$row['truyen_name'].'">'.$txt_new.'</cite></span></li>
</ul>
</div>
</div>';
}
$nav = $print->Pagination($totalPage,$pageNum,'pages','?act=manga&code=history&type='.$type);
?>