Difference between revisions of "CompanyHistory"

Revision as of 15:25, 13 January 2020

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 12: / Line 12: @@
 |limit=1000
 |template=CompanyHistory/Cargo
+|default=
+}}{{#cargo_query:
+table=unreleased,companies
+|fields=companies.name=companiesname,unreleased.name=releasesname,unreleased.date,companies.company,companies.format,companies.role,companies.credited
+|join on=unreleased.name=companies.name
+|group by=unreleased.name
+|order by=unreleased.date,unreleased.name
+|where=({{#var:command}}) {{#if:{{{role|}}}|and (companies.role LIKE "{{{role|}}}%")}} {{#if:{{{format|}}}|and (companies.format="{{{format|}}}")}}
+|format=template
+|limit=1000
+|template=CompanyHistory/Cargo/Unreleased
 |default=
 }}}}}}{{#var:results}}</includeonly><noinclude>