Re: [ cf-dev ] IP and whois

duncan . cumming Fri, 24 Sep 2004 09:38:00 -0700

not sure I understand; you mean it only works for US IP addresses, or for the IP addresses in the US it only gives the country code not the country name? Give me the IP's you're using, and what your output is.

"Jenny" <[EMAIL PROTECTED]>

24/09/2004 15:47
Please respond to dev

To: <[EMAIL PROTECTED]>
cc:
Subject: Re: [ cf-dev ] IP and whois

Hi Duncan, well, kinda got it running .. but it's only returning a country code for US registered IPs! rgrds, Jenny ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 23, 2004 11:47 AM Subject: Re: [ cf-dev ] IP and whois > > you have two options. Either save it in your website folder, or save it > in > the C:\Cfusion\Custom Tags\ folder. Depending probably on if you think > you'll use this in more than one website? > > see also: > http://tutorial18.easycfm.com/ > > > > > "Jenny" > <[EMAIL PROTECTED] To: > <[EMAIL PROTECTED]> > place.org> cc: > Subject: Re: [ cf-dev ] IP > and whois > 22/09/2004 > 22:11 > Please respond > to dev > > > > > > Hi Duncan, > > This looks great, I'm just not sure how to install the custom tag. Can > you > > help please? > > Thanks, Jenny > > Jenny > Admin and Development, chicksNchaps > http://www.chicksNchaps.co.uk > > ----- Original Message ----- > From: <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, September 22, 2004 12:49 PM > Subject: Re: [ cf-dev ] IP and whois > > >> >> missed out a bit, here's an example of how you could use it (included a >> few >> bogus addresses): >> >> <cfset IPList = "2.6.190.57, 12.3.248.184, 24.230.192.0, 61.247.224.0, >> 212.124.240.0, 217.77.241.204, 217.168.0.0, 192.191.138.0, , 1.1.1.1.1, >> a.1.2, 1.2.3, a.b.c.1"> >> >> <cfloop list="#IPList#" index="IPAddress"> >> <cfset IP_Country = ""> >> <cfset IP_CountryCode = ""> >> <cfset IP_Error = ""> >> >> <cf_CountryIPWhois IPAddress="#IPAddress#"> >> >> <cfoutput> >> <cfif Len(IPAddress)>IPAddress: #IPAddress#<br></cfif> >> <cfif Len(IP_Country)>IP_Country: #IP_Country#<br></cfif> >> <cfif Len(IP_CountryCode)>IP_CountryCode: #IP_CountryCode#<br></cfif> >> <cfif Len(IP_Error)>IP_Error: #IP_Error#</cfif> >> </cfoutput> >> <br> >> </cfloop> >> >> >> >> >> >> [EMAIL PROTECTED] >> sign.co.uk To: >> <[EMAIL PROTECTED]> >> cc: >> 22/09/2004 12:47 Subject: Re: [ >> cf-dev ] IP and whois >> Please respond to dev >> >> >> >> >> >> >> get the .csv list here, either free or not-so-free: >> http://www.maxmind.com/app/geoip_country >> >> store it in a table. >> >> use this code as your custom tag, call it CountryIPWhois.cfm: >> >> <cfparam name="Attributes.IPAddress" default=""> >> >> <cfif NOT Len(Attributes.IPAddress)> >>  >> <cfset Attributes.IPAddress = CGI.REMOTE_ADDR> >> </cfif> >> >> <cfset Attributes.IPAddress = Trim(Attributes.IPAddress)> >> >> <cfif Len(Attributes.IPAddress)> >>  >>  >> <cfif ListLen(Attributes.IPAddress, ".") EQ 4> >>  >> <cfset w = ListGetAt(Attributes.IPAddress, 1, ".")> >> <cfset x = ListGetAt(Attributes.IPAddress, 2, ".")> >> <cfset y = ListGetAt(Attributes.IPAddress, 3, ".")> >> <cfset z = ListGetAt(Attributes.IPAddress, 4, ".")> >> >> <cfif IsNumeric(w) AND IsNumeric(x) AND IsNumeric(y) AND >> IsNumeric(z)> >>  >> <cfset IPNumber = (16777216*w) + (65536*x) + (256*y) + z> >> >>  >> <cfquery name="getCountry" datasource="CountryIPWhois"> >> SELECT CountryCode, Country >> FROM IPCountry >> WHERE #IPNumber# >= IPNumberStart >> AND #IPNumber# <= IPNumberEnd >> </cfquery> >> >> <cfif getCountry.RecordCount GT 0> >> <cfset CALLER.IP_CountryCode = getCountry.CountryCode> >> <cfset CALLER.IP_Country = getCountry.Country> >> <cfelse> >> <cfset CALLER.IP_Error = "Error: IP address not found >> in database"> >> </cfif> >> <cfelse> >> <cfset CALLER.IP_Error = "Error: Part of the IP address >> isn't numeric"> >> </cfif> >> <cfelse> >> <cfset CALLER.IP_Error = "Error: IP address must have 4 parts >> seperated by dots"> >> </cfif> >> <cfelse> >> <cfset CALLER.IP_Error = "Error: No IP address found"> >> </cfif> >> >> >> call it like this: <cf_CountryIPWhois IPAddress="#IPAddress#"> >> >> >> >> >> >> "Jenny" >> >> <[EMAIL PROTECTED] To: >> <[EMAIL PROTECTED]> >> place.org> cc: >> >> Subject: Re: [ cf-dev ] IP >> and whois >> 22/09/2004 >> >> 12:37 >> >> Please respond >> >> to dev >> >> >> >> >> >> >> could well be if i don't figured out the cfx ... thanks Tom. Going to > try >> the freebie way first. >> >> >> Jenny >> Admin and Development, chicksNchaps >> http://www.chicksNchaps.co.uk >> ----- Original Message ----- >> From: Tom Smith >> To: [EMAIL PROTECTED] >> Sent: Wednesday, September 22, 2004 11:52 AM >> Subject: Re: [ cf-dev ] IP and whois >> >> we use ip2location any use to you? >> >> http://www.ip2location.com/ >> ----- Original Message ----- >> From: Jenny >> To: [EMAIL PROTECTED] >> Sent: Wednesday, September 22, 2004 11:40 AM >> Subject: [ cf-dev ] IP and whois >> >> >> Hi all, >> >> Anyone know of a util that will look up an ip address and update a >> database >> with country location? >> >> ie, I log the remote_addr .. the util scans the ip's in the database and >> updates a country field based on the lookup. Loads of whois stuff out >> there >> if i wanted to do it one by one, but it'd be nice to automate it, >> especially >> with the volumes we deal with. >> >> thanks, >> >> Jenny >> Admin and Development, chicksNchaps >> http://www.chicksNchaps.co.uk >> >> >> >> --- >> Outgoing mail is certified Virus Free. >> Checked by AVG anti-virus system (http://www.grisoft.com). >> Version: 6.0.766 / Virus Database: 513 - Release Date: 18/09/2004 >> >> >> >> -- >> These lists are syncronised with the CFDeveloper forum at >> http://forum.cfdeveloper.co.uk/ >> Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ >> >> CFDeveloper Sponsors and contributors:- >> *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF > provided >> by activepdf.com* >> *Forums provided by fusetalk.com* :: *ProWorkFlow provided by >> proworkflow.com* >> *Tutorials provided by helmguru.com* :: *Lists hosted by >> gradwell.com* >> >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> >> >> >> >> -- >> These lists are syncronised with the CFDeveloper forum at >> http://forum.cfdeveloper.co.uk/ >> Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ >> >> CFDeveloper Sponsors and contributors:- >> *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF > provided >> by activepdf.com* >> *Forums provided by fusetalk.com* :: *ProWorkFlow provided by >> proworkflow.com* >> *Tutorials provided by helmguru.com* :: *Lists hosted by >> gradwell.com* >> >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> >> >> >> >> >> >> -- >> These lists are syncronised with the CFDeveloper forum at >> http://forum.cfdeveloper.co.uk/ >> Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ >> >> CFDeveloper Sponsors and contributors:- >> *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF > provided >> by activepdf.com* >> *Forums provided by fusetalk.com* :: *ProWorkFlow provided by >> proworkflow.com* >> *Tutorials provided by helmguru.com* :: *Lists hosted by >> gradwell.com* >> >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> >> > > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.766 / Virus Database: 513 - Release Date: 18/09/2004 > > > > -- > These lists are syncronised with the CFDeveloper forum at > http://forum.cfdeveloper.co.uk/ > Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > CFDeveloper Sponsors and contributors:- > *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided > by activepdf.com* > *Forums provided by fusetalk.com* :: *ProWorkFlow provided by > proworkflow.com* > *Tutorials provided by helmguru.com* :: *Lists hosted by > gradwell.com* > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > > > > > -- > These lists are syncronised with the CFDeveloper forum at > http://forum.cfdeveloper.co.uk/ > Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > CFDeveloper Sponsors and contributors:- > *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided > by activepdf.com* > *Forums provided by fusetalk.com* :: *ProWorkFlow provided by > proworkflow.com* > *Tutorials provided by helmguru.com* :: *Lists hosted by > gradwell.com* > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.768 / Virus Database: 515 - Release Date: 23/09/2004 -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]

Re: [ cf-dev ] IP and whois

Reply via email to