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 change_order($id, $user, $order, $new_order)
{
include 'config.php';
$res = "";
$db = new IMDB();
$fields = array("ord" => $order);
$where = array("ord" => $new_order, "imuser" => "'" . $user . "'");
$res = $db->edit_item_from_table("credentials", $fields, $where);
if (strlen($res) == 0) {
$fields = array("ord" => $new_order);
$where = array("rowid" => $id);
$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;
}
