Moving to GitHub.

[platal.git] / bin / search.rebuild_db.php

diff --git a/bin/search.rebuild_db.php b/bin/search.rebuild_db.php
index 966287e..be34531 100755 (executable)
--- a/bin/search.rebuild_db.php
+++ b/bin/search.rebuild_db.php
@@ -1,7 +1,7 @@
 #!/usr/bin/php5 -q
 <?php
 /***************************************************************************
- *  Copyright (C) 2003-2010 Polytechnique.org                              *
+ *  Copyright (C) 2003-2014 Polytechnique.org                              *
  *  http://opensource.polytechnique.org/                                   *
  *                                                                         *
  *  This program is free software; you can redistribute it and/or modify   *
@@ -20,21 +20,28 @@
  *  59 Temple Place, Suite 330, Boston, MA  02111-1307  USA                *
  ***************************************************************************/
 
-require('./connect.db.inc.php');
+require './connect.db.inc.php';
 
-ini_set('memory_limit', "16M");
-$globals->debug = 0; // Do not store backtraces
-
-$res = XDB::iterRow("SELECT  user_id
-                       FROM  auth_user_md5");
+$res = XDB::iterRow('SELECT  pid
+                       FROM  profiles');
 $i = 0;
 $n = $res->total();
-while ($uid = $res->next()->fetchOneCell()) {
-    Profile::rebuildSearchTokens($uid);
-    printf("\r%u / %u",  ++$i, $n);
+$pids = array();
+while ($pid = $res->next()) {
+    $pids[] = intval($pid[0]);
+    ++$i;
+    if (count($pids) == 100) {
+        Profile::rebuildSearchTokens($pids);
+        printf("\r%u / %u",  $i, $n);
+        $pids = array();
+    }
+}
+if (count($pids) > 0) {
+    Profile::rebuildSearchTokens($pids);
+    printf("\r%u / %u",  $i, $n);
 }
 
 print "done\n";
 
-// vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
+// vim:set et sw=4 sts=4 sws=4 foldmethod=marker fenc=utf-8:
 ?>