From e87e62d953ec5d4a79390ce28ef88fe43a816473 Mon Sep 17 00:00:00 2001
From: cookie <cookie@29ba0400-6e00-0410-a75a-ca02368028f8>
Date: Fri, 10 Nov 2006 19:37:59 +0000
Subject: probleme mit leeren tabellen beseitigt

git-svn-id: svn://svn.cccv.de/engel-system@157 29ba0400-6e00-0410-a75a-ca02368028f8
---
 www-ssl/nonpublic/schichtplan.1.php |  8 ++++----
 www-ssl/nonpublic/schichtplan.2.php |  7 ++++---
 www-ssl/nonpublic/schichtplan.php   | 13 ++++++++-----
 3 files changed, 16 insertions(+), 12 deletions(-)

(limited to 'www-ssl/nonpublic')

diff --git a/www-ssl/nonpublic/schichtplan.1.php b/www-ssl/nonpublic/schichtplan.1.php
index a4884a11..d733b111 100755
--- a/www-ssl/nonpublic/schichtplan.1.php
+++ b/www-ssl/nonpublic/schichtplan.1.php
@@ -13,9 +13,9 @@ function Printlink( $Datum)
 	echo "'>$Datum</a></li>\n";
 } //function Printlink(
 
-foreach( $VeranstaltungsTage as $k => $v)
-{
-	Printlink( $v);
-}
+if( isset ($VeranstaltungsTage))
+	foreach( $VeranstaltungsTage as $k => $v)
+		Printlink( $v);
+
 
 ?>
diff --git a/www-ssl/nonpublic/schichtplan.2.php b/www-ssl/nonpublic/schichtplan.2.php
index 2074e3fa..bfa1d5a4 100755
--- a/www-ssl/nonpublic/schichtplan.2.php
+++ b/www-ssl/nonpublic/schichtplan.2.php
@@ -4,15 +4,16 @@
 
 include ("./inc/funktion_schichtplan_aray.php");
 
-foreach( $Room as $RoomEntry  )
-{
+if( isset ($Room))
+    foreach( $Room as $RoomEntry  )
+    {
 	if(isset($ausdatum))
 	  echo "\t<li><a href='./schichtplan.php?ausdatum=$ausdatum&raum=". $RoomEntry["RID"]. "'>".
 	       $RoomEntry["Name"]. "</a></li>\n";
 	else
 	  echo "\t<li><a href='./schichtplan.php?raum=". $RoomEntry["RID"]. "'>".
 	       $RoomEntry["Name"]. "</a></li>\n";
-}
+    }
 echo "<br>";
 if(isset($ausdatum))
 	echo "<li><a href='./schichtplan.php?ausdatum=$ausdatum&raum=-1'>alle</a></li>";
diff --git a/www-ssl/nonpublic/schichtplan.php b/www-ssl/nonpublic/schichtplan.php
index b9a24cfd..a9e2d50e 100755
--- a/www-ssl/nonpublic/schichtplan.php
+++ b/www-ssl/nonpublic/schichtplan.php
@@ -51,7 +51,10 @@ if( !isset($ausdatum) )
  		$sql = "SELECT `DateS` FROM `Shifts` ORDER BY `DateS` ASC LIMIT 0, 1";
   		$Erg = mysql_query($sql, $con);
 	}
-	$ausdatum = substr(mysql_result($Erg,0,"DateS"),0,10);
+	if( mysql_num_rows( $Erg ) > 0 )
+		$ausdatum = substr(mysql_result($Erg,0,"DateS"),0,10);
+	else
+		$ausdatum = gmdate("Y-m-d", time()+3600);
 
 }
 
@@ -61,10 +64,10 @@ if ( !isset($raum) )
 {
 	// Ausgabe wenn kein Raum Ausgewählt:
 	echo Get_Text("pub_schicht_auswahl_raeume"). "<br><br>\n";
-	
-	foreach( $Room as $RoomEntry  )
-		echo "\t<li><a href='./schichtplan.php?ausdatum=$ausdatum&raum=". $RoomEntry["RID"]. "'>".
-		$RoomEntry["Name"]. "</a></li>\n";
+	if( isset($Room))	
+		foreach( $Room as $RoomEntry  )
+			echo "\t<li><a href='./schichtplan.php?ausdatum=$ausdatum&raum=". $RoomEntry["RID"]. "'>".
+				$RoomEntry["Name"]. "</a></li>\n";
 
 	echo "<br><br>";
 	echo Get_Text("pub_schicht_alles_1"). "<a href='./schichtplan.php?ausdatum=$ausdatum&raum=-1'> <u>".
-- 
cgit v1.2.3-54-g00ecf