Template:ID to name: Difference between revisions

Template:ID to name (view source)

515 bytes removed , 20:52, 6 August 2019

m

no edit summary

8,756

edits

@@ Line 1: / Line 1: @@
-<includeonly>{{#sub:{{#cargo_query:table={{{2|ItemsTable}}}|
+<includeonly>{{#sub:{{#cargo_query:table=GeneralData|
-fields={{#switch: {{{2|temsTable}}} | Corpses=StrippedTitle | Cybernetics=Name| _pageName='Page'}}|
+fields=PlainName|
-where={{#switch: {{{2|ItemsTable}}}| ItemsTable=ObjectID| Mods=ModID| Mutations=MutationID | Factions=FactionID | Corpses=CorpseID | Cybernetics=CyberneticID | ObjectID }}='{{{1|}}}' and _pageNamespace <> '2' and _pageNamespace <> '10'|format=template|template=single query result|nohtml}}}}</includeonly><noinclude>[[Category:Templates]]
+where=ObjectID='{{{1|}}}' and _pageNamespace='0'|format=template|template=single query result|nohtml}}}}</includeonly><noinclude>[[Category:Templates]]
 Basic implementation that searches the objectid in ItemsTable and returns the page name in plain text.
@@ Line 10: / Line 10: @@
 {{ID to name|Cyclopean Prism}}
-This defaults to Items table, but can search other tables given that they have their own ID in by specifying the table as the second argument:
+This uses the GeneralData Table,
-<syntaxhighlight lang="sql">
-{{ID to name|Human Corpse|Corpses}}
-</syntaxhighlight>
-output:
-{{ID to name|Human Corpse|Corpses}}
 </noinclude>