鼠标移动到主题显示最后回复内容(D2.5sp1)改良版

感谢文文大大,一次成功!!

我的出错了:

Discuz! info: MySQL Query Error

User: 西域苍狼
Time: 2005-8-26 2:50pm
Script: /forumdisplay.php

SQL: SELECT p.subject AS re_subject, p.message, t.*, p.rate FROM cdb_threads t LEFT JOIN cdb_posts p ON (t.tid=p.tid AND t.lastpost=p.dateline)
LEFT JOIN cdb_posts p USING(tid, dateline)
WHERE (t.displayorder='3' OR t.fid='25')
ORDER BY t.displayorder DESC, t.lastpost DESC
LIMIT 0, 20
Error: Not unique table/alias: 'p'
Errno.: 1066

Similar error report has beed dispatched to administrator before.

何故?

在主页的热门排行榜里,不起作用...

望楼主解决..

先谢了

修改完以后,把鼠标移动到有连接的地方的时候,不出现五光十色的效果了

我的出错了:

Discuz! info: MySQL Query Error

User: 西域苍狼
Time: 2005-8-26 2:50pm
Script: /forumdisplay.php

SQL: SELECT p.subject AS re_subject, p.message, t.*, p.rate FROM cdb_threads t LEFT JOIN cdb_posts p ON (t.tid=p.tid AND t.lastpost=p.dateline)
LEFT JOIN cdb_posts p USING(tid, dateline)
WHERE (t.displayorder='3' OR t.fid='25')
ORDER BY t.displayorder DESC, t.lastpost DESC
LIMIT 0, 20
Error: Not unique table/alias: 'p'
Errno.: 1066

Similar error report has beed dispatched to administrator before.

何故?

童虎哥请帮忙!

<td width="47%" bgcolor="{ALTBG2}" onMouseOver ="this.style.backgroundColor='{ALTBG1}'" onMouseOut ="this.style.backgroundColor='{ALTBG2}'"  title="$thread[shortmsg]">
              <table cellpadding="0" cellspacing="0" border="0" width="100%" style="table-layout: fixed; word-wrap: break-word">
                <tr>
                  </td>


中的</td>应该为<td>

发现一个BUG，如果最后回复中带有"符号，主题显示不正常！

楼主好久没来了啊。。
怎么没人处理这个帖子了呢？

似乎BUG多了。ｈｏｈｏ。。

我安装了，可惜没有显示回复内容