Sveiki niekaip nesuprantu kur ce klaida ysivelus ar galit pataisyti
<?php
/*-------------------------------------------------------+
| PHP-Fusion Content Management System
| Copyright © 2002 - 2011 Nick Jones
| http://www.php-fusion.co.uk/
+--------------------------------------------------------+
| Filmu sistema
| file: filmai.php
+--------------------------------------------------------+
| Redagavo: minimukas
| web: www.phpfusion.lt
+--------------------------------------------------------+
| Sukurë WeberiZ
| El.pastas: gintaras321@inbox.lt
| skype: weberiz
| web: http://weberiz.tt.lt
+--------------------------------------------------------*/
require_once "maincore.php";
require_once THEMES."templates/header.php";
require_once INFUSIONS."filmai_panel/funkcijos.php";
include INFUSIONS."filmai_panel/ziureti_seriala.php";
$items_per_page = 20;
if (isset($_GET['filmas_id']) && isnum($_GET['filmas_id'])) { //filmo rodimas
$result = dbquery("SELECT * FROM ".DB_FILMAI." WHERE filmai_id='".$_GET['filmas_id']."'");
$topasonline = 0;
if (dbrows($result) != 0) {
require_once INFUSIONS."filmai_panel/priedai/comments_include.php";
require_once INFUSIONS."filmai_panel/priedai/ratings_include.php";
$data = dbarray($result);
$result = dbquery("UPDATE ".DB_FILMAI." SET filmai_per=filmai_per+1 WHERE filmai_id='".$_GET['filmas_id']."'");
$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 .= " <a href='filmai.php?kat_id=".$kdata['filmai_kat_id']."'>".$kdata['filmai_kat_pav']."</a>,";}
}
$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ų k.</font></b> $img";
}elseif($data['filmai_kalba'] == 1){
$filmai_kalba = "<b><font color=#ff7a7a>Rusų k.</font></b> $img1";
}if($data['filmai_kalba'] == 2){
$filmai_kalba = "<b><font color=#00a9ff>Anglų k.</font></b> $img2";
}if($data['filmai_kalba'] == 3){
$filmai_kalba = "<b><font color=green>Lietuvių sub.</font></b> $img";
}
$kkk++;
}
$kategorijos = substr($kategorijo, 0, -1);
opentable("".$data['filmai_pav']."");
echo "<table cellpadding='0' cellspacing='0'><tr><td width='190' valign='top' align='center' style='padding: 0 5px;'>";
echo "<img src='".$data['filmai_img']."' width='190' height='290' />";
echo "</td><td valign='top' align='left' style='padding: 0 5px;'>";
if ($data['filmai_kodas'] != "") {
echo "<img onclick=\"TINY.box.show({url:'".INFUSIONS."filmai_panel/filmas.php?filmas_id=".$data['filmai_id']."',boxid:'dezute',maskid:'patamsejimas',})\" src='".INFUSIONS."filmai_panel/img/ziuret.png' onmouseover=\"this.src='".INFUSIONS."filmai_panel/img/ziuret1.png'\" onmouseout=\"this.src='".INFUSIONS."filmai_panel/img/ziuret.png'\" style='cursorointer' >";
}
if ($data['filmai_kodas2'] != "") {
echo "<img onclick=\"TINY.box.show({url:'".INFUSIONS."filmai_panel/filmas2.php?filmas_id=".$data['filmai_id']."',boxid:'dezute',maskid:'patamsejimas',})\" src='".INFUSIONS."filmai_panel/img/ziuretifilma.png' onmouseover=\"this.src='".INFUSIONS."filmai_panel/img/ziuretifilma1.png'\" onmouseout=\"this.src='".INFUSIONS."filmai_panel/img/ziuretifilma.png'\" style='cursorointer' >";
}
if ($data['filmai_trailler'] != "") {
echo "<img onclick=\"TINY.box.show({url:'".INFUSIONS."filmai_panel/trailler.php?filmas_id=".$data['filmai_id']."',boxid:'dezute',maskid:'patamsejimas',})\" src='".INFUSIONS."filmai_panel/img/trailer.png' onmouseover=\"this.src='".INFUSIONS."filmai_panel/img/trailer1.png'\" onmouseout=\"this.src='".INFUSIONS."filmai_panel/img/trailer.png'\" style='cursorointer' />";
}
if ($data['filmai_siustis'] != "") {
echo "<a href='".$data['filmai_siustis']."' rel='nofollow'><img src='".INFUSIONS."filmai_panel/img/siustis.png' onmouseover=\"this.src='".INFUSIONS."filmai_panel/img/siustis1.png'\" onmouseout=\"this.src='".INFUSIONS."filmai_panel/img/siustis.png'\" border='0' /></a><br/>";
}
//showratings("F", $_GET['filmas_id'], INFUSIONS."filmai_panel/filmai.php?filmas_id=".$data['filmai_id']);
echo "<br /><br />";
set_title($data['filmai_pav']);
echo "<b>Režisierius</b>: ".$data['filmai_rezisierius']."<br />";
echo "<b>Aktoriai</b>: ".$data['filmai_aktoriai']."<br />";
echo "<b>Premjera</b>: ".$data['filmai_metai']."<br />";
echo "<b>Žanras</b>: ".$kategorijos."<br />";
echo "<b>Įgarsinimas</b>: $filmai_kalba<br />";
echo "<b>Trukmė</b>: ".$data['filmai_trukme']."<br /><br />";
//echo "<b>Apie filmą</b>:<br />";
//echo nl2br(stripslashes($data['filmai_apr']));
//facebook like miktukas
$url = (!empty($_SERVER['HTTPS'])) ? "https://".$_SERVER['SERVER_NAME'].$_SERVER['REQUEST_URI'] : "http://".$_SERVER['SERVER_NAME'].$_SERVER['REQUEST_URI'];
echo "<table cellpadding='0' cellspacing='0'>\n<tr>\n
<td valign='top' align='left'>";
?>
<script src='http://connect.facebook.net/lt_LT/all.js'></script>
<script>
window.fbAsyncInit = function() {
FB.init({appId: '266587840018167', status: true, cookie: true,
xfbml: true});
};
(function() {
var e = document.createElement('script'); e.async = true;
e.src = document.location.protocol +
'//connect.facebook.net/en_US/all.js';
document.getElementById('fb-root').appendChild(e);
}());
</script>
<div id='fb-root'><fb:like href='<?php echo $url;?>' layout='standard' show-faces='true' width='500' action='like' colorscheme='light' /></div>
<?
echo"</td>\n
<td valign='top' align='left'><a name='fb_share' type='button' href='http://www.facebook.com/sharer.php'>Dalintis</a><script src='http://static.ak.fbcdn.net/connect.php/js/FB.Share' type='text/javascript'></script></td>\n
</tr>\n</table>\n";
//facebook like miktuko pabaiga
echo "<table class='reit' cellspacing='0' border='0' width='100%' style='margin: 0.7em 0em 0.7em 0em;'>";
echo"<tr><td align='center' valign='middle'> ";
showratings("F", $_GET['filmas_id'], INFUSIONS."filmai_panel/filmai.php?filmas_id=".$data['filmai_id']);
echo "</table>";
echo "</td></tr>";
echo "</table>";
echo"<table align='center' width='100%'>";
echo "<td colspan='2' valign='top' style='padding-top: 0px; color:#B8B8B8 ; font-size: 12px; font-family: Verdana;'> <hr/><span style='font-size: 10px'><b>Aprašymas:</b><br/> ".$data['filmai_apr']." </span> <hr/> </td>";
echo "</table>";
// tblline
// tblline1
// tblline
// tblline1
echo"<table align='center' width='100%'>";
if ($data['pavadinimas1'] == ''){
}else{
echo"<tr>
<td width='80%' class='tbl9'> $data[pavadinimas1] </td>
<td width='10%' class='tbl9' align='center'> <a href='$data[serialas1]' title='$data[pavadinimas1]' rel='shadowbox'><img src='".IMAGES."play_icon.png'></td>
</tr>";
}
if ($data['pavadinimas2'] == ''){
}else{
echo"<tr>
<td width='90%' class='tbl9'> $data[pavadinimas2] </td>
<td width='10%' class='tbl9' align='center'> <a href='$data[serialas2]' title='$data[pavadinimas2]' rel='shadowbox'><img src='".IMAGES."play_icon.png'></td>
</tr>";
}
if ($data['pavadinimas3'] == ''){
}else{
echo"<tr>
<td width='90%' class='tbl9'> $data[pavadinimas3] </td>
<td width='10%' class='tbl9' align='center'> <a href='$data[serialas3]' title='$data[pavadinimas3]' rel='shadowbox'><img src='".IMAGES."play_icon.png'></td>
</tr>";
}
if ($data['pavadinimas4'] == ''){
}else{
echo"<tr>
<td width='90%' class='tbl9'> $data[pavadinimas4] </td>
<td width='10%' class='tbl9' align='center'> <a href='$data[serialas4]' title='$data[pavadinimas4]' rel='shadowbox'><img src='".IMAGES."play_icon.png'></td>
</tr>";
}
if ($data['pavadinimas5'] == ''){
}else{
echo"<tr>
<td width='90%' class='tbl9'> $data[pavadinimas5] </td>
<td width='10%' class='tbl9' align='center'> <a href='$data[serialas5]' title='$data[pavadinimas5]' rel='shadowbox'><img src='".IMAGES."play_icon.png'></td>
</tr>";
}
if ($data['pavadinimas6'] == ''){
}else{
echo"<tr>
<td width='90%' class='tbl9'> $data[pavadinimas6] </td>
<td width='10%' class='tbl9' align='center'> <a href='$data[serialas6]' title='$data[pavadinimas6]' rel='shadowbox'><img src='".IMAGES."play_icon.png'></td>
</tr>";
}
if ($data['pavadinimas7'] == ''){
}else{
echo"<tr>
<td width='90%' class='tbl9'> $data[pavadinimas7] </td>
<td width='10%' class='tbl9' align='center'> <a href='$data[serialas7]' title='$data[pavadinimas7]' rel='shadowbox'><img src='".IMAGES."play_icon.png'></td>
</tr>";
}
if ($data['pavadinimas8'] == ''){
}else{
echo"<tr>
<td width='90%' class='tbl9'> $data[pavadinimas8] </td>
<td width='10%' class='tbl9' align='center'> <a href='$data[serialas8]' title='$data[pavadinimas8]' rel='shadowbox'><img src='".IMAGES."play_icon.png'></td>
</tr>";
}
if ($data['pavadinimas9'] == ''){
}else{
echo"<tr>
<td width='90%' class='tbl9'> $data[pavadinimas9] </td>
<td width='10%' class='tbl9' align='center'> <a href='$data[serialas9]' title='$data[pavadinimas9]' rel='shadowbox'><img src='".IMAGES."play_icon.png'></td>
</tr>";
}
if ($data['pavadinimas10'] == ''){
}else{
echo"<tr>
<td width='90%' class='tbl9'> $data[pavadinimas10] </td>
<td width='10%' class='tbl9' align='center'> <a href='$data[serialas10]' title='$data[pavadinimas10]' rel='shadowbox'><img src='".IMAGES."play_icon.png'></td>
</tr>";
}
if ($data['pavadinimas11'] == ''){
}else{
echo"<tr>
<td width='90%' class='tbl9'> $data[pavadinimas11] </td>
<td width='10%' class='tbl9' align='center'> <a href='$data[serialas11]' title='$data[pavadinimas11]' rel='shadowbox'><img src='".IMAGES."play_icon.png'></td>
</tr>";
}
if ($data['pavadinimas12'] == ''){
}else{
echo"<tr>
<td width='90%' class='tbl9'> $data[pavadinimas12] </td>
<td width='10%' class='tbl9' align='center'> <a href='$data[serialas12]' title='$data[pavadinimas12]' rel='shadowbox'><img src='".IMAGES."play_icon.png'></td>
</tr>";
}
if ($data['pavadinimas13'] == ''){
}else{
echo"<tr>
<td width='90%' class='tbl9'> $data[pavadinimas13] </td>
<td width='10%' class='tbl9' align='center'> <a href='$data[serialas13]' title='$data[pavadinimas13]' rel='shadowbox'><img src='".IMAGES."play_icon.png'></td>
</tr>";
}
if ($data['pavadinimas14'] == ''){
}else{
echo"<tr>
<td width='90%' class='tbl9'> $data[pavadinimas14] </td>
<td width='10%' class='tbl9' align='center'> <a href='$data[serialas14]' title='$data[pavadinimas14]' rel='shadowbox'><img src='".IMAGES."play_icon.png'></td>
</tr>";
}
if ($data['pavadinimas15'] == ''){
}else{
echo"<tr>
<td width='90%' class='tbl9'> $data[pavadinimas15] </td>
<td width='10%' class='tbl9' align='center'> <a href='$data[serialas15]' title='$data[pavadinimas15]' rel='shadowbox'><img src='".IMAGES."play_icon.png'></td>
</tr>";
}
if ($data['pavadinimas16'] == ''){
}else{
echo"<tr>
<td width='90%' class='tbl9'> $data[pavadinimas16] </td>
<td width='10%' class='tbl9' align='center'> <a href='$data[serialas16]' title='$data[pavadinimas16]' rel='shadowbox'><img src='".IMAGES."play_icon.png'></td>
</tr>";
}
if ($data['pavadinimas17'] == ''){
}else{
echo"<tr>
<td width='90%' class='tbl9'> $data[pavadinimas17] </td>
<td width='10%' class='tbl9' align='center'> <a href='$data[serialas17]' title='$data[pavadinimas17]' rel='shadowbox'><img src='".IMAGES."play_icon.png'></td>
</tr>";
}
if ($data['pavadinimas18'] == ''){
}else{
echo"<tr>
<td width='90%' class='tbl9'> $data[pavadinimas18] </td>
<td width='10%' class='tbl9' align='center'> <a href='$data[serialas18]' title='$data[pavadinimas18]' rel='shadowbox'><img src='".IMAGES."play_icon.png'></td>
</tr>";
}
if ($data['pavadinimas19'] == ''){
}else{
echo"<tr>
<td width='90%' class='tbl9'> $data[pavadinimas19] </td>
<td width='10%' class='tbl9' align='center'> <a href='$data[serialas19]' title='$data[pavadinimas19]' rel='shadowbox'><img src='".IMAGES."play_icon.png'></td>
</tr>";
}
if ($data['pavadinimas20'] == ''){
}else{
echo"<tr>
<td width='90%' class='tbl9'> $data[pavadinimas20] </td>
<td width='10%' class='tbl9' align='center'> <a href='$data[serialas20]' title='$data[pavadinimas20]' rel='shadowbox'><img src='".IMAGES."play_icon.png'></td>
</tr>";
}
if ($data['pavadinimas21'] == ''){
}else{
echo"<tr>
<td width='90%' class='tbl9'> $data[pavadinimas21] </td>
<td width='10%' class='tbl9' align='center'> <a href='$data[serialas21]' title='$data[pavadinimas21]' rel='shadowbox'><img src='".IMAGES."play_icon.png'></td>
</tr>";
}
if ($data['pavadinimas22'] == ''){
}else{
echo"<tr>
<td width='90%' class='tbl9'> $data[pavadinimas22] </td>
<td width='10%' class='tbl9' align='center'> <a href='$data[serialas22]' title='$data[pavadinimas22]' rel='shadowbox'><img src='".IMAGES."play_icon.png'></td>
</tr>";
}
if ($data['pavadinimas23'] == ''){
}else{
echo"<tr>
<td width='90%' class='tbl9'> $data[pavadinimas23] </td>
<td width='10%' class='tbl9' align='center'> <a href='$data[serialas23]' title='$data[pavadinimas23]' rel='shadowbox'><img src='".IMAGES."play_icon.png'></td>
</tr>";
}
if ($data['pavadinimas24'] == ''){
}else{
echo"<tr>
<td width='90%' class='tbl9'> $data[pavadinimas24] </td>
<td width='10%' class='tbl9' align='center'> <a href='$data[serialas24]' title='$data[pavadinimas24]' rel='shadowbox'><img src='".IMAGES."play_icon.png'></td>
</tr>";
}
if ($data['pavadinimas25'] == ''){
}else{
echo"<tr>
<td width='90%' class='tbl9'> $data[pavadinimas25] </td>
<td width='10%' class='tbl9' align='center'> <a href='$data[serialas25]' title='$data[pavadinimas25]' rel='shadowbox'><img src='".IMAGES."play_icon.png'></td>
</tr>";
}
if ($data['pavadinimas26'] == ''){
}else{
echo"<tr>
<td width='90%' class='tbl9'> $data[pavadinimas26] </td>
<td width='10%' class='tbl9' align='center'> <a href='$data[serialas26]' title='$data[pavadinimas26]' rel='shadowbox'><img src='".IMAGES."play_icon.png'></td>
</tr>";
}
if ($data['pavadinimas27'] == ''){
}else{
echo"<tr>
<td width='90%' class='tbl9'> $data[pavadinimas27] </td>
<td width='10%' class='tbl9' align='center'> <a href='$data[serialas27]' title='$data[pavadinimas27]' rel='shadowbox'><img src='".IMAGES."play_icon.png'></td>
</tr>";
}
if ($data['pavadinimas28'] == ''){
}else{
echo"<tr>
<td width='90%' class='tbl9'> $data[pavadinimas28] </td>
<td width='10%' class='tbl9' align='center'> <a href='$data[serialas28]' title='$data[pavadinimas28]' rel='shadowbox'><img src='".IMAGES."play_icon.png'></td>
</tr>";
}
if ($data['pavadinimas29'] == ''){
}else{
echo"<tr>
<td width='90%' class='tbl9'> $data[pavadinimas29] </td>
<td width='10%' class='tbl9' align='center'> <a href='$data[serialas29]' title='$data[pavadinimas29]' rel='shadowbox'><img src='".IMAGES."play_icon.png'></td>
</tr>";
}
if ($data['pavadinimas30'] == ''){
}else{
echo"<tr>
<td width='90%' class='tbl9'> $data[pavadinimas30] </td>
<td width='10%' class='tbl9' align='center'> <a href='$data[serialas30]' title='$data[pavadinimas30]' rel='shadowbox'><img src='".IMAGES."play_icon.png'></td>
</tr>";
}
if ($data['pavadinimas31'] == ''){
}else{
echo"<tr>
<td width='90%' class='tbl9'> $data[pavadinimas31] </td>
<td width='10%' class='tbl9' align='center'> <a href='$data[serialas31]' title='$data[pavadinimas31]' rel='shadowbox'><img src='".IMAGES."play_icon.png'></td>
</tr>";
}
if ($data['pavadinimas32'] == ''){
}else{
echo"<tr>
<td width='90%' class='tbl9'> $data[pavadinimas32] </td>
<td width='10%' class='tbl9' align='center'> <a href='$data[serialas31]' title='$data[pavadinimas32]' rel='shadowbox'><img src='".IMAGES."play_icon.png'></td>
</tr>";
}
if ($data['pavadinimas33'] == ''){
}else{
echo"<tr>
<td width='90%' class='tbl9'> $data[pavadinimas33] </td>
<td width='10%' class='tbl9' align='center'> <a href='$data[serialas33]' title='$data[pavadinimas33]' rel='shadowbox'><img src='".IMAGES."play_icon.png'></td>
</tr>";
}
if ($data['pavadinimas34'] == ''){
}else{
echo"<tr>
<td width='90%' class='tbl9'> $data[pavadinimas34] </td>
<td width='10%' class='tbl9' align='center'> <a href='$data[serialas34]' title='$data[pavadinimas34]' rel='shadowbox'><img src='".IMAGES."play_icon.png'></td>
</tr>";
}
if ($data['pavadinimas35'] == ''){
}else{
echo"<tr>
<td width='90%' class='tbl9'> $data[pavadinimas35] </td>
<td width='10%' class='tbl9' align='center'> <a href='$data[serialas35]' title='$data[pavadinimas35]' rel='shadowbox'><img src='".IMAGES."play_icon.png'></td>
</tr>";
}
if ($data['pavadinimas36'] == ''){
}else{
echo"<tr>
<td width='90%' class='tbl9'> $data[pavadinimas36] </td>
<td width='10%' class='tbl9' align='center'> <a href='$data[serialas36]' title='$data[pavadinimas36]' rel='shadowbox'><img src='".IMAGES."play_icon.png'></td>
</tr>";
}
if ($data['pavadinimas37'] == ''){
}else{
echo"<tr>
<td width='90%' class='tbl9'> $data[pavadinimas37] </td>
<td width='10%' class='tbl9' align='center'> <a href='$data[serialas37]' title='$data[pavadinimas37]' rel='shadowbox'><img src='".IMAGES."play_icon.png'></td>
</tr>";
}
if ($data['pavadinimas38'] == ''){
}else{
echo"<tr>
<td width='90%' class='tbl9'> $data[pavadinimas38] </td>
<td width='10%' class='tbl9' align='center'> <a href='$data[serialas38]' title='$data[pavadinimas38]' rel='shadowbox'><img src='".IMAGES."play_icon.png'></td>
</tr>";
}
if ($data['pavadinimas39'] == ''){
}else{
echo"<tr>
<td width='90%' class='tbl9'> $data[pavadinimas39] </td>
<td width='10%' class='tbl9' align='center'> <a href='$data[serialas39]' title='$data[pavadinimas39]' rel='shadowbox'><img src='".IMAGES."play_icon.png'></td>
</tr>";
}
if ($data['pavadinimas40'] == ''){
}else{
echo"<tr>
<td width='90%' class='tbl9'> $data[pavadinimas40] </td>
<td width='10%' class='tbl9' align='center'> <a href='$data[serialas40]' title='$data[pavadinimas40]' rel='shadowbox'><img src='".IMAGES."play_icon.png'></td>
</tr>";
}
if ($data['pavadinimas41'] == ''){
}else{
echo"<tr>
<td width='90%' class='tbl9'> $data[pavadinimas41] </td>
<td width='10%' class='tbl9' align='center'> <a href='$data[serialas41]' title='$data[pavadinimas41]' rel='shadowbox'><img src='".IMAGES."play_icon.png'></td>
</tr>";
}
if ($data['pavadinimas42'] == ''){
}else{
echo"<tr>
<td width='90%' class='tbl9'> $data[pavadinimas42] </td>
<td width='10%' class='tbl9' align='center'> <a href='$data[serialas42]' title='$data[pavadinimas42]' rel='shadowbox'><img src='".IMAGES."play_icon.png'></td>
</tr>";
}
echo"</table>";
closetable();
//$curlink = 'http://filmas.tt.lt';
//echo "<iframe src='http://www.facebook.com/plugins/like.php?href=".$curlink."&layout=standard&show_faces=true&width=450&action=like&font=tahoma&colorscheme=light&height=80' scrolling='no' frameborder='0' style='border:none; overflow:hidden; width:450px; height:80px;' allowTransparency='true'></iframe>";
//facebook komentaru pradzia
opentable("Facebook komentarai");
$curlink = 'http://filmas.tt.lt/';
$curlink .= $_SERVER['SERVER_NAME'].$_SERVER['REQUEST_URI'];
$curlink = urlencode($curlink);
echo "<table cellpadding='0' cellspacing='0' width='auto' class='center tbl-border'>\n<tr>\n";
echo "<td class='tbl2' colspan='2'><strong>Komentaras</strong></td>\n";
echo "</tr>\n<tr>\n";
echo "<td class='tbl1'>\n";
echo "<div id='fb-root'></div>
<script>
window.fbAsyncInit = function() {
FB.init({appId: '266587840018167', status: true, cookie: true,
xfbml: true});
};
(function() {
var e = document.createElement('script'); e.async = true;
e.src = document.location.protocol +
'//connect.facebook.net/lt_LT/all.js';
document.getElementById('fb-root').appendChild(e);
}());
</script>\n";
echo "<fb:comments xid='266587840018167' href='".$curlink."' numposts='5' width='auto' publish_feed='false' migrated='1'></fb:comments>\n";
echo "</td></tr>\n</table>\n";
closetable();
//facebook komentaru pabaiga
showcomments("F", DB_FILMAI, "filmai_id", $_GET['filmas_id'], INFUSIONS."filmai_panel/filmai.php?filmas_id=".$data['filmai_id']);
} else {
opentable("klaida"); echo "<center>nera tokio filmo</center>"; 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 = 5;
echo"<table cellpadding='0' cellspacing='0' width='100%' style='padding:1px;' >\n<tr>\n";
while($data = dbarray($result)) {
if ($counter != 0 && ($counter % $columns == 0)) { echo "</tr>\n<tr>\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']));
$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ų k.</font></b> $img";
}elseif($data['filmai_kalba'] == 1){
$filmai_kalba = "<b><font color=#ff7a7a>Rusų k.</font></b> $img1";
}if($data['filmai_kalba'] == 2){
$filmai_kalba = "<b><font color=#00a9ff>Anglų k.</font></b> $img2";
}if($data['filmai_kalba'] == 3){
$filmai_kalba = "<b><font color=green>Lietuvių sub.</font></b> $img";
}
echo"<td style='padding:5px;'>";
echo "<table cellpadding='0' cellspacing='0' width='160' >\n<tr>\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 "<table cellpadding='0' cellspacing='1' width='170' class='borderis' onmouseover=\"className='borderis2'\" onmouseout=\"className='borderis'\">\n<tr>\n";
echo"<td colspan='2' align='center'>
<a href='filmai.php?filmas_id=".$data['filmai_id']."'><img src='".$data['filmai_img']."' width='170' height='260' class='tipper' title='DOM:tip".$data['filmai_id']."' /></a>
<div id='tip".$data['filmai_id']."' style='visibility: hidden;position: absolute'><b><span style=color:#ff9709;font-size:13px;>".$data['filmai_pav']."</span></b><br /><br /><b>Režisierius</b>: ".$data['filmai_rezisierius']."<br /><b>Aktoriai</b>: ".$data['filmai_aktoriai']."<br /><b>Premjera</b>: ".$data['filmai_metai']."<br /><b>Žanras</b>: ".$kategorijos."<br /><b>Įgarsinimas</b>: $filmai_kalba<br /><b>Trukmė</b>: ".$data['filmai_trukme']."<br /><br /><b>Aprašymas</b>: ".trump($tas,100)."</div>
</td>";
echo"</tr>
<td style='padding:2px;'><img src='".INFUSIONS."filmai_panel/img/".$reitas.".png' width='68' height='13' style='vertical-align:middle;' title='".round($reitingas,2)."' />";
if ($data['filmai_trailler'] != "") {
echo "<img onclick=\"TINY.box.show({url:'".INFUSIONS."filmai_panel/trailler.php?filmas_id=".$data['filmai_id']."',boxid:'dezute',maskid:'patamsejimas',})\" src='".INFUSIONS."filmai_panel/img/youtube.gif' width='30' height='12' style='vertical-align:middle;cursorointer' title='Trailer' />";
}
echo "</td><td class='c' align='right'><a href='filmai.php?filmas_id=".$data['filmai_id']."'>Žiūrėti</a></td>
</tr>";
echo"</table>";
echo "</td>\n" ;
$counter++;
}
echo "</tr>\n</table>\n";
if ($rows > $items_per_page) echo "<div align='center' style=';margin-top:5px;'>\n".makepagenav($_GET['rowstart'],$items_per_page,$rows,3)."\n</div>\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 = 5;
echo"<table cellpadding='0' cellspacing='0' width='100%' style='padding:5px;' >\n<tr>\n";
while($data = dbarray($result)) {
if ($counter != 0 && ($counter % $columns == 0)) { echo "</tr>\n<tr>\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"<td style='padding:5px;'>";
echo "<table cellpadding='0' cellspacing='0' width='160' >\n<tr>\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'].",";
}
}
$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ų k.</font></b> $img";
}elseif($data['filmai_kalba'] == 1){
$filmai_kalba = "<b><font color=#ff7a7a>Rusų k.</font></b> $img1";
}if($data['filmai_kalba'] == 2){
$filmai_kalba = "<b><font color=#00a9ff>Anglų k.</font></b> $img2";
}if($data['filmai_kalba'] == 3){
$filmai_kalba = "<b><font color=green>Lietuvių sub.</font></b> $img";
}
$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 "<table cellpadding='0' cellspacing='1' width='170' class='borderis' onmouseover=\"className='borderis2'\" onmouseout=\"className='borderis'\">\n<tr>\n";
echo"<td colspan='2' align='center'>
<a href='filmai.php?filmas_id=".$data['filmai_id']."'><img src='".$data['filmai_img']."' width='170' height='260' class='tipper' title='DOM:tip".$data['filmai_id']."' /></a>
<div id='tip".$data['filmai_id']."' style='visibility: hidden;position: absolute'><b><span style=color:#ff9709;font-size:13px;>".$data['filmai_pav']."</span></b><br /><br /><b>Režisierius</b>: ".$data['filmai_rezisierius']."<br /><b>Aktoriai</b>: ".$data['filmai_aktoriai']."<br /><b>Premjera</b>: ".$data['filmai_metai']."<br /><b>Žanras</b>: ".$kategorijos."<br /><b>Įgarsinimas</b>: $filmai_kalba<br /><b>Trukmė</b>: ".$data['filmai_trukme']."<br /><br /><b>Apie filmą</b>:<br /> ".trump($tas,100)."</div>
</td>";
echo"</tr>
<td width='105' style='padding:2px;'><img src='".INFUSIONS."filmai_panel/img/".$reitas.".png' width='68' height='13' style='vertical-align:middle;' title='".round($reitingas,2)."' /></td>
<td class='c' align='right'><a href='filmai.php?filmas_id=".$data['filmai_id']."'>Žiūrėti</a></td>
</tr>";
echo"</table>";
echo "</td>\n" ;
$counter++;
}
echo "</tr>\n</table>\n";
if ($rows > $items_per_page) echo "<div align='center' style=';margin-top:5px;'>\n".makepagenav($_GET['rowstart'],$items_per_page,$rows,3,FUSION_SELF."?kat_id=".$kddata['filmai_kat_id']."&")."\n</div>\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 "<table cellpadding='0' cellspacing='0' width='100%' style='padding:5px;'><tr>";
while($data = dbarray($result)) {
$tas = nl2br(stripslashes($data['filmai_apr']));
echo "<td><table cellpadding='0' cellspacing='0' width='140' >\n<tr>\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"<td colspan='3' align='center'>
<a href='filmai.php?filmas_id=".$data['filmai_id']."'><img src='".$data['filmai_img']."' width='170' height='260' class='tipper' title='DOM:tip".$data['filmai_id']."' /></a>
<div id='tip".$data['filmai_id']."' style='visibility: hidden;position: absolute'><b><span style=color:#ff9709;font-size:13px;>".$data['filmai_pav']."</span></b><br /><br /><b>Režisierius</b>: ".$data['filmai_rezisierius']."<br /><b>Aktoriai</b>: ".$data['filmai_aktoriai']."<br /><b>Premjera</b>: ".$data['filmai_metai']."<br /><b>Žanras</b>: ".$kategorijos."<br /><b>Įgarsinimas</b>: $filmai_kalba<br /><b>Trukmė</b>: ".$data['filmai_trukme']."<br /><br /><b>Apie filmą</b>:<br /> ".trump($tas,100)."</div>
</td>";
echo"</tr>
<td align='left'>".round($data['topas'],2)." ";
if ($data['filmai_trailler'] != "") {
echo "<img onclick=\"TINY.box.show({url:'".INFUSIONS."filmai_panel/trailler.php?filmas_id=".$data['filmai_id']."',boxid:'dezute',maskid:'patamsejimas',})\" src='".INFUSIONS."filmai_panel/img/youtube.gif' width='30' height='12' style='vertical-align:middle;cursorointer' title='Trailer' />";
}
echo "</td><td class='c' align='right'><a href='filmai.php?filmas_id=".$data['filmai_id']."'>Žiūrėti</a></td>
</tr>";
echo"</table></td>";
}
echo "</tr></table>";
closetable();
}
}
echo "<script type=\"text/javascript\">
var theTips = new TipsX3 ($$('.tipper'), {showDelay: 0});
</script>";
require_once THEMES."templates/footer.php";
?>
|