Template:Testpage: Difference between revisions
From Heroes of Might and Magic: Olden Era Official Wiki
No edit summary |
No edit summary |
||
| (14 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
<noinclude> | |||
<div style="display:flex;flex-wrap:wrap;margin-bottom:40px;"> | |||
{{FactionBuildingCargo | |||
|faction = dungeon | |||
|bldg_id = dungeon_Build_Treasury_L1 | |||
|note = Notenotenote | |||
}} | |||
{{FactionBuildingCargo | |||
|faction = dungeon | |||
|bldg_id = dungeon_Build_Artifact_Market_L1 | |||
|note = Notenotenote | |||
}} | |||
</div> | |||
<!-- <code><nowiki>{{FactionBuildingCargo | |||
|faction = dungeon | |||
|bldg_id = dungeon_Build_Artifact_Market_L1 | |||
|note = Notenotenote | |||
}}</nowiki></code> --> | |||
<!-- | |||
{{#cargo_query: | |||
tables = Building=B, | |||
Translation=building_t | |||
|join on = | |||
building_t.target_id = B.id | |||
|where = B.faction = 'dungeon' | |||
AND building_t.language = 'en' | |||
|fields = B.id = id, | |||
building_t.name = name, | |||
building_t.description = description, | |||
B.faction = faction, | |||
B.icon = icon, | |||
B.prereqs__full = prereqs | |||
<!-- B.gold_cost = gold cost, | |||
B.wood_cost = wood cost, | |||
B.ore_cost = ore cost, | |||
B.crystals_cost = crystals cost, | |||
B.gemstones_cost = gemstones cost, | |||
B.mercury_cost = mercury cost, | |||
B.dust_cost = dust cost, | |||
B.graal_cost = graal cost, | |||
B.units_hire_sid = units hire sid, | |||
B.units_weekly = units weekly, | |||
|format = Table | |||
|named args = yes | |||
}} </noinclude> | |||
--> | |||
<!-- | |||
Test Query | |||
{{#cargo_query: | |||
tables = Building=B, | |||
Translation=building_t | |||
|join on = | |||
building_t.target_id = B.id | |||
|where = B.faction = 'unfrozen' | |||
AND building_t.language = 'en' | |||
AND B.id = 'unfrozen_Build_Market_L1' | |||
|fields = building_t.name = name | |||
|format = table | |||
|named args = yes | |||
}} | |||
unfrozen_Build_Market_L1 | |||
Query with results sent to sub-template | |||
{{#cargo_query: | {{#cargo_query: | ||
tables = Building=B | tables = Building=B, | ||
Translation=building_t | Translation=building_t | ||
|join on = | |join on = | ||
building_t.target_id = B.id | building_t.target_id = B.id | ||
|where = B.faction = | |where = B.faction = 'unfrozen' | ||
AND building_t.language = 'en' | |||
AND B.id = 'unfrozen_Build_Artifact_Market_L1' | |||
|fields = B.id = id, | |||
building_t.name = name, | |||
B.icon = icon | |||
|format = template | |||
|template = BuildingNameDisplay | |||
|named args = yes | |||
}} | |||
Query to fetch Prereqs for a building | |||
{{#cargo_query: | |||
tables = Building=B, | |||
Translation=building_t | |||
|join on = | |||
building_t.target_id = B.id | |||
|where = B.faction = 'unfrozen' | |||
AND building_t.language = 'en' | |||
AND B.prereqs__full = 'Build_Market_L1' | |||
|order by = B.prereqs__full = 'Build_Market_L1' | |||
|fields = B.id = id, | |||
building_t.name = name, | |||
building_t.description = description, | |||
B.icon = icon, | |||
B.prereqs__full = requirements | |||
|format = table | |||
|named args = yes | |||
}} | |||
--> | |||
<!-- Default View | |||
{{#cargo_query: | |||
tables = Building=B, | |||
Translation=building_t | |||
|join on = | |||
building_t.target_id = B.id | |||
|where = B.faction = 'unfrozen' | |||
AND building_t.language = 'en' | AND building_t.language = 'en' | ||
| Line 41: | Line 163: | ||
|format = Table | |format = Table | ||
|named args = yes | |named args = yes | ||
}} | }} --> | ||
<!-- | |||
{{#cargo_query: | {{#cargo_query: | ||
| Line 73: | Line 194: | ||
|format = Table | |format = Table | ||
|named args = yes | |named args = yes | ||
}} | }} --> | ||
