opentable("Top");

$limit = "15";

$result = dbquery("SELECT * from ".$db_prefix."filmai ORDER BY filmai_per DESC LIMIT 0,".$limit."");



echo"<table cellpadding='0' cellspacing='2'>

<tr>";



if (dbrows($result) != 0) {



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



$itemsubject = trimlink($data['filmai_pav'], 23);



 



            $wynik = dbquery("SELECT SUM(rating_vote) FROM ".DB_RATINGS." WHERE rating_type='F' AND rating_item_id='".$data['filmai_id']."'");



                $info2 = dbresult($wynik,0);



                $num_rating = dbcount("(rating_vote)", DB_RATINGS, "rating_type='F' AND rating_item_id='".$data['filmai_id']."'");



                $wyn_rating = ($num_rating ? $info2 / $num_rating : 0);



 



    $tas = nl2br(stripslashes($data['filmai_apr']));



 

echo "

<td width='100'>



<br />

<a href='/filmai.php?filmas_id=".$data['filmai_id']."'><img src='".$data['filmai_img']."' width='90' height='150' /></a>

<br />

<center><img src='".INFUSIONS."filmai_panel/img/r".ceil($wyn_rating).".png' width='80' height='13' alt='".ceil($wyn_rating)."' style='vertical-align:middle;' title='".ceil($wyn_rating)."' /></center>

<br />



</td>";



}



} else {



echo "<center>Nerasta</center>\n";



}



echo "</tr>

</table>";



closetable();