- //1周热门
- $hotspacelist = array();
- $query = $_SGLOBAL['db']->query("SELECT uid,username,name,namestatus FROM ".tname('space')."
- WHERE updatetime > ".($_SGLOBAL['timestamp']-3600*24*7)."
- ORDER BY viewnum DESC LIMIT 0,30");
- while ($value = $_SGLOBAL['db']->fetch_array($query)) {
- realname_set($value['uid'], $value['username'], $value['name'], $value['namestatus']);//实名
- $hotspacelist[] = $value;
- }
复制代码
去掉代码中的WHERE updatetime > ".($_SGLOBAL['timestamp']-3600*24*7)." |