From 866c47ec603595e8fe67da5f0e5d162a70b1f7b4 Mon Sep 17 00:00:00 2001
From: cookie <cookie@29ba0400-6e00-0410-a75a-ca02368028f8>
Date: Sun, 6 Nov 2005 17:14:25 +0000
Subject: move files

git-svn-id: svn://svn.cccv.de/engel-system@20 29ba0400-6e00-0410-a75a-ca02368028f8
---
 admin/free.php | 108 ---------------------------------------------------------
 1 file changed, 108 deletions(-)
 delete mode 100755 admin/free.php

(limited to 'admin/free.php')

diff --git a/admin/free.php b/admin/free.php
deleted file mode 100755
index 1e7bd259..00000000
--- a/admin/free.php
+++ /dev/null
@@ -1,108 +0,0 @@
-<?PHP
-
-$title = "Erzengel";
-$header = "Freie Engel";
-include ("./inc/header.php");
-include ("./inc/funktion_db_list.php");
-include ("./inc/funktion_user.php");
-
-
-echo "Hallo ".$_SESSION['Nick'].",<br>\n";
-
-?>
-hier findest du alle Engel, welche zur Zeit in Schichten verplant sind:
-<br><br>
-
-
-<?
-#######################################################
-# Ermitteln freier Engel
-# 
-# auslesen aller Engel und dazugehoerige Schichten
-#######################################################
-
-// $SQL= "SELECT User.Nick, Schichtplan.*, Schichtbelegung. * FROM User LEFT JOIN Schichtplan ON User.UID=Schichtbelegung.UID, Schichtplan.SID LEFT JOIN Schichtbelegung.SID WHERE User.UID = Schichtbelegung.UID AND Schichtplan.SID = Schichtbelegung.SID AND Schichtplan.Date < now() and Schichtplan.EndDate > now() ORDER BY Nick";
-
-/* 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";
-	
-$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() );";		
-*/
-$SQL =  "SELECT Shifts.*, ShiftEntry.* ".
-	"FROM Shifts INNER JOIN ShiftEntry ON Shifts.SID = ShiftEntry.SID ".
-	"WHERE (Shifts.DateS<=Now() AND Shifts.DateE>=Now() );";		
-
-//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);
-
-// 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";
-echo "\t\t<td>Schicht</td>\n";
-echo "\t\t<td>Ort</td>\n";
-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=\"./user.php?Type=Normal&enterUID=". mysql_result($Erg, $i, "UID"). "\">". 
-		mysql_result($Erg, $i, "Nick"). "</td></a>\n";
-	echo "<td>". UID2Nick(mysql_result($Erg, $i, "UID")). "</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.")";
-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.";";
-$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=\"./user.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 ("./inc/footer.php");
-?>
-
-- 
cgit v1.2.3-54-g00ecf