$root=$DOCUMENT_ROOT;
require ("$root"."/templates/main.inc");
$category_id=13;
$subcategory_id=41;
$subcat=2;
$add_query='';
$heading='';
if ((isset($search)) && (isset($wan_count))  && (isset($wan))) {
	$wan_count	=	intval($wan_count);
	$wan	=	intval($wan);
	
	$heading.=$subcategory=' (подбор по параметрам)'; 
	if ($wan_count) {
		$add_query='router_reviews.wan_count='.$wan_count.' AND ';
	}
	if ($wan) {
		$add_query.='router_reviews.wan='.$wan.' AND ';
	}
}
$title='Маршрутизаторы'.$heading.'. Маршрутизаторы 3Com,D-Link и др.';
bd_connect();
get_category_info($category_id,$subcategory_id);
print_header($category,$subcategory,$heading,$headspecial,$bodyspecial);
print_official_table(0);
print_menu_table(1);
print_subcategory_table($category_link,$category,$subcategory_link,$subcategory,$heading);
echo '
Маршрутизаторы'.$heading.'
';
print_main_table_start();
start_show();
?>
			  | 
			Модель | 
			Порты WAN | 
			Порты LAN | 
			Протоколы | 
			QoS | 
			VLAN | 
			Управление | 
			Корпус | 
			Примечание | 
		
		
			| число | 
			тип | 
			число | 
			тип | 
		
		
		$i=0;
		$directory='net/router';
		$query="
		SELECT 
		router_reviews.id,
		router_reviews.manufacturer,
		router_reviews.filename,
		router_reviews.heading,
		router_reviews.review,
		router_reviews.active, 
		manufacturers.id,
		manufacturers.name,
		manufacturers.directory,
		manufacturers.kind,
		router_reviews.data,
		router_reviews.comments,
		router_reviews.icase,
		router_reviews.qos,
		router_reviews.wan,
		router_reviews.vlan,
		router_reviews.lan,
		router_reviews.wan_count,
		router_reviews.lan_count,
		router_reviews.protocols,
		router_case.id,
		router_case.name,
		router_wan.id,
		router_wan.name,
		router_vlan.id,
		router_vlan.name,
		router_lan.id,
		router_lan.name,
		router_reviews.managing 
		FROM router_reviews 
		LEFT JOIN manufacturers ON manufacturers.id=router_reviews.manufacturer 
		LEFT JOIN router_case ON router_case.id=router_reviews.icase
		LEFT JOIN router_wan ON router_wan.id=router_reviews.wan
		LEFT JOIN router_vlan ON router_vlan.id=router_reviews.vlan
		LEFT JOIN router_lan ON router_lan.id=router_reviews.lan
		WHERE router_reviews.active=1 AND ";
		$query.=$add_query ." manufacturers.kind='$cat' 
		ORDER BY manufacturers.name,router_reviews.heading";
		$result=mysql_query($query,$db);
		while ($row_array = mysql_fetch_array ($result)) {
			if ($i==0) {$bgcolor='white'; $i++;} else {$bgcolor='#e7e7e7'; $i--;}
			echo "
			
			 | $row_array[7] $row_array[3] | 
			$row_array[17] | $row_array[23] | $row_array[18] | $row_array[27] | 
			$row_array[19] | $row_array[13] | $row_array[25] | $row_array[28] | $row_array[21] | 
			$row_array[11] | 
			
\n";
		}
stop_show();
if (!mysql_num_rows($result)) {
	echo 'К сожалению, по Вашему запросу не найдено ни одной записи.
';
}
print_main_table_end();
print_copyright_table();
print_footer_table();
?>