Coal Mine: Difference between revisions
No edit summary |
No edit summary |
||
| Line 53: | Line 53: | ||
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, CONCAT(ScavengeJobRewards.Chance, "%")= | |fields=CONCAT('https://www.zed.city/items/', Items.Codename, '.png')=Image, Items._pageName=Reward, ScavengeJobRewards.Qty, CONCAT(ScavengeJobRewards.Chance, "%")=Drop Rate | ||
|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 12:59, 22 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=Consumed |join on=ScavengeJobItems.Codename = Items.Codename |where=ScavengeJobItems.JobCodename="job_scavenge_coal_mine" |order by=ScavengeJobItems.Qty |format=table }}
Rewards
Note: Rewards at 100% can still mean you don't get loot at the start due to your skill efficiency being below that of this particular action. Repeating actions in the same skill (e.g. mining) increase your efficiency for that skill. {{#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, "%")=Drop Rate |where=ScavengeJobRewards.JobCodename="job_scavenge_coal_mine" |order by=ScavengeJobRewards.Codename |format=table }}