From 6d7e7bb8a31910de2acf6b9e7dd8bb3eb2886dd2 Mon Sep 17 00:00:00 2001
From: Dries Buytaert <dries@buytaert.net>
Date: Thu, 25 Feb 2010 20:12:27 +0000
Subject: - Patch #300714 by j0hn-smith, lilou, alexj, linuxbox: sort node
 revisions by vid not timestamp.

---
 modules/node/node.module | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'modules/node/node.module')

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;
   }
-- 
cgit v1.2.3