|
|
| (3 intermediate revisions by the same user not shown) |
| Line 1: |
Line 1: |
| <noinclude>{{RefineryBlueprints| Codename=refine_oil | | <noinclude>{{ScavengeRooms| Name=Refine Oil| Codename=job_oil_refinery| Location=loc_oil_refinery| Zone=1| WaitTime=30| SkillLevel=25| MinSkillLevel=0| JobSkill=scavenging| DisableChance=1| CooldownTimer=0| MultiRoomGroup=N/A| ActionType=scavenge |
| }} | | }} |
| | </noinclude><noinclude>{{ScavengeJobItems |
| | | JobCodename=job_oil_refinery |
| | | ReqType=item_default |
| | | Codename=rad |
| | | Qty=1 |
| | | TakeItem=Yes |
| | }}{{ScavengeJobItems |
| | | JobCodename=job_oil_refinery |
| | | ReqType=item_default |
| | | Codename=oil |
| | | Qty=3 |
| | | TakeItem=Yes |
| | }}{{ScavengeJobRewards |
| | | JobCodename=job_oil_refinery |
| | | ReqType=item |
| | | Codename=fuel |
| | | Chance=100 |
| | | Qty=1 |
| | }}<!-- LTC_C_Autogen_End --> |
| </noinclude> | | </noinclude> |
| === Crafting === | | === Location === |
| Refine Oil is a crafting recipe that takes '''21600 seconds''' to complete.
| |
|
| |
|
| ==Requires==
| |
| {{#cargo_query: | | {{#cargo_query: |
| tables=BlueprintItems=BI,Items=I
| | table=ScavengeRooms,Locations |
| |join on=BI.Codename=I.Codename | | | join on=ScavengeRooms.Location=Locations.Codename |
| |fields=CONCAT('https://www.zed.city/items/', I.Codename, '.png')=Image,I._pageName=Resource, BI.Qty | | | fields=Locations._pageName |
| |where=BI.BlueprintCodename="refine_oil" | | | where=ScavengeRooms.Codename='job_oil_refinery' |
| |format=table | | | format=list |
| | | delimiter=, |
| | | intro=This action is located in |
| | | outro=. |
| }} | | }} |
|
| |
|
| ==Outputs==
| |
| {{#cargo_query:
| |
| tables=BlueprintRewards=BI,Items=I
| |
| |join on=BI.Codename=I.Codename
| |
| |fields=CONCAT('https://www.zed.city/items/', I.Codename, '.png')=Image,I._pageName=Resource, BI.Qty
| |
| |where=BI.BlueprintCodename="refine_oil"
| |
| |format=table
| |
| }}
| |
| <!-- ZC_CP_Autogen_End -->
| |
|
| |
| <noinclude>{{Items
| |
| | Codename=refine_oil
| |
| | Type=RefineryBlueprints
| |
| }}
| |
|
| |
| </noinclude>
| |
| == Information ==
| |
| {| class="cargoTable noMerge sortable jquery-tablesorter"
| |
| ! Attribute !! Value
| |
| |-
| |
| ! Name || Refine Oil
| |
| |-
| |
| ! Weight || 1kg
| |
| |-
| |
| ! Buy Value || N/A
| |
| |-
| |
| ! Sell Value || N/A
| |
| |}
| |
|
| |
|
| | | === Requirements === |
| | |
| | |
| | |
| == Status Effects On Use == | |
| {{#cargo_query:
| |
| tables=StatusEffectLink,PlayerEffects
| |
| | join on=StatusEffectLink.Codename=PlayerEffects.Codename
| |
| | fields=PlayerEffects.Name, PlayerEffects.Description, StatusEffectLink.Duration=Duration (seconds)
| |
| | where=StatusEffectLink.LinkCodename="refine_oil"
| |
| | format=table
| |
| | default=No extra effects
| |
| }}
| |
| | |
| | |
| == Produced by ==
| |
| | |
| === Crafting ===
| |
| {{#cargo_query: | | {{#cargo_query: |
| tables=BlueprintRewards,ItemBlueprints,BuildingBlueprintList,Buildings
| | table=ScavengeJobItems,Items |
| | join on=ItemBlueprints.Codename = BlueprintRewards.BlueprintCodename, BuildingBlueprintList.Codename = ItemBlueprints.ItemType, BuildingBlueprintList.BuildingCodename = Buildings.Codename | | | join on=ScavengeJobItems.Codename=Items.Codename |
| | fields=ItemBlueprints._pageName = Blueprint, Buildings._pageName = Building
| | | fields=CONCAT('https://www.zed.city/items/', ScavengeJobItems.Codename, '.png')=Image, Items._pageName=Item, Qty=Quantity |
| | where=BlueprintRewards.Codename = "refine_oil" | | | where=JobCodename='job_oil_refinery' |
| | format=table | | | format=table |
| | default=Not craftable in stronghold | | | order by=ScavengeJobItems.Codename |
| }} | | }} |
|
| |
|
| === Scavenges === | | === Rewards === |
| {{#cargo_query: | | {{#cargo_query: |
| tables=ScavengeJobRewards=R,ScavengeJobs=J | | tables=LootTableItem,LootTable,Items,LootTableLink |
| |join on=R.JobCodename=J.Codename | | | join on = LootTable.Codename = LootTableItem.LootTableCodename, |
| |fields=CONCAT('[[',J._pageName,'|',J.Name,']]')=Job, CONCAT(UPPER(SUBSTRING(J.Location,1,1)), SUBSTRING(J.Location,2))=Location, CONCAT(R.Chance,'%')=Drop Rate, R.Qty | | LootTableItem.Codename = Items.Codename, |
| |where=R.Codename="refine_oil" AND J.Location="city" | | LootTableLink.Codename = LootTable.Codename |
| | | fields=CONCAT('https://www.zed.city/items/', Items.Codename, '.png')=Image, Items._pageName=Item, LootTable._pageName=Table, CONCAT(LootTableItem.Chance, "%")=Drop Rate |
| | | where=LootTableLink.LinkCodename="job_oil_refinery" |
| |format=table | | |format=table |
| |headers=show
| |
| |default=There are no ways to scavenge for this item.
| |
| }} | | }} |
|
| |
|
| | | === Extra Loot=== |
| === Hunts === | |
| {{#cargo_query: | | {{#cargo_query: |
| tables=HuntingJobRewards=R,HuntingJobs=J
| | table=ScavengeJobRewards,Items |
| |join on=R.JobCodename=J.Codename | | | join on=ScavengeJobRewards.Codename=Items.Codename |
| |fields=CONCAT('[[',J._pageName,'|',J.Name,']]')=Job, CONCAT(UPPER(SUBSTRING(J.Location,1,1)), SUBSTRING(J.Location,2))=Location, CONCAT(R.Chance,'%')=Drop Rate, R.Qty | | | fields=CONCAT('https://www.zed.city/items/', Items.Codename, '.png')=Image, Items._pageName=Item, Qty=Quantity, CONCAT(ScavengeJobRewards.Chance, "%")=Drop Rate |
| |where=R.Codename="refine_oil" | | | where=JobCodename='job_oil_refinery' |
| |format=table
| |
| |headers=show
| |
| |default=There are no guaranteed hunting locations for this item.
| |
| }}
| |
| | |
| === Zeds ===
| |
| | |
| {{#cargo_compound_query:
| |
| tables=LootTableItem,LootTableLink,Zeds,LootTable;
| |
| join on=LootTableItem.LootTableCodename=LootTable.Codename,
| |
| LootTable.Codename=LootTableLink.Codename,
| |
| LootTableLink.LinkCodename=Zeds.Codename;
| |
| fields=CONCAT('{{FA|crosshairs}}')=_, Zeds._pageName=Zed;
| |
| where=LootTableItem.Codename="refine_oil" AND LootTableLink.LinkType="Zeds";
| |
| |tables=ZedLoot,Zeds;
| |
| join on=ZedLoot.ZedCodename=Zeds.Codename;
| |
| fields=CONCAT('{{FA|crosshairs}}')=_, Zeds._pageName=Zed;
| |
| where=ZedLoot.Codename="refine_oil";
| |
| |format=table
| |
| }}
| |
| | |
| | |
| | |
| === Explore Locations ===
| |
| | |
| {{#cargo_query:
| |
| table=ScavengeJobRewards,ScavengeRooms,Locations
| |
| | join on=ScavengeRooms.Location=Locations.Codename,
| |
| ScavengeJobRewards.JobCodename = ScavengeRooms.Codename
| |
| | fields=Locations._pageName=Location
| |
| | where=ScavengeJobRewards.Codename='refine_oil' AND Location != "city"
| |
| | group by=Locations._pageName
| |
| | format=table | | | format=table |
| | | order by=ScavengeJobRewards.Codename |
| }} | | }} |
| | | <!-- ZC_CP_Autogen_End --> |
| | |
| == Consumed by ==
| |
| | |
| === Crafting Blueprints ===
| |
| {{#cargo_query:
| |
| tables=BlueprintItems, ItemBlueprints, BuildingBlueprintList, Buildings
| |
| | join on=BlueprintItems.BlueprintCodename=ItemBlueprints.Codename,
| |
| ItemBlueprints.ItemType=BuildingBlueprintList.Codename,
| |
| BuildingBlueprintList.BuildingCodename=Buildings.Codename
| |
| | fields=ItemBlueprints._pageName=Recipe, IF(Buildings.Name='', 'Stronghold', Buildings._pageName)=Building
| |
| | where=BlueprintItems.Codename="refine_oil"
| |
| }}
| |
| | |
| | |
| === Scavenges ===
| |
| {{#cargo_query:
| |
| tables=ScavengeJobItems=R,ScavengeJobs=J
| |
| |join on=R.JobCodename=J.Codename
| |
| |fields=CONCAT('[[',J._pageName,'|',J.Name,']]')=Job, J.Location, J.Type, R.Qty
| |
| |where=R.Codename="refine_oil"
| |
| |format=table
| |
| |headers=show
| |
| |default=This item is not used in any scavenge.
| |
| }}
| |
| | |
| {{ItemBlueprints
| |
| | Name=Refine Oil
| |
| | Codename=refine_oil
| |
| | ItemType=blueprint_refinery
| |
| | Type=RefineryBlueprints
| |
| | WaitTime=undefined
| |
| | AutoUnlock=false
| |
| | UnlockLevel=undefined
| |
| | AllowMultiCraft=false
| |
| }}
| |
| {{BlueprintItems
| |
| | BlueprintCodename=refine_oil
| |
| | Codename=oil
| |
| | Qty = 60
| |
| | TakeItem = Yes
| |
| }}{{BlueprintRewards
| |
| | BlueprintCodename=refine_oil
| |
| | Codename=fuel_container
| |
| | Qty=1
| |
| }}{{BlueprintRewards
| |
| | BlueprintCodename=refine_oil
| |
| | Codename=scrapnote
| |
| | Qty=36
| |
| }}<!-- ZC_CP_Autogen_End -->
| |