Difference between revisions of "Magrow"

From Sega Retro

Line 1: Line 1:
 
<includeonly><span style="display:none;">{{#vardefine:oldmagrow|}}{{#if:{{{file|}}}|{{#ifexpr:{{#pos:{{{file|}}}|.pdf}}>0|[[Category:Old magrow template]]{{#vardefine:oldmagrow|yes}}|}}|}}{{#vardefine:magrowpubcode|{{{1|{{{source}}}}}}}}{{#vardefine:issueno|{{{2|{{{issueno}}}}}}}}{{#vardefine:page|{{{3|{{{page}}}}}}}}{{#cargo_query:
 
<includeonly><span style="display:none;">{{#vardefine:oldmagrow|}}{{#if:{{{file|}}}|{{#ifexpr:{{#pos:{{{file|}}}|.pdf}}>0|[[Category:Old magrow template]]{{#vardefine:oldmagrow|yes}}|}}|}}{{#vardefine:magrowpubcode|{{{1|{{{source}}}}}}}}{{#vardefine:issueno|{{{2|{{{issueno}}}}}}}}{{#vardefine:page|{{{3|{{{page}}}}}}}}{{#cargo_query:
 
tables=issuenames,magnames
 
tables=issuenames,magnames
|fields=issuenames.name=issuename,issuenames.date,issuenames.pdf,magnames.name=magname,magnames.country,,magnames.link
+
|fields=issuenames.name=issuename,issuenames.date,issuenames.pdf,magnames.name=magname,magnames.country,magnames.link
 
|where=issuenames.code="{{#var:magrowpubcode}}" and issuenames.num="{{#var:issueno}}"
 
|where=issuenames.code="{{#var:magrowpubcode}}" and issuenames.num="{{#var:issueno}}"
 
|join on=issuenames.code=magnames.code
 
|join on=issuenames.code=magnames.code
Line 11: Line 11:
 
|style="vertical-align:top"|{{#if: {{#var:filename}} | {{#if: {{{cover|}}} | [[File:{{#var:filename}}|120x120px|page=1]] | }} {{#ifeq:{{fileext|{{#var:filename}}}}|pdf| [[File:Logo-pdf.svg|120x120px|link={{fullurl:File:{{#var:filename}}|page={{#var:page}}}}]] | [[File:{{#var:filename}}|120x120px]] }} }}
 
|style="vertical-align:top"|{{#if: {{#var:filename}} | {{#if: {{{cover|}}} | [[File:{{#var:filename}}|120x120px|page=1]] | }} {{#ifeq:{{fileext|{{#var:filename}}}}|pdf| [[File:Logo-pdf.svg|120x120px|link={{fullurl:File:{{#var:filename}}|page={{#var:page}}}}]] | [[File:{{#var:filename}}|120x120px]] }} }}
 
|style="vertical-align:top"|{{#var:date}}
 
|style="vertical-align:top"|{{#var:date}}
|style="vertical-align:top"|{{#if:{{#var:pubname}}|''{{#var:pubname}}'' ({{#var:country}}), "{{#var:issuename}}"|{{#if:{{#var:issuename}}||[[Category:Bad magazine reference]]}}}}
+
|style="vertical-align:top"|{{#if:{{#var:pubname}}|''[[{{#var:publink}}|{{#var:pubname}}]]'' ({{#var:country}}), "{{#var:issuename}}"|{{#if:{{#var:issuename}}||[[Category:Bad magazine reference]]}}}}
 
|style="vertical-align:top"}}|{{#if:{{#var:oldmagrow}}|<span style="color:#FF0000;"><b>Editors: PDF magazine with "file" parameter - add to or use [[:Template:IssueNameStore]]</b></span><br/>|}}{{#if: {{{title|}}} | '''"{{{title}}}"'''<br> | }}{{{comment|}}}
 
|style="vertical-align:top"}}|{{#if:{{#var:oldmagrow}}|<span style="color:#FF0000;"><b>Editors: PDF magazine with "file" parameter - add to or use [[:Template:IssueNameStore]]</b></span><br/>|}}{{#if: {{{title|}}} | '''"{{{title}}}"'''<br> | }}{{{comment|}}}
 
{{#if:{{#var:ratingrow}}|{{ConvertRating|{{#if:{{{ratingsystem|}}}|{{{ratingsystem}}}|{{GetDefaultRatingSystem|{{#var:magrowpubcode}}}}}}|{{{rating|}}}}}
 
{{#if:{{#var:ratingrow}}|{{ConvertRating|{{#if:{{{ratingsystem|}}}|{{{ratingsystem}}}|{{GetDefaultRatingSystem|{{#var:magrowpubcode}}}}}}|{{{rating|}}}}}
Line 116: Line 116:
 
}}
 
}}
 
}}
 
}}
 
 
[[Category:Sega Retro templates]]
 
[[Category:Sega Retro templates]]
 
</noinclude>
 
</noinclude>

Revision as of 08:19, 22 April 2020

This template defines the table "ratings". View table.

See Template:Magtable for usage.

Back to: [[]].
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`,`cargo__magnames`.`link` AS `link` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="cvg" and `cargo__issuenames`.`num`="120" 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-d0a7cf-553.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

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`,`cargo__magnames`.`link` AS `link` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="cvg" and `cargo__issuenames`.`num`="120" 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-d0a7cf-557.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

Expression error: Unexpected > operator.
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`,`cargo__magnames`.`link` AS `link` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="igr" and `cargo__issuenames`.`num`="5" 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-d0a7cf-55b.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

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`,`cargo__magnames`.`link` AS `link` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="mm" and `cargo__issuenames`.`num`="5" 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-d0a7cf-55f.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

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`,`cargo__magnames`.`link` AS `link` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="gamepro" and `cargo__issuenames`.`num`="5" 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-d0a7cf-569.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

Expression error: Unexpected > operator.
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`,`cargo__magnames`.`link` AS `link` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="igr" and `cargo__issuenames`.`num`="5" 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-d0a7cf-56f.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

File Date Source Title and comments
Logo-pdf.svg Editors: PDF magazine with "file" parameter - add to or use Template:IssueNameStore
"Old style"
"New style"
Igromania 5 BG Lunacy PD II.jpg
Commenty comments

lots of commments

so many comments

Review
Version Rating Awards Calculated score
NTSC-J 3%
Initially misprinted, corrected in issue #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`="mega" and `cargo__issuenames`.`num`="5" 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-d0a7cf-564.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

[1]
Mega Game
3
[Info]
Commenty comments

lots of commments

so many comments

Review
Version Rating Awards Calculated score
NTSC-J 3/5   2.5/5   3/5   4/5
63
[Info]
Igromania 5 BG Lunacy PD II.jpg
  1. ', "" (; ), page 5