<?
// written by Hristo Gaydarov
// 01.11.2006

require_once("../conf/config.inc.php");
###########
//require_once("../include/init_smarty.php");
require_once("../libs/Smarty.class.php");

$sm = new Smarty;
$sm->compile_check = true;
$sm->debugging = false;
$sm->caching = false;
$sm->force_compile = true;
$sm->assign_by_ref("title", $title);
$sm->assign('lang_conf', $language);

###########
require_once("../include/classes.php");
require_once("../include/functions.php");
require_once("../conf/configure.php");
require_once("../include/class_sql_ticket.php");
require('adv.php'); 

require('../include/_drawrating.php');

$db = new MyDB($bill_DBhost,$bill_DBuser,$bill_DBpass,$bill_DBase);

if(isset($_GET['district']))
{
	
	$district=$_GET['district'];
	$district=unhtmlentities (addslashes (trim ($district)));	
	//$district = iconv("CP1251", "UTF-8//IGNORE", $district);
	
	$district_info=$db->Query_result("SELECT d.id AS did, d.district AS ddistrict, di.*
	 FROM districts d, districts_info di
	 WHERE d.district = '$district' AND d.id=di.district");	
	//echo "<pre>";
	//print_r($district_info);
	if(!$district_info)
	{
		///*
		echo '<META Http-Equiv="Cache-Control" Content="no-cache" />';
		echo '<META Http-Equiv="Pragma" Content="no-cache" />';
		echo '<META Http-Equiv="Expires" Content="0" />';
		echo '<META NAME="GOOGLEBOT" CONTENT="NOARCHIVE" /> ';
		$sm->display('404.shtml');
		exit();
		//*/
	}
	else 
	{
		$ddistrict=$district_info[1]['ddistrict'];
		$did=$district_info[1]['did'];
		$sm->assign('ddistrict',$ddistrict);
		$sm->assign('did',$did);
		$sm->assign('district_info',$district_info);
	}
}
else 
{
	///*
	echo '<META Http-Equiv="Cache-Control" Content="no-cache" />';
	echo '<META Http-Equiv="Pragma" Content="no-cache" />';
	echo '<META Http-Equiv="Expires" Content="0" />';
	echo '<META NAME="GOOGLEBOT" CONTENT="NOARCHIVE" /> ';
	$sm->display('404.shtml');
	exit();
	//*/
}


$sm->assign('filename',"districts");
require('casts.php'); 

##############
$sm->display('districts.html');
?>