<?php
/*-------------------------------------------------------+
| PHP-Fusion Content Management System
| Copyright � 2002 - 2011 Nick Jones
| http://www.php-fusion.co.uk/
+--------------------------------------------------------+
| Redagavo: minimukas
| web: www.phpfusion.lt
+--------------------------------------------------------+
| Filmu sistema
| file: filmai_panel.php
+--------------------------------------------------------+
| Sukur�  WeberiZ
| El.pa?tas: gintaras321@inbox.lt
| skype: weberiz
| web: http://weberiz.tt.lt
+--------------------------------------------------------*/
if (!defined("IN_FUSION")) { die("Access Denied"); }
require_once "funkcijos.php";
openside("&#381;iurimiausi filmai");
 
$result = dbquery("SELECT * FROM ".DB_FILMAI." ORDER BY filmai_per DESC LIMIT 0,3");
 
//zanro rodytmo kodo pradzia
if (dbrows($result) != 0) {
	while($data = dbarray($result)) {
 
	$kategorijo=""; $kkk = 0;
			while ($kkk != 9) {
				if ($data['filmai_kat'.$kkk] != 0) {
					$rresult = dbquery("SELECT * FROM ".DB_FILMAI_KAT." WHERE filmai_kat_id = '".$data['filmai_kat'.$kkk]."'");
					if (dbrows($rresult)) { 
						$kdata = dbarray($rresult); 
						$kategorijo .= " ".$kdata['filmai_kat_pav'].",";}
					}
				$kkk++;	
			}
			$kategorijos = substr($kategorijo, 0, -1); 
			//zanro pabaiga
 
			//kalbos kodo pradzia
			$img = "<img src='/infusions/filmai_panel/img/kalba/lt.png' />";
                                 $img1 = "<img src=/infusions/filmai_panel/img/kalba/ru.png alt=>";
                                 $img2 = "<img src=/infusions/filmai_panel/img/kalba/en.gif alt=>";
  if($data['filmai_kalba'] == 0){
  $filmai_kalba = "<b><font color=yellow>Lie</font><font color=green>tu</font><font color=red>vi&#371; k.</font></b> $img";
  }elseif($data['filmai_kalba'] == 1){
  $filmai_kalba = "<b><font color=#ff7a7a>Rus&#371; k.</font></b> $img1";
  }if($data['filmai_kalba'] == 2){
  $filmai_kalba = "<b><b><font color=#00a9ff>Angl&#371; k.</font></b> $img2";
  }if($data['filmai_kalba'] == 3){
  $filmai_kalba = "<b><font color=green>Lietuvi&#371; sub.</font></b> $img";
  } 
			//kalbos pabaiga
 
		echo "<table><tr><td>";
		echo"<a href='".INFUSIONS."filmai_panel/filmai.php?filmas_id=".$data['filmai_id']."'><img src='".$data['filmai_img']."' width='100' height='153'/></a>";
		echo "</td><td><b><a href='".INFUSIONS."filmai_panel/filmai.php?filmas_id=".$data['filmai_id']."'>".$data['filmai_pav']."</a></b><br/>";
		echo "<b>Re&#382;isierius</b>: ".$data['filmai_rezisierius']."";
		echo "<b>&#302;garsinimas:</b>  $filmai_kalba";
		echo "<b>Premjera</b>: ".$data['filmai_metai']."";
		echo "<b>&#381;anras</b>: ".$kategorijos."";
		echo "<b>Trukm&#279;</b>: ".$data['filmai_trukme']."";
		echo "</td></tr></table>";
	}
 
} else {
	echo "N&#279;ra film&#371;";
}
 
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 "<table><tr><td>";
		echo"<a href='".INFUSIONS."filmai_panel/filmai.php?filmas_id=".$data['filmai_id']."'><img src='".$data['filmai_img']."' width='100' height='153'/></a>";
		echo "</td><td><b><a href='".INFUSIONS."filmai_panel/filmai.php?filmas_id=".$data['filmai_id']."'>".$data['filmai_pav']."</a></b><br/>";
		echo "<b>Metai</b>: ".$data['filmai_metai']."".trump(nl2br($data['filmai_apr']),170);
		echo "</td></tr></table>";
	}
 
} else {
	echo "N&#279;ra film&#371;";
}
closeside();
?>
Parsed in 0.066 seconds, using GeSHi 1.0.8.10