Article Management';
require('../data/config.php');
require('includes/functions.php');
require('includes/header.php');
?>
';
echo 'Click here to refresh the article list and close this window.';
tableClose();
}
elseif ($_GET['action'] == 'edit' && hasAccess('articles', 'edit')) {
$article_id = $_GET['id'];
echo '
';
}
elseif ($_GET['action'] == 'preview' && hasAccess('articles', 'view')) {
$id = $_GET['id'];
$result = dbQuery("SELECT admins.username AS publisher, a.id, a.title, a.body, a.view_count, a.print_count, a.email_count, a.ratings_1, a.ratings_2, a.ratings_3, a.ratings_4, a.ratings_5, UNIX_TIMESTAMP(a.created) AS created, UNIX_TIMESTAMP(a.last_updated) AS last_updated, c.id AS cat_id, c.title AS category FROM admins, articles AS a, categories AS c WHERE a.id=$id AND a.cat_id=c.id AND a.admin_id=admins.id");
while ($row = mysql_fetch_object($result)) {
$rating = getRating($row->ratings_1, $row->ratings_2, $row->ratings_3, $row->ratings_4, $row->ratings_5, 'Not yet rated');
tableHeader($row->title);
echo nl2br($row->body);
tableClose();
echo '
|
';
tableHeader('Document Information');
echo '
Published by: '.$row->publisher.' Found in: '.$row->category.' Created: '.date($cfg['date_format'], $row->created).' Last updated: '.date($cfg['date_format'], $row->last_updated); tableClose(); echo ' | ';
tableHeader('Document Statistics');
echo '
Rating: '.$rating['standard'].' Views: '.$row->view_count.' Print count: '.$row->print_count.' E-mail count: '.$row->email_count; tableClose(); echo ' |
| '.$nav['total'].' '.isPlural($nav['total'], 'articles', 'articles').' found. Displaying page '.$nav['page'].' of '.$nav['pages'].' |