Template:QuadrantDataQuery

From Traveller Wiki - Science-Fiction Adventure in the Far future
Jump to navigation Jump to search
# Generated by http://wiki.travellerrpg.com/
# 2022-04-24 08:49:22+00:00
No results
No results

No results

Hex  Name                 UWP       Remarks                                {Ix}   (Ex)    [Cx]   N    B   Z PBG W  A    Stellar        
---- -------------------- --------- -------------------------------------- ------ ------- ------ ---- --- - --- -- ---- ---------------
Error 1052: Column 'era' in where clause is ambiguous (localhost) Function: CargoSQLQuery::run Query: SELECT `hex` AS `hex`,`mw_cargo__StellarData`.`name` AS `name`,`uwp` AS `uwp`,CONCAT(codes__full,COALESCE(CONCAT(',',details__full),), COALESCE(CONCAT(',',sophonts__full),)) AS `REMARKS`,concat('{ ', ix , ' }') AS `IX`,CONCAT('(', ex, ')') AS `EX`,CONCAT('[',cx,']') AS `CX`,`nobility` AS `nobility`,`bases` AS `bases`,`zone` AS `zone`,CONCAT(popmul, belts, giants) AS `PBG`,`worlds` AS `worlds`,`allegiance` AS `allegiance`,`stars__full` AS `STARS` FROM `mw_cargo__StellarData` LEFT OUTER JOIN `mw_cargo__SubsectorData` ON ((`mw_cargo__StellarData`.`subsector`=`mw_cargo__SubsectorData`.`name`)) WHERE `mw_cargo__StellarData`.`sector`=CONCAT() AND era=CONCAT() AND CASE WHEN 'Alpha' THEN `mw_cargo__SubsectorData`.`position` in ('A', 'B', 'E', 'F') WHEN 'Beta' THEN `mw_cargo__SubsectorData`.`position` in ('C', 'D', 'G', 'H') WHEN 'Gamma' THEN `mw_cargo__SubsectorData`.`position` in ('I', 'J', 'M', 'N') WHEN 'Delta' THEN `mw_cargo__SubsectorData`.`position` in ('K', 'L', 'O', 'P') ELSE True END ORDER BY `hex`,`mw_cargo__StellarData`.`name`,`uwp`,CONCAT(codes__full,COALESCE(CONCAT(',',details__full),), COALESCE(CONCAT(',',sophonts__full),)),concat('{ ', ix , ' }') LIMIT 1000

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: