Difference between revisions of "OmniMedia"

Latest revision as of 11:15, 22 February 2023

Template that generates relevant media for Omni tables, so you don't have to.

{{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)

@@ Line 36: / Line 36: @@
 |group by=releases.name
 |order by=releases.date
+|format=template
+|template=OmniMedia/Cargo
+|default=
+}}}}{{#vardefine:eventresult|{{#cargo_query:
+tables=relationships,events
+|fields=relationships.name=eventname,events.startdate
+|where=relationships.relatedto="{{FormatSQL|{{{1|}}}}}" and relationships.relationshiptype="event"
+|join on=relationships.name=events.name
+|group by=events.name
+|order by=events.startdate
 |format=template
 |template=OmniMedia/Cargo
@@ Line 43: / Line 53: @@
 #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:Sega Retro templates]]
+#if:{{#var:videoresult}}|'''Videos:''' {{#sub:{{UnformatSQL|{{#var:videoresult}}}}|0|-2}}<br/>|}}{{
+#if:{{#var:eventresult}}|'''Events:''' {{#sub:{{UnformatSQL|{{#var:eventresult}}}}|0|-2}}<br/>|}}{{clearvar|bookresult|musicresult|audiobookresult|videoresult|prereleaseresult|eventresult}}</includeonly><noinclude>[[Category:Templates]]
 Template that generates relevant media for Omni tables, so you don't have to.