TRACKBOARD 3.0 UPGRADE OVERLAY

Contents are only replacement files, new files and SQL migration.

IMPORTANT BACKUP
1. Export your current TrackBoard database from phpMyAdmin.
2. Download a backup copy of your TrackBoard folder.
3. Upload the contents of this overlay into the existing TrackBoard folder and allow replacement only for files included here.
4. In phpMyAdmin select the EXISTING TrackBoard database and import upgrade.sql.
5. Sign in to /admin/superadmin-login.php and open the new Security settings page.
6. Configure vendor name and optional WhatsApp, Telegram and email in the Super Admin panel.

REPLACED FILES
- admin/superadmin.php
- admin/superadmin-login.php
- admin/dashboard.php
- admin/license.php
- admin/sites.php
- api/collect.php

NEW FILES
- admin/superadmin-security.php
- upgrade.sql
- README-UPGRADE.txt

LICENCE MODEL
- Validity is 1–12 months; optional custom expiry date overrides calculated expiry.
- Popup-link allowance currently maps to the existing TrackBoard project/site records. In this codebase one project/site represents one tracked popup/page endpoint. The quota limits creation of these records.
- Existing max_projects values are migrated into max_popup_links.
- Expired/suspended licences are blocked by the existing collect and engagement APIs. Customer license panel shows configured vendor renewal contacts.

REPORTING
- Returning visitors are estimated using a stable keyed hash of IP + browser user-agent. Raw IP addresses are not stored. This is an estimate and can undercount users who change networks/devices or clear browser identity.
- Engagement is active visible-tab time reported by the browser tracker. Closing a tab, connectivity loss, or browser restrictions may cause under-reporting.
- Existing tracker still only records homepage/index page paths in this version; the report filters and URL breakdown display only the paths currently collected. This overlay does not add a full multi-URL popup-campaign manager.

SUPER-ADMIN PASSWORD
- No password-reset link is provided on the sign-in page.
- Password change is available only after sign-in at /admin/superadmin-security.php.

TESTING LIMITATION
This overlay is statically checked for PHP syntax and SQL/file references. It has not been run against your live Namecheap PHP/MySQL environment. Test on a backup/staging copy before production. If your existing database schema differs from the supplied TrackBoard 3.0 Enhanced Full build, stop and share the table structure before importing.
