🔒 Admin Withdrawal Requests

\n {withdrawalRequests.length === 0 ? (\n

No pending withdrawal requests

\n ) : (\n \n \n \n \n \n \n \n \n \n {withdrawalRequests.map((request) => (\n \n \n \n \n \n ))}\n \n

User	Amount	Actions
{request.username}	₹{request.amount}	\n \n \n

\n )}\n

\n );\n\n const renderUserDashboard = () => (\n

💰 Wallet Balance: ₹{balance}

\n setWithdrawalAmount(e.target.value)}\n style={{\n padding: '10px',\n marginRight: '10px',\n backgroundColor: '#0f3460',\n color: 'white',\n border: '1px solid #535c91'\n }}\n />\n \n

\n\n

\n {lotteryConfigs.map((config, index) => (\n

Game {index + 1}

Bet: ₹{config.amount}

Potential Win: ₹{config.prize}

\n \n

\n ))}\n

\n\n

🕒 Transaction History

\n \n \n \n \n \n \n \n \n \n {transactions.slice(0, 5).map((tx, index) => (\n 0 ? '#16c79a' : '#ff3f34'\n }}\n >\n \n \n \n \n ))}\n \n

Type	Amount	Date
{tx.type}	₹{tx.amount}	{new Date(tx.timestamp).toLocaleString()}

\n );\n\n const renderContent = () => {\n if (!isLoggedIn) {\n return mode === 'login' ? (\n

Login to Gaming Platform

\n setUsername(e.target.value)}\n required \n style={{\n width: '100%',\n padding: '10px',\n marginBottom: '15px',\n backgroundColor: '#0f3460',\n color: 'white',\n border: '1px solid #535c91'\n }}\n />\n setPassword(e.target.value)}\n required \n style={{\n width: '100%',\n padding: '10px',\n marginBottom: '15px',\n backgroundColor: '#0f3460',\n color: 'white',\n border: '1px solid #535c91'\n }}\n />\n \n

\n Don't have an account? \n \n

\n ) : (\n

Register to Gaming Platform

\n Already have an account? \n \n

\n );\n }\n\n return (\n

\n {result && (\n

\n {result}\n

\n )}\n {userRole === 'admin' ? renderAdminDashboard() : renderUserDashboard()}\n \n

\n );\n };\n\n const playLottery = async (config) => {\n // Existing lottery play logic remains the same\n };\n\n return (\n

\n {renderContent()}\n

\n \n View Source\n \n

\n );\n}\n\nfunction client() {\n createRoot(document.getElementById(\"root\")).render();\n}\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 = new URL(import.meta.url).pathname.split(\"/\").at(-1);\n const SCHEMA_VERSION = 3; // Updated schema version\n\n // Create necessary tables with updated schema\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_users (\n username TEXT PRIMARY KEY,\n password TEXT NOT NULL,\n balance REAL DEFAULT 0,\n role TEXT DEFAULT 'user'\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_transactions (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n username TEXT NOT NULL,\n type TEXT NOT NULL,\n amount REAL NOT NULL,\n timestamp DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_withdrawal_requests (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n username TEXT NOT NULL,\n amount REAL NOT NULL,\n status TEXT DEFAULT 'pending',\n timestamp DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Ensure admin user exists\n try {\n await sqlite.execute(\n `INSERT OR IGNORE INTO ${KEY}_users (username, password, role) VALUES (?, ?, ?)`, \n ['admin', 'admin123', 'admin']\n );\n } catch {}\n\n // Handle different routes\n if (request.method === 'POST') {\n const body = await request.json();\n\n // Registration\n if (request.url.includes('/register')) {\n try {\n await sqlite.execute(\n `INSERT INTO ${KEY}_users (username, password, balance) VALUES (?, ?, ?)`, \n [body.username, body.password, 1000]\n );\n await sqlite.execute(\n `INSERT INTO ${KEY}_transactions (username, type, amount) VALUES (?, ?, ?)`, \n [body.username, 'Initial Balance', 1000]\n );\n return new Response(JSON.stringify({ success: true }), { \n headers: { 'Content-Type': 'application/json' } \n });\n } catch (error) {\n return new Response(JSON.stringify({ \n success: false, \n message: 'Username already exists' \n }), { \n headers: { 'Content-Type': 'application/json' } \n });\n }\n }\n\n // Login\n if (request.url.includes('/login')) {\n const user = await sqlite.execute(\n `SELECT * FROM ${KEY}_users WHERE username = ? AND password = ?`, \n [body.username, body.password]\n );\n\n if (user.rows.length > 0) {\n const transactions = await sqlite.execute(\n `SELECT * FROM ${KEY}_transactions \n WHERE username = ? \n ORDER BY timestamp DESC \n LIMIT 5`, \n [body.username]\n );\n\n return new Response(JSON.stringify({ \n success: true, \n balance: user.rows[0].balance,\n role: user.rows[0].role,\n transactions: transactions.rows\n }), { \n headers: { 'Content-Type': 'application/json' } \n });\n } else {\n return new Response(JSON.stringify({ \n success: false, \n message: 'Invalid credentials' \n }), { \n headers: { 'Content-Type': 'application/json' } \n });\n }\n }\n\n // Submit Withdrawal Request\n if (request.url.includes('/submit-withdrawal')) {\n try {\n await sqlite.execute(\n `INSERT INTO ${KEY}_withdrawal_requests (username, amount) VALUES (?, ?)`, \n [body.username, body.amount]\n );\n return new Response(JSON.stringify({ \n success: true,\n message: 'Withdrawal request submitted' \n }), { \n headers: { 'Content-Type': 'application/json' } \n });\n } catch (error) {\n return new Response(JSON.stringify({ \n success: false, \n message: 'Withdrawal request failed' \n }), { \n headers: { 'Content-Type': 'application/json' } \n });\n }\n }\n\n // Process Withdrawal\n if (request.url.includes('/process-withdrawal')) {\n try {\n const request = await sqlite.execute(\n `SELECT * FROM ${KEY}_withdrawal_requests WHERE id = ?`, \n [body.requestId]\n );\n\n if (request.rows.length === 0) {\n return new Response(JSON.stringify({ \n success: false, \n message: 'Invalid withdrawal request' \n }), { \n headers: { 'Content-Type': 'application/json' } \n });\n }\n\n const withdrawalRequest = request.rows[0];\n\n if (body.action === 'approve') {\n // Deduct amount from user balance\n await sqlite.execute(\n `UPDATE ${KEY}_users SET balance = balance - ? WHERE username = ?`, \n [withdrawalRequest.amount, withdrawalRequest.username]\n );\n\n // Add transaction record\n await sqlite.execute(\n `INSERT INTO ${KEY}_transactions (username, type, amount) VALUES (?, ?, ?)`, \n [withdrawalRequest.username, 'Withdrawal', -withdrawalRequest.amount]\n );\n }\n\n // Update withdrawal request status\n await sqlite.execute(\n `UPDATE ${KEY}_withdrawal_requests SET status = ? WHERE id = ?`, \n [body.action, body.requestId]\n );\n\n return new Response(JSON.stringify({ \n success: true,\n message: `Withdrawal ${body.action}d successfully` \n }), { \n headers: { 'Content-Type': 'application/json' } \n });\n } catch (error) {\n return new Response(JSON.stringify({ \n success: false, \n message: 'Withdrawal processing failed' \n }), { \n headers: { 'Content-Type': 'application/json' } \n });\n }\n }\n\n // Get Withdrawal Requests (Admin Only)\n if (request.url.includes('/get-withdrawal-requests')) {\n const requests = await sqlite.execute(\n `SELECT * FROM ${KEY}_withdrawal_requests WHERE status = 'pending'`\n );\n\n return new Response(JSON.stringify({ \n success: true,\n requests: requests.rows\n }), { \n headers: { 'Content-Type': 'application/json' } \n });\n }\n }\n\n // Serve the main HTML\n return new Response(`\n \n \n Advanced Gaming Platform\n \n \n \n \n

\n \n \n \n \n `, {\n headers: { \"content-type\": \"text/html\" }\n });\n}","createdAt",["D",1737228303189],"version",5,"currentUserHasLiked","likeCount","forkCount","referenceCount","dependencyCount",1,"commentCount","prCount","mergedPr",{"_129":130,"_131":132},"handle","funjo","profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJyb0ZUYUZpOGJlbWRTRm5KUkVxVkM4TkxjWCJ9","forkedVal","interval",{"_95":96,"_136":37,"_100":101,"_137":138,"_139":140,"_141":142,"_143":144,"_145":146,"_147":148,"_93":149,"_149":150},"runtime","clearedAt",["D",1737228401657],"nextRunAt",["D",1737262800000],"unit","hour","delay",60000,"registeredAt",["D",1737228299984],"lastRunAt",["D",1737228303853],"cron","0 5 * * *","slug","funjo/lotterymahaGame","description","@jsxImportSource https://esm.sh/react@18.2.0","versions",[157,160,164,168,171,174],{"_117":118,"_158":-5,"_115":159,"_112":110},"prId",["D",1737228303189],{"_117":161,"_158":-5,"_115":162,"_112":163},4,["D",1737228120460],"7da81450-d5d1-11ef-beaf-e6cdfca9ef9f",{"_117":165,"_158":-5,"_115":166,"_112":167},3,["D",1737227965836],"217cb794-d5d1-11ef-8167-e6cdfca9ef9f",{"_117":90,"_158":-5,"_115":169,"_112":170},["D",1737227150424],"3b772bcc-d5cf-11ef-b92f-e6cdfca9ef9f",{"_117":124,"_158":-5,"_115":172,"_112":173},["D",1737226807654],"6f28dd18-d5ce-11ef-81cd-e6cdfca9ef9f",{"_117":31,"_158":-5,"_115":175,"_112":176},["D",1737226679581],"22da612a-d5ce-11ef-8277-e6cdfca9ef9f","recentThread","breadcrumbs","comments",[],"isOwner","routes/_app.v.$handle.$name.dependencies",{"_184":185,"_250":124,"_251":152,"_252":31,"_94":253},"dependenciesList",[186],{"_100":187,"_188":189},"08f95904-3584-11ef-8995-0e10024e3b32","initialData",{"_98":190,"_95":191,"_100":187,"_102":192,"_103":-5,"_104":105,"_106":193,"_107":194,"_109":195,"_111":26,"_112":195,"_113":196,"_115":197,"_117":198,"_119":26,"_120":199,"_122":200,"_123":124,"_125":124,"_121":201,"_126":31,"_127":-5,"_20":202,"_133":205,"_134":-7,"_153":210,"_211":-5,"_151":212,"_155":213},"sqlite","a0bf3b31-15a5-4d5c-880e-4b1e22c9bc18","76a8911e-393e-11ef-8e71-de64eea55b61","# LLM-Safe Fork of @std/sqlite\n\nWe found that LLMs have trouble with the inputs and outputs of our @std/sqlite method.\n\n1. It expects the input to be `(sql: string, args: any[])` but it's `{ sql: string, args: any[] }`\n2. It expects the output to be objects, but they are arrays\n\nInstead of struggling to teach it, we built this val to be a wrapper around @std/sqlite that adheres to what the LLMs expect. \n\nThis val is also backwards-compatible with @std/sqlite, so we're considering merging it in.","script","5631f2d0-dcb9-11ef-80ec-e6cdfca9ef9f","import { API_URL } from \"https://esm.town/v/std/API_URL\";\nimport { LibsqlError, type ResultSet, type Row, type TransactionMode } from \"npm:@libsql/client\";\nimport { z } from \"npm:zod\";\n\n/**\n * Every Val Town account comes with its own private\n * [SQLite database](https://www.sqlite.org/) that\n * is accessible from any of your vals.\n * ([Docs ↗](https://docs.val.town/std/sqlite))\n */\nexport const sqlite = {\n /**\n * Executes a SQLite statement.\n *\n * @param {InStatement} statement - The SQLite statement to execute.\n * @example String query:\n * `sqlite.execute(\"SELECT 1;\")`\n * @example Query with arguments:\n * `sqlite.execute({sql: \"SELECT * from books WHERE year > ?;\", args: [2020]})`\n */\n execute,\n\n /**\n * Executes a batch of SQLite statements.\n *\n * @param {InStatement[]} statements - An array of SQLite statements to execute.\n * @param {TransactionMode} [mode] - The transaction mode for the batch execution.\n */\n batch,\n};\n\n// ------------\n// Functions\n// ------------\n\nasync function execute(statement: InStatement, args?: InArgs): Promise {\n const res = await fetch(`${API_URL}/v1/sqlite/execute`, {\n method: \"POST\",\n headers: {\n Authorization: `Bearer ${Deno.env.get(\"valtown\")}`,\n },\n body: JSON.stringify({ statement: normalizeStatement(statement, args) }),\n });\n if (!res.ok) {\n throw createResError(await res.text());\n }\n const resultSet = await res.json();\n return upgradeResultSet(resultSet);\n}\n\nasync function batch(statements: InStatement[], mode?: TransactionMode): Promise {\n if (mode && ![\"write\", \"read\", \"deferred\"].includes(mode)) {\n throw new Error(\"Invalid transaction mode provided to sqlite.batch. Must be 'write', 'read', or 'deferred.\");\n }\n const res = await fetch(`${API_URL}/v1/sqlite/batch`, {\n method: \"POST\",\n headers: {\n Authorization: `Bearer ${Deno.env.get(\"valtown\")}`,\n },\n body: JSON.stringify({ statements: statements.map(s => normalizeStatement(s)), mode }),\n });\n if (!res.ok) {\n throw createResError(await res.text());\n }\n const resultSets = await res.json();\n return resultSets.map(upgradeResultSet);\n}\n\nfunction createResError(body: string) {\n try {\n const e = zLibsqlError.parse(JSON.parse(body));\n // e.message already contains the code, and LibsqlError adds the\n // code to the beginning, so we remove it here\n const msg = e.message.replace(e.code, \"\").replace(/^:\\s+/, \"\");\n return new LibsqlError(msg, e.code, e.rawCode);\n } catch (_) {\n // Failed to parse libsql error\n }\n return new Error(body);\n}\n\n/* Val Town's Turso Proxy returns rows as an array of values\n * Yet the LibSQL API has a Row type which behave as an array or object,\n * ie you can access it via numerical index or string\n */\ninterface ImpoverishedResultSet extends ResultSet {\n rows: any[];\n}\n\nfunction normalizeStatement(statement: InStatement, args?: InArgs) {\n if (Array.isArray(statement)) {\n // for the case of an array of arrays\n return normalizeStatement(statement[0], statement[1]);\n }\n if (typeof statement === \"string\") {\n if (args) {\n return { sql: statement, args };\n } else return statement;\n }\n else if (typeof statement === \"object\") {\n if (statement.args) {\n return statement;\n }\n if (args) {\n return { sql: statement.sql, args };\n }\n return statement.sql;\n }\n else throw new Error(\"Error normalizing sql input\");\n}\n\nfunction upgradeResultSet(results: ImpoverishedResultSet): ResultSet {\n return {\n ...results,\n rows: results.rows.map(row => rowFromSql(row, results.columns)),\n };\n}\n\n// adapted from\n// https://github.com/tursodatabase/libsql-client-ts/blob/17dd996b840c950dd22b871adfe4ba0eb4a5ead3/packages/libsql-client/src/sqlite3.ts#L314C1-L337C2\nfunction rowFromSql(\n sqlRow: Array,\n columns: Array,\n): Row {\n const row = {};\n // make sure that the \"length\" property is not enumerable\n Object.defineProperty(row, \"length\", { value: sqlRow.length });\n for (let i = 0; i < sqlRow.length; ++i) {\n const value = sqlRow[i];\n Object.defineProperty(row, i, { value });\n\n const column = columns[i];\n if (!Object.hasOwn(row, column)) {\n Object.defineProperty(row, column, {\n value,\n enumerable: true,\n configurable: true,\n writable: true,\n });\n }\n }\n return row as Row;\n}\n\n// ------------\n// Helpers\n// ------------\n\nconst zLibsqlError = z.object({\n message: z.string(),\n code: z.string(),\n rawCode: z.number().optional(),\n});\n\n// We patch these types to only support JSON values\nexport type InValue = null | string | number | boolean;\nexport type InArgs = Array | Record;\nexport type InStatement = {\n /**\n * The SQL statement to execute.\n */\n sql: string;\n\n /**\n * The arguments to bind to the SQL statement.\n */\n args: InArgs;\n} | string;",["D",1737987404484],13,10,13508,21,{"_129":203,"_131":204},"stevekrouse","https://images.clerk.dev/uploaded/img_2PqHa2Gsy93xQrjh2w78Xu0cChW.jpeg",{"_112":206,"_129":207,"_98":190,"_117":208,"_209":-5},"56c849ee-f1f8-11ee-9b87-cab58f78796a","std",6,"prDisabledHint","LLM-Safe Fork of @std/sqlite We found that LLMs have trouble with the inputs and outputs of our @std/sqlite method. It expects the input to be (sql: string, args: any[]) but it's { sql: string, args: any[] } It expects the output to be objects, but they are arrays Instead of struggling to teach it, we built this val to be a wrapper around @std/sqlite that adheres to what the LLMs expect. This val is also backwards-compatible with @std/sqlite, so we're considering merging it in.","latestEvaluation","stevekrouse/sqlite",[214,218,222,226,229,233,237,241,244,247],{"_115":215,"_117":198,"_216":217},["D",1737987404484],"n","1",{"_115":219,"_117":220,"_216":221},["D",1724087412304],12,"2",{"_115":223,"_117":224,"_216":225},["D",1724087404512],11,"3",{"_115":227,"_117":199,"_216":228},["D",1723494410142],"4",{"_115":230,"_117":231,"_216":232},["D",1723494389876],9,"5",{"_115":234,"_117":235,"_216":236},["D",1723494345363],8,"6",{"_115":238,"_117":239,"_216":240},["D",1723494323065],7,"7",{"_115":242,"_117":208,"_216":243},["D",1719604370206],"8",{"_115":245,"_117":118,"_216":246},["D",1719604260994],"9",{"_115":248,"_117":161,"_216":249},["D",1719604144103],"10","dependenciesCount","valname","page",{"_112":110,"_98":99,"_129":130,"_11":96,"_117":118,"_100":101,"_113":114,"_104":105,"_111":26,"_151":152},"routes/_app","actionData","errors"]