AzerothCore
Posts (Latest 10 updated) :
Read all

ip2nationCountries

<-Back-to:Auth

The `ip2nationCountries` table

Structure

Field Type Attributes Key Null Default Extra Comment
code varchar(4) PRI NO
iso_code_2 varchar(2) NO
iso_code_3 varchar(3) YES
iso_country varchar(255) NO
country varchar(255) NO
lat float NO 0
lon float NO 0

Description of the fields

code

iso_code_2

iso_code_3

iso_country

country

lat

lon

Example

code iso_code_2 iso_code_3 iso_country country lat lon
01 Private 0 0
ad AD AND Andorra Andorra 42.3 1.3
ae AE ARE United Arab Emirates United Arab Emirates 24 54
af AF AFG Afghanistan Afghanistan 33 65
ag AG ATG Antigua and Barbuda Antigua and Barbuda 17.03 -61.48

They are not mantained by AzerothCore development team and they require external data to perform their function, which can be found at ip2nation or via this module mod-ip2natioon-ip2nationcountries