$gui_id_array[$cnt_gui] = $row["gui_id"]; $gui_name[$cnt_gui] = $row["gui_name"]; $cnt_gui++; } /*get owner group **********************************************************************************************/ $sql_group = "SELECT * FROM mb_group WHERE mb_group_owner = \$1 ORDER BY mb_group_name"; $v = array($logged_user_id); $t = array('i'); $res_group = db_prep_query($sql_group, $v, $t); while ($row = db_fetch_array($res_group)) { $group_id[$cnt_group] = $row["mb_group_id"]; $group_name[$cnt_group] = $row["mb_group_name"]; $cnt_group++; } /*get all gui from selected_group******************************************************************************/ $arrayGuis = mb_getGUIs($logged_user_id); $sql_group_mb_gui = "SELECT gui.gui_id, gui.gui_name, gui_mb_group.fkey_mb_group_id FROM gui_mb_group "; $sql_group_mb_gui .= "INNER JOIN gui ON gui_mb_group.fkey_gui_id = gui.gui_id "; $sql_group_mb_gui .= "WHERE gui_mb_group.fkey_mb_group_id = \$1 "; $sql_group_mb_gui .= " ORDER BY gui.gui_name"; if (!$selected_group) { if ($group_id[0] > 0) { $v = array($group_id[0]); } else { $v = array("NULL"); } } if ($selected_group) { if ($selected_group >= 0) { $v = array($selected_group); } else {
# session_write_close(); # session_id(sha1(mt_rand())); # session_start(); # } include dirname(__FILE__) . "/../../conf/session.conf"; } else { redirectToLogin($name); } if (Mapbender::session()->get("mb_user_id")) { if ($row["mb_user_login_count"] <= MAXLOGIN) { $sql_del_cnt = "UPDATE mb_user SET mb_user_login_count = 0 WHERE mb_user_id = \$1"; $v = array(Mapbender::session()->get('mb_user_id')); $t = array("i"); db_prep_query($sql_del_cnt, $v, $t); require_once dirname(__FILE__) . "/../php/mb_getGUIs.php"; $arrayGUIs = mb_getGUIs($row["mb_user_id"]); new mb_notice("login.setSession.mb_user_guis: " . serialize($arrayGUIs) . " in session: " . session_id()); Mapbender::session()->set("mb_user_guis", $arrayGUIs); Mapbender::session()->set("mb_login", $login); # a gui is explicitly ordered if ((isset($_REQUEST["mb_user_myGui"]) || Mapbender::session()->get("mb_user_myGui")) && in_array($_REQUEST["mb_user_myGui"], $arrayGUIs)) { unset($arrayGUIs); if (isset($_REQUEST["mb_user_myGui"])) { $arrayGUIs[0] = $_REQUEST["mb_user_myGui"]; } else { $arrayGUIs[0] = Mapbender::session()->set("mb_user_myGui"); } } #only one gui is provided if (count($arrayGUIs) == 1) { if (isset($_SERVER["HTTPS"]) && $_SERVER["HTTPS"] == "on") {
echo "<script type='text/javascript'>"; echo "alert('Error: Gui already exists!');"; echo "</script>"; } else { $sql = "INSERT INTO gui (gui_id,gui_name,gui_description,gui_public) "; $sql .= "VALUES(\$1, \$2, \$3, \$4)"; $v = array($newGui, $newGui, $newDesc, 1); $t = array('s', 's', 's', 'i'); $res = db_prep_query($sql, $v, $t); $sql = "INSERT INTO gui_mb_user (fkey_gui_id,fkey_mb_user_id,mb_user_type) "; $sql .= "VALUES(\$1, \$2, \$3)"; $v = array($newGui, Mapbender::session()->get("mb_user_id"), 'owner'); $t = array('s', 'i', 's'); $res = db_prep_query($sql, $v, $t); require_once dirname(__FILE__) . "/mb_getGUIs.php"; $arrayGUIs = mb_getGUIs(Mapbender::session()->get("mb_user_id")); Mapbender::session()->set("mb_user_guis", $arrayGUIs); $guiCreated = true; } } ?> <script type="text/javascript"> <!-- function setFocus(){ document.form1.newGui.focus(); } function validate(){ if(document.form1.newGui.value == ""){ alert("Please enter a GUI-NAME!"); document.form1.newGui.focus(); return;
Mapbender::session()->set("mb_user_description", $isAuthenticated["mb_user_description"]); Mapbender::session()->set("mb_user_city", $isAuthenticated["mb_user_city"]); Mapbender::session()->set("mb_user_postal_code", $isAuthenticated["mb_user_postal_code"]); Mapbender::session()->set("epsg", "EPSG:31466"); Mapbender::session()->set("HTTP_HOST", $_SERVER["HTTP_HOST"]); //INSERT LAST LOGIN DATE AND TIME //NEW Filed required "ALTER TABLE mapbender.mb_user ADD COLUMN mb_user_last_login_date date;" $sql = "UPDATE mb_user SET"; $sql .= " mb_user_last_login_date = now()"; $V[0] = Mapbender::session()->get('mb_user_id'); $T[0] = 'i'; $sql .= 'WHERE mb_user_id = $1'; $res = db_prep_query($sql, $V, $T); //UPDATE USER LOGIN DATE and TIME require_once dirname(__FILE__) . "/../php/mb_getGUIs.php"; $arrayGUIs = mb_getGUIs($isAuthenticated["mb_user_id"]); Mapbender::session()->set("mb_user_guis", $arrayGUIs); header("Location: http://" . $_SERVER['HTTP_HOST'] . "/portal/success.html" . $URLAdd); session_write_close(); } else { header("Location: http://" . $_SERVER['HTTP_HOST'] . "/portal/failed.html" . $URLAdd); } function authenticate($name, $pw) { $con = db_connect(DBSERVER, OWNER, PW); db_select_db(DB, $con); $sql = "SELECT * FROM mb_user WHERE mb_user_name = \$1 AND mb_user_password = \$2"; $v = array($name, md5($pw)); // is md5 used really? $t = array('s', 's'); $res = db_prep_query($sql, $v, $t);