Brick: Difference between revisions
No edit summary |
No edit summary |
||
| Line 6: | Line 6: | ||
}} | }} | ||
==Produced by== | == Produced by == | ||
===Scavenges=== | === Scavenges === | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=ScavengeJobRewards=R,ScavengeJobs=J | tables=ScavengeJobRewards=R,ScavengeJobs=J | ||
| Line 19: | Line 19: | ||
}} | }} | ||
===Hunts=== | === Hunts === | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=HuntingJobRewards=R,HuntingJobs=J | tables=HuntingJobRewards=R,HuntingJobs=J | ||
| Line 30: | Line 30: | ||
}} | }} | ||
==Zeds== | == Zeds == | ||
<table class="cargoTable noMerge sortable jquery-tablesorter"> | <table class="cargoTable noMerge sortable jquery-tablesorter"> | ||
<tr> | <tr> | ||
| Line 68: | Line 68: | ||
== | === Explore Location=== | ||
== Crafting Blueprints == | {{#cargo_query: | ||
table=ScavengeJobRewards,ScavengeRooms,Locations | |||
| join on=ScavengeRooms.Location=Locations.Codename, | |||
ScavengeJobRewards.JobCodename = ScavengeRooms.Codename | |||
| fields=Locations._pageName=Location | |||
| where=ScavengeJobRewards.Codename='gun_powder' | |||
| format=table | |||
}} | |||
== Consumed by == | |||
=== Crafting Blueprints === | |||
{{#cargo_query: | {{#cargo_query: | ||
tables=BlueprintItems, ItemBlueprints, BuildingBlueprintList, Buildings | tables=BlueprintItems, ItemBlueprints, BuildingBlueprintList, Buildings | ||
| Line 81: | Line 93: | ||
===Scavenges=== | === Scavenges === | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=ScavengeJobItems=R,ScavengeJobs=J | tables=ScavengeJobItems=R,ScavengeJobs=J | ||
Revision as of 14:55, 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" |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
{{#cargo_query: tables=ZedLoot,Zeds,HuntingJobNpcs,HuntingJobs |join on=ZedLoot.ZedCodename=Zeds.Codename, Zeds.Codename=HuntingJobNpcs.Codename, HuntingJobNpcs.JobCodename=HuntingJobs.Codename |fields=Zeds._pageName=Zed, HuntingJobs._pageName=Area, ZedLoot.Level, ZedLoot.Qty, Concat(ZedLoot.Chance,"%")=Chance |where=ZedLoot.Codename="brick" |format=template |template=ZedLootRow |named args=yes |default= }} {{#cargo_query: tables=LootTable,LootTableItem,LootTableLink,Zeds,HuntingJobNpcs,HuntingJobs |join on=LootTableItem.LootTableCodename=LootTable.Codename, LootTable.Codename=LootTableLink.Codename, LootTableLink.LinkCodename=Zeds.Codename, Zeds.Codename=HuntingJobNpcs.Codename, HuntingJobNpcs.JobCodename=HuntingJobs.Codename |fields=Zeds._pageName=Zed, HuntingJobs._pageName=Area, LootTableLink.Level, LootTableItem.Qty, Concat(LootTableLink.Chance,"%")=Chance |where=LootTableItem.Codename="brick" |format=template |template=ZedLootRow |named args=yes |default= }}| Zed | Area | Level | Qty | Chance |
|---|
Explore Location
{{#cargo_query: table=ScavengeJobRewards,ScavengeRooms,Locations | join on=ScavengeRooms.Location=Locations.Codename, ScavengeJobRewards.JobCodename = ScavengeRooms.Codename | fields=Locations._pageName=Location | where=ScavengeJobRewards.Codename='gun_powder' | 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. }}