diff options
| author | Kristian Lyngstol <kristian@bohemians.org> | 2015-04-21 17:14:45 +0200 |
|---|---|---|
| committer | Kristian Lyngstol <kristian@bohemians.org> | 2015-04-21 17:14:45 +0200 |
| commit | 56a38583fd770ad8851de49485489e30baa7467c (patch) | |
| tree | 5edd90db060d8b61d2ae74f5800b806a972eb44a /web/nms.gathering.org/port-state.pl | |
| parent | 0443c94d44ecf94d10f47bba2945e695bd16da12 (diff) | |
NMS: More coarse-tuning of comments
Wouldn't call it fine tuning.
Now got active/inactive/persists/delete state working OK, and things are
showing up prettier.
Diffstat (limited to 'web/nms.gathering.org/port-state.pl')
| -rwxr-xr-x | web/nms.gathering.org/port-state.pl | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/web/nms.gathering.org/port-state.pl b/web/nms.gathering.org/port-state.pl index 83e15f1..b21bd8d 100755 --- a/web/nms.gathering.org/port-state.pl +++ b/web/nms.gathering.org/port-state.pl @@ -73,7 +73,7 @@ my $q5 = $dbh->prepare ('select ' . $now . ' as time;'); $q5->execute(); $json{'time'} = $q5->fetchrow_hashref()->{'time'}; -my $q6 = $dbh->prepare('select sysname,extract(epoch from date_trunc(\'second\',time)) as time,state,username,id,comment from switch_comments natural join switches order by time desc'); +my $q6 = $dbh->prepare('select sysname,extract(epoch from date_trunc(\'second\',time)) as time,state,username,id,comment from switch_comments natural join switches where state != \'delete\' order by time desc'); $q6->execute(); while (my $ref = $q6->fetchrow_hashref()) { push @{$json{'switches'}{$ref->{'sysname'}}{'comments'}},$ref; |