[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_174":175,"_176":177},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_131":-5,"_20":132,"_22":133,"_134":135,"_136":137,"_25":138,"_24":-5,"_139":-5,"_140":-5,"_141":54,"_142":143,"_144":45,"_145":-5,"_146":-5,"_147":148},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":-7,"_25":26,"_27":-5,"_28":-5,"_29":-5,"_30":-5,"_31":-5},"handle","chezlanoisette","name","ebenenews-radio","branchName","main","version","path","","project",{"_34":75,"_13":14,"_46":76,"_77":-5,"_78":54,"_79":80,"_81":80,"_82":83,"_84":-5,"_85":86,"_87":59,"_88":45,"_89":-5,"_90":-5,"_91":48,"_92":93,"_94":95,"_96":97,"_98":99,"_100":-5,"_101":102,"_103":102,"_104":105,"_106":105,"_107":105,"_108":102,"_109":102,"_110":111,"_112":113,"_114":115,"_116":54},"tree",[66,67],"file","contents",[32,33],"upstream","pull","ahead","behind","envVars",{"_34":57,"_13":58,"_37":59,"_39":-5,"_40":41,"_42":60,"_44":45,"_46":61,"_17":62,"_49":63,"_51":64,"_53":54,"_55":-5,"_18":65},{"_34":35,"_13":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":47,"_17":48,"_49":50,"_51":52,"_53":54,"_55":-5,"_18":56},"id","20347c29-391b-4b9b-89e4-7db61d05d2fb","server.ts","fileId","95267b30-ae92-11f1-b134-1607ee4eb77e","parentId","branchId","5ceca850-d09a-42c1-b232-bfd1ed528ec3","branchVersion",7,"latest",true,"createdAt",["D",1789208001588],0,"fileType","script","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport async function initDb() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS content (key TEXT PRIMARY KEY, value TEXT NOT NULL, updated_at TEXT NOT NULL)`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS admin_sessions (token TEXT PRIMARY KEY, created_at TEXT NOT NULL, expires_at TEXT NOT NULL)`);\n await sqlite.execute({sql:`INSERT OR IGNORE INTO content (key,value,updated_at) VALUES (?,?,?)`,args:[\"music\",\"[]\",new Date().toISOString()]});\n await sqlite.execute({sql:`INSERT OR IGNORE INTO content (key,value,updated_at) VALUES (?,?,?)`,args:[\"program\",\"[]\",new Date().toISOString()]});\n await sqlite.execute({sql:`INSERT OR IGNORE INTO content (key,value,updated_at) VALUES (?,?,?)`,args:[\"announcements\",\"[]\",new Date().toISOString()]});\n}\n\nexport async function readContent(key:string){\n const r=await sqlite.execute({sql:\"SELECT value FROM content WHERE key=?\",args:[key]});\n return r.rows[0]?.value ? JSON.parse(String(r.rows[0].value)) : [];\n}\n\nexport async function writeContent(key:string,value:unknown){\n await sqlite.execute({sql:\"INSERT INTO content(key,value,updated_at) VALUES(?,?,?) ON CONFLICT(key) DO UPDATE SET value=excluded.value, updated_at=excluded.updated_at\",args:[key,JSON.stringify(value),new Date().toISOString()]});\n}\n\nexport async function createSession(){\n const token=crypto.randomUUID()+crypto.randomUUID().replaceAll(\"-\",\"\");\n const now=Date.now(); const expires=new Date(now+7*24*60*60*1000).toISOString();\n await sqlite.execute({sql:\"INSERT INTO admin_sessions(token,created_at,expires_at) VALUES(?,?,?)\",args:[token,new Date(now).toISOString(),expires]});\n return token;\n}\n\nexport async function validSession(token:string|null){\n if(!token) return false;\n const r=await sqlite.execute({sql:\"SELECT token FROM admin_sessions WHERE token=? AND expires_at>?\",args:[token,new Date().toISOString()]});\n return r.rows.length>0;\n}\n\nexport async function deleteSession(token:string|null){\n if(token) await sqlite.execute({sql:\"DELETE FROM admin_sessions WHERE token=?\",args:[token]});\n}\n","deleted",false,"label",[36],"a59e9937-a8c7-403a-8cb5-87093f358185","main.ts","7ba67b72-a3f4-11f1-86a3-1607ee4eb77e",11,["D",1789208224644],9,"http","import { Hono } from \"npm:hono\";\nimport { getOAuthUserData, oauthMiddleware } from \"https://esm.town/v/std/oauth/middleware.ts\";\nimport { initDb, readContent, writeContent, createSession, validSession, deleteSession } from \"./server.ts\";\n\nconst OWNER = \"chezlanoisette\";\nconst GITHUB_INDEX = \"https://raw.githubusercontent.com/antoninleturgie-arch/ebenenews-radio/main/index.html\";\nconst app = new Hono();\n\nfunction tokenFrom(req: Request) {\n const h = req.headers.get(\"authorization\") || \"\";\n if (h.toLowerCase().startsWith(\"bearer \")) return h.slice(7).trim();\n return new URL(req.url).searchParams.get(\"token\");\n}\nasync function requireAdmin(req: Request) { return await validSession(tokenFrom(req)); }\n\napp.get(\"/\", async (c) => {\n await initDb();\n const music = await readContent(\"music\");\n const program = await readContent(\"program\");\n const announcements = await readContent(\"announcements\");\n return c.html(`Ébénénews 72.8 — serveur

📻 Ébénénews 72.8 — serveur

Serveur actif

Le contenu est stocké côté serveur dans SQLite et partagé entre les visiteurs.

${music.length} musique(s), ${program.length} programme(s), ${announcements.length} annonce(s).

Administration

Connecte-toi avec ton compte Val Town propriétaire.

`);\n});\n\napp.get(\"/site\", async (c) => {\n const r = await fetch(GITHUB_INDEX, { cache: \"no-store\" });\n if (!r.ok) return c.text(\"Impossible de charger l'interface GitHub.\", 502);\n let html = await r.text();\n const duplicate = ` const announcements=getAnnouncements();\\n announcements.unshift({text:text.trim(),date:new Date().toLocaleString('fr-FR')});\\n saveAnnouncements(announcements);\\n displayAnnouncements();\\n\\n const announcements=getAnnouncements();\\n announcements.unshift({text:text.trim(),date:new Date().toLocaleString('fr-FR')});\\n saveAnnouncements(announcements);\\n displayAnnouncements();`;\n const single = ` const announcements=getAnnouncements();\\n announcements.unshift({text:text.trim(),date:new Date().toLocaleString('fr-FR')});\\n saveAnnouncements(announcements);\\n displayAnnouncements();`;\n html = html.replace(duplicate, single);\n const oldAdmin = `return currentUser.role === 'admin';`;\n html = html.replace(oldAdmin, `return currentUser.role === 'admin' || !!localStorage.getItem('enneBServerAdminToken');`);\n html = html.replace(/]+server-bridge\\.js[^>]*><\\/script>/gi, \"\");\n const bridge = ``;\n html = html.replace(\"\", bridge + \"\");\n return c.html(html);\n});\n\napp.get(\"/api/content\", async (c) => {\n await initDb();\n return c.json({ok:true, music:await readContent(\"music\"), program:await readContent(\"program\"), announcements:await readContent(\"announcements\")});\n});\n\napp.get(\"/admin\", async (c) => {\n const session = await getOAuthUserData(c.req.raw);\n if (!session?.user) return c.redirect(\"/auth/login?returnTo=/admin\");\n if (session.user.username !== OWNER) return c.text(\"Accès refusé : ce compte n'est pas l'administrateur Ébénénews.\",403);\n await initDb();\n const token = await createSession();\n return c.html(`Admin Ébénénews

📻 Admin Ébénénews 72.8

Connecté en tant que ${session.user.username}.

Jeton serveur à copier dans le panneau admin du site :

${token}

Ce jeton expire dans 7 jours.

`);\n});\n\napp.get(\"/auth/logout-server\", async (c) => { await deleteSession(tokenFrom(c.req.raw)); return c.text(\"Déconnecté\"); });\n\napp.put(\"/api/admin/content\", async (c) => {\n await initDb();\n if (!(await requireAdmin(c.req.raw))) return c.json({ok:false,error:\"admin_required\"},401);\n const body = await c.req.json().catch(()=>null);\n if (!body || ![\"music\",\"program\",\"announcements\"].includes(body.key) || !Array.isArray(body.value)) return c.json({ok:false,error:\"invalid_payload\"},400);\n await writeContent(body.key, body.value);\n return c.json({ok:true,key:body.key,value:body.value});\n});\n\nexport default oauthMiddleware(app.fetch);",[58],{"_34":57,"_13":58,"_37":59,"_39":-5,"_40":41,"_42":60,"_44":45,"_46":72,"_17":62,"_49":63,"_51":64,"_53":54,"_55":-5,"_69":73,"_18":74},{"_34":35,"_13":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":68,"_17":48,"_49":50,"_51":52,"_53":54,"_55":-5,"_69":70,"_18":71},["D",1789208001588],"children",[],[36],["D",1789208224644],[],[58],"63ff13f2-e50d-4896-9b99-d08eacc04d73",["D",1788040586645],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Ébénénews 72.8 radio et lecteur multimédia","imageUrl","userId","e06dd92d-1045-495f-8f1d-c5dbb6d6b66d","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","01a04d97-81fb-71bc-a1db-828e350973f0","tursoName","63ff13f2e50d48969b99d08eacc04d73","tursoHostname","63ff13f2e50d48969b99d08eacc04d73-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789558275908],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_130":19},"org",{"_11":12,"_125":19,"_126":19,"_85":86,"_127":128,"_129":54},"branch",{"_17":60,"_13":16,"_34":41,"_117":75,"_118":-5,"_119":-5,"_120":-5,"_121":-5,"_122":-5,"_123":14,"_124":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_34":75,"_13":14,"_46":169,"_77":-5,"_78":54,"_79":80,"_81":80,"_82":83,"_84":-5,"_85":86,"_87":59,"_88":45,"_89":-5,"_90":-5,"_91":48,"_92":93,"_94":95,"_96":97,"_98":170,"_100":-5,"_101":102,"_103":102,"_104":105,"_106":105,"_107":105,"_108":102,"_109":102,"_110":171,"_112":172,"_114":173,"_116":54},[163,164],"files",[163,164],"counts",{"_153":48,"_154":155,"_156":155,"_31":157,"_158":159},[149,150],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_34":57,"_13":58,"_37":59,"_39":-5,"_40":41,"_42":60,"_44":45,"_46":61,"_17":62,"_49":63,"_51":64,"_53":54,"_55":-5,"_18":152},{"_34":35,"_13":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":47,"_17":48,"_49":50,"_51":52,"_53":54,"_55":-5,"_18":151},[36],[58],"pulls","branches",1,"forks",{"_160":48,"_162":48},"connections",{"_160":48,"_161":48},"count","unfilledCount","emptyCount",{"_34":57,"_13":58,"_37":59,"_39":-5,"_40":41,"_42":60,"_44":45,"_46":72,"_17":62,"_49":63,"_51":64,"_53":54,"_55":-5,"_69":167,"_18":168},{"_34":35,"_13":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":68,"_17":48,"_49":50,"_51":52,"_53":54,"_55":-5,"_69":165,"_18":166},[],[36],[],[58],["D",1788040586645],["D",1789558275908],{"_11":12,"_130":19},{"_11":12,"_125":19,"_126":19,"_85":86,"_127":128,"_129":54},{"_17":60,"_13":16,"_34":41,"_117":75,"_118":-5,"_119":-5,"_120":-5,"_121":-5,"_122":-5,"_123":14,"_124":12},"ctx",{"_110":-5,"_146":207,"_208":209,"_210":211,"_212":54,"_213":54,"_214":54,"_215":45,"_216":-5,"_217":-7,"_218":-7,"_219":48,"_220":54,"_221":54,"_222":-5,"_223":54,"_224":54,"_225":54,"_226":-5},"ENV",{"_178":179,"_180":181,"_182":16,"_183":184,"_185":186,"_187":188,"_189":190,"_191":192,"_193":194,"_195":196,"_197":198,"_199":200,"_201":202,"_203":204,"_205":206},"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"]

Code