From 56a38583fd770ad8851de49485489e30baa7467c Mon Sep 17 00:00:00 2001 From: Kristian Lyngstol Date: Tue, 21 Apr 2015 17:14:45 +0200 Subject: 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. --- web/nms.gathering.org/port-state.pl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'web/nms.gathering.org/port-state.pl') 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; -- cgit v1.2.3