From 931ab7be83b04b07b5f1fad77b28db0af3c5fd95 Mon Sep 17 00:00:00 2001 From: mjollnir_ Date: Sun, 24 Sep 2006 07:15:22 +0000 Subject: [PATCH] fixes to activity stats processing for dailies --- lib/statslib.php | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) diff --git a/lib/statslib.php b/lib/statslib.php index 3a67618784..baccc00990 100644 --- a/lib/statslib.php +++ b/lib/statslib.php @@ -186,17 +186,19 @@ function stats_cron_daily () { $stat->timeend = $nextmidnight; $stat->stattype = 'activity'; - $sql = 'SELECT COUNT(DISTINCT prs.userid) FROM ('.$primary_roles.') prs + $sql = 'SELECT COUNT(DISTINCT l.id) FROM ('.$primary_roles.') prs INNER JOIN '.$CFG->prefix.'log l ON (prs.userid=l.userid AND l.course=prs.courseid) WHERE prs.primary_roleid='.$role->id.' AND prs.courseid='.$course->id.' AND prs.contextlevel = '.CONTEXT_COURSE.' AND '.$timesql.' '.stats_get_action_sql_in('view'); $stat->stat1 = count_records_sql($sql); - $sql = 'SELECT COUNT(DISTINCT prs.userid) FROM ('.$primary_roles.') prs + + $sql = 'SELECT COUNT(DISTINCT l.id) FROM ('.$primary_roles.') prs INNER JOIN '.$CFG->prefix.'log l ON (prs.userid=l.userid AND l.course=prs.courseid) WHERE prs.primary_roleid='.$role->id.' AND prs.courseid='.$course->id.' AND prs.contextlevel = '.CONTEXT_COURSE.' AND '.$timesql.' '.stats_get_action_sql_in('post'); $stat->stat2 = count_records_sql($sql); + insert_record('stats_daily',$stat,false); // don't worry about the return id, we don't need it. } -- 2.39.5