婚恋中心插件for discuz 6.0

蓝雨

首先第一步，升级数据库（在升级数据库之前请先备份您原来的数据库以防不测！）
MYSQL <= 4.0.* 的升级以下

复制内容到剪贴板

代码:

DROP TABLE IF EXISTS `cdb_marry` ;
CREATE TABLE `cdb_marry` (
`mid` mediumint(8) unsigned NOT NULL auto_increment,
`uid` mediumint(8) unsigned NOT NULL,
`username` char(15) NOT NULL,
`marryuser` char(15) NOT NULL,
`proposetime` int(10) default NULL,
`agreetime` int(10) unsigned default NULL,
`regtime` int(10) unsigned default NULL,
`content` mediumtext NOT NULL,
`isreg` tinyint(1) NOT NULL default \'0\',
`status` tinyint(1) NOT NULL default \'0\',
`divorce` mediumint(8) unsigned default NULL,
PRIMARY KEY(`mid`),
KEY `uid` (`uid`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

MYSQL == 4.1.* 的升级以下

复制内容到剪贴板

代码:

DROP TABLE IF EXISTS `cdb_marry` ;
CREATE TABLE `cdb_marry` (
`mid` mediumint(8) unsigned NOT NULL auto_increment,
`uid` mediumint(8) unsigned NOT NULL,
`username` char(15) NOT NULL,
`marryuser` char(15) NOT NULL,
`proposetime` int(10) default NULL,
`agreetime` int(10) unsigned default NULL,
`regtime` int(10) unsigned default NULL,
`content` mediumtext NOT NULL,
`isreg` tinyint(1) NOT NULL default \'0\',
`status` tinyint(1) NOT NULL default \'0\',
`divorce` mediumint(8) unsigned default NULL,
PRIMARY KEY(`mid`),
KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=1 ;

引用:

下面是第二步，导入Discuz_plugin_marry.txt全部内容
具体操作（扩展设置=>插件管理=>导入插件数据）然后将discuz_plugin_marry.txt全部内容导入进去
（5.5的我重新钩了一遍，所以不用勾选“允许导入不同版本 Discuz! 的插件”这个选项了！）

引用:

然后是第三步（724更新），贴间显示
1 根目录viewthread.php
找：

复制内容到剪贴板

代码:

$query = $db->query(\"SELECT p.*, m.uid, m.username, m.groupid, m.adminid, m.regdate, m.lastactivity, 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.email, m.gender, m.showemail, m.invisible, m.xspacestatus, mf.nickname, mf.site,
mf.icq, mf.qq, mf.yahoo, mf.msn, mf.taobao, mf.alipay, mf.location, mf.medals, mf.avatar, mf.avatarwidth,
mf.avatarheight, mf.sightml AS signature, mf.customstatus, mf.spacename $fieldsadd
FROM {$tablepre}posts p
LEFT JOIN {$tablepre}members m ON m.uid=p.authorid
LEFT JOIN {$tablepre}memberfields mf ON mf.uid=m.uid
WHERE p.tid=\'$tid\' AND p.invisible=\'0\' $pageadd\");

替换成：

复制内容到剪贴板

代码:

//婚恋中心 For 5.X 贴间显示 By [DST]wxyuan90 [DST]Rockoy
@include_once DISCUZ_ROOT.\'./forumdata/cache/plugin_marry.php\';
$ismarried = $_DPLUGIN[\'marry\'][\'vars\'][\'ismarried\'];//结婚记录相关extcredits
$query = $db->query(\"SELECT mm.username as musername, p.*, m.uid, m.username, m.groupid, m.adminid, m.regdate, m.lastactivity, 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.email, m.gender, m.showemail, m.invisible, m.xspacestatus, mf.nickname, mf.site,
mf.icq, mf.qq, mf.yahoo, mf.msn, mf.taobao, mf.alipay, mf.location, mf.medals, mf.avatar, mf.avatarwidth,
mf.avatarheight, mf.sightml AS signature, mf.customstatus, mf.spacename $fieldsadd
FROM {$tablepre}posts p
LEFT JOIN {$tablepre}members m ON m.uid=p.authorid
LEFT JOIN {$tablepre}members mm ON mm.uid=m.{$ismarried}
LEFT JOIN {$tablepre}memberfields mf ON mf.uid=m.uid
WHERE p.tid=\'$tid\' AND p.invisible=\'0\' $pageadd\");
//婚恋中心插件 For 5.X 贴间显示 By [DST]wxyuan90 [DST]Rockoy END

保存上传！
[quote]※※※※※※也就是说，原来的

复制内容到剪贴板

代码:

WHERE p.tid=\'$tid\' AND p.invisible=\'0\' ORDER BY dateline LIMIT $start_limit, $ppp\");

替换为

复制内容到剪贴板

代码:

WHERE p.tid=\'$tid\' AND p.invisible=\'0\' $pageadd\");

2 当前模版文件viewthread.htm
找：

复制内容到剪贴板

代码:


{lang location} $post[location]


如果你经过修改，你可以在avatarshow.htm 或者 roinfo.htm 或者适当位置下面加上：

复制内容到剪贴板

代码:

配偶：{$post[\'musername\']}偶是单身贵族！


蓝雨

反安装代码 DROP TABLE cdb_marry;