Template:Missions: Difference between revisions
mNo edit summary |
mNo edit summary |
||
Line 15: | Line 15: | ||
| 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 IN ({{#vardefine:i|0}}{{#while:|{{#expr:{{#var:i}}<={{#count:{{{1}}}|,}}}}|"{{#explode:{{{1}}}|,|{{#var:i}}}}" {{#vardefine:i|{{#expr:{{#var:i}}+1}}}}}})}} {{#if:{{{name|}}}|OR name IN ({{#vardefine:i|0}}{{#while:|{{#expr:{{#var:i}}<={{#count:{{{name}}}|,}}}}|"{{#explode:{{{name}}}|,|{{#var:i}}}}" {{#vardefine:i|{{#expr:{{#var:i}}+1}}}}}})}} | | where = {{#if:{{{1|}}}|type IN ({{#vardefine:i|0}}{{#while:|{{#expr:{{#var:i}}<={{#count:{{{1}}}|,}}}}|"{{#explode:{{{1}}}|,|{{#var:i}}}}", {{#vardefine:i|{{#expr:{{#var:i}}+1}}}}}})}} {{#if:{{{name|}}}|OR name IN ({{#vardefine:i|0}}{{#while:|{{#expr:{{#var:i}}<={{#count:{{{name}}}|,}}}}|"{{#explode:{{{name}}}|,|{{#var:i}}}}", {{#vardefine:i|{{#expr:{{#var:i}}+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:43, 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",) OR name IN ("Find Jacov Subra","The Ultimate Jest",) 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",) OR name IN ("The Eye",) 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)