2,修改论坛 include/common.inc.php
找到
m.accessmasks
修改为
m.accessmasks,m.xspacestatus
这个修改完了
共有2处
下面的全部都找不到 字段在那里,怎么会事?
3,修改论坛模板
templates/default/index.htm
templates/default/forumdisplay.htm
找到
<td class="nav" width="85%" align="left" nowrap>
修改为
<td class="nav" width="65%" align="left" nowrap>
找到
[Copy to clipboard]CODE:
<td align="right" width="15%">
修改为
[Copy to clipboard]CODE:
<td align="right" width="35%"><a href="X-Space访问地址/index.php?action/panel" target="_blank"><img src="images/common/icon_x.gif" border="0" align="absmiddle">我的个人空间(new!)</a>
4,上传附件btn_post_xs.rar 里面的图片btn_post_xs.gif,btn_reg_xs.gif到
./images/default
5,修改:
viewthread.php
找到:
[Copy to clipboard]CODE:
$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");
更改为:
[Copy to clipboard]CODE:
$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
找到:
[Copy to clipboard]CODE:
<span class="smalltxt"><span class="bold">$post[subject]</span></span><br><br><!--{/if}-->
在前面添加:
[Copy to clipboard]CODE:
<!--{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="$_DCACHE['settings']['supe_siteurl']/index.php?action/register.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文件。
然后进入 个人后台 -> 论坛同步 -> 同步个人信息
注意2:出现类似错误提示应该怎么办?
错误提示:
[Copy to clipboard]CODE:
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'
解决办法:
这个是因为升级过程中有字段没有添加导致
请登陆论坛后台升级数据库
[Copy to clipboard]CODE:
ALTER TABLE `cdb_members` ADD `xspacestatus` TINYINT( 1 ) DEFAULT '0' NOT NULL AFTER `accessmasks` ;
[ 本帖最后由 飘雨寒 于 2006-12-1 12:39 编辑 ] |