【帖子布景V0.4.1】(搜刮会员荷包)适应DZ6.1&6.0【美化及修正BUG】

建議不要在個人欄而是 說話的對話整個框內做背景,我覺得更有意思

支持了

等下装上,我们确实很需要一些能够消费掉会员帐上金币的插件.

再次感谢楼主 -- 此插件作者

Discuz! info: MySQL Query Error

User: admin
Time: 2008-9-22 10:19pm
Script: /redirect.php

SQL: SELECT bg.file, bg.position, bg.repeat, 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, mf.nickname, mf.site,
mf.icq, mf.qq, mf.yahoo, mf.msn, mf.taobao, mf.alipay, mf.location, mf.medals,
mf.sightml AS signature, mf.customstatus, mf.spacename, mf.pighead , mf.field_1
FROM [Table]posts p
LEFT JOIN [Table]members m ON m.uid=p.authorid

LEFT JOIN [Table]memberfields mf ON mf.uid=m.uid LEFT JOIN displu_dress_users bg ON bg.uid=m.uid AND bg.expiration> AND active=1
WHERE p.tid='26' AND p.invisible='0' ORDER BY dateline LIMIT 0, 15
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND active=1
WHERE p.tid='26' AND p.invisible='0' ORDER BY dateline LIMIT 0' at line 9
Errno.: 1064

Similar error report has beed dispatched to administrator before.

到 http://faq.comsenz.com 搜索此错误的解决方案

出现这个问题

感觉不错，做个记号

留个记号？
6.0的可以不？

安装文档勘误，请下午下载的朋友重新下载最新的，抱歉了

找到
$query = $db->query("SELECT p.*, m.uid, m.username, m.groupid, m.adminid, m.regdate, m.lastactivity, m.posts, m.digestposts, m.oltime,

在上面一行加入
$bgnow = time();

然后此行替换为
$query = $db->query("SELECT bg.file, bg.position, bg.repeat, p.*, m.uid, m.username, m.groupid, m.adminid, m.regdate, m.lastactivity, m.posts, m.digestposts, m.oltime,

要是不升级数据库就更好了。DZ7就要出来了，到时候如果升级，恐怕这些改过数据库的插件，会导致很多未知错误出现。