NMS: Bump location and placement

2 files changed, 3 insertions, 3 deletions

diff --git a/web/nms.gathering.org/api/public/location b/web/nms.gathering.org/api/public/location
index 6c25ab9..b940007 100755
--- a/web/nms.gathering.org/api/public/location
+++ b/web/nms.gathering.org/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");
+my $query = $nms::web::dbh->prepare("select * from switches where ? << subnet4 or ? << subnet6");
 
 print "Cache-Control: max-age=0";
 print "Content-Type: text/html";
@@ -20,7 +20,7 @@ print "\n\n";
 my @xff = split(",",$ENV{HTTP_X_FORWARDED_FOR});
 my $addr = $xff[0] // $ENV{REMOTE_ADDR};
 
-$query->execute($addr);
+$query->execute($addr,$addr);
 
 # add start html: header + body etc.
 print "
diff --git a/web/nms.gathering.org/api/read/switches-management b/web/nms.gathering.org/api/read/switches-management
index 9e12337..4461a90 100755
--- a/web/nms.gathering.org/api/read/switches-management
+++ b/web/nms.gathering.org/api/read/switches-management
@@ -12,7 +12,7 @@ use Data::Dumper;
 
 $nms::web::cc{'max-age'} = "60";
 
-my $q2 = $nms::web::dbh->prepare('select switch,sysname,mgmt_v4_addr,subnet4,subnet6,mgmt_v6_addr,mgmt_v4_gw,mgmt_v6_gw,mgmt_vlan,traffic_vlan,last_config_fetch,current_mac,poll_frequency,last_updated from switches where placement is not null');
+my $q2 = $nms::web::dbh->prepare('select switch,sysname,mgmt_v4_addr,subnet4,subnet6,mgmt_v6_addr,mgmt_v4_gw,mgmt_v6_gw,mgmt_vlan,traffic_vlan,last_config_fetch,current_mac,poll_frequency,last_updated,distro_phy_port from switches where placement is not null');
 
 $q2->execute();
 while (my $ref = $q2->fetchrow_hashref()) {