From da0c90c3135933ee5a38c4d9f141e1ca35c8e7cd Mon Sep 17 00:00:00 2001
From: moodler <moodler>
Date: Fri, 25 Jul 2003 13:23:28 +0000
Subject: [PATCH] Fixed user graphs for site-level, all logs

---
 course/loggraph.php | 10 +++++++++-
 lib/datalib.php     |  7 +++++--
 2 files changed, 14 insertions(+), 3 deletions(-)

diff --git a/course/loggraph.php b/course/loggraph.php
index faf9f10870..e07405cb6a 100644
--- a/course/loggraph.php
+++ b/course/loggraph.php
@@ -34,6 +34,14 @@
     switch ($type) {
      case "usercourse.png":
 
+       $site = get_site();
+        
+       if ($course->id == $site->id) {
+           $courseselect = 0;
+       } else {
+           $courseselect = $course->id;
+       }
+
        $maxseconds = COURSE_MAX_LOG_DISPLAY * 3600 * 24;  // seconds
        if ($timenow - $course->startdate > $maxseconds) {
            $course->startdate = $timenow - $maxseconds;
@@ -63,7 +71,7 @@
            $timestart = $timefinish;
        }
 
-       if ($rawlogs = get_logs_usercourse($user->id, $course->id, $coursestart)) {
+       if ($rawlogs = get_logs_usercourse($user->id, $courseselect, $coursestart)) {
            foreach ($rawlogs as $rawlog) {
                $logs[$rawlog->day] = $rawlog->num;
            }
diff --git a/lib/datalib.php b/lib/datalib.php
index 7ad75db571..2554687764 100644
--- a/lib/datalib.php
+++ b/lib/datalib.php
@@ -1249,11 +1249,14 @@ function get_logs($select, $order) {
 function get_logs_usercourse($userid, $courseid, $coursestart) {
     global $CFG;
 
+    if ($courseid) {
+       $courseselect = " AND course = '$courseid' ";
+    }
+
     return get_records_sql("SELECT floor((`time` - $coursestart)/86400) as day, count(*) as num 
                             FROM {$CFG->prefix}log 
                            WHERE userid = '$userid' 
-                             AND course = '$courseid'
-                             AND `time` > '$coursestart'
+                             AND `time` > '$coursestart' $courseselect
                         GROUP BY day ");
 }
 
-- 
2.39.5