I gang

Check IP's against DNSBL's

I'm looking to automate checking a list of IP's against the DNSBL's, either via Pear/Cpan NET_DNSBL.

DB Structure:

CREATE TABLE `authsmtpdomains` (

`id` INT(11) NOT NULL AUTO_INCREMENT,

`user_id` INT(11) NOT NULL,

`ip` VARCHAR(16) NOT NULL,

`company_domain` VARCHAR(100) NOT NULL,

`authenticated_domain` VARCHAR(100) NOT NULL,

`status` TINYINT(1) NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `dnsbl` (

`user_id` int(11) NOT NULL,

`datetime` DATETIME NULL,

`source` VARCHAR(100) NOT NULL,

`url` VARCHAR(100) NOT NULL

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--------------------------------------------------------

1) Check IP's against DNSBL's - Cron Job Script: (runs hourly)

a) IF authsmtpdomains.status=3 THEN check each user_id [url removed, login to view] against all black lists

b) IF IP found in blacklist, then create record in dnsbl table for user_id.

datetime = NOW

source = blacklist (e.g. [url removed, login to view])

url = removal url (or url of info)

c) Remove any records in dnsbl table that are no longer blacklisted.

d) Repeat until finished

Variables to hardcode at top of script;

mysql_host / mysql_db / mysql_username / mysql_password

----------------------------------------------------------

I need as many blacklists supporting as possible (80+).

Please see attachment.

Færdigheder: Linux, MySQL, Perl, PHP

Se mere: php script null, check blacklists, s+db, S&M, pear, null, hardcode, check, blacklist ip, remove blacklist, datetime, table perl, perl table, url check, hardcode php, please check attachment, blacklist check, check status, list status net, please check url, primary key, via status net, script php null, php remove url, url datetime

Om arbejdsgiveren:
( 30 bedømmelser ) Brixham, United Kingdom

Projekt-ID: #931590

3 freelancere byder i gennemsnit $133 for dette job

shuiwatermizu

please see pm

$60 USD in 0 dage
(93 bedømmelser)
6.4
viewaskew

please see pm

$90 USD in 0 dage
(1 bedømmelse)
0.0
memento78

i can do it for you

$250 USD in 5 dage
(0 bedømmelser)
0.0