8,290
edits
Harvestry: Difference between revisions
Jump to navigation
Jump to search
m
power -> skill
No edit summary |
m (power -> skill) |
||
| (5 intermediate revisions by 2 users not shown) | |||
| Line 10: | Line 10: | ||
Harvestable plants and items can generate in the world either "ripe" or "unripe". Items do not ripen or re-ripen over time. After they are harvested, they cannot be harvested again. | Harvestable plants and items can generate in the world either "ripe" or "unripe". Items do not ripen or re-ripen over time. After they are harvested, they cannot be harvested again. | ||
'''Tip:''' When holding the ALT key to highlight objects on the screen, "ripe" harvestables | '''Tip:''' When holding the ALT key to highlight objects on the screen, "ripe" harvestables appear with a brown color. | ||
== List of Harvestables == | == List of Harvestables == | ||
{{# | {{#cargo_query: | ||
tables=ItemsTable | | tables = GeneralData=GD, ItemsTable=IT, Characters=CH, Food=F1, Food=F2, | ||
GeneralData=HarvestData1, GeneralData=HarvestData2, | |||
|format= | GeneralData=PreserveData1, GeneralData=PreserveData2 | ||
| join on = GD.JoinKey=IT.JoinKey, GD.JoinKey=CH.JoinKey, IT.HarvestedInto=F1.ObjectID, CH.HarvestedInto=F2.ObjectID, | |||
F1.ObjectID=HarvestData1.ObjectID, F2.ObjectID=HarvestData2.ObjectID, | |||
F1.PreservedInto=PreserveData1.ObjectID, F2.PreservedInto=PreserveData2.ObjectID | |||
| fields = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Harvestable, | |||
CONCAT('{{(}}favilink id{{!}}',CASE WHEN IT.HarvestedInto IS NOT NULL THEN IT.HarvestedInto ELSE CH.HarvestedInto END,'{{)}}')=HarvestedInto, | |||
CONCAT('{{(}}qud text{{!}}&B$&C',COALESCE(HarvestData1.Commerce, HarvestData2.Commerce),'{{)}}')=H. Value, | |||
CONCAT('{{(}}qud text{{!}}',COALESCE(HarvestData1.Weight, HarvestData2.Weight),'&K#{{)}}')=H. Weight, | |||
COALESCE(CONCAT('{{(}}favilink id{{!}}',F1.PreservedInto,'{{!}}prefix:',F1.PreservedQuantity,'x{{)}}'), | |||
CONCAT('{{(}}favilink id{{!}}',F2.PreservedInto,'{{!}}prefix:',F2.PreservedQuantity,'x{{)}}'),'-')=PreservedInto, | |||
CONCAT('{{(}}qud text{{!}}&B$&C',COALESCE(PreserveData1.Commerce, PreserveData2.Commerce),'{{)}} <span style="color:#155352;">/ea.</span>')=P. Value, | |||
CONCAT('{{(}}qud text{{!}}',COALESCE(PreserveData1.Weight, PreserveData2.Weight),'&K#{{)}}')=P. Weight | |||
| where = IT.HarvestedInto IS NOT NULL OR CH.HarvestedInto IS NOT NULL | |||
| order by = GD.PlainName | |||
| format = table | |||
}} | }} | ||
{{Factions that teach the skill}} | |||
{{Skills | {{Creatures with the skill}} | ||
{{Skills Navbox}} | |||