Harvestry: Difference between revisions

Harvestry (view source)

Revision as of 20:51, 1 October 2021

1,460 bytes added , 20:51, 1 October 2021

Enhance the cargo table

Egocarib

Bureaucrats, Interface administrators, Administrators

8,290

edits

@@ Line 14: / Line 14: @@
 == List of Harvestables ==
 {{#cargo_compound_query:
-tables=ItemsTable;fields=_pageName,HarvestedInto;where=HarvestedInto IS NOT NULL
-|tables=Characters;fields=_pageName,HarvestedInto;where=HarvestedInto IS NOT NULL
+|tables=ItemsTable=IT,Food=F,GeneralData=GD1,GeneralData=GD2;
-|format=ul
+  join on=IT.HarvestedInto=F.ObjectID,F.JoinKey=GD1.JoinKey,F.PreservedInto=GD2.ObjectID;
+  fields=
+    CONCAT('{{(}}favilink id{{!}}',IT.ObjectID,'{{)}}')=Harvestable,
+    CONCAT('{{(}}favilink id{{!}}',IT.HarvestedInto,'{{)}} <span class="cargoFieldName">(Value: {{(}}qud text{{!}}&B$&C',GD1.Commerce,'{{)}} - Weight: {{(}}qud text{{!}}',GD1.Weight,'&amp;K#{{)}})</span>')=HarvestedInto,
+    CONCAT(CASE WHEN F.PreservedInto IS NULL THEN '-' ELSE CONCAT('{{(}}favilink id{{!}}',F.PreservedInto,'{{!}}prefix:',F.PreservedQuantity,'x{{)}} <span class="cargoFieldName">(Value: {{(}}qud text{{!}}&B$&C',GD2.Commerce,'{{)}} - Weight: {{(}}qud text{{!}}',GD2.Weight,'&amp;K#{{)}})</span>') END)=PreservedInto;
+    where=IT.HarvestedInto IS NOT NULL
+|tables=Characters=IT,Food=F,GeneralData=GD1,GeneralData=GD2;
+  join on=IT.HarvestedInto=F.ObjectID,F.JoinKey=GD1.JoinKey,F.PreservedInto=GD2.ObjectID;
+  fields=
+    CONCAT('{{(}}favilink id{{!}}',IT.ObjectID,'{{)}}')=Harvestable,
+    CONCAT('{{(}}favilink id{{!}}',IT.HarvestedInto,'{{)}} <span class="cargoFieldName">(Value: {{(}}qud text{{!}}&B$&C',GD1.Commerce,'{{)}} - Weight: {{(}}qud text{{!}}',GD1.Weight,'&amp;K#{{)}})</span>')=HarvestedInto,
+    CONCAT(CASE WHEN F.PreservedInto IS NULL THEN '-' ELSE CONCAT('{{(}}favilink id{{!}}',F.PreservedInto,'{{!}}prefix:',F.PreservedQuantity,'x{{)}} <span class="cargoFieldName">(Value: {{(}}qud text{{!}}&B$&C',GD2.Commerce,'{{)}} - Weight: {{(}}qud text{{!}}',GD2.Weight,'&amp;K#{{)}})</span>') END)=PreservedInto;
+    where=IT.HarvestedInto IS NOT NULL
+|format=table
 }}
 {{Skills and Powers Navbox}}