Template:SubsWithWeapon: Difference between revisions

From Official Barotrauma Wiki
Jump to: navigation, search
mNo edit summary
mNo edit summary
Line 1: Line 1:
{|
<!--{|
! Submarine
! Submarine
! Amount
! Amount
|-
|-
<!--{{#cargo_query:table = Submarines
{{#cargo_query:table = Submarines
| format = template
| format = template
| fields = _pageName,name,{{lc:{{{1|{{PAGENAME}}}}}}}s
| fields = _pageName,name,{{lc:{{{1|{{PAGENAME}}}}}}}s
Line 13: Line 13:
}}
}}
-->{{#cargo_query:table = Submarines
-->{{#cargo_query:table = Submarines
| format = ul
| fields = name
| fields = name
| where = {{lc:{{{1|{{PAGENAME}}}}}}}s NOT LIKE "0"
| where = {{lc:{{{1|{{PAGENAME}}}}}}}s NOT LIKE "0"
| order by = name ASC
| order by = name ASC
}}
}}<!--
|}
|}-->

Revision as of 02:09, 2 August 2022

Error 1054: Unknown column 'subswithweapons' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `cargo__Submarines`.`_pageID` AS `cargo_backlink_page_id_Submarines`,`name` AS `name` FROM `cargo__Submarines` WHERE subswithweapons NOT LIKE "0" ORDER BY `name` LIMIT 100