diff options
| author | Nathaniel Guse <nathaniel.guse@gmail.com> | 2012-09-08 17:28:13 -0500 |
|---|---|---|
| committer | Nathaniel Guse <nathaniel.guse@gmail.com> | 2012-09-08 17:28:13 -0500 |
| commit | 16a0757f2a21ad2ca36a9463c822539c9ea14d30 (patch) | |
| tree | 9fe86a93bb6370d848fbf2dcb14afd6c9bb3c575 /phpBB/includes/notifications/service.php | |
| parent | 86b801df7304d43f117bea762710149c25385260 (diff) | |
| download | forums-16a0757f2a21ad2ca36a9463c822539c9ea14d30.tar forums-16a0757f2a21ad2ca36a9463c822539c9ea14d30.tar.gz forums-16a0757f2a21ad2ca36a9463c822539c9ea14d30.tar.bz2 forums-16a0757f2a21ad2ca36a9463c822539c9ea14d30.tar.xz forums-16a0757f2a21ad2ca36a9463c822539c9ea14d30.zip | |
[ticket/11103] Order notifications properly
PHPBB3-11103
Diffstat (limited to 'phpBB/includes/notifications/service.php')
| -rw-r--r-- | phpBB/includes/notifications/service.php | 7 |
1 files changed, 6 insertions, 1 deletions
diff --git a/phpBB/includes/notifications/service.php b/phpBB/includes/notifications/service.php index 74e2e29e1a..4794472883 100644 --- a/phpBB/includes/notifications/service.php +++ b/phpBB/includes/notifications/service.php @@ -46,6 +46,8 @@ class phpbb_notifications_service * * @param array $options Optional options to control what notifications are loaded * user_id User id to load notifications for (Default: $user->data['user_id']) + * order_by Order by (Default: time) + * order_dir Order direction (Default: DESC) * limit Number of notifications to load (Default: 5) * start Notifications offset (Default: 0) */ @@ -58,12 +60,15 @@ class phpbb_notifications_service 'user_id' => $user->data['user_id'], 'limit' => 5, 'start' => 0, + 'order_by' => 'time', + 'order_dir' => 'DESC', ), $options); $notifications = $user_ids = array(); $sql = 'SELECT * FROM ' . NOTIFICATIONS_TABLE . ' - WHERE user_id = ' . (int) $options['user_id']; + WHERE user_id = ' . (int) $options['user_id'] . ' + ORDER BY ' . $this->db->sql_escape($options['order_by']) . ' ' . $this->db->sql_escape($options['order_dir']); $result = $this->db->sql_query_limit($sql, $options['limit'], $options['start']); while ($row = $this->db->sql_fetchrow($result)) |