$root=$DOCUMENT_ROOT;
require ("$root"."/templates/main.inc");
$category_id=13;
$subcategory_id=40;
$subcat=2;
$add_query='';
$heading='';
if ($list==1) {}
if ($list==2) {$heading=$subcategory='начального уровня'; $add_query='(switch_reviews.vlan=5) AND (switch_reviews.level=2) AND (switch_reviews.managing="")';}
elseif ($list==3) {$heading=$subcategory='настраиваемые'; $add_query='(switch_reviews.vlan!=5) AND (switch_reviews.level=2) AND (switch_reviews.managing="")';}
elseif ($list==4) {$heading=$subcategory='управляемые'; $add_query='(switch_reviews.level=2) AND (switch_reviews.managing!="")';}
elseif ($list==5) {$heading=$subcategory='уровня 3'; $add_query='switch_reviews.level=3';}
elseif ($list==6) {$heading=$subcategory='уровня 4'; $add_query='switch_reviews.level=4';}
elseif ($list==7) {$heading=$subcategory='уровня 7'; $add_query='switch_reviews.level=7';}
/*
elseif ($list==4) {$subcategory='Уровня 3'; $add_query='switch_reviews.level=3';}
elseif ($list==5) {$subcategory='Уровня 4'; $add_query='switch_reviews.level=4';}
elseif ($list==6) {$subcategory='Уровня 7'; $add_query='switch_reviews.level=5';}
*/
if ($add_query) {
$add_query.=' AND ';
}
if ((isset($search)) && (isset($port_count)) && (isset($port_type))) {
$port_count = intval($port_count);
$port_type = intval($port_type);
$heading.=$subcategory=' (подбор по параметрам)';
if ($port_count) {
$add_query='switch_reviews.port_hor_count='.$port_count.' AND ';
}
if ($port_type) {
$add_query.='switch_reviews.port_hor='.$port_type.' 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();
?>
Модель
OSI
Горизонтальные порты
Вертикальные порты
Функции
Стек
Управление
Корпус
Примечание
N
тип
PoE
N
тип
агрегирование
VLAN
STP
QoS
$i=0;
$directory='net/switch';
$query="
SELECT
switch_reviews.id,
switch_reviews.manufacturer,
switch_reviews.filename,
switch_reviews.heading,
switch_reviews.review,
switch_reviews.active,
manufacturers.id,
manufacturers.name,
manufacturers.directory,
manufacturers.kind,
switch_reviews.data,
switch_reviews.comments,
switch_reviews.level,
switch_reviews.icase,
switch_reviews.aggreg,
switch_reviews.vlan,
switch_reviews.stp,
switch_reviews.qos,
switch_reviews.port_hor,
switch_reviews.port_vert,
switch_reviews.port_hor_count,
switch_reviews.port_vert_count,
switch_level.id,
switch_level.name,
switch_case.id,
switch_case.name,
switch_aggreg.id,
switch_aggreg.name,
switch_vlan.id,
switch_vlan.name,
switch_stp.id,
switch_stp.name,
switch_qos.id,
switch_qos.name,
switch_port_hor.id,
switch_port_hor.name,
switch_port_vert.id,
switch_port_vert.name,
switch_reviews.stack,
switch_reviews.poe,
switch_poe.id,
switch_poe.name,
switch_reviews.managing
FROM switch_reviews
LEFT JOIN manufacturers ON manufacturers.id=switch_reviews.manufacturer
LEFT JOIN switch_level ON switch_level.id=switch_reviews.level
LEFT JOIN switch_case ON switch_case.id=switch_reviews.icase
LEFT JOIN switch_aggreg ON switch_aggreg.id=switch_reviews.aggreg
LEFT JOIN switch_vlan ON switch_vlan.id=switch_reviews.vlan
LEFT JOIN switch_stp ON switch_stp.id=switch_reviews.stp
LEFT JOIN switch_qos ON switch_qos.id=switch_reviews.qos
LEFT JOIN switch_port_hor ON switch_port_hor.id=switch_reviews.port_hor
LEFT JOIN switch_port_vert ON switch_port_vert.id=switch_reviews.port_vert
LEFT JOIN switch_poe ON switch_poe.id=switch_reviews.poe
WHERE switch_reviews.active=1 AND ";
$query.=$add_query ." manufacturers.kind='$cat'
ORDER BY manufacturers.name,switch_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 "