Butchery: Difference between revisions

Jump to navigation Jump to search
1,616 bytes added ,  02:40, 2 October 2021
New Query with more info
(→‎Butchering and Cybernetics: (not) destroyed on removal)
(New Query with more info)
Line 16: Line 16:


==Corpses that can be butchered==
==Corpses that can be butchered==
Only one of the results will be chosen.
Except for the case of cybernetic implants, only one object can be butchered from a corpse. If there are multiple item/food options listed below, the game chooses only one (according to the percentage drop rates shown).
<table class="wikitable">
{{#cargo_query:
<tr><th>Corpse</th><th>Items butchered</th></tr>
  | tables   = GeneralData=GD, Characters=CH, CorpseTables=CT, GeneralData=CorpseData,
{{#invoke:CargoQuery|main
              GeneralData=ButcheredObjInfo, Food=ButcheredFoodInfo, GeneralData=ButcheredPreserveInfo
| tables=CorpseTables=CT,GeneralData=GD
  | join on = GD.JoinKey=CH.JoinKey, CH.Corpse=CT.MainObjectID, CH.Corpse=CorpseData.ObjectID,
| join on=GD.ObjectID=CT.MainObjectID
              CT.ObjectID=ButcheredObjInfo.ObjectID, ButcheredObjInfo.JoinKey=ButcheredFoodInfo.JoinKey, ButcheredFoodInfo.PreservedInto=ButcheredPreserveInfo.ObjectID
| fields={{Favilink format args}}, CT.Weight=chance, GD.ObjectID
  | fields   = CONCAT('{{(}}',CASE WHEN CH.Corpse<>'SlogCorpse' THEN 'non-unique ' ELSE '' END,'creatures with the corpse{{!}}',CH.Corpse,'{{!}}<br>{{)}}')=Creature & Corpse Drop Rate,
| where=CT.ObjectID IS NOT NULL AND (CT._pageNamespace = '0' OR CT._pageNamespace = '10002')
              CONCAT('{{(}}favilink id{{!}}',CH.Corpse,'{{)}}')=Corpse,
| one_to_many=CONCAT('<li> [[', CT.Object, ']] (', CT.Weight, '%)')=CTObjects
              CONCAT('{{(}}non-food butcherable from the corpse{{!}}',CH.Corpse,'{{!}}<br>{{!}}3={{)}}')=Butchered Items,
| one_to_many_group=GD.ObjectID
              CONCAT('{{(}}favilink id{{!}}',ButcheredFoodInfo.ObjectID,'{{)}} <span style="color:#155352;">(',CT.Weight,'%)</span>')=Butchered Food,
| one_to_many_sep=&nbsp;
              CONCAT(CASE WHEN ButcheredFoodInfo.ObjectID IS NULL THEN '' ELSE
| template = butchery row
                      CONCAT('{{(}}qud text{{!}}&B$&C',ButcheredObjInfo.Commerce,'{{)}}') END)=B.F. Value,
              CONCAT(CASE WHEN ButcheredFoodInfo.ObjectID IS NULL THEN '' ELSE
                      CONCAT('{{(}}qud text{{!}}',ButcheredObjInfo.Weight,'&amp;K#{{)}}') END)=B.F. Weight,
              CONCAT('{{(}}favilink id{{!}}',ButcheredPreserveInfo.ObjectID,'{{!}}prefix:',ButcheredFoodInfo.PreservedQuantity,'x{{)}}')=PreservedInto,
              CONCAT('{{(}}qud text{{!}}&B$&C',ButcheredPreserveInfo.Commerce,'{{)}} <span style="color:#155352;">/ea.</span>')=P. Value,
              CONCAT('{{(}}qud text{{!}}',ButcheredPreserveInfo.Weight,'&amp;K#{{)}}')=P. Weight
  | group by = CH.Corpse
  | where    = CH.Corpse IS NOT NULL AND CH.CorpseChance > 0 AND CT.Population IS NOT NULL
  | order by = CorpseData._pageName
  | format  = table
}}
}}
</table>
 
{{References|2.0.201.71}}
{{References|2.0.201.71}}
{{Skills and Powers Navbox}}
{{Skills and Powers Navbox}}

Navigation menu