preload
Make all letters caps Session based coordinates mapper
Feb 27

You can use the following code to get the latest threads from a PHPbb forum, it extracts the post information and the user information. Remember to replace "tblprefix" with your defined table prefix.

SELECT
p.post_id,
p.topic_id,
p.forum_id,
p.post_time,
p.poster_id,
pt.post_subject,
pt.post_text,
u.username
FROM
`tblprefix_posts` p
INNER JOIN
`tblprefix_posts_text` pt
ON
pt.post_id = p.post_id
LEFT JOIN
`tblprefix_users` u
ON
p.poster_id = u.user_id
ORDER BY
p.post_id DESC

Leave a Reply

 
 
Please enter the word above into the box below, the word is not case sensitive.
 
If you have trouble reading the word above then click here to load a new word.
Security word: