Discuz!6.0增加推荐人记录查询功能

蓝雨

该升级补丁涉及1个数据表，及2个页面文件。如果您喜欢自己动手，请按以下方法进行升级：

手动升级方法：
=================================================
1、升级数据表members，增加fromuser字段：

引用:

ALTER TABLE `{$tablepre}members` ADD `fromuser` varchar(15) NOT NULL default \'\';

2、修改register.php，增加推荐人记录代码：
查找：

引用:

$db->query(\"INSERT INTO {$tablepre}members

在其上方添加代码：

引用:

if($fromuid) {
$query = $db->query(\"SELECT username FROM {$tablepre}members WHERE uid=\'$fromuid\'\");
if($db->num_rows($query)) {
$fromuser = $db->result($query, 0);
} else {

}
}

查找：

引用:

$db->query(\"INSERT INTO {$tablepre}members (username, password, secques, gender, adminid, groupid, regip, regdate, lastvisit, lastactivity, posts, credits, extcredits1, extcredits2, extcredits3, extcredits4, extcredits5, extcredits6, extcredits7, extcredits8, email, bday, sigstatus, tpp, ppp, styleid, dateformat, timeformat, pmsound, showemail, newsletter, invisible, timeoffset)
VALUES (\'$username\', \'$password\', \'$secques\', \'$gendernew\', \'0\', \'$groupinfo[groupid]\', \'$onlineip\', \'$timestamp\', \'$timestamp\', \'$timestamp\', \'0\', $initcredits, \'$email\', \'$bday\', \'$sigstatus\', \'$tppnew\', \'$pppnew\', \'$styleidnew\', \'$dateformatnew\', \'$timeformatnew\', \'$pmsoundnew\', \'$showemailnew\', \'$newsletter\', \'$invisiblenew\', \'$timeoffsetnew\')\");

将其修改为：

引用:

$db->query(\"INSERT INTO {$tablepre}members (username, password, fromuser, secques, gender, adminid, groupid, regip, regdate, lastvisit, lastactivity, posts, credits, extcredits1, extcredits2, extcredits3, extcredits4, extcredits5, extcredits6, extcredits7, extcredits8, email, bday, sigstatus, tpp, ppp, styleid, dateformat, timeformat, pmsound, showemail, newsletter, invisible, timeoffset)
VALUES (\'$username\', \'$password\', \'$fromuser\', \'$secques\', \'$gendernew\', \'0\', \'$groupinfo[groupid]\', \'$onlineip\', \'$timestamp\', \'$timestamp\', \'$timestamp\', \'0\', $initcredits, \'$email\', \'$bday\', \'$sigstatus\', \'$tppnew\', \'$pppnew\', \'$styleidnew\', \'$dateformatnew\', \'$timeformatnew\', \'$pmsoundnew\', \'$showemailnew\', \'$newsletter\', \'$invisiblenew\', \'$timeoffsetnew\')\");

3、修改用户管理页面\\admin\\members.inc.php，增加推荐人查找功能：
查找：

引用: