"; $img1 = ""; $img2 = ""; if($data['filmai_kalba'] == 0){ $filmai_kalba = "Lietuvių k. $img"; }elseif($data['filmai_kalba'] == 1){ $filmai_kalba = "Rusų k. $img1"; }if($data['filmai_kalba'] == 2){ $filmai_kalba = "Anglų k. $img2"; }if($data['filmai_kalba'] == 3){ $filmai_kalba = "Lietuvių sub. $img"; } //kalbos pabaiga echo "

"; echo""; echo "

".$data['filmai_pav']." "; echo "Režisierius: ".$data['filmai_rezisierius']." "; echo "Įgarsinimas: $filmai_kalba "; echo "Premjera: ".$data['filmai_metai']." "; echo "Žanras: ".$kategorijos." "; echo "Trukmė: ".$data['filmai_trukme']." "; echo "

"; } } else { echo "Nėra filmų"; } closeside(); openside("TOP 3 filmai"); $result = dbquery(" SELECT P1.rating_item_id, AVG(P1.rating_vote) AS topas, FL.filmai_id, FL.filmai_img, FL.filmai_pav, FL.filmai_apr, FL.filmai_trailler, FL.filmai_metai, FL.filmai_kalba, FL.filmai_aktoriai, FL.filmai_rezisierius, FL.filmai_trukme, FL.filmai_kat0, FL.filmai_kat1, FL.filmai_kat2, FL.filmai_kat3, FL.filmai_kat4, FL.filmai_kat5, FL.filmai_kat6, FL.filmai_kat7, FL.filmai_kat8, FL.filmai_kat9 FROM ".DB_RATINGS." AS P1, ".DB_RATINGS." AS P2, ".DB_FILMAI." AS FL WHERE P1.rating_type='F' AND P1.rating_item_id=P2.rating_item_id AND FL.filmai_id=P1.rating_item_id GROUP BY P1.rating_item_id HAVING ( SUM(CASE WHEN P2.rating_vote <= P1.rating_vote THEN 1 ELSE 0 END) >= ((COUNT(*) + 1) / 2) AND SUM(CASE WHEN P2.rating_vote >= P1.rating_vote THEN 1 ELSE 0 END) >= (COUNT(*)/2 + 1) ) OR ( SUM(CASE WHEN P2.rating_vote >= P1.rating_vote THEN 1 ELSE 0 END) >= ((COUNT(*) + 1) / 2) AND SUM(CASE WHEN P2.rating_vote <= P1.rating_vote THEN 1 ELSE 0 END) >= (COUNT(*)/2 + 1) ) ORDER BY topas DESC LIMIT 3"); if (dbrows($result)) { while($data = dbarray($result)) { //stripslashes() echo "

"; echo""; echo "

".$data['filmai_pav']." "; echo "Metai: ".$data['filmai_metai']." ".trump(nl2br($data['filmai_apr']),170); echo "

"; } } else { echo "Nėra filmų"; } closeside(); ?>