diff options
| author | Simon Rettberg | 2019-08-01 11:48:05 +0200 |
|---|---|---|
| committer | Simon Rettberg | 2019-08-01 11:48:05 +0200 |
| commit | db48d5f65579e7c69ce11d5258e7d9f647108f1f (patch) | |
| tree | e64134b281b60c5b5671a94965947462aeb0a476 | |
| parent | [locations] Refine location matching checks (diff) | |
| download | slx-admin-db48d5f65579e7c69ce11d5258e7d9f647108f1f.tar.gz slx-admin-db48d5f65579e7c69ce11d5258e7d9f647108f1f.tar.xz slx-admin-db48d5f65579e7c69ce11d5258e7d9f647108f1f.zip | |
[locations] Sort subnets by address in subnet view
| -rw-r--r-- | modules-available/locations/pages/subnets.inc.php | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/modules-available/locations/pages/subnets.inc.php b/modules-available/locations/pages/subnets.inc.php index 6c37129a..381023d2 100644 --- a/modules-available/locations/pages/subnets.inc.php +++ b/modules-available/locations/pages/subnets.inc.php @@ -51,7 +51,9 @@ class SubPage { if ($getAction === false) { User::assertPermission('subnets.edit', NULL, '?do=locations'); - $res = Database::simpleQuery("SELECT subnetid, startaddr, endaddr, locationid FROM subnet"); + $res = Database::simpleQuery("SELECT subnetid, startaddr, endaddr, locationid + FROM subnet + ORDER BY startaddr ASC, endaddr DESC"); $rows = array(); while ($row = $res->fetch(PDO::FETCH_ASSOC)) { $row['startaddr'] = long2ip($row['startaddr']); |