![]() |
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: HTML Code:
<ul class="vb_topics">
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 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 |
I'll be cool like all the veterans out there and reserve the first post. :)
|
hmm... looks interesting. what would this be handy for?
|
Quote:
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. :) |
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) |
Great, installed it but i am also interested in the "updated threads"
|
Quote:
HTML Code:
<?php 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. |
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 ? |
Quote:
HTML Code:
if ($post_date_format == "1") { $date2 = date ("m/d/y h:i" ,$lastpost); } HTML Code:
if ($post_date_format == "1") { $date2 = date ("m/d/y H:i A" ,$lastpost); } edit: removed AM/PM. Thanks for pointing it out, firstrebel |
Quote:
Installed. Bob |
Its possible to export this mod to a Javascript that lent me some like this:
Code:
<script type="text/javascript" language="JavaScript1.2"> |
Awesome! Thanks for this. :)
|
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". Quote:
Quote:
|
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. |
Quote:
Bob |
Quote:
Stay tuned. |
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:
PHP Code:
PHP Code:
PHP Code:
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. |
i've entered my db settings but it only outputs this
Quote:
|
FABULOUS, FABULOUS!!! (Nice site, btw!)
Any chance this works on non-vb pages that are on a different domain? ETA I just went back and read the entire first post. Now I see it works on any HTML page. I think I'm in love!! :) |
Quote:
Quote:
I haven't tried it on different domains since my site isn't run like that but I would think you'd just change $db_host to whatever the db server is. |
LBmtb: all db settings seems to be ok ... its kind of weird why it doesnt work :S
|
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. |
Quote:
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. |
Quote:
Bob |
Ah, dangit. You guys are right. Here's the fix:
FIND: PHP Code:
PHP Code:
|
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. |
Quote:
Bob |
Quote:
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? |
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. |
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. |
Quote:
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:
|
Quote:
|
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. |
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. |
Quote:
|
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? |
Quote:
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> |
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. |
Quote:
|
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. |
All times are GMT. The time now is 05:47 AM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|