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);
}
