MyVideoGameList/myvideogamelist.com

Fork

You've already forked myvideogamelist.com

Code Issues 45 Pull requests Projects 3 Releases Activity Actions

Show curated related games on game profile pages #11

New issue

Open

opened 2024-01-14 14:18:08 -06:00 by jimmyb · 6 comments

jimmyb commented

2024-01-14 14:18:08 -06:00

Owner

Copy link

The original discussion raised a real scope concern: mapping every game franchise and relationship in detail would be a huge editorial project. In the Laravel rebuild, the public game profile route exists, but the profile view is still incomplete and there is no related-game or franchise persistence yet. This issue tracks building the technical foundation for manually curated related-game links without requiring the team to fully map every series up front.

Scope

Public game profile pages at /game/{gameId}/{gameName?}.
Related-game persistence linking one game to another.
Relationship labels such as prequel, sequel, spin-off, remake, expansion, collection, same series, or related.
Admin game create/edit surfaces for managing related games.
Display ordering and grouping for related game links.
Filtering unavailable, disabled, deleted, or soft-deleted games from public output.
Reuse of existing game profile, admin game, and Laravel/Tailwind layout patterns.

Acceptance Criteria

Admins can add, edit, order, and remove related-game links for a game.
Related-game links are manually curated; the app does not try to infer relationships automatically from titles.
Related games can include a relationship type label.
Game profile pages show a Related Games section only when visible related games exist.
Related games link to the canonical game profile URL for the related game.
The section is readable and not overcrowded when a game has many related entries.
Disabled, deleted, soft-deleted, missing, or otherwise unavailable related games are excluded from public game profiles.
Relationship data does not require every game in a franchise to be mapped before partial related links can ship.
Admin validation prevents linking a game to itself and prevents duplicate active relationships for the same game pair/type.
User-facing UI supports light/dark mode and follows existing Laravel/Tailwind site layout patterns.

Test Coverage Required

Feature tests confirming related games render on public game profiles with labels and canonical links.
Feature tests confirming the Related Games section is hidden when no visible related games exist.
Feature tests confirming deleted, disabled, soft-deleted, or missing related games are excluded.
Admin feature tests for adding, editing, ordering, and removing related-game links.
Validation tests for self-links, duplicate relationships, invalid related game IDs, and invalid relationship types.
Regression tests confirming games with multiple related entries render in stable order.
Regression tests confirming public game profile pages still render when a related game has missing box art or missing platform data.
Tests should use Pest and focused feature coverage.
Run the focused affected tests, then run vendor/bin/pint --dirty before closing the issue.

Progress Checklist

Public game profile route exists
Admin game create/edit pages exist
Canonical game profile URLs are used elsewhere in the site
Complete or update the public game profile view
Add related-game persistence and model relationships
Add admin controls for managing related games on game edit pages
Add relationship type labels and display ordering
Render Related Games on public game profiles
Hide unavailable related games from public output
Handle empty, many-related-games, duplicate, and self-link states
Add tests for public rendering, admin management, validation, filtering, and ordering
Confirm the feature supports curated partial data without requiring full franchise mapping

Game profile pages should show a curated “Related Games” section so visitors can discover closely connected titles such as direct prequels, sequels, remakes, spin-offs, expansions, collections, or same-franchise entries. The original discussion raised a real scope concern: mapping every game franchise and relationship in detail would be a huge editorial project. In the Laravel rebuild, the public game profile route exists, but the profile view is still incomplete and there is no related-game or franchise persistence yet. This issue tracks building the technical foundation for manually curated related-game links without requiring the team to fully map every series up front. ## Scope - Public game profile pages at `/game/{gameId}/{gameName?}`. - Related-game persistence linking one game to another. - Relationship labels such as prequel, sequel, spin-off, remake, expansion, collection, same series, or related. - Admin game create/edit surfaces for managing related games. - Display ordering and grouping for related game links. - Filtering unavailable, disabled, deleted, or soft-deleted games from public output. - Reuse of existing game profile, admin game, and Laravel/Tailwind layout patterns. ## Acceptance Criteria - Admins can add, edit, order, and remove related-game links for a game. - Related-game links are manually curated; the app does not try to infer relationships automatically from titles. - Related games can include a relationship type label. - Game profile pages show a Related Games section only when visible related games exist. - Related games link to the canonical game profile URL for the related game. - The section is readable and not overcrowded when a game has many related entries. - Disabled, deleted, soft-deleted, missing, or otherwise unavailable related games are excluded from public game profiles. - Relationship data does not require every game in a franchise to be mapped before partial related links can ship. - Admin validation prevents linking a game to itself and prevents duplicate active relationships for the same game pair/type. - User-facing UI supports light/dark mode and follows existing Laravel/Tailwind site layout patterns. ## Test Coverage Required - Feature tests confirming related games render on public game profiles with labels and canonical links. - Feature tests confirming the Related Games section is hidden when no visible related games exist. - Feature tests confirming deleted, disabled, soft-deleted, or missing related games are excluded. - Admin feature tests for adding, editing, ordering, and removing related-game links. - Validation tests for self-links, duplicate relationships, invalid related game IDs, and invalid relationship types. - Regression tests confirming games with multiple related entries render in stable order. - Regression tests confirming public game profile pages still render when a related game has missing box art or missing platform data. - Tests should use Pest and focused feature coverage. - Run the focused affected tests, then run `vendor/bin/pint --dirty` before closing the issue. ## Progress Checklist - [x] Public game profile route exists - [x] Admin game create/edit pages exist - [x] Canonical game profile URLs are used elsewhere in the site - [ ] Complete or update the public game profile view - [ ] Add related-game persistence and model relationships - [ ] Add admin controls for managing related games on game edit pages - [ ] Add relationship type labels and display ordering - [ ] Render Related Games on public game profiles - [ ] Hide unavailable related games from public output - [ ] Handle empty, many-related-games, duplicate, and self-link states - [ ] Add tests for public rendering, admin management, validation, filtering, and ordering - [ ] Confirm the feature supports curated partial data without requiring full franchise mapping

jimmyb added the

component: games

type: feature

labels

2024-01-14 14:18:08 -06:00

jimmyb commented

2024-01-14 14:18:17 -06:00

Author

Owner

Copy link

Originally posted by: Jessikitax

It would be useful, but with all the prequels/sequels/spin-off/DLC/expansions/collections/remakes/etc AND the available platforms, it could get quite messy with some series. If there is a way to pull it off that doesn't look bad then it would be awesome.

However, I think just searching for the series tittle like "Final Fantasy", "Dragon Quest" works good enough, and if/when we get alphabetical sorting it would be more organized.

**Originally posted by: Jessikitax** It would be useful, but with all the prequels/sequels/spin-off/DLC/expansions/collections/remakes/etc AND the available platforms, it could get quite messy with some series. If there is a way to pull it off that doesn't look bad then it would be awesome. However, I think just searching for the series tittle like "Final Fantasy", "Dragon Quest" works good enough, and if/when we get alphabetical sorting it would be more organized.

jimmyb commented

2024-01-14 14:18:23 -06:00

Author

Owner

Copy link

Originally posted by: Miles_Edgeworth

That's a good point. Ultimately though it could be sufficient to only link up the games that are either very closely connected or directly in chronological order.

Admittedly it's pretty simple to follow the order of series like FF where the main games go by numerical order, but when it comes to those other series with more elaborate titles, or say the Tales of series where first glance will in no way tell you the order of the games, it might be nice to at least have an idea of game order and relations. It's no good to buy a game only for you to realize that you have to buy another 5 to truly appreciate it after all.

**Originally posted by: Miles_Edgeworth** That's a good point. Ultimately though it could be sufficient to only link up the games that are either very closely connected or directly in chronological order. Admittedly it's pretty simple to follow the order of series like FF where the main games go by numerical order, but when it comes to those other series with more elaborate titles, or say the Tales of series where first glance will in no way tell you the order of the games, it might be nice to at least have an idea of game order and relations. It's no good to buy a game only for you to realize that you have to buy another 5 to truly appreciate it after all.

jimmyb commented

2024-01-14 14:18:45 -06:00

Author

Owner

Copy link

Originally posted by Vilkathewolf

This is how MAL does it. It does look a little cramped but it could work. If theres over 10 or 20 spinoffs or something you could add a "Read More" tab. I don't know much about MySQL and html but I'd want to help wherever I can ^.^

**Originally posted by Vilkathewolf** This is how MAL does it. It does look a little cramped but it could work. If theres over 10 or 20 spinoffs or something you could add a "Read More" tab. I don't know much about MySQL and html but I'd want to help wherever I can ^.^

9e227d00-3087-11ea-8bce-ab3b777e3bce.png

124 KiB

jimmyb commented

2024-01-14 14:19:05 -06:00

Author

Owner

Copy link

Originally posted by Vilkathewolf

I made this, it doesn't look too crowded. i mean for final fantasy 1 you wouldnt list all the sequels, only ff2. so?...

**Originally posted by Vilkathewolf** I made this, it doesn't look too crowded. i mean for final fantasy 1 you wouldnt list all the sequels, only ff2. so?...

b0042000-3087-11ea-9c62-2080460def4b.png

612 KiB

jimmyb commented

2024-01-14 14:19:13 -06:00

Author

Owner

Copy link

Originally posted by bergdoll

Okay so I have one major issue with this suggestion, or at least the MAL variant that Vilka is suggesting (sorry bro!).

Namely, this is a massive unprecedented undertaking with little to go by. No other gaming site has a MAL-style relation system, meaning that our puny little team would be the first to begin mapping out the sequel/prequel/spin off/remake-hierarchy for all of gaming. Aside from the ludicrous amount of time this would take (while we're still struggling with filling up the database with games mind you) there's also the issue of figuring out the relations between games. So Halo and Final Fantasy are easy enough, right? We have played them and know them well enough to tell how their hierarchy should be. But what about the remaining thousands upon thousands of games out there, some of which we will never have heard of. Other sites will be of little help, descriptions don't always lay out the exact relation to remaining games, relying on the users for advice will only take you so far etc. How do you tell direct sequels like Halo 1-2-3 from alternative settings like Final Fantasy 1-2-3 despite them being numbered the same way if the description or wikis doesn't mention what they are? Play them to make sure? Guess until the users corrects us? No, I don't think this will be worth the hassle.

My suggestion is that we scale this project back to just having a franchise-tag, kinda like gamefaqs. That way we can at least group franchises together without having to figure out the specifics, and we'd also have other sites as a blue-print. The pages for these tags could be sorted by release date to at least give an idea of the release order. How about that?

**Originally posted by bergdoll** Okay so I have one major issue with this suggestion, or at least the MAL variant that Vilka is suggesting (sorry bro!). Namely, this is a massive unprecedented undertaking with little to go by. No other gaming site has a MAL-style relation system, meaning that our puny little team would be the first to begin mapping out the sequel/prequel/spin off/remake-hierarchy for all of gaming. Aside from the ludicrous amount of time this would take (while we're still struggling with filling up the database with games mind you) there's also the issue of figuring out the relations between games. So Halo and Final Fantasy are easy enough, right? We have played them and know them well enough to tell how their hierarchy should be. But what about the remaining thousands upon thousands of games out there, some of which we will never have heard of. Other sites will be of little help, descriptions don't always lay out the exact relation to remaining games, relying on the users for advice will only take you so far etc. How do you tell direct sequels like Halo 1-2-3 from alternative settings like Final Fantasy 1-2-3 despite them being numbered the same way if the description or wikis doesn't mention what they are? Play them to make sure? Guess until the users corrects us? No, I don't think this will be worth the hassle. My suggestion is that we scale this project back to just having a franchise-tag, kinda like gamefaqs. That way we can at least group franchises together without having to figure out the specifics, and we'd also have other sites as a blue-print. The pages for these tags could be sorted by release date to at least give an idea of the release order. How about that?

jimmyb commented

2024-01-14 14:19:22 -06:00

Author

Owner

Copy link

Adding back discussion tag since @bergdoll does bring up a good point. This would definitely be a massive undertaking. Definitely doable, but it would be a lot of work. That said, it shouldn't stop us from doing it, it's just something we can tag as a project, no due date.