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,$print,$memcache;
$CORE->title_page = 'Manga is following';
$type = $CORE->input['type'] ?? 'list';
$where = "";
$pageNum = isset($_GET['pageNum']) ? intval($_GET['pageNum']) : 1;
if(isset($ob_user->user_id) and intval($ob_user->user_id)>0) {
$where = " user_id='" . intval($ob_user->user_id) . "' ";
$pageSize = 36;
$from = (($pageNum * $pageSize) - $pageSize);
$t = $DB->fetch_row($DB->query("SELECT COUNT(*) as total
FROM tb_follow
WHERE " . $where));
$total = $t['total'];
$totalPage = ceil($total / $pageSize);
/*$q_follow = $DB->query("
SELECT follow_id,truyen_id, already_read, chuong_id as chuong_follow_id, truyen_id, truyen_fname, truyen_name, truyen_thumb,truyen_chuong_moinhat_time,truyen_chuong_moinhat_id,truyen_chuong_moinhat_name,truyen_chuong_moinhat_fname
FROM tb_follow
WHERE " . $where . "
ORDER BY chuong_id DESC LIMIT $from,$pageSize
");*/
$q_follow = $DB->query("
SELECT truyen_id,already_read
FROM tb_follow
WHERE " . $where . "
ORDER BY chuong_id DESC LIMIT $from,$pageSize
");
while($r_follow = $DB->fetch_row($q_follow)){
$arr_truyen_id[] = $r_follow['truyen_id'];
$arr_read[$r_follow['truyen_id']] = $r_follow['already_read'];
}
if(isset($arr_truyen_id)){
$txt_truyen_id = implode(',',$arr_truyen_id);
$query = $DB->query("SELECT * FROM tb_truyen WHERE truyen_id IN (".$txt_truyen_id.") ORDER BY time_update DESC");
$list = $list_unread = '';
while ($row = $DB->fetch_row($query)) {
$row['already_read'] = $arr_read[$row['truyen_id']];
$txt_new = $func->time_site($row['truyen_chuong_moinhat_time']);
if (!empty($row['truyen_chuong_moinhat_lock']) and strtotime($row['truyen_chuong_moinhat_lock']) > time()) {
$txt_new = '<span class="text-warning"><i class="fas fa-crown"></i></span>';
}
$read = '';
if ($row['already_read'] != 'yes') {
$read = '<a href="javascript:void(0);" class="mark-as-read" id="mark-as-read-' . $row['truyen_id'] . '" data-id="' . $row['truyen_id'] . '"><i class="fa fa-check"></i> Already read</a>';
$list_unread .= '<div class="col-lg-3 col-md-4 col-sm-4 col-6 video position-relative mb-2">
<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="unfollow follow-link" id="unfollow-follow-link-' . $row['truyen_chuong_moinhat_id'] . '" data-id="' . $row['truyen_chuong_moinhat_id'] . '" data-subid="' . $row['truyen_chuong_moinhat_id'] . '"><i class="fas fa-trash-alt"></i> Unfollow</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="Source Title">' . $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">
<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="unfollow follow-link" id="unfollow-follow-link-' . $row['truyen_chuong_moinhat_id'] . '" data-id="' . $row['truyen_chuong_moinhat_id'] . '" data-subid="' . $row['truyen_chuong_moinhat_id'] . '"><i class="fas fa-trash-alt"></i> Unfollow</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="Source Title">' . $txt_new . '</cite></span></li>
</ul>
</div>
</div>';
}
$nav = $print->Pagination($totalPage, $pageNum, 'pages', '?act=manga&code=follow&type=' . $type);
}
}else{
$list = $list_unread = $nav = '';
}
?>