UBB.Developers Forums UBB.threads 6 V6 Modifications Forum Design Integration MySQL database fields...

Hi

First thing I want to do is integrate the forusm so we can post a "latest posts" list on the general site. But we use ASP there.

Can anyone tell me which fields, in which tables, PHP quesries to get the latest posts? Useful fields would be those defining the latest-post-date in a thread, as well as the thread topic, board name (since there are several boards).

Bascially this is what I want:

1. Post a list of the ten latest posts on the entire forum, using ASP, and post the thread names and fourms they are from.

2. Post such a list, but board-specific, ie the ten latest posts from a board.

Thanks!
James

Posts are stored in w3t_Posts. I have never worked with ASP pages but in one of my php scripts I use these fields to basicly do what you are wanting to do:
B_Number,B_Posted,B_Last_Post,B_Username,B_Subject,B_Body,B_Main,B_Replies,B_Board,B_File,B_Poll,B_Status

The forum name is not stored in this table but the forum's keyword is. You will have to pull the forum's title from w3t_Boards in the field Bo_Title

You may want to take a look at the ubbtnews.php script located in your "addons" directory. This should help []/forum/images/icons/smile.gif[/]