public function user() { $saveTime = Config::getConfig('save_account_time') + Config::getConfig('max_remember_time') * 2; $saveDay = $saveTime / 86400; $sql = "SELECT `u`.`uid`, `s`.`name` FROM `user` `u`\n LEFT JOIN `student` `s` ON `s`.`sid` = `u`.`uid`\n WHERE `u`.`rank` < ?\n AND DATE_SUB(CURDATE(), INTERVAL {$saveDay} DAY) >= DATE(`u`.`lastTime`)"; if (!($users = Mysql::execute($sql, array(Config::RANK_ADMIN)))) { return; } //删除微信及Token $names = array(); $cache = new Cache('auth'); foreach ($users as $user) { $names[] = $user['name']; Wechat::deleteUser($user['uid']); $tokens = $cache->smembers($user['uid']); foreach ($tokens as $token) { $cache->hdelete('token', $token); } $cache->delete($user['uid']); } //从数据库中删除 $sql = "DELETE FROM `user` WHERE `rank` < ?\n AND DATE_SUB(CURDATE(), INTERVAL {$saveDay} DAY) >= DATE(`lastTime`)"; Mysql::execute($sql, array(Config::RANK_ADMIN)); return '删除用户' . implode('、', $names); }
public function setting() { $type = \Hnust\input('type'); //更新参数 if ('update' === $type) { $method = \Hnust\input('method'); $value = \Hnust\input('value'); $sql = 'UPDATE `ini` SET `value` = ? WHERE `method` = ?'; Mysql::execute($sql, array($value, $method)); //更新缓存 $cache = new Cache(); $cache->delete('config'); $this->code = Config::RETURN_NORMAL; //获取参数列表 } else { $sql = 'SELECT * FROM `ini`'; $this->data = Mysql::execute($sql); } }