Difference between revisions of "Magref"
From Sega Retro
(shouldn't break things any more) |
|||
Line 8: | Line 8: | ||
|template=Magref/Cargo | |template=Magref/Cargo | ||
|more results text= | |more results text= | ||
− | }}{{ | + | }}{{FilerefStore |
− | |||
| name={{FULLPAGENAME}} | | name={{FULLPAGENAME}} | ||
− | | file= | + | | file={{#var:filename}} |
− | | | + | | page={{#var:page}} |
}}{{#if: {{#var:filename}} | {{#tag: ref | {{#if: {{#var:page}} | [{{fullurl:File:{{#var:filename}}|page={{#var:page}}}} ''{{#var:pubname}}'', "{{#var:issuename}}" ({{#var:country}}; {{#var:date}}), page {{#if:{{#var:printpage}}|{{#var:printpage}} ({{#var:page}})|{{#var:page}}}} ] | [[:File:{{#var:filename}}]]}} | name=":File:{{#var:filename}}_p{{#var:page}} {{#if:{{#var:printpage}}|({{#var:printpage}})|}}" }} | {{#tag: ref | ''{{#var:pubname}}'', "{{#var:issuename}}" ({{#var:country}}; {{#var:date}}){{#if:{{#var:page}}|, page {{#var:page}} {{#if:{{#var:printpage}}|({{#var:printpage}})|}} }} }}}}{{incvar|refcount}}</includeonly><noinclude>[[Category:Sega Retro templates]] | }}{{#if: {{#var:filename}} | {{#tag: ref | {{#if: {{#var:page}} | [{{fullurl:File:{{#var:filename}}|page={{#var:page}}}} ''{{#var:pubname}}'', "{{#var:issuename}}" ({{#var:country}}; {{#var:date}}), page {{#if:{{#var:printpage}}|{{#var:printpage}} ({{#var:page}})|{{#var:page}}}} ] | [[:File:{{#var:filename}}]]}} | name=":File:{{#var:filename}}_p{{#var:page}} {{#if:{{#var:printpage}}|({{#var:printpage}})|}}" }} | {{#tag: ref | ''{{#var:pubname}}'', "{{#var:issuename}}" ({{#var:country}}; {{#var:date}}){{#if:{{#var:page}}|, page {{#var:page}} {{#if:{{#var:printpage}}|({{#var:printpage}})|}} }} }}}}{{incvar|refcount}}</includeonly><noinclude>[[Category:Sega Retro templates]] | ||
Revision as of 00:30, 18 May 2020
This is an improved version of the fileref template
Query: SELECT `cargo__issuenames`.`name` AS `issuename`,`cargo__issuenames`.`date` AS `date`,`cargo__issuenames`.`pdf` AS `pdf`,`cargo__magnames`.`name` AS `magname`,`cargo__magnames`.`country` AS `country` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="mms" and `cargo__issuenames`.`num`="12" ORDER BY `cargo__issuenames`.`name`,`cargo__issuenames`.`date`,`cargo__issuenames`.`pdf`,`cargo__magnames`.`name`,`cargo__magnames`.`country` LIMIT 1 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-2596d4d-4.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)
[1]. You only need to specify a code, issue and page
Query: SELECT `cargo__issuenames`.`name` AS `issuename`,`cargo__issuenames`.`date` AS `date`,`cargo__issuenames`.`pdf` AS `pdf`,`cargo__magnames`.`name` AS `magname`,`cargo__magnames`.`country` AS `country` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="edge" and `cargo__issuenames`.`num`="10" ORDER BY `cargo__issuenames`.`name`,`cargo__issuenames`.`date`,`cargo__issuenames`.`pdf`,`cargo__magnames`.`name`,`cargo__magnames`.`country` LIMIT 1 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-2596d4d-8.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)
[2], the rest should be done for you
Query: SELECT `cargo__issuenames`.`name` AS `issuename`,`cargo__issuenames`.`date` AS `date`,`cargo__issuenames`.`pdf` AS `pdf`,`cargo__magnames`.`name` AS `magname`,`cargo__magnames`.`country` AS `country` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="hyper" and `cargo__issuenames`.`num`="1" ORDER BY `cargo__issuenames`.`name`,`cargo__issuenames`.`date`,`cargo__issuenames`.`pdf`,`cargo__magnames`.`name`,`cargo__magnames`.`country` LIMIT 1 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-2596d4d-c.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)
Query: SELECT `cargo__issuenames`.`name` AS `issuename`,`cargo__issuenames`.`date` AS `date`,`cargo__issuenames`.`pdf` AS `pdf`,`cargo__magnames`.`name` AS `magname`,`cargo__magnames`.`country` AS `country` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="edge" and `cargo__issuenames`.`num`="10" ORDER BY `cargo__issuenames`.`name`,`cargo__issuenames`.`date`,`cargo__issuenames`.`pdf`,`cargo__magnames`.`name`,`cargo__magnames`.`country` LIMIT 1 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-2596d4d-10.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)
Query: SELECT `cargo__issuenames`.`name` AS `issuename`,`cargo__issuenames`.`date` AS `date`,`cargo__issuenames`.`pdf` AS `pdf`,`cargo__magnames`.`name` AS `magname`,`cargo__magnames`.`country` AS `country` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="mms" and `cargo__issuenames`.`num`="34" ORDER BY `cargo__issuenames`.`name`,`cargo__issuenames`.`date`,`cargo__issuenames`.`pdf`,`cargo__magnames`.`name`,`cargo__magnames`.`country` LIMIT 1 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-2596d4d-14.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)
[5].
Query: SELECT `cargo__issuenames`.`name` AS `issuename`,`cargo__issuenames`.`date` AS `date`,`cargo__issuenames`.`pdf` AS `pdf`,`cargo__magnames`.`name` AS `magname`,`cargo__magnames`.`country` AS `country` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="cvg" and `cargo__issuenames`.`num`="93a" ORDER BY `cargo__issuenames`.`name`,`cargo__issuenames`.`date`,`cargo__issuenames`.`pdf`,`cargo__magnames`.`name`,`cargo__magnames`.`country` LIMIT 1 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-2596d4d-18.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)
Query: SELECT `cargo__issuenames`.`name` AS `issuename`,`cargo__issuenames`.`date` AS `date`,`cargo__issuenames`.`pdf` AS `pdf`,`cargo__magnames`.`name` AS `magname`,`cargo__magnames`.`country` AS `country` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="mms" and `cargo__issuenames`.`num`="35" ORDER BY `cargo__issuenames`.`name`,`cargo__issuenames`.`date`,`cargo__issuenames`.`pdf`,`cargo__magnames`.`name`,`cargo__magnames`.`country` LIMIT 1 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-2596d4d-1c.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)
Query: SELECT `cargo__issuenames`.`name` AS `issuename`,`cargo__issuenames`.`date` AS `date`,`cargo__issuenames`.`pdf` AS `pdf`,`cargo__magnames`.`name` AS `magname`,`cargo__magnames`.`country` AS `country` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="mms" and `cargo__issuenames`.`num`="35" ORDER BY `cargo__issuenames`.`name`,`cargo__issuenames`.`date`,`cargo__issuenames`.`pdf`,`cargo__magnames`.`name`,`cargo__magnames`.`country` LIMIT 1 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-2596d4d-20.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)
Query: SELECT `cargo__issuenames`.`name` AS `issuename`,`cargo__issuenames`.`date` AS `date`,`cargo__issuenames`.`pdf` AS `pdf`,`cargo__magnames`.`name` AS `magname`,`cargo__magnames`.`country` AS `country` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="cvg" and `cargo__issuenames`.`num`="100" ORDER BY `cargo__issuenames`.`name`,`cargo__issuenames`.`date`,`cargo__issuenames`.`pdf`,`cargo__magnames`.`name`,`cargo__magnames`.`country` LIMIT 1 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-2596d4d-24.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)
Query: SELECT `cargo__issuenames`.`name` AS `issuename`,`cargo__issuenames`.`date` AS `date`,`cargo__issuenames`.`pdf` AS `pdf`,`cargo__magnames`.`name` AS `magname`,`cargo__magnames`.`country` AS `country` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="cvg" and `cargo__issuenames`.`num`="100" ORDER BY `cargo__issuenames`.`name`,`cargo__issuenames`.`date`,`cargo__issuenames`.`pdf`,`cargo__magnames`.`name`,`cargo__magnames`.`country` LIMIT 1 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-2596d4d-28.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)
Usage
{{magref|<CODE>|<ISSUE>|<PAGE>}}
PAGE is always the PDF page number. If the magazine has its page numbering system shifted, or multiple pages are being referenced, use the optional "printpage" argument:
{{magref|<CODE>|<ISSUE>|<PAGE>|printpage=<PRINTPAGE>}}