Jump to content

Yearly/Monthly Pages and Issue Milestones?


Phillyman
 Share

Recommended Posts

  • Retromags Curator

As we put more and more information into the Magazine Database, I can extract said information and present it in new ways. One such idea that I am toying with is creating monthly pages. We would have a year folder such as 1983, and within that folder would be each month. Users could browse to September 1983 and any magazines that published a mag in that month would display. I could also do the same with issue numbers, maybe a page for premier issues, issues 25, issues 50, issues 100, issues 150...etc

These pages would be static, I could look into what it would cost to have someone write a PHP script to pull the information dynamically.

Quick Mockup

August1997.png

  • Like 1
Link to comment
Share on other sites

I'm not saying I would use such a feature, but displaying all the mags in a given month might be kind of neat.  I can't say I have any interest in grouping together "milestone" issues, though.

My dream would be able to type in the name of a game and get an index of all issues it was reviewed in along with the score it was given in each (if applicable), with links to their DB/download pages.  Gamerankings has something like this that includes online reviews with print mag reviews, but their inclusion of print mag reviews is far from complete, particularly with older games.  And while reviews would be my main interest, being able to find what issues had feature articles/previews/strategy guides for a given game would be nice as well.  No need for indexing stuff like codes - that's what Gamefaqs/the internet is for.:)

Of course, we're nowhere remotely near being able to do anything like this, and probably never will be, but dreams don't have to be realistic.:)

  • Like 2
Link to comment
Share on other sites

  • Retromags Curator
28 minutes ago, kitsunebi77 said:

My dream would be able to type in the name of a game and get an index of all issues it was reviewed in along with the score it was given in each (if applicable), with links to their DB/download pages.  Gamerankings has something like this that includes online reviews with print mag reviews, but their inclusion of print mag reviews is far from complete, particularly with older games.  And while reviews would be my main interest, being able to find what issues had feature articles/previews/strategy guides for a given game would be nice as well.  No need for indexing stuff like codes - that's what Gamefaqs/the internet is for.:)

Of course, we're nowhere remotely near being able to do anything like this, and probably never will be, but dreams don't have to be realistic.:)

I don't think we are as far off as you think we are from that. This software allows us to cross reference records with each other. I can create another database, call it Master Database

Video Game <---- pulls titles from the existing VG database as you type

Magazines <----- pulls titles from existing Mag database as you type

Pages <---- page(s) that the information is on

Mention Type <----- is it a review, preview, code, poster, etc

Review Score <--- if a review score, how was it rated

System <--- What game system was it for

Related Games <----for titles that span multiple systems

Download Link <--- Self explainitory

 

So then you would end up with a record......

 

 

 

Link to comment
Share on other sites

50 minutes ago, kitsunebi77 said:

My dream would be able to type in the name of a game and get an index of all issues it was reviewed in along with the score it was given in each (if applicable), with links to their DB/download pages.

I started this last year but it's turned into a ridiculously huge undertaking

1MiAx0C.jpg

You can click on the publication to see all the games they reviewed, click on the issue to see games in that issue, or click on the game itself to see which mags reviewed it, etc

Haven't really done any American mags though. All UK stuff.

  • Like 1
Link to comment
Share on other sites

10 hours ago, kitsunebi77 said:

My dream would be able to type in the name of a game and get an index of all issues it was reviewed in along with the score it was given in each (if applicable), with links to their DB/download pages.  Gamerankings has something like this that includes online reviews with print mag reviews, but their inclusion of print mag reviews is far from complete, particularly with older games.  And while reviews would be my main interest, being able to find what issues had feature articles/previews/strategy guides for a given game would be nice as well.  No need for indexing stuff like codes - that's what Gamefaqs/the internet is for.:)

Of course, we're nowhere remotely near being able to do anything like this, and probably never will be, but dreams don't have to be realistic.:)

I was watching the latest season of Halt and Catch fire last night and became inspired by Joe McMillan, a fictional character who made it big in Silicon Valley as CEO for IBM, then Computer Hardware and now web browsers and search algorithms.  There was a time when we had the world wide web but we never had Lycos, Yahoo or Google.  These companies built algorithms which crawled the internet and indexing web pages automatically.  

We have an advantage right now, a relatively limited amount of magazines to index and the tools to do it.  If somebody was to have all the magazines on one hard drive and then they converted it to PDF, they could hold the data needed to index it page for page, title for title and word for word.  This could be relatively easy to do for private use but the problem for me would be coding it so website users could use it.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

  • Recent Achievements

    • Prisma earned a badge
      Member for 1 Day
    • Prisma earned a badge
      Member for 3 Months
    • Prisma earned a badge
      Member for 6 Months
    • Blake00 earned a badge
      Member for 1 Day
    • Blake00 earned a badge
      Member for 3 Months
×
×
  • Create New...