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/admin/userpoint/ |
<?php
$fkeyword = $CORE->input['fkeyword'] ?? '';
$where = ' WHERE guestpoint_id>0 ';
if($fkeyword!=''){
$where .= " AND guestpoint_level LIKE '%".$fkeyword."%' " ;
}
$q_userpoint = $DB->query("SELECT * FROM tb_guestpoint ".$where." ORDER BY guestpoint_value DESC");
$txt_list = '';
while($r = $DB->fetch_row($q_userpoint)){
$txt_list .= '<tr id="tr_userpoint_'.$r['guestpoint_id'].'"><td>'.$r['guestpoint_level'].'</td><td>'.$r['guestpoint_value'].'</td><td>[<a href="javascript:void(0);" onclick="open_popup(\'?act=admin&code=userpoint&type=post&guestpoint_id='.$r['guestpoint_id'].'\',\'rule user point\')">Edit</a>] [<a href="javascript:void(0);" data-id="'.$r['guestpoint_id'].'" class="delete_userpoint">Delete</a>]</td></tr>';
}
?>