vb.org Archive - Top 5 Last Threads On index.php

Page 1 of 2

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

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

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

- - Top 5 Last Threads On index.php (https://vborg.vbsupport.ru/showthread.php?t=57557)

mcyates

10-02-2003 10:09 PM

Top 5 Last Threads On index.php

I have the top.5.threads on my index page but the problem is, when i click on any of the top 5 newest threads it takes me to the first message posted. I need it to take me to the latest thead (the last thread) posted on the topic, does anyone know how this can be done. The code for the last 10 threads is below. If posswible could someone alter it for me and then post it in a reply to this topic. Thanks. Mine is called the Top 10 Thread Replys as i have set it to show 10 threads instead of 5.

Code:

// Top 10 Thread Replys

// Top 1 Most Popular Thread

$pop1 = $DB_site->query('SELECT title,threadid,views FROM thread ORDER BY views DESC LIMIT 1');

while ($pop1top = mysql_fetch_array($pop1)):

        ++$pop1topnbsp;

        $pop1title .= "<a href=showthread.php?s=$session[sessionhash]&threadid=$pop1top[threadid]>$pop1top[title]</a>";

        $pop1views .= "$pop1top[views]";

Thanks in advance

assassingod

10-03-2003 05:41 AM

PHP Code:


		
			
$pop1 = $DB_site->query('SELECT title,threadid,views,lastpost FROM thread ORDER BY lastpost DESC LIMIT 1');

while ($pop1top = mysql_fetch_array($pop1)):

    ++$pop1topnbsp;

    $pop1title .= "<a href=showthread.php?s=$session[sessionhash]&threadid=$pop1top[threadid]>$pop1top[title]</a>";

    $pop1views .= "$pop1top[views]";

Try that.

mcyates

10-03-2003 06:41 AM

nope that didn't work, just didn't show anything. Thanks for the try though. Is there anuthing else that may work.

assassingod

10-03-2003 01:34 PM

Try

PHP Code:


		
			
$pop1 = $DB_site->query('SELECT title,threadid,views,dateline FROM thread ORDER BY dateline DESC LIMIT 1'); 

while ($pop1top = mysql_fetch_array($pop1)): 

    ++$pop1topnbsp; 

    $pop1title .= "<a href=showthread.php?s=$session[sessionhash]&threadid=$pop1top[threadid]>$pop1top[title]</a>"; 

    $pop1views .= "$pop1top[views]";

mcyates

10-03-2003 04:33 PM

nope that didn't work either. But thanks again. Anyone else know?

assassingod

10-03-2003 04:40 PM

It should work. Also, why are you LIMITing to 1?

Use this, its templated as well so it's much better:

PHP Code:


		
			
$latestthread=$DB_site->query("SELECT title,threadid,lastpost FROM thread ORDER BY lastpost LIMIT 5");

    while ($latestthread=$DB_site->fetch_array($latestthreads)) {

  eval("\$fh_lthreads .= \"".gettemplate('forumhome_latestthreads)."\";");

}

Then creat a template called forumhome_latestthreads with the contents:

Code:

<a href="showthread.php?s=$session[sessionhash]&threadid=$latestthreads[threadid]">$latestthreads[title]</a>

Then use '$fh_lthreads' anywhere you want

That SHOULD work.

mcyates

10-04-2003 10:43 AM

that creates a parse error

sabret00the

10-04-2003 11:46 AM

that's relatively easy, suprised you didn't get that assassin, oh well, heres teh fix

PHP Code:


		
			
// Top 10 Thread Replys// Top 1 Most Popular Thread$pop1 = $DB_site->query('SELECT title,threadid,views FROM thread ORDER BY views DESC LIMIT 1');while ($pop1top = mysql_fetch_array($pop1)):    ++$pop1topnbsp;    $pop1title .= "<a href=showthread.php?s=$session[sessionhash]&goto=lastpost&threadid=$pop1top[threadid]>$pop1top[title]</a>";    $pop1views .= "$pop1top[views]";

sorted

sabret00the

10-04-2003 01:27 PM

awwww vb3 messed up the line breakes, but it's easy enough to read, i only changed one line, that's the one with the html in it

mcyates

10-04-2003 01:48 PM

thanks, i'll give it a try in 15 minutes

All times are GMT. The time now is 01:01 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.01166 seconds Memory Usage 1,743KB 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 (4)bbcode_php_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 (10)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: