";
///
add_to_title($locale['global_200'].$locale['400']);
if (isset($_GET['article_id']) && isnum($_GET['article_id'])) {
$result = dbquery(
"SELECT ta.*,tac.*, tu.user_id,user_name FROM ".DB_ARTICLES." ta
INNER JOIN ".DB_ARTICLE_CATS." tac ON ta.article_cat=tac.article_cat_id
LEFT JOIN ".DB_USERS." tu ON ta.article_name=tu.user_id
WHERE ".groupaccess('article_cat_access')." AND article_id='".$_GET['article_id']."' AND article_draft='0'"
);
if (dbrows($result)) {
require_once INCLUDES."comments_include.php";
require_once INCLUDES."ratings_include.php";
$data = dbarray($result);
if (!isset($_GET['rowstart']) || !isnum($_GET['rowstart'])) { $_GET['rowstart'] = 0; }
if ($_GET['rowstart'] == 0) { $result = dbquery("UPDATE ".DB_ARTICLES." SET article_reads=article_reads+1 WHERE article_id='".$_GET['article_id']."'"); }
$article = stripslashes($data['article_article']);
if (ereg('<--PAGEBREAK-->', $article)) {
$article = explode("<--PAGEBREAK-->", $article);
} else {
$article = explode("", $article);
}
$pagecount = count($article);
$article_subject = stripslashes($data['article_subject']);
$article_info = array(
"article_id" => $data['article_id'],
"user_id" => $data['user_id'],
"user_name" => $data['user_name'],
"article_date" => $data['article_datestamp'],
"article_breaks" => $data['article_breaks'],
"article_comments" => dbcount("(comment_id)", DB_COMMENTS, "comment_type='A' AND comment_item_id='".$data['article_id']."'"),
"article_reads" => $data['article_reads'],
"article_allow_comments" => $data['article_allow_comments']
);
add_to_title($locale['global_201'].$article_subject);
echo "";
render_article($article_subject, $article[$_GET['rowstart']], $article_info);
echo "";
if ($pagecount > 1) {
echo "\n".makepagenav($_GET['rowstart'], 1, $pagecount, 3, FUSION_SELF."?article_id=".$_GET['article_id']."&")."\n
\n";
}
if ($data['article_allow_comments']) { showcomments("A", DB_ARTICLES, "article_id", $_GET['article_id'], FUSION_SELF."?article_id=".$_GET['article_id']); }
if ($data['article_allow_ratings']) { showratings("A", $_GET['article_id'], FUSION_SELF."?article_id=".$_GET['article_id']); }
} else {
redirect(FUSION_SELF);
}
} elseif (!isset($_GET['cat_id']) || !isnum($_GET['cat_id'])) {
opentable($locale['400']);
echo "\n";
$result = dbquery("SELECT * FROM ".DB_ARTICLE_CATS." WHERE ".groupaccess('article_cat_access')." ORDER BY article_cat_name");
$rows = dbrows($result);
if ($rows) {
$counter = 0; $columns = 2;
$to = dbcount("(article_id)", DB_ARTICLES, "article_draft='0'");
echo " There are ".$to." Articles Online
\n";
echo "\n\n";
while ($data = dbarray($result)) {
if ($counter != 0 ) { echo "
\n\n"; }
$num = dbcount("(article_cat)", DB_ARTICLES, "article_cat='".$data['article_cat_id']."' AND article_draft='0'");
echo "".$data['article_cat_name']."
$num Articles";
if ($data['article_cat_description'] != "") { echo "
\n".$data['article_cat_description'].""; }
echo " | \n";
// start of waddays article query for right colomn
$wadday = dbquery("SELECT * FROM ".DB_ARTICLES." WHERE article_cat='".$data['article_cat_id']."' ORDER BY article_id DESC");
$row = dbrows($wadday);
if ($row) {
$line = 0;
while ($adata = dbarray($wadday)) {
if ($adata['article_datestamp'] + 604800 > time() + ($settings['timeoffset'] * 3600)) {
$new = " [".$locale['402']."]";
} else {
$new = "";
}
echo "» ".showdate("shortdate", $adata['article_datestamp'])." | ".$adata['article_subject']."$new
\n"; $line++;
}
}else {
echo "".$locale['403']." \n";
}
echo " | \n";
$counter++;
}
echo "
\n
©\n";
} else {
echo "
\n".$locale['401']."
\n
\n";
}
echo "\n";
closetable();
} else {
$res = 0;
$result = dbquery("SELECT * FROM ".DB_ARTICLE_CATS." WHERE article_cat_id='".$_GET['cat_id']."'");
if (dbrows($result) != 0) {
$cdata = dbarray($result);
if (checkgroup($cdata['article_cat_access'])) {
$res = 1;
add_to_title($locale['global_201'].$cdata['article_cat_name']);
opentable($locale['400'].": ".$cdata['article_cat_name']);
echo "";
$rows = dbcount("(article_id)", DB_ARTICLES, "article_cat='".$_GET['cat_id']."' AND article_draft='0'");
if (!isset($_GET['rowstart']) || !isnum($_GET['rowstart'])) { $_GET['rowstart'] = 0; }
if ($rows != 0) {
$result = dbquery(
"SELECT ta.article_id, ta.article_subject, ta.article_snippet, ta.article_name, ta.article_datestamp, tu.user_id, tu.user_name FROM ".DB_ARTICLES." ta
INNER JOIN ".DB_USERS." tu ON tu.user_id=ta.article_name WHERE article_cat='".$_GET['cat_id']."' AND article_draft='0' ORDER BY ".$cdata['article_cat_sorting']." LIMIT ".$_GET['rowstart'].",15"
);
$numrows = dbrows($result); $i = 1;
while ($data = dbarray($result)) {
if ($data['article_datestamp'] + 604800 > time() + ($settings['timeoffset'] * 3600)) {
$new = " [".$locale['402']."]";
} else {
$new = "";
}
echo "\n";
echo ($i != $numrows ? "
\n" : "\n"); $i++;
}
echo "";
closetable(); echo "©\n";
if ($rows > 15) echo "\n".makepagenav($_GET['rowstart'], 15, $rows, 3, FUSION_SELF."?cat_id=".$_GET['cat_id']."&")."\n
\n";
} else {
echo "".$locale['403']."
\n";
echo "";
closetable();
}
}
}
if ($res == 0) { redirect(FUSION_SELF); }
}
require_once THEMES."templates/footer.php";
?>