diff -r e3d7322305bf -r 5e1f1e916419 punbb/admin/reindex.php
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/punbb/admin/reindex.php Sat Apr 05 23:56:45 2008 -0400
@@ -0,0 +1,252 @@
+ $_ )
+{
+ $$key =& $GLOBALS[$key];
+}
+
+($hook = get_hook('ari_start')) ? eval($hook) : null;
+
+if ($session->user_level < USER_LEVEL_ADMIN)
+ message($lang_common['No permission']);
+
+// The reindexer isn't used for MySQL
+if ($db_type == 'mysql' || $db_type == 'mysqli')
+ message($lang_common['Bad request']);
+
+// Load the admin.php language file
+require PUN_ROOT.'lang/'.$pun_user['language'].'/admin.php';
+$GLOBALS['lang_admin'] = $lang_admin;
+
+
+if (isset($_GET['i_per_page']) && isset($_GET['i_start_at']))
+{
+ $per_page = intval($_GET['i_per_page']);
+ $start_at = intval($_GET['i_start_at']);
+ if ($per_page < 1 || $start_at < 1)
+ message($lang_common['Bad request']);
+
+ ($hook = get_hook('ari_cycle_start')) ? eval($hook) : null;
+
+ @set_time_limit(0);
+
+ // If this is the first cycle of posts we empty the search index before we proceed
+ if (isset($_GET['i_empty_index']))
+ {
+ $query = array(
+ 'DELETE' => 'search_matches'
+ );
+
+ ($hook = get_hook('ari_qr_empty_search_matches')) ? eval($hook) : null;
+ $pun_db->query_build($query) or error(__FILE__, __LINE__);
+
+ $query = array(
+ 'DELETE' => 'search_words'
+ );
+
+ ($hook = get_hook('ari_qr_empty_search_words')) ? eval($hook) : null;
+ $pun_db->query_build($query) or error(__FILE__, __LINE__);
+
+ // Reset the sequence for the search words (not needed for SQLite)
+ if ($db_type == 'pgsql')
+ $result = $pun_db->query('SELECT setval(\''.$pun_db->prefix.'search_words_id_seq\', 1, false)') or error(__FILE__, __LINE__);
+ }
+
+?>
+
+
+
+
+
+
+<?php echo htmlspecialchars($pun_config['o_board_title']) ?> - Rebuilding search index …
+
+
+
+
+
+
+ 'p.id, p.message, t.id, t.subject, t.first_post_id',
+ 'FROM' => 'posts AS p',
+ 'JOINS' => array(
+ array(
+ 'INNER JOIN' => 'topics AS t',
+ 'ON' => 't.id=p.topic_id'
+ )
+ ),
+ 'WHERE' => 'p.id>='.$start_at,
+ 'ORDER BY' => 'p.id',
+ 'LIMIT' => $per_page
+ );
+
+ ($hook = get_hook('ari_qr_fetch_posts')) ? eval($hook) : null;
+ $result = $pun_db->query_build($query) or error(__FILE__, __LINE__);
+
+ $post_id = 0;
+ echo '';
+ while ($cur_post = $pun_db->fetch_row($result))
+ {
+ printf($lang_admin['Processing post'], $cur_post[0], $cur_post[2]).'
'."\n";
+
+ if ($cur_post[0] == $cur_post[4]) // This is the "topic post" so we have to index the subject as well
+ update_search_index('post', $cur_post[0], $cur_post[1], $cur_post[3]);
+ else
+ update_search_index('post', $cur_post[0], $cur_post[1]);
+
+ $post_id = $cur_post[0];
+ }
+ echo '
';
+
+ // Check if there is more work to do
+ $query = array(
+ 'SELECT' => 'p.id',
+ 'FROM' => 'posts AS p',
+ 'WHERE' => 'p.id>'.$post_id,
+ 'ORDER BY' => 'p.id',
+ 'LIMIT' => '1'
+ );
+
+ ($hook = get_hook('ari_qr_find_next_post')) ? eval($hook) : null;
+ $result = $pun_db->query_build($query) or error(__FILE__, __LINE__);
+
+ $query_str = ($pun_db->num_rows($result)) ? '?i_per_page='.$per_page.'&i_start_at='.$pun_db->result($result) : '';
+
+ ($hook = get_hook('ari_cycle_end')) ? eval($hook) : null;
+
+ $pun_db->end_transaction();
+ $pun_db->close();
+
+ exit('
'.$lang_admin['Javascript redirect'].' '.$lang_admin['Click to continue'].'.');
+}
+
+
+// Get the first post ID from the db
+$query = array(
+ 'SELECT' => 'p.id',
+ 'FROM' => 'posts AS p',
+ 'ORDER BY' => 'p.id',
+ 'LIMIT' => '1'
+);
+
+($hook = get_hook('ari_qr_find_lowest_post_id')) ? eval($hook) : null;
+$result = $pun_db->query_build($query) or error(__FILE__, __LINE__);
+if ($pun_db->num_rows($result))
+ $first_id = $pun_db->result($result);
+
+// Setup form
+$pun_page['set_count'] = $pun_page['fld_count'] = 0;
+
+// Setup breadcrumbs
+$pun_page['crumbs'] = array(
+ array($pun_config['o_board_title'], pun_link($pun_url['index'])),
+ array($lang_admin['Forum administration'], pun_link($pun_url['admin_index'])),
+ $lang_admin['Rebuild index']
+);
+
+define('PUN_PAGE_SECTION', 'management');
+define('PUN_PAGE', 'admin-reindex');
+require PUN_ROOT.'header.php';
+
+?>
+
+