<?php

require_once('config/config.inc.php');
require_once('Pager_Wrapper.php');

class index extends PHPApplication {
	
	function run() {
		
		global $SITES_DB_URL;
		
		$this->categ  = $this->get_categ();
		$this->type   = $this->get_type();
		$this->form   = $this->get_format();
		$this->pay    = $this->get_paysites();
		$this->friend = $this->get_friendsites();
		
		$pagerOptions = array(
			 'mode'    => 'Sliding',
			 'perPage'   => 30,
			 'urlVar' => 'page',
			);
		
		$sql  = "SELECT site_name AS name, site_url AS url, site_desc AS descr, format_id AS format, type_id AS tipo, site_recom AS recom FROM sites";
		$sql .= " WHERE site_ban = 1 AND categ_id = 25 ORDER BY site_date DESC";
			 
		$db = MDB2::connect($SITES_DB_URL);
		$paged_data = Pager_Wrapper_MDB2($db, $sql, $pagerOptions);
		
		if (!empty($paged_data['data'])) {
			
			$this->data = true;
			$this->paged_data = $paged_data['data'];
			$this->links = $paged_data['links'];
			$this->display();
			
		} else {
			
			$this->data = false;
			$this->display();
			
		}
		
	}
	
	function get_paysites() {
		
		global $CONFG_DB_URL;
		
		$dbi  = new DBI($CONFG_DB_URL);
		$sql  = "SELECT site_name AS name, site_url AS url, site_dest AS dest FROM sites WHERE site_type = 'P' AND site_categ = 25";
		$sql .= " ORDER BY name ASC LIMIT 40";
		$res  = $dbi->query($sql);
		
		while ($row = $res->fetchRow()) {
			
			$dat[] = $row;
			
		}
		
		$dbi->disconnect();
		
		return $dat;
		
	}
	
	function get_temp() {
		
		global $CONFG_DB_URL;

		$dbi = new DBI($CONFG_DB_URL);
		$sql = "SELECT * FROM temp WHERE categ_id = 25";
		$res = $dbi->query($sql);
		$num = $res->numRows();
		
		if ($num > 0) {
			
			foreach ($res->fetchRow() as $key => $value) {
			
				$dat[$key] = $value;
				
			}
			
		}		
		
		$dbi->disconnect();
		
		return $dat;
		
	}
	
	function get_banners() {
		
		global $CONFG_DB_URL;
		
		$dbi = new DBI($CONFG_DB_URL);
		$sql = "SELECT * FROM banners WHERE categ_id = 25";
		$res = $dbi->query($sql);
		$num = $res->numRows();
		
		if ($num > 0) {
			
			$this->banners = true;
			
			while ($row = $res->fetchRow()) {
				
				$dat[] = $row;
				
			}
			
		}		
		
		$dbi->disconnect();
		
		return $dat;
		
	}
	
	function get_friendsites() {
		
		global $CONFG_DB_URL;
		
		$dbi  = new DBI($CONFG_DB_URL);
		$sql  = "SELECT site_name AS name, site_url AS url, site_dest AS dest FROM sites WHERE site_type = 'F' AND site_categ = 25";
		$sql .= " ORDER BY name ASC LIMIT 30";
		$res  = $dbi->query($sql);
		
		while ($row = $res->fetchRow()) {
			
			$dat[] = $row;
			
		}
		
		$dbi->disconnect();
		
		return $dat;
		
	}
	
	function get_format() {
		
		global $CONFG_DB_URL;
		
		$dbi = new DBI($CONFG_DB_URL);
		$sql = "SELECT format_id, LCASE(format_name) FROM format ORDER BY format_name ASC";
		$dat = $dbi->getAssoc($sql);
		$dbi->disconnect();
		
		return $dat;
		
	}
	
	function get_type() {
		
		global $CONFG_DB_URL;
		
		$dbi = new DBI($CONFG_DB_URL);
		$sql = "SELECT type_id AS id, type_name AS name FROM type ORDER BY type_name ASC";
		$dat = $dbi->getAssoc($sql);
		$dbi->disconnect();
		
		return $dat;
		
	}
	
	function get_categ() {
		
		global $CONFG_DB_URL;
		
		$dbi = new DBI($CONFG_DB_URL);
		$sql = "SELECT categ_id AS id, UCASE(categ_name) AS name FROM categ ORDER BY categ_name ASC";
		$dat = $dbi->getAssoc($sql);
		$dbi->disconnect();
		
		return $dat;
		
	}
	
	function display() {
		
		$banner = $this->get_banners($this->id);
		
		$smarty = new Smarty;
		
		$smarty->assign('temp', $this->get_temp($this->id));
		$smarty->assign('ban', $this->banners);
		$smarty->assign('banner', $banner);
		$smarty->assign("categ", $this->categ);
		$smarty->assign("type", $this->type);
		$smarty->assign("format", $this->form);
		$smarty->assign("pay", $this->pay);
		$smarty->assign("friend", $this->friend);
		if ($this->data === true) {
			$smarty->assign('gals', $this->paged_data);
			$smarty->assign('links', $this->links);
			$smarty->assign('data', $this->data);
		}
		$smarty->display('latina-porn.tpl');
		
	}
	
}

global $AUTH_DB_URL;

$thisApp = new index(array(
                              'app_name'             => $APPLICATION_NAME,
                              'app_version'          => '1.0.0',
                              'app_db_url'           => $AUTH_DB_URL,
                              'app_auto_authorize'   => TRUE,
                              'app_auto_chk_session' => TRUE,
                              'app_auto_connect'     => FALSE
                             )
                      );
                      
$thisApp->run();

?>