| ";
foreach ($fields as $key=>$value){
if (isset($_SESSION['OCS']['ADMIN_CONSOLE'])){
if (isset($no_show['name'][$key]))
$icon=" |  | ";
else
$icon=" | ";
}else
$icon="";
$arg_result=$sql_field[$key]['ARG'];
if (isset($sql_field[$key]['SQL']))
$sql_result=$sql_field[$key]['SQL'];
else
$sql_result="select %s from %s %s";
if($table[$key] == 'hardware'){
if (isset($arg_result[2]) and $arg_result[2] != '')
$sql_result.=" and ".$no_groups_sql;
else
$sql_result.=" where ".$no_groups_sql;
}
if ($myids){
if (!in_array($key,$no_restrict)){
if ((isset($arg_result[2]) and $arg_result[2] != '')
or $table[$key] == 'hardware'
or (isset($sql_field[$key]['SQL']) and $sql_field[$key]['SQL']!= ''))
$sql_result.=" and ";
else
$sql_result.=" where ";
if ($table[$key] != 'hardware'
and $table[$key] != 'snmp'
and $table[$key] !='nk'){
$sql_result.=$table[$key].".hardware_id in ".$myids['SQL'];
}elseif ($table[$key] == 'hardware'){
$sql_result.=" id in ".$myids['SQL'];
}elseif ($table[$key] == 'snmp'){
}elseif($table[$key] == 'nk'){
$sql_result=substr($sql_result,0,-4);
}
if (is_array($sql_field[$key]['ARG'])){
$arg_result=array_merge($arg_result,$myids['ARG']);
}else{
$arg_result=$myids['ARG'];
}
}
}
if (!isset($_SESSION['OCS']['COUNT_CONSOLE'][$key])){
$res=mysql2_query_secure($sql_result,$_SESSION['OCS']["readServer"],$arg_result);
if ($res){
$count = mysql_fetch_object($res);
$_SESSION['OCS']['COUNT_CONSOLE'][$key]=$count->c;
}
}
if (isset($_SESSION['OCS']['COUNT_CONSOLE'][$key]) and is_numeric($_SESSION['OCS']['COUNT_CONSOLE'][$key])){
$id_count=$_SESSION['OCS']['COUNT_CONSOLE'][$key];
if (is_array($link[$key]) and $id_count != 0){
if (isset($link[$key]['PAGE'])){
$link_me_begin="'&fields=HARDWARE-LASTCOME&comp=tall&values='.date($l->g(1242))
$link_me_begin.="&fields=".$multi_search[$key]['FIELD']."&comp=".$multi_search[$key]['COMP']."&values=".$multi_search[$key]['VALUE']."&values2=".$multi_search[$key]['VALUE2']."&type_field=".$multi_search[$key]['TYPE_FIELD'];
}
$link_me_begin.="' target='_blank'>";
$link_me_end="";
}elseif (isset($link[$key]['RELOAD'])){
$link_me_begin="";
$link_me_end="";
}
}else{
$link_me_begin="";
$link_me_end="";
}
echo $value." | ".$link_me_begin.$id_count.$link_me_end." | ".$icon."