================================================================
  FarmOS — MySQL Server Setup Guide
  Migrated from: Firebase (Firestore + Firebase Auth)
  Now uses: MySQL + PHP (compatible with phpMyAdmin)
================================================================

----------------------------------------------------------------
  WHAT CHANGED
----------------------------------------------------------------

  BEFORE (Firebase):
    - Data stored in: Firestore (NoSQL cloud database)
    - Login via: Firebase Authentication
    - Real-time sync: Firestore onSnapshot() listeners
    - Password reset: Firebase email

  AFTER (MySQL/PHP):
    - Data stored in: MySQL database (managed via phpMyAdmin)
    - Login via: PHP session tokens + bcrypt passwords
    - Real-time sync: Polling every 15–30 seconds
    - Password reset: Admin resets directly in portal


----------------------------------------------------------------
  FILES IN THIS PACKAGE
----------------------------------------------------------------

  FarmOS-MySQL.html           → Farm app (replaces FarmOS-Firebase.html)
  FarmOS-Admin-MySQL.html     → Admin portal (replaces FarmOS-Admin-Firebase.html)

  farmos_database.sql         → Import this into phpMyAdmin FIRST
  config/db.php               → Edit with your MySQL credentials
  api/login.php               → POST: login, returns session token
  api/logout.php              → POST: logout
  api/farmdata.php            → GET/POST: load & save all farm data
  api/clients.php             → GET/POST: manage clients (admin)
  api/activity.php            → GET/POST: activity log
  api/recovery.php            → POST: password recovery requests
  api/users.php               → GET/POST: users + password change


----------------------------------------------------------------
  STEP 1 — Import the Database (phpMyAdmin)
----------------------------------------------------------------

  1. Open phpMyAdmin (usually at http://localhost/phpmyadmin)
  2. Click "New" to create a database named: farmos
     (or the import will create it automatically)
  3. Select the "farmos" database
  4. Click the "Import" tab
  5. Choose file: farmos_database.sql
  6. Click "Go"

  This creates all 7 tables and a default admin user:
    Email:    admin@farmos.local
    Password: farmos2024
    ⚠️ CHANGE THIS after first login!


----------------------------------------------------------------
  STEP 2 — Configure db.php
----------------------------------------------------------------

  Open config/db.php and edit these 4 lines:

    define('DB_HOST', 'localhost');   // your MySQL host
    define('DB_NAME', 'farmos');      // database name
    define('DB_USER', 'root');        // your MySQL username
    define('DB_PASS', '');            // your MySQL password

  For a typical XAMPP/WAMP local setup:
    DB_HOST = localhost
    DB_USER = root
    DB_PASS = (empty)

  For a hosting provider (shared hosting):
    DB_HOST = localhost (usually)
    DB_USER = (your cPanel username)_farmos
    DB_PASS = (the password you set)


----------------------------------------------------------------
  STEP 3 — Set the API_BASE in HTML files
----------------------------------------------------------------

  Both HTML files have this at the top of their <script>:

    var API_BASE = './api';

  This means the PHP files must be in a folder called "api/"
  in the same directory as the HTML files.

  Your folder structure must look like this:

    /your-website-folder/
    ├── FarmOS-MySQL.html
    ├── FarmOS-Admin-MySQL.html
    ├── config/
    │   └── db.php
    └── api/
        ├── login.php
        ├── logout.php
        ├── farmdata.php
        ├── clients.php
        ├── activity.php
        ├── recovery.php
        └── users.php


----------------------------------------------------------------
  STEP 4 — Upload to Server
----------------------------------------------------------------

  OPTION A — Local (XAMPP / WAMP):
    Copy your folder to: C:/xampp/htdocs/farmos/
    Open: http://localhost/farmos/FarmOS-Admin-MySQL.html

  OPTION B — Shared Web Hosting (cPanel):
    1. Upload all files via File Manager or FTP
    2. Put them in public_html/farmos/ or a subdomain
    3. Make sure PHP 7.4+ is enabled

  OPTION C — VPS / Cloud Server:
    - Install: Apache/Nginx + PHP 7.4+ + MySQL 5.7+
    - Enable PDO and pdo_mysql PHP extensions
    - Point your domain/subdomain to the folder


----------------------------------------------------------------
  STEP 5 — Create Your First Farm Client
----------------------------------------------------------------

  1. Open FarmOS-Admin-MySQL.html in your browser
  2. Login with:
       Email:    admin@farmos.local
       Password: farmos2024
  3. Go to Settings → Change the admin password IMMEDIATELY
  4. Go to Clients → Add New Client
     - Enter farm name, owner name, owner email
     - Set a password for the owner
     - Click Save
  5. The farm owner can now log into FarmOS-MySQL.html


----------------------------------------------------------------
  DIFFERENCES FROM FIREBASE VERSION
----------------------------------------------------------------

  1. PASSWORD RESET
     - Before: Firebase sent an email automatically
     - Now: User clicks "Forgot Password" → admin sees a
       recovery request → admin sets new password manually
       via Admin Portal → Recovery Requests

  2. REAL-TIME SYNC
     - Before: Firestore pushed changes instantly
     - Now: App polls every 30 seconds for changes
     - Changes you make yourself save immediately

  3. OFFLINE
     - Before: Firebase had offline cache
     - Now: Requires an internet/network connection to the server

  4. ADMIN USER
     - Before: Any Firebase Auth email worked if in config
     - Now: Only users with role='admin' can access the admin portal


----------------------------------------------------------------
  TROUBLESHOOTING
----------------------------------------------------------------

  "Database connection failed"
    → Check DB_HOST, DB_NAME, DB_USER, DB_PASS in config/db.php
    → Make sure MySQL is running

  "Unauthorized" / login fails
    → Run the SQL import again to ensure tables exist
    → Check PHP error logs

  "No farm linked to account"
    → The user exists but has no client_id
    → Create the client first via admin portal

  CORS errors in browser console
    → config/db.php sets CORS headers automatically
    → Make sure you're not opening HTML as file:// (use http://)

  PHP errors visible on screen
    → Add to the top of config/db.php:
       error_reporting(0); ini_set('display_errors', 0);

================================================================
  END OF SETUP GUIDE
================================================================