From 2bda8358da004792b592c4098199d730efdcc1ce Mon Sep 17 00:00:00 2001
From: selliott <selliott>
Date: Wed, 4 Feb 2004 15:07:08 +0000
Subject: [PATCH] In function forum_get_recent_posts, removed u.id from select
 because of conflict with p.id field (p.userid is available) also changed sort
 from discussion id to modified.

---
 mod/forum/lib.php | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/mod/forum/lib.php b/mod/forum/lib.php
index c7f77de23e..e0058bf6f6 100644
--- a/mod/forum/lib.php
+++ b/mod/forum/lib.php
@@ -969,14 +969,14 @@ function forum_get_recent_posts($sincetime, $forum="0") {
         $forumselect = "";
     }
 
-    return get_records_sql("SELECT p.*, d.name, u.id, u.firstname, u.lastname, u.picture, d.course
+    return get_records_sql("SELECT p.*, d.name, u.firstname, u.lastname, u.picture, d.course
                               FROM {$CFG->prefix}forum_posts p, 
                                    {$CFG->prefix}forum_discussions d,
                                    {$CFG->prefix}user u
                              WHERE p.modified > '$sincetime' $forumselect
                                AND p.userid = u.id
                                AND p.discussion = d.id
-                             ORDER BY p.discussion ASC");
+                             ORDER BY p.modified ASC");
 }
 
 
-- 
2.39.5