diff options
| author | Dries Buytaert <dries@buytaert.net> | 2010-02-25 20:12:27 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2010-02-25 20:12:27 +0000 |
| commit | 6d7e7bb8a31910de2acf6b9e7dd8bb3eb2886dd2 (patch) | |
| tree | 131ba6d810ba7bfe92b8fc4a51e04711df1d9811 | |
| parent | f041110b34edf353626d1f2ba0df2cf6a0fa77c1 (diff) | |
| download | brdo-6d7e7bb8a31910de2acf6b9e7dd8bb3eb2886dd2.tar.gz brdo-6d7e7bb8a31910de2acf6b9e7dd8bb3eb2886dd2.tar.bz2 | |
- Patch #300714 by j0hn-smith, lilou, alexj, linuxbox: sort node revisions by vid not timestamp.
| -rw-r--r-- | modules/node/node.module | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/modules/node/node.module b/modules/node/node.module index 531de3abb..5e6f0c11f 100644 --- a/modules/node/node.module +++ b/modules/node/node.module @@ -2033,7 +2033,7 @@ function node_last_changed($nid) { */ function node_revision_list($node) { $revisions = array(); - $result = db_query('SELECT r.vid, r.title, r.log, r.uid, n.vid AS current_vid, r.timestamp, u.name FROM {node_revision} r LEFT JOIN {node} n ON n.vid = r.vid INNER JOIN {users} u ON u.uid = r.uid WHERE r.nid = :nid ORDER BY r.timestamp DESC', array(':nid' => $node->nid)); + $result = db_query('SELECT r.vid, r.title, r.log, r.uid, n.vid AS current_vid, r.timestamp, u.name FROM {node_revision} r LEFT JOIN {node} n ON n.vid = r.vid INNER JOIN {users} u ON u.uid = r.uid WHERE r.nid = :nid ORDER BY r.vid DESC', array(':nid' => $node->nid)); foreach ($result as $revision) { $revisions[$revision->vid] = $revision; } |