/* $Log: do_edit_category.html,v $ Revision 1.16 1996/08/21 17:53:50 kimberly rename index.html to index.html; break long lines; add comments Revision 1.15 1996/08/09 02:04:48 kimberly change version number Revision 1.14 1996/08/08 21:32:27 kimberly save db error in client Revision 1.13 1996/08/06 17:58:48 kimberly go back to edit screen with message after edit Revision 1.12 1996/08/06 17:01:55 kimberly add code to deal with saving a change when someone else has already used that name Revision 1.11 1996/08/05 21:42:35 kimberly add parameter when redirecting to initial.html because of an error to prevent loading frames again Revision 1.10 1996/08/02 23:17:46 kimberly if item is default or active for a user, show delete button. if deleted, remove from defaults and active lists. Revision 1.9 1996/08/02 22:08:56 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:47 kimberly changes for flattened directory s structure Revision 1.7 1996/08/01 19:01:40 kimberly add status line info after add, edit, or delete Revision 1.6 1996/08/01 18:03:38 kimberly add checks to deal with database errors Revision 1.5 1996/07/31 22:01:17 kimberly prevent blank screen from user typing in URL when on correct prevPage Revision 1.4 1996/07/25 16:26:53 kimberly remove absolute paths Revision 1.3 1996/07/23 18:54:58 kimberly Change hours_ims to tock_ims Revision 1.2 1996/07/23 18:53:00 kimberly Add Log tag */ if (request.prevPage) client.prevPage = request.prevPage; checkPrevPage("do_edit_category.html"); if (lookupAdminStatus(client.id) != "Y") redirect("initial.html?err=1"); if (request.submit_type == "U") { if (request.cat_name != request.orig_name) { query = database.cursor("select name from category where name='"+ escQuote(request.cat_name)+"'"); if (query.next()) { query.close(); redirect("edit_category.html?msg=name_in_use&Category="+ request.category_id+"&cat_"+request.category_id+"="+ escape(request.cat_name)); } query.close(); } database.execute("update category set name='"+request.cat_name+ "' where id="+request.category_id); if (database.majorErrorCode() != 0) { client.db_err = database.majorErrorMessage(); redirect("db_down.html"); } } if (request.submit_type == "D") { database.execute("delete from category where id="+request.category_id); if (database.majorErrorCode() != 0) { client.db_err = database.majorErrorMessage(); redirect("db_down.html"); } database.execute("update user set def_category=null where def_category="+ request.category_id); if (database.majorErrorCode() != 0) { client.db_err = database.majorErrorMessage(); redirect("db_down.html"); } } project.category_list = null; loadCategories(); if (request.submit_type == "U") redirect("edit_category.html?msg=updated&Category="+request.category_id+ "&cat_"+request.category_id+"="+escape(request.cat_name)); if (request.submit_type == "D") { client.status_msg = "Work type "+request.cat_name+" deleted."; redirect("admin.html"); }