Template:QuadrantDataQuery
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:
- 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.