本文整理汇总了PHP中DbFetchRow函数的典型用法代码示例。如果您正苦于以下问题:PHP DbFetchRow函数的具体用法?PHP DbFetchRow怎么用?PHP DbFetchRow使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了DbFetchRow函数的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: TblHead
}
?>
<h2><?= $usrlbl ?> <?= $lstlbl ?></h2>
<?php
TblHead("$modgroup[$self]2",2);
if ($grp){
$query = GenQuery('users','s','*',$ord,'',array('groups'),array('&'),array($grp) );
}else{
$query = GenQuery('users','s','*',$ord );
}
$res = DbQuery($query,$link);
if($res){
$row = 0;
while( ($usr = DbFetchRow($res)) ){
if ($row % 2){$bg = "txta"; $bi = "imga";}else{$bg = "txtb"; $bi = "imgb";}
$row++;
list($cc,$lc) = Agecol($usr[5],$usr[6],$row % 2);
TblRow($bg);
?>
<th class="<?= $bi ?>">
<?=Smilie($usr[0]) ?><br><?= $usr[0] ?></th>
<td nowrap><?= $usr[3] ?></td>
<td nowrap><?= $usr[4] ?></td>
<td nowrap><?= $usr[7] ?></td>
<td bgcolor="#<?= $cc ?>"><?= (date($datfmt,$usr[5])) ?></td>
<td bgcolor="#<?= $lc ?>"><?= (date($datfmt,$usr[6])) ?></td>
<td>
<?php if( !($usr[2] & 1) ) { ?>
<form method="get">
示例2: TopoFloors
function TopoFloors($r, $c, $b, $siz = 0)
{
global $link, $dev, $img, $modgroup, $self, $v, $place, $netlbl, $acslbl, $porlbl, $frelbl, $refresh;
$query = GenQuery('locations', 's', 'id,x,y,ns,ew,locdesc', '', '', array('region', 'city', 'building'), array('=', '=', '='), array($r, $c, $b), array('AND', 'AND'));
$res = DbQuery($query, $link);
if (DbNumRows($res)) {
list($id, $x, $y, $ns, $ew, $des) = DbFetchRow($res);
echo "<h2>{$b} - {$des}</h2>\n";
} else {
echo "<h2>{$b} {$place['b']}</h2>\n";
}
echo "<table class=\"content fixed\">\n";
uksort($dev, "floorsort");
foreach (array_keys($dev) as $fl) {
echo "<tr>\n\t<td class=\"{$modgroup[$self]}2\" width=\"80\"><h3>\n";
if (!$siz) {
echo "<img src=\"img/stair.png\"><br>\n";
}
echo "{$fl}</h3>\n";
if (!$siz) {
$bas = "topo/" . preg_replace('/\\W/', '', $r) . '/' . preg_replace('/\\W/', '', $c) . '/' . preg_replace('/\\W/', '', $b) . '-' . preg_replace('/\\W/', '', $fl);
foreach (glob("{$bas}*") as $f) {
list($ico, $ed) = FileImg($f);
echo "{$ico} ";
}
}
echo "</td>\n";
$col = 0;
$prm = "";
ksort($dev[$fl]);
foreach (array_keys($dev[$fl]) as $rm) {
if ($prm != $rm) {
$bi = $bi == "imga" ? "imgb" : "imga";
}
$prm = $rm;
foreach (array_keys($dev[$fl][$rm]) as $d) {
$ip = $dev[$fl][$rm][$d]['ip'];
$po = $dev[$fl][$rm][$d]['po'];
$ty = $dev[$fl][$rm][$d]['ty'];
$di = $dev[$fl][$rm][$d]['ic'];
$co = $dev[$fl][$rm][$d]['co'];
$rk = $dev[$fl][$rm][$d]['rk'];
$mn = $dev[$fl][$rm][$d]['mn'];
$al = $dev[$fl][$rm][$d]['al'];
$sz = $dev[$fl][$rm][$d]['sz'];
$sk = $dev[$fl][$rm][$d]['sk'] > 1 ? "<img src=\"img/" . $dev[$fl][$rm][$d]['sk'] . ".png\" title=\"Stack\">" : "";
list($statbg, $stat) = StatusBg(1, $mn, $al, $bi);
$tit = $stat ? $stat : $ty;
$ud = urlencode($d);
$ur = urlencode($r);
$uc = urlencode($c);
$ub = urlencode($b);
$uf = urlencode($fl);
$um = urlencode($rm);
if ($col == $_SESSION['col']) {
$col = 0;
echo "</tr><tr><td> </td>\n";
}
if ($siz) {
echo "<td class=\"{$statbg}\" valign=\"top\"><center><img src=\"img/dev/{$di}.png\" title=\"{$ip}\"><br>{$d}</center></td>\n";
} else {
$ii = $refresh ? 0 : IfFree($d);
$inif = $ii ? "<div style=\"float:right\"><a href=\"Devices-Interfaces.php?in[]=device&op[]==&st[]={$ud}&co[]=AND&in[]=ifstat&op[]=<&st[]=3&co[]=AND&in[]=iftype&op[]=~&st[]=^(6|7|117)\$&col[]=imBL&col[]=ifname&col[]=device&col[]=linktype&col[]=ifdesc&col[]=alias&col[]=lastchg&col[]=inoct&col[]=outoct&ord=lastchg\"><img src=\"img/p45.png\" title=\"{$acslbl} {$porlbl} {$frelbl}\">{$ii}</a></div>" : '';
$rkv = $dev[$fl][$rm][$d]['ru'] ? "<a href=\"Topology-Table.php?reg={$ur}&cty={$uc}&bld={$ub}&fl={$uf}&rm={$um}\">{$rm}</a>" : $rm;
echo "<td class=\"{$statbg}\" valign=\"top\"><b>{$rkv}</b> {$rk} {$inif}<p><div style=\"text-align:center;\">\n";
echo "<a href=\"Devices-Status.php?dev={$ud}\">";
echo "<img src=\"" . ($img ? DevPanel($ty, $di, $sz) . "\" width=\"" . (preg_match('/^ph|^wa|^ca/', $di) ? 40 : 100) . "\"" : "img/dev/{$di}.png\"") . " title=\"{$tit}\"></a>{$sk}<br><b>{$d}</b><br>\n";
echo Devcli($ip, $po);
echo "<p>{$co}</div></td>\n";
}
$col++;
}
}
}
echo "</tr></table>\n";
}
示例3: rawurlencode
$bi = $bia;
} else {
$row = "1";
$bg = $bgb;
$bi = $bib;
}
$fs = rawurlencode(date("m/d/Y H:i:s", $istart));
$fe = rawurlencode(date("m/d/Y H:i:s", $iend));
echo "<tr bgcolor=#{$bg}>\n";
echo "<th bgcolor=#{$bi}><a href=Monitoring-Messages.php?ina=time&opa=%3E=&sta={$fs}&cop=AND&inb=time&opb=%3C&stb={$fe}>" . date("j.M G:i", $istart) . "</a></th><td>\n";
if ($det) {
$query = GenQuery('messages', 'g', 'level', '', '', array('time', 'time'), array('>=', '<'), array($istart, $iend), array('AND'));
$res = @DbQuery($query, $link);
if ($res) {
$nmsg = 0;
while ($m = @DbFetchRow($res)) {
$mbar = Bar($m[1], 0, 1);
echo "<a href=Monitoring-Messages.php?ina=time&opa=%3E=&sta={$fs}&cop=AND&inb=time&opb=%3C&stb={$fe}&lvl={$m['0']}>";
echo "<img src=img/16/" . $mico[$m[0]] . ".png title=\"" . $mlvl[$m[0]] . "\" border=0></a>{$mbar} \n";
$nmsg += $m[1];
}
if (!$nmsg) {
echo "<img src=img/16/fogy.png title=\"All Messages\"> ";
}
$tmsg += $nmsg;
echo "{$nmsg}</td></tr>\n";
@DbFreeResult($res);
} else {
print @DbError($link);
}
} else {
示例4: GenQuery
$query = GenQuery('locations', 's', 'id,x,y,comment', '', '', array('region', 'city', 'building'), array('=', '=', '='), array($reg, $cty, ''), array('AND', 'AND'));
$mapbg = TopoMap($reg);
$nam = $cty;
$com = "City with " . count(array_keys($lopt[$reg][$cty])) . " buildings on {$now}";
} elseif ($reg) {
$query = GenQuery('locations', 's', 'id,x,y,comment', '', '', array('region', 'city', 'building'), array('=', '=', '='), array($reg, '', ''), array('AND', 'AND'));
$nam = $reg;
$com = "Region with " . count(array_keys($lopt[$reg])) . " cities on {$now}";
} else {
$query = "";
}
if ($query) {
$res = @DbQuery($query, $link);
$nloc = @DbNumRows($res);
if ($nloc == 1) {
list($id, $x, $y, $com) = @DbFetchRow($res);
$loco = 1;
}
}
?>
<h1>Location Editor</h1>
<form method="get" action="<?php
echo $_SERVER['PHP_SELF'];
?>
" name="lof">
<table bgcolor=#000000 <?php
echo $tabtag;
?>
>
<tr bgcolor=#<?php
echo $bg1;
示例5: GenQuery
}
echo " >{$d['0']}\n";
}
@DbFreeResult($res);
} else {
print @DbError($link);
}
?>
</select>
<select multiple size=6 name="if[]">
<?php
if ($dv) {
$query = GenQuery('interfaces', 's', 'ifname,alias,comment', 'ifname', '', array('device'), array('='), array($dv));
$res = @DbQuery($query, $link);
if ($res) {
while ($i = @DbFetchRow($res)) {
echo "<OPTION VALUE=\"{$i['0']}\" ";
if (in_array($i[0], $if)) {
echo "selected";
}
echo " >{$i['0']} " . substr("{$i['1']} {$i['2']}\n", 0, 30);
}
@DbFreeResult($res);
}
}
?>
</select>
</th>
<td>
<INPUT type="checkbox" name="cpu" <?php
echo $cpu ? "checked" : "";
示例6: GenQuery
echo $bg2;
?>
>
<th colspan=2><img src=img/32/key.png><br>Serial #</th>
<th><img src=img/32/fiap.png><br>Type</th>
<th><img src=img/32/smil.png><br>Added by</th>
<th><img src=img/32/clock.png><br>Added on</th>
<th><img src=img/32/glob.png><br>Location</th>
<th><img src=img/32/idea.png><br>Action</th></tr>
<?php
$query = GenQuery('stock', 's', '*', 'type');
$res = @DbQuery($query, $link);
if ($res) {
$row = 0;
while ($dev = @DbFetchRow($res)) {
if ($row % 2) {
$bg = $bgb;
$bi = $bib;
} else {
$bg = $bga;
$bi = $bia;
}
$row++;
$img = "genh.png";
$ud = rawurlencode($dev[0]);
$da = date("j.M (G:i)", $dev[3]);
list($a1c, $a2c) = Agecol($dev[3], $dev[3], $row % 2);
echo "<tr bgcolor=#{$bg}><th bgcolor=#{$bi}><img src=img/16/" . $cico[$dev[5]] . ".png title=" . $stco[$dev[5]] . "></th><td>{$dev['0']}</td>\n";
echo "<td>{$dev['1']}</td><td>{$dev['2']}</td><td bgcolor=#{$a1c}>{$da}</td><td>{$dev['4']}</td>\n";
echo "<td align=center><a href={$_SERVER['PHP_SELF']}?del={$ud}><img src=img/16/bcnl.png border=0 onclick=\"return confirm('Delete {$dev['0']} from stock?')\" title=\"Delete this device!\"></a></td>\n";
示例7: GenQuery
<th><img src=img/32/powr.png title="PoE consumption in mW"><br>Power</th>
<th><img src=img/32/dev.png><br>Neighbour</th>
<th><img src=img/32/dumy.png><br>Interface</th>
<th><img src=img/32/idea.png><br>Action</th></tr>
</tr>
<?php
if ($typ) {
$query = GenQuery('links', 's', '*', 'ifname', '', array('type'), array('='), array($typ));
} else {
$query = GenQuery('links', 's', '*', 'ifname', '', array('device'), array('='), array($dv));
}
$res = @DbQuery($query, $link);
if ($res) {
$nli = 0;
$row = 0;
while ($l = @DbFetchRow($res)) {
$ud = urlencode($l[1]);
$un = urlencode($l[3]);
if ($row % 2) {
$bg = $bga;
$bi = $bia;
} else {
$bg = $bgb;
$bi = $bib;
}
$row++;
echo "<tr bgcolor=#{$bg}><td><a href=Devices-Status.php?dev={$ud}>{$l['1']}</a></td><td>{$l['2']}</td>\n";
echo "<th>{$l['6']}</th>\n";
echo "<td align=right>" . Zfix($l[5]) . "</td>\n";
echo "<td align=right>{$l['7']}</td>";
echo "<td><a href=Devices-Status.php?dev={$un}>{$l['3']}</a></td><td>{$l['4']} (Vlan{$l['9']} {$l['8']})</td>\n";
示例8: DbConnect
<head>
<title>NeDi Find Me</title>
<meta http-equiv="Content-Type" content="text/html;charset=iso-8859-1">
<link href="inc/print.css" type="text/css" rel="stylesheet">
<link rel="shortcut icon" href="img/favicon.ico">
</head>
<body>
<?php
$link = DbConnect($dbhost, $dbuser, $dbpass, $dbname);
$query = GenQuery('nodes', 's', 'nodes.*,location,speed,duplex,pvid,dinoct,doutoct,dinerr,douterr,dindis,doutdis,dinbrc', 'lastseen', '1', array('nodip'), array('='), array(ip2long($_SERVER[REMOTE_ADDR])), array(), 'LEFT JOIN devices USING (device) LEFT JOIN interfaces USING (device,ifname)');
$res = DbQuery($query, $link);
if ($res) {
$n = DbFetchRow($res);
if ($n[2]) {
$img = Nimg($n[3]);
$l = explode($locsep, $n[23]);
echo "<table class=\"mon2\">";
echo "<tr class=\"txta\"><th class=\"imga\" width=\"20\"><img src=\"img/oui/{$img}.png\" title=\"{$n['3']}\"></th><td><b>{$n['0']}</b></td><td class=\"mrn code\">{$n['2']}</td></tr>\n";
echo "<tr class=\"txtb\"><th class=\"imgb\" width=\"20\"><img src=\"img/16/net.png\" title=\"Network\"></th><td class=\"blu code\">" . long2ip($n[1]) . "</td><td class=\"prp code\">" . ($n[16] ? inet_ntop($n[16]) : '') . "</td></tr>\n";
echo "<tr class=\"txta\"><th class=\"imga\" width=\"20\"><img src=\"img/16/dev.png\" title=\"Device\"></th><td>{$n['6']}</td><td>{$l['2']} {$l['3']}</td></tr>\n";
echo "<tr class=\"txtb\"><th class=\"imgb\" width=\"20\"><img src=\"img/16/port.png\" title=\"Interface\"></th><td>{$n['7']}</td><td>" . DecFix($n[24]) . "-{$n['25']} vl{$n['8']}</td></tr>\n";
echo "<tr class=\"txta\"><th class=\"imga\" width=\"20\"><img src=\"img/16/grph.png\" title=\"In/Out\"></th><td colspan=\"2\">Traffic: <b class=\"blu code\">" . DecFix($n[27]) . "/" . DecFix($n[28]) . "</b> Errors:<b class=\"drd code\"> " . DecFix($n[29]) . "/" . DecFix($n[30]) . "</b> Discards:<b class=\"prp code\">" . DecFix($n[31]) . "/" . DecFix($n[32]) . " </b> Bcast:<b class=\"dgy code\"> " . DecFix($n[33]) . "</b></td></tr>\n";
echo "</table>";
} else {
echo "<h4>{$_SERVER['REMOTE_ADDR']} was not found</h4>";
}
DbFreeResult($res);
} else {
示例9: GenQuery
if ($ccc[1] == "") {
$color = "blue";
$ccc_message = "Unknown";
}
echo "<td align=right>-</td><td><b>$d[1]</b></td><td>$d[2]</td><td><font color=$color>$ccc_message</font></td></tr>\n";
$mquery = GenQuery('modules','s','*','slot','',array('device'),array('='),array($d[0]));
$mres = DbQuery($mquery,$link);
if($mres){
while( ($m = DbFetchRow($mres)) ){
if ($row % 2){$bg = "txta";}else{$bg = "txtb";}
$row++;
echo "<tr class=\"$bg\"><th>\n";
$query_ccc = "SELECT service_level,contract_number,end_date,DATEDIFF(STR_TO_DATE(end_date, '%d-%b-%Y'),CURDATE()) FROM cisco_contracts WHERE serial_number=\"$m[4]\"";
$res_ccc = DbQuery($query_ccc,$link_ccc);
$ccc = DbFetchRow($res_ccc);
if ($ccc[3] > 30) {
$color = "green";
$ccc_message = "$ccc[0]<br>Contract #$ccc[1] valid till $ccc[2]";
} elseif ($ccc[3] > 1) {
$color = "darkyellow";
$ccc_message = "$ccc[0]<br>Contract #$ccc[1] valid till $ccc[2]";
} else {
$color = "red";
$ccc_message = "$ccc[0]<br>Contract #$ccc[1] expired since $ccc[2]";
}
if ($ccc[1] == "") {
$color = "blue";
$ccc_message = "Unknown";
}
echo "<td align=right>$m[1]</td><td><b>$m[2]</b> $m[3]</td><td>$m[4]</td><td><font color=$color>$ccc_message</font></td></tr>\n";
示例10: while
<?php
$row = 0;
while ($s = @DbFetchRow($res)) {
if ($row % 2) {
$bg = $bga;
$bi = $bia;
} else {
$bg = $bgb;
$bi = $bib;
}
$row++;
$nquery = GenQuery('nodes', 's', '*', '', '', array('mac'), array('='), array($s[2]));
$nres = @DbQuery($nquery, $link);
$nnod = @DbNumRows($nres);
if ($nnod == 1) {
$n = @DbFetchRow($nres);
@DbFreeResult($nres);
} else {
$n = array($s[0], $s[1], $s[2], '-', 0, 0, 'Not in nodes', '-');
}
$dbna = preg_replace("/^(.*?)\\.(.*)/", "\$1", $n[0]);
$dbip = long2ip($n[1]);
$img = Nimg("{$n['2']};{$n['3']}");
$ls = date("r", $n[5]);
list($fc, $lc) = Agecol($n[4], $n[5], $row % 2);
$na = preg_replace("/^(.*?)\\.(.*)/", "\$1", $s[0]);
$ip = long2ip($s[1]);
$sup = date("r", $s[6]);
$simg = "";
list($s1c, $s2c) = Agecol($s[6], $s[6], $row % 2);
if ($n[5] > $s[6]) {
示例11: GenQuery
?>
</th><th width=80>
<input type="submit" value="Show">
</th>
</tr></table></form>
<?
if ($rtr) {
$query = GenQuery('devices','s','*','','',array('name'),array('='),array($rtr) );
$res = @DbQuery($query,$link);
$ndev = @DbNumRows($res);
if ($ndev != 1) {
echo "<h4>$rtr $n1rmsg</h4>";
@DbFreeResult($res);
die;
}else{
$dev = @DbFetchRow($res);
$ip = long2ip($dev[1]);
$sv = Syssrv($dev[6]);
$ud = rawurlencode($dev[0]);
@DbFreeResult($res);
?>
<h2>General Info</h2>
<table class="content">
<tr><th class="imga" width=80>
<a href=Devices-Status.php?dev=<?php
echo $ud;
?>
><img src="img/dev/<?php
echo $dev[18];
?>
.png" title="<?php
示例12: DbError
print DbError($lnk);
die;
}
$qry = GenQuery('devices', 's', 'count(*)', '', '', array('snmpversion'), array('='), array('0'));
$res = DbQuery($qry, $lnk);
if ($res) {
$ndv = DbFetchRow($res);
DbFreeResult($res);
} else {
print DbError($lnk);
die;
}
$qry = GenQuery('nodes', 's', 'count(*)');
$res = DbQuery($qry, $lnk);
if ($res) {
$nod = DbFetchRow($res);
DbFreeResult($res);
} else {
print DbError($lnk);
die;
}
if ($cu == "u") {
$cuf = 0.95;
$cul = 'USD';
$ibn = 'CH72 0070 0130 0072 8546 9';
} elseif ($cu == "e") {
$cuf = 1.2;
$cul = 'EUR';
$ibn = 'CH77 0070 0130 0079 5031 4';
} elseif ($cu == "c") {
$cuf = 1;
示例13: while
<?php
$row = 0;
while ($s = DbFetchRow($res)) {
if ($row % 2) {
$bg = "txta";
$bi = "imga";
} else {
$bg = "txtb";
$bi = "imgb";
}
$row++;
$nquery = GenQuery('nodes', 's', '*', '', '', array('mac'), array('='), array($s[2]));
$nres = DbQuery($nquery, $link);
$nnod = DbNumRows($nres);
if ($nnod == 1) {
$n = DbFetchRow($nres);
DbFreeResult($nres);
} else {
$n = array($s[0], $s[1], $s[2], '-', 0, 0, 'Not in nodes', '-');
}
$dbna = preg_replace("/^(.*?)\\.(.*)/", "\$1", $n[0]);
$dbip = long2ip($n[1]);
$img = Nimg("{$n['2']};{$n['3']}");
$ls = date("r", $n[5]);
list($fc, $lc) = Agecol($n[4], $n[5], $row % 2);
$na = preg_replace("/^(.*?)\\.(.*)/", "\$1", $s[0]);
$ip = long2ip($s[1]);
$sup = date("r", $s[6]);
$simg = "";
list($s1c, $s2c) = Agecol($s[6], $s[6], $row % 2);
if ($n[5] > $s[6]) {
示例14: GenQuery
?>
</table>
<table class="content">
<tr class="<?= $modgroup[$self] ?>2"><td><?= $row ?> Devices</td></tr>
</table>
<?php
}
}elseif($shc){
echo "<h2>$shc</h2>\n";
$query = GenQuery('configs','s','configs.*,inet_ntoa(devip),cliport','','',array('device'),array('='),array($shc),array(),'LEFT JOIN devices USING (device)');
$res = DbQuery($query,$link);
$cfgok = DbNumRows($res);
if ($cfgok == 1) {
$cfg = DbFetchRow($res);
DbFreeResult($res);
}else{
echo "<h4>$shc: $cfgok $vallbl</h4>";
die;
}
$ucfg = rawurlencode($cfg[0]);
$charr = explode("\n",$cfg[2]);
$charr = preg_replace("/^#(.*)$/","<span class='gry'>#$1</span>",$charr);
$charr = preg_replace("/(^\s*[0-9]{1,3}\-.*)$/","<span class='drd'>$1</span>",$charr);
$charr = preg_replace("/(^\s*[0-9]{1,3}\+.*)$/","<span class='olv'>$1</span>",$charr);
?>
<table class="content"><tr class="<?= $modgroup[$self] ?>2">
<th><img src="img/32/note.png"><br><?= $cfglbl ?> (<?= date($_SESSION['date'],$cfg[3]) ?>)</th>
<th><img src="img/32/news.png"><br><?= $chglbl ?></th></tr>
<tr class="txta"><td valign="top">
示例15: Layout
function Layout() {
global $link,$locsep,$resmsg;
global $xm,$ym,$xo,$yo,$len,$geo,$ina,$flt,$lev,$ipi;
global $mapbg,$rloc,$cloc,$bloc;
$net = array();
# Gather Device Info
if($ina == "vlan"){
$query = GenQuery('vlans','g','device','device','',array('vlanid'),array('regexp'),array($flt));
$res = @DbQuery($query,$link);
if($res){
while( ($vl = @DbFetchRow($res)) ){
$devs[] = preg_replace('/([\^\$+])/','\\\\\\\\$1',$vl[0]); # \Q...\E Doesn't seem to work in MySQL?
}
@DbFreeResult($res);
}else{
echo @DbError($link);
}
if (! is_array ($devs) ){echo $resmsg;die;}
$query = GenQuery('devices','s','name,ip,location,icon','','',array('name'),array('regexp'),array(implode("|",$devs)));
}elseif($ina == "network"){
$query = GenQuery('networks','g','device','device','',array('ip'),array('='),array($flt));
$res = @DbQuery($query,$link);
if($res){
while( ($net = @DbFetchRow($res)) ){
$devs[] = preg_replace('/([\^\$\*\+])/','\\\\\\\\$1',$net[0]);
}
@DbFreeResult($res);
}else{
echo @DbError($link);
}
if (! is_array ($devs) ){echo $resmsg;die;}
$query = GenQuery('devices','s','name,ip,location,icon','','',array('name'),array('regexp'),array(implode("|",$devs)));
}elseif($ina == "type"){
$query = GenQuery('devices','s','name,ip,location,icon','','',array('type'),array('regexp'),array($flt));
}else{
$query = GenQuery('devices','s','name,ip,location,icon','','',array('location'),array('regexp'),array($flt));
}
$res = @DbQuery($query,$link);
if($res){
while( ($d = @DbFetchRow($res)) ){
$l = explode($locsep, $d[2]);
if($lev == "c" or $lev == "C"){
$locs[$l[0]][$l[1]]++;
}elseif($lev == "b" or $lev == "B"){
$locs[$l[0]][$l[1]][$l[2]]++;
}else{
$locs[$l[0]][$l[1]][$l[2]][$l[3]][] = $d[0];
}
$dev['ip'] [$d[0]] = long2ip($d[1]);
$dev['ic'] [$d[0]] = $d[3];
$dev['reg'][$d[0]] = $l[0];
$dev['cty'][$d[0]] = $l[1];
$dev['bld'][$d[0]] = $l[2];
$dev['rom'][$d[0]] = $l[4];
}
@DbFreeResult($res);
}else{
echo @DbError($link);
}
if($ipi){
$query = GenQuery('networks');
$res = @DbQuery($query,$link);
if($res){
while( ($n = @DbFetchRow($res)) ){
$net[$n[0]][$n[1]] .= " ". long2ip($n[2]);
}
}else{
echo @DbError($link);
}
@DbFreeResult($res);
}
# Gather Link Info
$query = GenQuery('links');
$res = @DbQuery($query,$link);
if($res){
while( ($l = @DbFetchRow($res)) ){
if($dev[$l[1]]['ic'] and $dev[$l[3]]['ic']){ # both ends are ok, if an icon exists
if($lev == "f"){
if( isset($devlink[$l[3]][$l[1]]) ){ # opposite link doesn't exist?
$devlink[$l[3]][$l[1]]['nbw'][$l[3]][$l[4]][$l[1]][$l[2]] = $l[5];
}else{
$devlink[$l[1]][$l[3]]['bw'][$l[1]][$l[2]][$l[3]][$l[4]] = $l[5];
}
}
if($dev[$l[1]]['bld'] != $dev[$l[3]]['bld']) { # is it same bld?
$nbldlink[$dev[$l[1]]['bld']] ++;
$abldlink[$dev[$l[1]]['bld']][$dev[$l[3]]['bld']]++; # needed for Arranging.
if(isset($bldlink[$dev[$l[3]]['bld']][$dev[$l[1]]['bld']]) ){ # link defined already?
$bldlink[$dev[$l[3]]['bld']][$dev[$l[1]]['bld']]['nbw'][$l[3]][$l[4]][$l[1]][$l[2]] = $l[5];
}else{
$bldlink[$dev[$l[1]]['bld']][$dev[$l[3]]['bld']]['bw'][$l[1]][$l[2]][$l[3]][$l[4]] = $l[5];
}
}
if($dev[$l[1]]['cty'] != $dev[$l[3]]['cty']){ # is it same cty?
$nctylink[$dev[$l[1]]['cty']]++;
$actylink[$dev[$l[1]]['cty']][$dev[$l[3]]['cty']]++; # needed for Arranging.
//.........这里部分代码省略.........