[LBmtb]

Originally Posted by OmniBuzz

any chance to have a version that would add an "updated threads" list ?
Like :
palm spring ...(created by outlaw blabla, last answer by neil blabla)

Here ya go:

<?php 
##########################################################################
// RECENT TOPICS by LBmtb
// webmaster@socaltrailriders.org OR aim: LBmtb
//
// Do not remove copyright unless you donate $5 via paypal
// to the above email address, thanks
// CUSTOMIZED from a www.phase1media.com script found here:
// https://vborg.vbsupport.ru/showpost.php?p=589067&postcount=7
##########################################################################

## CUSTOMIZE THE FOLLOWING	##############################################

// DATABASE & URL SETTINGS
$db_host = "localhost"; // Change this if your MySQL database host is different.
$db_name = "db_name"; // Change this to the name of your database.
$db_user = "db_username"; // Change this to your database username.
$db_pw = "db_password"; // Change this to your database password.
$db_prefix = "vb_"; // Change to your tables' prefix. Usually vb_
$forum_url = "http://www.yourdomain.com/forum"; // Change this to reflect to your forum's URL.

// APEARANCE OPTIONS
$seperator = "@"; // this goes between last poster and date
$forum_id = ""; // If you wish to display the posts from a specific forum, enter the forum id here. Otherwise, leave it blank.
$limit = "10"; // Number of posts displayed
$post_date_format = "1"; // leave as 1 for "12/18/06 05:26 PM" or change to 2 for "05:26 PM"

// CSS CLASSES	
$recent_topics = "vb_topics"; // you can use CSS to adjust the presentation of the list 
$recent_poster = "vb_last_post";  // you can use CSS to adjust the presentation the last poster and date

## NO NEED TO TOUCH ANYTHING BELOW	#####################################
#########################################################################

if (!($recent_topics_connection = mysql_connect("$db_host", "$db_user", "$db_pw")))
die ("could not connect"); 
if (!(mysql_select_db("$db_name", $recent_topics_connection)))
mysql_error(); 
echo "<ul class=\"$recent_topics\">\n";
if ($forum_id) { $forumid = "AND forumid=$forum_id"; }
$thread_sql = mysql_query("SELECT threadid,title,lastpost,lastposter, postusername FROM ".$db_prefix."thread WHERE visible=1 AND open=1 $forumid ORDER BY lastpost desc LIMIT $limit");
while($thread_get=@mysql_fetch_array($thread_sql))
{
	$lastpost = $thread_get['lastpost'];
	$firstpost = $thread_get['postusername'];
	$poster = $thread_get['lastposter'];
	$tid = $thread_get['threadid'];
	if ($post_date_format == "1") { $date2 = date ("m/d/y h:i A" ,$lastpost); }
	elseif ($post_date_format == "2") { $date2 = date ("h:i A" ,$lastpost); }
	else { $date2 = date ("m/d/y h:i A" ,$lastpost); }
	echo "<li><a href=\"$forum_url/showthread.php?t=$tid\">$thread_get[title]</a> <span class=\"$recent_poster\">(created by: $firstpost, last reply by: $poster $seperator $date2)</span></li>\n";
}
echo "</ul>\n<div style=\"font-size: .9em;\">recent topics by <a href=\"http://wwwsocaltrailriders.org/\"><acronym title=\"Southern California Trail Riders\">SocalTrailRiders.org</acronym></a></div>";
mysql_close($recent_topics_connection);
?>

That will stick "(created by: MOSH1DH, last reply by: SAR_boats @ 12/18/06 09:23 PM)" at the end of it. Looks a bit long to me? What would be a better format for it?

Well if you set $post_date_format to 2 then it'll only have 09:23 PM for the last post time. That should ease up on the clutter.

UPDATE: Instructions for this functionality are in post 17.