From 36ea1cf957fe03fa49df11481bdeaedf4787edde Mon Sep 17 00:00:00 2001
From: Dries Buytaert <dries@buytaert.net>
Date: Mon, 2 Apr 2001 20:13:19 +0000
Subject: - list nodes chronological

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

(limited to 'modules/node.module')

diff --git a/modules/node.module b/modules/node.module
index a16390453..a84e33a05 100644
--- a/modules/node.module
+++ b/modules/node.module
@@ -8,7 +8,7 @@ $nstatus = array(0 => dumped, 1 => expired, 2 => queued, 3 => posted);
 function node_overview($query = 0) {
   global $user, $nstatus;
 
-  $result = db_query("SELECT n.*, u.userid FROM node n LEFT JOIN users u ON n.author = u.id". ($query ? " WHERE $query" : ""));
+  $result = db_query("SELECT n.*, u.userid FROM node n LEFT JOIN users u ON n.author = u.id ". ($query ? "WHERE $query" : "") ." ORDER BY n.timestamp DESC");
 
   $output .= "<TABLE BORDER=\"1\" CELLPADDING=\"2\" CELLSPACING=\"2\">\n";
   $output .= " <TR><TH>title</TH><TH>type</TH><TH>status</TH><TH>author</TH><TH>date</TH><TH COLSPAN=\"3\">operations</TH></TR>\n";
-- 
cgit v1.2.3