Example #1
0
 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);
 }
Example #2
0
 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);
     }
 }