Butchery: Difference between revisions

No change in size ,  15:06, 3 October 2021
m
no edit summary
(New Query with more info)
mNo edit summary
Line 25: Line 25:
               CONCAT('{{(}}favilink id{{!}}',CH.Corpse,'{{)}}')=Corpse,
               CONCAT('{{(}}favilink id{{!}}',CH.Corpse,'{{)}}')=Corpse,
               CONCAT('{{(}}non-food butcherable from the corpse{{!}}',CH.Corpse,'{{!}}<br>{{!}}3={{)}}')=Butchered Items,
               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('{{(}}favilink id{{!}}',ButcheredFoodInfo.ObjectID,'{{)}} <span style="color:#155352;">(',CT.Chance,'%)</span>')=Butchered Food,
               CONCAT(CASE WHEN ButcheredFoodInfo.ObjectID IS NULL THEN '' ELSE  
               CONCAT(CASE WHEN ButcheredFoodInfo.ObjectID IS NULL THEN '' ELSE  
                       CONCAT('{{(}}qud text{{!}}&B$&C',ButcheredObjInfo.Commerce,'{{)}}') END)=B.F. Value,
                       CONCAT('{{(}}qud text{{!}}&B$&C',ButcheredObjInfo.Commerce,'{{)}}') END)=B.F. Value,