📄 index.php
字号:
<?include("include.php");?><html><center><img src=logo.gif><?// Get variables from urlif (isset($_GET['sensor_name']) && $_GET['sensor_name'] != "none") $sensor_name = $_GET['sensor_name'];if (isset($_GET['interval']) && $_GET['interval'] != "none") $interval = $_GET['interval'];if (isset($_GET['timestamp']) && $_GET['timestamp'] != "none") $timestamp = $_GET['timestamp'];if (isset($_GET['subnet']) && $_GET['subnet'] != "none") $subnet = $_GET['subnet'];if (isset($_GET['limit']) && $_GET['limit'] != "none") $limit = $_GET['limit'];$db = ConnectDb();?><FORM name="navigation" method=get action=<?=$PHP_SELF?>><table width=100% cellspacing=0 cellpadding=5 border=1><tr><td><SELECT name="sensor_name"><OPTION value="none">--Select A Sensor--<?$sql = "SELECT sensor_name from sensors order by sensor_name;";$result = pg_query($sql);while ($r = pg_fetch_array($result)) echo "<option value=\"".$r['sensor_name']."\" ".($sensor_name==$r['sensor_name']?"SELECTED":"").">".$r['sensor_name']."\n";?></SELECT><td><SELECT name="interval"><OPTION value="none">--Select An Interval--<OPTION value=<?=INT_DAILY?> <?=$interval==INT_DAILY?"SELECTED":""?>>Daily<OPTION value=<?=INT_WEEKLY?> <?=$interval==INT_WEEKLY?"SELECTED":""?>>Weekly<OPTION value=<?=INT_MONTHLY?> <?=$interval==INT_MONTHLY?"SELECTED":""?>>Monthly<OPTION value=<?=INT_YEARLY?> <?=$interval==INT_YEARLY?"SELECTED":""?>>Yearly<OPTION value=<?=24*60*60?> <?=$interval==24*60*60?"SELECTED":""?>>24hrs<OPTION value=<?=30*24*60*60?> <?=$interval==30*24*60*60?"SELECTED":""?>>30days</select><td><SELECT name="limit"><OPTION value="none">--How Many Results--<OPTION value=20 <?=$limit==20?"SELECTED":""?>>20<OPTION value=50 <?=$limit==50?"SELECTED":""?>>50<OPTION value=100 <?=$limit==100?"SELECTED":""?>>100<OPTION value=all <?=$limit=="all"?"SELECTED":""?>>All</select><td>Subnet Filter:<input name=subnet value="<?=isset($subnet)?$subnet:"0.0.0.0/0"?>"> <input type=submit value="Go"></table></FORM><?// Set defaultsif (!isset($interval)) $interval = DFLT_INTERVAL;if (!isset($timestamp)) $timestamp = time() - $interval + (0.05*$interval);if (!isset($limit)) $limit = 20;// Validationif (!isset($sensor_name)) exit(0);// Print Titleif (isset($limit)) echo "<h2>Top $limit - $sensor_name</h2>";else echo "<h2>All Records - $sensor_name</h2>";// Sqlize the incomming variablesif (isset($subnet)) $sql_subnet = "and ip <<= '$subnet'";// Sql Statement$sql = "select tx.ip, rx.scale as rxscale, tx.scale as txscale, tx.total+rx.total as total, tx.total as sent, rx.total as received, tx.tcp+rx.tcp as tcp, tx.udp+rx.udp as udp,tx.icmp+rx.icmp as icmp, tx.http+rx.http as http,tx.p2p+rx.p2p as p2p, tx.ftp+rx.ftp as ftpfrom(SELECT ip, max(total/sample_duration)*8 as scale, sum(total) as total, sum(tcp) as tcp, sum(udp) as udp, sum(icmp) as icmp,sum(http) as http, sum(p2p) as p2p, sum(ftp) as ftpfrom sensors, bd_tx_logwhere sensor_name = '$sensor_name'and sensors.sensor_id = bd_tx_log.sensor_id$sql_subnetand timestamp > $timestamp::abstime and timestamp < ".($timestamp+$interval)."::abstimegroup by ip) as tx,(SELECT ip, max(total/sample_duration)*8 as scale, sum(total) as total, sum(tcp) as tcp, sum(udp) as udp, sum(icmp) as icmp,sum(http) as http, sum(p2p) as p2p, sum(ftp) as ftpfrom sensors, bd_rx_logwhere sensor_name = '$sensor_name'and sensors.sensor_id = bd_rx_log.sensor_id$sql_subnetand timestamp > $timestamp::abstime and timestamp < ".($timestamp+$interval)."::abstimegroup by ip) as rxwhere tx.ip = rx.iporder by total desc;";//echo "</center><pre>$sql</pre><center>"; exit(0);pg_query("SET sort_mem TO 30000;");$result = pg_query($sql);pg_query("set sort_mem to default;");if ($limit == "all") $limit = pg_num_rows($result);echo "<table width=100% border=1 cellspacing=0><tr><td>Ip<td>Name<td>Total<td>Sent<td>Received<td>tcp<td>udp<td>icmp<td>http<td>p2p<td>ftp";if (!isset($subnet)) // Set this now for total graphs $subnet = "0.0.0.0/0";// Output Total Lineecho "<TR><TD><a href=Total>Total</a><TD>$subnet";foreach (array("total", "sent", "received", "tcp", "udp", "icmp", "http", "p2p", "ftp") as $key) { for($Counter=0, $Total = 0; $Counter < pg_num_rows($result); $Counter++) { $r = pg_fetch_array($result, $Counter); $Total += $r[$key]; } echo fmtb($Total); }echo "\n";// Output Other Linesfor($Counter=0; $Counter < pg_num_rows($result) && $Counter < $limit; $Counter++) { $r = pg_fetch_array($result, $Counter); echo "<tr><td><a href=#".$r['ip'].">"; echo $r['ip']."<td>".gethostbyaddr($r['ip']); echo "</a>"; echo fmtb($r['total']).fmtb($r['sent']).fmtb($r['received']). fmtb($r['tcp']).fmtb($r['udp']).fmtb($r['icmp']).fmtb($r['http']). fmtb($r['p2p']).fmtb($r['ftp'])."\n"; }echo "</table></center>";// Output Total Graphfor($Counter=0, $Total = 0; $Counter < pg_num_rows($result); $Counter++) { $r = pg_fetch_array($result, $Counter); $scale = max($r['txscale'], $scale); $scale = max($r['rxscale'], $scale); }if ($subnet == "0.0.0.0/0") $total_table = "bd_tx_total_log";else $total_table = "bd_tx_log";echo "<a name=Total><h3><a href=details.php?sensor_name=$sensor_name&ip=$subnet>";echo "Total - Total of $subnet</h3>";echo "</a>";echo "Send:<br><img src=graph.php?ip=$subnet&interval=$interval&sensor_name=".$sensor_name."&table=$total_table><br>";echo "<img src=legend.gif><br>\n";if ($subnet == "0.0.0.0/0") $total_table = "bd_rx_total_log";else $total_table = "bd_rx_log";echo "Receive:<br><img src=graph.php?ip=$subnet&interval=$interval&sensor_name=".$sensor_name."&table=$total_table><br>";echo "<img src=legend.gif><br>\n";// Output Other Graphsfor($Counter=0; $Counter < pg_num_rows($result) && $Counter < $limit; $Counter++) { $r = pg_fetch_array($result, $Counter); echo "<a name=".$r['ip']."><h3><a href=details.php?sensor_name=$sensor_name&ip=".$r['ip'].">"; if ($r['ip'] == "0.0.0.0") echo "Total - Total of all subnets</h3>"; else echo $r['ip']." - ".gethostbyaddr($r['ip'])."</h3>"; echo "</a>"; echo "Send:<br><img src=graph.php?ip=".$r['ip']."&interval=$interval&sensor_name=".$sensor_name."&table=bd_tx_log&yscale=".(max($r['txscale'], $r['rxscale']))."><br>"; echo "<img src=legend.gif><br>\n"; echo "Receive:<br><img src=graph.php?ip=".$r['ip']."&interval=$interval&sensor_name=".$sensor_name."&table=bd_rx_log&yscale=".(max($r['txscale'], $r['rxscale']))."><br>"; echo "<img src=legend.gif><br>\n"; }include('footer.php');⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -