Not added to mysql

Quote:

---

Originally Posted by Ni3ls

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).

PHP Code:

---

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.

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

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

Code:

---

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?

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.

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

Yeah, guess we could count the difference in microseconds

With inet_aton it's easier to do subnet operations

what kind of subnet operations?

like 1.2.3.0/24