Search options

<?php

/**
Punbb News Script
Written by: Jesse Spillane (http://www.jessespillane.com)
*/

$news_forum_id = 5;
$limit = 5;
$forum_path = './forum/';

define('PUN_ROOT', $forum_path);
require PUN_ROOT.'include/common.php';

define('PUN_TURN_OFF_MAINT', 1);
define('PUN_QUIET_VISIT', 1);

require PUN_ROOT.'include/parser.php';

echo "<h2>News</h2>";

$result = $db->query('select id, subject, num_replies, posted from '.$db->prefix.'topics WHERE forum_id='.$news_forum_id.' ORDER BY -posted LIMIT '.$limit.';')or error('Unable to fetch topic list', __FILE__, __LINE__, $db->error());
while ($row = $db->fetch_assoc($result))
{
    $id = $row['id'];
    $subject = $row['subject'];
    $num_replies = $row['num_replies'];
    $posted = date("F j, Y, g:i a", $row['posted']);

    $result2 = $db->query('select message, poster from '.$db->prefix.'posts WHERE topic_id='.$id.' ORDER BY id LIMIT 1 ')or error('Unable to fetch topic list', __FILE__, __LINE__, $db->error());
    
    $post = $db->fetch_assoc($result2);
    $message = parse_message($post['message'], 1);
    $poster = $post['poster'];

?>


<div style='margin-bottom: 30px;'>    
  <h3>
    <?php echo $subject; ?>
  </h3> 

  <hr />

  <div>
    <i> by <?php echo $poster; ?> </i>
  </div>

  <div>
    <i> <?php echo $posted; ?> </i>
  </div>

  <div>
    <?php echo $message; ?>
  </div>

  <div style='float: right;'>
    <?php
      echo '<a href='.$forum_path.'viewtopic.php?id='.$id.'>Comments ('.$num_replies.')</a>';
    ?>      
  </div>

</div>
<br />

<?php
  

}

?>