From b76128b0f51d8ad13440990ea2d928b53884b462 Mon Sep 17 00:00:00 2001 From: martin Date: Thu, 1 Aug 2002 04:00:56 +0000 Subject: [PATCH] More improvements to user discussion display --- mod/forum/lib.php | 8 +++++--- 1 file changed, 5 insertions(+), 3 deletions(-) diff --git a/mod/forum/lib.php b/mod/forum/lib.php index b2e09fe9ac..522dce4a0b 100644 --- a/mod/forum/lib.php +++ b/mod/forum/lib.php @@ -437,16 +437,18 @@ function forum_delete_discussion($discussion) { function forum_print_user_discussions($courseid, $userid) { global $USER; - $discussions = get_records_sql("SELECT p.*, u.firstname, u.lastname, u.email, u.picture, u.id as userid, f.type as forumtype + $discussions = get_records_sql("SELECT p.*, u.firstname, u.lastname, u.email, u.picture, + u.id as userid, f.type as forumtype FROM forum_discussions d, forum_posts p, user u, forum f WHERE d.course = '$courseid' AND p.discussion = d.id AND p.parent = 0 AND p.user = u.id AND u.id = '$userid' AND d.forum = f.id - ORDER BY p.created DESC"); + ORDER BY p.created ASC"); if ($discussions) { + $user = get_record("user", "id", $userid); echo "
"; - print_heading("Discussion topics"); + print_heading("Discussions started by $user->firstname $user->lastname"); $replies = forum_count_discussion_replies(); foreach ($discussions as $discussion) { if (($discussion->forumtype == "teacher") and !isteacher($courseid)) { -- 2.39.5