<?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, categ_id AS categ FROM sites";
		$sql .= " WHERE site_ban = 1 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'";
		$sql .= " ORDER BY RAND() 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 = 0";
		$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 = 0";
		$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'";
		$sql .= " ORDER BY RAND() LIMIT 40";
		$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, LCASE(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);
		$catUrls = array(1 => "hardcore.html",
    								 2 => "anal.html",
                     3 => "blowjob.html",
                     4 => "cartoons.html",
                     5 => "gay.html",
                     6 => "lesbian.html",
                     7 => "milf.html",
                     8 => "shemale.html",
                     9 => "watersports.html",
                     10 => "fetish.html",
                     11 => "ebony.html",
                     12 => "mature.html",
                     13 => "asian.html",
                     14 => "bbw.html",
                     15 => "tits.html",
                     16 => "teen.html",
                     17 => "handjob.html",
                     18 => "bisexual-porn.html",
                     19 => "interracial-porn.html",
                     20 => "amateur-porn.html",
                     21 => "sex-toys.html",
                     22 => "orgy.html",
                     23 => "solo-babes.html",
                     24 => "webcams.html",
                     25 => "latinas-porn.html");
		$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("catUrls", $catUrls);
		$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('main.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();