public function saveUserlogin($c, $p) { if (empty($p['u_id'])) { $mdpass = md5($p['u_password']); $c->log($mdpass); $sql = array("u_id" => "{$p['u_id']}", "u_username" => "{$p['u_username']}", "u_password" => "{$mdpass}", "u_room" => "{$p['u_room']}", "u_tel" => "{$p['u_tel']}", "u_group" => "{$p['u_group']}", "limit_mac" => "{$p['limit_mac']}", "permission_id" => "{$p['permission_id']}"); g::db()->aInsert($sql, "user"); } else { $counter = g::db()->getRows("SELECT count(*) as 'result' FROM `authenuser` WHERE `u_id` = ?", array($p['u_id'])); $total_del = $counter[0][result] - $p['limit_mac']; if ($total_del >= 0) { $result_del = g::db()->getRows("SELECT * FROM `authenuser` WHERE `u_id` = ? ORDER by `a_id` ASC LIMIT {$total_del} ", array($p['u_id'])); $c->log($result_del); foreach ($result_del as $r) { $c->log($r["authen_user"]); $data = Router::comm('/ip/hotspot/user/remove', array(".id" => "{$r['authen_user']}")); } $result = g::db()->exec("DELETE FROM `authenuser` WHERE `u_id` = ? ORDER by `a_id` ASC LIMIT {$total_del}", array($p['u_id'])); $c->log($result); } $mdpass = md5($p['u_password']); $c->log($mdpass); $data = g::db()->aUpdate(array("u_username" => "{$p['u_username']}", "u_password" => "{$mdpass}", "u_room" => "{$p['u_room']}", "u_tel" => "{$p['u_tel']}", "u_group" => "{$p['u_group']}", "limit_mac" => "{$p['limit_mac']}", "permission_id" => "{$p['permission_id']}"), 'user', 'u_id', $p["u_id"]); } $c->data(array("rows" => $data))->send(true); }
public function removeProfile($c, $p) { $c->log($p['id']); $data = Router::comm('/ip/hotspot/user/profile/remove', array(".id" => "*" . $p['id'])); if (empty($data)) { $c->send(true); } $c->send(false); }
public function listmac($c, $p) { //$data = Router::exec("/ip/dhcp-server/lease/print"); $data = Router::comm("/ip/dhcp-server/lease/print", array("?active-address" => $_SERVER['REMOTE_ADDR'])); $c->data($data)->send(true); }
public function saveProfile($c, $p) { $data = Router::comm('/ip/hotspot/user/profile/add', array("name" => "{$p['name']}", "add-mac-cookie" => "true", "mac-cookie-timeout" => "1d", "open-status-page" => "http-login", "rate-limit" => "{$p['rate_limit']}", "transparent-proxy" => "true")); $c->data($data)->send(true); }