admin/upgradeforumread.php

   1 <?PHP  //$Id$
   2
   3     require_once('../config.php');
   4     require_once($CFG->dirroot.'/mod/forum/lib.php');
   5     require_once($CFG->libdir.'/adminlib.php');
   6
   7     admin_externalpage_setup('upgradeforumread');
   8
   9     $confirm = optional_param('confirm', 0, PARAM_BOOL);
  10
  11     if ($CFG->version < 2005042300) {
  12         error("This script does not work with this old version of Moodle");
  13     }
  14
  15     if (!$site = get_site()) {
  16         redirect('index.php');
  17     }
  18
  19
  20 /// Print header
  21
  22     $strupgradingdata  = get_string('upgradingdata', 'admin');
  23
  24     admin_externalpage_print_header();
  25     print_heading($strupgradingdata);
  26
  27     if (!data_submitted() or empty($confirm) or !confirm_sesskey()) {
  28         $optionsyes = array('confirm'=>'1', 'sesskey'=>sesskey());
  29         notice_yesno(get_string('upgradeforumreadinfo', 'admin'),
  30                     'upgradeforumread.php', 'index.php', $optionsyes, NULL, 'post', 'get');
  31         admin_externalpage_print_footer();
  32         exit;
  33     }
  34
  35
  36 /// Turn off time limits, sometimes upgrades can be slow.
  37
  38     @set_time_limit(0);
  39     @ob_implicit_flush(true);
  40     while(@ob_end_flush());
  41
  42     execute_sql('TRUNCATE TABLE '.$CFG->prefix.'forum_read;', false);   // Trash all old entries
  43
  44 /// Enter initial read records for all posts older than 1 day.
  45
  46 /// Timestamp for old posts (and therefore considered read).
  47     $dateafter = time() - ($CFG->forum_oldpostdays*24*60*60);
  48
  49 /// Timestamp for one day ago.
  50     $onedayago = time() - (24*60*60);
  51
  52
  53 /// Get all discussions that have had posts since the old post date.
  54     if ($discussions = get_records_select('forum_discussions', 'timemodified > '.$dateafter,
  55                                           'course', 'id,course,forum,groupid,userid')) {
  56         $dtotal = count($discussions);
  57         print_heading('Updating forum post read/unread records for '.$dtotal.' discussions...'.
  58                       'Please keep this window open until it completes', '', 3);
  59
  60         $groups = array();
  61
  62         $currcourse = 0;
  63         $users = 0;
  64         $count = 0;
  65         $dcount = 0;
  66
  67         foreach ($discussions as $discussion) {
  68             $dcount++;
  69             print_progress($dcount, $dtotal);
  70
  71             if ($discussion->course != $currcourse) {
  72                 /// Discussions are ordered by course, so we only need to get any course's users once.
  73                 $currcourse = $discussion->course;
  74                 $users = get_course_users($currcourse, '', '', 'u.id,u.confirmed');
  75             }
  76             /// If this course has users, and posts more than a day old, mark them for each user.
  77             if ($users &&
  78                     ($posts = get_records_select('forum_posts', 'discussion = '.$discussion->id.
  79                                                  ' AND '.$dateafter.' < modified AND modified < '.$onedayago,
  80                                                  '', 'id,discussion,modified'))) {
  81                 foreach ($users as $user) {
  82                     /// If its a group discussion, make sure the user is in the group.
  83                     if ($discussion->groupid) {
  84                         if (!isset($groups[$discussion->groupid][$user->id])) {
  85                             $groups[$discussion->groupid][$user->id] = groups_is_member($discussion->groupid, $user->id);
  86                         }
  87                     }
  88                     if (!$discussion->groupid || !empty($groups[$discussion->groupid][$user->id])) {
  89                         foreach ($posts as $post) {
  90                             print_progress($dcount, $dtotal);
  91                             forum_tp_mark_post_read($user->id, $post, $discussion->forum);
  92                         }
  93                     }
  94                 }
  95             }
  96         }
  97         print_progress($dcount, $dtotal, 0);
  98     }
  99
 100
 101     delete_records('config', 'name', 'upgrade', 'value', 'forumread');
 102
 103     notify('Log upgrading was successful!', 'notifysuccess');
 104
 105     print_continue('index.php');
 106
 107     admin_externalpage_print_footer();
 108
 109 ?>