Changeset 1865

Timestamp:

08/21/07 02:14:13 (1 year ago)

Author:

anarcat

Message:

remove the size_db cache, it wasn't used in the code and is fully accessible from the PHP/MySQL API

Files:

• alternc/trunk/install/mysql.sql (modified) (1 diff)
• alternc/trunk/install/upgrades/0.9.7.sql (added)
• alternc/trunk/src/spoolsize.php (modified) (1 diff)

alternc/trunk/install/mysql.sql

@@ -440 +440 @@
-
--- --------------------------------------------------------
--- TABLES de mémorisation de la taille des dossiers web/mail/db
-
-CREATE TABLE IF NOT EXISTS `size_db` (
-  `db` varchar(255) NOT NULL default '',
-  `size` int(10) unsigned NOT NULL default '0',
-  `ts` timestamp(14) NOT NULL,
-  PRIMARY KEY  (`db`),
-  KEY `ts` (`ts`)
-) TYPE=MyISAM COMMENT='MySQL Database used space';
-
-
--- --------------------------------------------------------
-CREATE TABLE IF NOT EXISTS `size_mail` (
-  `alias` varchar(255) NOT NULL default '',

alternc/trunk/src/spoolsize.php

@@ -15 +15 @@
-}
-
-echo "---------------------------\n Generating size-cache for db accounts\n\n";
-$r=mysql_query("SELECT db FROM db;");
-while ($c=mysql_fetch_array($r)) {
-  echo $c["db"]; flush();
-  $size=$mysql->get_db_size($c["db"]);
-  mysql_query("REPLACE INTO size_db SET db='".addslashes($c["db"])."',size='$size';");
-  echo " done ($size KB) \n"; flush();
-}
-
-echo "---------------------------\n Generating size-cache for web accounts\n\n";
-$r=mysql_query("SELECT uid,login FROM membres;");