Difference between revisions of "OmniMedia"
From Sega Retro
(Created page with "<includeonly>{{#cargo_query: tables=relationships,releases |fields=relationships.name,releases.date |where=relationships.relatedto="{{{1|}}}" and relationships.relationshiptyp...") |
m (Text replacement - "Category:Sega Retro templates" to "Category:Templates") |
||
(8 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
− | <includeonly>{{#cargo_query: | + | <includeonly>{{#vardefine:bookresult|{{#cargo_query: |
tables=relationships,releases | tables=relationships,releases | ||
|fields=relationships.name,releases.date | |fields=relationships.name,releases.date | ||
− | |where=relationships.relatedto="{{{1|}}}" and relationships.relationshiptype=" | + | |where=relationships.relatedto="{{FormatSQL|{{{1|}}}}}" and relationships.relationshiptype="book" |
|join on=relationships.name=releases.name | |join on=relationships.name=releases.name | ||
|group by=releases.name | |group by=releases.name | ||
− | | | + | |order by=releases.date |
|format=template | |format=template | ||
|template=OmniMedia/Cargo | |template=OmniMedia/Cargo | ||
− | }}</includeonly><noinclude>[[Category: | + | |default= |
− | + | }}}}{{#vardefine:musicresult|{{#cargo_query: | |
+ | tables=relationships,releases | ||
+ | |fields=relationships.name,releases.date | ||
+ | |where=relationships.relatedto="{{FormatSQL|{{{1|}}}}}" and relationships.relationshiptype="music" | ||
+ | |join on=relationships.name=releases.name | ||
+ | |group by=releases.name | ||
+ | |order by=releases.date | ||
+ | |format=template | ||
+ | |template=OmniMedia/Cargo | ||
+ | |default= | ||
+ | }}}}{{#vardefine:audiobookresult|{{#cargo_query: | ||
+ | tables=relationships,releases | ||
+ | |fields=relationships.name,releases.date | ||
+ | |where=relationships.relatedto="{{FormatSQL|{{{1|}}}}}" and relationships.relationshiptype="audiobook" | ||
+ | |join on=relationships.name=releases.name | ||
+ | |group by=releases.name | ||
+ | |order by=releases.date | ||
+ | |format=template | ||
+ | |template=OmniMedia/Cargo | ||
+ | |default= | ||
+ | }}}}{{#vardefine:videoresult|{{#cargo_query: | ||
+ | tables=relationships,releases | ||
+ | |fields=relationships.name,releases.date | ||
+ | |where=relationships.relatedto="{{FormatSQL|{{{1|}}}}}" and relationships.relationshiptype="video" | ||
+ | |join on=relationships.name=releases.name | ||
+ | |group by=releases.name | ||
+ | |order by=releases.date | ||
+ | |format=template | ||
+ | |template=OmniMedia/Cargo | ||
+ | |default= | ||
+ | }}}} | ||
+ | {{#if:{{#var:bookresult}}|'''Books:''' {{#sub:{{UnformatSQL|{{#var:bookresult}}}}|0|-2}}<br/>|}}{{ | ||
+ | #if:{{#var:musicresult}}|'''Music:''' {{#sub:{{UnformatSQL|{{#var:musicresult}}}}|0|-2}}<br/>|}}{{ | ||
+ | #if:{{#var:audiobookresult}}|'''Audiobooks:''' {{#sub:{{UnformatSQL|{{#var:audiobookresult}}}}|0|-2}}<br/>|}}{{ | ||
+ | #if:{{#var:videoresult}}|'''Videos:''' {{#sub:{{UnformatSQL|{{#var:videoresult}}}}|0|-2}}<br/>|}}{{clearvar|bookresult|musicresult|audiobookresult|videoresult|prereleaseresult}}</includeonly><noinclude>[[Category:Templates]] | ||
+ | Template that generates relevant media for Omni tables, so you don't have to. | ||
+ | ==Examples== | ||
+ | <pre>{{OmniMedia|Space Channel 5: Part 2}}</pre> | ||
{{OmniMedia|Space Channel 5: Part 2}} | {{OmniMedia|Space Channel 5: Part 2}} | ||
− | |||
− | |||
</noinclude> | </noinclude> |
Revision as of 14:08, 1 January 2022
Template that generates relevant media for Omni tables, so you don't have to.
Examples
{{OmniMedia|Space Channel 5: Part 2}}
Books: Space Channel 5 Part 2 Sugoku Sugoi Guide Book (2002)
Music: Space Channel 5 Part 2 Soundtrack Volume "Chu!!" (2002) | Space Channel 5 Part 2 Soundtrack Volume "Hey!!" (2002) | Space Channel 5 Part 2 Uki Uki ★ Non Stop Mega Mix (2002) | Space Channel 5 Part 2 Moji Moji ★ Can't Stop Remix (2002) | Space Channel 5 Part 2 Uha Uha ★ Readymade Remixes (2002)