Template:Missions: Difference between revisions
m (added option to collapse) |
No edit summary |
||
Line 11: | Line 11: | ||
| table = Missions | | table = Missions | ||
| fields = _pageName, name, icon, description, difficulty, locations, targets, rewards | | fields = _pageName, name, icon, description, difficulty, locations, targets, rewards | ||
| where = {{#if:{{{1|}}}|type | | where = {{#if:{{{1|}}}|type IN ({{{1|}}})}} | ||
| order by = type DESC, difficulty ASC, name ASC, identifier ASC | | order by = type DESC, difficulty ASC, name ASC, identifier ASC | ||
| format = template | | format = template |
Revision as of 07:33, 22 December 2023
This template is used to display missions on the Missions page.
Combat (PvP)
Function: CargoSQLQuery::run Query: SELECT `cargo__Missions`.`_pageID` AS `cargo_backlink_page_id_Missions`,`_pageName` AS `_pageName`,`name` AS `name`,`icon` AS `icon`,`description` AS `description`,`difficulty` AS `difficulty`,`locations` AS `locations`,`targets` AS `targets`,`rewards` AS `rewards` FROM `cargo__Missions` WHERE type IN (Combat) ORDER BY `type` DESC,`difficulty`,`name`,`identifier` LIMIT 100
Mission | Description | Valid Locations/Passageways | Targets | Rewards |
---|
Cargo
Function: CargoSQLQuery::run Query: SELECT `cargo__Missions`.`_pageID` AS `cargo_backlink_page_id_Missions`,`_pageName` AS `_pageName`,`name` AS `name`,`icon` AS `icon`,`description` AS `description`,`difficulty` AS `difficulty`,`locations` AS `locations`,`targets` AS `targets`,`rewards` AS `rewards` FROM `cargo__Missions` WHERE type IN (cargo) ORDER BY `type` DESC,`difficulty`,`name`,`identifier` LIMIT 100
Mission | Description | Valid Locations/Passageways | Targets | Rewards |
---|
Escort
Function: CargoSQLQuery::run Query: SELECT `cargo__Missions`.`_pageID` AS `cargo_backlink_page_id_Missions`,`_pageName` AS `_pageName`,`name` AS `name`,`icon` AS `icon`,`description` AS `description`,`difficulty` AS `difficulty`,`locations` AS `locations`,`targets` AS `targets`,`rewards` AS `rewards` FROM `cargo__Missions` WHERE type IN (Escort) ORDER BY `type` DESC,`difficulty`,`name`,`identifier` LIMIT 100
Mission | Description | Valid Locations/Passageways | Targets | Rewards |
---|
Mining
Function: CargoSQLQuery::run Query: SELECT `cargo__Missions`.`_pageID` AS `cargo_backlink_page_id_Missions`,`_pageName` AS `_pageName`,`name` AS `name`,`icon` AS `icon`,`description` AS `description`,`difficulty` AS `difficulty`,`locations` AS `locations`,`targets` AS `targets`,`rewards` AS `rewards` FROM `cargo__Missions` WHERE type IN (Mining) ORDER BY `type` DESC,`difficulty`,`name`,`identifier` LIMIT 100
Mission | Description | Valid Locations/Passageways | Targets | Rewards |
---|
Beacon
Function: CargoSQLQuery::run Query: SELECT `cargo__Missions`.`_pageID` AS `cargo_backlink_page_id_Missions`,`_pageName` AS `_pageName`,`name` AS `name`,`icon` AS `icon`,`description` AS `description`,`difficulty` AS `difficulty`,`locations` AS `locations`,`targets` AS `targets`,`rewards` AS `rewards` FROM `cargo__Missions` WHERE type IN (Beacon) ORDER BY `type` DESC,`difficulty`,`name`,`identifier` LIMIT 100
Mission | Description | Valid Locations/Passageways | Targets | Rewards |
---|
Salvage
Function: CargoSQLQuery::run Query: SELECT `cargo__Missions`.`_pageID` AS `cargo_backlink_page_id_Missions`,`_pageName` AS `_pageName`,`name` AS `name`,`icon` AS `icon`,`description` AS `description`,`difficulty` AS `difficulty`,`locations` AS `locations`,`targets` AS `targets`,`rewards` AS `rewards` FROM `cargo__Missions` WHERE type IN (Salvage) ORDER BY `type` DESC,`difficulty`,`name`,`identifier` LIMIT 100
Mission | Description | Valid Locations/Passageways | Targets | Rewards |
---|
Monster
Function: CargoSQLQuery::run Query: SELECT `cargo__Missions`.`_pageID` AS `cargo_backlink_page_id_Missions`,`_pageName` AS `_pageName`,`name` AS `name`,`icon` AS `icon`,`description` AS `description`,`difficulty` AS `difficulty`,`locations` AS `locations`,`targets` AS `targets`,`rewards` AS `rewards` FROM `cargo__Missions` WHERE type IN (Monster) ORDER BY `type` DESC,`difficulty`,`name`,`identifier` LIMIT 100
Mission | Description | Valid Locations/Passageways | Targets | Rewards |
---|
Nest
Function: CargoSQLQuery::run Query: SELECT `cargo__Missions`.`_pageID` AS `cargo_backlink_page_id_Missions`,`_pageName` AS `_pageName`,`name` AS `name`,`icon` AS `icon`,`description` AS `description`,`difficulty` AS `difficulty`,`locations` AS `locations`,`targets` AS `targets`,`rewards` AS `rewards` FROM `cargo__Missions` WHERE type IN (Nest) ORDER BY `type` DESC,`difficulty`,`name`,`identifier` LIMIT 100
Mission | Description | Valid Locations/Passageways | Targets | Rewards |
---|
Outpost
Function: CargoSQLQuery::run Query: SELECT `cargo__Missions`.`_pageID` AS `cargo_backlink_page_id_Missions`,`_pageName` AS `_pageName`,`name` AS `name`,`icon` AS `icon`,`description` AS `description`,`difficulty` AS `difficulty`,`locations` AS `locations`,`targets` AS `targets`,`rewards` AS `rewards` FROM `cargo__Missions` WHERE type IN (Abandoned outpost,Destroy outpost) ORDER BY `type` DESC,`difficulty`,`name`,`identifier` LIMIT 100
Mission | Description | Valid Locations/Passageways | Targets | Rewards |
---|
Pirate
Function: CargoSQLQuery::run Query: SELECT `cargo__Missions`.`_pageID` AS `cargo_backlink_page_id_Missions`,`_pageName` AS `_pageName`,`name` AS `name`,`icon` AS `icon`,`description` AS `description`,`difficulty` AS `difficulty`,`locations` AS `locations`,`targets` AS `targets`,`rewards` AS `rewards` FROM `cargo__Missions` WHERE type IN (Pirate) ORDER BY `type` DESC,`difficulty`,`name`,`identifier` LIMIT 100
Mission | Description | Valid Locations/Passageways | Targets | Rewards |
---|
Alien
Function: CargoSQLQuery::run Query: SELECT `cargo__Missions`.`_pageID` AS `cargo_backlink_page_id_Missions`,`_pageName` AS `_pageName`,`name` AS `name`,`icon` AS `icon`,`description` AS `description`,`difficulty` AS `difficulty`,`locations` AS `locations`,`targets` AS `targets`,`rewards` AS `rewards` FROM `cargo__Missions` WHERE type IN (Alien ruins,Scan) ORDER BY `type` DESC,`difficulty`,`name`,`identifier` LIMIT 100
Mission | Description | Valid Locations/Passageways | Targets | Rewards |
---|
End
Function: CargoSQLQuery::run Query: SELECT `cargo__Missions`.`_pageID` AS `cargo_backlink_page_id_Missions`,`_pageName` AS `_pageName`,`name` AS `name`,`icon` AS `icon`,`description` AS `description`,`difficulty` AS `difficulty`,`locations` AS `locations`,`targets` AS `targets`,`rewards` AS `rewards` FROM `cargo__Missions` WHERE type IN (End) ORDER BY `type` DESC,`difficulty`,`name`,`identifier` LIMIT 100
Mission | Description | Valid Locations/Passageways | Targets | Rewards |
---|
The above documentation is transcluded from Template:Missions/doc. (edit | history)