E-Cola: Difference between revisions

Latest revision as of 23:21, 5 August 2025

Information

Attribute	Value
Name	e-Cola
Weight	1kg
Buy Value	N/A
Sell Value	N/A

Immediate Effects

Attribute	Value
Energy	25

Status Effects On Use

No extra effects

Produced by

Crafting

Not craftable in stronghold

Scavenges

There are no ways to scavenge for this item.

Hunts

There are no guaranteed hunting locations for this item.

Zeds

_	Zed
	Bloater
	Crawler
	Frenzied Bloater
	Frenzied Crawler
	Frenzied Spitter
	Frenzied Zombie
	Lurcher
	Raging Bloater
	Raging Crawler
	Raging Spitter
	Raging Zombie
	Spitter
	Undead Corporal
	Undead Soldier
	Undead Supervisor
	Undead Workman
	X-Bloater
	X-Spitter
	Zombie

Explore Locations

Location
Fuel Depot

@@ Line 1: / Line 1: @@
-<!-- ZC_CP_Autogen AUTOGENERATED DO NOT REMOVE THESE SECTION -->{{EnergyDrinks| Image = e_cola| Codename = ecola| EnergyBoost = 25| Cooldown = 7200| BuyPrice = n/a| SellPrice = n/a| Weight = 1kg| Desc = No information known
+<noinclude>{{EnergyDrinks| Image = ecola| Codename = ecola| EnergyBoost = 25| Cooldown = 7200| BuyPrice = N/A| SellPrice = N/A| Weight = 1kg
 }}
-{{Items
+</noinclude><noinclude>{{Items
 | Codename=ecola
 | Type=EnergyDrinks
 }}
-==Produced by==
+</noinclude>
+== Information ==
+{| class="cargoTable noMerge sortable jquery-tablesorter"
+! Attribute !! Value
+|-
+! Name || e-Cola
+|-
+! Weight || 1kg
+|-
+! Buy Value || N/A
+|-
+! Sell Value || N/A
+|}
-===Scavenges===
+== Immediate Effects ==
+{| class="cargoTable noMerge sortable jquery-tablesorter"
+! Attribute !! Value
+|-
+! Energy || 25
+    |}
+== Status Effects On Use ==
+{{#cargo_query:
+tables=StatusEffectLink,PlayerEffects
+| join on=StatusEffectLink.Codename=PlayerEffects.Codename
+| fields=PlayerEffects.Name, PlayerEffects.Description, StatusEffectLink.Duration=Duration (seconds)
+| where=StatusEffectLink.LinkCodename="ecola"
+| format=table
+| default=No extra effects
+}}
+== Produced by ==
+=== Crafting ===
+{{#cargo_query:
+tables=BlueprintRewards,ItemBlueprints,BuildingBlueprintList,Buildings
+| join on=ItemBlueprints.Codename = BlueprintRewards.BlueprintCodename, BuildingBlueprintList.Codename = ItemBlueprints.ItemType, BuildingBlueprintList.BuildingCodename = Buildings.Codename
+| fields=ItemBlueprints._pageName = Blueprint, Buildings._pageName = Building
+| where=BlueprintRewards.Codename = "ecola"
+| format=table
+| default=Not craftable in stronghold
+}}
+=== Scavenges ===
 {{#cargo_query:
 tables=ScavengeJobRewards=R,ScavengeJobs=J
 |join on=R.JobCodename=J.Codename
-|fields=CONCAT('[[',J._pageName,'|',J.Name,']]')=Job, CONCAT(UPPER(SUBSTRING(J.Location,1,1)), SUBSTRING(J.Location,2))=Location, CONCAT(R.Chance,'%')=Chance, R.Qty
+|fields=CONCAT('[[',J._pageName,'|',J.Name,']]')=Job, CONCAT(UPPER(SUBSTRING(J.Location,1,1)), SUBSTRING(J.Location,2))=Location, CONCAT(R.Chance,'%')=Drop Rate, R.Qty
-|where=R.Codename="ecola"
+|where=R.Codename="ecola" AND J.Location="city"
 |format=table
 |headers=show
@@ Line 19: / Line 63: @@
 }}
-===Hunts===
+=== Hunts ===
 {{#cargo_query:
 tables=HuntingJobRewards=R,HuntingJobs=J
 |join on=R.JobCodename=J.Codename
-|fields=CONCAT('[[',J._pageName,'|',J.Name,']]')=Job, CONCAT(UPPER(SUBSTRING(J.Location,1,1)), SUBSTRING(J.Location,2))=Location, CONCAT(R.Chance,'%')=Chance, R.Qty
+|fields=CONCAT('[[',J._pageName,'|',J.Name,']]')=Job, CONCAT(UPPER(SUBSTRING(J.Location,1,1)), SUBSTRING(J.Location,2))=Location, CONCAT(R.Chance,'%')=Drop Rate, R.Qty
 |where=R.Codename="ecola"
 |format=table
@@ Line 31: / Line 76: @@
 === Zeds ===
-{{#cargo_query:
-tables=ZedLoot,Zeds,HuntingJobNpcs,HuntingJobs
+{{#cargo_compound_query:
-|join on=ZedLoot.ZedCodename=Zeds.Codename,
+tables=LootTableItem,LootTableLink,Zeds,LootTable;
-Zeds.Codename=HuntingJobNpcs.Codename,
+join on=LootTableItem.LootTableCodename=LootTable.Codename,
-HuntingJobNpcs.JobCodename=HuntingJobs.Codename
+LootTable.Codename=LootTableLink.Codename,
-|fields=Zeds._pageName=Zed
+LootTableLink.LinkCodename=Zeds.Codename;
-|where=ZedLoot.Codename="ecola"
+fields=CONCAT('{{FA|crosshairs}}')=_, Zeds._pageName=Zed;
-|group by=Zed
+where=LootTableItem.Codename="ecola" AND LootTableLink.LinkType="Zeds";
+|tables=ZedLoot,Zeds;
+join on=ZedLoot.ZedCodename=Zeds.Codename;
+fields=CONCAT('{{FA|crosshairs}}')=_, Zeds._pageName=Zed;
+where=ZedLoot.Codename="ecola";
 |format=table
-|named args=yes
-|default=
 }}
+=== Explore Locations ===
 {{#cargo_query:
-tables=LootTable,LootTableItem,LootTableLink,Zeds,HuntingJobNpcs,HuntingJobs
+table=ScavengeJobRewards,ScavengeRooms,Locations
-|join on=LootTableItem.LootTableCodename=LootTable.Codename,
+| join on=ScavengeRooms.Location=Locations.Codename,
-LootTable.Codename=LootTableLink.Codename,
+ScavengeJobRewards.JobCodename = ScavengeRooms.Codename
-LootTableLink.LinkCodename=Zeds.Codename,
+| fields=Locations._pageName=Location
-Zeds.Codename=HuntingJobNpcs.Codename,
+| where=ScavengeJobRewards.Codename='ecola' AND Location != "city"
-HuntingJobNpcs.JobCodename=HuntingJobs.Codename
+| group by=Locations._pageName
-|fields=Zeds._pageName=Zed
+| format=table
-|where=ZedLoot.Codename="ecola"
-|group by=Zed
-|format=table
-|named args=yes
-|default=
 }}
-</table>
-==Consumed by==
-== Crafting Blueprints ==
+== Consumed by ==
+=== Crafting Blueprints ===
 {{#cargo_query:
 tables=BlueprintItems, ItemBlueprints, BuildingBlueprintList, Buildings
@@ Line 73: / Line 119: @@
-===Scavenges===
+=== Scavenges ===
 {{#cargo_query:
 tables=ScavengeJobItems=R,ScavengeJobs=J