Nintendo World Report Forums

NWR Interactive => TalkBack => Topic started by: Jonnyboy117 on February 10, 2006, 09:02:26 PM

Title: Welcome to PGC's New Database!
Post by: Jonnyboy117 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.

Title: RE:Welcome to PGC's New Database!
Post by: Pryopizm on February 10, 2006, 09:14:34 PM
TYP is truly a god among men.
Title: RE:Welcome to PGC's New Database!
Post by: breakyboy 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  
Title: RE:Welcome to PGC's New Database!
Post by: King of Twitch 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...  
Title: RE:Welcome to PGC's New Database!
Post by: Dasmos 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.
Title: RE: Welcome to PGC's New Database!
Post by: Shecky on February 11, 2006, 03:19:04 AM
I agree with breakyboy's points
Title: RE: Welcome to PGC's New Database!
Post by: vudu on February 11, 2006, 03:51:27 AM
This is a huge improvement.  Thanks TYP (and anyone else who contributed).
Title: RE: Welcome to PGC's New Database!
Post by: UncleBob on February 11, 2006, 04:10:48 AM
Neat.  Good job.
Title: RE: Welcome to PGC's New Database!
Post by: thame^ on February 11, 2006, 04:52:32 AM
Fantastic work, thanks loads!
Title: RE: Welcome to PGC's New Database!
Post by: thepoga 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!
Title: RE: Welcome to PGC's New Database!
Post by: KnowsNothing 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!
Title: RE:Welcome to PGC's New Database!
Post by: nickmitch on February 11, 2006, 07:32:48 AM
Excellent!
TYP is awesome!
Title: RE: Welcome to PGC's New Database!
Post by: TheYoungerPlumber on February 11, 2006, 08:07:49 AM
Thanks guys.
Title: RE: Welcome to PGC's New Database!
Post by: jtownzen2 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.    
Title: RE: Welcome to PGC's New Database!
Post by: Karl Castaneda #2 on February 11, 2006, 09:31:46 AM
http://planetgamecube.com/forums/messageview.cfm?catid=14&threadid=14920
Title: RE: Welcome to PGC's New Database!
Post by: Infernal Monkey on February 11, 2006, 09:40:18 AM
This is fantastic! Thanks! =D
Title: RE:Welcome to PGC's New Database!
Post by: miedo 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?!?
Title: RE:Welcome to PGC's New Database!
Post by: breakyboy 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.
Title: RE:Welcome to PGC's New Database!
Post by: Robageejammin on February 11, 2006, 11:09:36 AM
Jeez you guys are great. Really awesome job TYP. Looking forward to crazy E3 coverage.
Title: RE:Welcome to PGC's New Database!
Post by: IceCold 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.
Title: RE: Welcome to PGC's New Database!
Post by: TheYoungerPlumber on February 11, 2006, 11:12:37 PM
I think Breaky needs a hug.  Please don't be mad at me.
Title: RE:Welcome to PGC's New Database!
Post by: bananaboy 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)
Title: RE: Welcome to PGC's New Database!
Post by: TheYoungerPlumber 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).