indexcontacts.sh
No OneTemporary
Actions

Size

1 KB

Referenced Files

None

Subscribers

None

indexcontacts.sh
View Options

	#!/usr/bin/env php
	<?php
	/*

	+-----------------------------------------------------------------------+
	\| bin/indexcontacts.sh \|
	\| \|
	\| This file is part of the Roundcube Webmail client \|
	\| Copyright (C) 2011, The Roundcube Dev Team \|
	\| Licensed under the GNU GPL \|
	\| \|
	\| PURPOSE: \|
	\| Update the fulltext index for all contacts of the internal \|
	\| address book. \|
	+-----------------------------------------------------------------------+
	\| Author: Thomas Bruederli <roundcube@gmail.com> \|
	+-----------------------------------------------------------------------+

	$Id$

	*/

	define('INSTALL_PATH', realpath(dirname(__FILE__) . '/..') . '/' );

	require_once INSTALL_PATH.'program/include/clisetup.php';
	ini_set('memory_limit', -1);

	// connect to DB
	$RCMAIL = rcmail::get_instance();

	$db = $RCMAIL->get_dbh();
	$db->db_connect('w');

	if (!$db->is_connected() \|\| $db->is_error())
	die("No DB connection\n");

	// iterate over all users
	$sql_result = $db->query("SELECT user_id FROM " . $RCMAIL->config->get('db_table_users', 'users')." WHERE 1=1");
	while ($sql_result && ($sql_arr = $db->fetch_assoc($sql_result))) {
	echo "Indexing contacts for user " . $sql_arr['user_id'] . "...";

	$contacts = new rcube_contacts($db, $sql_arr['user_id']);
	$contacts->set_pagesize(9999);

	$result = $contacts->list_records();
	while ($result->count && ($row = $result->next())) {
	unset($row['words']);
	$contacts->update($row['ID'], $row);
	}

	echo "done.\n";
	}

	?>