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

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:



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

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.

[palosanto]

Originally Posted by 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?

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]

Originally Posted by 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

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]

Originally Posted by 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

I get the same error

[hollyboy]

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

[Johnny]

Originally Posted by palosanto

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.