Coal Mine: Difference between revisions
From Zed Wiki
| Line 62: | Line 62: | ||
tables=ScavengeJobRewards, Items | tables=ScavengeJobRewards, Items | ||
|join on=Items.Codename = ScavengeJobRewards.Codename | |join on=Items.Codename = ScavengeJobRewards.Codename | ||
|fields=Items._pageName=Reward, ScavengeJobRewards.Qty, ScavengeJobRewards.Chance | |fields=CONCAT('https://www.zed.city/items/', Items.Codename, '.png')=Image, Items._pageName=Reward, ScavengeJobRewards.Qty, ScavengeJobRewards.Chance | ||
|where=ScavengeJobRewards.JobCodename="job_scavenge_coal_mine" | |where=ScavengeJobRewards.JobCodename="job_scavenge_coal_mine" | ||
|order by=ScavengeJobRewards.Codename | |order by=ScavengeJobRewards.Codename | ||
|format=table | |format=table | ||
}} | }} | ||
