MyVideoGameList/myvideogamelist.com
MyVideoGameList/myvideogamelist.com
Watch
3
0
Fork
You've already forked myvideogamelist.com
 0
Code Issues 33 Pull requests 3 Projects 2 Releases Activity Actions

SonarQube CRITICAL CODE_SMELL: Define a constant instead of duplicating this literal "game_lists.*" 4 times. #950

New issue
Closed
opened 2026-10-02 10:59:12 -05:00 by forgejo-actions · 1 comment
forgejo-actions commented 2026-10-02 10:59:12 -05:00
Copy link

SonarQube issue detected.

SonarQube key: cc63c15b-23fc-488a-b4d9-bd1b1edd2577
Severity: CRITICAL
Type: CODE_SMELL
Location: myvideogamelist:app/Support/GameLists/GameListSections.php:240
Message: Define a constant instead of duplicating this literal "game_lists.*" 4 times.

https://sonarqube.linuxbox.ninja/project/issues?id=myvideogamelist&issues=cc63c15b-23fc-488a-b4d9-bd1b1edd2577&open=cc63c15b-23fc-488a-b4d9-bd1b1edd2577

SonarQube issue detected. **SonarQube key:** `cc63c15b-23fc-488a-b4d9-bd1b1edd2577` **Severity:** `CRITICAL` **Type:** `CODE_SMELL` **Location:** `myvideogamelist:app/Support/GameLists/GameListSections.php:240` **Message:** Define a constant instead of duplicating this literal "game_lists.*" 4 times. https://sonarqube.linuxbox.ninja/project/issues?id=myvideogamelist&issues=cc63c15b-23fc-488a-b4d9-bd1b1edd2577&open=cc63c15b-23fc-488a-b4d9-bd1b1edd2577 <!-- sonarqube:issue:cc63c15b-23fc-488a-b4d9-bd1b1edd2577 -->
Codex self-assigned this 2026-10-02 15:56:58 -05:00
Codex commented 2026-10-02 16:02:02 -05:00
Member
Copy link

Replaced the repeated game_lists.* selection with a shared column constant. Game-list pagination tests pass. Implemented in PR #957. Pint and PHPStan pass; Forgejo CI and the post-merge SonarQube scan are pending. Leaving this issue open until merge.

Replaced the repeated game_lists.* selection with a shared column constant. Game-list pagination tests pass. Implemented in PR #957. Pint and PHPStan pass; Forgejo CI and the post-merge SonarQube scan are pending. Leaving this issue open until merge.
Sign in to join this conversation.
No Branch/Tag specified
Branches Tags
master
codex/issue-1014-verified-gamer-entries
renovate/npm/master/laravel-vite-plugin-3.2.1
renovate/npm/master/concurrently-10.0.7
dev
No results found.
Labels
Clear labels   
automated

   
code-quality

   
component: admin dashboard
The issue is related to the admin dashboard functionality.

  
component: backend
The issue is related to the backend code.

  
component: billing
The issue is related to our billing and payment system functionality.

  
component: content management
The issue is related to site content and moderation functionality.

  
component: faqs
The issue relates to our frequency asked questions and their categories.

  
component: game genres
The issue is related to genres in relation to games.

  
component: game lists
The issue is related to user-facing game list functionality.

  
component: game reviews
The issue relates to the game reviews functionality.

  
component: game search
The issue is related to the user-facing game search functionality.

  
component: games
The issue relates to games in our database.

  
component: internal notifications
The issue is related to the functionality of notifications sent for internal usage.

  
component: platforms
The issue is related to platform functionality.

  
component: security
The issue relates to the security issues within the app.

  
component: tests
The issue relates to unit and feature tests.

  
component: user api
The issue relates to the user-facing API.

  
component: user badges
The issue is related to our badge/achievements functionality.

  
component: user blogs
The issue is related to blogging functionality.

  
component: user consoles
The issue is related to user console lists functionality.

  
component: user favorites
This is issue is related to the favorites functionality.

  
component: user friends
The issue relates to the friending functionality.

  
component: user notifications
The issue is related to user-facing notifications functionality.

  
component: user profiles
The issue is related to user profile functionality.

  
component: user site notifications
The issue relates to the functionality of notifications shown to users directly on the website.

  
component: user wishlists
This issue is related to the wishlists functionality.

  
component: web design
This issue is related to the design of the website.

  
dependencies
Pull requests that update a dependency file.

  
javascript
Pull requests that update Javascript code

  
php
Pull requests that update PHP code.

  
priority
high
 The issue is considered a high priority.

  
priority
low
 This issue is considered a low priority.

  
priority
medium
 This issue is considered a medium priority.

  
security-hotspot

   
source: codex

   
source: sonarqube
  
status
awaiting feedback
 The issue is awaiting feedback from others.

  
status
backlog
 Issues that are in a backlog status.

  
status
done
 The issue has been completed and closed out.

  
status
in progress
 The issue is in progress and being actively worked on.

  
status
in queue
 The issue is in queue and will be worked on shortly.

  
status
in review
 The issue work has been completed and now the work needs to be reviewed.

  
status
needs codex review
 Use this tag to have Codex spiffy up your issue.

  
status
needs investigation
 The issue describes a problem which needs further investigation.

  
status
wontfix
 This issue will not be worked on.

  
type: bug
The issue describes something working the way it wasn't intended too.

  
type: documentation
Improvements or additions to site documentation.

  
type: feature
A new feature for the website.

  
type: improvement
An improvement on an existing feature.

  
type: regression
The issue describes a function that previously worked and no longer does.

  
type: task
A small-ish task.

No labels
automated
code-quality
component: admin dashboard
component: backend
component: billing
component: content management
component: faqs
component: game genres
component: game lists
component: game reviews
component: game search
component: games
component: internal notifications
component: platforms
component: security
component: tests
component: user api
component: user badges
component: user blogs
component: user consoles
component: user favorites
component: user friends
component: user notifications
component: user profiles
component: user site notifications
component: user wishlists
component: web design
dependencies
javascript
php
priority
high
priority
low
priority
medium
security-hotspot
source: codex
source: sonarqube
status
awaiting feedback
status
backlog
status
done
status
in progress
status
in queue
status
in review
status
needs codex review
status
needs investigation
status
wontfix
type: bug
type: documentation
type: feature
type: improvement
type: regression
type: task
Milestone
Clear milestone
No items
No milestone
Projects
Clear projects
No items
No project
Assignees
Clear assignees
No assignees
Codex
2 participants
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set

Reference
MyVideoGameList/myvideogamelist.com#950
No description provided.