diff options
Diffstat (limited to 'includes/pages/admin_active.php')
| -rw-r--r-- | includes/pages/admin_active.php | 13 |
1 files changed, 11 insertions, 2 deletions
diff --git a/includes/pages/admin_active.php b/includes/pages/admin_active.php index 38edbfdb..34b9eb14 100644 --- a/includes/pages/admin_active.php +++ b/includes/pages/admin_active.php @@ -1,10 +1,16 @@ <?php +/** + * @return string + */ function admin_active_title() { return _("Active angels"); } +/** + * @return string + */ function admin_active() { global $tshirt_sizes, $shift_sum_formula; @@ -110,7 +116,10 @@ function admin_active() } $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` " . ($show_all_shifts ? "" : "AND (`Shifts`.`end` < " . time() . " OR `Shifts`.`end` IS NULL)") . " WHERE `User`.`Gekommen` = 1 @@ -186,7 +195,7 @@ function admin_active() form_text('count', _("How much angels should be active?"), $count), form_submit('set_active', _("Preview")) ]) : $set_active, - msg(), + $msg . msg(), table([ 'nick' => _("Nickname"), 'shirt_size' => _("Size"), |