8 my $dbh = nms::db_connect();
9 print $cgi->header(-type=>'text/html; charset=utf-8', -refresh=>'45; http://nms.tg07.gathering.org/nettkart-telnet.pl');
14 <title>nettkart - telnet</title>
20 my $q = $dbh->prepare('select * from switches natural join placements');
22 while (my $ref = $q->fetchrow_hashref()) {
23 $ref->{'placement'} =~ /\((\d+),(\d+)\),\((\d+),(\d+)\)/;
25 my $traffic = 4.0 * $ref->{'bytes_in'} + $ref->{'bytes_out'}; # average and convert to bits (should be about the same in practice)
27 if ($traffic >= 1_000_000_000) {
28 $ttext = sprintf "%.2f Gbit/port/sec", $traffic/1_000_000_000;
29 } elsif ($traffic => 1_000_000) {
30 $ttext = sprintf "%.2f Mbit/port/sec", $traffic/1_000_000;
32 $ttext = sprintf "%.2f kbit/port/sec", $traffic/1_000;
35 printf " <area shape=\"rect\" coords=\"%u,%u,%u,%u\" target=\"blank\" href=\"telnet://$ref->{'ip'}\" alt=\"%s (%s)\" onmouseover=\"window.status='%s (%s)'; return true\" onmouseout=\"window.status=''\" />\n",
36 $3, $4, $1, $2, $ref->{'switch'}, $ref->{'sysname'},
37 $ttext, $ref->{'sysname'}, $ttext;
44 <p><img src="nettkart.pl" usemap="#switches" /></p>