diff options
| author | msquare <msquare@notrademark.de> | 2016-11-10 13:38:31 +0100 |
|---|---|---|
| committer | msquare <msquare@notrademark.de> | 2016-11-10 13:38:31 +0100 |
| commit | f6da9148e7fa2097688613f3dd6e097d9e71293a (patch) | |
| tree | df115229e367f0f367c58a1657f93229669c14b6 /includes | |
| parent | defdb3007c426db16838f49b44e8577e6e964233 (diff) | |
fix missing var check
Diffstat (limited to 'includes')
| -rw-r--r-- | includes/pages/admin_active.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/includes/pages/admin_active.php b/includes/pages/admin_active.php index daa2382b..4e2ca89f 100644 --- a/includes/pages/admin_active.php +++ b/includes/pages/admin_active.php @@ -40,7 +40,7 @@ function admin_active() { if (isset($_REQUEST['ack'])) { sql_query("UPDATE `User` SET `Aktiv` = 0 WHERE `Tshirt` = 0"); $users = sql_select(" - SELECT `User`.*, COUNT(`ShiftEntry`.`id`) as `shift_count`, ${shift_sum_formula} as `shift_length` + SELECT `User`.*, COUNT(`ShiftEntry`.`id`) as `shift_count`, $shift_sum_formula as `shift_length` FROM `User` LEFT JOIN `ShiftEntry` ON `User`.`UID` = `ShiftEntry`.`UID` LEFT JOIN `Shifts` ON `ShiftEntry`.`SID` = `Shifts`.`SID` |