function addr_id_full($id)
{
global $table_street_name;
global $table_street_num;
global $table_node;
global $table_pq;
global $table_location;
global $table_room;
$sql = "SELECT s_name.name AS street_name,\r\n\t \ts_name.small_name AS street_small_name,\r\n\t \ts_num.num AS street_num,\r\n\t \tloc.location AS location,\r\n\t \troom.room AS room,\r\n\t \tn1.*,p1.id AS pq_id\r\n\t \tFROM " . $table_street_name . " AS s_name,\r\n\t \t" . $table_street_num . " AS s_num,\r\n\t \t" . $table_node . " AS n1\r\n\t \tLEFT JOIN " . $table_pq . " AS p1 ON n1.id = p1.node\r\n\t \tLEFT JOIN " . $table_location . " AS loc ON n1.location_id = loc.id\r\n\t \tLEFT JOIN " . $table_room . " AS room ON n1.room_id = room.id\r\n\t \tWHERE n1.street_id = s_name.id\r\n\t \tAND n1.street_num_id = s_num.id\r\n\t \tAND n1.id=" . $id;
$result = pg_fetch_assoc(pg_query($sql), 0);
$name = $result['street_name'];
return addr($name, $result['street_num'], $result['num_ent'], $result['location'], $result['room']);
}
// подсветка для ПТО
if ($_SESSION['group'] <= 5) {
$content .= '<td class="span1' . ($row['key_num'] ? ' bg-color-green' : '') . '" ' . ($row['key_num'] ? 'title="Ключ № ' . $row['key_num'] . '"' : '') . '><a href="engine/map.php?id=' . $row['id'] . '" target="_blank">' . $i . '.</a>';
} else {
$content .= '<td class="span1" ' . ($row['key_num'] ? 'title="Ключ № ' . $row['key_num'] . '"' : '') . '>' . $i . '.';
}
$content .= '</td><td class="span5 ';
// подсветка для ПТО
if ($_SESSION['group'] <= 5) {
$content .= $row['incorrect'] == true ? ' bg-color-orangeDark' : (!$row['pq_id'] ? ' bg-color-orange' : '');
}
$content .= '">';
if ($group_access['pq']) {
$content .= '<a id="addr" href="?act=s_pq&node_id=' . $row['id'] . '" ' . ($_SESSION['group'] == 0 ? 'title="' . $row['user_id'] . '"' : '') . '>' . addr($row['street_name'], $row['street_num'], $row['num_ent'], $row['location'], $row['room']) . '</a>';
} else {
$content .= addr($row['street_name'], $row['street_num'], $row['num_ent'], $row['location'], $row['room']);
}
$content .= '</td>';
// подсветка статуса заполнения паспорта узла
$content .= '<td class="span1';
if ($row['box'] == 'f' && $row['sw'] == 'f' && $group_access['p_node'] && $row['type'] == 0) {
$content .= ' bg-color-orangeDark" title="Паспорт узла не заполнен"';
} else {
if ($row['box'] == 't' && $row['sw'] == 'f' && $group_access['p_node'] && $row['type'] == 0) {
$content .= ' bg-color-blueLight" title="Коммутатор не задан"';
} else {
if ($row['box'] == 'f' && $row['sw'] == 't' && $group_access['p_node'] && $row['type'] == 0) {
$content .= ' bg-color-blue" title="Ящик/рама не заданы"';
} else {
$content .= '" title="Информация занесена"';
}
return $ip;
} else {
$ip = getenv('REMOTE_ADDR');
return $ip;
}
}
if (!isset($_GET['port']) || !is_numeric($_GET['port']) || !isset($_GET['id'])) {
echo "-1";
} else {
$socket = @socket_create(AF_INET, SOCK_STREAM, SOL_TCP);
if ($socket < 0) {
echo "-1";
return;
}
@socket_set_option($socket, SOL_SOCKET, SO_SNDTIMEO, array("sec" => 2, "usec" => 0));
$result = @socket_connect($socket, addr(), $_GET['port']);
if ($result == 0) {
echo "0";
} else {
if (socket_select($r = array($socket), $w = NULL, $f = NULL, 2) > 0) {
$retval = @socket_read($socket, 10000, PHP_NORMAL_READ);
#echo '"'.$retval.'"';
if (!strncmp($retval, "AMSNPING" . $_GET['id'], strlen("AMSNPING" . $_GET['id']))) {
echo "1";
} else {
echo "0";
}
} else {
#Timeout : it's not aMSN on the other end
echo "0";
}
