Skip to content

Wire: Difference between revisions

From Zed City Wiki

No edit summary
No edit summary
Line 31: Line 31:
}}
}}


== Zeds ==
=== Zeds Standard Loot ===
<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:
{{#cargo_query:
tables=ZedLoot,Zeds,HuntingJobNpcs,HuntingJobs
tables=ZedLoot,Zeds
|join on=ZedLoot.ZedCodename=Zeds.Codename,
|join on=ZedLoot.ZedCodename=Zeds.Codename
Zeds.Codename=HuntingJobNpcs.Codename,
|fields=Zeds._pageName=Zed
HuntingJobNpcs.JobCodename=HuntingJobs.Codename
|where=ZedLoot.Codename="craft_log"
|fields=Zeds._pageName=Zed, HuntingJobs._pageName=Area, ZedLoot.Level, ZedLoot.Qty, Concat(ZedLoot.Chance,"%")=Chance
|format=table
|where=ZedLoot.Codename="craft_wire"
|format=template
|template=ZedLootRow
|named args=yes
|default=
|default=
}}
}}
=== Zeds Loot Tables ===
{{#cargo_query:
{{#cargo_query:
tables=LootTable,LootTableItem,LootTableLink,Zeds,HuntingJobNpcs,HuntingJobs
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.Codename,
LootTableLink.LinkCodename=Zeds.Codename
Zeds.Codename=HuntingJobNpcs.Codename,
|fields=Zeds._pageName=Zed
HuntingJobNpcs.JobCodename=HuntingJobs.Codename
|where=LootTableItem.Codename="craft_log" AND LootTableLink.LinkType="Zeds"
|fields=Zeds._pageName=Zed, HuntingJobs._pageName=Area, LootTableLink.Level, LootTableItem.Qty, Concat(LootTableLink.Chance,"%")=Chance
|format=table
|where=LootTableItem.Codename="craft_wire"
|format=template
|template=ZedLootRow
|named args=yes
|default=
|default=
}}
}}
</table>


=== 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="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.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 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='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.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. }}