8,290
edits
(Enhance the cargo table) |
(cleaner query) |
||
Line 13: | Line 13: | ||
== 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 | |||
|format=table | |||
}} | }} | ||
{{Skills and Powers Navbox}} | {{Skills and Powers Navbox}} |