Template:ArtifactSummary: Difference between revisions

From Heroes of Might and Magic: Olden Era Official Wiki
Created page with "<includeonly><!-- -->{{#cargo_query: tables = Artifact = A, Translation = T | join on = A.id = T.target_id | where = A.id = {{{id}}} AND T.type = 'artifact' | fields = H.id = id, T.name = name, T.description = description, T.language = lang | format = template | template = ArtifactSummary/base | named args = yes | default = {{Label|none|{{{lang|en}}}|nolink}} }}<!-- ######################################################..."
 
No edit summary
Line 10: Line 10:
     AND T.type = 'artifact'
     AND T.type = 'artifact'
| fields =
| fields =
     H.id = id,
     A.id = id,
     T.name = name,
     T.name = name,
     T.description = description,
     T.description = description,

Revision as of 07:02, 28 June 2026


Displays brief information about an artifact.

Usage

1. English:

Input: {{ArtifactSummary | lang=en | id=cards_deck_artifact }}

Output:

Error 1054: Unknown column 'cards_deck_artifact' in 'WHERE'

Function: CargoSQLQuery::run Query: SELECT `T`.`_pageID` AS `cargo_backlink_page_id_T`,`A`.`_pageID` AS `cargo_backlink_page_id_A`,`A`.`id` AS `id`,`T`.`name` AS `name`,`T`.`description` AS `description`,`T`.`language` AS `lang` FROM `mw4v_cargo__Artifact` `A` LEFT OUTER JOIN `mw4v_cargo__Translation` `T` ON ((`A`.`id`=`T`.`target_id`)) WHERE `A`.`id` = cards_deck_artifact

   AND `T`.`type` = 'artifact'  ORDER BY `T`.`_pageID`,`A`.`_pageID`,`A`.`id`,`T`.`name`,`T`.`description` LIMIT 100  

2. Japanese:

Input: {{ArtifactSummary | lang=ja | id=cards_deck_artifact }}

Output:

Error 1054: Unknown column 'cards_deck_artifact' in 'WHERE'

Function: CargoSQLQuery::run Query: SELECT `T`.`_pageID` AS `cargo_backlink_page_id_T`,`A`.`_pageID` AS `cargo_backlink_page_id_A`,`A`.`id` AS `id`,`T`.`name` AS `name`,`T`.`description` AS `description`,`T`.`language` AS `lang` FROM `mw4v_cargo__Artifact` `A` LEFT OUTER JOIN `mw4v_cargo__Translation` `T` ON ((`A`.`id`=`T`.`target_id`)) WHERE `A`.`id` = cards_deck_artifact

   AND `T`.`type` = 'artifact'  ORDER BY `T`.`_pageID`,`A`.`_pageID`,`A`.`id`,`T`.`name`,`T`.`description` LIMIT 100  

3. When the id is wrong, the wiki_none text is displayed:

Input: {{ArtifactSummary | id=foo}}

Output:

Error 1054: Unknown column 'foo' in 'WHERE'

Function: CargoSQLQuery::run Query: SELECT `T`.`_pageID` AS `cargo_backlink_page_id_T`,`A`.`_pageID` AS `cargo_backlink_page_id_A`,`A`.`id` AS `id`,`T`.`name` AS `name`,`T`.`description` AS `description`,`T`.`language` AS `lang` FROM `mw4v_cargo__Artifact` `A` LEFT OUTER JOIN `mw4v_cargo__Translation` `T` ON ((`A`.`id`=`T`.`target_id`)) WHERE `A`.`id` = foo

   AND `T`.`type` = 'artifact'  ORDER BY `T`.`_pageID`,`A`.`_pageID`,`A`.`id`,`T`.`name`,`T`.`description` LIMIT 100