| | |
| | | #!/usr/bin/env php |
| | | <?php |
| | | /* |
| | | |
| | | +-----------------------------------------------------------------------+ |
| | | | bin/cleandb.sh | |
| | | | | |
| | | | This file is part of the Roundcube Webmail client | |
| | | | Copyright (C) 2010, The Roundcube Dev Team | |
| | | | Licensed under the GNU GPL | |
| | | | | |
| | | | Licensed under the GNU General Public License version 3 or | |
| | | | any later version with exceptions for skins & plugins. | |
| | | | See the README file for a full license statement. | |
| | | | | |
| | | | PURPOSE: | |
| | | | Finally remove all db records marked as deleted some time ago | |
| | |
| | | +-----------------------------------------------------------------------+ |
| | | | Author: Thomas Bruederli <roundcube@gmail.com> | |
| | | +-----------------------------------------------------------------------+ |
| | | |
| | | $Id$ |
| | | |
| | | */ |
| | | |
| | | if (php_sapi_name() != 'cli') { |
| | | die('Not on the "shell" (php-cli).'); |
| | | } |
| | | |
| | | define('INSTALL_PATH', realpath(dirname(__FILE__) . '/..') . '/' ); |
| | | require INSTALL_PATH.'program/include/iniset.php'; |
| | | |
| | | require INSTALL_PATH.'program/include/clisetup.php'; |
| | | |
| | | // mapping for table name => primary key |
| | | $primary_keys = array( |
| | |
| | | $db = $RCMAIL->get_dbh(); |
| | | $db->db_connect('w'); |
| | | |
| | | if (!$db->is_connected() || $db->is_error()) |
| | | die("No DB connection\n"); |
| | | if (!$db->is_connected() || $db->is_error()) { |
| | | rcube::raise_error("No DB connection", false, true); |
| | | } |
| | | |
| | | if (!empty($_SERVER['argv'][1])) |
| | | $days = intval($_SERVER['argv'][1]); |
| | |
| | | |
| | | foreach (array('contacts','contactgroups','identities') as $table) { |
| | | |
| | | $sqltable = get_table_name($table); |
| | | $sqltable = $db->table_name($table); |
| | | |
| | | // also delete linked records |
| | | // could be skipped for databases which respect foreign key constraints |