Changeset 347 for trunk/DNSDB.pm

Timestamp:

06/15/12 18:08:14 (12 years ago)

Author:

Kris Deugau

Message:

/trunk

Clean up dns.sql a little; some of this will be more important once
automagical table upgrades are implemented

• set primary keys so we can't even accidentally add duplicate domains or revzones
• bump dbversion in misc table

Fix buglet in _hostparent() that triggered if the hostname passed in
started with *.

File:

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

trunk/DNSDB.pm

@@ -296 +296 @@
   my $dbh = shift;
   my $hname = shift;
-  
+
+  $hname =~ s/^\*\.//;  # this should be impossible to find in the domains table.
   my @hostbits = split /\./, $hname;
   my $sth = $dbh->prepare("SELECT count(*),domain_id FROM domains WHERE domain = ? GROUP BY domain_id");