From d194783e8f2aa2e9e27e34572cda6f796930ac37 Mon Sep 17 00:00:00 2001
From: Philip Häusler <msquare@notrademark.de>
Date: Wed, 14 Sep 2011 22:54:36 +0200
Subject: cleanup from old files

---
 www-ssl_old/admin/free_DECT.php | 65 -----------------------------------------
 1 file changed, 65 deletions(-)
 delete mode 100644 www-ssl_old/admin/free_DECT.php

(limited to 'www-ssl_old/admin/free_DECT.php')

diff --git a/www-ssl_old/admin/free_DECT.php b/www-ssl_old/admin/free_DECT.php
deleted file mode 100644
index 4b4e3085..00000000
--- a/www-ssl_old/admin/free_DECT.php
+++ /dev/null
@@ -1,65 +0,0 @@
-<?php
-require_once ('../bootstrap.php');
-
-include ("config/config_db.php");
-include ("includes/funktion_db_list.php");
-include ("includes/funktion_user.php");
-
-#######################################################
-# Ermitteln freier Engel
-# 
-# auslesen aller Engel und dazugehoerige Schichten
-#######################################################
-
-$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);";
-
-$Erg = mysql_query($SQL, $con);
-$Zeilen = mysql_num_rows($Erg);
-
-$inuse = "";
-for ($i = 0; $i < $Zeilen; $i++) {
-	if ($inuse != "")
-		$inuse .= " OR ";
-	$inuse .= "(UID = \"" . mysql_result($Erg, $i, "UID") . "\")";
-}
-if ($inuse != "") {
-	$inuse = " WHERE (NOT (" . $inuse . ")) AND (DECT!='')";
-} else {
-	$inuse = " WHERE (DECT!='')";
-}
-
-//##########################################################################################################
-
-$SQL = "SELECT * FROM User" . $inuse . ";";
-$Erg = mysql_query($SQL, $con);
-$Zeilen = mysql_num_rows($Erg);
-for ($i = 0; $i < $Zeilen; $i++) {
-	// get DECT number
-	echo mysql_result($Erg, $i, "DECT") . "\t";
-
-	// get all user rights
-	$SQL_RIGHT = "SELECT * FROM UserCVS WHERE UID=" . mysql_result($Erg, $i, "UID") . ";";
-	$Erg_RIGHT = mysql_query($SQL_RIGHT, $con);
-	$UserRights = mysql_fetch_array($Erg_RIGHT);
-
-	foreach ($UserRights as $Var => $Value) {
-		if ((strpos($Var, ".php") === false) AND (strpos($Var, "/") === false) AND (strpos($Var, "UID") === false) AND (is_numeric($Var) === false)) {
-			echo "\"" . $Var . "\"=" . $Value . "\t";
-		}
-	}
-
-	// get shift types
-	$SQL_TYPES = "SELECT TID FROM `ShiftEntry` WHERE UID=" . mysql_result($Erg, $i, "UID") . " GROUP BY TID;";
-	$Erg_TYPES = mysql_query($SQL_TYPES, $con);
-	$Zeilen_Typen = mysql_num_rows($Erg_TYPES);
-	for ($j = 0; $j < $Zeilen_Typen; $j++) {
-		echo "\"TID_" . TID2Type(mysql_result($Erg_TYPES, $j, "TID")) . "\"=Y\t";
-	}
-
-	echo "\n";
-	//  echo "<br />";
-}
-?>
-
-- 
cgit v1.2.3-70-g09d2