8,290
edits
(Enhance the cargo table) |
m (power -> skill) |
||
(4 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 = GeneralData=GD, ItemsTable=IT, Characters=CH, Food=F1, Food=F2, | |||
|tables=ItemsTable=IT,Food= | GeneralData=HarvestData1, GeneralData=HarvestData2, | ||
join on=IT.HarvestedInto= | GeneralData=PreserveData1, GeneralData=PreserveData2 | ||
| join on = GD.JoinKey=IT.JoinKey, GD.JoinKey=CH.JoinKey, IT.HarvestedInto=F1.ObjectID, CH.HarvestedInto=F2.ObjectID, | |||
fields= | 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}} | |||
{{Creatures with the skill}} | |||
}} | |||
{{Skills | {{Skills Navbox}} |