rendered paste body<?php#if(!defined("accessed")) die("No direct acces..");# Funktsioon lugeda filme databaasis.function count_filmid() { $q = @mysql_query("SELECT COUNT(filmi_id) FROM filmid"); $a = @mysql_fetch_row($q); return !empty($a[0]) ? $a[0] : "0";}function count_($s) {if($s == 1) $q = @mysql_query("SELECT COUNT(id) FROM seriaalid"); elseif($s == 2) $q = @mysql_query("SELECT COUNT(id) FROM naitlejad"); else $q = @mysql_query("SELECT COUNT(id) FROM lavastajad"); $a = @mysql_fetch_row($q); return !empty($a[0]) ? $a[0] : "0";}function get_all_into_string($id) { $q = @mysql_query("SELECT * FROM filmid WHERE filmi_id = $id"); while($info = mysql_fetch_assoc($q)) { $rea .= "<div style='font-size: 12px; font-family: Geneva, Arial, Helvetica, sans-serif;'>"; $rea .= ($info['filmi_pildiaadress'] == 'puudub') ? "<img src='img/puudub.jpg' alt='Pilt puudub!' style='height: 120px; width: 90px'>" : "<img src='".$info['filmi_pildiaadress']."' alt='Filmi pilt!' style='width:90px; height:120px'>"; $rea .= "<div style='font-size: 19px; font-weight:900'>".$info['filmi_nimi']."</div>"; $rea .= "<div>".(!empty($info['filmi_ing_nimi']) ? $info['filmi_ing_nimi'] : "ingliskeelne nimi puudub")."</div>"; $rea .= "<b>Zanr:</b> ".$info['filmi_zanr']; $rea .= "<div><hr style='border: 0; color: #043; background-color: #043; width:210px; height:1px; text-align: left; margin: 2px 0;'></div>"; $rea .= "<b>Aasta:</b> ".$info['filmi_aasta']; $rea .= "<div><hr style='border: 0; color: #043; background-color: #043; width:210px; height:1px; text-align: left; margin: 2px 0;'></div>"; $rea .= "<b>Lavastaja:</b> ".$info['filmi_lavastaja']; $rea .= "<div><hr style='border: 0; color: #043; background-color: #043; width:210px; height:1px; text-align: left; margin: 2px 0;'></div>"; $rea .= "<b>Stuudio:</b> ".$info['filmi_stuudio']; $rea .= "<div><hr style='border: 0; color: #043; background-color: #043; width:210px; height:1px; text-align: left; margin: 2px 0;'></div>"; $rea .= "<b>Näitlejad:</b> <br />"; $rea .= $info['filmi_naitlejad']; $rea .= "<div><hr style='border: 0; color: #043; background-color: #043; width:210px; height:1px; text-align: left; margin: 2px 0;'></div>"; $rea .= "<b>Lingid:</b> <br />"; $rea .= $info['filmi_lingid']; $rea .= "<div><hr style='border: 0; color: #043; background-color: #043; width:210px; height:1px; text-align: left; margin: 2px 0;'></div>"; $rea .= "<b>Lühikirjeldus:</b> <br />"; $rea .= $info['filmi_lyhikirjeldus']; $rea .= "<div><hr style='border: 0; color: #043; background-color: #043; width:210px; height:1px; text-align: left; margin: 2px 0;'></div>"; // hinnangu süsteem $rea .="<div style='font-size:17px; font-weight: 900;'>Filmi hinnang: </div>"; $rea .="<div style='font-size:13px'>".hinnang($id,$info['filmi_hinnang'])."</div>"; $rea .= "<hr style='border: 0; color: black; background-color: black; width:210px; height:1px; text-align: left; margin: 3px 0;'>"; $rea .= "</div>"; } return $rea;}function search_seriaalid($nimi) { $q = @mysql_query("SELECT nimi,id FROM seriaalid WHERE nimi LIKE '%".$nimi."%'"); while($i = mysql_fetch_assoc($q)) { $output .= "<div class='AH'><a href='#' onClick='win3(".$i['id'].")'>".$i['nimi']."[seriaal]</a></div>"; } return (strlen($output) > 0) ? $output : "";}function search_lavastajad($nimi) { $q = @mysql_query("SELECT id,nimi FROM lavastajad WHERE nimi LIKE '%".$nimi."%'"); while($i = mysql_fetch_assoc($q)) { $output .= "<div class='AH'><a href='#' onClick='win1(".$i['id'].")'>".$i['nimi']."[Lavastaja]</a></div>"; } return (strlen($output) > 0) ? $output : "";}function search_naitlejad($nimi) { $q = @mysql_query("SELECT id,nimi FROM naitlejad WHERE nimi LIKE '%".$nimi."%'"); while($i = mysql_fetch_assoc($q)) { $output .= "<div class='AH'><a href='#' onClick='win1(".$i['naitlejad'].")'>".$i['nimi']."[Naitleja]</a></div>"; } return (strlen($output) > 0) ? $output : "";}function search_films($nimi) { $q = @mysql_query("SELECT filmi_id,filmi_nimi FROM filmid WHERE filmi_nimi LIKE '%".$nimi."%'"); while($i = mysql_fetch_assoc($q)) { $output .= "<div class='AH'><a href='#' onClick='win1(".$i['filmi_id'].")'>".$i['filmi_nimi']."[Film]</a></div>"; } return (strlen($output) > 0) ? $output : "";} function top10() {$a = mysql_query("select filmi_hinnang,filmi_nimi,filmi_id from filmid order by filmi_hinnang desc limit 5");$o = 1;while($i = mysql_fetch_assoc($a)) {$output .= "<div class='loe'><a href='#' onClick='win1(".$i['filmi_id'].")'>» ".$i['filmi_nimi']." (".$i['filmi_hinnang'].")</a></div>";$o++;}return $output;}function last_added() {$a = mysql_query("select filmi_nimi,filmi_id from filmid order by filmi_lisamisaeg desc limit 5");$o = 1;while($i = mysql_fetch_assoc($a)) {$output .= "<div class='loe'><a href='#' onClick='win1(".$i['filmi_id'].")' class='loe'>» ".$i['filmi_nimi']."</a></div>";$o++;}return $output;}function hinnang($ID,$hetkeline) { switch($hetkeline) { default: if($_GET['hinnang'] == 'lisatud' AND $_COOKIE[$ID] != "1") { setcookie($ID, "1", time()-36000000000000); @mysql_query("UPDATE filmid SET filmi_hinnang = '".($hetkeline+1)."' where filmi_id = $ID"); } if($_GET['hinnang'] == 'removed' AND $_COOKIE[$ID] != "1") { setcookie($ID, "1", time()-360000000000000); @mysql_query("UPDATE filmid SET filmi_hinnang = '".($hetkeline-1)."' WHERE filmi_id = $ID"); } $a = mysql_query("SELECT filmi_hinnang FROM filmid WHERE filmi_id = $ID"); $i = mysql_fetch_row($a); $output .= "<div><div><b>Filmil hetkel hääli: $i[0]</b></div></div>"; if($i[0] > 0) { $output .= "<div>"; for($s = 0; $s < $i[0]; $s++) { $output .= "<img src='img/furl.gif' alt='Hinnang'>"; } $output .= "</div>"; } if($_COOKIE[$ID] == "1") $output .= "<div style='color: red; font-weight: 900; font-size: 13px;'>Olete juba hääletanud, uuesti hääletamine on keelatud.</div>"; else $output .= "<div><a href='vaata.php?id=$ID&hinnang=lisatud' style='AH'>Lisa punkt</a> | <a href='vaata.php?id=$ID&hinnang=removed' style='AH'>Eemalda punkt</a></div>"; } return $output;}function get_uudis($ID) {$a = mysql_query("SELECT sisu,pealkiri,lisamisaeg,pilt,ID FROM uudised where ID=$ID");while($i = mysql_fetch_assoc($a)) {$pilt = (!empty($i['pilt']) ? "<img src='".$i['pilt']."' class='new' alt='pilt'>" : "<img src='img/puudub.jpg' class='new' alt='wtf'>");$out .= "<div>$pilt</div>";$out .= "<div>Te loete uudist #$ID</div>";$out .= "<div style='font-size: 15px; font-weight:900'>".$i['pealkiri']."</div>";$out .= "<div>".$i['sisu']."</div>";$out .= "<div><div><b>lisatud: ".$i['lisamisaeg']."</b></div></div";}return $out;}function buffer_uudised() {$a = mysql_query("SELECT sisu,pealkiri,lisamisaeg,pilt,id FROM uudised ORDER by pealkiri DESC");while($i = mysql_fetch_assoc($a)) {$pilt = (!empty($i['pilt']) ? "<img src='".$i['pilt']."' class='new' alt='uudise pilt'>" : "<img src='img/puudub.jpg' alt='uudise pilt' class='new'>");$uudis .= '<div class="news_ar"> <div style="font-weight: 900; font-size: 12px; color: #000000; " class="loe">'.$i['pealkiri'].'| <a href="#" onClick="win2('.$i['id'].')">loe edasi..</a></div></div>';}return $uudis;}function uudis() {$a = mysql_query("SELECT sisu,pealkiri,lisamisaeg,pilt,id FROM uudised ORDER by lisamisaeg DESC limit 3");while($i = mysql_fetch_assoc($a)) {$pilt = (!empty($i['pilt']) ? "<img src='".$i['pilt']."' class='new' alt='tore pilt'>" : "<img src='img/puudub.jpg' class='new' alt='uudise pilt'>");$uudis .= '<div class="news_ar" style="margin-top: 1px;"> <div style="font-weight: 900; font-size: 14px; color: #000000;">'.$i['pealkiri'].'</div> '.$pilt.' <div class="sisu">'.substr($i['sisu'],0,100).'....</div> <div class="AH" style="clear: left"><a href="#" onClick="win2('.$i['id'].')">loe edasi..</a></div> </div>';}return $uudis;}function imdb() {$a = file_get_contents("imdb.txt");if(strlen($a) < 5) return "Kahjuks ei leitud midagi..";return $a;}function buffer_films($qi) { $ad = " WHERE filmi_nimi LIKE '".$qi."%'"; $addon = ($qi == "ALL" ? "" : $ad); if($addon == "" AND $qi == "0") $addon = " REGEXP '^[0-9].*$'"; $q = @mysql_query("SELECT filmi_nimi,filmi_id FROM filmid $addon ORDER BY filmi_nimi DESC"); while($i = mysql_fetch_assoc($q)) { $output .= "<div class='AH'><a href='#' onClick='win1(".$i['filmi_id'].")'>".$i["filmi_nimi"]."</a></div>"; } return (strlen($output) > 0) ? $output : "<div>filmid databaasis puuduvad!</div>";}function admin_films($io) {if($io == 1) $q = @mysql_query("SELECT filmi_nimi,filmi_id FROM filmid"); elseif($io == 3) $q = @mysql_query("SELECT nimi,id FROM seriaalid"); else $q = @mysql_query("SELECT pealkiri,id FROM uudised"); if($io == 1) { $output .= ' <script type="text/javascript"> function win1(name) { window.open("kustuta_film.php?id="+name,"","menubar=no,width=460,height=10,toolbar=no"); } function win2(name) { window.open("muuda_film.php?id="+name,"","menubar=no,width=460,height=800,toolbar=no"); } </script> '; } elseif($io == 3) { $output .= ' <script type="text/javascript"> function win1(name) { window.open("kustuta_seriaal.php?id="+name,"","menubar=no,width=460,height=10,toolbar=no"); } function win2(name) { window.open("muuda_seriaal.php?id="+name,"","menubar=no,width=460,height=800,toolbar=no"); } </script> '; } else { $output .= ' <script type="text/javascript"> function win1(name) { window.open("kustuta_uudis.php?id="+name,"","menubar=no,width=460,height=10,toolbar=no"); } function win2(name) { window.open("muuda_uudis.php?id="+name,"","menubar=no,width=460,height=300,toolbar=no"); } </script> '; } if($io == 1) { while($i = mysql_fetch_assoc($q)) { $output .= "<div class='AH'>".$i["filmi_nimi"]." [ <a href='#' onClick='win1(".$i['filmi_id'].")'> Kustuta </a> || <a href='#' onClick='win2(".$i['filmi_id'].")'> Muuda </a> ]</div>";} } elseif($io == 3) { while($i = mysql_fetch_assoc($q)) { $output .= "<div class='AH'>".$i["nimi"]." [ <a href='#' onClick='win1(".$i['id'].")'> Kustuta </a> || <a href='#' onClick='win2(".$i['id'].")'> Muuda </a> ]</div>"; } } else { while($i = mysql_fetch_assoc($q)) { $output .= "<div class='AH'>".$i["pealkiri"]." [ <a href='#' onClick='win1(".$i['id'].")'> Kustuta </a> || <a href='#' onClick='win2(".$i['id'].")'> Muuda </a> ]</div>"; } } return (strlen($output) > 0) ? $output : "<div>uudised databaasis puuduvad!</div>";}// Seriialidfunction get_seriaal($id) { $q = @mysql_query("SELECT * FROM seriaalid WHERE id = $id"); while($info = mysql_fetch_assoc($q)) { $rea .= "<div style='font-size: 12px; font-family: Geneva, Arial, Helvetica, sans-serif;'>"; $rea .= (empty($info['pilt']) || $info['pilt'] == " " ? "<img src='img/puudub.jpg' alt='Pilt puudub!' style='height: 120px; width: 90px'>" : "<img src='".$info['filmi_pildiaadress']."' alt='Filmi pilt!' style='width:90px; height:120px'>"); $rea .= "<div style='font-size: 19px; font-weight:900'>".$info['nimi']."</div>"; $rea .= "<div><hr style='border: 0; color: #043; background-color: #043; width:210px; height:1px; text-align: left; margin: 2px 0;'></div>"; $rea .= "<b>Aasta:</b> ".$info['aastad']; $rea .= "<div><hr style='border: 0; color: #043; background-color: #043; width:210px; height:1px; text-align: left; margin: 2px 0;'></div>"; $rea .= "<b>Osa pikkus:</b> ".$info['osa_pikkus']; $rea .= "<div><hr style='border: 0; color: #043; background-color: #043; width:210px; height:1px; text-align: left; margin: 2px 0;'></div>"; $rea .= "<b>Lingid:</b> <br />"; $rea .= $info['lingid']; $rea .= "<div><hr style='border: 0; color: #043; background-color: #043; width:210px; height:1px; text-align: left; margin: 2px 0;'></div>"; $rea .= "<b>Näitlejad:</b> <br />"; $rea .= $info['naitlejad']; $rea .= "<div><hr style='border: 0; color: #043; background-color: #043; width:210px; height:1px; text-align: left; margin: 2px 0;'></div>"; $rea .= "<b>Lühikirjeldus:</b> <br />"; $rea .= $info['seriaali_kokkuvote']; $rea .= "<div><hr style='border: 0; color: #043; background-color: #043; width:210px; height:1px; text-align: left; margin: 2px 0;'></div>"; } return $rea;}function get_lavastaja($id) { $q = @mysql_query("SELECT * FROM lavastajad WHERE id = $id"); while($info = mysql_fetch_assoc($q)) { $rea .= "<div style='font-size: 12px; font-family: Geneva, Arial, Helvetica, sans-serif;'>"; $rea .= ($info['pilt'] == '') ? "<img src='img/puudub.jpg' alt='Pilt puudub!' style='height: 120px; width: 90px'>" : "<img src='".$info['filmi_pildiaadress']."' alt='Filmi pilt!' style='width:90px; height:120px'>"; $rea .= "<div style='font-size: 19px; font-weight:900'>".$info['nimi']."</div>"; $rea .= "<div><hr style='border: 0; color: #043; background-color: #043; width:210px; height:1px; text-align: left; margin: 2px 0;'></div>"; $rea .= "<b>Sündis:</b> ".$info['synd']; $rea .= "<div><hr style='border: 0; color: #043; background-color: #043; width:210px; height:1px; text-align: left; margin: 2px 0;'></div>"; $rea .= "<b>Elulugu:</b> <br />"; $rea .= $info['elulugu']; $rea .= "<div><hr style='border: 0; color: #043; background-color: #043; width:210px; height:1px; text-align: left; margin: 2px 0;'></div>"; $rea .= "<b>lingid:</b> <br />"; $rea .= $info['lingid']; $rea .= "<div><hr style='border: 0; color: #043; background-color: #043; width:210px; height:1px; text-align: left; margin: 2px 0;'></div>"; $rea .= "<b>Kuulsamad filmid:</b> <br />"; $rea .= $info['kuulsamad_filmid']; $rea .= "<div><hr style='border: 0; color: #043; background-color: #043; width:210px; height:1px; text-align: left; margin: 2px 0;'></div>"; } return $rea;}function get_naitleja($id) { $q = @mysql_query("SELECT * FROM naitlejad WHERE id = $id"); while($info = mysql_fetch_assoc($q)) { $rea .= "<div style='font-size: 12px; font-family: Geneva, Arial, Helvetica, sans-serif;'>"; $rea .= ($info['pilt'] == '') ? "<img src='img/puudub.jpg' alt='Pilt puudub!' style='height: 120px; width: 90px'>" : "<img src='".$info['filmi_pildiaadress']."' alt='Filmi pilt!' style='width:90px; height:120px'>"; $rea .= "<div style='font-size: 19px; font-weight:900'>".$info['nimi']."</div>"; $rea .= "<div><hr style='border: 0; color: #043; background-color: #043; width:210px; height:1px; text-align: left; margin: 2px 0;'></div>"; $rea .= "<b>Sündis:</b> ".$info['synd']; $rea .= "<div><hr style='border: 0; color: #043; background-color: #043; width:210px; height:1px; text-align: left; margin: 2px 0;'></div>"; $rea .= "<b>Elulugu:</b> <br />"; $rea .= $info['elulugu']; $rea .= "<div><hr style='border: 0; color: #043; background-color: #043; width:210px; height:1px; text-align: left; margin: 2px 0;'></div>"; $rea .= "<b>Kuulsamad filmid:</b> <br />"; $rea .= $info['rollid']; $rea .= "<div><hr style='border: 0; color: #043; background-color: #043; width:210px; height:1px; text-align: left; margin: 2px 0;'></div>"; $rea .= "<b>lingid:</b> <br />"; $rea .= $info['lingid']; $rea .= "<div><hr style='border: 0; color: #043; background-color: #043; width:210px; height:1px; text-align: left; margin: 2px 0;'></div>"; } return $rea;}function buffer_serialz($qi) { $ad = " WHERE nimi LIKE '".$qi."%'"; $addon = ($qi == "ALL" ? "" : $ad); if($addon == "" AND $qi == "0") $addon = " REGEXP '^[0-9].*$'"; $q = @mysql_query("SELECT nimi,id FROM seriaalid $addon ORDER BY nimi DESC"); while($i = mysql_fetch_assoc($q)) { $output .= "<div class='AH'><a href='#' onClick='win3(".$i['id'].")'>".$i["nimi"]."</a></div>"; } return (strlen($output) > 0) ? $output : "<div>seriaalid databaasis puuduvad!</div>";}function buffer_lavastajad($qi) { $ad = " WHERE nimi LIKE '".$qi."%'"; $addon = ($qi == "ALL" ? "" : $ad); if($addon == "" AND $qi == "0") $addon = " REGEXP '^[0-9].*$'"; $q = @mysql_query("SELECT nimi,id FROM lavastajad $addon ORDER BY nimi DESC"); while($i = mysql_fetch_assoc($q)) { $output .= "<div class='AH'><a href='#' onClick='win5(".$i['id'].")'>".$i["nimi"]."</a></div>"; } return (strlen($output) > 0) ? $output : "<div>Lavastajad databaasis puuduvad!</div>";}function buffer_naitlejad($qi) { $ad = " WHERE nimi LIKE '".$qi."%'"; $addon = ($qi == "ALL" ? "" : $ad); if($addon == "" AND $qi == "0") $addon = " REGEXP '^[0-9].*$'"; $q = @mysql_query("SELECT nimi,id FROM naitlejad $addon ORDER BY nimi DESC"); while($i = mysql_fetch_assoc($q)) { $output .= "<div class='AH'><a href='#' onClick='win4(".$i['id'].")'>".$i["nimi"]."</a></div>"; } return (strlen($output) > 0) ? $output : "<div>Näitlejad databaasis puuduvad!</div>";}?>