diff options
| -rwxr-xr-x | www-ssl/inc/funktion_xml_room.php | 69 |
1 files changed, 69 insertions, 0 deletions
diff --git a/www-ssl/inc/funktion_xml_room.php b/www-ssl/inc/funktion_xml_room.php new file mode 100755 index 00000000..a8f626d1 --- /dev/null +++ b/www-ssl/inc/funktion_xml_room.php @@ -0,0 +1,69 @@ +<?PHP
+
+
+/*##############################################################################################
+ R o o m
+ ##############################################################################################*/
+echo "\n\n<br>\n<h1>Rooms:</h1>\n";
+
+function saveRoomData()
+{
+ global $con;
+ if( isset($_GET["NameXML"]))
+ {
+ $SQL= "INSERT INTO `Room` ( `Name`, `FromPentabarf` ) ".
+ "VALUES ('". mysql_escape_string($_GET["NameXML"]). "', 'Y');";
+ $Erg = mysql_query($SQL, $con);
+ if( $Erg )
+ echo "Aenderung, an Raum ". $_GET["NameXML"]. ", war erfogreich<br>";
+ else
+ echo "Aenderung, an Raum ". $_GET["NameXML"]. ", war <u>nicht</u> erfogreich.(".
+ mysql_error($con). ")<br>[$SQL]<br>";
+ }
+ else
+ echo "Fehler in den Parametern!<br>";
+} /*function saveRoomData*/
+
+if( isset($_GET["RoomUpdate"]))
+ saveRoomData();
+
+//INIT Status counter
+$DS_KO = 0;
+
+//Ausgabe
+echo "<table border=\"0\">\n";
+echo "<tr><th>Name</th><th>state</th></tr>\n";
+if( $EnableSchudle)
+foreach($XMLmain->sub as $EventKey => $Event)
+{
+ if( $Event->name == "VEVENT")
+ {
+ $NameXML = getXMLsubData( $Event, "LOCATION");
+ if( !isset( $RoomName[$NameXML]))
+ {
+ $RoomName[$NameXML] = "";
+
+ if( isset($_GET["UpdateALL"]))
+ {
+ $_GET["NameXML"] = $NameXML;
+ saveRoomData();
+ CreateRoomArrays();
+ }
+ else
+ {
+ echo "<form action=\"dbUpdateFromXLS.php\">\n";
+ echo "\t<tr>\n";
+ echo "\t<td><input name=\"NameXML\" type=\"text\" value=\"$NameXML\" readonly></td>\n";
+ echo "\t<td><input type=\"submit\" name=\"RoomUpdate\" value=\"update\"></td>\n";
+ $DS_KO++;
+ echo "\t</tr>\n";
+ echo "</form>\n";
+ echo "<br>";
+ }
+ }
+ }
+}
+echo "<tr><td colspan=\"6\">status: $DS_KO nicht vorhanden.</td></tr>\n";
+echo "</table>\n";
+
+?>
|