diff options
| author | Walter Pagani <paganiwalter@gmail.com> | 2021-01-12 06:25:43 -0300 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2021-01-12 10:25:43 +0100 |
| commit | 20d1b6045f788b5bdbd0ec6aa7ebee5800603476 (patch) | |
| tree | 0d95a644e237423c9838f8ebc801b98fa1a1bc3b /docs | |
| parent | a7b56fa51f9ad48e879135cba7744d3d57ea30db (diff) | |
| download | wiki-20d1b6045f788b5bdbd0ec6aa7ebee5800603476.tar.gz wiki-20d1b6045f788b5bdbd0ec6aa7ebee5800603476.tar.bz2 wiki-20d1b6045f788b5bdbd0ec6aa7ebee5800603476.zip | |
update ip2nation.md (#345)
* update ip2nation.md
* Adding some examples
Diffstat (limited to 'docs')
| -rw-r--r-- | docs/ip2nation.md | 34 |
1 files changed, 26 insertions, 8 deletions
diff --git a/docs/ip2nation.md b/docs/ip2nation.md index ecafe42..abe76d4 100644 --- a/docs/ip2nation.md +++ b/docs/ip2nation.md @@ -4,18 +4,36 @@ **The \`ip2nation\` and \`ip2nationCountries\` tables** -These tables allow to see approximately which country a player might be from when doing **.pinfo <player>** command. +## Structure -They are not mantained by TrinityCore development team and **they require external data to perform their function**, which can be found at <http://www.ip2nation.com/ip2nation/Download> +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|--------------|---------|------------|-----|------|---------|-------|---------| +| [ip][1] | int(11) | unsigned | MUL | NO | 0 | | | +| [country][2] | char(2) | | | NO | | | | -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. +[1]: #ip +[2]: #country + +# Description of the fields + +### ip - +### country - +### Example - +| ip | country | +|-----------|---------| +| 0 | us | +| 687865856 | za | +| 689963008 | eg | +| 691011584 | za | +| 691617792 | zw | +| 691621888 | lr | - +These tables allow to see approximately which country a player might be from when doing **.pinfo <player>** command. - +They are not mantained by TrinityCore development team and **they require external data to perform their function**, which can be found at +[ip2nation](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. |