GameSense – Ad-friendly HTML5 Games Portal (PHP & MySQL)

GameSense is a clean, fast and mobile-friendly HTML5 games portal with a modern admin panel. Publish games, organize categories, manage ads, moderate comments, create pages, import games in bulk, generate sitemaps and show GDPR cookie consent — built for smooth UX and search engine visibility.

✅ Key Features

• Dashboard with overview & top stats
• 🎮 Add / Edit / Feature / Delete games (iframe/embed support)
• 🗂️ Categories management (organize your library)
• 💬 Comment moderation (approve/reject/spam/delete)
• 📄 Pages manager (Privacy, Terms, About & custom pages)
• 📣 Ads manager (multiple placements)
• ⚙️ Site + SEO settings (meta defaults, UI/theme options)
• 📥 Bulk importers (import games in one click)
• 🗺️ Sitemap generator from admin panel (sitemap.xml)
• 🍪 GDPR cookie consent (enable/disable + policy page link)
• ❤️ Favorites (user-friendly save system)
• 📨 Contact inbox (read & reply)
• ✉️ SMTP settings + test email
• 🔐 Change admin password

🚀 SEO Ready

• Dynamic meta title/description per game page
• OpenGraph + Twitter Cards for social previews
• JSON-LD schema markup (VideoGame + breadcrumbs)
• Admin sitemap generator for faster indexing

## GameSense v3 upgrade notes

### New user account system
- Added frontend `/signup`, `/login`, `/logout`, and `/account` routes.
- Added a new `users` database table for email/password accounts and Google accounts.
- Existing installations are safe: the users table is created automatically the first time the auth system is used, and the installer schema also includes it for fresh installs.

### Google social login
- Added admin page: **Admin → Social Login**.
- Admin can enable/disable Google login and save:
  - Google Client ID
  - Google Client Secret
  - Google login button text
- The Social Login settings page shows the exact Google OAuth redirect/callback URL that must be pasted into Google Cloud Console.
- Required Google scopes: `openid email profile`.

### Mobile game player / fullscreen fixes
- Improved game detail page responsiveness on mobile.
- Fixed sideways page overflow where users had to scroll right to center the game.
- The game player now stays centered and uses a responsive 16:9 landscape viewport on mobile before fullscreen.
- Fullscreen mode still uses the full viewport height and keeps the player locked to the screen.

### Updated files in this v3 patch
- `index.php`
- `app/Core/Bootstrap.php`
- `app/Models/User.php`
- `resources/views/layouts/app.php`
- `resources/views/layouts/admin.php`
- `resources/views/auth_login.php`
- `resources/views/auth_signup.php`
- `resources/views/account.php`
- `resources/views/admin/social_login.php`
- `resources/views/game.php`
- `assets/css/app.css`
- `install/schema.sql`

## v3 Account Interaction Update

This package adds account-based player interactions:

- Google login opens in a centered popup window for better UX.
- Favorites are saved to the logged-in user account instead of browser local storage.
- Guests see a login/signup prompt when trying to save favorites.
- Ratings require a logged-in account and are stored per user.
- Comments require a logged-in account and use the account name/email automatically.
- Added API endpoints for account favorites:
  - `GET /api/favorites`
  - `POST /api/favorites/toggle`
  - `POST /api/favorites/clear`

For upgrades from v2/v3, run the SQL migration in: use PHPmyadmin

```
database/migrate_v2_to_v3_accounts.sql
database/migrate_v3_account_email_flows.sql
database/migrate_v3_slug_cookie_ads
database/migrate_v3_turnstile.sql

replace all the files in the root public_html with this v3 files that are in the zip(use Filezilla)

```

If any `ALTER TABLE ... ADD COLUMN` statement says the column already exists, skip that one. The code also has automatic schema checks for user favorites, ratings, and comments.

## v3 Admin User Management Update

This package adds a dedicated frontend user management section in the admin panel.

### New admin route

```
/admin/users
```

### What admin can do

- View all frontend user accounts in one table.
- Search users by name, email, or Google provider ID.
- Filter by provider:
  - All providers
  - Email signup
  - Google login
- Filter by account status:
  - Active
  - Disabled
  - Verified
  - Unverified
- View user activity counts:
  - Favorites saved
  - Ratings submitted
  - Comments posted
- Manually verify email users.
- Disable or enable user accounts.
- Delete frontend user accounts.

### What happens when admin deletes a user

When an admin deletes a user from **Admin → Users**:

- The user account is permanently deleted.
- The user’s saved favorites are deleted.
- The user’s ratings are deleted.
- The user’s comments are kept but anonymized as `Deleted player`.

## Couldflare Turnstile

Added features:

Admin → Turnstile
Enable/disable Turnstile globally
Add Turnstile Site Key
Add Turnstile Secret Key
Enable/disable protection for auth pages
Enable/disable protection for contact page
Choose Turnstile theme: Auto, Light, Dark

📦 Requirements

• PHP 8.0+
• MySQL 5.7+ / MariaDB 10.4+
• PDO enabled

🚀 Installation (One-Click)

1. Upload all files to your domain root:

   public_html/
   
   
   
   
   
   

2. Create a MySQL database from cPanel
3. Open installer in browser:

   https://yourdomain.com/install
   
   
   
   
   
   

4. Fill in:
   • Database host
   • Database name
   • Database user & password
   • Site name
   • Admin email & password
5. Click Install
6. After success:
   • Delete /install folder (important for security)
   • Login to admin panel:

     /admin/login
     
     
     
     
     
     

---

🔐 Admin Panel

Access:

/admin/login

---

🧭 Admin Panel Features

📊 Dashboard

Overview & top stats

🎮 Games

Add, edit, feature & delete games

🗂️ Categories

Organize your game library

💬 Comments

Moderation queue & approval system

📄 Pages

Privacy Policy, Terms, About & custom pages

📣 Ads Manager

Ad placements & monetization units

⚙️ Settings

Site configuration, SEO, UI & performance

📥 Importers

Bulk game importers & automated imports

🕸 Sitemap

Auto generate sitemap

🍪 Cookie (GDPR)

GDPR Cookie Settings

Important note (Cookie Policy page setup):

In Admin → Pages, create:

• Title: Cookie Policy
• Slug: cookie-policy

Your policy URL will be:

/page/cookie-policy

📩 Contact Inbox

Read & reply to user messages

✉️ SMTP

Email & notification settings

🔐 Change Password

Update admin password securely

---

📥 Importers (Bulk Games)

GameSense includes built-in importers to save time.

Supported Import Methods

• Import games from JSON / API sources
• Bulk iframe URL import
• Category auto-assignment
• Auto slug generation
• Auto thumbnail support

Import Steps

1. Go to: Admin → Importers
2. Select importer
3. Configure options
4. Run importer
5. Games appear instantly on frontend
6. For GameMonetize, generate your JSON feed here: https://gamemonetize.com/rss-builder
7. For GamePix, generate your JSON feed here: https://partners.gamepix.com/rss-feed
8. For GameDistribution:
   • Go to Admin → Importers
   • Choose GD JSON Import (Manual)
   • Select Category: override / auto
   • Enable Include category as tag
   • Click Import
   • Includes 800+ GD games

---

🧠 SEO Features

GameSense is built SEO-first:

• Dynamic <title> per game
• Dynamic meta description
• SEO-friendly URLs (e.g. /game/super-mario-run)
• Category pages
• Browse A–Z index
• Clean HTML output
• Google-friendly structure
• Optional FAQ content for homepage SEO

GameSense v1.1 — Major Engagement Update

We are excited to release GameSense v1.1, introducing a powerful game rating system, improved discovery features, and new admin analytics tools. This update focuses on increasing user engagement and game discoverability, making your game portal more interactive and dynamic.

⭐ New: Game Rating System

Players can now rate games directly on the game detail page.

Features

1–5 star rating system

Displays average rating and vote count

Rating breakdown bars (5★ → 1★)

Prevents duplicate ratings

Fully integrated with the existing game database

This helps users quickly identify high-quality and popular games.

⚡ AJAX Rating (No Page Reload)

The rating system uses AJAX, meaning:

Instant rating submission

No page reload required

Live updates of:

average rating

vote count

rating bars

This creates a modern and smooth user experience.

🏆 Top Rated Games (Homepage)

A new Top Rated Games section has been added to the homepage.

Benefits:

Highlights the best games automatically

Improves game discovery

Encourages users to explore more games

🔎 Improved Game Sorting

Users can now sort games by rating.

Browse Page

Sorting options:

Newest

Popular

⭐ Top Rated

Category Pages

Sorting options:

Newest

Popular

⭐ Top Rated

This allows visitors to quickly find the best-rated games.

📊 New Admin Rating Dashboard

Administrators can now monitor rating activity.

The new Ratings dashboard includes:

Total votes

Average rating

Rated games count

Unique voters

Rating distribution chart

Top rated games

Most rated games

Recent rating activity

This provides useful insights into game popularity and user behavior.

🗄 Database Update

New table added:

game_ratings

Stores:

game_id

rating value

voter IP

timestamp

The table auto-creates for existing installations, so no reinstall is required.

📂 Files Added
app/Models/Rating.php
resources/views/admin/ratings.php
📂 Files Updated
app/Core/Bootstrap.php
app/Models/Game.php
index.php
resources/views/game.php
resources/views/home.php
resources/views/browse.php
resources/views/category.php
resources/views/layouts/admin.php
install/schema.sql
🔧 Upgrade Notes

Replace the updated files with the new version.

Existing installations will automatically create the rating table when the rating system is first used.

No fresh installation required.