Changeset 92
- Timestamp:
- 09/16/25 15:56:31 (9 hours ago)
- Location:
- trunk/dnsbl
- Files:
-
- 5 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/dnsbl/DNSBL.pm
r77 r92 206 206 while (my ($masklen,$ipcount) = $sth->fetchrow_array) { 207 207 $autolist{$masklen} = $ipcount; 208 } 209 my $sth = $dbh->prepare("SELECT key,value FROM misc"); 210 $sth->execute; 211 while (my ($key,$value) = $sth->fetchrow_array) { 212 $self->{misc}{$key} = $value; 208 213 } 209 214 return $dbh; -
trunk/dnsbl/browse.cgi
r73 r92 67 67 $ENV{HTML_TEMPLATE_ROOT} = $templatedir; 68 68 69 my %config;70 my $sth = $dbh->prepare("SELECT key,value FROM misc");71 $sth->execute;72 while (my ($key,$value) = $sth->fetchrow_array) {73 $config{$key} = $value;74 }75 76 69 # basic validation so we don't try to look up something ridiculous 77 70 if ($webvar{block}) { … … 83 76 my $template = HTML::Template->new(filename => "browse.tmpl"); 84 77 85 $template->param(pgtitle => $ config{pgtitle}) if defined($config{pgtitle});86 $template->param(pgcomment => $ config{pgcomment}) if defined($config{pgcomment});78 $template->param(pgtitle => $dnsbl->{misc}{pgtitle}) if defined($dnsbl->{misc}{pgtitle}); 79 $template->param(pgcomment => $dnsbl->{misc}{pgcomment}) if defined($dnsbl->{misc}{pgcomment}); 87 80 88 81 my $out; … … 101 94 <html> 102 95 <head> 103 <title>$ config{pgtitle}</title>96 <title>$dnsbl->{misc}{pgtitle}</title> 104 97 <body> 105 $ config{pgcomment}<br>98 $dnsbl->{misc}{pgcomment}<br> 106 99 ); 107 100 if ($webvar{block}) { -
trunk/dnsbl/delist-ip
r73 r92 37 37 $dnsbl->connect; 38 38 39 my %config;40 my $sth = $dbh->prepare("SELECT key,value FROM misc");41 $sth->execute;42 while (my ($key,$value) = $sth->fetchrow_array) {43 $config{$key} = $value;44 }45 46 39 my $removeme = $ARGV[0]; 47 40 -
trunk/dnsbl/dnsbl.cgi
r78 r92 72 72 $ENV{HTML_TEMPLATE_ROOT} = $templatedir; 73 73 74 my %config;75 my $sth = $dbh->prepare("SELECT key,value FROM misc");76 $sth->execute;77 while (my ($key,$value) = $sth->fetchrow_array) {78 $config{$key} = $value;79 }80 81 74 # decide which page to spit out... 82 75 if (!$webvar{page}) { … … 86 79 } 87 80 88 $page->param(pgtitle => $ config{pgtitle}) if defined($config{pgtitle});89 $page->param(pgcomment => $ config{pgcomment}) if defined($config{pgcomment});81 $page->param(pgtitle => $dnsbl->{misc}{pgtitle}) if defined($dnsbl->{misc}{pgtitle}); 82 $page->param(pgcomment => $dnsbl->{misc}{pgcomment}) if defined($dnsbl->{misc}{pgcomment}); 90 83 91 84 if ($webvar{page} eq 'report') { -
trunk/dnsbl/export-dnsbl
r75 r92 35 35 $dnsbl->connect; 36 36 37 my %config;38 my $sth = $dbh->prepare("SELECT key,value FROM misc");39 $sth->execute;40 while (my ($key,$value) = $sth->fetchrow_array) {41 $config{$key} = $value;42 }43 44 37 my %iplist; 45 38 my $ipref = \%iplist; … … 56 49 if ($mode eq 'cidr') { 57 50 # SOA, NS records. Maybe dnscache needs them? 58 print "\$SOA 900 ".($ config{blzone} ? $config{blzone} : 'company.dnsbl')." ".59 ($ config{bladmin} ? $config{bladmin} : 'systems.company.com')." 0 1200 600 600 900\n".51 print "\$SOA 900 ".($dnsbl->{misc}{blzone} ? $dnsbl->{misc}{blzone} : 'company.dnsbl')." ". 52 ($dnsbl->{misc}{bladmin} ? $dnsbl->{misc}{bladmin} : 'systems.company.com')." 0 1200 600 600 900\n". 60 53 "\$NS 3600 127.0.0.1\n". 61 "\$TTL ".($ config{ttl} ? $config{ttl} : '900')."\n";54 "\$TTL ".($dnsbl->{misc}{ttl} ? $dnsbl->{misc}{ttl} : '900')."\n"; 62 55 63 56 # more or less raw CIDR block-and-IP info. rbldnsd format for convenience. … … 84 77 my $out = "$_:127.$entry:". 85 78 ($iplist{$_} & 2 ? 86 ($ config{iplisted} ? $config{iplisted} : '$ relayed a reported spam') :87 ($ config{blocklisted} ? $config{blocklisted} : 'Netblock listed on one or more criteria')79 ($dnsbl->{misc}{iplisted} ? $dnsbl->{misc}{iplisted} : '$ relayed a reported spam') : 80 ($dnsbl->{misc}{blocklisted} ? $dnsbl->{misc}{blocklisted} : 'Netblock listed on one or more criteria') 88 81 )."\n"; 89 82 $out =~ s/:ENTITY:/$_/; … … 111 104 my ($o1,$o2,$o3,$o4) = (/^(\d+)\.([\d*]+)(?:\.([\d*]+)(?:\.([\d*]+))?)?$/); 112 105 print "+".(defined($o4) ? "$o4." : '').(defined($o3) ? "$o3." : '').(defined($o2) ? "$o2." : ''). 113 "$o1.".($ config{blzone} ? $config{blzone} : 'spamhosts.company.dnsbl').":127.$entry:".114 ($ config{ttl} ? $config{ttl} : '900').":::\n";106 "$o1.".($dnsbl->{misc}{blzone} ? $dnsbl->{misc}{blzone} : 'spamhosts.company.dnsbl').":127.$entry:". 107 ($dnsbl->{misc}{ttl} ? $dnsbl->{misc}{ttl} : '900')."::\n"; 115 108 } 116 109 }
Note:
See TracChangeset
for help on using the changeset viewer.