'; ?>
Create New Mapbender User
var myPW = '".$myPW."';"; ?> alert('Username must be unique!');"; } else{ $sql = "Insert INTO mb_user (mb_user_name, mb_user_password,mb_user_owner, "; $sql .= "mb_user_description, mb_user_email, mb_user_phone, mb_user_department, "; $sql .= "mb_user_resolution) VALUES "; $sql.= "($1, $2, $3, $4, $5, $6, $7, $8)"; $v = array($name,md5($password),$owner_id,$description,$email,$phone,$department,$resolution); $t = array('s','s','i','s','s','s','s','i'); $res = db_prep_query($sql,$v,$t); $selected_user = db_insert_id('platzhalter','mb_user','mb_user_id'); $sql_owner = "Update mb_user SET mb_user_owner = $1 "; $sql_owner.= " WHERE mb_user_name = $2 "; $v = array(1,$name); #$selected_user; $t = array('i','s'); $res_owner = db_prep_query($sql_owner,$v,$t); # removed, because a new user may be inserted in a group with too many privileges $sql_group = "Insert INTO mb_user_mb_group (fkey_mb_user_id, fkey_mb_group_id) VALUES "; $sql_group.= "($1, $2) "; $v = array($selected_user,20); $t = array('i','i'); $res_group = db_prep_query($sql_group,$v,$t); // CB (begin) // adding new GUIs for new user (copies of gui and gui1 with owner rights) $gui = new gui(); $admin = new administration(); //create new name for gui $gui_id1 = $admin->getGuiIdByGuiName("gui"); $gui_id2 = $admin->getGuiIdByGuiName("gui1"); $gui_id3 = $admin->getGuiIdByGuiName("gui2"); $gui_id4 = $admin->getGuiIdByGuiName("gui_digitize"); $gui_newName1 = $name . "_gui"; $gui_newName2 = $name . "_gui1"; $gui_newName3 = $name . "_gui2"; $gui_newName4 = $name . "_gui_digitize"; //check if new gui names are already taken while ($gui->guiExists($gui_newName1)) { $gui_newName1 .= "_1"; } while ($gui->guiExists($gui_newName2)) { $gui_newName2 .= "_1"; } while ($gui->guiExists($gui_newName3)) { $gui_newName3 .= "_1"; } while ($gui->guiExists($gui_newName4)) { $gui_newName4 .= "_1"; } //create gui_(name) and gui1_(name) $gui->copyGui($gui_id1[0], $gui_newName1,true); $gui->copyGui($gui_id2[0], $gui_newName2,true); $gui->copyGui($gui_id3[0], $gui_newName3,true); $gui->copyGui($gui_id4[0], $gui_newName4,true); $new_guiId1 = $admin->getGuiIdByGuiName($gui_newName1); $new_guiId2 = $admin->getGuiIdByGuiName($gui_newName2); $new_guiId3 = $admin->getGuiIdByGuiName($gui_newName3); $new_guiId4 = $admin->getGuiIdByGuiName($gui_newName4); //grant owner rights for new guis to this user only! $admin->delAllUsersOfGui($new_guiId1[0]); $admin->delAllUsersOfGui($new_guiId2[0]); $admin->delAllUsersOfGui($new_guiId3[0]); $admin->delAllUsersOfGui($new_guiId4[0]); $admin->insertUserAsGuiOwner($new_guiId1[0], $selected_user); $admin->insertUserAsGuiOwner($new_guiId2[0], $selected_user); $admin->insertUserAsGuiOwner($new_guiId3[0], $selected_user); $admin->insertUserAsGuiOwner($new_guiId4[0], $selected_user); // delete gui from groups // (gui and gui1 are associated with groups 20 and 21, new guis belong to mb_user only) $sql_del_from_group = "DELETE FROM gui_mb_group WHERE fkey_gui_id = $1 OR fkey_gui_id = $2 OR fkey_gui_id = $3 OR fkey_gui_id = $4"; $v = array($new_guiId1[0],$new_guiId2[0],$new_guiId3[0],$new_guiId4[0]); $t = array('s','s','s','s'); $res_del_from_group = db_prep_query($sql_del_from_group,$v,$t); } } if (!isset($name) || $selected_user == 'new'){ $name = ""; $password = ""; $description = ""; $email = ""; $phone = ""; $department = ""; } /* HTML */ echo "
"; echo "
"; if(isset($selected_user) && $selected_user != 0){ $sql = "SELECT * FROM mb_user WHERE mb_user_id = $1 ORDER BY mb_user_name "; $v = array($selected_user); $t = array('i'); $res = db_prep_query($sql,$v,$t); if(db_fetch_row($res)){ $name = db_result($res,0,"mb_user_name"); $password = db_result($res,0,"mb_user_password"); $owner_id = db_result($res,0,"mb_user_owner"); $description = db_result($res,0,"mb_user_description"); $login_count = db_result($res,0,"mb_user_login_count"); $email = db_result($res,0,"mb_user_email"); $phone = db_result($res,0,"mb_user_phone"); $department = db_result($res,0,"mb_user_department"); $resolution = db_result($res,0,"mb_user_resolution"); } $sql = "SELECT mb_user_name FROM mb_user WHERE mb_user_id = $1 "; $v = array($owner_id); $t = array('i'); $res = db_prep_query($sql,$v,$t); if(db_fetch_row($res)){ $owner_name = db_result($res,0,"mb_user_name"); } } #name echo "
"; echo "
Name*:
"; echo "
"; echo "
"; echo "
"; echo "
"; #password echo "
"; echo "
Password*:
"; echo "
"; echo "
"; echo "
"; echo "
"; #password echo "
"; echo "
Confirm password*:
"; echo "
"; echo "
"; echo "
"; echo "
"; #description echo "
"; echo "
Description:
"; echo "
"; echo "
"; echo "
"; echo "
"; #email echo "
"; echo "
Email
(Why?):
"; echo "
"; echo "
"; echo "
"; echo "
"; #phone echo "
"; echo "
Phone:
"; echo "
"; echo "
"; echo "
"; echo "
"; #department echo "
"; echo "
Department:
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; if($selected_user == 'new' || !isset($selected_user)){ echo "
"; } echo "
"; echo "
"; echo"
"; ?>