<?php
        echo ( "
        <table width=\"100%\"><tr id=\"header\"><td><center><strong>.::Last Post in Each Forum::.</strong></center></td></tr></table>
        <div id=\"content\">
        <center>
        <table cellpadding=\"2\" width=\"100%\">
        " );

        function lastPost($fid)
        {
                $fname="snip"; //forum database login name
                $fpass="snip"; //forum database pass
                $fdb="forum";  //name of database forum uses

                mysql_connect(localhost,$fname,$fpass);
                @mysql_select_db($fdb) or die("Could not connect to database.");
                $query="select last_post_date, id, replies, forum_id, last_post_id from fud26_thread where forum_id = '$fid' order by last_post_date desc";
                $result=mysql_query($query);
                $num=mysql_numrows($result);
                $x=0;


                while ($x < $num) {
                        $post_id=mysql_result($result,$x,"id");
                        $replies=mysql_result($result,$x,"replies");
                        $last_post_date=mysql_result($result,$x,"last_post_date");
                        $last_post_id=mysql_result($result,$x,"last_post_id");
                $x=$num;
                }

                $num=mysql_numrows($result);
                $x=0;


                while ($x < $num) {
                        $post_id=mysql_result($result,$x,"id");
                        $replies=mysql_result($result,$x,"replies");
                        $last_post_date=mysql_result($result,$x,"last_post_date");
                        $last_post_id=mysql_result($result,$x,"last_post_id");
                        $url="http://www.uplinklounge.com/forum/index.php?t=msg&th=$post_id";

                $x=$num;
                }

                $query="select name from fud26_forum where id = \"$fid\"";
                $result=mysql_query($query);
                $num=mysql_numrows($result);
                $x=0;

                while ($x < $num) {
                        $forum_name=mysql_result($result,$x,"name");
                $x=$num;
                }

                $query="select subject, poster_id from fud26_msg where id = \"$last_post_id\"";
                $result=mysql_query($query);
                $num=mysql_numrows($result);
                $x=0;

                while ($x < $num) {
                        $poster_id=mysql_result($result,$x,"poster_id");
                        $subject=mysql_result($result,$x,"subject");

                $x=$num;;
                }
                if (!isset($poster))
                {
                        $poster = "Anonymous Coward";
                }
                $pdate=date("m/d/Y", $last_post_date);
                $ptime=date("g:i A", $last_post_date);

                echo ( "
                        <tr><td width=\"20%\">
                        <div align=\"right\"><b><a href=\"http://www.uplinklounge.com/forum/index.php?t=thread&frm_id=$fid\">$forum_name</a>: </b></div>
                        </td>
                        <td width=\"35%\">
                        <a href=\"$url\">$subject</a>
                        </td>
                        <td>($replies replies)</td>
                        <td>
                        <a href=\"http://www.uplinklounge.com/forum/index.php?t=usrinfo&id=$poster_id\">$poster</a>
                        </td>
                        <td>
                        <small>$pdate at $ptime</small>
                        </td>
                        </tr>
                "

                );

                mysql_close();
        }
        lastPost(2);
        lastPost(30);
        lastPost(8);
        lastPost(9);
        lastPost(10);
        lastPost(12);
        lastPost(32);
        lastPost(44);
        lastPost(42);
        lastPost(14);
        lastPost(17);
        lastPost(37);
        lastPost(38);
        lastPost(7);
        lastPost(41);

        echo ( "
        </table>
        </center>
        </div>
        " );
?>

function fetch_forum_posts($n_posts) /* n_posts is the number of messages you wish to fetch */
{       /* change the following for your forum GLOBALS paths!!! */
        include_once "forum/fud/include/GLOBALS.php";
        
        $cid = mysql_connect($DBHOST, $DBHOST_USER, $DBHOST_PASSWORD);
	$tbl = $DBHOST_TBL_PREFIX;
        $r = mysql_db_query($DBHOST_DBNAME, "SELECT resource_id FROM ".$tbl."group_cache WHERE user_id=0 AND group_cache_opt>>1&1=1", $cid);
        $lm='';
        while( list($id) = mysql_fetch_row($r) ) $lm .= $id.',';
        $lm = substr($lm, 0, -1);

        $r = mysql_db_query($DBHOST_DBNAME, "SELECT
                                                ".$tbl."msg.id,
                                                ".$tbl."msg.subject,
                                                ".$tbl."thread.last_post_date,
                                                ".$tbl."thread.last_post_id
                                        FROM
                                                ".$tbl."thread
                                        INNER JOIN ".$tbl."msg
                                                ON ".$tbl."thread.root_msg_id=".$tbl."msg.id
                                        WHERE
                                                ".$tbl."thread.forum_id IN (".$lm.") AND
                                                ".$tbl."msg.apr=1
                                        ORDER by
                                                ".$tbl."thread.last_post_id DESC
                                        LIMIT ".$n_posts, $cid);
        while( $obj = mysql_fetch_object($r) ) {
                /* Here you do your actual code, below is a working example */
				$tm = date("d/m/Y H:i", $obj->last_post_date);
                echo "<p><SPAN CLASS=\"date\">".$tm."</SPAN> - <a href=\"".$WWW_ROOT."index.php?t=msg&goto=".$obj->id."\">".$obj->subject."</a> <a href=\"".$WWW_ROOT."index.php?t=tree&goto=".$obj->last_post_id."\">&raquo;&raquo;</a></p>\n";
        }
        mysql_free_result($r);
}

/*Here goes the actual call of the function!
Insert the number of posts you wish to pull instead of 10
And insert the call in the place you wish it to show the list */
fetch_forum_posts(10);