Skip to content

Fish Kebab: Difference between revisions

From Zed City Wiki

No edit summary
No edit summary
Line 33: Line 33:
tables=StatusEffectLink,PlayerEffects
tables=StatusEffectLink,PlayerEffects
| join on=StatusEffectLink.Codename=PlayerEffects.Codename
| join on=StatusEffectLink.Codename=PlayerEffects.Codename
| fields=PlayerEffects.Name, PlayerEffects.Description, StatusEffectLink.Duration=Duration (s)
| fields=PlayerEffects.Name, PlayerEffects.Description, StatusEffectLink.Duration=Duration (seconds)
| where=StatusEffectLink.LinkCodename="fish_kebab"
| where=StatusEffectLink.LinkCodename="fish_kebab"
| format=table
| format=table

Revision as of 11:12, 14 July 2025



Information

Attribute Value
Name Fish Kebab
Weight 1kg
Buy Value $250
Sell Value $40


Immediate Effects

Attribute Value
Morale 100


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="fish_kebab" | 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 = "fish_kebab" | format=table | default=Not craftable in stronghold }}

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="fish_kebab" 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="fish_kebab" |format=table |headers=show |default=There are no guaranteed hunting locations for this item. }}

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(' ')=_, Zeds._pageName=Zed; where=LootTableItem.Codename="fish_kebab" AND LootTableLink.LinkType="Zeds"; |tables=ZedLoot,Zeds; join on=ZedLoot.ZedCodename=Zeds.Codename; fields=CONCAT(' ')=_, Zeds._pageName=Zed; where=ZedLoot.Codename="fish_kebab"; |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='fish_kebab' 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="fish_kebab" }}


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="fish_kebab" |format=table |headers=show |default=This item is not used in any scavenge. }}