Template:Missions: Difference between revisions
Jade Harley (talk | contribs) mNo edit summary |
Jade Harley (talk | contribs) mNo edit summary |
||
Line 9: | Line 9: | ||
{{#cargo_query: | {{#cargo_query: | ||
| table = Missions | | table = Missions | ||
| fields = _pageName | | fields = _pageName, name, icon, description, difficulty, locations, targets, rewards | ||
| where = {{#if:{{{1|}}}|type{{=}}{{{1|}}}}} | | where = {{#if:{{{1|}}}|type{{=}}{{{1|}}}}} | ||
| order by = type | | order by = type DESC, difficulty ASC, name ASC, identifier ASC | ||
| format = template | | format = template | ||
| template = Missions/row | | template = Missions/row |
Revision as of 23:38, 14 March 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=Combat ORDER BY `type` DESC,`difficulty`,`name`,`identifier` LIMIT 100
Mission | Description | Valid 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=cargo ORDER BY `type` DESC,`difficulty`,`name`,`identifier` LIMIT 100
Mission | Description | Valid 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=Escort ORDER BY `type` DESC,`difficulty`,`name`,`identifier` LIMIT 100
Mission | Description | Valid 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=Mining ORDER BY `type` DESC,`difficulty`,`name`,`identifier` LIMIT 100
Mission | Description | Valid 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=Beacon ORDER BY `type` DESC,`difficulty`,`name`,`identifier` LIMIT 100
Mission | Description | Valid 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=Salvage ORDER BY `type` DESC,`difficulty`,`name`,`identifier` LIMIT 100
Mission | Description | Valid 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=Monster ORDER BY `type` DESC,`difficulty`,`name`,`identifier` LIMIT 100
Mission | Description | Valid 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=Nest ORDER BY `type` DESC,`difficulty`,`name`,`identifier` LIMIT 100
Mission | Description | Valid 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=Abandoned outpost,Destroy outpost ORDER BY `type` DESC,`difficulty`,`name`,`identifier` LIMIT 100
Mission | Description | Valid 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=Pirate ORDER BY `type` DESC,`difficulty`,`name`,`identifier` LIMIT 100
Mission | Description | Valid 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=Alien ruins,Scan ORDER BY `type` DESC,`difficulty`,`name`,`identifier` LIMIT 100
Mission | Description | Valid 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=End ORDER BY `type` DESC,`difficulty`,`name`,`identifier` LIMIT 100
Mission | Description | Valid Passageways | Targets | Rewards |
---|
The above documentation is transcluded from Template:Missions/doc. (edit | history)