E-Cola: Difference between revisions

Latest revision as of 13:00, 22 July 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
	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| Description = No information known
 }}
-{{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 30: / Line 75: @@
 }}
-==Zeds==
+=== Zeds ===
-<table class="cargoTable noMerge sortable jquery-tablesorter">
-<tr>
+{{#cargo_compound_query:
-  <th>Zed</th>
+tables=LootTableItem,LootTableLink,Zeds,LootTable;
-  <th>Area</th>
+join on=LootTableItem.LootTableCodename=LootTable.Codename,
-  <th>Level</th>
+LootTable.Codename=LootTableLink.Codename,
-  <th>Qty</th>
+LootTableLink.LinkCodename=Zeds.Codename;
-  <th>Chance</th>
+fields=CONCAT('{{FA|crosshairs}}')=_, Zeds._pageName=Zed;
-</tr>
+where=LootTableItem.Codename="ecola" AND LootTableLink.LinkType="Zeds";
-{{#cargo_query:
+|tables=ZedLoot,Zeds;
-tables=ZedLoot,Zeds,HuntingJobNpcs,HuntingJobs
+join on=ZedLoot.ZedCodename=Zeds.Codename;
-|join on=ZedLoot.ZedCodename=Zeds.Codename,
+fields=CONCAT('{{FA|crosshairs}}')=_, Zeds._pageName=Zed;
-Zeds.Codename=HuntingJobNpcs.Codename,
+where=ZedLoot.Codename="ecola";
-HuntingJobNpcs.JobCodename=HuntingJobs.Codename
+|format=table
-|fields=Zeds._pageName=Zed, HuntingJobs._pageName=Area, ZedLoot.Level, ZedLoot.Qty, Concat(ZedLoot.Chance,"%")=Chance
-|where=ZedLoot.Codename="ecola"
-|format=template
-|template=ZedLootRow
-|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
+| format=table
-|fields=Zeds._pageName=Zed, HuntingJobs._pageName=Area, LootTableLink.Level, LootTableItem.Qty, Concat(LootTableLink.Chance,"%")=Chance
-|where=LootTableItem.Codename="ecola"
-|format=template
-|template=ZedLootRow
-|named args=yes
-|default=
 }}
-</table>
-==Consumed by==
+== Consumed by ==
-== Crafting Blueprints ==
+=== Crafting Blueprints ===
 {{#cargo_query:
 tables=BlueprintItems, ItemBlueprints, BuildingBlueprintList, Buildings
@@ Line 81: / Line 118: @@
-===Scavenges===
+=== Scavenges ===
 {{#cargo_query:
 tables=ScavengeJobItems=R,ScavengeJobs=J