/*
$Log: do_add_group.html,v $
Revision 1.14 1996/08/21 17:53:48 kimberly
rename index.html to index.html; break long lines; add comments
Revision 1.13 1996/08/09 02:04:45 kimberly
change version number
Revision 1.12 1996/08/08 21:32:25 kimberly
save db error in client
Revision 1.11 1996/08/06 17:02:01 kimberly
add code to deal with saving a change when someone else has already used that name
Revision 1.10 1996/08/05 21:42:33 kimberly
add parameter when redirecting to initial.html because of an error to prevent loading frames again
Revision 1.9 1996/08/02 22:08:55 kimberly
changed name of name field to something else because JavaScript seems to have trouble with it
Revision 1.8 1996/08/02 02:19:44 kimberly
changes for flattened directory s structure
Revision 1.7 1996/08/01 19:01:38 kimberly
add status line info after add, edit, or delete
Revision 1.6 1996/08/01 18:03:34 kimberly
add checks to deal with database errors
Revision 1.5 1996/07/31 22:01:15 kimberly
prevent blank screen from user typing in URL when on correct prevPage
Revision 1.4 1996/07/25 16:26:51 kimberly
remove absolute paths
Revision 1.3 1996/07/23 18:54:56 kimberly
Change hours_ims to tock_ims
Revision 1.2 1996/07/23 18:52:57 kimberly
Add Log tag
*/
if (request.prevPage)
client.prevPage = request.prevPage;
checkPrevPage("do_add_group.html");
if (lookupAdminStatus(client.id) != "Y")
redirect("initial.html?err=1");
project.lock();
query = database.cursor("select name from group where name='"+
escQuote(request.group_name)+"'");
if (query.next()) {
query.close();
project.unlock();
redirect("add_group.html?msg=name_in_use");
}
query.close();
database.execute("insert into group (name) values ('"+
escQuote(request.group_name)+"')");
if (database.majorErrorCode() != 0) {
client.db_err = database.majorErrorMessage();
redirect("db_down.html");
}
cursor = database.cursor("select dbinfo(\"sqlca.sqlerrd1\") from systables"+
" where tabid=1");
cursor.next();
group_id = cursor[0];
cursor.close();
project.unlock();
var numSelections = getOptionValueCount("group_people");
for (var i = 0; i < numSelections; i++) {
database.execute("delete from group_people where user_id="+
getOptionValue("group_people",i));
if (database.majorErrorCode() != 0) {
client.db_err = database.majorErrorMessage();
redirect("db_down.html");
}
database.execute("insert into group_people (user_id,group_id) values ("+
getOptionValue("group_people",i)+","+group_id+")");
if (database.majorErrorCode() != 0) {
client.db_err = database.majorErrorMessage();
redirect("db_down.html");
}
}
project.group_list = null;
loadGroups();
client.status_msg = "Group "+request.group_name+" added.";
redirect("admin.html");