diff options
Diffstat (limited to 'docs')
| -rw-r--r-- | docs/database-auth.md | 2 | ||||
| -rw-r--r-- | docs/documentation_index.md | 1 | ||||
| -rw-r--r-- | docs/ip2location.md | 13 | ||||
| -rw-r--r-- | docs/ip2nation.md | 37 | ||||
| -rw-r--r-- | docs/ip2nationCountries.md | 55 |
5 files changed, 14 insertions, 94 deletions
diff --git a/docs/database-auth.md b/docs/database-auth.md index ae5d4fd..e039009 100644 --- a/docs/database-auth.md +++ b/docs/database-auth.md @@ -8,8 +8,6 @@ The auth database currently has 14 tables, which mainly store information relate - [account_muted](account_muted.md) - [autobroadcast](autobroadcast.md) - [build_info](build_info.md) -- [ip2nation](ip2nation.md) -- [ip2nationCountries](ip2nationCountries.md) - [ip_banned](ip_banned.md) - [logs](logs.md) - [logs_ip_actions](logs_ip_actions.md) diff --git a/docs/documentation_index.md b/docs/documentation_index.md index 669a639..b391e76 100644 --- a/docs/documentation_index.md +++ b/docs/documentation_index.md @@ -12,6 +12,7 @@ * [CMake options](cmake-options.md) * [Directory structure](directory-structure.md) * [How to Debug and Restart](how-to-restart-and-debug.md) +* [IP2LOCATION](ip2location.md) * [Logging Configuration](logging-configuration.md) * [MySQL types (C++)](mysqltypescpp.md) * [Project Versioning](project-versioning.md) diff --git a/docs/ip2location.md b/docs/ip2location.md new file mode 100644 index 0000000..7334219 --- /dev/null +++ b/docs/ip2location.md @@ -0,0 +1,13 @@ +# IP2LOCATION + +With IP2LOCATION we can approximately see which country a player might be coming from using the `.pinfo <player>` command. + +To be able to use this system you have to provide the **ip2location lite database** to your Authserver. + +Download **IP2LOCATION-LITE-DB1.CSV** from https://download.ip2location.com/lite/ + +Unzip the file and place it in the directory of your choice. + +In authserver.conf and worldserver.conf you need to set the full directory path including the .CSV under IPLocationFile. + +On the Auth- and Worldserver start you will be able to see the .CSV file being loaded in the log. diff --git a/docs/ip2nation.md b/docs/ip2nation.md deleted file mode 100644 index 3788e30..0000000 --- a/docs/ip2nation.md +++ /dev/null @@ -1,37 +0,0 @@ -# ip2nation - -[<-Back-to:Auth](database-auth.md) - -**The \`ip2nation\` and \`ip2nationCountries\` tables** - -## Structure - -| Field | Type | Attributes | Key | Null | Default | Extra | Comment | -|--------------|---------|------------|-----|------|---------|-------|---------| -| [ip][1] | INT | UNSIGNED | MUL | NO | 0 | | | -| [country][2] | char(2) | | | NO | | | | - -[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 AzerothCore development team and **they require external data to perform their function**, which can be found at -[ip2nation](http://www.ip2nation.com/ip2nation/Download) or via this module [mod-ip2natioon-ip2nationcountries](https://github.com/azerothcore/mod-ip2nation-ip2nationcontries) diff --git a/docs/ip2nationCountries.md b/docs/ip2nationCountries.md deleted file mode 100644 index c50bf86..0000000 --- a/docs/ip2nationCountries.md +++ /dev/null @@ -1,55 +0,0 @@ -# ip2nationCountries - -[<-Back-to:Auth](database-auth.md) - -**The \`ip2nationCountries\` table** - -## Structure - -| Field | Type | Attributes | Key | Null | Default | Extra | Comment | -|------------------|--------------|------------|-----|------|---------|-------|---------| -| [code][1] | VARCHAR(4) | | PRI | NO | | | | -| [iso_code_2][2] | VARCHAR(2) | | | NO | | | | -| [iso_code_3][3] | VARCHAR(3) | | | YES | | | | -| [iso_country][4] | VARCHAR(255) | | | NO | | | | -| [country][5] | VARCHAR(255) | | | NO | | | | -| [lat][6] | FLOAT | | | NO | 0 | | | -| [lon][7] | FLOAT | | | NO | 0 | | | - -[1]: #code -[2]: #iso_code_2 -[3]: #iso_code_3 -[4]: #iso_country -[5]: #country -[6]: #lat -[7]: #lon - -## 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](http://www.ip2nation.com/ip2nation/Download) or via this module [mod-ip2natioon-ip2nationcountries](https://github.com/azerothcore/mod-ip2nation-ip2nationcontries) - |