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/guest/ |
<?php
if(!isset($ob_user->user_id) or intval($ob_user->user_id)==0){
header('Location: /login.html');
}
$CORE->title_page = 'Account information';
$user_id = intval($ob_user->user_id);
$where = " a.user_id='".$user_id."' ";
$q_follow = $DB->query("
SELECT DISTINCT a.follow_id,a.truyen_id, a.already_read, a.chuong_id as chuong_follow_id, b.truyen_id, b.truyen_fname, b.truyen_name, b.truyen_thumb, c.chuong_id, c.chuong_fname, c.chuong_name,c.time_post
FROM tb_follow a LEFT JOIN tb_truyen b ON a.truyen_id=b.truyen_id
LEFT JOIN tb_chuong c ON a.chuong_id=c.chuong_id
WHERE ".$where."
ORDER BY a.date_post DESC LIMIT 0,4
");
$list_follow = '';
while($row = $DB->fetch_row($q_follow)){
if($row['chuong_follow_id']>0){
$chuong_id = $row['chuong_follow_id'];
}else{
$chuong_id = $row['chuong_id'];
}
$txt_new = date('F j, Y',strtotime($row['time_post']));
$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_follow .= '<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['chuong_id'].'" data-id="'.$row['chuong_id'].'" data-subid="'.$row['follow_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['chuong_fname'].'-'.$row['chuong_id'].'/" class="text-secondary list-2-chap" title="'.$row['chuong_name'].'">'.$row['chuong_name'].'</a> <span class="blockquote-footer"><cite title="Source Title">'.$txt_new.'</cite></span></li>
</ul>
</div>
</div>';
}
$where = " AND user_id_post='$user_id' AND parent_id=0 ";
$order_by = 'time_post DESC,like_num DESC';
$q_comment = $DB->query("SELECT * FROM tb_comment WHERE 1 ".$where." ORDER BY $order_by LIMIT 0,5");
$list = '';
$flag = '';
while($r_comment = $DB->fetch_row($q_comment)) {
$comment_id = $r_comment['comment_id'];
$date_comment = date('d/m/Y h:i:s A', $r_comment['time_post']);
$date_comment2 = date('Y-m-d H:i:s', ($r_comment['time_post'] - (12 * 60 * 60)));
$time_comment = $func->time_ago($r_comment['time_post']);
$time_flag = date('F j, Y',$r_comment['time_post']);
if($flag!=$time_flag){
$list .= '<div class="time-label">
<span class="bg-danger">
'.$time_flag.'
</span>
</div>';
$flag=$time_flag;
}
$list .= '<div id="comment_'.$comment_id.'">
<i class="fa-regular fa-comment-dots bg-info text-white"></i>
<div class="timeline-item">
<span class="time"><i class="far fa-clock"></i> '.$time_comment.'</span>
<h3 class="timeline-header"><a href="/'.$r_comment['truyen_fname'].'-'.$r_comment['truyen_id'].'/" class="manga">'.$r_comment['truyen_name'].'</a> <a href="/'.$r_comment['truyen_fname'].'-'.$r_comment['truyen_id'].'/'.$r_comment['chuong_fname'].'-'.$r_comment['chuong_id'].'/" class="chapter">'.$r_comment['chuong_name'].'</a></h3>
<div class="timeline-body">
'.html_entity_decode($r_comment['comment_content']).'
</div>
<div class="timeline-footer">
<a href="/'.$r_comment['truyen_fname'].'-'.$r_comment['truyen_id'].'/#tab_comment_id" class="btn btn-warning btn-flat btn-sm">View comment</a>
<a href="javascript:void(0);" class="btn btn-danger btn-sm" onclick="deleteComment('.$comment_id.')">Delete</a>
</div>
</div>
</div>';
$q_sub = $DB->query("select * from (select * from tb_comment order by parent_id, comment_id) products_sorted, (select @pv := '".$comment_id."') initialisation where find_in_set(parent_id, @pv) and length(@pv := concat(@pv, ',', comment_id));");
$list_sub = '';
while($r_sub = $DB->fetch_row($q_sub)) {
$comment_sub_id = $r_sub['comment_id'];
$date_comment = date('d/m/Y h:i:s A', $r_sub['time_post']);
$date_comment2 = date('Y-m-d H:i:s', $r_sub['time_post']);
$time_comment = $func->time_ago($r_sub['time_post']);
$list_sub .= '<div id="comment_'.$comment_sub_id.'">
<i class="fa-regular fa-comments bg-warning text-white"></i>
<div class="timeline-item">
<span class="time"><i class="far fa-clock"></i> '.$time_comment.'</span>
<h3 class="timeline-header"><a href="/'.$r_sub['truyen_fname'].'-'.$r_sub['truyen_id'].'/">'.$r_sub['truyen_name'].'</a> '.$r_sub['chuong_name'].' commented on '.$r_sub['user_id_post_name'].'</h3>
<div class="timeline-body">
'.html_entity_decode($r_sub['comment_content']).'
</div>
<div class="timeline-footer">
<a href="/'.$r_sub['truyen_fname'].'-'.$r_sub['truyen_id'].'/#tab_comment_id" class="btn btn-warning btn-flat btn-sm">View comment</a>
<a href="javascript:void(0);" class="btn btn-danger btn-sm" onclick="deleteComment('.$comment_sub_id.')">Delete</a>
</div>
</div>
</div>';
}
if(!empty($list_sub)){
$list .= $list_sub;
}
}
?>