Hrm.. The CSV's look feasible to use. Thanks. :) On Sun, Dec 25, 2011 at 10:54 AM, Donnie Bachan (Gmail) <donnie.bac...@gmail.com> wrote: > > FYI, http://www.maxmind.com/app/geolitecity, best to check with them > about your particular use case to ensure you are good to use the free > version. > > Best Regards, > Donnie Bachan > "Nitendo Vinces - By Striving You Shall Conquer" > ====================================================================== > The information transmitted is intended only for the person or entity to > which it is addressed and may contain confidential and/or privileged > material. Any review, retransmission, dissemination or other use of, or > taking of any action in reliance upon, this information by persons or > entities other than the intended recipient is prohibited. If you received > this in error, please contact the sender and delete the material from any > computer. > > > > On Sun, Dec 25, 2011 at 4:18 PM, Phillip Vector > <vec...@mostdeadlygame.com> wrote: >> >> *nods* I was looking for city and state actually. >> >> and it would need to be free. I can't drop $370 on this. >> >> On Sun, Dec 25, 2011 at 3:48 AM, Donnie Bachan (Gmail) >> <donnie.bac...@gmail.com> wrote: >>> >>> Although this isn't a completely free solution we've used it with very >>> good success without any updates for a while now. >>> http://www.maxmind.com/app/geoip_features. If you are using it for >>> just country level access for $50 it's not a bad investment. >>> >>> I've included some code for accessing checking the IP, once you have >>> the database loaded. Please note that the java database is much, much >>> faster than using the data in a database table. >>> >>> <cffunction name="getIsBadIP" access="public" returntype="boolean" >>> output="false"> >>> <cfargument name="theIP" default="" required="false" >>> type="string" /> >>> >>> <cfset var isBadIP = false /> >>> <cfset var clientip = arguments.theIP /> >>> <cfset var aIPParts = '' /> >>> <cfset var iIPNum = '' /> >>> <cfset var getIP = '' /> >>> <cfset var getBlackListed = '' /> >>> >>> <!--- If no IP passed use CGI.REMOTE_ADDR if exists ---> >>> <cfif not len(clientIP)> >>> <cfif structKeyExists(CGI,"REMOTE_ADDR") and len >>> (CGI.REMOTE_ADDR)> >>> <cfset clientip = CGI.REMOTE_ADDR /> >>> </cfif> >>> </cfif> >>> <!--- Check that this is a valid country, if not no actions >>> to be >>> performed ---> >>> >>> <!--- Perform the GEOIP limiting ---> >>> <!--- Check if the IP address is provided ---> >>> <cfif len (clientIP)> >>> <cfset aIPParts = listToArray(clientip, ".") /> >>> <cfif arrayLen(aIPParts) eq 4 and >>> isNumeric(aIPParts[1]) and >>> isNumeric(aIPParts[2]) and isNumeric(aIPParts[3]) and >>> isNumeric(aIPParts[4])> >>> <cfset iIPNum = (aIPParts[1] * (256^3)) + >>> (aIPParts[2] * (256^2)) >>> + (aIPParts[3] * (256^1)) + (aIPParts[4]) /> >>> <cfquery name="getIP" >>> datasource="#getDatasource()#"> >>> SELECT TOP 1 country FROM GeoIP >>> WHERE >>> CAST(#iIPNum# AS bigint) between >>> CAST(begin_num AS bigint) and >>> CAST(end_num AS bigint) >>> </cfquery> >>> <!--- Check if the country is in the bad >>> range ---> >>> <cfif getIP.recordcount> >>> <cfquery name="getBlackListed" >>> datasource="#getDatasource()#"> >>> SELECT * FROM >>> countryBlacklist >>> WHERE country = >>> <cfqueryparam cfsqltype="cf_sql_varchar" >>> value="#getIP.country#" /> >>> </cfquery> >>> <cfif getBlackListed.recordcount> >>> <cfset isBadIP = true /> >>> </cfif> >>> </cfif> >>> </cfif> >>> >>> </cfif> >>> >>> >>> <cfreturn isBadIP /> >>> </cffunction> >>> >>> Hope this helps. >>> >>> Best Regards, >>> Donnie Bachan >>> "Nitendo Vinces - By Striving You Shall Conquer" >>> ====================================================================== >>> The information transmitted is intended only for the person or entity to >>> which it is addressed and may contain confidential and/or privileged >>> material. Any review, retransmission, dissemination or other use of, or >>> taking of any action in reliance upon, this information by persons or >>> entities other than the intended recipient is prohibited. If you received >>> this in error, please contact the sender and delete the material from any >>> computer. >>> >>> >>> >>> On Sun, Dec 25, 2011 at 5:56 AM, Phillip Vector >>> <vec...@mostdeadlygame.com> wrote: >>>> >>>> Is there a server side solution for GeoIP that I can use? I'd like to >>>> make
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349243 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm