Difference between revisions of "OmniMedia"

From Sega Retro

(4 intermediate revisions by 2 users not shown)
Line 2: Line 2:
 
tables=relationships,releases
 
tables=relationships,releases
 
|fields=relationships.name,releases.date
 
|fields=relationships.name,releases.date
|where=relationships.relatedto="{{{1|}}}" and relationships.relationshiptype="book"
+
|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
Line 12: Line 12:
 
tables=relationships,releases
 
tables=relationships,releases
 
|fields=relationships.name,releases.date
 
|fields=relationships.name,releases.date
|where=relationships.relatedto="{{{1|}}}" and relationships.relationshiptype="music"
+
|where=relationships.relatedto="{{FormatSQL|{{{1|}}}}}" and relationships.relationshiptype="music"
 
|join on=relationships.name=releases.name
 
|join on=relationships.name=releases.name
 
|group by=releases.name
 
|group by=releases.name
Line 22: Line 22:
 
tables=relationships,releases
 
tables=relationships,releases
 
|fields=relationships.name,releases.date
 
|fields=relationships.name,releases.date
|where=relationships.relatedto="{{{1|}}}" and relationships.relationshiptype="audiobook"
+
|where=relationships.relatedto="{{FormatSQL|{{{1|}}}}}" and relationships.relationshiptype="audiobook"
 
|join on=relationships.name=releases.name
 
|join on=relationships.name=releases.name
 
|group by=releases.name
 
|group by=releases.name
Line 32: Line 32:
 
tables=relationships,releases
 
tables=relationships,releases
 
|fields=relationships.name,releases.date
 
|fields=relationships.name,releases.date
|where=relationships.relatedto="{{{1|}}}" and relationships.relationshiptype="video"
+
|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=
 
}}}}{{#vardefine:prereleaseresult|{{#cargo_query:
 
tables=relationships,releases
 
|fields=relationships.name,releases.date
 
|where=relationships.relatedto="{{{1|}}}" and relationships.relationshiptype="prerelease"
 
 
|join on=relationships.name=releases.name
 
|join on=relationships.name=releases.name
 
|group by=releases.name
 
|group by=releases.name
Line 50: Line 40:
 
|default=
 
|default=
 
}}}}
 
}}}}
{{#if:{{#var:bookresult}}|'''Books:''' {{#sub:{{#var:bookresult}}|0|-2}}<br/>|}}{{
+
{{#if:{{#var:bookresult}}|'''Books:''' {{#sub:{{UnformatSQL|{{#var:bookresult}}}}|0|-2}}<br/>|}}{{
#if:{{#var:musicresult}}|'''Music:''' {{#sub:{{#var:musicresult}}|0|-2}}<br/>|}}{{
+
#if:{{#var:musicresult}}|'''Music:''' {{#sub:{{UnformatSQL|{{#var:musicresult}}}}|0|-2}}<br/>|}}{{
#if:{{#var:audiobookresult}}|'''Audiobooks:''' {{#sub:{{#var:audiobookresult}}|0|-2}}<br/>|}}{{
+
#if:{{#var:audiobookresult}}|'''Audiobooks:''' {{#sub:{{UnformatSQL|{{#var:audiobookresult}}}}|0|-2}}<br/>|}}{{
#if:{{#var:videoresult}}|'''Videos:''' {{#sub:{{#var:videoresult}}|0|-2}}<br/>|}}{{
+
#if:{{#var:videoresult}}|'''Videos:''' {{#sub:{{UnformatSQL|{{#var:videoresult}}}}|0|-2}}<br/>|}}{{clearvar|bookresult|musicresult|audiobookresult|videoresult|prereleaseresult}}</includeonly><noinclude>[[Category:Templates]]
#if:{{#var:prereleaseresult}}|'''Prereleases:''' {{#sub:{{#var:prereleaseresult}}|0|-2}}<br/>|}}
 
{{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 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:

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

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__releases`.`date` LIMIT 100 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-2b9b91-279.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

</di
Music:
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

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__releases`.`date` LIMIT 100 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-2b9b91-27c.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

</di
Audiobooks:
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

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__releases`.`date` LIMIT 100 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-2b9b91-27f.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

</di
Videos:
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

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__releases`.`date` LIMIT 100 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-2b9b91-282.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost) </di