我曾经想过那样,但是通过比较得知,mysql 的 rand 非常耗资源,不适宜做随机~~
所以我将用户分单双ID进行长草~~我的刷新时间:1小时2次,第一次 偶数ID,第二次奇数ID,红色删除就行了,click_time是农场点击时间或者说是今天日期,意思就是只除了5点和 22点之外,只更新今天登陆用户地里的草、牧场大便、蚊子,加快SQL语句查询更新速度~~
$hours_ = date("G",time());
$minutes_ = date("i",time());
if($minutes_ < 30 ){ //配合每小时 8分与38分两次刷新
$date_no = " where uid/2 = round(uid/2)";
}else{
$date_no = " where uid/2 <> round(uid/2)";
}
if($hours_ !=5 && $hours_ !=22){
$date_no .= " and click_time=".intval(date('Ymd'));
}
$query = $_SGLOBAL['db']->query("SELECT uid,farmlandstatus,animal,dabian,wenzi FROM ".tname('plug_newfarm')."{$date_no} order by uid asc");
while ($value = $_SGLOBAL['db']->fetch_array($query)) {
$list[] = $value;
} |