openside("Najnowsze strony");

$result = dbquery("

	SELECT c.*, (SELECT AVG(rating_vote) 

		FROM ".DB_PREFIX."ratings r 

		WHERE r.rating_type='C' 

		AND (r.rating_item_id = c.page_id)) as ratingcount 

	FROM ".DB_PREFIX."custom_pages c 

	ORDER BY ratingcount DESC LIMIT 5

");



echo '<b>Najnowsze Strony:</b><br>';

$rows = dbrows($result);

if ($rows != 0) {

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

		echo "<img src='".THEME."images/bullet.gif' alt=''> <a href='".BASEDIR."viewpage.php?page_id=".$row['page_id']."'>".$row['page_title']."</a><br>";

	}

}else{

	echo "Obecnie nie ma żadnych stron.<br>"; 

}

closeside();