Last X Threads From A Particular Forum On Non-VB Page

[RobinHood]

Hi everyone,

By request, I have released this script which will display the last X number of thread titles from a specified forum. It will only show the thread starter so the thread doesn't look like it was started from a commenter or visitor.

Well, pictures are worth a thousand words so here's a screenshot:

https://vborg.vbsupport.ru/

--------------------------------------------------------------------------------------------

Instructions:

1) Download the script (of course).
2) Change the settings in the script.
3) Use include("/path/to/lastthreads3.php"); in your PHP page.

That's it! Enjoy.

[Silverdawn222]

I requested this... brilliant work, and so fast! Thank you.

[Owen]

Can we also set it to all forums? Is it possible to limit the amount of characters?

Thanks.

[Owen]

Ignore that last post...

[MischiefThought]

Great hack man, this is outstanding!

[gmarik]

Wow, I'll test this later...

[Buddha]

i have tried to set this one up with the multiple sub-domains, just like the lastposts3, but for some reason, i just can't get it to work.

[egyptsons]

mmmmm I 'll try it

[Diana Notacat]

What about setting this up to display posts only from a certain category, or allowing multiple forums?

This is great by the way! ;) I was looking for something like this last night!

[Quintak]

nice work! thx a lot!

[Tim Wheatley]

How does this differ from using external.php?

[ptbyjason]

I would also be interested in pulling posts from various forums. Is there a way that one page could pull posts from forum X, and different page could pull posts from forum Y?

[Buddha]

managed to get it working.
thanks for the hack.

[Kumaro]

exactly what I need...thanks a mil.

[ga.net]

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

I left it blank but I get an error. Hows this?

[Anne Lise]

Me too:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/barnemix/public_html/lastthreads3.php on line 41

[sammyman]

Is the other guy copying you with lastposts3, or what?

[KW802]

Could somebody clarify.... what are the advantages to using this method over external.php? :o

[hitmanuk2k]

please could someone post of a slight modification of this hack so that it can display threads from multiple forums

[egyptsons]

There Is A Errorrrrrrrrr Dear :(

[palosanto]

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

I left it blank but I get an error. Hows this?

I have the same error if I don't write 9. And if I write 0 or other number it does't work. :surprised:

Actually I have in my test index2.php it working but I only see the last 10 of a particular subforum (number9) NOT ALL THE MESAGES IN general. I don't understand

This is a bug or no?

Any idea?

Regards:

Palosanto :ermm:

[Charlie Argueta]

Where did you used the "tid" after all? this could be the problem of the hack.

See Ya

[Jannefant]

Me too:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/barnemix/public_html/lastthreads3.php on line 41

Try to edit Line 41


$tsql = mysql_query("SELECT threadid,title,lastpost,postusername FROM thread WHERE forumid=$forum_id ORDER BY threadid DESC LIMIT $limit");


FROM thread must be modify to yourprefix_thread if you use a prefix

[Fragpoint]

I receive only an blank screen, no errors: http://www.fragpoint.de/lastthreads3.php
Why? Plz help.

I have changed this: $tsql = mysql_query("SELECT threadid,title,lastpost,postusername FROM thread WHERE forumid=$forum_id ORDER BY threadid DESC LIMIT $limit");


to this: $tsql = mysql_query("SELECT threadid,title,lastpost,postusername FROM vb3_thread WHERE forumid=$forum_id ORDER BY threadid DESC LIMIT $limit");



and i have changed this:
$psql = mysql_query("SELECT postid FROM post WHERE threadid=$tid ORDER BY postid ASC");

to this:
$psql = mysql_query("SELECT postid FROM vb3_post WHERE threadid=$tid ORDER BY postid ASC");

[gwon]

working well for me thanks :)

live @ http://www.somethingboring.com

[hollyboy]

Me too:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/barnemix/public_html/lastthreads3.php on line 41

I get the same error

[hollyboy]

how can this hack be in the realeased forum when it doesn't work?

[Johnny]

I have the same error if I don't write 9. And if I write 0 or other number it does't work. :surprised:

Actually I have in my test index2.php it working but I only see the last 10 of a particular subforum (number9) NOT ALL THE MESAGES IN general. I don't understand

This is a bug or no?

Any idea?

Regards:

Palosanto :ermm:


anyone know how to fix this error

[aberg]

Also this error, but i try it on version 3.0.3
So who knows the solution for this problem???

[boiboi]

doesn't work for me. shows the wrong time. my server is in pacific time and the forum is offset to +8. the hack always follow the server time.

[AnhTuanCool]

Nothing but a blank page :\

[SVTBlackLight01]

The Author(s) agreed to give support for this modification!

I haven't seen anything from the author in here since the first post 5 months ago.

I'm looking for a way to display more than one forums as well.

[Anne Lise]

Anyone solved the problem?

[ipgn]

This has the serious problem of showing threads from private forums, as I just found out to my cost!

It'd be nice to see this fixed also... major issue for some...

[dfmafia]

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

im using vB3.0.3 and it dont work

what version are u guys using that its working on?

[dfmafia]

well looky there...

at:
$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/lastthreads3.php on line 41

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

[James T Brock]

Can someone update this so that it will show multiple forums and not just one?

I know you can use external.php to do the same thing, but it's much more convenient to use this script and it's easier to customize the colors and look. I'm using it now and like it, but would prefer it if I could show threads from several different forums.

[lancepoint]

can you just double up the row?



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

[xeonkiller711]

can you just double up the row?



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


Nope it picks the last number... I dont think you can use more then one forum on this script... Its a wonderful script but thats the problem...

[Wistow]

Easy - find the following code:
if ($forum_id) {
$forumid = "AND forumid=$forum_id";
}
and replace it with
if ($forum_id) {
$forumid = "AND forumid!=$forum_id AND forumid!=$forum_id2";
}
Now below the $forum_id variable at the top of the script, add
$forum_id2 = "FORUM YOU WANT POSTS FROM";

You can repeat this for more forums, adding an extra variable and SQL statement for each. Quite an untidy compromise, but it works!

Craig

[Gastongr]

Wistow i can't find that code,
i don't even have an "if" in my file. i downlaoded it from here :S

[Gastongr]

Already edited this to my needs and get it working

[CrimsonGT]

It works just fine on my site, however I am having a problem getting it to display the post as well. It shows the thread titles and the person who posted it, but I would like to actually display the message as well.

[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

[Dionysis]

just remove the "WHERE forumid=$forumid" completely from the query, and it'll select from every forum.

If you want to select from secified forum ID's, you'll have to write a loop to insert that ID foreach forumid

something like:

..."WHERE (loop here{each forum id}) ORDER BY"....

too lazy to type code ^_^.

[poetic]

so how do we put the code?

include("/path/to/lastthreads3.php");

or

/path/to/lastthreads3.php

[lewisbeech]

this is odd, i uploaded the script to /includes (right?!?) and nothing! the site i want it on is www.a-2z.com