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/ajax/ |
<?php
if(isset($ob_user->user_id) and intval($ob_user->user_id)>0){
$q_follow = $DB->query("SELECT truyen_id FROM tb_follow WHERE 1 AND (user_id='" . intval($ob_user->user_id) . "' OR follow_ip='$ip') ");
$arr_chuong_id = array();
while($r_follow = $DB->fetch_row($q_follow)){
$arr_truyen_id[] = $r_follow['truyen_id'];
}
if(!empty($arr_truyen_id)){
$q_chuong = $DB->query("SELECT truyen_id,max(chuong_id) as max_chuong_id,max(chuong_pos) as max_chuong_pos FROM tb_chuong WHERE truyen_id IN (".implode(',',$arr_truyen_id).") GROUP BY truyen_id;");
while($r_chuong = $DB->fetch_row($q_chuong)){
$truyen_id = $r_chuong['truyen_id'];
$chuong_id = $r_chuong['max_chuong_id'];
$chuong_pos = $r_chuong['max_chuong_pos'];
$DB->query("UPDATE tb_follow SET chuong_id='$chuong_id',chuong_pos='$chuong_pos' WHERE truyen_id='$truyen_id' AND (user_id='" . intval($ob_user->user_id) . "' OR follow_ip='$ip') ");
}
}
$DB->query("UPDATE tb_follow SET already_read='yes' WHERE 1 AND (user_id='" . intval($ob_user->user_id) . "' OR follow_ip='$ip') ");
}else{
$DB->query("UPDATE tb_follow SET already_read='yes' WHERE 1 AND follow_ip='$ip' ");
}
echo 'ok';
?>