From 01c9d1a810f293c6ec379b8ec8d3b1b1dabb6bd4 Mon Sep 17 00:00:00 2001 From: Jan-Philipp Litza Date: Fri, 28 Dec 2012 18:45:26 +0100 Subject: hotfix: show completely free shifts when searching for free shifts --- includes/pages/user_shifts.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'includes') diff --git a/includes/pages/user_shifts.php b/includes/pages/user_shifts.php index 22f26da8..c26ad668 100644 --- a/includes/pages/user_shifts.php +++ b/includes/pages/user_shifts.php @@ -357,7 +357,7 @@ function view_user_shifts() { if (count($_SESSION['user_shifts']['filled']) == 1) { if ($_SESSION['user_shifts']['filled'][0] == 0) $SQL .= " - AND NOT (nat.`count` <= entries.`count`) "; + AND (nat.`count` > entries.`count` OR entries.`count` IS NULL) "; elseif ($_SESSION['user_shifts']['filled'][0] == 1) $SQL .= " AND (nat.`count` <= entries.`count`) "; -- cgit v1.2.3-54-g00ecf