openside("name"); echo "

Najwyżej oceniane:

"; $wynik = dbquery("SELECT *, (SELECT COUNT(rating_id) FROM ".DB_RATINGS." c WHERE c.rating_type='A' AND (c.rating_item_id = article_id)) AS ile, (SELECT ROUND(AVG(rating_vote), 2) FROM ".DB_RATINGS." c WHERE c.rating_type='A' AND (c.rating_item_id = article_id)) AS srednia FROM ".DB_ARTICLES." WHERE article_draft='0' ORDER BY srednia DESC, ile DESC LIMIT 4"); echo ""; if(dbrows($wynik) > 0) { while($data = dbarray($wynik)) { $itemsubject = trimlink($data['article_subject'], 23); echo " "; } } else { echo " "; } echo "

".THEME_BULLET." $itemsubject	Oceniono: ".number_format($data['ile'])."
	Średnia: ".number_format($data['srednia'], 2)."

Brak artykułów

"; echo "

Najczęściej czytane:

"; $wynik1 = dbquery("SELECT * FROM ".DB_ARTICLES." WHERE article_draft='0' ORDER BY article_reads DESC LIMIT 4"); echo ""; if(dbrows($wynik1) > 0) { while($data1 = dbarray($wynik1)) { $itemsubjecta = trimlink($data1['article_subject'], 23); echo " "; } } else { echo " "; } echo "

".THEME_BULLET." $itemsubjecta	Czytano: ".number_format($data1['article_reads'])."
Brak artykułów

"; closeside();