summaryrefslogtreecommitdiff
path: root/includes/funktion_xml_room.php
diff options
context:
space:
mode:
Diffstat (limited to 'includes/funktion_xml_room.php')
-rw-r--r--[-rwxr-xr-x]includes/funktion_xml_room.php130
1 files changed, 61 insertions, 69 deletions
diff --git a/includes/funktion_xml_room.php b/includes/funktion_xml_room.php
index a8f626d1..cb91af6f 100755..100644
--- a/includes/funktion_xml_room.php
+++ b/includes/funktion_xml_room.php
@@ -1,69 +1,61 @@
-<?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";
-
-?>
+<?php
+ echo "<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 />";
+ }
+
+ 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";
+?>