details.php (4339B)
1 <?php 2 include("include.php"); 3 ?> 4 <html> 5 <center> 6 <img src=logo.gif> 7 <?php 8 if (isset($_GET['sensor_name'])) 9 $sensor_name = $_GET['sensor_name']; 10 else 11 { 12 echo "<br>Please provide a sensor_name"; 13 exit(1); 14 } 15 16 if (isset($_GET['ip'])) 17 $ip = $_GET['ip']; 18 else 19 { 20 echo "<br>Please provide an ip address"; 21 exit(1); 22 } 23 24 echo "<h3>"; 25 if (strpos($ip, "/") === FALSE) 26 echo "$ip - ".gethostbyaddr($ip)."</h3>"; 27 else 28 echo "Total - $ip</h3>"; 29 30 $db = ConnectDb(); 31 32 if ($ip == "0.0.0.0/0") 33 { 34 $rxtable = "bd_rx_total_log"; 35 $txtable = "bd_tx_total_log"; 36 } 37 else 38 { 39 $rxtable = "bd_rx_log"; 40 $txtable = "bd_tx_log"; 41 } 42 43 $sql = "select rx.scale as rxscale, tx.scale as txscale, tx.total+rx.total as total, tx.total as sent, 44 rx.total as received, tx.tcp+rx.tcp as tcp, tx.udp+rx.udp as udp, 45 tx.icmp+rx.icmp as icmp, tx.http+rx.http as http, 46 tx.p2p+rx.p2p as p2p, tx.ftp+rx.ftp as ftp 47 from 48 49 (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, 50 sum(http) as http, sum(p2p) as p2p, sum(ftp) as ftp 51 from sensors, $txtable 52 where sensor_name = '$sensor_name' 53 and sensors.sensor_id = ".$txtable.".sensor_id 54 $sql_subnet 55 group by ip) as tx, 56 57 (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, 58 sum(http) as http, sum(p2p) as p2p, sum(ftp) as ftp 59 from sensors, $rxtable 60 where sensor_name = '$sensor_name' 61 and sensors.sensor_id = ".$rxtable.".sensor_id 62 $sql_subnet 63 group by ip) as rx 64 65 where tx.ip = rx.ip;"; 66 //error_log($sql); printf('</center><tt>%s</tt><center>', $sql); 67 $db = ConnectDb(); 68 $result = $db->query($sql); 69 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>smtp<td>ftp"; 70 $r = $result->fetch(); 71 $db = NULL; 72 echo "<tr><td>"; 73 if (strpos($ip, "/") === FALSE) 74 echo "$ip<td>".gethostbyaddr($ip); 75 else 76 echo "Total<td>$ip"; 77 echo fmtb($r['total']).fmtb($r['sent']).fmtb($r['received']). 78 fmtb($r['tcp']).fmtb($r['udp']).fmtb($r['icmp']).fmtb($r['http']). 79 fmtb($r['p2p']).fmtb($r['ftp']); 80 echo "</table></center>"; 81 82 echo "<center><h4>Daily</h4></center>"; 83 echo "Send:<br><img src=graph.php?ip=$ip&sensor_name=".$sensor_name."&table=$txtable&yscale=".(max($r['txscale'], $r['rxscale']))."><br>"; 84 echo "<img src=legend.gif><br>"; 85 echo "Receive:<br><img src=graph.php?ip=$ip&sensor_name=".$sensor_name."&table=$rxtable&yscale=".(max($r['txscale'], $r['rxscale']))."><br>"; 86 echo "<img src=legend.gif><br>"; 87 88 echo "<center><h4>Weekly</h4></center>"; 89 echo "Send:<br><img src=graph.php?interval=".INT_WEEKLY."&ip=$ip&sensor_name=$sensor_name&table=$txtable&yscale=".(max($r['txscale'], $r['rxscale']))."><br>"; 90 echo "<img src=legend.gif><br>"; 91 echo "Receive:<br><img src=graph.php?interval=".INT_WEEKLY."&ip=$ip&sensor_name=$sensor_name&table=$rxtable&yscale=".(max($r['txscale'], $r['rxscale']))."><br>"; 92 echo "<img src=legend.gif><br>"; 93 94 echo "<center><h4>Monthly</h4></center>"; 95 echo "Send:<br><img src=graph.php?interval=".INT_MONTHLY."&ip=$ip&sensor_name=$sensor_name&table=$txtable&yscale=".(max($r['txscale'], $r['rxscale']))."><br>"; 96 echo "<img src=legend.gif><br>"; 97 echo "Receive:<br><img src=graph.php?interval=".INT_MONTHLY."&ip=$ip&sensor_name=$sensor_name&table=$rxtable&yscale=".(max($r['txscale'], $r['rxscale']))."><br>"; 98 echo "<img src=legend.gif><br>"; 99 100 echo "<center><h4>Yearly</h4></center>"; 101 echo "Send:<br><img src=graph.php?interval=".INT_YEARLY."&ip=$ip&sensor_name=$sensor_name&table=$txtable&yscale=".(max($r['txscale'], $r['rxscale']))."><br>"; 102 echo "<img src=legend.gif><br>"; 103 echo "Receive:<br><img src=graph.php?interval=".INT_YEARLY."&ip=$ip&sensor_name=$sensor_name&table=$rxtable&yscale=".(max($r['txscale'], $r['rxscale']))."><br>"; 104 echo "<img src=legend.gif><br>";