<?
$smarty = new Smarty;
$smarty->debugging = false;
?>
<?

//##############################################################################
//Ezzel a függvénynle állítóm elõ az adatait a listázáshoz a filmnek
//$movie: adatbázisból jövõ adatok
//##############################################################################
function getMovieListData($movie,$pic, $ertekeles='')
{
global $database;
global $ajanlo;
global $_CMSVARS;

  if($movie){
		foreach ($movie as $key=>$ajanlo) {
			unset($data,$onetag);
		  $i++;
		  $data['id'] = $ajanlo->get("id");
			$data['title_hun'] = $ajanlo->get("title_hun");
			$data['origin'] = $ajanlo->get("origin");
			$data['birth'] = $ajanlo->get("birth");
			$data['tags'] = $ajanlo->get("tagek");
			foreach($data['tags'] as $key=>$tag)
			{
        $onetag=$tag[obj]->attribs;
        $data['tagsall'].=$onetag['name']." ";
        $data['tagsarray'][$onetag['id']]=$onetag['name'];
      }
			$data['tags']=$data['tagsall'];      
			foreach($ajanlo->get("mufajok") as $key=>$mufaj)
			{
        $data['mufajok'].=$mufaj." ";
      }			

			if($pic=='1')
			{
			 $ret="";
        if (is_file("common/images/movies/".ceil($data['id']/1000).'/'.$data['id']."/mains.jpg")) {
			 	 $ret = "common/images/movies/".ceil($data['id']/1000).'/'.$data['id']."/mains.jpg";
        } else {
				  $ret = "common/images/movies/blank.jpg";
			 }      	
			 $data['pic'] = $_CMSVARS['urlroot']."/".$ret;
			}else{
        $data['pic'] = $_CMSVARS['urlroot']."/".$ajanlo->get("pic");
      }
			$data['origins'] = $ajanlo->get("orig_lang_");
			$data['description_hun'] = $ajanlo->get("description_hun");
			$data['plot_hun'] = $ajanlo->get("plot_hun");
			if(!$ertekeles)
			{
  		  $q="SELECT SUM(general) AS points, COUNT(id) AS votes, SUM(general)/COUNT(id) as atlag FROM fx_assess WHERE ref_movie=".$data['id'];
        $res = $database->db->Execute($q);
        $data['points'] =$res->fields;
        $data['points2'] = $ajanlo->get("general");
      }else{
        $data['general_egyedi']=$ertekeles[$i-1];
        $data['general_txt'] = get_general_by_id($ertekeles[$i-1], $_CMSVARS['lng']);
      }
			$Movies[$data['title_hun']]=$data;			
			
		}
	}
		return $Movies;
}
//##############################################################################
//Szûrõ elõállítása bitmapmezõ lekérdezéshez
//$vals: arrya, melyik helyértékeken van 1 es
//$long: a mezõ hossza;
//##############################################################################
function GetBitmap($val, $arr, $long) 
{
$long=$long-1;
  for($i=0;$i<=$long; $i++)
  {
    if(substr($val,$i,1))
    {
      $effect.= $arr[$i]['name'].",";
    }
  }
  return $effect;
}


?>
<?

$_SESSION['cathegories']=array (

	0 => array (

		'id' => 'comedy',

		'name' => 'vÃ­gjÃ¡tÃ©k',

		'position' => 10

	),

	1 => array (

		'id' => 'action',

		'name' => 'akciÃ³',

		'position' => 20

	),

	2 => array (

		'id' => 'fantasy',

		'name' => 'fantasy',

		'position' => 30

	),

	3 => array (

		'id' => 'cartoon',

		'name' => 'rajzfilm',

		'position' => 40

	),

	4 => array (

		'id' => 'animation',

		'name' => 'animÃ¡ciÃ³',

		'position' => 50

	),

	5 => array (

		'id' => 'drollery',

		'name' => 'bÃ¡bfilm',

		'position' => 60

	),

	6 => array (

		'id' => 'familial',

		'name' => 'csalÃ¡di',

		'position' => 70

	),

	7 => array (

		'id' => 'documentary',

		'name' => 'dokumentum',

		'position' => 80

	),

	8 => array (

		'id' => 'drama',

		'name'=> 'drÃ¡ma',

		'position' => 90

	),

	9 => array (

		'id' => 'biographical',

		'name' => 'Ã©letrajzi',

		'position' => 100

	),

	10 => array (

		'id' => 'erotic',

		'name' => 'erotikus',

		'position' => 110

	),

	11 => array (

		'id' => 'thriller',

		'name' => 'thriller',

		'position' => 120

	),

	12 => array(

		'id' => 'wartime',

		'name' => 'hÃ¡borÃºs',

		'position' => 130

	),

	13 => array(

		'id' => 'horror',

		'name' => 'horror',

		'position' => 140

	),

	14 => array (

		'id' => 'sci-fi',

		'name' => 'sci-fi',

		'position' => 150

	),

	15 => array (

		'id' => 'humor',

		'name' => 'humor',

		'position' => 160

	),

	16 => array (

		'id' => 'concert',

		'name' => 'koncert',

		'position' => 170

	),

	17 => array (

		'id' => 'picture',

		'name' => 'jÃ¡tÃ©kfilm',

		'position' => 180

	),

	18 => array (

		'id' => 'adventure',

		'name' => 'kalandfilm',

		'position' => 190

	),

	19 => array (

		'id' => 'farce',

		'name' => 'komÃ©dia',

		'position' => 200

	),

	20 => array (

		'id' => 'detective',

		'name' => 'krimi',

		'position' => 210

	),

	21 => array (

		'id' => 'mysterious',

		'name' => 'misztikus',

		'position' => 220

	),

	22 => array (

		'id' => 'art',

		'name' => 'mÅ±vÃ©sz',

		'position' => 230

	),

	23 => array (

		'id' => 'musical',

		'name' => 'musical',

		'position' => 240

	),

	24 => array (

		'id' => 'opera',

		'name' => 'opera',

		'position' => 250

	),

	25 => array (

		'id' => 'romantic',

		'name' => 'romantikus',

		'position' => 260

	),

	26 => array (

		'id' => 'sport',

		'name' => 'sport',

		'position' => 270

	),

	27 => array (

		'id' => 'satire',

		'name' => 'szatÃ­ra',

		'position' => 280

	),

	28 => array (

		'id' => 'historic',

		'name' => 'tÃ¶rtÃ©nelmi',

		'position' => 290

	),

	29 => array (

		'id' => 'western',

		'name' => 'western',

		'position' => 300

	),

	30 => array (

		'id' => 'nonfiction',

		'name' => 'ismeretterjesztÅ‘',

		'position' => 310

	),

	31 => array (

		'id' => 'music',

		'name' => 'zenÃ©s',

		'position' => 320

	),

	32 => array (

		'id' => 'pszthriller',

		'name' => 'pszichotriller',

		'position' => 330

	),

	33 => array (

		'id' => 'operett',

		'name' => 'operett',

		'position' => 340

	),

	34 => array (

		'id' => 'nature',

		'name' => 'termÃ©szetfilm',

		'position' => 350

	),

	35 => array (

		'id' => 'parodia',

		'name' => 'parÃ³dia',

		'position' => 360

	),

	36 => array (

		'id' => 'dogma',

		'name' => 'dogma film',

		'position' => 370



	)

);

?>
<?
//Nyelvi fÃ¡jlom
$TEXT['hun']['GBR']="Angol";
$TEXT['hun']['FRA']="Francia";
$TEXT['hun']['GRC']="GÃ¶rÃ¶g";
$TEXT['hun']['POL']="Lengyel";
$TEXT['hun']['HUN']="Magyar";
$TEXT['hun']['DEU']="NÃ©met";
$TEXT['hun']['ITA']="Olasz";
$TEXT['hun']['RUS']="Orosz";
$TEXT['hun']['ESP']="Spanyol";
$TEXT['hun']['ROM']="RomÃ¡n";
$TEXT['hun']['USA']="Amerika";
$TEXT['hun']['segitunk_filmet_valasztani']="SegÃ­tÃ¼nk filmet vÃ¡lasztani!";
$TEXT['hun']['milyen_mufajt_szeretnel']="Milyen mÅ±fajt szeretnÃ©l";
$TEXT['hun']['nem_tudod']="Nem tudod";
$TEXT['hun']['veletlen_ajanlas']="VÃ©letlen ajÃ¡nlÃ¡s";
$TEXT['hun']['ird_be_a_filmcimet_es_megmutatjuk_masok_velemenyet']="Ãrd be a filmcÃ­mÃ©t, Ã©s megmutatjuk  mÃ¡sok vÃ©lemÃ©nyÃ©t!";
$TEXT['hun']['milyen_filmet_keresel']="Milyen filmet keresel";
$TEXT['hun']['ezek_a']="Ezek a(z)"; 
$TEXT['hun']['filmek_az_adatbazisunk_alapjan_abc_sorban']="filmek az adatbÃ¡zisunkban ABC sorban.";
$TEXT['hun']['osszesen']="Ã¶sszesen";
$TEXT['hun']['vissza']="Vissza";
$TEXT['hun']['ertekeles_alapjan_ez_a_film_atlag']="Ã©rtÃ©kelÃ©s alapjÃ¡n ez Ã¡tlag";
$TEXT['hun']['bovebben']="BÅ‘vebben";
$TEXT['hun']['kovetkezo']="KÃ¶vetkezÅ‘";
$TEXT['hun']['elozo']="ElÅ‘zÅ‘";
$TEXT['hun']['ezeket_ajanljuk']="Ezeket ajÃ¡nljuk az Ã©rtÃ©kelÃ©sek alapjÃ¡n, ha <b>#text</b> keresel.";
$TEXT['hun']['veletlen_ajanlas_ebben_a_kategoriaban']="VÃ©letlen ajÃ¡nlÃ¡s ebben a kategÃ³riÃ¡ban!";
$TEXT['hun']['kezdo_oldal']="KezdÅ‘ oldal";
$TEXT['hun']['sok_talalt']="Sok a talÃ¡lat. PontosÃ­tsd a keresÃ©st.";
$TEXT['hun']['hasonlo_filmek']="HasonlÃ³ filmek";
$TEXT['hun']['keres']="Keres";
$TEXT['hun']['velemenyek']="VÃ©lemÃ©nyek";
$TEXT['hun']['tobb_lehetoseg']="TÃ¶bb lehetÅ‘sÃ©g";
$TEXT['hun']['keresd_az_interneten']="Keresd az Interneten";
$TEXT['hun']['lap_tetejere']="Lap tetejÃ©re";
$TEXT['hun']['altal_ertekelt_filmek']=" Ã¡ltal Ã©rtÃ©kelt filmek";
$TEXT['hun']['szia']="Szia!";
$TEXT['hun']['vissza_a_foldalra']="Vissza a fÅ‘oldalra";
$TEXT['hun']['ujabb_ajanlas_ebben_a_kategoriaban']="Ãšjabb ajÃ¡nlÃ¡s ebben a kategÃ³riÃ¡ban";
$TEXT['hun']['ertekelo_tobbi_filmje']="Ã‰rtÃ©kelÅ‘ tÃ¶bbi filmje";
$TEXT['hun']['szerint_ez_a_film']="szerint ez a film";



//BetÃ¶ltjÃ¼k az aktuÃ¡lis nyelvet
$TEXTLNG=$TEXT[$_SESSION['lng']];
$smarty->assign("TEXT",$TEXTLNG);

?>
<?
class Pager { 
    /** 
    * Total number of pages 
    * @access private 
    * @var int 
    */ 
    var $totalPages; 

    /** 
    * The row MySQL should start it's select with 
    * @access private 
    * @var int 
    */ 
    var $startRow; 

    /** 
    * SimplePager Constructor 
    * @param int number of rows per page 
    * @param int total number of rows available 
    * @param int current page being viewed 
    * @access public 
    */ 
    
    function Pager($rowsPerPage=10,$numRows=10,$currentPage=1) { 
        // Calculate the total number of pages 
        $this->totalPages=ceil($numRows/$rowsPerPage); 
        // Check that a valid page has been provided 
        if ( $currentPage < 1 ) 
            $currentPage=1; 
        else if ( $currentPage > $this->totalPages ) 
            $currentPage=$this->totalPages; 
        // Calculate the row to start the select with 
        $this->startRow=(($currentPage - 1) * $rowsPerPage); 
        //what was the limit
        $this->Limit=$rowsPerPage;
        
        if($currentPage <= $this->PagersNum)
        {    
        
        $end=$this->PagersNum*2;
        if($end>$this->totalPages)$end=$this->totalPages-1;
      
          for($i=0;$i<=$end;$i++){
            
            $Pagers[$i]=$i+1;
          }   
          $low_pagenum='1';
        }
         
        if($currentPage>$this->PagersNum and $currentPage<$this->totalPages-$this->PagersNum)
        {
     
          for($i=0-$this->PagersNum;$i<=$this->PagersNum;$i++){
            
            $Pagers[$i]=$i+$currentPage;
          }  
    
        }

        if(($currentPage>=($this->totalPages-$this->PagersNum)) and $low_pagenum!='1')
        {
        $start=$this->totalPages-$this->PagersNum*2;
        if($start<1)$start=1;
          for($i=$start;$i<=$this->totalPages;$i++){
            $Pagers[$i]=$i;
          }
        }    
        $this->Pagers=$Pagers;
        //
    } 


    function getTotalPages () { 
        return $this->totalPages; 
    } 

    function getStartRow() { 
        return $this->startRow; 
    } 
    
    function getLimit() { 
        return $this->Limit; 
    }     
} 
?>
<?
$_SESSION['backurl1']=$_REQUEST['menu'].'/'.$_REQUEST['param1']."&from=".$_REQUEST['from'];

//Ez a program kategória szerint listázzta f ilmeket

  if($_REQUEST['param1']!='')
  {
    $ilyet=$_REQUEST['param1'];
    $_CMSVARS['cathegory']=$_SESSION['cathegories'][$_REQUEST['param1']];
    if(!$_REQUEST['from'] or $_REQUEST['from']<0)$_REQUEST['from']=1;
    $_REQUEST['next']=$_REQUEST['from']+1;
    if($_REQUEST['from']-1!='0')$_REQUEST['prew']=$_REQUEST['from']-1;
      
  }
//objektum létrehozása  
   $film = new tFilm();
   $params['oldal']=$_REQUEST['from'];   // hanyadik oldal
   $params['count_per_page']=$_CMSVARS['MovieStepLimit'];  // mennyi van 1 oldalo   
   $params['rendezes'] = 'fx_movie.title_hun ASC';
   $params['cathegory'] = array($ilyet);
   list($lista, $res_count)=$film->getRelevList($params);
   $_REQUEST['all_num']=$res_count; 

//lekérdezés, kategória szerinti vilmek
/*
    $query_count = "SELECT COUNT(id) AS darab FROM fx_movie WHERE SUBSTRING(fx_movie.cathegory, 1, 1)='1'";
     $query="SELECT * FROM fx_movie WHERE SUBSTRING(fx_movie.cathegory, ".$ilyet.", 1)='1' ORDER BY fx_movie.title_hun ASC";
    list($res, $res_count) = $film->getLista($query, $query_count, $_REQUEST['from'], $_CMSVARS['MovieStepLimit']);
    $_REQUEST['all_num']=$res_count;
	   if ($res) {
				while (!$res->EOF) {
					$film = new tFilm();
					/* betoltjuk az adatokat 
					$film->load($res->fields("id"));
					$lista[] = $film;    
					$res->MoveNext();
				}
			} else {
				echo $query."\n".$query_count;
			}    
*/
//Templéthez az adatok feldolgozása
    $Movies=getMovieListData($lista,'1');
    $i=count($Movies);

//léptetéshez
		if($i<$_CMSVARS['MovieStepLimit']   or ($_REQUEST['from']*$_CMSVARS['MovieStepLimit'])>=$_REQUEST['all_num']){unset($_REQUEST['next']);} //ha nincs több oldal elõre

//templétbe
		$smarty->assign("Movies",$Movies);

//ezt a templétet kérjük
    $display='listmovies.tpl';

?>