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.

[Detomah]

I've been trying to achieve this for a while now, with certain, but limited, success. This has just made my life so much easier, saving me quite a bit of work. Thanks

[fabz]

I got Pluhnews working for my vb 3.0.1 and this works too.

[sbryan]

hmmmm ive got mine configured properly but the links never work, it always says that theyre wrong

[fabz]

Yes, you have to modify your pluhnews php files and replace all the lines containing links.

For example, a link to a thread in vb 2 was :
http://path_to_your_forum/showthread.php?s=Array[sessionhash]&threadid=xxxx

In vb 3, links to threads are now like this
http://path_to_your_forum/showthread.php?t=xxxx

So just search for lines containing "threadid=", remove "s=....." and change "threadid=" to "t="

It's simple, but if you don't succeed in it, I can send you my files.

[northernstar]

great hack!
Just wondering though if there's any way to not show topic titles from forums the user is not allowed to see?

[boatdesign]

Great mod - but one big problem.

It is showing links to threads that have been soft deleted by a moderator, so when a non-admin clicks them they get "invalid thread specified" since it's been soft deleted.

Is there a way to make this mod not display the thread title if the thread has been soft deleted by a moderator?

[Synicide]

Here's a question that's probably off topic a little bit, how would one go about and show the contents of the first post? Like say if I had event threads and the first post of those threads were summaries, could I have those summaries on that page?

[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

[007]

/me clicks install!

Works like a charm!

One thing I would like to see, is if the title gets cut off due to the character limit, it should add "..." at the end of the title like VB does on the forumhome.

[sbryan]

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

im getting a similar message as well...

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

does anyone know what causes this?