| Author |
Thread Statistics | Show CCP posts - 22 post(s) |
Aineko Macx
Royal Amarr Institute
Amarr Empire
298
   |
Posted - 2014.07.12 09:56:00 -
[1] - Quote
Steve Ronuken wrote:SDE conversions
Thx Steve, again you bring light and order into this mess.
Before I begin any development on it, are you somewhat sure you'll keep the proposed scheme for the industry tables?
Some notes:
- Column 'typeid' in industryActivitySkills should be 'typeID' for consistency
- If you have composite indices over (typeID, activityTypeID), another simple index over typeID is redundant. The only use I could see is for implementing foreign keys, which is pointless for this static data.
iveeCore - PHP library for calculations of industrial activities |
Aineko Macx
Royal Amarr Institute
Amarr Empire
300
|
Posted - 2014.07.20 15:35:00 -
[2] - Quote
Are the CREST endpoints actually cached server side and if so, are the caches invalidated at predictable times? i.e. are 1-hour long caches cleared every full our? What about the 23h cache? Or is it just a rate-limit by IP and the actual cache logic being completely opaque?
iveeCore - PHP library for calculations of industrial activities |
Aineko Macx
Royal Amarr Institute
Amarr Empire
301
|
Posted - 2014.07.21 19:21:00 -
[3] - Quote
Thx. Some form of cache expiry indicator would be much appreciated.
Next question: What is the criteria for which typeIDs are included in the market/prices CREST endpoint? I currently see only a bit more than half of the tradeable items there.
iveeCore - PHP library for calculations of industrial activities |
Aineko Macx
Royal Amarr Institute
Amarr Empire
301
|
Posted - 2014.07.22 18:59:00 -
[4] - Quote
probag Bear wrote:In simpler words:
The teams CREST endpoints give you the bonuses of each team, but don't tell you if they apply towards Manufacturing, Copying, ME Research, or TE Research.
There is a "value" attribute...
@CCP: I find the industry/facilities endpoint hugely bloated, the only data of value in there seems to be "tax" and "owner" (and corps have their own endpoint), everything else is static and available in the SDE.
iveeCore - PHP library for calculations of industrial activities |
Aineko Macx
Royal Amarr Institute
Amarr Empire
301
|
Posted - 2014.07.22 21:56:00 -
[5] - Quote
probag Bear wrote:Value tells you what the actual value of the bonus is. What's missing is what activity the bonus is being applied towards.
Ah, i think what you mean has to be looked up in the referenced specialties endpoint.
@CCP: What I'm actually missing from the facilities endpoint is something like assemblyLineTypeIDs, as AFAIK there is currently no way to get this info for player built outposts.
iveeCore - PHP library for calculations of industrial activities |
Aineko Macx
Royal Amarr Institute
Amarr Empire
301
|
Posted - 2014.07.23 08:28:00 -
[6] - Quote
Yes, I see the problem now that I'm trying to handle teams. Workers have both bonus and specialization nodes, but teams have only specialization, so it's not possible to determine the type or value of the bonus.
tl;dr whats missing so far in CREST:
- bonus node for teams
- assemblyLineTypeIDs for facilities
iveeCore - PHP library for calculations of industrial activities |
| |
|