X-Git-Url: https://git.sesse.net/?a=blobdiff_plain;f=web%2Fnettkart-telnet.pl;h=2a21bad5c397028be24e297696b29616595bb066;hb=cdd60722550e4c3fc22faf1d00b0214f0d08bce8;hp=b3ea2dfa124c8e7e3e04ec9dbeb1b73b03e9fbc6;hpb=f6cc98a589e8dd3b1b98151a70f6b5db98b2b04f;p=nms diff --git a/web/nettkart-telnet.pl b/web/nettkart-telnet.pl index b3ea2df..2a21bad 100755 --- a/web/nettkart-telnet.pl +++ b/web/nettkart-telnet.pl @@ -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+)\)/;