💰 Earn Money App

\n \n

Your Points: {points} 🌟

\n = 100 ? \"#4CAF50\" : \"#cccccc\",\n color: \"white\",\n padding: \"10px 20px\",\n border: \"none\",\n borderRadius: \"5px\",\n }}\n >\n Redeem Rewards (Min 100 pts)\n \n \n\n

Available Tasks:

\n {tasks.map(task => (\n \n {task.name}\n

\n +{task.reward} pts\n completeTask(task.id)}\n disabled={task.completed}\n style={{\n backgroundColor: task.completed ? \"#cccccc\" : \"#2196F3\",\n color: \"white\",\n border: \"none\",\n padding: \"5px 10px\",\n borderRadius: \"3px\",\n }}\n >\n {task.completed ? \"Completed\" : \"Complete\"}\n \n

\n \n ))}\n \n View Source\n \n \n );\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 = \"Earn\";\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_earnings_2 (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n points INTEGER DEFAULT 0,\n last_task_time DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n if (request.method === \"POST\" && new URL(request.url).pathname === \"/complete-task\") {\n const { taskId } = await request.json();\n\n await sqlite.execute(\n `\n UPDATE ${KEY}_earnings_2 \n SET points = points + ?, last_task_time = CURRENT_TIMESTAMP \n WHERE id = 1\n `,\n [taskId === 1 ? 10 : taskId === 2 ? 25 : 50],\n );\n\n const result = await sqlite.execute(`SELECT points FROM ${KEY}_earnings_2 WHERE id = 1`);\n\n return new Response(\n JSON.stringify({\n success: true,\n newPoints: result.rows[0].points,\n }),\n { headers: { \"Content-Type\": \"application/json\" } },\n );\n }\n\n if (request.method === \"GET\" && new URL(request.url).pathname === \"/get-points\") {\n let userPoints = 0;\n const result = await sqlite.execute(`SELECT points FROM ${KEY}_earnings_2 WHERE id = 1`);\n\n if (result.rows.length === 0) {\n await sqlite.execute(`INSERT INTO ${KEY}_earnings_2 (id, points) VALUES (1, 0)`);\n } else {\n userPoints = result.rows[0].points;\n }\n\n return new Response(JSON.stringify({ points: userPoints }), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n if (request.method === \"GET\" && new URL(request.url).pathname === \"/redeem-rewards\") {\n const result = await sqlite.execute(`SELECT points FROM ${KEY}_earnings_2 WHERE id = 1`);\n const currentPoints = result.rows[0].points;\n\n if (currentPoints >= 100) {\n const redeemAmount = Math.floor(currentPoints / 100) * 5;\n\n await sqlite.execute(`\n UPDATE ${KEY}_earnings_2 \n SET points = points % 100, last_task_time = CURRENT_TIMESTAMP \n WHERE id = 1\n `);\n\n return new Response(\n JSON.stringify({\n success: true,\n amount: redeemAmount,\n }),\n { headers: { \"Content-Type\": \"application/json\" } },\n );\n }\n\n return new Response(\n JSON.stringify({\n success: false,\n message: \"Not enough points\",\n }),\n { headers: { \"Content-Type\": \"application/json\" } },\n );\n }\n\n return new Response(\n `\n \n \n Earn Money App\n \n \n \n

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