🧠 Study Mining Game 💰

Total Earnings: {totalEarnings}¢

\n \n

\n\n

\n {startTime ? (\n \n ) : (\n \n )}\n

\n\n

Session History

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

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}¢

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

\n \n \n \n \n `, {\n headers: { 'Content-Type': 'text/html' }\n });\n}","deleted","label",[98],"permalink","https://www.val.town/x/studywithai/sprightlyWhiteLion/code/main.tsx","extension","actionData","errors"]