Craft Brick - Revision history

127.0.0.1 at 14:39, 11 October 2025

2025-10-11T14:39:16Z

← Older revision		Revision as of 14:39, 11 October 2025
Line 1:		Line 1:
	<noinclude>{{MiscBlueprints\| Codename=~~craft_brick~~		<noinclude>{{MiscBlueprints\| Codename=craft_brick_dirty
	}}		}}
	</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="~~craft_brick~~"		\|where=BI.BlueprintCodename="craft_brick_dirty"
	\|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="~~craft_brick~~"		\|where=BI.BlueprintCodename="craft_brick_dirty"
	\|format=table		\|format=table
	}}		}}
Line 25:		Line 25:

	<noinclude>{{Items		<noinclude>{{Items
	\| Codename=~~craft_brick~~		\| Codename=craft_brick_dirty
	\| Type=MiscBlueprints		\| 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="~~craft_brick~~"		\| where=StatusEffectLink.LinkCodename="craft_brick_dirty"
	\| 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 = "~~craft_brick~~"		\| where=BlueprintRewards.Codename = "craft_brick_dirty"
	\| 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="~~craft_brick~~" AND J.Location="city"		\|where=R.Codename="craft_brick_dirty" 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="~~craft_brick~~"		\|where=R.Codename="craft_brick_dirty"
	\|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="~~craft_brick~~" AND LootTableLink.LinkType="Zeds";		where=LootTableItem.Codename="craft_brick_dirty" 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="~~craft_brick~~";		where=ZedLoot.Codename="craft_brick_dirty";
	\|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='~~craft_brick~~' AND Location != "city"		\| where=ScavengeJobRewards.Codename='craft_brick_dirty' 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="~~craft_brick~~"		\| where=BlueprintItems.Codename="craft_brick_dirty"
	}}		}}

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="~~craft_brick~~"		\|where=R.Codename="craft_brick_dirty"
	\|format=table		\|format=table
	\|headers=show		\|headers=show
Line 150:		Line 150:
	{{ItemBlueprints		{{ItemBlueprints
	\| Name=Craft Brick		\| Name=Craft Brick
	\| Codename=~~craft_brick~~		\| Codename=craft_brick_dirty
	\| ItemType=blueprint_misc		\| ItemType=blueprint_misc
	\| Type=MiscBlueprints		\| Type=MiscBlueprints
Line 159:		Line 159:
	}}		}}
	{{BlueprintItems		{{BlueprintItems
	\| BlueprintCodename=~~craft_brick~~		\| BlueprintCodename=craft_brick_dirty
	\| Codename=cement		\| Codename=cement
	\| Qty = 1		\| Qty = 1
	\| TakeItem = Yes		\| TakeItem = Yes
	}}{{BlueprintItems		}}{{BlueprintItems
	\| BlueprintCodename=~~craft_brick~~		\| BlueprintCodename=craft_brick_dirty
	\| Codename=~~water~~		\| Codename=dirty_water
	\| Qty = 1		\| Qty = 1
	\| TakeItem = Yes		\| TakeItem = Yes
	}}{{BlueprintRewards		}}{{BlueprintRewards
	\| BlueprintCodename=~~craft_brick~~		\| BlueprintCodename=craft_brick_dirty
	\| Codename=brick		\| Codename=brick
	\| Qty=1		\| Qty=1
	}}<!-- ZC_CP_Autogen_End -->		}}<!-- ZC_CP_Autogen_End -->

127.0.0.1 at 14:39, 11 October 2025

2025-10-11T14:39:15Z

← Older revision		Revision as of 14:39, 11 October 2025
Line 1:		Line 1:
	<noinclude>{{MiscBlueprints\| Codename=~~craft_brick_dirty~~		<noinclude>{{MiscBlueprints\| Codename=craft_brick
	}}		}}
	</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="~~craft_brick_dirty~~"		\|where=BI.BlueprintCodename="craft_brick"
	\|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="~~craft_brick_dirty~~"		\|where=BI.BlueprintCodename="craft_brick"
	\|format=table		\|format=table
	}}		}}
Line 25:		Line 25:

	<noinclude>{{Items		<noinclude>{{Items
	\| Codename=~~craft_brick_dirty~~		\| Codename=craft_brick
	\| Type=MiscBlueprints		\| 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="~~craft_brick_dirty~~"		\| where=StatusEffectLink.LinkCodename="craft_brick"
	\| 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 = "~~craft_brick_dirty~~"		\| where=BlueprintRewards.Codename = "craft_brick"
	\| 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="~~craft_brick_dirty~~" AND J.Location="city"		\|where=R.Codename="craft_brick" 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="~~craft_brick_dirty~~"		\|where=R.Codename="craft_brick"
	\|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="~~craft_brick_dirty~~" AND LootTableLink.LinkType="Zeds";		where=LootTableItem.Codename="craft_brick" 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="~~craft_brick_dirty~~";		where=ZedLoot.Codename="craft_brick";
	\|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='~~craft_brick_dirty~~' AND Location != "city"		\| where=ScavengeJobRewards.Codename='craft_brick' 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="~~craft_brick_dirty~~"		\| where=BlueprintItems.Codename="craft_brick"
	}}		}}

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="~~craft_brick_dirty~~"		\|where=R.Codename="craft_brick"
	\|format=table		\|format=table
	\|headers=show		\|headers=show
Line 150:		Line 150:
	{{ItemBlueprints		{{ItemBlueprints
	\| Name=Craft Brick		\| Name=Craft Brick
	\| Codename=~~craft_brick_dirty~~		\| Codename=craft_brick
	\| ItemType=blueprint_misc		\| ItemType=blueprint_misc
	\| Type=MiscBlueprints		\| Type=MiscBlueprints
Line 159:		Line 159:
	}}		}}
	{{BlueprintItems		{{BlueprintItems
	\| BlueprintCodename=~~craft_brick_dirty~~		\| BlueprintCodename=craft_brick
	\| Codename=cement		\| Codename=cement
	\| Qty = 1		\| Qty = 1
	\| TakeItem = Yes		\| TakeItem = Yes
	}}{{BlueprintItems		}}{{BlueprintItems
	\| BlueprintCodename=~~craft_brick_dirty~~		\| BlueprintCodename=craft_brick
	\| Codename=~~dirty_water~~		\| Codename=water
	\| Qty = 1		\| Qty = 1
	\| TakeItem = Yes		\| TakeItem = Yes
	}}{{BlueprintRewards		}}{{BlueprintRewards
	\| BlueprintCodename=~~craft_brick_dirty~~		\| BlueprintCodename=craft_brick
	\| Codename=brick		\| Codename=brick
	\| 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:10Z

← Older revision		Revision as of 17:53, 22 August 2025
Line 1:		Line 1:
	<noinclude>{{MiscBlueprints\| Codename=~~craft_brick~~		<noinclude>{{MiscBlueprints\| Codename=craft_brick_dirty
	}}		}}
	</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="~~craft_brick~~"		\|where=BI.BlueprintCodename="craft_brick_dirty"
	\|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="~~craft_brick~~"		\|where=BI.BlueprintCodename="craft_brick_dirty"
	\|format=table		\|format=table
	}}		}}
Line 25:		Line 25:

	<noinclude>{{Items		<noinclude>{{Items
	\| Codename=~~craft_brick~~		\| Codename=craft_brick_dirty
	\| Type=MiscBlueprints		\| 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="~~craft_brick~~"		\| where=StatusEffectLink.LinkCodename="craft_brick_dirty"
	\| 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 = "~~craft_brick~~"		\| where=BlueprintRewards.Codename = "craft_brick_dirty"
	\| 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="~~craft_brick~~" AND J.Location="city"		\|where=R.Codename="craft_brick_dirty" 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="~~craft_brick~~"		\|where=R.Codename="craft_brick_dirty"
	\|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="~~craft_brick~~" AND LootTableLink.LinkType="Zeds";		where=LootTableItem.Codename="craft_brick_dirty" 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="~~craft_brick~~";		where=ZedLoot.Codename="craft_brick_dirty";
	\|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='~~craft_brick~~' AND Location != "city"		\| where=ScavengeJobRewards.Codename='craft_brick_dirty' 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="~~craft_brick~~"		\| where=BlueprintItems.Codename="craft_brick_dirty"
	}}		}}

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="~~craft_brick~~"		\|where=R.Codename="craft_brick_dirty"
	\|format=table		\|format=table
	\|headers=show		\|headers=show
Line 150:		Line 150:
	{{ItemBlueprints		{{ItemBlueprints
	\| Name=Craft Brick		\| Name=Craft Brick
	\| Codename=~~craft_brick~~		\| Codename=craft_brick_dirty
	\| ItemType=blueprint_misc		\| ItemType=blueprint_misc
	\| Type=MiscBlueprints		\| Type=MiscBlueprints
Line 159:		Line 159:
	}}		}}
	{{BlueprintItems		{{BlueprintItems
	\| BlueprintCodename=~~craft_brick~~		\| BlueprintCodename=craft_brick_dirty
	\| Codename=cement		\| Codename=cement
	\| Qty = 1		\| Qty = 1
	\| TakeItem = Yes		\| TakeItem = Yes
	}}{{BlueprintItems		}}{{BlueprintItems
	\| BlueprintCodename=~~craft_brick~~		\| BlueprintCodename=craft_brick_dirty
	\| Codename=~~water~~		\| Codename=dirty_water
	\| Qty = 1		\| Qty = 1
	\| TakeItem = Yes		\| TakeItem = Yes
	}}{{BlueprintRewards		}}{{BlueprintRewards
	\| BlueprintCodename=~~craft_brick~~		\| BlueprintCodename=craft_brick_dirty
	\| Codename=brick		\| Codename=brick
	\| 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:09Z

← Older revision		Revision as of 17:53, 22 August 2025
Line 1:		Line 1:
	<noinclude>{{MiscBlueprints\| Codename=~~craft_brick_dirty~~		<noinclude>{{MiscBlueprints\| Codename=craft_brick
	}}		}}
	</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="~~craft_brick_dirty~~"		\|where=BI.BlueprintCodename="craft_brick"
	\|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="~~craft_brick_dirty~~"		\|where=BI.BlueprintCodename="craft_brick"
	\|format=table		\|format=table
	}}		}}
Line 25:		Line 25:

	<noinclude>{{Items		<noinclude>{{Items
	\| Codename=~~craft_brick_dirty~~		\| Codename=craft_brick
	\| Type=MiscBlueprints		\| 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="~~craft_brick_dirty~~"		\| where=StatusEffectLink.LinkCodename="craft_brick"
	\| 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 = "~~craft_brick_dirty~~"		\| where=BlueprintRewards.Codename = "craft_brick"
	\| 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="~~craft_brick_dirty~~" AND J.Location="city"		\|where=R.Codename="craft_brick" 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="~~craft_brick_dirty~~"		\|where=R.Codename="craft_brick"
	\|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="~~craft_brick_dirty~~" AND LootTableLink.LinkType="Zeds";		where=LootTableItem.Codename="craft_brick" 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="~~craft_brick_dirty~~";		where=ZedLoot.Codename="craft_brick";
	\|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='~~craft_brick_dirty~~' AND Location != "city"		\| where=ScavengeJobRewards.Codename='craft_brick' 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="~~craft_brick_dirty~~"		\| where=BlueprintItems.Codename="craft_brick"
	}}		}}

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="~~craft_brick_dirty~~"		\|where=R.Codename="craft_brick"
	\|format=table		\|format=table
	\|headers=show		\|headers=show
Line 150:		Line 150:
	{{ItemBlueprints		{{ItemBlueprints
	\| Name=Craft Brick		\| Name=Craft Brick
	\| Codename=~~craft_brick_dirty~~		\| Codename=craft_brick
	\| ItemType=blueprint_misc		\| ItemType=blueprint_misc
	\| Type=MiscBlueprints		\| Type=MiscBlueprints
Line 159:		Line 159:
	}}		}}
	{{BlueprintItems		{{BlueprintItems
	\| BlueprintCodename=~~craft_brick_dirty~~		\| BlueprintCodename=craft_brick
	\| Codename=cement		\| Codename=cement
	\| Qty = 1		\| Qty = 1
	\| TakeItem = Yes		\| TakeItem = Yes
	}}{{BlueprintItems		}}{{BlueprintItems
	\| BlueprintCodename=~~craft_brick_dirty~~		\| BlueprintCodename=craft_brick
	\| Codename=~~dirty_water~~		\| Codename=water
	\| Qty = 1		\| Qty = 1
	\| TakeItem = Yes		\| TakeItem = Yes
	}}{{BlueprintRewards		}}{{BlueprintRewards
	\| BlueprintCodename=~~craft_brick_dirty~~		\| BlueprintCodename=craft_brick
	\| Codename=brick		\| Codename=brick
	\| 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:32Z

← Older revision		Revision as of 13:29, 14 August 2025
Line 1:		Line 1:
	<noinclude>{{MiscBlueprints\| Codename=~~craft_brick~~		<noinclude>{{MiscBlueprints\| Codename=craft_brick_dirty
	}}		}}
	</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="~~craft_brick~~"		\|where=BI.BlueprintCodename="craft_brick_dirty"
	\|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="~~craft_brick~~"		\|where=BI.BlueprintCodename="craft_brick_dirty"
	\|format=table		\|format=table
	}}		}}
Line 25:		Line 25:

	<noinclude>{{Items		<noinclude>{{Items
	\| Codename=~~craft_brick~~		\| Codename=craft_brick_dirty
	\| Type=MiscBlueprints		\| 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="~~craft_brick~~"		\| where=StatusEffectLink.LinkCodename="craft_brick_dirty"
	\| 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 = "~~craft_brick~~"		\| where=BlueprintRewards.Codename = "craft_brick_dirty"
	\| 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="~~craft_brick~~" AND J.Location="city"		\|where=R.Codename="craft_brick_dirty" 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="~~craft_brick~~"		\|where=R.Codename="craft_brick_dirty"
	\|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="~~craft_brick~~" AND LootTableLink.LinkType="Zeds";		where=LootTableItem.Codename="craft_brick_dirty" 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="~~craft_brick~~";		where=ZedLoot.Codename="craft_brick_dirty";
	\|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='~~craft_brick~~' AND Location != "city"		\| where=ScavengeJobRewards.Codename='craft_brick_dirty' 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="~~craft_brick~~"		\| where=BlueprintItems.Codename="craft_brick_dirty"
	}}		}}

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="~~craft_brick~~"		\|where=R.Codename="craft_brick_dirty"
	\|format=table		\|format=table
	\|headers=show		\|headers=show
Line 150:		Line 150:
	{{ItemBlueprints		{{ItemBlueprints
	\| Name=Craft Brick		\| Name=Craft Brick
	\| Codename=~~craft_brick~~		\| Codename=craft_brick_dirty
	\| ItemType=blueprint_misc		\| ItemType=blueprint_misc
	\| Type=MiscBlueprints		\| Type=MiscBlueprints
Line 159:		Line 159:
	}}		}}
	{{BlueprintItems		{{BlueprintItems
	\| BlueprintCodename=~~craft_brick~~		\| BlueprintCodename=craft_brick_dirty
	\| Codename=cement		\| Codename=cement
	\| Qty = 1		\| Qty = 1
	\| TakeItem = Yes		\| TakeItem = Yes
	}}{{BlueprintItems		}}{{BlueprintItems
	\| BlueprintCodename=~~craft_brick~~		\| BlueprintCodename=craft_brick_dirty
	\| Codename=~~water~~		\| Codename=dirty_water
	\| Qty = 1		\| Qty = 1
	\| TakeItem = Yes		\| TakeItem = Yes
	}}{{BlueprintRewards		}}{{BlueprintRewards
	\| BlueprintCodename=~~craft_brick~~		\| BlueprintCodename=craft_brick_dirty
	\| Codename=brick		\| Codename=brick
	\| 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:32Z

← Older revision		Revision as of 13:29, 14 August 2025
Line 1:		Line 1:
	<noinclude>{{MiscBlueprints\| Codename=~~craft_brick_dirty~~		<noinclude>{{MiscBlueprints\| Codename=craft_brick
	}}		}}
	</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="~~craft_brick_dirty~~"		\|where=BI.BlueprintCodename="craft_brick"
	\|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="~~craft_brick_dirty~~"		\|where=BI.BlueprintCodename="craft_brick"
	\|format=table		\|format=table
	}}		}}
Line 25:		Line 25:

	<noinclude>{{Items		<noinclude>{{Items
	\| Codename=~~craft_brick_dirty~~		\| Codename=craft_brick
	\| Type=MiscBlueprints		\| 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="~~craft_brick_dirty~~"		\| where=StatusEffectLink.LinkCodename="craft_brick"
	\| 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 = "~~craft_brick_dirty~~"		\| where=BlueprintRewards.Codename = "craft_brick"
	\| 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="~~craft_brick_dirty~~" AND J.Location="city"		\|where=R.Codename="craft_brick" 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="~~craft_brick_dirty~~"		\|where=R.Codename="craft_brick"
	\|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="~~craft_brick_dirty~~" AND LootTableLink.LinkType="Zeds";		where=LootTableItem.Codename="craft_brick" 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="~~craft_brick_dirty~~";		where=ZedLoot.Codename="craft_brick";
	\|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='~~craft_brick_dirty~~' AND Location != "city"		\| where=ScavengeJobRewards.Codename='craft_brick' 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="~~craft_brick_dirty~~"		\| where=BlueprintItems.Codename="craft_brick"
	}}		}}

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="~~craft_brick_dirty~~"		\|where=R.Codename="craft_brick"
	\|format=table		\|format=table
	\|headers=show		\|headers=show
Line 149:		Line 150:
	{{ItemBlueprints		{{ItemBlueprints
	\| Name=Craft Brick		\| Name=Craft Brick
	\| Codename=~~craft_brick_dirty~~		\| Codename=craft_brick
	\| ItemType=blueprint_misc		\| ItemType=blueprint_misc
	\| Type=MiscBlueprints		\| Type=MiscBlueprints
Line 158:		Line 159:
	}}		}}
	{{BlueprintItems		{{BlueprintItems
	\| BlueprintCodename=~~craft_brick_dirty~~		\| BlueprintCodename=craft_brick
	\| Codename=cement		\| Codename=cement
	\| Qty = 1		\| Qty = 1
	\| TakeItem = Yes		\| TakeItem = Yes
	}}{{BlueprintItems		}}{{BlueprintItems
	\| BlueprintCodename=~~craft_brick_dirty~~		\| BlueprintCodename=craft_brick
	\| Codename=~~dirty_water~~		\| Codename=water
	\| Qty = 1		\| Qty = 1
	\| TakeItem = Yes		\| TakeItem = Yes
	}}{{BlueprintRewards		}}{{BlueprintRewards
	\| BlueprintCodename=~~craft_brick_dirty~~		\| BlueprintCodename=craft_brick
	\| Codename=brick		\| Codename=brick
	\| 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:14Z

← Older revision		Revision as of 20:12, 5 August 2025
Line 1:		Line 1:
	<noinclude>{{MiscBlueprints\| Codename=~~craft_brick~~		<noinclude>{{MiscBlueprints\| Codename=craft_brick_dirty
	}}		}}
	</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="~~craft_brick~~"		\|where=BI.BlueprintCodename="craft_brick_dirty"
	\|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="~~craft_brick~~"		\|where=BI.BlueprintCodename="craft_brick_dirty"
	\|format=table		\|format=table
	}}		}}
Line 25:		Line 25:

	<noinclude>{{Items		<noinclude>{{Items
	\| Codename=~~craft_brick~~		\| Codename=craft_brick_dirty
	\| Type=MiscBlueprints		\| 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="~~craft_brick~~"		\| where=StatusEffectLink.LinkCodename="craft_brick_dirty"
	\| 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 = "~~craft_brick~~"		\| where=BlueprintRewards.Codename = "craft_brick_dirty"
	\| 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="~~craft_brick~~" AND J.Location="city"		\|where=R.Codename="craft_brick_dirty" 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="~~craft_brick~~"		\|where=R.Codename="craft_brick_dirty"
	\|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="~~craft_brick~~" AND LootTableLink.LinkType="Zeds";		where=LootTableItem.Codename="craft_brick_dirty" 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="~~craft_brick~~";		where=ZedLoot.Codename="craft_brick_dirty";
	\|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='~~craft_brick~~' AND Location != "city"		\| where=ScavengeJobRewards.Codename='craft_brick_dirty' 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="~~craft_brick~~"		\| where=BlueprintItems.Codename="craft_brick_dirty"
	}}		}}

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="~~craft_brick~~"		\|where=R.Codename="craft_brick_dirty"
	\|format=table		\|format=table
	\|headers=show		\|headers=show
Line 149:		Line 149:
	{{ItemBlueprints		{{ItemBlueprints
	\| Name=Craft Brick		\| Name=Craft Brick
	\| Codename=~~craft_brick~~		\| Codename=craft_brick_dirty
	\| ItemType=blueprint_misc		\| ItemType=blueprint_misc
	\| Type=MiscBlueprints		\| Type=MiscBlueprints
Line 158:		Line 158:
	}}		}}
	{{BlueprintItems		{{BlueprintItems
	\| BlueprintCodename=~~craft_brick~~		\| BlueprintCodename=craft_brick_dirty
	\| Codename=cement		\| Codename=cement
	\| Qty = 1		\| Qty = 1
	\| TakeItem = Yes		\| TakeItem = Yes
	}}{{BlueprintItems		}}{{BlueprintItems
	\| BlueprintCodename=~~craft_brick~~		\| BlueprintCodename=craft_brick_dirty
	\| Codename=~~water~~		\| Codename=dirty_water
	\| Qty = 1		\| Qty = 1
	\| TakeItem = Yes		\| TakeItem = Yes
	}}{{BlueprintRewards		}}{{BlueprintRewards
	\| BlueprintCodename=~~craft_brick~~		\| BlueprintCodename=craft_brick_dirty
	\| Codename=brick		\| Codename=brick
	\| 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:14Z

← Older revision		Revision as of 20:12, 5 August 2025
Line 1:		Line 1:
	<noinclude>{{MiscBlueprints\| Codename=~~craft_brick_dirty~~		<noinclude>{{MiscBlueprints\| Codename=craft_brick
	}}		}}
	</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="~~craft_brick_dirty~~"		\|where=BI.BlueprintCodename="craft_brick"
	\|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="~~craft_brick_dirty~~"		\|where=BI.BlueprintCodename="craft_brick"
	\|format=table		\|format=table
	}}		}}
Line 25:		Line 25:

	<noinclude>{{Items		<noinclude>{{Items
	\| Codename=~~craft_brick_dirty~~		\| Codename=craft_brick
	\| Type=MiscBlueprints		\| 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="~~craft_brick_dirty~~"		\| where=StatusEffectLink.LinkCodename="craft_brick"
	\| 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 = "~~craft_brick_dirty~~"		\| where=BlueprintRewards.Codename = "craft_brick"
	\| 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="~~craft_brick_dirty~~" AND J.Location="city"		\|where=R.Codename="craft_brick" 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="~~craft_brick_dirty~~"		\|where=R.Codename="craft_brick"
	\|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="~~craft_brick_dirty~~" AND LootTableLink.LinkType="Zeds";		where=LootTableItem.Codename="craft_brick" 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="~~craft_brick_dirty~~";		where=ZedLoot.Codename="craft_brick";
	\|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='~~craft_brick_dirty~~' AND Location != "city"		\| where=ScavengeJobRewards.Codename='craft_brick' 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="~~craft_brick_dirty~~"		\| where=BlueprintItems.Codename="craft_brick"
	}}		}}

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="~~craft_brick_dirty~~"		\|where=R.Codename="craft_brick"
	\|format=table		\|format=table
	\|headers=show		\|headers=show
Line 149:		Line 149:
	{{ItemBlueprints		{{ItemBlueprints
	\| Name=Craft Brick		\| Name=Craft Brick
	\| Codename=~~craft_brick_dirty~~		\| Codename=craft_brick
	\| ItemType=blueprint_misc		\| ItemType=blueprint_misc
	\| Type=MiscBlueprints		\| Type=MiscBlueprints
Line 158:		Line 158:
	}}		}}
	{{BlueprintItems		{{BlueprintItems
	\| BlueprintCodename=~~craft_brick_dirty~~		\| BlueprintCodename=craft_brick
	\| Codename=cement		\| Codename=cement
	\| Qty = 1		\| Qty = 1
	\| TakeItem = Yes		\| TakeItem = Yes
	}}{{BlueprintItems		}}{{BlueprintItems
	\| BlueprintCodename=~~craft_brick_dirty~~		\| BlueprintCodename=craft_brick
	\| Codename=~~dirty_water~~		\| Codename=water
	\| Qty = 1		\| Qty = 1
	\| TakeItem = Yes		\| TakeItem = Yes
	}}{{BlueprintRewards		}}{{BlueprintRewards
	\| BlueprintCodename=~~craft_brick_dirty~~		\| BlueprintCodename=craft_brick
	\| Codename=brick		\| Codename=brick
	\| 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:27Z

← Older revision		Revision as of 01:21, 31 July 2025
Line 1:		Line 1:
	<noinclude>{{MiscBlueprints\| Codename=~~craft_brick~~		<noinclude>{{MiscBlueprints\| Codename=craft_brick_dirty
	}}		}}
	</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="~~craft_brick~~"		\|where=BI.BlueprintCodename="craft_brick_dirty"
	\|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="~~craft_brick~~"		\|where=BI.BlueprintCodename="craft_brick_dirty"
	\|format=table		\|format=table
	}}		}}
Line 25:		Line 25:

	<noinclude>{{Items		<noinclude>{{Items
	\| Codename=~~craft_brick~~		\| Codename=craft_brick_dirty
	\| Type=MiscBlueprints		\| 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="~~craft_brick~~"		\| where=StatusEffectLink.LinkCodename="craft_brick_dirty"
	\| 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 = "~~craft_brick~~"		\| where=BlueprintRewards.Codename = "craft_brick_dirty"
	\| 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="~~craft_brick~~" AND J.Location="city"		\|where=R.Codename="craft_brick_dirty" 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="~~craft_brick~~"		\|where=R.Codename="craft_brick_dirty"
	\|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="~~craft_brick~~" AND LootTableLink.LinkType="Zeds";		where=LootTableItem.Codename="craft_brick_dirty" 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="~~craft_brick~~";		where=ZedLoot.Codename="craft_brick_dirty";
	\|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='~~craft_brick~~' AND Location != "city"		\| where=ScavengeJobRewards.Codename='craft_brick_dirty' 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="~~craft_brick~~"		\| where=BlueprintItems.Codename="craft_brick_dirty"
	}}		}}

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="~~craft_brick~~"		\|where=R.Codename="craft_brick_dirty"
	\|format=table		\|format=table
	\|headers=show		\|headers=show
Line 149:		Line 149:
	{{ItemBlueprints		{{ItemBlueprints
	\| Name=Craft Brick		\| Name=Craft Brick
	\| Codename=~~craft_brick~~		\| Codename=craft_brick_dirty
	\| ItemType=blueprint_misc		\| ItemType=blueprint_misc
	\| Type=MiscBlueprints		\| Type=MiscBlueprints
Line 158:		Line 158:
	}}		}}
	{{BlueprintItems		{{BlueprintItems
	\| BlueprintCodename=~~craft_brick~~		\| BlueprintCodename=craft_brick_dirty
	\| Codename=cement		\| Codename=cement
	\| Qty = 1		\| Qty = 1
	\| TakeItem = Yes		\| TakeItem = Yes
	}}{{BlueprintItems		}}{{BlueprintItems
	\| BlueprintCodename=~~craft_brick~~		\| BlueprintCodename=craft_brick_dirty
	\| Codename=~~water~~		\| Codename=dirty_water
	\| Qty = 1		\| Qty = 1
	\| TakeItem = Yes		\| TakeItem = Yes
	}}{{BlueprintRewards		}}{{BlueprintRewards
	\| BlueprintCodename=~~craft_brick~~		\| BlueprintCodename=craft_brick_dirty
	\| Codename=brick		\| Codename=brick
	\| 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:26Z

← Older revision		Revision as of 01:21, 31 July 2025
Line 1:		Line 1:
	<noinclude>{{MiscBlueprints\| Codename=~~craft_brick_dirty~~		<noinclude>{{MiscBlueprints\| Codename=craft_brick
	}}		}}
	</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="~~craft_brick_dirty~~"		\|where=BI.BlueprintCodename="craft_brick"
	\|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="~~craft_brick_dirty~~"		\|where=BI.BlueprintCodename="craft_brick"
	\|format=table		\|format=table
	}}		}}
Line 25:		Line 25:

	<noinclude>{{Items		<noinclude>{{Items
	\| Codename=~~craft_brick_dirty~~		\| Codename=craft_brick
	\| Type=MiscBlueprints		\| 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="~~craft_brick_dirty~~"		\| where=StatusEffectLink.LinkCodename="craft_brick"
	\| 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 = "~~craft_brick_dirty~~"		\| where=BlueprintRewards.Codename = "craft_brick"
	\| 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="~~craft_brick_dirty~~" AND J.Location="city"		\|where=R.Codename="craft_brick" 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="~~craft_brick_dirty~~"		\|where=R.Codename="craft_brick"
	\|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="~~craft_brick_dirty~~" AND LootTableLink.LinkType="Zeds";		where=LootTableItem.Codename="craft_brick" 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="~~craft_brick_dirty~~";		where=ZedLoot.Codename="craft_brick";
	\|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='~~craft_brick_dirty~~' AND Location != "city"		\| where=ScavengeJobRewards.Codename='craft_brick' 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="~~craft_brick_dirty~~"		\| where=BlueprintItems.Codename="craft_brick"
	}}		}}

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="~~craft_brick_dirty~~"		\|where=R.Codename="craft_brick"
	\|format=table		\|format=table
	\|headers=show		\|headers=show
Line 149:		Line 149:
	{{ItemBlueprints		{{ItemBlueprints
	\| Name=Craft Brick		\| Name=Craft Brick
	\| Codename=~~craft_brick_dirty~~		\| Codename=craft_brick
	\| ItemType=blueprint_misc		\| ItemType=blueprint_misc
	\| Type=MiscBlueprints		\| Type=MiscBlueprints
Line 158:		Line 158:
	}}		}}
	{{BlueprintItems		{{BlueprintItems
	\| BlueprintCodename=~~craft_brick_dirty~~		\| BlueprintCodename=craft_brick
	\| Codename=cement		\| Codename=cement
	\| Qty = 1		\| Qty = 1
	\| TakeItem = Yes		\| TakeItem = Yes
	}}{{BlueprintItems		}}{{BlueprintItems
	\| BlueprintCodename=~~craft_brick_dirty~~		\| BlueprintCodename=craft_brick
	\| Codename=~~dirty_water~~		\| Codename=water
	\| Qty = 1		\| Qty = 1
	\| TakeItem = Yes		\| TakeItem = Yes
	}}{{BlueprintRewards		}}{{BlueprintRewards
	\| BlueprintCodename=~~craft_brick_dirty~~		\| BlueprintCodename=craft_brick
	\| Codename=brick		\| Codename=brick
	\| Qty=1		\| Qty=1
	}}<!-- ZC_CP_Autogen_End -->		}}<!-- ZC_CP_Autogen_End -->