Latest Posts on Forum Home

[PyroNET]

Hello.

I am trying to display the poster, threadid, and thread title of the latest post (not thread)

At the moment I have the following in a plugin set for the parse_templates hook

PHP Code:

$posts = $db->query("
    SELECT post.postid, post.username, thread.title, thread.threadid 
    FROM ". TABLE_PREFIX ."post 
        LEFT JOIN ". TABLE_PREFIX ."thread ON(thread.threadid = post.threadid) WHERE thread.visible IN (0,1,2) ORDER BY post.dateline DESC LIMIT 15
    ");

while ($posts2 = $db->fetch_array($posts)) {

$hiccup .= "<img class=\"inlineimg\" src=\"$stylevar[imgdir_button]/lastpost.gif\" alt=\"\" border=\"0\" /> <a href=\"showthread.php?$session[sessionurl_q]t=".$posts2[threadid]."\">".$posts2[title]."</a> (Posted by ".$posts2[username].")<br />";

} 


I would like to know how to change this so that it:
a.) Only displays gets the latest posts from forums that a guest would be able to view
b.) Doesn't show a thread more than once in the list... If the query returns more than one result from the same thread, they are collapsed into one with the poster of the latest post in that thread listed.

Any help appreciated.