Difference between revisions of "ProductionHistory"

From Sega Retro

(bug fixes)
 
(17 intermediate revisions by the same user not shown)
Line 1: Line 1:
−
{{clearvar|alias|nameList}}{{#if:{{{1|}}}|{{#vardefine:command|credits.name="{{FormatSQL|{{{1|}}}}}"}}{{#fornumargs: n
+
<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}}) and credits.console=releases.console
 +
|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:unreleased|yes}}
 +
{{#vardefine:unreleasedcontents|{{#cargo_query:
 +
tables=credits,unreleased,codeformat
 +
|fields=credits.role=role,credits.name=name,credits.game=game,credits.console,credits.date,credits.pdf,credits.pdfpage
 +
|where=({{#var:command}}) and unreleased.name != "" and credits.console=codeformat.code
 +
|join on=unreleased.format=codeformat.format,credits.game=unreleased.name
 +
|order by=unreleased.name
 +
|group by=credits.console, credits.game, credits.role
 +
|default=
 +
|limit=10000
 +
|format=template
 +
|template=ProductionHistoryLine
 +
}}
 +
}}
 +
{{#vardefine:unreleased|}}
 +
{{#vardefine:gameContentsHistoryCount|{{#var:historyCount}}}}{{#vardefine:historyCount|0}}
 +
 
 +
<!-- videos -->
 +
{{#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 -->
 +
{{#vardefine:musicContents|{{#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="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
 +
}}
 +
}}
 +
 
 +
<!-- books -->
 +
{{#vardefine:bookContents|{{#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="4" 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
 
|format=template
 
|format=template
 
|template=ProductionHistoryLine
 
|template=ProductionHistoryLine
 
}}
 
}}
−
|}}
+
}}
−
<noinclude>Template for listing the production history of a developer. This is all sourced from [[Template:Creditstable]] templates being used in game pages.
+
 
 +
<!-- hardware -->
 +
{{#vardefine:noitalics|yes}}
 +
{{#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
 +
|order by=releases.date
 +
|group by=credits.console, credits.game, credits.role
 +
|default=
 +
|limit=10000
 +
|format=template
 +
|template=ProductionHistoryLine
 +
}}
 +
}}
 +
{{clearvar|noitalics}}
 +
 
 +
<!-- display -->
 +
}}</div>{{#if:{{#var:contents}}|{{#if:{{#var:musicContents}}{{#var:videoContents}}|<h3>Games</h3>
 +
|}}{{multicol|{{#var:contents}}{{#var:unreleasedcontents}}
 +
|cols={{#expr:{{MulticolColumnCalc|{{#var:gameContentsHistoryCount}}}}-1}}
 +
}}}}{{
 +
#if:{{#var:videoContents}}|<h3>Videos</h3>
 +
{{multicol|{{#var:videoContents}}
 +
|cols={{#expr:{{MulticolColumnCalc|{{#var:videoContentsHistoryCount}}}}-1}}
 +
}}}}{{
 +
#if:{{#var:musicContents}}|<h3>Music</h3>
 +
{{multicol|{{#var:musicContents}}
 +
|cols={{#expr:{{MulticolColumnCalc|{{#var:historyCount}}}}-1}}
 +
}}}}{{
 +
#if:{{#var:bookContents}}|<h3>Books</h3>
 +
{{#var:bookContents}}
 +
}}{{
 +
#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==
 
<pre>{{ProductionHistory|Yoshitaka Tamaki|玉木 美孝}}</pre>
 
<pre>{{ProductionHistory|Yoshitaka Tamaki|玉木 美孝}}</pre>
 
Produces:
 
Produces:
−
{{ProductionHistory|Yoshitaka Tamaki|玉木 美孝}}[[Category:Sega Retro templates]]</noinclude>
+
{{ProductionHistory|Yoshitaka Tamaki|玉木 美孝}}
 +
 
 +
<!--{{ProductionHistory|Matt Furniss|Marvellous Matt Furniss|Mat Furniss|Matt|Matt Furness|Fatt Murniss}}-->
 +
 
 +
{{ProductionHistory|Kazuyuki Hoshino|星野一幸}}
 +
[[Category:Templates]]</noinclude>

Latest revision as of 03:18, 24 November 2023

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


Games

Videos

Music

Books

  • ↑ File:Shining in the Darkness MD credits.pdf
  • ↑ Sega TV Game Genga Gallery, Graphic Sha, page 35
  • ↑ 3.0 3.1 3.2 3.3 File:Shining Force MD credits.pdf
  • ↑ Sega TV Game Genga Gallery, Graphic Sha, page 37
  • ↑ 5.0 5.1 5.2 File:Landstalker MD credits.pdf
  • ↑ Sega TV Game Genga Gallery, Graphic Sha, page 30
  • ↑ File:FEDA Remake! The Emblem of Justice Saturn credits.pdf
  • ↑ File:Shining Force GBA credits.pdf
  • ↑ File:Panic MCD credits.pdf
  • ↑ 10.0 10.1 10.2 10.3 File:Sonic CD MCD JP credits.pdf
  • ↑ File:NiGHTS into Dreams Saturn credits.pdf
  • ↑ 12.0 12.1 12.2 File:Sonic CD PC DirectX good ending credits.pdf
  • ↑ File:Sonic Jam Saturn credits.pdf
  • ↑ File:Sonic R Saturn credits.pdf
  • ↑ File:Burning Rangers JP Saturn credits.pdf
  • ↑ File:Sonic 3D Blast Saturn credits.pdf
  • ↑ File:SonicRivals2 PSP US manual.pdf, page 23
  • ↑ File:SongsWithAttitude CD JP booklet.pdf, page 7
  • ↑ File:SARemix CD JP booklet.pdf, page 9
  • ↑ File:SADLCOST CD JP booklet1.pdf, page 2
  • ↑ File:CompleteTrinity CD JP booklet.pdf, page 8
  • ↑ File:LostandFound CD JP booklet.pdf, page 6
  • ↑ File:StHOriginalSoundtrax CD JP booklet.pdf, page 2
  • ↑ File:TrueBlue CD JP booklet.pdf, page 5
  • ↑ File:SMPOST CD JP booklet.pdf, page 3
  • ↑ File:MaximumOverdrive CD JP inlay front.jpg
    • Retrieved from "https://segaretro.org/index.php?title=Template:ProductionHistory&oldid=938620"