From 20d1b6045f788b5bdbd0ec6aa7ebee5800603476 Mon Sep 17 00:00:00 2001 From: Walter Pagani Date: Tue, 12 Jan 2021 06:25:43 -0300 Subject: update ip2nation.md (#345) * update ip2nation.md * Adding some examples --- docs/ip2nation.md | 34 ++++++++++++++++++++++++++-------- 1 file changed, 26 insertions(+), 8 deletions(-) (limited to 'docs') 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 +| 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 ** 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. -- cgit