|
|
| Line 1: |
Line 1: |
| <noinclude>{{Materials| Image = coal| Codename = coal| BuyPrice = 30| SellPrice = 10| Weight = 1kg| Desc = No information known | | <noinclude>{{FurnaceBlueprint| Codename=blueprint_burn_coal| Desc = No information known |
| }} | | }} |
| </noinclude>{{Items | | </noinclude>{{ItemBlueprints |
| | | Name=Coal |
| | | Codename=blueprint_burn_coal |
| | | ItemType=blueprint_furnace |
| | | Type=FurnaceBlueprint |
| | | WaitTime=undefined |
| | | AutoUnlock=false |
| | | UnlockLevel=undefined |
| | | AllowMultiCraft=false |
| | }} |
| | {{BlueprintItems |
| | | BlueprintCodename=blueprint_burn_coal |
| | | Codename=craft_log |
| | | Qty = 2 |
| | | TakeItem = Yes |
| | }}{{BlueprintRewards |
| | | BlueprintCodename=blueprint_burn_coal |
| | Codename=coal | | | Codename=coal |
| | Type=Materials | | | Qty=1 |
| }}
| |
| | |
| == Information ==
| |
| {| class="cargoTable noMerge sortable jquery-tablesorter"
| |
| ! Attribute !! Value
| |
| |-
| |
| ! Name || Coal
| |
| |-
| |
| ! Weight || 1kg
| |
| |-
| |
| ! Buy Value || $30
| |
| |-
| |
| ! Sell Value || $10
| |
| |}
| |
|
| |
| | |
| == 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 = "coal"
| |
| | format=table
| |
| }} | | }} |
| | ===Information=== |
| | Coal is a crafting recipe that takes '''60 seconds''' to complete. |
|
| |
|
| === Scavenges === | | ==Requires== |
| {{#cargo_query: | | {{#cargo_query: |
| tables=ScavengeJobRewards=R,ScavengeJobs=J | | tables=BlueprintItems=BI,Items=I |
| |join on=R.JobCodename=J.Codename | | |join on=BI.Codename=I.Codename |
| |fields=CONCAT('[[',J._pageName,'|',J.Name,']]')=Job, CONCAT(UPPER(SUBSTRING(J.Location,1,1)), SUBSTRING(J.Location,2))=Location, CONCAT(R.Chance,'%')=Chance, R.Qty | | |fields=CONCAT('https://www.zed.city/items/', I.Codename, '.png')=Image,I._pageName=Resource, BI.Qty |
| |where=R.Codename="coal" AND J.Location="city" | | |where=BI.BlueprintCodename="blueprint_burn_coal" |
| |format=table | | |format=table |
| |headers=show
| |
| |default=There are no ways to scavenge for this item.
| |
| }} | | }} |
|
| |
|
| | | ==Outputs== |
| === Hunts === | |
| {{#cargo_query: | | {{#cargo_query: |
| tables=HuntingJobRewards=R,HuntingJobs=J | | tables=BlueprintRewards=BI,Items=I |
| |join on=R.JobCodename=J.Codename | | |join on=BI.Codename=I.Codename |
| |fields=CONCAT('[[',J._pageName,'|',J.Name,']]')=Job, CONCAT(UPPER(SUBSTRING(J.Location,1,1)), SUBSTRING(J.Location,2))=Location, CONCAT(R.Chance,'%')=Chance, R.Qty | | |fields=CONCAT('https://www.zed.city/items/', I.Codename, '.png')=Image,I._pageName=Resource, BI.Qty |
| |where=R.Codename="coal" | | |where=BI.BlueprintCodename="blueprint_burn_coal" |
| |format=table | | |format=table |
| |headers=show
| |
| |default=There are no guaranteed hunting locations for this item.
| |
| }} | | }} |
| | <!-- ZC_CP_Autogen_End --> |
|
| |
|
| === Zeds ===
| | <!-- ZC_CP_Autogen_End --> |
| | |
| {{#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="coal" AND LootTableLink.LinkType="Zeds";
| |
| |tables=ZedLoot,Zeds;
| |
| join on=ZedLoot.ZedCodename=Zeds.Codename;
| |
| fields=CONCAT('{{FA|crosshairs}}')=_, Zeds._pageName=Zed;
| |
| where=ZedLoot.Codename="coal";
| |
| |format=table
| |
| }}
| |
| | |
| | |
| | |
| === 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='coal' 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="coal"
| |
| }}
| |
| | |
| | |
| === Scavenges ===
| |
| {{#cargo_query:
| |
| tables=ScavengeJobItems=R,ScavengeJobs=J
| |
| |join on=R.JobCodename=J.Codename
| |
| |fields=CONCAT('[[',J._pageName,'|',J.Name,']]')=Job, J.Location, J.Type, R.Qty
| |
| |where=R.Codename="coal"
| |
| |format=table
| |
| |headers=show
| |
| |default=This item is not used in any scavenge.
| |
| }}
| |
| | |
| <!-- ZC_CP_Autogen_End --> | |