From 88e729beed34504089ca57bc2c59b92cde96116f Mon Sep 17 00:00:00 2001 From: moodler Date: Thu, 28 Nov 2002 09:04:04 +0000 Subject: [PATCH] Add searching of subjects as well as messages --- mod/forum/search.php | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/mod/forum/search.php b/mod/forum/search.php index 7e60a58861..070d1328f9 100644 --- a/mod/forum/search.php +++ b/mod/forum/search.php @@ -47,7 +47,8 @@ $posts = get_records_sql("SELECT p.*,u.firstname,u.lastname,u.email,u.picture,u.id as userid FROM forum_posts p, forum_discussions d, user u, forum f - WHERE message LIKE '%$search%' AND p.user = u.id + WHERE (p.message LIKE '%$search%' OR p.subject LIKE '%$search%') + AND p.user = u.id AND p.discussion = d.id AND d.course = '$course->id' AND d.forum = f.id $notteacherforum ORDER BY p.modified DESC LIMIT 0, 50 "); -- 2.39.5