aboutsummaryrefslogtreecommitdiffstats
path: root/web
diff options
context:
space:
mode:
authorKristian Lyngstol <kly@kly.no>2016-03-04 18:40:51 +0000
committerKristian Lyngstol <kly@kly.no>2016-03-04 18:40:51 +0000
commitb4527d6f786ec856f0346a600db81aaf849bb363 (patch)
treebde2151f7490f0e07068f34ac9f4427de8bcb212 /web
parent15dde408db57009e1e4e26d969b9b3e6c1e0c255 (diff)
NMS: Remove now redundant "Security" things
Better to have proper isolation than this crud.
Diffstat (limited to 'web')
-rwxr-xr-xweb/nms.gathering.org/api/private/port-state2
-rwxr-xr-xweb/nms.gathering.org/api/public/switch-state2
2 files changed, 2 insertions, 2 deletions
diff --git a/web/nms.gathering.org/api/private/port-state b/web/nms.gathering.org/api/private/port-state
index 6410805..1f30181 100755
--- a/web/nms.gathering.org/api/private/port-state
+++ b/web/nms.gathering.org/api/private/port-state
@@ -6,7 +6,7 @@ use nms::web;
use strict;
use warnings;
-my $query = 'select sysname,extract(epoch from date_trunc(\'second\',time)) as time, '.$nms::web::ifname.',ifhighspeed,ifhcinoctets,ifhcoutoctets from polls natural join switches where time in (select max(time) from polls where ' . $nms::web::when . ' group by switch,ifname);';
+my $query = 'select sysname,extract(epoch from date_trunc(\'second\',time)) as time, ifname,ifhighspeed,ifhcinoctets,ifhcoutoctets from polls natural join switches where time in (select max(time) from polls where ' . $nms::web::when . ' group by switch,ifname);';
my $q = $nms::web::dbh->prepare($query);
$q->execute();
diff --git a/web/nms.gathering.org/api/public/switch-state b/web/nms.gathering.org/api/public/switch-state
index 81e8d91..e494e6d 100755
--- a/web/nms.gathering.org/api/public/switch-state
+++ b/web/nms.gathering.org/api/public/switch-state
@@ -6,7 +6,7 @@ use nms::web;
use strict;
use warnings;
-my $query = 'select sysname,extract(epoch from date_trunc(\'second\',time)) as time, '.$nms::web::ifname.',ifhighspeed,ifhcinoctets,ifhcoutoctets from polls natural join switches where time in (select max(time) from polls where ' . $nms::web::when . ' group by switch,ifname);';
+my $query = 'select sysname,extract(epoch from date_trunc(\'second\',time)) as time, ifname,ifhighspeed,ifhcinoctets,ifhcoutoctets from polls natural join switches where time in (select max(time) from polls where ' . $nms::web::when . ' group by switch,ifname);';
my $q = $nms::web::dbh->prepare($query);
$q->execute();