[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_106":107,"_108":109},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","francy","name","ip-tracker","path","dashboard.ts","project",{"_22":46,"_11":12,"_33":47,"_48":-5,"_49":42,"_50":51,"_52":51,"_53":-5,"_54":-5,"_55":56,"_57":58,"_59":32,"_60":-5,"_61":-5,"_62":36,"_63":64,"_65":66,"_67":68,"_69":70,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":82,"_83":84,"_85":86,"_87":42},"file",{"_22":23,"_11":14,"_24":25,"_26":-5,"_27":28,"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_13":45},"permalink","https://www.val.town/x/francy/ip-tracker/code/dashboard.ts","extension","id","34da8828-66a5-470d-b9a8-211335b80aff","fileId","d2b45d00-a39d-11f1-a034-1607ee4eb77e","parentId","branchId","cd608267-8d16-470c-a5f2-80698b4e7c9d","branchVersion",16,"latest",true,"createdAt",["D",1788003366536],"version",0,"fileType","http","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst KEY = \"rfghydyhfuidhfuijdhù\";\n\nexport default async function(req: Request): Promise {\n const url = new URL(req.url);\n if (url.searchParams.get(\"key\") !== KEY) {\n return new Response(\"Not Found\", { status: 404 });\n }\n\n const visits = await sqlite.execute(\n \"SELECT * FROM visits ORDER BY id DESC LIMIT 100\"\n );\n const players = await sqlite.execute(\n \"SELECT * FROM players ORDER BY best_score DESC LIMIT 50\"\n );\n\n const th = (s: string) =>\n `${s}`;\n const td = (v: unknown) =>\n `${v ?? \"—\"}`;\n\n const visitRows = visits.rows.map((r: any) => `\n \n ${td(r.time)}${td(r.ip)}${td(r.city)}${td(r.region)}${td(r.country)}\n ${td(r.org)}${td(r.device)}${td(r.os)}${td(r.browser)}${td(r.lang)}\n ${td(r.screen)}${td(r.tz)}${td(r.cores)}${td(r.memory)}\n ${td(r.lat)}, ${td(r.lon)}${td(r.postal)}${td(r.continent)}\n ${td(r.battery ?? \"—\")}${td(r.charging ? \"⚡ sì\" : \"no\")}\n ${td(r.bot ? \"🤖 bot\" : \"👤 umano\")}\n `).join(\"\");\n\n const playerRows = players.rows.map((p: any) => `\n \n ${td(p.time)}${td(p.first_name)}${td(p.last_name)}${td(p.phone)}\n ${td(p.email)}${td(`${p.best_score}`)}\n ${td(p.consent ? \"✅\" : \"—\")}\n `).join(\"\");\n\n const html = `\n\n\n\n\nDashboard\n\n\n\n

🎮 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","deleted",false,"label","pacman-dashboard",[14],"9b4131ac-3d7f-44fd-86be-643b8fae1211",["D",1788001999001],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","cb7326f8-d0d4-4689-a784-ecd8b408be49","pinnedFileId","a7a83ca6-a39a-11f1-818a-1607ee4eb77e","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","01a04d36-bd04-74ec-b817-0ef9a310c88d","tursoName","9b4131ac3d7f44fd86be643b8fae1211","tursoHostname","9b4131ac3d7f44fd86be643b8fae1211-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789479081816],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_9":10,"_105":101},"org",{"_9":10,"_98":99,"_100":101,"_55":56,"_102":103,"_104":42},"branch",{"_35":88,"_11":89,"_22":28,"_90":46,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":12,"_97":10},"isOwned",24,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Francy","avatar","https://lh3.googleusercontent.com/a/ACg8ocImoFzwwWV5mE-DEq2hTY83rV6c7HGbJ80nBAgN-nh8taMJqmM=s96-c","tier","free","canRestrictVals","profileImageUrl","ctx",{"_81":-5,"_139":140,"_141":142,"_143":144,"_145":42,"_146":42,"_147":42,"_148":32,"_149":-5,"_150":-7,"_151":-7,"_152":36,"_153":42,"_154":42,"_155":-5,"_156":42,"_157":42,"_158":42,"_159":-5},"ENV",{"_110":111,"_112":113,"_114":89,"_115":116,"_117":118,"_119":120,"_121":122,"_123":124,"_125":126,"_127":128,"_129":130,"_131":132,"_133":134,"_135":136,"_137":138},"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","orgs",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]