<?php


// By Gremmie





if (!defined('BLOCK_FILE')) 


{


    Header("Location: ../index.php");


    die();


}





global $prefix, $db, $sitename;





$sql = 'SELECT t.topic_title, p.post_time, p.post_id, u.username ' .


  "FROM {$prefix}_bbtopics AS t, {$prefix}_bbforums AS f, {$prefix}_bbposts AS p, {$prefix}_users as u " .


  'WHERE t.forum_id = f.forum_id AND f.auth_view = 0 AND p.topic_id = t.topic_id AND p.post_id = t.topic_last_post_id ' .


  'AND p.poster_id = u.user_id ' .


  'ORDER BY p.post_time DESC LIMIT 0, 10';





$result = $db->sql_query($sql);


if ($db->sql_numrows($result) > 0)


{


   $forumLink     = 'forums.html';


   $forumPostLink = $forumLink . '&amp;file=viewtopic&amp;p=';


   $content = '<center>Join us in our forums for some lively discussions. Here are the latest forum threads with ' .


      'new posts:<br /><br /><table border="0">';


   while ($row = $db->sql_fetchrow($result))


   {


      $title   = $row['topic_title'];


      $time    = strftime('%I:%M %p %b %d', intval($row['post_time']));


      $pid     = intval($row['post_id']);


      $pidStr  = $pid . '#' . $pid;


      $uname   = $row['username'];





      $content .= '<tr><td align="left"><img src="images/arrow.gif" border="0" alt="arrow" />&nbsp;';


      $content .= '<a href="' . $forumPostLink . $pidStr . '">' . $title . '</a> by ' . $uname .


         ' at ' . $time . '</td></tr>';


   }


   $content .= '</table>';


   $content .= "<br /><a href=\"$forumLink\"><b>$sitename Forums</b></a><br /><br /></center>";


}


else


{


   $content = '<center><i>No forum info available at this time.</i></center>';


}





?>