Application Scope

Added 780 new records + updated 243: GDP, inflation, unemployment, trade, reserves, external debt, FDI, Gini index from World Bank and REST Countries.

Added 395 new records: population density, birth/death/fertility rates, life expectancy, urban population %, infant mortality, and more from World Bank.

New deploy_update/scrape_all_apps.php enriches all 11 affiliate apps with data from REST Countries, World Bank (21 indicators), and Wikipedia (country-specific articles).

New auto_update_log table tracks all update runs with status, record counts, duration, and source details.

deploy_update/auto_updater.php pulls fresh data from REST Countries API, World Bank API, Wikipedia summaries, and local Factbook JSON to update affiliate app content.

New Auto Updates admin tab with configurable update interval (daily/weekly/monthly), data source selection (REST Countries, World Bank, Wikipedia, Factbook JSON), manual update trigger, and cron job setup instructions.

Limited footer Partner Apps to 8 entries with a "View All Apps" link as the 9th item pointing to platform-apps.php.

Limited Explore More section to 6 apps with auto-rotation on each visit via session-based shuffling. Added link to platform-apps.php.

Reduced height of Featured Countries + Did You Know and Browse by Region + Data Categories sections by ~50%. Added "View All" links to full pages.

Admin can process pending GDPR requests (data deletion, account deletion) and run manual retention cleanup from the admin panel.

Upgraded footer cookie banner to GDPR-aware version with granular consent options (essential, analytics, usage) using Alpine.js. Respects admin GDPR settings.

Three new tables: gdpr_consents (consent tracking), gdpr_deletion_requests (deletion queue), gdpr_retention_log (cleanup audit trail).

New api/gdpr.php endpoint supporting consent recording, consent withdrawal, data export, data deletion, account deletion, and settings retrieval.

Admin panel GDPR & Privacy tab with 10 toggles: GDPR master switch, cookie consent, privacy policy, analytics tracking, usage tracking, data retention, data export, data deletion, account deletion, and configurable retention period.

New privacy.php page where users can manage consent preferences, export personal data as JSON, delete activity data, or permanently delete their account.

Full GDPR implementation with consent management, data export, data deletion, and account deletion. Includes granular cookie consent banner with essential/analytics/usage tracking options.

Fixed broken nav links replaced with working Countries page links in all app pages.

Updated sitemap.php XML and sitemap-page.php with countries.php for all 5 new affiliate apps.

Added 5 new apps to frontpage partners auto-scrolling slider. Total: 11 partners.

Extracted Browse by Country into dedicated countries.php pages with region filter, letter filter, search, and data count badges.

Created full page sets (index.php, country.php, detail.php, countries.php) for World Sports, World Music, World Movies & TV, World Religion & Culture, and World Food & Cuisine apps.

New Activity tab with 30-day signups bar chart, user role distribution, and recent user activity log from audit_logs. Stats bar shows 8 summary cards: total, active, verified, admins, banned, 2FA, new today, new this week. New verified/unverified filter options.

Select-all checkbox with bulk activate, deactivate, verify, and ban actions. Superadmin accounts are protected from bulk operations. All bulk actions are audit-logged.

User management now paginates at 50 users per page with page navigation. Sort options: newest, oldest, name, last login, role. Search extended to also match by IP address.

Analytics sidebar now includes 16 sections: Overview, Traffic, Partner Apps, Performance, Searches, Downloads, AI Chatbot, Content, Ads, Announcements, API, Widgets, Users, Newsletter, Security, Audit Log. Overview section expanded to 10 stat cards including Partner App Views and Widget Embeds.

New Widgets section (total views, unique embed domains, per-app breakdown) and Newsletter section (total/active/new subscriber counts) added to analytics dashboard.

New Content section displaying counts for countries, data records, editions, rankings, resources, and affiliate data/content broken down per app.

New Performance section with average page load time, slow pages (>500ms), hourly traffic distribution bar chart, and API response time tracking.

New Partner Apps analytics section showing per-app cards with page views, unique visitors, data count, content count, and online users. Includes combined daily traffic chart and top pages per app.

Complete rewrite of api-docs.php with sidebar navigation (Alpine.js). Sections: Overview, Authentication, Get API Key, Countries, Timeline, Export, AI Chatbot, Error Codes, Widgets & Embeds, plus dynamic per-app API documentation for all 5 affiliate apps with endpoint tables and embed code examples.

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.

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.

New dedicated admin page for managing API keys with 6 tabs: Keys, Usage Analytics, Endpoints, By User, Widget Usage, and App APIs. Supports full CRUD for API keys including approve/reject/revoke/reactivate workflows, rate limit adjustments, per-key detail drill-down with recent call logs, and Chart.js daily API calls chart.

Updated buildSiteKnowledge() in ChatController.php with all 5 affiliate apps and their features. Added affiliate app query examples to fallback suggestions.

Built analytics flow: trackAppPageView() writes to affiliate_analytics_log (raw events) and upserts affiliate_analytics (daily aggregates). affiliate_online table tracks active sessions with 15-minute cleanup. Admin dashboard queries aggregated analytics and live online counts.

New "Affiliate Apps" tab in admin sidebar. Shows apps table with status indicators, offline/active toggle switches, and analytics summary. Per-app settings editor for title, theme color, description, meta keywords. Per-app analytics view with daily page views and unique visitors. CSRF-protected toggle actions.

Added "Explore More" section on frontpage with affiliate app cards queried from DB. Added "Partner Apps" column in footer with dynamic links. Extended search.php to query affiliate_content via FULLTEXT for unified search results across all apps.

AI readiness index and digital infrastructure tracker by country. Features country technology profiles, AI milestones timeline, public AI perception data, internet/mobile penetration stats. Path: /affiliates/worldai/

Historical maps collection organized by region and time period — Ancient, Medieval, Renaissance, Early Modern, and Modern eras. Features map browsing by region with detailed descriptions and source attribution. Path: /affiliates/oldmaps/

Historical eras explorer with civilizations, empires, and major events. Features interactive timeline, era-based browsing, and detailed article pages. Path: /affiliates/worldhistory/

Country economic data explorer with GDP, trade, employment, and financial indicators. Features country profiles, comparison tool, economic rankings, and indicator explorer. Path: /affiliates/worldeconomies/

Real-time animated world statistics counters built with Alpine.js. Shows live population, births, deaths, CO2 emissions, internet users, and more with smooth counter animations. Path: /affiliates/worldmeter/

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.

New affiliate app with index, countries, market, history, research pages. Data scraped from CoinGecko API. Theme: amber-to-orange, bitcoin icon. 187 data records, 8 content articles.

Changed the Explore More section grid from xl:grid-cols-5 to xl:grid-cols-6 with smaller card sizes and icons so all 6 affiliate apps fit horizontally.

Updated worldai affiliate_data with 1,394 records from World Bank API covering internet users, mobile subscriptions, patent applications, high-tech exports, and secure internet servers.

Timeline events now link to article.php detail pages where matching content exists. Created article.php with sidebar, related articles, breadcrumbs, and styled content layout.

Completely rewritten to show maps from affiliate_content grouped by category (Ancient, Medieval, Renaissance, Early Modern, Modern). Added clickable filter tabs and styled map cards with images and descriptions.

Joined countries table in compare.php and rankings.php to display full country names instead of GEC abbreviations.

Replaced static grid layout in shared footer with an Alpine.js auto-scrolling carousel slider with dot indicators, gradient fade edges, and responsive visible count.

Added file upload fields (logo_file, favicon_file) to the affiliate settings form with enctype multipart/form-data. Files saved to uploads/affiliates/ with app_key prefix. Shows preview of existing logo/favicon.

Added pencil edit button per partner row in admin Affiliates tab. Clicking it pre-fills the add/edit form via JavaScript (editPartner/resetPartnerForm functions). Added Reset button and editing indicator.

Added renderAdSlot(content_top) to affiliates/shared/header.php and renderAdSlot(content_bottom) to affiliates/shared/footer.php. When ads are enabled in admin, they now display on all affiliate apps.

Added the announcement ticker (from admin panel) to affiliates/shared/header.php. Reads from announcements table and announcement_enabled setting. Includes marquee animation and dismiss button.

Replaced "Home" text link with a house icon button. Added a grid icon (layout-grid) that opens a dropdown listing all active affiliate apps with gradient icons, names, and short descriptions. Separated from main nav links with a vertical divider.

The country_data table uses value_text, not value. Fixed worldeconomies/country.php SQL query and grouping code.

The rankings table uses field_name/display_name (not category), value_numeric/value_formatted (not value), and has no total_ranked column. Fixed SQL query and all template references in worldeconomies/country.php.

Resolved SQLSTATE[HY000] 1267 Illegal mix of collations error in cryptoworld/countries.php and index.php. Applied COLLATE utf8mb4_unicode_ci on affiliate_data.country_code (general_ci) to match countries.gec_code (unicode_ci). Also fixed in worldeconomies compare.php and rankings.php.

Fixed 3 GDP rankings showing 0 countries due to field_name mismatch between rankings table and sidebar.

Added 6 new military ranking categories to rebuildRankings(). Total ranking categories now 35.

Expanded World Bank military indicators from 1 to 5 in EditionBuilder.

Added globalfirepower source type to EditionBuilder with scrapeGlobalFirepower() method and parseGfpCountryPage() HTML parser. Covers 145 countries with detailed military strength data.

New standalone import script (populate_military_data.php) fetches military data from World Bank API (5 indicators) and GlobalFirepower (60+ data points per country). Inserts 796+ World Bank records across 169 countries.

Added Contact Us link to header More dropdown, mobile navigation, and footer Resources section. Updated About page with Quick Links section for Sitemap, Application Scope, and Contact Us.

Admin settings to enable/disable 2FA site-wide and require 2FA for admin accounts. Includes live adoption stats showing users and admins with 2FA enabled.

New Contact Messages tab in admin panel for viewing, filtering, and managing contact form submissions. Includes status updates, admin notes, message deletion, and contact page settings.

Backend API endpoint for contact form submissions with input validation, honeypot spam detection, and IP-based rate limiting (5 per hour).

Professional Contact Us page with interactive globe map (Leaflet.js), contact details, inquiry categories, and modal contact form with CAPTCHA challenge to prevent spam.

Added "Import Other Archives (1981-1989, 1998-1999 to DB)" option to the admin import scripts dropdown. Supports single-year or batch processing via CLI argument or admin panel.

Cleaned text files for 1981, 1983-1989, 1998, and 1999 editions copied to /data/archives/hathitrust/. Automatically available in the HathiTrust Reader, Download Center, and Resource Library. SQL backup files generated for each year in /data/import/.

Comprehensive alias map resolving 50+ historical country names to current database entries. Covers Cold War-era names (USSR, East/West Germany, Yugoslavia), colonial names (Zaire, Rhodesia, Burma), and format-specific variants (comma-inverted names like "Korea, North").

Two dedicated parsers for Project Gutenberg text editions. The 1998 parser handles @Country:Section markers with underscore separators. The 1999 parser handles ====== block separators with @CountryName prefixes. Both resolve country names via aliasing and produce structured field-value records.

Parses scanned OCR text files for years 1981, 1983-1989. Detects country names by matching against the database, identifies section headers (Geography, People, Government, Economy, Communications, Defense Forces), and extracts field-value pairs with continuation line support. Handles both ALL-CAPS and mixed-case section headers.

New import script process_other_archives.php parses CIA World Factbook text editions from Internet Archive and Project Gutenberg. Supports three parser modes: OCR (1981, 1983-1989), Gutenberg98 with @Country:Section markers (1998), and Gutenberg with ====== separators (1999). Imported 124,630 records across 1,754 country-editions.

All destructive GET-based admin actions (delete/toggle for announcements, ads, resources, paths, lessons, classrooms, API keys) now require a CSRF token and cast IDs to integer to prevent injection.

All 7 input handlers in api/learn.php now use InputSanitizer: enrollment, lesson completion, bookmarks, and path import. Slug validation, score range enforcement, and lesson content sanitization added.

All 12 input handlers in api/classroom.php now use InputSanitizer: class creation, assignments, discussions, grading, rubrics, bulk import, and moderation. Array type checks added for nested inputs.

New InputSanitizer class with 10 methods: text, richText, positiveInt, float, enum, email, url, slug, csvList, and json. Strips dangerous HTML (scripts, iframes, event handlers, JS URIs) while preserving safe formatting tags.

All admin POST forms (settings, announcements, ads, resources, learning paths, lessons) now include CSRF tokens. All destructive GET actions (delete, toggle) require a valid token parameter. Uses Auth::generateCsrfToken/verifyCsrfToken with 2-hour expiry.

Replaced hardcoded admin credentials with the Auth system. Admin panel now requires login via the users table with role-based access control — only admin and superadmin roles are permitted. Includes full Auth features: rate limiting, account lockout, and session management.

Added ARIA roles and labels to main navigation, notification bell, and desktop menu bar for screen reader support.

Enrollment trend line chart and enrollments vs completions bar chart added to admin Learning Paths tab using Chart.js.

Students can flag discussion posts. Teachers see flagged posts and can approve or reject them. Notifications sent to teachers.

Real-time leaderboard ranking students by average score and assignments completed. Cached in database for performance.

My Progress page with XP chart, streak calendar, learning path progress bars, recent quizzes, achievements, and quick links.

Export learning paths as JSON for backup or sharing. Import JSON to create new paths with all lessons. Admin-only import.

Toggle dark mode in admin panel via nav bar button. CSS-based dark theme applied to all cards, tables, inputs, and text.

Web app manifest, service worker with cache-first for assets and network-first for pages, and automatic SW registration.

RateLimiter and ApiMiddleware classes enforce per-key hourly rate limits with X-RateLimit headers and 429 responses.

Reusable Pagination helper class with rendered page controls. Applied to classrooms table with configurable per-page limits.

SimpleCache class provides database-backed caching with TTL, remember pattern, enable/disable, and automatic cleanup.

Teachers can import multiple students into a classroom by username or email. Handles duplicates, capacity limits, and reports results.

Teachers can archive and unarchive classes. Archived classes are preserved but hidden from active views.

Real-time notification bell in header with dropdown showing assignment alerts, grade notifications, class joins, path completions, and moderation flags.

Teachers can create detailed rubrics with criteria and point breakdowns for assignments. Rubric-based grading with per-criterion scores and feedback.

Lessons now support file attachments (PDF, images) with sort ordering. Attachments are displayed alongside lesson content.

Users can bookmark lessons for quick access later. Bookmarks include optional notes and are accessible from the My Progress dashboard.

Paths can now require completion of a prerequisite path before enrollment. Enforced in API and shown in UI.

Added 9 new database tables for Learning Paths and Classroom features: learning_paths, learning_lessons, user_path_enrollment, user_lesson_progress, classrooms, classroom_students, classroom_assignments, assignment_submissions, classroom_discussions. Seeded 8 learning paths with 36 lessons containing rich educational content.

Full classroom management system. Teachers can create classes with unique 6-character join codes, invite students, create quiz assignments with configurable difficulty/question count/deadlines/max attempts, view submission status, remove students, and export grades as CSV. Students join classes via code, view assignments with due dates, and submit work. Includes per-class and per-assignment threaded discussion boards with teacher badges. 5 new database tables: classrooms, classroom_students, classroom_assignments, assignment_submissions, classroom_discussions.

New structured course system with 8 learning paths (World Geography 101, Global Economics, Demographics Deep Dive, World Governments & Politics, Africa Focus, Asia & Oceania Focus, Europe Focus, Americas Focus). Each path contains 4-5 lessons following a Reading → Visual → Quiz → Summary flow. Features include enrollment tracking, per-lesson progress, XP rewards, Chart.js data visualizations from live country data, integrated quiz engine, and certificate of completion. 36 lessons total with rich educational content.

Created new sitemap-page.php with tree and grid views. Features expandable sections, page badges with counts, color-coded categories, and smooth animations.

Added Edition Updates section to analytics page showing full/partial edition counts, records by decade breakdown, and complete edition table with coverage indicators.

API key requests now require authenticated users. Form pre-fills name and email from user profile. Non-logged-in users see a login prompt.

Added National Anthems tab to the Download Center with search, play/pause controls, progress bar, download buttons, and session listen/download counters.

Added 15 new resources including edition guides, analysis documents, field references, and educational materials. Total: 36 resources.

Added 61 new curated facts covering geography, demographics, economics, government, military, infrastructure, and culture. Total: 181 facts.

Created World Regions, World Religions, Independence Dates, Country Climates, and National Anthems flashcard decks. Total: 10 system decks with 1,400+ cards.

Rewrote quiz question generation to use bulk pre-fetched data instead of per-country queries. Quiz generation is now instant instead of timing out.

Added 81 new glossary terms covering economic, demographic, geographic, government, military, infrastructure, and energy categories. All terms include related_field mappings for country data tooltips.