Regarding digital games on multiple systems

[Duke.Togo]

It will be interesting to me to watch how this plays out. With the new consoles coming out some of these distribution systems may be called the same thing, but there will be more platform fragmentation. I don't have any good suggestions, but perhaps a digital database would be best.

[Shadow Kisuragi]

Yeah, I had a hunch that this would cause some problems with the database and opinions whether DL games have any ownership at all (people do play on Steam games quite a lot these days and most recent PC games on discs use Steam anyway). If it causes problems, then a seperate DB might have to be made but that would mean 4162+ games would have to be moved.

It's interesting you bring this up:
First - where are you getting the Product Codes? Do those appear on the PlayStation Network page?
Second - Do you think we should split up the PSN section into the separate sections, or do you think we should just use the Variation Title/Title Name to separate them?

I'm getting the product codes from the Sony Entertainment Network site, they list them in the url of the game page (the end of the url seems to be the filename, many of them are zeroes or just say base). E.g. https://store.sonyentertainmentnetwork.com/#!/en-gb/games/dead-or-alive-5/cid=EP4108-NPEB01129_00-DOA5HDDBOOT01000 https://store.sonyentertainmentnetwork.com/#!/en-gb/games/metal-gear-solid-hd-collection-ps-vita/cid=EP0101-PCSB00118_00-MGSHDVITA0000000 (might not work since SEN detects your region.)

As for the second question, I don't really know what's best.

...I recognize those codes quite well. I would really hope I do. That would be the same exact name of the file you're downloading from the service as well.

EP4108-NPEB01129_00-DOA5HDDBOOT01000

EP4108 = Publisher Code
NPEB01129 = Title Id
NPEB01129_00 = Service Id
DOA5HDDBOOT01000 = Package Name (Content)

[Sirgin]

(...) i think digital games should be split into a digital DB. A distribution platform is not the same thing as a console.

Digital people would still be able to track digital releases (unfortunately myself included) and not have to worry about it mucking up the physical release side of the DB.

(emphasis mine)


Fully support this idea. A "digital" collection really has nothing to do with a physical collection. Most people wanting to compare their physical collection will want to compare it with other physical collections, not with digital games on a myriad of different distribution platforms.

I say split the DB in two. Make searching the physical and digital DB seperate, too. With all the regional variants, many searches look cluttered enough as it is. In the near future, games will be available on a dozen digital platforms and I'd still like to be able to do a quick search for, say, "Assassin's Creed III" and not have it return 75 results.

Force digital games to be in a seperate folder in the Collection Tools, and give the option to see people's physical and digital collection seperately (default to physical).

[techwizard]

i'd love a digital database too.

[Shadow Kisuragi]

(...) i think digital games should be split into a digital DB. A distribution platform is not the same thing as a console.

Digital people would still be able to track digital releases (unfortunately myself included) and not have to worry about it mucking up the physical release side of the DB.

(emphasis mine)


Fully support this idea. A "digital" collection really has nothing to do with a physical collection. Most people wanting to compare their physical collection will want to compare it with other physical collections, not with digital games on a myriad of different distribution platforms.

I say split the DB in two. Make searching the physical and digital DB seperate, too. With all the regional variants, many searches look cluttered enough as it is. In the near future, games will be available on a dozen digital platforms and I'd still like to be able to do a quick search for, say, "Assassin's Creed III" and not have it return 75 results.

Force digital games to be in a seperate folder in the Collection Tools, and give the option to see people's physical and digital collection seperately (default to physical).

...and, to be honest, that would completely break the site as-is and make it even more unwieldy to develop for. Hardware is half-broken due to taking that approach and not following through with it from the previous administration. We need to combine all of the databases and separate them by type and then build the page based on that type, not the hard-coded shenanigans we currently have. Did you know we already have 6+ php pages that are almost exact duplicates of each other for submissions, just with small tweaks based on whether or not you're staff, whether or not you're reviewing it, and whether it's software vs. hardware?

The solution is not a separate database. The solution is to create a shared database that properly extends all of the types of items we plan on tracking, eventually including Arcade Boards and Strategy Guides.

[techwizard]

i wasn't thinking just copy paste the entire database code with tweaks for each one, i had in mind something more like what you said with shared code between the databases that has room for expansion into each section needed.

as nice as it is to have the site donor funded, ad-free and volunteer run, it sounds like it could really use someone full time to rework it from the ground up. the staff currently do a great job but there's only so much you can do when you all have other jobs and this is a hobby of sorts.

[Duke.Togo]

After reading Shadow's last post, it makes me wonder if we should even be doing digital at all. There's nothing that says that this site has to have them, and to be honest I'd really rather see resources used for other things.

I'm glad I don't have to make these decision, but you can't please everyone.

[moonraker_fats]

It's definitely a tough call.  On one hand, thinking about my steam games, they are part of my collection, and I like the idea of having them documented and shown off as part of my complete library of games that I own.  On the other hand, if I really want to see what games I own digitally, I can just log into steam and look.  A lot if the benefits that the RFGen tools offer for collectors are kind of N/A in the digital world.  I'll never be out hunting for digital games and need to check if I already downloaded it.  I'll never need to check and see if a XBLA game has a variant on steam.  I don't need to document that I have a game, but not the digital manual or cyber-case.  Etc. etc.  Maybe a compromise between the two worlds would be a fourth area to add a value to when adding a game to your collection...like game, box, manual, and digital.  Just thinking out loud...

[Tynstar]

After reading Shadow's last post, it makes me wonder if we should even be doing digital at all. There's nothing that says that this site has to have them, and to be honest I'd really rather see resources used for other things.

Truer words have never been spoken.

Questions for the people that want to track downloaded stuff. Do you want to track and ROMS you might have for emulation? If not why? What's the difference?

[techwizard]

well it is the "modern" gaming database as well as classic, and digital is modern gaming even if it's not the only option yet. i thought the idea was to track games that have been made (and can be owned somehow), not just physical games.

when i say i'd love to have a digital database though, i do want it for the ability to track my entire gaming collection in one place, but i really just want it separated from the physical part. that way it's easy to say what exactly is on my shelves, and what's on my hard drives. i totally understand it not being a priority though and it would probably be a huge job to separate. it does the job fine the way it is now it's just not ideal.

[Izret101]

[img width=240 height=184]http://t2.gstatic.com/images?q=tbn:ANd9GcTV_H8_ZioUUxk5Xy6CphyhGyJotfZuE002CblvnEE-szEhQdGuAA[/img]
Here is where a gigantic post filled with complaints, ideas and probably some rather offensive things was going to be.
Instead i will just say...

[img width=240 height=184]http://t0.gstatic.com/images?q=tbn:ANd9GcTxq8_tMjCOWo0nxLm2bm4At5raORjk_lmG_hHWXx60vnYmSRU[/img]
I don't care anymore. I'll still make my suggestions and harp on things i feel should be changed.
Shadow claims the DB is full of completely asinine variants because a large part of our userbase was begging for more and more of them to be added. Instead of wasting weeks of time looking for tiny TMs and Rs and Cs put that time into something that will benefit the entire community. If a user gives a damn and wants to track a variant they will notice it and submit it. If they don't care about variants they won't notice it. Everyone stays happy.

[img width=240 height=184]http://t1.gstatic.com/images?q=tbn:ANd9GcS8GfxnWx0fFPaXlVzLUhGRwSqjgQT4LWCh-0Dv3N4SqnJFKBjOPQ[/img]
On the other hand everytime i suggest having a unique trackable DB for hardware/software/digital i see support from everyone except the programers who complain about how fucked up the site is and how outdated the code is.
Well here you go. A chance to make everything new instead of putting band-aids on everything and bitching.

[img width=240 height=184]http://t0.gstatic.com/images?q=tbn:ANd9GcTpcLXcLtg4xgSsxtYVbSuCUg_CIL2eazqKOi-AFGLtQ5YuqGhR[/img]

FIN

[Shadow Kisuragi]

Anthony, completely understand...that's how I ended my day yesterday after the constant talks of how things could be improved and how they should be done. I'm exhausted from just dealing with properly documenting European variants, let alone the rest of the database issues. Grue's been putting in quite a bit of polish work on the site though, which is nice, but it doesn't help us tackle the larger issues just yet.

If you want this to go away, contribute to the staff thread about page redesign so that we can start moving forward - we have a working sandbox now where we can start ripping things out and try new things! Combining the hardware php files with the software php files would likely take a small amount of time and would immensely help with this effort, even if we do just start with separating the databases for everything. We can merge the databases at a later point, but the point being right now is that hardware isn't even properly supported and we should fix the current state of the site before taking on another large project.

I'm just now getting back under 60 hours/week for work, and you've seen how little I'm actually on my Xbox 360 besides Netflix for the past year. Give me some time to catch back up on house work, and I'll throw in my lot to getting this resolved in the coming month. The important part in all of this is to discuss and design the work beforehand, which will reduce the amount of implementation time immensely. Get a design together, and Grue and I can likely tackle it within the span of a week.

[Tynstar]

Why are you searching for them? Like Anthony said let European people submit them. If they want it track it will be added. Work on bigger issue things. I remember when we only added games we owned not tracked stuff down to add it.

[Sirgin]

Why are you searching for them? Like Anthony said let European people submit them. If they want it track it will be added. Work on bigger issue things. I remember when we only added games we owned not tracked stuff down to add it.

Agreed. Shadow shouldn't be wasting his time on minutiae (unless he really wants to). We've got good members doing European variant submissions. There's no rush to get the Euro DB done, anyway. Slowly does it.

I do like the idea you guys are working with the sandbox to start getting things into shape.

[Shadow Kisuragi]

Wow, you guys think I spend hours upon hours adding these variants? I'm just going far enough out of my way to sort out variants in the submission queue to verify that what we're getting is what's being submitted. Half an hour of time doing research for the queue isn't something I can apply to code refactors.