Pages: [1] 2 3 4 :: one page |
|
Author |
Thread Statistics | Show CCP posts - 11 post(s) |
TheNetNinja
|
Posted - 2008.11.12 01:33:00 -
[1]
Hi guys,
I'd like to know if there will be an updated Database Export for the Quantum Rise expansion? And if so when it will be released? I was working on my new Eve-Online website with a heap of unique lookups and functionality, and I would really like to know if anything changed structure or schema wise in the export too.
Thanks,
Adam
|
Alphanio
|
Posted - 2008.11.12 03:05:00 -
[2]
From the patchnotes:
Database extensions for Certificates will be added to the Static Data Dump.
So, yes there will be an updated Quantum Rise dump. When? Who knows, historically within a week or two, but possibly longer. Schema? Nothing mentioned, so I would expect it to say the same, not that it's guaranteed or anything.
|
TheNetNinja
|
Posted - 2008.11.12 07:03:00 -
[3]
Thanks
|
|
CCP Lingorm
C C P
|
Posted - 2008.11.12 09:44:00 -
[4]
Being built and deployed today.
Will keep you informed.
CCP Lingorm CCP Quality Assurance QA Engineering Team Leader
Originally by: Lord Fitz Eve is to WoW as Wow is to an 8 player game of Unreal Tournament.
|
|
|
CCP Lingorm
C C P
|
Posted - 2008.11.13 09:12:00 -
[5]
And here you go.
http://ccp.vo.llnwd.net/o2/data/QuantumRise_1.0.0.69477_db.zip
Toolkit page being updated.
Working on the Icons today.
CCP Lingorm CCP Quality Assurance QA Engineering Team Leader
Originally by: Lord Fitz Eve is to WoW as Wow is to an 8 player game of Unreal Tournament.
|
|
Slyton Silur
NorCorp Security Southern Cross Alliance
|
Posted - 2008.11.13 09:12:00 -
[6]
Edited by: Slyton Silur on 13/11/2008 09:12:38 So, any news on the database export?
Edit: Close one, hehe. Nvm then, just got released xD
|
Vessper
Indicium Technologies
|
Posted - 2008.11.13 09:17:00 -
[7]
Thanks Lingorm!
- - -
EveHQ Character App | Item Database |
Vessper
Indicium Technologies
|
Posted - 2008.11.13 10:33:00 -
[8]
Just a quick question about the new certificates. Is there somewhere in the export that gives the pre-requisites for each certificate and their names?
I've checked the dgmTypeAttributes table and there's nothing in there for the requiredSkill4 attribute which I know some of these certificates have.
- - -
EveHQ Character App | Item Database |
iulixxi
Dracula Order The Black Isle
|
Posted - 2008.11.13 11:31:00 -
[9]
Originally by: CCP Lingorm Being built and deployed today.
Will keep you informed.
Any ideea when the images for map will be released ? (Black Rise and some other systems are missing from the v.old export ... )
Also I asked before but got no answer - see here
|
|
CCP Lingorm
C C P
|
Posted - 2008.11.13 11:51:00 -
[10]
Working on the Icon Renderings now. Hope to get them out today.
CCP Lingorm CCP Quality Assurance QA Engineering Team Leader
Originally by: Lord Fitz Eve is to WoW as Wow is to an 8 player game of Unreal Tournament.
|
|
|
Ambo
State Protectorate
|
Posted - 2008.11.13 12:30:00 -
[11]
awesome, thank you. --------------------------------------
Trader? Investor? Just want to track your finances? Check out EMMA |
Gilgamoth
Eldritch Storm The Matari Consortium
|
Posted - 2008.11.13 17:06:00 -
[12]
The Community tool kit page still shows EA data dumps :)
Regards,
Gil
Live on Eden Underground Radio every Wednesday 19:00 - 21:00 GMT. |
WolfSinger SilverShadow
Gallente Caldari Deep Space Ventures Arcane Alliance
|
Posted - 2008.11.13 17:43:00 -
[13]
And for those of us who are MS-SQL challenged (IE, Mac & Linux users) I have converted it again into a MySQL dump:
http://dl.eve-files.com/media/corp/wolfsinger/eve-QuantumRise1_0MySQL.zip
Let me know if there are any problemms with that.
WolfSinger SilverShadow
|
Muscaat
Eve University Ivy League
|
Posted - 2008.11.13 18:35:00 -
[14]
Originally by: WolfSinger SilverShadow And for those of us who are MS-SQL challenged (IE, Mac & Linux users) I have converted it again into a MySQL dump:
http://dl.eve-files.com/media/corp/wolfsinger/eve-QuantumRise1_0MySQL.zip
Let me know if there are any problemms with that.
WolfSinger SilverShadow
Thanks WolfSinger... and after I spent the whole day wrestling with a VM and SQL Server...! (You'd think that MySQL could mention their migration tool on their "migrating from SQL Server" page, really, wouldn't you?)
|
J nx
Glowing Goat
|
Posted - 2008.11.13 18:43:00 -
[15]
Thanks for the dump and for the conversion to MySQL people!
-> Recruiting <-
|
Dragonaire
Caldari Corax.
|
Posted - 2008.11.13 21:28:00 -
[16]
Edited by: Dragonaire on 13/11/2008 21:28:38 Me too :D Thanks for the MySQL conversions know they save me a couple hours fighting with it myself trying to get it to work. -- Finds camping stations from the inside much easier. Been known to write some PHP code for API from time to time too. |
Vessper
Indicium Technologies
|
Posted - 2008.11.13 22:04:00 -
[17]
If anyone is interested in an Access version, I have made one available at http://www.evehq.net/download.php?view.39 - - -
EveHQ Character App | Item Database |
Madam Mika
Gallente Shadow-Triad Lost Sheep Domain
|
Posted - 2008.11.14 03:58:00 -
[18]
hemm the table is named eve_dbo which sucks cuz then u have to change it all and that's a waste of time Welcome to Madam's World |
Legowan Wealson
Caldari Ardent Industrial Arcane Alliance
|
Posted - 2008.11.14 08:21:00 -
[19]
Originally by: Madam Mika hemm the table is named eve_dbo which sucks cuz then u have to change it all and that's a waste of time
Nice way to thank someone for exporting it for you. Search&Replace on the two SQL scripts takes about 30s? ---
|
Nash'Krul
Madagascar Penguins
|
Posted - 2008.11.14 08:44:00 -
[20]
Lingorm, is ther a possibility that the above mentioned datadump is inconsistent?
I put the dump up, and made a compare of the old (trinity) and the new (quantum) structural build.
First thing I noticed was, that Attributes are no longer connected to their Categories as the "attributeCategory" field in the dgmAttributeTypes Table ceased to exist... Maybe it's me who is blind but I wasn't able to spot whether this link has just been moved to a separate table or has ben established in another form. -------------------------------------------------- si vis pacem para bellum |
|
iulixxi
EVE-RO
|
Posted - 2008.11.14 10:08:00 -
[21]
Originally by: Vessper If anyone is interested in an Access version, I have made one available at http://www.evehq.net/download.php?view.39
Yep ... I need it as usual , didnt had time to convert it myself Thnx m8.
Any news on the icons ?
Iulian
|
Jonai Laigon
|
Posted - 2008.11.14 10:14:00 -
[22]
Originally by: WolfSinger SilverShadow And for those of us who are MS-SQL challenged (IE, Mac & Linux users) I have converted it again into a MySQL dump:
http://dl.eve-files.com/media/corp/wolfsinger/eve-QuantumRise1_0MySQL.zip
Let me know if there are any problemms with that.
WolfSinger SilverShadow
Thank you! :) |
Tonto Auri
Vhero' Multipurpose Corp
|
Posted - 2008.11.14 10:35:00 -
[23]
Originally by: Nash'Krul SOLVED: nvm, I got that the link is now categoryID in the same table, seems I had got some tomatoes up my eyes :)
That's because table structure has been changed in (or before) EA. -- Thanks CCP for cu |
PyjamaSam
Minmatar Vanguard Frontiers Violent-Tendencies
|
Posted - 2008.11.14 14:17:00 -
[24]
Bumping this back up.
Any news on the icon renderings?
Community Toolkit page also still references the EA information.
chris.
|
WolfSinger SilverShadow
Gallente Caldari Deep Space Ventures Arcane Alliance
|
Posted - 2008.11.14 15:29:00 -
[25]
Originally by: Legowan Wealson
Originally by: Madam Mika hemm the table is named eve_dbo which sucks cuz then u have to change it all and that's a waste of time
Nice way to thank someone for exporting it for you. Search&Replace on the two SQL scripts takes about 30s?
Or just rename the database after you import it?
When you pull over an entire database with the MySQL Migration Toolkit, it sticks the database name in the script, and eve_dbo is the name of the DB in the official release. If I changed it, someone else would complain. As it is now, I have to edit the scripts to make sure TINYINT columns are UNSIGNED. Microsoft (and their "we do our own thing" mentality) seems to make the only database engine where TINYINT defaults to UNSIGNED instead of SIGNED like the rest of the world. |
DeTox MinRohim
Madhatters Inc. The Initiative.
|
Posted - 2008.11.14 18:05:00 -
[26]
Edited by: DeTox MinRohim on 14/11/2008 18:09:36 Seems that the old query that gives the skill requirements fails as some ships in the invTypes table don't have their requirements in the valueInt field but in the valueFloat field now. Example... the Orca.
Just want to let people know about it. |
Victoria Xanders
Caldari The Watchful Eye
|
Posted - 2008.11.14 19:22:00 -
[27]
tables agtResearchAgents and agtAgents are empty... does it mean that nothing changed since the last dump or what? |
Vessper
Indicium Technologies
|
Posted - 2008.11.14 23:44:00 -
[28]
Originally by: Victoria Xanders tables agtResearchAgents and agtAgents are empty... does it mean that nothing changed since the last dump or what?
Which export are you looking at? The official CCP ones do have these tables so unless you're looking at a faulty conversion??
- - -
EveHQ Character App | Item Database |
Victoria Xanders
Caldari The Watchful Eye
|
Posted - 2008.11.15 06:20:00 -
[29]
nevermind, it's just me being stupid, should've at least look inside ebs_datadump.sql before running it on freshly imported database. Quote: IF OBJECT_ID('dbo.agtAgents') IS NOT NULL DROP TABLE dbo.agtAgents
that's the reason...
|
Kniht
D.M.T inc Bionic Dawn
|
Posted - 2008.11.15 06:29:00 -
[30]
And here's a sqlite3 version of the export. I generated it with a python script reading the mysql version to grab sql statements, and I'm not sure I handle character encoding properly. However, it only appears to apply to some of the description fields.
I'm uploading it via bittorrent and eve-files says it will keep seeding for a few days afterwards.
|
|
|
|
|
Pages: [1] 2 3 4 :: one page |
First page | Previous page | Next page | Last page |