Latest XX Threads on Forumhome Page

This hack will add your latest xx threads to your forum home page.
The good part is that you can do all this with only 1 query.

The following options are available:
- number of threads displayed
- alternating background color (same like the showthread view)
- thread's title (with link)
- thread's title lenght (just in case you use it in a small table)
- thread's icon
- thread's date and time
- thread's starter (with link)
- thread's no. of views
- thread's no. of replies

[high]The hack uses each forum's permissions.[/high]
In other words, if you have a private forum, your private threads will not show unless you have permissions to view them.

ESTIMATED INSTALL TIME: 5 minutes
REQUESTED BY: Nobody
TESTED IN VERSION: 2.2.7

To download the latest version of this hack, click below:

[Floris]

That would be interesting yes,
to also use this on a seperate.html (.php) none-vBulletin page.

By the way, I have your vB powered version running here: http://www.steroidology.com/forum/ on the bottom of the forumhome page. I added an extra header for it and put it in another table (row) so it had the lines and everything.

[350Chevy]

Is there anyway to make it show the last person who replied instead of the thread starter?

[GTGT]

CaMuscleguy:

can this be done on a usual html page isnetad of the forumhome page?

The 5 latest discussions on the Anabolic Forum

[Erwin]

Originally posted by TECK
1. You can't add the forum title, unless you do a query on the loop. You will end up with 40-50 queries... or you write a function for this...
2. Find:

$threads=$DB_site->query("SELECT * FROM thread WHERE open='1' AND open<>10 $iforumperms

Replace with:

$threads=$DB_site->query("SELECT * FROM thread WHERE open='1' AND open<>10 AND forumid=xx

where xx is your unique forum you want to grab the threads from.

TECK, not really. In my own version of this hack for my forums, I have included the forum title as well as the post replier plus thread starter, all with 1 query. No loop needed - just join it to the original query. Which is why I said at the start of this thread that you need to join for forumid.

[TECK]

True.

$threads = $DB_site->query("
  SELECT thread.*,thread.forumid as threadforumid,thread.title as threadtitle
  FROM thread
  LEFT JOIN forum ON (thread.forumid=forum.forumid)
  WHERE visible=1 AND open<>10 $iforumperms
  ORDER BY lastpost DESC $maxthreads
");

[Visionray]

Originally posted by xiphoid
That would be interesting yes,
to also use this on a seperate.html (.php) none-vBulletin page.

You can do that by just using the code in Teck's vBHome lite hack.

[obiwan8472]

Brilliant hack. Worked first time!

[Boofo]

Originally posted by Erwin


I have had my own version of this running on my forumhome for a few months now - yeah, mine runs with 1 query too. I also have the latest reply poster in as well as the forum category that the thread is in, using JOIN. Took me days to figure out how to join them - in the end Chen helped.

Would you be willing to share the code, "buddy"?

[user360]

I've installed the hack.. it works, but I want it to display the information in Columns instead of Rows, so I can put it on top of the forums instead of the side. How can I go about doing this

[PiotrasG]

how do i change this to last post not thread is there a hack for this or can i change it from inside of this hack