Difference between revisions of "ProductionHistory"

From Sega Retro
 
(6 intermediate revisions by the same user not shown)
Line 8: Line 8:
 
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=releases.type="0" and ({{#var:command}})
+
|where=releases.type="0" and ({{#var:command}}) and credits.console=releases.console
 
|join on=credits.game=releases.name
 
|join on=credits.game=releases.name
 
|order by=releases.date
 
|order by=releases.date
Line 19: Line 19:
 
{{#vardefine:unreleased|yes}}
 
{{#vardefine:unreleased|yes}}
 
{{#vardefine:unreleasedcontents|{{#cargo_query:
 
{{#vardefine:unreleasedcontents|{{#cargo_query:
−
tables=credits,unreleased
+
tables=credits,unreleased,codeformat
 
|fields=credits.role=role,credits.name=name,credits.game=game,credits.console,credits.date,credits.pdf,credits.pdfpage
 
|fields=credits.role=role,credits.name=name,credits.game=game,credits.console,credits.date,credits.pdf,credits.pdfpage
−
|where=({{#var:command}}) and unreleased.name != ""
+
|where=({{#var:command}}) and unreleased.name != "" and credits.console=codeformat.code
−
|join on=credits.game=unreleased.name
+
|join on=unreleased.format=codeformat.format,credits.game=unreleased.name
 
|order by=unreleased.name
 
|order by=unreleased.name
 
|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
Line 64: Line 65:
 
}}
 
}}
 
}}
 
}}
 +
 +
<!-- books -->
 +
{{#vardefine:bookContents|{{#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="4" 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: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 -->
 
<!-- display -->
Line 77: Line 125:
 
{{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: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==
Line 84: Line 141:
 
{{ProductionHistory|Yoshitaka Tamaki|玉木 美孝}}
 
{{ProductionHistory|Yoshitaka Tamaki|玉木 美孝}}
  
 +
<!--{{ProductionHistory|Matt Furniss|Marvellous Matt Furniss|Mat Furniss|Matt|Matt Furness|Fatt Murniss}}-->
 +
 +
{{ProductionHistory|Kazuyuki Hoshino|星野一幸}}
 
[[Category:Templates]]</noinclude>
 
[[Category:Templates]]</noinclude>

Latest revision as of 04: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:Shining Force GBA credits.pdf
  • ↑ File:Panic MCD credits.pdf
  • ↑ 9.0 9.1 9.2 9.3 File:Sonic CD MCD JP credits.pdf
  • ↑ File:NiGHTS into Dreams Saturn credits.pdf
  • ↑ File:Sonic Jam Saturn credits.pdf
  • ↑ File:Sonic R 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:MDSA2OST poster1.pdf, page 1
  • ↑ 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"