Template:Testpage: Difference between revisions
From Heroes of Might and Magic: Olden Era Official Wiki
No edit summary |
No edit summary |
||
| Line 18: | Line 18: | ||
{{#cargo_query: | |||
tables = Building=B, | tables = Building=B, | ||
Translation=building_t | Translation=building_t | ||
| Line 26: | Line 26: | ||
AND building_t.language = 'en' | AND building_t.language = 'en' | ||
|fields = B.id =id, | |fields = B.id = id, | ||
building_t.name = name, | building_t.name = name, | ||
building_t.description = description, | building_t.description = description, | ||
B.faction =faction, | B.faction = faction, | ||
B.icon =icon, | B.icon = icon, | ||
B.prereqs__full =prereqs, | B.prereqs__full = prereqs, | ||
<!-- B.gold_cost = gold cost, | |||
B.wood_cost =wood cost, | B.wood_cost = wood cost, | ||
B.ore_cost =ore cost, | B.ore_cost = ore cost, | ||
B.crystals_cost =crystals cost, | B.crystals_cost = crystals cost, | ||
B.gemstones_cost =gemstones cost, | B.gemstones_cost = gemstones cost, | ||
B.mercury_cost =mercury cost, | B.mercury_cost = mercury cost, | ||
B.dust_cost =dust cost, | B.dust_cost = dust cost, | ||
B.graal_cost =graal cost, | B.graal_cost = graal cost, | ||
B.units_hire_sid =units hire sid, | B.units_hire_sid = units hire sid, | ||
B.units_weekly =units weekly, | B.units_weekly = units weekly, --> | ||
|format = Table | |format = Table | ||
Revision as of 00:26, 1 June 2026
 |
Artifact Merchant |
| Requirements: Marketplace | |
| Cost | Effect |
2500  Gold5  Wood5  Ore |
Allows artifacts to be traded. |
| id | name | description | faction | icon | prereqs |
|---|---|---|---|---|---|
| unfrozen_Build_Artifact_Market_L1 | Artifact Merchant | Allows artifacts to be traded. | unfrozen | U_build_Artifact_Market | Build_Market_L1 |
| unfrozen_Build_Bank_L1 | Bank | Produces 1000 Gold daily. | unfrozen | U_build_Bank | Build_Main_L2 |
| unfrozen_Build_Endless_Library_L1 | Great Library | Grants +2 Knowledge to any visiting hero. | unfrozen | U_build_Endless_Library | |
| unfrozen_Build_Frigid_Firmament_L1 | Firmament's Abyss | Building a Mage Guild in this city unlocks all spells of the corresponding tier. This city’s dwellings produce +100% units. | unfrozen | U_build_Frigid_Firmament | |
| unfrozen_Build_Magic_Guild_L1 | Mage Guild | Unlocks 7 random tier-1 spells in the Magic Observatory and the ability to spend dust to upgrade tier-1 spells or unlock additional ones. When heroes visit the city, all unlocked tier-1 spells are added to their Spellbook. | unfrozen | U_build_Mage_Guild_Level_1 | |
| unfrozen_Build_Magic_Guild_L2 | Mage Guild II | Unlocks 6 random tier-2 spells in the Magic Observatory and the ability to spend dust to upgrade tier-2 spells or unlock additional ones. When heroes visit the city, all unlocked tier-1–2 spells are added to their Spellbook. | unfrozen | U_build_Mage_Guild_Level_2 | Build_Magic_Guild_L1 |
| unfrozen_Build_Magic_Guild_L3 | Mage Guild III | Unlocks 5 random tier-3 spells in the Magic Observatory and the ability to spend dust to upgrade tier-3 spells or unlock additional ones. When heroes visit the city, all unlocked tier-1–3 spells are added to their Spellbook. | unfrozen | U_build_Mage_Guild_Level_3 | Build_Magic_Guild_L2 |
| unfrozen_Build_Magic_Guild_L4 | Mage Guild IV | Unlocks 4 random tier-4 spells in the Magic Observatory and the ability to spend dust to upgrade tier-4 spells or unlock additional ones. When heroes visit the city, all unlocked tier-1–4 spells are added to their Spellbook. | unfrozen | U_build_Mage_Guild_Level_4 | Build_Magic_Guild_L3 |
| unfrozen_Build_Main_L1 | Abyssal Remnant | Grants the kingdom 500 Gold, Law points, and Astrology points daily. +1 hero cap. | unfrozen | U_build_Main_Level_1 | |
| unfrozen_Build_Main_L2 | Abyssal Remnant II | Grants the kingdom 750 Gold, Law points, and Astrology points daily. Allows the owner to pick one level-1 economy upgrade. | unfrozen | U_build_Main_Level_2 | Build_Main_L1 |
| unfrozen_Build_Main_L3 | Abyssal Remnant III | Grants the kingdom 1000 Gold, Law points, and Astrology points daily. Allows the owner to pick one level-2 economy upgrade. | unfrozen | U_build_Main_Level_3 | Build_Main_L2 |
| unfrozen_Build_Market_L1 | Marketplace | Allows resources to be traded. | unfrozen | U_build_resource_Market | Build_Tavern_L1 |
| unfrozen_Build_Portal_Summoning_L1 | Involuntary Summons | Once per week, allows the owner to recruit creatures from any one external dwelling under their control — even if there are no available units on the global map itself. | unfrozen | U_build_Portal_Summoning | Build_Magic_Guild_L3 |
| unfrozen_Build_Resource_Depot_L1 | Resource Depot | Produces 1 Mercury daily. | unfrozen | U_build_Resource_Depot | Build_Market_L1 • Build_Bank_L1 |
| unfrozen_Build_Resource_Depot_level_2_L1 | Alchemic Depot | Produces 5 Alchemical Dust daily. | unfrozen | U_build_Resource_Depot_2 | Build_Resource_Depot_L1 |
| unfrozen_Build_Tavern_L1 | Tavern | Allows the hiring of new heroes. | unfrozen | U_build_tavern | |
| unfrozen_Build_Tier_1_L1 | Lesser Summoning Rite | Allows the recruitment of Ra’Shoth. | unfrozen | U_build_Tier_1_Level_1 | |
| unfrozen_Build_Tier_1_L2 | Lesser Summoning Rite II | Allows the recruitment of Stinging Ra’Shoth and Ferocious Ra’Shoth. | unfrozen | U_build_Tier_1_Level_2 | Build_Tier_1_L1 |
| unfrozen_Build_Tier_2_L1 | Cultist Spire | Allows the recruitment of Cultists. | unfrozen | U_build_Tier_2_Level_1 | |
| unfrozen_Build_Tier_2_L2 | Cultist Spire II | Allows the recruitment of Binders and Votaries. | unfrozen | U_build_Tier_2_Level_2 | Build_Tier_2_L1 |
| unfrozen_Build_Tier_3_L1 | Aga'Shoth Stables | Allows the recruitment of Aga’Shoth Riders. | unfrozen | U_build_Tier_3_Level_1 | Build_Tier_2_L1 |
| unfrozen_Build_Tier_3_L2 | Aga'Shoth Stables II | Allows the recruitment of Aga’Shoth Tamers and Aga’Shoth Matha. | unfrozen | U_build_Tier_3_Level_2 | Build_Tier_3_L1 |
| unfrozen_Build_Tier_4_L1 | Disturbing Summoning Rite | Allows the recruitment of Grand Shoth. | unfrozen | U_build_Tier_4_Level_1 | Build_Tier_1_L1 • Build_Magic_Guild_L1 |
| unfrozen_Build_Tier_4_L2 | Disturbing Summoning Rite II | Allows the recruitment of Unspeakable Shoth and Unthinkable Shoth. | unfrozen | U_build_Tier_4_Level_2 | Build_Tier_4_L1 |
| unfrozen_Build_Tier_5_L1 | House of Chains | Allows the recruitment of Concubi. | unfrozen | U_build_Tier_5_Level_1 | Build_Tier_3_L1 |
| unfrozen_Build_Tier_5_L2 | House of Chains II | Allows the recruitment of Mistresses of Chains and Bewitchers. | unfrozen | U_build_Tier_5_Level_2 | Build_Tier_5_L1 |
| unfrozen_Build_Tier_6_L1 | Bloated Mansion | Allows the recruitment of Arbitrators. | unfrozen | U_build_Tier_6_Level_1 | Build_Tier_5_L1 |
| unfrozen_Build_Tier_6_L2 | Bloated Mansion II | Allows the recruitment of Rift Arbitrators and Bloated Arbitrators. | unfrozen | U_build_Tier_6_Level_2 | Build_Tier_6_L1 |
| unfrozen_Build_Tier_7_L1 | Eerie Summoning Rite | Allows the recruitment of Abyssal Envoys. | unfrozen | U_build_Tier_7_Level_1 | Build_Tier_3_L1 • Build_Tier_4_L1 |
| unfrozen_Build_Tier_7_L2 | Eerie Summoning Rite II | Allows the recruitment of Abyssal Overseers and Abyssal Executors. | unfrozen | U_build_Tier_7_Level_2 | Build_Tier_7_L1 |
| unfrozen_Build_Treasury_L1 | Treasury | Produces 2000 Gold daily. | unfrozen | U_build_Treasury | Build_Bank_L1 • Build_Wall_L1 |
| unfrozen_Build_Wall_L1 | Fortifications | Provides walls during sieges. Allows the builder to pick one level-1 defensive upgrade. | unfrozen | U_build_Walls_level_1 | |
| unfrozen_Build_Wall_L2 | Fortifications II | Adds two towers to the battlements that shoot at attackers during sieges. Allows the builder to pick one level-2 defensive upgrade. City dwellings produce +50% units. | unfrozen | U_build_Walls_level_2 | Build_Wall_L1 |
| unfrozen_Build_Wall_L3 | Fortifications III | Adds one more grand tower to the battlements that shoots at attackers during sieges and spikes by the walls. Allows the builder to pick one level-3 defensive upgrade. City dwellings produce +100% units. | unfrozen | U_build_Walls_level_3 | Build_Wall_L2 |
-->
Test Query
| name |
|---|
| Marketplace |
unfrozen_Build_Market_L1
Query with results sent to sub-template
id: unfrozen_Build_Artifact_Market_L1
name: Artifact Merchant
Query to fetch Prereqs for a building
| id | name | description | icon | requirements |
|---|---|---|---|---|
| unfrozen_Build_Artifact_Market_L1 | Artifact Merchant | Allows artifacts to be traded. | U_build_Artifact_Market | Build_Market_L1 |
