summaryrefslogtreecommitdiff
path: root/www-ssl
diff options
context:
space:
mode:
Diffstat (limited to 'www-ssl')
-rwxr-xr-xwww-ssl/admin/free.php2
1 files changed, 1 insertions, 1 deletions
diff --git a/www-ssl/admin/free.php b/www-ssl/admin/free.php
index cf36ded5..4a137243 100755
--- a/www-ssl/admin/free.php
+++ b/www-ssl/admin/free.php
@@ -35,7 +35,7 @@ $SQL = "SELECT Shifts.*, ShiftEntry.*, User.Nick ".
*/
$SQL = "SELECT Shifts.*, ShiftEntry.* ".
"FROM `Shifts` INNER JOIN ShiftEntry ON Shifts.SID = ShiftEntry.SID ".
- "WHERE (Shifts.DateS<=Now() AND Shifts.DateE>=Now() );";
+ "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