From 04a252be7e5560e4fa75ce3715a2e15ad8c523db Mon Sep 17 00:00:00 2001
From: moodler <moodler>
Date: Tue, 9 Jan 2007 12:23:57 +0000
Subject: [PATCH] A "guess" at what this query might be.  Needs MH or DOnal to
 check it.

MDL-8082
---
 course/report/log/lib.php | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

diff --git a/course/report/log/lib.php b/course/report/log/lib.php
index 17e64b2a07..0a1cd3f25f 100644
--- a/course/report/log/lib.php
+++ b/course/report/log/lib.php
@@ -81,11 +81,11 @@ function print_mnet_log_selector_form($hostid, $course, $selecteduser=0, $select
             FROM 
                 {$CFG->prefix}mnet_host h
             LEFT OUTER JOIN 
-                {$CFG->prefix}mnet_rpc2host rh    ON 
-                (h.id=rh.host_id AND rh.subscribe!=0)
+                {$CFG->prefix}mnet_host2service hs    ON 
+                (h.id=hs.hostid AND hs.subscribe!=0)
             LEFT OUTER JOIN 
                 {$CFG->prefix}mnet_service2rpc sr ON 
-                sr.rpcid=rh.rpc_id
+                sr.serviceid=hs.serviceid
             LEFT OUTER JOIN 
                 {$CFG->prefix}mnet_service s      ON 
                 (sr.serviceid=s.id AND s.name='sso')";
-- 
2.39.5