\\n

COIN & CHIP ARCADE

農家になれよ

COINS0CHIPS0

\\n

\\n\\n

\";\n\nasync function ensureSchema() {\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS leaderboard (player_id TEXT PRIMARY KEY, name TEXT NOT NULL, farm_level INTEGER NOT NULL, farm_xp INTEGER NOT NULL, chips INTEGER NOT NULL, coins INTEGER NOT NULL, updated_at TEXT NOT NULL)`,\n );\n}\nfunction json(data, status = 200) {\n return new Response(JSON.stringify(data), {\n status,\n headers: {\n \"content-type\": \"application/json; charset=utf-8\",\n \"cache-control\": \"no-store\",\n },\n });\n}\nasync function route(req: Request): Promise {\n const url = new URL(req.url);\n if (req.method === \"GET\" && url.searchParams.get(\"api\") === \"ranking\") {\n await ensureSchema();\n const result = await sqlite.execute(\n \"SELECT name, farm_level, farm_xp, chips, coins FROM leaderboard ORDER BY chips DESC, coins DESC, farm_level DESC, farm_xp DESC LIMIT 50\",\n );\n return json({ ok: true, rows: result.rows });\n }\n if (req.method === \"POST\") {\n const body = await req.json().catch(() => ({}));\n if (body.op !== \"upsert\") {\n return json({ ok: false, error: \"unknown operation\" }, 400);\n }\n const playerId = String(body.playerId || \"\").slice(0, 80);\n const name = String(body.name || \"\").trim().slice(0, 20);\n const farmLevel = Math.max(\n 1,\n Math.min(20, Math.floor(Number(body.farmLevel) || 1)),\n );\n const farmXp = Math.max(\n 0,\n Math.min(999999999, Math.floor(Number(body.farmXp) || 0)),\n );\n const chips = Math.max(\n 0,\n Math.min(999999999, Math.floor(Number(body.chips) || 0)),\n );\n const coins = Math.max(\n 0,\n Math.min(999999999, Math.floor(Number(body.coins) || 0)),\n );\n if (!playerId || !name) {\n return json({ ok: false, error: \"name and playerId are required\" }, 400);\n }\n await ensureSchema();\n await sqlite.execute({\n sql:\n \"INSERT INTO leaderboard (player_id,name,farm_level,farm_xp,chips,coins,updated_at) VALUES (:id,:name,:level,:xp,:chips,:coins,datetime('now')) ON CONFLICT(player_id) DO UPDATE SET name=excluded.name, farm_level=excluded.farm_level, farm_xp=excluded.farm_xp, chips=excluded.chips, coins=excluded.coins, updated_at=excluded.updated_at\",\n args: { id: playerId, name, level: farmLevel, xp: farmXp, chips, coins },\n });\n return json({ ok: true });\n }\n return new Response(page, {\n headers: {\n \"content-type\": \"text/html; charset=utf-8\",\n \"cache-control\": \"no-store\",\n },\n });\n}\nexport default async function (req: Request): Promise {\n try {\n return await route(req);\n } catch (error) {\n console.error(error);\n return json({ ok: false, error: \"server error\" }, 500);\n }\n}","mnd",[152],"b195445c-ece6-4af7-8721-54a51317efca",["D",1787334493089],[27],"pulls","branches",1,"forks","envVars",{"_171":61,"_173":61},"connections",{"_171":61,"_172":61},"count","unfilledCount","emptyCount",{"_42":160,"_32":27,"_30":31,"_135":-5,"_40":41,"_39":14,"_137":24,"_37":188,"_13":61,"_33":34,"_35":36,"_23":24,"_141":-5,"_179":189,"_26":190},{"_42":151,"_32":152,"_30":55,"_135":-5,"_40":41,"_39":153,"_137":24,"_37":185,"_13":155,"_33":156,"_35":157,"_23":24,"_141":158,"_179":186,"_26":187},{"_42":143,"_32":144,"_30":145,"_135":-5,"_40":41,"_39":146,"_137":57,"_37":182,"_13":148,"_33":34,"_35":149,"_23":24,"_141":-5,"_179":183,"_26":184},{"_42":132,"_32":133,"_30":134,"_135":-5,"_40":41,"_39":136,"_137":57,"_37":178,"_13":139,"_33":34,"_35":140,"_23":24,"_141":-5,"_179":180,"_26":181},["D",1787306151415],"children",[],[133],["D",1787243432652],[],[144],["D",1787306180426],[],[152],["D",1787334493089],[],[27],["D",1787236709175],["D",1789500689328],{"_98":97,"_106":102},{"_98":97,"_99":100,"_101":102,"_18":53,"_103":104,"_105":24},{"_13":87,"_32":88,"_42":41,"_89":43,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":44,"_96":97},"ctx",{"_80":-5,"_125":229,"_230":231,"_232":233,"_234":24,"_235":24,"_236":24,"_237":57,"_238":-5,"_239":-7,"_240":-7,"_241":61,"_242":24,"_243":24,"_244":-5,"_245":24,"_246":24,"_247":24,"_248":-5},"ENV",{"_200":201,"_202":203,"_204":88,"_205":206,"_207":208,"_209":210,"_211":212,"_213":214,"_215":216,"_217":218,"_219":220,"_221":222,"_223":224,"_225":226,"_227":228},"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"]

Diff · v71