Difference between revisions of "CompanyHistory"
From Sega Retro
(Undo revision 805491 by Black Squirrel (talk)) Tag: Undo |
|||
(21 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
− | <includeonly><span style="display:none;">{{#if:{{{1|}}}|{{#vardefine:companyname|{{{1}}}}}{{#vardefine:command|companies.company="{{{1}}}"}}{{#fornumargs: n | + | <includeonly>{{#vardefine:results|}}<span style="display:none;">{{#if:{{{1|}}}|{{#vardefine:companyname|{{{1}}}}}{{#vardefine:command|companies.company="{{{1}}}"}}{{#fornumargs: n |
| value | | value | ||
| {{#vardefine:nameList|{{#var:nameList}},{{#var:value}}}}{{#ifexpr:{{#var:n}} > 1|{{#vardefine:command|{{#var:command}} OR companies.company="{{#var:value}}"}}|}} | | {{#vardefine:nameList|{{#var:nameList}},{{#var:value}}}}{{#ifexpr:{{#var:n}} > 1|{{#vardefine:command|{{#var:command}} OR companies.company="{{#var:value}}"}}|}} | ||
− | }}</span>{{#cargo_query: | + | }}</span>{{#vardefine:results|{{#var:results}}{{#cargo_query: |
− | table=companies,releases | + | table=companies,releases,codeformat |
− | |fields=companies.name=companiesname,releases.name=releasesname,releases.date,companies.company,companies.format,companies.role,companies.credited | + | |fields=companies.name=companiesname,releases.name=releasesname,releases.date,companies.company,companies.format,companies.role,companies.credited,codeformat.code=test,codeformat.format=test2,companies.specificrole |
− | |join on=companies.name=releases.name | + | |join on=companies.name=releases.name,releases.console=codeformat.code |
|group by=releases.name | |group by=releases.name | ||
− | |where=({{#var:command}}) {{#if:{{{role|}}}|and (companies.role LIKE "{{{role|}}}%")}} {{#if:{{{format|}}}|and (companies.format | + | |order by=releases.date,releases.name |
− | | | + | |where=({{#var:command}}) {{#if:{{{role|}}}|and (companies.role LIKE "{{{role|}}}%")}} {{#ifeq:{{{type|}}}|hardware||{{#if:{{{format|}}}|and (companies.format="{{{format|}}}") and (codeformat.format="{{{format|}}}")}}}} {{#switch:{{{type|}}} |
+ | |accessories=and releases.type="1"{{#vardefine:italics|}} | ||
+ | |hardware=and (releases.type="2" or releases.type="-1"){{#vardefine:italics|}} | ||
+ | |#default=and not releases.type="1" and not releases.type="2" and not releases.type="-1"{{#vardefine:italics|yes}} | ||
+ | }} | ||
|format=template | |format=template | ||
|limit=1000 | |limit=1000 | ||
|template=CompanyHistory/Cargo | |template=CompanyHistory/Cargo | ||
− | }}}}</includeonly><noinclude> | + | |default= |
+ | }}{{#ifeq:{{{type|}}}|accessories||{{#cargo_query: | ||
+ | table=unreleased,companies | ||
+ | |fields=companies.name=companiesname,unreleased.name=releasesname,unreleased.date,companies.company,companies.format,companies.role,companies.credited | ||
+ | |join on=unreleased.name=companies.name | ||
+ | |group by=unreleased.name | ||
+ | |order by=unreleased.date,unreleased.name | ||
+ | |where=({{#var:command}}) {{#if:{{{role|}}}|and (companies.role LIKE "{{{role|}}}%")}} {{#if:{{{format|}}}|and (companies.format="{{{format|}}}")}} | ||
+ | |format=template | ||
+ | |limit=1000 | ||
+ | |template=CompanyHistory/Cargo/Unreleased | ||
+ | |default= | ||
+ | }}}}}}}}{{#var:results}}</includeonly><noinclude> | ||
Template to list a company's softography. It's a bit crude. | Template to list a company's softography. It's a bit crude. | ||
Line 29: | Line 45: | ||
{{CompanyHistory|Sega|format=32X|role=Licensor}} | {{CompanyHistory|Sega|format=32X|role=Licensor}} | ||
− | [[Category: | + | [[Category:Templates]] |
</noinclude> | </noinclude> |
Revision as of 08:01, 12 August 2022
Template to list a company's softography. It's a bit crude.
e.g. Sega, 32X:
Publisher
{{CompanyHistory|Sega|format=32X|role=Publisher}}
Query: SELECT `cargo__companies`.`name` AS `companiesname`,`cargo__releases`.`name` AS `releasesname`,`cargo__releases`.`date` AS `date`,`cargo__companies`.`company` AS `company`,`cargo__companies`.`format` AS `format`,`cargo__companies`.`role` AS `role`,`cargo__companies`.`credited` AS `credited`,`cargo__codeformat`.`code` AS `test`,`cargo__codeformat`.`format` AS `test2`,`cargo__companies`.`specificrole` AS `specificrole` FROM `cargo__companies` LEFT OUTER JOIN `cargo__releases` ON ((`cargo__companies`.`name`=`cargo__releases`.`name`)) LEFT OUTER JOIN `cargo__codeformat` ON ((`cargo__releases`.`console`=`cargo__codeformat`.`code`)) WHERE (`cargo__companies`.`company`="Sega") and (`cargo__companies`.`role` LIKE "Publisher%") and (`cargo__companies`.`format`="32X") and (`cargo__codeformat`.`format`="32X") and not `cargo__releases`.`type`="1" and not `cargo__releases`.`type`="2" and not `cargo__releases`.`type`="-1" GROUP BY `cargo__releases`.`name` ORDER BY `cargo__releases`.`date`,`cargo__releases`.`name` LIMIT 1000 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-29ea76-a.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)
Query: SELECT `cargo__companies`.`name` AS `companiesname`,`cargo__unreleased`.`name` AS `releasesname`,`cargo__unreleased`.`date` AS `date`,`cargo__companies`.`company` AS `company`,`cargo__companies`.`format` AS `format`,`cargo__companies`.`role` AS `role`,`cargo__companies`.`credited` AS `credited` FROM `cargo__unreleased` LEFT OUTER JOIN `cargo__companies` ON ((`cargo__unreleased`.`name`=`cargo__companies`.`name`)) WHERE (`cargo__companies`.`company`="Sega") and (`cargo__companies`.`role` LIKE "Publisher%") and (`cargo__companies`.`format`="32X") GROUP BY `cargo__unreleased`.`name` ORDER BY `cargo__unreleased`.`date`,`cargo__unreleased`.`name` LIMIT 1000 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-29ea76-d.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)
Developer
{{CompanyHistory|Sega|Sega CS|format=32X|role=Developer}}
Query: SELECT `cargo__companies`.`name` AS `companiesname`,`cargo__releases`.`name` AS `releasesname`,`cargo__releases`.`date` AS `date`,`cargo__companies`.`company` AS `company`,`cargo__companies`.`format` AS `format`,`cargo__companies`.`role` AS `role`,`cargo__companies`.`credited` AS `credited`,`cargo__codeformat`.`code` AS `test`,`cargo__codeformat`.`format` AS `test2`,`cargo__companies`.`specificrole` AS `specificrole` FROM `cargo__companies` LEFT OUTER JOIN `cargo__releases` ON ((`cargo__companies`.`name`=`cargo__releases`.`name`)) LEFT OUTER JOIN `cargo__codeformat` ON ((`cargo__releases`.`console`=`cargo__codeformat`.`code`)) WHERE (`cargo__companies`.`company`="Sega" OR `cargo__companies`.`company`="Sega CS") and (`cargo__companies`.`role` LIKE "Developer%") and (`cargo__companies`.`format`="32X") and (`cargo__codeformat`.`format`="32X") and not `cargo__releases`.`type`="1" and not `cargo__releases`.`type`="2" and not `cargo__releases`.`type`="-1" GROUP BY `cargo__releases`.`name` ORDER BY `cargo__releases`.`date`,`cargo__releases`.`name` LIMIT 1000 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-29ea76-11.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)
Query: SELECT `cargo__companies`.`name` AS `companiesname`,`cargo__unreleased`.`name` AS `releasesname`,`cargo__unreleased`.`date` AS `date`,`cargo__companies`.`company` AS `company`,`cargo__companies`.`format` AS `format`,`cargo__companies`.`role` AS `role`,`cargo__companies`.`credited` AS `credited` FROM `cargo__unreleased` LEFT OUTER JOIN `cargo__companies` ON ((`cargo__unreleased`.`name`=`cargo__companies`.`name`)) WHERE (`cargo__companies`.`company`="Sega" OR `cargo__companies`.`company`="Sega CS") and (`cargo__companies`.`role` LIKE "Developer%") and (`cargo__companies`.`format`="32X") GROUP BY `cargo__unreleased`.`name` ORDER BY `cargo__unreleased`.`date`,`cargo__unreleased`.`name` LIMIT 1000 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-29ea76-14.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)
Licensor
{{CompanyHistory|Sega|format=32X|role=Licensor}}
Query: SELECT `cargo__companies`.`name` AS `companiesname`,`cargo__releases`.`name` AS `releasesname`,`cargo__releases`.`date` AS `date`,`cargo__companies`.`company` AS `company`,`cargo__companies`.`format` AS `format`,`cargo__companies`.`role` AS `role`,`cargo__companies`.`credited` AS `credited`,`cargo__codeformat`.`code` AS `test`,`cargo__codeformat`.`format` AS `test2`,`cargo__companies`.`specificrole` AS `specificrole` FROM `cargo__companies` LEFT OUTER JOIN `cargo__releases` ON ((`cargo__companies`.`name`=`cargo__releases`.`name`)) LEFT OUTER JOIN `cargo__codeformat` ON ((`cargo__releases`.`console`=`cargo__codeformat`.`code`)) WHERE (`cargo__companies`.`company`="Sega") and (`cargo__companies`.`role` LIKE "Licensor%") and (`cargo__companies`.`format`="32X") and (`cargo__codeformat`.`format`="32X") and not `cargo__releases`.`type`="1" and not `cargo__releases`.`type`="2" and not `cargo__releases`.`type`="-1" GROUP BY `cargo__releases`.`name` ORDER BY `cargo__releases`.`date`,`cargo__releases`.`name` LIMIT 1000 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-29ea76-18.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)
Query: SELECT `cargo__companies`.`name` AS `companiesname`,`cargo__unreleased`.`name` AS `releasesname`,`cargo__unreleased`.`date` AS `date`,`cargo__companies`.`company` AS `company`,`cargo__companies`.`format` AS `format`,`cargo__companies`.`role` AS `role`,`cargo__companies`.`credited` AS `credited` FROM `cargo__unreleased` LEFT OUTER JOIN `cargo__companies` ON ((`cargo__unreleased`.`name`=`cargo__companies`.`name`)) WHERE (`cargo__companies`.`company`="Sega") and (`cargo__companies`.`role` LIKE "Licensor%") and (`cargo__companies`.`format`="32X") GROUP BY `cargo__unreleased`.`name` ORDER BY `cargo__unreleased`.`date`,`cargo__unreleased`.`name` LIMIT 1000 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-29ea76-1b.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)