diff options
Diffstat (limited to 'includes/model')
| -rw-r--r-- | includes/model/ShiftEntry_model.php | 18 |
1 files changed, 9 insertions, 9 deletions
diff --git a/includes/model/ShiftEntry_model.php b/includes/model/ShiftEntry_model.php index 903bc544..0cf5c040 100644 --- a/includes/model/ShiftEntry_model.php +++ b/includes/model/ShiftEntry_model.php @@ -22,7 +22,7 @@ function ShiftEntries_by_shift($shift_id) { /** * Create a new shift entry. * - * @param ShiftEntry $shift_entry + * @param ShiftEntry $shift_entry */ function ShiftEntry_create($shift_entry) { return sql_query("INSERT INTO `ShiftEntry` SET @@ -55,7 +55,7 @@ function ShiftEntry_delete($shift_entry_id) { /** * Returns next (or current) shifts of given user. * - * @param User $user + * @param User $user */ function ShiftEntries_upcoming_for_user($user) { return sql_select(" @@ -71,12 +71,12 @@ function ShiftEntries_upcoming_for_user($user) { /** * Returns all shift entries in given shift for given angeltype. * - * @param int $shift_id - * @param int $angeltype_id + * @param int $shift_id + * @param int $angeltype_id */ function ShiftEntries_by_shift_and_angeltype($shift_id, $angeltype_id) { return sql_select(" - SELECT * + SELECT * FROM `ShiftEntry` WHERE `SID`=" . sql_escape($shift_id) . " AND `TID`=" . sql_escape($angeltype_id) . " @@ -87,10 +87,10 @@ function ShiftEntries_by_shift_and_angeltype($shift_id, $angeltype_id) { * Returns all freeloaded shifts for given user. */ function ShiftEntries_freeloaded_by_user($user) { - return sql_select("SELECT * - FROM `ShiftEntry` - WHERE `freeloaded` = 1 + return sql_select("SELECT * + FROM `ShiftEntry` + WHERE `freeloaded` = 1 AND `UID`=" . sql_escape($user['UID'])); } -?>
\ No newline at end of file +?> |