Difference between revisions of "OmniMedia"
From Sega Retro
Line 1: | Line 1: | ||
− | <includeonly>{{#vardefine:musicresult|{{#cargo_query: | + | <includeonly>{{#vardefine:bookresult|{{#cargo_query: |
+ | tables=relationships,releases | ||
+ | |fields=relationships.name,releases.date | ||
+ | |where=relationships.relatedto="{{{1|}}}" and relationships.relationshiptype="book" | ||
+ | |join on=relationships.name=releases.name | ||
+ | |group by=releases.name | ||
+ | |order_by=releases.date | ||
+ | |format=template | ||
+ | |template=OmniMedia/Cargo | ||
+ | |default= | ||
+ | }}}}{{#vardefine:musicresult|{{#cargo_query: | ||
tables=relationships,releases | tables=relationships,releases | ||
|fields=relationships.name,releases.date | |fields=relationships.name,releases.date | ||
Line 9: | Line 19: | ||
|template=OmniMedia/Cargo | |template=OmniMedia/Cargo | ||
|default= | |default= | ||
− | }}}}{{#vardefine: | + | }}}}{{#vardefine:audiobookresult|{{#cargo_query: |
+ | tables=relationships,releases | ||
+ | |fields=relationships.name,releases.date | ||
+ | |where=relationships.relatedto="{{{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 | tables=relationships,releases | ||
|fields=relationships.name,releases.date | |fields=relationships.name,releases.date | ||
− | |where=relationships.relatedto="{{{1|}}}" and relationships.relationshiptype=" | + | |where=relationships.relatedto="{{{1|}}}" and relationships.relationshiptype="video" |
|join on=relationships.name=releases.name | |join on=relationships.name=releases.name | ||
|group by=releases.name | |group by=releases.name | ||
Line 30: | Line 50: | ||
|default= | |default= | ||
}}}} | }}}} | ||
+ | {{#if:{{#var:bookresult}}|'''Books:''' {{#sub:{{#var:bookresult}}|0|-2}}<br/>|}} | ||
{{#if:{{#var:musicresult}}|'''Music:''' {{#sub:{{#var:musicresult}}|0|-2}}<br/>|}} | {{#if:{{#var:musicresult}}|'''Music:''' {{#sub:{{#var:musicresult}}|0|-2}}<br/>|}} | ||
− | {{#if:{{#var: | + | {{#if:{{#var:audiobookresult}}|'''Audiobooks:''' {{#sub:{{#var:audiobookresult}}|0|-2}}<br/>|}} |
+ | {{#if:{{#var:videoresult}}|'''Videos:''' {{#sub:{{#var:videoresult}}|0|-2}}<br/>|}} | ||
{{#if:{{#var:prereleaseresult}}|'''Prereleases:''' {{#sub:{{#var:prereleaseresult}}|0|-2}}<br/>|}} | {{#if:{{#var:prereleaseresult}}|'''Prereleases:''' {{#sub:{{#var:prereleaseresult}}|0|-2}}<br/>|}} | ||
− | {{clearvar|musicresult| | + | {{clearvar|bookresult|musicresult|audiobookresult|videoresult|prereleaseresult}}</includeonly><noinclude>[[Category:Sega Retro templates]] |
Template that generates relevant media for Omni tables, so you don't have to. | Template that generates relevant media for Omni tables, so you don't have to. | ||
Revision as of 08:55, 20 December 2020
Template that generates relevant media for Omni tables, so you don't have to.
Examples
{{OmniMedia|Space Channel 5: Part 2}}
Books:
Query: SELECT `cargo__relationships`.`name` AS `name`,`cargo__releases`.`date` AS `date` FROM `cargo__relationships` LEFT OUTER JOIN `cargo__releases` ON ((`cargo__relationships`.`name`=`cargo__releases`.`name`)) WHERE `cargo__relationships`.`relatedto`="Space Channel 5: Part 2" and `cargo__relationships`.`relationshiptype`="book" GROUP BY `cargo__releases`.`name` ORDER BY `cargo__relationships`.`name`,`cargo__releases`.`date` LIMIT 100
Function: CargoSQLQuery::run
Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-25ad6ec-2730.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)
</di
Query: SELECT `cargo__relationships`.`name` AS `name`,`cargo__releases`.`date` AS `date` FROM `cargo__relationships` LEFT OUTER JOIN `cargo__releases` ON ((`cargo__relationships`.`name`=`cargo__releases`.`name`)) WHERE `cargo__relationships`.`relatedto`="Space Channel 5: Part 2" and `cargo__relationships`.`relationshiptype`="music" GROUP BY `cargo__releases`.`name` ORDER BY `cargo__relationships`.`name`,`cargo__releases`.`date` LIMIT 100
Function: CargoSQLQuery::run
Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-25ad6ec-2733.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)
</di
Query: SELECT `cargo__relationships`.`name` AS `name`,`cargo__releases`.`date` AS `date` FROM `cargo__relationships` LEFT OUTER JOIN `cargo__releases` ON ((`cargo__relationships`.`name`=`cargo__releases`.`name`)) WHERE `cargo__relationships`.`relatedto`="Space Channel 5: Part 2" and `cargo__relationships`.`relationshiptype`="audiobook" GROUP BY `cargo__releases`.`name` ORDER BY `cargo__relationships`.`name`,`cargo__releases`.`date` LIMIT 100
Function: CargoSQLQuery::run
Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-25ad6ec-2736.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)
</di
Query: SELECT `cargo__relationships`.`name` AS `name`,`cargo__releases`.`date` AS `date` FROM `cargo__relationships` LEFT OUTER JOIN `cargo__releases` ON ((`cargo__relationships`.`name`=`cargo__releases`.`name`)) WHERE `cargo__relationships`.`relatedto`="Space Channel 5: Part 2" and `cargo__relationships`.`relationshiptype`="video" GROUP BY `cargo__releases`.`name` ORDER BY `cargo__relationships`.`name`,`cargo__releases`.`date` LIMIT 100
Function: CargoSQLQuery::run
Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-25ad6ec-2739.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)
</di
Query: SELECT `cargo__relationships`.`name` AS `name`,`cargo__releases`.`date` AS `date` FROM `cargo__relationships` LEFT OUTER JOIN `cargo__releases` ON ((`cargo__relationships`.`name`=`cargo__releases`.`name`)) WHERE `cargo__relationships`.`relatedto`="Space Channel 5: Part 2" and `cargo__relationships`.`relationshiptype`="prerelease" GROUP BY `cargo__releases`.`name` ORDER BY `cargo__relationships`.`name`,`cargo__releases`.`date` LIMIT 100
Function: CargoSQLQuery::run
Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-25ad6ec-273c.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)
</di