admin/replace.php

   1 <?php /// $Id$
   2       /// Search and replace strings throughout all texts in the whole database
   3
   4 require_once('../config.php');
   5
   6 $search  = optional_param('search', '', PARAM_RAW);
   7 $replace = optional_param('replace', '', PARAM_RAW);
   8
   9 require_login();
  10
  11 if (!isadmin()) {
  12     error("Admins only");
  13 }
  14
  15 ###################################################################
  16 print_header('Search and replace throughout the whole database', 'Replace text within the whole database');
  17
  18
  19 if (!$search or !$replace or !confirm_sesskey()) {   /// Print a form
  20
  21     print_simple_box_start('center');
  22     echo '<div align="center">';
  23     echo '<form action="replace.php">';
  24     echo '<input type="hidden" name="sesskey" value="'.$USER->sesskey.'">';
  25     echo 'Search whole database for: <input type="text" name="search"><br />';
  26     echo 'Replace with this string: <input type="text" name="replace"><br /></br />';
  27     echo '<input type="submit" value="Yes, do it now"><br />';
  28     echo '</form>';
  29     echo '</div>';
  30     print_simple_box_end();
  31     die;
  32 }
  33
  34
  35 if (!$tables = $db->Metatables() ) {    // No tables yet at all.
  36     error("no tables");
  37 }
  38
  39 print_simple_box_start('center');
  40 foreach ($tables as $table) {
  41     if (in_array($table, array($CFG->prefix.'config'))) {      // Don't process these
  42         continue;
  43     }
  44     if ($columns = $db->MetaColumns($table, false)) {
  45         foreach ($columns as $column => $data) {
  46             if (in_array($data->type, array('text','mediumtext','longtext','varchar'))) {  // Text stuff only
  47                 $db->debug = true;
  48                 execute_sql("UPDATE $table SET $column = REPLACE($column, '$search', '$replace');");
  49                 $db->debug = false;
  50             }
  51         }
  52     }
  53 }
  54 print_simple_box_end();
  55
  56 print_continue('index.php');
  57
  58 ?>