=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 "
"; } ?>