Find Jobs
Hire Freelancers

Update RBL check script with DB functions

€30-250 EUR

Færdiggjort
Slået op over 4 år siden

€30-250 EUR

Betales ved levering
Update RBL check script with DB functions RBL servers are in array $rbls in the script we store them in DB TO DO get them from DB $sql = "SELECT * FROM `rblservers` WHERE `use` = 'true'"; and place it in array get clientnumbers from DB $sqlclientsresult = "SELECT clientnr FROM `clients`"; for each client get ipaddresses to check $ip is in the script now We have a table ipaddress where all IP's are in, get them from table and do rblcheck for each We store the IP as longip $sqlclientsipsresult = "SELECT id, inet_ntoa(longip) as IP FROM `ipaddress` WHERE `clientid` = '" . $rowclients['clientnr'] . "' AND `test` = '1'"; $nu = gmdate($this->dateFormat, time()); Store the scan for the ip listedinrbl is amount of RBL where IP is positive INSERT INTO `rbltests` (`id`, `ipaddressid`, `datetime`, `listedinrbl`) If listed store it rblpositive INSERT INTO `rblpositive` (`ipid`, `rblserverid`, `datetimefirstfound`, `datetimelastfound`, `listed`) INSERT INTO `rblpositive` (`ipid`, `rblserverid`, `datetimefirstfound`, `listed`) VALUES ('1', '8', '$nu', '1') If solved UPDATE `rblpositive` SET `datetimelastfound`='$nu', `listed`='0' This script uses $rev = join('.', array_reverse(explode('.', trim($ip)))); $lookup = sprintf('%s.%s', $rev, $rbl); $listed = gethostbyname($lookup) !== $lookup; for the tests Another solution is: $reversedIP = implode('.', array_reverse(explode ('.', $ip))); // Do the DNS lookup $result = ""; exec("nslookup " . $reversedIP . "." . $value, $result); Please test which works best: fastest versus server load
Projekt-ID: 20826986

Om projektet

2 forslag
Projekt på afstand
Aktiv 5 år siden

Leder du efter muligheder for at tjene penge?

Fordele ved budafgivning på Freelancer

Fastsæt dit budget og din tidsramme
Bliv betalt for dit arbejde
Oprids dit forslag
Det er gratis at skrive sig op og byde på jobs
Tildel til:
Brug Avatar.
Hello there, As discussed in chat, the project is already finished and completed. Looking forward to working on more projects.
€105 EUR på 1 dag
5,0 (131 anmeldelser)
6,3
6,3

Om klienten

Flag for BELGIUM
Brugge, Belgium
5,0
41
Betalingsmetode verificeret
Medlem siden feb. 4, 2008

Klientverificering

Tak! Vi har sendt dig en e-mail med et link, så du kan modtage din kredit.
Noget gik galt, da vi forsøgte at sende din mail. Prøv venligst igen.
Registrerede brugere Oprettede jobs i alt
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Indlæser forhåndsvisning
Geolokalisering er tilladt.
Din session er udløbet, og du er blevet logget ud. Log venligst ind igen.