|
|
| (20 intermediate revisions by one other user not shown) |
| Line 1: |
Line 1: |
| <noinclude>{{Materials| Image = wire| Codename = craft_wire| BuyPrice = n/a| SellPrice = n/a| Weight = 0.25kg| Desc = No information known
| | {{#zed_entity:craft_wire}} |
| }}
| |
| </noinclude>{{Items
| |
| | Codename=craft_wire
| |
| | Type=Materials
| |
| }}
| |
| | |
| == Produced by ==
| |
| | |
| === Scavenges ===
| |
| {{#cargo_query:
| |
| tables=ScavengeJobRewards=R,ScavengeJobs=J
| |
| |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,'%')=Chance, R.Qty
| |
| |where=R.Codename="craft_wire" 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._pageName,'|',J.Name,']]')=Job, CONCAT(UPPER(SUBSTRING(J.Location,1,1)), SUBSTRING(J.Location,2))=Location, CONCAT(R.Chance,'%')=Chance, R.Qty
| |
| |where=R.Codename="craft_wire"
| |
| |format=table
| |
| |headers=show
| |
| |default=There are no guaranteed hunting locations for this item.
| |
| }}
| |
| | |
| == Zeds ==
| |
| <table class="cargoTable noMerge sortable jquery-tablesorter">
| |
| <tr>
| |
| <th>Zed</th>
| |
| <th>Area</th>
| |
| <th>Level</th>
| |
| <th>Qty</th>
| |
| <th>Chance</th>
| |
| </tr>
| |
| {{#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="craft_wire"
| |
| |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="craft_wire"
| |
| |format=template
| |
| |template=ZedLootRow
| |
| |named args=yes
| |
| |default=
| |
| }}
| |
| </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='craft_wire' 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="craft_wire"
| |
| }}
| |
| | |
| | |
| === 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="craft_wire"
| |
| |format=table
| |
| |headers=show
| |
| |default=This item is not used in any scavenge.
| |
| }} | |
| | |
| <!-- ZC_CP_Autogen_End -->
| |
