X-Git-Url: https://git.sesse.net/?a=blobdiff_plain;f=web%2Fnettkart-web.pl;h=8f37b1efd12b63b6af21aa73879934bbee47c4c3;hb=cdd60722550e4c3fc22faf1d00b0214f0d08bce8;hp=040d4767865e5ee2a5566a60ff079caf0be4933f;hpb=8c3c9e3b907b47ea0aa1f89d75d80d618fde9e95;p=nms diff --git a/web/nettkart-web.pl b/web/nettkart-web.pl index 040d476..8f37b1e 100755 --- a/web/nettkart-web.pl +++ b/web/nettkart-web.pl @@ -6,7 +6,7 @@ use nms; my $cgi = CGI->new; my $dbh = nms::db_connect(); -print $cgi->header(-type=>'text/html', -refresh=>'45; http://nms.tg07.gathering.org/nettkart-web.pl'); +print $cgi->header(-type=>'text/html; charset=utf-8', -refresh=>'45; http://nms.tg07.gathering.org/nettkart-web.pl'); print <<"EOF"; @@ -17,10 +17,7 @@ print <<"EOF"; EOF -my $q = $dbh->prepare('select * from switches natural join placements natural left join -( select switch,sum(bytes_in)/count(*) as -bytes_in,sum(bytes_out)/count(*) as bytes_out from get_datarate() group -by switch ) t1'); +my $q = $dbh->prepare('select * from switches natural join placements'); $q->execute(); while (my $ref = $q->fetchrow_hashref()) { $ref->{'placement'} =~ /\((\d+),(\d+)\),\((\d+),(\d+)\)/;