session_start();
if ($_SESSION[PROJ_LOGIN]=="J") { include("auth.php"); }
include("db_setup.php");
if (!empty($_GET['lat_lon'])) {$field["lat_lon"] = $_POST['lat_lon']; $coord_array=explode(" ",$_GET['lat_lon']); $field["LAT"]=$coord_array[0]; $field["LON"]=$coord_array[1]; }
else { $muss_check["lat_lon"]="style=\"background-color:#ff0000;\" "; }
if ($_GET['lat_lon']=="0 0") { $muss_check["lat_lon"]="style=\"background-color:#ff0000;\" "; }
if ($_GET['lat_lon']==" ") { $muss_check["lat_lon"]="style=\"background-color:#ff0000;\" "; }
if ($_GET['mid']) { $mail_id_field=""; }
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>");
##########################################################################################################################################################
} ##
} #
?>