The Arcive of Official vBulletin Modifications Site.

LBmtb's Recent Topics on Non-VB Pages · **Released**: 12-18-2006

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:

HTML Code:

<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:

Code:

$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:

Code:

$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:

Code:

    $tid = $thread_get['threadid'];

AFTER, ADD:

Code:

    $text = $thread_get['post_text'];

FIND AND REPLACE:

Code:

forumid=".$value

WITH:

Code:

t.forumid=".$value

FIND:

Code:

    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:

Code:

    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

LBmtb · #32 12-21-2006, 02:39 PM

Quote:

Originally Posted by hornstar1337

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.

Thanks a lot for the info on the mispelling. Maybe I should have waited until after finals week to work on this? lol

I'll try and get the vbSEO one released tomorrow. Snippet of post is possible. What would be more useful: snippet of the last post made or of the first post?

Quote:

Originally Posted by 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.

BBcode sounds like a lot of work, lol. I'll look into it though . . .

LBmtb · #33 12-22-2006, 02:01 AM

Quote:

Originally Posted by s0b

EDIT: I forget to say that the vbSEO version will be great, i use it

Here ya go: linkage.

Hornstar · #34 12-24-2006, 11:50 AM

Im thinking first post would be more useful, maybe release this one as a second mod release, have it like a news system. so it displays a snipet of the post including all bb code. that would be really good for some more content on my homepage.

Thanks.

weicool · #35 12-26-2006, 04:42 PM

Hi, is there anyway to display only the name of the person who started the thread, and NOT the latest poster?

Never mind, I figured it out. Thanks for this nice script.

Hornstar · #36 01-04-2007, 01:24 AM

Quote:

Originally Posted by weicool

Hi, is there anyway to display only the name of the person who started the thread, and NOT the latest poster?

Never mind, I figured it out. Thanks for this nice script.

Mind sharing it, the more we have the better.

tonynlek · #37 01-31-2007, 01:20 PM

LBmtb,

I need help to install it and i dunno much about PHP. care to guide me along or anyone.

I do not know how to do this part:
<< The page it's on must have a .php extension or you should setup apache to parse the page correctly. >>

What must i do first?

saman · #38 02-03-2007, 01:43 PM

Quote:

Originally Posted by tonynlek

LBmtb,

I need help to install it and i dunno much about PHP. care to guide me along or anyone.

I do not know how to do this part:
<< The page it's on must have a .php extension or you should setup apache to parse the page correctly. >>

What must i do first?

facing the same problem

right now i have added it on .html extension and the only thing it shows is this:

recent topics by SocalTrailRiders.org

can someone help me out with this? i really like this mod, i am testing it and if he works i will need to get the copyright removed ($5)...

btw, where should i add this html code?

HTML Code:
<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>

tonynlek · #39 02-05-2007, 02:21 AM

As far as i know, You need to create an inframe in HTml page to put in the site address of that PHP file and it will open in the inframe.

I hate the borderline of the inframe, so my homepage has to be index.php, in order to put the code without the inframe border.

a programmer that i paid, told me this. I wonder why the script creator dun reply.

tonynlek · #40 02-05-2007, 03:42 AM

Quote:

// 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

How do you put the ID there?

Dave-ahfb · #41 02-05-2007, 03:56 PM

I am attempting to install this and it does works as designed, however I am trying to include multiple instances of the script on the same page, each instance using a different forum./

example:

top of page use only forum 14
middle of page use only forum 13

yadda yadda

I can include multiple instances of the same forum meaning I can place forum 14 in as many places of a page as I want, but I cannot get a second forum to show in a different location of the page.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.06349 seconds Memory Usage 2,374KB Queries Executed 26 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (8)bbcode_code (1)bbcode_html (4)bbcode_php (6)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!