'; #require_once(dirname(__FILE__)."/../../conf/mapbender.conf"); #require_once(dirname(__FILE__)."/../classes/class_administration.php"); #require_once(dirname(__FILE__)."/../php/mb_validateSession.php"); require_once(dirname(__FILE__)."/../../core/globalSettings.php"); require_once(dirname(__FILE__)."/../classes/class_administration.php"); require_once dirname(__FILE__) . "/../classes/class_Uuid.php"; require_once dirname(__FILE__) . "/../classes/class_user.php"; ?>
BPlanID für Verbände
id; if (isset($_REQUEST["id"])) { #--------------------------- $uuid = new Uuid(); $sql = "SELECT mb_user_name, mb_user_email FROM mapbender.mb_user WHERE mb_user_id=$1"; $v = array($userId); $t = array('i'); $res = db_prep_query($sql, $v, $t); while($row = db_fetch_array($res)) { $mb_user_name=$row['mb_user_name']; $mb_user_email=$row['mb_user_email']; } #----------------------------- $sql = "INSERT INTO bplan_id (fkey_mb_user_id, uuid, fkey_mb_user_name, fkey_mb_user_email) VALUES ($1, $2, $3, $4)"; //$sql = "INSERT INTO public.bplan_id (fkey_mb_user_id, uuid, fkey_mb_user_name, fkey_mb_user_email) VALUES (".$userId.", '".$uuid."', '".$mb_user_name."','".$mb_user_email."')"; #$e = new mb_exception("user_id: ".$_SESSION["mb_user_id"]); #$e = new mb_exception("uuid: ".$uuid); #$e = new mb_exception("mb_user_name: ".$mb_user_name); #$e = new mb_exception("mb_user_email: ".$mb_user_email); $v = array($userId, $uuid, $mb_user_name, $mb_user_email); $t = array('i','s','s','s'); $res = db_prep_query($sql, $v, $t); #--------------------------------------------- $sql = "SELECT id FROM bplan_id WHERE uuid = $1"; $v = array($uuid); $t = array('s'); $res = db_prep_query($sql, $v, $t); while($row=db_fetch_array($res)) { $id = $row['id']; } } echo "
"; echo "
ID für einen Bebauungsplan
"; echo "
"; echo "
"; echo "
"; echo "
Sie sind momentan eingeloggt als:
"; echo "
".$_SESSION["mb_user_name"]."
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
Eine ID für einen Bebauungsplan anfordern
"; echo "
"; echo "
"; echo "
"; if (isset($_REQUEST["id"])) { //generate id string $idString = $prefix.str_repeat("0", (5 - strlen((string)$id))). $id; echo "
"; echo "
"; echo "
Die nächstfreie ID für einen Bebauungsplan lautet:
"; echo "
".$idString."
"; echo "
"; echo "
"; } echo ""; ?>