Apšylantis
Pranešimai: 56
Įstojo: 23.03.08
|
Man reikia ant šito biški pakeisto modo, kad būtų filmo pavadinimas užvedus pelyte ant filmo didesnis, o įgarsinimą rodytų ir įėjus į pilną filmo aprašymą t.y. kur žiūri filmą.
filmai_admin.php
 Kodas<?php
/*-------------------------------------------------------+
| PHP-Fusion Content Management System
| Copyright © 2002 - 2011 Nick Jones
| http://www.php-fu...
+--------------------------------------------------------+
| Filmu sistema
| file: filmai_admin.php
+--------------------------------------------------------+
| Sukure WeberiZ
| El.pastas:
| skype: weberiz
| web: http://weberiz.tt.lt
+--------------------------------------------------------*/
require_once "../../maincore.php";
require_once THEMES."templates/admin_header.php";
require_once INCLUDES."html_buttons_include.php";
if (!checkrights("FILM") || !defined("iAUTH") || $_GET['aid'] != iAUTH) { redirect("../../index.php"); }
if (!defined("DB_FILMAI")) { define("DB_FILMAI", DB_PREFIX."filmai"); }
if (!defined("DB_FILMAI_KAT")) { define("DB_FILMAI_KAT", DB_PREFIX."filmai_kat"); }
if (isset($_POST['delete'])) {
$result = dbquery("DELETE FROM ".DB_FILMAI." WHERE filmai_id='".$_POST['filmai_id']."'");
$result = dbquery("DELETE FROM ".DB_COMMENTS." WHERE comment_item_id='".$_POST['filmai_id']."' and comment_type='F'");
$result = dbquery("DELETE FROM ".DB_RATINGS." WHERE rating_item_id='".$_POST['filmai_id']."' and rating_type='F'");
echo "<div id='close-message'><div class='admin-message'>Filmas ištrintas</div></div>\n";
$_GET['action'] = "edlit";
$filmai_img = "";
$filmai_pav = "";
$filmai_apr = "";
$filmai_kodas = "";
$filmai_trailler = "";
$filmai_siustis = "";
$filmai_metai = "20";
$filmai_kalba = "";
$filmai_kat0 = "0";
$filmai_kat1 = "0";
$filmai_kat2 = "0";
$filmai_kat3 = "0";
$filmai_kat4 = "0";
$filmai_kat5 = "0";
$filmai_kat6 = "0";
$filmai_kat7 = "0";
$filmai_kat8 = "0";
$filmai_kat9 = "0";
}
if (isset($_POST['save'])) {
$filmai_img = stripinput($_POST['filmai_img']);
$filmai_pav = stripinput($_POST['filmai_pav']);
$filmai_apr = addslash($_POST['filmai_apr']);
$filmai_kodas = addslash($_POST['filmai_kodas']);
$filmai_trailler = addslash($_POST['filmai_trailler']);
$filmai_siustis = stripinput($_POST['filmai_siustis']);
$filmai_metai = stripinput($_POST['filmai_metai']);
$filmai_kalba = stripinput($_POST['filmai_kalba']);
$filmai_kat0 = isnum($_POST['filmai_kat0']) ? $_POST['filmai_kat0'] : "0";
$filmai_kat1 = isnum($_POST['filmai_kat1']) ? $_POST['filmai_kat1'] : "0";
$filmai_kat2 = isnum($_POST['filmai_kat2']) ? $_POST['filmai_kat2'] : "0";
$filmai_kat3 = isnum($_POST['filmai_kat3']) ? $_POST['filmai_kat3'] : "0";
$filmai_kat4 = isnum($_POST['filmai_kat4']) ? $_POST['filmai_kat4'] : "0";
$filmai_kat5 = isnum($_POST['filmai_kat5']) ? $_POST['filmai_kat5'] : "0";
$filmai_kat6 = isnum($_POST['filmai_kat6']) ? $_POST['filmai_kat6'] : "0";
$filmai_kat7 = isnum($_POST['filmai_kat7']) ? $_POST['filmai_kat7'] : "0";
$filmai_kat8 = isnum($_POST['filmai_kat8']) ? $_POST['filmai_kat8'] : "0";
$filmai_kat9 = isnum($_POST['filmai_kat9']) ? $_POST['filmai_kat9'] : "0";
if (isset($_POST['filmai_id']) && isnum($_POST['filmai_id'])) {
$result = dbquery("UPDATE ".DB_FILMAI." SET filmai_img='".$filmai_img."', filmai_pav='".$filmai_pav."', filmai_apr='".$filmai_apr."', filmai_kodas='".$filmai_kodas."', filmai_trailler='".$filmai_trailler."', filmai_siustis='".$filmai_siustis."', filmai_metai='".$filmai_metai."', filmai_kalba='".$filmai_kalba."', filmai_kat0='".$filmai_kat0."', filmai_kat1='".$filmai_kat1."', filmai_kat2='".$filmai_kat2."', filmai_kat3='".$filmai_kat3."', filmai_kat4='".$filmai_kat4."', filmai_kat5='".$filmai_kat5."', filmai_kat6='".$filmai_kat6."', filmai_kat7='".$filmai_kat7."', filmai_kat8='".$filmai_kat8."', filmai_kat9='".$filmai_kat9."' WHERE filmai_id='".$_POST['filmai_id']."'");
echo "<div id='close-message'><div class='admin-message'>Filmas atnaujintas</div></div>\n";
} else {
$result = dbquery("INSERT INTO ".DB_FILMAI." (filmai_img, filmai_pav, filmai_apr, filmai_kodas, filmai_trailler, filmai_siustis, filmai_metai, filmai_kalba, filmai_kat0, filmai_kat1, filmai_kat2, filmai_kat3, filmai_kat4, filmai_kat5, filmai_kat6, filmai_kat7, filmai_kat8, filmai_kat9, filmai_date) VALUES ('$filmai_img', '$filmai_pav', '$filmai_apr', '$filmai_kodas', '$filmai_trailler', '$filmai_siustis', '$filmai_metai', '$filmai_kalba', '$filmai_kat0', '$filmai_kat1', '$filmai_kat2', '$filmai_kat3', '$filmai_kat4', '$filmai_kat5', '$filmai_kat6', '$filmai_kat7', '$filmai_kat8', '$filmai_kat9', '".time()."')");
echo "<div id='close-message'><div class='admin-message'>Filmas pridėtas</div></div>\n";
}
}
if (1==1) {
}
$result = dbquery("SELECT filmai_id, filmai_pav FROM ".DB_FILMAI." ORDER BY filmai_date DESC");
if (dbrows($result) != 0) {
$editlist = ""; $sel = "";
while ($data = dbarray($result)) {
if ((isset($_POST['filmai_id']) && isnum($_POST['filmai_id'])) || (isset($_GET['filmai_id']) && isnum($_GET['filmai_id']))) {
$filmai_id = isset($_POST['filmai_id']) ? $_POST['filmai_id'] : $_GET['filmai_id'];
$sel = ($filmai_id == $data['filmai_id'] ? " selected='selected'" : "");
}
$editlist .= "<option value='".$data['filmai_id']."'$sel>".$data['filmai_pav']."</option>\n";
}
opentable("Esami filmai");
echo "<div style='text-align:center'>\n<form name='selectform' method='post' action='".FUSION_SELF.$aidlink."&action=edit'>\n";
echo "<select name='filmai_id' class='textbox' style='width:250px'>\n".$editlist."</select>\n";
echo "<input type='submit' name='edit' value='Redaguoti' class='button' />\n";
echo "<input type='submit' name='delete' value='Trinti' class='button' />\n";
echo "</form>\n</div>\n";
closetable();
}
if ((isset($_GET['action']) && $_GET['action'] == "edit") && (isset($_POST['filmai_id']) && isnum($_POST['filmai_id'])) || (isset($_GET['filmai_id']) && isnum($_GET['filmai_id']))) {
$result = dbquery("SELECT * FROM ".DB_FILMAI." WHERE filmai_id='".(isset($_POST['filmai_id']) ? $_POST['filmai_id'] : $_GET['filmai_id'])."' LIMIT 1");
if (dbrows($result)) {
$data = dbarray($result);
$filmai_img = $data['filmai_img'];
$filmai_pav = $data['filmai_pav'];
$filmai_apr = phpentities(stripslashes($data['filmai_apr']));
$filmai_kodas = phpentities(stripslashes($data['filmai_kodas']));
$filmai_trailler = phpentities(stripslashes($data['filmai_trailler']));
$filmai_siustis = $data['filmai_siustis'];
$filmai_metai = $data['filmai_metai'];
$filmai_kalba = $data['filmai_kalba'];
$filmai_kat0 = $data['filmai_kat0'];
$filmai_kat1 = $data['filmai_kat1'];
$filmai_kat2 = $data['filmai_kat2'];
$filmai_kat3 = $data['filmai_kat3'];
$filmai_kat4 = $data['filmai_kat4'];
$filmai_kat5 = $data['filmai_kat5'];
$filmai_kat6 = $data['filmai_kat6'];
$filmai_kat7 = $data['filmai_kat7'];
$filmai_kat8 = $data['filmai_kat8'];
$filmai_kat9 = $data['filmai_kat9'];
} else {
redirect(FUSION_SELF.$aidlink);
}
}
if ((isset($_POST['filmai_id']) && isnum($_POST['filmai_id'])) || (isset($_GET['filmai_id']) && isnum($_GET['filmai_id']))) {
opentable("Redagiuoti filmą");
} else {
if (!isset($_POST['preview'])) {
$filmai_img = "";
$filmai_pav = "";
$filmai_apr = "";
$filmai_kodas = "";
$filmai_trailler = "";
$filmai_siustis = "";
$filmai_metai = "20";
$filmai_kalba = "";
$filmai_kat0 = "0";
$filmai_kat1 = "0";
$filmai_kat2 = "0";
$filmai_kat3 = "0";
$filmai_kat4 = "0";
$filmai_kat5 = "0";
$filmai_kat6 = "0";
$filmai_kat7 = "0";
$filmai_kat8 = "0";
$filmai_kat9 = "0";
}
opentable("Pridėti filmą");
}
$result = dbquery("SELECT filmai_kat_id, filmai_kat_pav FROM ".DB_FILMAI_KAT." ORDER BY filmai_kat_pav");
$filmai_kat_opts0 = ""; $sel = ""; $filmai_kat_opts1 = ""; $sel1 = "";
$filmai_kat_opts2 = ""; $sel2 = ""; $filmai_kat_opts3 = ""; $sel3 = "";
$filmai_kat_opts4 = ""; $sel4 = ""; $filmai_kat_opts5 = ""; $sel5 = "";
$filmai_kat_opts6 = ""; $sel6 = ""; $filmai_kat_opts7 = ""; $sel7 = "";
$filmai_kat_opts8 = ""; $sel8 = ""; $filmai_kat_opts9 = ""; $sel9 = "";
if (dbrows($result)) {
while ($data = dbarray($result)) {
if (isset($filmai_kat0)) $sel = ($filmai_kat0 == $data['filmai_kat_id'] ? " selected='selected'" : "");
$filmai_kat_opts0 .= "<option value='".$data['filmai_kat_id']."'$sel>".$data['filmai_kat_pav']."</option>\n";
if (isset($filmai_kat1)) $sel1 = ($filmai_kat1 == $data['filmai_kat_id'] ? " selected='selected'" : "");
$filmai_kat_opts1 .= "<option value='".$data['filmai_kat_id']."'$sel1>".$data['filmai_kat_pav']."</option>\n";
if (isset($filmai_kat2)) $sel2 = ($filmai_kat2 == $data['filmai_kat_id'] ? " selected='selected'" : "");
$filmai_kat_opts2 .= "<option value='".$data['filmai_kat_id']."'$sel2>".$data['filmai_kat_pav']."</option>\n";
if (isset($filmai_kat3)) $sel3 = ($filmai_kat3 == $data['filmai_kat_id'] ? " selected='selected'" : "");
$filmai_kat_opts3 .= "<option value='".$data['filmai_kat_id']."'$sel3>".$data['filmai_kat_pav']."</option>\n";
if (isset($filmai_kat4)) $sel4 = ($filmai_kat4 == $data['filmai_kat_id'] ? " selected='selected'" : "");
$filmai_kat_opts4 .= "<option value='".$data['filmai_kat_id']."'$sel4>".$data['filmai_kat_pav']."</option>\n";
if (isset($filmai_kat5)) $sel5 = ($filmai_kat5 == $data['filmai_kat_id'] ? " selected='selected'" : "");
$filmai_kat_opts5 .= "<option value='".$data['filmai_kat_id']."'$sel5>".$data['filmai_kat_pav']."</option>\n";
if (isset($filmai_kat6)) $sel6 = ($filmai_kat6 == $data['filmai_kat_id'] ? " selected='selected'" : "");
$filmai_kat_opts6 .= "<option value='".$data['filmai_kat_id']."'$sel6>".$data['filmai_kat_pav']."</option>\n";
if (isset($filmai_kat7)) $sel7 = ($filmai_kat7 == $data['filmai_kat_id'] ? " selected='selected'" : "");
$filmai_kat_opts7 .= "<option value='".$data['filmai_kat_id']."'$sel7>".$data['filmai_kat_pav']."</option>\n";
if (isset($filmai_kat8)) $sel8 = ($filmai_kat8 == $data['filmai_kat_id'] ? " selected='selected'" : "");
$filmai_kat_opts8 .= "<option value='".$data['filmai_kat_id']."'$sel8>".$data['filmai_kat_pav']."</option>\n";
if (isset($filmai_kat9)) $sel9 = ($filmai_kat9 == $data['filmai_kat_id'] ? " selected='selected'" : "");
$filmai_kat_opts9 .= "<option value='".$data['filmai_kat_id']."'$sel9>".$data['filmai_kat_pav']."</option>\n";
}
}
echo "<form name='inputform' method='post' action='".FUSION_SELF.$aidlink."' >\n";
echo "<table cellpadding='0' cellspacing='0' class='center'>\n<tr>\n";
echo "<td width='100' class='tbl'>Pavadinimas</td>\n";
echo "<td width='80%' class='tbl'><input type='text' name='filmai_pav' value='".$filmai_pav."' class='textbox' style='width: 250px' /></td>\n";
echo "</tr>\n<tr>\n";
echo "<td width='10%' class='tbl'>Kategorijos</td>\n";
echo "<td width='90%' class='tbl'>";
echo "<select name='filmai_kat0' class='textbox'><option value='0'>Pasirinkti</option>\n".$filmai_kat_opts0."</select>";
echo "<select name='filmai_kat1' class='textbox'><option value='0'>Pasirinkti</option>\n".$filmai_kat_opts1."</select>";
echo "<select name='filmai_kat2' class='textbox'><option value='0'>Pasirinkti</option>\n".$filmai_kat_opts2."</select>";
echo "<select name='filmai_kat3' class='textbox'><option value='0'>Pasirinkti</option>\n".$filmai_kat_opts3."</select>";
echo "<select name='filmai_kat4' class='textbox'><option value='0'>Pasirinkti</option>\n".$filmai_kat_opts4."</select>";
echo "</td></tr>\n<tr>\n";
echo "<td width='10%' class='tbl'></td>\n";
echo "<td width='90%' class='tbl'>";
echo "<select name='filmai_kat5' class='textbox'><option value='0'>Pasirinkti</option>\n".$filmai_kat_opts5."</select>";
echo "<select name='filmai_kat6' class='textbox'><option value='0'>Pasirinkti</option>\n".$filmai_kat_opts6."</select>";
echo "<select name='filmai_kat7' class='textbox'><option value='0'>Pasirinkti</option>\n".$filmai_kat_opts7."</select>";
echo "<select name='filmai_kat8' class='textbox'><option value='0'>Pasirinkti</option>\n".$filmai_kat_opts8."</select>";
echo "<select name='filmai_kat9' class='textbox'><option value='0'>Pasirinkti</option>\n".$filmai_kat_opts9."</select>";
echo "</td></tr>\n<tr>\n";
echo "<td width='100' class='tbl'>Paveikslelis</td>\n";
echo "<td width='80%' class='tbl'><input type='text' name='filmai_img' value='".$filmai_img."' class='textbox' style='width: 250px' /></td>\n";
echo "</tr>\n<tr>\n";
echo "<td width='100' class='tbl'>Siustis</td>\n";
echo "<td width='80%' class='tbl'><input type='text' name='filmai_siustis' value='".$filmai_siustis."' class='textbox' style='width: 250px' /></td>\n";
echo "</tr>\n<tr>\n";
echo "<td width='100' class='tbl'>Metai</td>\n";
echo "<td width='80%' class='tbl'><input type='text' name='filmai_metai' value='".$filmai_metai."' class='textbox' style='width: 250px' /></td>\n";
echo "</tr>\n<tr>\n";
echo "<td width='100' class='tbl'>Įgarsinimas</td>\n";
echo "<td width='80%' class='tbl'><select size='1' name='filmai_kalba' style='width:250px;'>
<option selected value='0'>Lietuvių k.</option>
<option value='1'>Rusų k.</option>
<option value='2'>Anglų k.</option>
<option value='3'>LT TITRAI</option>
</select>
</tr>\n<tr>\n";
echo "</tr>";
echo" <tr>\n";
echo "<td valign='top' width='100' class='tbl'>Aprašymas</td>\n";
echo "<td width='80%' class='tbl'><textarea name='filmai_apr' cols='95' rows='10' class='textbox' style='width:98%'>".$filmai_apr."</textarea></td>\n";
echo "</tr>\n";
echo "<tr>\n<td valign='top' width='100' class='tbl'>Kodas</td>\n";
echo "<td width='80%' class='tbl'><textarea name='filmai_kodas' cols='95' rows='10' class='textbox' style='width:98%'>".$filmai_kodas."</textarea></td>\n";
echo "</tr>\n";
echo "<tr>\n<td valign='top' width='100' class='tbl'>Trailer</td>\n";
echo "<td width='80%' class='tbl'><textarea name='filmai_trailler' cols='95' rows='10' class='textbox' style='width:98%'>".$filmai_trailler."</textarea></td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td align='center' colspan='2' class='tbl'><br />\n";
if ((isset($_POST['edit']) && (isset($_POST['filmai_id']) && isnum($_POST['filmai_id']))) || (isset($_GET['filmai_id']) && isnum($_GET['filmai_id']))) {
echo "<input type='hidden' name='filmai_id' value='".(isset($_POST['filmai_id']) ? $_POST['filmai_id'] : $_GET['filmai_id'])."' />\n";
}
echo "<input type='submit' name='save' value='Irašyti' class='button' /></td>\n";
echo "</tr>\n</table>\n</form>\n";
closetable();
require_once THEMES."templates/footer.php";
?>
filmai.php:
Kodas <?php
/*-------------------------------------------------------+
| PHP-Fusion Content Management System
| Copyright © 2002 - 2011 Nick Jones
| http://www.php-fu...
+--------------------------------------------------------+
| Filmu sistema
| file: filmai.php
+--------------------------------------------------------+
| Sukurė WeberiZ
| El.pastas:
| skype: weberiz
| web: http://weberiz.tt.lt
+--------------------------------------------------------*/
require_once "../../maincore.php";
require_once THEMES."templates/header.php";
require_once "funkcijos.php";
$items_per_page = 16;
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='".INFUSIONS."filmai_panel/filmai.php?kat_id=".$kdata['filmai_kat_id']."'>".$kdata['filmai_kat_pav']."</a>,";}
}
$kkk++;
}
$kategorijos = substr($kategorijo, 0, -1);
opentable($data['filmai_pav']." (".$data['filmai_metai'].")");
echo "<table cellpadding='0' cellspacing='0'><tr><td width='176' valign='top' align='center' style='padding: 0 5px;'>";
echo "<img src='".$data['filmai_img']."' width='176' height='290' />";
echo "</td><td valign='top' align='left' style='padding: 0 5px;'>";
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='cursor:pointer' >";
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='cursor:pointer' />";
}
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 "<b>Kategorijos</b>: ".$kategorijos."<br />";
echo "<b>Įgarsinimas</b>: $filmai_kalba<br />";
echo "<b>Aprašymas</b>:<br />";
echo nl2br(stripslashes($data['filmai_apr']));
echo "</td></tr>";
echo "</table>";
closetable();
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 = 4;
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']));
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);
$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";
}
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"<td colspan='2' align='center'>
<a href='".INFUSIONS."filmai_panel/filmai.php?filmas_id=".$data['filmai_id']."'><img src='".$data['filmai_img']."' width='160' height='245' class='tipper' title='DOM:tip".$data['filmai_id']."' /></a>
<div id='tip".$data['filmai_id']."' style='visibility: hidden;position: absolute'>".$data['filmai_pav']."<br /><br /><b>Kategorijos</b>: ".$kategorijos."<br /><b>Įgarsinimas</b>: $filmai_kalba<br /><b>Metai</b>: ".$data['filmai_metai']."<br /><br /><b>Apie filmą</b>:<br /> ".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;cursor:pointer' title='Trailer' />";
}
echo "</td><td class='c' align='right'><a href='".INFUSIONS."filmai_panel/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,4)."\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 = 4;
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'].",";
}
}
$kkk++;
}
$kategorijos = substr($kategorijo, 0, -1);
$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";
}
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"<td colspan='2' align='center'>
<a href='".INFUSIONS."filmai_panel/filmai.php?filmas_id=".$data['filmai_id']."'><img src='".$data['filmai_img']."' width='160' height='245' class='tipper' title='DOM:tip".$data['filmai_id']."' /></a>
<div id='tip".$data['filmai_id']."' style='visibility: hidden;position: absolute'>".$data['filmai_pav']."::<b>Kategorijos</b>: ".$kategorijos."<br /><b>Metai</b>: ".$data['filmai_metai']."<br />".trump($tas,1000)."</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='".INFUSIONS."filmai_panel/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,4,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='4' align='center'>
<a href='".INFUSIONS."filmai_panel/filmai.php?filmas_id=".$data['filmai_id']."'><img src='".$data['filmai_img']."' width='140' height='210' class='tipper' title='DOM:tip".$data['filmai_id']."' /></a>
<div id='tip".$data['filmai_id']."' style='visibility: hidden;position: absolute'>".$data['filmai_pav']."::<b>Kategorijos</b>: ".$kategorijos."<br /><b>Metai</b>: ".$data['filmai_metai']."<br />".trump($tas,1000)."</div>
</td>";
echo"</tr>
<td align='left'>".round($data['topas'],2)." ";
if ($data['filmai_trailler'] != "") {
echo "<td>       <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;cursor:pointer' title='Trailer' /></td>";
}
echo "</td><td class='c' align='right'><a href='".INFUSIONS."filmai_panel/filmai.php?filmas_id=".$data['filmai_id']."'>Žiūrėti</a>
</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";
?>
Redagavo Armin 2012-02-03 10:36 |
Moderatorius
Pranešimai: 950
Įstojo: 11.06.09
|
filmai.php
Kodas <?php
/*-------------------------------------------------------+
| PHP-Fusion Content Management System
| Copyright © 2002 - 2011 Nick Jones
| http://www.php-fu...
+--------------------------------------------------------+
| Filmu sistema
| file: filmai.php
+--------------------------------------------------------+
| Sukure WeberiZ
| El.pastas:
| skype: weberiz
| web: http://weberiz.tt.lt
+--------------------------------------------------------*/
require_once "../../maincore.php";
require_once THEMES."templates/header.php";
require_once "funkcijos.php";
$items_per_page = 16;
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='".INFUSIONS."filmai_panel/filmai.php?kat_id=".$kdata['filmai_kat_id']."'>".$kdata['filmai_kat_pav']."</a>,";}
}
$kkk++;
}
$kategorijos = substr($kategorijo, 0, -1);
$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";
}
opentable($data['filmai_pav']." (".$data['filmai_metai'].")");
echo "<table cellpadding='0' cellspacing='0'><tr><td width='176' valign='top' align='center' style='padding: 0 5px;'>";
echo "<img src='".$data['filmai_img']."' width='176' height='290' />";
echo "</td><td valign='top' align='left' style='padding: 0 5px;'>";
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='cursor:pointer' >";
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='cursor:pointer' />";
}
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 "<b>Kategorijos</b>: ".$kategorijos."<br />";
echo "<b>Įgarsinimas</b>: $filmai_kalba<br />";
echo "<b>Aprašymas</b>:<br />";
echo nl2br(stripslashes($data['filmai_apr']));
echo "</td></tr>";
echo "</table>";
closetable();
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 = 4;
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']));
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);
$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";
}
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"<td colspan='2' align='center'>
<a href='".INFUSIONS."filmai_panel/filmai.php?filmas_id=".$data['filmai_id']."'><img src='".$data['filmai_img']."' width='160' height='245' 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>Kategorijos</b>: ".$kategorijos."<br /><b>Įgarsinimas</b>: $filmai_kalba<br /><b>Metai</b>: ".$data['filmai_metai']."<br /><br /><b>Apie filmą</b>:<br /> ".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;cursor:pointer' title='Trailer' />";
}
echo "</td><td class='c' align='right'><a href='".INFUSIONS."filmai_panel/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,4)."\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 = 4;
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'].",";
}
}
$kkk++;
}
$kategorijos = substr($kategorijo, 0, -1);
$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";
}
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"<td colspan='2' align='center'>
<a href='".INFUSIONS."filmai_panel/filmai.php?filmas_id=".$data['filmai_id']."'><img src='".$data['filmai_img']."' width='160' height='245' class='tipper' title='DOM:tip".$data['filmai_id']."' /></a>
<div id='tip".$data['filmai_id']."' style='visibility: hidden;position: absolute'>".$data['filmai_pav']."::<b>Kategorijos</b>: ".$kategorijos."<br /><b>Metai</b>: ".$data['filmai_metai']."<br />".trump($tas,1000)."</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='".INFUSIONS."filmai_panel/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,4,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='4' align='center'>
<a href='".INFUSIONS."filmai_panel/filmai.php?filmas_id=".$data['filmai_id']."'><img src='".$data['filmai_img']."' width='140' height='210' class='tipper' title='DOM:tip".$data['filmai_id']."' /></a>
<div id='tip".$data['filmai_id']."' style='visibility: hidden;position: absolute'>".$data['filmai_pav']."::<b>Kategorijos</b>: ".$kategorijos."<br /><b>Metai</b>: ".$data['filmai_metai']."<br />".trump($tas,1000)."</div>
</td>";
echo"</tr>
<td align='left'>".round($data['topas'],2)." ";
if ($data['filmai_trailler'] != "") {
echo "<td>       <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;cursor:pointer' title='Trailer' /></td>";
}
echo "</td><td class='c' align='right'><a href='".INFUSIONS."filmai_panel/filmai.php?filmas_id=".$data['filmai_id']."'>Žiūrėti</a>
</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";
?>
Padėjau? tada įvertink ir parašyk komentarą mano profilyje :) |
ajaxuser_info_panel by...
Svečių: 7
Dekoju 
