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

s0b · #12 12-19-2006, 08:09 AM

Its possible to export this mod to a Javascript that lent me some like this:

Code:

<script type="text/javascript" language="JavaScript1.2">
    var parameter1=value1;
    var parameter2=value2;
    etc.

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

projectego · #13 12-19-2006, 11:36 AM

Awesome! Thanks for this.

LBmtb · #14 12-19-2006, 12:44 PM

Quote:

Originally Posted by firstrebel

Still shows AM/PM after doing this. Nice mod, better than the one from vB's support site, which is never up-to-date.

Installed.

Bob

Oops, didn't notice the lack of AM/PM. Only noticed the 24hr time (it's finals week here and I'm tired). I updated post #9 - now it takes out AM/PM also.

If you modified it like I said before and it shows 24hr time and AM/PM just do a find/replace turning "H:i A" into "H:i".

Quote:

Originally Posted by s0b

Its possible to export this mod to a Javascript that lent me some like this:

Code:

<script type="text/javascript" language="JavaScript1.2">
    var parameter1=value1;
    var parameter2=value2;
    etc.

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

Sorry, I don't know javascript. I'll see about releasing the vbSEO one tonight.

Quote:

Originally Posted by projectego

Awesome! Thanks for this.

You're welcome.

Amenadiel · #15 12-19-2006, 01:48 PM

I use something similar based on a stripped vaispy code (without the scrolling part) inside an iframe. I use this because I need it to look at the permissions, so gathering data directly from the database wouldn't suit my needs.

Congratz anyway.

firstrebel · #16 12-19-2006, 02:42 PM

Quote:

If you modified it like I said before and it shows 24hr time and AM/PM just do a find/replace turning "H:i A" into "H:i".

Works fine, thanks.

Bob

LBmtb · #17 12-19-2006, 03:41 PM

Quote:

Originally Posted by Amenadiel

I use something similar based on a stripped vaispy code (without the scrolling part) inside an iframe. I use this because I need it to look at the permissions, so gathering data directly from the database wouldn't suit my needs.

Congratz anyway.

Thanks for pointing that out, I didn't think about permissions and such. I'll make a version tonight that selects only public forums. The option "$forum_id =" in the current script only works when one forum is selected. The new version will take multiple forum ID's separated by commas.

Stay tuned.

LBmtb · #18 12-19-2006, 04:55 PM

UPDATE: uploaded a new version that can restrict the threads to just a select number of forums. If you want to use this feature, modify "$fid_raw =" (there's instructions in the code).

It won't check whether the user is logged in and what he/she has permission to. But you can simply restrict it to forums that you want to be publicly available.

edit: Added following instructions.

In this newer version, if you guys want to include the thread creator as was discussed in post 7, do this:
FIND:

PHP Code:


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

REPLACE WITH:

PHP Code:


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

FIND:

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

PHP Code:


			
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";

The time instructions are still the same to change from 12hr to 24hr.

Anybody need upgrade instructions to go from 1.00 if you already installed it to 1.01? Only new functionality is to be able to restrict threads to multiple forums.

Injektilo · #19 12-19-2006, 06:13 PM

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

Quote:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04703 seconds Memory Usage 2,390KB 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 (10)bbcode_code (1)bbcode_html (8)bbcode_php (8)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 (3)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!