50,050
edits
Template:NewBellePage: Difference between revisions
Jump to navigation
Jump to search
Escaping page names with single quotes as apostrophes (there's like two right now...)
No edit summary |
(Escaping page names with single quotes as apostrophes (there's like two right now...)) |
||
| Line 20: | Line 20: | ||
tables=MAINBelle | tables=MAINBelle | ||
|fields=MAINBelle.TXT_NationName | |fields=MAINBelle.TXT_NationName | ||
|where=MAINBelle.TXT_CharName='{{PAGENAME}}' | |where=MAINBelle.TXT_CharName='{{#replace:{{PAGENAME}}|'|\'}}' | ||
|format=template | |format=template | ||
|template=Template:Country2nationality | |template=Template:Country2nationality | ||
| Line 39: | Line 39: | ||
tables=JOINBelleVesture, ITEMVesture | tables=JOINBelleVesture, ITEMVesture | ||
|fields=ITEMVesture.TXT_VestureType=Vesture Type, ITEMVesture.TXT_VestureName=Vesture Name, ITEMVesture.INT_XPBonus=XP Bonus, ITEMVesture.TXT_StatBonus1=Stat Bonus 1, ITEMVesture.TXT_StatBonus2=Stat Bonus 2 | |fields=ITEMVesture.TXT_VestureType=Vesture Type, ITEMVesture.TXT_VestureName=Vesture Name, ITEMVesture.INT_XPBonus=XP Bonus, ITEMVesture.TXT_StatBonus1=Stat Bonus 1, ITEMVesture.TXT_StatBonus2=Stat Bonus 2 | ||
|where=JOINBelleVesture.TXT_CharName = '{{PAGENAME}}' | |where=JOINBelleVesture.TXT_CharName = '{{#replace:{{PAGENAME}}|'|\'}}' | ||
|join on=JOINBelleVesture.TXT_VestureName=ITEMVesture.TXT_VestureName | |join on=JOINBelleVesture.TXT_VestureName=ITEMVesture.TXT_VestureName | ||
|format=template | |format=template | ||
| Line 60: | Line 60: | ||
tables=JOINBelleMap, MAINMap | tables=JOINBelleMap, MAINMap | ||
|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 = '{{PAGENAME}}' | |where=JOINBelleMap.TXT_BelleName = '{{#replace:{{PAGENAME}}|'|\'}}' | ||
|join on=JOINBelleMap.TXT_MapName = MAINMap.TXT_MapName | |join on=JOINBelleMap.TXT_MapName = MAINMap.TXT_MapName | ||
|format=template | |format=template | ||
| Line 115: | Line 115: | ||
tables=MISCTombstoneQuotes | tables=MISCTombstoneQuotes | ||
|fields=MISCTombstoneQuotes.TXT_Tragic=Tragic, MISCTombstoneQuotes.TXT_Heroic=Heroic | |fields=MISCTombstoneQuotes.TXT_Tragic=Tragic, MISCTombstoneQuotes.TXT_Heroic=Heroic | ||
|where=TXT_BelleName='{{PAGENAME}}' | |where=TXT_BelleName='{{#replace:{{PAGENAME}}|'|\'}}' | ||
|format=template | |format=template | ||
|template=Template:TombstoneQuotes | |template=Template:TombstoneQuotes | ||
| Line 133: | Line 133: | ||
tables=MISC_BelleMoreInfo | tables=MISC_BelleMoreInfo | ||
|fields=MISC_BelleMoreInfo.TXT_CommissionYear=commission, MISC_BelleMoreInfo.TXT_Summary=summary, MISC_BelleMoreInfo.TXT_ServiceDates=service, MISC_BelleMoreInfo.TXT_Namesake=namesake, MISC_BelleMoreInfo.TXT_Sisters=sisters, MISC_BelleMoreInfo.TXT_NotableSistersList=notable, MISC_BelleMoreInfo.TXT_Builder=builder, MISC_BelleMoreInfo.TXT_Fate=fate | |fields=MISC_BelleMoreInfo.TXT_CommissionYear=commission, MISC_BelleMoreInfo.TXT_Summary=summary, MISC_BelleMoreInfo.TXT_ServiceDates=service, MISC_BelleMoreInfo.TXT_Namesake=namesake, MISC_BelleMoreInfo.TXT_Sisters=sisters, MISC_BelleMoreInfo.TXT_NotableSistersList=notable, MISC_BelleMoreInfo.TXT_Builder=builder, MISC_BelleMoreInfo.TXT_Fate=fate | ||
|where=FK_Belle = '{{PAGENAME}}' | |where=FK_Belle = '{{#replace:{{PAGENAME}}|'|\'}}' | ||
|format=template | |format=template | ||
|template=Template:BelleMoreInfo | |template=Template:BelleMoreInfo | ||
| Line 154: | Line 154: | ||
tables=MAINBelle | tables=MAINBelle | ||
|fields=MAINBelle.TXT_NationName | |fields=MAINBelle.TXT_NationName | ||
|where=TXT_CharName='{{PAGENAME}}' | |where=TXT_CharName='{{#replace:{{PAGENAME}}|'|\'}}' | ||
|no html | |no html | ||
}}]] | }}]] | ||
| Line 161: | Line 161: | ||
tables=MAINBelle | tables=MAINBelle | ||
|fields=MAINBelle.TXT_VoiceName | |fields=MAINBelle.TXT_VoiceName | ||
|where=TXT_CharName='{{PAGENAME}}' | |where=TXT_CharName='{{#replace:{{PAGENAME}}|'|\'}}' | ||
|no html | |no html | ||
}} | [[Category:Voiced Belles]] | [[Category:Unvoiced Belles]] }} | }} | [[Category:Voiced Belles]] | [[Category:Unvoiced Belles]] }} | ||