编辑 upgrade22.class.php - 文件管理器

✏️ 编辑：upgrade22.class.php

路径：/virtual/bigbrother/public_html/edream-c.com/extras/extra_preload/upgrade22.class.php

大小：3.16 KB · 修改：2013-09-07 07:17:41 · 权限：0644 · 可写

<?php

if(! defined('XOOPS_ROOT_PATH')) exit();

if(alterChangeColumn()==false){
	echo 'unable to alter change column for XCL2.2 upgrade';die();
}
if(alterModulesTable()==false){
	echo 'unable to alter modules table for XCL2.2 upgrade';die();
}
if(insertXoopsConfig()==false){
	echo 'unable to insert cool_uri config for XCL2.2 upgrade';die();
}

function alterChangeColumn()
{
	$db = _getDB();

$column = array(
        array('bannerclient','email'),
        array('config','conf_title'),
        array('config','conf_desc'),
        array('users','email'),
    );

foreach($column as $value) {
        $alterSql = 'ALTER TABLE `' . $db->prefix($value[0]) . '` MODIFY ' . $value[1] . ' VARCHAR(255) DEFAULT ""';
        if (!$db->queryF($alterSql)) {
            _error_message($db);
            return false;
        }
    }

return true;
}

function alterModulesTable()
{
	$db = _getDB();

$checkSql = 'DESC `'.$db->prefix('modules').'`';

$alterSql = 'ALTER TABLE `'.$db->prefix('modules').'` ADD `role` VARCHAR( 15 ) NOT NULL default "" AFTER `dirname`, ADD `trust_dirname` VARCHAR( 25 ) NOT NULL default "" AFTER `dirname`';

$resultC = $db->queryF($checkSql);
	$cols = $db->fetchArray($resultC);
	while($row = $db->fetchArray($resultC)) {
		if($row['Field']=='trust_dirname'){
			return true;
		}
	}
    
    if (!$db->queryF($alterSql)) {
        _error_message($db);
        return false;
    }
    
    return true;
}

function insertXoopsConfig()
{
	$db = _getDB();

$checkSql = 'SELECT COUNT(*) FROM `'.$db->prefix('config').'` WHERE `conf_name`="cool_uri"';
	$insertSql = 'INSERT INTO `'.$db->prefix('config').'` VALUES (48,0,1,"cool_uri","_MD_AM_COOLURI","0","_MD_AM_COOLURIDSC","yesno","int",17)';

$resultC = $db->queryF($checkSql);
	if($row = $db->fetchArray($resultC)){
		if($row['COUNT(*)']>0){
			return true;
		}
	}
	
    if (!$db->queryF($insertSql)) {
        $insertSql = 'INSERT INTO `'.$db->prefix('config').'` VALUES (null,0,1,"cool_uri","_MD_AM_COOLURI","0","_MD_AM_COOLURIDSC","yesno","int",17)';
        if (!$db->queryF($insertSql)) {
            _error_message($db);
            return false;
        }
    }
    
    return true;
}

/**
 * Create the instance of DataBase class, and set it to member property.
 * @access protected
 */
function _getDB()
{
	require_once XOOPS_ROOT_PATH . '/class/logger.php';
	$root = XCube_Root::getSingleton();
	if(!defined('XOOPS_DB_CHKREF'))
		define('XOOPS_DB_CHKREF', 1);

require_once XOOPS_ROOT_PATH.'/class/database/databasefactory.php';

if ($root->getSiteConfig('Legacy', 'AllowDBProxy') == true) {
		if (xoops_getenv('REQUEST_METHOD') != 'POST' || !xoops_refcheck(XOOPS_DB_CHKREF)) {
			if(!defined('XOOPS_DB_PROXY'))
				define('XOOPS_DB_PROXY', 1);
		}
	}
	elseif (xoops_getenv('REQUEST_METHOD') != 'POST') {
		if(!defined('XOOPS_DB_PROXY'))
			define('XOOPS_DB_PROXY', 1);
	}

return XoopsDatabaseFactory::getDatabaseConnection();
}

function _error_message($db) {
    if (is_object($db) && $db->errno()) {
        $err_msg = '#' . $db->errno() . ' - ' . $db->error() . "<br />\n";
        echo $err_msg;
    }
}

ページが見つかりませんでした – Lumiere Shop