Genre & Subgenre Guide

[Shadow Kisuragi]

Yeah, I can pull a list, though I may need to tweak a couple DB queries until I can appropriately find the information I need.
I'm not a SQL wizard, but I'm sure I can find the right combination of joins and deduplication to make it work.

[Izret101]

EDIT
Shadow posted while i was typing
/EDIT

Well that is kind of what my comment to SK was anyways.
Unless he intends on doing something i am unaware of anytime there has been a change. Like the removal of a Genre or the addition of a Game Rating it hasn't populated on the pages or been removed from the pages.

Anything that had that required a manual change.
Like when "Misc." (a now unsearchable Genre that still exists in our database) became "Miscellaneous"(the still searchable genre in the database i am removing)
http://www.rfgeneration.c...nfo.pl?ID=U-016-S-02940-A
http://www.rfgeneration.c...nfo.pl?ID=U-040-S-00750-A
http://www.rfgeneration.c...nfo.pl?ID=U-016-S-08340-A
http://www.rfgeneration.c...nfo.pl?ID=U-016-S-08370-A
http://www.rfgeneration.c...nfo.pl?ID=U-00H-S-04740-A
http://www.rfgeneration.c...nfo.pl?ID=U-00H-S-04990-A
http://www.rfgeneration.c...nfo.pl?ID=U-00H-S-05230-A
http://www.rfgeneration.c...nfo.pl?ID=U-00H-S-04940-A
http://www.rfgeneration.c...nfo.pl?ID=U-048-S-01400-A

I linked to those all of those games to save time from someone having to search in the future or forgetting they exist and need correcting... Again.
I have not corrected them yet to make sure they were seen and to prove the point i was getting at.

All of the entries were not dealt with in advance so when the "new" genre was added the "old" genre became unsearchable.

I don't see how enabling the selectable subgenre limitations could lead to issues because the other fields (Game Rating, Rating Content Descriptors, Genre, Release type) have all had a multitude of items added and/or subtracted after the fact and it in no way disrupted what was already there.

With the exception of them (initially)not being alphabetical. Which was probably just laziness on the person who added them at that time.

Also had these limitations already been put in place there would a decent number of games already updated to conform with those new standards.

[Shadow Kisuragi]

The issue is that you'd be unable to search for them, and I'd have to add in error handling for unknown cases. "Misc." was not my fault...

[Izret101]

They could be searched for in the same way that the Release Types were searched for. (Assuming this is going to be searchable)

Do a search for an empty field. Open game page. If no subgenre add one. If subgenre entered before the switch update it to conform.

[Izret101]

Expansion Packs - add under Non-game (DOES NOT COUNT FOR DLC/DIGITAL DISTRIBUTION)

Example
Halo, Borderlands, etc had physical expansions released for consoles which required the base game. In addition to the endless number of PC expansion discs which required owning the base game.

[blcklblskt]

Expansion Packs - add under Non-game (DOES NOT COUNT FOR DLC/DIGITAL DISTRIBUTION)

Example
Halo, Borderlands, Red Dead Redemption, etc had physical expansions released for consoles which required the base game. In addition to the endless number of PC expansion discs which required owning the base game.

I'm pretty certain Red Dead Undead Nightmare was a stand-alone title, at least on PS3.  I'm pretty sure you didn't need RDR to play it.

[Shadow Kisuragi]

^ Correct. There are a few examples of that, including the Xtreme Legends versions of Dynasty Warriors/Samurai Warriors. Some, however, are just Key Discs that install the DLC or provide codes for the content itself.

[Izret101]

Removed RDR from suggested titles

[tactical_nuke]

Fortune Telling and Expansion added to non-games.

[techwizard]

I'm not sure i entirely agree with expansion packs being "non-game", or for that matter a genre/subgenre at all. shouldn't that be a release type? because "expansion" doesn't describe anything about the content of the game, it's only a method of distribution that requires a base game. some expansion packs can have substantial extra content added to the base game, usually much more than today's DLCs add, and i feel like "non-game" doesn't fit that very well.

[Izret101]

Expansion is indeed a catch all term.
But how often does an expansion actually change the genre of the game it would be played with? Additionally Non-game/Expansion would be used only in specific instances and not for every expansion ever.

My example of Halo 2 was a Multiplayer Mappack expansion.
Borderlands contained some of the DLC story expansions on disc.

In both instances (to my knowledge)you were required to instal those to your systems harddrive and use them in conjunction with the base game.

Any example of an expansion that would not require the base game would not be a "non-game" such as the Undead Nightmare Pack which i was corrected on.
I believe Lips or some other music games (DJRockBandGuitarHero Track Packs?) that could be played just from the disc.

[Shadow Kisuragi]

Better example of Non-Game Expansion Pack:
http://www.rfgeneration.c...nfo.pl?ID=U-115-S-13030-A

It's a retail case with a code used to download content for the full game. Tomb Raider Underworld had a similar concept.

[tactical_nuke]

Chipping away! Added Education>>Language to guide.

[Izret101]

I've recently come across a ton of other Non-Game stuff. GPS, Video/picture galleries, manga, comic books, videos, etc etc

Education is specifically going to be for items were it is educational game play right?
Not things like dictionaries or encyclopedias or study guides? (Recently edited info for JP "games" that taught you how to pass exams to be a realtor, IT specialist, civil servant, etc)

I recently swapped a bunch of PAL PSX games to edutainment. Example page http://www.rfgeneration.c...nfo.pl?ID=E-061-S-06170-A



For subgenres i think it is going to be nigh impossible to get every subgenre accounted for for every genre (because they can be so varied) but hopefully with enough of them people can have a good idea of what to use where. Especially those approving submissions or who are able to bypass the submission review process.


EDIT
Also Trajectory as action/adventure?
Every "trajectory" game in the database (that i know of) currently has Puzzle as the genre. Thoughts?
EDIT 2
Worth noting Rovio (and every other source on the internet i can dig up) says they are Puzzle Games.

[tactical_nuke]

I put trajectory under act/adv because I consider them action games. (Act/adv being split up into 3 different parts is going to be phase 2 of the restructuring) and your question about education: yes.