🎮 Dashboard Pacman

Dati aggiornati in tempo reale

\n\n

📊 Visite totali: ${visits.rows.length}

🧍 Giocatori registrati: ${players.rows.length}

⏱️ Aggiornato: ${new Intl.DateTimeFormat(\"it-IT\", { timeZone: \"Europe/Rome\", hour: \"2-digit\", minute: \"2-digit\", second: \"2-digit\" }).format(new Date())}

\n\n

🏆 Classifica giocatori

\n \n ${th(\"Data\")}${th(\"Nome\")}${th(\"Cognome\")}${th(\"Telefono\")}${th(\"Email\")}${th(\"Record\")}${th(\"Consenso\")}\n ${playerRows || ''}\n

Nessun giocatore registrato

\n\n

📈 Visite recenti (ultime 100)

\n \n ${th(\"Data (Roma)\")}${th(\"IP\")}${th(\"Città\")}${th(\"Regione\")}${th(\"Nazione\")}${th(\"Provider\")}${th(\"Dispositivo\")}${th(\"OS\")}${th(\"Browser\")}${th(\"Lingua\")}${th(\"Schermo\")}${th(\"Fuso orario\")}${th(\"Core\")}${th(\"RAM\")}${th(\"Lat\")}${th(\"\")}${th(\"Lon\")}${th(\"CAP\")}${th(\"Continente\")}${th(\"Batteria\")}${th(\"In carica\")}${th(\"Tipo\")}\n ${visitRows}\n

\n\n

Vedi come JSON

\n\n`;\n\n return new Response(html, { headers: { \"content-type\": \"text/html; charset=utf-8\" } });\n}\n","label","pacman-dashboard",[18],"pulls","branches",1,"forks","envVars",{"_162":26,"_164":26},"connections",{"_162":26,"_163":26},"count","unfilledCount","emptyCount",{"_32":145,"_13":18,"_62":63,"_42":-5,"_34":35,"_146":39,"_147":83,"_36":186,"_38":26,"_64":65,"_149":150,"_66":24,"_151":152,"_175":187,"_17":188},{"_32":178,"_13":179,"_62":180,"_42":-5,"_34":35,"_146":109,"_147":83,"_36":181,"_38":182,"_64":21,"_149":183,"_66":24,"_151":-5,"_175":184,"_17":185},{"_32":168,"_13":169,"_62":81,"_42":-5,"_34":35,"_146":170,"_147":83,"_36":171,"_38":172,"_64":65,"_149":173,"_66":24,"_151":174,"_175":176,"_17":177},"e0f3285c-962a-46b0-8c23-ae5f8b462e23","main.ts",21,["D",1788003550483],11,"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { readFile } from \"https://esm.town/v/std/utils/index.ts\";\n\n// Crea la tabella se non esiste\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS visits (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n ip TEXT,\n user_agent TEXT,\n referer TEXT,\n time TEXT,\n city TEXT,\n region TEXT,\n country TEXT,\n org TEXT,\n device TEXT,\n os TEXT,\n browser TEXT,\n lang TEXT,\n screen TEXT,\n tz TEXT,\n cores INTEGER,\n memory INTEGER,\n lat TEXT,\n lon TEXT,\n continent TEXT,\n postal TEXT,\n bot INTEGER\n )\n`);\n\n// Orario di Roma (fuso Europe/Rome) in formato 24h: gg/mm/aaaa hh:mm:ss\nfunction romeNow(): string {\n return new Intl.DateTimeFormat(\"it-IT\", {\n timeZone: \"Europe/Rome\",\n day: \"2-digit\",\n month: \"2-digit\",\n year: \"numeric\",\n hour: \"2-digit\",\n minute: \"2-digit\",\n second: \"2-digit\",\n hour12: false,\n }).format(new Date());\n}\n\n// Riconosce dispositivo, OS, browser e bot dallo user agent\nfunction parseUA(ua: string) {\n const isBot = /bot|crawl|spider|slurp|headless|curl|wget|python|node/i.test(ua);\n const device = /mobile|android|iphone|ipad/i.test(ua) ? (/ipad|tablet/i.test(ua) ? \"tablet\" : \"telefono\") : \"PC\";\n const os =\n /windows/i.test(ua) ? \"Windows\" :\n /android/i.test(ua) ? \"Android\" :\n /iphone|ipad|ipod/i.test(ua) ? \"iOS\" :\n /mac os/i.test(ua) ? \"macOS\" :\n /linux/i.test(ua) ? \"Linux\" : \"sconosciuto\";\n const browser =\n /edg\\//i.test(ua) ? \"Edge\" :\n /opr\\//i.test(ua) ? \"Opera\" :\n /chrome\\//i.test(ua) ? \"Chrome\" :\n /firefox\\//i.test(ua) ? \"Firefox\" :\n /safari\\//i.test(ua) ? \"Safari\" : \"sconosciuto\";\n return { device, os, browser, isBot };\n}\n\n// Geolocalizzazione approssimativa dell'IP\nasync function geoIp(ip: string) {\n const empty = { city: \"?\", region: \"?\", country: \"?\", org: \"?\", lat: \"?\", lon: \"?\", continent: \"?\", postal: \"?\" };\n try {\n const res = await fetch(`https://ipapi.co/${ip}/json/`);\n if (!res.ok) return empty;\n const d = await res.json();\n return {\n city: d.city ?? \"?\",\n region: d.region ?? \"?\",\n country: d.country_name ?? \"?\",\n org: d.org ?? \"?\",\n lat: String(d.latitude ?? \"?\"),\n lon: String(d.longitude ?? \"?\"),\n continent: d.continent_code ?? \"?\",\n postal: String(d.postal ?? \"?\"),\n };\n } catch {\n return empty;\n }\n}\n\nexport default async function(req: Request): Promise {\n const url = new URL(req.url);\n\n // Registrazione giocatore per la classifica (dati forniti volontariamente)\n if (url.pathname === \"/register\" && req.method === \"POST\") {\n try {\n const d = await req.json();\n if (!d.consent) return new Response(\"consenso richiesto\", { status: 400 });\n if (!d.email || !d.phone || !d.first_name || !d.last_name)\n return new Response(\"email e telefono obbligatori\", { status: 400 });\n await sqlite.execute({\n sql: `INSERT INTO players (first_name, last_name, phone, email, best_score, consent, time)\n VALUES (?, ?, ?, ?, 0, 1, ?)`,\n args: [\n d.first_name ?? \"\", d.last_name ?? \"\",\n d.phone || null, d.email || null,\n romeNow(),\n ],\n });\n return new Response(\"ok\");\n } catch {\n return new Response(\"errore\", { status: 400 });\n }\n }\n\n // Classifica pubblica: mostra SOLO il nome (mai cognome/telefono/email)\n if (url.pathname === \"/leaderboard\") {\n const res = await sqlite.execute(\n \"SELECT first_name, best_score FROM players ORDER BY best_score DESC LIMIT 20\"\n );\n return new Response(JSON.stringify(res.rows), {\n headers: { \"content-type\": \"application/json\", \"access-control-allow-origin\": \"*\" },\n });\n }\n\n // Endpoint segreto per vedere gli IP salvati: /visits?key=...\n if (url.pathname === \"/visits\") {\n const key = url.searchParams.get(\"key\");\n if (key !== \"rfghydyhfuidhfuijdhù\") {\n return new Response(\"Not Found\", { status: 404 });\n }\n const res = await sqlite.execute(\"SELECT * FROM visits ORDER BY id DESC LIMIT 500\");\n return new Response(JSON.stringify(res.rows, null, 2), {\n headers: { \"content-type\": \"application/json\" },\n });\n }\n\n // Il browser del visitatore manda i dati del dispositivo qui\n if (url.pathname === \"/collect\" && req.method === \"POST\") {\n try {\n const d = await req.json();\n await sqlite.execute({\n sql: `UPDATE visits SET device=?, os=?, browser=?, lang=?, screen=?, tz=?, cores=?, memory=?\n WHERE id = (SELECT id FROM visits ORDER BY id DESC LIMIT 1)`,\n args: [\n d.device ?? \"?\", d.os ?? \"?\", d.browser ?? \"?\",\n d.lang ?? \"?\", d.screen ?? \"?\", d.tz ?? \"?\",\n d.cores ?? null, d.memory ?? null,\n ],\n });\n } catch { /* ignora */ }\n return new Response(\"ok\");\n }\n\n // Aggiornamento batteria (solo Chrome/Edge/Opera)\n if (url.pathname === \"/battery\" && req.method === \"POST\") {\n try {\n const d = await req.json();\n await sqlite.execute({\n sql: `UPDATE visits SET battery=?, charging=?\n WHERE id = (SELECT id FROM visits ORDER BY id DESC LIMIT 1)`,\n args: [d.battery ?? \"?\", d.charging ?? 0],\n });\n } catch { /* ignora */ }\n return new Response(\"ok\");\n }\n\n // Registra il visitatore\n const ip =\n req.headers.get(\"x-forwarded-for\")?.split(\",\")[0].trim() ??\n req.headers.get(\"x-real-ip\") ??\n \"sconosciuto\";\n\n const ua = req.headers.get(\"user-agent\") ?? \"sconosciuto\";\n const uaInfo = parseUA(ua);\n const geo = await geoIp(ip);\n\n await sqlite.execute({\n sql: `INSERT INTO visits (ip, user_agent, referer, time, city, region, country, org,\n device, os, browser, lang, screen, tz, cores, memory, lat, lon, continent, postal, bot)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [\n ip,\n ua,\n req.headers.get(\"referer\") ?? \"nessuno\",\n romeNow(), // fuso orario Roma, formato 24h\n geo.city, geo.region, geo.country, geo.org,\n uaInfo.device, uaInfo.os, uaInfo.browser,\n req.headers.get(\"accept-language\")?.split(\",\")[0] ?? \"?\",\n \"?\", \"?\", null, null, // screen/tz/cores/memory: riempiti dal browser\n geo.lat, geo.lon, geo.continent, geo.postal,\n uaInfo.isBot ? 1 : 0,\n ],\n });\n\n // Pagina con giochino pacman (con script raccoglidati)\n const html = await readFile(\"game.html\");\n return new Response(html, { headers: { \"content-type\": \"text/html; charset=utf-8\" } });\n}\n","pacman-game","children",[],[169],"a400f97e-6698-4d74-997b-954eed94cae9","game.html","2240008e-a39b-11f1-b807-1607ee4eb77e",["D",1788003741187],10,"\n\n\n\n\nPacman Game\n\n\n\n

PACMAN GAME

\n\n \n

🏆 Registrati per giocare

La registrazione è necessaria per partecipare alla classifica del gioco. Nome e punteggio saranno visibili pubblicamente; gli altri dati solo agli amministratori.

\n \n \n

\n\n \n

Frecce / WASD per muoverti · swipe su mobile

\n\n \n

🏆 Classifica

\n \n \n\n\n\n",[],[179],["D",1788003366536],[],[18],["D",1788001999001],["D",1789479081816],{"_11":12,"_123":69},{"_11":12,"_118":119,"_68":69,"_30":67,"_120":121,"_122":24},{"_38":109,"_13":16,"_32":35,"_110":71,"_111":-5,"_112":-5,"_113":-5,"_114":-5,"_115":-5,"_116":14,"_117":12},"ctx",{"_52":-5,"_142":227,"_228":229,"_230":231,"_232":24,"_233":24,"_234":24,"_235":83,"_236":-5,"_237":-7,"_238":-7,"_239":26,"_240":24,"_241":24,"_242":-5,"_243":24,"_244":24,"_245":24,"_246":-5},"ENV",{"_198":199,"_200":201,"_202":16,"_203":204,"_205":206,"_207":208,"_209":210,"_211":212,"_213":214,"_215":216,"_217":218,"_219":220,"_221":222,"_223":224,"_225":226},"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 · dashboard.ts