Last X Posts Titles on Non-VB page

Hi everyone,

Well, here is my first full release to the vB.org community. It's a small little script I just whipped up a few minutes ago. I already have this on my webpage for months now and thought I'd share it with the rest of you.

Description:
This script will display the titles, poster's names, and times of the last X's posts. It's fully customizable. Should be very easy to understand so enjoy!

Instructions:
1) Download the script below.
2) Change the settings in the script.
3) Insert include("/path/to/lastposts3.php"); anywhere in a non-VB page.

If you like to check out a live demo, you may go visit one of my sites: http://www.generazn.com.

If you have any problems, questions, or comments regarding this, feel free to post them here or send me an email to tre@phase1media.com.

[sammyman]

I am with Buddha. I am trying everything but it doesn't like me much. Where do I install this file, and what do I do for the include.

Any help for a beginer?

[sammyman]

I realized that the file lastposts3.php works, but it is not importing correctly into the non-VB page. I guess the import file is not right.

[sammyman]

Ok- I am an idiot. Don't answer my questions. I forgot the "s" in "lastposts". IDIOT.

[Oblivion Knight]

Here's an addon to exclude forums that I've quickly thrown together..

Find:

$limit = "10"; // Number of posts displayed.

Add below:

$excludeforums = ""; // The forums you want to exclude from being displayed, put their ID here.

Find:

if ($limit) {
	$limited = "LIMIT $limit";
}

Add below:

if ($excludeforums == "" or $excludeforums <= "0") {
	$quarter = "no";
} else {
	$excfid = explode(",",$excludeforums); $i = 0; $a = count($excfid);
	while ($i < $a) {
		$wheresql .= " AND thread.forumid!='$excfid[$i]'";	++$i;
	}
}

Find:

SELECT threadid,title,lastpost,lastposter

Add on the same line:

,forumid

Find:

WHERE visible=1

Add on the same line:

$wheresql

All done..

[sabret00the]

nice add-on, when i get round to installing this i'll try and write a truncating threadname add-on

[krohnathlonman]

Anybody using this on a higher traffic site? I'll do about 50k pageviews today... I'm using turk mmcache and the load didn't seem to jump very much, but it was noticeable.

[TYorke]

Alternating Row Colours

I added "outside" of the WHILE loop:

$color1 = "#DEDFDF";
$color2 = "#F7F7F7";
$rowcolorcount = 0;

"Inside" of the WHILE loop:

$rowcolor = ($rowcolorcount % 2) ? $color1 : $color2;

-- "Before" the final '}' at the end of the WHILE loop:

$rowcolorcount++;

add <tr bgcolor=\"$rowcolor\"> where you want your rows to change colours

Add Thread Replies and Views

Replace the entire line that starts with $thread_sql with:

$thread_sql = mysql_query("SELECT threadid,title,lastpost,lastposter,replycount,views FROM thread WHERE visible=1 AND open=1 $forumid ORDER BY lastpost DESC $limited");

Find:

$tid = $thread_get['threadid'];

Add underneath:

$view = $thread_get['views'];
$reply = $thread_get['replycount'];

Use something like <br />Replies: $reply | Views: $view where you want the counts to display

For an example check out http://www.cchl.ca/web/scripts/last.php

[nektar]

Hi!

If I could include the forum name of the post in the output this would be what I was looking for :squareeyed:

Any ideas?

[nektar]

Hi!

Thank you for the hack!

However, I would like to see a more advanced Top X posts on my homepage like I do now whith phpbb2.

What I would like to see is the forum name of each post + an icon next to each post showing if the post has been read or not by the visitor.

I know this is available for phpbb2 because I'm using it. Now I want to move to vbulletin but my visitors have used to see the last posts (and if they have read them or not) on my homepage.

Is this possible?

I think this would make the hack perfect.

Thanks.

[fabz]

Hello and thank you for this,

is there a way to get this script show post contents (like Pluhnews do for vb2) instead of only titles and posters ?