Re: Blocking off access
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 63198
interpreted = N
texte = The format of the lines is like this 85.239.224.0 85.239.255.255 cz 86.49.0.0 86.49.255.255 cz 86.59.128.0 86.59.255.255 cz 86.61.128.0 86.61.255.255 cz 86.63.192.0 86.63.223.255 cz Starting point ending point and then country code Will this cause a problem? Thanks Paul ----- Original Message ----- From: "Frank Nordberg"
To: "WebDNA Talk" Sent: Saturday, October 08, 2005 10:20 PM Subject: Re: Blocking off access > paul wrote: > ... > > Dotted IP and normal IPs, in a range format > ... > > Actually I think the dotted ones are the ones that are regarded as > "normal." They're a bit tricky to do math with though. > > ... > > 60,000 lines so a lookup would be best I think, > > If it's the database Will Starck gave us a link to - or similar to it, > lookup won't work. The reason is that it gives ip no *ranges* rather > than individual ip nos. (a complete ip no. list would be far bigger than > 60 000 lines long). > So you'll have to use two serch criteria and lookup won't allow that. I > wouldn't worry too much though. WebDNA is *FAST*!!! > > > just need a starting point and I will give it a go > > Here' a quickie. Should work, but I'm sure somebody can come up with a > more elegant solution: > > [!]Convert ip address to "ip number" and store as a variable named > ipnumber[/!] > [TEXT]ipnumber=[MATH][ListWords > Words=[IPADDRESS]&delimiters=.]([WORD][SHOWIF > [INDEX]<4]*256[/SHOWIF][SHOWIF [INDEX]<3]*256[/SHOWIF][SHOWIF > [INDEX]<2]*256[/SHOWIF])+[/LISTWORDS]0[/MATH][/TEXT] > > [!]Search code[/!] > [Search > db=ip-to-country.db&ipFromtype=num&ipTotype=num&geipFromdatarq=[ipnumber]&le ipTodatarq=[ipnumber]&max=1] > [Founditems] > {Insert whatever code you need to do what you want to do with the > nationality data} > [/Founditems] > [/Search] > > > Dale-List wrote: > > > > Keep in mind that this won't work for AOL as pretty much all of their > > IPs reflect the US, even for european AOL users. > > True, and there are also surfers who use a proxy in a different country. > There's simply no way to make an ip address based nationality > identification hundred percent reliable. > > > Frank Nordberg > http://www.musicaviva.com > > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > Web Archive of this list is at: http://webdna.smithmicro.com/ > ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
The format of the lines is like this 85.239.224.0 85.239.255.255 cz 86.49.0.0 86.49.255.255 cz 86.59.128.0 86.59.255.255 cz 86.61.128.0 86.61.255.255 cz 86.63.192.0 86.63.223.255 cz Starting point ending point and then country code Will this cause a problem? Thanks Paul ----- Original Message ----- From: "Frank Nordberg" To: "WebDNA Talk" Sent: Saturday, October 08, 2005 10:20 PM Subject: Re: Blocking off access > paul wrote: > ... > > Dotted IP and normal IPs, in a range format > ... > > Actually I think the dotted ones are the ones that are regarded as > "normal." They're a bit tricky to do math with though. > > ... > > 60,000 lines so a lookup would be best I think, > > If it's the database Will Starck gave us a link to - or similar to it, > lookup won't work. The reason is that it gives ip no *ranges* rather > than individual ip nos. (a complete ip no. list would be far bigger than > 60 000 lines long). > So you'll have to use two serch criteria and lookup won't allow that. I > wouldn't worry too much though. WebDNA is *FAST*!!! > > > just need a starting point and I will give it a go > > Here' a quickie. Should work, but I'm sure somebody can come up with a > more elegant solution: > > [!]Convert ip address to "ip number" and store as a variable named > ipnumber[/!] > [text]ipnumber=[math][ListWords > Words=[ipaddress]&delimiters=.]([WORD][SHOWIF > [INDEX]<4]*256[/SHOWIF][SHOWIF [INDEX]<3]*256[/SHOWIF][SHOWIF > [INDEX]<2]*256[/SHOWIF])+[/LISTWORDS]0[/MATH][/TEXT] > > [!]Search code[/!] > [Search > db=ip-to-country.db&ipFromtype=num&ipTotype=num&geipFromdatarq=[ipnumber]&le ipTodatarq=[ipnumber]&max=1] > [founditems] > {Insert whatever code you need to do what you want to do with the > nationality data} > [/Founditems] > [/Search] > > > Dale-List wrote: > > > > Keep in mind that this won't work for AOL as pretty much all of their > > IPs reflect the US, even for european AOL users. > > True, and there are also surfers who use a proxy in a different country. > There's simply no way to make an ip address based nationality > identification hundred percent reliable. > > > Frank Nordberg > http://www.musicaviva.com > > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > Web Archive of this list is at: http://webdna.smithmicro.com/ > ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
"paul"
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
[ReturnRaw] and hiding FORM data (2003)
RePost: NAT and the CART (1999)
[OT]Co-Location of a Server (2002)
IIS4b2 and WebCatalog b19 (1997)
reporting commands (2001)
Runtime version ... (2003)
[WebDNA] test 2 (2009)
my price won't move (1997)
[WebDNA] Digital Ocean /WebDNA is not configured to accept (2019)
Separate SSL Server (1997)
New Site Announcement (1998)
***JUNK MAIL*** [WebDNA] merging multiple database fields into a new field (2016)
foreign character sets and conversions (1998)
Permissions Ignored - PLEASE HELP (2003)
[WebDNA] anyone use curl with shell? (2010)
WCS Newbie question (1997)
WebCat2b13MacPlugin - [math][date][/math] problem (1997)
Performance Issue (2000)
syntax question, not in online refernce (1997)
[OT] Xserve (2002)