From 8b145da9131aa9aa818dcbfde4bae19ee7be9431 Mon Sep 17 00:00:00 2001
From: cookie <cookie@29ba0400-6e00-0410-a75a-ca02368028f8>
Date: Tue, 15 Nov 2005 19:49:05 +0000
Subject: jetzt werden auch raeume automatisch hinzugefuegt werden

git-svn-id: svn://svn.cccv.de/engel-system@53 29ba0400-6e00-0410-a75a-ca02368028f8
---
 www-ssl/admin/dbUpdateFromXLS.php | 36 ++++++++++++++++++++----------------
 1 file changed, 20 insertions(+), 16 deletions(-)

(limited to 'www-ssl/admin/dbUpdateFromXLS.php')

diff --git a/www-ssl/admin/dbUpdateFromXLS.php b/www-ssl/admin/dbUpdateFromXLS.php
index 11ce6911..de342945 100755
--- a/www-ssl/admin/dbUpdateFromXLS.php
+++ b/www-ssl/admin/dbUpdateFromXLS.php
@@ -10,9 +10,9 @@ include ("./inc/funktion_xml.php");
 ///////////
 $ShowDataStrukture = 0;
 $EnableRoomFunctions = 1;
-$EnableRooms = 0;
-$EnableRoomsDB = 0;
-$EnableSchudleFunctions = 0;
+$EnableRooms = 1;
+$EnableRoomsDB = 1;
+$EnableSchudleFunctions = 1;
 $EnableSchudle = 1;
 $EnableSchudleDB = 0;
 
@@ -20,21 +20,25 @@ $EnableSchudleDB = 0;
 /*##############################################################################################
 				erstellt Arrays der Reume
   ##############################################################################################*/
-$sql =	"SELECT `RID`, `Name` FROM `Room` ".
-	"WHERE `Show`='Y'".
-	"ORDER BY `Number`, `Name`;";
-$Erg = mysql_query($sql, $con);
-$rowcount = mysql_num_rows($Erg);
-
-for ($i=0; $i<$rowcount; $i++)
+function CreateRoomArrays()
 {
-	$Room[$i]["RID"]  = mysql_result($Erg, $i, "RID");
-	$Room[$i]["Name"] = mysql_result($Erg, $i, "Name");
-	$RoomID[ mysql_result($Erg, $i, "RID") ] =  mysql_result($Erg, $i, "Name");
-	$RoomName[ mysql_result($Erg, $i, "Name") ] = mysql_result($Erg, $i, "RID");
+	global $Room, $RoomID, $RoomName, $con;
+
+	$sql =	"SELECT `RID`, `Name` FROM `Room` ".
+		"WHERE `Show`='Y'".
+		"ORDER BY `Number`, `Name`;";
+	$Erg = mysql_query($sql, $con);
+	$rowcount = mysql_num_rows($Erg);
+
+	for ($i=0; $i<$rowcount; $i++)
+	{
+		$Room[$i]["RID"]  = mysql_result($Erg, $i, "RID");
+		$Room[$i]["Name"] = mysql_result($Erg, $i, "Name");
+		$RoomID[ mysql_result($Erg, $i, "RID") ] =  mysql_result($Erg, $i, "Name");
+		$RoomName[ mysql_result($Erg, $i, "Name") ] = mysql_result($Erg, $i, "RID");
+	}
 }
-
-
+CreateRoomArrays();
 
 /*##############################################################################################
 				           F I L E
-- 
cgit v1.2.3-54-g00ecf