Brick: Difference between revisions
No edit summary |
No edit summary |
||
| Line 31: | Line 31: | ||
}} | }} | ||
== Zeds == | === Zeds Standard Loot === | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=ZedLoot,Zeds | tables=ZedLoot,Zeds | ||
|join on=ZedLoot.ZedCodename=Zeds | |join on=ZedLoot.ZedCodename=Zeds.Codename | ||
|fields=Zeds._pageName=Zed | |||
|where=ZedLoot.Codename="craft_log" | |||
|fields=Zeds._pageName=Zed | |format=table | ||
|where=ZedLoot.Codename=" | |||
|format= | |||
|default= | |default= | ||
}} | }} | ||
=== Zeds Loot Tables === | |||
{{#cargo_query: | {{#cargo_query: | ||
tables= | tables=LootTableItem,LootTableLink,Zeds,LootTable | ||
|join on=LootTableItem.LootTableCodename=LootTable.Codename, | |join on=LootTableItem.LootTableCodename=LootTable.Codename, | ||
LootTable.Codename=LootTableLink.Codename, | LootTable.Codename=LootTableLink.Codename, | ||
LootTableLink.LinkCodename=Zeds | LootTableLink.LinkCodename=Zeds.Codename | ||
|fields=Zeds._pageName=Zed | |||
|where=LootTableItem.Codename="craft_log" AND LootTableLink.LinkType="Zeds" | |||
|fields=Zeds._pageName=Zed | |format=table | ||
|where=LootTableItem.Codename=" | |||
|format= | |||
|default= | |default= | ||
}} | }} | ||
=== Explore Locations === | === Explore Locations === | ||
Revision as of 15:32, 10 July 2025
Produced by
Scavenges
{{#cargo_query: tables=ScavengeJobRewards=R,ScavengeJobs=J |join on=R.JobCodename=J.Codename |fields=CONCAT('',J.Name,'')=Job, CONCAT(UPPER(SUBSTRING(J.Location,1,1)), SUBSTRING(J.Location,2))=Location, CONCAT(R.Chance,'%')=Chance, R.Qty |where=R.Codename="brick" AND J.Location="city" |format=table |headers=show |default=There are no ways to scavenge for this item. }}
Hunts
{{#cargo_query: tables=HuntingJobRewards=R,HuntingJobs=J |join on=R.JobCodename=J.Codename |fields=CONCAT('',J.Name,'')=Job, CONCAT(UPPER(SUBSTRING(J.Location,1,1)), SUBSTRING(J.Location,2))=Location, CONCAT(R.Chance,'%')=Chance, R.Qty |where=R.Codename="brick" |format=table |headers=show |default=There are no guaranteed hunting locations for this item. }}
Zeds Standard Loot
{{#cargo_query: tables=ZedLoot,Zeds |join on=ZedLoot.ZedCodename=Zeds.Codename |fields=Zeds._pageName=Zed |where=ZedLoot.Codename="craft_log" |format=table |default= }}
Zeds Loot Tables
{{#cargo_query: tables=LootTableItem,LootTableLink,Zeds,LootTable |join on=LootTableItem.LootTableCodename=LootTable.Codename, LootTable.Codename=LootTableLink.Codename, LootTableLink.LinkCodename=Zeds.Codename |fields=Zeds._pageName=Zed |where=LootTableItem.Codename="craft_log" AND LootTableLink.LinkType="Zeds" |format=table |default= }}
Explore Locations
{{#cargo_query: table=ScavengeJobRewards,ScavengeRooms,Locations | join on=ScavengeRooms.Location=Locations.Codename, ScavengeJobRewards.JobCodename = ScavengeRooms.Codename | fields=Locations._pageName=Location | where=ScavengeJobRewards.Codename='brick' AND Location != "city" | format=table }}
Consumed by
Crafting Blueprints
{{#cargo_query: tables=BlueprintItems, ItemBlueprints, BuildingBlueprintList, Buildings | join on=BlueprintItems.BlueprintCodename=ItemBlueprints.Codename,
ItemBlueprints.ItemType=BuildingBlueprintList.Codename,
BuildingBlueprintList.BuildingCodename=Buildings.Codename
| fields=ItemBlueprints._pageName=Recipe, IF(Buildings.Name=, 'Stronghold', Buildings._pageName)=Building | where=BlueprintItems.Codename="brick" }}
Scavenges
{{#cargo_query: tables=ScavengeJobItems=R,ScavengeJobs=J |join on=R.JobCodename=J.Codename |fields=CONCAT('',J.Name,'')=Job, J.Location, J.Type, R.Qty |where=R.Codename="brick" |format=table |headers=show |default=This item is not used in any scavenge. }}