让无限个论坛共用一个会员数据的方法(5.0)

原帖由 摇摆 于 2006-9-22 19:48 发表
这样合并会遇到很多问题……
比如两个论坛精华帖不一样。在A论坛的精华帖。在B论坛也有显示。在B论坛点精华。显示主题不存在
还有很多会员数据。
要是只同步注册会员就好了。其他都不关联。只同步一个ID。可以 ...

我按照楼主的方法修改后成这样了：


Discuz! info: MySQL Query Error

Time: 2007-2-4 2:16pm
Script: /index.php

SQL: SELECT s.sid, s.styleid, s.groupid='6' AS ipbanned, s.pageviews AS spageviews, s.lastolupdate, s.seccode, m.uid AS discuz_uid,
m.username AS discuz_user, m.password AS discuz_pw, m.secques AS discuz_secques, m.adminid, m.groupid, m.groupexpiry,
m.extgroupids, m.email, m.timeoffset, m.tpp, m.ppp, m.posts, m.digestposts, m.oltime, m.pageviews, m.credits, m.extcredits1, m.extcredits2, m.extcredits3,
m.extcredits4, m.extcredits5, m.extcredits6, m.extcredits7, m.extcredits8, m.timeformat, m.dateformat, m.pmsound,
m.sigstatus, m.invisible, m.lastvisit, m.lastactivity, m.lastpost, m.newpm, m.accessmasks,m.xspacestatus, m.editormode, m.customshow
FROM cdb_sessions s, cncn21_3.cdb_members m
WHERE m.uid=s.uid AND s.sid='uenbyT' AND CONCAT_WS('.',s.ip1,s.ip2,s.ip3,s.ip4)='219.151.199.16' AND m.uid='1'
AND m.password='98dee097553f7003097f2d3aba3ed98c' AND m.secques=''
Error: SELECT command denied to user: 'cncn21_sj@localhost' for table 'cdb_members'
Errno.: 1142

Similar error report has beed dispatched to administrator before.

怎么办呢？有哪位好心人帮帮忙？

顶上来顶上来，等待回音。

唉，还是同样的错误：
Discuz! info: MySQL Query Error

Time: 2007-2-8 10:28pm
Script: /admincp.php

SQL: SELECT s.sid, s.styleid, s.groupid='6' AS ipbanned, s.pageviews AS spageviews, s.lastolupdate, s.seccode, m.uid AS discuz_uid,
m.username AS discuz_user, m.password AS discuz_pw, m.secques AS discuz_secques, m.adminid, m.groupid, m.groupexpiry,
m.extgroupids, m.email, m.timeoffset, m.tpp, m.ppp, m.posts, m.digestposts, m.oltime, m.pageviews, m.credits, m.extcredits1, m.extcredits2, m.extcredits3,
m.extcredits4, m.extcredits5, m.extcredits6, m.extcredits7, m.extcredits8, m.timeformat, m.dateformat, m.pmsound,
m.sigstatus, m.invisible, m.lastvisit, m.lastactivity, m.lastpost, m.newpm, m.accessmasks,m.xspacestatus, m.editormode, m.customshow
FROM cdb_sessions s, cncn21_3.cdb_members m
WHERE m.uid=s.uid AND s.sid='z5iFsr' AND CONCAT_WS('.',s.ip1,s.ip2,s.ip3,s.ip4)='219.151.204.149' AND m.uid='1'
AND m.password='98dee097553f7003097f2d3aba3ed98c' AND m.secques=''
Error: SELECT command denied to user: 'cncn21_shouji@localhost' for table 'cdb_members'
Errno.: 1142

Similar error report has beed dispatched to administrator before.

不错！·······

本地共用一个数据是成功了

但在A论坛注册，A论坛立即更新了最新会员

但B论坛虽可使用在A论坛注册的ID 但B论坛最新会员却未更新

需要手动更新缓存方可

楼主的办法需要B的数据库用户在A和B都有权限才行

两个论坛的管理人员是否 也被同步了呢?