Difference between revisions of "Template:QuadrantDataQuery"
Jump to navigation
Jump to search
(Created page with "<pre<noinclude></noinclude> > # Generated by http://wiki.travellerrpg.com/ # {{#time: Y-m-d H:i:sP}} {{#cargo_query: tables=SectorData |fields=name, pos_x=posX, pos_y=posY, s...") |
|||
| (One intermediate revision by the same user not shown) | |||
| 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 |
| + | CASE '{{{quadrant|}}}' WHEN 'Alpha' THEN SubsectorData.position in ('A', 'B', 'E', 'F') | ||
| + | WHEN 'Beta' THEN SubsectorData.position in ('C', 'D', 'G', 'H') | ||
| + | WHEN 'Gamma' THEN SubsectorData.position in ('I', 'J', 'M', 'N') | ||
| + | WHEN 'Delta' THEN SubsectorData.position in ('K', 'L', 'O', 'P') | ||
| + | ELSE True END | ||
|order by=position | |order by=position | ||
|format=template | |format=template | ||
| Line 23: | Line 28: | ||
|fields=code, description, detail, detail2 | |fields=code, description, detail, detail2 | ||
|group by=code | |group by=code | ||
| − | |where=sector=CONCAT('{{#replace:{{{sector|}}}|'|''}}') and era=CONCAT('{{#replace:{{{era|}}}|'|''}}') | + | |where=sector=CONCAT('{{#replace:{{{sector|}}}|'|''}}') and era=CONCAT('{{#replace:{{{era|}}}|'|''}}') |
|order by=code | |order by=code | ||
|named args=yes | |named args=yes | ||
| Line 42: | Line 47: | ||
CASE '{{{quadrant|}}}' WHEN 'Alpha' THEN SubsectorData.position in ('A', 'B', 'E', 'F') | CASE '{{{quadrant|}}}' WHEN 'Alpha' THEN SubsectorData.position in ('A', 'B', 'E', 'F') | ||
WHEN 'Beta' THEN SubsectorData.position in ('C', 'D', 'G', 'H') | WHEN 'Beta' THEN SubsectorData.position in ('C', 'D', 'G', 'H') | ||
| − | WHEN ' | + | WHEN 'Gamma' THEN SubsectorData.position in ('I', 'J', 'M', 'N') |
| − | WHEN ' | + | WHEN 'Delta' THEN SubsectorData.position in ('K', 'L', 'O', 'P') |
ELSE True END | ELSE True END | ||
|limit=1000 | |limit=1000 | ||
Latest revision as of 17:38, 15 May 2016
# Generated by http://wiki.travellerrpg.com/ # 2026-01-01 12:02:56+00:00 No results No results No results Hex Name UWP Remarks {Ix} (Ex) [Cx] N B Z PBG W A Stellar ---- -------------------- --------- -------------------------------------- ------ ------- ------ ---- --- - --- -- ---- ---------------Column 'era' in WHERE is ambiguous
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.