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.

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

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.

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

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.

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.

Added full CRUD (Create, Read, Update, Delete) for editions, countries, and categories in the admin panel with inline editing.

Admin can ban/unban users from discussions, suspend users temporarily, enable/disable accounts, and reject pending users directly from the user management panel.

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.

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.

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

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.

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

Development progress page with list and timeline views showing all platform changes.

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

25+ defined terms across economic, government, geographic, demographic, military categories. Alphabet browse, search, related field links.

Auto-generated facts from data anomalies, community submissions, upvote/downvote, category filtering.

Spaced repetition (SM-2 algorithm) flashcards. System decks: Capitals, Flags, Currencies, Government Types, Languages. Progress tracking.

Bookmark countries, create named study collections, personal notes, public sharing via token links.

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.

Daily featured country with deterministic rotation, key facts, map, anthem, streak tracking, XP rewards.

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.