if (!isset($cat_id)) {
opentable($locale['400']);
$result = dbquery("SELECT * FROM ".$db_prefix."faq_cats ORDER BY faq_cat_name");
$rows = dbrows($result);
if ($rows != 0) {
$columns = 3; $counter = 0;
echo "
\n\n";
while($data = dbarray($result)) {
if ($counter != 0 && ($counter % $columns == 0)) echo "
\n\n";
$num = dbcount("(faq_id)", "faqs", "faq_cat_id='".$data['faq_cat_id']."'");
echo "".$data['faq_cat_name']."\n";
if ($data['faq_cat_description'] != "") echo " \n".$data['faq_cat_description']."";
echo " | \n";
$counter++;
}
echo "
\n
\n";
} else {
echo "
\n".$locale['410']."
\n\n";
}
closetable();
} else {
if (!isNum($cat_id)) fallback(FUSION_SELF);
if ($data = dbarray(dbquery("SELECT * FROM ".$db_prefix."faq_cats WHERE faq_cat_id='$cat_id'"))) {
opentable($locale['401'].": ".$data['faq_cat_name']);
$rows = dbcount("(*)", "faqs", "faq_cat_id='$cat_id'");
if (!isset($rowstart) || !isNum($rowstart)) $rowstart = 0;
if ($rows != 0) {
$columns = 2; $counter = 0;
$result = dbquery("SELECT * FROM ".$db_prefix."faqs WHERE faq_cat_id='$cat_id' ORDER BY faq_question LIMIT $rowstart,12");
$numrows = dbrows($result);
$i = 1;
while ($data = dbarray($result)) {
echo "".$data['faq_question']."
\n".nl2br(stripslashes($data['faq_answer']));
echo ($i != $numrows ? "
\n" : "\n");
$i++;
}
closetable();
if ($rows != 0) echo "".makePageNav($rowstart,12,$rows,3,FUSION_SELF."?cat_id=$cat_id&")."\n
\n";
} else {
echo $locale['411']."\n";
closetable();
}
} else {
redirect(FUSION_SELF);
}
}
require_once "side_right.php";
require_once "footer.php";
?>