diff options
author | cookie <cookie@29ba0400-6e00-0410-a75a-ca02368028f8> | 2008-12-26 11:25:59 +0000 |
---|---|---|
committer | cookie <cookie@29ba0400-6e00-0410-a75a-ca02368028f8> | 2008-12-26 11:25:59 +0000 |
commit | ec9554993b9fa783a0aecee8500f16b833fce5a2 (patch) | |
tree | 11f36191c7b568e052feee1ddfff19a6391de3f6 /www-ssl/admin/free.php | |
parent | e71ae4ec9093f33ba36cde0456f539ee3cc6d52e (diff) |
bugfix in free engels, now are free shifts are not showed
git-svn-id: svn://svn.cccv.de/engel-system@328 29ba0400-6e00-0410-a75a-ca02368028f8
Diffstat (limited to 'www-ssl/admin/free.php')
-rwxr-xr-x | www-ssl/admin/free.php | 2 |
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 |