diff options
| author | Dries Buytaert <dries@buytaert.net> | 2001-04-02 20:13:19 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2001-04-02 20:13:19 +0000 |
| commit | 36ea1cf957fe03fa49df11481bdeaedf4787edde (patch) | |
| tree | 5b03166dccc684942647d39b80f46001c2c1727d /modules | |
| parent | 805107cd2202ddee66c4743e43804a3069508f29 (diff) | |
| download | brdo-36ea1cf957fe03fa49df11481bdeaedf4787edde.tar.gz brdo-36ea1cf957fe03fa49df11481bdeaedf4787edde.tar.bz2 | |
- list nodes chronological
Diffstat (limited to 'modules')
| -rw-r--r-- | modules/node.module | 2 | ||||
| -rw-r--r-- | modules/node/node.module | 2 |
2 files changed, 2 insertions, 2 deletions
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"; diff --git a/modules/node/node.module b/modules/node/node.module index a16390453..a84e33a05 100644 --- a/modules/node/node.module +++ b/modules/node/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"; |