$root=$DOCUMENT_ROOT;
require ("$root"."/templates/main.inc");
$category_id=12;
$subcat=2;
if ($list==1) {$heading=$subcategory='до 1000'; $ups_query='ups_reviews.power_va < 1000';}
elseif ($list==2) {$heading=$subcategory='от 1000 до 3000'; $ups_query='ups_reviews.power_va >= 1000 AND ups_reviews.power_va < 3000';}
else {$heading=$subcategory='более 3000';  $ups_query='ups_reviews.power_va >= 3000';}
$title='ИБП '.$heading.'. ИБП APC,Chloride,Eline,Invensys,Ippon,MGE,Mustek,NeuHaus,OPTI,PowerCom,Riello.';
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();
?>
			  | 
			Модель | 
			Топология | 
			Окно входных напряжений | 
			Возможность замены батареи пользователем/ в горячем режиме | 
			Время поддержки 100%-нагрузки  мин. | 
			Вес (кг.) | 
			Выходные разъемы IEC | 
			Емкость и количество батарей | 
			Оценка | 
		
		
			| 320 | 
			RJ-45 | 
			RS-232 | 
			RS-232 | 
			RJ-11 | 
		
		
		$i=0;
		$category_dir='ups';
		$query="
		SELECT 
		ups_reviews.id,
		ups_reviews.manufacturer,
		ups_reviews.filename,
		ups_reviews.heading,
		ups_reviews.review,
		ups_reviews.active, 
		ups_reviews.power_va,
		ups_reviews.power_w,
		ups_reviews.topology,
		ups_reviews.window_min,
		ups_reviews.window_max,
		ups_reviews.change_user,
		ups_reviews.change_hot,
		ups_reviews.support_time,
		ups_reviews.weight,
		ups_reviews.socket_320,
		ups_reviews.socket_rj45,
		ups_reviews.socket_rs232,
		ups_reviews.socket_usb,
		ups_reviews.socket_rj11,
		ups_reviews.capacity,
		ups_reviews.quantity,
		ups_topology.id,
		ups_topology.name,
		ups_change_user.id,
		ups_change_user.name,
		ups_change_hot.id,
		ups_change_hot.name,
		manufacturers.id,
		manufacturers.name,
		manufacturers.directory,
		manufacturers.kind,
		ups_reviews.opinion_mark 
		FROM ups_reviews 
		LEFT JOIN manufacturers ON manufacturers.id=ups_reviews.manufacturer 
		LEFT JOIN ups_topology ON ups_topology.id=ups_reviews.topology 
		LEFT JOIN ups_change_user ON ups_change_user.id=ups_reviews.change_user 
		LEFT JOIN ups_change_hot ON ups_change_hot.id=ups_reviews.change_hot 
		WHERE ups_reviews.active=1 AND manufacturers.kind='$cat' AND ";
		$query.=$ups_query ." ORDER BY manufacturers.name,ups_reviews.heading";
		$result=mysql_query($query,$db);
		
		while ($row_array = mysql_fetch_array ($result)) {
			if ($i==0) {$bgcolor='white'; $i++;} else {$bgcolor='#e7e7e7'; $i--;}
			$row_array[9]=converter("$row_array[9]");
			$row_array[10]=converter("$row_array[10]");
			$row_array[20]=converter("$row_array[20]");
			$row_array[21]=converter("$row_array[21]");
			$row_array[25]=converter("$row_array[25]");
			$row_array[27]=converter("$row_array[27]");
			echo " | $row_array[29] $row_array[3] | $row_array[23] | $row_array[9]...$row_array[10] | $row_array[25] | $row_array[27] | $row_array[13] | $row_array[14] | $row_array[15] | $row_array[16] | $row_array[17] | $row_array[18] | $row_array[19] | $row_array[20] | $row_array[21] | ".convert_zero("$row_array[32]")." | 
\n";
		}
stop_show();
print_main_table_end();
print_copyright_table();
print_footer_table();
?>