Application Scope

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.

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

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.

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.

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 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.

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.

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.

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.

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/

5 partner applications: World Meters (real-time stats), World Economies (economic data), World History (historical encyclopedia), Old Maps Online (historical maps), World AI and Technology (AI/tech stats). Shared framework with config, header, footer, offline mode. Per-app API, sitemap, PWA manifest, embeddable widgets. Admin panel with offline toggle, settings customization, and per-app analytics. Frontpage Explore More section. Unified search across affiliate content. Cross-linking between all apps. Partner Apps in parent footer and sitemap.

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

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

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 full CRUD (Create, Read, Update, Delete) for editions, countries, and categories in the admin panel with inline editing.

Admins can now toggle which download types are available to users. Per-type enable/disable for editions, resources, CIA archives, Gutenberg, HathiTrust, anthems, bulk packs, rankings export, and country export.

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.

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

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.

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.

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

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.

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.

Real-time online user counter, admin user management with ban/suspend/reject, visitor analytics (IP, device, location).

Interactive Chart.js dashboard: population bars, GDP charts, region pie/doughnut, GDP vs Life Expectancy bubble scatter plot.

Full forum system: groups (open/restricted/private), threads, nested replies, reactions, polls, @mentions, notifications, moderation (ban/suspend), reputation system.

XP system with 25 levels, 30 achievements across 6 categories, 5 tiers, streak tracking, leaderboard, country visit tracking.

6 quiz modes, 9 question types auto-generated from DB, 3 difficulty levels, region filter, leaderboard, Alpine.js interactive UI.

AIProvider abstraction supporting Local, Ollama, OpenAI, Groq, Together AI, and OpenRouter. Admin-switchable providers.

AI-powered research with 6 database tools (search, compare, rankings, trends, profiles, field discovery). Function calling loop with up to 5 tool calls per query.

Edition archives (JSON/CSV/SQL), resource downloads, bulk packs, download analytics with charts.

jVectorMap integration replacing Leaflet. Click-to-play anthems, country modals, region coloring. 216 local MP3 anthems.

Admin dashboard for site settings, announcements, user management, AI configuration.

Full auth system: registration, login, sessions, 2FA, password policies, CSRF protection, audit logging, rate limiting.

Hybrid chatbot with SQL-first approach and OpenAI fallback. Natural language queries about country data.

Core platform built with 261 countries, 138,606 data records, 256 flags, 267 maps. Pages: Home, Countries, Country Profile, Compare, Rankings, Regions, Search, About.