last five threads of each forum on forum home?

[vB-Host.com]

Anyone have a hack to do something like this? http://www.elitetrader.com/vb/

[sabret00the]

if i was to think of a way to do it, it would be to introduce a new query for each forum, thus your server load goes up, but i aint a hacker, but it's pretty simple really, if no one helps you, i will try to

[vB-Host.com]

ok great!

[sabret00the]

since no one's helped you try this

this code is taken from nanoentity's top10 hack

// Top 10 Thread Replys
$pop = $DB_site->query("SELECT replycount,title,threadid,lastpost,postusername,la stposter,views FROM thread WHERE forumid<>'17' AND forumid<>'18' AND forumid<>'20' AND forumid<>'46' AND forumid<>'47' AND forumid<>'57' ORDER BY lastpost DESC LIMIT 5");
while ($poptop = mysql_fetch_array($pop)):
++$poptopnbsp;
$popthread .= "<a href=showthread.php?s=$session[sessionhash]&threadid=$poptop[threadid]>$poptop[title]</a>&nbsp;<a href=showthread.php?s=$session[sessionhash]&goto=newpost&threadid=$poptop[threadid]&goto=lastpost>&raquo;</a><br>";
$poppostusername .= "$poptop[postusername]<br>";
$poplastposter .= "$poptop[lastposter]<br>";
$popviews .= "$poptop[replycount] ($poptop[views])<br>";


endwhile;
fiddle witht hat make the nessassary references in your template and hey presto you should have it but then again i dunno nothing about php so i'm relying on my common sense :nervous: