Butchery: Difference between revisions

Jump to navigation Jump to search
228 bytes added ,  00:34, 4 April 2021
make query more powerful
(make query more powerful)
Line 12: Line 12:


==Corpses that can be butchered==
==Corpses that can be butchered==
Only one of the results will be chosen.
<table class="wikitable">
<tr><th>Corpse</th><th>Items butchered</th></tr>
{{#invoke:CargoQuery|main
{{#invoke:CargoQuery|main
| tables=Corpses=C,CorpseTables=CT,GeneralData=GD
| tables=CorpseTables=CT,GeneralData=GD
| join on=C.ObjectID=CT.MainObjectID,C.ObjectID = GD.ObjectID
| join on=GD.ObjectID=CT.MainObjectID
| fields={{Favilink format args}}
| fields={{Favilink format args}}, CT.Weight=chance, GD.ObjectID
| where=CT.ObjectID IS NOT NULL AND C._pageNamespace = '0'
| where=CT.ObjectID IS NOT NULL AND (CT._pageNamespace = '0' OR CT._pageNamespace = '10002')
| group by = GD.ObjectID
| one_to_many=CONCAT('<li> [[', CT.Object, ']] (', CT.Weight, '%)')=CTObjects
| template = favilink format
| one_to_many_group=GD.ObjectID
| format=ul
| one_to_many_sep=&nbsp;
| columns = 2}}
| template = butchery row
}}
{{Skills and Powers Navbox}}
{{Skills and Powers Navbox}}

Navigation menu