Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> SELECT * FROM geoip_blocks WHERE inet_aton('176.15.57.165') >= startIpNum AND inet_aton('176.15.57.165') < endIpNum;
- +------------+------------+-----------------------------+-------------+----------+
- | startIpNum | endIpNum | IpTextBlock | CountryCode | CityCode |
- +------------+------------+-----------------------------+-------------+----------+
- | 2953785600 | 2953787903 | 176.15.49.0 - 176.15.57.255 | RU | 1442 |
- +------------+------------+-----------------------------+-------------+----------+
- 1 row in set (0.13 sec)
- mysql> DESC geoip_location;
- +-----------+----------------------+------+-----+---------+-------+
- | Field | Type | Null | Key | Default | Extra |
- +-----------+----------------------+------+-----+---------+-------+
- | id | smallint(5) unsigned | NO | PRI | NULL | |
- | city | varchar(150) | NO | | NULL | |
- | subject | varchar(200) | NO | | NULL | |
- | district | varchar(200) | NO | | NULL | |
- | latitude | float unsigned | NO | | NULL | |
- | longitude | float unsigned | NO | | NULL | |
- +-----------+----------------------+------+-----+---------+-------+
- 6 rows in set (0.00 sec)
- mysql> SELECT * FROM geoip_location WHERE id = 1442;
- +------+----------------+-----------------------------------+------------------------------------------------------+----------+-----------+
- | id | city | subject | district | latitude | longitude |
- +------+----------------+-----------------------------------+------------------------------------------------------+----------+-----------+
- | 1442 | Иркутск | Иркутская область | Сибирский федеральный округ | 52.2753 | 104.309 |
- +------+----------------+-----------------------------------+------------------------------------------------------+----------+-----------+
Advertisement
Add Comment
Please, Sign In to add comment