Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Tarei
Minmatar GoonFleet GoonSwarm
|
Posted - 2009.07.02 00:07:00 -
[1]
Edited by: Tarei on 02/07/2009 00:08:51 I'm working on a side project that's dealing with killmails and I seem to be a bit puzzled about a couple things. I've looked over the API docs and can't seem to find out where I'm missing things.
- How do you correlate an alliance with it's logo id? That is, how do I go from the alliance ID for GoonSwarm of '824518128' to their logo name of '23_02' (Only picked theirs because I knew what their logo looks like).
- How do you correlate a ship module from the invTypes table to to their slot (High/Med/Low)? If all I have is a killmail that says 'Warp Core Stabilizer', how do I find out that it's a Low-slot module?
- Tarei |
Johnathan Roark
Caldari Quantum Industries RAZOR Alliance
|
Posted - 2009.07.02 01:32:00 -
[2]
Only way is by using Eve-Dev Wiki. Its built by user contributions since ccp hasn't ever released the mappings. I just looked that up the other day as I am getting ready to do this for Karambit Killboard System. I am thinking about just renaming every image to match its ID to save a database lookup.
Vuk Lau for CSM 3.0 |
Tarei
Minmatar GoonFleet GoonSwarm
|
Posted - 2009.07.02 01:33:00 -
[3]
Cool; thanks for pointing this out.
Any idea on how to get a ship module's slot type?
- Tarei |
Johnathan Roark
Caldari Quantum Industries RAZOR Alliance
|
Posted - 2009.07.02 01:55:00 -
[4]
Originally by: Tarei Cool; thanks for pointing this out.
Any idea on how to get a ship module's slot type?
From the killmail api, in the item section, there is a field called flag, that relates to invFlags from the eve database dump
Vuk Lau for CSM 3.0 |
Tarei
Minmatar GoonFleet GoonSwarm
|
Posted - 2009.07.02 15:08:00 -
[5]
Edited by: Tarei on 02/07/2009 15:12:53 Hrm, I guess, i'm not seeing it. Take for instance a T2 Miner:
insert into table invTypes (typeID, groupID, typeName, description, graphicID, radius, mass, volume, capacity, portionSize, raceID, basePrice, published, marketGroupID, chanceOfDuplicating) values (482,54,'Miner II','Has an improved technology beam, making the extraction process more efficient. Useful for extracting all but the rarest ore.',1061,25,0,5,0,1,NULL,7912 8,1,1039,0.06);
I would assume that this would be related to one of the rows in invFlag that would have a flagID between 26-34, but am I wrong?
Let's just say I have a totally imported database from the EVE DB dump and I have the string "Miner II". What sort of SQL am I looking at in order to tell me that it's a "Hi Slot Module"?
- Tarei |
Tarei
Minmatar GoonFleet GoonSwarm
|
Posted - 2009.07.02 18:15:00 -
[6]
Hrm, I suppose I'm getting a bit closer:
select invTypes.typeName as name, dgmEffects.effectName as slot from invTypes, dgmEffects, dgmTypeEffects where dgmTypeEffects.typeID = invTypes.typeID and dgmTypeEffects.effectID = dgmEffects.effectID and invTypes.typeName = 'Miner II';
But that's returning more rows than I need/want: +----------+--------------+ | name | slot | +----------+--------------+ | Miner II | hiPower | | Miner II | online | | Miner II | turretFitted | | Miner II | miningLaser | +----------+--------------+
I think I'm just going to have to write some sort of parser to statically set these in another table or something.
- Tarei |
Dragonaire
Caldari Corax.
|
Posted - 2009.07.03 13:53:00 -
[7]
Might check out the /char/AssetList.xml.aspx page at EVE-Dev where they refer to the http://wiki.eve-id.net/API_Inventory_Flags page as it also applies to kills -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|
Jurimaru
|
Posted - 2009.07.03 16:13:00 -
[8]
Edited by: Jurimaru on 03/07/2009 16:15:50 Tarei: You may try this query to 1.2 off dump
Quote: select i.typeID, i.typeName, case s.slot_type when 11 then 'low' when 12 then 'med' when 13 then 'high' when 2663 then 'rig' when 8 then 'subsystem' end as slot from invTypes i left join ( select typeID, effectID as slot_type from dgmTypeEffects where effectID in (11, 12, 13, 2663) union select typeID, CAST (valueFloat-120 as varchar) from dgmTypeAttributes WHERE attributeID=1366 ) as s on s.typeID=i.typeID where i.typeName in ('Heavy Missile Launcher I', 'Warp Disruptor II', 'Damage Control I', 'Trimark Armor Pump I', 'Legion Offensive - Covert Reconfiguration')
It looks like it works, however i suppose a number of exceptions might arise.
The whole concept around modules and so on refers to data extraction from official dumps which is normal
Regarding correlation between allianceID and icon names in format "xx_xx" it is a challenge to convert. EDK IconToAllianceID mapping appears to be a great job done manually which is hard to update unfortunately. It would be great in case CCP includes in the next db dump that mapping as soon as image\icons dump already has the format of xx_xx.
btw: Recently i've discovered that the format of killmails has been changed to contain information about items stored in containers. Where i could find let's say relevant and up-to-date info regarding killmail's format update?
|
Dragonaire
Caldari Corax.
|
Posted - 2009.07.03 16:35:00 -
[9]
Quote: btw: Recently i've discovered that the format of killmails has been changed to contain information about items stored in containers. Where i could find let's say relevant and up-to-date info regarding killmail's format update?
http://wiki.eve-id.net/APIv2_Char_KillLog_XML and look at the notes just before description of the items Rowset it's the only reference I've ever found about it (After I added it anyway when figuring out that API for Yapeal )
EVE-Dev is probably one of the best places to look for any information about the Eve APIs as it seems more people have taken the time to keep it updated then anywhere else I've found. I know I've always tried to update it every time I run into something new while working on Yapeal even taking a few hours to clean a lot of the API pages and reformatting some of them to make it IMHO easier to use. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |