Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 [14] [14]:: one page |
|
Author |
Thread Statistics | Show CCP posts - 3 post(s) |
Chruker
|
Posted - 2007.10.21 23:58:00 -
[391]
I'm slowly building one for the ice ores, but so far I've just added to it when I passed a system with a belt.
function getIceOre($securityClass) { $matrix = array( "C"=> "White Glaze", "D1"=> "Blue Ice", "D3"=> "Blue Ice, Glare crust", "H7"=> "Krystallos, Pristine White Glaze", "J"=> "Dark Glitter, Glare crust, Thick Blue Ice", );
if (array_key_exists($securityClass, $matrix)) { return $matrix[$securityClass]; } else { return "Unknown"; } }
----- http://games.chruker.dk/eve_online ----- Top wishes: - No daily downtime - Faster training on sisi - Speedup IGB table rendering |
Z010
|
Posted - 2007.10.28 09:55:00 -
[392]
One of the search functions I used on an earlier version of the database was to search for the string "Ice Field". Then I at least had the systems that had ice at all.
From that, I used faction to determine which "basic" ice (for isotopes) would be available, and for regions that were accessible to me, I went in a shuttle on SISI to check for the "special" ice.
|
Ischia
|
Posted - 2007.11.04 01:49:00 -
[393]
Looking at the DB I can't seem to see which attributes apply when a module is offline, online or activated.
Anyone know how to tell?
I've looked at Invulnerability Field II and Expanded Cargo I; the descriptions help, but I'd be most interested in a reliable query for determining when attributes apply.
|
Rexy
DarkStar 1 GoonSwarm
|
Posted - 2007.11.11 16:01:00 -
[394]
Edited by: Rexy on 11/11/2007 16:01:47
Originally by: Raquel Smith
See here.
parentblueprinttypeid, i expected it to point to the parenblueprint id, but for instance for the vagabond it is null, what is it supposed to point to?
also when i imported the postgres sql the strings in char fields of variable lenght were not terminated, So "Stabber" would be stored as "Stabber +lots of spaces", not sure if this is desired?
<unusual big structure 4tw> |
Jedzias Miezekatze
|
Posted - 2007.11.15 11:05:00 -
[395]
Another version of my AIO mysql installer.
Sponsored by chrucker
|
Tak nTar
Gallente Center for Advanced Studies
|
Posted - 2007.12.09 11:51:00 -
[396]
Edited by: Tak nTar on 09/12/2007 11:51:53 Hey, iI#m looking for a site where I can get the offical database for a market-tool I'm writing. Could somebody give me a hint, please ? I found the site of Chruker, but is that the official source ? :) Tak
EDIT: Ummh, where can I set the Icon for my Avatar ?
|
Greymalkin Gillion
Gallente Freelancing Corp Confederation of Independent Corporations
|
Posted - 2007.12.11 11:03:00 -
[397]
Use: EVE-DEV CCP database dump resources
Plus: your avatar will become available by itself in due time
|
Tak nTar
Gallente Center for Advanced Studies
|
Posted - 2007.12.11 21:40:00 -
[398]
Thx !!! :) Tak
|
Ilor Prophet
|
Posted - 2007.12.31 20:33:00 -
[399]
Is there a handy key somewhere that equates the icon filenames with the graphicID field in the tables?
|
Zuiki
Ulysse Inc. The Core Collective
|
Posted - 2008.01.01 16:44:00 -
[400]
Originally by: Ilor Prophet Is there a handy key somewhere that equates the icon filenames with the graphicID field in the tables?
Indeed. Get a graphic for type and look at "icon" field.
|
|
Ilor Prophet
|
Posted - 2008.01.02 20:11:00 -
[401]
Ah, excellent! Thanks!
|
Xeron Silverblade
Esthar Industries Tres Viri
|
Posted - 2008.01.07 05:45:00 -
[402]
i can't find the images for the blueprint-icons any more neither any reference to them in the db... anybody can help me here?
|
Zuiki
Ulysse Inc. The Core Collective
|
Posted - 2008.01.08 19:48:00 -
[403]
Where to find list of materials for building simple T1 stuff and components?
There is tl2...blabla.. table, but there is no info on building things like "FOO thruster" and "BAR shield emitter".
|
Tkar vonBiggendorf
Gallente Snake Eyes Inc Rule of Three
|
Posted - 2008.01.09 01:46:00 -
[404]
Originally by: Zuiki Where to find list of materials for building simple T1 stuff and components?
There is tl2...blabla.. table, but there is no info on building things like "FOO thruster" and "BAR shield emitter".
http://wiki.eve-dev.net/Bill_of_Materials
|
Zuiki
Ulysse Inc. The Core Collective
|
Posted - 2008.01.09 06:47:00 -
[405]
http://wiki.eve-dev.net/Bill_of_Materials
Still no materials for capital components and t2 components.
And i have to use activity = 6 (duplicating??) even for t1 items.
PS: Using postgresql dump.
|
Barlaam Aella
|
Posted - 2008.01.19 10:18:00 -
[406]
Edited by: Barlaam Aella on 19/01/2008 10:18:45 AM sort of stuck and can not find any info on this within these pages...
I have downloaded the latest MS SQL datafiles and am looking at the reactions
Query SELECT * FROM dbo_invtypereactions d where reactionTypeID = 17972; reactionTypeIDinputtypeIDquantity 17972 017317 1 17972 116663 1 17972 116668 1 17972 117769 1 17972 117960 1
lists the results for Fermionic Condensates requiring apparently 1 of each material and resulting in 1 output.
The ingame reaction states 100 of each material required and 200 is the result.
Similar quieries give the same result.. Crystalline Carbonide 2 items 1 each and 1 result from the database but ingame 100 of each item and 10,000 results...
does anyone know where to pick up the correct values from please... ????
Many regards.. G
|
Raskor
|
Posted - 2008.03.03 06:20:00 -
[407]
Edited by: Raskor on 03/03/2008 06:25:05 I created a query in an attempt to mimic the "hierarchy" information displayed for an item in the Market.
For the 1st example I look at Cruise Missile Launcher I (typeID = 13320):
13320,Cruise Missile Launcher I,Cruise Launchers,140,Missile Launchers,10,Turrets & Bays,9,Ship Equipment,NULL,NULL,NULL,NULL,NULL
This matches the Market for this item: (read sql output backwards) Ship Equipment / Turrets & Bays / Missile Launchers / Cruise Launchers
Next I look at Tritanium (typeID = 34):
34,Tritanium,Minerals,533,Materials,475,Manufacture & Research,NULL,NULL,NULL,NULL,NULL,NULL,NULL
However on the market, it is Manufacture & Research / Materials / Ore & Minerals / Minerals. Where did the Ore & Minerals come from?
Lastly I look at Proton S (typeID = 180):
180,Proton S,Small,845,Standard Ammo,99,Projectile Ammo,11,Ammunition & Charges,9,Ship Equipment,NULL,NULL,NULL
Here again we have a difference. In the data, "Ammunition & Charges" has a parent of "Ship Equipment" but in the Market it displays as:
Ammunition & Charges / Projectile Ammo / Standard Ammo / Small
Am I missing something in the data or did they hard code some things and not others?
|
Raskor
|
Posted - 2008.03.03 06:21:00 -
[408]
Originally by: Raskor I created a query in an attempt to mimic the "hierarchy" information displayed for an item in the Market.
Here is the query:
select a.typeId, a.typeName, b.marketGroupName, b.parentGroupID, c.marketGroupName, c.parentGroupID, d.marketGroupName, d.parentGroupID, e.marketGroupName, e.parentGroupID, f.marketGroupName, f.parentGroupID, g.marketGroupName, g.parentGroupID from dbo.invTypes a, dbo.invMarketGroups b, dbo.invMarketGroups c left outer join dbo.invMarketGroups d on c.parentGroupID = d.marketGroupID left outer join dbo.invMarketGroups e on d.parentGroupID = e.marketGroupID left outer join dbo.invMarketGroups f on e.parentGroupID = f.marketGroupID left outer join dbo.invMarketGroups g on f.parentGroupID = g.marketGroupID where a.marketGroupID is not NULL and a.marketGroupID = b.marketGroupID and b.parentGroupID = c.marketGroupID and a.typeID = 13320 order by a.typeId;
PS: Any word on a new data dump for Trinity?
|
Jaabaa
Minmatar Dental Drilling Corporation
|
Posted - 2008.03.03 15:47:00 -
[409]
Originally by: Raskor
PS: Any word on a new data dump for Trinity?
Hi,
The trinity dump has been available for quite a while.
Trinity 1.0 Static Data Export -- EVE Mobile Skill Planner V3 !! http://evemsp.sourceforge.net/ |
Raskor
|
Posted - 2008.03.03 19:38:00 -
[410]
Originally by: Jaabaa The trinity dump has been available for quite a while.
Trinity 1.0 Static Data Export
Thanks for the heads up. I switched to the Trinity data and now my query matches what is displayed in game.
|
|
|
|
|
Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 [14] [14]:: one page |
First page | Previous page | Next page | Last page |