[Sommaire] [Imprimer]

   1  <?php
   2  // rebuild search-table
   3  // this script rebuilds the search-table
   4  
   5  // this needs some time, please make sure that its really needed
   6  // i.e. in case of errors, required updates etc.
   7  
   8  // it only works with the mysql/mysqli-layer.
   9  
  10  // YOU NEED TO MOVE THIS SCRIPT TO YOUR PHORUM-DIRECTORY
  11  
  12  define('phorum_page', 'rebuild_search_table');
  13  
  14  if(!file_exists('./common.php')) {
  15      echo "You didn't move this script to your phorum-directory!\n";
  16      exit();
  17  }
  18  
  19  include  './common.php';
  20  
  21  if (! ini_get('safe_mode')) {
  22      set_time_limit(0);
  23      ini_set("memory_limit","64M");
  24  }
  25  
  26  echo "Rebuilding search-table ...\n";
  27  
  28  $sql=array();
  29  $sql[]="truncate {$PHORUM['search_table']}";
  30  $sql[]="insert into {$PHORUM['search_table']} (message_id,search_text,forum_id) select message_id, concat(author, ' | ', subject, ' | ', body), forum_id from {$PHORUM['message_table']}";
  31  
  32  phorum_db_run_queries($sql);
  33  
  34  flush();
  35  echo "Rebuilding search-table finished successfully if no errors were logged above.\n";
  36  
  37  
  38  ?>