From 42cd7a105b8e9e66485db2ffb72ebc83d196439a Mon Sep 17 00:00:00 2001
From: gbateson <gbateson>
Date: Sun, 1 Oct 2006 06:39:51 +0000
Subject: [PATCH] do not join "hotpot_attempts" and "hotpot_details" tables
 when displaying "hotpot/index.php". This should speed display when courses
 have many HotPot activities, especially for students

---
 mod/hotpot/index.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/mod/hotpot/index.php b/mod/hotpot/index.php
index 4ad23d6ec9..c1eb4a6e8b 100644
--- a/mod/hotpot/index.php
+++ b/mod/hotpot/index.php
@@ -241,7 +241,7 @@
         // restrict results to this user only
         $select .= " AND a.userid='$USER->id'";
     }
-    $usejoin = 1;
+    $usejoin = 0;
     if (has_capability('mod/hotpot:grade', get_context_instance(CONTEXT_SYSTEM, SITEID)) && $usejoin) {
         // join attempts table and details table
         $tables .= ",{$CFG->prefix}hotpot_details AS d";
-- 
2.39.5