Changeset 578

Timestamp:

01/02/14 10:07:39 (11 years ago)

Author:

Kris Deugau

Message:

/trunk

Fix the fix in r576, retrieve the *right* SOA for each domain

File:

• trunk/DNSDB.pm (modified) (1 diff)

trunk/DNSDB.pm

@@ -5151 +5151 @@
 
   $soasth = $dbh->prepare("SELECT host,type,val,distance,weight,port,ttl,record_id,location ".
-        "FROM records WHERE rdns_id=? AND type=6");
+        "FROM records WHERE domain_id=? AND type=6");
   $recsth = $dbh->prepare("SELECT host,type,val,distance,weight,port,ttl,record_id,location,extract(epoch from stamp),expires,stampactive ".
         "FROM records WHERE domain_id=? AND NOT type=6");       # Just exclude all types relating to rDNS