fluxbb/admin_maintenance.php

   1 <?php
   2 /***********************************************************************
   3
   4   Copyright (C) 2002-2005  Rickard Andersson (rickard@punbb.org)
   5
   6   This file is part of PunBB.
   7
   8   PunBB is free software; you can redistribute it and/or modify it
   9   under the terms of the GNU General Public License as published
  10   by the Free Software Foundation; either version 2 of the License,
  11   or (at your option) any later version.
  12
  13   PunBB is distributed in the hope that it will be useful, but
  14   WITHOUT ANY WARRANTY; without even the implied warranty of
  15   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  16   GNU General Public License for more details.
  17
  18   You should have received a copy of the GNU General Public License
  19   along with this program; if not, write to the Free Software
  20   Foundation, Inc., 59 Temple Place, Suite 330, Boston,
  21   MA  02111-1307  USA
  22
  23 ************************************************************************/
  24
  25
  26 // Tell header.php to use the admin template
  27 define('PUN_ADMIN_CONSOLE', 1);
  28 // Tell common.php that we don't want output buffering
  29 define('PUN_DISABLE_BUFFERING', 1);
  30
  31 define('PUN_ROOT', './');
  32 require PUN_ROOT.'include/common.php';
  33 require PUN_ROOT.'include/common_admin.php';
  34
  35
  36 if ($pun_user['g_id'] > PUN_ADMIN)
  37         message($lang_common['No permission']);
  38
  39
  40 if (isset($_GET['i_per_page']) && isset($_GET['i_start_at']))
  41 {
  42         $per_page = intval($_GET['i_per_page']);
  43         $start_at = intval($_GET['i_start_at']);
  44         if ($per_page < 1 || $start_at < 1)
  45                 message($lang_common['Bad request']);
  46
  47         @set_time_limit(0);
  48
  49         // If this is the first cycle of posts we empty the search index before we proceed
  50         if (isset($_GET['i_empty_index']))
  51         {
  52                 // This is the only potentially "dangerous" thing we can do here, so we check the referer
  53                 confirm_referrer('admin_maintenance.php');
  54
  55                 $truncate_sql = ($db_type != 'sqlite' && $db_type != 'pgsql') ? 'TRUNCATE TABLE ' : 'DELETE FROM ';
  56                 $db->query($truncate_sql.$db->prefix.'search_matches') or error('Unable to empty search index match table', __FILE__, __LINE__, $db->error());
  57                 $db->query($truncate_sql.$db->prefix.'search_words') or error('Unable to empty search index words table', __FILE__, __LINE__, $db->error());
  58
  59                 // Reset the sequence for the search words (not needed for SQLite)
  60                 switch ($db_type)
  61                 {
  62                         case 'mysql':
  63                         case 'mysqli':
  64                                 $result = $db->query('ALTER TABLE '.$db->prefix.'search_words auto_increment=1') or error('Unable to update table auto_increment', __FILE__, __LINE__, $db->error());
  65                                 break;
  66
  67                         case 'pgsql';
  68                                 $result = $db->query('SELECT setval(\''.$db->prefix.'search_words_id_seq\', 1, false)') or error('Unable to update sequence', __FILE__, __LINE__, $db->error());
  69                 }
  70         }
  71
  72 ?>
  73 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  74
  75 <html>
  76 <head>
  77 <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
  78 <title><?php echo pun_htmlspecialchars($pun_config['o_board_title']) ?> / Reconstruction des index de recherches ...</title>
  79 <style type="text/css">
  80 body {
  81         font: 10px Verdana, Arial, Helvetica, sans-serif;
  82         color: #333333;
  83         background-color: #FFFFFF
  84 }
  85 </style>
  86 </head>
  87 <body>
  88
  89 Reconstruction des index ... C'est peut être le bon moment pour aller prendre un café :-)<br /><br />
  90
  91 <?php
  92
  93         require PUN_ROOT.'include/search_idx.php';
  94
  95         // Fetch posts to process
  96         $result = $db->query('SELECT id FROM '.$db->prefix.'topics WHERE id>='.$start_at.' ORDER BY id LIMIT '.$per_page) or error('Unable to fetch topic list', __FILE__, __LINE__, $db->error());
  97         $topics = array();
  98         while ($cur_topic = $db->fetch_row($result))
  99                 $topics[] = $cur_topic[0];
 100
 101         $result = $db->query('SELECT topic_id, id, message FROM '.$db->prefix.'posts WHERE topic_id IN ('.implode(',', $topics).') ORDER BY topic_id') or error('Unable to fetch topic/post info', __FILE__, __LINE__, $db->error());
 102
 103         $cur_topic = 0;
 104         while ($cur_post = $db->fetch_row($result))
 105         {
 106                 if ($cur_post[0] <> $cur_topic)
 107                 {
 108                         // Fetch subject and ID of first post in topic
 109                         $result2 = $db->query('SELECT p.id, t.subject, MIN(p.posted) AS first FROM '.$db->prefix.'posts AS p INNER JOIN '.$db->prefix.'topics AS t ON t.id=p.topic_id WHERE t.id='.$cur_post[0].' GROUP BY p.id, t.subject ORDER BY first LIMIT 1') or error('Unable to fetch topic info', __FILE__, __LINE__, $db->error());
 110                         list($first_post, $subject) = $db->fetch_row($result2);
 111
 112                         $cur_topic = $cur_post[0];
 113                 }
 114
 115                 echo 'Traitement du message <strong>'.$cur_post[1].'</strong> de la discussion <strong>'.$cur_post[0].'</strong><br />'."\n";
 116
 117                 if ($cur_post[1] == $first_post)        // This is the "topic post" so we have to index the subject as well
 118                         update_search_index('post', $cur_post[1], $cur_post[2], $subject);
 119                 else
 120                         update_search_index('post', $cur_post[1], $cur_post[2]);
 121         }
 122
 123         // Check if there is more work to do
 124         $result = $db->query('SELECT id FROM '.$db->prefix.'topics WHERE id>'.$cur_topic.' ORDER BY id ASC LIMIT 1') or error('Unable to fetch topic info', __FILE__, __LINE__, $db->error());
 125
 126         $query_str = ($db->num_rows($result)) ? '?i_per_page='.$per_page.'&i_start_at='.$db->result($result) : '';
 127
 128         $db->end_transaction();
 129         $db->close();
 130
 131         exit('<script type="text/javascript">window.location="admin_maintenance.php'.$query_str.'"</script><br />La redirection javaScript a échouée. <a href="admin_maintenance.php'.$query_str.'">Cliquez ici</a> pour continuer.');
 132 }
 133
 134
 135 // Get the first post ID from the db
 136 $result = $db->query('SELECT id FROM '.$db->prefix.'topics ORDER BY id LIMIT 1') or error('Unable to fetch topic info', __FILE__, __LINE__, $db->error());
 137 if ($db->num_rows($result))
 138         $first_id = $db->result($result);
 139
 140 $page_title = pun_htmlspecialchars($pun_config['o_board_title']).' / Admin / Maintenance';
 141 require PUN_ROOT.'header.php';
 142
 143 generate_admin_menu('maintenance');
 144
 145 ?>
 146         <div class="blockform">
 147                 <h2><span>Maintenance des Forums</span></h2>
 148                 <div class="box">
 149                         <form method="get" action="admin_maintenance.php">
 150                                 <div class="inform">
 151                                         <fieldset>
 152                                                 <legend>Reconstruction des index de recherches</legend>
 153                                                 <div class="infldset">
 154                                                         <p>Si vous avez ajouté, modifié ou supprimé manuellement des messages dans la base de données ou si vous avez des problèmes avec la  recherche vous devriez reconstruire les index de recherche (supprime les mots inutiles). Pour de meilleures performances, pendant la reconstruction des index, vous devriez mettre vos forums en mode maintenance. <strong>La reconstruction des index de recherches peut prendre beaucoup de temps et augmenter considérablement la charge serveur au cours du processus de reconstruction&nbsp;!</strong></p>
 155                                                         <table class="aligntop" cellspacing="0">
 156                                                                 <tr>
 157                                                                         <th scope="row">Discussions par cycle</th>
 158                                                                         <td>
 159                                                                                 <input type="text" name="i_per_page" size="7" maxlength="7" value="100" tabindex="1" />
 160                                                                                 <span>Le nombre de discussions à traiter par cycle. Si vous saisissez 100, une centaine de discussions sera traitée et ensuite la page sera actualisée. Cela permet d'éviter que le script n'atteigne le temps limite d'exécution pendant le processus de reconstruction.</span>
 161                                                                         </td>
 162                                                                 </tr>
 163                                                                 <tr>
 164                                                                         <th scope="row">ID de la discussion de départ</th>
 165                                                                         <td>
 166                                                                                 <input type="text" name="i_start_at" size="7" maxlength="7" value="<?php echo (isset($first_id)) ? $first_id : 0 ?>" tabindex="2" />
 167                                                                                 <span>L'ID de discussion de laquelle vous souhaitez lancer la reconstruction. La valeur par défaut est le premier ID disponible dans la base de données. Normalement vous ne devriez pas avoir à changer ceci.</span>
 168                                                                         </td>
 169                                                                 </tr>
 170                                                                 <tr>
 171                                                                         <th scope="row">Vider index</th>
 172                                                                         <td class="inputadmin">
 173                                                                                 <span><input type="checkbox" name="i_empty_index" value="1" tabindex="3" checked="checked" />&nbsp;&nbsp;Cochez cette option si vous souhaitez que les index de recherches soient vidés avant la reconstruction (voir ci-dessous).</span>
 174                                                                         </td>
 175                                                                 </tr>
 176                                                         </table>
 177                                                         <p class="topspace">Lorsque le processus sera terminé vous serez redirigé sur cette page. Il est fortement recommandé que Javascript soit activé sur votre navigateur pour effectuer la reconstruction (pour une redirection automatique lorsqu'un cycle est achevé). Si vous êtes obligé d'abandonner le processus de reconstruction, notez l'ID du dernier sujet traité et saisissez cet ID+1 dans le champ "ID de la discussion de départ" quand/si vous reprennez le processus  ("Vider index" ne doit pas être coché).</p>
 178                                                         <div class="fsetsubmit"><input type="submit" name="rebuild_index" value=" Reconstruire index " tabindex="4" /></div>
 179                                                 </div>
 180                                         </fieldset>
 181                                 </div>
 182                         </form>
 183                 </div>
 184         </div>
 185         <div class="clearer"></div>
 186 </div>
 187 <?php
 188
 189 require PUN_ROOT.'footer.php';