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

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

///////////////////////////////////
//Select regions
//////////////////////////////////

function display_regions($id, $regions, $e)
{	
	global $language, $cache_lang;
	
	if(isset($e['reg']))
	echo '<select id="form_county" name="reg" class="form-error" onchange="DisplayCounties()">';
	
	else echo '<select id="form_county" name="reg" onchange="DisplayCounties()">';
	
	echo '<option value="0">'. $language['form_reg_select'] .'</option>';
	
	foreach($regions as $row)
	{
		$id_reg = (int) $row['id_reg'];
		
		if(isset($row['name_reg_'. $_SESSION['code_lang']]))
		$name_reg = stripslashes(htmlspecialchars($row['name_reg_'. $_SESSION['code_lang']], ENT_QUOTES));		
	
		if ($id_reg == $id)
		echo '<option value="'. $id_reg .'" selected>'. $name_reg .'</option>';
	 
		else echo '<option value="'. $id_reg .'">'. $name_reg .'</option>';
	}	
	echo '</select>';
}

///////////////////////////////////
//Select counties
//////////////////////////////////

function display_counties($id, $reg, $counties, $e)
{	
	global $language, $cache_lang;
	
	if(isset($e['county']))
	echo '<select id="form_reg" name="county" class="form-error">';
	
	else echo '<select id="form_reg" name="county">';
	
	echo '<option value="0">'. $language['form_county_select'] .'</option>';
	
	foreach($counties as $row)
	{
		$id_county = (int) $row['id_county'];
		$par_reg = (int) $row['par_reg'];
		
		if(isset($row['name_county_'. $_SESSION['code_lang']]))
		$name_county = stripslashes(htmlspecialchars($row['name_county_'. $_SESSION['code_lang']], ENT_QUOTES));  			
	
		if($par_reg == $reg)
		{
			if($id_county == $id)
			echo '<option value="'. $id_county .'" selected>'. $name_county.'</option>';
	 
			else echo '<option value="'. $id_county .'">'. $name_county .'</option>';
		}
	}	
	echo '</select>';
}

///////////////////////////////////
//Select categories
//////////////////////////////////

function display_categories($id, $categories, $e)
{
	global $language, $cache_lang;
	
	if(isset($e['cat']))
	echo '<select id="options" name="cat" class="short form-error" onchange="DisplayOptions(); DisplayNote(); DisplayPrice(); DisplayCalendar(); DisplayFile()">';
	
	else echo '<select id="options" name="cat" class="short" onchange="DisplayOptions(); DisplayNote(); DisplayPrice(); DisplayCalendar(); DisplayFile()">';
	
	echo '<option value="0">'. $language['form_cat_select'] .'</option>';

	foreach($categories as $row)
	{	
		$id_cat = (int) $row['id_cat'];
		$par_cat = (int) $row['par_cat'];
		
		if(isset($row['name_cat_'. $_SESSION['code_lang']]))
		$name_cat = stripslashes(htmlspecialchars($row['name_cat_'. $_SESSION['code_lang']], ENT_QUOTES));		
       
		if($par_cat == 0)
		echo '<option value="0" disabled class="background_select_cat uppercase">-- '. mb_strtoupper($name_cat) .' --</option>';
		
		//Subategories
		
		$subcategories = $categories;
		
		foreach($subcategories as $row)
		{
			$id_subcat = (int) $row['id_cat'];
			$par_subcat = (int) $row['par_cat'];
			
			if(isset($row['name_cat_'. $_SESSION['code_lang']]))
			$name_subcat = stripslashes(htmlspecialchars($row['name_cat_'. $_SESSION['code_lang']], ENT_QUOTES));
			
			if($par_subcat == $id_cat) 
			{
				if($id_subcat == $id)
				echo '<option value="'. $id_subcat .'" selected>'. $name_subcat .'</option>';
				
				else echo '<option value="'. $id_subcat .'">'. $name_subcat .'</option>';
			}
		}
	}	
	echo '</select>';
}

///////////////////////////////////
//Select categories rubric
//////////////////////////////////

function display_categories_rubric($id, $m_id_cat, $categories, $e)
{
	global $language, $cache_lang;
	
	if (isset($e['cat']))
	echo '<select id="options" name="cat" class="short form-error" onchange="DisplayOptions(); DisplayNote(); DisplayPrice(); DisplayCalendar(); DisplayFile()">';
	
	else echo '<select id="options" name="cat" class="short" onchange="DisplayOptions(); DisplayNote(); DisplayPrice(); DisplayCalendar(); DisplayFile()">';
	
	echo '<option value="0">'. $language['form_cat_select'] .'</option>';

	foreach($categories as $row)
	{	
		$id_cat = (int) $row['id_cat'];
		$par_cat = (int) $row['par_cat'];
		
		if(isset($row['name_cat_'. $_SESSION['code_lang']]))
		$name_cat = stripslashes(htmlspecialchars($row['name_cat_'. $_SESSION['code_lang']], ENT_QUOTES));		
       
		if($id_cat == $m_id_cat) 
		{
			echo '<option value="0" disabled class="background_select_cat uppercase">-- '. mb_strtoupper($name_cat) .' --</option>';
		
			//Subategories
			
			$subcategories = $categories;
			
			foreach($subcategories as $row)
			{
				$id_subcat = (int) $row['id_cat'];
				$par_subcat = (int) $row['par_cat'];
				
				if(isset($row['name_cat_'. $_SESSION['code_lang']]))
				$name_subcat = stripslashes(htmlspecialchars($row['name_cat_'. $_SESSION['code_lang']], ENT_QUOTES));
				
				if($par_subcat == $id_cat) 
				{
					if($id_subcat == $id)
					echo '<option value="'. $id_subcat .'" selected>'. $name_subcat .'</option>';
					
					else echo '<option value="'. $id_subcat .'">'. $name_subcat .'</option>';
				}
			}
		}
	}	
	echo '</select>';
}

///////////////////////////////////
//Select rubric
//////////////////////////////////

function display_rubric($id, $categories, $e)
{
	global $language, $cache_lang;
	
	if (isset($e['cat']))
	echo '<select id="options" name="cat" class="select_form form-error">';
	
	else echo '<select id="options" name="cat" class="select_form">';
	
	echo '<option value="0">'. $language['form_cat_rubric'] .'</option>';

	foreach($categories as $row)
	{	
		$id_cat = (int) $row['id_cat'];
		$par_cat = (int) $row['par_cat'];
		
		if(isset($row['name_cat_'. $_SESSION['code_lang']]))
		$name_cat = stripslashes(htmlspecialchars($row['name_cat_'. $_SESSION['code_lang']], ENT_QUOTES));
		
		if($par_cat == 0) 
		{
			if(!empty($id) && $id == $id_cat)
			echo '<option value="'. $id_cat .'" class="uppercase" selected>'. mb_strtoupper($name_cat) .'</option>';
			
			else echo '<option value="'. $id_cat .'" class="uppercase">'. mb_strtoupper($name_cat) .'</option>';
		}
	}	
	echo '</select>';
}

//////////////////////////////////////////////////
//Display ad price
//////////////////////////////////////////////////

function display_price($cat, $array)
{
	global $language, $param_gen;
	
	$price_par = '';
	$price_pro = '';
	
	foreach($array as $v)
	{
		if($v['id_cat'] == $cat)
		{
			$price_par = (float) $v['price_par'];
			$prix_par_display = number_format($price_par, 2, ',', ' ');
			$price_pro = (float) $v['price_pro'];
			$price_pro_display = number_format($price_pro, 2, ',', ' ');
		}
	}
	
	echo '<p>';
	
	if($price_par != 0)
	echo $language['form_price_par'] .' '. $prix_par_display .' '. $param_gen['currency'] .'<br />';
	
	else echo $language['form_price_par_free'] .'<br />';
	
	if($price_pro != 0)
	echo $language['form_price_pro'] .' '. $price_pro_display .' '. $param_gen['currency'];
	
	else echo $language['form_price_pro_free'];
	
	echo '</p>';
}

//////////////////////////////////////////////////
//Display digital options
//////////////////////////////////////////////////

function display_digital($cat, $array, $e)
{
	global $language, $cache_cat_opts, $cache_lang, $infos;
	
	foreach($cache_cat_opts as $opt)
	{
		$id_cat_opt = (int) $opt['id_cat_opt'];
		$type_cat_opt = (int) $opt['type_cat_opt'];
		$display = (int) $opt['display'];
		
		if($type_cat_opt != 1)
		continue;
				
		foreach($array as $row)
		{
			$id_cat = (int) $row['id_cat'];
			$id_cat_opt_digital = (int) $row['id_cat_opt'];
			
			$name_cat_opt = '';
			$unit_cat_opt = '';
			$optional = '';
			
			if($id_cat_opt_digital == $id_cat_opt)
			{
				if(isset($opt['name_cat_opt_'. $_SESSION['code_lang']]))
				$name_cat_opt = stripslashes(htmlspecialchars($opt['name_cat_opt_'. $_SESSION['code_lang']], ENT_QUOTES));
						
				if(isset($opt['unit_cat_opt_'. $_SESSION['code_lang']]))
				$unit_cat_opt = stripslashes(htmlspecialchars($opt['unit_cat_opt_'. $_SESSION['code_lang']], ENT_QUOTES));
				
				$optional = (int) $opt['optional'];
			
				if(isset($_POST['digital_'. $id_cat_opt_digital]))
				$value = stripslashes(htmlspecialchars($_POST['digital_'.$id_cat_opt_digital], ENT_QUOTES));
				
				elseif(isset($infos['digital_'. $id_cat_opt_digital]))
				$value = stripslashes(htmlspecialchars($infos['digital_'. $id_cat_opt_digital], ENT_QUOTES));
		
				else $value = '';
				
				if($id_cat == $cat)
				{
					$value = !empty($value)  && is_numeric($value) && $display > 0 ? number_format($value, $display, '.', '') : $value;
					
					if(isset($e['digital_'. $id_cat_opt_digital]))
					echo '<div><input type="text" id="digital_'. $id_cat_opt_digital .'" class="short form-error" name="digital_'. $id_cat_opt_digital .'" placeholder="'. $name_cat_opt .'" value="'. $value .'" /><span>'. $unit_cat_opt;
					
					else echo '<div><input type="text" id="digital_'. $id_cat_opt_digital .'" class="short" name="digital_'. $id_cat_opt_digital .'" placeholder="'. $name_cat_opt .'" value="'. $value .'" /><span>'. $unit_cat_opt;
				
					if($optional == 1)
					echo ' &nbsp;'. $language['form_video_optional']; 
					
					echo '</span></div>';
					break;
				}
			}
		}
	}
}

//////////////////////////////////////////////////
//Display data options
//////////////////////////////////////////////////

function display_data($cat, $array, $e)
{
	global $language, $cache_val_data, $cache_cat_opts, $cache_lang, $infos;
	
	foreach($cache_cat_opts as $opt)
	{
		$id_cat_opt = (int) $opt['id_cat_opt'];
		$type_cat_opt = (int) $opt['type_cat_opt'];
		
		if($type_cat_opt != 2)
		continue;
				
		$i = 1;
		
		foreach ($array as $row)
		{ 
			$id_cat = (int) $row['id_cat'];
			$id_cat_opt_data = (int) $row['id_cat_opt'];
			
			if($id_cat_opt_data == $id_cat_opt)
			{
				if(isset($opt['name_cat_opt_'. $_SESSION['code_lang']]))
				$name_cat_opt = stripslashes(htmlspecialchars($opt['name_cat_opt_'. $_SESSION['code_lang']], ENT_QUOTES));
					
				$optional = (int) $opt['optional'];
					
				if($id_cat == $cat)
				{
					$error = (isset($e['data_'. $id_cat_opt_data])) ? ' form-error' : '';
					
					echo '<div><select id="options_child_'. $i .'" name="data_'. $id_cat_opt_data .'" class="short'. $error .'" onchange="DisplayOptionsChild('. $i .');">
					<option value="0">'. $name_cat_opt .'</option>';
					
					foreach($cache_val_data as $row)
					{
						$id_val_data = (int) $row['id_val_data'];
						$id_opt_data = (int) $row['id_cat_opt'];
						
						if(isset($row['val_data_'. $_SESSION['code_lang']]))
						$val_data = stripslashes(htmlspecialchars($row['val_data_'. $_SESSION['code_lang']], ENT_QUOTES));
						
						if($id_cat_opt_data == $id_opt_data)
						{
							if(isset($_POST['data_'. $id_cat_opt_data]) && $_POST['data_'. $id_cat_opt_data] == $id_val_data)
							echo '<option value="'. $_POST['data_'. $id_cat_opt_data] .'" selected>'. $val_data .'</option>';
							
							elseif(!isset($_POST['data_'. $id_cat_opt_data]) && isset($infos['data_'. $id_cat_opt_data]) && $infos['data_'. $id_cat_opt_data] == $id_val_data)
							echo '<option value="'. $infos['data_'. $id_cat_opt_data] .'" selected>'. $val_data .'</option>';
							
							else echo '<option value="'. $id_val_data .'">'. $val_data .'</option>';
						}
					}
					
					echo '</select>';
					
					if($optional == 1)
					echo '<span class="optional">'. $language['form_video_optional'] .'</span>'; 
					
					echo '</div>';
					
					echo '<div id="options_child_form_'. $i .'">';
					
					if(isset($_POST['data_'. $id_cat_opt_data]))
					display_child_data($_POST['data_'. $id_cat_opt_data], $cache_cat_opts, $e);
					
					elseif(isset($infos['data_'. $id_cat_opt_data]))
					display_child_data($infos['data_'. $id_cat_opt_data], $cache_cat_opts, $e);
					
					echo '</div>';
					break;
				}
			}
			$i++;
		}
	}
}

//////////////////////////////////////////////////
//Display checkbox options
//////////////////////////////////////////////////

function display_checkbox($cat, $array, $e)
{
	global $language, $cache_val_check, $cache_cat_opts, $cache_lang, $infos;
	
	foreach($cache_cat_opts as $opt)
	{
		$id_cat_opt = (int) $opt['id_cat_opt'];
		$type_cat_opt = (int) $opt['type_cat_opt'];
		
		if($type_cat_opt != 3)
		continue;
		
		foreach($array as $row)
		{ 
			$id_sea_check = (int) $row['id_sea_check'];
			$id_cat = (int) $row['id_cat'];
			$id_cat_opt_check = (int) $row['id_cat_opt'];
			
			if($id_cat_opt_check == $id_cat_opt)
			{
				if(isset($opt['name_cat_opt_'. $_SESSION['code_lang']]))
				$name_cat_opt = stripslashes(htmlspecialchars($opt['name_cat_opt_'. $_SESSION['code_lang']], ENT_QUOTES));
			
				if($id_cat == $cat)
				{
					echo '<p class="bold"><label for="'. $name_cat_opt .'">'. $name_cat_opt .'</label></p>';
					
					$i = 0;
					
					foreach($cache_val_check as $row)
					{
						$id_val_check = (int) $row['id_val_check'];
						$id_opt_check = (int) $row['id_cat_opt'];
						
						if(isset($row['val_check_'. $_SESSION['code_lang']]))
						$val_check = stripslashes(htmlspecialchars($row['val_check_'. $_SESSION['code_lang']], ENT_QUOTES));
								
						if($id_cat_opt_check == $id_opt_check)
						{
							echo '<p>';
							
							if(isset($_POST['check_'. $id_val_check]) && $_POST['check_'. $id_val_check] == $id_val_check)
							{
							?> 
								<input type="checkbox" id="<?php echo 'check_'. $id_val_check; ?>" name="<?php echo 'check_'. $id_val_check; ?>" value="<?php echo $_POST['check_'. $id_val_check]; ?>" checked />
								<label for="<?php echo 'check_'. $id_val_check; ?>"><?php echo ucfirst($val_check); ?></label>
							<?php
							}
							elseif(count($_POST) == 0 && isset($infos['check_'. $id_val_check]) && $infos['check_'. $id_val_check] == $id_val_check)
							{
							?> 
								<input type="checkbox" id="<?php echo 'check_'. $id_val_check; ?>" name="<?php echo 'check_'. $id_val_check; ?>" value="<?php echo $infos['check_'. $id_val_check]; ?>" checked />
								<label for="<?php echo 'check_'. $id_val_check; ?>"><?php echo ucfirst($val_check); ?></label>
							<?php
							}
							else
							{
							?>
								<input type="checkbox" id="<?php echo 'check_'. $id_val_check; ?>" name="<?php echo 'check_'. $id_val_check; ?>" value="<?php echo $id_val_check; ?>" />
								<label for="<?php echo 'check_'. $id_val_check; ?>"><?php echo ucfirst($val_check); ?></label>
							<?php
							}
							
							echo '</p>';
							
							$i++;
						}
					}
					break;
				}
			}
		}
	}
}

//////////////////////////////////////////////////
//Display data child options
//////////////////////////////////////////////////

function display_child_data($id_val, $array, $e)
{
	global $language, $cache_val_data, $cache_lang, $cache_cat_opts, $infos;
	
	$id_val_data = 0;
	
	foreach($cache_val_data as $v)
	{
		$id_val_data = (int) $v['id_val_data'];
		$par_cat_opt = (int) $v['par_cat_opt'];
		
		if($id_val_data != $id_val)
		continue;
		
		else break;
	}
	
	if($id_val_data == $id_val)
	{
		foreach($array as $row)
		{
			$id_cat_opt = (int) $row['id_cat_opt'];
			$child_cat_opt = (int) $row['child_cat_opt'];
			$type_cat_opt = (int) $row['type_cat_opt'];
			
			if($type_cat_opt != 2 || $child_cat_opt != 1 || $par_cat_opt != $id_cat_opt)
			continue;
			
			if(isset($row['name_cat_opt_'. $_SESSION['code_lang']]))
			$name_cat_opt = stripslashes(htmlspecialchars($row['name_cat_opt_'. $_SESSION['code_lang']], ENT_QUOTES));
			
			$optional = (int) $row['optional'];
			
			$error = (isset($e['data_'. $id_cat_opt])) ? ' form-error' : '';
				
			echo '<div><select id="options_child_'. $id_cat_opt .'" name="data_'. $id_cat_opt .'" class="short'. $error .'" onchange="DisplayOptionsChild('. $id_cat_opt .');">
			<option value="0">'. $name_cat_opt .'</option>';
			
			foreach($cache_val_data as $row)
			{
				$id_val_data = (int) $row['id_val_data'];
				$id_opt_data = (int) $row['id_cat_opt'];
				
				if(isset($row['val_data_'. $_SESSION['code_lang']]))
				$val_data = stripslashes(htmlspecialchars($row['val_data_'. $_SESSION['code_lang']], ENT_QUOTES));
				
				if($id_opt_data == $id_cat_opt)
				{
					if(isset($_POST['data_'. $id_cat_opt]) && $_POST['data_'. $id_cat_opt] == $id_val_data)
					echo '<option value="'. $_POST['data_'. $id_cat_opt] .'" selected>'. $val_data .'</option>';
					
					elseif(!isset($_POST['data_'. $id_cat_opt]) && isset($infos['data_'. $id_cat_opt]) && $infos['data_'. $id_cat_opt] == $id_val_data)
					echo '<option value="'. $infos['data_'. $id_cat_opt] .'" selected>'. $val_data .'</option>';
					
					else echo '<option value="'. $id_val_data .'">'. $val_data .'</option>';
				}
			}
			
			echo '</select>';
			
			if($optional == 1)
			echo '<span class="optional">'. $language['form_video_optional'] .'</span>'; 
			
			echo '</div>';
			
			echo '<div id="options_child_form_'. $id_cat_opt .'">';
			
			if(isset($_POST['data_'. $id_cat_opt]))
			display_child_data($_POST['data_'. $id_cat_opt], $cache_cat_opts, $e);
			
			elseif(isset($infos['data_'. $id_cat_opt]))
			display_child_data($infos['data_'. $id_cat_opt], $cache_cat_opts, $e);
			
			echo '</div>';
		}
	}
}

//////////////////////////////////////////////////
//Display fields
//////////////////////////////////////////////////

function display_fields($cat, $array, $e)
{
	global $language, $cache_val_check, $cache_cat_opts, $cache_lang, $infos;
	
	foreach($array as $v)
	{	
		$id_field = (int) $v['id_field'];
		$id_cat = (int) $v['id_cat'];
		$type = (int) $v['type'];
		$optional = $v['optional'];
		
		if(isset($v['name_field_'. $_SESSION['code_lang']]))
		$name_field = stripslashes(htmlspecialchars($v['name_field_'. $_SESSION['code_lang']], ENT_QUOTES));
				
		$placehoder = ($type != 3) ? $name_field : 'http://';
		
		if($id_cat == $cat)
		{
			if($type == 3)
			echo '<p class="p-field">'. $name_field .'</p>';
		?>
		<div><input type="text" id="<?php echo 'field_'. $id_field; ?>" class="short <?php if(isset($e['field_'. $id_field])) echo 'form-error'; ?>" name="<?php echo 'field_'. $id_field; ?>" placeholder="<?php echo $placehoder; ?>" value="<?php if(isset($_POST['field_'. $id_field])) echo htmlspecialchars($_POST['field_'. $id_field]); elseif(!empty($infos['field_'. $id_field])) echo htmlspecialchars($infos['field_'. $id_field]); ?>" /> 
		<?php if($optional == 0) echo '<span>'. $language['form_video_optional'] .'</span>'; ?></div>
		<?php
		}
	}
}

//////////////////////////////////////////////////
//Googel valid captcha
//////////////////////////////////////////////////

function validCaptcha($data) {
	global $param_api_gg;
	$params = ['secret' => $param_api_gg['gg_recaptcha_secret_key'], 'response'  => $data];
	$url = "https://www.google.com/recaptcha/api/siteverify?".http_build_query($params);
	$response = file_get_contents($url);
	$result = json_decode($response);
	return $result->success;
}