12 3 4 5 下一页

Member

Rank: 2

帖子: 35
积分: 79
威望: 0
金币: 34 个
体力: 50
注册时间: 2005-8-20

楼主

打印

字体大小: tT

outcrop发表于 2008-4-7 06:55 | 只看该作者

用“超级站长”安装Discuz!和UCHome，超级简单！

Mediawiki 1.12+Discuz 6.1+Ucenter 1同步登陆整合方法（080409更新）

080409： 13楼加了段通过hook mediawiki自动登录功能实现自动同步登陆的演示代码，自动同步退出需要hook下mediawiki的自动退出功能。
【适用范围】
UCenter 1.0.0RC GBK
Discuz 6.1.0RC GBK
Mediawiki 1.12.0
实现了基于Ucenter的各产品之间的同步登陆、简单的权限管理（即DZ中某些用户组才具有编辑百科的权力）。时间关系，更多丰富的功能还没实现，大概的整合思路在代码里注释了，希望能抛砖引玉：）。因为我用的都是GBK的DZ，所以只做了GBK部分的工作，UTF8版本之间集成应该更方便。如果你有什么特别的DZ+Mw应用思路，欢迎到 www.allwiki.com 的QQ群交流。

【使用方法】
1、extensions目录下建立Auth_UC目录，复制Auth_Discuz.php、config.inc.php以及UC客户端的/client目录到Auth_UC下
2、设置LocalSettings.php，调用Auth_Discuz.php并设置相关参数，我的设置参考：
LocalSettings.php下添加：

// 调用插件
require_once './extensions/Auth_UC/Auth_Discuz.php';
// GroupID of your Discuz group 允许编辑百科的DZ用户组ID，这里随便写的
$wgDiscuz_WikiGroupID = '9,10,11,12,13,14';
$wgDiscuz_WikiGroupName = 'user'; // Name of your Discuz group
// users need to be a member
// of to use the wiki. (i.e. wiki)
$wgDiscuz_UseWikiGroup = true; // This tells the Plugin to require
// a user to be a member of the above
// Discuz group. (ie. wiki) Setting
// this to false will let any Discuz
// user edit the wiki.
$wgDiscuz_UseExtDatabase = true; // This tells the plugin that the Discuz tables
// are in a different database then the wiki.
// The default settings is false.
$wgDiscuz_Version = '6'; // This is what version of Discuz you are using.
// Current valid values are 5.5 and 6 修改过来的，就没改了
/*-[NOTE: You only need the next four settings if you set $wgDiscuz_UseExtDatabase to true.]-*/
$wgDiscuz_MySQL_Host = 'localhost:6033'; // Discuz MySQL Host Name. 我个人的测试环境
$wgDiscuz_MySQL_Username = 'root'; // Discuz MySQL Username. 这些是DZ里设置权限的数据库
$wgDiscuz_MySQL_Password = 'root'; // Discuz MySQL Password. 就是说用DZ来决定哪些人可以编辑
$wgDiscuz_MySQL_Database = 'dz61'; // Discuz MySQL Database Name. 权限应该还可以细化
$wgDiscuz_Charset = 'gbk'; // Discuz MySQL Database Name. GBK的数据库，utf8的设置有差异
$wgDiscuz_UserTB = 'cdb_members'; // Name of your Discuz user table. (i.e. bbs_members)
$wgDiscuz_UserFieldTB = 'cdb_memberfields'; // Name of your SMF user table. (i.e. bbs_memberfields)
$wgDiscuz_GroupsTB = 'cdb_usergroups'; // Name of your Discuz groups table. (i.e. bbs_usergroups)
$wgAuth = new Auth_Discuz(); // Auth_Discuz Plugin.

复制代码

我的config.inc.php文件，参照Ucenter设置:

<?php
// ============================================================================
define('UC_CONNECT', 'mysql');
define('UC_DBHOST', 'localhost:6033');
define('UC_DBUSER', 'root');
define('UC_DBPW', 'root');
define('UC_DBNAME', 'test');
define('UC_DBCHARSET', 'gbk');
define('UC_DBTABLEPRE', '`test`.uc10_');
define('UC_DBCONNECT', '0');
define('UC_KEY', '12345');
define('UC_API', 'http://localhost/passport');
define('UC_CHARSET', 'gbk');
define('UC_IP', '');
define('UC_APPID', '7');
define('UC_PPP', '20');

复制代码

【参考】
http://www.51ajax.com/blog/?p=99

[ 本帖最后由 outcrop 于 2008-4-9 14:21 编辑 ]

Auth_UC.rar (24.15 KB)

三个修改了的文件

收藏分享评分

北京LAMP就业班十六期热招ing

回复引用

订阅 TOP

Member

Rank: 2

帖子: 35
积分: 79
威望: 0
金币: 34 个
体力: 50
注册时间: 2005-8-20

沙发

outcrop发表于 2008-4-7 06:56 | 只看该作者

修改过的代码

【修改过的文件】
请自行查找行号，我的修改变了
1、/extensions/Auth_UC/Auth_Discuz.php

<?php
/* vim: set expandtab tabstop=4 shiftwidth=4 softtabstop=4: */
/**
* This file makes MediaWiki use a SMF user database to
* authenticate with. This forces users to have a SMF account
* in order to log into the wiki. This should also force the user to
* be in a group called wiki.
*
* 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.
* http://www.gnu.org/copyleft/gpl.html
*
* @package MediaWiki
* @subpackage Auth_SMF
* @author Nicholas Dunnaway
* @copyright 2004-2006 php|uber.leet
* @license http://www.gnu.org/copyleft/gpl.html
* @CVS: $Id: Auth_SMF.php,v 1.3 2007/04/05 22:17:56 nkd Exp $
* @link http://uber.leetphp.com
* @version $Revision: 1.3 $
*
*
* @Modified By Hopesoft
* @link http://www.51ajax.com
* @2007-11-11
*
*
* @Modified By outcrop
* @email outcrop@163.com
* @2008-04-07
*/
error_reporting(E_ALL); // Debug
include './extensions/Auth_UC/config.inc.php';
include './extensions/Auth_UC/client/client.php';
// First check if class has already been defined.
if (!class_exists('AuthPlugin'))
{
/**
* Auth Plugin
*
*/
require_once './includes/AuthPlugin.php';
}
/**
* Handles the Authentication with the Discuz database.
*
* @package MediaWiki
* @subpackage Auth_Discuz
*/
class Auth_Discuz extends AuthPlugin
{
/**
* Add a user to the external authentication database.
* Return true if successful.
*
* NOTE: We are not allowed to add users to Discuz from the
* wiki so this always returns false.
*
* @param User $user
* @param string $password
* @return bool
* @access public
*/
function addUser( $user, $password )
{
return false;
}
/**
* Can users change their passwords?
*
* @return bool
*/
function allowPasswordChange()
{
return true;
}
/**
* Check if a username+password pair is a valid login.
* The name will be normalized to MediaWiki's requirements, so
* you might need to munge it (for instance, for lowercase initial
* letters).
*
* @param string $username
* @param string $password
* @return bool
* @access public
* @todo Check if the password is being changed when it contains a slash or an escape char.
*/
function authenticate($username, $password)
{
// Clean $username and force lowercase username.
//echo "
Authenticate Start";
$username = htmlentities(strtolower($username), ENT_QUOTES, 'UTF-8');
$username = str_replace(''', '\\\'', $username); // Allow apostrophes (Escape them though)
//调用client的uc_user_login判断用户密码，由于MediaWiki为utf8编码，因此转换为GBK后判断，主要是中文ID
list($uid, $username1, $password, $email) = uc_user_login(iconv("UTF-8", "GBK", $username), $password);
setcookie('WIKI_auth', '', -86400);
if ($uid > 0 && $this->isMemberOfWikiGroup($username)) {
//用户登陆成功，设置 Cookie，加密直接用 uc_authcode 函数，用户使用自己的函数
setcookie('WIKI_auth', uc_authcode($uid."\t".$username1, 'ENCODE'));
//生成同步登录的代码
//由于uc_user_synlogin返回string,必须要echo一下才能成功同步登陆
echo uc_user_synlogin($uid);
if(uc_pm_checknew($uid)) {
//echo "You have new message....";
}
return true;
}
if ($uid== -1){
echo "No this username for login, please confirm";
return false;
}
if ($uid== -2){
echo "assword Error";
return false;
}
}
/**
* Return true if the wiki should create a new local account automatically
* when asked to login a user who doesn't exist locally but does in the
* external auth database.
*
* If you don't automatically create accounts, you must still create
* accounts in some way. It's not possible to authenticate without
* a local account.
*
* This is just a question, and shouldn't perform any actions.
*
* NOTE: I have set this to true to allow the wiki to create accounts.
* Without an accout in the wiki database a user will never be
* able to login and use the wiki. I think the password does not
* matter as long as authenticate() returns true.
*
* @return bool
* @access public
*/
function autoCreate()
{
return true;
}
/**
* Check to see if external accounts can be created.
* Return true if external accounts can be created.
*
* NOTE: We are not allowed to add users to Discuz from the
* wiki so this always returns false.
*
* @return bool
* @access public
*/
function canCreateAccounts()
{
return false;
}
/**
* Connect to the database. All of these settings are from the
* LocalSettings.php file. This assumes that the Discuz uses the same
* database/server as the wiki.
*
* {@source }
* @return resource
*/
function connect()
{
//echo "
----connecting----";
$dbcharset = $GLOBALS['wgDiscuz_Charset'];
//echo "Charset: ".$dbcharset;
// Check if the Discuz tables are in a different database then the Wiki.
if ($GLOBALS['wgDiscuz_UseExtDatabase'] == true) {
// Connect to database. I supress the error here.
$fresMySQLConnection = @mysql_connect($GLOBALS['wgDiscuz_MySQL_Host'],
$GLOBALS['wgDiscuz_MySQL_Username'],
$GLOBALS['wgDiscuz_MySQL_Password'],
true);
if (mysql_get_server_info()>= 4.1)
if($dbcharset) {
mysql_query("SET character_set_connection=$dbcharset, character_set_results=$dbcharset, character_set_client=binary");
}
// Check if we are connected to the database.
if (!$fresMySQLConnection)
{
$this->mySQLError('There was a problem when connecting to the Discuz database.
' .
'Check your Host, Username, and Password settings.
');
}
// Select Database
$db_selected = mysql_select_db($GLOBALS['wgDiscuz_MySQL_Database'], $fresMySQLConnection);
// Check if we were able to select the database.
if (!$db_selected)
{
$this->mySQLError('There was a problem when connecting to the Discuz database.
' .
'The database ' . $GLOBALS['wgDiscuz_MySQL_Database'] .
' was not found.
');
}
}
else
{
// Connect to database.
$fresMySQLConnection = mysql_connect($GLOBALS['wgDBserver'],
$GLOBALS['wgDBuser'],
$GLOBALS['wgDBpassword'],
true);
// Check if we are connected to the database.
if (!$fresMySQLConnection)
{
$this->mySQLError('There was a problem when connecting to the Discuz database.
' .
'Check your Host, Username, and Password settings.
');
}
// Select Database: This assumes the wiki and Discuz are in the same database.
$db_selected = mysql_select_db($GLOBALS['wgDBname']);
// Check if we were able to select the database.
if (!$db_selected)
{
$this->mySQLError('There was a problem when connecting to the Discuz database.
' .
'The database ' . $GLOBALS['wgDBname'] . ' was not found.
');
}
}
$GLOBALS['gstrMySQLVersion'] = substr(mysql_get_server_info(), 0, 3); // Get the mysql version.
return $fresMySQLConnection;
}
/**
* If you want to munge the case of an account name before the final
* check, now is your chance.
*/
function getCanonicalName( $username )
{
return $username;
}
/**
* When creating a user account, optionally fill in preferences and such.
* For instance, you might pull the email address or real name from the
* external user database.
*
* The User object is passed by reference so it can be modified; don't
* forget the & on your function declaration.
*
* NOTE: This gets the email address from Discuz for the wiki account.
*
* @param User $user
* @access public
*/
function initUser(&$user)
{
//echo "
initUser Start";
$username = htmlentities(strtolower($user->mName), ENT_QUOTES, 'UTF-8');
$username = str_replace(''', '\\\'', $username); // Allow apostrophes (Escape them though)
//echo "
Start init---";
if($data = uc_get_user(iconv("UTF-8", "GBK", $username))) { //Get information from UC
//if($data = uc_get_user($username)) { //Get information from UC
list($uid, $username1, $email) = $data;
//$username=iconv("GBK", "UTF-8", $username);
//echo "init uname1:".$username1;
//echo $email.$uid;
$user->mEmail=$email; //Get email from UC
$user->mid=$uid; //Get address from UC
} else {
echo 'No such user for initial: '.$username;
}
//$username=iconv("GBK", "UTF-8", $username);
}
/**
* Checks if the user is a member of the Discuz group called wiki.
*
* @param string $username
* @access public
* @return bool
* @todo Remove 2nd connection to database. For function isMemberOfWikiGroup()
*
*/
function isMemberOfWikiGroup($username)
{
// In LocalSettings.php you can control if being
//echo "
---IsMember Start---";
// a member of a wiki is required or not.
//return false;
if (isset($GLOBALS['wgDiscuz_UseWikiGroup']) && $GLOBALS['wgDiscuz_UseWikiGroup'] === false)
{
return true;
}
// Connect to the database.
$fresMySQLConnection = $this->connect();
// Check MySQL Version
if ($GLOBALS['gstrMySQLVersion'] >= 4.1)
{
// Get all the groups the user is a member of.
$fstrMySQLQuery = 'SELECT `adminid`, `groupid`
FROM `' . $GLOBALS['wgDiscuz_UserTB'] . '`
WHERE `username` = CONVERT( _utf8 \'' . $username . '\' USING utf8 )
LIMIT 1';
}
else
{
// Get all the groups the user is a member of.
$fstrMySQLQuery = 'SELECT `adminid`, `groupid`
FROM `' . $GLOBALS['wgDiscuz_UserTB'] . '`
WHERE `username` = \'' . $username . '\'
LIMIT 1';
}
// Query Database.
$fresMySQLResult = mysql_query($fstrMySQLQuery, $fresMySQLConnection)
or die($this->mySQLError('Unable to view external table_2'));
//echo $fstrMySQLQuery;
while($faryMySQLResult = mysql_fetch_array($fresMySQLResult))
{
$GroupID = $faryMySQLResult['groupid'];
// echo "groupID is: ".$GroupID;
$AdminID = $faryMySQLResult['adminid'];
}
$wgDiscuz_WikiGroupIDArray=explode(',',$GLOBALS['wgDiscuz_WikiGroupID']);
if (in_array($GroupID,$wgDiscuz_WikiGroupIDArray ) || $AdminID =="1") {
return true;
}
else
{
return false;
}
}
/**
* Modify options in the login template.
*
* NOTE: Turned off some Template stuff here. Anyone who knows where
* to find all the template options please let me know. I was only able
* to find a few.
*
* @param UserLoginTemplate $template
* @access public
*/
function modifyUITemplate( &$template )
{
$template->set('usedomain', false); // We do not want a domain name.
$template->set('create', false); // Remove option to create new accounts from the wiki.
$template->set('useemail', false); // Disable the mail new password box.
}
/**
* This prints an error when a MySQL error is found.
*
* @param string $message
* @access public
*/
function mySQLError( $message )
{
echo $message . '
';
echo 'MySQL Error Number: ' . mysql_errno() . '
';
echo 'MySQL Error Message: ' . mysql_error() . '
';
exit;
}
/**
* Set the domain this plugin is supposed to use when authenticating.
*
* NOTE: We do not use this.
*
* @param string $domain
* @access public
*/
function setDomain( $domain )
{
$this->domain = $domain;
}
/**
* Set the given password in the authentication database.
* Return true if successful.
*
* NOTE: We only allow the user to change their password via phpBB.
*
* @param string $password
* @return bool
* @access public
*/
function setPassword( $password )
{
return true;
}
/**
* Return true to prevent logins that don't authenticate here from being
* checked against the local database's password fields.
*
* This is just a question, and shouldn't perform any actions.
*
* Note: This forces a user to pass Authentication with the above
* function authenticate(). So if a user changes their Discuz
* password, their old one will not work to log into the wiki.
* Wiki does not have a way to update it's password when Discuz
* does. This however does not matter.
*
* @return bool
* @access public
*/
function strict()
{
return true;
}
/**
* Update user information in the external authentication database.
* Return true if successful.
*
* @param $user User object.
* @return bool
* @public
*/
function updateExternalDB( $user )
{
return true;
}
/**
* When a user logs in, optionally fill in preferences and such.
* For instance, you might pull the email address or real name from the
* external user database.
*
* The User object is passed by reference so it can be modified; don't
* forget the & on your function declaration.
*
* NOTE: Not useing right now.
*
* @param User $user
* @access public
*/
function updateUser( &$user )
{
return true;
}
/**
* Check whether there exists a user account with the given name.
* The name will be normalized to MediaWiki's requirements, so
* you might need to munge it (for instance, for lowercase initial
* letters).
*
* NOTE: MediaWiki checks its database for the username. If it has
* no record of the username it then asks. "Is this really a
* valid username?" If not then MediaWiki fails Authentication.
*
* @param string $username
* @return bool
* @access public
* @todo write this function.
*/
function userExists($username)
{
// Clean $username and force lowercase username.
//echo "
userExists Start";
$username = htmlentities(strtolower($username), ENT_QUOTES, 'UTF-8');
$username = str_replace(''', '\\\'', $username); // Allow apostrophes (Escape them though)
//$username=iconv("UTF-8", "GBK", $username);
//echo "
Start Exist---";
//---------------------------------------------------------------------------------------------------
if($data = uc_get_user(iconv("UTF-8", "GBK", $username))) {
list($uid, $username1, $email) = $data;
//$username=iconv("GBK", "UTF-8", $username);
//echo "Exist username :".$username;
//echo "---Exist username1 :".$username1;
return true;
} else {
echo 'No such user:'.$username;
//echo iconv("UTF-8", "GBK", $username);
return false;
}
}
/**
* Check to see if the specific domain is a valid domain.
*
* @param string $domain
* @return bool
* @access public
*/
function validDomain( $domain )
{
return true;
}
}
?>

复制代码

2、./includes/Database.php第818行添加mysql_query("SET NAMES 'utf8';", $this->mConn );
修改这个主要是我的中文ID会出问题，不一定要求

/*private*/ function doQuery( $sql ) {
if( $this->bufferResults() ) {
mysql_query("SET NAMES 'utf8';", $this->mConn );
$ret = mysql_query( $sql, $this->mConn );
} else {
$ret = mysql_unbuffered_query( $sql, $this->mConn );
}
return $ret;
}

复制代码

3、./extensions/Auth_UC/client/lib/db.class.php 第71行和78行，分别设置了mysql_query方式，我的GBK对utf8，所以修改这里，utf8的dz和ucenter就不必了

function query($sql, $type = '', $cachetime = FALSE) {
mysql_query("SET NAMES 'GBK'"); //设定UC查询编码为GBK，避免编码冲突
$func = $type == 'UNBUFFERED' && function_exists('mysql_unbuffered_query') ? 'mysql_unbuffered_query' : 'mysql_query';
if(!($query = $func($sql, $this->link)) && $type != 'SILENT') {
$this->halt('MySQL Query Error', $sql);
}
$this->querynum++;
$this->histories[] = $sql;
mysql_query("SET NAMES 'utf8'");//还原MW系统查询编码为UTF-8，避免编码冲突
return $query;
}

复制代码

《PHPer》电子杂志免费下载

回复引用

TOP

King

Rank: 6 Rank: 6

帖子: 640
积分: 1260
威望: 65
金币: 65 个
体力: 514
注册时间: 2006-8-8

藤椅

appleshow发表于 2008-4-7 09:02 | 只看该作者

支持楼主：）

新手建站学堂

回复引用

TOP

King

Rank: 6 Rank: 6

帖子: 2456
积分: 2094
威望: -1
金币: 93 个
体力: 2386
注册时间: 2005-4-3

板凳

尐強发表于 2008-4-7 09:09 | 只看该作者

【点击进入:::哟哟城市:::】
新网互联 COM,NET 50元/年联系QQ：5166143
★淘宝鞋店★ 主营NIKE ADIDAS 篮球鞋、板鞋

新手建站学堂

回复引用

TOP

King

Rank: 6 Rank: 6

帖子: 2320
积分: 2214
威望: 5
金币: 205 个
体力: 415
注册时间: 2007-8-6

报纸

zhangjinlu发表于 2008-4-7 09:29 | 只看该作者

PHPChina上海认证就业班热招ing

回复引用

TOP

King

Rank: 6 Rank: 6

帖子: 2152
积分: 2194
威望: 36
金币: 48 个
体力: 2094
注册时间: 2005-11-12

地板

HY清风发表于 2008-4-7 10:16 | 只看该作者

占楼支持~~~~~~~

宇风影院-提供多通道免费在线观看影视 Discuz! 6 HY清风收集贴！

PHPChina上海认证就业班热招ing

回复引用

TOP

Lord

Rank: 4

帖子: 811
积分: 862
威望: 0
金币: 142 个
体力: 564
注册时间: 2006-8-1

7^#

影火虫发表于 2008-4-7 23:35 | 只看该作者

这个兄弟好像认识的，好久没联系了，转战media了啊呵呵

生活就是....

《PHPer》电子杂志免费下载

回复引用

TOP

Member

Rank: 2

帖子: 104
积分: 83
威望: 0
金币: 0 个
体力: 107
注册时间: 2005-8-4

8^#

zyr12发表于 2008-4-8 01:24 | 只看该作者

支持个

WIINDSBBS 掌机迷的家

PHPChina上海认证就业班热招ing

回复引用

TOP

Forum Legend

Rank: 8 Rank: 8

帖子: 8161
积分: 6714
威望: 14
金币: 30 个
体力: 1289
注册时间: 2005-7-29

9^#

inonce发表于 2008-4-8 02:14 | 只看该作者

慧美女性网

PHPChina上海认证就业班热招ing

回复引用

TOP

Conqueror

Rank: 3 Rank: 3

帖子: 207
积分: 208
威望: 0
金币: 28 个
体力: 174
注册时间: 2006-9-14

10^#

17eee发表于 2008-4-8 02:16 | 只看该作者

战位!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

龙港网:www.lgbbs.cn

新手建站学堂

回复引用

TOP

12 3 4 5 下一页

返回列表

Manyou诚邀开发者加盟 \| 常见问题《站长》俱乐部官方群公布城市联络员机会多多	立即免费下载 Discuz!7.0.0 正式版安装升级指南 \| 用户手册 \| 新手建站学堂	基于.net架构的Discuz!NT2.6正式版发布 Comsenz公司2009年招贤纳士，期待您的加盟
Discuz!收费服务内容及价格 7月重庆、成都、西安三地社区运营实战特训速报名	Discuz!/UCHome 专用官方虚拟主机牧场新服一起联运：豆浆机免费带回家	基于Discuz!的免费论坛空间5D6D 康盛创想《站长》俱乐部18城市互动之旅报名ing