";
$result = dbquery("SELECT * FROM ".DB_SLOWNIK_CATS." ORDER BY slownik_cat_name");
$rows = dbrows($result);
if ($rows) {
$columns = 2; $counter = 0;
echo "\n\n";
while($data = dbarray($result)) {
if ($counter != 0 && ($counter % $columns == 0)) { echo "
\n\n"; }
$num = dbcount("(slownik_id)", DB_SLOWNIKS, "slownik_cat_id='".$data['slownik_cat_id']."'");
echo "".$data['slownik_cat_name']." ($num)\n";
if ($data['slownik_cat_description']) { echo "
\n".$data['slownik_cat_description'].""; }
echo " | \n";
$counter++;
}
echo "
\n
\n";
} else {
echo "
\n".$locale['410']."
\n
\n";
}
echo "";
closetable();
} else {
if ($data = dbarray(dbquery("SELECT * FROM ".DB_SLOWNIK_CATS." WHERE slownik_cat_id='".$_GET['cat_id']."'"))) {
add_to_title($locale['global_201'].$data['slownik_cat_name']);
opentable($locale['401'].": ".$data['slownik_cat_name']);
echo "";
$rows = dbcount("(slownik_id)", DB_SLOWNIKS, "slownik_cat_id='".$_GET['cat_id']."'");
if (!isset($_GET['rowstart']) || !isnum($_GET['rowstart'])) { $_GET['rowstart'] = 0; }
if ($rows != 0) {
$result = dbquery("SELECT * FROM ".DB_SLOWNIKS." WHERE slownik_cat_id='".$_GET['cat_id']."' ORDER BY slownik_id LIMIT ".$_GET['rowstart'].",15");
$numrows = dbrows($result);
$tbl = 2; $i = 0;
echo "\n\n";
while ($data = dbarray($result)) {
if ($i != 0 && ($i % $tbl == 0)) { echo "
\n\n"; }
echo "".$data['slownik_question']."
\n".nl2br(stripslashes($data['slownik_answer']));
echo ($i != $numrows ? "
\n" : "\n");
echo " | ";
$i++;
}
echo "
\n
\n";
echo "";
closetable();
if ($rows != 0) { echo "".makepagenav($_GET['rowstart'], 15, $rows, 3, FUSION_SELF."?cat_id=".$_GET['cat_id']."&")."\n
\n"; }
} else {
echo $locale['411']."\n";
echo "";
closetable();
}
} else {
redirect(FUSION_SELF);
}
}
require_once THEMES."templates/footer.php";
?>