/**
* Get normalized group from a string like:
* group:access_level; group:access_level; ...
* and return normalized string.
*
* @param string $groups
* @author Alberto Basso <*****@*****.**>
*/
function sumo_get_normalized_group($groups = '', $group_only = FALSE)
{
// strip blank, newline, tab, comma
$groups = strtolower(preg_replace('/[\\s\\n\\t\\r\\,]+/', ';', $groups));
$groups = array_unique(explode(';', $groups));
asort($groups);
reset($groups);
$num_groups = count($groups);
$old_group = array();
for ($g = 0; $g < $num_groups; $g++) {
$gv[$g] = explode(":", $groups[$g]);
if ($group_only) {
if ($gv[$g][0]) {
$group[$g] = $gv[$g][0];
}
} else {
if (!in_array($gv[$g][0], $old_group) && $gv[$g][0]) {
$group[$g] = $gv[$g][0] . ":" . $gv[$g][1];
}
$old_group[$g] = $gv[$g][0];
}
}
$groups = is_array($group) ? implode(';', $group) : $group;
if (preg_match("/sumo:7/i", $groups)) {
$groups = "sumo:7";
}
// Alfab. order
$groups = sumo_get_ordered_groups($groups);
return $groups;
}
/**
* Update accesspoint data
*/
function sumo_update_accesspoint_data($data = array())
{
if (!empty($data)) {
global $SUMO;
$id = intval($data['id']);
$node = $data['node'] ? intval($data['node']) : "NULL";
$path = $data['path'];
$group = $data['group'];
$reg_group = $data['reg_group'];
$theme = $data['theme'];
$http_auth = $data['http_auth'] == 'on' || $data['http_auth'] == 1 ? 1 : 0;
$filtering = $data['filtering'] == 'on' || $data['filtering'] == 1 ? 1 : 0;
$pwd_encrypt = $data['pwd_encrypt'] == 'on' || $data['pwd_encrypt'] == 1 ? 1 : 0;
$change_pwd = $data['change_pwd'] == 'on' || $data['change_pwd'] == 1 ? 1 : 0;
$registration = $data['registration'] == 'on' || $data['registration'] == 1 ? 1 : 0;
// AP names
$languages = sumo_get_available_languages();
$names = "";
for ($l = 0; $l < count($languages); $l++) {
$names[$l] = $languages[$l] . ":" . $data['name'][$languages[$l]];
}
$name = implode(";", $names);
$filtering = sumo_verify_is_console($path) ? 1 : $filtering;
/**
* Kill all sessions at path where pwd_encrypt
* or http_auth it has been changed
*/
$accesspoint = sumo_get_accesspoint_info($id, 'id', FALSE);
$nodeinfo = sumo_get_node_info($node);
if ($accesspoint['pwd_encrypt'] != $pwd_encrypt || $accesspoint['http_auth'] != $http_auth) {
$query = "DELETE FROM " . SUMO_TABLE_SESSIONS . " \r\n\t\t\t\t\t WHERE node='" . $nodeinfo['ip'] . "' AND url LIKE '%" . $path . "'";
$SUMO['DB']->Execute($query);
}
// Delete cached data
#if($path) $SUMO['DB']->CacheFlush("SELECT * FROM ".SUMO_TABLE_ACCESSPOINTS."
# WHERE path='".$path."'");
if ($node >= 1) {
$record['node'] = "node=" . $node;
}
if ($path) {
$record['path'] = "path='" . $path . "'";
}
if ($name) {
$record['name'] = "name='" . $name . "'";
}
if ($group) {
$record['group'] = "usergroup='" . sumo_get_ordered_groups($group) . "'";
}
if ($reg_group) {
$record['reg_group'] = "reg_group='" . $reg_group . "'";
}
if ($theme) {
$record['theme'] = "theme='" . $theme . "'";
}
$record['http_auth'] = "http_auth=" . $http_auth;
$record['filtering'] = "filtering=" . $filtering;
$record['pwd_encrypt'] = "pwd_encrypt=" . $pwd_encrypt;
$record['change_pwd'] = "change_pwd=" . $change_pwd;
$record['registration'] = "registration=" . $registration;
$record['updated'] = "updated=" . $SUMO['server']['time'];
// Create fields for query
$new_record = array_values($record);
for ($r = 0; $r < count($new_record); $r++) {
if ($new_record[$r]) {
$records[$r] = $new_record[$r];
}
}
$update = implode(', ', $records);
$select = implode(' AND ', $records);
// create query
$query = "UPDATE " . SUMO_TABLE_ACCESSPOINTS . " \r\n\t\t\t\t SET " . $update . " \r\n\t\t\t\t WHERE id=" . $id;
$SUMO['DB']->CacheFlush();
$SUMO['DB']->Execute($query);
// verify query success
$query = "SELECT COUNT(id) FROM " . SUMO_TABLE_ACCESSPOINTS . " \r\n\t\t\t\t WHERE id=" . $id . " \r\n\t\t\t\t AND " . $select;
$rs = $SUMO['DB']->Execute($query);
$tab = $rs->FetchRow();
// if updated:
if ($tab[0] == 1) {
if ($nodeinfo['ip'] == '') {
$nodeinfo['ip'] = 'UNDEFINED';
}
$apname = sumo_get_accesspoint_name($name, $SUMO['config']['server']['language']);
sumo_write_log('I07000X', array($id, $apname, $nodeinfo['ip'], $SUMO['user']['user']), 3, 3, 'system', FALSE);
return TRUE;
} else {
return FALSE;
}
}
}
