<?php
///////////////////////////////////////////////////////////////////////////////////////////
///Script PHP/MYSQL of management of classifieds ads developed by Script PAG
///Script PAG all rights reserved. Use under license. http://www.script-pag.com
///////////////////////////////////////////////////////////////////////////////////////////

############################################################

require_once __DIR__.'/includes_adm/all_fns_adm.php';

///////////////////////////////////
//Check if the super admin is connected
//////////////////////////////////
	
if(!empty($_SESSION['valid_admin']))
$valid_admin = $_SESSION['valid_admin'];

if(!check_super_admin())
redirect('index.php');

///////////////////////////////////
//Validation of the action
//////////////////////////////////

if(!empty($_GET['act']))
{
	if($_GET['act'] >= 1 && $_GET['act'] <= 4)
	$act = (int) $_GET['act'];
	
	else $act = 0;
}
else $act = 0;

///////////////////////////////////
//Validation of the region and county
//////////////////////////////////

$id_reg = (!empty($_GET['id_reg'])) ? (int) $_GET['id_reg'] : 0;
$id_county = (!empty($_GET['id_county'])) ? (int) $_GET['id_county'] : 0;
$par_reg = (!empty($_GET['par_reg'])) ? (int) $_GET['par_reg'] : 0;

///////////////////////////////////
//Select searche engine and title values
//////////////////////////////////

if($act != 1 && $act != 2)
{
	$action = (isset($_GET['id_reg'])) ? 'regions.php?id_reg='. (int) $_GET['id_reg'] .'&amp;act=4&amp;menu=3' : 'regions.php?act=4&amp;menu=3';
	$href = (isset($_GET['id_reg'])) ? 'regions.php?id_reg='. (int) $_GET['id_reg'] .'&amp;act=1&amp;menu=3' : 'regions.php?act=1&amp;menu=3';
	$href_name = (isset($_GET['id_reg'])) ? $language_adm['page_list_reg_add_county'] : $language_adm['page_list_reg_add_reg'];
	
	$name_reg_lang_add = '';
	
	if(isset($_GET['id_reg']))
	{
		foreach($cache_lang as $row)
		{
			$code_lang = stripslashes(htmlspecialchars($row['code_lang'], ENT_QUOTES));
			$name_reg_lang = (isset($cache_regions[$_GET['id_reg']]['name_reg_'. $code_lang])) ? stripslashes(htmlspecialchars($cache_regions[$_GET['id_reg']]['name_reg_'. $code_lang], ENT_QUOTES)) : '';
			$position = (int) $row['position'];
			$active = (int) $row['active'];
			
			if($active == 1 && !empty($name_reg_lang))
			$name_reg_lang_add = $name_reg_lang;
			
			if($position == 1)
			break;
		}
	}
}

///////////////////////////////////
//Initializing variable $error
//////////////////////////////////

$error = '';

///////////////////////////////////
//Add region or county
//////////////////////////////////

if($act == 1)
{
	//Get action form
	$action = (!empty($_GET['id_reg'])) ? 'regions.php?id_reg='. (int) $_GET['id_reg'] .'&amp;act='. $act .'&amp;menu=3' : 'regions.php?act='. $act .'&amp;menu=3';
	
	if(count($_POST) > 0 && !isset($_POST['lang']))
	{
		foreach($cache_lang as $v)
		{
			$code_lang = stripslashes(htmlspecialchars($v['code_lang'], ENT_QUOTES));
			$active = (int) $v['active'];
			
			if($active == 1 && empty($_POST['name_'. $code_lang]))
			$error = 1;
		}
		 
		if(empty($error))
		{
			if(empty($id_reg))
			{
				create_reg($_POST);
				create_cache_reg();
			}
			else
			{
				create_county($id_reg, $_POST);
				create_cache_counties();
			}
				
			$redirect = (!empty($id_reg)) ? '&id_reg='. $id_reg .'&succes=2' : '&succes=1';
			
			redirect("regions.php?menu=3". $redirect);
		}
	}
}

///////////////////////////////////
//Update region or county
//////////////////////////////////

elseif($act == 2)
{
	if(count($_POST) > 0 && !isset($_POST['lang']))
	{
		foreach($cache_lang as $v)
		{
			$code_lang = stripslashes(htmlspecialchars($v['code_lang'], ENT_QUOTES));
			$active = (int) $v['active'];
			
			if($active == 1 && empty($_POST['name_'. $code_lang]))
			$error = 1;
		}
		 
		if(empty($error))
		{
			if(!empty($id_reg))
			{
				update_reg($id_reg, $_POST);
				create_cache_reg();
			}
			else
			{
				update_county($id_county, $par_reg, $_POST);
				create_cache_counties();
			}
			
			$redirect = (!empty($par_reg)) ? '&id_reg='. $par_reg .'&succes=4' : '&succes=3';
				
			redirect("regions.php?menu=3". $redirect);
		}
	}
}

///////////////////////////////////
//Delete region or county
//////////////////////////////////

if((!empty($id_reg) || !empty($id_county)) && $act == 3)
{
	if(!empty($id_reg))
	{
		delete_reg($id_reg);
		create_cache_reg();
	}
	else
	{
		delete_county($id_county);
		create_cache_counties();
	}
	
	$redirect = (!empty($par_reg)) ? '&id_reg='. $par_reg .'&succes=6' : '&succes=5';
				
	redirect("regions.php?menu=3". $redirect);
}

///////////////////////////////////
//Delete all regions or counties
//////////////////////////////////

if(!empty($_POST['check_all']) && $act == 4)
{
	$array = $_POST['check_all'];
	
	if(empty($id_reg))
	{
		foreach($array as $reg)
		delete_reg($reg);
		
		create_cache_reg();
	}
	else 
	{
		foreach($array as $county)
		delete_county($county);
		
		create_cache_counties();
	}
	
	if(count($_POST['check_all']) > 1)
	$redirect = (!empty($id_reg)) ? '&id_reg='. $id_reg .'&succes=8' : '&succes=7';
	
	else $redirect = (!empty($id_reg)) ? '&id_reg='. $id_reg .'&succes=6' : '&succes=5';
				
	redirect("regions.php?menu=3". $redirect);
}

///////////////////////////////////
//Update cache nb ads
//////////////////////////////////

if(isset($_GET['succes']))
get_nb_ads();

///////////////////////////////////
//Close database connexion
//////////////////////////////////

$conn = null;

///////////////////////////////////
//Display view
//////////////////////////////////

$view = array();

if($act == 1) 
$view[] = 'template_adm/tpl_reg_crea_adm.php';

elseif($act == 2) 
$view[] = 'template_adm/tpl_reg_mod_adm.php';

else $view[] = 'template_adm/tpl_reg_adm.php';

require_once __DIR__.'/template_adm/tpl_layout_adm.php';