Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 6 post(s) |
Zifrian
Licentia Ex Vereor The Gorgon Spawn
1606
|
Posted - 2015.01.14 01:57:22 -
[1] - Quote
ramAssemblyLineTypeDetailPerCategory still is missing all rows for categoryID=9, which is Blueprints. This affects the lookups for copying, and ME/TE research facilities.
We've brought this up in threads for the last three SDEs. Is there something here that I'm missing and this is not an issue, or can we get this fixed? Category 34 was removed (Ancient Relics) with pheobe, and that is fine but this is pretty key to facility look ups.
Help?
GÇ£Any fool can criticize, condemn, and complain - and most fools do. GÇ¥ - Dale Carnegie
Maximze your Industry Potential! - Download EVE Isk per Hour!
|
|
CCP FoxFour
C C P C C P Alliance
3818
|
Posted - 2015.01.14 11:05:03 -
[2] - Quote
Have passed word of this on. Will let you know what I hear. :)
@CCP_FoxFour // Technical Designer // Team Size Matters
Third-party developer? Check out the official developers site for dev blogs, resources, and more.
|
|
Zifrian
Licentia Ex Vereor Phoebe Freeport Republic
1616
|
Posted - 2015.03.19 02:29:31 -
[3] - Quote
CCP FoxFour wrote:Have passed word of this on. Will let you know what I hear. :) Re-bumping this. I just looked at the Tiamat database and this still isn't fixed. Can you look into it again? I never got a response but I understand that this isn't a high priority.
GÇ£Any fool can criticize, condemn, and complain - and most fools do. GÇ¥ - Dale Carnegie
Maximze your Industry Potential! - Download EVE Isk per Hour!
|
Aineko Macx
344
|
Posted - 2015.03.25 06:37:40 -
[4] - Quote
... and the Scylla SDE misses this again.
iveeCrest: A PHP library for CREST || iveeCore: The PHP library for industrial activities
|
|
CCP FoxFour
C C P C C P Alliance
3950
|
Posted - 2015.03.25 11:01:08 -
[5] - Quote
Thanks for the bump. Will poke people harder. :)
@CCP_FoxFour // Technical Designer // Team Size Matters
Third-party developer? Check out the official developers site for dev blogs, resources, and more.
|
|
|
CCP Nullarbor
C C P C C P Alliance
1156
|
Posted - 2015.04.21 14:13:15 -
[6] - Quote
This is not an error, just a change to the data we store in this table since the Crius release.
Details per category defines the blueprints that are compatible with an assembly line type, as well as any bonuses available. The way it does this is by checking to see if the productTypeID defined in the manufacturing activity of each blueprint exists within the category in ramAssemblyLineTypeDetailPerCategory. If it is then the blueprint can be used and / or a bonus can be applied.
You can find the productTypeID from the blueprints.yaml file in the SDE.
It's not particularly elegant, and I want to eventually move the assembly line data into YAML too. Most likely when we get to the new assembly array structures.
For now though, I hope that helps.
CCP Nullarbor // Senior Engineer // Team Game of Drones
|
|
Ortho Loess
Pentag Blade Curatores Veritatis Alliance
56
|
Posted - 2015.04.21 19:18:13 -
[7] - Quote
Sounds like a great example of why I want to con fuzzysteve into writing the SDE docs |
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
5184
|
Posted - 2015.04.21 21:12:58 -
[8] - Quote
Ortho Loess wrote:Sounds like a great example of why I want to con fuzzysteve into writing the SDE docs
Noooooooooooooooooooooooooooooooooooooooooooooooooo *breath* oooooooooooooooooooooooooooooooo
Woo! CSM X!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Zifrian
Licentia Ex Vereor Phoebe Freeport Republic
1629
|
Posted - 2015.04.28 23:16:19 -
[9] - Quote
CCP Nullarbor wrote:This is not an error, just a change to the data we store in this table since the Crius release.
Details per category defines the blueprints that are compatible with an assembly line type, as well as any bonuses available. The way it does this is by checking to see if the productTypeID defined in the manufacturing activity of each blueprint exists within the category in ramAssemblyLineTypeDetailPerCategory. If it is then the blueprint can be used and / or a bonus can be applied.
You can find the productTypeID from the blueprints.yaml file in the SDE.
It's not particularly elegant, and I want to eventually move the assembly line data into YAML too. Most likely when we get to the new assembly array structures.
For now though, I hope that helps. Thanks for the reply.
I'm still not sure I understand what is going on. The ramAssemblyLineTypeDetailPerCategory table is linked by assemblyLineTypeID to ramAssemblyLineTypes, which as the activityID field. Perhaps saying that there are no categoryID 9's in the table is incorrect. Maybe a better way to highlight the issue I'm seeing is that there are no assemblyLineTypeID's that link to activities 3, 4, or 5.
select * from ramAssemblyLineTypeDetailPerCategory where assemblyLineTypeID in (select assemblyLineTypeID from ramAssemblyLineTypes where activityID in (3,4,5))
This is what facilities do ME/TE/Copy activities and before this was accomplished with the records that had categoryID 9 (Blueprint).
It really doesn't matter (as far as I can tell) what blueprint you are using; what matters is what the bp's item category links to in the table. If I read right what you say above, then you would need every category of products for all blueprints added for every assemblyLineTypeID that you can do activity 3/4/5. Right now that's not the case and I don't know (for my purposes) what facilities can do copying and what bonuses they have, hence why I just copy over the old table from Phoebe.
Hope that makes more sense. Again, I might not be reading the data correctly but if not, I'd love to see an example of where I'm screwing up.
GÇ£Any fool can criticize, condemn, and complain - and most fools do. GÇ¥ - Dale Carnegie
Maximze your Industry Potential! - Download EVE Isk per Hour!
|
Aineko Macx
346
|
Posted - 2015.04.29 07:06:19 -
[10] - Quote
ignore
iveeCrest: A PHP library for CREST || iveeCore: The PHP engine for industrial activities
|
|
|
CCP Nullarbor
C C P C C P Alliance
1157
|
Posted - 2015.05.02 15:02:06 -
[11] - Quote
Ok I inderstand now.
If there is no entry in details per group or category then it means that assembly line has no restrictions or bonuses to specific blueprints, and will accept any blueprint that supports that activity. You can check the blueprint data to determine which of them have that activity.
CCP Nullarbor // Senior Engineer // Team Game of Drones
|
|
Zifrian
Licentia Ex Vereor Phoebe Freeport Republic
1630
|
Posted - 2015.05.02 17:54:35 -
[12] - Quote
CCP Nullarbor wrote:Ok I inderstand now.
If there is no entry in details per group or category then it means that assembly line has no restrictions or bonuses to specific blueprints, and will accept any blueprint that supports that activity. You can check the blueprint data to determine which of them have that activity. Thanks for the reply.
The issue with this though is that Copying, ME/TE research are all activities that have bonuses in POS laboratories and those values are not included in the group or category tables for activities 3,4, or 5. By your reply, they should have a bonus value in the tables.
See these labs: http://games.chruker.dk/eve_online/inventory.php?group_id=413
SELECT ARRAY_TYPE_ID, ARRAY_NAME, ACTIVITY_ID, ACTIVITY_NAME, BASE_MM * ADDITIONAL_MM AS MM, BASE_TM * ADDITIONAL_TM AS TM, BASE_CM * ADDITIONAL_CM AS CM, GROUP_ID, GROUP_NAME, CATEGORY_ID, CATEGORY_NAME FROM ( SELECT typeID AS ARRAY_TYPE_ID, typeName AS ARRAY_NAME, ramActivities.activityID AS ACTIVITY_ID, activityName AS ACTIVITY_NAME, baseMaterialMultiplier AS BASE_MM, baseTimeMultiplier AS BASE_TM, baseCostMultiplier AS BASE_CM, materialMultiplier AS ADDITIONAL_MM, timeMultiplier AS ADDITIONAL_TM, costMultiplier AS ADDITIONAL_CM,0 AS GROUP_ID, NULL AS GROUP_NAME, invCategories.categoryID AS CATEGORY_ID, invCategories.categoryName AS CATEGORY_NAME FROM ramInstallationTypeContents, invTypes, ramAssemblyLineTypes, ramActivities, invGroups AS IG1, invCategories AS IC1, invCategories, ramAssemblyLineTypeDetailPerCategory WHERE ramInstallationTypeContents.assemblyLineTypeID = ramAssemblyLineTypes.assemblyLineTypeID AND ramAssemblyLineTypeDetailPerCategory.categoryID = invCategories.categoryID AND ramAssemblyLineTypes.assemblyLineTypeID = ramAssemblyLineTypeDetailPerCategory.assemblyLineTypeID AND ramAssemblyLineTypes.activityID = ramActivities.activityID AND invTypes.groupID = IG1.groupID AND IG1.categoryID = IC1.categoryID AND ramInstallationTypeContents.installationTypeID = invTypes.typeID AND IC1.categoryID = 23 UNION SELECT typeID AS ARRAY_TYPE_ID, typeName AS ARRAY_NAME, ramActivities.activityID AS ACTIVITY_ID, activityName AS ACTIVITY_NAME, baseMaterialMultiplier AS BASE_MM, baseTimeMultiplier AS BASE_TM, baseCostMultiplier AS BASE_CM, materialMultiplier AS ADDITIONAL_MM, timeMultiplier AS ADDITIONAL_TM, costMultiplier AS ADDITIONAL_CM, invGroups.groupID AS GROUP_ID, invGroups.groupName AS GROUP_NAME, invGroups.categoryID AS CATEGORY_ID, invCategories.categoryName AS CATEGORY_NAME FROM ramInstallationTypeContents, invTypes, ramAssemblyLineTypes, ramActivities, invGroups AS IG1, invCategories AS IC1, invGroups, ramAssemblyLineTypeDetailPerGroup, invCategories WHERE ramInstallationTypeContents.assemblyLineTypeID = ramAssemblyLineTypes.assemblyLineTypeID AND ramAssemblyLineTypeDetailPerGroup.groupID = invGroups.groupID AND ramAssemblyLineTypes.assemblyLineTypeID = ramAssemblyLineTypeDetailPerGroup.assemblyLineTypeID AND ramAssemblyLineTypes.activityID = ramActivities.activityID AND invTypes.groupID = IG1.groupID AND IG1.categoryID = IC1.categoryID AND invGroups.categoryID = invCategories.categoryID AND ramInstallationTypeContents.installationTypeID = invTypes.typeID AND IC1.categoryID = 23) AS ASSEMBLY_ARRAYS WHERE (GROUP_NAME IS NOT NULL OR CATEGORY_NAME IS NOT NULL) AND ACTIVITY_ID <> 1 ORDER BY ARRAY_NAME
The result of the above query on the SDE in MSSQL is:
ARRAY_TYPE_ID ARRAY_NAME ACTIVITY_ID ACTIVITY_NAME MM TM CM GROUP_ID GROUP_NAME CATEGORY_ID CATEGORY_NAME 28351 Design Laboratory 8 Invention 1 0.5 1 0 NULL 6 Ship 28351 Design Laboratory 8 Invention 1 0.5 1 0 NULL 7 Module 28351 Design Laboratory 8 Invention 1 0.5 1 0 NULL 8 Charge 28351 Design Laboratory 8 Invention 1 0.5 1 0 NULL 18 Drone 28351 Design Laboratory 8 Invention 1 0.5 1 0 NULL 22 Deployable 24567 Experimental Laboratory 8 Invention 1 1 1 973 Subsystem Blueprints 9 Blueprint 24567 Experimental Laboratory 8 Invention 1 1 1 996 Strategic Cruiser Blueprints 9 Blueprint 24567 Experimental Laboratory 8 Invention 1 1 1 1309 Tactical Destroyer Blueprint 9 Blueprint
Two things to note are that there are no records for 3/4/5 activities, which have bonuses in both those assembly arrays, and for the experimental lab, blueprints are included for subsystems and subsystems. Shouldn't those be Category 6 for ship and Category 23 for subsystem?
Although, above you said 'specific blueprints' so does that mean that we have to hardcode the bonus values (50% for copying in a design lab for instance) that we would otherwise get from the table? That's not ideal and not really the point of all this is it? I'd like to use the SDE to NOT do wor...
GÇ£Any fool can criticize, condemn, and complain - and most fools do. GÇ¥ - Dale Carnegie
Maximze your Industry Potential! - Download EVE Isk per Hour!
|
|
CCP Nullarbor
C C P C C P Alliance
1157
|
Posted - 2015.05.04 22:27:50 -
[13] - Quote
The bonus for the other activities is on the ramAssemblyLineTypes table in the baseTimeMultiplier, baseMaterialMultiplier and baseCostMultiplier columns.
Take note that these bonuses multiply with any category or group bonuses in the case where there is both a base value and a per group or per category value. You can actually see this in game because the facility bonus will appear twice in the tooltip.
CCP Nullarbor // Senior Engineer // Team Game of Drones
|
|
Zifrian
Licentia Ex Vereor Phoebe Freeport Republic
1631
|
Posted - 2015.05.04 23:19:55 -
[14] - Quote
CCP Nullarbor wrote:The bonus for the other activities is on the ramAssemblyLineTypes table in the baseTimeMultiplier, baseMaterialMultiplier and baseCostMultiplier columns.
Take note that these bonuses multiply with any category or group bonuses in the case where there is both a base value and a per group or per category value. You can actually see this in game because the facility bonus will appear twice in the tooltip. Ahh ok, that was what I was missing. I guess I should have figured that out but I was stuck on the idea that we had to have a record in category or group since we had the old blueprint category for so long. Looks like it's a left join then.
I'll play around with it and rework my create table queries but I should be able to figure out what I need.
Thanks again for the replies. Very helpful...Now if we could just get the installed upgrades and tax rates for outposts in the industry facilities via CREST, this would be perfect.
GÇ£Any fool can criticize, condemn, and complain - and most fools do. GÇ¥ - Dale Carnegie
Maximze your Industry Potential! - Download EVE Isk per Hour!
|
|
CCP Nullarbor
C C P C C P Alliance
1158
|
Posted - 2015.05.05 11:17:09 -
[15] - Quote
I don't think that one is used, if you have a look at ramInstallationTypeContents you can see it is not assigned to any installation types.
We don't have outposts in the crest api because the tax rate is private information. In game we show you *your* tax rate but not the tax rates for all the different standings, nor do we show you what standing you have been set to. All NPC stations should be in there though.
CCP Nullarbor // Senior Engineer // Team Game of Drones
|
|
Zifrian
Licentia Ex Vereor Phoebe Freeport Republic
1631
|
Posted - 2015.05.05 11:47:59 -
[16] - Quote
CCP Nullarbor wrote:I don't think that one is used, if you have a look at ramInstallationTypeContents you can see it is not assigned to any installation types.
We don't have outposts in the crest api because the tax rate is private information. In game we show you *your* tax rate but not the tax rates for all the different standings, nor do we show you what standing you have been set to. All NPC stations should be in there though. Yeah I figured the tax and upgrade info would be private, but was hoping. Thanks again.
GÇ£Any fool can criticize, condemn, and complain - and most fools do. GÇ¥ - Dale Carnegie
Maximze your Industry Potential! - Download EVE Isk per Hour!
|
Aineko Macx
346
|
Posted - 2015.05.06 20:50:53 -
[17] - Quote
What hasn't been mentioned is that the bonuses for cat=9 have been merged into the base bonuses of the assembly line types with Phoebe. So for developers using this data there's only need to code the special casing for blueprint compatibility, not bonuses.
iveeCrest: A PHP library for CREST || iveeCore: The PHP engine for industrial activities
|
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |