Application Scope
Development progress & changelog
Platform Apps
11 applications — economies, history, maps, AI, crypto, sports, music, movies, religion, food & more
Auto-Update History Log
New auto_update_log table tracks all update runs with status, record counts, duration, and source details.
GDPR Database Schema
Three new tables: gdpr_consents (consent tracking), gdpr_deletion_requests (deletion queue), gdpr_retention_log (cleanup audit trail).
DB: Widget usage tracking table
New widget_usage table to track embed widget views with app_key, widget_type, embed_domain, IP, user agent, and referrer. Indexed by app_key, created_at, and embed_domain for analytics queries.
DB: API keys user ownership & approval workflow
Added user_id, status (pending/approved/rejected/revoked), rejected_reason, approved_at, and approved_by columns to api_keys table with indexes. API key requests from api-docs.php now submit as pending for admin approval.
Affiliate Apps platform — shared framework and database schema
Built the complete affiliate apps platform with 8 new database tables (affiliate_apps, affiliate_settings, affiliate_analytics, affiliate_analytics_log, affiliate_content, affiliate_scrapers, affiliate_data, affiliate_online). Created shared framework in affiliates/shared/ with config, header, footer, offline page, PWA manifest generator, sitemap generator, JSON API handler, and embeddable widget generator.
PHPUnit Test Suite
Test bootstrap, phpunit.xml config, and test classes for SimpleCache, Notification, and Pagination with full coverage of core methods.