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.

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-25bab40-132a.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-25bab40-132d.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-25bab40-1330.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-25bab40-1333.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

</di
Events:

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 `eventname`,`cargo__events`.`startdate` AS `startdate` FROM `cargo__relationships` LEFT OUTER JOIN `cargo__events` ON ((`cargo__relationships`.`name`=`cargo__events`.`name`)) WHERE `cargo__relationships`.`relatedto`="Space Channel 5: Part 2" and `cargo__relationships`.`relationshiptype`="event" GROUP BY `cargo__events`.`name` ORDER BY `cargo__events`.`startdate` LIMIT 100 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-25bab40-1336.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost) </di

@@ 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="music"
+|where=relationships.relatedto="{{FormatSQL|{{{1|}}}}}" and relationships.relationshiptype="book"
 |join on=relationships.name=releases.name
 |group by=releases.name
-|order_by=releases.date
+|order by=releases.date
 |format=template
 |template=OmniMedia/Cargo
 |default=
-}}}}{{#vardefine:bookresult|{{#cargo_query:
+}}}}{{#vardefine:musicresult|{{#cargo_query:
 tables=relationships,releases
 |fields=relationships.name,releases.date
-|where=relationships.relatedto="{{{1|}}}" and relationships.relationshiptype="book"
+|where=relationships.relatedto="{{FormatSQL|{{{1|}}}}}" and relationships.relationshiptype="music"
 |join on=relationships.name=releases.name
 |group by=releases.name
-|order_by=releases.date
+|order by=releases.date
 |format=template
 |template=OmniMedia/Cargo
 |default=
-}}}}{{#vardefine:prereleaseresult|{{#cargo_query:
+}}}}{{#vardefine:audiobookresult|{{#cargo_query:
 tables=relationships,releases
 |fields=relationships.name,releases.date
-|where=relationships.relatedto="{{{1|}}}" and relationships.relationshiptype="prerelease"
+|where=relationships.relatedto="{{FormatSQL|{{{1|}}}}}" and relationships.relationshiptype="audiobook"
 |join on=relationships.name=releases.name
 |group by=releases.name
-|order_by=releases.date
+|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=
+}}}}{{#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
 |default=
 }}}}
-{{#if:{{#var:musicresult}}|'''Music:''' {{#sub:{{#var:musicresult}}|0|-2}}<br/>|}}
+{{#if:{{#var:bookresult}}|'''Books:''' {{#sub:{{UnformatSQL|{{#var:bookresult}}}}|0|-2}}<br/>|}}{{
-{{#if:{{#var:bookresult}}|'''Books:''' {{#sub:{{#var:bookresult}}|0|-2}}<br/>|}}
+#if:{{#var:musicresult}}|'''Music:''' {{#sub:{{UnformatSQL|{{#var:musicresult}}}}|0|-2}}<br/>|}}{{
-{{#if:{{#var:prereleaseresult}}|'''Prereleases:''' {{#sub:{{#var:prereleaseresult}}|0|-2}}<br/>|}}
+#if:{{#var:audiobookresult}}|'''Audiobooks:''' {{#sub:{{UnformatSQL|{{#var:audiobookresult}}}}|0|-2}}<br/>|}}{{
-{{clearvar|musicresult|bookresult|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.

Template

Difference between revisions of "OmniMedia"

From Sega Retro

Latest revision as of 11:15, 22 February 2023

Examples