Template:ArtifactSummary: Difference between revisions

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

Revision as of 07:07, 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 `T`.`target_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 `T`.`target_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 `T`.`target_id` = foo

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