论坛帖子推送到X-Space修改方法，针对20060417版本

论坛帖子推送到X-Space修改方法，针对20060417版本

上传图片btn_post_xs.gif,btn_reg_xs.gif到

./images/default

修改：

viewthread.php

找到：

CODE:
[Copy to clipboard]
$query = $db->query("SELECT p.*, m.uid, m.username, m.groupid, 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.avatarshowid, 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 $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' ORDER BY dateline LIMIT $start_limit, $ppp");
更改为：

CODE:
[Copy to clipboard]
$query = $db->query("SELECT p.*, m.uid, m.username, m.groupid, 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.avatarshowid, 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 $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' ORDER BY dateline LIMIT $start_limit, $ppp");
修改：

viewthread.htm

找到：

CODE:
[Copy to clipboard]
<span class="smalltxt"><span class="bold">$post[subject]</span></span><br><br><!--{/if}-->
在前面添加：

CODE:
[Copy to clipboard]
<!--{if $_DCACHE['settings']['supe_siteurl'] && $post['authorid'] == $discuz_uid && $post['first'] == 1}-->
                        <!--{if $post['xspacestatus'] ==1}-->
                                <b><a href="$_DCACHE['settings']['supe_siteurl']/spacecp.php?action=spaceblogs&op=add&tid=$post['tid']" target="_blank"><img src="{IMGDIR}/btn_post_xs.gif" style="border:0;float:right" /></a></b>
                        <!--{else}-->
                                <b><a href="http://x.discuz.net/action/register.html.html" target="_blank"><img src="{IMGDIR}/btn_reg_xs.gif" style="float:right" /></a></b>
                        <!--{/if}-->
                <!--{/if}-->
注意1：对新申请的用户，会显示推送。
对升级以前就申请个人空间的用户，就不显示了。

下载admin_mybbs.rar附件中文件，覆盖admin目录中admin_mybbs.php文件。
然后进入 个人后台 -> 论坛同步 -> 同步个人信息

注意1：出现类似错误提示应该怎么办？
错误提示：

CODE:
[Copy to clipboard]
Time: 2006-4-17 2:10pm
Script: /bbs/viewthread.php

SQL: SELECT p.*, m.uid, m.username, m.groupid, 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.avatarshowid, 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
FROM cdb_posts p
LEFT JOIN cdb_members m ON m.uid=p.authorid
LEFT JOIN cdb_memberfields mf ON mf.uid=m.uid
WHERE p.tid='24256' AND p.invisible='0' ORDER BY dateline LIMIT 0, 10
Error: Unknown column 'm.xspacestatus' in 'field list'
解决办法：
这个是因为升级过程中有字段没有添加导致
请登陆论坛后台升级数据库

CODE:
[Copy to clipboard]
ALTER TABLE `cdb_members` ADD `xspacestatus` TINYINT( 1 ) DEFAULT '0' NOT NULL AFTER `accessmasks` ;