Hobbit
Trap History

HEAD; ##### Get any previous form data ##### if (!isset($match)) { $match="and"; } $checked[$match]="CHECKED"; $agentip = $_GET['agentip']; $hostname = $_GET['hostname']; $trapoid = $_GET['trapoid']; $severity = $_GET['severity']; $snmpttdb = $_GET['snmpttdb']; if (isset($_GET['last'])) { $last = $_GET['last']; } else { $last = 25; } if (isset($snmpttdb)) { if ($snmpttdb == 1) { $SNMPDB = "snmptt"; } elseif ($snmpttdb == 2) { $SNMPDB = "snmptt_unknown"; } else { $SNMPDB = "snmptt"; } } else { $SNMPDB = "snmptt"; } ##### Print Form ##### print <<
AND OR
Traps


FORM; ##### Setup MySQL connection and clean up SQL input ##### # Must connect to MySQL first before testing with # magic_quotes or real_escape $link = mysql_connect($MYSQLSERVER,$MYSQLUSER,$MYSQLPASSWD); function quote_smart($value) { // Stripslashes if (get_magic_quotes_gpc()) { $value = stripslashes($value); } // Quote if not a number or a numeric string if (!is_numeric($value)) { $value = "'" . mysql_real_escape_string($value) . "'"; } return $value; } unset($criteria); if ($agentip != '') { $agentip = quote_smart($agentip); $criteria[] = "agentip LIKE $agentip"; } if ($hostname != '') { $hostname = quote_smart($hostname); $criteria[] = "hostname RLIKE $hostname"; } if ($trapoid != '') { $trapoid = quote_smart($trapoid); $criteria[] = "trapoid LIKE $trapoid"; } if ($severity != '') { $severity = quote_smart($severity); if ($SNMPDB == 'snmptt') { $criteria[] = "severity RLIKE $severity"; } } $wherestr = ""; if (isset($criteria)) { $wherestr = "WHERE " .implode(" $match ",$criteria); } if ($SNMPDB == 'snmptt_unknown') { $SELECT = "SELECT id, traptime, agentip, hostname, trapoid, formatline "; } else { $SELECT = "SELECT id, traptime, agentip, hostname, trapoid, severity, formatline "; } ##### Execute SQL query and print results ##### mysql_select_db($MYSQLDB) or die(mysql_error()); $SQLSELECT = "$SELECT FROM $SNMPDB $wherestr ORDER BY id DESC LIMIT $last"; #print "$SQLSELECT"; print << Date Agent IP Hostname Trap OID Severity Message TABLEHEAD; $cas = mysql_query("$SQLSELECT") or die(mysql_error()); while ($car = mysql_fetch_array($cas)) { $color = "clear"; if ($car[severity] == 'Normal') { $color = "green"; } if ($car[severity] == 'INFORMATIONAL') { $color = "green"; } if ($car[severity] == 'WARNING') { $color = "yellow"; } if ($car[severity] == 'MINOR') { $color = "yellow"; } if ($car[severity] == 'SEVERE') { $color = "red"; } if ($car[severity] == 'MAJOR') { $color = "red"; } if ($car[severity] == 'CRITICAL') { $color = "red"; } if ($SNMPDB == 'snmptt_unknown') { $severity = "Unknown"; } else { $severity = $car[severity]; } print << $car[traptime] $car[agentip] $car[hostname] $car[trapoid] $severity $car[formatline] LINE; } print "\n"; mysql_close($link); ?>