diff options
| author | Knut Auvor Grythe <knut@auvor.no> | 2015-04-02 08:54:36 +0200 |
|---|---|---|
| committer | root <root@einstein.tg15.gathering.org> | 2015-04-02 08:54:36 +0200 |
| commit | 9f03931fce78a2fe2a21852f7228ea093493d60f (patch) | |
| tree | 432ee0724559a8c4d696eaec01ea306ab4c5b6b6 /web/nms.gathering.org/uplinkkart.pl | |
| parent | d1eeb0c628ec5cbdb9649a241a02f97016b83015 (diff) | |
Update all maps to use the poll2 table
Diffstat (limited to 'web/nms.gathering.org/uplinkkart.pl')
| -rwxr-xr-x | web/nms.gathering.org/uplinkkart.pl | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/web/nms.gathering.org/uplinkkart.pl b/web/nms.gathering.org/uplinkkart.pl index a72edcc..48eefff 100755 --- a/web/nms.gathering.org/uplinkkart.pl +++ b/web/nms.gathering.org/uplinkkart.pl @@ -40,7 +40,7 @@ for my $ports (0..4) { $img->stringFT($blk, "/usr/share/fonts/truetype/msttcorefonts/Arial.ttf", 10, 0, 40, $y + 10, $ports); } -my $q = $dbh->prepare(' select switch,sysname,(select placement from placements where placements.switch = switches.switch) as placement,count((operstatus = 1) or null) as active_ports from switches natural left join get_operstatus() natural join placements where ifdescr = \'ge-0/0/44\' or ifdescr = \'ge-0/0/45\' or ifdescr = \'ge-0/0/46\' or ifdescr = \'ge-0/0/47\' group by switch,sysname'); +my $q = $dbh->prepare(' select switch,sysname,(select placement from placements where placements.switch = switches.switch) as placement,count((ifoperstatus = 1) or null) as active_ports from switches natural left join get_operstatus() natural join placements where ifdescr = \'ge-0/0/44\' or ifdescr = \'ge-0/0/45\' or ifdescr = \'ge-0/0/46\' or ifdescr = \'ge-0/0/47\' group by switch,sysname'); $q->execute(); while (my $ref = $q->fetchrow_hashref()) { my $ports = $ref->{'active_ports'}; |