[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_150":151,"_152":153},"routes/_app.x.$handle.$name",{"_93":92,"_31":43,"_101":83,"_26":102,"_13":14,"_103":-5,"_11":104,"_105":106,"_107":108,"_109":110,"_111":112,"_20":-5,"_113":-5,"_114":-5,"_115":24,"_116":117,"_118":47,"_119":-5,"_120":-5,"_121":122},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_41":42,"_31":43,"_36":44,"_45":-5,"_46":47,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":30,"_55":47,"_56":-5,"_57":-5,"_58":59,"_60":61,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":67,"_68":67,"_69":70,"_71":70,"_72":70,"_73":67,"_74":67,"_75":76,"_77":78,"_79":80,"_81":24},"version",1,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":27,"_32":33,"_34":35,"_36":37,"_38":14,"_39":40,"_23":24},"previous","deleted",false,"deletedHere","path","main.tsx","latestPath","fileId","4f3e72e8-26c7-11f0-9396-569c3dd06744","name","fileType","http","content","/** @jsxImportSource https://esm.sh/react */\nimport React, { useState, useEffect } from \"https://esm.sh/react\";\nimport { createRoot } from \"https://esm.sh/react-dom/client\";\n\n// Game Award Categories and Nominations\nconst AWARD_CATEGORIES = [\n {\n category: \"Game of the Year\",\n options: [\n \"Baldur's Gate 3\",\n \"Alan Wake 2\",\n \"Spider-Man 2\",\n \"Starfield\",\n \"Super Mario Bros. Wonder\"\n ]\n },\n {\n category: \"Best Narrative\",\n options: [\n \"Alan Wake 2\",\n \"Baldur's Gate 3\",\n \"Cyberpunk 2077: Phantom Liberty\",\n \"Final Fantasy XVI\",\n \"Marvel's Spider-Man 2\"\n ]\n },\n {\n category: \"Best Art Direction\",\n options: [\n \"Alan Wake 2\",\n \"Baldur's Gate 3\",\n \"Final Fantasy XVI\",\n \"Hi-Fi Rush\",\n \"Super Mario Bros. Wonder\"\n ]\n }\n];\n\nfunction App() {\n const [predictions, setPredictions] = useState({});\n const [username, setUsername] = useState(\"\");\n const [submittedUsers, setSubmittedUsers] = useState([]);\n\n useEffect(() => {\n fetchSubmittedUsers();\n }, []);\n\n const fetchSubmittedUsers = async () => {\n try {\n const response = await fetch('/users');\n const users = await response.json();\n setSubmittedUsers(users);\n } catch (error) {\n console.error(\"Failed to fetch users\", error);\n }\n };\n\n const handlePredictionChange = (category, value) => {\n setPredictions(prev => ({\n ...prev,\n [category]: value\n }));\n };\n\n const handleSubmit = async (e) => {\n e.preventDefault();\n \n if (!username.trim()) {\n alert(\"Please enter a username\");\n return;\n }\n\n const completePredictions = AWARD_CATEGORIES.every(cat => \n predictions[cat.category]\n );\n\n if (!completePredictions) {\n alert(\"Please make a prediction for all categories\");\n return;\n }\n\n try {\n const response = await fetch('/submit', {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json'\n },\n body: JSON.stringify({\n username,\n predictions\n })\n });\n\n if (response.ok) {\n fetchSubmittedUsers();\n alert(\"Predictions submitted successfully!\");\n }\n } catch (error) {\n console.error(\"Submission failed\", error);\n }\n };\n\n return (\n

🎮 Game Awards Prediction Challenge 🏆

\n \n

Users Who've Already Predicted:

\n {submittedUsers.length > 0 ? (\n

{user}

\n ) : (\n

No predictions yet!

\n )}\n

\n\n

\n ℹ️ Check back on December 13th to view the leaderboard!\n

\n\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 = \"GameAwards2024PredictionGame\";\n const SCHEMA_VERSION = 1;\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_predictions_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n username TEXT NOT NULL,\n predictions TEXT NOT NULL,\n timestamp DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n if (request.method === 'POST' && new URL(request.url).pathname === '/submit') {\n const { username, predictions } = await request.json();\n \n await sqlite.execute(`\n INSERT INTO ${KEY}_predictions_${SCHEMA_VERSION} \n (username, predictions) VALUES (?, ?)\n `, [username, JSON.stringify(predictions)]);\n\n return new Response(JSON.stringify({ success: true }), {\n headers: { 'Content-Type': 'application/json' }\n });\n }\n\n if (request.method === 'GET' && new URL(request.url).pathname === '/users') {\n const result = await sqlite.execute(`\n SELECT DISTINCT username FROM ${KEY}_predictions_${SCHEMA_VERSION}\n ORDER BY id DESC LIMIT 10\n `);\n \n return new Response(JSON.stringify(result.rows.map(row => row.username)), {\n headers: { 'Content-Type': 'application/json' }\n });\n }\n\n return new Response(`\n \n \n Game Awards Prediction Challenge\n \n \n \n

\n \n \n \n \n `, {\n headers: { 'Content-Type': 'text/html' }\n });\n}\n\nconst css = `\nbody {\n font-family: 'Arial', sans-serif;\n background-color: #f4f4f4;\n display: flex;\n justify-content: center;\n line-height: 1.6;\n color: #333;\n}\n\n.game-prediction-container {\n background-color: white;\n border-radius: 8px;\n box-shadow: 0 4px 6px rgba(0,0,0,0.1);\n padding: 30px;\n width: 100%;\n max-width: 600px;\n margin: 20px;\n}\n\nh1 {\n text-align: center;\n color: #444;\n margin-bottom: 20px;\n}\n\n.submitted-users {\n background-color: #f9f9f9;\n border-radius: 4px;\n padding: 15px;\n margin-bottom: 20px;\n}\n\n.prediction-note {\n text-align: center;\n background-color: #e7f3fe;\n border-radius: 4px;\n padding: 10px;\n margin-bottom: 20px;\n font-style: italic;\n}\n\n.prediction-category {\n margin-bottom: 15px;\n}\n\nlabel {\n display: block;\n margin-bottom: 5px;\n font-weight: bold;\n}\n\nselect, input {\n width: 100%;\n padding: 10px;\n border: 1px solid #ddd;\n border-radius: 4px;\n}\n\nbutton {\n width: 100%;\n padding: 12px;\n background-color: #4CAF50;\n color: white;\n border: none;\n border-radius: 4px;\n cursor: pointer;\n margin-top: 20px;\n}\n\nbutton:hover {\n background-color: #45a049;\n}\n`;","createdAt",["D",1732037386604],"branchVersion","branchId","4f3b7cd2-26c7-11f0-9396-569c3dd06744","id","4f3b2e12-26c7-11f0-9396-569c3dd06744","GameAwards2024PredictionGame",["D",1746129791809],"deletedAt","legacyEnvVars",true,"privacy","public","httpPrivacy","description","imageUrl","04e56ba7-c54a-427f-8070-67219b83ca20","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","2e901eee-3aff-4826-99a0-ea4001a41cef","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_93":92,"_100":96},"org",{"_93":92,"_94":-5,"_95":96,"_18":53,"_97":98,"_99":24},"branch",{"_13":82,"_31":83,"_41":40,"_84":42,"_85":-5,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":43,"_91":92},"isOwned",44,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","bmitchinson","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18ybGNycExZSzZneWRkMGZuTGRiSDlsZjNSU3MifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_41":42,"_31":43,"_36":146,"_45":-5,"_46":47,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":30,"_55":47,"_56":-5,"_57":-5,"_58":59,"_60":61,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":67,"_68":67,"_69":70,"_71":70,"_72":70,"_73":67,"_74":67,"_75":147,"_77":148,"_79":149,"_81":24},"tree",[141],"files",[141],"counts",{"_131":59,"_132":14,"_133":59,"_134":135,"_136":137},"contents",[124],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{"_30":123},"gameawards.mitchinson.dev",{"_41":125,"_31":27,"_29":30,"_126":-5,"_39":40,"_38":14,"_127":24,"_36":128,"_13":59,"_32":33,"_34":35,"_23":24,"_129":-5,"_26":130},"4f3e7220-26c7-11f0-9396-569c3dd06744","parentId","latest",["D",1732037386604],"label",[27],"pulls","branches","forks","envVars",{"_138":59,"_140":59},"connections",{"_138":59,"_139":59},"count","unfilledCount","emptyCount",{"_41":125,"_31":27,"_29":30,"_126":-5,"_39":40,"_38":14,"_127":24,"_36":142,"_13":59,"_32":33,"_34":35,"_23":24,"_129":-5,"_143":144,"_26":145},["D",1732037386604],"children",[],[27],["D",1746129791809],{"_93":92,"_100":96},{"_93":92,"_94":-5,"_95":96,"_18":53,"_97":98,"_99":24},{"_13":82,"_31":83,"_41":40,"_84":42,"_85":-5,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":43,"_91":92},"ctx",{"_75":-5,"_120":183,"_184":185,"_186":187,"_188":24,"_189":24,"_190":24,"_191":47,"_192":-5,"_193":-7,"_194":-7,"_195":59,"_196":24,"_197":24,"_198":-5,"_199":24,"_200":24,"_201":24,"_202":-5},"ENV",{"_154":155,"_156":157,"_158":83,"_159":160,"_161":162,"_163":164,"_165":166,"_167":168,"_169":170,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","71c1b20804b3232a7e513be260cfffc1932a9e97","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v1