🐼 PandaPlayGames — Full Project Save

Generated: April 8, 2026 · Upload to Claude to resume building

What This Is

PandaPlayGames — a premium educational gaming platform for kids ages 4-12, built specifically for homeschool families. Browser-based games covering math, language arts, spelling, geography, and science.

Domain: pandaplaygames.com (available as of April 8 2026)

Supabase Credentials

URL: https://cgkqyptzvejjsedlgqiq.supabase.co

Anon Key: eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJzdXBhYmFzZSIsInJlZiI6ImNna3F5cHR6dmVqanNlZGxncWlxIiwicm9sZSI6ImFub24iLCJpYXQiOjE3NzU2NzA2NTcsImV4cCI6MjA5MTI0NjY1N30.4hjVa_mmLOF8btXbfSuOQOu2pCb_4u5v0skz_v0Kx8o

Database Tables Created

• profiles — parent accounts (id, email, plan_type, stripe_customer_id, subscription_status, trial_ends_at, subscription_id, newsletter_opt_in)
• children — child profiles (id, parent_id, name, avatar, grade, xp, level, coins, streak, last_played)
• game_sessions — every game played (child_id, game_name, score, xp_earned, subject, played_at)
• badges — earned badges (child_id, badge_name, badge_emoji, earned_at)
• daily_challenges — daily progress (child_id, challenge_date, tasks_complete, bonus_complete, xp_earned)
• email_subscribers — newsletter list (email, source, opted_in_at, tags)
• donations — donation records (email, amount, message, stripe_payment_id, donated_at)

Pricing Model

• Free: 3 games, no accounts required
• Per Child: $5/month — all games, XP system, 1 child profile
• Family: $9/month — unlimited child profiles, all features
• Annual Family: $79/year
• Free month trial with credit card required (card not charged for 30 days)
• Donations: one-time, any amount via Stripe

Games Built — 11 Total

Wave 1 (Free: 3, Premium: 3)

FREE Grammar Quest — turn-based RPG, identify nouns/verbs/adjectives

FREE Noun Racer — racing game, identify word types

FREE Math Dash — side-scrolling platformer, math problems

PREMIUM Times Table Duel — multiplication battle game

PREMIUM Number Ninja — reflex math, countdown timer

PREMIUM Word Scramble Sprint — unscramble words

Wave 2 (All Premium)

PREMIUM Word Defenders — castle defense, match words to definitions (Battle Buddies inspired)

PREMIUM Asteroid Math — space shooter, blast correct answer asteroids

PREMIUM Spelling Dungeon — dungeon RPG, spell words to defeat monsters

PREMIUM Geography Quest — 15 questions, flags/capitals/landmarks

PREMIUM Science Sorter — sort animals/planets/matter into categories

Games Still To Build (Target: 25 total, 5 per subject)

Math (need 2 more)

• Fraction Frenzy — visual fraction matching game
• Pattern Patrol — complete number and shape patterns

Language Arts (need 2 more)

• Sentence Builder — drag and drop words to make correct sentences
• Punctuation Patrol — place commas, periods, question marks correctly

Spelling (need 4 more)

• Spell Blaster — shoot letters to complete falling words
• Missing Letter — fill in the blank letter in words
• Word Chain — each word starts with the last letter of previous
• Rhyme Time — match rhyming word pairs

Geography (need 4 more)

• State Spotter — identify US states
• Flag Match — memory card match with world flags
• Capital City — match countries to their capitals
• Continent Crush — sort countries into continents

Science (need 4 more)

• Animal Kingdom — classify animals into kingdoms
• Planet Patrol — identify planets by appearance
• Food Chain — arrange animals in correct food chain order
• Body Parts — label parts of the human body

What Still Needs To Be Built

NEXT Stripe billing — Vercel serverless functions for automated subscriptions

NEXT Free trial flow — 30-day trial with card on file, auto-charges day 30

NEXT Email capture popup — visitor email capture with free month offer

NEXT Newsletter opt-in — checkbox on signup form

NEXT Donation Stripe link — one-time payment link integration

NEXT Privacy policy and Terms of Service pages

NEXT Marketing landing page — separate from the game app

NEXT Email confirmation customization in Supabase

NEXT 14 more games (see list above)

NEXT Deploy to Vercel + pandaplaygames.com domain

Stripe Setup Needed

• Create product: PandaPlayGames Family Plan — $9/month recurring
• Create product: PandaPlayGames Per Child — $5/month recurring
• Create donation payment link (customer chooses price)
• Get Price IDs for both subscription products
• Get publishable key (pk_live_...) and secret key (sk_live_...)
• Set up webhook endpoint for subscription events

Vercel Serverless Functions Needed

• api/create-subscription.js — creates Stripe trial subscription with 30-day free period
• api/webhook.js — receives Stripe events, updates Supabase plan_type
• api/cancel-subscription.js — handles cancellation requests
• api/create-donation.js — creates one-time Stripe payment intent

Architecture Notes

• Adding a new game: add entry to GAMES_DATA array + add new screen HTML + game JS. Zero disruption to existing users.
• Free games: Grammar Quest, Noun Racer, Math Dash
• All other games are premium-locked
• XP formula: correct answer = 10 XP base + streak bonus. Level up every 100 XP.
• Coins: 1 per correct answer, spendable in avatar shop
• Sponsor ad slots: 3 on homepage, 1 on parent dashboard. Swap image/link per sponsor.
• Panda mascot: 🐼 used throughout as brand character

How To Resume With Claude

Upload this file and say: "Here is my PandaPlayGames project save file. I have my Supabase credentials and I'm ready to continue. Today I want to [build Stripe billing / build more games / deploy to Vercel]."

Last updated: April 8, 2026