================================================================================
     EDUBASEFORUM — WEB HOSTING DEPLOYMENT & DATABASE IMPORT GUIDE
================================================================================

This guide explains the EXACT file to import into your database and the EXACT
files to upload to your web hosting (cPanel, DirectAdmin, Plesk, VPS, or Apache).

================================================================================
1. THE EXACT DATABASE FILE TO IMPORT
================================================================================
File path on your computer:
C:\Users\REVOLVE\.gemini\antigravity\scratch\php-forum\00_DATABASE_IMPORT_FOR_HOSTING.sql
(also available inside: database/edubaseforum_full_mysql_import.sql)

File Size: ~223 KB
Format: Standard MySQL/MariaDB SQL dump
Compatibility: MySQL 5.7+, MySQL 8.0+, MariaDB 10.3+, phpMyAdmin

WHAT THIS FILE CONTAINS:
- All 80 database table structures (users, profiles, roles, discussions, comments,
  marketplace, earning wallets, tasks, messaging, communities, settings, etc.)
- Complete live seed data:
  * Super Admin Account: admin / password123 (member code: EBF-000001)
  * Scholar Member: sarah_code / password123 (member code: EBF-000002)
  * Seller/Mod Member: alex_mod / password123 (member code: EBF-000003)
  * All discussion categories, CMS pages, default permissions, and theme settings (#38BDF8)
- Safe foreign key checks (SET FOREIGN_KEY_CHECKS = 0) so the import will never fail.

HOW TO IMPORT IT IN CPANEL / PHPMYADMIN:
1. Log in to your hosting control panel (cPanel).
2. Go to "MySQL Databases" -> Create a new database (e.g. `youruser_edubase`).
3. Create a database user with a strong password and assign it to the database with ALL PRIVILEGES.
4. Go back to cPanel home -> Open "phpMyAdmin".
5. In the left sidebar, click on your newly created database name.
6. Click the "Import" tab at the top.
7. Click "Choose File" -> Select `00_DATABASE_IMPORT_FOR_HOSTING.sql`.
8. Scroll to the bottom and click "Import" (or "Go").
9. Done! All tables and data are now imported.

================================================================================
2. THE EXACT PROJECT FILES TO UPLOAD TO HOSTING
================================================================================
Zip and upload all folders and files inside your project directory:
C:\Users\REVOLVE\.gemini\antigravity\scratch\php-forum\

FILES AND FOLDERS TO INCLUDE IN YOUR ZIP:
  [Folders]
  - app/              (Controllers, Models, Middleware, Services, Views)
  - bootstrap/        (Application core bootloader)
  - config/           (Application configurations)
  - database/         (Migrations and SQL schemas)
  - public/           (Entry point index.php, assets, CSS, JS, uploads)
  - routes/           (URL router definitions web.php, admin.php, api.php)
  - storage/          (Logs, cache, and public uploads)
  - vendor/           (PHP Composer packages)

  [Files]
  - .env              (Your environment and database credentials)
  - .htaccess         (Apache server rewrite rules)
  - composer.json     (Package definitions)
  - composer.lock     (Locked dependencies)

OPTIONAL / EXCLUDE FROM UPLOAD (Not needed on live server):
  - storage/database/forum.sqlite (You are using MySQL on hosting, not SQLite)
  - scripts/                      (Internal automated test scripts)
  - 00_DATABASE_IMPORT_FOR_HOSTING.sql (Upload only to phpMyAdmin, not web root)

================================================================================
3. HOW TO CONFIGURE YOUR .ENV FILE ON HOSTING
================================================================================
After uploading, open the `.env` file in cPanel File Manager and edit these lines:

APP_NAME="Edubaseforum"
APP_ENV=production
APP_DEBUG=false
APP_URL=https://yourdomain.com

DB_CONNECTION=mysql
DB_HOST=localhost
DB_PORT=3306
DB_DATABASE=yourcpanel_dbname
DB_USERNAME=yourcpanel_dbuser
DB_PASSWORD=your_db_password

MAIL_MAILER=smtp
MAIL_HOST=mail.yourdomain.com
MAIL_PORT=465
MAIL_USERNAME=noreply@yourdomain.com
MAIL_PASSWORD=your_mail_password
MAIL_ENCRYPTION=ssl
MAIL_FROM_ADDRESS=noreply@yourdomain.com
MAIL_FROM_NAME="Edubaseforum"

================================================================================
4. CPANEL PUBLIC_HTML SETUP
================================================================================
Option A (Simplest):
If your domain points directly to `public_html`, extract all files into `public_html`.
The included `.htaccess` file in the root will automatically and securely route
all incoming traffic to the `/public` folder and protect your `.env` file.

Option B (Recommended Best Practice):
1. Extract the project into your hosting home directory: `/home/username/edubaseforum`
2. In cPanel -> "Domains", change the Document Root for your domain to:
   `edubaseforum/public`
This ensures only the `public/` directory is accessible from the web.

================================================================================
5. DEFAULT ADMINISTRATOR CREDENTIALS AFTER IMPORT
================================================================================
Dedicated Admin Login URL:
https://yourdomain.com/admin/login

Super Administrator:
Username: admin
Password: password123
================================================================================
