ss与dz的数据库配置分别为同一台mysql服务器的不同用户，聚合报权限错误的解决方案

lidq.jingwu · 发表于 2010-4-23 12:37:45

打开function/common.func.php文件，找到下面一个 dbconect 函数，将其改为：

//连接数据库
function dbconnect($mode=0) {
global $_SGLOBAL, $_SC;
if(empty($_SGLOBAL['db'])) {
include_once(S_ROOT.'./class/db_mysql.class.php');
$_SGLOBAL['db'] = new dbstuff;
$_SGLOBAL['db']->charset = $_SC['dbcharset'];
$_SGLOBAL['db']->connect($_SC['dbhost'], $_SC['dbuser'], $_SC['dbpw'], $_SC['dbname'], $_SC['pconnect']);
}
if($mode==1) {
if(empty($_SGLOBAL['db_bbs'])) {
if($_SC['dbhost'] == $_SC['dbhost_bbs'] && $_SC['dbuser'] == $_SC['dbuser_bbs'] && $_SC['dbcharset'] == $_SC['dbcharset_bbs']) {
//同一台服务器
$_SGLOBAL['db_bbs'] = $_SGLOBAL['db'];
} else {
//不同的mysql服务器
include_once(S_ROOT.'./class/db_mysql.class.php');
$newlink = $_SC['dbhost'] == $_SC['dbhost_bbs'] && $_SC['dbuser'] == $_SC['dbuser_bbs'] && $_SC['dbcharset'] != $_SC['dbcharset_bbs'] ? 1 : 0;
$_SGLOBAL['db_bbs'] = new dbstuff;
$_SGLOBAL['db_bbs']->charset = $_SC['dbcharset_bbs'];
$_SGLOBAL['db_bbs']->connect($_SC['dbhost_bbs'], $_SC['dbuser_bbs'], $_SC['dbpw_bbs'], $_SC['dbname_bbs'], $_SC['pconnect_bbs'], 1);
}
}
} elseif($mode==2) {
if(empty($_SGLOBAL['db_uch'])) {
if($_SC['dbhost'] == $_SC['dbhost_uch'] && $_SC['dbuser'] == $_SC['dbuser_uch'] && $_SC['dbcharset'] == $_SC['dbcharset_uch']) {
//同一台服务器
$_SGLOBAL['db_uch'] = $_SGLOBAL['db'];
} else {
//不同的mysql服务器
include_once(S_ROOT.'./class/db_mysql.class.php');
$newlink = $_SC['dbhost'] == $_SC['dbhost_uch'] && $_SC['dbuser'] == $_SC['dbuser_uch'] && $_SC['dbcharset'] != $_SC['dbcharset_uch'] ? 1 : 0;
$_SGLOBAL['db_uch'] = new dbstuff;
$_SGLOBAL['db_uch']->charset = $_SC['dbcharset_uch'];
$_SGLOBAL['db_uch']->connect($_SC['dbhost_uch'], $_SC['dbuser_uch'], $_SC['dbpw_uch'], $_SC['dbname_uch'], $_SC['pconnect_uch'], $newlink);
}
}
}
}

复制代码

亚光耐普罗 · 发表于 2010-4-23 12:44:21

elevensky · 发表于 2010-4-23 21:12:43

第一个

elevensky · 发表于 2010-4-23 21:12:48

顶一个

怪物之家 · 发表于 2010-4-29 13:28:28

修改一下两个数据库的交叉权限问题~

caiyiping2010 · 发表于 2010-5-13 15:56:22

http://www.2010taobaotop8.com/

chris_zcl · 发表于 2010-5-21 09:11:56

这种改动篇幅过大吧~~~。。。为什么不提取部分代码更换演示，还有注释~写上多好呀~

		自动登录	找回密码
密码			立即注册