Template:Testpage: Difference between revisions
From Heroes of Might and Magic: Olden Era Official Wiki
No edit summary |
No edit summary |
||
| (11 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
<noinclude> | <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: | |||
<!-- | |||
{{#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 = 'dungeon' | ||
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 | ||
|named args = yes | |named args = yes | ||
}} | }} </noinclude> | ||
--> | |||
<!-- | |||
Test Query | Test Query | ||
{{#cargo_query: | {{#cargo_query: | ||
| Line 38: | Line 65: | ||
|where = B.faction = 'unfrozen' | |where = B.faction = 'unfrozen' | ||
AND building_t.language = 'en' | AND building_t.language = 'en' | ||
AND B.id = ' | AND B.id = 'unfrozen_Build_Market_L1' | ||
|fields = | |fields = building_t.name = name | ||
|format = table | |format = table | ||
| Line 48: | Line 73: | ||
}} | }} | ||
unfrozen_Build_Market_L1 | |||
| Line 71: | Line 96: | ||
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: | {{#cargo_query: | ||
tables = Building=B, | tables = Building=B, | ||
| Line 117: | Line 163: | ||
|format = Table | |format = Table | ||
|named args = yes | |named args = yes | ||
}} | }} --> | ||
--> | |||
