Difference between revisions of "CompanyHistory"

From Sega Retro

Line 13: Line 13:
 
|template=CompanyHistory/Cargo
 
|template=CompanyHistory/Cargo
 
|default=
 
|default=
}}{{#cargo_query:
+
}}{{#ifeq:{{{type|}}}|accessories||{{#cargo_query:
 
table=unreleased,companies
 
table=unreleased,companies
 
|fields=companies.name=companiesname,unreleased.name=releasesname,unreleased.date,companies.company,companies.format,companies.role,companies.credited
 
|fields=companies.name=companiesname,unreleased.name=releasesname,unreleased.date,companies.company,companies.format,companies.role,companies.credited
Line 19: Line 19:
 
|group by=unreleased.name
 
|group by=unreleased.name
 
|order by=unreleased.date,unreleased.name
 
|order by=unreleased.date,unreleased.name
|where=({{#var:command}}) {{#if:{{{role|}}}|and (companies.role LIKE "{{{role|}}}%")}} {{#if:{{{format|}}}|and (companies.format="{{{format|}}}")}} {{#ifeq:{{{type|}}}|accessories|and releases.type="1"{{#vardefine:italics|}}|and not releases.type="1"{{#vardefine:italics|yes}}}}
+
|where=({{#var:command}}) {{#if:{{{role|}}}|and (companies.role LIKE "{{{role|}}}%")}} {{#if:{{{format|}}}|and (companies.format="{{{format|}}}")}}
 
|format=template
 
|format=template
 
|limit=1000
 
|limit=1000
 
|template=CompanyHistory/Cargo/Unreleased
 
|template=CompanyHistory/Cargo/Unreleased
 
|default=
 
|default=
}}}}}}{{#var:results}}</includeonly><noinclude>
+
}}}}}}}}{{#var:results}}</includeonly><noinclude>
 
Template to list a company's softography. It's a bit crude.
 
Template to list a company's softography. It's a bit crude.
  

Revision as of 11:01, 13 October 2020

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

e.g. Sega, 32X:

Publisher

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

Developer

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

Licensor

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