$root=$DOCUMENT_ROOT;
require ("$root"."/templates/main.inc");
$category_id=13;
$subcategory_id=46;
$subcat=2;
$add_query='';
$heading='Мосты, преобразователи среды и трансиверы';
if ($list==1) {}
if ($list==2) {$heading=$subcategory='Преобразователи среды (mediaconverters)'; $add_query='mediaconv_reviews.type=2';}
elseif ($list==3) {$heading=$subcategory='Мосты (bridges)'; $add_query='mediaconv_reviews.type=3';}
elseif ($list==4) {$heading=$subcategory='Приёмопередатчики (transcievers)'; $add_query='mediaconv_reviews.type=4';}
if ($add_query) {
	$add_query.=' AND ';
}
if ((isset($search)) && (isset($port_type))  && (isset($port1)) && (isset($port2))) {
	$port_type	=	intval($port_type);
	$port1	=	intval($port1);
	$port2	=	intval($port2);
	$subcategory=' (подбор по параметрам)'; 
	if ($port_type) {
		$add_query='mediaconv_reviews.type='.$port_type.' AND ';
	}
	if ($port1) {
		$add_query.='mediaconv_reviews.port1='.$port1.' AND ';
	}
	if ($port2) {
		$add_query.='mediaconv_reviews.port2='.$port2.' 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();
?>
			  | 
			Модель | 
			Категория | 
			Первый порт | 
			Второй порт | 
			Управление | 
			Примечание | 
		
		
			| тип | 
			дальность | 
			тип | 
			дальность | 
		
		
		$i=0;
		$directory='net/mediaconv';
		$query="
		SELECT 
		mediaconv_reviews.id,
		mediaconv_reviews.manufacturer,
		mediaconv_reviews.filename,
		mediaconv_reviews.heading,
		mediaconv_reviews.review,
		mediaconv_reviews.active, 
		manufacturers.id,
		manufacturers.name,
		manufacturers.directory,
		manufacturers.kind,
		mediaconv_reviews.data,
		mediaconv_reviews.comments,
		mediaconv_reviews.type,
		mediaconv_reviews.port1,
		mediaconv_reviews.port2,
		mediaconv_reviews.port1_count,
		mediaconv_reviews.port2_count,
		mediaconv_type.id,
		mediaconv_type.name,
		mediaconv_port1.id,
		mediaconv_port1.name,
		mediaconv_port2.id,
		mediaconv_port2.name,
		mediaconv_reviews.managing 
		FROM mediaconv_reviews 
		LEFT JOIN manufacturers ON manufacturers.id=mediaconv_reviews.manufacturer 
		LEFT JOIN mediaconv_type ON mediaconv_type.id=mediaconv_reviews.type
		LEFT JOIN mediaconv_port1 ON mediaconv_port1.id=mediaconv_reviews.port1
		LEFT JOIN mediaconv_port2 ON mediaconv_port2.id=mediaconv_reviews.port2
		WHERE mediaconv_reviews.active=1 AND ";
		$query.=$add_query ." manufacturers.kind='$cat' 
		ORDER BY manufacturers.name,mediaconv_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[18] | $row_array[20] | $row_array[15] | $row_array[22] | $row_array[16] | 
			$row_array[23] | $row_array[11] | 
			
\n";
		}
stop_show();
if (!mysql_num_rows($result)) {
	echo 'К сожалению, по Вашему запросу не найдено ни одной записи.
';
}
print_main_table_end();
print_copyright_table();
print_footer_table();
?>