Coal Mine: Difference between revisions
From Zed City Wiki
No edit summary |
No edit summary |
||
| Line 62: | Line 62: | ||
tables=ScavengeJobRewards, Items | tables=ScavengeJobRewards, Items | ||
|join on=Items.Codename = ScavengeJobRewards.Codename | |join on=Items.Codename = ScavengeJobRewards.Codename | ||
|fields=CONCAT('https://www.zed.city/items/', Items.Codename, '.png')=Image, Items._pageName=Reward, ScavengeJobRewards.Qty, ScavengeJobRewards.Chance | |fields=CONCAT('https://www.zed.city/items/', Items.Codename, '.png')=Image, Items._pageName=Reward, ScavengeJobRewards.Qty, CONCAT(ScavengeJobRewards.Chance, "%")=Chance | ||
|where=ScavengeJobRewards.JobCodename="job_scavenge_coal_mine" | |where=ScavengeJobRewards.JobCodename="job_scavenge_coal_mine" | ||
|order by=ScavengeJobRewards.Codename | |order by=ScavengeJobRewards.Codename | ||
Revision as of 08:09, 11 July 2025
Requirements
{{#cargo_query: tables=ScavengeJobItems, Items |fields=CONCAT('https://www.zed.city/items/', Items.Codename, '.png')=Image, Items._pageName=Item, ScavengeJobItems.Qty, ScavengeJobItems.TakeItem |join on=ScavengeJobItems.Codename = Items.Codename |where=ScavengeJobItems.JobCodename="job_scavenge_coal_mine" |order by=ScavengeJobItems.Qty |format=table }}
Rewards
{{#cargo_query: tables=ScavengeJobRewards, Items |join on=Items.Codename = ScavengeJobRewards.Codename |fields=CONCAT('https://www.zed.city/items/', Items.Codename, '.png')=Image, Items._pageName=Reward, ScavengeJobRewards.Qty, CONCAT(ScavengeJobRewards.Chance, "%")=Chance |where=ScavengeJobRewards.JobCodename="job_scavenge_coal_mine" |order by=ScavengeJobRewards.Codename |format=table }}