Forest: Difference between revisions
From Zed Wiki
No edit summary |
No edit summary |
||
| Line 39: | Line 39: | ||
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_forest" | |where=ScavengeJobRewards.JobCodename="job_scavenge_forest" | ||
|order by=ScavengeJobRewards.Codename | |order by=ScavengeJobRewards.Codename | ||
