Augustomendes4426: Augustomendes4426 moved page DB:Auth:ip2nationcountries 548 to Ip2nationcountries 548: Removing prefix to match with world and to come characters wiki

2025-06-14T15:52:16Z

Augustomendes4426 moved page DB:Auth:ip2nationcountries 548 to Ip2nationcountries 548: Removing prefix to match with world and to come characters wiki

← Older revision	Revision as of 10:52, 14 June 2025
(No difference)

Augustomendes4426: Augustomendes4426 moved page DB:Auth:1p2nationcountries 548 to DB:Auth:ip2nationcountries 548: Corrected the typo 1p2nat to ip2nat (to match the database) and the wiki

2025-06-14T15:34:38Z

Augustomendes4426 moved page DB:Auth:1p2nationcountries 548 to DB:Auth:ip2nationcountries 548: Corrected the typo 1p2nat to ip2nat (to match the database) and the wiki

← Older revision	Revision as of 10:34, 14 June 2025
(No difference)

Admin: Unfinished

2023-08-03T02:32:26Z

Unfinished

← Older revision		Revision as of 21:32, 2 August 2023
Line 1:		Line 1:
	~~placeholder~~		{\| align="right"
			\|-
			\| __TOC__
			\|}
			{{Back-to:Auth_18414}}


			<big>'''The `ip2nationcountries` table'''</big>

			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.


			<big>'''Structure'''</big>
			{\| border="1"
			\|'''Field'''
			\|'''Type'''
			\|'''Attributes'''
			\|'''Key'''
			\|'''Null'''
			\|'''Default'''
			\|'''Extra'''
			\|'''Comment'''
			\|-
			\|[[#code\|code]]
			\|int
			\|
			\|
			\|NO
			\|<nowiki>0</nowiki>
			\|
			\|
			\|-
			\|[[#iso_code_2\|iso_code_2]]
			\|char(2)
			\|
			\|
			\|NO
			\|
			\|
			\|
			\|-
			\|[[#iso_code_3\|iso_code_3]]
			\|char(2)
			\|
			\|
			\|NO
			\|
			\|
			\|
			\|-
			\|[[#iso_country\|iso_country]]
			\|char(2)
			\|
			\|
			\|NO
			\|
			\|
			\|
			\|-
			\|[[#country\|country]]
			\|char(2)
			\|
			\|
			\|NO
			\|
			\|
			\|
			\|-
			\|[[#lat\|lat]]
			\|char(2)
			\|
			\|
			\|NO
			\|
			\|
			\|
			\|-
			\|[[#lon\|lon]]
			\|char(2)
			\|
			\|
			\|NO
			\|
			\|
			\|
			\|-
			\|}
			<br> <big>'''DB Structure'''</big>
			<br>
			{\| border="1"<br>
			<pre style="color: red">
			CREATE TABLE `ip2nationcountries` (
			`code` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
			`iso_code_2` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
			`iso_code_3` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
			`iso_country` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
			`country` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
			`lat` float NOT NULL DEFAULT 0,
			`lon` float NOT NULL DEFAULT 0,
			PRIMARY KEY (`code`) USING BTREE,
			INDEX `code`(`code` ASC) USING BTREE
			) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
			</pre>

			<big>'''Description of the fields'''</big>

			==== code ====
			Please Define

			==== so_code_2 ====

			Please Define
			==== iso_code_3 ====

			Please Define
			==== iso_country ====

			Please Define
			==== country ====

			Please Define
			==== lat ====

			Please Define
			==== lon ====

			Please Define

Admin: placeholder

2023-08-02T23:42:43Z

placeholder

New page

placeholder

Ip2nationcountries 548 - Revision history

Augustomendes4426: Augustomendes4426 moved page DB:Auth:ip2nationcountries 548 to Ip2nationcountries 548: Removing prefix to match with world and to come characters wiki

Augustomendes4426: Augustomendes4426 moved page DB:Auth:1p2nationcountries 548 to DB:Auth:ip2nationcountries 548: Corrected the typo 1p2nat to ip2nat (to match the database) and the wiki

Admin: Unfinished

Admin: placeholder