From 9859e26cc092edd8e3312e8eb17e292c1c9fda99 Mon Sep 17 00:00:00 2001
From: jamiesensei <jamiesensei>
Date: Thu, 24 Jul 2008 17:45:01 +0000
Subject: [PATCH] MDL-14208 "add cron routine to clean up cache records"

---
 mod/quiz/report/statistics/cron.php       | 15 +++++++++++++++
 mod/quiz/report/statistics/db/upgrade.php | 20 ++++++++++++++++++++
 mod/quiz/report/statistics/version.php    |  2 +-
 3 files changed, 36 insertions(+), 1 deletion(-)
 create mode 100644 mod/quiz/report/statistics/cron.php
 create mode 100644 mod/quiz/report/statistics/db/upgrade.php

diff --git a/mod/quiz/report/statistics/cron.php b/mod/quiz/report/statistics/cron.php
new file mode 100644
index 0000000000..0c4537b04b
--- /dev/null
+++ b/mod/quiz/report/statistics/cron.php
@@ -0,0 +1,15 @@
+<?php  // $Id$
+function quiz_report_statistics_cron(){
+    global $DB;
+    if ($todelete = $DB->get_records_select_menu('quiz_statistics', 'timemodified < ?', array(time()-5*HOURSECS))){
+        list($todeletesql, $todeleteparams) = $DB->get_in_or_equal($todelete);
+        if (!$DB->delete_records_select('quiz_statistics', "id $todeletesql", $todeleteparams)){
+            mtrace('Error deleting out of date quiz_statistics records.');
+        }
+        if (!$DB->delete_records_select('quiz_question_statistics', "quizstatisticsid $todeletesql", $todeleteparams)){
+            mtrace('Error deleting out of date quiz_question_statistics records.');
+        }
+    }
+    return true;
+}
+?>
diff --git a/mod/quiz/report/statistics/db/upgrade.php b/mod/quiz/report/statistics/db/upgrade.php
new file mode 100644
index 0000000000..23c5e2f65b
--- /dev/null
+++ b/mod/quiz/report/statistics/db/upgrade.php
@@ -0,0 +1,20 @@
+<?php  // $Id$
+
+function xmldb_quizreport_statistics_upgrade($oldversion=0) {
+
+    global $DB;
+    
+    $dbman = $DB->get_manager();
+
+    $result = true;
+
+//===== 1.9.0 upgrade line ======//
+
+    if ($result && $oldversion < 2008072401) {
+        //register cron to run every 5 hours.
+        $result = $result && $DB->set_field('quiz_report', 'cron', HOURSECS*5, array('name'=>'statistics'));
+    }
+    return $result;
+}
+
+?>
diff --git a/mod/quiz/report/statistics/version.php b/mod/quiz/report/statistics/version.php
index 45cd43c6f5..f872ee95f1 100644
--- a/mod/quiz/report/statistics/version.php
+++ b/mod/quiz/report/statistics/version.php
@@ -1,4 +1,4 @@
 <?php
-$plugin->version  = 2008072400;   // The (date) version of this module
+$plugin->version  = 2008072401;   // The (date) version of this module
 
 ?>
\ No newline at end of file
-- 
2.39.5