diff options
| author | Dries Buytaert <dries@buytaert.net> | 2006-01-15 17:03:34 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2006-01-15 17:03:34 +0000 |
| commit | ae84e469b060c6e8df22080064221813575d0b28 (patch) | |
| tree | 74153d49bae5d0d54a9e811b760fba88153253fe | |
| parent | f649b42d9c3d654da63d38be28ba0eda1aa24ef0 (diff) | |
| download | brdo-ae84e469b060c6e8df22080064221813575d0b28.tar.gz brdo-ae84e469b060c6e8df22080064221813575d0b28.tar.bz2 | |
- Patch #39329 by markus: order sources in aggregator.
| -rw-r--r-- | modules/aggregator.module | 2 | ||||
| -rw-r--r-- | modules/aggregator/aggregator.module | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/modules/aggregator.module b/modules/aggregator.module index dd371af95..e86244844 100644 --- a/modules/aggregator.module +++ b/modules/aggregator.module @@ -1021,7 +1021,7 @@ function aggregator_page_list_submit($form_id, $form) { * Menu callback; displays all the feeds used by the aggregator. */ function aggregator_page_sources() { - $result = db_query('SELECT f.fid, f.title, f.description, f.image, MAX(i.timestamp) AS last FROM {aggregator_feed} f LEFT JOIN {aggregator_item} i ON f.fid = i.fid GROUP BY f.fid, f.title, f.description, f.image'); + $result = db_query('SELECT f.fid, f.title, f.description, f.image, MAX(i.timestamp) AS last FROM {aggregator_feed} f LEFT JOIN {aggregator_item} i ON f.fid = i.fid GROUP BY f.fid, f.title, f.description, f.image ORDER BY last DESC, f.title'); $output = "<div id=\"aggregator\">\n"; while ($feed = db_fetch_object($result)) { $output .= '<h2>'. check_plain($feed->title) ."</h2>\n"; diff --git a/modules/aggregator/aggregator.module b/modules/aggregator/aggregator.module index dd371af95..e86244844 100644 --- a/modules/aggregator/aggregator.module +++ b/modules/aggregator/aggregator.module @@ -1021,7 +1021,7 @@ function aggregator_page_list_submit($form_id, $form) { * Menu callback; displays all the feeds used by the aggregator. */ function aggregator_page_sources() { - $result = db_query('SELECT f.fid, f.title, f.description, f.image, MAX(i.timestamp) AS last FROM {aggregator_feed} f LEFT JOIN {aggregator_item} i ON f.fid = i.fid GROUP BY f.fid, f.title, f.description, f.image'); + $result = db_query('SELECT f.fid, f.title, f.description, f.image, MAX(i.timestamp) AS last FROM {aggregator_feed} f LEFT JOIN {aggregator_item} i ON f.fid = i.fid GROUP BY f.fid, f.title, f.description, f.image ORDER BY last DESC, f.title'); $output = "<div id=\"aggregator\">\n"; while ($feed = db_fetch_object($result)) { $output .= '<h2>'. check_plain($feed->title) ."</h2>\n"; |