vb.org Archive - Show most popular thread on index page

Page 3 of 3

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

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

- vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)

- - Show most popular thread on index page (https://vborg.vbsupport.ru/showthread.php?t=25755)

Boofo

06-22-2002 11:56 PM

Can you do both of these at the same time?

Quote:

Originally posted by PPN

Code:

//Most Popular Thread by Replies $popular=$DB_site->query_first("SELECT * FROM thread ORDER by replycount DESC LIMIT 1");

Code:

//Most Popular Thread by Views $popular=$DB_site->query_first("SELECT * FROM thread ORDER by views DESC LIMIT 1");

Exactly how would you insert this?

Code:

Then in either of your forumhome templates place $popularthread and the text "Most populat thread is THREADTITLE"

the threadtitle will be a link to the title.

musicfreak12399

06-23-2002 03:25 AM

have it like this

Code:

//Most Popular Thread by Replies 

$popularreply=$DB_site->query_first("SELECT * FROM thread ORDER by replycount DESC LIMIT 1");

Code:

//Most Popular Thread by Views 

$popularview=$DB_site->query_first("SELECT * FROM thread ORDER by views DESC LIMIT 1");

Template Change

Code:

Most popular thread by reply is <a href="showthread.php?s=$session[sessionhash]&threadid=$popularreply[threadid][threadid]">$popularreply[title]</a>

Code:

Most popular thread by views is <a href="showthread.php?s=$session[sessionhash]&threadid=$popularview[threadid][threadid]">$popularview[title]</a>

Boofo

06-23-2002 03:39 AM

Thanks but I still don't understand quite yet. What about the eval part that goes under it? Don't I need 2 of them? And what do I call the templates? Can you give me the complete code with this stuff in it, please? :) And is there any way to incorporate Lesane's addon for the character limit in these?

Quote:

Originally posted by musicfreak12399
have it like this

Code:

//Most Popular Thread by Replies $popularreply=$DB_site->query_first("SELECT * FROM thread ORDER by replycount DESC LIMIT 1");

Code:

//Most Popular Thread by Views $popularview=$DB_site->query_first("SELECT * FROM thread ORDER by views DESC LIMIT 1");

Template Change

Code:

Most popular thread by reply is <a href="showthread.php?s=$session[sessionhash]&threadid=$popularreply[threadid][threadid]">$popularreply[title]</a>

Code:

Most popular thread by views is <a href="showthread.php?s=$session[sessionhash]&threadid=$popularview[threadid][threadid]">$popularview[title]</a>

Boofo

06-23-2002 05:42 AM

How could I do this for the following code?

Code:

//Most Popular Thread by Replies 

$popularreply=$DB_site->query_first("SELECT * FROM thread ORDER by replycount DESC LIMIT 1");



//Most Popular Thread by Views 

$popularview=$DB_site->query_first("SELECT * FROM thread ORDER by views DESC LIMIT 1");

Quote:

Originally posted by Lesane
Great Hack PPN, i luv it but i had the "Show most popular thread" in a table and my most popular thread has a very long title, more then 40 characters so i reduced it 2 25.

Boofo

06-23-2002 05:45 AM

musicfreak12399,

I figured it out. Instead of making any templates, I just used the template code you gave directly in the forum home template. I put the first 2 parts in the index.php and that last 2 lines of code in the forumhome template. Is that what you meant?

Boofo

08-03-2002 09:33 PM

Is there any way to make these so they won't show a private forum or thread?

Snapperhaed

03-27-2003 02:12 AM

Nice Hack thanks. Installed on v2.3 #3 Easily. The code I used was that which was posted by 'musicfreak12399' above. There is a slight code difference.

On the forum home template, you will note that his code has an extra: '[threadid]' on it - While it will work that way, its not correct. Just remove it from the end and you should be fine.

Thanks!

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

Page 3 of 3

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01090 seconds Memory Usage 1,737KB 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 (12)bbcode_code_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (7)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: