From ca908eb724640883ce1cf1de1ce77599a044d54d Mon Sep 17 00:00:00 2001
From: natrak <>
Date: Mon, 4 Jun 2001 22:09:16 +0000
Subject: - Sorted by n.nid in account_track_comments/nodes() so users can see
the status on what they recently submitted. Will try and make this a little
more configurable in the near future.
---
account.php | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)
(limited to 'account.php')
diff --git a/account.php b/account.php
index 49f73b864..79e436f07 100644
--- a/account.php
+++ b/account.php
@@ -344,7 +344,7 @@ function account_password($min_length=6) {
function account_track_comments() {
global $theme, $user;
- $sresult = db_query("SELECT n.nid, n.title, COUNT(n.nid) AS count FROM comments c LEFT JOIN node n ON c.lid = n.nid WHERE c.author = '$user->id' GROUP BY n.nid DESC LIMIT 5");
+ $sresult = db_query("SELECT n.nid, n.title, COUNT(n.nid) AS count FROM comments c LEFT JOIN node n ON c.lid = n.nid WHERE c.author = '$user->id' GROUP BY n.nid DESC ORDER BY n.nid DESC LIMIT 5");
while ($node = db_fetch_object($sresult)) {
$output .= "". format_plural($node->count, "comment", "comments") ." ". t("attached to node") ." `nid\">". check_output($node->title) ."`:\n";
@@ -365,7 +365,7 @@ function account_track_comments() {
function account_track_nodes() {
global $theme, $user;
- $result = db_query("SELECT n.nid, n.type, n.title, n.timestamp, COUNT(c.cid) AS count FROM node n LEFT JOIN comments c ON c.lid = n.nid WHERE n.status = '". node_status("posted") ."' AND n.author = '$user->id' GROUP BY n.nid DESC LIMIT 25");
+ $result = db_query("SELECT n.nid, n.type, n.title, n.timestamp, COUNT(c.cid) AS count FROM node n LEFT JOIN comments c ON c.lid = n.nid WHERE n.status = '". node_status("posted") ."' AND n.author = '$user->id' GROUP BY n.nid DESC ORDER BY n.nid DESC LIMIT 25");
while ($node = db_fetch_object($result)) {
$output .= "