// Family Quest v17 → Database Upgrade Script // Add this BEFORE your existing game code on the WordPress page import React, { useState, useEffect } from ‘react’; import { Trophy, Star, Award, Plus, X, RotateCcw, History, Footprints } from ‘lucide-react’; const FamilyQuestGame = () => { const [players, setPlayers] = useState([ { id: 1, name: ‘Player 1’, points: 0, steps: 0, dailyPoints: 0, hasUsedBonus: false, color: ‘bg-blue-500’ }, { id: 2, name: ‘Player 2’, points: 0, steps: 0, dailyPoints: 0, hasUsedBonus: false, color: ‘bg-purple-500’ }, { id: 3, name: ‘Player 3’, points: 0, steps: 0, dailyPoints: 0, hasUsedBonus: false, color: ‘bg-green-500’ }, { id: 4, name: ‘Player 4’, points: 0, steps: 0, dailyPoints: 0, hasUsedBonus: false, color: ‘bg-orange-500’ } ]); const [weekHistory, setWeekHistory] = useState([]); const [currentWeek, setCurrentWeek] = useState(1); const [showHistory, setShowHistory] = useState(false); const [showRandomizer, setShowRandomizer] = useState(false); const [showRules, setShowRules] = useState(false); const [selectedPlayer, setSelectedPlayer] = useState(null); const [isSpinning, setIsSpinning] = useState(false); const [spinResult, setSpinResult] = useState(null); const defaultTasks = [ // 6 Points { id: 1, name: ‘Work a shift outside of home’, points: 6, category: ‘growth’ }, { id: 2, name: ‘Volunteer (per hour)’, points: 6, category: ‘growth’ }, { id: 3, name: ‘Counseling session (per person/hour)’, points: 6, category: ‘growth’ }, { id: 4, name: ‘Coaching session (per person/hour)’, points: 6, category: ‘growth’ }, { id: 5, name: ‘Cook a meal for the house’, points: 6, category: ‘chore’ }, { id: 6, name: ‘Attend online class/course (1+ hour)’, points: 6, category: ‘growth’ }, // 2 Points { id: 7, name: ‘Write a journal entry’, points: 2, category: ‘growth’ }, { id: 8, name: ‘List 3 items you are grateful for’, points: 2, category: ‘growth’ }, { id: 9, name: ‘One MyGrow droplet’, points: 2, category: ‘growth’ }, { id: 10, name: ‘Write a thank you note for someone’, points: 2, category: ‘growth’ }, { id: 11, name: ‘Attend a church service’, points: 2, category: ‘growth’ }, { id: 12, name: ‘Doctor or dentist appointment’, points: 2, category: ‘growth’ }, { id: 13, name: ‘Job interview’, points: 2, category: ‘growth’ }, { id: 14, name: ‘Practice an instrument’, points: 2, category: ‘growth’ }, { id: 15, name: ‘Duolingo/Babbel lesson (10+ min)’, points: 2, category: ‘growth’ }, { id: 16, name: ‘Playground time with Matthew (no phones)’, points: 2, category: ‘growth’ }, { id: 17, name: ‘Watch Chosen episode with Mom/Dad’, points: 2, category: ‘growth’ }, { id: 18, name: ‘Attend weekly family business meeting’, points: 2, category: ‘growth’ }, { id: 19, name: ‘Meet step goal (3000/5000/10000)’, points: 2, category: ‘growth’ }, { id: 20, name: ‘One of your regular chores’, points: 2, category: ‘chore’ }, { id: 21, name: ’30 min weeding/watering/raking’, points: 2, category: ‘chore’ }, // 1 Point { id: 22, name: ‘Library visit with M’, points: 1, category: ‘growth’ }, { id: 23, name: ‘Read 5 books to M’, points: 1, category: ‘growth’ }, { id: 24, name: ‘Go on a walk (15+ min, 1/day)’, points: 1, category: ‘growth’ }, { id: 25, name: ‘Swim at Y or rec center as family’, points: 1, category: ‘growth’ }, { id: 26, name: ’10 min of calisthenics’, points: 1, category: ‘growth’ }, { id: 27, name: ‘Apply for a job’, points: 1, category: ‘growth’ }, { id: 28, name: ‘One hour without media/phone’, points: 1, category: ‘growth’ }, { id: 29, name: ‘Read a chapter of a book’, points: 1, category: ‘growth’ }, { id: 30, name: ‘Read the Bible (5+ minutes)’, points: 1, category: ‘growth’ }, { id: 31, name: ‘One load of laundry completed’, points: 1, category: ‘chore’ }, { id: 32, name: ‘Wash sheets’, points: 1, category: ‘chore’ }, { id: 33, name: ‘Wash towels’, points: 1, category: ‘chore’ }, { id: 34, name: ‘Make bathroom “guest ready”‘, points: 1, category: ‘chore’ }, { id: 35, name: ‘Three days without fast food’, points: 1, category: ‘growth’ }, { id: 36, name: ‘No meals/snacks after 7pm’, points: 1, category: ‘growth’ }, { id: 37, name: ‘No screen time one hour before bed’, points: 1, category: ‘growth’ } ]; const [tasks, setTasks] = useState(defaultTasks); const [newTaskName, setNewTaskName] = useState(”); const [newTaskPoints, setNewTaskPoints] = useState(”); const [newTaskCategory, setNewTaskCategory] = useState(‘chore’); const addTask = () => { if (newTaskName && newTaskPoints) { const newTask = { id: tasks.length + 1, name: newTaskName, points: parseInt(newTaskPoints), category: newTaskCategory }; setTasks([…tasks, newTask]); setNewTaskName(”); setNewTaskPoints(”); } }; const removeTask = (taskId) => { setTasks(tasks.filter(t => t.id !== taskId)); }; const addPoints = (playerId, points) => { setPlayers(players.map(p => p.id === playerId ? { …p, points: p.points + points, dailyPoints: p.dailyPoints + points } : p )); }; const completeDay = (playerId) => { setPlayers(players.map(p => { if (p.id === playerId && p.dailyPoints >= 10) { return { …p, steps: p.steps + 1, dailyPoints: 0 }; } return p; })); }; const resetDailyPoints = (playerId) => { setPlayers(players.map(p => p.id === playerId ? { …p, dailyPoints: 0 } : p )); }; const updatePlayerName = (playerId, newName) => { setPlayers(players.map(p => p.id === playerId ? { …p, name: newName } : p )); }; const endWeek = () => { const sortedPlayers = […players].sort((a, b) => b.points – a.points); const winners = sortedPlayers.filter(p => p.points >= 50 || p.steps >= 5); const weekData = { week: currentWeek, date: new Date().toLocaleDateString(), winners: winners.length > 0 ? winners.map(w => w.name).join(‘, ‘) : ‘No winners this week’, scores: players.map(p => ({ name: p.name, points: p.points, steps: p.steps })) }; setWeekHistory([weekData, …weekHistory]); setPlayers(players.map(p => ({ …p, points: 0, steps: 0, dailyPoints: 0, hasUsedBonus: false }))); setCurrentWeek(currentWeek + 1); }; const resetGame = () => { setPlayers(players.map(p => ({ …p, points: 0, steps: 0, dailyPoints: 0 }))); }; const spinWheel = (playerId) => { setIsSpinning(true); setSpinResult(null); setTimeout(() => { const won = Math.random() < 0.25; // 25% chance setSpinResult(won); if (won) { setPlayers(players.map(p => p.id === playerId ? { …p, points: p.points + 5, hasUsedBonus: true } : p )); } else { setPlayers(players.map(p => p.id === playerId ? { …p, hasUsedBonus: true } : p )); } setIsSpinning(false); }, 2000); }; const openRandomizer = (playerId) => { setSelectedPlayer(playerId); setShowRandomizer(true); setSpinResult(null); }; const sortedPlayers = […players].sort((a, b) => b.points – a.points); const PathStep = ({ active, isGoal }) => ( ); return (