Difference between revisions of "Template:MCFloorDisplay"
Jump to navigation
Jump to search
imported>Elaeagnifolia |
>Boblers (passing element field) |
||
| (48 intermediate revisions by one other user not shown) | |||
| Line 4: | Line 4: | ||
# Stat Node Counter | # Stat Node Counter | ||
| − | -->{{#vardefine:totalHpNodes|{{#cargo_query:tables=MCNodes|fields=COUNT(Id)|where=MC="{{#var:manaCircleName}}" AND Hierarchy="{{{1|}}}" AND ManaPieceType="10101"}}}}<!-- | + | -->{{#vardefine:totalHpNodes|{{#cargo_query:tables=MCNodes|fields=COUNT(Id)|where=MC="{{#var:manaCircleName}}" AND Hierarchy="{{{1|}}}" AND ManaPieceType="10101"|no html}}}}<!-- |
| − | -->{{#vardefine:totalStrNodes|{{#cargo_query:tables=MCNodes|fields=COUNT(Id)|where=MC="{{#var:manaCircleName}}" AND Hierarchy="{{{1|}}}" AND ManaPieceType="10102"}}}}<!-- | + | -->{{#vardefine:totalStrNodes|{{#cargo_query:tables=MCNodes|fields=COUNT(Id)|where=MC="{{#var:manaCircleName}}" AND Hierarchy="{{{1|}}}" AND ManaPieceType="10102"|no html}}}}<!-- |
| − | -->{{#vardefine:hpNodeCounter|0}}<!-- | + | -->{{#vardefine:totalHpStrNodes|{{#cargo_query:tables=MCNodes|fields=COUNT(Id)|where=MC="{{#var:manaCircleName}}" AND Hierarchy="{{{1|}}}" AND ManaPieceType="10103"|no html}}}}<!-- |
| − | -->{{#vardefine: | + | -->{{#vardefine:hpNodeCounter|{{#var:totalHpNodes}}}}<!-- |
| + | -->{{#vardefine:strNodeCounter|{{#var:totalStrNodes}}}}<!-- | ||
| + | -->{{#vardefine:hpStrNodeCounter|{{#var:totalHpStrNodes}}}}<!-- | ||
| + | -->{{#vardefine:eldwaterFloorTotal|0}}<!-- | ||
| + | -->{{#vardefine:matCounter|0}}<!-- | ||
| + | -->{{#vardefine:floorMaterials|}}<!-- | ||
| + | -->{{#vardefine:floor|{{{1|}}}}}<!-- | ||
### Template Display | ### Template Display | ||
--><div class="skill-section" style="margin:auto;justify-content:center"> | --><div class="skill-section" style="margin:auto;justify-content:center"> | ||
| − | {{# | + | {{#invoke:CargoQuery|main |
| − | |fields=MC,IsReleaseStory,ManaPieceType,NecessaryManaPoint,Hierarchy | + | |q?tables=MCNodes |
| − | |where=MC="{{#var:manaCircleName}}" AND Hierarchy="{{{1|}}}" | + | |q?fields=MC,IsReleaseStory,ManaPieceType,NecessaryManaPoint,Hierarchy |
| − | | | + | |q?where=MC="{{#var:manaCircleName}}" AND Hierarchy="{{{1|}}}" |
| − | + | |q?orderBy=No ASC | |
|template=MCNodeDisplay | |template=MCNodeDisplay | ||
| − | |||
}} | }} | ||
</div> | </div> | ||
| − | {{MCFloorOverviewDisplay|{{{1|}}}}}</includeonly> | + | {{MCFloorOverviewDisplay|{{{1|}}}|{{{element|}}}}}</includeonly> |