<?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
///////////////////////////////////////////////////////////////////////////////////////////

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

///////////////////////////////////
///Opening session
//////////////////////////////////

ini_set('session.use_trans_sid', 0);
ini_set('display_errors', '1');
session_start();

///////////////////////////////////
///Include function files
//////////////////////////////////
	
require_once __DIR__.'/../../includes/configuration.php';
require_once __DIR__.'/../../includes/cache/all_cache.php';
require_once __DIR__.'/../../includes/fns_data.php';
require_once __DIR__.'/../../includes/fns_mail.php';
require_once __DIR__.'/../../includes/fns_sql.php';
require_once __DIR__.'/../../includes/fns_sql_adm.php';
require_once __DIR__.'/../../includes/fns_sql_global.php';
require_once __DIR__.'/fns_form_adm.php';

if(file_exists(__DIR__.'/../../template/map/cache_map.php'))
require_once __DIR__.'/../../template/map/cache_map.php';

///////////////////////////////////
///Default website language
//////////////////////////////////

$default_lang = current($cache_lang);
define('DEFAULT_LANG', $default_lang['code_lang']);

///////////////////////////////////
///Managing the language call
//////////////////////////////////

if(isset($_POST['lang']) && $_POST['lang'] == 'fr')
{
	require_once('language_adm/french_adm.php');
	$_SESSION['lang'] = 'fr';
	
	setcookie('SP_adm', 'SP_adm_fr', time() + (365 * 24 * 60 * 60), '/');
}
elseif(isset($_POST['lang']) && $_POST['lang'] == 'en')
{
	require_once('language_adm/english_adm.php');
	$_SESSION['lang'] = 'en';
	
	setcookie('SP_adm', 'SP_adm_en', time() + (365 * 24 * 60 * 60), '/');
}
elseif(isset($_POST['lang']) && $_POST['lang'] == 'es')
{
	require_once('language_adm/spanish_adm.php');
	$_SESSION['lang'] = 'es';
	
	setcookie('SP_adm', 'SP_adm_es', time() + (365 * 24 * 60 * 60), '/');
}
elseif(isset($_POST['lang']) && $_POST['lang'] == 'it')
{
	require_once('language_adm/italian_adm.php');
	$_SESSION['lang'] = 'it';
	
	setcookie('SP_adm', 'SP_adm_it', time() + (365 * 24 * 60 * 60), '/');
}
elseif(isset($_POST['lang']) && $_POST['lang'] == 'ru')
{
	require_once('language_adm/russian_adm.php');
	$_SESSION['lang'] = 'ru';
	
	setcookie('SP_adm', 'SP_adm_ru', time() + (365 * 24 * 60 * 60), '/');
}
elseif((isset($_SESSION['lang']) && $_SESSION['lang'] == 'fr') || (isset($_COOKIE['SP_adm']) && $_COOKIE['SP_adm'] == 'SP_adm_fr'))
{
	require_once('language_adm/french_adm.php');
	$_SESSION['lang'] = 'fr';
}
elseif((isset($_SESSION['lang']) && $_SESSION['lang'] == 'en') || (isset($_COOKIE['SP_adm']) && $_COOKIE['SP_adm'] == 'SP_adm_en'))
{
	require_once('language_adm/english_adm.php');
	$_SESSION['lang'] = 'en';
}
elseif((isset($_SESSION['lang']) && $_SESSION['lang'] == 'es') || (isset($_COOKIE['SP_adm']) && $_COOKIE['SP_adm'] == 'SP_adm_es'))
{
	require_once('language_adm/spanish_adm.php');
	$_SESSION['lang'] = 'es';
}
elseif((isset($_SESSION['lang']) && $_SESSION['lang'] == 'it') || (isset($_COOKIE['SP_adm']) && $_COOKIE['SP_adm'] == 'SP_adm_it'))
{
	require_once('language_adm/italian_adm.php');
	$_SESSION['lang'] = 'it';
}
elseif((isset($_SESSION['lang']) && $_SESSION['lang'] == 'ru') || (isset($_COOKIE['SP_adm']) && $_COOKIE['SP_adm'] == 'SP_adm_ru'))
{
	require_once('language_adm/russian_adm.php');
	$_SESSION['lang'] = 'ru';
}
elseif(!isset($_SESSION['lang']))
{
	require_once('language_adm/french_adm.php');
	$_SESSION['lang'] = 'fr';
}

///////////////////////////////////
///Trim on POST data
//////////////////////////////////

function array_trim($array) {
	$trimed = array();
	foreach($array as $key => $elt) $trimed[$key] = is_array($elt) ? array_trim($elt) : trim($elt); 
	return $trimed;
}
if(count($_POST) > 0) {
	$_POST = array_trim($_POST);
}

///////////////////////////////////
///Trim on GET data
//////////////////////////////////

if(count($_GET) > 0)
{
	foreach($_GET as $k => $v)
	{
		$_GET[$k] = trim($_GET[$k]);
	}
}

///////////////////////////////////
//Opening the connection to the database
//////////////////////////////////

$conn = db_connect();

///////////////////////////////////
//Get statistics for ads management
//////////////////////////////////

$total_conf = get_ad_total_num(0);
$total_wait = get_ad_total_num(1);
$total_val = get_ad_total_num(2);
$total_rej = get_ad_total_num(3);
$total_exp = get_ad_total_num(4);
$total_pay = get_ad_total_num(5);
$total_wit = get_ad_total_num(6);

///////////////////////////////////
//Get statistics for accounts management
//////////////////////////////////

$total_acc_mem_wait = get_acc_total_num(1, 1);
$total_acc_mem_val = get_acc_total_num(2, 1);
$total_acc_mem_rej = get_acc_total_num(3, 1);
$total_acc_mem_conf = get_acc_total_num(0, 1);
$total_acc_pro_wait = get_acc_total_num(1, 2);
$total_acc_pro_val = get_acc_total_num(2, 2);
$total_acc_pro_rej = get_acc_total_num(3, 2);
$total_acc_pro_conf = get_acc_total_num(0, 2);

///////////////////////////////////
//Load XML color
//////////////////////////////////

if(file_exists(__DIR__.'/../template_adm/css_adm/adm_colors.xml')) {
	$color_xml = simplexml_load_file (__DIR__.'/../template_adm/css_adm/adm_colors.xml');
	$adm_colors = array();
	foreach($color_xml as $color) {
		$adm_colors[] = $color->current_color->__toString();
	}
}