phpbb recent posts addition ( 16 Views )

1. Anyone know of a phpbb add on that can display recent forum posts on your homepage like SP has or like what I have on WebsitePublisher.net?
   
   I found one that displays the topic, but no other information (replies, author, etc).
   
   
   (sevim, Jordan)


2. Aspen,
   
   Whats your e-mail?
   
   
   (songül, Oman)


3. I've got one which I wrote (I don't use the authors, replies, etc though personally).
   
   

   PHP Code:

   ---

   <?
    /************ CONFIG ***************/

    $ammount_to_display = 10;
    $cutoff_length = 20;

    // end names / folders with a slash
    $domainname = 'http://www.yourdomain.com/';
    $path_to_phpbb = '';

    /************ /CONFIG **************/

    require($path_to_phpbb.'config.php');

    $connect = mysql_connect($dbhost, $dbuser, $dbpasswd) or die (mysql_error());
    mysql_select_db($dbname, $connect);

    $latest = mysql_query("
        SELECT phpbb_topics.topic_id, phpbb_topics.topic_title, phpbb_topics.forum_id, phpbb_topics.topic_poster, phpbb_topics.topic_replies,
        phpbb_users.user_id, phpbb_users.username,
        phpbb_forums.auth_read, phpbb_forums.forum_id
        FROM phpbb_topics
        LEFT JOIN phpbb_users ON phpbb_topics.topic_poster=phpbb_users.user_id
        LEFT JOIN phpbb_forums ON phpbb_topics.forum_id=phpbb_forums.forum_id
        WHERE phpbb_forums.auth_read=0
        ORDER BY topic_last_post_id DESC LIMIT ". $ammount_to_display ."
    ") or die (mysql_error());

    While ($recent = mysql_fetch_array($latest)){
        $topic_id = $recent['topic_id'];
        $topic_poster = $recent['username'];
        $topic_replies = $recent['topic_replies'];
        $topic_title = ucfirst(strtolower($recent['topic_title']));
        $topic_desc = $topic_title;

        if(strlen($topic_title) > $cutoff_length){
            $topic_title = substr($topic_title, 0, $cutoff_length);
            $topic_title = ($topic_title.'...');
        }

        echo('<a href="'.$domainname.''.$path_to_phpbb.'viewtopic.php?t='.$topic_id.'" title="'.$topic_desc.'">'.$topic_title.'</a> by '.$topic_poster.' - '.$topic_replies.' replies<br />');

    }
?>

   ---

   
   
   (irem, Yemen)


4. Look it up in the Admin panel Patrick.
   
   I suppose that could have been seen as an order. ;)
   
   I just don't want to post it -- I get enough email as it is.
   
   
   (asilberk, Venezuela)

Related Topics ... (or search in 1.720.883 topics !)