DB:Auth:ip2nation 548
Jump to navigation
Jump to search
Back to auth database list of tables.
The `ip2nation` table
These tables allow to see approximately which country a player might be from when doing .pinfo <player> command.
They are not mantained by the ProjectSkyfire development team and they require external data to perform their function, which can be found at http://www.ip2nation.com/ip2nation/Download
NOTE IF YOU EXPORT THIS DATABASE FROM WINDOWS ENVIROMENT AND IMPORT IT ON LINUX YOU WILL HAVE STARTUP ERROR BECAUSE ip2nationCountries WILL BE RENAMED TO ip2nationcountries IMPORT IT AGAIN FROM IP2NATION WEBPAGE TO FIX IT.
Structure
Field | Type | Attributes | Key | Null | Default | Extra | Comment |
ip | int | NO | 0 | ||||
country | char(2) | NO |
DB Structure
CREATE TABLE `ip2nation` ( `ip` int UNSIGNED NOT NULL DEFAULT 0, `country` char(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', INDEX `ip`(`ip` ASC) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
Description of the fields
ip
ip Range
country
Country Code