[geeklog-cvs] geeklog: Removed toinnodb.php script - functionality has been ro...

[geeklog-cvs at lists.geeklog.net]

changeset 7417:7f9887d0ea71
url:  http://project.geeklog.net/cgi-bin/hgwebdir.cgi/geeklog/rev/7f9887d0ea71
user: Dirk Haun <dirk at haun-online.de>
date: Sat Sep 26 22:20:05 2009 +0200
description:
Removed toinnodb.php script - functionality has been rolled into the Database Backups admin panel

diffstat:

 public_html/admin/install/toinnodb.php |  116 --------------------------------------
 1 files changed, 0 insertions(+), 116 deletions(-)

diffs (120 lines):

diff -r ace128f1bd0b -r 7f9887d0ea71 public_html/admin/install/toinnodb.php
--- a/public_html/admin/install/toinnodb.php	Sat Sep 26 22:19:20 2009 +0200
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,116 +0,0 @@
-<?php
-
-/* Reminder: always indent with 4 spaces (no tabs). */
-// +---------------------------------------------------------------------------+
-// | Geeklog 1.6                                                               |
-// +---------------------------------------------------------------------------+
-// | toinnodb.php                                                              |
-// |                                                                           |
-// | Change Geeklog tables from MyISAM to InnoDB.                              |
-// +---------------------------------------------------------------------------+
-// | Copyright (C) 2004-2009 by the following authors:                         |
-// |                                                                           |
-// | Authors: Dirk Haun - dirk AT haun-online DOT de                           |
-// +---------------------------------------------------------------------------+
-// |                                                                           |
-// | This program is free software; you can redistribute it and/or             |
-// | modify it under the terms of the GNU General Public License               |
-// | as published by the Free Software Foundation; either version 2            |
-// | of the License, or (at your option) any later version.                    |
-// |                                                                           |
-// | This program is distributed in the hope that it will be useful,           |
-// | but WITHOUT ANY WARRANTY; without even the implied warranty of            |
-// | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the             |
-// | GNU General Public License for more details.                              |
-// |                                                                           |
-// | You should have received a copy of the GNU General Public License         |
-// | along with this program; if not, write to the Free Software Foundation,   |
-// | Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.           |
-// |                                                                           |
-// +---------------------------------------------------------------------------+
-
-require_once '../../lib-common.php';
-
-// bail if user isn't a Root user
-if (!SEC_inGroup('Root')) {
-    $display = COM_siteHeader('menu', $MESSAGE[30])
-             . COM_showMessageText($LANG20[6], $MESSAGE[30])
-             . COM_siteFooter();
-    COM_accessLog('User ' . COM_getDisplayName() . ' tried to illegally access the optimize database screen.');
-    COM_output($display);
-    exit;
-}
-
-/**
-* Check for InnoDB table support (usually as of MySQL 4.0, but may be
-* available in earlier versions, e.g. "Max" or custom builds).
-*
-* @return   true = InnoDB tables supported, false = not supported
-*
-*/
-function innodb_supported()
-{
-    global $_DB_dbms;
-
-    $retval = false;
-
-    if ($_DB_dbms == 'mysql') {
-        $result = DB_query("SHOW VARIABLES LIKE 'have_innodb'");
-        $A = DB_fetchArray($result, true);
-
-        if (strcasecmp($A[1], 'yes') == 0) {
-            $retval = true;
-        }
-    }
-
-    return $retval;
-}
-
-
-// MAIN
-
-echo COM_siteHeader('menu', 'Changing tables to InnoDB');
-echo COM_startBlock('Changing tables to InnoDB');
-
-if (innodb_supported()) {
-
-    echo '<p>This may take a while ...</p>' . LB;
-    flush();
-
-    $opt_time = new timerobject();
-    $opt_time->startTimer();
-
-    DB_displayError(true);
-
-    $result = DB_query("SHOW TABLES");
-    $numTables = DB_numRows($result);
-    for ($i = 0; $i < $numTables; $i++) {
-        $A = DB_fetchArray($result, true);
-        if (in_array($A[0], $_TABLES)) {
-            $make_innodb = DB_query("ALTER TABLE $A[0] TYPE=InnoDB", 1);
-            if ($make_innodb === false) {
-                echo '<p>SQL error for table "' . $A[0] . '" (ignored): '
-                     . DB_error() . '</p>' . LB;
-                flush();
-            }
-        }
-    }
-
-    DB_delete($_TABLES['vars'], 'name', 'database_engine');
-    DB_query("INSERT INTO {$_TABLES['vars']} (name, value) VALUES ('database_engine', 'InnoDB')");
-
-    $exectime = $opt_time->stopTimer();
-
-    echo '<p>Changing ' . count($_TABLES) . ' tables to InnoDB took '
-         . $exectime . ' seconds.<p>' . LB;
-
-} else {
-
-    echo '<p>Sorry, your database does not support InnoDB tables.</p>' . LB;
-
-}
-
-echo COM_endBlock();
-echo COM_siteFooter();
-
-?>