From 6d3d9bd927d5386b1dc4fbbcb7db5559efa7a5cd Mon Sep 17 00:00:00 2001 From: Adrian Greeve Date: Thu, 10 Oct 2013 13:18:11 +0800 Subject: [PATCH] MDL-42238 - mod_wiki: Alternate name sql update to wiki_print_recent_activity --- mod/wiki/lib.php | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/mod/wiki/lib.php b/mod/wiki/lib.php index 95de2f36f30..375669e3407 100644 --- a/mod/wiki/lib.php +++ b/mod/wiki/lib.php @@ -279,10 +279,12 @@ function wiki_supports($feature) { function wiki_print_recent_activity($course, $viewfullnames, $timestart) { global $CFG, $DB, $OUTPUT; - $sql = "SELECT p.*, w.id as wikiid, sw.groupid + $usernamefields = get_all_user_name_fields(true, 'u'); + $sql = "SELECT p.*, w.id as wikiid, sw.groupid, $usernamefields FROM {wiki_pages} p JOIN {wiki_subwikis} sw ON sw.id = p.subwikiid JOIN {wiki} w ON w.id = sw.wikiid + JOIN {user} u ON u.id = sw.userid WHERE p.timemodified > ? AND w.course = ? ORDER BY p.timemodified ASC"; if (!$pages = $DB->get_records_sql($sql, array($timestart, $course->id))) { -- 2.43.0