owner::
nazov fora::
zorad podla::	id fora vzostupne (najstarsie) id fora zostupne (najnovsie) najstarsieho casu posledneho prispevku najstarsieho pristupu ownera do fora poctu prispevkov vzostupne poctu prispevkov zostupne
kategoria::	query("select * from category order by category_tree"); $selectstring=""; $selectstring.="vsetky kategorie"; while ($set->next()) { $count=substr_count($set->getString('category_tree'),";"); $selectstring.="getString('category_id')) $selectstring.= " selected "; $selectstring.= ">"; if ($count) { $selectstring.="|"; for ($i=0;$i<$count;$i++) $selectstring.="----"; } $selectstring.=$set->getString('category_name').""; } $selectstring.=""; echo $selectstring; ?>

query("select id from user where login='$forum_owner'"); $set->next(); $forum_owner_id=$set->getString('id'); } else $forum_owner_id=$forum_owner; $q.=" and forum_owner='$forum_owner_id' "; } if (!empty($_POST['forum_text'])) { $q.=" and forum_name like '%".$_POST['forum_text']."%' "; } if ($_POST['forum_category']!='all') { $forum_category=$_POST['forum_category'].";"; $q.="and category_tree like '$forum_category' "; } $forum_order=$_POST['forum_order']; if ($forum_order=="id_desc") { $q.="order by forum.forum_id desc"; } if ($forum_order=="id_asc") { $q.="order by forum.forum_id asc"; } if ($forum_order=="last_owner_access") { $q.="order by owner_access.last_visit asc"; } if ($forum_order=="last_submission") { $q.="order by last_submission asc"; } if ($forum_order=="submission_count_asc") { $q.="order by submission_count asc"; } if ($forum_order=="submission_count_desc") { $q.="order by submission_count desc"; } echo $q; $set=$kyberia->query($q); while($set->next()) { echo "forum::".$set->getString('forum_name')."
"; echo "owner::".$set->getString('forum_owner')."
"; echo "pocet prispevkov::".$set->getString('forum_submissions')."
"; echo "posledny prispevok::".$set->getString('last_submission')."
"; echo "ownerova posledna navsteva fora::".$set->getString('owner_access.last_visit')."
"; echo "

"; } } ?>