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