From dc97b997e8d6e5edc63c598c05090a8b98e79757 Mon Sep 17 00:00:00 2001 From: "Ole Mathias Aa. Heggem" Date: Sat, 17 Mar 2018 18:03:23 +0100 Subject: Added support for delete switches --- web/api/public/location | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'web/api/public/location') diff --git a/web/api/public/location b/web/api/public/location index 2247f73..b960bb2 100755 --- a/web/api/public/location +++ b/web/api/public/location @@ -8,7 +8,7 @@ use warnings; use Data::Dumper; #my $query = $nms::web::dbh->prepare("select * from switches where '185.110.150.7' << subnet4"); -my $query = $nms::web::dbh->prepare("select * from switches where ? << subnet4 or ? << subnet6"); +my $query = $nms::web::dbh->prepare("select * from switches where deleted = false and (? << subnet4 or ? << subnet6)"); print "Cache-Control: max-age=0"; print "Content-Type: text/html"; -- cgit v1.2.3