Cement: Difference between revisions
From Zed Wiki
No edit summary |
No edit summary |
||
(24 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
< | <noinclude>{{Materials| Image = cement| Codename = cement| BuyPrice = N/A| SellPrice = N/A| Weight = 0.25kg | ||
}} | }} | ||
{{Items | </noinclude><noinclude>{{Items | ||
| Codename=cement | | Codename=cement | ||
| Type=Materials | | Type=Materials | ||
}} | }} | ||
== | </noinclude> | ||
== Information == | |||
{| class="cargoTable noMerge sortable jquery-tablesorter" | |||
! Attribute !! Value | |||
|- | |||
! Name || Cement | |||
|- | |||
! Weight || 0.25kg | |||
|- | |||
! Buy Value || N/A | |||
|- | |||
! Sell Value || N/A | |||
|} | |||
===Scavenges=== | |||
== Status Effects On Use == | |||
{{#cargo_query: | |||
tables=StatusEffectLink,PlayerEffects | |||
| join on=StatusEffectLink.Codename=PlayerEffects.Codename | |||
| fields=PlayerEffects.Name, PlayerEffects.Description, StatusEffectLink.Duration=Duration (seconds) | |||
| where=StatusEffectLink.LinkCodename="cement" | |||
| format=table | |||
| default=No extra effects | |||
}} | |||
== Produced by == | |||
=== Crafting === | |||
{{#cargo_query: | |||
tables=BlueprintRewards,ItemBlueprints,BuildingBlueprintList,Buildings | |||
| join on=ItemBlueprints.Codename = BlueprintRewards.BlueprintCodename, BuildingBlueprintList.Codename = ItemBlueprints.ItemType, BuildingBlueprintList.BuildingCodename = Buildings.Codename | |||
| fields=ItemBlueprints._pageName = Blueprint, Buildings._pageName = Building | |||
| where=BlueprintRewards.Codename = "cement" | |||
| format=table | |||
| default=Not craftable in stronghold | |||
}} | |||
=== Scavenges === | |||
{{#cargo_query: | {{#cargo_query: | ||
tables=ScavengeJobRewards=R,ScavengeJobs=J | tables=ScavengeJobRewards=R,ScavengeJobs=J | ||
|join on=R.JobCodename=J.Codename | |join on=R.JobCodename=J.Codename | ||
|fields=CONCAT('[[',J._pageName,'|',J.Name,']]')=Job, CONCAT(UPPER(SUBSTRING(J.Location,1,1)), SUBSTRING(J.Location,2))=Location, CONCAT(R.Chance,'%')= | |fields=CONCAT('[[',J._pageName,'|',J.Name,']]')=Job, CONCAT(UPPER(SUBSTRING(J.Location,1,1)), SUBSTRING(J.Location,2))=Location, CONCAT(R.Chance,'%')=Drop Rate, R.Qty | ||
|where=R.Codename="cement" | |where=R.Codename="cement" AND J.Location="city" | ||
|format=table | |format=table | ||
|headers=show | |headers=show | ||
Line 19: | Line 58: | ||
}} | }} | ||
===Hunts=== | |||
=== Hunts === | |||
{{#cargo_query: | {{#cargo_query: | ||
tables=HuntingJobRewards=R,HuntingJobs=J | tables=HuntingJobRewards=R,HuntingJobs=J | ||
|join on=R.JobCodename=J.Codename | |join on=R.JobCodename=J.Codename | ||
|fields=CONCAT('[[',J._pageName,'|',J.Name,']]')=Job, CONCAT(UPPER(SUBSTRING(J.Location,1,1)), SUBSTRING(J.Location,2))=Location, CONCAT(R.Chance,'%')= | |fields=CONCAT('[[',J._pageName,'|',J.Name,']]')=Job, CONCAT(UPPER(SUBSTRING(J.Location,1,1)), SUBSTRING(J.Location,2))=Location, CONCAT(R.Chance,'%')=Drop Rate, R.Qty | ||
|where=R.Codename="cement" | |where=R.Codename="cement" | ||
|format=table | |format=table | ||
Line 30: | Line 70: | ||
}} | }} | ||
==Zeds== | === Zeds === | ||
{{#cargo_compound_query: | |||
tables=LootTableItem,LootTableLink,Zeds,LootTable; | |||
join on=LootTableItem.LootTableCodename=LootTable.Codename, | |||
LootTable.Codename=LootTableLink.Codename, | |||
LootTableLink.LinkCodename=Zeds.Codename; | |||
fields=CONCAT('{{FA|crosshairs}}')=_, Zeds._pageName=Zed; | |||
where=LootTableItem.Codename="cement" AND LootTableLink.LinkType="Zeds"; | |||
{{# | |tables=ZedLoot,Zeds; | ||
tables= | join on=ZedLoot.ZedCodename=Zeds.Codename; | ||
fields=CONCAT('{{FA|crosshairs}}')=_, Zeds._pageName=Zed; | |||
where=ZedLoot.Codename="cement"; | |||
|format=table | |||
| | |||
|format= | |||
}} | }} | ||
=== Explore Locations === | |||
{{#cargo_query: | {{#cargo_query: | ||
table=ScavengeJobRewards,ScavengeRooms,Locations | |||
|join on= | | join on=ScavengeRooms.Location=Locations.Codename, | ||
ScavengeJobRewards.JobCodename = ScavengeRooms.Codename | |||
| fields=Locations._pageName=Location | |||
| where=ScavengeJobRewards.Codename='cement' AND Location != "city" | |||
| group by=Locations._pageName | |||
|fields= | | format=table | ||
|where= | |||
| | |||
| | |||
}} | }} | ||
==Consumed by== | == Consumed by == | ||
== Crafting Blueprints == | === Crafting Blueprints === | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=BlueprintItems, ItemBlueprints, BuildingBlueprintList, Buildings | tables=BlueprintItems, ItemBlueprints, BuildingBlueprintList, Buildings | ||
Line 81: | Line 114: | ||
===Scavenges=== | === Scavenges === | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=ScavengeJobItems=R,ScavengeJobs=J | tables=ScavengeJobItems=R,ScavengeJobs=J |
Latest revision as of 23:21, 5 August 2025
Information
Attribute | Value |
---|---|
Name | Cement |
Weight | 0.25kg |
Buy Value | N/A |
Sell Value | N/A |
Status Effects On Use
No extra effects
Produced by
Crafting
Not craftable in stronghold
Scavenges
There are no ways to scavenge for this item.
Hunts
There are no guaranteed hunting locations for this item.
Zeds
_ | Zed |
---|---|
Undead Supervisor | |
Undead Workman |
Explore Locations
Location |
---|
Construction Yard |
Consumed by
Crafting Blueprints
Recipe | Building |
---|---|
Craft Barricade | |
Craft Brick |
Scavenges
This item is not used in any scavenge.