<?php

 

require_once "maincore.php";

require_once THEMES."templates/header.php";

 

openside("top naujienos");

$result = dbquery("SELECT tn.*, SUM(tr.rating_vote) AS sum_rating, COUNT(tr.rating_item_id) AS count_votes FROM

".$db_prefix."news tn

LEFT JOIN ".$db_prefix."ratings tr ON tn.news_id=tr.rating_item_id AND tr.rating_type='N'

GROUP BY news_subject

ORDER BY news_reads DESC LIMIT 150");

 

if (dbrows($result)) {

echo "<table cellpadding='0' cellspadding='0' class='tbl-border'>";

echo "<tr>

</td>

</tr>";

 

$i = 0;

$rating = "<div style='background:url(http://img80.imageshack.us/img80/3918/ratingsbghp8.gif); height:21px; width:105px;'>".($data['count_votes'] > 0 ? str_repeat("<img src='http://img165.imageshack.us/img165/8202/starwd7.gif' alt='*' style='vertical-align:middle'>", ceil($data['sum_rating'] / $data['count_votes'])) : "")."</div>";

echo "<table border='0' cellpadding='0' cellspacing='0' width='100%' class='tbl-border'>

<td width='100%' class='tbl2'><b><big><a href='".BASEDIR."news.php?readmore=".$data['news_id']."'>

".trimlink($data['news_subject'],30)."</a></big></b></td></table>

<table border='0' cellpadding='0' cellspacing='0' width='100%' class='tbl-border'>

<td width='80%' class='tbl1'><small>".$data['news_news']."</small></td></table>

<table border='0' cellpadding='0' cellspacing='0' width='100%' class='tbl-border'>

<td width='100%' class='tbl2'><center><small>· ".$data['news_reads']." Peržiuros · <a href='".BASEDIR."news.php?readmore=".$data['news_id']."'>

Toliau...</a></small></center></td><td class='".($i%2?"tbl1":"tbl2")."'>$rating</td></table>";

$i++;

}

 

echo "</table>";

} else {

echo "<center>Naujeinu Nera</center>";

}

 

closeside();

 

require_once THEMES."templates/footer.php";

?>