<?
	$ret = GetFile(DEFAULT_TEMPLATE.'index'.TPL_EX);

	if($_SESSION[type_offers] == 1)
	{
		$ret = EnableInTemplate("activ_buy", $ret);
	}
	elseif($_SESSION[type_offers] == 2)
	{
		$ret = EnableInTemplate("activ_sell", $ret);
	}
	elseif($_SESSION[type_offers] < 1)
	{
		$ret = EnableInTemplate("none_selected", $ret);
	}

	$category = GetFromTemplate("category", $ret);

	GetAllCategoriesByTemplate($category, $all_categories, $_POST[cat_id]);

	if($all_categories)
	{
		$ret = EnableInTemplate("select_category", $ret);
		$ret = InsertIntoTemplate("category", $all_categories, $ret);
	}

	//$no_login = GetFromTemplate("login_hidden", $ret);


	//ezicite ...
	$curl = curl();
		//if(strlen($curl)<1)
		//die($curl);
	$url = '?'.$curl;

	$ret = str_replace("{url}", $url, $ret);
	$ret =  str_replace("{bg_lang}",$url.'&lang=1' , $ret);
	$ret =  str_replace("{en_lang}",$url.'&lang=2' , $ret);
	
	$result = db_query("SELECT COUNT(id) FROM massage WHERE company_id_recever='$_SESSION[company_id]' AND is_read='0'");
	$row = db_fetch_row($result);
	$ret = str_replace("{count_unread}", $row[0], $ret);
	
	return $ret;
?><?
global $count;
$ret = GetFile(DEFAULT_TEMPLATE.'front'.TPL_EX);

$one = GetFromTemplate('one_list',$ret);
$one_subcat = GetFromTemplate('one_list_subcategories',$ret);
$query = "SELECT * FROM categories WHERE parent_cat='0' ORDER BY priority DESC";
$result = db_query($query);
$num=1;

if($_SESSION[lang_id] == 1)
{
	$lng = '';
}
elseif($_SESSION[lang_id] == 2)
{
	$lng = '_en';
}

while($row=db_fetch_array($result))
{
	$count = 0;
	all_count_offers($row[cat_id]);
	$row[count] = $count; //iz4islqvane na broq na vsi4ki oferti na glavnata kategoriq
	
	
	$temp = $one;
	//za da izvle4em pod kategoriite ..
	/*
	$query =    "SELECT *, count(offers.id) AS coffers FROM categories 
				LEFT JOIN offers ON offers.categories_id = categories.cat_id
				WHERE categories.parent_cat='$row[cat_id]' 
				GROUP BY categories.cat_id
				ORDER by coffers DESC
				LIMIT 0, ".COUNT_SUBCATS_PER_FRONT_PAGE."
				";
	*/
	$query =    "SELECT *, count(offers.id) AS coffers FROM categories 
				LEFT JOIN offers ON offers.categories_id = categories.cat_id
				WHERE categories.parent_cat='$row[cat_id]' 
				GROUP BY categories.cat_id
				ORDER by coffers DESC
				";
				//die($query);
	$result_sub = db_query($query);
	$all_subcat = '';
	$count_rows = db_num_rows($result_sub);
	if(db_num_rows($result_sub) > 0)
	{
		while($inner_row = db_fetch_array($result_sub))
		{
			$inner_row[nid] = $inner_row[cat_id];
			$inner_row[cat_name] = $inner_row["cat_name".$lng];
			$temp_subcat = $one_subcat;
			$temp_subcat = parse_db_to_template($inner_row, $temp_subcat);
			$all_subcat .= $temp_subcat;
		}
	}
	
	$all_subcat = substr($all_subcat, 0, -2);
	
	$temp = InsertIntoTemplate('one_list_subcategories',$all_subcat,$temp);
	//za da izvle4em pod kategoriite .. end
	$row[nid] = $row[cat_id];
	$row[num] = $num;
	$temp = parse_db_to_template($row,$temp);
	
	$all .= $temp;
	$num++;
}
$ret = InsertIntoTemplate('one_list',$all,$ret);


$query = "
SELECT * FROM offers ORDER BY addedtime DESC LIMIT 0,4";
$result = db_query($query);

if(db_num_rows($result))
{
	$ret = EnableInTemplate("view_last_offers", $ret);
	$offer = GetFromTemplate("offer", $ret);
	$all = '';
	while($row = db_fetch_array($result))
	{
		$temp = $offer;
		if($row[pics] != 0) 
		{
			$pics_array = explode(",", $row[pics]);
			$pic = $pics_array[0]; 
			$row[imgpath] = MODULE_WEBPATH."image.php?file_id=$pic";
		}
		else
		{
			$row[imgpath] = MODULE_WEBPATH."image.php?file_id=0";
		}
		$row[offerid] = $row[id];
		$temp = parse_db_to_template($row,$temp);
		$all .=  $temp;
	}
	$ret = InsertIntoTemplate("offer", $all, $ret);
}
return $ret;
?>1