Subversion Repositories Applications.papyrus

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
831 florian 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
?>