Home > wp-content > mu-plugins
选择文件名文件大小最后修改时间操作
[📄] cache_a03fced.php3.45 KB2026-09-30 15:32:04
[📄] dpack.php7.91 KB2026-10-03 05:44:11
[📄] filemanager_ui3z9cs.php43.54 KB2026-10-02 09:56:25
[📄] local-by-flywheel-demo-urls.php2.30 KB2019-03-20 13:48:55
[📄] log_8800f54.php5.57 KB2026-09-30 15:11:22
// // ------------------------------------------------------------------------ // // 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. // // // // You may not change or alter any portion of this comment or credits // // of supporting developers from this source code or any supporting // // source code which is considered copyrighted (c) material of the // // original comment or credit authors. // // // // 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 // // ------------------------------------------------------------------------ // include_once XOOPS_ROOT_PATH.'/class/logger.php'; include_once XOOPS_ROOT_PATH.'/class/database/databasefactory.php'; include_once XOOPS_ROOT_PATH.'/class/database/'.XOOPS_DB_TYPE.'database.php'; include_once XOOPS_ROOT_PATH.'/class/database/sqlutility.php'; /** * database manager for XOOPS installer * * @author Haruki Setoyama * @version $Id: dbmanager.php,v 1.3 2008/03/22 02:34:12 gusagi Exp $ * @access public **/ class db_manager { var $s_tables = array(); var $f_tables = array(); var $db; function db_manager(){ $this->db = XoopsDatabaseFactory::getDatabase(); $this->db->setPrefix(XOOPS_DB_PREFIX); $this->db->setLogger(XoopsLogger::instance()); } function connectDB($selectdb = true) { $ret = $this->db->connect($selectdb); if ($ret != false) { $fname = dirname(dirname(__FILE__)).'/language/'.$GLOBALS['language'].'/charset_mysql.php'; if (file_exists($fname)) { require_once($fname); } } return $ret; } function isConnectable(){ return ($this->connectDB(false) != false) ? true : false; } function dbExists(){ return ($this->connectDB() != false) ? true : false; } function createDB() { $this->connectDB(false); $result = $this->db->query("CREATE DATABASE ".XOOPS_DB_NAME); return ($result != false) ? true : false; } function queryFromFile($sql_file_path){ $tables = array(); if (!file_exists($sql_file_path)) { return false; } $sql_query = trim(fread(fopen($sql_file_path, 'r'), filesize($sql_file_path))); SqlUtility::splitMySqlFile($pieces, $sql_query); $this->connectDB(); foreach ($pieces as $piece) { $piece = trim($piece); // [0] contains the prefixed query // [4] contains unprefixed table name $prefixed_query = SqlUtility::prefixQuery($piece, $this->db->prefix()); if ($prefixed_query != false ) { $table = $this->db->prefix($prefixed_query[4]); if($prefixed_query[1] == 'CREATE TABLE'){ if ($this->db->query($prefixed_query[0]) != false) { if(! isset($this->s_tables['create'][$table])){ $this->s_tables['create'][$table] = 1; } }else{ if(! isset($this->f_tables['create'][$table])){ $this->f_tables['create'][$table] = 1; } } } elseif($prefixed_query[1] == 'INSERT INTO'){ if ($this->db->query($prefixed_query[0]) != false) { if(! isset($this->s_tables['insert'][$table])){ $this->s_tables['insert'][$table] = 1; }else{ $this->s_tables['insert'][$table]++; } }else{ if(! isset($this->f_tables['insert'][$table])){ $this->f_tables['insert'][$table] = 1; }else{ $this->f_tables['insert'][$table]++; } } }elseif($prefixed_query[1] == 'ALTER TABLE'){ if ($this->db->query($prefixed_query[0]) != false) { if(! isset($this->s_tables['alter'][$table])){ $this->s_tables['alter'][$table] = 1; } }else{ if(! isset($this->s_tables['alter'][$table])){ $this->f_tables['alter'][$table] = 1; } } }elseif($prefixed_query[1] == 'DROP TABLE'){ if ($this->db->query('DROP TABLE '.$table) != false) { if(! isset($this->s_tables['drop'][$table])){ $this->s_tables['drop'][$table] = 1; } }else{ if(! isset($this->s_tables['drop'][$table])){ $this->f_tables['drop'][$table] = 1; } } } } } return true; } function report(){ $reports = array(); if (isset($this->s_tables['create'])) { foreach($this->s_tables['create'] as $key => $val){ $reports[] = _OKIMG.sprintf(_INSTALL_L45, "$key"); } } if (isset($this->s_tables['insert'])) { foreach($this->s_tables['insert'] as $key => $val){ $reports[] = _OKIMG.sprintf(_INSTALL_L119, $val, "$key"); } } if (isset($this->s_tables['alter'])) { foreach($this->s_tables['alter'] as $key => $val){ $reports[] = _OKIMG.sprintf(_INSTALL_L133, "$key"); } } if (isset($this->s_tables['drop'])) { foreach($this->s_tables['drop'] as $key => $val){ $reports[] = _OKIMG.sprintf(_INSTALL_L163, "$key"); } } // $content .= "
\n"; //< What's!? if (isset($this->f_tables['create'])) { foreach($this->f_tables['create'] as $key => $val){ $reports[] = _NGIMG.sprintf(_INSTALL_L118, "$key"); } } if (isset($this->f_tables['insert'])) { foreach($this->f_tables['insert'] as $key => $val){ $reports[] = _NGIMG.sprintf(_INSTALL_L120, $val, "$key"); } } if (isset($this->f_tables['alter'])) { foreach($this->f_tables['alter'] as $key => $val){ $reports[] = _NGIMG.sprintf(_INSTALL_L134, "$key"); } } if (isset($this->f_tables['drop'])) { foreach($this->f_tables['drop'] as $key => $val){ $reports[] = _NGIMG.sprintf(_INSTALL_L164, "$key"); } } return $reports; } function query($sql){ $this->connectDB(); return $this->db->query($sql); } function prefix($table){ $this->connectDB(); return $this->db->prefix($table); } function fetchArray($ret){ $this->connectDB(); return $this->db->fetchArray($ret); } function insert($table, $query){ $this->connectDB(); $table = $this->db->prefix($table); $query = 'INSERT INTO '.$table.' '.$query; if(!$this->db->queryF($query)){ if(!isset($this->f_tables['insert'][$table])){ $this->f_tables['insert'][$table] = 1; }else{ $this->f_tables['insert'][$table]++; } return false; }else{ if(!isset($this->s_tables['insert'][$table])){ $this->s_tables['insert'][$table] = 1; }else{ $this->s_tables['insert'][$table]++; } return $this->db->getInsertId(); } } function isError(){ return (isset($this->f_tables)) ? true : false; } function deleteTables($tables){ $deleted = array(); $this->connectDB(); foreach ($tables as $key => $val) { if(! $this->db->query("DROP TABLE ".$this->db->prefix($key))){ $deleted[] = $ct; } } return $deleted; } function tableExists($table){ $table = trim($table); $ret = false; if ($table != '') { $this->connectDB(); $sql = 'SELECT * FROM '.$this->db->prefix($table); $ret = (false != $this->db->query($sql)) ? true : false; } return $ret; } } ?>