".$locale['404']."";
$str .= " » ".$data['anime_cat_name']."";
$str .= " » ".$data['anime_subject']."";
$isTrue = true;
}
} elseif (isset($_GET['cat_id']) && isnum($_GET['cat_id'])){
$result = dbquery(
"SELECT anime_cat_name FROM ".DB_anime_CATS."
WHERE anime_cat_id='".$_GET['cat_id']."'");
if (dbrows($result)) {
$data = dbarray($result);
$str .= "".$locale['404']."";
$str .= " » ".$data['anime_cat_name']."";
$isTrue = true;
}
}
if($isTrue){
opentable($locale['405']);
echo $str;
closetable();
}
# end of breadcrumbs
add_to_title($locale['global_200'].$locale['400']);
if (isset($_GET['anime_id']) && isnum($_GET['anime_id'])) {
$result = dbquery(
"SELECT ta.anime_subject, ta.anime_anime, ta.anime_breaks,
ta.anime_datestamp, ta.anime_reads, ta.anime_allow_comments, ta.anime_allow_ratings,
tac.anime_cat_id, tac.anime_cat_name,
tu.user_id, tu.user_name, tu.user_status
FROM ".DB_anime." ta
INNER JOIN ".DB_anime_CATS." tac ON ta.anime_cat=tac.anime_cat_id
LEFT JOIN ".DB_USERS." tu ON ta.anime_name=tu.user_id
WHERE ".groupaccess('anime_cat_access')." AND anime_id='".$_GET['anime_id']."' AND anime_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_anime." SET anime_reads=anime_reads+1 WHERE anime_id='".$_GET['anime_id']."'"); }
$anime = stripslashes($data['anime_anime']);
if (preg_match('<--PAGEBREAK-->', $anime)) {
$anime = explode("<--PAGEBREAK-->", $anime);
} else {
$anime = explode("", $anime);
}
$pagecount = count($anime);
$anime_subject = stripslashes($data['anime_subject']);
$anime_info = array(
"anime_id" => $_GET['anime_id'],
"cat_id" => $data['anime_cat_id'],
"cat_name" => $data['anime_cat_name'],
"user_id" => $data['user_id'],
"user_name" => $data['user_name'],
"user_status" => $data['user_status'],
"anime_date" => $data['anime_datestamp'],
"anime_breaks" => $data['anime_breaks'],
"anime_comments" => dbcount("(comment_id)", DB_COMMENTS, "comment_type='A' AND comment_item_id='".$_GET['anime_id']."'"),
"anime_reads" => $data['anime_reads'],
"anime_allow_comments" => $data['anime_allow_comments']
);
add_to_title($locale['global_201'].$anime_subject);
echo "";
render_anime($anime_subject, $anime[$_GET['rowstart']], $anime_info);
echo "";
if ($pagecount > 1) {
echo "\n".makepagenav($_GET['rowstart'], 1, $pagecount, 3, FUSION_SELF."?anime_id=".$_GET['anime_id']."&")."\n
\n";
}
if ($data['anime_allow_comments']) { showcomments("A", DB_anime, "anime_id", $_GET['anime_id'], FUSION_SELF."?anime_id=".$_GET['anime_id']); }
if ($data['anime_allow_ratings']) { showratings("A", $_GET['anime_id'], FUSION_SELF."?anime_id=".$_GET['anime_id']); }
} else {
redirect(FUSION_SELF);
}
} elseif (!isset($_GET['cat_id']) || !isnum($_GET['cat_id'])) {
opentable($locale['400']);
echo "\n";
//$result = dbquery("SELECT anime_cat_id, anime_cat_name, anime_cat_description FROM ".DB_anime_CATS." WHERE ".groupaccess('anime_cat_access')." ORDER BY anime_cat_name");
// NEW QUERY
$result = dbquery(
"SELECT ac.anime_cat_id, ac.anime_cat_name, ac.anime_cat_description, COUNT(a.anime_cat) AS anime_count FROM ".DB_anime." a
LEFT JOIN ".DB_anime_CATS." ac ON a.anime_cat=ac.anime_cat_id
WHERE ".groupaccess('ac.anime_cat_access')."
GROUP BY ac.anime_cat_id
ORDER BY ac.anime_cat_name"
);
$rows = dbrows($result);
if ($rows) {
$counter = 0; $columns = 2;
echo "\n\n";
while ($data = dbarray($result)) {
if ($counter != 0 && ($counter % $columns == 0)) { echo "
\n\n"; }
//$num = dbcount("(anime_cat)", DB_anime, "anime_cat='".$data['anime_cat_id']."' AND anime_draft='0'");
echo "".$data['anime_cat_name']." (".$data['anime_count'].")";
if ($data['anime_cat_description'] != "") { echo "
\n".$data['anime_cat_description'].""; }
echo " | \n";
$counter++;
}
echo "
\n
\n";
} else {
echo "
\n".$locale['401']."
\n
\n";
}
echo "\n";
closetable();
} else {
$res = 0;
$result = dbquery("SELECT anime_cat_name, anime_cat_sorting, anime_cat_access FROM ".DB_anime_CATS." WHERE anime_cat_id='".$_GET['cat_id']."'");
if (dbrows($result) != 0) {
$cdata = dbarray($result);
if (checkgroup($cdata['anime_cat_access'])) {
$res = 1;
add_to_title($locale['global_201'].$cdata['anime_cat_name']);
opentable($locale['400'].": ".$cdata['anime_cat_name']);
echo "";
$rows = dbcount("(anime_id)", DB_anime, "anime_cat='".$_GET['cat_id']."' AND anime_draft='0'");
if (!isset($_GET['rowstart']) || !isnum($_GET['rowstart'])) { $_GET['rowstart'] = 0; }
if ($rows != 0) {
$result = dbquery(
"SELECT anime_id, anime_subject, anime_snippet, anime_datestamp FROM ".DB_anime."
WHERE anime_cat='".$_GET['cat_id']."' AND anime_draft='0' ORDER BY ".$cdata['anime_cat_sorting']." LIMIT ".$_GET['rowstart'].",".$settings['anime_per_page']
);
$numrows = dbrows($result); $i = 1;
while ($data = dbarray($result)) {
$class = ($i%2 ? "tbl1" : "tbl2");
if ($data['anime_datestamp'] + 604800 > time() + ($settings['timeoffset'] * 3600)) {
$new = " [".$locale['402']."]";
} else {
$new = "";
}
echo "";
echo ($i != $numrows ? "
\n" : "\n"); $i++;
}
echo "";
closetable();
if ($rows > $settings['anime_per_page']) echo "\n".makepagenav($_GET['rowstart'], $settings['anime_per_page'], $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";
?>