Integration with vBulletin - LBmtb's Recent Topics on Non-VB Pages

RECENT TOPICS by LBmtb
Version 1.03
Last updated: March 27th, 2007

DESCRIPTION
This script will display the topics with the most recent posts on a non-vb page (any HTML page). The page it's on must have a .php extension or you should setup apache to parse the page correctly. The threads with the latest posts are on top. The output is a clean list in this format:

<ul class="vb_topics">
<li><a href="http://www.yourdomain.com/forum/showthread.php?t=4150">This is the latest thread</a> <span class="vb_last_post">(user1 @ 12/18/06 05:58 PM)</span></li>
<li><a href="http://www.yourdomain.com/forum/showthread.php?t=4138">Another recent thread</a> <span class="vb_last_post">(user2 @ 12/18/06 05:58 PM)</span></li>
</ul>

Customizable options include:

• forum ID - choose to only include or exclude certain forums
• number of topics displayed
• CSS class names for the topic name/url and last poster/date
• and a few others

COPYRIGHT
There is a copyright line. I am releasing this script on the condition that you do not remove this line unless you send $5 via paypal to webmaster@socaltrailriders.org. Thanks in advance for understanding.

NEED CUSTOMIZATION OR PROFESSIONAL INSTALLATION?
Email me at webmaster@socaltrailriders.org, PM me on vbulletin.org, or aim me at "lbmtb" to inquire about customizing this script or installation.

REVISION HISTORY
Version 1.03: Adds small preview of first post when the user rolls over the links
Version 1.02: option to exclude certain forums
Version 1.01: option to only include certain forums
Version 1.0: Initial Release

INSTRUCTIONS:
1) Copy and paste the following code where you want the list to appear and adjust the values in the section "CUSTOMIZE THE FOLLOWING":

PHP Code:

<?php 
##########################################################################
// RECENT TOPICS by LBmtb
// Version 1.03
// 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
$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"

// use one or the other, not both. if left blank the script will return threads from any forum
$fid_raw = ""; // ONLY include threads from these forums. seperate each ID with a comma
$fidx_raw = ""; // Exclude threads from these forum. seperate each ID with a comma

// 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";
$fid_array = explode (',', $fid_raw);
if ($fid_raw)  {
    $fid_final .= "AND (";
    foreach( $fid_array as $key => $value){
        if ($key == 0) { $fid_final .= "t.forumid=".$value; }
        else { $fid_final .= " OR t.forumid=".$value; }
    }
    $fid_final .= ")";
}
$fidx_array = explode (',', $fidx_raw);
if ($fidx_raw)  {
    $fidx_final .= "AND NOT (";
    foreach( $fidx_array as $key => $value){
        if ($key == 0) { $fidx_final .= "t.forumid=".$value; }
        else { $fidx_final .= " OR t.forumid=".$value; }
    }
    $fidx_final .= ")";
}
$thread_sql = mysql_query("SELECT SQL_CACHE t.threadid,t.title,t.lastpost,t.lastposter,t.forumid,substring(p.pagetext,1,90) as post_text
    FROM ".$GLOBALS['db_prefix']."thread t
    INNER JOIN ".$GLOBALS['db_prefix']."post p
    ON t.firstpostid = p.postid
    WHERE t.visible=1 
    AND t.open=1 $fidi_final $fidx_final 
    ORDER BY t.lastpost desc 
    LIMIT $limit");
while($thread_get=@mysql_fetch_array($thread_sql))
{
    $lastpost = $thread_get['lastpost'];
    $poster = $thread_get['lastposter'];
    $tid = $thread_get['threadid'];
$text = $thread_get['post_text'];
    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\" title=\"".$text."\">$thread_get[title]</a> <span class=\"$recent_poster\">($poster $seperator $date2)</span></li>\n";
}
echo "</ul>\n<div style=\"font-size: .9em;\">recent topics by <a href=\"http://www.socaltrailriders.org/\"><acronym title=\"Southern California Trail Riders\">SocalTrailRiders.org</acronym></a></div>";
mysql_close($recent_topics_connection);
?>

2) Go back to the vbulletin.org thread where you found this and click on "Mark as Installed"
3) Enjoy!
4) Donate (this step optional)


UPGRADE INSTRUCTIONS (from 1.02 to 1.03):

FIND:

$thread_sql = mysql_query("SELECT threadid,title,lastpost,lastposter FROM ".$db_prefix."thread WHERE visible=1 AND open=1 $fid_final $fidx_final ORDER BY lastpost desc LIMIT $limit");

REPLACE WITH:

$thread_sql = mysql_query("SELECT SQL_CACHE t.threadid,t.title,t.lastpost,t.lastposter,t.forumid,substring(p.pagetext,1,90) as post_text
    FROM ".$GLOBALS['db_prefix']."thread t
    INNER JOIN ".$GLOBALS['db_prefix']."post p
    ON t.firstpostid = p.postid
    WHERE t.visible=1 
    AND t.open=1 $fidi_final $fidx_final 
    ORDER BY t.lastpost desc 
    LIMIT $limit");

FIND:

    $tid = $thread_get['threadid'];

AFTER, ADD:

    $text = $thread_get['post_text'];

FIND AND REPLACE:

forumid=".$value

WITH:

t.forumid=".$value

FIND:

    echo "<li><a href=\"$forum_url/showthread.php?t=$tid\">$thread_get[title]</a> <span class=\"$recent_poster\">($poster $seperator $date2)</span></li>\n";

REPLACE WITH:

    echo "<li><a href=\"$forum_url/showthread.php?t=$tid\" title=\"".$text."\">$thread_get[title]</a> <span class=\"$recent_poster\">($poster $seperator $date2)</span></li>\n";

UPGRADE INSTRUCTIONS (from 1.01 to 1.02):

FIND:

PHP Code:

// APEARANCE OPTIONS
$seperator = "@"; // this goes between last poster and date
$fid_raw = ""; // If you want to restrict to specific forums, enter the forum id(s) here. seperate them with a comma. 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" 


REPLACE WITH:

PHP Code:

// APEARANCE OPTIONS
$seperator = "@"; // this goes between last poster and date
$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"

// use one or the other, not both. if left blank the script will return threads from any forum
$fid_raw = ""; // ONLY include threads from these forums. seperate each ID with a comma
$fidx_raw = ""; // Exclude threads from these forum. seperate each ID with a comma 


REPLACE EVERYTHING BELOW:

PHP Code:

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


With everything below that same line in 1.02

NOTES:
This is my first mod/script so be nice, please

DEMO:
http://www.socaltrailriders.org/latest_posts.php

[Injektilo]

LBmtb: all db settings seems to be ok ... its kind of weird why it doesnt work :S

[Hornstar]

I'm about to install this now. I think ill donate you the $5 as well, because i'm hoping you may be able to help me with getting it to fit into the current style of my site, as I know ill end up having trouble with that part.

Also what are the chances you will release other vbadvanced mods for non vb pages? Because then you would be my god lol. There are all these mods that I used to use, but since going to a non vb page for my homepage, I have not been able to use any of them.

[LBmtb]

Originally Posted by hornstar1337

I'm about to install this now. I think ill donate you the $5 as well, because i'm hoping you may be able to help me with getting it to fit into the current style of my site, as I know ill end up having trouble with that part.

Also what are the chances you will release other vbadvanced mods for non vb pages? Because then you would be my god lol. There are all these mods that I used to use, but since going to a non vb page for my homepage, I have not been able to use any of them.

Thanks a lot, hornstar. I don't have msn. Do you have aim? I'm lbmtb on there.

Chances of releasing vbadvanced mods for non vb pages are fairly slim. I don't and have never used vbadvanced before. I also have an upcoming events script on my site - that one I got off of vbulletin.org. I'm sure you can find it if you search. PM me with mod ideas if you'd like.

[firstrebel]

Originally Posted by Injektilo

i've entered my db settings but it only outputs this

I have this same problem. v1.00 works but v1.01 does not.

Bob

[LBmtb]

Ah, dangit. You guys are right. Here's the fix:

FIND:

PHP Code:

if ($fid_array)  { 


REPLACE WITH:

PHP Code:

if ($fid_raw)  { 


I updated the top instructions. Sorry!

[LBmtb]

Plan for tomorrow: Add the ability to exclude forums. Currently you can only specify forums to include.

The include would be useful if you want threads from just one or two forums. If you want most forums to be displayed except for one or two then you'd want to use the exclude thing.

[firstrebel]

Originally Posted by LBmtb

Ah, dangit. You guys are right. Here's the fix:

FIND:

PHP Code:

if ($fid_array)  { 


REPLACE WITH:

PHP Code:

if ($fid_raw)  { 


I updated the top instructions. Sorry!

All OK now, thanks.

Bob

[LBmtb]

Originally Posted by firstrebel

All OK now, thanks.

Bob

Good to hear!

Updated the script with the ability to exclude certain forums. Included upgrade instructions from 1.01. So now you can either specify forums to include OR forums to exclude.

Anybody have any suggestions for future releases?

[Hornstar]

Well I sent you a list of other mods suggestions, but so far this looks great. I'm just trying to get it positioned into the right spot on my homepage tho, i'll probably spend hours on that lol.

Some suggestions could be to also include a snipet of the post, and if you do that, then I have heaps of ideas to go on from their.

also do you have the vbseo version?

also you misspelled your domain name in the copyright part.

Thanks.

[4yBak]

hm... maybe you know how to parse bb-codes stored in DB ? I was did similar task, but I have trouble with parsing vBulletin bb-codes

More info here.