Which format does the data have?

[furkican_16]

Ayyıldız2 | 2008 TR Yapısı • 1-99 Orta Emek Destan • Oto Avsız • 10 Temmuz 21:00 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`)
);