Difference between revisions of "ProductionHistory"
From Sega Retro
Line 1: | Line 1: | ||
− | <div style="display:none;">{{#vardefine:historyCount|0}}{{clearvar|alias|nameList}}{{#if:{{{1|}}}|{{#vardefine:command|credits.name="{{FormatSQL|{{{1|}}}}}"}} | + | <div style="display:none;">{{#vardefine:historyCount|0}}{{clearvar|alias|nameList}}{{#if:{{{1|}}}|{{#vardefine:command|credits.name="{{FormatSQL|{{{1|}}}}}"}}{{#fornumargs: n |
| value | | value | ||
| {{#vardefine:nameList|{{#var:nameList}},{{#var:value}}}}{{#ifexpr:{{#var:n}} > 1|{{#vardefine:command|{{#var:command}} OR credits.name="{{FormatSQL|{{#var:value}}}}"}}|}} | | {{#vardefine:nameList|{{#var:nameList}},{{#var:value}}}}{{#ifexpr:{{#var:n}} > 1|{{#vardefine:command|{{#var:command}} OR credits.name="{{FormatSQL|{{#var:value}}}}"}}|}} | ||
− | }}{{#cargo_query: | + | }} |
+ | |||
+ | <!-- games --> | ||
+ | {{#vardefine:contents|{{#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="0" and ({{#var:command}}) | ||
+ | |join on=credits.game=releases.name | ||
+ | |order by=releases.date | ||
+ | |group by=credits.console, credits.game, credits.role | ||
+ | |limit=10000 | ||
+ | |format=template | ||
+ | |template=ProductionHistoryLine | ||
+ | }} | ||
+ | }} | ||
+ | |||
+ | {{#vardefine:gameContentsHistoryCount|{{#var:historyCount}}}}{{#vardefine:historyCount|0}} | ||
+ | |||
+ | <!-- music --> | ||
+ | {{#vardefine:musicContents|{{#cargo_query: | ||
tables=credits,releases | tables=credits,releases | ||
|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={{#var:command}} | + | |where=releases.type="3" and ({{#var:command}}) |
|join on=credits.game=releases.name | |join on=credits.game=releases.name | ||
|order by=releases.date | |order by=releases.date | ||
|group by=credits.console, credits.game, credits.role | |group by=credits.console, credits.game, credits.role | ||
+ | |default= | ||
|limit=10000 | |limit=10000 | ||
|format=template | |format=template | ||
|template=ProductionHistoryLine | |template=ProductionHistoryLine | ||
}} | }} | ||
− | + | }} | |
+ | |||
+ | <!-- display --> | ||
+ | }}</div>{{#if:{{#var:contents}}|{{#if:{{#var:musicContents}}|<h3>Games</h3> | ||
+ | |}}{{multicol|{{#var:contents}} | ||
+ | |cols={{#expr:{{MulticolColumnCalc|{{#var:gameContentsHistoryCount}}}}-1}} | ||
+ | }}}}{{ | ||
+ | #if:{{#var:musicContents}}|<h3>Music</h3> | ||
+ | {{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. | + | }}}}<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 05:44, 22 July 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]
- Shining Force (Mega Drive; 1992) — Scenario[3]
- Shining Force (Mega Drive; 1992) — Character Design by[3]
- Shining Force (Mega Drive; 1992) — Graphics Directed by[3]
- Shining Force (Mega Drive; 1992) — Graphic Design[3]
- Shining Force (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