Difference between revisions of "ProductionHistory"

From Sega Retro

Line 19: Line 19:
  
 
{{#vardefine:gameContentsHistoryCount|{{#var:historyCount}}}}{{#vardefine:historyCount|0}}
 
{{#vardefine:gameContentsHistoryCount|{{#var:historyCount}}}}{{#vardefine:historyCount|0}}
 +
 +
<!-- video -->
 +
{{#vardefine:videoContents|{{#cargo_query:
 +
tables=credits,releases
 +
|fields=credits.role=role,credits.name=name,credits.game=game,credits.console,credits.date,credits.pdf,credits.pdfpage,releases.date
 +
|where=releases.type="6" and ({{#var:command}})
 +
|join on=credits.game=releases.name
 +
|order by=releases.date
 +
|group by=credits.console, credits.game, credits.role
 +
|default=
 +
|limit=10000
 +
|format=template
 +
|template=ProductionHistoryLine
 +
}}
 +
}}
 +
 +
{{#vardefine:videoContentsHistoryCount|{{#var:historyCount}}}}{{#vardefine:historyCount|0}}
  
 
<!-- music -->
 
<!-- music -->
Line 39: Line 56:
 
|}}{{multicol|{{#var:contents}}
 
|}}{{multicol|{{#var:contents}}
 
|cols={{#expr:{{MulticolColumnCalc|{{#var:gameContentsHistoryCount}}}}-1}}
 
|cols={{#expr:{{MulticolColumnCalc|{{#var:gameContentsHistoryCount}}}}-1}}
 +
}}}}{{
 +
#if:{{#var:videoContents}}|<h3>Video</h3>
 +
{{multicol|{{#var:videoContents}}
 +
|cols={{#expr:{{MulticolColumnCalc|{{#var:videoContentsHistoryCount}}}}-1}}
 
}}}}{{
 
}}}}{{
 
#if:{{#var:musicContents}}|<h3>Music</h3>
 
#if:{{#var:musicContents}}|<h3>Music</h3>

Revision as of 16:45, 8 August 2022

Template for listing the production history of a developer. This is all sourced from Template:Creditstable templates being used in game pages.

Example

{{ProductionHistory|Yoshitaka Tamaki|玉木 美孝}}

Produces:

Games

Music