<?php
/*-------------------------------------------------------+
| PHP-Fusion Content Management System
| Copyright © 2002 - 2011 Nick Jones
| http://www.php-fusion.co.uk/
+--------------------------------------------------------+
| Filmu sistema
| file: filmai_admin.php
+--------------------------------------------------------+
| Sukure  WeberiZ
| El.pastas: gintaras321@inbox.lt
| 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&#353;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&#261;");
} 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&#261;");
}
$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'>&#302;garsinimas</td>\n";
echo "<td width='80%' class='tbl'><select size='1' name='filmai_kalba' style='width:250px;'>
<option selected value='0'>Lietuvi&#371; k.</option>
<option value='1'>Rus&#371; k.</option>
<option value='2'>Angl&#371; 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&#353;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&#353;yti' class='button' /></td>\n";
echo "</tr>\n</table>\n</form>\n";
closetable();

require_once THEMES."templates/footer.php";

?>