From: Arjen Baart Date: Tue, 10 Nov 2020 07:00:02 +0000 (+0100) Subject: Provide a web interface for dropped IP addresses X-Git-Url: http://www.andromeda.nl/gitweb/?p=gnucomo.git;a=commitdiff_plain;h=7e2b806f26741a643fe74ed5c09be6d0189f5ac9 Provide a web interface for dropped IP addresses --- diff --git a/src/web/dropped.php b/src/web/dropped.php new file mode 100644 index 0000000..08264f9 --- /dev/null +++ b/src/web/dropped.php @@ -0,0 +1,63 @@ +read("gnucomo"); + + // A special user for accessing dropped addresses + + $name = "firewall"; + $passw = "Gnuc0mo-Ab4se"; + + $database = pg_connect($config->Database($name, $passw)); + + $query = "select source from object_abuse where status='dropped' and family(source)=4"; + + if (!empty($_GET['object'])) + { + $object_query = "SELECT objectid FROM object WHERE objectname='" . $_GET['object']."'"; + $res = pg_exec($database, $object_query); + $obj = pg_fetch_object($res, 0); + + $query .= " and objectid=" . $obj->objectid; + } + + $query .= " order by source"; + + + $res = pg_exec($database, $query); + + for ($ip = 0; $ip < pg_num_rows($res); $ip++) + { + $abuse = pg_fetch_object($res, $ip); + echo $abuse->source; + echo "\n"; + } +} +else +{ + echo "Permission denied.\n"; +} +?>