Gun Powder: Difference between revisions
No edit summary |
No edit summary |
||
| Line 13: | Line 13: | ||
|join on=R.JobCodename=J.Codename | |join on=R.JobCodename=J.Codename | ||
|fields=CONCAT('[[',J._pageName,'|',J.Name,']]')=Job, CONCAT(UPPER(SUBSTRING(J.Location,1,1)), SUBSTRING(J.Location,2))=Location, CONCAT(R.Chance,'%')=Chance, R.Qty | |fields=CONCAT('[[',J._pageName,'|',J.Name,']]')=Job, CONCAT(UPPER(SUBSTRING(J.Location,1,1)), SUBSTRING(J.Location,2))=Location, CONCAT(R.Chance,'%')=Chance, R.Qty | ||
|where=R.Codename="gun_powder" | |where=R.Codename="gun_powder",J.Location="city" | ||
|format=table | |format=table | ||
|headers=show | |headers=show | ||
Revision as of 14:59, 10 July 2025
Produced by
Scavenges
Function: CargoSQLQuery::run Query: SELECT `J`.`_pageID` AS `cargo_backlink_page_id_J`,`R`.`_pageID` AS `cargo_backlink_page_id_R`,CONCAT('',`J`.`Name`,'') AS `Job`,CONCAT(UPPER(SUBSTRING(`J`.`Location`,1,1)), SUBSTRING(`J`.`Location`,2)) AS `Location`,CONCAT(`R`.`Chance`,'%') AS `Chance`,`R`.`Qty` AS `Qty` FROM `cargo__ScavengeJobRewards` `R` LEFT OUTER JOIN `cargo__ScavengeJobs` `J` ON ((`R`.`JobCodename`=`J`.`Codename`)) WHERE `R`.`Codename`="gun_powder",`J`.`Location`="city" ORDER BY `J`.`_pageID`,`R`.`_pageID`,CONCAT('',`J`.`Name`,''),CONCAT(UPPER(SUBSTRING(`J`.`Location`,1,1)), SUBSTRING(`J`.`Location`,2)),CONCAT(`R`.`Chance`,'%') LIMIT 5000
Hunts
There are no guaranteed hunting locations for this item.
Zeds
| Zed | Area | Level | Qty | Chance |
|---|
Explore Location
| Location |
|---|
| Demolition Site |
Consumed by
Crafting Blueprints
| Recipe | Building |
|---|---|
| Craft Explosives | |
| Pistol Ammo Blueprint | Ammo Bench |
| Rifle Ammo Blueprint | Ammo Bench |
| Shotgun Slug Blueprint | Ammo Bench |
| Simple Ammo Blueprint | Ammo Bench |
Scavenges
This item is not used in any scavenge.