• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

[1.1.x] Recent Posts Forum Index (Smf Style) [Paid] [Deleted]

borbole

Well-known member
#1
borbole submitted a new resource:

Recent Posts Forum Index (Smf Style) (version 1.0) - Recent Posts Forum Index (Smf Style)

This mod will add the most recent posts of your forum at the bottom of your board index. Kinda liek Smf does but in more advanced way. Invisible posts and posts started by banned members will not show up. Also the group/groups that does/have not permissions to view a forum, will not be able to see the posts from the forum/forums that they are not allowed to view. And the posters names will be styled if the group they belong to is styled.

Installation. First unzip the mod package and ftp the...
Read more about this resource...
 

Brent W

Well-known member
#2
Seems some performance issues exists with this:

PHP:
# Time: 120730 10:34:19
# User@Host: xxxx[xxxx] @ localhost []
# Query_time: 99.313858  Lock_time: 0.000049 Rows_sent: 5  Rows_examined: 807237
SET timestamp=1343662459;
SELECT post.*, thread.*, user.*,^M
                        forum.title AS node_title, forum.node_id AS node_id^M
            FROM xf_post AS post^M
            LEFT JOIN xf_thread AS thread ON (thread.thread_id = post.thread_id)^M
            LEFT JOIN xf_user AS user ON (user.user_id = post.user_id)^M
                        LEFT JOIN xf_node AS forum ON (forum.node_id = thread.node_id)^M
                        WHERE NOT ISNULL(thread.thread_id) ^M
            AND post.message_state = 'visible'^M
                        AND user.is_banned = 0^M
                        GROUP BY post.post_id^M
            ORDER BY post.post_date DESC^M
        LIMIT 5;
 

Brent W

Well-known member
#3
Every time I enable this product it adds seconds to the page load and shows up in slow query log.....

PHP:
# Time: 120801 14:19:19
# User@Host: xxxx[xxxx] @ localhost []
# Query_time: 11.521370  Lock_time: 0.000028 Rows_sent: 5  Rows_examined: 807532
use cruising_xen;
SET timestamp=1343848759;
SELECT post.*, thread.*, user.*,^M
                        forum.title AS node_title, forum.node_id AS node_id^M
            FROM xf_post AS post^M
            LEFT JOIN xf_thread AS thread ON (thread.thread_id = post.thread_id)^M
            LEFT JOIN xf_user AS user ON (user.user_id = post.user_id)^M
                        LEFT JOIN xf_node AS forum ON (forum.node_id = thread.node_id)^M
                        WHERE NOT ISNULL(thread.thread_id) ^M
            AND post.message_state = 'visible'^M
                        AND user.is_banned = 0^M
                        GROUP BY post.post_id^M
            ORDER BY post.post_date DESC^M
        LIMIT 5;
PHP:
# Time: 120801 14:20:14
# User@Host: xxxxl[xxxx] @ localhost []
# Query_time: 10.157922  Lock_time: 0.000024 Rows_sent: 5  Rows_examined: 807532
SET timestamp=1343848814;
SELECT post.*, thread.*, user.*,^M
                        forum.title AS node_title, forum.node_id AS node_id^M
            FROM xf_post AS post^M
            LEFT JOIN xf_thread AS thread ON (thread.thread_id = post.thread_id)^M
            LEFT JOIN xf_user AS user ON (user.user_id = post.user_id)^M
                        LEFT JOIN xf_node AS forum ON (forum.node_id = thread.node_id)^M
                        WHERE NOT ISNULL(thread.thread_id) ^M
            AND post.message_state = 'visible'^M
                        AND user.is_banned = 0^M
                        GROUP BY post.post_id^M
            ORDER BY post.post_date DESC^M
        LIMIT 5;
 

CritiKiL

Active member
#5
I have a simple request. The addon is working perfectly for me. However I AM having a 'small' width issue and I would like to tweak with it a bit. Some of the members names are fairly long so that is forcing the width of the forum to stretch the boundaries. I would like to try to make the "Recent Posts" or "Post Date" a little smaller? Here's an image:

IMG_0898[1].PNG
 
#6
Are the performance issues being fixed in an update? Is this compatible with 1.2.x? I'll buy this instead of making it again myself. Does it work with the responsive design?
 

borbole

Well-known member
#9

OperaManiac

Well-known member
#14
Thanks. I noticed you are looking for a buyer for all your mods. This sort of worries me. You no longer plan to develop for XenForo? I mean I do not expect lifetime of updates and support but a few months would be nice!