🔒 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}",["D",1737228303189],"version",5,"currentUserHasLiked","referenceCount","dependencyCount","commentCount","prCount","mergedPr",{"_96":97,"_101":102},"forkedVal","interval","description","@jsxImportSource https://esm.sh/react@18.2.0","latestEvaluation","slug","funjo/lotterymahaGame","versions",[157,161,165,169,172,175],{"_98":158,"_139":140,"_159":160},["D",1737228303189],"n","1",{"_98":162,"_139":163,"_159":164},["D",1737228120460],4,"2",{"_98":166,"_139":167,"_159":168},["D",1737227965836],3,"3",{"_98":170,"_139":90,"_159":171},["D",1737227150424],"4",{"_98":173,"_139":107,"_159":174},["D",1737226807654],"5",{"_98":176,"_139":31,"_159":177},["D",1737226679581],"6","hasNext","filters",{"_181":182,"_183":184,"_128":129},"sort","newest","type","all","routes/_app","actionData","errors"]