Difference between revisions of "CompanyHistory"

Revision as of 10:47, 4 June 2021

Template to list a company's softography. It's a bit crude.

e.g. Sega, 32X:

{{CompanyHistory|Sega|format=32X|role=Publisher}}

{{CompanyHistory|Sega|Sega CS|format=32X|role=Developer}}

{{CompanyHistory|Sega|format=32X|role=Licensor}}

@@ Line 8: / Line 8: @@
 |group by=releases.name
 |order by=releases.date,releases.name
-|where=({{#var:command}}) {{#if:{{{role|}}}|and (companies.role LIKE "{{{role|}}}%")}} {{#if:{{{format|}}}|and (companies.format="{{{format|}}}") and (codeformat.format="{{{format|}}}")}} {{#switch:{{{type|}}}
+|where=({{#var:command}}) {{#if:{{{role|}}}|and (companies.role LIKE "{{{role|}}}%")}} {{#ifeq:{{{type|}}}|hardware||{{#if:{{{format|}}}|and (companies.format="{{{format|}}}") and (codeformat.format="{{{format|}}}")}}}} {{#switch:{{{type|}}}
 |accessories=and releases.type="1"{{#vardefine:italics|}}
 |hardware=and releases.type="2"{{#vardefine:italics|}}