From d4ba9ef7dceb7bf084923a50a0cb25c332487219 Mon Sep 17 00:00:00 2001
From: poltawski <poltawski>
Date: Wed, 16 Jan 2008 14:45:24 +0000
Subject: [PATCH] MDL-13023 - avoid a db query per user picture

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

diff --git a/mod/assignment/lib.php b/mod/assignment/lib.php
index ec4278ca10..c8a9c77350 100644
--- a/mod/assignment/lib.php
+++ b/mod/assignment/lib.php
@@ -1128,7 +1128,7 @@ class assignment_base {
             $sort = ' ORDER BY '.$sort;
         }
 
-        $select = 'SELECT u.id, u.firstname, u.lastname, u.picture,
+        $select = 'SELECT u.id, u.firstname, u.lastname, u.picture, u.imagealt,
                           s.id AS submissionid, s.grade, s.submissioncomment,
                           s.timemodified, s.timemarked,
                           COALESCE(SIGN(SIGN(s.timemarked) + SIGN(s.timemarked - s.timemodified)), 0) AS status ';
@@ -1152,7 +1152,7 @@ class assignment_base {
                 $final_grade = $grading_info->items[0]->grades[$auser->id];
             /// Calculate user status
                 $auser->status = ($auser->timemarked > 0) && ($auser->timemarked >= $auser->timemodified);
-                $picture = print_user_picture($auser->id, $course->id, $auser->picture, false, true);
+                $picture = print_user_picture($auser, $course->id, $auser->picture, false, true);
 
                 if (empty($auser->submissionid)) {
                     $auser->grade = -1; //no submission yet
-- 
2.39.5