| Subject: | Please add ttl and priority to list_records() |
This is extremely useful to dump completely zone data. Thanks
--- MySQL.pm 2008-02-16 01:39:38.000000000 +0100
+++ PowerDNS/Backend/MySQL.pm 2008-02-23 10:45:48.000000000 +0100
@@ -295,11 +295,11 @@
my $domain = shift;
my @records;
- my $sth = $self->{'dbh'}->prepare("SELECT name,content FROM
records WHERE type = ? and domain_id = (SELECT id FROM domains WHERE name =
+ my $sth = $self->{'dbh'}->prepare("SELECT name,content,ttl,prio
FROM records WHERE type = ? and domain_id = (SELECT id FROM domains WHE
$sth->execute($$rr,$$domain);
- while ( my ($name,$content) = $sth->fetchrow_array )
- { push @records , [ ($name,$content) ]; } # push anonymous array
on to end.
+ while ( my ($name,$content,$ttl,$prio) = $sth->fetchrow_array )
+ { push @records , [ ($name,$content,$ttl,$prio) ]; } # push
anonymous array on to end.
return \@records;
}