Harvestry: Difference between revisions

Jump to navigation Jump to search

Harvestry (view source)

Revision as of 15:17, 2 July 2022

48 bytes added ,  15:17, 2 July 2022
m
power -> skill
(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 that can be harvested from appear with a brown color.
'''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_compound_query:
{{#cargo_query:
 
  | tables   = GeneralData=GD, ItemsTable=IT, Characters=CH, Food=F1, Food=F2,
|tables=ItemsTable=IT,Food=F,GeneralData=GD1,GeneralData=GD2;
              GeneralData=HarvestData1, GeneralData=HarvestData2,
   join on=IT.HarvestedInto=F.ObjectID,F.JoinKey=GD1.JoinKey,F.PreservedInto=GD2.ObjectID;
              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,
    CONCAT('{{(}}favilink id{{!}}',IT.ObjectID,'{{)}}')=Harvestable,
              F1.PreservedInto=PreserveData1.ObjectID, F2.PreservedInto=PreserveData2.ObjectID
    CONCAT('{{(}}favilink id{{!}}',IT.HarvestedInto,'{{)}} <span class="cargoFieldName">(Value: {{(}}qud text{{!}}&B$&C',GD1.Commerce,'{{)}} - Weight: {{(}}qud text{{!}}',GD1.Weight,'&amp;K#{{)}})</span>')=HarvestedInto,
   | fields   = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Harvestable,
    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;
              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),'&amp;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),'&amp;K#{{)}}')=P. Weight
  | where    = IT.HarvestedInto IS NOT NULL OR CH.HarvestedInto IS NOT NULL
  | order by = GD.PlainName
  | format  = table
}}


    where=IT.HarvestedInto IS NOT NULL
{{Factions that teach the skill}}


|tables=Characters=IT,Food=F,GeneralData=GD1,GeneralData=GD2;
{{Creatures with the skill}}
  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}}
{{Skills Navbox}}
Retrieved from "https://wiki.cavesofqud.com/wiki/Special:MobileDiff/54256...79605"

Navigation menu