<?
if(@$_GET['lang'] != '') $lang = '/'.str_replace('/', '', @$_GET['lang']) . '/';
else $lang = '/';

include('files/config.php');
include('files/connect.php');

// Main Page
if(@$_GET['mode'] == '') {

	$sql = "
		SELECT
			prefix,
			name,
			name_ru,
			id,
			(SELECT 
				COUNT(*)
			FROM
				countries
			WHERE
				countries.reg_id = regions.id
			) AS in_region
		FROM
			regions
		ORDER BY
			id
	";
	$res = mysql_query($sql);
	$rws = mysql_num_rows($res);
	$r = 0;
	while($region = mysql_fetch_array($res)) {
		$regions[$r]['name'] 	= $region['name'];
		$regions[$r]['name_ru']	= $region['name_ru'];
		$regions[$r]['prefix'] 	= $region['prefix'];
		$regions[$r]['in_reg'] 	= $region['in_region'];
		$regions[$r]['id'] 		= $region['id'];
		$red_id 				= $region['id'];
		$sql_c = "
			SELECT 
				countries.name,
				countries.name_ru
			FROM 
				countries
			WHERE 
				reg_id = '".$red_id."'
			ORDER BY
				RAND()
			LIMIT 15
		";
		$res_c = mysql_query($sql_c);
		$rws_c = mysql_num_rows($res_c);
		$c 	 = 0;
		while($country = mysql_fetch_array($res_c)) {
			$countries[$red_id][$c]['name'] 	= $country['name'];
			$countries[$red_id][$c]['name_ru'] 	= $country['name_ru'];
			$c ++;
		}
		
		$r ++;
	}
	
	if($lang == '/ru/') {
		include('files/templates/ru/header.php');
		include('files/templates/ru/index.php');
		include('files/templates/ru/footer.php');
	} else {
		include('files/templates/header.php');
		include('files/templates/index.php');
		include('files/templates/footer.php');
	}
} 

// Region Page
elseif(@$_GET['mode'] == 'region' && isset($_GET['region'])) {
	
	if($lang == '/ru/') {
	$sql = "
		SELECT 
			DISTINCT(countries.name_ru),
			countries.name,
			countries.code,
			countries.id AS c_id,
			regions.name AS reg_name,
			regions.name_ru AS reg_name_ru
		FROM
			regions,
			countries
		WHERE
			countries.reg_id = regions.id AND
			regions.prefix = '". @$_GET['region'] ."'
		ORDER BY
			countries.name_ru
	";
	} else {
	$sql = "
		SELECT 
			DISTINCT(countries.name),
			countries.name_ru,
			countries.code,
			countries.id AS c_id,
			regions.name AS reg_name,
			regions.name_ru AS reg_name_ru
		FROM
			regions,
			countries
		WHERE
			countries.reg_id = regions.id AND
			regions.prefix = '". @$_GET['region'] ."'
		ORDER BY
			countries.name
	";
	}
	$res = mysql_query($sql);
	$rws = mysql_num_rows($res);
	$c   = 0;
	$prevCountry = '';
	$_TMPL['meta']['kwrds'] = '';
	while($country = mysql_fetch_array($res)) {
		$countries[$c]['country'] 	= $country['name'];
		$countries[$c]['country_ru']= $country['name_ru'];
		$countries[$c]['c_id'] 		= $country['c_id'];
		$countries[$c]['code']	 	= trim(str_replace(' ', '', $country['code']));
		$countries[$c]['prefix'] 	= str_replace('St.', 'Saint', $country['name']);
		$countries[$c]['prefix'] 	= str_replace('-', '_', $countries[$c]['prefix']);
		$countries[$c]['prefix'] 	= str_replace('&nbsp;', '', $countries[$c]['prefix']);
		$countries[$c]['prefix'] 	= str_replace(' ', '_', mb_strtolower($countries[$c]['prefix'], 'utf-8'));		
		$countries[$c]['reg_name'] 	= $country['reg_name'];		
		$countries[$c]['reg_name_ru'] 	= $country['reg_name_ru'];
		
		if($lang == '/ru/') $_TMPL['meta']['kwrds'] .= $country['name'] . ' white and yellow pages, ';
		else $_TMPL['meta']['kwrds'] .= $country['name_ru'] . ' белые и желтые страницы, ';
			
		$sql_l = "
			SELECT
				*
			FROM 
				links
			WHERE 
				c_id = '".$country['c_id']."' AND
				link != ''
		";
		$res_l = mysql_query($sql_l);
		$rws_l = mysql_num_rows($res_l);
		if($rws_l > 0) {
			$links[$country['c_id']] = 0;
			while($l = mysql_fetch_array($res_l)) {
				$link[$country['c_id']][$links[$country['c_id']]]['link'] = $l['link'];
				$link[$country['c_id']][$links[$country['c_id']]]['type'] = $l['type'];
				if($l['type'] == 'yellow') $link[$country['c_id']][$links[$country['c_id']]]['name'] = 'Yellow pages';
				elseif($l['type'] == 'white') $link[$country['c_id']][$links[$country['c_id']]]['name'] = 'White pages';
				elseif($l['type'] == 'both') $link[$country['c_id']][$links[$country['c_id']]]['name'] = 'White and Yellow pages';
				
				$links[$country['c_id']] ++;
			}
		}
		
		$c ++;
	}
	
	$sql = "
		SELECT
			prefix,
			name,
			name_ru
		FROM
			regions
		ORDER BY
			id
	";
	$res = mysql_query($sql);
	$rws = mysql_num_rows($res);
	$r = 0;
	while($region = mysql_fetch_array($res)) {
		$regions[$r]['name'] 	= $region['name'];
		$regions[$r]['name_ru']	= $region['name_ru'];
		$regions[$r]['prefix'] 	= $region['prefix'];
		$r ++;
	}
	
	if($lang == '/ru/') $_TMPL['meta']['title'] = $countries[0]['reg_name_ru'] . '&nbsp;&mdash; телефонные справочники';
	else $_TMPL['meta']['title'] = $countries[0]['reg_name'] . ' telephone directories';
	
	
	if($lang == '/ru/') {
		include('files/templates/ru/header.php');
		include('files/templates/ru/region.php');
		include('files/templates/ru/footer.php');
	} else {
		include('files/templates/header.php');
		include('files/templates/region.php');
		include('files/templates/footer.php');
	}
}
?>