Re: IP address and Country

2022-11-27 Thread harrison--- via use-livecode
Hi Kee, I did solve it, I just forgot to tell the list that I did. Oops. Thanks! Rick > On Nov 27, 2022, at 4:17 PM, kee nethery via use-livecode > wrote: > > When we did this, the database table had a start and end IP address range > column. > > The IP addresses were entered into the

Re: IP address and Country

2022-11-27 Thread kee nethery via use-livecode
When we did this, the database table had a start and end IP address range column. The IP addresses were entered into the table as integers without the dots. I’m not sure but I think we might have put a “1” at the beginning of the IP address integers so that everything stayed 13 digits (ie the

Re: IP address and Country

2022-11-15 Thread harrison--- via use-livecode
Hi Alex, Sorry, it’s been a really busy day here. I can’t get back to this problem until tomorrow. Don’t drag out your C code just yet, I have some ideas to try. Thanks, Rick > On Nov 15, 2022, at 1:35 PM, Alex Tweedly via use-livecode > wrote: > > Hi Rick, > > I had missed the fact that

Re: IP address and Country

2022-11-15 Thread Alex Tweedly via use-livecode
Hi Rick, I had missed the fact that you said you already had the database - that makes it a much easier problem :-) While I don't have any Livecode code for this, I do have some C code for a (probably) very similar problem. If you can describe the format of your database, and the query you

Re: IP address and Country

2022-11-15 Thread harrison--- via use-livecode
Hi Martin, Thanks for the information, but what I really want is a LiveCode solution that doesn’t depend on third parties. I have the database. I was asking if other people here had come up with a fast LiveCode solution. If all else fails, I will look into one of the third party suggestions,

Re: IP address and Country

2022-11-14 Thread Martin Koob via use-livecode
You can use a website with a api that you send a HTTP request with an IP address parameter to and which returns the country info. Here is an example I found of one site. https://ipapi.co/api/#introduction HTTP Request GET https://ipapi.co/{ip}/{format}/ URL Parameters Parameter

Re: IP address and Country

2022-11-14 Thread harrison--- via use-livecode
Hi Bob, Yes, that website illustrates what I’m trying to do, but I really need my own code for this. Thanks for the suggestion anyway. Rick > On Nov 14, 2022, at 7:57 PM, Bob Sneidar via use-livecode > wrote: > > Is that a fixed thing? Can it ever change? Seems like there must be a web >

Re: IP address and Country

2022-11-14 Thread Bob Sneidar via use-livecode
Is that a fixed thing? Can it ever change? Seems like there must be a web site for that. I found https://www.ipvoid.com/ip-to-country/. They may license the tool that does this. Bob S On Nov 14, 2022, at 16:50 , harrison--- via use-livecode mailto:use-livecode@lists.runrev.com>> wrote:

IP address and Country

2022-11-14 Thread harrison--- via use-livecode
Greetings LiveCoders, I’m trying to set up an LC Server routine to retrieve the country name where the user is supposedly located by using the user’s IP Address and a cross-reference table. I’m sure someone here must have done something similar in the past and I was wondering what the best