diff options
Diffstat (limited to 'www-ssl/admin/free.php')
| -rw-r--r--[-rwxr-xr-x] | www-ssl/admin/free.php | 68 |
1 files changed, 34 insertions, 34 deletions
diff --git a/www-ssl/admin/free.php b/www-ssl/admin/free.php index 5ceaebb6..577ef7be 100755..100644 --- a/www-ssl/admin/free.php +++ b/www-ssl/admin/free.php @@ -1,4 +1,4 @@ -<?PHP +<?php $title = "Erzengel"; $header = "Freie Engel"; @@ -6,9 +6,9 @@ include ("../../../camp2011/includes/header.php"); include ("../../../camp2011/includes/funktion_db_list.php"); -echo "Hallo ".$_SESSION['Nick'].",<br>\n"; +echo "Hallo ".$_SESSION['Nick'].",<br />\n"; -echo "<br><br>\n\nHier findest du alle Engel, welche zur Zeit in keiner Schicht verplant sind:<br><br>\n"; +echo "<br /><br />\n\nHier findest du alle Engel, welche zur Zeit in keiner Schicht verplant sind:<br /><br />\n"; ####################################################### @@ -21,21 +21,21 @@ echo "<br><br>\n\nHier findest du alle Engel, welche zur Zeit in keiner Schicht /* geht nicht ??? unter stabel !! $SQL= "SELECT User.Nick, Schichtplan.*, Schichtbelegung.* ". - "FROM Schichtplan, User LEFT OUTER ". - "JOIN Schichtbelegung ON User.UID=Schichtbelegung.UID ". - "WHERE Schichtplan.SID = Schichtbelegung.SID AND ". - "Schichtplan.Date < now() and ". - "Schichtplan.EndDate > now() ". - "ORDER BY Nick"; - + "FROM Schichtplan, User LEFT OUTER ". + "JOIN Schichtbelegung ON User.UID=Schichtbelegung.UID ". + "WHERE Schichtplan.SID = Schichtbelegung.SID AND ". + "Schichtplan.Date < now() and ". + "Schichtplan.EndDate > now() ". + "ORDER BY Nick"; + $SQL = "SELECT Shifts.*, ShiftEntry.*, User.Nick ". - "FROM User ". - "INNER JOIN (Shifts INNER JOIN ShiftEntry ON Shifts.SID = ShiftEntry.SID) ON User.UID = ShiftEntry.UID ". - "WHERE (Shifts.DateS<=Now() AND Shifts.DateE>=Now() );"; + "FROM User ". + "INNER JOIN (Shifts INNER JOIN ShiftEntry ON Shifts.SID = ShiftEntry.SID) ON User.UID = ShiftEntry.UID ". + "WHERE (Shifts.DateS<=Now() AND Shifts.DateE>=Now() );"; */ $SQL = "SELECT Shifts.*, ShiftEntry.* ". - "FROM `Shifts` INNER JOIN ShiftEntry ON Shifts.SID = ShiftEntry.SID ". - "WHERE (Shifts.DateS<=Now() AND Shifts.DateE>=Now() AND ShiftEntry.UID>0);"; + "FROM `Shifts` INNER JOIN ShiftEntry ON Shifts.SID = ShiftEntry.SID ". + "WHERE (Shifts.DateS<=Now() AND Shifts.DateE>=Now() AND ShiftEntry.UID>0);"; //SELECT User.Nick, Schichtplan.*, Schichtbelegung. * FROM User LEFT JOIN Schichtbelegung ON User.UID=Schichtbelegung.UID, Schichtplan LEFT JOIN Schichtbelegung ON Schichtplan.SID = Schichtbelegung.SID WHERE Schichtplan.Date < now() and Schichtplan.EndDate > now() ORDER BY Nick @@ -62,27 +62,27 @@ echo "\t</tr>\n"; $inuse=""; for ($i=0; $i < $Zeilen; $i++) { - echo "<tr class=\"content\">\n"; - echo "<td><a href=\"./userChangeNormal.php?Type=Normal&enterUID=". mysql_result($Erg, $i, "UID"). "\">". - UID2Nick(mysql_result($Erg, $i, "UID")). "</td></a>\n"; - echo "<td></td>\n"; - echo "<td>". mysql_result($Erg, $i, "RID"). "</td>\n"; - echo "<td>". mysql_result($Erg, $i, "DateS"). "</td>\n"; - echo "<td>". mysql_result($Erg, $i, "DateE"). "</td>\n"; - echo "</tr>\n"; - - if ($inuse!="") - $inuse.= " OR "; - $inuse.= "(Nick = \"". UID2Nick(mysql_result($Erg, $i, "UID")). "\")"; + echo "<tr class=\"content\">\n"; + echo "<td><a href=\"./userChangeNormal.php?Type=Normal&enterUID=". mysql_result($Erg, $i, "UID"). "\">". + UID2Nick(mysql_result($Erg, $i, "UID")). "</td></a>\n"; + echo "<td></td>\n"; + echo "<td>". mysql_result($Erg, $i, "RID"). "</td>\n"; + echo "<td>". mysql_result($Erg, $i, "DateS"). "</td>\n"; + echo "<td>". mysql_result($Erg, $i, "DateE"). "</td>\n"; + echo "</tr>\n"; + + if ($inuse!="") + $inuse.= " OR "; + $inuse.= "(Nick = \"". UID2Nick(mysql_result($Erg, $i, "UID")). "\")"; } if ($inuse!="") - $inuse=" WHERE NOT (".$inuse.")"; + $inuse=" WHERE NOT (".$inuse.")"; echo "</table>\n"; //########################################################################################################## -echo "<br><br>\n\nhier findest du alle Engel, welche zur Zeit in keiner Schichten verplant sind:<br><br>\n"; +echo "<br /><br />\n\nhier findest du alle Engel, welche zur Zeit in keiner Schichten verplant sind:<br /><br />\n"; echo "<table width=\"100%\" class=\"border\" cellpadding=\"2\" cellspacing=\"1\"\>\n"; echo "\t<tr class=\"contenttopic\">\n\t\t<td>Nick</td>\n\t\t<td>DECT</td>\n\t</tr>\n"; @@ -91,11 +91,11 @@ $Erg = mysql_query($SQL, $con); $Zeilen = mysql_num_rows($Erg); for ($i=0; $i < $Zeilen; $i++) { - echo "\t<tr class=\"content\">\n"; - echo "\t\t<td><a href=\"./userChangeNormal.php?Type=Normal&enterUID=". mysql_result($Erg, $i, "UID"). "\">". - mysql_result($Erg, $i, "Nick"). "</a></td>\n"; - echo "\t\t<td>". mysql_result($Erg, $i, "DECT"). "</td>\n"; - echo "\n</tr>\n"; + echo "\t<tr class=\"content\">\n"; + echo "\t\t<td><a href=\"./userChangeNormal.php?Type=Normal&enterUID=". mysql_result($Erg, $i, "UID"). "\">". + mysql_result($Erg, $i, "Nick"). "</a></td>\n"; + echo "\t\t<td>". mysql_result($Erg, $i, "DECT"). "</td>\n"; + echo "\n</tr>\n"; } echo "</table>\n"; |