diff options
| author | Philip Häusler <msquare@notrademark.de> | 2014-09-06 15:02:54 +0200 |
|---|---|---|
| committer | Philip Häusler <msquare@notrademark.de> | 2014-09-08 13:57:36 +0200 |
| commit | 4414358cf5abf410368341d80ec72340011d5b29 (patch) | |
| tree | 673c6beb0b5affd31166f1c13183ada8a3ddce67 /includes/model/NeededAngelTypes_model.php | |
| parent | 2716c6364844db129e4f2514eb05edc5cfe49c6a (diff) | |
fix wrong nick and api sql query
Diffstat (limited to 'includes/model/NeededAngelTypes_model.php')
| -rw-r--r-- | includes/model/NeededAngelTypes_model.php | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/includes/model/NeededAngelTypes_model.php b/includes/model/NeededAngelTypes_model.php index 81ce2d5f..e9176d34 100644 --- a/includes/model/NeededAngelTypes_model.php +++ b/includes/model/NeededAngelTypes_model.php @@ -23,7 +23,8 @@ function NeededAngelTypes_by_shift($shiftId) { SELECT `NeededAngelTypes`.*, `AngelTypes`.`name`, `AngelTypes`.`restricted` FROM `NeededAngelTypes` JOIN `AngelTypes` ON `AngelTypes`.`id` = `NeededAngelTypes`.`angel_type_id` - WHERE `room_id`=" . sql_escape($shiftId) . " + JOIN `Shifts` ON `Shifts`.`RID` = `NeededAngelTypes`.`room_id` + WHERE `Shifts`.`SID`=" . sql_escape($shiftId) . " AND `count` > 0 ORDER BY `room_id` DESC "); |