DB:Auth:ip2nation 548

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