openside("Kategorie i fora");

//forums cats

$result = dbquery("SELECT * FROM ".DB_FORUMS." WHERE ".groupaccess('forum_access')." AND forum_cat=0 ORDER BY forum_order ASC");

$rows = dbrows($result);

if ($rows!=0) {

   echo "<b>Kategorie forów</b>";

	echo "<p style='margin-left:20px'>";

	while ($data = dbarray($result)) {

		$forums_count = dbcount("(*)", DB_FORUMS, "forum_cat='".$data['forum_id']."'");

		echo "<img src='".THEME."images/bullet.gif' alt='bullet' /> ".$data['forum_name']." - <span class='small'>[fora: ".$forums_count."]</span><br  />";

	}

	echo "</p>";

}

//forums

$result = dbquery("SELECT * FROM ".DB_FORUMS." WHERE ".groupaccess('forum_access')." AND forum_cat!=0 ORDER BY forum_order ASC");

$rows = dbrows($result);

if ($rows!=0) {

   echo "<b>Fora</b>";

	echo "<p style='margin-left:20px'>";

	while ($data = dbarray($result)) {

		$threads_count = dbcount("(*)", DB_THREADS, "forum_id='".$data['forum_id']."'");

		echo "<img src='".THEME."images/bullet.gif' alt='bullet' /> <a href='".BASEDIR."forum/viewforum.php?forum_id=".$data['forum_id']."'>".$data['forum_name']."</a> - <span class='small'>[tematy: ".$threads_count."]</span><br  />";

	}

	echo "</p>";

}

closeside();