vb.org Archive - Showing Latest Posts on FORUMHOME

Page 1 of 2

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)

- - Showing Latest Posts on FORUMHOME (https://vborg.vbsupport.ru/showthread.php?t=326167)

scottkoz20

03-01-2018 01:46 PM

Showing Latest Posts on FORUMHOME

I'm not sure if this exists or if it even possible, but is there a mod that exists that will show the last X number of posts on the forumhome?

I have a sidebar block that does this now, but I would love to have this as a part of the forumhome

OR

Allowing the activity stream to be apart of the ForumHome

MarkFL

03-01-2018 07:04 PM

That would be easy enough to do, just depends on exactly what you want.

scottkoz20

03-01-2018 10:29 PM

well - my vision for this would be similar to what you built had for your featured threads mod... allowing from 5-20 of the latest post to show in the forumhome at the top of the page before the first forum section that would have
-- Timestamp
-- Username
-- Title
-- Forum posted in

I do like in the activity stream that it can dynamic tell when there are new posts

There would be some forums I'd like to exclude from this, but not a need

MarkFL

03-02-2018 12:20 AM

What if a thread has more than 1 new post in it...do you want that thread to show only once, but link to the oldest new post?

scottkoz20

03-02-2018 01:04 AM

Quote:

Originally Posted by MarkFL (Post 2593215)

What if a thread has more than 1 new post in it...do you want that thread to show only once, but link to the oldest new post?

yes - I would not want to have the same post on the list multiple times

romaine

03-03-2018 02:38 AM

Quote:

Originally Posted by scottkoz20 (Post 2593209)

You may interested in this mod https://vborg.vbsupport.ru/showthread.php?t=235841
and there are more similar mods like this on vBulletin, just using search function on this forum.

MarkFL

03-03-2018 03:32 AM

I'm going to begin on this soon...likely tomorrow.

scottkoz20

03-03-2018 03:08 PM

Quote:

Originally Posted by romaine (Post 2593230)

You may interested in this mod https://vborg.vbsupport.ru/showthread.php?t=235841
and there are more similar mods like this on vBulletin, just using search function on this forum.

the issue that I see with this mod is that it has more information than I would want to have on the page at this point.

Stratis

03-03-2018 06:43 PM

You can try this one
https://vborg.vbsupport.ru/showthread.php?t=232811 :)

scottkoz20

03-04-2018 02:40 PM

ill have to review this - thanks Stratis

MarkFL

03-06-2018 04:08 AM

1 Attachment(s)

I have attached a "first draft" of the product. Please give this a try and let me know of any changes you would like. :)

scottkoz20

03-06-2018 01:50 PM

Quote:

Originally Posted by MarkFL (Post 2593303)

I have attached a "first draft" of the product. Please give this a try and let me know of any changes you would like. :)

hey Mark -

When I enable this, my Forumhome triggers this SQL error - the rest of the forum is fine.

Code:

Database error in vBulletin 4.2.2:



Invalid SQL:



                SELECT post.*, thread.title, thread.forumid, thread.prefixid, thread.iconid, thread.postuserid, thread.dateline AS t_dateline, thread.pollid, thread.sticky, user.*, icon.iconpath, icon.title AS icon_title

                FROM post AS post

                INNER JOIN thread AS thread

                ON thread.threadid = post.threadid

                INNER JOIN user AS user

                ON user.userid = post.userid

                LEFT JOIN icon AS icon

                ON icon.iconid = thread.iconid

                LEFT JOIN phrase AS phrase

                ON phrase.varname = CONCAT('prefix_', thread.prefixid, '_title_rich')

                WHERE post.visible = 1

                ORDER BY post.dateline DESC;



MySQL Error   : Incorrect key file for table '/tmp/#sql_24f2_2.MYI'; try to repair it

Error Number  : 126

Request Date  : Tuesday, March 6th 2018 @ 09:42:49 AM

Error Date    : Tuesday, March 6th 2018 @ 09:43:55 AM

Script        : http://www.sportscardforum.com/forum.php

Referrer      : https://www.sportscardforum.com/admincp/index.php?do=head

IP Address    : 74.77.177.253

Username      : scottkoz20

Classname     : vB_Database_MySQLi

MySQL Version : 5.6.38

I have it off at the moment - I need to rebuild my dev site this week as I blew it up (had to try this live :erm: )

MarkFL

03-06-2018 02:18 PM

1 Attachment(s)

Ah, I didn't take into account running this query on a large database. I have put a limit on the query...try this updated version please. :)

scottkoz20

03-06-2018 02:32 PM

same error

Code:

Database error in vBulletin 4.2.2:



Invalid SQL:



                SELECT post.*, thread.title, thread.forumid, thread.prefixid, thread.iconid, thread.postuserid, thread.dateline AS t_dateline, thread.pollid, thread.sticky, user.*, icon.iconpath, icon.title AS icon_title

                FROM post AS post

                INNER JOIN thread AS thread

                ON thread.threadid = post.threadid

                INNER JOIN user AS user

                ON user.userid = post.userid

                LEFT JOIN icon AS icon

                ON icon.iconid = thread.iconid

                LEFT JOIN phrase AS phrase

                ON phrase.varname = CONCAT('prefix_', thread.prefixid, '_title_rich')

                WHERE post.visible = 1

                ORDER BY post.dateline DESC

                LIMIT 10;



MySQL Error   : Incorrect key file for table '/tmp/#sql_24f2_2.MYI'; try to repair it

Error Number  : 126

Request Date  : Tuesday, March 6th 2018 @ 10:23:52 AM

Error Date    : Tuesday, March 6th 2018 @ 10:25:35 AM

Script        : http://www.sportscardforum.com/forum.php

Referrer      : https://www.sportscardforum.com/admincp/index.php?do=head

IP Address    : 74.77.177.253

Username      : scottkoz20

Classname     : vB_Database_MySQLi

MySQL Version : 5.6.38

--------------- Added [DATE]1520354018[/DATE] at [TIME]1520354018[/TIME] ---------------

i wonder if the issue is on my /tmp directory

MarkFL

03-06-2018 02:37 PM

Hmm...I have never encountered that error before, and doing a search led me to believe it was due to a disk space issue on your server as a result of a query on all your posts. So, I figured limiting the query would cure it.

Dave	03-06-2018 02:45 PM

Looks like OP needs to run a repair & optimize query against his database.

scottkoz20

03-06-2018 02:58 PM

Quote:

Originally Posted by MarkFL (Post 2593316)

is it possible to limit the query to the last day (24 hours)

In the meantime, I am working on table optimization and checking space issue on /tmp on my server

MarkFL

03-06-2018 03:39 PM

1 Attachment(s)

Quote:

Originally Posted by scottkoz20 (Post 2593319)

is it possible to limit the query to the last day (24 hours)

In the meantime, I am working on table optimization and checking space issue on /tmp on my server

I've added an optional "Hours Limit" setting that will allow you to select posts made only during the last x hours.

CAG CheechDogg

03-06-2018 04:30 PM

Where exactly is this supposed to display and what does it look like ? lol ...

MarkFL

03-06-2018 04:42 PM

1 Attachment(s)

Quote:

Originally Posted by CAG CheechDogg (Post 2593321)

Where exactly is this supposed to display and what does it look like ? lol ...

It displays on the index script (home) as well as other selected scripts, a block containing links to the most recent posts. Here's a screenshot from my local dev site:

https://vborg.vbsupport.ru/attachmen...1&d=1520361685

CAG CheechDogg

03-06-2018 04:57 PM

1 Attachment(s)

Weird ... for me it only shows the tittle

scottkoz20

03-06-2018 05:04 PM

1 Attachment(s)

Mark -

Well, I got past the SQL errors (the time seemed to help as optimization is still going :rolleyes: )

However, I get no posts when I enable the modification

MarkFL

03-06-2018 05:08 PM

Scott, it looks like you have the block collapsed?

CAG CheechDogg

03-06-2018 05:09 PM

Quote:

Originally Posted by scottkoz20 (Post 2593324)

Mark -

Well, I got past the SQL errors (the time seemed to help as optimization is still going :rolleyes: )

However, I get no posts when I enable the modification

Exactly what I got too ...

--------------- Added [DATE]1520363400[/DATE] at [TIME]1520363400[/TIME] ---------------

Quote:

Originally Posted by MarkFL (Post 2593325)

Scott, it looks like you have the block collapsed?

I don't have it collapsed myself and it still doesn't show

MarkFL

03-06-2018 05:12 PM

Quote:

Originally Posted by CAG CheechDogg (Post 2593326)

Exactly what I got too ...

--------------- Added [DATE]1520363400[/DATE] at [TIME]1520363400[/TIME] ---------------

I don't have it collapsed myself and it still doesn't show

Can I get a link to your site, so I can inspect the DOM?

scottkoz20

03-06-2018 05:13 PM

does the samething as what CAG is seeing -

I'll PM you with my site info

CAG CheechDogg

03-06-2018 05:16 PM

Here it is ..

https://www.cagclan.com/community/forum.php

scottkoz20

03-06-2018 05:30 PM

1 Attachment(s)

Ok Mark - what did you do?

MarkFL

03-06-2018 05:34 PM

1 Attachment(s)

I had a variable used from another addon, which wasn't aan issue for me, but was for everyone else.

Scott, I have updated your site with the latest update, and for everyone else, I attach it here.

CAG CheechDogg

03-06-2018 05:40 PM

Good stuff Mark .. as always good stuff !!

scottkoz20

03-06-2018 05:48 PM

this is really cool... simple yet slick

thank you very much

MarkFL

03-06-2018 05:51 PM

Quote:

Originally Posted by scottkoz20 (Post 2593335)

this is really cool... simple yet slick

thank you very much

Glad to help out, and it you think of any features you'd like to add, feel free to let me know. One thing might be an option to truncate long forum names, and include the forum description in the tooltip.

CAG CheechDogg

03-06-2018 06:04 PM

Mark ... why do I have a scroll bar on mine? can I set the height or have the height be set automatically depending on the amount of threads to be shown?

scottkoz20

03-06-2018 06:12 PM

Quote:

Originally Posted by MarkFL (Post 2593336)

For me, I think having the Thread Started isn't fully needed for my site - I would probably move the posttime in the first column and just the member that posted the thread. This would leave more room for the longer names on the forums and thread Topic.

I'm not sure if number of replies would be needed for me, but I think some folks might want to see this.

MarkFL

03-06-2018 06:12 PM

In the settings, if your "Default/Minimum Rows" is 1 more than the "Number Of Posts" then there won't be a scrollbar, because the column headers count as 1 row. I gave a default height so that you could show a large number of posts without having a tall block displayed.

--------------- Added [DATE]1520367361[/DATE] at [TIME]1520367361[/TIME] ---------------

Quote:

Originally Posted by scottkoz20 (Post 2593338)

I will add a setting tonight that will allow you to choose which columns you want in the display. :)

CAG CheechDogg

03-06-2018 06:47 PM

How can I edit the height or just make it auto depending on the amount of posts Mark?

MarkFL

03-06-2018 06:52 PM

Quote:

Originally Posted by CAG CheechDogg (Post 2593341)

How can I edit the height or just make it auto depending on the amount of posts Mark?

If you want it to just show all the posts, set "Default/Minimum Rows" to 1 more than the "Number Of Posts."

MarkFL

03-07-2018 01:32 AM

1 Attachment(s)

I have attached the latest update, which allows all but the last column to be optional, and allows for the selection of the styles in which the product is active.

scottkoz20

03-07-2018 10:55 AM

i will test this out later this morning after I get done with the real job :D

--------------- Added [DATE]1520449168[/DATE] at [TIME]1520449168[/TIME] ---------------

hey mark - i was having server issues this morning/ early afternoon - I am going to hold off testing this until stable

MarkFL

03-07-2018 07:09 PM

1 Attachment(s)

I have removed an unneeded query, and attached the latest update.

All times are GMT. The time now is 06:21 PM.

Page 1 of 2

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01376 seconds Memory Usage 1,828KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (14)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (40)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: