New subject: [Serusers] lcr module and column type in DB

4 Mar 2005


      So, just to clear this up. You still have to reverse the ip, so:
example:
209.247.17.5
reverses to:
5.17.247.209
which long format comes to:
85063633
Thanks .. ??
-----Original Message-----
From: Iqbal [mailto:iqbal@gigo.co.uk] 
Sent: Wednesday, March 02, 2005 2:55 PM
To: jh@lohi.tutpro.com
Cc: serusers@lists.iptel.org
Subject: Re: [Serusers] lcr module and column type in DB
cheers, just what I needed..one thing though I had to reverse the
format...not sure if I was doing it wrong or something else.
Anyhow for all those with the same problem manually calculating it is
IP=A.B.C.D
IPlong= A*16777216 + B*65536 + C*256 + D
but as mentioned above I for some reason had to do
D*16777216 + C*65536 + B*256 + A
Iqbal
On 3/2/2005, "Juha Heinanen" jh@lohi.tutpro.com wrote:
...
Iqbal writes:
...
Any ideas
yes, you have to put in ip_addr field integer representation of ip 
address. use, for example, php's ip2long function.
-- juha
_______________________________________________
Serusers mailing list
serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers

RE: [Serusers] lcr module and column type in DB