<?php
define('_ASTEXE_', true);

//Соединение с БД
require_once($_SERVER["DOCUMENT_ROOT"]."/config.php");
$DP_Config = new DP_Config;//Конфигурация CMS
//Подключение к БД
try
{
	$db_link = new PDO('mysql:host='.$DP_Config->host.';dbname='.$DP_Config->db, $DP_Config->user, $DP_Config->password);
}
catch (PDOException $e) 
{
	exit("No DB connect");
}
$db_link->query("SET NAMES utf8;");
	
//---------------------------------------------------

$REQUEST_URI = $_SERVER['REQUEST_URI'];// URL запроса

if(strpos($REQUEST_URI,'?') > 0)
{
	$REQUEST_URI = substr($REQUEST_URI,0,strpos($REQUEST_URI,'?'));
}

$array_pages_url = explode('/', $REQUEST_URI);// Разбиваем URL запроса на страницы

if($array_pages_url[1] == 'catalog' && empty($array_pages_url[4])){
	
	$page_exists = true;
	
	$generator_pages_settings = array();
	$generator_pages_settings['page'] = 1;
	$generator_pages_settings['script'] = 'page_all_brends.php';
	if(!empty($array_pages_url[2])){
		$generator_pages_settings['page'] = 2;
		$generator_pages_settings['script'] = 'page_one_brend.php';
	}
	if(!empty($array_pages_url[3])){
		$generator_pages_settings['page'] = 3;
		$generator_pages_settings['script'] = 'page_article.php';
	}
	
	// Поучаем настройки страниц:
	$settings = array();
	$SQL = "SELECT * FROM `generator_pages_settings`";
	$query = $db_link->prepare($SQL);
	$query->execute();
	while($record = $query->fetch(PDO::FETCH_ASSOC)){
		$settings[$record['pages']] = $record;
	}
	
	// Сохраняем настройки страницы
	$generator_pages_settings = array_merge($generator_pages_settings, $settings[$generator_pages_settings['page']]);
	
	if($generator_pages_settings['page'] == 2){
		
		// Если это страница одного бренда:
			
		$brend_url = $array_pages_url[2];
		
		$SQL = "SELECT `brend` FROM `generator_pages` WHERE `brend_url` = '$brend_url' LIMIT 1";
		$query = $db_link->prepare($SQL);
		$query->execute();
		$record = $query->fetch(PDO::FETCH_ASSOC);
		
		if(!empty($record)){
			$brend = $record['brend'];
			
			$generator_pages_settings['brend'] = $brend;
			$generator_pages_settings['brend_url'] = $brend_url;
			
			$generator_pages_settings['title_tag'] = str_replace('%manufacturer%', $brend, $generator_pages_settings['title_tag']);
			$generator_pages_settings['description_tag'] = str_replace('%manufacturer%', $brend, $generator_pages_settings['description_tag']);
			$generator_pages_settings['keywords_tag'] = str_replace('%manufacturer%', $brend, $generator_pages_settings['keywords_tag']);
			$generator_pages_settings['h1_tag'] = str_replace('%manufacturer%', $brend, $generator_pages_settings['h1_tag']);

		}else{
			$page_exists = false;
		}
		
	}else if($generator_pages_settings['page'] == 3){
		
		// Если это страница артикула:
		
		$brend_url = $array_pages_url[2];
		$article_url = $array_pages_url[3];
		
		$SQL = "SELECT * FROM `generator_pages` WHERE `brend_url` = '$brend_url' AND `article_url` = '$article_url' LIMIT 1";
		$query = $db_link->prepare($SQL);
		$query->execute();
		$record = $query->fetch(PDO::FETCH_ASSOC);
		
		if(!empty($record)){
			$generator_pages_settings = array_merge($generator_pages_settings, $record);
			
			$brend = $record['brend'];
			
			$generator_pages_settings['brend'] = $brend;
			$generator_pages_settings['brend_url'] = $brend_url;
			
			$generator_pages_settings['title_tag']		 = str_replace('%manufacturer%', $generator_pages_settings['brend'], $generator_pages_settings['title_tag']);
			$generator_pages_settings['description_tag'] = str_replace('%manufacturer%', $generator_pages_settings['brend'], $generator_pages_settings['description_tag']);
			$generator_pages_settings['keywords_tag']	 = str_replace('%manufacturer%', $generator_pages_settings['brend'], $generator_pages_settings['keywords_tag']);
			$generator_pages_settings['h1_tag'] 		 = str_replace('%manufacturer%', $generator_pages_settings['brend'], $generator_pages_settings['h1_tag']);
			
			$generator_pages_settings['title_tag']		 = str_replace('%article%', $generator_pages_settings['article'], $generator_pages_settings['title_tag']);
			$generator_pages_settings['description_tag'] = str_replace('%article%', $generator_pages_settings['article'], $generator_pages_settings['description_tag']);
			$generator_pages_settings['keywords_tag']	 = str_replace('%article%', $generator_pages_settings['article'], $generator_pages_settings['keywords_tag']);
			$generator_pages_settings['h1_tag'] 		 = str_replace('%article%', $generator_pages_settings['article'], $generator_pages_settings['h1_tag']);
			
			$generator_pages_settings['title_tag']		 = str_replace('%article_no_spaces%', $generator_pages_settings['article_no_spaces'], $generator_pages_settings['title_tag']);
			$generator_pages_settings['description_tag'] = str_replace('%article_no_spaces%', $generator_pages_settings['article_no_spaces'], $generator_pages_settings['description_tag']);
			$generator_pages_settings['keywords_tag']	 = str_replace('%article_no_spaces%', $generator_pages_settings['article_no_spaces'], $generator_pages_settings['keywords_tag']);
			$generator_pages_settings['h1_tag'] 		 = str_replace('%article_no_spaces%', $generator_pages_settings['article_no_spaces'], $generator_pages_settings['h1_tag']);
			
			$generator_pages_settings['title_tag']		 = str_replace('%name%', $generator_pages_settings['name'], $generator_pages_settings['title_tag']);
			$generator_pages_settings['description_tag'] = str_replace('%name%', $generator_pages_settings['name'], $generator_pages_settings['description_tag']);
			$generator_pages_settings['keywords_tag']	 = str_replace('%name%', $generator_pages_settings['name'], $generator_pages_settings['keywords_tag']);
			$generator_pages_settings['h1_tag'] 		 = str_replace('%name%', $generator_pages_settings['name'], $generator_pages_settings['h1_tag']);
		}else{
			$page_exists = false;
		}
	}
	
	if($page_exists == true){
		
		$_SERVER['REQUEST_URI'] = '/catalog';
		
		$settings[1]['h1_tag'] = 'Каталог брендов-производителей';

		// Формируем хлебные крошки
		$generator_pages_settings['breadcrumbs'] = array();
		switch($generator_pages_settings['page']){
			case 1:
				$generator_pages_settings['breadcrumbs'][] = array('name'=>$settings[1]['h1_tag'], 'link'=>'');
			break;
			case 2:
				$generator_pages_settings['breadcrumbs'][] = array('name'=>$settings[1]['h1_tag'], 'link'=>'/catalog');
				$generator_pages_settings['breadcrumbs'][] = array('name'=>str_replace('%manufacturer%', $brend, $settings[2]['h1_tag']), 'link'=>'', 'class'=>'last');
			break;
			case 3:
				$generator_pages_settings['breadcrumbs'][] = array('name'=>$settings[1]['h1_tag'], 'link'=>'/catalog');
				$generator_pages_settings['breadcrumbs'][] = array('name'=>str_replace('%manufacturer%', $brend, $settings[2]['h1_tag']), 'link'=>'/catalog/'.$brend_url);
				$generator_pages_settings['breadcrumbs'][] = array('name'=>$generator_pages_settings['h1_tag'], 'link'=>'', 'class'=>'last');
			break;
		}
	}
}

/*
if($_SERVER['REMOTE_ADDR'] == '80.82.46.136'){
	echo '<pre>';
	var_dump($generator_pages_settings);
	echo '</pre>';
}
*/

require_once($_SERVER["DOCUMENT_ROOT"]."/index.php");
?>