3600) { $query = DB::query("SELECT f.*, ff.redirect FROM ".DB::table('forum_forum')." f LEFT JOIN ".DB::table('forum_forumfield')." ff ON ff.fid=f.fid WHERE f.status='1' AND f.type='forum' ORDER BY f.todayposts DESC"); $data = array(); while($row = DB::fetch($query)) { if($row['redirect']) { continue; } list($row['lastpost_tid'], $row['lastpost_subject'], $row['lastpost'], $row['lastposter']) = explode("\t", $row['lastpost']); $row['lastpost'] = dgmdate($row['lastpost']); $data[] = mobile_core::getvalues($row, array('fid', 'name', 'threads', 'posts', 'lastpost', 'lastposter', 'lastpost_tid', 'lastpost_subject', 'todayposts')); } $variable = array( 'data' => $data, ); savecache('mobile_hotforum', array('variable' => $variable, 'expiration' => TIMESTAMP)); } else { $variable = $_G['cache']['mobile_hotforum']['variable']; } mobile_core::result(mobile_core::variable($variable)); } function output() { } } ?>