function us_AddressGetBuildAll($conn)
{
$result = array();
$query = "SELECT * from `build`";
$all = sqa($conn, $query);
if (!empty($all)) {
foreach ($all as $io => $each) {
$result[$each['id']]['id'] = $each['id'];
$result[$each['id']]['buildnum'] = $each['buildnum'];
$result[$each['id']]['streetid'] = $each['streetid'];
}
}
return $result;
}
$ln = $rs['VALUESTR'];
$rs2 = sq($conn2, "select VALUESTR from tbl_conf where PARAM='TRAFTX1'");
$ln2 = $rs2['VALUESTR'];
$pi1 = $ln2[0] - $ln[0];
//VALUESTR #VALUESTR
$pi_rxkbps = 0;
if ($pi1 > 0) {
$pi_rxkbps = $pi1 / $pi_interval / 1024 * 8;
}
nq($conn2, "update tbl_conf set VALUESTR=" . $pi_rxkbps . " where PARAM='TXKBPS'");
//=================================================================================================================
printlog("обновляем даты по максимальному пингу");
//Выясняем - нужно ли обновлять?
$pi1 = time() - 3600;
$pi2 = date("Y-m-d H:i:s", $pi1);
$rs = sqa($conn2, "select DATESTAT from tbl_pingtable where DATESTAT>'" . $pi2 . "'");
$pi_count = sizeof($rs);
//Если нужно - обновляем
if ($pi_count < 1) {
//Вычисляем сколько активных сейчас
$rs = sq($conn2, "select CODE from tbl_base where LASTPING>='" . $ps_activetime2 . "'");
$pi_count2 = sizeof($rs);
//Фиксируем данные
nq($conn2, "insert into tbl_pingtable (DATESTAT,COUNT) values (NOW()," . $pi_count2 . ")");
}
//=================================================================================================================
printlog("записываем дату обновления");
nq($conn2, "update tbl_conf set VALUEDATE=NOW() where PARAM='LASTUPDSCET'");
//=================================================================================================================
//=================================================================================================================
printlog("делаем запись в истории про обновление");
