Difference between revisions of "Magref"
From Sega Retro
(shouldn't break things any more) |
|||
Line 1: | Line 1: | ||
− | <includeonly | + | <includeonly>{{#vardefine:pubcode|{{{1|}}}}}{{#vardefine:issueno|{{{2|}}}}}{{#vardefine:page|{{{3|}}}}}{{#vardefine:printpage|{{{printpage|}}}}}{{#ifeq:{{#var:printpage}}|{{#var:page}}|{{clearvar|printpage}}}}{{#cargo_query: |
tables=issuenames,magnames | tables=issuenames,magnames | ||
|fields=issuenames.name=issuename,issuenames.date,issuenames.pdf,magnames.name=magname,magnames.country | |fields=issuenames.name=issuename,issuenames.date,issuenames.pdf,magnames.name=magname,magnames.country | ||
Line 6: | Line 6: | ||
|limit=1 | |limit=1 | ||
|format=template | |format=template | ||
− | |template= | + | |template=Magref/Cargo |
− | }} | + | |more results text= |
+ | }}{{#cargo_store: | ||
+ | _table = filerefs | ||
+ | | name={{FULLPAGENAME}} | ||
+ | | file={{#replace:{{#var:filename}}|_|<nowiki/> <nowiki/>}} | ||
+ | | filepage={{#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]] | ||
This is an improved version of the fileref template{{magref|mms|12|34}}. You only need to specify a code, issue and page{{magref|edge|10|20}}, the rest should be done for you{{magref|hyper|1|2}}{{magref|edge|10|20}}{{magref|mms|34|45}}.{{magref|cvg|93a}}{{magref|mms|35|45|printpage=60-68}}{{magref|mms|35|46|printpage=46}} | This is an improved version of the fileref template{{magref|mms|12|34}}. You only need to specify a code, issue and page{{magref|edge|10|20}}, the rest should be done for you{{magref|hyper|1|2}}{{magref|edge|10|20}}{{magref|mms|34|45}}.{{magref|cvg|93a}}{{magref|mms|35|45|printpage=60-68}}{{magref|mms|35|46|printpage=46}} |
Revision as of 20:53, 11 February 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: 14 Can't change size of file (Errcode: 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: 14 Can't change size of file (Errcode: 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: 14 Can't change size of file (Errcode: 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: 14 Can't change size of file (Errcode: 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: 14 Can't change size of file (Errcode: 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: 14 Can't change size of file (Errcode: 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: 14 Can't change size of file (Errcode: 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: 14 Can't change size of file (Errcode: 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: 14 Can't change size of file (Errcode: 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: 14 Can't change size of file (Errcode: 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>}}