Messages

1

Video Game Database Discussion / Re: Is there a way we can get a copy of the database?

« on: December 30, 2014, 05:39:33 pm »

Unfortunately, the database doesn't mark which ones are exclusive, so I don't think there's a way to export a list when we don't have a field for it :/

Thats why I would like the entire list of games occross all platforms, I can write a script to do the referencing myself

Another challenge would be games that were released cross-platform but named uniquely for each platform. It didn't happen often but it did happen.

I thought of this and am not to worried about it, since I'm only collecting NA releases it shouldn't be a problem. Hopefully once I have a shorter list any questions regarding it I can research on a game by game basis.

Ah, I see - well, it'd probably be Matt who'd have to help you out, so your best bet would be to email or PM him directly.  The only thing I can see would be an issue is that he'd basically be giving away all of his community members' work, if you know what I mean...

Yeah and thats why I figure it would be locked away, I'll send him a PM and see if we can part with a copy.

2

Video Game Database Discussion / Re: Is there a way we can get a copy of the database?

« on: December 23, 2014, 08:18:35 pm »

Unfortunately, the database doesn't mark which ones are exclusive, so I don't think there's a way to export a list when we don't have a field for it :/

Thats why I would like the entire list of games occross all platforms, I can write a script to do the referencing myself

Another challenge would be games that were released cross-platform but named uniquely for each platform. It didn't happen often but it did happen.

I thought of this and am not to worried about it, since I'm only collecting NA releases it shouldn't be a problem. Hopefully once I have a shorter list any questions regarding it I can research on a game by game basis.

3

Video Game Database Discussion / Re: Is there a way we can get a copy of the database?

« on: December 23, 2014, 12:59:56 am »

A slightly harder solution could be, put all of the ps1 games in your collection, and then you can export them in a csv file.

I'm not looking for a list of PS1 games, thats easy to find, I'm looking for a list of PS1 exclusive games. The only idea I have to create such a list now would be to search the site for every PS1 game and check if there are any results for a different platform.

4

Video Game Database Discussion / Is there a way we can get a copy of the database?

« on: December 21, 2014, 09:17:48 pm »

I'm interested in collecting a subset of games for the PS1 (and maybe other system eventually, but I want to start there), specifically games that were exclusive to the system. I've had a hard time finding a list of PS1 exclusives online with the only close result being on wikipedia (although it seems limited to games they have pages on, which misses quite a few). Manually searching on each game would take a long time and I'd probably miss something along the way.

If however I had a copy of the game DB that has been created and curated by users here I could write a script to cross reference each PS1 game and find the ones that are on no other platform. This could also be done by writing a script to search the site over and over again, but that seems like a poor way to do it (not only because it would be slower but because it could potentially cause a lot of traffic in a short period of time).

I'm only interested in the games, not user collections, and I could use any file I could get (I'm just going to guess it's a MySQL database, but another format, even a CSV, would work). I figure that the data is probably locked away, but figured I'd ask since it would make my goal a a lot easier.

5

Site Feedback / Re: Couple Feature Requests

« on: December 27, 2013, 09:25:09 pm »

An idea, since multiple generic "notes" fields would be kinda confusing, how about the ability to name your notes fields whatever you want. (In going with that any additional fields could easily be hidden by default, to keep the clutter out as has been mentioned as a goal). Kinda the same thing I suggested in my last post but instead of  a bunch of hidden fields it would be custom fields we name what we want (personally, I think the custom feilds are a better approach since they inputs can be more directly tailored for the data type). Say, has there been any talk of open sourcing the web app...

The reason i love the location field (and have been using in my current tracking) is about the memories, Looking back i can remember getting that pack of games out 3 hours from the city or the game i got on my trip to Rome, Its a great way to remember the hunt and that's my favorite part of game collecting.

Kinda sounds more like a "Purchase Location" field, I use it the same way. By location I was thinking more like "In storage","At parents house","Loaned out","in Box 33C" that sorta thing.

6

Site Feedback / Re: Couple Feature Requests

« on: December 25, 2013, 01:27:11 am »

I thought of using the notes field but it's 1 input for three different data points, I didn't feel mixing them together was the best way to solve the problem (not to mention that they would never be individually sortable, sorting by location or completed is quite useful when looking for something in particular).

The app I've been using takes care of this in a different way, allowing the user to select what is seen on the add/edit tabs (there system breaks it into three parts, although that seems rather odd as it's a bunch of extra clicks to see it all). This allows the user to see just the fields that interest them and not show the rest (or at least hide them initially, as they will rarely be edited). If you want the data in your collection then you can go to settings and control what you see on the add screen, if not it'll be hidden away. This would give the site the ability to be as detailed or as streamlined as the user wants.

7

Site Feedback / Couple Feature Requests

« on: December 24, 2013, 05:01:44 am »

I've been using a dedicated program to store all my games and it's been lacking lately (they have a DB that supposedly tracks games so that they can easily get the data from their server, but lately it's missing games, even big titles like Grand Theft Auto V). I've been considering several options for a new way to store the info (this site, plain spreadsheets, SQL database, even a full site to add and track them (although if the opportunity came up I'd rather work on a existing site rather than trying to build a database from he ground up)).

Anyways the application does have a few features that I don't see here that I think people could get some use of.

First, you have Purchased Date, but how about a text input for location purchased?

A way to track if you've completed a game or not (a simple checkbox is what the app I'm using has, but I think it might make more sense as a drop down, so you can denote if you just beat it, or if you went for 100%, as well as denote games that can't really be "beaten" (like atari games, they could have a high score system to track your highest score however).

A "location" field, this one is probably the single biggest thing preventing me from making a switch, since I have all my games in boxes (I don't really have the space to display them anymore) I've been making extensive use of the custom field to note what box there in so I can easily find them when I want to play them.

Those are the features that I've noticed that I think people may get some use out of and should be easy to implement (in fact, if you have the site up on a revision control system I'd be happy to make them when I get a chance and push the changes to you if you'd like, I'm guessing that the site is built on a standard LAMP setup using the Twitter bootstrap and jQuery, happens to be my usual stomping ground so the only problem would be finding the time).