1 | #!/usr/bin/perl
|
---|
2 |
|
---|
3 | use strict;
|
---|
4 | use warnings;
|
---|
5 | no warnings qw(uninitialized);
|
---|
6 | use CGI::Carp qw (fatalsToBrowser);
|
---|
7 | use CGI::Simple;
|
---|
8 | use HTML::Template;
|
---|
9 | use DNSBL;
|
---|
10 |
|
---|
11 | # Set up the CGI object...
|
---|
12 | my $q = new CGI::Simple;
|
---|
13 | # ... and get query-string params as well as POST params if necessary
|
---|
14 | $q->parse_query_string;
|
---|
15 |
|
---|
16 | my %webvar;
|
---|
17 | # This is probably excessive fiddling, but it puts the parameters somewhere my fingers know about...
|
---|
18 | foreach ($q->param()) {
|
---|
19 | $webvar{$_} = $q->param($_);
|
---|
20 | }
|
---|
21 |
|
---|
22 | my $dnsbl = new DNSBL;
|
---|
23 |
|
---|
24 | my $dbh = $dnsbl->connect;
|
---|
25 |
|
---|
26 | print "Content-type: text/html\n\n";
|
---|
27 |
|
---|
28 | my $page;
|
---|
29 | my $templatedir = "templates";
|
---|
30 |
|
---|
31 | # decide which page to spit out...
|
---|
32 | if (!$webvar{page}) {
|
---|
33 | $page = HTML::Template->new(filename => "$templatedir/index.tmpl");
|
---|
34 | } else {
|
---|
35 | $page = HTML::Template->new(filename => "$templatedir/$webvar{page}.tmpl");
|
---|
36 | }
|
---|
37 |
|
---|
38 | if ($webvar{page} eq 'report') {
|
---|
39 | $page->param(ip => $webvar{ip});
|
---|
40 | my $count = $dnsbl->ipexists($webvar{ip});
|
---|
41 | $page->param(nreports => $count) if $count;
|
---|
42 | $page->param(browsebits => browse($dbh,$webvar{ip}));
|
---|
43 | for (my $i=0; $i<3; $i++) {
|
---|
44 | my ($block,$org) = $dnsbl->getcontainer($webvar{ip},$i);
|
---|
45 | if ($block) {
|
---|
46 | $page->param("block$i" => $block);
|
---|
47 | $page->param("org$i" => $org);
|
---|
48 | }
|
---|
49 | }
|
---|
50 | } elsif ($webvar{page} eq 'dbreport') {
|
---|
51 | my $err = '';
|
---|
52 | my $count = $dnsbl->report($webvar{ip});
|
---|
53 | my $org0id = $dnsbl->orgexists($webvar{org0});
|
---|
54 | if (!$org0id) {
|
---|
55 | $org0id = $dnsbl->addorg($webvar{org0});
|
---|
56 | $page->param(org0 => $webvar{org0});
|
---|
57 | }
|
---|
58 | if (!$dnsbl->blockexists($webvar{block0})) {
|
---|
59 | my $ret = $dnsbl->addblock($webvar{block0}, $org0id, 0);
|
---|
60 | $err .= "error adding $webvar{block0}: $ret<br>\n" if $ret;
|
---|
61 | $page->param(block0 => $webvar{block0});
|
---|
62 | }
|
---|
63 | # yes, this is grotty. PTHBTT!
|
---|
64 | if ($webvar{block1}) {
|
---|
65 | my $org1id = $dnsbl->orgexists($webvar{org1});
|
---|
66 | if (!$org1id) {
|
---|
67 | $org1id = $dnsbl->addorg($webvar{org1});
|
---|
68 | $page->param(org1 => $webvar{org1});
|
---|
69 | }
|
---|
70 | if (!$dnsbl->blockexists($webvar{block1})) {
|
---|
71 | my $ret = $dnsbl->addblock($webvar{block1}, $org1id, 1);
|
---|
72 | $err .= "error adding $webvar{block1}: $ret<br>\n" if $ret;
|
---|
73 | $page->param(block1 => $webvar{block1});
|
---|
74 | }
|
---|
75 | if ($webvar{block2}) {
|
---|
76 | my $org2id = $dnsbl->orgexists($webvar{org2});
|
---|
77 | if (!$org2id) {
|
---|
78 | $org2id = $dnsbl->addorg($webvar{org2});
|
---|
79 | $page->param(org2 => $webvar{org2});
|
---|
80 | }
|
---|
81 | if (!$dnsbl->blockexists($webvar{block2})) {
|
---|
82 | my $ret = $dnsbl->addblock($webvar{block2}, $org2id, 2);
|
---|
83 | $err .= "error adding $webvar{block2}: $ret<br>\n" if $ret;
|
---|
84 | $page->param(block2 => $webvar{block2});
|
---|
85 | }
|
---|
86 | }
|
---|
87 | }
|
---|
88 |
|
---|
89 | $page->param(ip => $webvar{ip});
|
---|
90 | $page->param(err => $err);
|
---|
91 | }
|
---|
92 | print $page->output;
|
---|
93 |
|
---|
94 | exit 0;
|
---|
95 |
|
---|
96 |
|
---|
97 |
|
---|
98 | ## extra subs. should probably put this in a module somehow to share with browse.cgi
|
---|
99 |
|
---|
100 | sub browse {
|
---|
101 | my $dbh = shift;
|
---|
102 | my $ip = shift;
|
---|
103 |
|
---|
104 | my $basesql = "SELECT b.block,o.orgname,b.listme,o.listme,b.comments,o.comments ".
|
---|
105 | "FROM blocks b INNER JOIN orgs o ON b.orgid=o.orgid ".
|
---|
106 | "WHERE b.block ";
|
---|
107 |
|
---|
108 | my $sth0 = $dbh->prepare($basesql." >> ? AND b.level=0 ORDER BY block");
|
---|
109 | my $sth1 = $dbh->prepare($basesql." <<= ? AND b.level=1 ORDER BY block");
|
---|
110 | my $sth2 = $dbh->prepare($basesql." <<= ? AND b.level=2 ORDER BY block");
|
---|
111 | my $sthiplist = $dbh->prepare("select * from iplist where ip <<= ? order by ip");
|
---|
112 |
|
---|
113 | my %ipseen;
|
---|
114 | my $out = '';
|
---|
115 |
|
---|
116 | $sth0->execute($ip);
|
---|
117 | while (my ($block0,$org0,$listmeb0,$listmeo0,$bcomments0,$ocomments0) = $sth0->fetchrow_array) {
|
---|
118 | $out .= "<div class=\"lvl0".($dnsbl->autolist_block($block0) ? ' auto0"' : '"').
|
---|
119 | "><span".($listmeb0 ? ' class=b0list' : '').">$block0".
|
---|
120 | ($listmeb0 ? " ($bcomments0)" : '')."</span> ".
|
---|
121 | "<span".($listmeo0 ? ' class=b0org' : '').">$org0".
|
---|
122 | ($listmeo0 ? " ($ocomments0)" : '')."</span>\n";
|
---|
123 | $sth1->execute($block0);
|
---|
124 | if ($sth1->rows > 0) {
|
---|
125 | while (my ($block1,$org1,$listmeb1,$listmeo1,$bcomments1,$ocomments1) = $sth1->fetchrow_array) {
|
---|
126 | # lvl 1 div open
|
---|
127 | $out .= " <div class=\"lvl1".($dnsbl->autolist_block($block1) ? ' auto1"' : '"').
|
---|
128 | "><span".($listmeb1 ? ' class=b1list' : '').">$block1".
|
---|
129 | ($listmeb1 ? " ($bcomments1)" : '')."</span> ".
|
---|
130 | "<span".($listmeo1 ? ' class=b1org' : '').">$org1".
|
---|
131 | ($listmeo1 ? " ($ocomments1)" : '')."</span>\n";
|
---|
132 | $sth2->execute($block1);
|
---|
133 | if ($sth2->rows > 0) {
|
---|
134 | while (my ($block2,$org2,$listmeb2,$listmeo2,$bcomments2,$ocomments2) = $sth2->fetchrow_array) {
|
---|
135 | # lvl 2 div open
|
---|
136 | $out .= " <div class=\"lvl2".($dnsbl->autolist_block($block2) ? ' auto2"' : '"').
|
---|
137 | "><span".($listmeb2 ? ' class=b2list' : '').">$block2".
|
---|
138 | ($listmeb2 ? " ($bcomments2)" : '')."</span> ".
|
---|
139 | "<span".($listmeo2 ? ' class=b2org' : '').">$org2".
|
---|
140 | ($listmeo2 ? " ($ocomments2)" : '')."</span>\n";
|
---|
141 | $sthiplist->execute($block2);
|
---|
142 | $out .= " <div class=iplist>\n";
|
---|
143 | while (my @data4 = $sthiplist->fetchrow_array) {
|
---|
144 | # ip | count | s4list | added
|
---|
145 | $out .= " $data4[0] ($data4[1])<br>\n";
|
---|
146 | $ipseen{$data4[0]} = 1;
|
---|
147 | }
|
---|
148 | $out .= " </div>\n";
|
---|
149 | # lvl2 div close
|
---|
150 | $out .= " </div>\n";
|
---|
151 | }
|
---|
152 | } else {
|
---|
153 | $sthiplist->execute($block1);
|
---|
154 | $out .= " <div class=iplist>\n";
|
---|
155 | while (my @data4 = $sthiplist->fetchrow_array) {
|
---|
156 | # ip | count | s4list | added
|
---|
157 | $out .= " $data4[0] ($data4[1])<br>\n";
|
---|
158 | $ipseen{$data4[0]} = 1;
|
---|
159 | }
|
---|
160 | $out .= " </div>\n";
|
---|
161 | }
|
---|
162 |
|
---|
163 | my $sqlalt = "select ip from iplist where ip << ?";
|
---|
164 | my $sthalt = $dbh->prepare($sqlalt);
|
---|
165 | $sthalt->execute($block1);
|
---|
166 | my @newips;
|
---|
167 | while (my @data4 = $sthalt->fetchrow_array) {
|
---|
168 | push @newips, $data4[0] if !$ipseen{$data4[0]};
|
---|
169 | $ipseen{$data4[0]} = 1;
|
---|
170 | }
|
---|
171 | if ($#newips > -1) {
|
---|
172 | $out .= " <div class=iplist>\n";
|
---|
173 | foreach (@newips) {
|
---|
174 | $out .= " $_ ($ipseen{$_})<br>\n";
|
---|
175 | }
|
---|
176 | $out .= " </div>\n";
|
---|
177 | }
|
---|
178 | # lvl 1 div close
|
---|
179 | $out .= " </div>\n";
|
---|
180 | }
|
---|
181 | } else {
|
---|
182 | $sthiplist->execute($block0);
|
---|
183 | $out .= " <div class=iplist>\n";
|
---|
184 | while (my @data4 = $sthiplist->fetchrow_array) {
|
---|
185 | # ip | count | s4list | added
|
---|
186 | $out .= " $data4[0] ($data4[1])<br>\n";
|
---|
187 | $ipseen{$data4[0]} = 1;
|
---|
188 | }
|
---|
189 | $out .= " </div>\n";
|
---|
190 | }
|
---|
191 |
|
---|
192 | my $sqlalt = "select ip from iplist where ip << ?";
|
---|
193 | my $sthalt = $dbh->prepare($sqlalt);
|
---|
194 | $sthalt->execute($block0);
|
---|
195 | my @newips;
|
---|
196 | while (my @data4 = $sthalt->fetchrow_array) {
|
---|
197 | push @newips, $data4[0] if (!$ipseen{$data4[0]});
|
---|
198 | }
|
---|
199 | if ($#newips > -1) {
|
---|
200 | $out .= " <div class=iplist>\n";
|
---|
201 | foreach (@newips) {
|
---|
202 | $out .= " $_<br>\n";
|
---|
203 | }
|
---|
204 | $out .= " </div>\n";
|
---|
205 | }
|
---|
206 |
|
---|
207 | $out .= "</div>\n";
|
---|
208 | }
|
---|
209 |
|
---|
210 | return $out;
|
---|
211 | } # end browse()
|
---|