Difference between revisions of "Template:SectorDataQuery"
Jump to navigation
Jump to search
| 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, -pos_y=posY, source, credits, other_names=otherNames, CONCAT('{{#replace:{{{era|}}}|'|''}}')=era | + | |fields=name, pos_x=posX, (-1 * 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 | ||
Revision as of 14:56, 7 August 2016
# Generated by http://wiki.travellerrpg.com/ # 2026-01-02 18:51:48+00:00Error: No field named "(-1 * pos_y)" found for any of the specified database tables.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.