summaryrefslogtreecommitdiff
path: root/www-ssl/admin/free_DECT.php
diff options
context:
space:
mode:
authorMoritz helios Rudert <helios@planetcyborg.de>2011-06-01 12:13:39 +0200
committerMoritz helios Rudert <helios@planetcyborg.de>2011-06-01 12:13:39 +0200
commit75448045cfe70054c8f4bae1bcfaf9bb0f70d330 (patch)
tree6a4d3d35019cdf933c1816e8522dc5d2557f5238 /www-ssl/admin/free_DECT.php
parent12e0b0d809c29d435a247798d7318cc9835980ea (diff)
fixes
Diffstat (limited to 'www-ssl/admin/free_DECT.php')
-rw-r--r--[-rwxr-xr-x]www-ssl/admin/free_DECT.php68
1 files changed, 34 insertions, 34 deletions
diff --git a/www-ssl/admin/free_DECT.php b/www-ssl/admin/free_DECT.php
index c28c78af..83a4123f 100755..100644
--- a/www-ssl/admin/free_DECT.php
+++ b/www-ssl/admin/free_DECT.php
@@ -1,4 +1,4 @@
-<?PHP
+<?php
include ("../../../camp2011/includes/config_db.php");
include ("../../../camp2011/includes/funktion_db_list.php");
@@ -12,8 +12,8 @@ include ("../../../camp2011/includes/funktion_user.php");
#######################################################
$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);";
$Erg = mysql_query($SQL, $con);
$Zeilen = mysql_num_rows($Erg);
@@ -21,17 +21,17 @@ $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.= " OR ";
+ $inuse.= "(UID = \"". mysql_result($Erg, $i, "UID"). "\")";
}
if ($inuse!="")
{
- $inuse=" WHERE (NOT (".$inuse.")) AND (DECT!='')";
+ $inuse=" WHERE (NOT (".$inuse.")) AND (DECT!='')";
}
else
{
- $inuse=" WHERE (DECT!='')";
+ $inuse=" WHERE (DECT!='')";
}
@@ -42,36 +42,36 @@ $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 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);
+ // 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";
- }
- }
+ 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";
- }
+ // 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>";
+ echo "\n";
+// echo "<br />";
}
?>