Server Help

BDwinsAlt · Posted: Mon Nov 13, 2006 8:14 pm Post subject: Alias - Ip

On the alias module that comes in ASSS, the ip is stored as an integer instead of the decimal form, how do I get it back into that decimal form in php? You might have seen my alias site that is linked the logic bot, well in logic bot the ip is stored as a plain ip. How can i convert this integer back into the decimal ip form? Thanks in advance.

Example: 192.168.1.104 = 3232235880

Mine GO BOOM · Posted: Mon Nov 13, 2006 8:31 pm Post subject:

long2ip. Warning: depends on the byte order, so it may result in reverse numbering.

BDwinsAlt · Posted: Mon Nov 13, 2006 8:52 pm Post subject:

Thank you so much. This worked.
Nice job on the fast response time. <3

Smong · Posted: Tue Nov 14, 2006 5:23 am Post subject:

If you look at the source to asss's alias module you can see there is a mysql function called inet_ntoa.
_________________
ss news

BDwinsAlt · Posted: Tue Nov 14, 2006 7:45 am Post subject:

I did see that. I looked at it before I posted.

Cyan~Fire · Posted: Tue Nov 14, 2006 11:28 am Post subject:

That's a mysql function? I think it's a networking (Winsock/whatever linux uses) function.
_________________
This help is informational only. No representation is made or warranty given as to its content. User assumes all risk of use. Cyan~Fire assumes no responsibility for any loss or delay resulting from such use.
Wise men STILL seek Him.

Dr Brain · Posted: Tue Nov 14, 2006 2:33 pm Post subject:

http://dev.mysql.com/doc/refman/5.0/en/miscellaneous-functions.html

fourth and fifth functions from the top of the page.
_________________
Hyperspace Owner

Smong> so long as 99% deaths feel lame it will always be hyperspace to me

BDwinsAlt · Posted: Tue Nov 14, 2006 5:02 pm Post subject:

Nice, I thought it was a built in function in AS3 or something. I think it would be faster/better to just call the integer value from mysql then use long2ip. Calling the integer value, then calling the value of the integer in a decimal would mean putting a little more stress on the mysql server. I try to make everything load as fast and easy as possible.

If I notice the IPs not turning out right then I'll use the mysql function.

Thanks for helping me guys.

p.s. I know its not much for the sql server to do but I'm just picky about things.

Cyan~Fire · Posted: Wed Nov 15, 2006 11:30 am Post subject:

Crazy. Why'd they put that in mysql too?

Mine GO BOOM · Posted: Wed Nov 15, 2006 2:30 pm Post subject:

Because MySQL is usually a database behind an application running for multiple users. Since multiple users usually come from different locations, be it the Internet or on a LAN, IP storage is common. Since IPs are stored as numbers (4 bytes for IPv4, 16 bytes for IPv6), might as well support an easy to use interface for accessing those numbers. It is not like those couple of functions add much bloat.