Difference between revisions of "Magref"

From Sega Retro

(shouldn't break things any more)
Line 1: Line 1:
<includeonly><span style="display:none;">{{#vardefine:pubcode|{{{1}}}}}{{#vardefine:issueno|{{{2}}}}}{{#vardefine:page|{{{3|}}}}}{{#vardefine:printpage|{{{printpage|}}}}}{{#ifeq:{{#var:printpage}}|{{#var:page}}|{{#vardefine:printpage|}}|}}{{#cargo_query:
+
<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=magref/Cargo
+
|template=Magref/Cargo
}}</span>{{#if: {{#var:filename}} | {{#ifexist:File:{{#var:filename}}|<span style="display:none;">[[Media:{{#var:filename}}]]</span>}}{{#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]]
+
|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

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

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

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

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

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

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)

[3]

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

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)

[4]

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

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].

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

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)

[6]

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

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)

[7]

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

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)

[8]

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

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)

[9]

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

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)

[10]

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>}}


References

  1. ', "" (; ), page 34
  2. ', "" (; ), page 20
  3. ', "" (; ), page 2
  4. ', "" (; ), page 20
  5. ', "" (; ), page 45
  6. ', "" (; )
  7. ', "" (; ), page 45 (60-68)
  8. ', "" (; ), page 46
  9. ', "" (; ), page 1
  10. ', "" (; ), page 1 (2/3)