🎮 GeekZoneGaming.com - Game Card & Member Management System

Welcome to the GeekZoneGaming web platform — a fully self-contained, SQLite3-based application for managing members and displaying interactive game cards on a retro-inspired frontend. This system was designed to be portable, easy to install, and fully extensible.

🚀 Features

• SQLite3 database backend for zero-config deployment
• CRUD system for game cards including click tracking
• User registration and login with secure password hashing
• Email verification system using PHPMailer + SMTP
• Role-based access control (admin vs member)
• Admin dashboard to promote or remove users
• Retro 80's arcade theme UI with Press Start 2P font
• Session timeout logic for better security
• CSRF token system to secure form submissions
• Complete unit tests for users and cards

📁 File Structure

/api/                  - RESTful endpoints (CRUD + email + click tracking)
/data/games.db         - SQLite3 database (users, cards)
/members/              - Auth system, dashboard, profile, admin tools
/tests/                - Unit test scripts
index.html             - Public arcade-style game launcher
manage-cards.html      - Auth-protected card editor UI
register.php           - Registration + verification email sender
verify.php             - Email token activation
login.php              - User login
logout.php             - Session destroy
csrf.php               - CSRF token generator/validator
session.php            - Central session start + timeout logic
profile.php            - User can edit their own name/email
admin.php              - Admin-only user management panel
style.css              - Global styles
favicon.ico            - Icon file
    

🧠 How the System Works

1. Users register via register.php
   → Stored in users table, email sent via verify.php
2. Verified users log in via login.php, stored in $_SESSION['user']
3. Members can:
   • View games on index.html
   • Create/edit on manage-cards.html
   • Update profile via profile.php
4. Admins can:
   • Access admin.php
   • Promote/demote/delete members
5. Game Cards are loaded via api/get_cards.php and update clicks with api/increment_click.php
6. Security:
   • CSRF protection (csrf.php)
   • Session timeout logic
   • Password hashing
   • Email verification
7. Testing: Run tests/run_all_tests.php to validate user and card systems

✅ Requirements

• PHP 7.4 or later
• SQLite3
• SMTP mail server
• PHPMailer (included in /phpmailer)

📦 Portability

This app runs on shared hosting or localhost. With all data stored in games.db, deployment is as simple as:

• Upload the folder to your server
• Edit SMTP settings in register.php
• Done! You’re ready to register users and add games.

📜 License

This project is licensed under the MIT License.

• You may use it in personal or commercial projects
• Modify or redistribute it freely
• Keep the license included if shared

🙋 Need Help?

If you're planning to integrate with your own domain, add OAuth, leaderboards, or analytics, reach out! I’d love to help.

👾 Welcome to the arcade!