Currently, our four core datafiles (skills.xml, ships.xml, items.xml, certificates.xml) are provided by Zofu anytime the game is patched and before the official database dumps are released (to quote Richard : "don't ask, it's witchcraft"). Zofu can be contacted on IRC (#eve-dev or #evedev, dunno), and often lures around the shadows of Battleclinic. He also has a website where one can find up-to-date conversions of the eve DB under miscalleneous formats, although EVEMon uses specific ones not present on this page.

Also, there is an assembly named ZofusXMLImporter for generating additional datafiles (properties.xml) for EVEMon. Just drop the latest XML dumps from Zofu into the input directory of this assembly (<SolutionDirectory?>\ZofusXmlImporter?\Input) and run it.

Old informations

Note : the following content may be deprecated (below). I suspect the database dumps formats have changed since then. However you can trust the informations presented at the top of the page.

Creating the Ships/Items/Implants data files

The php scripts for generating the xml data files are in the repository at http://evemon.battleclinic.com/cgi-bin/trac.cgi/browser/EVEMon.ExportMassage (except for skills, which was painstakingly hand crafted by Eewec)

These scripts were orinigally written by MrCue and subsequently modified by Eewec and Brad Stone.

Should you wish to generate your own data files for whatever reason then you will need:

• A webserver running PHP (4.x or 5.x will work) with the MySQL extension.

• A MySQL server, either version 4.x or 5.x

• The revelations datadump from t20 loaded into your database (eve files has a MySQL-ised version of the dump, including the table creation scripts)

You may have to tweak the maximum script execution time in your php.file script as the items file can take a minute or 3 to generate, although the scripts attempt to override the max execution time specified in your php.ini file.

Download the scripts and stick them somewhere in your DocumentRoot.

• Edit the xml_creator_common2.php.

This is the bit you need to mess with.

$database = array(

	'host' => 'localhost', //The host on which the database server resides

	'port' => '3306', //The port which MySQL is listening on

	'user' => 'You', //The user which the database belongs to

	'password' => '???', //The password used to connect to the database

	'database' => 'eve_revelations_stuff', //The name of the database the tables are located within

	'version' => '4' //What version of MySQL are you running [4 or 5]

);

And a bit further down:

$output_path = 'a:/place/somewhere/'; //This is the path to where you want the file to go, must have write permission for either the webserver, or whoever invokes PHP. WITH trailing slash.

Amend the $database array to reflect your own configuration.

It's particularly important to ensure you've set the correct MySQL version. The MySQL folks changed the syntax and precedence of joins to be more compliant with the ANSI standard and thsi change impacts one of the queries we use in the ship generator.

• Fire up a browser and point it at the relevant script to generate the xml. The script will generate both the xml and the xml.gz files. The xml file is preserved for convenience so you can view it immediately in a browser or editor.