Not added to mysql

[Mitch]

And how do I check if an IP is banned?

When the result is 1 then the IP is banned otherwise not banned (e.g. no results).

		SELECT 1 FROM bans WHERE ip = INET_ATON('" + stripstring(self getip()) + "') LIMIT 1 
	

Edit: you can also return the fields (ip, name, reason, admin) for showing the kick message.

[Ni3ls]

Okay thanks. Switching the int in mysql to varchar did the trick

[Ni3ls]

Sorry to bump, but whats the main difference between inet_atom and storing the ip?

inet_aton() converts the Internet host address cp from the IPv4 numbers-and-dots notation into binary form (in network byte order) and stores it in the structure that inp points to. inet_aton() returns nonzero if the address is valid, zero if not.

Is there performance improvements or does it not affect ip changes?

[Whiskas]

Even with few manipulations (inet functions) IP is the same, but it's stored as number.

Single IP with inet_aton can be saved in database as an integer in 4 bytes.

If you would like to save an IP as varchar you would need to use varchar(15). If the charset of the text is ASCII it store 15 x 1 byte + 1 byte to save maximum length of text.

Note: Even if ip would be 1.2.3.4, varchar uses maximum size it has (16 bytes)

Conclusion: Each stored IP is 4 times larger when using varchar.

Performance? More data more reading.

If I'm wrong, correct me xD.

[serthy]

But I doubt it would have any noticable perfomance impact using strings over ints in CoD2

[Whiskas]

Yeah, guess we could count the difference in microseconds

[IzNoGoD]

With inet_aton it's easier to do subnet operations

[Ni3ls]

what kind of subnet operations?

[IzNoGoD]

like 1.2.3.0/24