Howto: have the 10 newest posts on my homepage

[jer2eydevil88]

I would like to have the 10 newest posts titles show up on the homepage for my site, the best idea I can come up with is to use an rss feed reader (although I don't think the forum software supports feeds) or something equivalent to that unless someone has a better idea.

[nico_swd]

Originally Posted by jer2eydevil88

(although I don't think the forum software supports feeds)

https://vborg.vbsupport.ru/faq.php?f...ss_syndication

[EnIgMa1234]

Create a new plugin

Product: vBulletin
Hook: forumhome_complete

In the box add:

PHP Code:

$query = $vbulletin->db->query_read("SELECT * FROM " . TABLE_PREFIX . "thread ORDER BY lastpost DESC LIMIT 10");

while ($last = $vbulletin->db->fetch_array($query))
{
$lasttitle = $last['title']<br />;
} 


Now you can use $lasttitle in your forumhome template

[amnesia623]

This only displays one 'latest thread'

Is there a way to fix it?
Thanks!

[Opserty]

He forgot a '.'

PHP Code:

$query = $vbulletin->db->query_read("SELECT * FROM " . TABLE_PREFIX . "thread ORDER BY lastpost DESC LIMIT 10");

while ($last = $vbulletin->db->fetch_array($query))
{
// If you want to link to the thread to use $lasttitle .= '<a href="showthread.php?t='. $last['threadid'] .'">'. $last['title'] .'</a><br />';
$lasttitle .= $last['title']<br />;
} 


[amnesia623]

AHH...thank you!

How would you go about coding this to follow forum permissions?

I really appreciate any help!

[amnesia623]

Does this still work in 3.7? I can't seem to get it to work...

[mrkhm]

thank you this works perfectly in vb 3.6.x

quick question for anyone is there anyway to limit it to only show titles from specific forums should i be doing

select * from where something something is = to something

thanks anyway

[Opserty]

Originally Posted by mrkhm

thank you this works perfectly in vb 3.6.x

quick question for anyone is there anyway to limit it to only show titles from specific forums should i be doing

select * from where something something is = to something

thanks anyway

Change the MySQL query to:
[sql]
SELECT title, threadid FROM ". TABLE_PREFIX ."thread WHERE forumid IN (X, Y, Z) ORDER BY lastpost DESC LIMIT 10"[/sql]

Change [minicode]title, threadid[/minicode] to * if you want to select all fields.

X, Y, Z Being a comma separated list of the ForumID numbers.

[mrkhm]

ahhh! many thanks opserty! that works absolutely absolutely perfectly