".$kdata['filmai_kat_pav'].",";}
}
$kkk++;
}
$kategorijos = substr($kategorijo, 0, -1);
opentable($data['filmai_pav']." (".$data['filmai_metai'].")");
echo "";
echo "![](".$data[) ";
echo " | ";
echo "![](".INFUSIONS."filmai_panel/img/ziuret.png) ";
if ($data['filmai_trailler'] != "") {
echo "![](".INFUSIONS."filmai_panel/img/trailer.png) ";
}
if ($data['filmai_siustis'] != "") {
echo "![](".INFUSIONS."filmai_panel/img/siustis.png)
";
}
showratings("F", $_GET['filmas_id'], INFUSIONS."filmai_panel/filmai.php?filmas_id=".$data['filmai_id']);
echo "Kategorijos: ".$kategorijos."
";
echo nl2br(stripslashes($data['filmai_apr']));
echo " |
";
echo "
";
closetable();
showcomments("F", DB_FILMAI, "filmai_id", $_GET['filmas_id'], INFUSIONS."filmai_panel/filmai.php?filmas_id=".$data['filmai_id']);
} else {
opentable("klaida"); echo "nera tokio filmo"; closetable();
}
} elseif (!isset($_GET['kat_id']) || !isnum($_GET['kat_id'])) { //rodo
if (!isset($_GET['rowstart']) || !isnum($_GET['rowstart'])) { $_GET['rowstart'] = 0; }
$rows = dbcount("(*)", DB_FILMAI, "");
$result = dbquery("SELECT * FROM ".DB_FILMAI." ORDER BY filmai_date DESC LIMIT ".$_GET['rowstart'].",$items_per_page");
opentable("Filmai");
if (dbrows($result) != 0) {
$counter = 0; $columns = 3;
echo"\n\n";
while($data = dbarray($result)) {
if ($counter != 0 && ($counter % $columns == 0)) { echo "
\n\n"; }
$result1 = dbquery("SELECT SUM(rating_vote) FROM ".DB_RATINGS." WHERE rating_type='F' AND rating_item_id='".$data['filmai_id']."'");
$sudietas = dbresult($result1,0);
$kiekyra = dbcount("(rating_vote)", DB_RATINGS, "rating_type='F' AND rating_item_id='".$data['filmai_id']."'");
$reitingas = ($kiekyra ? $sudietas / $kiekyra : 0);
$komentarai = dbcount("(comment_id)", DB_COMMENTS, "comment_type='F' AND comment_item_id='".$data['filmai_id']."' AND comment_hidden='0'");
$tas = nl2br(stripslashes($data['filmai_apr']));
echo"| ";
echo "";
echo " | \n" ;
$counter++;
}
echo "
\n
\n";
if ($rows > $items_per_page) echo "\n".makepagenav($_GET['rowstart'],$items_per_page,$rows,3)."\n
\n";
}
closetable();
} else { //pagal kategorija
if (!isset($_GET['rowstart']) || !isnum($_GET['rowstart'])) { $_GET['rowstart'] = 0; }
$rresult = dbquery("SELECT * FROM ".DB_FILMAI_KAT." WHERE filmai_kat_id = '".$_GET['kat_id']."'");
if (dbrows($rresult)) {
$kddata = dbarray($rresult);
opentable($kddata['filmai_kat_pav']);
$veikia=1;
} else {
opentable("klaida!");
echo "tokia kategorija neegzistoja";
$veikia=0;
}
$rows = dbcount("(*)", DB_FILMAI, "filmai_kat0 = '".$_GET['kat_id']."' OR filmai_kat1 = '".$_GET['kat_id']."'
OR filmai_kat2 = '".$_GET['kat_id']."' OR filmai_kat3 = '".$_GET['kat_id']."'
OR filmai_kat4 = '".$_GET['kat_id']."' OR filmai_kat5 = '".$_GET['kat_id']."'
OR filmai_kat6 = '".$_GET['kat_id']."' OR filmai_kat7 = '".$_GET['kat_id']."'
OR filmai_kat8 = '".$_GET['kat_id']."' OR filmai_kat9 = '".$_GET['kat_id']."'");
$result = dbquery("SELECT * FROM ".DB_FILMAI."
WHERE filmai_kat0 = '".$_GET['kat_id']."' OR filmai_kat1 = '".$_GET['kat_id']."'
OR filmai_kat2 = '".$_GET['kat_id']."' OR filmai_kat3 = '".$_GET['kat_id']."'
OR filmai_kat4 = '".$_GET['kat_id']."' OR filmai_kat5 = '".$_GET['kat_id']."'
OR filmai_kat6 = '".$_GET['kat_id']."' OR filmai_kat7 = '".$_GET['kat_id']."'
OR filmai_kat8 = '".$_GET['kat_id']."' OR filmai_kat9 = '".$_GET['kat_id']."'
ORDER BY filmai_date DESC LIMIT ".$_GET['rowstart'].",$items_per_page");
if (dbrows($result) != 0 && $veikia != 0) {
$counter = 0; $columns = 3;
echo"\n\n";
while($data = dbarray($result)) {
if ($counter != 0 && ($counter % $columns == 0)) { echo "
\n\n"; }
$result1 = dbquery("SELECT SUM(rating_vote) FROM ".DB_RATINGS." WHERE rating_type='F' AND rating_item_id='".$data['filmai_id']."'");
$sudietas = dbresult($result1,0);
$kiekyra = dbcount("(rating_vote)", DB_RATINGS, "rating_type='F' AND rating_item_id='".$data['filmai_id']."'");
$reitingas = ($kiekyra ? $sudietas / $kiekyra : 0);
$komentarai = dbcount("(comment_id)", DB_COMMENTS, "comment_type='F' AND comment_item_id='".$data['filmai_id']."' AND comment_hidden='0'");
$tas = nl2br(stripslashes($data['filmai_apr']));
echo"";
echo "\n\n";
$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);
if ($reitingas >= 4.51) { $reitas = "r5";}
elseif ($reitingas >= 4.01) { $reitas = "r4-5";}
elseif ($reitingas >= 3.51) { $reitas = "r4";}
elseif ($reitingas >= 3.01) { $reitas = "r3-5";}
elseif ($reitingas >= 2.51) { $reitas = "r3";}
elseif ($reitingas >= 2.01) { $reitas = "r2-5";}
elseif ($reitingas >= 1.51) { $reitas = "r2";}
elseif ($reitingas >= 1.01) { $reitas = "r1-5";}
elseif ($reitingas >= 0.51) { $reitas = "r1";}
elseif ($reitingas >= 0.01) { $reitas = "r0-5";}
else { $reitas = "r0";}
echo"|
".$data['filmai_pav']."::Kategorijos: ".$kategorijos."
Metai: ".$data['filmai_metai']."
".trump($tas,1000)."
| ";
echo"
![](".INFUSIONS."filmai_panel/img/".$reitas.".png "\".round($reitingas,2).\"") |
Žiūrėti |
";
echo" ";
echo " | \n" ;
$counter++;
}
echo "
\n
\n";
if ($rows > $items_per_page) echo "\n".makepagenav($_GET['rowstart'],$items_per_page,$rows,3,FUSION_SELF."?kat_id=".$kddata['filmai_kat_id']."&")."\n
\n";
} else {
echo("Šioje kategorija nėra filmu");
}
closetable();
}
if ($topasonline == 1) {
$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_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 4");
if (dbrows($result) != 0) {
opentable("Top reitingojami filmai");
echo "";
while($data = dbarray($result)) {
$tas = nl2br(stripslashes($data['filmai_apr']));
echo "\n\n";
$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);
echo"|
".$data['filmai_pav']."::Kategorijos: ".$kategorijos."
Metai: ".$data['filmai_metai']."
".trump($tas,1000)."
| ";
echo"
".round($data['topas'],2)." ";
if ($data['filmai_trailler'] != "") {
echo " | ![](".INFUSIONS."filmai_panel/img/youtube.gif "Trailer") | ";
}
echo "Žiūrėti |
";
echo" | ";
}
echo "
";
closetable();
}
}
echo "";
require_once THEMES."templates/footer.php";
?>