Changeset 149 for trunk/tools/dnszones-poller

Timestamp:

03/01/2006 04:59:17 AM (6 years ago)

Author:

Winner

Message:

Fix: DNS zone nameservers ordering on dns zones form update.
Fix: DNS zone nameservers ordering on dns poller tool.

File:

• trunk/tools/dnszones-poller/dnszones-poller.php (modified) (2 diffs)

trunk/tools/dnszones-poller/dnszones-poller.php

@@ -48 +48 @@
                           INNER JOIN nodes ON dns_nameservers.node_id = nodes.id
                           WHERE dns_nameservers.status = 'active' AND dns_zones.type = 'forward' AND dns_zones.status = 'active'
-                          ORDER BY dns_zones.name ASC";
+                          ORDER BY dns_zones.name ASC, dns_zones_nameservers.id ASC";
         $q = mysql_query($query, $mysql_link);
         echo mysql_error();
@@ -92 +92 @@
                           INNER JOIN nodes ON dns_nameservers.node_id = nodes.id
                           WHERE dns_nameservers.status = 'active' AND dns_zones.type = 'reverse' AND dns_zones.status = 'active'
-                          ORDER BY dns_zones.name ASC";
+                          ORDER BY dns_zones.name ASC, dns_zones_nameservers.id ASC";
         $q = mysql_query($query, $mysql_link);
         echo mysql_error();