后台审回复贴,不显示标题,修改如下:
source\class\table\table_common_moderate.php
查找public function fetch_all_by_search_for_post 处
把下段代码
return DB::fetch_all('SELECT p.pid, p.fid, p.tid, p.author, p.authorid, p.subject, p.dateline, p.message, p.useip, p.attachment, p.htmlon, p.smileyoff, p.bbcodeoff, p.status FROM %t m LEFT JOIN %t p on p.pid=m.id WHERE %i ORDER BY m.dateline DESC '.DB::limit($start, $limit), array($this->_get_table('pid'), $posttable, implode(' AND ', $wheresql)));
替换成
return DB::fetch_all('SELECT f.name AS forumname, f.allowsmilies, f.allowhtml, f.allowbbcode, f.allowimgcode, p.pid, p.fid, p.tid,
p.author, p.authorid, p.subject, p.dateline, p.message, p.useip, p.attachment, p.htmlon, p.smileyoff, p.bbcodeoff, t.subject, p.status
FROM %t m
LEFT JOIN %t p on p.pid=m.id
LEFT JOIN %t t ON t.tid=p.tid
LEFT JOIN %t f ON f.fid=p.fid
WHERE %i
ORDER BY m.dateline DESC '.DB::limit($start, $limit),
array($this->_get_table('pid'), $posttable, 'forum_thread', 'forum_forum', implode(' AND ', $wheresql)));
|