[Slice]

Quote:

Originally Posted by TheArcher You know i love you Slice.

Yay!

Quote:

Originally Posted by AndreT Thanks a lot for the explanation, Slice. I wasn't aware of such functions in MySQL and had never before looked into how IP addresses can be integers. For anyone interested, here's an article with some benchmarking on how storing IP addresses can be made more efficient. This change will make 4 string fields into 2 unsigned integer fields. And the change to the ban checking query which is ran every time a player connects, will improve things even more! I'll sure look into your code even more and I hope you haven't forgotten your awesome topic about optimizations and enhancements. I'd love to see something new in there!

Well not only that, but you will easily be able to compare IPs in the server (for example, find players with the same IP/subnet).
Are you familiar with bitwise operations such as AND, OR, XOR, shifting? If not, you should read about that a little bit and you'll be able to do and understand so much more.