email; $email = Radius::GetUserName($email); $tempuserbox[$email] = $user->id; } /*$tempnodebox=array(); $nodes = Node::all(); foreach($nodes as $node){ if(strpos($node->name,"Shadowsocks")!=FALSE) { $ip=gethostbyname($node->server); $tempnodebox[$ip]=$node->id; } }*/ $logs = RadiusRadPostauth::where('authdate', '<', date('Y-m-d H:i:s'))->where('authdate', '>', date('Y-m-d H:i:s', time() - 60))->get(); foreach ($logs as $log) { if (isset($tempuserbox[$log->username])) { $traffic = new TrafficLog(); $traffic->user_id = $tempuserbox[$log->username]; $traffic->u = 0; $traffic->d = 10000; $traffic->node_id = 1; $traffic->rate = 1; $traffic->traffic = Tools::flowAutoShow(10000); $traffic->log_time = time(); $traffic->save(); $user = User::find($tempuserbox[$log->username]); $user->t = time(); $user->u += 0; $user->d += 10000; $user->save(); } } /*$stmt = $db->query("SELECT * FROM `radacct` WHERE `acctstoptime`<'".date("Y-m-d H:i:s")."' AND `acctstoptime`>'".date("Y-m-d H:i:s",time()-60)."'"); $result = $stmt->fetchAll(); foreach($result as $row) { $traffic = new TrafficLog(); $traffic->user_id = $tempuserbox[$row["username"]]; $traffic->u = $row["acctinputoctets"]; $traffic->d = $row["acctoutputoctets"]; $traffic->node_id = 150; $traffic->rate = 1; $traffic->traffic = Tools::flowAutoShow(($row["acctinputoctets"]+$row["acctoutputoctets"])/1024/1024); $traffic->log_time = time(); $traffic->save(); $user->t = time(); $user->u = $user->u + $row["acctinputoctets"]; $user->d = $user->d + $row["acctoutputoctets"]; $user->save(); } */ } public static function syncvpn() { if (Config::get('radius_db_host') == '') { return; } $tempuserbox = array(); $users = User::all(); foreach ($users as $user) { $email = $user->email; $email = Radius::GetUserName($email); $tempuserbox[$email] = $user->id; } /*$tempnodebox=array(); $nodes = Node::all(); foreach($nodes as $node){ if(strpos($node->name,"Shadowsocks")!=FALSE) { $ip=gethostbyname($node->server); $tempnodebox[$ip]=$node->id; } }*/ /*$stmt = $db->query("SELECT * FROM `radpostauth` WHERE `authdate`<'".date("Y-m-d H:i:s")."' AND`authdate`>'".date("Y-m-d H:i:s",time()-60)."'"); $result = $stmt->fetchAll(); foreach($result as $row) { //if($row["pass"]!="") { $traffic = new TrafficLog(); $traffic->user_id = $tempuserbox[$row["username"]]; $traffic->u = 0; $traffic->d = 10000; $traffic->node_id = 149; $traffic->rate = 1; $traffic->traffic = Tools::flowAutoShow(10000); $traffic->log_time = time(); $traffic->save(); $user->t = time(); $user->u = $user->u + 0; $user->d = $user->d + 10000; $user->save(); } } */ $logs = RadiusRadAcct::where('acctstoptime', '<', date('Y-m-d H:i:s'))->where('acctstoptime', '>', date('Y-m-d H:i:s', time() - 60))->get(); foreach ($logs as $log) { $traffic = new TrafficLog(); $traffic->user_id = $tempuserbox[$log->username]; $traffic->u = $log->acctinputoctets; $traffic->d = $log->acctoutputoctets; $traffic->node_id = 2; $traffic->rate = 1; $traffic->traffic = Tools::flowAutoShow($log->acctinputoctets + $log->acctoutputoctets); $traffic->log_time = time(); $traffic->save(); $user = User::find($tempuserbox[$log->username]); $user->t = time(); $user->u += $log->acctinputoctets; $user->d += $log->acctoutputoctets; $user->save(); } } public static function syncusers() { $users = User::all(); foreach ($users as $user) { Radius::Add($user, $user->passwd); echo 'Send sync mail to user: ' . $user->id; $subject = Config::get('appName') . '-密码更新通知'; $to = $user->email; $text = '您好,为了保证密码系统的统一,刚刚系统已经将您 vpn 等连接方式的用户名已经重置为:' . Radius::GetUserName($user->email) . ',密码自动重置为您 ss 的密码:' . $user->passwd . ' 了,以后您修改 ss 密码就会自动修改 vpn 等连接方式的密码了,感谢您的支持。 '; try { Mail::send($to, $subject, 'password/vpn.tpl', [ 'user' => $user, 'text' => $text ], [ ]); } catch (Exception $e) { echo $e->getMessage(); } } } public static function syncnas() { if (Config::get('radius_db_host') != '') { $md5txt = ''; $nases = RadiusNas::all(); foreach ($nases as $nas) { //if($row["pass"]!="") { $md5txt = $md5txt . $nas->id . $nas->nasname . $nas->shortname . $nas->secret . $nas->description; } } $md5 = MD5($md5txt); $oldmd5 = file_get_contents(BASE_PATH . '/storage/nas.md5'); if ($oldmd5 != $md5) { //Restart radius $myfile = fopen(BASE_PATH . '/storage/nas.md5', 'wb+') or die('Unable to open file!'); echo('Restarting...'); system('/bin/bash /sbin/service radiusd restart', $retval); echo($retval); $txt = $md5; fwrite($myfile, $txt); fclose($myfile); } } $Nodes = Node::where('sort', 0)->where('node_ip', '<>', '')->where('node_ip', '<>', 'NULL')->get(); foreach ($Nodes as $Node) { if (file_exists('/usr/local/psionic/portsentry/portsentry.ignore')) { $content = file_get_contents('/usr/local/psionic/portsentry/portsentry.ignore'); if (strpos($content, $Node->node_ip) === false) { file_put_contents('/usr/local/psionic/portsentry/portsentry.ignore', "\n" . $Node->node_ip . '/32', FILE_APPEND); } } } } }