= 1 and !in_array($parent_id, $mac_exists['users_id'])) {
$dup_sql = "SELECT * FROM User_list WHERE id=" . $mac_exists['users_id']['0'];
$dup_info = get_record_sql($db_link, $dup_sql);
$msg_error = "Mac already exists at another user in this subnet! Skip creating $ip [$mac].
Old user id: " . $dup_info['id'] . " login: " . $dup_info['login'];
$_SESSION[$page_url]['msg'] = $msg_error;
LOG_ERROR($db_link, $msg_error);
header("Location: " . $_SERVER["REQUEST_URI"]);
exit;
}
//disable dhcp for secondary ip
$f_dhcp = $_POST["f_dhcp"] * 1;
if (!empty($mac_exists) and in_array($parent_id, $mac_exists['users_id'])) {
if ($parent_id != $mac_exists['users_id'][0]) {
$f_dhcp = 0;
}
}
//search ip
$dup_ip_record = get_record_sql($db_link, "SELECT * FROM User_auth WHERE `ip_int`=$ip_aton AND id<>$id AND deleted=0");
if (!empty($dup_ip_record)) {
$dup_info = get_record_sql($db_link, "SELECT * FROM User_list WHERE id=" . $dup_ip_record['user_id']);
$msg_error = "$ip already exists. Skip creating $ip [$mac].
Old user id: " . $dup_info['id'] . " login: " . $dup_info['login'];
$_SESSION[$page_url]['msg'] = $msg_error;
LOG_ERROR($db_link, $msg_error);
header("Location: " . $_SERVER["REQUEST_URI"]);
exit;
}
$new['ip'] = $ip;
$new['ou_id'] = $parent_ou_id;
$new['ip_int'] = $ip_aton;
$new['mac'] = mac_dotted($_POST["f_mac"]);
$new['comments'] = $_POST["f_comments"];
$new['WikiName'] = $_POST["f_wiki"];
$f_dnsname = trim($_POST["f_dns_name"]);
//update device managment ip
$device = get_record_sql($db_link,"SELECT * FROM devices WHERE ip_int=".$old_auth_info['ip_int']);
if (!empty($device)) {
$dev['ip'] = $ip;
$dev['ip_int']=$ip_aton;
update_record($db_link,"devices","id=".$device['id'],$dev);
}
$dns_alias_count = get_count_records($db_link,'User_auth_alias','auth_id='.$id);
if (!empty($f_dnsname)) {
$domain_zone = get_option($db_link, 33);
$f_dnsname = preg_replace('/'.$domain_zone.'/','',$f_dnsname);
$f_dnsname = preg_replace('/\.$/','',$f_dnsname);
$f_dnsname = preg_replace('/\s+/','-',$f_dnsname);
$f_dnsname = preg_replace('/\./','-',$f_dnsname);
//disable change dns name when exists aliases
if ($dns_alias_count >0 and $f_dnsname !== $old_auth_info['dns_name']) {
$f_dnsname = $old_auth_info['dns_name'];
} else {
if (checkValidHostname($f_dnsname) and checkUniqHostname($db_link,$id,$f_dnsname)) {
$new['dns_name'] = $f_dnsname;
} else {
$msg_error = "DNS $f_dnsname already exists at: ".searchHostname($db_link,$id,$f_dnsname)." Discard changes!";
$_SESSION[$page_url]['msg'] = $msg_error;
LOG_ERROR($db_link, $msg_error);
header("Location: " . $_SERVER["REQUEST_URI"]);
exit;
}
}
} else {
//remove all dns aliases
$new['dns_name'] = '';
$t_User_auth_alias = get_records($db_link,'User_auth_alias',"auth_id=$id ORDER BY alias");
if (!empty($t_User_auth_alias)) {
foreach ( $t_User_auth_alias as $row ) {
LOG_INFO($db_link, "Remove alias id: ".$row['id']." for auth_id: $id :: ".dump_record($db_link,'User_auth_alias','id='.$row['id']));
delete_record($db_link,'User_auth_alias','id='.$row['id']);
}
}
}
$new['save_traf'] = $_POST["f_save_traf"] * 1;
$new['dhcp_acl'] = trim($_POST["f_acl"]);
$new['dynamic'] = trim($_POST["f_dynamic"]);
if ($new['dynamic']) { $new['eof'] = trim($_POST["f_eof"]); }
if (get_const('default_user_ou_id') == $parent_ou_id or get_const('default_hotspot_ou_id') == $parent_ou_id) {
$new['nagios_handler'] = '';
$new['enabled'] = 0;
$new['link_check'] = 0;
$new['nagios'] = 0;
$new['blocked'] = 0;
$new['day_quota'] = 0;
$new['month_quota'] = 0;
$new['queue_id'] = 0;
$new['filter_group_id'] = 0;
} else {
$new['nagios_handler'] = $_POST["f_handler"];
$new['enabled'] = get_int($_POST["f_enabled"]);
$new['link_check'] = get_int($_POST["f_link"]);
$new['nagios'] = get_int($_POST["f_nagios"]);
$new['dhcp'] = $f_dhcp;
$new['blocked'] = get_int($_POST["f_blocked"]);
$new['day_quota'] = get_int($_POST["f_day_q"]);
$new['month_quota'] = get_int($_POST["f_month_q"]);
$new['queue_id'] = get_int($_POST["f_queue_id"]);
$new['filter_group_id'] = get_int($_POST["f_group_id"]);
}
if ($new['nagios'] == 0) {
$new['nagios_status'] = 'UP';
}
if (!$user_enabled) { $new['enabled']=0; }
$changes = get_diff_rec($db_link, "User_auth", "id='$id'", $new, 0);
if (!empty($changes)) {
LOG_WARNING($db_link, "Changed record for $ip! Log: " . $changes, $id);
}
if (is_auth_bind_changed($db_link, $id, $ip, $mac)) {
$new_id = copy_auth($db_link, $id, $new);
if (!empty($new_id)) {
header("Location: /admin/users/editauth.php?id=" . $new_id, TRUE, 302);
} else {
header("Location: " . $_SERVER["REQUEST_URI"]);
}
exit;
} else {
update_record($db_link, "User_auth", "id='$id'", $new);
}
} else {
$msg_error = "$msg_ip_error xxx.xxx.xxx.xxx";
$_SESSION[$page_url]['msg'] = $msg_error;
}
header("Location: " . $_SERVER["REQUEST_URI"]);
exit;
}
if (isset($_POST["moveauth"]) and !$old_auth_info['deleted']) {
$new_parent_id = $_POST["f_new_parent"] * 1;
$moved_auth = get_record_sql($db_link,"SELECT comments FROM User_auth WHERE id=".$id);
$changes = apply_auth_rule($db_link, $moved_auth, $new_parent_id);
update_record($db_link, "User_auth", "id='$id'", $changes);
LOG_WARNING($db_link, "IP-address moved to another user! Applyed: " . get_rec_str($changes), $id);
run_sql($db_link,"DELETE FROM auth_rules WHERE user_id=".$old_auth_info["user_id"]." AND rule='".$old_auth_info["mac"]."' AND type=2");
run_sql($db_link,"DELETE FROM auth_rules WHERE user_id=".$old_auth_info["user_id"]." AND rule='".$old_auth_info["ip"]."' AND type=1");
LOG_INFO($db_link,"Autorules removed for user_id: ".$old_auth_info["user_id"]." login: ".$user_info["login"]." by mac and ip");
header("Location: " . $_SERVER["REQUEST_URI"]);
exit;
}
if (isset($_POST["recovery"]) and $old_auth_info['deleted']) {
$ip = trim($_POST["f_ip"]);
if (checkValidIp($ip)) {
$ip_aton = ip2long($ip);
$mac = mac_dotted($_POST["f_mac"]);
//search mac
$mac_exists = find_mac_in_subnet($db_link, $ip, $mac);
if (isset($mac_exists) and $mac_exists['count'] >= 1 and !in_array($parent_id, $mac_exists['users_id'])) {
$dup_sql = "SELECT * FROM User_list WHERE id=" . $mac_exists['users_id']['0'];
$dup_info = get_record_sql($db_link, $dup_sql);
$msg_error = "Mac already exists at another user in this subnet! Skip creating $ip [$mac].
Old user id: " . $dup_info['id'] . " login: " . $dup_info['login'];
$_SESSION[$page_url]['msg'] = $msg_error;
LOG_ERROR($db_link, $msg_error);
header("Location: " . $_SERVER["REQUEST_URI"]);
exit;
}
//disable dhcp for secondary ip
$f_dhcp = $_POST["f_dhcp"] * 1;
if (in_array($parent_id, $mac_exists['users_id'])) {
if ($parent_id != $mac_exists['users_id'][0]) {
$f_dhcp = 0;
}
}
//search ip
$dup_ip_record = get_record_sql($db_link, "SELECT * FROM User_auth WHERE `ip_int`=$ip_aton AND id<>$id AND deleted=0");
if (!empty($dup_ip_record)) {
$dup_info = get_record_sql($db_link, "SELECT * FROM User_list WHERE id=" . $dup_ip_record['user_id']);
$msg_error = "$ip already exists. Skip creating $ip [$mac].
Old user id: " . $dup_info['id'] . " login: " . $dup_info['login'];
$_SESSION[$page_url]['msg'] = $msg_error;
LOG_ERROR($db_link, $msg_error);
header("Location: " . $_SERVER["REQUEST_URI"]);
exit;
}
$new['deleted'] = 0;
$new['dynamic'] = 0;
$f_dnsname = trim($_POST["f_dns_name"]);
if (!empty($f_dnsname)) {
$domain_zone = get_option($db_link, 33);
$f_dnsname = preg_replace('/'.$domain_zone.'/','',$f_dnsname);
$f_dnsname = preg_replace('/\.$/','',$f_dnsname);
$f_dnsname = preg_replace('/\s+/','-',$f_dnsname);
$f_dnsname = preg_replace('/\./','-',$f_dnsname);
}
if (!empty($f_dnsname) and checkValidHostname($f_dnsname) and checkUniqHostname($db_link,$id,$f_dnsname)) {
run_sql($db_link,"UPDATE User_auth SET dns_name='' WHERE id=".$id);
$new['dns_name'] = $f_dnsname;
} else { $new['dns_name']=''; }
$parent_id = $old_auth_info['user_id'];
$old_parent = get_record_sql($db_link, "SELECT * FROM User_list WHERE id=".$parent_id);
if (empty($old_parent)) {
$new_user_info = get_new_user_id($db_link, $ip, $mac, NULL);
if ($new_user_info['user_id']) { $new_user_id = $new_user_info['user_id']; }
if (empty($new_user_id)) { $new_user_id = new_user($db_link, $new_user_info); }
$new['user_id'] = $new_user_id;
}
//save comments
$new['comments']=$old_parent['comments'];
if (get_const('default_user_ou_id') == $parent_ou_id or get_const('default_hotspot_ou_id') == $parent_ou_id) {
$new['nagios_handler'] = '';
$new['enabled'] = 0;
$new['link_check'] = 0;
$new['nagios'] = 0;
$new['blocked'] = 0;
$new['day_quota'] = 0;
$new['month_quota'] = 0;
$new['queue_id'] = 0;
$new['filter_group_id'] = 0;
} else {
$new['nagios_handler'] = $_POST["f_handler"];
$new['enabled'] = get_int($_POST["f_enabled"]);
$new['link_check'] = get_int($_POST["f_link"]);
$new['nagios'] = get_int($_POST["f_nagios"]);
$new['dhcp'] = get_int($_POST["f_dhcp"]);
$new['blocked'] = get_int($_POST["f_blocked"]);
$new['day_quota'] = get_int($_POST["f_day_q"]);
$new['month_quota'] = get_int($_POST["f_month_q"]);
$new['queue_id'] = get_int($_POST["f_queue_id"]);
$new['filter_group_id'] = get_int($_POST["f_group_id"]);
}
$changes = get_diff_rec($db_link, "User_auth", "id='$id'", $new, 0);
if (!empty($changes)) {
LOG_WARNING($db_link, "Recovered ip-address. Applyed: $changes", $id);
}
$new = apply_auth_rule($db_link, $new, $new['user_id']);
update_record($db_link, "User_auth", "id='$id'", $new);
} else {
$msg_error = "$msg_ip_error xxx.xxx.xxx.xxx/xx";
$_SESSION[$page_url]['msg'] = $msg_error;
}
header("Location: " . $_SERVER["REQUEST_URI"]);
exit;
}
unset($_POST);
require_once($_SERVER['DOCUMENT_ROOT'] . "/inc/header.php");
$sSQL = "SELECT * FROM User_auth WHERE id=$id";
$auth_info = get_record_sql($db_link, $sSQL);
$device = get_record_sql($db_link, "SELECT * FROM devices WHERE user_id=" . $auth_info['user_id']);
$parent_name = get_login($db_link, $auth_info['user_id']);
if ($auth_info['dhcp_time'] == '0000-00-00 00:00:00') {
$dhcp_str = '';
} else {
$dhcp_str = $auth_info['dhcp_time'] . " (" . $auth_info['dhcp_action'] . ")";
}
if ($auth_info['last_found'] == '0000-00-00 00:00:00') { $auth_info['last_found'] = ''; }
if ($auth_info['arp_found'] == '0000-00-00 00:00:00') { $auth_info['arp_found'] = ''; }
$now = DateTime::createFromFormat("Y-m-d H:i:s",date('Y-m-d H:i:s'));
$created = DateTime::createFromFormat("Y-m-d H:i:s",$auth_info['timestamp']);
if (empty($auth_info['eof']) or $auth_info['eof'] == '0000-00-00 00:00:00') {
$now->modify('+1 day');
$auth_info['eof'] = $now->format('Y-m-d H:i:s');
}
?>
' . $_SESSION[$page_url]['msg'] . '
';
unset($_SESSION[$page_url]['msg']);
}
print "" . WEB_user_title . " " . $parent_name . " ";
$alias_link = '';
if (!empty($auth_info['dns_name'])) { $alias_link="/admin/users/edit_alias.php?id=".$id; }
if (empty($auth_info['created_by'])) { $auth_info['created_by'] = '-'; }
?>