Quote:
Originally Posted by Vince
It won't work if you are connecting locally to your own server, because your IP will be a private IP (127.0.0.1 or 192.168.x.x most likely), which is not included in the database. If you so wish, you can add those manually, using any of the user-assigned country codes.
PHP код:
INSERT INTO list_countries (country_code, country_name) VALUES ('XP', 'Private Network');
PHP код:
INSERT INTO list_ipv4 (range_start, range_end, country_code) VALUES
(INET_ATON('127.0.0.0'), INET_ATON('127.255.255.255'), 'XP'),
(INET_ATON('10.0.0.0'), INET_ATON('10.255.255.255'), 'XP'),
(INET_ATON('172.16.0.0'), INET_ATON('172.31.255.255'), 'XP'),
(INET_ATON('192.168.0.0'), INET_ATON('192.168.255.255'), 'XP');
|
I've added the banned field and set A1 banned to 1, can you alter the query to check for this? I know regular queries, but this is weird as they're joined or some how.
