Last X Posts Titles on Non-VB page

Hi everyone,

Well, here is my first full release to the vB.org community. It's a small little script I just whipped up a few minutes ago. I already have this on my webpage for months now and thought I'd share it with the rest of you.

Description:
This script will display the titles, poster's names, and times of the last X's posts. It's fully customizable. Should be very easy to understand so enjoy!

Instructions:
1) Download the script below.
2) Change the settings in the script.
3) Insert include("/path/to/lastposts3.php"); anywhere in a non-VB page.

If you like to check out a live demo, you may go visit one of my sites: http://www.generazn.com.

If you have any problems, questions, or comments regarding this, feel free to post them here or send me an email to tre@phase1media.com.

[sbryan]

bump.

[sbryan]

Originally Posted by sbryan

bump.

is anyone supporting this hack still? im still getting an error with it and would like some help if its possible still..

[fabz]

Check that your VB version matches this hack, and that you didn't have copy/paste errors in your code.

This error occurs if the passed command to mysql is invalid (code error), or if it doesn't match the database structure.

[sbryan]

Originally Posted by fabz

Check that your VB version matches this hack, and that you didn't have copy/paste errors in your code.

This error occurs if the passed command to mysql is invalid (code error), or if it doesn't match the database structure.

mine is the latest, vBulletin Version 3.0.1.

The Author agreed to give support for this hack!

also, i dont think the author is supporting this. ive had no answers to PM's. if anyone is using VB3.0.1 and gets it going, please PM me

[sbryan]

bump. is ANYONE supporting this hack. If a moderator sees this can you let me know whats happening and why it still says this hack is supported when it clearly isnt?

[Baptizer]

I am surprised there isnt more interest in this makes me sad support for vb3 stuff is definitley lacking.............sad.

any idea how to get it to display today/yesterday for the time?

[sbryan]

Originally Posted by Baptizer

I am surprised there isnt more interest in this makes me sad support for vb3 stuff is definitley lacking.............sad.

any idea how to get it to display today/yesterday for the time?

i've even emailed the guy and had no reply. hope nothing bad has happened to him.

[boiboi]

this hack cannot handle server offset time. oh well.

[ChurchMedia]

Thanks for the hacks to exclude forums and alternating colors! It works perfectly.

[JohnK]

I've installed this hack with both modifications and it works fine for me -- thanks! < clicks install >

If someone has the time and inclination to sort out the server time vs forum time issue that would be even better

John

[TheClassic]

Originally Posted by JohnK

If someone has the time and inclination to sort out the server time vs forum time issue that would be even better

I'll take a look at this, no promises.

To do this, I need to know what the forum timezone is, any clues on where that is in the DB?

[dfmafia]

what version of vB3 is it working on and which versions does it not work on

im using vB 3.0.3 and it dont work

[dfmafia]

well looky there...

at:

PHP Code:

$forum_id = "3"; // If you wish to display the posts from a specific forum, enter the forum id here. Otherwise, leave it blank. 


it will only work out correctly if u input 1 forum_id - when i entered in only the forums i wanted t show up (about 20 of them) i get:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/xxx/public_html/lastposts3.php on line 48

if i just enter in 1 forum id it works great

this is fior both the scripts the author made

lastposts3.php and lastthreads3.php

[JohnK]

I haven't used $forum_id but I have used $excludeforums successfully which could give you the same result in the end. A list of forum numbers separated by commas works here.

John

[3dfly]

Is it possible to show Thumbnail from post ?

[nhatrang]

any chance we can display the posts under the thread title as well too?

[WoodiE]

Does anyone know how to convert the output of this script to valid XHTML code?

-Michael

[therczone]

I want to start off by saying I take no credit for this code. I simply found a easy bug.

https://vborg.vbsupport.ru/showthread.php?t=62624
https://vborg.vbsupport.ru/showpost....2&postcount=38

I have been looking for a "Racent Topics" script to pull 10-15 of the latest threads onto a non-vB page. Well I almost gave up, but decided to give RobinHood's code one last try.

The error that you receive is:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/xxx/public_html/lastposts3.php on line 48

The reason being that the prefix for the tables has to be manually added.

Original:

<?php 

#########################
## LAST X POSTS v3.1   ##
## PHASE(1) MEDIA      ##
## WWW.PHASE1MEDIA.COM ##
## TRE@PHASE1MEDIA.COM ##
#########################

/* This script shows the last X numbers of posts (titles) posted last on a non-VB page.
You may customize it in any way you wish. If you have any problems with it, you can
post them at vB.org or send me an email to tre@phase1media.com.

Enjoy!
*/

## CUSTOMIZE SETTINGS FOR YOUR SITE ##
$db_host = "localhost"; // Change this if your MySQL database host is different.
$db_name = "vbulletin"; // Change this to the name of your database.
$db_user = "user"; // Change this to your database username.
$db_pw = "password"; // Change this to your database password.

$forum_url = "http://www.yourdomain.com/forum"; // Change this to reflect to your forum's URL.
$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.
$titlecolor = "#0000FF"; // This is the color of the title.
$postedcolor = "#404040"; // This is the color of the bottom text.
$txtlimit = "100"; // This is the character limit.
#######################################

// Connecting to your database
mysql_connect($db_host, $db_user, $db_pw) 
OR die ("Cannot connect to your database"); 
mysql_select_db($db_name) OR die("Cannot connect to your database"); 

// Below is the beginning of a table. If you feel you don't need it, you may remove it.
echo "<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"2\">";

if ($forum_id) {
	$forumid = "AND forumid=$forum_id";
}

if ($limit) {
	$limited = "LIMIT $limit";
}
$thread_sql = mysql_query("SELECT threadid,title,lastpost,lastposter FROM thread WHERE visible=1 AND open=1 $forumid ORDER BY lastpost DESC $limited");

while($thread_get=mysql_fetch_array($thread_sql))
{
$lastpost = $thread_get['lastpost'];
$poster = $thread_get['lastposter'];
$tid = $thread_get['threadid'];
$psql = mysql_query("SELECT postid FROM post WHERE threadid=$tid ORDER BY postid DESC");
$getp=mysql_fetch_array($psql);
$pid = $getp['postid'];
$date2 = date ("m/d/y h:i A" ,$lastpost);
$title = $thread_get['title'];
$title = substr($title,0,$txtlimit);
echo "<tr><td><font size=\"2\" face=\"arial,verdana,geneva\"><a href=\"$forum_url/showthread.php?p=$pid#post$pid\"><FONT SIZE=\"2\" COLOR=\"$titlecolor\" face=\"arial,verdana,geneva\">$title</FONT></a></font><br /><font color=\"$postedcolor\" face=\"arial,verdana,geneva\" size='1'>posted by $poster <i>$date2</i></FONT></td></tr>";
}
echo "</table>";

?>

Correct (for vB3.0.7):

<?php 

#########################
## LAST X POSTS v3.1   ##
## PHASE(1) MEDIA      ##
## WWW.PHASE1MEDIA.COM ##
## TRE@PHASE1MEDIA.COM ##
#########################

/* This script shows the last X numbers of posts (titles) posted last on a non-VB page.
You may customize it in any way you wish. If you have any problems with it, you can
post them at vB.org or send me an email to tre@phase1media.com.

Enjoy!
*/

## CUSTOMIZE SETTINGS FOR YOUR SITE ##
$db_host = "localhost"; // Change this if your MySQL database host is different.
$db_name = "vbulletin"; // Change this to the name of your database.
$db_user = "user"; // Change this to your database username.
$db_pw = "password"; // Change this to your database password.

$forum_url = "http://www.yourdomain.com/forum"; // Change this to reflect to your forum's URL.
$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.
$titlecolor = "#0000FF"; // This is the color of the title.
$postedcolor = "#404040"; // This is the color of the bottom text.
$txtlimit = "100"; // This is the character limit.
#######################################

// Connecting to your database
mysql_connect($db_host, $db_user, $db_pw) 
OR die ("Cannot connect to your database"); 
mysql_select_db($db_name) OR die("Cannot connect to your database"); 

// Below is the beginning of a table. If you feel you don't need it, you may remove it.
echo "<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"2\">";

if ($forum_id) {
	$forumid = "AND forumid=$forum_id";
}

if ($limit) {
	$limited = "LIMIT $limit";
}
$thread_sql = mysql_query("SELECT threadid,title,lastpost,lastposter FROM YOURPREFIXHERE_thread WHERE visible=1 AND open=1 $forumid ORDER BY lastpost DESC $limited");

while($thread_get=mysql_fetch_array($thread_sql))
{
$lastpost = $thread_get['lastpost'];
$poster = $thread_get['lastposter'];
$tid = $thread_get['threadid'];
$psql = mysql_query("SELECT postid FROM YOURPREFIXHERE_post WHERE threadid=$tid ORDER BY postid DESC");
$getp=mysql_fetch_array($psql);
$pid = $getp['postid'];
$date2 = date ("m/d/y h:i A" ,$lastpost);
$title = $thread_get['title'];
$title = substr($title,0,$txtlimit);
echo "<tr><td><font size=\"2\" face=\"arial,verdana,geneva\"><a href=\"$forum_url/showthread.php?p=$pid#post$pid\"><FONT SIZE=\"2\" COLOR=\"$titlecolor\" face=\"arial,verdana,geneva\">$title</FONT></a></font><br /><font color=\"$postedcolor\" face=\"arial,verdana,geneva\" size='1'>posted by $poster <i>$date2</i></FONT></td></tr>";
}
echo "</table>";

?>

Simple diagnostics:

$thread_sql = mysql_query("SELECT threadid,title,lastpost,lastposter FROM YOURPREFIXHERE_thread WHERE visible=1 AND open=1 $forumid ORDER BY lastpost DESC $limited");

while($thread_get=mysql_fetch_array($thread_sql))
{
$lastpost = $thread_get['lastpost'];
$poster = $thread_get['lastposter'];
$tid = $thread_get['threadid'];
$psql = mysql_query("SELECT postid FROM YOURPREFIXHERE_post WHERE threadid=$tid ORDER BY postid DESC");

[sabret00the]

yup if you don't include the global.php then it has no way of knowing what "TABLE_PREFIX" means.

[therczone]

Even if it was included, the table prefix snippet of code is not in this code.

[Umpakati]

I felt dumb when I realized, but make sure $db_name is set to the right database. I got the same error as you guys before:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/xxx/public_html/lastposts3.php on line 48

[Gastongr]

I'd like to have this but in a all the vb pages.
I know there are many hacks for that but not for all pages, and if there are they display many details and requiere mayor edits.
Is there any way to include a php file from a template like footer or header?

[Gastongr]

i have solved this creating a new variable containing the file in the phpinclude_start template. Then in just insert that variable where i want this displayed.
This is working in all pages except in showthread.php and forumdisplay.php where i get this error

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /includes/lastposts.php on line 47

This is line 47 in /includes/lastpost.php

while($thread_get=mysql_fetch_array($thread_sql))

how can i solve it?

[Gastongr]

My line 47 is actually line 48 of the original file

[Gastongr]

Just saw the fixed file by therczone. I'll try it now.
What's suppoused to be my thread prefix?
db table prefix?

[Gastongr]

I really don't know what's wrong with this i did all the suggested in this thread, but the error is still there.
Can someone help me?

[smdani]

This is a great hack.
I use it a lot into my website.
I would like to show also 400 first characters of a post below the link. I tried to select the text through the mysql sentence, but it appears unformatted (no spidering tags).
Anyone knows how to do this?

Thanks in advance

[lazyseller]

if u dont use a prefix u delete this line YOURPREFIXHERE_ in both instances for people who are having trouble...

[MarketingPatch]

Also the error message :
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/traffic/public_html/marketingpatch/lastposts.php on line 48

[Gutspiller]

How do I get this to exclude forums as well? Also, does it respect viewable permissions so it won't show mod forum posts to people that aren't allowed?

Thanks.

[lazyseller]

Originally Posted by MarketingPatch

Also the error message :
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/traffic/public_html/marketingpatch/lastposts.php on line 48

u forgot to remove _ <~~~

[Gutspiller]

How do I get this to run multiple times on the same non-vb page? I renamed the file, but one file includes all forums and the other just 1 latest thread from the announcement forum. When it displays on the page both show only threads from the announcement forum. How can I fix this without only including all the forums in the one and still be able to leave that setting blank?

[leevoth]

Originally Posted by freakify

I keep getting this error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in "path" on line 57

Almost forgot, my line 57 is:
while($thread_get=mysql_fetch_array($thread_sql))

any suggestions?

thanks

change the table prefix with your

PHP Code:

        $wheresql .= " AND TABLEPREFIX_thread.forumid!='$excfid[$i]'";    ++$i; 


[Aeolian]

work needed in the code to fit the standard of 3.5.0

thanx~

[PokerKnowledge]

Hi,
I have installed this but get a blank page once I click on it now. any sugestions?

Thanks

[PokerKnowledge]

Ok, I have installed this now and working find if I click my url /last3posts.php BUT is it possible instead of just having one page that shows the last posts I can make it so it all appears somewhere on my homepage?
my homepage isn't php would it be possible to link this all together?

Thanks

[Aaron RV]

Hi,

work in vb 3.5.1?

thank's. :nervous:

[mrpotatohead]

Originally Posted by PokerKnowledge

Hi,
I have installed this but get a blank page once I click on it now. any sugestions?


Thanks

Me too!

[Dark Riku]

I have it converted to vb 3.5 but i dont no how to add prefixes and robinhood did not add prefixes origionally.

@Powerknoledge
best thing to do is use iframes or use php =)

@mrpotatohead
did you setup the config file and everything that needs to be edited?

[malfuncion]

Originally Posted by Aaron RV

Hi,

work in vb 3.5.1?

thank's. :nervous:

i have it working in 3.5.2

alternating colors and excluding forums also works fine.