admin/upgradelogs.php

   1 <?PHP  //$Id$
   2
   3     require_once('../config.php');
   4     require_once($CFG->libdir.'/adminlib.php');
   5
   6     admin_externalpage_setup('upgradelogs');
   7
   8     $confirm = optional_param('confirm', 0, PARAM_BOOL);
   9
  10     if ($CFG->version < 2004013101) {
  11         error("This script does not work with this old version of Moodle");
  12     }
  13
  14     if (!$site = get_site()) {
  15         redirect("index.php");
  16     }
  17
  18 /// Turn off time limits, sometimes upgrades can be slow.
  19
  20     @set_time_limit(0);
  21     @ob_implicit_flush(true);
  22     while(@ob_end_flush());
  23
  24
  25 /// Print header
  26
  27     $strupgradinglogs  = get_string("upgradinglogs", "admin");
  28     admin_externalpage_print_header();
  29     print_heading($strupgradinglogs);
  30
  31     if (!data_submitted() or empty($confirm) or !confirm_sesskey()) {
  32         $optionsyes = array('confirm'=>'1', 'sesskey'=>sesskey());
  33         notice_yesno(get_string('upgradeforumreadinfo', 'admin'),
  34                     'upgradelogs.php', 'index.php', $optionsyes, NULL, 'post', 'get');
  35         admin_externalpage_print_footer();
  36         exit;
  37     }
  38
  39
  40 /// Try and extract as many cmids as possible from the existing logs
  41
  42     if ($coursemodules = get_records_sql("SELECT cm.*, m.name
  43                                             FROM {$CFG->prefix}course_modules cm,
  44                                                  {$CFG->prefix}modules m
  45                                             WHERE cm.module = m.id")) {
  46         $cmcount = count($coursemodules);
  47         $count = 0;
  48         $starttime = time();
  49         $sleeptime = 0;
  50
  51         $LIKE = sql_ilike();
  52
  53         if ($cmcount > 10) {
  54             print_simple_box('This process may take a very long time ... please be patient and let it finish.',
  55                              'center', '', '#ffcccc');
  56             $sleeptime = 1;
  57         }
  58         foreach ($coursemodules as $cm) {
  59
  60             switch ($cm->name) {
  61                 case "forum":
  62                     execute_sql("UPDATE {$CFG->prefix}log SET cmid = '$cm->id'
  63                                  WHERE module = '$cm->name' AND url = 'view.php?id=$cm->id'", false);
  64
  65                     execute_sql("UPDATE {$CFG->prefix}log SET cmid = '$cm->id'
  66                                  WHERE module = '$cm->name' AND url = 'view.php?f=$cm->instance'", false);
  67
  68                     if ($discussions = get_records("forum_discussions", "forum", $cm->instance)) {
  69                         foreach ($discussions as $discussion) {
  70                             execute_sql("UPDATE {$CFG->prefix}log SET cmid = '$cm->id'
  71                                          WHERE module = '$cm->name' AND url $LIKE 'discuss.php?d=$discussion->id%'", false);
  72                         }
  73                     }
  74                     break;
  75
  76                 case "glossary":
  77                     execute_sql("UPDATE {$CFG->prefix}log SET cmid = '$cm->id'
  78                                  WHERE module = '$cm->name' AND url $LIKE 'view.php?id=$cm->id%'", false);
  79                     break;
  80
  81                 case "quiz":
  82                     execute_sql("UPDATE {$CFG->prefix}log SET cmid = '$cm->id'
  83                                  WHERE module = '$cm->name' AND url = 'view.php?id=$cm->id'", false);
  84                     break;
  85
  86                 case "assignment":
  87                     execute_sql("UPDATE {$CFG->prefix}log SET cmid = '$cm->id'
  88                                  WHERE module = '$cm->name' AND url = 'view.php?id=$cm->id'", false);
  89                     execute_sql("UPDATE {$CFG->prefix}log SET cmid = '$cm->id'
  90                                  WHERE module = '$cm->name' AND url = 'view.php?a=$cm->instance'", false);
  91                     execute_sql("UPDATE {$CFG->prefix}log SET cmid = '$cm->id'
  92                                  WHERE module = '$cm->name' AND url = 'submissions.php?id=$cm->instance'", false);
  93                     break;
  94
  95                 case "journal":
  96                     execute_sql("UPDATE {$CFG->prefix}log SET cmid = '$cm->id'
  97                                  WHERE module = '$cm->name' AND url = 'report.php?id=$cm->id'", false);
  98
  99                     execute_sql("UPDATE {$CFG->prefix}log SET cmid = '$cm->id'
 100                                  WHERE module = '$cm->name' AND url = 'view.php?id=$cm->id'", false);
 101                     break;
 102
 103             }
 104
 105             $count++;
 106             $elapsedtime = time() - $starttime;
 107             $projectedtime = (int)(((float)$cmcount / (float)$count) * $elapsedtime) - $elapsedtime;
 108
 109             if ($cmcount > 10) {
 110                 notify("Processed $count of $cmcount coursemodules.  Estimated completion: ".format_time($projectedtime));
 111                 flush();
 112                 sleep($sleeptime);     // To help reduce database load
 113             }
 114         }
 115     }
 116
 117     delete_records("config", "name", "upgrade", "value", "logs");
 118
 119     notify('Log upgrading was successful!', 'notifysuccess');
 120
 121     print_continue('index.php');
 122
 123     admin_externalpage_print_footer();
 124
 125 ?>