Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Someones Scout
|
Posted - 2009.05.23 16:14:00 -
[1]
Data dumps are only available in mysql? Anyone has portion of it in xml? I need: Which type ID's are needed to manufacture some other typeID TypeID to name
Linux will be the OS of choise for my app Ty
|
Dragonaire
Caldari Corax. Sex Drugs And Rock'N'Roll
|
Posted - 2009.05.23 17:32:00 -
[2]
A XML version could be made from one of the SQL versions. I know you can with phpMyAdmin for MySQL and there has to be a way to do so with MsSQL too as that's where the data for the APIs comes from at some point -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|
LifeHatesMe
Royal Enterprise
|
Posted - 2009.05.23 18:12:00 -
[3]
Edited by: LifeHatesMe on 23/05/2009 18:16:03 If you use google, you find several methods of converting MySQL to XML. Some use a app, others show how to write a for loop that does it manually for each entry. I think the easiest method is through the command line with MySQL, shown here; http://en.wikibooks.org/wiki/XML_-_Managing_Data_Exchange/Converting_MySQL_to_XML
I should point out though, you want to try to steer clear from XML as much as possible, seeing as it's plain text, and the eve database is gigantic.. around the order of 500mb or so when in plain text format. (And that's not even with XML's bloated tag stuff)
XML seems to work best for small data snippits. Might be worthwhile to use a database management system internally for whatever your writing, and then exporting smaller XML objects with something like SOAP. Just a idea! :P
|
Dragonaire
Caldari Corax. Sex Drugs And Rock'N'Roll
|
Posted - 2009.05.23 18:19:00 -
[4]
Yep XML is nice to work with for some things but does have a lot of overhead too. It compress really well though -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|
LifeHatesMe
Royal Enterprise
|
Posted - 2009.05.23 18:26:00 -
[5]
Originally by: Dragonaire Yep XML is nice to work with for some things but does have a lot of overhead too. It compress really well though
I thought about that.. but then dismissed it, if you write in compression in XML, what happens is it takes longer to parse, same thing if you try to use https with XML objects. I love the idea of XML, but so far the actual methods you can use are too slow for anything but behind the scene updates.
|
Mamede
|
Posted - 2009.05.23 19:45:00 -
[6]
Edited by: Mamede on 23/05/2009 19:46:38
|
Someones Scout
|
Posted - 2009.05.23 22:50:00 -
[7]
Thank you to all the info. All I need is reactions. Which I mean all the materials needed to make complex reactions and their output. Then of course transforme typeIDs to Human readable names. Eve-central typeIDs are the same as database dumps? Ty for all the help and ideas.
|
LifeHatesMe
Royal Enterprise
|
Posted - 2009.05.25 21:00:00 -
[8]
Edited by: LifeHatesMe on 25/05/2009 21:06:50 I wrote a long post, but eve forums died on me.. it does that :/
SELECT IF(`input` = 0, 'Output', 'Input') AS `Reaction`, `invTypes`.`typeID`, `invTypes`.`typeName`, `quantity` FROM `invTypeReactions` INNER JOIN `invTypes` ON `invTypes`.`typeID` = `invTypeReactions`.`typeID` WHERE `reactionTypeID` = '17962' Which will return;Reaction typeID typeName quantity Output 16671 Titanium Carbide 1 Input 16654 Titanium Chromide 1 Input 16658 Silicon Diborite 1 If you want it for a specific marketGroupID, in this case marketGroupID 509, the query gets a little bit more complicated..SELECT IF(`input` = 0, 'Output', 'Input') AS `Reaction`, `invTypes`.`typeID`, `invTypes`.`typeName`, `quantity` FROM `invTypeReactions` INNER JOIN `invTypes` ON `invTypes`.`typeID` = `invTypeReactions`.`typeID` WHERE `reactionTypeID` IN (SELECT `typeID` FROM `invTypes` WHERE `marketGroupID` = '509') Just so you know, the reactionTypeID is the typeID for the blueprint, the one returned from invTypeReactions is the actual typeID's of the finished complex reaction, and the two (or more) ingredients.
|
Someones Scout
|
Posted - 2009.05.25 22:47:00 -
[9]
Hello, and thanks for the reply. I was like searching the database and I'm scratching my head. If I do SELECT * FROM invTypeReactions WHERE reactionTypeID=30345; +----------------+-------+--------+----------+ | reactionTypeID | input | typeID | quantity | +----------------+-------+--------+----------+ | 30345 | 0 | 30304 | 250 | | 30345 | 1 | 35 | 800 | | 30345 | 1 | 30370 | 300 | | 30345 | 1 | 30371 | 100 | +----------------+-------+--------+----------+
I get the right quantities for PPD Fullerene Fibers Reaction
But if I do SELECT * FROM invTypeReactions WHERE reactionTypeID=17963; +----------------+-------+--------+----------+ | reactionTypeID | input | typeID | quantity | +----------------+-------+--------+----------+ | 17963 | 0 | 16670 | 1 | | 17963 | 1 | 16655 | 1 | | 17963 | 1 | 16659 | 1 | +----------------+-------+--------+----------+ For crystalline carbonnide all I get is "1" in quantities. I checked for sylramic fibers and ends up in the same. Any hints?
|
LifeHatesMe
|
Posted - 2009.05.25 23:21:00 -
[10]
Edited by: LifeHatesMe on 25/05/2009 23:24:35 That's because basic reactions multiply, while complex reactions are 1 for 1. If you don't believe me, look them up here;
http://eve-online.itemdrop.net/eve_db/items/reaction/complex_reactions/
|
|
Someones Scout
|
Posted - 2009.05.26 08:10:00 -
[11]
Edited by: Someones Scout on 26/05/2009 08:14:16 I'm even more confused now ;).
100 carbonpolymers+100 crysallite alloy make 10000 crystalline carobnide. 100 ceramic powerder + 100 hexite make 6000 sylramic fibers
It's a volume relation? I'm lost Hmm... Moon mining ammount. you input 1x those and you get 1x those.
|
Someones Scout
|
Posted - 2009.05.28 07:24:00 -
[12]
bump.
|
LifeHatesMe
|
Posted - 2009.05.28 17:39:00 -
[13]
Originally by: Someones Scout I'm even more confused now ;).
100 carbonpolymers+100 crysallite alloy make 10000 crystalline carobnide. 100 ceramic powerder + 100 hexite make 6000 sylramic fibers
It's a volume relation? I'm lost Hmm... Moon mining ammount. you input 1x those and you get 1x those? How can I get that values?
quantity < that value.. ? What am I missing here? I believe the db matches the reaction quantities..
|
Someones Scout
|
Posted - 2009.05.28 21:20:00 -
[14]
...I'm feeling the dumbest person on earth. SELECT * FROM invTypeReactions WHERE reactionTypeID=17963; +----------------+-------+--------+----------+ | reactionTypeID | input | typeID | quantity | +----------------+-------+--------+----------+ | 17963 | 0 | 16670 | 1 | | 17963 | 1 | 16655 | 1 | | 17963 | 1 | 16659 | 1 | +----------------+-------+--------+----------+
In the db the quantity value shows 1. in game you need 100 of each of the inputs to give 10000 of the final product. You said it was a one to one reaction but i'm not getting how.
|
Someones Scout
|
Posted - 2009.05.29 17:45:00 -
[15]
Ok I got it now. I wasn't seeing the right table. I didn't noticed there was a dgmAttributeTypes and a dgmTypeAttributes. Ty for all the help. I have everything I need now :)
|
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |