From 30aa4ccaafb10707c8da72e734d1f59f2c528ce8 Mon Sep 17 00:00:00 2001
From: alecpl <alec@alec.pl>
Date: Tue, 18 May 2010 10:32:39 +0000
Subject: - Renamed all php-cli scripts to use .sh extension

---
 bin/cleandb.php | 80 ---------------------------------------------------------
 1 file changed, 80 deletions(-)
 delete mode 100755 bin/cleandb.php

(limited to 'bin/cleandb.php')

diff --git a/bin/cleandb.php b/bin/cleandb.php
deleted file mode 100755
index 79d0b6510..000000000
--- a/bin/cleandb.php
+++ /dev/null
@@ -1,80 +0,0 @@
-#!/usr/bin/env php
-<?php
-/*
-
- +-----------------------------------------------------------------------+
- | bin/cleandb.php                                                       |
- |                                                                       |
- | This file is part of the RoundCube Webmail client                     |
- | Copyright (C) 2010, RoundCube Dev. - Switzerland                      |
- | Licensed under the GNU GPL                                            |
- |                                                                       |
- | 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';
-
-// mapping for table name => primary key
-$primary_keys = array(
-    'contacts' => "contact_id",
-    'contactgroups' => "contactgroup_id",
-);
-
-// connect to DB
-$RCMAIL = rcmail::get_instance();
-$db = $RCMAIL->get_dbh();
-
-if (!$db->is_connected() || $db->is_error)
-    die("No DB connection");
-
-if (!empty($_SERVER['argv'][1]))
-    $days = intval($_SERVER['argv'][1]);
-else
-    $days = 7;
-
-// remove all deleted records older than two days
-$threshold = date('Y-m-d 00:00:00', time() - $days * 86400);
-
-foreach (array('contacts','contactgroups','identities') as $table) {
-
-    $sqltable = get_table_name($table);
-
-    // also delete linked records
-    // could be skipped for databases which respect foreign key constraints
-    if ($db->db_provider == 'sqlite'
-        && ($table == 'contacts' || $table == 'contactgroups')
-    ) {
-        $pk = $primary_keys[$table];
-        $memberstable = get_table_name('contactgroupmembers');
-
-        $db->query(
-            "DELETE FROM $memberstable".
-            " WHERE $pk IN (".
-                "SELECT $pk FROM $sqltable".
-                " WHERE del=1 AND changed < ?".
-            ")",
-            $threshold);
-
-        echo $db->affected_rows() . " records deleted from '$memberstable'\n";
-    }
-
-    // delete outdated records
-    $db->query("DELETE FROM $sqltable WHERE del=1 AND changed < ?", $threshold);
-
-    echo $db->affected_rows() . " records deleted from '$table'\n";
-}
-
-?>
-- 
cgit v1.2.3