KPool Gaming Cafe

\n 🎱 KPool Gaming Zone\n

\n \n

\n\n

\n {selectedCategory === \"cafe\" && (\n

\n {cafeMenu.map((item, index) => (\n \n

{item.icon}

{item.name}

{item.price}

{item.description}

\n ))}\n \n )}\n\n {selectedCategory === \"tournament\" && currentUser && (\n

\n {randomChallenge\n ? (\n

\n {randomChallenge.icon} {randomChallenge.name}\n

\n {randomChallenge.description}\n

\n Difficulty: {randomChallenge.difficulty}\n Points: {challengePointsMap[randomChallenge.difficulty]}\n

\n\n {isChallengeStarted\n ? (\n

\n Time: {challengeTimer} seconds\n

\n )\n : (\n \n Start Challenge ▶️\n \n )}\n\n {isChallengeStarted && (\n \n Complete Challenge ✅\n \n )}\n

\n )\n : (\n

No More Challenges

You've completed all available challenges!

\n )}\n

\n\n

Global Challenge History

\n {globalChallengeHistory.map((challenge, index) => (\n

\n {challenge.player_name}\n {challenge.challenge_name}\n

\n Score: {challenge.score}\n Time: {challenge.time} sec\n {new Date(challenge.created_at).toLocaleDateString()}\n

\n ))}\n

\n )}\n \n \n );\n}\n\nconst styles = {\n container: {\n fontFamily: \"'Segoe UI', Tahoma, Geneva, Verdana, sans-serif\",\n backgroundColor: \"#0f0f1a\",\n color: \"#e0e0e0\",\n minHeight: \"100vh\",\n position: \"relative\",\n overflow: \"hidden\",\n },\n backgroundOverlay: {\n position: \"fixed\",\n top: 0,\n left: 0,\n width: \"100%\",\n height: \"100%\",\n background: \"linear-gradient(135deg, rgba(15,15,26,0.9) 0%, rgba(30,30,50,0.9) 100%)\",\n zIndex: 1,\n },\n header: {\n display: \"flex\",\n justifyContent: \"space-between\",\n alignItems: \"center\",\n padding: \"20px 5%\",\n backgroundColor: \"rgba(22, 22, 36, 0.7)\",\n backdropFilter: \"blur(10px)\",\n position: \"relative\",\n zIndex: 2,\n },\n logo: {\n fontSize: \"24px\",\n fontWeight: \"bold\",\n display: \"flex\",\n alignItems: \"center\",\n gap: \"10px\",\n color: \"#4CAF50\",\n },\n navigation: {\n display: \"flex\",\n gap: \"15px\",\n },\n navButton: {\n padding: \"10px 20px\",\n border: \"none\",\n borderRadius: \"20px\",\n color: \"white\",\n cursor: \"pointer\",\n transition: \"all 0.3s ease\",\n fontWeight: \"bold\",\n },\n main: {\n maxWidth: \"1200px\",\n margin: \"0 auto\",\n padding: \"20px\",\n position: \"relative\",\n zIndex: 2,\n },\n menuGrid: {\n display: \"grid\",\n gridTemplateColumns: \"repeat(auto-fill, minmax(250px, 1fr))\",\n gap: \"20px\",\n },\n menuItem: {\n display: \"flex\",\n alignItems: \"center\",\n gap: \"15px\",\n backgroundColor: \"rgba(44, 44, 60, 0.7)\",\n padding: \"15px\",\n borderRadius: \"10px\",\n backdropFilter: \"blur(5px)\",\n transition: \"transform 0.3s ease\",\n },\n menuItemIcon: {\n fontSize: \"3em\",\n marginRight: \"15px\",\n },\n menuItemTitle: {\n margin: 0,\n color: \"#4CAF50\",\n fontSize: \"1.2em\",\n },\n menuItemPrice: {\n margin: \"5px 0\",\n color: \"#e0e0e0\",\n fontWeight: \"bold\",\n },\n menuItemDescription: {\n margin: 0,\n color: \"#a0a0a0\",\n fontSize: \"0.9em\",\n },\n tournamentLayout: {\n display: \"grid\",\n gridTemplateColumns: \"1fr 1fr\",\n gap: \"20px\",\n },\n challengeSection: {\n display: \"flex\",\n flexDirection: \"column\",\n gap: \"20px\",\n },\n glassCard: {\n backgroundColor: \"rgba(44, 44, 60, 0.7)\",\n backdropFilter: \"blur(10px)\",\n borderRadius: \"15px\",\n padding: \"25px\",\n boxShadow: \"0 8px 32px 0 rgba(31, 38, 135, 0.37)\",\n },\n challengeTitle: {\n color: \"#4CAF50\",\n margin: 0,\n marginBottom: \"15px\",\n },\n challengeDescription: {\n color: \"#a0a0a0\",\n marginBottom: \"15px\",\n },\n challengeStats: {\n display: \"flex\",\n justifyContent: \"space-between\",\n marginBottom: \"15px\",\n color: \"#e0e0e0\",\n },\n primaryButton: {\n width: \"100%\",\n padding: \"12px\",\n backgroundColor: \"#4CAF50\",\n color: \"white\",\n border: \"none\",\n borderRadius: \"25px\",\n cursor: \"pointer\",\n transition: \"background-color 0.3s ease\",\n },\n secondaryButton: {\n width: \"100%\",\n padding: \"12px\",\n backgroundColor: \"#2196F3\",\n color: \"white\",\n border: \"none\",\n borderRadius: \"25px\",\n cursor: \"pointer\",\n transition: \"background-color 0.3s ease\",\n marginTop: \"10px\",\n },\n globalChallengeHistorySection: {\n backgroundColor: \"rgba(44, 44, 60, 0.7)\",\n backdropFilter: \"blur(10px)\",\n borderRadius: \"15px\",\n padding: \"25px\",\n boxShadow: \"0 8px 32px 0 rgba(31, 38, 135, 0.37)\",\n },\n scrollableTable: {\n maxHeight: \"500px\",\n overflowY: \"auto\",\n },\n historyItem: {\n backgroundColor: \"rgba(30, 30, 45, 0.7)\",\n borderRadius: \"10px\",\n padding: \"15px\",\n marginBottom: \"10px\",\n },\n historyItemHeader: {\n display: \"flex\",\n justifyContent: \"space-between\",\n marginBottom: \"10px\",\n color: \"#4CAF50\",\n },\n historyItemDetails: {\n display: \"flex\",\n justifyContent: \"space-between\",\n color: \"#a0a0a0\",\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 // Server-side code remains the same as in the previous implementation\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 = 11;\n\n // Create tables for users, challenges, and scores\n try {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_users_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL UNIQUE,\n password TEXT NOT NULL,\n total_points INTEGER DEFAULT 0,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_challenges_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_id INTEGER,\n player_name TEXT,\n challenge_name TEXT NOT NULL,\n score INTEGER NOT NULL,\n time INTEGER NOT NULL,\n status TEXT DEFAULT 'Pending',\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY(user_id) REFERENCES ${KEY}_users_${SCHEMA_VERSION}(id)\n )\n `);\n } catch (error) {\n console.error(\"Table creation error:\", error);\n }\n\n const url = new URL(request.url);\n\n // Existing routes remain the same as in the previous implementation\n // (global challenge history, submit score, etc.)\n\n return new Response(\n `\n \n \n KPool Gaming Cafe\n \n \n \n \n \n

\n \n \n \n \n `,\n {\n headers: { \"content-type\": \"text/html\" },\n },\n );\n}","createdAt",["D",1736772559643],"version",12,"currentUserHasLiked","likeCount","forkCount","referenceCount","dependencyCount",1,"commentCount","prCount","mergedPr",{"_129":130,"_131":132},"handle","Kpool","profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJyWHF2SlN3eEdKVHFRSEJNa25OMTZwVzU1MSJ9","forkedVal",{"_95":96,"_135":37,"_100":101,"_136":-5,"_137":138,"_139":140,"_141":142,"_143":144,"_145":146,"_93":147,"_147":148},"runtime","clearedAt","nextRunAt",["D",1740373200000],"unit","hour","delay",60000,"registeredAt",["D",1737015879577],"lastRunAt",["D",1740286822870],"cron","0 5 * * *","slug","Kpool/KPoolCafeGameMenu","description","@jsxImportSource https://esm.sh/react@18.2.0","versions",[155,158,162,166,170,174,178,182,186,190,194,197,200],{"_117":118,"_156":-5,"_115":157,"_112":110},"prId",["D",1736772559643],{"_117":159,"_156":-5,"_115":160,"_112":161},11,["D",1736772539199],"c210284a-d1ac-11ef-911a-e6cdfca9ef9f",{"_117":163,"_156":-5,"_115":164,"_112":165},10,["D",1736772390412],"6962c1e4-d1ac-11ef-a83f-e6cdfca9ef9f",{"_117":167,"_156":-5,"_115":168,"_112":169},9,["D",1736772339239],"4ae0688e-d1ac-11ef-9d68-e6cdfca9ef9f",{"_117":171,"_156":-5,"_115":172,"_112":173},8,["D",1736768340246],"fb4ba5c6-d1a2-11ef-8651-e6cdfca9ef9f",{"_117":175,"_156":-5,"_115":176,"_112":177},7,["D",1736768257189],"c9c8ee14-d1a2-11ef-bb39-e6cdfca9ef9f",{"_117":179,"_156":-5,"_115":180,"_112":181},6,["D",1736768190048],"a1c42802-d1a2-11ef-a353-e6cdfca9ef9f",{"_117":183,"_156":-5,"_115":184,"_112":185},5,["D",1736768019830],"3c4eea3e-d1a2-11ef-974e-e6cdfca9ef9f",{"_117":187,"_156":-5,"_115":188,"_112":189},4,["D",1736767926432],"04a49e4e-d1a2-11ef-ac0f-e6cdfca9ef9f",{"_117":191,"_156":-5,"_115":192,"_112":193},3,["D",1736767898636],"f412517a-d1a1-11ef-866b-e6cdfca9ef9f",{"_117":90,"_156":-5,"_115":195,"_112":196},["D",1736767803462],"bb56bda8-d1a1-11ef-a84f-e6cdfca9ef9f",{"_117":124,"_156":-5,"_115":198,"_112":199},["D",1736765436998],"38d1c918-d19c-11ef-83d7-e6cdfca9ef9f",{"_117":31,"_156":-5,"_115":201,"_112":202},["D",1736765348571],"041d2618-d19c-11ef-b259-e6cdfca9ef9f","recentThread","breadcrumbs","comments",[],"isOwner","routes/_app.v.$handle.$name.versions.$(version)",{"_93":210,"_211":212,"_94":213},"single","redirect","/v/Kpool/KPoolCafeGameMenu/versions",{"_112":185,"_113":214,"_117":183,"_115":215,"_216":99,"_100":101,"_107":108,"_129":130,"_11":96,"_217":-5,"_218":-5,"_219":-5,"_207":26,"_149":150},"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\n\nfunction App() {\n const [selectedCategory, setSelectedCategory] = useState('cafe');\n const [playerName, setPlayerName] = useState('');\n const [password, setPassword] = useState('');\n const [currentUser, setCurrentUser] = useState(null);\n const [registrationError, setRegistrationError] = useState('');\n const [randomChallenge, setRandomChallenge] = useState(null);\n const [scoreboard, setScoreboard] = useState([]);\n const [completedChallenges, setCompletedChallenges] = useState([]);\n\n const cafeMenu = [\n { \n name: 'Espresso', \n price: '$3.50', \n description: 'Rich, bold espresso shot', \n icon: '☕' \n },\n { \n name: 'Cappuccino', \n price: '$4.50', \n description: 'Creamy espresso with steamed milk', \n icon: '🥛' \n },\n { \n name: 'Latte', \n price: '$4.75', \n description: 'Smooth espresso with lots of milk', \n icon: '🧋' \n },\n { \n name: 'Americano', \n price: '$3.75', \n description: 'Espresso with hot water', \n icon: '🔥' \n },\n { \n name: 'Mocha', \n price: '$5.00', \n description: 'Chocolate and espresso delight', \n icon: '🍫' \n }\n ];\n\n const billiardChallenges = [\n { \n name: \"Speed Pocket Challenge\", \n description: \"Pocket 8 balls in the fastest time possible\",\n points: 50,\n difficulty: \"Intermediate\"\n },\n { \n name: \"Precision Shot Challenge\", \n description: \"Hit specific target balls in a sequence\",\n points: 75,\n difficulty: \"Advanced\"\n },\n { \n name: \"Bank Shot Master\", \n description: \"Complete a series of complex bank shots\",\n points: 100,\n difficulty: \"Expert\"\n },\n { \n name: \"Trick Shot Tournament\", \n description: \"Perform unique and challenging trick shots\",\n points: 125,\n difficulty: \"Pro\"\n }\n ];\n\n useEffect(() => {\n if (currentUser) {\n fetchScoreboard();\n fetchCompletedChallenges();\n generateRandomChallenge();\n }\n }, [currentUser]);\n\n const fetchScoreboard = async () => {\n try {\n const response = await fetch('/scoreboard');\n const data = await response.json();\n setScoreboard(data);\n } catch (error) {\n console.error('Failed to fetch scoreboard', error);\n setScoreboard([]);\n }\n };\n\n const fetchCompletedChallenges = async () => {\n if (!currentUser) return;\n\n try {\n const response = await fetch(`/completed-challenges?userId=${currentUser.id}`);\n const data = await response.json();\n setCompletedChallenges(data);\n } catch (error) {\n console.error('Failed to fetch completed challenges', error);\n }\n };\n\n const generateRandomChallenge = () => {\n // Filter out already completed challenges\n const availableChallenges = billiardChallenges.filter(\n challenge => !completedChallenges.some(\n completed => completed.challenge_name === challenge.name\n )\n );\n\n if (availableChallenges.length > 0) {\n const challenge = availableChallenges[\n Math.floor(Math.random() * availableChallenges.length)\n ];\n setRandomChallenge(challenge);\n } else {\n // If all challenges are completed, reset or show a message\n setRandomChallenge(null);\n }\n };\n\n const handleLogin = async () => {\n try {\n const response = await fetch('/login', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({ \n name: playerName, \n password: password \n })\n });\n\n const result = await response.json();\n if (result.success) {\n setCurrentUser(result.user);\n setRegistrationError('');\n } else {\n setRegistrationError(result.message || 'Login failed');\n }\n } catch (error) {\n console.error('Login error:', error);\n setRegistrationError('Network error. Please try again.');\n }\n };\n\n const handleRegister = async () => {\n try {\n const response = await fetch('/register', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({ \n name: playerName, \n password: password \n })\n });\n\n const result = await response.json();\n if (result.success) {\n setCurrentUser(result.user);\n setRegistrationError('');\n } else {\n setRegistrationError(result.message || 'Registration failed');\n }\n } catch (error) {\n console.error('Registration error:', error);\n setRegistrationError('Network error. Please try again.');\n }\n };\n\n const handleLogout = async () => {\n try {\n await fetch('/logout', { method: 'POST' });\n setCurrentUser(null);\n setRandomChallenge(null);\n setCompletedChallenges([]);\n setScoreboard([]);\n } catch (error) {\n console.error('Logout failed', error);\n }\n };\n\n const submitChallengeScore = async (score) => {\n if (!currentUser || !randomChallenge) return;\n\n try {\n const response = await fetch('/submit-score', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({ \n userId: currentUser.id, \n challengeName: randomChallenge.name,\n score: score,\n status: 'Completed' \n })\n });\n\n const result = await response.json();\n console.log('Score submission result:', result);\n\n // Refresh data\n fetchScoreboard();\n fetchCompletedChallenges();\n generateRandomChallenge();\n } catch (error) {\n console.error('Score submission failed', error);\n }\n };\n\n const skipChallenge = async () => {\n if (!currentUser || !randomChallenge) return;\n\n try {\n const response = await fetch('/submit-score', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({ \n userId: currentUser.id, \n challengeName: randomChallenge.name,\n score: 0,\n status: 'Skipped' \n })\n });\n\n const result = await response.json();\n console.log('Challenge skip result:', result);\n\n // Refresh data\n fetchCompletedChallenges();\n generateRandomChallenge();\n } catch (error) {\n console.error('Challenge skip failed', error);\n }\n };\n\n return (\n

\n \n

\n\n

\n {/* Cafe Menu Section */}\n {selectedCategory === 'cafe' && (\n

Cafe Menu

\n {cafeMenu.map((item, index) => (\n

\n {item.icon}\n

{item.name} - {item.price}

{item.description}

\n ))}\n

\n )}\n \n {/* Tournament Section */}\n {selectedCategory === 'tournament' && (\n

\n {!currentUser ? (\n

\n setPlayerName(e.target.value)}\n style={styles.authInput}\n />\n setPassword(e.target.value)}\n style={styles.authInput}\n />\n

\n \n \n

\n {registrationError && (\n

{registrationError}

\n )}\n

\n ) : (\n

Welcome, {currentUser.name}! 🏆

\n \n

\n\n {randomChallenge ? (\n

{randomChallenge.name}

{randomChallenge.description}

\n Difficulty: {randomChallenge.difficulty}\n Points: {randomChallenge.points}\n

\n \n \n

\n ) : (\n

No More Challenges

You've completed or skipped all available challenges!

\n )}\n\n {/* Scoreboard Section */}\n

Top Players Scoreboard

\n \n \n \n \n \n \n \n \n \n {scoreboard.map((player, index) => (\n \n \n \n \n \n ))}\n \n

Rank	Name	Total Points
{index + 1}	{player.name}	{player.total_points}

\n\n {/* Completed Challenges Section */}\n

Your Challenge History

\n \n \n \n \n \n \n \n \n \n \n {completedChallenges.map((challenge, index) => (\n \n \n \n \n \n \n ))}\n \n

Challenge	Status	Points	Date
{challenge.challenge_name}	{challenge.status}	{challenge.score}	{new Date(challenge.created_at).toLocaleDateString()}

\n )}\n

\n );\n}\n\nconst styles = {\n container: {\n fontFamily: 'Arial, sans-serif',\n backgroundColor: '#121212',\n color: 'white',\n minHeight: '100vh',\n padding: '20px'\n },\n header: {\n backgroundColor: '#1E1E1E',\n padding: '15px',\n borderRadius: '10px',\n marginBottom: '20px'\n },\n navigation: {\n display: 'flex',\n justifyContent: 'center',\n gap: '20px'\n },\n navButton: {\n padding: '10px 20px',\n border: 'none',\n borderRadius: '5px',\n color: 'white',\n cursor: 'pointer',\n transition: 'background-color 0.3s'\n },\n main: {\n maxWidth: '800px',\n margin: '0 auto'\n },\n menuSection: {\n backgroundColor: '#1E1E1E',\n borderRadius: '10px',\n padding: '20px'\n },\n menuGrid: {\n display: 'grid',\n gridTemplateColumns: 'repeat(auto-fill, minmax(200px, 1fr))',\n gap: '15px'\n },\n menuItem: {\n display: 'flex',\n alignItems: 'center',\n gap: '10px',\n backgroundColor: '#2C2C2C',\n padding: '10px',\n borderRadius: '8px'\n },\n menuIcon: {\n fontSize: '2em'\n },\n tournamentSection: {\n backgroundColor: '#1E1E1E',\n borderRadius: '10px',\n padding: '20px'\n },\n authContainer: {\n display: 'flex',\n flexDirection: 'column',\n alignItems: 'center',\n gap: '15px',\n backgroundColor: '#2C2C2C',\n padding: '30px',\n borderRadius: '12px'\n },\n authInput: {\n width: '300px',\n padding: '12px',\n backgroundColor: '#333',\n border: '1px solid #4CAF50',\n borderRadius: '20px',\n color: 'white'\n },\n authButtonContainer: {\n display: 'flex',\n gap: '15px'\n },\n authButton: {\n backgroundColor: '#4CAF50',\n color: 'white',\n border: 'none',\n padding: '12px 25px',\n borderRadius: '20px',\n cursor: 'pointer'\n },\n errorMessage: {\n color: 'red',\n marginTop: '10px'\n },\n challengeContainer: {\n textAlign: 'center'\n },\n userProfile: {\n display: 'flex',\n justifyContent: 'center',\n alignItems: 'center',\n gap: '20px',\n marginBottom: '20px'\n },\n logoutButton: {\n backgroundColor: '#FF5252',\n color: 'white',\n border: 'none',\n padding: '10px 20px',\n borderRadius: '20px',\n cursor: 'pointer'\n },\n challengeCard: {\n backgroundColor: '#2C2C2C',\n padding: '20px',\n borderRadius: '12px',\n margin: '0 auto',\n maxWidth: '500px',\n marginBottom: '20px'\n },\n challengeDetails: {\n display: 'flex',\n justifyContent: 'space-between',\n marginTop: '15px',\n color: '#BBB'\n },\n startChallengeButton: {\n backgroundColor: '#4CAF50',\n color: 'white',\n border: 'none',\n padding: '12px 25px',\n borderRadius: '20px',\n marginTop: '15px',\n cursor: 'pointer'\n },\n completedChallengesContainer: {\n backgroundColor: '#2C2C2C',\n borderRadius: '12px',\n padding: '20px',\n marginTop: '20px'\n },\n completedChallengesTable: {\n width: '100%',\n borderCollapse: 'collapse',\n color: 'white'\n },\n scoreboardContainer: {\n backgroundColor: '#2C2C2C',\n borderRadius: '12px',\n padding: '20px',\n marginTop: '20px'\n },\n scoreboard: {\n width: '100%',\n borderCollapse: 'collapse'\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 = new URL(import.meta.url).pathname.split(\"/\").at(-1);\n const SCHEMA_VERSION = 9;\n\n // Create tables for users, challenges, and scores\n try {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_users_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL UNIQUE,\n password TEXT NOT NULL,\n total_points INTEGER DEFAULT 0,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_challenges_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_id INTEGER,\n challenge_name TEXT NOT NULL,\n score INTEGER NOT NULL,\n status TEXT DEFAULT 'Pending',\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY(user_id) REFERENCES ${KEY}_users_${SCHEMA_VERSION}(id)\n )\n `);\n } catch (error) {\n console.error('Table creation error:', error);\n }\n\n const url = new URL(request.url);\n\n // Login route\n if (request.method === 'POST' && url.pathname === '/login') {\n try {\n const { name, password } = await request.json();\n const result = await sqlite.execute(\n `SELECT * FROM ${KEY}_users_${SCHEMA_VERSION} WHERE name = ? AND password = ?`, \n [name, password]\n );\n\n if (result.rows.length > 0) {\n return new Response(JSON.stringify({ \n success: true, \n user: result.rows[0] \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 } catch (error) {\n console.error('Login error:', error);\n return new Response(JSON.stringify({ \n success: false, \n message: 'Login failed' \n }), { \n headers: { 'Content-Type': 'application/json' } \n });\n }\n }\n\n // Registration route\n if (request.method === 'POST' && url.pathname === '/register') {\n try {\n const { name, password } = await request.json();\n \n await sqlite.execute(\n `INSERT INTO ${KEY}_users_${SCHEMA_VERSION} (name, password) VALUES (?, ?)`, \n [name, password]\n );\n\n const newUser = await sqlite.execute(\n `SELECT * FROM ${KEY}_users_${SCHEMA_VERSION} WHERE name = ?`, \n [name]\n );\n\n return new Response(JSON.stringify({ \n success: true, \n user: newUser.rows[0] \n }), { \n headers: { 'Content-Type': 'application/json' } \n });\n } catch (error) {\n console.error('Registration error:', error);\n return new Response(JSON.stringify({ \n success: false, \n message: 'Registration failed. Username might already exist.' \n }), { \n headers: { 'Content-Type': 'application/json' } \n });\n }\n }\n\n // Completed challenges route\n if (request.method === 'GET' && url.pathname === '/completed-challenges') {\n try {\n const userId = url.searchParams.get('userId');\n const challenges = await sqlite.execute(\n `SELECT challenge_name, score, status, created_at \n FROM ${KEY}_challenges_${SCHEMA_VERSION} \n WHERE user_id = ? \n ORDER BY created_at DESC \n LIMIT 10`, \n [userId]\n );\n\n return new Response(JSON.stringify(challenges.rows), { \n headers: { 'Content-Type': 'application/json' } \n });\n } catch (error) {\n console.error('Completed challenges fetch error:', error);\n return new Response(JSON.stringify([]), { \n headers: { 'Content-Type': 'application/json' } \n });\n }\n }\n\n // Submit score route\n if (request.method === 'POST' && url.pathname === '/submit-score') {\n try {\n const { userId, challengeName, score, status } = await request.json();\n \n // Insert challenge score with status\n await sqlite.execute(\n `INSERT INTO ${KEY}_challenges_${SCHEMA_VERSION} \n (user_id, challenge_name, score, status) VALUES (?, ?, ?, ?)`, \n [userId, challengeName, score, status]\n );\n\n // Only update points for completed challenges\n if (status === 'Completed') {\n await sqlite.execute(\n `UPDATE ${KEY}_users_${SCHEMA_VERSION} \n SET total_points = total_points + ? \n WHERE id = ?`, \n [score, userId]\n );\n }\n\n return new Response(JSON.stringify({ success: true }), { \n headers: { 'Content-Type': 'application/json' } \n });\n } catch (error) {\n console.error('Score submission error:', error);\n return new Response(JSON.stringify({ \n success: false, \n message: 'Score submission failed' \n }), { \n headers: { 'Content-Type': 'application/json' } \n });\n }\n }\n\n // Scoreboard route\n if (request.method === 'GET' && url.pathname === '/scoreboard') {\n try {\n const scoreboard = await sqlite.execute(\n `SELECT id, name, total_points \n FROM ${KEY}_users_${SCHEMA_VERSION} \n ORDER BY total_points DESC \n LIMIT 10`\n );\n\n return new Response(JSON.stringify(scoreboard.rows), { \n headers: { 'Content-Type': 'application/json' } \n });\n } catch (error) {\n console.error('Scoreboard fetch error:', error);\n return new Response(JSON.stringify([]), { \n headers: { 'Content-Type': 'application/json' } \n });\n }\n }\n\n // Logout route\n if (request.method === 'POST' && url.pathname === '/logout') {\n return new Response(JSON.stringify({ success: true }), { \n headers: { 'Content-Type': 'application/json' } \n });\n }\n\n // Main HTML response\n return new Response(`\n \n \n KPool Gaming Cafe\n \n \n \n \n

\n \n \n \n \n `, {\n headers: { \"content-type\": \"text/html\" }\n });\n}",["D",1736768019830],"valName","deletedAt","messageId","threadId","routes/_app","actionData","errors"]

KPoolCafeGameMenu

Version 5