Show ordered results after a search for SUBNET

phpipam open-source IP address management

Brought to you by: myha

#37 Show ordered results after a search for SUBNET

Milestone: Unstable_(example)

Status: open

Owner: nobody

Labels: search (2)

Priority: 5

Updated: 2015-10-27

Created: 2015-10-27

Private: No

Miha Petkovsek ,

This patch returns ordered results from a search for subnets:

Version: 1.1.010
phpipam/functions/functions-tools.php
Line 647

--- orig/functions-tools.php 2015-10-27 15:37:35.339198275 -0200
+++ new/functions-tools.php 2015-10-27 15:37:18.431561123 -0200
@@ -644,7 +644,7 @@

 /* set query */
 if($searchTermEdited['low']==0 && $searchTermEdited['high']==0) {

$query[] = 'select * from subnets where description like "%'. $searchterm .'%" '.$custom.';';
$query[] = 'select * from subnets where description like "%'. $searchterm .'%" '.$custom.' order by subnet ;';
} else {
$query[] = 'select * from subnets where description like "%'. $searchterm .'%" or subnet between "'. $searchTermEdited['low'] .'" and "'. $searchTermEdited['high'] .'" '.$custom.';';
}
@@ -1279,4 +1279,4 @@

Anonymous