<?php if (!defined('FLUX_ROOT')) exit;
$newsTable = Flux::config('FluxTables.NewsTable');
$categoryTable = Flux::config('FluxTables.NewsCategoryTable');
$profileTable = Flux::config('FluxTables.NewsProfileTable');
$col = "n.news_title, n.news_desc, n.news_content, n.news_date_posted, ";
$col .= "np.name AS news_author, nc.name AS news_category, n.id";
$sql = "SELECT $col FROM {$server->loginDatabase}.$newsTable AS n ";
$sql .= "LEFT JOIN {$server->loginDatabase}.$categoryTable AS nc ";
$sql .= "ON nc.id = n.news_category ";
$sql .= "LEFT JOIN {$server->loginDatabase}.$profileTable AS np ";
$sql .= "ON np.account_id = n.news_author ";
$sql .= "ORDER BY n.id DESC LIMIT 7";
$sth = $server->connection->getStatement($sql);
$sth->execute();
$news = $sth->fetchAll();
?>
<?php if ($news): ?>
<table cellspacing="0" cellpadding="2" width="100%">
<?php foreach ($news as $article): ?>
<tr>
<td width="39"><div class="news_icon_<?php echo strtolower($article->news_category); ?>"></div></td>
<td><a href="<?php echo $this->url('news', 'view', array('id' => $article->id)); ?>" class="news_title"><?php echo $article->news_title; ?></a></td>
<td><span class="news_date"><?php echo date('m.d.y', strtotime($article->news_date_posted)); ?></span></td>
</tr>
<?php endforeach; ?>
</table>
<?php else: ?>
<p class="not-applicable">No latest news</p>
<?php endif; ?>