The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
LBmtb's Recent Topics on Non-VB Pages Details »» | |||||||||||||||||||||||||
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>
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:
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"); 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"); Code:
$tid = $thread_get['threadid']; Code:
$text = $thread_get['post_text']; Code:
forumid=".$value Code:
t.forumid=".$value 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"; 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:
PHP Code:
PHP Code:
NOTES: This is my first mod/script so be nice, please DEMO: http://www.socaltrailriders.org/latest_posts.php Supporters / CoAuthors Show Your Support
|
Comments |
#2
|
|||
|
|||
I'll be cool like all the veterans out there and reserve the first post.
|
#3
|
||||
|
||||
hmm... looks interesting. what would this be handy for?
|
#4
|
|||
|
|||
Probably most useful for people who have a website outside of their forums. Like my website has some 'static' html pages aside from the forums. There are mods and vBAdvanced modules that do this sort of thing but I never found one that did this on a page outside of vBulletin.
So basically . . . handy for displaying recent forum activity outside of the forums. Check my website link in my sig for an idea of how I use it. |
#5
|
|||
|
|||
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) |
#6
|
|||
|
|||
Great, installed it but i am also interested in the "updated threads"
|
#7
|
|||
|
|||
Quote:
HTML Code:
<?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);
?>
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. |
#8
|
|||
|
|||
THANKs, I am going to install it today
Well, me being in France (bonjour) any chance to have a 17:00 rather than a 5:00 PM time display ? |
#9
|
|||
|
|||
Quote:
HTML Code:
if ($post_date_format == "1") { $date2 = date ("m/d/y h:i" ,$lastpost); } elseif ($post_date_format == "2") { $date2 = date ("h:i" ,$lastpost); } else { $date2 = date ("m/d/y h:i A" ,$lastpost); } HTML Code:
if ($post_date_format == "1") { $date2 = date ("m/d/y H:i A" ,$lastpost); } elseif ($post_date_format == "2") { $date2 = date ("H:i" ,$lastpost); } else { $date2 = date ("m/d/y H:i A" ,$lastpost); } edit: removed AM/PM. Thanks for pointing it out, firstrebel |
#10
|
||||
|
||||
Quote:
Installed. Bob |
Thread Tools | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|