From e050c0dc7f4c70b13596f8e940a31a9678bb3b52 Mon Sep 17 00:00:00 2001
From: Philip Häusler <msquare@notrademark.de>
Date: Wed, 1 Jun 2011 15:02:00 +0200
Subject: bootstrapping

---
 www-ssl/admin/free.php | 74 +++++++++++++++++++++++---------------------------
 1 file changed, 34 insertions(+), 40 deletions(-)

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

diff --git a/www-ssl/admin/free.php b/www-ssl/admin/free.php
index 577ef7be..b45fadcf 100644
--- a/www-ssl/admin/free.php
+++ b/www-ssl/admin/free.php
@@ -1,16 +1,15 @@
 <?php
+require_once ('../bootstrap.php');
 
 $title = "Erzengel";
 $header = "Freie Engel";
-include ("../../../camp2011/includes/header.php");
-include ("../../../camp2011/includes/funktion_db_list.php");
+include ("includes/header.php");
+include ("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";
 
-
 #######################################################
 # Ermitteln freier Engel
 # 
@@ -33,22 +32,20 @@ $SQL =  "SELECT Shifts.*, ShiftEntry.*, User.Nick ".
   "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);";    
+$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);";
 
 //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
 
 //echo "<pre>$SQL</pre>"; 
 
 $Erg = mysql_query($SQL, $con);
-$Zeilen  = mysql_num_rows($Erg);
+$Zeilen = mysql_num_rows($Erg);
 
 // for ($i = 1; $i < mysql_num_fields($Erg); $i++)
 //  echo "|".mysql_field_name($Erg, $i);
 
-
-
 echo "<table width=\"100%\" class=\"border\" cellpadding=\"2\" cellspacing=\"1\">\n";
 echo "\t<tr class=\"contenttopic\">\n";
 echo "\t\t<td>Nick</td>\n";
@@ -58,47 +55,44 @@ echo "\t\t<td>Von</td>\n";
 echo "\t\t<td>Bis</td>\n";
 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")). "\")";
+$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")) . "\")";
 }
-if ($inuse!="") 
-  $inuse=" WHERE NOT (".$inuse.")";
+if ($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 "<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";
 
-$SQL = "SELECT Nick, UID, DECT FROM User".$inuse.";";
+$SQL = "SELECT Nick, UID, DECT FROM User" . $inuse . ";";
 $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";
+$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 "</table>\n";
 
-include ("../../../camp2011/includes/footer.php");
+include ("includes/footer.php");
 ?>
 
-- 
cgit v1.2.3-54-g00ecf