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/truyentranh/include/functions/ |
<?php
function top_member($limit=5){
global $DB,$memcache;
$key_cache_top_member = md5("SELECT * FROM tb_guest ORDER BY guest_hitchap DESC,guest_point DESC LIMIT 1,$limit ");
$list = '';
if($memcache->get($key_cache_top_member)){
$list = $memcache->get($key_cache_top_member);
}else {
$q_guest = $DB->query("SELECT * FROM tb_guest ORDER BY guest_hitchap DESC,guest_point DESC LIMIT 0,$limit ");
$i = 1;
while ($r_guest = $DB->fetch_row($q_guest)) {
$point_next_level_have = $r_guest['guest_point'] - $r_guest['guest_level'];
$point_next_level_need = $r_guest['guest_next_level'] - $r_guest['guest_level'];
$r_guest['percent'] = 0;
if ($point_next_level_need > 0) {
$r_guest['percent'] = round(($point_next_level_have / $point_next_level_need) * 100, 0);
}
$txt_vip_icon ='';
if($r_guest['is_vip']=='active'){
$txt_vip_icon = '<span class="text-warning"><i class="fas fa-crown"></i></span>';
}
$list .= '<li class="clearfix">
<span class="txt-rank fn-order pos' . $i . '">' . $i . '</span>
<div class="t-item-avatar">
<img class="thumb avatar lazy" src="' . $r_guest['guest_avatar'] . '" alt="">
<h3 class="title-member">' . $r_guest['guest_fullname'] . ' '.$txt_vip_icon.'</h3>
<span class="member" title="' . $point_next_level_have . '">
<span class="progress-bar" style="width:' . $r_guest['percent'] . '%"></span>
<span class="member-level-text">' . $r_guest['guest_level_name'] . '</span>
</span>
</div>
</li>';
$i++;
}
$memcache->set($key_cache_top_member,$list,MEMCACHE_COMPRESSED,2400);
}
return $list;
}
function refresh_local_token(){
global $DB,$ob_user,$ip;
$user_id = intval($ob_user->user_id);
$row_check_user = $DB->fetch_row($DB->query("SELECT user_id,user_key,user_status,user_type,user_comment_status FROM tb_user WHERE user_id='$user_id'"));
$row_check = $DB->fetch_row($DB->query("SELECT * FROM tb_guest WHERE user_id = '".$user_id."' "));
$token = array_merge($row_check, $row_check_user);
if ($row_check['guest_avatar'] != '' and $row_check['guest_avatar'] != 'NULL') {
$token['user_image'] = $row_check['guest_avatar'];
} else {
$token['user_image'] = 'layout/adminlte320rc/dist/img/letter/' . strtolower(substr($row_check['guest_email'], 0, 1)) . '.png';
}
$token['user_name'] = $row_check['guest_email'];
$token['fullname'] = $row_check['guest_fullname'];
$token['user_last_login'] = date('d/m/Y h:i A');
$token['user_type'] = $row_check_user['user_type'];
$token['from_ip'] = $ip;
$_SESSION['local_token'] = JWT::encode($token,'NHG#789-2017');
setcookie('cookie_local_token_new', $_SESSION['local_token'], time()+31536000, "/");
return $token;
}
function left_menu(){
global $ob_user,$CORE,$arr_vip;
$code_check = $CORE->input['code'] ?? 'profile';
$arr_active = array('account'=>'','profile'=>'','follow'=>'','comment'=>'','history'=>'','changepass'=>'');
$arr_active[$code_check] = 'active';
$txt_vip = '';
if($arr_vip['is_vip']=='active'){
$txt_vip = '<p class="text-muted text-center"><img src="/layout/default/images/vip-user.png" style="width: 23px;"> <span class="clock_cd">h:i:s</span></p>';
}
$html = '<div class="card card-info card-outline">
<form action="/profile/" method="post" enctype="multipart/form-data" id="upload_avatar">
<div class="card-body box-profile">
<div class="text-center">
<input type="file" id="imgupload" name="image_field" style="display:none"/>
<span class="button_edit_image"><i class="fas fa-user-edit"></i> Change avatar</span>
<img class="profile-user-img button_edit_image img-fluid img-circle" src="'.$ob_user->guest_avatar.'" alt="'.$ob_user->guest_fullname.'" id="OpenImgUpload">
</div>
<h3 class="profile-username text-center">'.$ob_user->guest_fullname.' <span class="text-warning"><i class="fas fa-crown"></i></span></h3>
<p class="text-muted text-center">'.$ob_user->guest_level_name.'</p>
'.$txt_vip.'
<ul class="list-group list-group-unbordered mb-3">
<li class="list-group-item">
<a href="/user/account/" class="text-info '.$arr_active['account'].'"><i class="fas fa-user-circle"></i> Account</a>
</li>
<li class="list-group-item">
<a href="/profile/" class="text-info '.$arr_active['profile'].'"><i class="fas fa-user"></i> Profile</a>
</li>
<li class="list-group-item">
<a href="/user/follow/" class="text-info '.$arr_active['follow'].'"><i class="far fa-heart"></i> Follow</a>
</li>
<li class="list-group-item">
<a href="/user/comment/" class="text-info '.$arr_active['comment'].'"><i class="far fa-comments"></i> Comment</a>
</li>
<li class="list-group-item">
<a href="/user/history/" class="text-info '.$arr_active['history'].'"><i class="fas fa-book-medical"></i> History</a>
</li>
<li class="list-group-item">
<a href="/user/changepass/" class="text-info '.$arr_active['changepass'].'"><i class="fas fa-unlock-alt"></i> Change password</a>
</li>
<li class="list-group-item">
<a href="/logout.html" class="text-info"><i class="fas fa-sign-out-alt"></i> Sign out</a>
</li>
</ul>
</div>
<input type="submit" class="submit_avatar" style="display:none;" name="submitbt">
</form>
</div>';
return $html;
}
function get_level_guest($user_id){
global $DB;
$r_user = $DB->fetch_row($DB->query("SELECT guest_point,guest_level,guest_next_level,guest_level_name,guest_next_level_name FROM tb_guest WHERE user_id='".$user_id."' "));
if($r_user){
$point_next_level_have = $r_user['guest_point']-$r_user['guest_level'];
$point_next_level_need = $r_user['guest_next_level']-$r_user['guest_level'];
$r_user['percent'] = 0;
if($point_next_level_need>0){
$r_user['percent'] = round(($point_next_level_have/$point_next_level_need)*100,0);
}
return $r_user;
}
return array();
}
function update_vip_his($user_id){
global $DB;
$row_check = $DB->fetch_row($DB->query("SELECT * FROM tb_guest_vip_his WHERE user_id='$user_id' AND time_end>='".date('Y-m-d')."' AND time_begin<='".date('Y-m-d')."' ORDER BY time_begin DESC LIMIT 1"));
if(!$row_check){
$DB->query("UPDATE tb_guest SET is_vip='no',vip_date=NULL WHERE user_id='$user_id'");
$DB->query("UPDATE tb_comment SET is_vip='no',vip_date=NULL WHERE user_id_post='$user_id'");
}else {
$vip_status = $row_check['vip_status'];
$DB->query("UPDATE tb_guest SET is_vip='$vip_status',vip_date='" . $row_check['time_end'] . "' WHERE user_id='$user_id' ");
$DB->query("UPDATE tb_comment SET is_vip='$vip_status',vip_date='" . $row_check['time_end'] . "' WHERE user_id_post='$user_id' ");
}
}
function check_vip($user_id){
global $DB;
$arr = array('is_vip'=>'','date_ex'=>'','logo_vip'=>'');
if($user_id>0){
$row_user = $DB->fetch_row($DB->query("SELECT vip_date FROM tb_guest WHERE is_vip='active' AND user_id='$user_id' "));
if($row_user){
$arr['is_vip']='active';
//$ex = strtotime($row_user['vip_date'])-time();
$date_ex = date('Y/m/d',strtotime($row_user['vip_date']));
$arr['date_ex']=$date_ex;
$arr['logo_vip']='logo_vip';
}
}
return $arr;
}
?>