+ <? echo $_SESSION["PROJ

"; } if ($_SESSION['MID']) { $mail_id_field=""; } $img_path="images_dyn/"; $MODE = "RATE"; ############################################################################################ TEXTBAUSTEINE EINBINDEN include('globals/text_blocks.php'); ##################################################################################################################### if ($_GET['ID']) { $field["ID"] = $_GET['ID']; $db_field["POI_ID"] = $_GET['ID']; $muss_check["lat_lon"]=""; $sql = "SELECT * FROM yp_P".$_SESSION["PROJ_ID"]."_".$_SESSION["PROJ_AUTH"]." where POI_ID= '".$field["ID"]."'"; $query = mysqli_query($conn, $sql); if (!mysqli_num_rows($query)) { die("Kein Punkt mit dieser ID verfügbar"); } for ($i = 0; $i < mysqli_num_rows($query); $i++) { $table_main_poi[$i] = mysqli_fetch_array($query); } for ($i = 0; $i < count($table_main_poi); $i++) { if ($table_main_poi[$i]["NAME"]) $rate_poi["NAME"][$i] = strtoupper($table_main_poi[$i]["NAME"]); if ($table_main_poi[$i]["LAT"]) $rate_poi["LAT"][$i] = $table_main_poi[$i]["LAT"]; if ($table_main_poi[$i]["LON"]) $rate_poi["LON"][$i] = $table_main_poi[$i]["LON"]; } $rate_poi["NAME"] = array_unique($rate_poi["NAME"]); # print_r($poi_mean); $field["LAT"]=array_sum($rate_poi["LAT"])/count($rate_poi["LAT"]); $field["LON"]=array_sum($rate_poi["LON"])/count($rate_poi["LON"]); } ######## MODULE AUSLESEN foreach ($_SESSION["PROJ_MODULES"] as $modules) { $module["$modules"]="TRUE"; } ######################## #print_r($_SESSION); $status_msg="Mit

markierte Felder müssen definiert werden.
"; $fail_bg_color="fcf40f"; $fail_style="style=\"background-color:#$fail_bg_color;\" "; $fail_style_generic="background-color:#$fail_bg_color;"; if($_POST) { # #print_r($_POST); $MODE = $_POST["MODE"]; $check_fail=0; if ($MODE=="RATE") { $field["ID"] = $_GET['ID']; $db_field["POI_ID"] = $_GET['ID']; $MODE="RATE"; } ### MAIL IDENTIFICATION if ($_POST['MID']) {$field["MID"] = $_POST['MID']; $db_field["MID"] = $_POST['MID']; } $field["USER_ID"] = $_SESSION["USER"]["ID"]; $db_field["USER_ID"] = $_SESSION["USER"]["ID"]; $field["ACTIVE"] = 1; $db_field["ACTIVE"] = 1; $field["TIMESTAMP"] = date('Y-m-d H:i:s'); $db_field["TIMESTAMP"] = $field["TIMESTAMP"]; if ($_SESSION["PROJ_LOC_CODE"]) { $db_field["LOC"]=$_SESSION["PROJ_LOC_CODE"]; } $field["COMMENT"] = $_POST['COMMENT']; $db_field["COMMENT"] = $_POST['COMMENT']; $field["POI_TYPE"] = $_POST['POI_TYPE']; $db_field["POI_TYPE"] = $_POST['POI_TYPE']; if (!empty($_POST['lat_lon'])) {$field["lat_lon"] = $_POST['lat_lon']; $coord_array=explode(" ",$_POST['lat_lon']); $field["LAT"]=$coord_array[0]; $field["LON"]=$coord_array[1]; } else { $muss_check["lat_lon"]=$fail_style; $check_fail=1; $fail[LAT_LON]=1; } if ($_POST['lat_lon']=="0 0") { $muss_check["lat_lon"]=$fail_style; $check_fail=1; $fail[LAT_LON]=1; } if ($_POST['lat_lon']==" ") { $muss_check["lat_lon"]=$fail_style; $check_fail=1; $fail[LAT_LON]=1; } #echo $_SESSION["PROJ_RATE"]; if ($_SESSION["PROJ_RATE"] and $_SESSION["PROJ_RATE"] != "RATE0") { if (!empty($_POST['RATE'])) {$field["RATE"] = $_POST['RATE']; $db_field["RATE"] = $_POST['RATE']; $checked["RATE"][$_POST['RATE']] ="checked=\"checked\" "; } else { $muss_check["RATE"]=$fail_style; $check_fail=1; $fail[RATE]=1; } } #print_r($_POST); foreach ($_POST as $key => $var) { ##### if ($key == "lat_lon") { $coord = explode (" ", $var); $db_field["LAT"]=$coord[0]; $db_field["LON"]=$coord[1]; } #### else { #### if (substr($key, 0, 2) == "F_") { ### if (is_array($var)) { foreach ($var as $cboxkey =>$cbox) { $db_field[$key."_".$cboxkey]=$cbox; $checked_box[$key][$cboxkey]=" checked=\"checked\""; $checked_matrix[$key."_".$cboxkey][$cbox]=" checked=\"checked\""; } } ## else { ## $db_field[$key]=$var; } # } ### } #### } ##### #print_r($fail); ######### GENERISCHER MUSSFELDER CHECK unset($db_field_sql); unset($db_field_value_sql); foreach ($db_field as $key => $var) { $db_field_sql[]=$key; $db_field_value_sql[]="'".$var."'"; } $db_fields = implode(",", $db_field_sql); $db_values = implode (",", $db_field_value_sql); # print_r($db_field); # print_r($fail); if ($check_fail==0) { ## $sql = "INSERT into yp_P".$_SESSION["PROJ_ID"]."_".$_SESSION["PROJ_AUTH"]." ("; $sql = $sql.$db_fields.") VALUES (".$db_values.");"; $query = mysqli_query($sql, $conn); $poiID = mysqli_insert_id($conn); #echo $MODE; ######################################## ID auf POI_ID �bertragen wenn ein neuer Punkt gesetzt wird if ($MODE=="CREATE") { $sql_id_add = "update yp_P".$_SESSION["PROJ_ID"]."_".$_SESSION["PROJ_AUTH"]." set POI_ID='".$poiID."' where ID ='".$poiID."';"; # echo $sql_id_add; # mysql_select_db($db, $conn); # $query = mysql_query($sql_id_add, $conn); } ####### IMAGE UPLOAD Processing if ($poiID) { ## include('modules/class.upload/src/class.upload.php'); include('modules/img_upload.php'); } ## $status="saved"; #################################################################################################################################### Kontroll-Mail senden $empfaenger = $_SESSION["PROJ_EMAIL"]; $absendername = $_SESSION['PROJ_NAME'].".notifier"; $absendermail = "thomas.schauppenlehner@boku.ac.at"; $betreff = $_SESSION['PROJ_NAME']." - Neuer Punkt"; $text = "PoiID:".$poiID."\nProjectID: ".$_SESSION["PROJ_ID"]."\nProjectAUTH: ".$_SESSION["PROJ_AUTH"]."\n$db_fields \n $db_values Punkt deaktivieren: http://iamhere.boku.ac.at/youthplaces/admin/deactivate_poi.php?poiid=".$poiID."&pid=".$_SESSION["PROJ_ID"]."&auth=".$_SESSION["PROJ_AUTH"]; mail($empfaenger, $betreff, $text, "From: $absendername <$absendermail>"); ########################################################################################################################################################## } ## } # ?> + <? echo $_SESSION["PROJ_NAME"]; ?>

Fenster schließen

"; } else { echo "Zurück zur Kartenansicht

"; } # echo "

"; } if($_SESSION["PROJ_PT_VIEW"]!="S") { if ($_GET["lat_lon"] AND !($_POST)) { echo $txt['NEW_PT_NOTE'][$_SESSION["PROJ_FORMAL"]]; echo "
"; echo $txt['NEW_PT'][$_SESSION["PROJ_FORMAL"]]; } } if ($MODE=="RATE") { echo $txt_rate[$_SESSION["PROJ_FORMAL"]]."

".implode("|", $rate_poi["NAME"])."

"; } # if ($MODE=="CREATE") { echo "

"; } ?>

".$txt['FAIL'][$_SESSION["PROJ_FORMAL"]]."
"; } if ($status=="saved") { # echo $txt['SAVED'][$_SESSION["PROJ_FORMAL"]]; echo $txt['RATED'][$_SESSION["PROJ_FORMAL"]]; die ("
"); } echo $txt['RATEONLY'][$_SESSION["PROJ_FORMAL"]]; ?>