/** @jsxImportSource https://esm.sh/react@18.2.0 */ import React, { useState, useEffect } from "https://esm.sh/react@18.2.0"; import { createRoot } from "https://esm.sh/react-dom@18.2.0/client"; // Earnings rate: 6¢ per minute, scaling to 360¢ per hour const EARNINGS_RATE_PER_MINUTE = 6; function formatTime(timestamp: number): string { return new Date(timestamp).toLocaleString('en-US', { year: 'numeric', month: 'short', day: 'numeric', hour: '2-digit', minute: '2-digit', second: '2-digit' }); } function formatDuration(minutes: number): string { const hours = Math.floor(minutes / 60); const remainingMinutes = Math.round(minutes % 60); return hours > 0 ? `${hours}h ${remainingMinutes}m` : `${remainingMinutes}m`; } function App() { const [startTime, setStartTime] = useState(null); const [totalEarnings, setTotalEarnings] = useState(0); const [sessionHistory, setSessionHistory] = useState>([]); useEffect(() => { // Load initial data from server fetchInitialData(); }, []); async function fetchInitialData() { try { const response = await fetch('/load-data'); const data = await response.json(); setTotalEarnings(data.totalEarnings); setSessionHistory(data.sessionHistory); } catch (error) { console.error("Failed to load initial data", error); } } function startStudySession() { setStartTime(Date.now()); } async function endStudySession() { if (!startTime) return; const endTime = Date.now(); const duration = (endTime - startTime) / 60000; // duration in minutes const earnings = Math.round(duration * EARNINGS_RATE_PER_MINUTE); try { const response = await fetch('/record-session', { method: 'POST', headers: { 'Content-Type': 'application/json' }, body: JSON.stringify({ duration, earnings, startTime, endTime }) }); const updatedData = await response.json(); setTotalEarnings(updatedData.totalEarnings); setSessionHistory(updatedData.sessionHistory); } catch (error) { console.error("Failed to record session", error); } setStartTime(null); } async function clearEarnings() { try { const response = await fetch('/clear-earnings', { method: 'POST' }); const data = await response.json(); setTotalEarnings(0); setSessionHistory([]); } catch (error) { console.error("Failed to clear earnings", error); } } return (

🧠 Study Mining Game 💰

Total Earnings: {totalEarnings}¢

{startTime ? ( ) : ( )}

Session History

{sessionHistory.map((entry, index) => ( ))}

Previous Open	Current Open	Total Time	Total Earn
{formatTime(entry.previous_open_time)}	{formatTime(entry.current_open_time)}	{formatDuration(entry.total_time)}	{entry.total_earn}¢

); } const tableCellStyle = { padding: '10px', textAlign: 'center', verticalAlign: 'middle' }; function client() { createRoot(document.getElementById("root")).render(); } if (typeof document !== "undefined") { client(); } export default async function server(request: Request): Promise { const { sqlite } = await import("https://esm.town/v/stevekrouse/sqlite"); const KEY = new URL(import.meta.url).pathname.split("/").at(-1); const SCHEMA_VERSION = 2; // Updated table schema to include more detailed tracking await sqlite.execute(` CREATE TABLE IF NOT EXISTS ${KEY}_study_sessions_${SCHEMA_VERSION} ( id INTEGER PRIMARY KEY AUTOINCREMENT, previous_open_time INTEGER NOT NULL, current_open_time INTEGER NOT NULL, total_time REAL NOT NULL, total_earn INTEGER NOT NULL, date TEXT NOT NULL ) `); await sqlite.execute(` CREATE TABLE IF NOT EXISTS ${KEY}_total_earnings_${SCHEMA_VERSION} ( total_earnings INTEGER DEFAULT 0 ) `); // Ensure initial total earnings record exists const existingEarnings = await sqlite.execute(` SELECT total_earnings FROM ${KEY}_total_earnings_${SCHEMA_VERSION} `); if (existingEarnings.rows.length === 0) { await sqlite.execute(` INSERT INTO ${KEY}_total_earnings_${SCHEMA_VERSION} (total_earnings) VALUES (0) `); } // Clear earnings endpoint if (request.method === 'POST' && new URL(request.url).pathname.endsWith('/clear-earnings')) { await sqlite.execute(` DELETE FROM ${KEY}_study_sessions_${SCHEMA_VERSION} `); await sqlite.execute(` UPDATE ${KEY}_total_earnings_${SCHEMA_VERSION} SET total_earnings = 0 `); return new Response(JSON.stringify({ totalEarnings: 0, sessionHistory: [] }), { headers: { 'Content-Type': 'application/json' } }); } if (request.method === 'POST' && new URL(request.url).pathname.endsWith('/record-session')) { const { duration, earnings, startTime, endTime } = await request.json(); const date = new Date().toISOString().split('T')[0]; // Get previous session's end time or use current start time if no previous session const previousSessionResult = await sqlite.execute(` SELECT current_open_time as last_session_end FROM ${KEY}_study_sessions_${SCHEMA_VERSION} ORDER BY id DESC LIMIT 1 `); const previousOpenTime = previousSessionResult.rows.length > 0 ? previousSessionResult.rows[0].last_session_end : startTime; // Record study session await sqlite.execute(` INSERT INTO ${KEY}_study_sessions_${SCHEMA_VERSION} (previous_open_time, current_open_time, total_time, total_earn, date) VALUES (?, ?, ?, ?, ?) `, [previousOpenTime, endTime, duration, earnings, date]); // Update total earnings await sqlite.execute(` UPDATE ${KEY}_total_earnings_${SCHEMA_VERSION} SET total_earnings = total_earnings + ? `, [earnings]); // Fetch updated data with more detailed session history const totalEarningsResult = await sqlite.execute(` SELECT total_earnings FROM ${KEY}_total_earnings_${SCHEMA_VERSION} `); const sessionHistoryResult = await sqlite.execute(` SELECT * FROM ${KEY}_study_sessions_${SCHEMA_VERSION} ORDER BY id DESC LIMIT 10 `); return new Response(JSON.stringify({ totalEarnings: totalEarningsResult.rows[0].total_earnings, sessionHistory: sessionHistoryResult.rows }), { headers: { 'Content-Type': 'application/json' } }); } if (request.method === 'GET' && new URL(request.url).pathname.endsWith('/load-data')) { const totalEarningsResult = await sqlite.execute(` SELECT total_earnings FROM ${KEY}_total_earnings_${SCHEMA_VERSION} `); const sessionHistoryResult = await sqlite.execute(` SELECT * FROM ${KEY}_study_sessions_${SCHEMA_VERSION} ORDER BY id DESC LIMIT 10 `); return new Response(JSON.stringify({ totalEarnings: totalEarningsResult.rows[0].total_earnings, sessionHistory: sessionHistoryResult.rows }), { headers: { 'Content-Type': 'application/json' } }); } return new Response(` Study Mining Game

`, { headers: { 'Content-Type': 'text/html' } }); }

studywithai