Pages: [1] 2 :: one page |
|
Author |
Thread Statistics | Show CCP posts - 1 post(s) |
Chruker
|
Posted - 2007.04.28 01:52:00 -
[1]
Versions This database export is up-to-date with version: 31460 Last CCP database export is up-to-date with version: 28028
As always my database export is available for download here: http://games.chruker.dk/eve_online/datadump.php
Files for download http://games.chruker.dk/eve_online/files/dbo_20070427.zip which is a complete dump of the database (34 MB) http://games.chruker.dk/eve_online/files/dbo_update_20070427.zip which is a blob of SQL statements that updates a database from the lastest CCP export to the newest one. http://games.chruker.dk/eve_online/files/dbo_update_20070420_to_20070427.zip which is some SQL statements that updates my last database dump to the newest one.
File Issues - There have been some issues with the previous ones where the .zip file was incompatible. Instead of packing with gzip I've used regular zip this time. And it seems more compatible. Let me know if there are still problems. - One of the earlier dumps had all the CREATE TABLE statements make tables with lowercase letters only, instead of mixed. That is fixed. - The 20070720 dump had an invalid scientific number in one of the stargate coordinates. This is fixed now.
SQL Issues There are some changes noted in the patchnotes that I for different reasons couldn't include. Let me know if you know any of them: - The border, fringe, corridor, hub, international, regional, constellation fields in mapSolarSystems should be updated with all the jump changes. - Need Mobile Warp Disruptor tech 2 blueprints invention run times and invention chances. I don't have the skill yet to start the invention job. - In general all of the changes to NPC ships are not known. Many of them have changed names, graphics, and weapon/defenses stats. - All of the security status changes to the Jove and ISD regions are currently disabled, since I don't know what exact status to set them to.
Finally some bugs that CCP hasn't fixed yet, and therefore I haven't in the dump - Large Energy Transfer Array II is listed as a tech 1 variation to Large Energy Transfer Array I - All tech 2 Electronics Rigs BPCs don't have have the same steep skill & material requirements as the other tech 2 rig BPCs - Deltole system: Warping to the 'Contested Gallente Skeleton Comet' beacon causes a database message which tells about the 'Contested Gallentean Canyon Of Rust' - The faction battleships 'Raven State Issue' and 'Tempest Tribal Issue' both require BS 5, however the 'Megathron Federate Issue' and 'Apocalypse Imperial Issue' only requires BS 2 - Spelling error: The word 'Hihgly' in the description of the 'Crop' Gas Cloud Harvester I - 'Tempest Tribal Issue' only has 200 calibration points, where as the other super-faction-issue BS'es have 350 points. - Blueprints for the 'Raven State Issue' and 'Tempest Tribal Issue' still have names like 'xxxxxxx Tournament Issue TEST Blueprint'
I think that was all ----- http://games.chruker.dk/eve_online ----- Top wishes: - No daily downtime - Faster training on sisi - Updated data export - Speedup IGB table rendering |
Mirida
Amarr Cataclysm Enterprises Dusk and Dawn
|
Posted - 2007.04.29 11:24:00 -
[2]
Edited by: Mirida on 29/04/2007 11:21:01 There are indexes in dgmtypeattributes on valueInt and valueFloat which are pretty useless as you usually dont search for specific attribute values.
Anyway, nice job, imported into mysql5 without problems! ___________________
EVE Development Network <Lead Developer> |
Chruker
|
Posted - 2007.04.29 13:22:00 -
[3]
Edited by: Chruker on 29/04/2007 13:18:52 Those indexes aren't entirely useless as I use the valueInt when looking up which items require certain skills. Like for my skillchart.
Good to know that it imports to MySQL 5. ----- http://games.chruker.dk/eve_online ----- Top wishes: - No daily downtime - Faster training on sisi - Updated data export - Speedup IGB table rendering |
Arimai
hirr Morsus Mihi
|
Posted - 2007.05.03 21:50:00 -
[4]
Nice dump :)
Imported into mysql 5 without problems here. The major advantage over the (simpler) dump is the added indices - which make hibernate a little bit happy. Too bad there is no version with foreign keys.
|
Chruker
|
Posted - 2007.05.06 15:29:00 -
[5]
I've added updated image archives to the download page. ----- http://games.chruker.dk/eve_online ----- Top wishes: - No daily downtime - Faster training on sisi - Updated data export - Speedup IGB table rendering |
Chruker
|
Posted - 2007.05.06 17:35:00 -
[6]
Database dump has been updated. Due to an error in a string of ID's one of them (typeID 5591) didn't get updated nor had a property deleted. ----- http://games.chruker.dk/eve_online ----- Top wishes: - No daily downtime - Faster training on sisi - Updated data export - Speedup IGB table rendering |
Robert Dobbs
Evolution Band of Brothers
|
Posted - 2007.05.06 18:31:00 -
[7]
Wow, nice work!
Thanks -
--------- DukeHeart > We dont like those terms, Phoenix does not agree. |
Jedzias Miezekatze
|
Posted - 2007.05.09 22:15:00 -
[8]
Is there any reason why you ignore the datatypes ?
I dont like boolean as enums :) ... or bigger defined types as needed.
Thanx for the updates, good work so far.
|
Jedzias Miezekatze
|
Posted - 2007.05.09 22:15:00 -
[9]
Is there any reason why you ignore the datatypes ?
I dont like boolean as enums :) ... or bigger defined types as needed.
Thanx for the updates, good work so far.
|
Chruker
|
Posted - 2007.05.11 12:04:00 -
[10]
Originally by: Jedzias Miezekatze Is there any reason why you ignore the datatypes ?
I dont like boolean as enums :) ... or bigger defined types as needed.
Thanx for the updates, good work so far.
Well, MySQL 3.23.xx don't have a boolean data type. And even 4.1 and above only seem to handle it during table creation (BOOLEAN columns become TINYINT(1) datatype).
So ENUM('true','false') was what I felt best would fit. ----- http://games.chruker.dk/eve_online ----- Top wishes: - No daily downtime - Faster training on sisi - Updated data export - Speedup IGB table rendering |
|
Arimai
hirr Morsus Mihi
|
Posted - 2007.05.11 17:50:00 -
[11]
I have a (partial) hibernate.reveng.xml
Anyone in here interested in it? I'll post if you shout.
On a sidenote, for documentation, this is how-to import this dump: mysql -f -B -u username -p dbname < dbo_release.sql
^^This can be quite hard & frustrating to find if you dont know it.
|
Jedzias Miezekatze
|
Posted - 2007.05.13 09:59:00 -
[12]
Well, MySQL 3.23.xx don't have a boolean data type. And even 4.1 and above only seem to handle it during table creation (BOOLEAN columns become TINYINT(1) datatype).
So ENUM('true','false') was what I felt best would fit.
Use Bit(1) and we are friends :)
oh and check this little thing ..... so i am a little exact on datatypes, excuse me mate :) And keep on working, thanks for the wonderful update.
|
Dyeadmheet
Caldari Khanid Aerospace Group Khanid Provincial Authority
|
Posted - 2007.05.15 17:30:00 -
[13]
Yes, thanks for this. I got some errors about "data truncated for column published" (invTypes) but for what I'm doing I dont care too much I not even sure what the official CCP dump is supposed to import into. It looks like it should work in MS SQL Server but I've encountered a number of problems trying to import it into that even....
|
Chruker
|
Posted - 2007.05.17 20:33:00 -
[14]
Originally by: Dyeadmheet Oh, one line I had trouble importing because of the fact that the keys on your table seem to differ from CCP's:
INSERT INTO mapConstellationJumps VALUES (10000030,20000370,20000497,10000042);
This caused a duplicate uniqe key error. Not sure exactly what's up here. Suggestions on how to fix? What's funny is that your MySQL export imports into MS SQL Server better than CCP's export (and CCP's looks like it originally came from MS SQL Server even.)
That is weird. I just double checked my databases and there are no duplicate rows, so there should be none in the dump either. Anyway, I wonder if MS SQL by default makes KEY a unique, and MySQL doesn't. ----- http://games.chruker.dk/eve_online ----- Top wishes: - No daily downtime - Faster training on sisi - Updated data export - Speedup IGB table rendering |
Dyeadmheet
Caldari Khanid Aerospace Group Khanid Provincial Authority
|
Posted - 2007.05.21 04:01:00 -
[15]
I'll have to investigate this further.
In general MS SQL is odd, as you'd expect from MS product. I'm not sure why I didn't just import this stuff directly into SQLite. (I guess I just like to mess with SQL server to maintain some basic familiarity with it or something.)
|
General Lilost
|
Posted - 2007.05.28 09:10:00 -
[16]
Hello.
First, thanks to Chruker for the excellent mysql data files and the schema. Perfect!
I have a question on an error I'm getting when executing the invTypes inserts. For many of the entries, the "published" item (enum true/false) is just an empty string ''. MySQL 5 gives me a Data truncated error when I try to execute those.
I am guessing I should replace all those with 'false' but could someone confirm or tell me what I'm not understanding?
Regards,
GL p.s. to Chruker: sent a contract with a little thanks for all your work. It's not a scam
|
Chruker
|
Posted - 2007.05.28 16:52:00 -
[17]
Edited by: Chruker on 28/05/2007 16:51:08
Originally by: General Lilost I have a question on an error I'm getting when executing the invTypes inserts. For many of the entries, the "published" item (enum true/false) is just an empty string ''. MySQL 5 gives me a Data truncated error when I try to execute those.
I wonder why your attempts to import it gives problems when Mirida and Arimai in post 2 and 4 respectively had no problems importing it. I just checked and the datadumps from that time also had the blank strings in place of the false value.
I've download the newest MySQL 5 and will try it and see which problems I run into.
Edit: And thank you for the gift ;-))) ----- http://games.chruker.dk/eve_online ----- Top wishes: - No daily downtime - Faster training on sisi - Updated data export - Speedup IGB table rendering |
Apple Blossom
|
Posted - 2007.05.29 00:52:00 -
[18]
Thanks for the great resource Chruker - imported fine on mySQL 5 (Ubuntu).
One question: Is it possible to determine which T2 blueprint is invented from which T1 blueprint. E.g. 1MN Afterburner II Blueprint is invented from 1MN Afterburner I Blueprint. At the moment I'm just cutting one of the 'I' characters off the T2 blueprint name and searching the invTypes table by name, but this seems a bit hacky and looses a few prints such as ammo.
Apple Blossom
|
General Lilost
|
Posted - 2007.05.29 09:23:00 -
[19]
I'm pretty noobish about databases so I could totally be missing the point here.
But for that problem I was having, I regex-replaced all the '' empty strings in the published item position with 'false' and could then insert everything fine. Could send you the file if you want it.
It would be nice if someone could confirm that replacing all those empty strings for published with 'false' was the right thing to do.
GL
|
DaOpa
Amarr Static Corp
|
Posted - 2007.05.29 14:22:00 -
[20]
Greetings Chruker!
Is there any chance you can also make the dump into Access MDB format?
Static Corp Website |
|
Chruker
|
Posted - 2007.05.29 18:16:00 -
[21]
Originally by: General Lilost It would be nice if someone could confirm that replacing all those empty strings for published with 'false' was the right thing to do.
I can say as much as I wouldn't expect it to give you any problems.
Just make sure that your SQL queries uses =='true' or !='true'
On a side note, I don't know which brain fart made me make that field an enum('true','false') instead of enum('1','0') or just int(1)... ----- http://games.chruker.dk/eve_online ----- Top wishes: - No daily downtime - Faster training on sisi - Updated data export - Speedup IGB table rendering |
Chruker
|
Posted - 2007.05.29 18:25:00 -
[22]
Originally by: Apple Blossom One question: Is it possible to determine which T2 blueprint is invented from which T1 blueprint. E.g. 1MN Afterburner II Blueprint is invented from 1MN Afterburner I Blueprint. At the moment I'm just cutting one of the 'I' characters off the T2 blueprint name and searching the invTypes table by name, but this seems a bit hacky and looses a few prints such as ammo.
It is kind of triggy: - you take the invBlueprintTypes.productTypeID field for the tech 1 blueprint and look it up in invMetaTypes.parentTypeID with invMetaTypes.metaGroup='2' that will give you the tech 2 items that can be invented. - then you just query the invBlueprintTypes.productTypeID for those tech 2 typeIDs
Or as php here is the code I use to get the tech 2 blueprints on this page: http://games.chruker.dk/eve_online/invention_tests.php?group=4
$query = "SELECT * FROM invBlueprintTypes"; $query .= " WHERE blueprintTypeID=".$db->sql_fix($test_scenarios[$i]["bpc_type_id"]); $blueprint_info = $db->query_row($query);
$query = "SELECT * FROM invMetaTypes"; $query .= " LEFT JOIN invBlueprintTypes ON invBlueprintTypes.productTypeID=invMetaTypes.typeID"; $query .= " LEFT JOIN invTypes ON invTypes.typeID=invBlueprintTypes.blueprintTypeID"; $query .= " WHERE parentTypeID=".$db->sql_fix($blueprint_info["productTypeID"]); $query .= " AND metaGroupID='2'";// Tech 2 $tech2 = $db->query($query); $tech2_tag = array(); $tech2_count = array();
echo "<h2>".htmlentities(getTypeName($test_scenarios[$i]["bpc_type_id"]))."</h2>\n"; echo "<div class=\"note\">\n"; echo "\tMax. BPC Runs = ".$blueprint_info["maxProductionLimit"]."<br />\n"; for ($ii = 0; $ii < sizeof($tech2); $ii++) { $tag = chr($ii + 88); $tech2_tag[$tech2[$ii]["typeID"]] = $tag; $tech2_count[$tech2[$ii]["typeID"]] = 0; echo "\t"; if (sizeof($tech2) > 1) {echo $tag.": ";} echo "Base chance for '".$tech2[$ii]["typeName"]."' = ".$tech2[$ii]["chanceOfReverseEngineering"]."<br />\n"; }
Chruker curses the BB code tag from stripping blank lines ----- http://games.chruker.dk/eve_online ----- Top wishes: - No daily downtime - Faster training on sisi - Updated data export - Speedup IGB table rendering |
Jesters Knight
Eclipse Enterprises Empire Research
|
Posted - 2007.05.29 18:29:00 -
[23]
is there an MSSQL database dum avalable instead of MySQL?
Highsec POS labs with no risk of scamming
Salvage Drone Operation |
Chruker
|
Posted - 2007.05.29 19:14:00 -
[24]
Originally by: DaOpa Is there any chance you can also make the dump into Access MDB format?
Sadly my experience with access is 9-10 years old, and I haven't gotten around to making a db wrapper in php so that my database manager can copy databases between mysql and access.
However if anybody know of a linux tool that'll generate the .mdb files, I'll look into it. ----- http://games.chruker.dk/eve_online ----- Top wishes: - No daily downtime - Faster training on sisi - Updated data export - Speedup IGB table rendering |
Chruker
|
Posted - 2007.05.29 19:43:00 -
[25]
Originally by: Jesters Knight is there an MSSQL database dum avalable instead of MySQL?
Well, yes, sort of. The original database export from CCP was MSSQL, however it doesn't have the updated stuff that this one has. ----- http://games.chruker.dk/eve_online ----- Top wishes: - No daily downtime - Faster training on sisi - Updated data export - Speedup IGB table rendering |
Jesters Knight
Eclipse Enterprises Empire Research
|
Posted - 2007.05.29 19:46:00 -
[26]
Originally by: Chruker
Originally by: Jesters Knight is there an MSSQL database dum avalable instead of MySQL?
Well, yes, sort of. The original database export from CCP was MSSQL, however it doesn't have the updated stuff that this one has.
Doh >.<
how would i go about getting the original, then seeing if i want to take the time to move MySQL over to MSSQL
Highsec POS labs with no risk of scamming
Salvage Drone Operation |
DaOpa
Amarr Static Corp
|
Posted - 2007.05.29 21:21:00 -
[27]
Edited by: DaOpa on 29/05/2007 21:20:53 Edited by: DaOpa on 29/05/2007 21:20:33
Originally by: Chruker
Originally by: DaOpa Is there any chance you can also make the dump into Access MDB format?
Sadly my experience with access is 9-10 years old, and I haven't gotten around to making a db wrapper in php so that my database manager can copy databases between mysql and access.
However if anybody know of a linux tool that'll generate the .mdb files, I'll look into it.
Hey Chruker,
Can you check this link, and see if it can assist with the dump to MDB ?
http://dev.mysql.com/doc/migration-toolkit/en/index.html
Static Corp Website |
Apple Blossom
|
Posted - 2007.05.30 02:06:00 -
[28]
Originally by: Chruker
Originally by: Apple Blossom One question: Is it possible to determine which T2 blueprint is invented from which T1 blueprint. E.g. 1MN Afterburner II Blueprint is invented from 1MN Afterburner I Blueprint. At the moment I'm just cutting one of the 'I' characters off the T2 blueprint name and searching the invTypes table by name, but this seems a bit hacky and looses a few prints such as ammo.
It is kind of triggy: - you take the invBlueprintTypes.productTypeID field for the tech 1 blueprint and look it up in invMetaTypes.parentTypeID with invMetaTypes.metaGroup='2' that will give you the tech 2 items that can be invented. - then you just query the invBlueprintTypes.productTypeID for those tech 2 typeIDs
You are a prince among men.
I knew it had to be something with the meta table. Thanks!
|
Vana Gank
Gallente Nosferatu Security Foundation
|
Posted - 2007.06.02 17:45:00 -
[29]
Ah, you sir are a genious. I've been looking for this. Downloading your updated db-dump now. Thank you :)
-------------------------- Please adjust the map, please. Im not clever enough to figure out which way to fly. |
DaOpa
Amarr Static Corp
|
Posted - 2007.06.07 17:10:00 -
[30]
Can someone give a guide on how to use the Dump file?
I just downloaded mysql 5 with the GUI Administrator interface..
There is a section for Restores but when I select the dump file it gives a bunch of errors and it doesnt seem to add anything in the Catalogs / Schemata section
Static Corp Website |
|
|
|
|
Pages: [1] 2 :: one page |
First page | Previous page | Next page | Last page |