Template:Belle By Map Query: Difference between revisions

From Victory Belles Community Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 7: Line 7:
|-  
|-  
{{#cargo_query:
{{#cargo_query:
tables=JOINBelleMap, MAINMap
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
|where=JOINBelleMap.TXT_BelleName = "{{#replace:{{{SearchTerm|}}}|'|\'}}"
|where=MAINBelle.TXT_CharName = "{{#replace:{{{SearchTerm|}}}|'|\'}}"
|join on=JOINBelleMap.TXT_MapName = MAINMap.TXT_MapName
|join on=MAINMap.TXT_BOIList HOLDS MAINBelle.TXT_ID
|format=template
|format=template
|template=Template:VestureMap
|template=Template:VestureMap

Revision as of 19:38, 17 July 2023

This is the 'Belle By Map Query' template. It should be called via the Form:Belle By Map Query form.