Template:Missions: Difference between revisions

From Official Barotrauma Wiki
Jump to: navigation, search
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

Documentation

This template is used to display missions on the Missions page.

Combat (PvP)

Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') ORDER BY `type` DESC,`difficulty`,`name`,`identifier` LIMIT 100' at line 1

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

Combat Missions
Mission Description Valid Locations/Passageways Targets Rewards


Cargo

Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') ORDER BY `type` DESC,`difficulty`,`name`,`identifier` LIMIT 100' at line 1

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

cargo Missions
Mission Description Valid Locations/Passageways Targets Rewards


Escort

Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') ORDER BY `type` DESC,`difficulty`,`name`,`identifier` LIMIT 100' at line 1

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

Escort Missions
Mission Description Valid Locations/Passageways Targets Rewards


Mining

Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') ORDER BY `type` DESC,`difficulty`,`name`,`identifier` LIMIT 100' at line 1

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

Mining Missions
Mission Description Valid Locations/Passageways Targets Rewards


Beacon

Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') ORDER BY `type` DESC,`difficulty`,`name`,`identifier` LIMIT 100' at line 1

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

Beacon Missions
Mission Description Valid Locations/Passageways Targets Rewards


Salvage

Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') ORDER BY `type` DESC,`difficulty`,`name`,`identifier` LIMIT 100' at line 1

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

Salvage Missions
Mission Description Valid Locations/Passageways Targets Rewards


Monster

Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') ORDER BY `type` DESC,`difficulty`,`name`,`identifier` LIMIT 100' at line 1

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

Monster Missions
Mission Description Valid Locations/Passageways Targets Rewards


Nest

Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') ORDER BY `type` DESC,`difficulty`,`name`,`identifier` LIMIT 100' at line 1

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

Nest Missions
Mission Description Valid Locations/Passageways Targets Rewards


Outpost

Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') OR name IN ("Find Jacov Subra","The Ultimate Jest",) ORDER BY `type` DESC,...' at line 1

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

Abandoned outpost,Destroy outpost Missions
Mission Description Valid Locations/Passageways Targets Rewards


Pirate

Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') ORDER BY `type` DESC,`difficulty`,`name`,`identifier` LIMIT 100' at line 1

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

Pirate Missions
Mission Description Valid Locations/Passageways Targets Rewards


Alien

Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') ORDER BY `type` DESC,`difficulty`,`name`,`identifier` LIMIT 100' at line 1

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

Alien ruins,Scan Missions
Mission Description Valid Locations/Passageways Targets Rewards


End

Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') OR name IN ("The Eye",) ORDER BY `type` DESC,`difficulty`,`name`,`identifi...' at line 1

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

End Missions
Mission Description Valid Locations/Passageways Targets Rewards