opentable("Atsitiktiniai filmai");

$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);



 



 

echo "

<td width='100'>

<strong>?iūrėjo: ".$data['filmai_per']."</strong>

<br />

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

<br />

<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)."' />

<br />

<a href='./filmai.php?filmas_id=".$data['filmai_id']."'>?iūrėti</a>

</td>";



}



} else {



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



}



echo "</tr>

</table>";



closetable();