diff options
| author | cookie <cookie@29ba0400-6e00-0410-a75a-ca02368028f8> | 2005-11-15 19:49:05 +0000 |
|---|---|---|
| committer | cookie <cookie@29ba0400-6e00-0410-a75a-ca02368028f8> | 2005-11-15 19:49:05 +0000 |
| commit | 8b145da9131aa9aa818dcbfde4bae19ee7be9431 (patch) | |
| tree | 8ff7f7a1576ca57ebe32899da165e0b874b9b14f /www-ssl/admin/dbUpdateFromXLS.php | |
| parent | 8648273e5ee3a548323a490b7cbd6c05467002e4 (diff) | |
jetzt werden auch raeume automatisch hinzugefuegt werden
git-svn-id: svn://svn.cccv.de/engel-system@53 29ba0400-6e00-0410-a75a-ca02368028f8
Diffstat (limited to 'www-ssl/admin/dbUpdateFromXLS.php')
| -rwxr-xr-x | www-ssl/admin/dbUpdateFromXLS.php | 36 |
1 files changed, 20 insertions, 16 deletions
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 |