These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

Get Base Invention Chance
Author
Previous Topic Next Topic
Talos Katuma
Helion Production Labs
Independent Operators Consortium
#1 - 2012-01-11 22:57:01 UTC
Can anyone tell me where in the dump I can get the base invention chance from? This is needed to compute the actual invention chance.
Ruziel
Twilight Military Industrial Complex
#2 - 2012-01-11 23:20:09 UTC  |  Edited by: Ruziel
It's not in the dump. You'll have to add it in or otherwise figure it out.
I add it to my database with a script every time a new dump is released.
I'd post it, but I don't have it where I can get to it right now.
Dragonaire
Here there be Dragons
#3 - 2012-01-12 04:32:35 UTC
If you haven't found this site yet you'll want to bookmark it.
http://wiki.eve-id.net/Main_Page
There's info there on the static data dump (and the missing ones) plus pages about the formulas used etc. Might save you a lot of time.

Finds camping stations from the inside much easier. Designer of Yapeal for the Eve API. Check out the Yapeal PHP API Library thread.
Talos Katuma
Helion Production Labs
Independent Operators Consortium
#4 - 2012-01-12 06:15:29 UTC
@Dragonaire I know the wiki but didn't find the information about the base invention chance there

@Ruziel thanks for the info, would be great if you can post the script when you get access to it
Ruziel
Twilight Military Industrial Complex
#5 - 2012-01-12 07:00:58 UTC
Here's the script I use on MySQL, that adds a column to the blueprints table:

ALTER TABLE invBlueprintTypes ADD chanceOfInvention FLOAT NULL;

UPDATE invBlueprintTypes bt, invTypes t
SET bt.chanceOfInvention =
CASE
WHEN t.groupID IN (419,27) OR t.typeID = 17476
THEN 0.20
WHEN t.groupID IN (26,28) OR t.typeID = 17478
THEN 0.25
WHEN t.groupID IN (25,420,513) OR t.typeID = 17480
THEN 0.30
WHEN EXISTS (SELECT * FROM invMetaTypes WHERE parentTypeID = t.typeID AND metaGroupID = 2)
THEN 0.40
ELSE 0.00
END
WHERE bt.productTypeID = t.typeID;

ALTER TABLE invBlueprintTypes MODIFY chanceOfInvention FLOAT NOT NULL;
Talos Katuma
Helion Production Labs
Independent Operators Consortium
#6 - 2012-01-12 18:45:24 UTC
Great, thx a lot