You're right. I just got verification on the userid. The code is good at this:
PHP Code:
$dposteurs=$DB_site->query_first("SELECT post.dateline, thread.threadid, user.username, user.userid
FROM post, thread
LEFT JOIN user ON user.userid = post.userid
WHERE thread.forumid = $forumid AND thread.threadid = post.threadid
ORDER BY post.dateline DESC
LIMIT 1
");
Now, all we have to do is get the Average rating to work right on my site.