Author Topic: Welcome to PGC's New Database!  (Read 9536 times)

0 Members and 1 Guest are viewing this topic.

Offline Jonnyboy117

  • Associate Editor
  • NWR Staff
  • Score: 37
    • View Profile
    • Nintendo World Report
Welcome to PGC's New Database!
« on: February 10, 2006, 09:02:26 PM »
Read about all the new features that will make your browsing experience so much better…and the staff's lives so much easier!

Over the past few months, Michael "TYP" Cole has been slaving away at this fabulous new database for Planet GameCube, and now you are viewing the result.  Looks much the same as before, doesn't it?  But it's not.  We'll be remaking the site's cosmetics later this year; this update is all about the back-end stuff.  TYP has written a completely new database structure and ported over all the information from the old database.  (That process alone is a massive improvement over the last time we upgraded the site; when switching from Planet N2000 to Planet GameCube in late 2000, every single archived article had to be re-entered in Justin Nation's database by hand.)    


Virtually every type of article and other feature has been tweaked or reinvented in the new database.  For our beloved readers, the result is a sleeker, easier to use site that helps you get to the information you want in less time and with less hassle.  Looking for information on Eternal Darkness (maybe to answer a Planet Trivia question)?  Just type the game title in our new search box at the top-left corner of every page.  Yes, we FINALLY have a search feature!  It's a full text search that literally scans through the entire text of every article we've ever published.  And it's fast, too.    


Our massive games list has been completely overhauled.  Now release dates are displayed next to the game title and other information, so there is no separate page for release dates…it's all right there on one page.  By default, the games list shows every game in our system (currently over 1000 of them!), but you have tons of options to narrow down the list.  Want to look only at GBA games released in Australia that start with the letter H?  No problem.  You can even sort that heavily filtered list by rating, number of players, whatever.    


When you click on the name of a game, you get a page we call a game profile.  The new database has tons of new information fields in each game profile.  We can now list a separate title, publisher, release date, and content rating for each of four regions: North America, Japan, Europe, and Australia.  There's also more flexibility on how to define the number of players, including for online modes if applicable.  Of course, all this information has to be entered manually, going all the way back to the first GameCube and GBA games that we ever covered.  That's why we just hired three new Data Editors to help us fill in the (thousands and thousands) of blanks.    


Much of the beauty of the new database is in how it handles some common behind-the-scenes tasks, which makes our jobs a lot easier.  For instance, the once laborious task of uploading a large batch of screenshots can now be done with a single click.  That means we can bring you the latest media faster than before…especially during critical times like E3.  Other fixes will help us to remove broken and redundant articles more quickly, which helps to keep PGC looking clean and professional.    


Oh yeah, and you can now see THREE screenshots on most types of articles…take that, Something Awful!    


Talkback has always been a popular feature, but it used to only work for news articles.  The new database creates Talkback threads for most types of articles…reviews, impressions, editorials, and so on.  Bitching about our coverage has never been easier!    


But for now, allow me to suggest a more polite use of this feature.  If you are enjoying the new features at PGC, or are simply excited by the potential the new database brings, please visit this announcement's Talkback thread and leave a message for Michael.  He has devoted a tremendous amount of time to this project, and although the time of a guy this talented is quite valuable, he is doing it for free in true PGC fashion.  Send your love.

THE LAMB IS WATCHING!

Offline Pryopizm

  • Staff Jedis-Are-Evil
  • Score: 0
    • View Profile
RE:Welcome to PGC's New Database!
« Reply #1 on: February 10, 2006, 09:14:34 PM »
TYP is truly a god among men.
"Bullets, my only weakness.  How did you know?"

Offline breakyboy

  • round the corner fudge is made
  • Score: 0
    • View Profile
RE:Welcome to PGC's New Database!
« Reply #2 on: February 10, 2006, 09:35:24 PM »
I'm going to keep this very brief because the memories and frustrations and, well, etcetera are kind of bubbling up to a frothy mess over here.

First of all: It's about damned time! (Note: not directed at TYP)

Second of all: Congratulations! (Note: Directed primarily to TYP, but also to PGC in general for this nice step forward)

Yeah, that's about as far as I can go without delving into ramble that will likely devolve into expletives. :3 ^____________^ :3  

Offline King of Twitch

  • twitch.tv/zapr2k i live for this
  • Score: 141
    • View Profile
RE:Welcome to PGC's New Database!
« Reply #3 on: February 10, 2006, 09:36:18 PM »
The format in the reviews/previews/etc section is perfect. You can look at the listings by system and ranking at the same time or by letter or date reviewed or...  
"I deem his stream to be supreme and highly esteem his Fortnite team!" - The Doritos Pope and his Mountain Dew Crew.

Offline Dasmos

  • Needs Him Some Tang in His Lollies
  • Score: 52
    • View Profile
RE:Welcome to PGC's New Database!
« Reply #4 on: February 10, 2006, 10:14:23 PM »
Holy crap! I just took a small look so far, but it really is easier to navigate. Awesome job, TYP.
Images are not allowed in signatures. That includes moving images (video).

Offline Shecky

  • Posts: 0
  • Score: 3
    • View Profile
RE: Welcome to PGC's New Database!
« Reply #5 on: February 11, 2006, 03:19:04 AM »
I agree with breakyboy's points

Offline vudu

  • You'd probably all be better off if I really were dead.
  • NWR Junior Ranger
  • Score: -19
    • View Profile
RE: Welcome to PGC's New Database!
« Reply #6 on: February 11, 2006, 03:51:27 AM »
This is a huge improvement.  Thanks TYP (and anyone else who contributed).
Why must all things be so bright? Why can things not appear only in hues of brown! I am so serious about this! Dull colors are the future! The next generation! I will never accept a world with such bright colors! It is far too childish! I will rage against your cheery palette with my last breath!

Offline UncleBob

  • (PATRON)
  • NWR Junior Ranger
  • Score: 98
    • View Profile
RE: Welcome to PGC's New Database!
« Reply #7 on: February 11, 2006, 04:10:48 AM »
Neat.  Good job.
Just some random guy on the internet who has a different opinion of games than you.

Offline thame^

  • Score: 0
    • View Profile
RE: Welcome to PGC's New Database!
« Reply #8 on: February 11, 2006, 04:52:32 AM »
Fantastic work, thanks loads!

Offline thepoga

  • Score: 0
    • View Profile
RE: Welcome to PGC's New Database!
« Reply #9 on: February 11, 2006, 06:51:47 AM »
It really is a lot of hard work so thanks a lot! Wow, there's 17 pages of Zelda links! Good job!

Offline KnowsNothing

  • Babycakes
  • Score: 11
    • View Profile
RE: Welcome to PGC's New Database!
« Reply #10 on: February 11, 2006, 07:29:07 AM »
Sweet, three screenshots!

Seriously, awesome job.  I love the fact that everything gets put into Talkback automatically now, since that's primarily where I get my news.  Thanks TYP!
kka wakka wakka wakka wakka wakka wakka wa

Offline nickmitch

  • You can edit these yourself now?!
  • Score: 82
    • View Profile
    • FACEBOOK!
RE:Welcome to PGC's New Database!
« Reply #11 on: February 11, 2006, 07:32:48 AM »
Excellent!
TYP is awesome!
TVman is dead. I killed him and took his posts.

Offline TheYoungerPlumber

  • Thy Rod and Staff
  • NWR Staff Pro
  • Score: 10
    • View Profile
    • Nintendo World Report
RE: Welcome to PGC's New Database!
« Reply #12 on: February 11, 2006, 08:07:49 AM »
Thanks guys.
::Michael "TYP" Cole
::Associate Editor
Nintendo World Report

"Only CHEATERS mess up!" -Waluigi

Offline jtownzen2

  • Score: 0
    • View Profile
RE: Welcome to PGC's New Database!
« Reply #13 on: February 11, 2006, 09:22:36 AM »
I get an error when trying to view most pages in the latest version of Firefox.  The message below occured when I was at the list of DS games and tried to view the info on "Brain Age":

**********************************
Error Occurred While Processing Request
Element 18790965 is undefined in a Java object of type class coldfusion.runtime.CookieScope referenced as

Please try the following:

   * Enable Robust Exception Information to provide greater detail about the source of errors. In the Administrator, click Debugging & Logging > Debugging Settings, and select the Robust Exception Information option.
   * Check the ColdFusion documentation to verify that you are using the correct syntax.
   * Search the Knowledge Base to find a solution to your problem.

Browser      Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.1) Gecko/20060111 Firefox/1.5.0.1
Remote Address      ***.***.***.***
Referrer      http://www.planetgamecube.com/games.cfm?letter=&ProdType=&System=Nintendo%20DS&Order=PreferredTitle®ion=&TimeSpan=&
Date/Time      11-Feb-06 02:23 PM

**********************************

If I load that page in Internet Explorer, it then works the next time that I try to view it through Firefox.    

Offline Karl Castaneda #2

  • Staff Clone
  • Score: 4
    • View Profile
I am Karl Castaneda's news-posting clone, also known as Karl Castaneda #2. I have an inferiority complex, thanks to my being a clone. Fear me!

Offline Infernal Monkey

  • burly British nanny wrapped in a blender
  • Score: 2
    • View Profile
RE: Welcome to PGC's New Database!
« Reply #15 on: February 11, 2006, 09:40:18 AM »
This is fantastic! Thanks! =D

Offline miedo

  • Score: 0
    • View Profile
RE:Welcome to PGC's New Database!
« Reply #16 on: February 11, 2006, 10:46:53 AM »
I didn't even see the new search box.  Good job hiding it in a corner.  So I broke the search's virginity and searched for "porn".  Interesting results, including an obscure one on kitty pornography.  What did you make Louie do?!?

Offline breakyboy

  • round the corner fudge is made
  • Score: 0
    • View Profile
RE:Welcome to PGC's New Database!
« Reply #17 on: February 11, 2006, 10:59:19 AM »
Quote

Originally posted by: Shecky
I agree with breakyboy's points


You don't want on that mantrain of pain Shecky. Just no. There's a history involved here

That being said, a good night's sleep (and just maybe that hint of vodka in my orange juice) has subsided that bit of ire. Congratulations again TYP.

Offline Robageejammin

  • Score: 1
    • View Profile
RE:Welcome to PGC's New Database!
« Reply #18 on: February 11, 2006, 11:09:36 AM »
Jeez you guys are great. Really awesome job TYP. Looking forward to crazy E3 coverage.
"Luigi is the dreamy, comical poster boy of the Smash series, and everywhere he goes his slightly awkward presence is felt."
- Sakurai

Offline IceCold

  • I love you Vanilla Ice!
  • Score: 2
    • View Profile
RE:Welcome to PGC's New Database!
« Reply #19 on: February 11, 2006, 05:33:40 PM »
I never thought I'd see the day

Even though this comes at the end of the GCN's life, it will be great leading into the Revolution.

E3 just got even better.

Congrats TYP - just remember:

Winners take time to relish their work, knowing that scaling the mountain is what makes the view from the top so exhilarating.
"I used to sell furniture for a living. The trouble was, it was my own."
---------------------------------------------
"If your parents never had children, chances are you won't either."
----------------------------
"If it weren't for electricity we'd all be watching television by the candlelig

Offline TheYoungerPlumber

  • Thy Rod and Staff
  • NWR Staff Pro
  • Score: 10
    • View Profile
    • Nintendo World Report
RE: Welcome to PGC's New Database!
« Reply #20 on: February 11, 2006, 11:12:37 PM »
I think Breaky needs a hug.  Please don't be mad at me.
::Michael "TYP" Cole
::Associate Editor
Nintendo World Report

"Only CHEATERS mess up!" -Waluigi

Offline bananaboy

  • Score: 0
    • View Profile
RE:Welcome to PGC's New Database!
« Reply #21 on: February 12, 2006, 05:03:52 AM »
RSS at last  Such a great back-end overhaul, can't wait to see the graphical overhaul when you conver to planet revolution (or whatever it may be)
Currently Playing: Zelda Twilight Princess, Trauma Center Second Opinion, Guitar Hero 2

Offline TheYoungerPlumber

  • Thy Rod and Staff
  • NWR Staff Pro
  • Score: 10
    • View Profile
    • Nintendo World Report
RE: Welcome to PGC's New Database!
« Reply #22 on: February 12, 2006, 01:19:05 PM »
MegaByte helped me get the RSS feature to 100% (there were some minor formatting errors on my part).
::Michael "TYP" Cole
::Associate Editor
Nintendo World Report

"Only CHEATERS mess up!" -Waluigi