Difference between revisions of "Template:SectorDataQuery"
Jump to navigation
Jump to search
| (5 intermediate revisions by the same user not shown) | |||
| Line 3: | Line 3: | ||
# {{#time: Y-m-d H:i:sP}} | # {{#time: Y-m-d H:i:sP}} | ||
{{#cargo_query: tables=SectorData | {{#cargo_query: tables=SectorData | ||
| − | |fields=name, pos_x=posX, | + | |fields=name, pos_x=posX, pos_y=posY, source, credits, other_names=otherNames, CONCAT('{{#replace:{{{era|}}}|'|''}}')=era |
|where=name=CONCAT('{{#replace:{{{sector|}}}|'|''}}') | |where=name=CONCAT('{{#replace:{{{sector|}}}|'|''}}') | ||
|format=template | |format=template | ||
| Line 12: | Line 12: | ||
{{#cargo_query: tables=SubsectorData | {{#cargo_query: tables=SubsectorData | ||
|fields=position,name | |fields=position,name | ||
| − | |where=sector=CONCAT('{{#replace:{{{sector|}}}|'|''}}') | + | |where=sector=CONCAT('{{#replace:{{{sector|}}}|'|''}}') and era=CONCAT('{{#replace:{{{era|}}}|'|''}}') |
|order by=position | |order by=position | ||
|format=template | |format=template | ||
| Line 31: | Line 31: | ||
}} | }} | ||
| − | Hex Name UWP Remarks | + | Hex Name UWP Remarks {Ix} (Ex) [Cx] N B Z PBG W A Stellar |
| − | <nowiki>---- -------------------- --------- -------------------------------------- ------ ------- ------ ---- --- - --- -- ---- ---------------</nowiki> | + | <nowiki>---- -------------------- --------- ---------------------------------------------------- ------ ------- ------ ----- --- - --- -- ---- -------------------</nowiki> |
{{#cargo_query: | {{#cargo_query: | ||
tables=StellarData | tables=StellarData | ||
Latest revision as of 10:43, 14 September 2016
# Generated by http://wiki.travellerrpg.com/ # 2025-12-06 06:04:55+00:00 No results No results No results Hex Name UWP Remarks {Ix} (Ex) [Cx] N B Z PBG W A Stellar ---- -------------------- --------- ---------------------------------------------------- ------ ------- ------ ----- --- - --- -- ---- ------------------- No results
Used to generate a full listing of sector data in a given era into the T5 Second Survey data format.
parameters:
- sector = sector name
- era = era name
Uses the following templates for layout:
- Template:SectorDataQuery.header.layout - base sector information: credits, location, name
- Template:SectorData.subsectors.layout - Subsector information, list by position
- Template:SectorDataQuery.allegiance.query - Allegiance information, list by code
- Template:SectorDataQuery.layout - Main data layout, with spacing.