Changeset 439 for trunk

Timestamp:

11/02/12 13:17:57 (12 years ago)

Author:

Kris Deugau

Message:

/trunk

Extend record list filtering to check both host and val columns;
this will make it easier to find entries in large reverse zones.

File:

• trunk/DNSDB.pm (modified) (2 diffs)

trunk/DNSDB.pm

@@ -3438 +3438 @@
   $sql .= "WHERE "._recparent($args{defrec},$args{revrec})." = ?";
   $sql .= " AND NOT r.type=$reverse_typemap{SOA}";
-  $sql .= " AND host ~* ?" if $args{filter};
+  $sql .= " AND (r.host ~* ? OR r.val ~* ?)" if $args{filter};
   $sql .= " ORDER BY $newsort $args{sortorder}";
   # ensure consistent ordering by sorting on record_id too
@@ -3445 +3445 @@
 
   my @bindvars = ($args{id});
-  push @bindvars, $args{filter} if $args{filter};
+  push @bindvars, ($args{filter},$args{filter}) if $args{filter};
 
   my $ret = $dbh->selectall_arrayref($sql, { Slice => {} }, (@bindvars) );