Difference between revisions of "ProductionHistory"
From Sega Retro
| Line 56: | Line 56: | ||
|fields=credits.role=role,credits.name=name,credits.game=game,credits.console,credits.date,credits.pdf,credits.pdfpage,releases.date | |fields=credits.role=role,credits.name=name,credits.game=game,credits.console,credits.date,credits.pdf,credits.pdfpage,releases.date | ||
|where=releases.type="3" and ({{#var:command}}) | |where=releases.type="3" 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 | ||
| + | }} | ||
| + | }} | ||
| + | |||
| + | <!-- hardware --> | ||
| + | {{#vardefine:hardwareContents|{{#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="2" 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 | ||
| + | }} | ||
| + | }} | ||
| + | |||
| + | <!-- accessories --> | ||
| + | {{#vardefine:accessoryContents|{{#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="1" and ({{#var:command}}) | ||
|join on=credits.game=releases.name | |join on=credits.game=releases.name | ||
|order by=releases.date | |order by=releases.date | ||
| Line 78: | Line 108: | ||
{{multicol|{{#var:musicContents}} | {{multicol|{{#var:musicContents}} | ||
|cols={{#expr:{{MulticolColumnCalc|{{#var:historyCount}}}}-1}} | |cols={{#expr:{{MulticolColumnCalc|{{#var:historyCount}}}}-1}} | ||
| − | }}}}<noinclude>Template for listing the production history of a developer. This is all sourced from [[Template:Creditstable]] templates being used in game pages. | + | }}}}{{ |
| + | #if:{{#var:hardwareContents}}|<h3>Hardware</h3> | ||
| + | {{#var:hardwareContents}} | ||
| + | }}{{ | ||
| + | #if:{{#var:accessoryContents}}|<h3>Accessories</h3> | ||
| + | {{#var:accessoryContents}} | ||
| + | }}<noinclude>Template for listing the production history of a developer. This is all sourced from [[Template:Creditstable]] templates being used in game pages. | ||
==Example== | ==Example== | ||
Revision as of 06:09, 14 November 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
- Shining in the Darkness (Mega Drive; 1991) — Outline and Storyboards[1]
- Shining in the Darkness (Mega Drive; 1991) — Japanese cover artist[2]
- Landstalker: The Treasures of King Nole (Mega Drive; 1992) — Item Obj CG Designer[3]
- Landstalker: The Treasures of King Nole (Mega Drive; 1992) — Original Story[3]
- Landstalker: The Treasures of King Nole (Mega Drive; 1992) — Character Design[3]
- Landstalker: The Treasures of King Nole (Mega Drive; 1992) — Japanese cover & manual artist[4]
- FEDA Remake!: The Emblem of Justice (Saturn; 1996) — Original Story & Character Design[5]
- Time Stalkers (Dreamcast; 1999) — キャラクターデザイン (as 玉木 美孝)
- Time Stalkers (Dreamcast; 1999) — Character Design
- Shining Soul (Game Boy Advance; 2002) — Character Design
- Shining Soul II (Game Boy Advance; 2003) — Character Design
- Shining Force: Resurrection of the Dark Dragon (Game Boy Advance; 2004) — Character Design[6]
- Shining Force Neo (PlayStation 2; 2005) — Monster Design
Music
- Landstalker: Koutei no Zaihou (CD; 1992) — Illustlated by