PHP mb_getGUIs Examples

Example #1

File: mod_filteredGroup_Gui.php Project: bfpi/klarschiff-frontend-mit-mapbender

    $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 {

Example #2

File: login.php Project: bfpi/klarschiff-frontend-mit-mapbender

     #			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") {

Example #3

File: mod_newGui.php Project: bfpi/klarschiff-frontend-mit-mapbender

        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;

Example #4

File: authentication.php Project: bfpi/klarschiff-frontend-mit-mapbender

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