本文整理汇总了PHP中DbError函数的典型用法代码示例。如果您正苦于以下问题：PHP DbError函数的具体用法？PHP DbError怎么用？PHP DbError使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了DbError函数的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: Map
function Map()
{
global $debug, $link, $locsep, $vallbl, $sholbl, $sumlbl, $imas, $fmt, $lit, $fsz, $pos;
global $xm, $ym, $xo, $yo, $rot, $cro, $bro, $len, $lsf, $mde, $in, $op, $st, $co, $lev, $loo, $loa, $loi, $ipi, $ifa;
global $mapbg, $mapitems, $maplinks, $mapinfo, $imgmap, $reg, $cty, $bld, $flr, $dev, $nod, $nlnk, $jnod, $cud;
$rlnk = array();
$clnk = array();
$blnk = array();
$dlnk = array();
$acol = '';
$join = '';
if ($pos == 'a') {
$acol = ',status';
$join .= 'LEFT JOIN monitoring USING (device) ';
}
if (in_array('vlanid', $in) or in_array('vlanname', $in)) {
$join .= 'LEFT JOIN vlans USING (device) ';
}
if (in_array('mac', $in) or in_array('nodip', $in) or in_array('name', $in) or in_array('oui', $in)) {
$join .= 'LEFT JOIN nodes USING (device) ';
}
if (in_array('ifip', $in) or in_array('vrfname', $in)) {
$join .= 'LEFT JOIN networks USING (device) ';
}
if (in_array('neighbor', $in)) {
$join .= 'LEFT JOIN links USING (device) ';
}
$query .= GenQuery('devices', 's', "distinct device,devip,type,location,contact,devmode,icon,cpu,temp,devopts,size,stack{$acol},snmpversion", '', '', $in, $op, $st, $co, $join);
# Postgres requires ordercolumn (snmpversion)!
if ($lev < 5) {
if (strpos($query, 'WHERE')) {
$query .= ' AND snmpversion != 0';
} else {
$query .= ' WHERE snmpversion != 0';
}
}
$query .= ' order by snmpversion desc';
$res = DbQuery($query, $link);
if ($res) {
while ($d = DbFetchRow($res)) {
$l = explode($locsep, $d[3]);
$reg[$l[0]]['ndv']++;
$cty[$l[0]][$l[1]]['ndv']++;
$dev[$d[0]]['reg'] = $l[0];
if ($d[6] and $ipi) {
# Get IP info for interfaces on snmpdevs
$nquery = GenQuery('networks', 's', 'ifname,ifip,ifip6,vrfname', '', '', array('device'), array('='), array($d[0]));
$nres = DbQuery($nquery, $link);
if ($nres) {
while ($n = DbFetchRow($nres)) {
if ($n[1]) {
$dev[$d[0]]['ifip'][$n[0]] .= " " . long2ip($n[1]) . ($n[3] ? " ({$n['3']})" : "");
} else {
$dev[$d[0]]['ifip'][$n[0]] .= " " . DbIPv6($n[2]) . ($n[3] ? " ({$n['3']})" : "");
}
}
} else {
echo DbError($nlink);
}
DbFreeResult($nres);
}
if ($d[6] and ($ifa or $lit == 'l')) {
# Get IF alias TODO use iftype to determine links?
$nquery = GenQuery('interfaces', 's', 'ifname,ifidx,iftype,alias,dinoct,doutoct', '', '', array('device'), array('='), array($d[0]));
$nres = DbQuery($nquery, $link);
if ($nres) {
while ($n = DbFetchRow($nres)) {
$dev[$d[0]]['ifty'][$n[0]] = $n[1];
$dev[$d[0]]['ifix'][$n[0]] = $n[2];
$dev[$d[0]]['ifal'][$n[0]] = $n[3];
$dev[$d[0]]['ifin'][$n[0]] = $n[4];
$dev[$d[0]]['ifout'][$n[0]] = $n[5];
}
} else {
echo DbError($nlink);
}
DbFreeResult($nres);
}
if ($lev > 1) {
$dev[$d[0]]['cty'] = $l[1];
}
if ($lev > 2) {
$bld[$l[0]][$l[1]][$l[2]]['ndv']++;
$dev[$d[0]]['bld'] = $l[2];
}
if ($lev > 3) {
if ($mde == "r") {
$flr[$l[0]][$l[1]][$l[2]][$d[0]]['ndv']++;
} else {
$flr[$l[0]][$l[1]][$l[2]][$l[3]][] = $d[0];
}
$dev[$d[0]]['ip'] = long2ip($d[1]);
$dev[$d[0]]['rom'] = $l[4];
$dev[$d[0]]['rak'] = $l[5] ? $l[5] : "";
$dev[$d[0]]['typ'] = $d[2];
$dev[$d[0]]['con'] = $d[4];
$dev[$d[0]]['mod'] = Devmode($d[5]);
$dev[$d[0]]['ico'] = $d[6];
if (substr($d[9], 1, 1) == "C") {
$dev[$d[0]]['cpu'] = $d[7];
//.........这里部分代码省略.........
示例2: DbQuery
if ($uok == 1) {
$res = DbQuery($_POST['q'], $link);
$sys = posix_uname();
$sys['nedi'] = "1.0.9-010";
if ($_POST['m']) {
if ($res) {
while ($l = DbFetchArray($res)) {
$rows[] = $l;
}
array_unshift($rows, $sys);
print json_encode($rows);
} else {
echo "ERR :DB - " . DbError($link);
}
} else {
echo join(';;', $sys) . "\n";
if ($res) {
while ($l = DbFetchRow($res)) {
echo join(';;', $l) . "\n";
}
} else {
echo "ERR :DB - " . DbError($link);
}
}
DbFreeResult($res);
} else {
echo "ERR :Incorrect password!";
}
} else {
echo "ERR :Need credentials!";
}示例3: GenQuery
echo "$n1rmsg";
}
}
echo "<h3>";
$query = GenQuery('user','u','name',$name,'',array('email'),array('='),array($_GET['email']) );
if( !@DbQuery($query,$link) ){echo DbError($link);}else{echo "Email, ";}
$query = GenQuery('user','u','name',$name,'',array('phone'),array('='),array($_GET['phone']) );
if( !@DbQuery($query,$link) ){echo DbError($link);}else{echo "Phone, ";}
$query = GenQuery('user','u','name',$name,'',array('comment'),array('='),array($_GET['comment']) );
if( !@DbQuery($query,$link) ){echo DbError($link);}else{echo "Comment, ";}
$_SESSION['lang'] = $_GET['lang'];
$query = GenQuery('user','u','name',$name,'',array('language'),array('='),array($_GET['lang']) );
if( !@DbQuery($query,$link) ){echo DbError($link);}else{echo "Feedback language, ";}
$_SESSION['theme'] = $_GET['teme'];
$query = GenQuery('user','u','name',$name,'',array('theme'),array('='),array($_GET['teme']) );
if( !@DbQuery($query,$link) ){echo DbError($link);}else{echo "Theme ";}
echo " $upokmsg</h3>";
}
$query = GenQuery('user','s','*','','',array('name'),array('='),array($name) );
$res = @DbQuery($query,$link);
$uok = @DbNumRows($res);
if ($uok == 1) {
$u = @DbFetchRow($res);
}else{
echo "<h4>user $name doesn't exist! ($uok)</h4>";
die;
}
?>
<h1>User Profile</h1>
<form method="get" action="<?php
echo $_SERVER['PHP_SELF'];示例4: TopoTable
function TopoTable($reg = "", $cty = "", $bld = "", $flr = "", $rom = "", $nsd = 0)
{
global $link, $dev, $noloc, $alarr, $dreg, $dcity, $dbuild, $locsep, $now, $retire;
if ($nsd) {
$query = GenQuery('devices', 's', '*', '', '', array('location'), array('like'), array(TopoLoc($reg, $cty, $bld, $flr, $rom)));
} else {
$query = GenQuery('devices', 's', '*', '', '', array('snmpversion', 'location'), array('>', 'like'), array('0', TopoLoc($reg, $cty, $bld, $flr, $rom)), array('AND'));
}
$res = DbQuery($query, $link);
if ($res) {
while ($d = DbFetchRow($res)) {
$mn = array_key_exists($d[0], $alarr) ? 1 : 0;
if (preg_match("/.+{$locsep}.+{$locsep}.+/", $d[10])) {
$l = explode($locsep, $d[10]);
if ($mn) {
$dreg[$l[0]]['mn']++;
$dreg[$l[0]]['al'] += $alarr[$d[0]]['st'];
$dcity[$l[0]][$l[1]]['mn']++;
$dcity[$l[0]][$l[1]]['al'] += $alarr[$d[0]]['st'];
$dbuild[$l[0]][$l[1]][$l[2]]['mn']++;
$dbuild[$l[0]][$l[1]][$l[2]]['al'] += $alarr[$d[0]]['st'];
}
$dreg[$l[0]]['nd']++;
$dcity[$l[0]][$l[1]]['nd']++;
$dbuild[$l[0]][$l[1]][$l[2]]['nd']++;
if ($d[6] > 3) {
$dbuild[$l[0]][$l[1]][$l[2]]['nr']++;
}
if ($reg and $cty) {
$dev[$l[3]][$l[4]][$d[0]]['rk'] = $l[5];
$dev[$l[3]][$l[4]][$d[0]]['ru'] = $l[6];
$dev[$l[3]][$l[4]][$d[0]]['ip'] = long2ip($d[1]);
$dev[$l[3]][$l[4]][$d[0]]['ty'] = $d[3];
$dev[$l[3]][$l[4]][$d[0]]['co'] = $d[11];
$dev[$l[3]][$l[4]][$d[0]]['po'] = $d[16];
$dev[$l[3]][$l[4]][$d[0]]['ic'] = $d[18];
$dev[$l[3]][$l[4]][$d[0]]['mn'] = $mn;
$dev[$l[3]][$l[4]][$d[0]]['al'] = $alarr[$d[0]]['st'];
$dev[$l[3]][$l[4]][$d[0]]['sz'] = $d[28];
$dev[$l[3]][$l[4]][$d[0]]['sk'] = $d[29] ? $d[29] : 1;
}
} else {
$noloc[$d[0]]['ip'] = long2ip($d[1]);
$noloc[$d[0]]['ty'] = $d[3];
$noloc[$d[0]]['lo'] = $d[10];
$noloc[$d[0]]['co'] = $d[11];
$noloc[$d[0]]['po'] = $d[16];
$noloc[$d[0]]['ic'] = $d[18];
$noloc[$d[0]]['mn'] = $mn;
if ($mn) {
$noloc[$d[0]]['al'] = $alarr[$d[0]]['st'];
}
}
}
DbFreeResult($res);
} else {
print DbError($link);
}
}示例5: while
}
$radres = @DbQuery($radquery, $radlink);
$nres = 0;
if ($radres) {
while ($u = @DbFetchArray($radres)) {
// allet in variablen schreiben
$radusr[$nres]["UserName"] = $u['UserName'];
$radusr[$nres]["Name"] = $u['Name'];
$radusr[$nres]["Department"] = $u['Department'];
$radusr[$nres]["Mail"] = $u['Mail'];
$radusr[$nres]["WorkPhone"] = $u['WorkPhone'];
$nres++;
}
@DbFreeResult($radres);
} else {
print @DbError($radlink);
}
// get online status on these users
for ($i = 0; $i < $nres; $i++) {
$radquery = Query('radacct', '*', 'UserName', '=', $radusr[$i]["UserName"], 'AND', 'AcctStopTime', '=', '0', $_GET[ord], '');
$radres = @DbQuery($radquery, $radlink);
if ($u = @DbFetchArray($radres)) {
$radusr[$i]["Online"] = true;
$radusr[$i]["NAS"] = $u['NASIPAddress'];
} else {
$radusr[$i]["Online"] = false;
$radusr[$i]["NAS"] = '';
}
@DbFreeResult($radres);
}
// print示例6: Read
function Read($ina, $filter)
{
global $link, $locsep, $resmsg;
global $lev, $ipi, $net, $dev, $ndev, $bdev, $cdev, $rdev;
global $devlink, $ctylink, $bldlink;
global $nctylink, $nbldlink, $actylink, $abldlink;
$net = array();
if ($ina == "vlan") {
$query = GenQuery('vlans', 'g', 'device', 'device', '', array('vlanid'), array('regexp'), array($filter));
$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($filter));
$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($filter));
} else {
$query = GenQuery('devices', 's', 'name,ip,location,icon', '', '', array('location'), array('regexp'), array($filter));
}
$res = @DbQuery($query, $link);
if ($res) {
while ($unit = @DbFetchRow($res)) {
$l = explode($locsep, $unit[2]);
$ndev["{$l['0']}{$locsep}{$l['1']}"][$l[2]][$l[3]][] = $unit[0];
$bdev["{$l['0']}{$locsep}{$l['1']}"][$l[2]]++;
$cdev["{$l['0']}{$locsep}{$l['1']}"]++;
$rdev[$l[0]][$l[1]]++;
$dev[$unit[0]]['ip'] = long2ip($unit[1]);
$dev[$unit[0]]['ic'] = $unit[3];
$dev[$unit[0]]['cty'] = "{$l['0']}{$locsep}{$l['1']}";
$dev[$unit[0]]['bld'] = $l[2];
$dev[$unit[0]]['rom'] = $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);
}
$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];
}
//.........这里部分代码省略.........
示例7: 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.
//.........这里部分代码省略.........
示例8: GenQuery
$lopt[$l[0]][$l[1]][$l[2]]++;
}
@DbFreeResult($res);
}else{
echo @DbError($link);
}
if ($do == 'Create' and $reg){
$query = GenQuery('locations','i','','','',array('region','city','building','x','y','comment'),'',array($reg,$cty,$bld,$x,$y,$com) );
if( !@DbQuery($query,$link) ){echo "<h4>".DbError($link)."</h4>";}else{echo "<h3>Location $reg $cty $bld - $upokmsg</h3>";}
}elseif ($do == 'Update' and $id){
$query = GenQuery('locations','u','id',$id,'',array('region','city','building','x','y','comment'),'',array($reg,$cty,$bld,$x,$y,$com) );
if( !@DbQuery($query,$link) ){echo "<h4>".DbError($link)."</h4>";}else{echo "<h3>Location $reg $cty $bld - $upokmsg</h3>";}
}elseif($do == 'Delete' and $id){
$query = GenQuery('locations','d','','','',array('id'),array('='),array($id) );
if( !@DbQuery($query,$link) ){echo "<h4>".DbError($link)."</h4>";}else{echo "<h3>Location $reg $cty $bld $delokmsg</h3>";}
}
if($bld){
$query = GenQuery('locations','s','id,x,y,comment','','',array('region','city','building'),array('=','=','='),array($reg,$cty,$bld),array('AND','AND'));
$mapbg = TopoMap($reg,$cty);
$nam = $bld;
$com = "Building with ".$lopt[$reg][$cty][$bld] ." devices on $now";
}elseif($cty){
$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;示例9: shell_exec
}elseif($stop and $isadmin){
if( $pid = GetPID($mysrv[$stop]['cmd']) ){
if( posix_kill ($pid, 9) ){
$procs = shell_exec($pscmd); # Refresh PIDs after kill
echo "<h5>$stop stopped</h5>";
}else{
echo "<h4>$stop not stopped!</h4>";
}
}else{
echo "<h4>$stop not running!</h4>";
}
}elseif($clear and $isadmin){
$query = GenQuery('system','u','name','=','threads',array('value'),array(),array('0') );
if( !DbQuery($query,$link) ){echo "<h4>".DbError($link)."</h4>";}else{echo "<h5>$dellbl threads OK</h5>";}
$query = GenQuery('system','u','name','=','nodlock',array('value'),array(),array('0') );
if( !DbQuery($query,$link) ){echo "<h4>".DbError($link)."</h4>";}else{echo "<h5>$reslbl nodlock OK</h5>";}
if( $pid = GetPID('nedi.pl') ){
posix_kill ($pid, 9);
$err = posix_get_last_error();
if( $err ){
echo "<h4>$dellbl NeDi: ".posix_strerror($err)."</h4>";
}else{
echo "<h5>NeDi $dellbl OK</h5>";
}
$procs = shell_exec($pscmd); # Refresh PIDs after kill
}else{
echo "<h4>NeDi not running</h4>";
}
}
示例10: key
if($res){
while( ($l = @DbFetchRow($res)) ){
$neb[$l[3]] = $l[4];
}
@DbFreeResult($res);
}else{
print @DbError($link);
}
if($gen == 'Monitor' and !$mdev[$na] and $dsnm[$na]){
$adep = 'none';
if(count(array_keys($neb) ) == 1 and $ars){
$adep = key($neb);
}
$mdep[$na] = $adep;
$query = GenQuery('monitoring','i','','','',array('device','status','depend','sms','mail','lastchk','uptime','lost','ok'),'',array($na,'0',$adep,'0','0','0','0','0','0') );
if( !@DbQuery($query,$link) ){echo "<h4 align=center>".DbError($link)."</h4>";}else{echo "<h3>$na $upokmsg</h3>";$mdev[$na]=1;}
}
list($statbg,$stat) = StatusBg(1,$mdev[$na],$msta[$na],$bi);
echo "<tr class=\"$bg\"><th class=\"$statbg\">\n";
echo "<a href=Devices-Status.php?dev=$ud><img src=\"img/dev/$ico.png\" title=\"$stat\"></a><p>\n";
echo "<b>$na</b></th><td>$dloc[$na]</td><td>$minfo[$na]</td>";
echo "<th>";
if($mdev[$na]){
echo "<a href=?loc=$uloc&crm=$ud&gen=up><img src=\"img/16/bchk.png\" title=\"-Check\"></a>";
}elseif($dsnm["$na"]){
echo "<a href=?loc=$uloc&cad=$ud&gen=up><img src=\"img/16/bcls.png\" title=\"+Check\"></a>";
}else{
echo "<img src=\"img/16/bstp.png\" title=\"no SNMP available!\"></a>";
}示例11: NodSum
function NodSum($ina, $opa, $sta, $lim, $ord)
{
global $link, $modgroup, $self, $rrdstep, $stco, $sumlbl, $srtlbl, $venlbl, $qtylbl, $alllbl, $chglbl, $totlbl, $deslbl, $fislbl, $laslbl, $emplbl, $namlbl, $metlbl, $nonlbl, $loslbl, $qutlbl, $faslbl, $vallbl, $mullbl;
$lasdis = time() - $rrdstep * 2;
$query = GenQuery('nodes', 's', "count(*),sum(case when nodip = 0 then 1 else 0 end),sum(case when name = '' then 1 else 0 end),sum(case when firstseen = lastseen then 1 else 0 end),sum(case when iplost > 0 then 1 else 0 end),sum(case when ifmetric < 256 then 1 else 0 end),sum(case when firstseen > {$lasdis} then 1 else 0 end),sum(case when lastseen > {$lasdis} then 1 else 0 end),sum(case when ipchanges > 0 then 1 else 0 end),sum(case when ifchanges > 0 then 1 else 0 end),sum(case when arpval > 1 then 1 else 0 end)", '', '', array($ina), array($opa), array($sta), array(), 'LEFT JOIN devices USING (device)');
$res = DbQuery($query, $link);
if ($res) {
$r = DbFetchRow($res);
} else {
print DbError($link);
die;
}
?>
<table class="full fixed"><tr><td class="helper">
<h2>Node <?php
echo $sumlbl;
?>
</h2>
<table class="content"><tr class="<?php
echo $modgroup[$self];
?>
2">
<th width="33%" colspan="2"><img src="img/16/find.png" title="Nodes <?php
echo $stslbl;
?>
">
<br><?php
echo $deslbl;
?>
</th><th><img src="img/16/nods.png"><br>Nodes</th>
<tr class="txtb"><th class="imgb"><img src="img/16/add.png" title="<?php
echo $fislbl;
?>
> <?php
echo date($_SESSION['date'], $lasdis);
?>
"></th><td><b><?php
echo $stco['10'];
?>
</b></td><td><?php
echo Bar($r[6], 0, 'mi');
?>
<a href="Nodes-List.php?in[]=firstseen&op[]=>&st[]=<?php
echo $lasdis;
?>
&ord=nodip"><?php
echo $r[6];
?>
</a></td></tr>
<tr class="txta"><th class="imga"><img src="img/16/exit.png" title="<?php
echo $laslbl;
?>
> <?php
echo date($_SESSION['date'], $lasdis);
?>
"></th><td><b><?php
echo $stco['100'];
?>
</b></td><td><?php
echo Bar($r[7], 0, 'mi');
?>
<a href="Nodes-List.php?in[]=lastseen&op[]=>&st[]=<?php
echo $lasdis;
?>
&ord=nodip"><?php
echo $r[7];
?>
</a></td></tr>
<tr class="txtb"><th class="imgb"><img src="img/16/wlan.png" title="IF <?php
echo $metlbl;
?>
< 256"></th><td><b>Wlan</th></b><td><?php
echo Bar($r[5], 0, 'mi');
?>
<a href="Nodes-List.php?in[]=ifmetric&op[]=<&st[]=256&ord=ifmetric+desc"> <?php
echo $r[5];
?>
</a></td></tr>
<tr class="txta"><th class="imga"><img src="img/16/calc.png" title="IP <?php
echo $chglbl;
?>
> 0"></th><td><b>IP <?php
echo $chglbl;
?>
</b></td><td><?php
echo Bar($r[8], 0, 'mi');
?>
<a href="Nodes-List.php?in[]=ipchanges&op[]=>&st[]=0&ord=ipchanges+desc"><?php
echo $r[8];
?>
</a></td></tr>
<tr class="txtb"><th class="imgb"><img src="img/16/walk.png" title="IF <?php
echo $chglbl;
?>
> 0"></th><td><b>IF <?php
echo $chglbl;
?>
</b></td><td><?php
echo Bar($r[9], 0, 'mi');
//.........这里部分代码省略.........
示例12: array
<?
$libw = array();
$query = GenQuery('links');
$res = @DbQuery($query,$link);
$nli = @DbNumRows($res);
if($res){
$row = 0;
while( ($l = @DbFetchRow($res)) ){
$libw[$l[1]][$l[2]][$l[3]][$l[4]] = $l[5]; # Bandwidth is the only value, which is constructed from local IF in SNMP::CDP/LLDP
$lity[$l[1]][$l[2]][$l[3]][$l[4]] = $l[6];
$lidu[$l[1]][$l[2]][$l[3]][$l[4]] = $l[8]; # Duplex and Vlan are read via CDP from remote side
$livl[$l[1]][$l[2]][$l[3]][$l[4]] = $l[9];
}
@DbFreeResult($res);
}else{
echo @DbError($link);
die;
}
$row = 0;
foreach(array_keys($libw) as $dv){
foreach(array_keys($libw[$dv]) as $if){
foreach(array_keys($libw[$dv][$if]) as $nb){
foreach(array_keys($libw[$dv][$if][$nb]) as $ni){
$ud = rawurlencode($dv);
$un = rawurlencode($nb);
if($alt or $libw[$dv][$if][$nb][$ni] and $libw[$nb][$ni][$dv][$if]){
if($libw[$dv][$if][$nb][$ni] != $libw[$nb][$ni][$dv][$if]){
if ($row % 2){$bg = "txta"; $bi = "imga";}else{$bg = "txtb"; $bi = "imgb";}
$row++;
echo "<tr class=\"$bg\"><th class=\"$bi\">\n";
echo "<img src=\"img/spd.png\" title=\"bandwidth\"></th>\n";示例13: TopoTable
function TopoTable($reg = "", $cty = "", $bld = "")
{
global $link, $dev, $deval, $dcity, $dbuild, $locsep, $maxcol, $bg1, $bg2, $tabtag;
$query = GenQuery('devices', 's', '*', '', '', array('location'), array('regexp'), array(TopoLoc($reg, $cty, $bld)));
$res = @DbQuery($query, $link);
if ($res) {
while ($d = @DbFetchRow($res)) {
$l = explode($locsep, $d[10]);
if (isset($deval[$d[0]])) {
# Device is monitored if set...
$dcity[$l[0]][$l[1]]['mn']++;
$dcity[$l[0]][$l[1]]['al'] += $deval[$d[0]];
$dbuild[$l[0]][$l[1]][$l[2]]['mn']++;
$dbuild[$l[0]][$l[1]][$l[2]]['al'] += $deval[$d[0]];
$mn = 1;
} else {
$mn = 0;
}
if (!$cty) {
$dcity[$l[0]][$l[1]]['nd']++;
} elseif (!$bld) {
$dbuild[$l[0]][$l[1]][$l[2]]['nd']++;
if ($d[6] > 3) {
$dbuild[$l[0]][$l[1]][$l[2]]['nr']++;
}
} else {
$dev[$l[3]][$l[4]][$d[0]]['rk'] = "{$l['5']} <i>{$l['6']}</i>";
$dev[$l[3]][$l[4]][$d[0]]['ip'] = $d[1];
$dev[$l[3]][$l[4]][$d[0]]['ty'] = $d[3];
$dev[$l[3]][$l[4]][$d[0]]['co'] = $d[11];
$dev[$l[3]][$l[4]][$d[0]]['ic'] = $d[18];
$dev[$l[3]][$l[4]][$d[0]]['mn'] = $mn;
$dev[$l[3]][$l[4]][$d[0]]['al'] = $deval[$d[0]];
}
}
@DbFreeResult($res);
} else {
print @DbError($link);
}
}示例14: DevDelete
function DevDelete($dld, $dtxt)
{
global $link, $delbl, $errlbl, $updlbl, $nedipath;
$query = GenQuery('devices', 'd', '', '', '', array('device'), array('='), array($dld));
if (!DbQuery($query, $link)) {
echo "<h4>Device " . DbError($link) . "</h4>";
} else {
echo "<h5>Device {$dld} {$dellbl} OK</h5>";
}
$query = GenQuery('interfaces', 'd', '', '', '', array('device'), array('='), array($dld));
if (!DbQuery($query, $link)) {
echo "<h4>IF " . DbError($link) . "</h4>";
} else {
echo "<h5>IF {$dld} {$dellbl} OK</h5>";
}
$query = GenQuery('modules', 'd', '', '', '', array('device'), array('='), array($dld));
if (!DbQuery($query, $link)) {
echo "<h4>Modules " . DbError($link) . "</h4>";
} else {
echo "<h5>Modules {$dld} {$dellbl} OK</h5>";
}
$query = GenQuery('links', 'd', '', '', '', array('device'), array('='), array($dld));
if (!DbQuery($query, $link)) {
echo "<h4>Links " . DbError($link) . "</h4>";
} else {
echo "<h5>Links {$dld} {$dellbl} OK</h5>";
}
$query = GenQuery('links', 'd', '', '', '', array('neighbor'), array('='), array($dld));
if (!DbQuery($query, $link)) {
echo "<h4>Links " . DbError($link) . "</h4>";
} else {
echo "<h5>Links {$dld} {$dellbl} OK</h5>";
}
$query = GenQuery('configs', 'd', '', '', '', array('device'), array('='), array($dld));
if (!DbQuery($query, $link)) {
echo "<h4>Config " . DbError($link) . "</h4>";
} else {
echo "<h5>Config {$dld} {$dellbl} OK</h5>";
}
$query = GenQuery('monitoring', 'd', '', '', '', array('name'), array('='), array($dld));
if (!DbQuery($query, $link)) {
echo "<h4>Monitoring " . DbError($link) . "</h4>";
} else {
echo "<h5>Monitoring {$dld} {$dellbl} OK</h5>";
}
$query = GenQuery('incidents', 'd', '', '', '', array('name'), array('='), array($dld));
if (!DbQuery($query, $link)) {
echo "<h4>Incidents " . DbError($link) . "</h4>";
} else {
echo "<h5>Incidents {$dld} {$dellbl} OK</h5>";
}
$query = GenQuery('vlans', 'd', '', '', '', array('device'), array('='), array($dld));
if (!DbQuery($query, $link)) {
echo "<h4>Vlans " . DbError($link) . "</h4>";
} else {
echo "<h5>Vlans {$dld} {$dellbl} OK</h5>";
}
$query = GenQuery('networks', 'd', '', '', '', array('device'), array('='), array($dld));
if (!DbQuery($query, $link)) {
echo "<h4>Networks " . DbError($link) . "</h4>";
} else {
echo "<h5>Networks {$dld} {$dellbl} OK</h5>";
}
$query = GenQuery('events', 'd', '', '', '', array('source'), array('='), array($dld));
if (!DbQuery($query, $link)) {
echo "<h4>Events " . DbError($link) . "</h4>";
} else {
echo "<h5>Events {$dld} {$dellbl} OK</h5>";
}
$devdir = rawurlencode($dld);
if (file_exists("{$nedipath}/rrd/{$devdir}/*.rrd")) {
foreach (glob("{$nedipath}/rrd/{$devdir}/*.rrd") as $rrd) {
echo unlink($rrd) ? "<h5>{$rrd} {$dellbl} OK</h5>" : "<h4>{$rrd} {$dellbl} {$errlbl}</h4>";
}
echo rmdir("{$nedipath}/rrd/{$devdir}") ? "<h5>{$nedipath}/rrd/{$devdir} {$dellbl} OK</h5>" : "<h4>{$nedipath}/rrd/{$devdir} {$dellbl} {$errlbl}</h4>";
}
if (file_exists("{$nedipath}/rrd/{$devdir}/*.rrd")) {
foreach (glob("{$nedipath}/conf/{$devdir}/*.cfg") as $cfg) {
echo unlink($cfg) ? "<h5>{$cfg} {$dellbl} OK</h5>" : "<h4>{$cfg} {$dellbl} {$errlbl}</h4>";
}
echo rmdir("{$nedipath}/conf/{$devdir}") ? "<h5>{$nedipath}/conf/{$devdir} {$dellbl} OK</h5>" : "<h4>{$nedipath}/conf/{$devdir} {$dellbl} {$errlbl}</h4>";
}
$query = GenQuery('events', 'i', '', '', '', array('level', 'time', 'source', 'info', 'class', 'device'), array(), array('100', time(), $dld, "device{$dtxt} deleted by {$_SESSION['user']}", 'usrd', $dld));
if (!DbQuery($query, $link)) {
echo "<h4>" . DbError($link) . "</h4>";
} else {
echo "<h5>{$msglbl} {$updlbl} OK</h5>";
}
}示例15: fgets
$mail_importe = fgets($liste, 4096);
if (strlen($mail_importe) == 2) {
// dummy and pretty function ;-) yeah !
} else {
$mail_importe = str_replace("'", "", $mail_importe);
$mail_importe = str_replace('"', "", $mail_importe);
$mail_importe = strtolower(trim($mail_importe));
if (!empty($mail_importe) && validEmailAddress($mail_importe)) {
$added = add_subscriber($cnx, $row_config_globale['table_email'], $list_id, $mail_importe);
if ($added == -1) {
$subscriber_op_msg .= "<h4 class='alert_error'>" . translate("ERROR_ALREADY_SUBSCRIBER", "<b>{$mail_importe}</b>") . ".</h4>";
} elseif ($added == 2) {
$subscriber_op_msg .= "<h4 class='alert_success'>" . translate("SUBSCRIBER_ADDED", "<b>{$mail_importe}</b>") . ".</h4>";
$tx_import++;
} elseif ($added == 0) {
$subscriber_op_msg .= "<h4 class='alert_error'>" . translate("ERROR_SQL", DbError()) . "</h4>";
}
} else {
$subscriber_op_msg .= "<h4 class='alert_error'>Adresse mail invalide : " . $mail_importe . "</h4>";
}
}
}
$subscriber_op_msg .= "<h4 class='alert_success'><b>{$tx_import} mails importés</b></h4>";
} else {
$subscriber_op_msg = "<h4 class='alert_error'>" . translate("ERROR_IMPORT_TMPDIR_NOT_WRITABLE") . " !</h4>";
}
} else {
$subscriber_op_msg = "<h4 class='alert_error'>" . translate("ERROR_IMPORT_FILE_MISSING") . " !</h4>";
}
break;
default: