.
*/
date_default_timezone_set("America/New_York");
function ListNews(){
global $db;
$result = $db->Query("SELECT n.news_id, n.title, n.message, n.date, n.category_id, u.username AS author, c.name AS catname, c.image AS catimage ".
"FROM `bayonet_news` AS n ".
"INNER JOIN `bayonet_news_categories` AS c ON c.category_id = n.category_id ".
"LEFT OUTER JOIN `mybb_users` AS u ON u.uid = n.author_id ORDER BY `date` DESC");
$row = $db->Fetch($result);
foreach($row as $news)
{
$newsBody = $news['message'];
echo "";
echo "{$news['title']} | {$news['catname']} ";
if(($len = strlen($newsBody))>150)
echo substr($newsBody, 0, 150)."...";
else
echo $newsBody;
echo ' ';
echo "Posted By: {$news['author']} on ".date('D M j, Y g:i a T', strtotime($news['date']));
echo '
';
}
}
function EditNews($news_id){
global $db;
if(isset($_POST['processed'])){
return;
}
$result = $db->Query("SELECT `author_id`, `title`, `message`, `date`, `category_id` FROM `bayonet_news` WHERE `news_id` = '$news_id' LIMIT 1");
$row = $db->FetchRow($result);
?>
![](\"images/page.png\")