https://forum.andowson.com/posts/list/7.page JForum - http://www.jforum.net [code=sql]
TopicModel.selectAllByForumByLimit = SELECT t.*, p.user_id AS last_user_id, p.post_time, (SELECT SUM(p.attach) \
FROM jforum_posts p \
WHERE p.topic_id = t.topic_id \
AND p.need_moderate = 0) AS attach \
FROM jforum_topics t, jforum_posts p \
WHERE (t.forum_id = ? OR t.topic_moved_id = ?) \
AND p.post_id = t.topic_last_post_id \
AND p.need_moderate = 0 \
ORDER BY t.topic_type DESC, t.topic_last_post_id DESC \
OFFSET ? LIMIT ?

TopicModel.selectByUserByLimit = SELECT t.*, p.user_id AS last_user_id, p.post_time, (SELECT SUM(p.attach) \
FROM jforum_posts p \
WHERE p.topic_id = t.topic_id \
AND p.need_moderate = 0) AS attach \
FROM jforum_topics t, jforum_posts p \
WHERE p.post_id = t.topic_last_post_id \
AND t.user_id = ? \
AND p.need_moderate = 0 \
AND t.forum_id IN(:fids:) \
ORDER BY t.topic_last_post_id DESC \
OFFSET ? LIMIT ?
[/code]
登入管理介面後清除主題的Cache即可]]> https://forum.andowson.com/posts/preList/165/255.page https://forum.andowson.com/posts/preList/165/255.page GMT insertSave():
[code]
attachments.insertAttachments(p);
t.setHasAttach(t.hasAttach() || p.hasAttachments());
[/code]
editSave():
[code]
attachments.insertAttachments(post);
t.setHasAttach(t.hasAttach() || post.hasAttachments());
[/code]
不過，這個方法有個bug，就是如果該主題只有一篇文章有附件，然後又把附件都刪光了，還是會顯示有附件。但是，一般來說通常發表有附件的文章後不太會去刪附件，而且重先載入JForum後也會正常顯示，所以這個應該算可以接受的bug吧！]]> https://forum.andowson.com/posts/preList/165/297.page https://forum.andowson.com/posts/preList/165/297.page GMT