<?php

require("global.php");

//   Newsforum -- The forum that the script will pull news headlines from.  Unless you want all
//   your users to be able to update your news, you may want to consider limiting this forum to
//   Moderators posting new threads...this is easily done via the vB control panel.

$newsforum = 11;

//   News Limit -- How many stories should be displayed?

$bfc_newslimit = 5;

$isnews = 1;
$newsbits="";
$threads=$DB_site->query("SELECT * FROM thread WHERE forumid=$newsforum ORDER BY dateline DESC LIMIT $bfc_newslimit");
while ($thread=$DB_site->fetch_array($threads)) {
  $postdate=date($dateformat,$thread[dateline]+(($timeoffset+$bbtimezoneoffset)*3600));
  $posttime=date($timeformat,$thread[dateline]+(($timeoffset+$bbtimezoneoffset)*3600));
  $replycount=$thread[replycount];
  $username=$thread[postusername];
  $newstitle=$thread[title];
  $threadid=$thread["threadid"];
  if ($replycount == "0") {
    $replies = "";
  }
  elseif ($replycount == "1") {
    $replies = "| (1 Comment)";
  }
  else {
    $replies = "| ($replycount Comments)";
  }
  $posts=$DB_site->query("SELECT post.userid, pagetext,user.username as username
                          FROM post LEFT JOIN user ON (post.userid = user.userid)
                          WHERE threadid=$threadid ORDER BY postid LIMIT 1");
  $postinfo=$DB_site->fetch_array($posts);
  $userid=$postinfo[userid];
  $username=$postinfo[username];
  //$dept=$postinfo[dept],
  //$category=$posts[category];
  $message=bbcodeparse($postinfo[pagetext],$forumid,1);
  eval("\$newsbits .= \"".gettemplate("newsbit")."\";");
}

eval("echo dovars(\"".gettemplate("news")."\");");