[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_209":210,"_211":212},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_156":-5,"_20":157,"_22":158,"_159":160,"_161":162,"_26":163,"_24":164,"_165":-5,"_166":-5,"_167":56,"_168":169,"_170":47,"_171":-5,"_172":-5,"_173":174},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":25,"_26":27,"_28":-5,"_29":-5,"_30":-5,"_31":-5,"_32":-5},"handle","potluck","name","wavelink-stats","branchName","main","version","path","backend","project",{"_35":100,"_13":14,"_48":101,"_102":-5,"_103":56,"_104":105,"_106":105,"_107":108,"_109":-5,"_110":111,"_112":39,"_113":47,"_114":-5,"_115":-5,"_116":50,"_117":118,"_119":-5,"_120":-5,"_121":-5,"_122":-5,"_123":124,"_125":124,"_126":127,"_128":127,"_129":127,"_130":124,"_131":124,"_132":133,"_134":135,"_136":137,"_138":56},"tree",[71,72],"file",{"_35":67,"_13":19,"_38":41,"_40":-5,"_42":43,"_44":62,"_46":47,"_48":68,"_17":50,"_51":69,"_53":-5,"_55":56,"_57":-5,"_18":70},"contents",[33,34],"upstream","pull","ahead","behind","envVars",{"_35":59,"_13":60,"_38":61,"_40":41,"_42":43,"_44":62,"_46":47,"_48":63,"_17":50,"_51":64,"_53":65,"_55":56,"_57":-5,"_18":66},{"_35":36,"_13":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_17":50,"_51":52,"_53":54,"_55":56,"_57":-5,"_18":58},"id","9d5d7806-5eb7-11f1-8583-1607ee4eb77e","index.tsx","fileId","9d5d78a6-5eb7-11f1-8583-1607ee4eb77e","parentId","5a619fc4-787b-4d43-bf5f-520e1d02f906","branchId","397a77ee-5eb7-11f1-86fe-1607ee4eb77e","branchVersion",6,"latest",true,"createdAt",["D",1780427813712],0,"fileType","http","content","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { Hono } from \"npm:hono\";\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { renderToString } from \"https://esm.sh/react-dom@18.2.0/server\";\nimport { parseVal } from \"https://esm.town/v/std/utils/index.ts\";\nimport { getLeaderboard } from \"./db.ts\";\nimport { Leaderboard } from \"../frontend/Leaderboard.tsx\";\n\nconst app = new Hono();\napp.onError((err) => Promise.reject(err));\n\n// Let users see and remix the source.\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\n// JSON API for the leaderboard data.\napp.get(\"/api/leaderboard\", async (c) => c.json(await getLeaderboard()));\n\n// Server-rendered leaderboard page.\napp.get(\"/\", async (c) => {\n const rows = await getLeaderboard();\n const html = renderToString();\n return c.html(\n `\n\n \n \n \n Wavelink Leaderboard\n \n \n \n \n

${html}

\n \n`,\n );\n});\n\nexport default app.fetch;\n","deleted",false,"label",[19,37],"8f703c4c-5eb7-11f1-8167-1607ee4eb77e","db.ts","8f703d28-5eb7-11f1-8167-1607ee4eb77e",4,["D",1780427790340],"script","import postgres from \"npm:postgres\";\n\nexport interface LeaderboardRow {\n game_id: number;\n player1: string;\n player2: string;\n completed_turns: number;\n avg_speed_score: number | null;\n}\n\n// A single shared connection. `prepare: false` is required for Neon's\n// pooled (pgbouncer) endpoint.\nconst sql = postgres(Deno.env.get(\"WAVELINK_DB_URL\")!, { prepare: false });\n\n/**\n * Top 10 games ranked by number of completed turns, then by average\n * speed_score. A turn counts as \"completed\" when completed_at is set, and the\n * average speed_score is taken over those completed turns only.\n */\nexport async function getLeaderboard(): Promise {\n return await sql`\n select\n g.id as game_id,\n u1.name as player1,\n u2.name as player2,\n count(t.id) filter (where t.completed_at is not null)::int\n as completed_turns,\n round(\n avg(t.speed_score) filter (where t.completed_at is not null), 1\n )::float as avg_speed_score\n from games g\n join users u1 on u1.id = g.user_id1\n join users u2 on u2.id = g.user_id2\n left join turns t on t.game_id = g.id\n group by g.id, u1.name, u2.name\n order by completed_turns desc, avg_speed_score desc nulls last\n limit 10\n `;\n}\n",[19,60],"8f707072-5eb7-11f1-8167-1607ee4eb77e",["D",1780427790340],"directory",[19],{"_35":67,"_13":19,"_38":41,"_40":-5,"_42":43,"_44":62,"_46":47,"_48":89,"_17":50,"_51":69,"_53":-5,"_55":56,"_57":-5,"_78":90,"_18":91},{"_35":73,"_13":74,"_38":75,"_40":-5,"_42":43,"_44":76,"_46":47,"_48":77,"_17":50,"_51":69,"_53":-5,"_55":56,"_57":-5,"_78":79,"_18":80},"982ed38e-5eb7-11f1-8d92-1607ee4eb77e","frontend","81f26c2f-dd3b-4b1a-a78e-165a5ce919bf",5,["D",1780427805019],"children",[81],[74],{"_35":82,"_13":83,"_38":84,"_40":75,"_42":43,"_44":76,"_46":47,"_48":85,"_17":50,"_51":64,"_53":86,"_55":56,"_57":-5,"_78":87,"_18":88},"982e9982-5eb7-11f1-8d92-1607ee4eb77e","Leaderboard.tsx","982e9a5e-5eb7-11f1-8d92-1607ee4eb77e",["D",1780427805019],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport type { LeaderboardRow } from \"../backend/db.ts\";\n\nconst medal = (rank: number) =>\n rank === 1 ? \"🥇\" : rank === 2 ? \"🥈\" : rank === 3 ? \"🥉\" : `${rank}`;\n\nfunction Row({ row, rank }: { row: LeaderboardRow; rank: number }) {\n return (\n \n \n {medal(rank)}\n \n \n

\n {row.player1} & {row.player2}\n

Game #{row.game_id}

\n \n \n {row.completed_turns}\n \n \n \n {row.avg_speed_score ?? \"—\"}\n \n \n \n );\n}\n\nexport function Leaderboard({ rows }: { rows: LeaderboardRow[] }) {\n return (\n

\n 🌊 Wavelink Leaderboard\n

\n Top 10 games by completed turns, tie-broken by average speed score\n

\n\n

\n \n \n \n \n \n \n \n \n \n \n {rows.length === 0 ? (\n \n \n \n ) : (\n rows.map((row, i) => (\n \n ))\n )}\n \n

Rank	Players	\n Completed turns\n	\n Avg speed\n
\n No games found yet.\n

\n\n \n

\n );\n}\n",[],[74,83],["D",1780427790340],[92,93],[19],{"_35":59,"_13":60,"_38":61,"_40":41,"_42":43,"_44":62,"_46":47,"_48":97,"_17":50,"_51":64,"_53":65,"_55":56,"_57":-5,"_78":98,"_18":99},{"_35":36,"_13":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":94,"_17":50,"_51":52,"_53":54,"_55":56,"_57":-5,"_78":95,"_18":96},["D",1780427813712],[],[19,37],["D",1780427790340],[],[19,60],"3979cd94-5eb7-11f1-86fe-1607ee4eb77e",["D",1780427646150],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Wavelink word game leaderboard / stats dashboard","imageUrl","userId","4672fa32-1c6f-4907-899e-57b7e45b1dcb","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","019e83d1-d41f-725b-9693-b632d430a029","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_155":151},"org",{"_11":12,"_148":149,"_150":151,"_110":111,"_152":153,"_154":56},"branch",{"_17":139,"_13":16,"_35":43,"_140":100,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":-5,"_146":14,"_147":12},"isOwned",7,"projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Potluck Mittal","avatar","https://lh3.googleusercontent.com/a/ACg8ocJYeiSQ8_eyVYtUAg9f5qRwEXzS1AreFm572a1csvZx7c6b_S8=s96-c","tier","pro","canRestrictVals","profileImageUrl","adoptOrgId",{"_35":100,"_13":14,"_48":205,"_102":-5,"_103":56,"_104":105,"_106":105,"_107":108,"_109":-5,"_110":111,"_112":39,"_113":47,"_114":-5,"_115":-5,"_116":50,"_117":118,"_119":-5,"_120":-5,"_121":-5,"_122":-5,"_123":124,"_125":124,"_126":127,"_128":127,"_129":127,"_130":124,"_131":124,"_132":206,"_134":207,"_136":208,"_138":56},[190,193],"files",[190,191,192,193,194],"counts",{"_180":50,"_181":182,"_183":50,"_32":184,"_185":186},[176,177],{"_35":67,"_13":19,"_38":41,"_40":-5,"_42":43,"_44":62,"_46":47,"_48":68,"_17":50,"_51":69,"_53":-5,"_55":56,"_57":-5,"_18":175},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[19],{"_35":59,"_13":60,"_38":61,"_40":41,"_42":43,"_44":62,"_46":47,"_48":63,"_17":50,"_51":64,"_53":65,"_55":56,"_57":-5,"_18":179},{"_35":36,"_13":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_17":50,"_51":52,"_53":54,"_55":56,"_57":-5,"_18":178},[19,37],[19,60],"pulls","branches",1,"forks",{"_187":182,"_189":50},"connections",{"_187":182,"_188":50},"count","unfilledCount","emptyCount",{"_35":67,"_13":19,"_38":41,"_40":-5,"_42":43,"_44":62,"_46":47,"_48":89,"_17":50,"_51":69,"_53":-5,"_55":56,"_57":-5,"_78":203,"_18":204},{"_35":59,"_13":60,"_38":61,"_40":41,"_42":43,"_44":62,"_46":47,"_48":97,"_17":50,"_51":64,"_53":65,"_55":56,"_57":-5,"_78":201,"_18":202},{"_35":36,"_13":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":94,"_17":50,"_51":52,"_53":54,"_55":56,"_57":-5,"_78":199,"_18":200},{"_35":73,"_13":74,"_38":75,"_40":-5,"_42":43,"_44":76,"_46":47,"_48":77,"_17":50,"_51":69,"_53":-5,"_55":56,"_57":-5,"_78":197,"_18":198},{"_35":82,"_13":83,"_38":84,"_40":75,"_42":43,"_44":76,"_46":47,"_48":85,"_17":50,"_51":64,"_53":86,"_55":56,"_57":-5,"_78":195,"_18":196},[],[74,83],[194],[74],[],[19,37],[],[19,60],[191,192],[19],["D",1780427646150],{"_11":12,"_155":151},{"_11":12,"_148":149,"_150":151,"_110":111,"_152":153,"_154":56},{"_17":139,"_13":16,"_35":43,"_140":100,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":-5,"_146":14,"_147":12},"ctx",{"_132":-5,"_172":242,"_243":244,"_245":246,"_247":56,"_248":56,"_249":56,"_250":47,"_251":-5,"_252":-7,"_253":-7,"_254":50,"_255":56,"_256":56,"_257":-5,"_258":56,"_259":56,"_260":56,"_261":-5},"ENV",{"_213":214,"_215":216,"_217":16,"_218":219,"_220":221,"_222":223,"_224":225,"_226":227,"_228":229,"_230":231,"_232":233,"_234":235,"_236":237,"_238":239,"_240":241},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","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"]