aboutsummaryrefslogtreecommitdiffstats
path: root/web/api/public/location
diff options
context:
space:
mode:
authorOle Mathias Aa. Heggem <olemathias.aa.heggem@gmail.com>2018-03-17 18:03:23 +0100
committerOle Mathias Aa. Heggem <olemathias.aa.heggem@gmail.com>2018-03-17 18:03:23 +0100
commitdc97b997e8d6e5edc63c598c05090a8b98e79757 (patch)
tree42762b3582ec8416cc70527c178dda6498b90f19 /web/api/public/location
parent8607a0880724eca35c220f7c26a138d9f0f50f72 (diff)
Added support for delete switches
Diffstat (limited to 'web/api/public/location')
-rwxr-xr-xweb/api/public/location2
1 files changed, 1 insertions, 1 deletions
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";