output from MySQL

[guvser]

I want to show the last 10 posts from my forum on my website.

I used Phpbb previously where i could make one single MySQL request to get the following data:
Topicname, number of posts(replys), Forum_ID, Username and the time of the post.

How can i get these from vBulletin, so i can put links to the last posts on my website?
I need an output with this condition forum_id !=12 AND forum_id != 13

[Eikinskjaldi]

Originally Posted by guvser

I want to show the last 10 posts from my forum on my website.

I used Phpbb previously where i could make one single MySQL request to get the following data:
Topicname, number of posts(replys), Forum_ID, Username and the time of the post.


How can i get these from vBulletin, so i can put links to the last posts on my website?
I need an output with this condition forum_id !=12 AND forum_id != 13

select t.title, replycount, forumid, username, from_unixtime(p.dateline) from post p join thread t on t.threadid=p.threadid order by p.dateline desc limit 10;

if you want the raw contents of the post as well then include p.pagetext. if you want a link to the post include p.postid and then build a vbulletin url using showpost.

[guvser]

Thank you, mate

been on vacation since i posted the question, so i only tried it now and it worked