Template:Belle By Map Query: Difference between revisions
Jump to navigation
Jump to search
(Created page with "<noinclude>This is the 'Belle By Map Query' template. It should be called via the Form:Belle By Map Query form. </noinclude> <includeonly> {| class=wikitable style=text-align:left width:65%" ! HQ Level !! Map Name |- {{#cargo_query: tables=JOINBelleMap, MAINMap |fields=MAINMap.INT_MapHQLevel=HQ Level, MAINMap.TXT_MapName=Map Name |where=JOINBelleMap.TXT_BelleName = "{{#replace:{{{SearchTerm|}}}|'|\'}}" |join on=JOINBelleMap.TXT_MapName = MAINMap.TXT_MapName |fo...") |
No edit summary |
||
| (7 intermediate revisions by the same user not shown) | |||
| Line 2: | Line 2: | ||
</noinclude> | </noinclude> | ||
<includeonly> | <includeonly> | ||
Note that these maps are merely where her Vestures can be found, and says nothing about what exact types of Vestures for her may appear on a given map. | |||
{| class=wikitable style=text-align:left width:65%" | {| class=wikitable style=text-align:left width:65%" | ||
! HQ Level !! Map Name | ! HQ Level !! Map Name !! Map Type !! Start !! End | ||
|- | |- | ||
{{#cargo_query: | {{#cargo_query: | ||
tables= | tables=MAINMap, MAINBelle | ||
|fields=MAINMap.INT_MapHQLevel=HQ Level, MAINMap.TXT_MapName=Map Name | |fields=MAINMap.INT_MapHQLevel=HQ Level, MAINMap.TXT_MapName=Map Name, MAINMap.TXT_MapType=MapType, MAINMap.DATE_IRLStart=IRLStart, MAINMap.DATE_IRLEnd=IRLEnd | ||
|where= | |where=MAINBelle.TXT_CharName = "{{#replace:{{{SearchTerm|}}}|'|\'}}" | ||
|join on= | |join on=MAINMap.TXT_BOIList HOLDS MAINBelle.TXT_ID | ||
|format=template | |format=template | ||
|template=Template:VestureMap | |template=Template:VestureMap | ||
|named args=yes | |named args=yes | ||
|order by=MAINMap.TXT_MapType ASC, MAINMap.INT_MapHQLevel ASC | |||
}} | }} | ||
|}</includeonly> | |}</includeonly> | ||
Latest revision as of 19:43, 17 July 2023
This is the 'Belle By Map Query' template. It should be called via the Form:Belle By Map Query form.