admin/multilangupgrade.php

   1 <?php
   2       /// Search and replace strings throughout all texts in the whole database
   3
   4 define('NO_OUTPUT_BUFFERING', true);
   5
   6 require_once('../config.php');
   7 require_once($CFG->dirroot.'/course/lib.php');
   8 require_once($CFG->libdir.'/adminlib.php');
   9
  10 admin_externalpage_setup('multilangupgrade');
  11
  12 $go = optional_param('go', 0, PARAM_BOOL);
  13
  14 ###################################################################
  15 echo $OUTPUT->header();
  16
  17 echo $OUTPUT->heading(get_string('multilangupgrade', 'admin'));
  18
  19 $strmultilangupgrade = get_String('multilangupgradeinfo', 'admin');
  20
  21 if (!$go or !data_submitted() or !confirm_sesskey()) {   /// Print a form
  22     $optionsyes = array('go'=>1, 'sesskey'=>sesskey());
  23     echo $OUTPUT->confirm($strmultilangupgrade, new moodle_url('multilangupgrade.php', $optionsyes), 'index.php');
  24     echo $OUTPUT->footer();
  25     die;
  26 }
  27
  28
  29 if (!$tables = $DB->get_tables() ) {    // No tables yet at all.
  30     print_error('notables', 'debug');
  31 }
  32
  33 echo $OUTPUT->box_start();
  34
  35 /// Turn off time limits, sometimes upgrades can be slow.
  36
  37 @set_time_limit(0);
  38
  39 echo '<strong>Progress:</strong>';
  40 $i = 0;
  41 $skiptables = array('config', 'user_students', 'user_teachers');
  42
  43 foreach ($tables as $table) {
  44     if (strpos($table,'pma') === 0) { // Not our tables
  45         continue;
  46     }
  47     if (in_array($table, $skiptables)) { // Don't process these
  48         continue;
  49     }
  50     $fulltable = $DB->get_prefix().$table;
  51     if ($columns = $DB->get_columns($table)) {
  52         if (!array_key_exists('id', $columns)) {
  53             continue; // moodle tables have id
  54         }
  55         foreach ($columns as $column => $data) {
  56             if (in_array($data->type, array('text','mediumtext','longtext','varchar'))) {  // Text stuff only
  57                 // first find candidate records
  58                 $sql = "SELECT id, $column FROM $fulltable WHERE $column LIKE '%</lang>%' OR $column LIKE '%<span lang=%'";
  59                 $rs = $DB->get_recordset_sql($sql);
  60                 foreach ($rs as $data) {
  61                     $text = $data->$column;
  62                     $id   = $data->id;
  63                     if ($i % 600 == 0) {
  64                         echo '<br />';
  65                     }
  66                     if ($i % 10 == 0) {
  67                         echo '.';
  68                     }
  69                     $i++;
  70
  71                     if (empty($text) or is_numeric($text)) {
  72                         continue; // nothing to do
  73                     }
  74
  75                     $search = '/(<(?:lang|span) lang="[a-zA-Z0-9_-]*".*?>.+?<\/(?:lang|span)>)(\s*<(?:lang|span) lang="[a-zA-Z0-9_-]*".*?>.+?<\/(?:lang|span)>)+/is';
  76                     $newtext = preg_replace_callback($search, 'multilangupgrade_impl', $text);
  77
  78                     if (is_null($newtext)) {
  79                         continue; // regex error
  80                     }
  81
  82                     if ($newtext != $text) {
  83                         $DB->execute("UPDATE $fulltable SET $column=? WHERE id=?", array($newtext, $id));
  84                     }
  85                 }
  86                 $rs->close();
  87             }
  88         }
  89     }
  90 }
  91
  92 // set conversion flag - switches to new plugin automatically
  93 set_config('filter_multilang_converted', 1);
  94
  95 echo $OUTPUT->box_end();
  96
  97 /// Rebuild course cache which might be incorrect now
  98 echo $OUTPUT->notification('Rebuilding course cache...', 'notifysuccess');
  99 rebuild_course_cache();
 100 echo $OUTPUT->notification('...finished', 'notifysuccess');
 101
 102 echo $OUTPUT->continue_button('index.php');
 103
 104 echo $OUTPUT->footer();
 105 die;
 106
 107
 108 function multilangupgrade_impl($langblock) {
 109     $searchtosplit = '/<(?:lang|span) lang="([a-zA-Z0-9_-]*)".*?>(.+?)<\/(?:lang|span)>/is';
 110     preg_match_all($searchtosplit, $langblock[0], $rawlanglist);
 111     $return = '';
 112     foreach ($rawlanglist[1] as $index=>$lang) {
 113         $return .= '<span lang="'.$lang.'" class="multilang">'.$rawlanglist[2][$index].'</span>';
 114     }
 115     return $return;
 116 }
 117