Smelt Iron Ore - Revision history

127.0.0.1 at 14:39, 11 October 2025

2025-10-11T14:39:14Z

← Older revision		Revision as of 14:39, 11 October 2025
Line 1:		Line 1:
	<noinclude>{{~~FurnaceBlueprint~~\| Codename=~~blueprint_smelt_iron_ore~~		<noinclude>{{MiscBlueprints\| Codename=blueprint_smelt_iron_ore_outpost
	}}		}}
	</noinclude>		</noinclude>
Line 10:		Line 10:
	\|join on=BI.Codename=I.Codename		\|join on=BI.Codename=I.Codename
	\|fields=CONCAT('https://www.zed.city/items/', I.Codename, '.png')=Image,I._pageName=Resource, BI.Qty		\|fields=CONCAT('https://www.zed.city/items/', I.Codename, '.png')=Image,I._pageName=Resource, BI.Qty
	\|where=BI.BlueprintCodename="~~blueprint_smelt_iron_ore~~"		\|where=BI.BlueprintCodename="blueprint_smelt_iron_ore_outpost"
	\|format=table		\|format=table
	}}		}}
Line 19:		Line 19:
	\|join on=BI.Codename=I.Codename		\|join on=BI.Codename=I.Codename
	\|fields=CONCAT('https://www.zed.city/items/', I.Codename, '.png')=Image,I._pageName=Resource, BI.Qty		\|fields=CONCAT('https://www.zed.city/items/', I.Codename, '.png')=Image,I._pageName=Resource, BI.Qty
	\|where=BI.BlueprintCodename="~~blueprint_smelt_iron_ore~~"		\|where=BI.BlueprintCodename="blueprint_smelt_iron_ore_outpost"
	\|format=table		\|format=table
	}}		}}
Line 25:		Line 25:

	<noinclude>{{Items		<noinclude>{{Items
	\| Codename=~~blueprint_smelt_iron_ore~~		\| Codename=blueprint_smelt_iron_ore_outpost
	\| Type=~~FurnaceBlueprint~~		\| Type=MiscBlueprints
	}}		}}

Line 52:		Line 52:
	\| join on=StatusEffectLink.Codename=PlayerEffects.Codename		\| join on=StatusEffectLink.Codename=PlayerEffects.Codename
	\| fields=PlayerEffects.Name, PlayerEffects.Description, StatusEffectLink.Duration=Duration (seconds)		\| fields=PlayerEffects.Name, PlayerEffects.Description, StatusEffectLink.Duration=Duration (seconds)
	\| where=StatusEffectLink.LinkCodename="~~blueprint_smelt_iron_ore~~"		\| where=StatusEffectLink.LinkCodename="blueprint_smelt_iron_ore_outpost"
	\| format=table		\| format=table
	\| default=No extra effects		\| default=No extra effects
Line 65:		Line 65:
	\| join on=ItemBlueprints.Codename = BlueprintRewards.BlueprintCodename, BuildingBlueprintList.Codename = ItemBlueprints.ItemType, BuildingBlueprintList.BuildingCodename = Buildings.Codename		\| join on=ItemBlueprints.Codename = BlueprintRewards.BlueprintCodename, BuildingBlueprintList.Codename = ItemBlueprints.ItemType, BuildingBlueprintList.BuildingCodename = Buildings.Codename
	\| fields=ItemBlueprints._pageName = Blueprint, Buildings._pageName = Building		\| fields=ItemBlueprints._pageName = Blueprint, Buildings._pageName = Building
	\| where=BlueprintRewards.Codename = "~~blueprint_smelt_iron_ore~~"		\| where=BlueprintRewards.Codename = "blueprint_smelt_iron_ore_outpost"
	\| format=table		\| format=table
	\| default=Not craftable in stronghold		\| default=Not craftable in stronghold
Line 75:		Line 75:
	\|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,'%')=Drop Rate, R.Qty		\|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
	\|where=R.Codename="~~blueprint_smelt_iron_ore~~" AND J.Location="city"		\|where=R.Codename="blueprint_smelt_iron_ore_outpost" AND J.Location="city"
	\|format=table		\|format=table
	\|headers=show		\|headers=show
Line 87:		Line 87:
	\|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,'%')=Drop Rate, R.Qty		\|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
	\|where=R.Codename="~~blueprint_smelt_iron_ore~~"		\|where=R.Codename="blueprint_smelt_iron_ore_outpost"
	\|format=table		\|format=table
	\|headers=show		\|headers=show
Line 101:		Line 101:
	LootTableLink.LinkCodename=Zeds.Codename;		LootTableLink.LinkCodename=Zeds.Codename;
	fields=CONCAT('{{FA\|crosshairs}}')=_, Zeds._pageName=Zed;		fields=CONCAT('{{FA\|crosshairs}}')=_, Zeds._pageName=Zed;
	where=LootTableItem.Codename="~~blueprint_smelt_iron_ore~~" AND LootTableLink.LinkType="Zeds";		where=LootTableItem.Codename="blueprint_smelt_iron_ore_outpost" AND LootTableLink.LinkType="Zeds";
	\|tables=ZedLoot,Zeds;		\|tables=ZedLoot,Zeds;
	join on=ZedLoot.ZedCodename=Zeds.Codename;		join on=ZedLoot.ZedCodename=Zeds.Codename;
	fields=CONCAT('{{FA\|crosshairs}}')=_, Zeds._pageName=Zed;		fields=CONCAT('{{FA\|crosshairs}}')=_, Zeds._pageName=Zed;
	where=ZedLoot.Codename="~~blueprint_smelt_iron_ore~~";		where=ZedLoot.Codename="blueprint_smelt_iron_ore_outpost";
	\|format=table		\|format=table
	}}		}}
Line 118:		Line 118:
	ScavengeJobRewards.JobCodename = ScavengeRooms.Codename		ScavengeJobRewards.JobCodename = ScavengeRooms.Codename
	\| fields=Locations._pageName=Location		\| fields=Locations._pageName=Location
	\| where=ScavengeJobRewards.Codename='~~blueprint_smelt_iron_ore~~' AND Location != "city"		\| where=ScavengeJobRewards.Codename='blueprint_smelt_iron_ore_outpost' AND Location != "city"
	\| group by=Locations._pageName		\| group by=Locations._pageName
	\| format=table		\| format=table
Line 133:		Line 133:
	BuildingBlueprintList.BuildingCodename=Buildings.Codename		BuildingBlueprintList.BuildingCodename=Buildings.Codename
	\| fields=ItemBlueprints._pageName=Recipe, IF(Buildings.Name='', 'Stronghold', Buildings._pageName)=Building		\| fields=ItemBlueprints._pageName=Recipe, IF(Buildings.Name='', 'Stronghold', Buildings._pageName)=Building
	\| where=BlueprintItems.Codename="~~blueprint_smelt_iron_ore~~"		\| where=BlueprintItems.Codename="blueprint_smelt_iron_ore_outpost"
	}}		}}

Line 142:		Line 142:
	\|join on=R.JobCodename=J.Codename		\|join on=R.JobCodename=J.Codename
	\|fields=CONCAT('[[',J._pageName,'\|',J.Name,']]')=Job, J.Location, J.Type, R.Qty		\|fields=CONCAT('[[',J._pageName,'\|',J.Name,']]')=Job, J.Location, J.Type, R.Qty
	\|where=R.Codename="~~blueprint_smelt_iron_ore~~"		\|where=R.Codename="blueprint_smelt_iron_ore_outpost"
	\|format=table		\|format=table
	\|headers=show		\|headers=show
Line 150:		Line 150:
	{{ItemBlueprints		{{ItemBlueprints
	\| Name=Smelt Iron Ore		\| Name=Smelt Iron Ore
	\| Codename=~~blueprint_smelt_iron_ore~~		\| Codename=blueprint_smelt_iron_ore_outpost
	\| ItemType=~~blueprint_furnace~~		\| ItemType=blueprint_misc
	\| Type=~~FurnaceBlueprint~~		\| Type=MiscBlueprints
	\| WaitTime=undefined		\| WaitTime=undefined
	\| AutoUnlock=false		\| AutoUnlock=false
Line 159:		Line 159:
	}}		}}
	{{BlueprintItems		{{BlueprintItems
	\| BlueprintCodename=~~blueprint_smelt_iron_ore~~		\| BlueprintCodename=blueprint_smelt_iron_ore_outpost
	\| Codename=iron_ore		\| Codename=iron_ore
	\| Qty = 2		\| Qty = 1
	\| TakeItem = Yes		\| TakeItem = Yes
	}}{{BlueprintRewards		}}{{BlueprintRewards
	\| BlueprintCodename=~~blueprint_smelt_iron_ore~~		\| BlueprintCodename=blueprint_smelt_iron_ore_outpost
	\| Codename=iron_bar		\| Codename=iron_bar
	\| Qty=1		\| Qty=1
	}}<!-- ZC_CP_Autogen_End -->		}}<!-- ZC_CP_Autogen_End -->

127.0.0.1 at 14:37, 11 October 2025

2025-10-11T14:37:58Z

← Older revision		Revision as of 14:37, 11 October 2025
Line 1:		Line 1:
	<noinclude>{{~~MiscBlueprints~~\| Codename=~~blueprint_smelt_iron_ore_outpost~~		<noinclude>{{FurnaceBlueprint\| Codename=blueprint_smelt_iron_ore
	}}		}}
	</noinclude>		</noinclude>
Line 10:		Line 10:
	\|join on=BI.Codename=I.Codename		\|join on=BI.Codename=I.Codename
	\|fields=CONCAT('https://www.zed.city/items/', I.Codename, '.png')=Image,I._pageName=Resource, BI.Qty		\|fields=CONCAT('https://www.zed.city/items/', I.Codename, '.png')=Image,I._pageName=Resource, BI.Qty
	\|where=BI.BlueprintCodename="~~blueprint_smelt_iron_ore_outpost~~"		\|where=BI.BlueprintCodename="blueprint_smelt_iron_ore"
	\|format=table		\|format=table
	}}		}}
Line 19:		Line 19:
	\|join on=BI.Codename=I.Codename		\|join on=BI.Codename=I.Codename
	\|fields=CONCAT('https://www.zed.city/items/', I.Codename, '.png')=Image,I._pageName=Resource, BI.Qty		\|fields=CONCAT('https://www.zed.city/items/', I.Codename, '.png')=Image,I._pageName=Resource, BI.Qty
	\|where=BI.BlueprintCodename="~~blueprint_smelt_iron_ore_outpost~~"		\|where=BI.BlueprintCodename="blueprint_smelt_iron_ore"
	\|format=table		\|format=table
	}}		}}
Line 25:		Line 25:

	<noinclude>{{Items		<noinclude>{{Items
	\| Codename=~~blueprint_smelt_iron_ore_outpost~~		\| Codename=blueprint_smelt_iron_ore
	\| Type=~~MiscBlueprints~~		\| Type=FurnaceBlueprint
	}}		}}

Line 52:		Line 52:
	\| join on=StatusEffectLink.Codename=PlayerEffects.Codename		\| join on=StatusEffectLink.Codename=PlayerEffects.Codename
	\| fields=PlayerEffects.Name, PlayerEffects.Description, StatusEffectLink.Duration=Duration (seconds)		\| fields=PlayerEffects.Name, PlayerEffects.Description, StatusEffectLink.Duration=Duration (seconds)
	\| where=StatusEffectLink.LinkCodename="~~blueprint_smelt_iron_ore_outpost~~"		\| where=StatusEffectLink.LinkCodename="blueprint_smelt_iron_ore"
	\| format=table		\| format=table
	\| default=No extra effects		\| default=No extra effects
Line 65:		Line 65:
	\| join on=ItemBlueprints.Codename = BlueprintRewards.BlueprintCodename, BuildingBlueprintList.Codename = ItemBlueprints.ItemType, BuildingBlueprintList.BuildingCodename = Buildings.Codename		\| join on=ItemBlueprints.Codename = BlueprintRewards.BlueprintCodename, BuildingBlueprintList.Codename = ItemBlueprints.ItemType, BuildingBlueprintList.BuildingCodename = Buildings.Codename
	\| fields=ItemBlueprints._pageName = Blueprint, Buildings._pageName = Building		\| fields=ItemBlueprints._pageName = Blueprint, Buildings._pageName = Building
	\| where=BlueprintRewards.Codename = "~~blueprint_smelt_iron_ore_outpost~~"		\| where=BlueprintRewards.Codename = "blueprint_smelt_iron_ore"
	\| format=table		\| format=table
	\| default=Not craftable in stronghold		\| default=Not craftable in stronghold
Line 75:		Line 75:
	\|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,'%')=Drop Rate, R.Qty		\|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
	\|where=R.Codename="~~blueprint_smelt_iron_ore_outpost~~" AND J.Location="city"		\|where=R.Codename="blueprint_smelt_iron_ore" AND J.Location="city"
	\|format=table		\|format=table
	\|headers=show		\|headers=show
Line 87:		Line 87:
	\|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,'%')=Drop Rate, R.Qty		\|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
	\|where=R.Codename="~~blueprint_smelt_iron_ore_outpost~~"		\|where=R.Codename="blueprint_smelt_iron_ore"
	\|format=table		\|format=table
	\|headers=show		\|headers=show
Line 101:		Line 101:
	LootTableLink.LinkCodename=Zeds.Codename;		LootTableLink.LinkCodename=Zeds.Codename;
	fields=CONCAT('{{FA\|crosshairs}}')=_, Zeds._pageName=Zed;		fields=CONCAT('{{FA\|crosshairs}}')=_, Zeds._pageName=Zed;
	where=LootTableItem.Codename="~~blueprint_smelt_iron_ore_outpost~~" AND LootTableLink.LinkType="Zeds";		where=LootTableItem.Codename="blueprint_smelt_iron_ore" AND LootTableLink.LinkType="Zeds";
	\|tables=ZedLoot,Zeds;		\|tables=ZedLoot,Zeds;
	join on=ZedLoot.ZedCodename=Zeds.Codename;		join on=ZedLoot.ZedCodename=Zeds.Codename;
	fields=CONCAT('{{FA\|crosshairs}}')=_, Zeds._pageName=Zed;		fields=CONCAT('{{FA\|crosshairs}}')=_, Zeds._pageName=Zed;
	where=ZedLoot.Codename="~~blueprint_smelt_iron_ore_outpost~~";		where=ZedLoot.Codename="blueprint_smelt_iron_ore";
	\|format=table		\|format=table
	}}		}}
Line 118:		Line 118:
	ScavengeJobRewards.JobCodename = ScavengeRooms.Codename		ScavengeJobRewards.JobCodename = ScavengeRooms.Codename
	\| fields=Locations._pageName=Location		\| fields=Locations._pageName=Location
	\| where=ScavengeJobRewards.Codename='~~blueprint_smelt_iron_ore_outpost~~' AND Location != "city"		\| where=ScavengeJobRewards.Codename='blueprint_smelt_iron_ore' AND Location != "city"
	\| group by=Locations._pageName		\| group by=Locations._pageName
	\| format=table		\| format=table
Line 133:		Line 133:
	BuildingBlueprintList.BuildingCodename=Buildings.Codename		BuildingBlueprintList.BuildingCodename=Buildings.Codename
	\| fields=ItemBlueprints._pageName=Recipe, IF(Buildings.Name='', 'Stronghold', Buildings._pageName)=Building		\| fields=ItemBlueprints._pageName=Recipe, IF(Buildings.Name='', 'Stronghold', Buildings._pageName)=Building
	\| where=BlueprintItems.Codename="~~blueprint_smelt_iron_ore_outpost~~"		\| where=BlueprintItems.Codename="blueprint_smelt_iron_ore"
	}}		}}

Line 142:		Line 142:
	\|join on=R.JobCodename=J.Codename		\|join on=R.JobCodename=J.Codename
	\|fields=CONCAT('[[',J._pageName,'\|',J.Name,']]')=Job, J.Location, J.Type, R.Qty		\|fields=CONCAT('[[',J._pageName,'\|',J.Name,']]')=Job, J.Location, J.Type, R.Qty
	\|where=R.Codename="~~blueprint_smelt_iron_ore_outpost~~"		\|where=R.Codename="blueprint_smelt_iron_ore"
	\|format=table		\|format=table
	\|headers=show		\|headers=show
Line 150:		Line 150:
	{{ItemBlueprints		{{ItemBlueprints
	\| Name=Smelt Iron Ore		\| Name=Smelt Iron Ore
	\| Codename=~~blueprint_smelt_iron_ore_outpost~~		\| Codename=blueprint_smelt_iron_ore
	\| ItemType=~~blueprint_misc~~		\| ItemType=blueprint_furnace
	\| Type=~~MiscBlueprints~~		\| Type=FurnaceBlueprint
	\| WaitTime=undefined		\| WaitTime=undefined
	\| AutoUnlock=false		\| AutoUnlock=false
Line 159:		Line 159:
	}}		}}
	{{BlueprintItems		{{BlueprintItems
	\| BlueprintCodename=~~blueprint_smelt_iron_ore_outpost~~		\| BlueprintCodename=blueprint_smelt_iron_ore
	\| Codename=iron_ore		\| Codename=iron_ore
	\| Qty = 1		\| Qty = 2
	\| TakeItem = Yes		\| TakeItem = Yes
	}}{{BlueprintRewards		}}{{BlueprintRewards
	\| BlueprintCodename=~~blueprint_smelt_iron_ore_outpost~~		\| BlueprintCodename=blueprint_smelt_iron_ore
	\| Codename=iron_bar		\| Codename=iron_bar
	\| Qty=1		\| Qty=1
	}}<!-- ZC_CP_Autogen_End -->		}}<!-- ZC_CP_Autogen_End -->

127.0.0.1 at 17:53, 22 August 2025

2025-08-22T17:53:07Z

← Older revision		Revision as of 17:53, 22 August 2025
Line 1:		Line 1:
	<noinclude>{{~~FurnaceBlueprint~~\| Codename=~~blueprint_smelt_iron_ore~~		<noinclude>{{MiscBlueprints\| Codename=blueprint_smelt_iron_ore_outpost
	}}		}}
	</noinclude>		</noinclude>
Line 10:		Line 10:
	\|join on=BI.Codename=I.Codename		\|join on=BI.Codename=I.Codename
	\|fields=CONCAT('https://www.zed.city/items/', I.Codename, '.png')=Image,I._pageName=Resource, BI.Qty		\|fields=CONCAT('https://www.zed.city/items/', I.Codename, '.png')=Image,I._pageName=Resource, BI.Qty
	\|where=BI.BlueprintCodename="~~blueprint_smelt_iron_ore~~"		\|where=BI.BlueprintCodename="blueprint_smelt_iron_ore_outpost"
	\|format=table		\|format=table
	}}		}}
Line 19:		Line 19:
	\|join on=BI.Codename=I.Codename		\|join on=BI.Codename=I.Codename
	\|fields=CONCAT('https://www.zed.city/items/', I.Codename, '.png')=Image,I._pageName=Resource, BI.Qty		\|fields=CONCAT('https://www.zed.city/items/', I.Codename, '.png')=Image,I._pageName=Resource, BI.Qty
	\|where=BI.BlueprintCodename="~~blueprint_smelt_iron_ore~~"		\|where=BI.BlueprintCodename="blueprint_smelt_iron_ore_outpost"
	\|format=table		\|format=table
	}}		}}
Line 25:		Line 25:

	<noinclude>{{Items		<noinclude>{{Items
	\| Codename=~~blueprint_smelt_iron_ore~~		\| Codename=blueprint_smelt_iron_ore_outpost
	\| Type=~~FurnaceBlueprint~~		\| Type=MiscBlueprints
	}}		}}

Line 52:		Line 52:
	\| join on=StatusEffectLink.Codename=PlayerEffects.Codename		\| join on=StatusEffectLink.Codename=PlayerEffects.Codename
	\| fields=PlayerEffects.Name, PlayerEffects.Description, StatusEffectLink.Duration=Duration (seconds)		\| fields=PlayerEffects.Name, PlayerEffects.Description, StatusEffectLink.Duration=Duration (seconds)
	\| where=StatusEffectLink.LinkCodename="~~blueprint_smelt_iron_ore~~"		\| where=StatusEffectLink.LinkCodename="blueprint_smelt_iron_ore_outpost"
	\| format=table		\| format=table
	\| default=No extra effects		\| default=No extra effects
Line 65:		Line 65:
	\| join on=ItemBlueprints.Codename = BlueprintRewards.BlueprintCodename, BuildingBlueprintList.Codename = ItemBlueprints.ItemType, BuildingBlueprintList.BuildingCodename = Buildings.Codename		\| join on=ItemBlueprints.Codename = BlueprintRewards.BlueprintCodename, BuildingBlueprintList.Codename = ItemBlueprints.ItemType, BuildingBlueprintList.BuildingCodename = Buildings.Codename
	\| fields=ItemBlueprints._pageName = Blueprint, Buildings._pageName = Building		\| fields=ItemBlueprints._pageName = Blueprint, Buildings._pageName = Building
	\| where=BlueprintRewards.Codename = "~~blueprint_smelt_iron_ore~~"		\| where=BlueprintRewards.Codename = "blueprint_smelt_iron_ore_outpost"
	\| format=table		\| format=table
	\| default=Not craftable in stronghold		\| default=Not craftable in stronghold
Line 75:		Line 75:
	\|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,'%')=Drop Rate, R.Qty		\|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
	\|where=R.Codename="~~blueprint_smelt_iron_ore~~" AND J.Location="city"		\|where=R.Codename="blueprint_smelt_iron_ore_outpost" AND J.Location="city"
	\|format=table		\|format=table
	\|headers=show		\|headers=show
Line 87:		Line 87:
	\|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,'%')=Drop Rate, R.Qty		\|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
	\|where=R.Codename="~~blueprint_smelt_iron_ore~~"		\|where=R.Codename="blueprint_smelt_iron_ore_outpost"
	\|format=table		\|format=table
	\|headers=show		\|headers=show
Line 101:		Line 101:
	LootTableLink.LinkCodename=Zeds.Codename;		LootTableLink.LinkCodename=Zeds.Codename;
	fields=CONCAT('{{FA\|crosshairs}}')=_, Zeds._pageName=Zed;		fields=CONCAT('{{FA\|crosshairs}}')=_, Zeds._pageName=Zed;
	where=LootTableItem.Codename="~~blueprint_smelt_iron_ore~~" AND LootTableLink.LinkType="Zeds";		where=LootTableItem.Codename="blueprint_smelt_iron_ore_outpost" AND LootTableLink.LinkType="Zeds";
	\|tables=ZedLoot,Zeds;		\|tables=ZedLoot,Zeds;
	join on=ZedLoot.ZedCodename=Zeds.Codename;		join on=ZedLoot.ZedCodename=Zeds.Codename;
	fields=CONCAT('{{FA\|crosshairs}}')=_, Zeds._pageName=Zed;		fields=CONCAT('{{FA\|crosshairs}}')=_, Zeds._pageName=Zed;
	where=ZedLoot.Codename="~~blueprint_smelt_iron_ore~~";		where=ZedLoot.Codename="blueprint_smelt_iron_ore_outpost";
	\|format=table		\|format=table
	}}		}}
Line 118:		Line 118:
	ScavengeJobRewards.JobCodename = ScavengeRooms.Codename		ScavengeJobRewards.JobCodename = ScavengeRooms.Codename
	\| fields=Locations._pageName=Location		\| fields=Locations._pageName=Location
	\| where=ScavengeJobRewards.Codename='~~blueprint_smelt_iron_ore~~' AND Location != "city"		\| where=ScavengeJobRewards.Codename='blueprint_smelt_iron_ore_outpost' AND Location != "city"
	\| group by=Locations._pageName		\| group by=Locations._pageName
	\| format=table		\| format=table
Line 133:		Line 133:
	BuildingBlueprintList.BuildingCodename=Buildings.Codename		BuildingBlueprintList.BuildingCodename=Buildings.Codename
	\| fields=ItemBlueprints._pageName=Recipe, IF(Buildings.Name='', 'Stronghold', Buildings._pageName)=Building		\| fields=ItemBlueprints._pageName=Recipe, IF(Buildings.Name='', 'Stronghold', Buildings._pageName)=Building
	\| where=BlueprintItems.Codename="~~blueprint_smelt_iron_ore~~"		\| where=BlueprintItems.Codename="blueprint_smelt_iron_ore_outpost"
	}}		}}

Line 142:		Line 142:
	\|join on=R.JobCodename=J.Codename		\|join on=R.JobCodename=J.Codename
	\|fields=CONCAT('[[',J._pageName,'\|',J.Name,']]')=Job, J.Location, J.Type, R.Qty		\|fields=CONCAT('[[',J._pageName,'\|',J.Name,']]')=Job, J.Location, J.Type, R.Qty
	\|where=R.Codename="~~blueprint_smelt_iron_ore~~"		\|where=R.Codename="blueprint_smelt_iron_ore_outpost"
	\|format=table		\|format=table
	\|headers=show		\|headers=show
Line 150:		Line 150:
	{{ItemBlueprints		{{ItemBlueprints
	\| Name=Smelt Iron Ore		\| Name=Smelt Iron Ore
	\| Codename=~~blueprint_smelt_iron_ore~~		\| Codename=blueprint_smelt_iron_ore_outpost
	\| ItemType=~~blueprint_furnace~~		\| ItemType=blueprint_misc
	\| Type=~~FurnaceBlueprint~~		\| Type=MiscBlueprints
	\| WaitTime=undefined		\| WaitTime=undefined
	\| AutoUnlock=false		\| AutoUnlock=false
Line 159:		Line 159:
	}}		}}
	{{BlueprintItems		{{BlueprintItems
	\| BlueprintCodename=~~blueprint_smelt_iron_ore~~		\| BlueprintCodename=blueprint_smelt_iron_ore_outpost
	\| Codename=iron_ore		\| Codename=iron_ore
	\| Qty = 2		\| Qty = 1
	\| TakeItem = Yes		\| TakeItem = Yes
	}}{{BlueprintRewards		}}{{BlueprintRewards
	\| BlueprintCodename=~~blueprint_smelt_iron_ore~~		\| BlueprintCodename=blueprint_smelt_iron_ore_outpost
	\| Codename=iron_bar		\| Codename=iron_bar
	\| Qty=1		\| Qty=1
	}}<!-- ZC_CP_Autogen_End -->		}}<!-- ZC_CP_Autogen_End -->

127.0.0.1 at 17:51, 22 August 2025

2025-08-22T17:51:22Z

← Older revision		Revision as of 17:51, 22 August 2025
Line 1:		Line 1:
	<noinclude>{{~~MiscBlueprints~~\| Codename=~~blueprint_smelt_iron_ore_outpost~~		<noinclude>{{FurnaceBlueprint\| Codename=blueprint_smelt_iron_ore
	}}		}}
	</noinclude>		</noinclude>
Line 10:		Line 10:
	\|join on=BI.Codename=I.Codename		\|join on=BI.Codename=I.Codename
	\|fields=CONCAT('https://www.zed.city/items/', I.Codename, '.png')=Image,I._pageName=Resource, BI.Qty		\|fields=CONCAT('https://www.zed.city/items/', I.Codename, '.png')=Image,I._pageName=Resource, BI.Qty
	\|where=BI.BlueprintCodename="~~blueprint_smelt_iron_ore_outpost~~"		\|where=BI.BlueprintCodename="blueprint_smelt_iron_ore"
	\|format=table		\|format=table
	}}		}}
Line 19:		Line 19:
	\|join on=BI.Codename=I.Codename		\|join on=BI.Codename=I.Codename
	\|fields=CONCAT('https://www.zed.city/items/', I.Codename, '.png')=Image,I._pageName=Resource, BI.Qty		\|fields=CONCAT('https://www.zed.city/items/', I.Codename, '.png')=Image,I._pageName=Resource, BI.Qty
	\|where=BI.BlueprintCodename="~~blueprint_smelt_iron_ore_outpost~~"		\|where=BI.BlueprintCodename="blueprint_smelt_iron_ore"
	\|format=table		\|format=table
	}}		}}
Line 25:		Line 25:

	<noinclude>{{Items		<noinclude>{{Items
	\| Codename=~~blueprint_smelt_iron_ore_outpost~~		\| Codename=blueprint_smelt_iron_ore
	\| Type=~~MiscBlueprints~~		\| Type=FurnaceBlueprint
	}}		}}

Line 52:		Line 52:
	\| join on=StatusEffectLink.Codename=PlayerEffects.Codename		\| join on=StatusEffectLink.Codename=PlayerEffects.Codename
	\| fields=PlayerEffects.Name, PlayerEffects.Description, StatusEffectLink.Duration=Duration (seconds)		\| fields=PlayerEffects.Name, PlayerEffects.Description, StatusEffectLink.Duration=Duration (seconds)
	\| where=StatusEffectLink.LinkCodename="~~blueprint_smelt_iron_ore_outpost~~"		\| where=StatusEffectLink.LinkCodename="blueprint_smelt_iron_ore"
	\| format=table		\| format=table
	\| default=No extra effects		\| default=No extra effects
Line 65:		Line 65:
	\| join on=ItemBlueprints.Codename = BlueprintRewards.BlueprintCodename, BuildingBlueprintList.Codename = ItemBlueprints.ItemType, BuildingBlueprintList.BuildingCodename = Buildings.Codename		\| join on=ItemBlueprints.Codename = BlueprintRewards.BlueprintCodename, BuildingBlueprintList.Codename = ItemBlueprints.ItemType, BuildingBlueprintList.BuildingCodename = Buildings.Codename
	\| fields=ItemBlueprints._pageName = Blueprint, Buildings._pageName = Building		\| fields=ItemBlueprints._pageName = Blueprint, Buildings._pageName = Building
	\| where=BlueprintRewards.Codename = "~~blueprint_smelt_iron_ore_outpost~~"		\| where=BlueprintRewards.Codename = "blueprint_smelt_iron_ore"
	\| format=table		\| format=table
	\| default=Not craftable in stronghold		\| default=Not craftable in stronghold
Line 75:		Line 75:
	\|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,'%')=Drop Rate, R.Qty		\|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
	\|where=R.Codename="~~blueprint_smelt_iron_ore_outpost~~" AND J.Location="city"		\|where=R.Codename="blueprint_smelt_iron_ore" AND J.Location="city"
	\|format=table		\|format=table
	\|headers=show		\|headers=show
Line 87:		Line 87:
	\|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,'%')=Drop Rate, R.Qty		\|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
	\|where=R.Codename="~~blueprint_smelt_iron_ore_outpost~~"		\|where=R.Codename="blueprint_smelt_iron_ore"
	\|format=table		\|format=table
	\|headers=show		\|headers=show
Line 101:		Line 101:
	LootTableLink.LinkCodename=Zeds.Codename;		LootTableLink.LinkCodename=Zeds.Codename;
	fields=CONCAT('{{FA\|crosshairs}}')=_, Zeds._pageName=Zed;		fields=CONCAT('{{FA\|crosshairs}}')=_, Zeds._pageName=Zed;
	where=LootTableItem.Codename="~~blueprint_smelt_iron_ore_outpost~~" AND LootTableLink.LinkType="Zeds";		where=LootTableItem.Codename="blueprint_smelt_iron_ore" AND LootTableLink.LinkType="Zeds";
	\|tables=ZedLoot,Zeds;		\|tables=ZedLoot,Zeds;
	join on=ZedLoot.ZedCodename=Zeds.Codename;		join on=ZedLoot.ZedCodename=Zeds.Codename;
	fields=CONCAT('{{FA\|crosshairs}}')=_, Zeds._pageName=Zed;		fields=CONCAT('{{FA\|crosshairs}}')=_, Zeds._pageName=Zed;
	where=ZedLoot.Codename="~~blueprint_smelt_iron_ore_outpost~~";		where=ZedLoot.Codename="blueprint_smelt_iron_ore";
	\|format=table		\|format=table
	}}		}}
Line 118:		Line 118:
	ScavengeJobRewards.JobCodename = ScavengeRooms.Codename		ScavengeJobRewards.JobCodename = ScavengeRooms.Codename
	\| fields=Locations._pageName=Location		\| fields=Locations._pageName=Location
	\| where=ScavengeJobRewards.Codename='~~blueprint_smelt_iron_ore_outpost~~' AND Location != "city"		\| where=ScavengeJobRewards.Codename='blueprint_smelt_iron_ore' AND Location != "city"
	\| group by=Locations._pageName		\| group by=Locations._pageName
	\| format=table		\| format=table
Line 133:		Line 133:
	BuildingBlueprintList.BuildingCodename=Buildings.Codename		BuildingBlueprintList.BuildingCodename=Buildings.Codename
	\| fields=ItemBlueprints._pageName=Recipe, IF(Buildings.Name='', 'Stronghold', Buildings._pageName)=Building		\| fields=ItemBlueprints._pageName=Recipe, IF(Buildings.Name='', 'Stronghold', Buildings._pageName)=Building
	\| where=BlueprintItems.Codename="~~blueprint_smelt_iron_ore_outpost~~"		\| where=BlueprintItems.Codename="blueprint_smelt_iron_ore"
	}}		}}

Line 142:		Line 142:
	\|join on=R.JobCodename=J.Codename		\|join on=R.JobCodename=J.Codename
	\|fields=CONCAT('[[',J._pageName,'\|',J.Name,']]')=Job, J.Location, J.Type, R.Qty		\|fields=CONCAT('[[',J._pageName,'\|',J.Name,']]')=Job, J.Location, J.Type, R.Qty
	\|where=R.Codename="~~blueprint_smelt_iron_ore_outpost~~"		\|where=R.Codename="blueprint_smelt_iron_ore"
	\|format=table		\|format=table
	\|headers=show		\|headers=show
Line 150:		Line 150:
	{{ItemBlueprints		{{ItemBlueprints
	\| Name=Smelt Iron Ore		\| Name=Smelt Iron Ore
	\| Codename=~~blueprint_smelt_iron_ore_outpost~~		\| Codename=blueprint_smelt_iron_ore
	\| ItemType=~~blueprint_misc~~		\| ItemType=blueprint_furnace
	\| Type=~~MiscBlueprints~~		\| Type=FurnaceBlueprint
	\| WaitTime=undefined		\| WaitTime=undefined
	\| AutoUnlock=false		\| AutoUnlock=false
Line 159:		Line 159:
	}}		}}
	{{BlueprintItems		{{BlueprintItems
	\| BlueprintCodename=~~blueprint_smelt_iron_ore_outpost~~		\| BlueprintCodename=blueprint_smelt_iron_ore
	\| Codename=iron_ore		\| Codename=iron_ore
	\| Qty = 1		\| Qty = 2
	\| TakeItem = Yes		\| TakeItem = Yes
	}}{{BlueprintRewards		}}{{BlueprintRewards
	\| BlueprintCodename=~~blueprint_smelt_iron_ore_outpost~~		\| BlueprintCodename=blueprint_smelt_iron_ore
	\| Codename=iron_bar		\| Codename=iron_bar
	\| Qty=1		\| Qty=1
	}}<!-- ZC_CP_Autogen_End -->		}}<!-- ZC_CP_Autogen_End -->

127.0.0.1 at 13:29, 14 August 2025

2025-08-14T13:29:31Z

← Older revision		Revision as of 13:29, 14 August 2025
Line 1:		Line 1:
	<noinclude>{{~~FurnaceBlueprint~~\| Codename=~~blueprint_smelt_iron_ore~~		<noinclude>{{MiscBlueprints\| Codename=blueprint_smelt_iron_ore_outpost
	}}		}}
	</noinclude>		</noinclude>
Line 10:		Line 10:
	\|join on=BI.Codename=I.Codename		\|join on=BI.Codename=I.Codename
	\|fields=CONCAT('https://www.zed.city/items/', I.Codename, '.png')=Image,I._pageName=Resource, BI.Qty		\|fields=CONCAT('https://www.zed.city/items/', I.Codename, '.png')=Image,I._pageName=Resource, BI.Qty
	\|where=BI.BlueprintCodename="~~blueprint_smelt_iron_ore~~"		\|where=BI.BlueprintCodename="blueprint_smelt_iron_ore_outpost"
	\|format=table		\|format=table
	}}		}}
Line 19:		Line 19:
	\|join on=BI.Codename=I.Codename		\|join on=BI.Codename=I.Codename
	\|fields=CONCAT('https://www.zed.city/items/', I.Codename, '.png')=Image,I._pageName=Resource, BI.Qty		\|fields=CONCAT('https://www.zed.city/items/', I.Codename, '.png')=Image,I._pageName=Resource, BI.Qty
	\|where=BI.BlueprintCodename="~~blueprint_smelt_iron_ore~~"		\|where=BI.BlueprintCodename="blueprint_smelt_iron_ore_outpost"
	\|format=table		\|format=table
	}}		}}
Line 25:		Line 25:

	<noinclude>{{Items		<noinclude>{{Items
	\| Codename=~~blueprint_smelt_iron_ore~~		\| Codename=blueprint_smelt_iron_ore_outpost
	\| Type=~~FurnaceBlueprint~~		\| Type=MiscBlueprints
	}}		}}

Line 52:		Line 52:
	\| join on=StatusEffectLink.Codename=PlayerEffects.Codename		\| join on=StatusEffectLink.Codename=PlayerEffects.Codename
	\| fields=PlayerEffects.Name, PlayerEffects.Description, StatusEffectLink.Duration=Duration (seconds)		\| fields=PlayerEffects.Name, PlayerEffects.Description, StatusEffectLink.Duration=Duration (seconds)
	\| where=StatusEffectLink.LinkCodename="~~blueprint_smelt_iron_ore~~"		\| where=StatusEffectLink.LinkCodename="blueprint_smelt_iron_ore_outpost"
	\| format=table		\| format=table
	\| default=No extra effects		\| default=No extra effects
Line 65:		Line 65:
	\| join on=ItemBlueprints.Codename = BlueprintRewards.BlueprintCodename, BuildingBlueprintList.Codename = ItemBlueprints.ItemType, BuildingBlueprintList.BuildingCodename = Buildings.Codename		\| join on=ItemBlueprints.Codename = BlueprintRewards.BlueprintCodename, BuildingBlueprintList.Codename = ItemBlueprints.ItemType, BuildingBlueprintList.BuildingCodename = Buildings.Codename
	\| fields=ItemBlueprints._pageName = Blueprint, Buildings._pageName = Building		\| fields=ItemBlueprints._pageName = Blueprint, Buildings._pageName = Building
	\| where=BlueprintRewards.Codename = "~~blueprint_smelt_iron_ore~~"		\| where=BlueprintRewards.Codename = "blueprint_smelt_iron_ore_outpost"
	\| format=table		\| format=table
	\| default=Not craftable in stronghold		\| default=Not craftable in stronghold
Line 75:		Line 75:
	\|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,'%')=Drop Rate, R.Qty		\|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
	\|where=R.Codename="~~blueprint_smelt_iron_ore~~" AND J.Location="city"		\|where=R.Codename="blueprint_smelt_iron_ore_outpost" AND J.Location="city"
	\|format=table		\|format=table
	\|headers=show		\|headers=show
Line 87:		Line 87:
	\|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,'%')=Drop Rate, R.Qty		\|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
	\|where=R.Codename="~~blueprint_smelt_iron_ore~~"		\|where=R.Codename="blueprint_smelt_iron_ore_outpost"
	\|format=table		\|format=table
	\|headers=show		\|headers=show
Line 101:		Line 101:
	LootTableLink.LinkCodename=Zeds.Codename;		LootTableLink.LinkCodename=Zeds.Codename;
	fields=CONCAT('{{FA\|crosshairs}}')=_, Zeds._pageName=Zed;		fields=CONCAT('{{FA\|crosshairs}}')=_, Zeds._pageName=Zed;
	where=LootTableItem.Codename="~~blueprint_smelt_iron_ore~~" AND LootTableLink.LinkType="Zeds";		where=LootTableItem.Codename="blueprint_smelt_iron_ore_outpost" AND LootTableLink.LinkType="Zeds";
	\|tables=ZedLoot,Zeds;		\|tables=ZedLoot,Zeds;
	join on=ZedLoot.ZedCodename=Zeds.Codename;		join on=ZedLoot.ZedCodename=Zeds.Codename;
	fields=CONCAT('{{FA\|crosshairs}}')=_, Zeds._pageName=Zed;		fields=CONCAT('{{FA\|crosshairs}}')=_, Zeds._pageName=Zed;
	where=ZedLoot.Codename="~~blueprint_smelt_iron_ore~~";		where=ZedLoot.Codename="blueprint_smelt_iron_ore_outpost";
	\|format=table		\|format=table
	}}		}}
Line 118:		Line 118:
	ScavengeJobRewards.JobCodename = ScavengeRooms.Codename		ScavengeJobRewards.JobCodename = ScavengeRooms.Codename
	\| fields=Locations._pageName=Location		\| fields=Locations._pageName=Location
	\| where=ScavengeJobRewards.Codename='~~blueprint_smelt_iron_ore~~' AND Location != "city"		\| where=ScavengeJobRewards.Codename='blueprint_smelt_iron_ore_outpost' AND Location != "city"
	\| group by=Locations._pageName		\| group by=Locations._pageName
	\| format=table		\| format=table
Line 133:		Line 133:
	BuildingBlueprintList.BuildingCodename=Buildings.Codename		BuildingBlueprintList.BuildingCodename=Buildings.Codename
	\| fields=ItemBlueprints._pageName=Recipe, IF(Buildings.Name='', 'Stronghold', Buildings._pageName)=Building		\| fields=ItemBlueprints._pageName=Recipe, IF(Buildings.Name='', 'Stronghold', Buildings._pageName)=Building
	\| where=BlueprintItems.Codename="~~blueprint_smelt_iron_ore~~"		\| where=BlueprintItems.Codename="blueprint_smelt_iron_ore_outpost"
	}}		}}

Line 142:		Line 142:
	\|join on=R.JobCodename=J.Codename		\|join on=R.JobCodename=J.Codename
	\|fields=CONCAT('[[',J._pageName,'\|',J.Name,']]')=Job, J.Location, J.Type, R.Qty		\|fields=CONCAT('[[',J._pageName,'\|',J.Name,']]')=Job, J.Location, J.Type, R.Qty
	\|where=R.Codename="~~blueprint_smelt_iron_ore~~"		\|where=R.Codename="blueprint_smelt_iron_ore_outpost"
	\|format=table		\|format=table
	\|headers=show		\|headers=show
Line 150:		Line 150:
	{{ItemBlueprints		{{ItemBlueprints
	\| Name=Smelt Iron Ore		\| Name=Smelt Iron Ore
	\| Codename=~~blueprint_smelt_iron_ore~~		\| Codename=blueprint_smelt_iron_ore_outpost
	\| ItemType=~~blueprint_furnace~~		\| ItemType=blueprint_misc
	\| Type=~~FurnaceBlueprint~~		\| Type=MiscBlueprints
	\| WaitTime=undefined		\| WaitTime=undefined
	\| AutoUnlock=false		\| AutoUnlock=false
Line 159:		Line 159:
	}}		}}
	{{BlueprintItems		{{BlueprintItems
	\| BlueprintCodename=~~blueprint_smelt_iron_ore~~		\| BlueprintCodename=blueprint_smelt_iron_ore_outpost
	\| Codename=iron_ore		\| Codename=iron_ore
	\| Qty = 2		\| Qty = 1
	\| TakeItem = Yes		\| TakeItem = Yes
	}}{{BlueprintRewards		}}{{BlueprintRewards
	\| BlueprintCodename=~~blueprint_smelt_iron_ore~~		\| BlueprintCodename=blueprint_smelt_iron_ore_outpost
	\| Codename=iron_bar		\| Codename=iron_bar
	\| Qty=1		\| Qty=1
	}}<!-- ZC_CP_Autogen_End -->		}}<!-- ZC_CP_Autogen_End -->

127.0.0.1 at 13:28, 14 August 2025

2025-08-14T13:28:22Z

← Older revision		Revision as of 13:28, 14 August 2025
Line 1:		Line 1:
	<noinclude>{{~~MiscBlueprints~~\| Codename=~~blueprint_smelt_iron_ore_outpost~~		<noinclude>{{FurnaceBlueprint\| Codename=blueprint_smelt_iron_ore
	}}		}}
	</noinclude>		</noinclude>
Line 10:		Line 10:
	\|join on=BI.Codename=I.Codename		\|join on=BI.Codename=I.Codename
	\|fields=CONCAT('https://www.zed.city/items/', I.Codename, '.png')=Image,I._pageName=Resource, BI.Qty		\|fields=CONCAT('https://www.zed.city/items/', I.Codename, '.png')=Image,I._pageName=Resource, BI.Qty
	\|where=BI.BlueprintCodename="~~blueprint_smelt_iron_ore_outpost~~"		\|where=BI.BlueprintCodename="blueprint_smelt_iron_ore"
	\|format=table		\|format=table
	}}		}}
Line 19:		Line 19:
	\|join on=BI.Codename=I.Codename		\|join on=BI.Codename=I.Codename
	\|fields=CONCAT('https://www.zed.city/items/', I.Codename, '.png')=Image,I._pageName=Resource, BI.Qty		\|fields=CONCAT('https://www.zed.city/items/', I.Codename, '.png')=Image,I._pageName=Resource, BI.Qty
	\|where=BI.BlueprintCodename="~~blueprint_smelt_iron_ore_outpost~~"		\|where=BI.BlueprintCodename="blueprint_smelt_iron_ore"
	\|format=table		\|format=table
	}}		}}
Line 25:		Line 25:

	<noinclude>{{Items		<noinclude>{{Items
	\| Codename=~~blueprint_smelt_iron_ore_outpost~~		\| Codename=blueprint_smelt_iron_ore
	\| Type=~~MiscBlueprints~~		\| Type=FurnaceBlueprint
	}}		}}

Line 52:		Line 52:
	\| join on=StatusEffectLink.Codename=PlayerEffects.Codename		\| join on=StatusEffectLink.Codename=PlayerEffects.Codename
	\| fields=PlayerEffects.Name, PlayerEffects.Description, StatusEffectLink.Duration=Duration (seconds)		\| fields=PlayerEffects.Name, PlayerEffects.Description, StatusEffectLink.Duration=Duration (seconds)
	\| where=StatusEffectLink.LinkCodename="~~blueprint_smelt_iron_ore_outpost~~"		\| where=StatusEffectLink.LinkCodename="blueprint_smelt_iron_ore"
	\| format=table		\| format=table
	\| default=No extra effects		\| default=No extra effects
Line 65:		Line 65:
	\| join on=ItemBlueprints.Codename = BlueprintRewards.BlueprintCodename, BuildingBlueprintList.Codename = ItemBlueprints.ItemType, BuildingBlueprintList.BuildingCodename = Buildings.Codename		\| join on=ItemBlueprints.Codename = BlueprintRewards.BlueprintCodename, BuildingBlueprintList.Codename = ItemBlueprints.ItemType, BuildingBlueprintList.BuildingCodename = Buildings.Codename
	\| fields=ItemBlueprints._pageName = Blueprint, Buildings._pageName = Building		\| fields=ItemBlueprints._pageName = Blueprint, Buildings._pageName = Building
	\| where=BlueprintRewards.Codename = "~~blueprint_smelt_iron_ore_outpost~~"		\| where=BlueprintRewards.Codename = "blueprint_smelt_iron_ore"
	\| format=table		\| format=table
	\| default=Not craftable in stronghold		\| default=Not craftable in stronghold
Line 75:		Line 75:
	\|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,'%')=Drop Rate, R.Qty		\|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
	\|where=R.Codename="~~blueprint_smelt_iron_ore_outpost~~" AND J.Location="city"		\|where=R.Codename="blueprint_smelt_iron_ore" AND J.Location="city"
	\|format=table		\|format=table
	\|headers=show		\|headers=show
Line 87:		Line 87:
	\|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,'%')=Drop Rate, R.Qty		\|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
	\|where=R.Codename="~~blueprint_smelt_iron_ore_outpost~~"		\|where=R.Codename="blueprint_smelt_iron_ore"
	\|format=table		\|format=table
	\|headers=show		\|headers=show
Line 101:		Line 101:
	LootTableLink.LinkCodename=Zeds.Codename;		LootTableLink.LinkCodename=Zeds.Codename;
	fields=CONCAT('{{FA\|crosshairs}}')=_, Zeds._pageName=Zed;		fields=CONCAT('{{FA\|crosshairs}}')=_, Zeds._pageName=Zed;
	where=LootTableItem.Codename="~~blueprint_smelt_iron_ore_outpost~~" AND LootTableLink.LinkType="Zeds";		where=LootTableItem.Codename="blueprint_smelt_iron_ore" AND LootTableLink.LinkType="Zeds";
	\|tables=ZedLoot,Zeds;		\|tables=ZedLoot,Zeds;
	join on=ZedLoot.ZedCodename=Zeds.Codename;		join on=ZedLoot.ZedCodename=Zeds.Codename;
	fields=CONCAT('{{FA\|crosshairs}}')=_, Zeds._pageName=Zed;		fields=CONCAT('{{FA\|crosshairs}}')=_, Zeds._pageName=Zed;
	where=ZedLoot.Codename="~~blueprint_smelt_iron_ore_outpost~~";		where=ZedLoot.Codename="blueprint_smelt_iron_ore";
	\|format=table		\|format=table
	}}		}}
Line 118:		Line 118:
	ScavengeJobRewards.JobCodename = ScavengeRooms.Codename		ScavengeJobRewards.JobCodename = ScavengeRooms.Codename
	\| fields=Locations._pageName=Location		\| fields=Locations._pageName=Location
	\| where=ScavengeJobRewards.Codename='~~blueprint_smelt_iron_ore_outpost~~' AND Location != "city"		\| where=ScavengeJobRewards.Codename='blueprint_smelt_iron_ore' AND Location != "city"
			\| group by=Locations._pageName
	\| format=table		\| format=table
	}}		}}
Line 132:		Line 133:
	BuildingBlueprintList.BuildingCodename=Buildings.Codename		BuildingBlueprintList.BuildingCodename=Buildings.Codename
	\| fields=ItemBlueprints._pageName=Recipe, IF(Buildings.Name='', 'Stronghold', Buildings._pageName)=Building		\| fields=ItemBlueprints._pageName=Recipe, IF(Buildings.Name='', 'Stronghold', Buildings._pageName)=Building
	\| where=BlueprintItems.Codename="~~blueprint_smelt_iron_ore_outpost~~"		\| where=BlueprintItems.Codename="blueprint_smelt_iron_ore"
	}}		}}

Line 141:		Line 142:
	\|join on=R.JobCodename=J.Codename		\|join on=R.JobCodename=J.Codename
	\|fields=CONCAT('[[',J._pageName,'\|',J.Name,']]')=Job, J.Location, J.Type, R.Qty		\|fields=CONCAT('[[',J._pageName,'\|',J.Name,']]')=Job, J.Location, J.Type, R.Qty
	\|where=R.Codename="~~blueprint_smelt_iron_ore_outpost~~"		\|where=R.Codename="blueprint_smelt_iron_ore"
	\|format=table		\|format=table
	\|headers=show		\|headers=show
Line 149:		Line 150:
	{{ItemBlueprints		{{ItemBlueprints
	\| Name=Smelt Iron Ore		\| Name=Smelt Iron Ore
	\| Codename=~~blueprint_smelt_iron_ore_outpost~~		\| Codename=blueprint_smelt_iron_ore
	\| ItemType=~~blueprint_misc~~		\| ItemType=blueprint_furnace
	\| Type=~~MiscBlueprints~~		\| Type=FurnaceBlueprint
	\| WaitTime=undefined		\| WaitTime=undefined
	\| AutoUnlock=false		\| AutoUnlock=false
Line 158:		Line 159:
	}}		}}
	{{BlueprintItems		{{BlueprintItems
	\| BlueprintCodename=~~blueprint_smelt_iron_ore_outpost~~		\| BlueprintCodename=blueprint_smelt_iron_ore
	\| Codename=iron_ore		\| Codename=iron_ore
	\| Qty = 1		\| Qty = 2
	\| TakeItem = Yes		\| TakeItem = Yes
	}}{{BlueprintRewards		}}{{BlueprintRewards
	\| BlueprintCodename=~~blueprint_smelt_iron_ore_outpost~~		\| BlueprintCodename=blueprint_smelt_iron_ore
	\| Codename=iron_bar		\| Codename=iron_bar
	\| Qty=1		\| Qty=1
	}}<!-- ZC_CP_Autogen_End -->		}}<!-- ZC_CP_Autogen_End -->

127.0.0.1 at 20:12, 5 August 2025

2025-08-05T20:12:13Z

← Older revision		Revision as of 20:12, 5 August 2025
Line 1:		Line 1:
	<noinclude>{{~~FurnaceBlueprint~~\| Codename=~~blueprint_smelt_iron_ore~~		<noinclude>{{MiscBlueprints\| Codename=blueprint_smelt_iron_ore_outpost
	}}		}}
	</noinclude>		</noinclude>
Line 10:		Line 10:
	\|join on=BI.Codename=I.Codename		\|join on=BI.Codename=I.Codename
	\|fields=CONCAT('https://www.zed.city/items/', I.Codename, '.png')=Image,I._pageName=Resource, BI.Qty		\|fields=CONCAT('https://www.zed.city/items/', I.Codename, '.png')=Image,I._pageName=Resource, BI.Qty
	\|where=BI.BlueprintCodename="~~blueprint_smelt_iron_ore~~"		\|where=BI.BlueprintCodename="blueprint_smelt_iron_ore_outpost"
	\|format=table		\|format=table
	}}		}}
Line 19:		Line 19:
	\|join on=BI.Codename=I.Codename		\|join on=BI.Codename=I.Codename
	\|fields=CONCAT('https://www.zed.city/items/', I.Codename, '.png')=Image,I._pageName=Resource, BI.Qty		\|fields=CONCAT('https://www.zed.city/items/', I.Codename, '.png')=Image,I._pageName=Resource, BI.Qty
	\|where=BI.BlueprintCodename="~~blueprint_smelt_iron_ore~~"		\|where=BI.BlueprintCodename="blueprint_smelt_iron_ore_outpost"
	\|format=table		\|format=table
	}}		}}
Line 25:		Line 25:

	<noinclude>{{Items		<noinclude>{{Items
	\| Codename=~~blueprint_smelt_iron_ore~~		\| Codename=blueprint_smelt_iron_ore_outpost
	\| Type=~~FurnaceBlueprint~~		\| Type=MiscBlueprints
	}}		}}

Line 52:		Line 52:
	\| join on=StatusEffectLink.Codename=PlayerEffects.Codename		\| join on=StatusEffectLink.Codename=PlayerEffects.Codename
	\| fields=PlayerEffects.Name, PlayerEffects.Description, StatusEffectLink.Duration=Duration (seconds)		\| fields=PlayerEffects.Name, PlayerEffects.Description, StatusEffectLink.Duration=Duration (seconds)
	\| where=StatusEffectLink.LinkCodename="~~blueprint_smelt_iron_ore~~"		\| where=StatusEffectLink.LinkCodename="blueprint_smelt_iron_ore_outpost"
	\| format=table		\| format=table
	\| default=No extra effects		\| default=No extra effects
Line 65:		Line 65:
	\| join on=ItemBlueprints.Codename = BlueprintRewards.BlueprintCodename, BuildingBlueprintList.Codename = ItemBlueprints.ItemType, BuildingBlueprintList.BuildingCodename = Buildings.Codename		\| join on=ItemBlueprints.Codename = BlueprintRewards.BlueprintCodename, BuildingBlueprintList.Codename = ItemBlueprints.ItemType, BuildingBlueprintList.BuildingCodename = Buildings.Codename
	\| fields=ItemBlueprints._pageName = Blueprint, Buildings._pageName = Building		\| fields=ItemBlueprints._pageName = Blueprint, Buildings._pageName = Building
	\| where=BlueprintRewards.Codename = "~~blueprint_smelt_iron_ore~~"		\| where=BlueprintRewards.Codename = "blueprint_smelt_iron_ore_outpost"
	\| format=table		\| format=table
	\| default=Not craftable in stronghold		\| default=Not craftable in stronghold
Line 75:		Line 75:
	\|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,'%')=Drop Rate, R.Qty		\|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
	\|where=R.Codename="~~blueprint_smelt_iron_ore~~" AND J.Location="city"		\|where=R.Codename="blueprint_smelt_iron_ore_outpost" AND J.Location="city"
	\|format=table		\|format=table
	\|headers=show		\|headers=show
Line 87:		Line 87:
	\|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,'%')=Drop Rate, R.Qty		\|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
	\|where=R.Codename="~~blueprint_smelt_iron_ore~~"		\|where=R.Codename="blueprint_smelt_iron_ore_outpost"
	\|format=table		\|format=table
	\|headers=show		\|headers=show
Line 101:		Line 101:
	LootTableLink.LinkCodename=Zeds.Codename;		LootTableLink.LinkCodename=Zeds.Codename;
	fields=CONCAT('{{FA\|crosshairs}}')=_, Zeds._pageName=Zed;		fields=CONCAT('{{FA\|crosshairs}}')=_, Zeds._pageName=Zed;
	where=LootTableItem.Codename="~~blueprint_smelt_iron_ore~~" AND LootTableLink.LinkType="Zeds";		where=LootTableItem.Codename="blueprint_smelt_iron_ore_outpost" AND LootTableLink.LinkType="Zeds";
	\|tables=ZedLoot,Zeds;		\|tables=ZedLoot,Zeds;
	join on=ZedLoot.ZedCodename=Zeds.Codename;		join on=ZedLoot.ZedCodename=Zeds.Codename;
	fields=CONCAT('{{FA\|crosshairs}}')=_, Zeds._pageName=Zed;		fields=CONCAT('{{FA\|crosshairs}}')=_, Zeds._pageName=Zed;
	where=ZedLoot.Codename="~~blueprint_smelt_iron_ore~~";		where=ZedLoot.Codename="blueprint_smelt_iron_ore_outpost";
	\|format=table		\|format=table
	}}		}}
Line 118:		Line 118:
	ScavengeJobRewards.JobCodename = ScavengeRooms.Codename		ScavengeJobRewards.JobCodename = ScavengeRooms.Codename
	\| fields=Locations._pageName=Location		\| fields=Locations._pageName=Location
	\| where=ScavengeJobRewards.Codename='~~blueprint_smelt_iron_ore~~' AND Location != "city"		\| where=ScavengeJobRewards.Codename='blueprint_smelt_iron_ore_outpost' AND Location != "city"
	\| format=table		\| format=table
	}}		}}
Line 132:		Line 132:
	BuildingBlueprintList.BuildingCodename=Buildings.Codename		BuildingBlueprintList.BuildingCodename=Buildings.Codename
	\| fields=ItemBlueprints._pageName=Recipe, IF(Buildings.Name='', 'Stronghold', Buildings._pageName)=Building		\| fields=ItemBlueprints._pageName=Recipe, IF(Buildings.Name='', 'Stronghold', Buildings._pageName)=Building
	\| where=BlueprintItems.Codename="~~blueprint_smelt_iron_ore~~"		\| where=BlueprintItems.Codename="blueprint_smelt_iron_ore_outpost"
	}}		}}

Line 141:		Line 141:
	\|join on=R.JobCodename=J.Codename		\|join on=R.JobCodename=J.Codename
	\|fields=CONCAT('[[',J._pageName,'\|',J.Name,']]')=Job, J.Location, J.Type, R.Qty		\|fields=CONCAT('[[',J._pageName,'\|',J.Name,']]')=Job, J.Location, J.Type, R.Qty
	\|where=R.Codename="~~blueprint_smelt_iron_ore~~"		\|where=R.Codename="blueprint_smelt_iron_ore_outpost"
	\|format=table		\|format=table
	\|headers=show		\|headers=show
Line 149:		Line 149:
	{{ItemBlueprints		{{ItemBlueprints
	\| Name=Smelt Iron Ore		\| Name=Smelt Iron Ore
	\| Codename=~~blueprint_smelt_iron_ore~~		\| Codename=blueprint_smelt_iron_ore_outpost
	\| ItemType=~~blueprint_furnace~~		\| ItemType=blueprint_misc
	\| Type=~~FurnaceBlueprint~~		\| Type=MiscBlueprints
	\| WaitTime=undefined		\| WaitTime=undefined
	\| AutoUnlock=false		\| AutoUnlock=false
Line 158:		Line 158:
	}}		}}
	{{BlueprintItems		{{BlueprintItems
	\| BlueprintCodename=~~blueprint_smelt_iron_ore~~		\| BlueprintCodename=blueprint_smelt_iron_ore_outpost
	\| Codename=iron_ore		\| Codename=iron_ore
	\| Qty = 2		\| Qty = 1
	\| TakeItem = Yes		\| TakeItem = Yes
	}}{{BlueprintRewards		}}{{BlueprintRewards
	\| BlueprintCodename=~~blueprint_smelt_iron_ore~~		\| BlueprintCodename=blueprint_smelt_iron_ore_outpost
	\| Codename=iron_bar		\| Codename=iron_bar
	\| Qty=1		\| Qty=1
	}}<!-- ZC_CP_Autogen_End -->		}}<!-- ZC_CP_Autogen_End -->

127.0.0.1 at 20:10, 5 August 2025

2025-08-05T20:10:19Z

← Older revision		Revision as of 20:10, 5 August 2025
Line 1:		Line 1:
	<noinclude>{{~~MiscBlueprints~~\| Codename=~~blueprint_smelt_iron_ore_outpost~~		<noinclude>{{FurnaceBlueprint\| Codename=blueprint_smelt_iron_ore
	}}		}}
	</noinclude>		</noinclude>
Line 10:		Line 10:
	\|join on=BI.Codename=I.Codename		\|join on=BI.Codename=I.Codename
	\|fields=CONCAT('https://www.zed.city/items/', I.Codename, '.png')=Image,I._pageName=Resource, BI.Qty		\|fields=CONCAT('https://www.zed.city/items/', I.Codename, '.png')=Image,I._pageName=Resource, BI.Qty
	\|where=BI.BlueprintCodename="~~blueprint_smelt_iron_ore_outpost~~"		\|where=BI.BlueprintCodename="blueprint_smelt_iron_ore"
	\|format=table		\|format=table
	}}		}}
Line 19:		Line 19:
	\|join on=BI.Codename=I.Codename		\|join on=BI.Codename=I.Codename
	\|fields=CONCAT('https://www.zed.city/items/', I.Codename, '.png')=Image,I._pageName=Resource, BI.Qty		\|fields=CONCAT('https://www.zed.city/items/', I.Codename, '.png')=Image,I._pageName=Resource, BI.Qty
	\|where=BI.BlueprintCodename="~~blueprint_smelt_iron_ore_outpost~~"		\|where=BI.BlueprintCodename="blueprint_smelt_iron_ore"
	\|format=table		\|format=table
	}}		}}
Line 25:		Line 25:

	<noinclude>{{Items		<noinclude>{{Items
	\| Codename=~~blueprint_smelt_iron_ore_outpost~~		\| Codename=blueprint_smelt_iron_ore
	\| Type=~~MiscBlueprints~~		\| Type=FurnaceBlueprint
	}}		}}

Line 52:		Line 52:
	\| join on=StatusEffectLink.Codename=PlayerEffects.Codename		\| join on=StatusEffectLink.Codename=PlayerEffects.Codename
	\| fields=PlayerEffects.Name, PlayerEffects.Description, StatusEffectLink.Duration=Duration (seconds)		\| fields=PlayerEffects.Name, PlayerEffects.Description, StatusEffectLink.Duration=Duration (seconds)
	\| where=StatusEffectLink.LinkCodename="~~blueprint_smelt_iron_ore_outpost~~"		\| where=StatusEffectLink.LinkCodename="blueprint_smelt_iron_ore"
	\| format=table		\| format=table
	\| default=No extra effects		\| default=No extra effects
Line 65:		Line 65:
	\| join on=ItemBlueprints.Codename = BlueprintRewards.BlueprintCodename, BuildingBlueprintList.Codename = ItemBlueprints.ItemType, BuildingBlueprintList.BuildingCodename = Buildings.Codename		\| join on=ItemBlueprints.Codename = BlueprintRewards.BlueprintCodename, BuildingBlueprintList.Codename = ItemBlueprints.ItemType, BuildingBlueprintList.BuildingCodename = Buildings.Codename
	\| fields=ItemBlueprints._pageName = Blueprint, Buildings._pageName = Building		\| fields=ItemBlueprints._pageName = Blueprint, Buildings._pageName = Building
	\| where=BlueprintRewards.Codename = "~~blueprint_smelt_iron_ore_outpost~~"		\| where=BlueprintRewards.Codename = "blueprint_smelt_iron_ore"
	\| format=table		\| format=table
	\| default=Not craftable in stronghold		\| default=Not craftable in stronghold
Line 75:		Line 75:
	\|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,'%')=Drop Rate, R.Qty		\|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
	\|where=R.Codename="~~blueprint_smelt_iron_ore_outpost~~" AND J.Location="city"		\|where=R.Codename="blueprint_smelt_iron_ore" AND J.Location="city"
	\|format=table		\|format=table
	\|headers=show		\|headers=show
Line 87:		Line 87:
	\|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,'%')=Drop Rate, R.Qty		\|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
	\|where=R.Codename="~~blueprint_smelt_iron_ore_outpost~~"		\|where=R.Codename="blueprint_smelt_iron_ore"
	\|format=table		\|format=table
	\|headers=show		\|headers=show
Line 101:		Line 101:
	LootTableLink.LinkCodename=Zeds.Codename;		LootTableLink.LinkCodename=Zeds.Codename;
	fields=CONCAT('{{FA\|crosshairs}}')=_, Zeds._pageName=Zed;		fields=CONCAT('{{FA\|crosshairs}}')=_, Zeds._pageName=Zed;
	where=LootTableItem.Codename="~~blueprint_smelt_iron_ore_outpost~~" AND LootTableLink.LinkType="Zeds";		where=LootTableItem.Codename="blueprint_smelt_iron_ore" AND LootTableLink.LinkType="Zeds";
	\|tables=ZedLoot,Zeds;		\|tables=ZedLoot,Zeds;
	join on=ZedLoot.ZedCodename=Zeds.Codename;		join on=ZedLoot.ZedCodename=Zeds.Codename;
	fields=CONCAT('{{FA\|crosshairs}}')=_, Zeds._pageName=Zed;		fields=CONCAT('{{FA\|crosshairs}}')=_, Zeds._pageName=Zed;
	where=ZedLoot.Codename="~~blueprint_smelt_iron_ore_outpost~~";		where=ZedLoot.Codename="blueprint_smelt_iron_ore";
	\|format=table		\|format=table
	}}		}}
Line 118:		Line 118:
	ScavengeJobRewards.JobCodename = ScavengeRooms.Codename		ScavengeJobRewards.JobCodename = ScavengeRooms.Codename
	\| fields=Locations._pageName=Location		\| fields=Locations._pageName=Location
	\| where=ScavengeJobRewards.Codename='~~blueprint_smelt_iron_ore_outpost~~' AND Location != "city"		\| where=ScavengeJobRewards.Codename='blueprint_smelt_iron_ore' AND Location != "city"
	\| format=table		\| format=table
	}}		}}
Line 132:		Line 132:
	BuildingBlueprintList.BuildingCodename=Buildings.Codename		BuildingBlueprintList.BuildingCodename=Buildings.Codename
	\| fields=ItemBlueprints._pageName=Recipe, IF(Buildings.Name='', 'Stronghold', Buildings._pageName)=Building		\| fields=ItemBlueprints._pageName=Recipe, IF(Buildings.Name='', 'Stronghold', Buildings._pageName)=Building
	\| where=BlueprintItems.Codename="~~blueprint_smelt_iron_ore_outpost~~"		\| where=BlueprintItems.Codename="blueprint_smelt_iron_ore"
	}}		}}

Line 141:		Line 141:
	\|join on=R.JobCodename=J.Codename		\|join on=R.JobCodename=J.Codename
	\|fields=CONCAT('[[',J._pageName,'\|',J.Name,']]')=Job, J.Location, J.Type, R.Qty		\|fields=CONCAT('[[',J._pageName,'\|',J.Name,']]')=Job, J.Location, J.Type, R.Qty
	\|where=R.Codename="~~blueprint_smelt_iron_ore_outpost~~"		\|where=R.Codename="blueprint_smelt_iron_ore"
	\|format=table		\|format=table
	\|headers=show		\|headers=show
Line 149:		Line 149:
	{{ItemBlueprints		{{ItemBlueprints
	\| Name=Smelt Iron Ore		\| Name=Smelt Iron Ore
	\| Codename=~~blueprint_smelt_iron_ore_outpost~~		\| Codename=blueprint_smelt_iron_ore
	\| ItemType=~~blueprint_misc~~		\| ItemType=blueprint_furnace
	\| Type=~~MiscBlueprints~~		\| Type=FurnaceBlueprint
	\| WaitTime=undefined		\| WaitTime=undefined
	\| AutoUnlock=false		\| AutoUnlock=false
Line 158:		Line 158:
	}}		}}
	{{BlueprintItems		{{BlueprintItems
	\| BlueprintCodename=~~blueprint_smelt_iron_ore_outpost~~		\| BlueprintCodename=blueprint_smelt_iron_ore
	\| Codename=iron_ore		\| Codename=iron_ore
	\| Qty = 1		\| Qty = 2
	\| TakeItem = Yes		\| TakeItem = Yes
	}}{{BlueprintRewards		}}{{BlueprintRewards
	\| BlueprintCodename=~~blueprint_smelt_iron_ore_outpost~~		\| BlueprintCodename=blueprint_smelt_iron_ore
	\| Codename=iron_bar		\| Codename=iron_bar
	\| Qty=1		\| Qty=1
	}}<!-- ZC_CP_Autogen_End -->		}}<!-- ZC_CP_Autogen_End -->

127.0.0.1 at 01:21, 31 July 2025

2025-07-31T01:21:25Z

← Older revision		Revision as of 01:21, 31 July 2025
Line 1:		Line 1:
	<noinclude>{{~~FurnaceBlueprint~~\| Codename=~~blueprint_smelt_iron_ore~~		<noinclude>{{MiscBlueprints\| Codename=blueprint_smelt_iron_ore_outpost
	}}		}}
	</noinclude>		</noinclude>
Line 10:		Line 10:
	\|join on=BI.Codename=I.Codename		\|join on=BI.Codename=I.Codename
	\|fields=CONCAT('https://www.zed.city/items/', I.Codename, '.png')=Image,I._pageName=Resource, BI.Qty		\|fields=CONCAT('https://www.zed.city/items/', I.Codename, '.png')=Image,I._pageName=Resource, BI.Qty
	\|where=BI.BlueprintCodename="~~blueprint_smelt_iron_ore~~"		\|where=BI.BlueprintCodename="blueprint_smelt_iron_ore_outpost"
	\|format=table		\|format=table
	}}		}}
Line 19:		Line 19:
	\|join on=BI.Codename=I.Codename		\|join on=BI.Codename=I.Codename
	\|fields=CONCAT('https://www.zed.city/items/', I.Codename, '.png')=Image,I._pageName=Resource, BI.Qty		\|fields=CONCAT('https://www.zed.city/items/', I.Codename, '.png')=Image,I._pageName=Resource, BI.Qty
	\|where=BI.BlueprintCodename="~~blueprint_smelt_iron_ore~~"		\|where=BI.BlueprintCodename="blueprint_smelt_iron_ore_outpost"
	\|format=table		\|format=table
	}}		}}
Line 25:		Line 25:

	<noinclude>{{Items		<noinclude>{{Items
	\| Codename=~~blueprint_smelt_iron_ore~~		\| Codename=blueprint_smelt_iron_ore_outpost
	\| Type=~~FurnaceBlueprint~~		\| Type=MiscBlueprints
	}}		}}

Line 52:		Line 52:
	\| join on=StatusEffectLink.Codename=PlayerEffects.Codename		\| join on=StatusEffectLink.Codename=PlayerEffects.Codename
	\| fields=PlayerEffects.Name, PlayerEffects.Description, StatusEffectLink.Duration=Duration (seconds)		\| fields=PlayerEffects.Name, PlayerEffects.Description, StatusEffectLink.Duration=Duration (seconds)
	\| where=StatusEffectLink.LinkCodename="~~blueprint_smelt_iron_ore~~"		\| where=StatusEffectLink.LinkCodename="blueprint_smelt_iron_ore_outpost"
	\| format=table		\| format=table
	\| default=No extra effects		\| default=No extra effects
Line 65:		Line 65:
	\| join on=ItemBlueprints.Codename = BlueprintRewards.BlueprintCodename, BuildingBlueprintList.Codename = ItemBlueprints.ItemType, BuildingBlueprintList.BuildingCodename = Buildings.Codename		\| join on=ItemBlueprints.Codename = BlueprintRewards.BlueprintCodename, BuildingBlueprintList.Codename = ItemBlueprints.ItemType, BuildingBlueprintList.BuildingCodename = Buildings.Codename
	\| fields=ItemBlueprints._pageName = Blueprint, Buildings._pageName = Building		\| fields=ItemBlueprints._pageName = Blueprint, Buildings._pageName = Building
	\| where=BlueprintRewards.Codename = "~~blueprint_smelt_iron_ore~~"		\| where=BlueprintRewards.Codename = "blueprint_smelt_iron_ore_outpost"
	\| format=table		\| format=table
	\| default=Not craftable in stronghold		\| default=Not craftable in stronghold
Line 75:		Line 75:
	\|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,'%')=Drop Rate, R.Qty		\|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
	\|where=R.Codename="~~blueprint_smelt_iron_ore~~" AND J.Location="city"		\|where=R.Codename="blueprint_smelt_iron_ore_outpost" AND J.Location="city"
	\|format=table		\|format=table
	\|headers=show		\|headers=show
Line 87:		Line 87:
	\|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,'%')=Drop Rate, R.Qty		\|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
	\|where=R.Codename="~~blueprint_smelt_iron_ore~~"		\|where=R.Codename="blueprint_smelt_iron_ore_outpost"
	\|format=table		\|format=table
	\|headers=show		\|headers=show
Line 101:		Line 101:
	LootTableLink.LinkCodename=Zeds.Codename;		LootTableLink.LinkCodename=Zeds.Codename;
	fields=CONCAT('{{FA\|crosshairs}}')=_, Zeds._pageName=Zed;		fields=CONCAT('{{FA\|crosshairs}}')=_, Zeds._pageName=Zed;
	where=LootTableItem.Codename="~~blueprint_smelt_iron_ore~~" AND LootTableLink.LinkType="Zeds";		where=LootTableItem.Codename="blueprint_smelt_iron_ore_outpost" AND LootTableLink.LinkType="Zeds";
	\|tables=ZedLoot,Zeds;		\|tables=ZedLoot,Zeds;
	join on=ZedLoot.ZedCodename=Zeds.Codename;		join on=ZedLoot.ZedCodename=Zeds.Codename;
	fields=CONCAT('{{FA\|crosshairs}}')=_, Zeds._pageName=Zed;		fields=CONCAT('{{FA\|crosshairs}}')=_, Zeds._pageName=Zed;
	where=ZedLoot.Codename="~~blueprint_smelt_iron_ore~~";		where=ZedLoot.Codename="blueprint_smelt_iron_ore_outpost";
	\|format=table		\|format=table
	}}		}}
Line 118:		Line 118:
	ScavengeJobRewards.JobCodename = ScavengeRooms.Codename		ScavengeJobRewards.JobCodename = ScavengeRooms.Codename
	\| fields=Locations._pageName=Location		\| fields=Locations._pageName=Location
	\| where=ScavengeJobRewards.Codename='~~blueprint_smelt_iron_ore~~' AND Location != "city"		\| where=ScavengeJobRewards.Codename='blueprint_smelt_iron_ore_outpost' AND Location != "city"
	\| format=table		\| format=table
	}}		}}
Line 132:		Line 132:
	BuildingBlueprintList.BuildingCodename=Buildings.Codename		BuildingBlueprintList.BuildingCodename=Buildings.Codename
	\| fields=ItemBlueprints._pageName=Recipe, IF(Buildings.Name='', 'Stronghold', Buildings._pageName)=Building		\| fields=ItemBlueprints._pageName=Recipe, IF(Buildings.Name='', 'Stronghold', Buildings._pageName)=Building
	\| where=BlueprintItems.Codename="~~blueprint_smelt_iron_ore~~"		\| where=BlueprintItems.Codename="blueprint_smelt_iron_ore_outpost"
	}}		}}

Line 141:		Line 141:
	\|join on=R.JobCodename=J.Codename		\|join on=R.JobCodename=J.Codename
	\|fields=CONCAT('[[',J._pageName,'\|',J.Name,']]')=Job, J.Location, J.Type, R.Qty		\|fields=CONCAT('[[',J._pageName,'\|',J.Name,']]')=Job, J.Location, J.Type, R.Qty
	\|where=R.Codename="~~blueprint_smelt_iron_ore~~"		\|where=R.Codename="blueprint_smelt_iron_ore_outpost"
	\|format=table		\|format=table
	\|headers=show		\|headers=show
Line 149:		Line 149:
	{{ItemBlueprints		{{ItemBlueprints
	\| Name=Smelt Iron Ore		\| Name=Smelt Iron Ore
	\| Codename=~~blueprint_smelt_iron_ore~~		\| Codename=blueprint_smelt_iron_ore_outpost
	\| ItemType=~~blueprint_furnace~~		\| ItemType=blueprint_misc
	\| Type=~~FurnaceBlueprint~~		\| Type=MiscBlueprints
	\| WaitTime=undefined		\| WaitTime=undefined
	\| AutoUnlock=false		\| AutoUnlock=false
Line 158:		Line 158:
	}}		}}
	{{BlueprintItems		{{BlueprintItems
	\| BlueprintCodename=~~blueprint_smelt_iron_ore~~		\| BlueprintCodename=blueprint_smelt_iron_ore_outpost
	\| Codename=iron_ore		\| Codename=iron_ore
	\| Qty = 2		\| Qty = 1
	\| TakeItem = Yes		\| TakeItem = Yes
	}}{{BlueprintRewards		}}{{BlueprintRewards
	\| BlueprintCodename=~~blueprint_smelt_iron_ore~~		\| BlueprintCodename=blueprint_smelt_iron_ore_outpost
	\| Codename=iron_bar		\| Codename=iron_bar
	\| Qty=1		\| Qty=1
	}}<!-- ZC_CP_Autogen_End -->		}}<!-- ZC_CP_Autogen_End -->

127.0.0.1 at 01:20, 31 July 2025

2025-07-31T01:20:35Z

← Older revision		Revision as of 01:20, 31 July 2025
Line 1:		Line 1:
	<noinclude>{{~~MiscBlueprints~~\| Codename=~~blueprint_smelt_iron_ore_outpost~~		<noinclude>{{FurnaceBlueprint\| Codename=blueprint_smelt_iron_ore
	}}		}}
	</noinclude>		</noinclude>
Line 10:		Line 10:
	\|join on=BI.Codename=I.Codename		\|join on=BI.Codename=I.Codename
	\|fields=CONCAT('https://www.zed.city/items/', I.Codename, '.png')=Image,I._pageName=Resource, BI.Qty		\|fields=CONCAT('https://www.zed.city/items/', I.Codename, '.png')=Image,I._pageName=Resource, BI.Qty
	\|where=BI.BlueprintCodename="~~blueprint_smelt_iron_ore_outpost~~"		\|where=BI.BlueprintCodename="blueprint_smelt_iron_ore"
	\|format=table		\|format=table
	}}		}}
Line 19:		Line 19:
	\|join on=BI.Codename=I.Codename		\|join on=BI.Codename=I.Codename
	\|fields=CONCAT('https://www.zed.city/items/', I.Codename, '.png')=Image,I._pageName=Resource, BI.Qty		\|fields=CONCAT('https://www.zed.city/items/', I.Codename, '.png')=Image,I._pageName=Resource, BI.Qty
	\|where=BI.BlueprintCodename="~~blueprint_smelt_iron_ore_outpost~~"		\|where=BI.BlueprintCodename="blueprint_smelt_iron_ore"
	\|format=table		\|format=table
	}}		}}
Line 25:		Line 25:

	<noinclude>{{Items		<noinclude>{{Items
	\| Codename=~~blueprint_smelt_iron_ore_outpost~~		\| Codename=blueprint_smelt_iron_ore
	\| Type=~~MiscBlueprints~~		\| Type=FurnaceBlueprint
	}}		}}

Line 52:		Line 52:
	\| join on=StatusEffectLink.Codename=PlayerEffects.Codename		\| join on=StatusEffectLink.Codename=PlayerEffects.Codename
	\| fields=PlayerEffects.Name, PlayerEffects.Description, StatusEffectLink.Duration=Duration (seconds)		\| fields=PlayerEffects.Name, PlayerEffects.Description, StatusEffectLink.Duration=Duration (seconds)
	\| where=StatusEffectLink.LinkCodename="~~blueprint_smelt_iron_ore_outpost~~"		\| where=StatusEffectLink.LinkCodename="blueprint_smelt_iron_ore"
	\| format=table		\| format=table
	\| default=No extra effects		\| default=No extra effects
Line 65:		Line 65:
	\| join on=ItemBlueprints.Codename = BlueprintRewards.BlueprintCodename, BuildingBlueprintList.Codename = ItemBlueprints.ItemType, BuildingBlueprintList.BuildingCodename = Buildings.Codename		\| join on=ItemBlueprints.Codename = BlueprintRewards.BlueprintCodename, BuildingBlueprintList.Codename = ItemBlueprints.ItemType, BuildingBlueprintList.BuildingCodename = Buildings.Codename
	\| fields=ItemBlueprints._pageName = Blueprint, Buildings._pageName = Building		\| fields=ItemBlueprints._pageName = Blueprint, Buildings._pageName = Building
	\| where=BlueprintRewards.Codename = "~~blueprint_smelt_iron_ore_outpost~~"		\| where=BlueprintRewards.Codename = "blueprint_smelt_iron_ore"
	\| format=table		\| format=table
	\| default=Not craftable in stronghold		\| default=Not craftable in stronghold
Line 75:		Line 75:
	\|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,'%')=Drop Rate, R.Qty		\|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
	\|where=R.Codename="~~blueprint_smelt_iron_ore_outpost~~" AND J.Location="city"		\|where=R.Codename="blueprint_smelt_iron_ore" AND J.Location="city"
	\|format=table		\|format=table
	\|headers=show		\|headers=show
Line 87:		Line 87:
	\|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,'%')=Drop Rate, R.Qty		\|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
	\|where=R.Codename="~~blueprint_smelt_iron_ore_outpost~~"		\|where=R.Codename="blueprint_smelt_iron_ore"
	\|format=table		\|format=table
	\|headers=show		\|headers=show
Line 101:		Line 101:
	LootTableLink.LinkCodename=Zeds.Codename;		LootTableLink.LinkCodename=Zeds.Codename;
	fields=CONCAT('{{FA\|crosshairs}}')=_, Zeds._pageName=Zed;		fields=CONCAT('{{FA\|crosshairs}}')=_, Zeds._pageName=Zed;
	where=LootTableItem.Codename="~~blueprint_smelt_iron_ore_outpost~~" AND LootTableLink.LinkType="Zeds";		where=LootTableItem.Codename="blueprint_smelt_iron_ore" AND LootTableLink.LinkType="Zeds";
	\|tables=ZedLoot,Zeds;		\|tables=ZedLoot,Zeds;
	join on=ZedLoot.ZedCodename=Zeds.Codename;		join on=ZedLoot.ZedCodename=Zeds.Codename;
	fields=CONCAT('{{FA\|crosshairs}}')=_, Zeds._pageName=Zed;		fields=CONCAT('{{FA\|crosshairs}}')=_, Zeds._pageName=Zed;
	where=ZedLoot.Codename="~~blueprint_smelt_iron_ore_outpost~~";		where=ZedLoot.Codename="blueprint_smelt_iron_ore";
	\|format=table		\|format=table
	}}		}}
Line 118:		Line 118:
	ScavengeJobRewards.JobCodename = ScavengeRooms.Codename		ScavengeJobRewards.JobCodename = ScavengeRooms.Codename
	\| fields=Locations._pageName=Location		\| fields=Locations._pageName=Location
	\| where=ScavengeJobRewards.Codename='~~blueprint_smelt_iron_ore_outpost~~' AND Location != "city"		\| where=ScavengeJobRewards.Codename='blueprint_smelt_iron_ore' AND Location != "city"
	\| format=table		\| format=table
	}}		}}
Line 132:		Line 132:
	BuildingBlueprintList.BuildingCodename=Buildings.Codename		BuildingBlueprintList.BuildingCodename=Buildings.Codename
	\| fields=ItemBlueprints._pageName=Recipe, IF(Buildings.Name='', 'Stronghold', Buildings._pageName)=Building		\| fields=ItemBlueprints._pageName=Recipe, IF(Buildings.Name='', 'Stronghold', Buildings._pageName)=Building
	\| where=BlueprintItems.Codename="~~blueprint_smelt_iron_ore_outpost~~"		\| where=BlueprintItems.Codename="blueprint_smelt_iron_ore"
	}}		}}

Line 141:		Line 141:
	\|join on=R.JobCodename=J.Codename		\|join on=R.JobCodename=J.Codename
	\|fields=CONCAT('[[',J._pageName,'\|',J.Name,']]')=Job, J.Location, J.Type, R.Qty		\|fields=CONCAT('[[',J._pageName,'\|',J.Name,']]')=Job, J.Location, J.Type, R.Qty
	\|where=R.Codename="~~blueprint_smelt_iron_ore_outpost~~"		\|where=R.Codename="blueprint_smelt_iron_ore"
	\|format=table		\|format=table
	\|headers=show		\|headers=show
Line 149:		Line 149:
	{{ItemBlueprints		{{ItemBlueprints
	\| Name=Smelt Iron Ore		\| Name=Smelt Iron Ore
	\| Codename=~~blueprint_smelt_iron_ore_outpost~~		\| Codename=blueprint_smelt_iron_ore
	\| ItemType=~~blueprint_misc~~		\| ItemType=blueprint_furnace
	\| Type=~~MiscBlueprints~~		\| Type=FurnaceBlueprint
	\| WaitTime=undefined		\| WaitTime=undefined
	\| AutoUnlock=false		\| AutoUnlock=false
Line 158:		Line 158:
	}}		}}
	{{BlueprintItems		{{BlueprintItems
	\| BlueprintCodename=~~blueprint_smelt_iron_ore_outpost~~		\| BlueprintCodename=blueprint_smelt_iron_ore
	\| Codename=iron_ore		\| Codename=iron_ore
	\| Qty = 1		\| Qty = 2
	\| TakeItem = Yes		\| TakeItem = Yes
	}}{{BlueprintRewards		}}{{BlueprintRewards
	\| BlueprintCodename=~~blueprint_smelt_iron_ore_outpost~~		\| BlueprintCodename=blueprint_smelt_iron_ore
	\| Codename=iron_bar		\| Codename=iron_bar
	\| Qty=1		\| Qty=1
	}}<!-- ZC_CP_Autogen_End -->		}}<!-- ZC_CP_Autogen_End -->