summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorDries Buytaert2011-08-12 13:28:27 (GMT)
committer Dries Buytaert2011-08-12 13:28:27 (GMT)
commit1787894dccc307236ad56be294dee905547f7ce0 (patch)
treef2f431839079ba765e7152cbd51646355002f7b0
parent75a3fd383b55dcb5677109eea9c938e71366e807 (diff)
- Patch #300714 by j0hn-smith, alexjarvis, lilou, linuxbox: sort node revisions by vid not timestamp.
-rw-r--r--modules/node/node.module2
1 files changed, 1 insertions, 1 deletions
diff --git a/modules/node/node.module b/modules/node/node.module
index 433ea51..299dfc1 100644
--- a/modules/node/node.module
+++ b/modules/node/node.module
@@ -1625,7 +1625,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_revisions} r LEFT JOIN {node} n ON n.vid = r.vid INNER JOIN {users} u ON u.uid = r.uid WHERE r.nid = %d ORDER BY r.timestamp DESC', $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_revisions} r LEFT JOIN {node} n ON n.vid = r.vid INNER JOIN {users} u ON u.uid = r.uid WHERE r.nid = %d ORDER BY r.vid DESC', $node->nid);
while ($revision = db_fetch_object($result)) {
$revisions[$revision->vid] = $revision;
}