${html}

\n \n`,\n );\n});\n\nexport default app.fetch;\n",[18,81],"8f703c4c-5eb7-11f1-8167-1607ee4eb77e",["D",1780427790340],"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",[18,65],"pulls","branches",1,"forks","envVars",{"_181":175,"_183":26},"connections",{"_181":175,"_182":26},"count","unfilledCount","emptyCount",{"_34":156,"_13":18,"_63":83,"_44":-5,"_36":37,"_159":41,"_165":24,"_38":210,"_40":26,"_66":84,"_157":-5,"_68":30,"_160":-5,"_196":211,"_17":212},{"_34":169,"_13":65,"_63":64,"_44":83,"_36":37,"_159":41,"_165":24,"_38":207,"_40":26,"_66":67,"_157":171,"_68":30,"_160":-5,"_196":208,"_17":209},{"_34":164,"_13":81,"_63":80,"_44":83,"_36":37,"_159":74,"_165":24,"_38":204,"_40":26,"_66":82,"_157":167,"_68":30,"_160":-5,"_196":205,"_17":206},{"_34":200,"_13":199,"_63":192,"_44":-5,"_36":37,"_159":193,"_165":24,"_38":201,"_40":26,"_66":84,"_157":-5,"_68":30,"_160":-5,"_196":202,"_17":203},{"_34":189,"_13":190,"_63":191,"_44":192,"_36":37,"_159":193,"_165":24,"_38":194,"_40":26,"_66":67,"_157":195,"_68":30,"_160":-5,"_196":197,"_17":198},"982e9982-5eb7-11f1-8d92-1607ee4eb77e","Leaderboard.tsx","982e9a5e-5eb7-11f1-8d92-1607ee4eb77e","81f26c2f-dd3b-4b1a-a78e-165a5ce919bf",5,["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","children",[],[199,190],"frontend","982ed38e-5eb7-11f1-8d92-1607ee4eb77e",["D",1780427805019],[188],[199],["D",1780427813712],[],[18,81],["D",1780427790340],[],[18,65],["D",1780427790340],[185,186],[18],["D",1780427646150],{"_11":12,"_134":71},{"_11":12,"_129":130,"_70":71,"_31":69,"_131":132,"_133":30},{"_40":120,"_13":16,"_34":37,"_121":86,"_122":-5,"_123":-5,"_124":-5,"_125":-5,"_126":-5,"_127":14,"_128":12},"ctx",{"_53":-5,"_153":250,"_251":252,"_253":254,"_255":30,"_256":30,"_257":30,"_258":24,"_259":-5,"_260":-7,"_261":-7,"_262":26,"_263":30,"_264":30,"_265":-5,"_266":30,"_267":30,"_268":30,"_269":-5},"ENV",{"_221":222,"_223":224,"_225":16,"_226":227,"_228":229,"_230":231,"_232":233,"_234":235,"_236":237,"_238":239,"_240":241,"_242":243,"_244":245,"_246":247,"_248":249},"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"]

History · backend