Difference between revisions of "Template:QuadrantDataQuery"

From Traveller Wiki - Science-Fiction Adventure in the Far future
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...")
 
Line 42: Line 42:
 
     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 'Delta' THEN SubsectorData.position in ('I', 'J', 'M', 'N')
+
     WHEN 'Gamma' THEN SubsectorData.position in ('I', 'J', 'M', 'N')
     WHEN 'Gamma' THEN SubsectorData.position in ('K', 'L', 'O', 'P')
+
     WHEN 'Delta' THEN SubsectorData.position in ('K', 'L', 'O', 'P')
 
ELSE True END
 
ELSE True END
 
  |limit=1000
 
  |limit=1000

Revision as of 17:31, 15 May 2016

# Generated by http://wiki.travellerrpg.com/
# 2026-01-10 08:51:34+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: