8,290
edits
(→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== | ||
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). | |||
{{#cargo_query: | |||
| tables = GeneralData=GD, Characters=CH, CorpseTables=CT, GeneralData=CorpseData, | |||
{{# | GeneralData=ButcheredObjInfo, Food=ButcheredFoodInfo, GeneralData=ButcheredPreserveInfo | ||
| tables=CorpseTables=CT,GeneralData= | | join on = GD.JoinKey=CH.JoinKey, CH.Corpse=CT.MainObjectID, CH.Corpse=CorpseData.ObjectID, | ||
| join on=GD. | CT.ObjectID=ButcheredObjInfo.ObjectID, ButcheredObjInfo.JoinKey=ButcheredFoodInfo.JoinKey, ButcheredFoodInfo.PreservedInto=ButcheredPreserveInfo.ObjectID | ||
| fields={{ | | fields = CONCAT('{{(}}',CASE WHEN CH.Corpse<>'SlogCorpse' THEN 'non-unique ' ELSE '' END,'creatures with the corpse{{!}}',CH.Corpse,'{{!}}<br>{{)}}')=Creature & Corpse Drop Rate, | ||
CONCAT('{{(}}favilink id{{!}}',CH.Corpse,'{{)}}')=Corpse, | |||
CONCAT('{{(}}non-food butcherable from the corpse{{!}}',CH.Corpse,'{{!}}<br>{{!}}3={{)}}')=Butchered Items, | |||
| | CONCAT('{{(}}favilink id{{!}}',ButcheredFoodInfo.ObjectID,'{{)}} <span style="color:#155352;">(',CT.Weight,'%)</span>')=Butchered Food, | ||
| | CONCAT(CASE WHEN ButcheredFoodInfo.ObjectID IS NULL THEN '' ELSE | ||
| | 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,'&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,'&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 | |||
}} | }} | ||
{{References|2.0.201.71}} | {{References|2.0.201.71}} | ||
{{Skills and Powers Navbox}} | {{Skills and Powers Navbox}} |