| commit | author | age | ||
| 3e2637 | 1 | #!/usr/bin/env php |
| T | 2 | <?php |
| 3 | /* | |
| 4 | +-----------------------------------------------------------------------+ | |
| 5 | | bin/indexcontacts.sh | | |
| 6 | | | | |
| 7 | | This file is part of the Roundcube Webmail client | | |
| 8 | | Copyright (C) 2011, The Roundcube Dev Team | | |
| 7fe381 | 9 | | | |
| T | 10 | | Licensed under the GNU General Public License version 3 or | |
| 11 | | any later version with exceptions for skins & plugins. | | |
| 12 | | See the README file for a full license statement. | | |
| 3e2637 | 13 | | | |
| T | 14 | | PURPOSE: | |
| 15 | | Update the fulltext index for all contacts of the internal | | |
| 16 | | address book. | | |
| 17 | +-----------------------------------------------------------------------+ | |
| 18 | | Author: Thomas Bruederli <roundcube@gmail.com> | | |
| 19 | +-----------------------------------------------------------------------+ | |
| 20 | */ | |
| 21 | ||
| 22 | define('INSTALL_PATH', realpath(dirname(__FILE__) . '/..') . '/' ); | |
| 23 | ||
| 24 | require_once INSTALL_PATH.'program/include/clisetup.php'; | |
| 4aafd9 | 25 | ini_set('memory_limit', -1); |
| 3e2637 | 26 | |
| T | 27 | // connect to DB |
| 28 | $RCMAIL = rcmail::get_instance(); | |
| 29 | ||
| 30 | $db = $RCMAIL->get_dbh(); | |
| 31 | $db->db_connect('w'); | |
| 32 | ||
| f23ef1 | 33 | if (!$db->is_connected() || $db->is_error()) { |
| AM | 34 | rcube::raise_error("No DB connection", false, true); |
| 35 | } | |
| 3e2637 | 36 | |
| T | 37 | // iterate over all users |
| 399db1 | 38 | $sql_result = $db->query("SELECT user_id FROM " . $db->table_name('users') . " ORDER BY user_id"); |
| 3e2637 | 39 | while ($sql_result && ($sql_arr = $db->fetch_assoc($sql_result))) { |
| T | 40 | echo "Indexing contacts for user " . $sql_arr['user_id'] . "..."; |
| f23ef1 | 41 | |
| 3e2637 | 42 | $contacts = new rcube_contacts($db, $sql_arr['user_id']); |
| T | 43 | $contacts->set_pagesize(9999); |
| f23ef1 | 44 | |
| 3e2637 | 45 | $result = $contacts->list_records(); |
| T | 46 | while ($result->count && ($row = $result->next())) { |
| 47 | unset($row['words']); | |
| 48 | $contacts->update($row['ID'], $row); | |
| 49 | } | |
| 4aafd9 | 50 | |
| 3e2637 | 51 | echo "done.\n"; |
| T | 52 | } |
| 53 | ||
| 54 | ?> | |
