Changeset 858 for trunk/cgi-bin/extras

Timestamp:

04/17/16 12:49:37 (9 years ago)

Author:

Kris Deugau

Message:

/trunk

Add an ORDER BY clause in db2rwhois.pl to make the output more predictable

File:

• trunk/cgi-bin/extras/db2rwhois.pl (modified) (1 diff)

trunk/cgi-bin/extras/db2rwhois.pl

@@ -79 +79 @@
         NOT (a.cidr <<= '172.16.0.0/12') AND
         NOT (a.cidr <<= '10.0.0.0/8') AND
-        NOT (a.type = 'wr' OR a.type = 'mm') AND
+        NOT (a.type = 'wr' OR a.type LIKE '_m') AND
         ((masklen(a.cidr) <=30 AND family(a.cidr)=4) OR (masklen(a.cidr) <=64 AND family(a.cidr)=6)) AND
         a.master_id = ? AND
         a.cidr <<= ?
+        ORDER BY a.cidr
         ) );