Which format does the data have?

[furkican_16]

ROHAN2 WORLD 1-120 TR TİPİ OFFICIAL YOHARA, BALATHOR VE AMON! 80. GÜNÜNDE! +10.000 ONLİNE! HİLE VE BOT %100 ENGELLİ HEMEN TIKLA!

Which format does the data have?
As already mentioned above the files are SQL-Dumps, therefore contain nothing but SQL-Insert-Commands. It is important to keep in mind that no advanced inserts are used but that there is one insert per record (would advanced inserts be used several records would be collected in a single insert).

The old Travian 2 game worlds used ANSI-encoding for the files, however, nowadays all dumps are UTF-8-encoded.

If you want to create the matching table in a database you can use the following piece of SQL-Code:

CREATE TABLE `x_world` (
`id` int(9) unsigned NOT NULL default '0',
`x` smallint(3) NOT NULL default '0',
`y` smallint(3) NOT NULL default '0',
`tid` tinyint(1) unsigned NOT NULL default '0',
`vid` int(9) unsigned NOT NULL default '0',
`village` varchar(20) NOT NULL default '',
`uid` int(9) NOT NULL default '0',
`player` varchar(20) NOT NULL default '',
`aid` int(9) unsigned NOT NULL default '0',
`alliance` varchar(8) NOT NULL default '',
`population` smallint(5) unsigned NOT NULL default '0',
UNIQUE KEY `id` (`id`)
);