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.
 

Determine bonus for an item based on rig
Author
Previous Topic Next Topic
Manuel Olacar
Imperial Academy
Amarr Empire
#1 - 2017-03-02 18:29:46 UTC
Hello!

I am building a PHP/Mysql app for myself, to determine exactly the ammount of materials i need to build, for example, a Hel.

I have already determined that the attributes 2355, 2356, 2357, 2358, 2593, 2594, 2595 from the table dgmTypeAttributes, when multiplied, gives you the bonus of that rig, for time and materials.

How can i determine now the items that are affected by the rig? For example, for the Standup XL-Set Ship Manufacturing Efficiency I, how can i determine which items, groups of market groups are affected by that rig?

Im pulling my data from the SQL database via standard SQL statements. (Select * from blabla...)

Thanks a lot in advance!
Messenger Of Truth
Butlerian Crusade
#2 - 2017-03-08 16:50:22 UTC  |  Edited by: Messenger Of Truth
Manuel Olacar wrote:
Hello!

I am building a PHP/Mysql app for myself, to determine exactly the ammount of materials i need to build, for example, a Hel.

I have already determined that the attributes 2355, 2356, 2357, 2358, 2593, 2594, 2595 from the table dgmTypeAttributes, when multiplied, gives you the bonus of that rig, for time and materials.

How can i determine now the items that are affected by the rig? For example, for the Standup XL-Set Ship Manufacturing Efficiency I, how can i determine which items, groups of market groups are affected by that rig?

Im pulling my data from the SQL database via standard SQL statements. (Select * from blabla...)

Thanks a lot in advance!


You can't. If you poke around in the SDE a bit, you find in the database what looks like yaml which seems to refer to some kind of procedure which tells you whether or not the rig applies to this item. So you're going to have to hardcode this yourself.

What I've done is set up code like this:

        'rigEquipmentManufactureTimeBonus' : {'categories' : ['Module', 'Implant', 'Deployable'],
              'groups' : ['Secure Cargo Container', 'Freight Container', 'Audit Log Secure Container', 'Cargo Container'],
              'activities' : ['Manufacturing'],
              },


So we have the name of the effect "rigEquimentManufactureTimeBonus" (which is linked to the rig in the SDE via dgmEffects), then based on my interpretation of the in-game description of the rig I have manually added the category and group names that I believe this rig applies to, based on my interpretation of the rig description (either of which could be wrong).

You will need to come up with a similar mechanism to figure out which items a rig applies to.

Good luck!

Trade Hub Price Checker: stop.hammerti.me.uk/pricecheck

Visit "Haulers Channel" in game for all matters courier-related.

Structure name/system API: stop.hammerti.me.uk/api