function edit_group($name, $new_name, $desc) { include 'config.php'; $res = ""; $db = new IMDB(); $fields = array(); $fields["name"] = "'" . $db->escapeString($new_name) . "'"; $fields["description"] = "'" . $db->escapeString($desc) . "'"; $where = array("name" => "'" . $name . "'"); $res = $db->edit_item_from_table("grp", $fields, $where); $db->close(); return $res; }
function edit_credential($rowid, $id, $type, $host, $username, $password, $token_type, $project, $proxy, $public_key, $private_key, $certificate, $tenant) { include 'config.php'; $res = ""; $db = new IMDB(); $fields = array(); $fields["id"] = "'" . $db->escapeString($id) . "'"; $fields["type"] = "'" . $type . "'"; $fields["host"] = "'" . $db->escapeString($host) . "'"; $fields["username"] = "******" . $db->escapeString($username) . "'"; $fields["token_type"] = "'" . $db->escapeString($token_type) . "'"; $fields["project"] = "'" . $db->escapeString($project) . "'"; if (strlen(trim($password)) > 0) { $fields["password"] = "******" . $db->escapeString($password) . "'"; } if (strlen(trim($proxy)) > 0) { $fields["proxy"] = "'" . $db->escapeString($proxy) . "'"; } if (strlen(trim($public_key)) > 0) { $fields["public_key"] = "'" . $db->escapeString($public_key) . "'"; } if (strlen(trim($private_key)) > 0) { $fields["private_key"] = "'" . $db->escapeString($private_key) . "'"; } if (strlen(trim($certificate)) > 0) { $fields["certificate"] = "'" . $db->escapeString($certificate) . "'"; } if (strlen(trim($tenant)) > 0) { $fields["tenant"] = "'" . $db->escapeString($tenant) . "'"; } $where = array("rowid" => $rowid); $res = $db->edit_item_from_table("credentials", $fields, $where); $db->close(); return $res; }
function edit_radl($id, $name, $desc, $radl, $group, $group_r, $group_w, $group_x, $other_r, $other_w, $other_x) { include 'config.php'; $res = ""; $db = new IMDB(); $fields = array(); $fields["name"] = "'" . $db->escapeString($name) . "'"; $fields["description"] = "'" . $db->escapeString($desc) . "'"; $fields["radl"] = "'" . $db->escapeString($radl) . "'"; $fields["grpname"] = "'" . $db->escapeString($group) . "'"; $fields["group_r"] = $group_r; $fields["group_w"] = $group_w; $fields["group_x"] = $group_x; $fields["other_r"] = $other_r; $fields["other_w"] = $other_w; $fields["other_x"] = $other_x; $where = array("rowid" => "'" . $id . "'"); $res = $db->edit_item_from_table("radls", $fields, $where); $db->close(); return $res; }
function edit_user($username, $new_username, $password, $groups, $permissions) { include 'config.php'; $res = ""; $db = new IMDB(); $fields = array(); $fields["username"] = "******" . $db->escapeString($new_username) . "'"; $fields["permissions"] = strval($permissions); if (strlen(trim($password)) > 0) { $fields["password"] = "******" . $db->escapeString(crypt_password($password)) . "'"; } $where = array("username" => "'" . $username . "'"); $res = $db->edit_item_from_table("user", $fields, $where); if ($res != "") { $res = $db->lastErrorMsg() . $sql; } // borramos para volver a anyadirlos $grp_res = $db->delete_item_from_table("users_grp", array("username" => "'" . $username . "'")); if ($grp_res != "") { $res = "Error adding user groups: " . $grp_res; } $all_ok = true; $error_msg = ""; foreach ($groups as $group) { $fields = array(); $fields[] = "'" . $db->escapeString($group) . "'"; $fields[] = "'" . $db->escapeString($username) . "'"; $grp_res = $db->insert_item_into_table("users_grp", $fields); if ($grp_res != "") { $all_ok = false; $error_msg = $grp_res; } } if (!$all_ok) { $res = "Error adding user groups: " . $error_msg; } $db->close(); return $res; }