[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_181":182,"_183":184},"routes/_app.x.$handle.$name",{"_108":107,"_32":50,"_116":94,"_27":110,"_13":14,"_117":-5,"_11":118,"_119":120,"_121":122,"_123":124,"_125":126,"_21":-5,"_127":128,"_129":130,"_131":25,"_132":133,"_134":63,"_135":-5,"_136":-5,"_137":138},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_48":49,"_32":50,"_37":51,"_52":-5,"_53":25,"_54":55,"_56":55,"_57":58,"_59":-5,"_18":60,"_61":44,"_62":63,"_64":-5,"_65":-5,"_66":67,"_68":69,"_70":71,"_72":73,"_74":75,"_76":-5,"_77":78,"_79":78,"_80":81,"_82":81,"_83":81,"_84":78,"_85":78,"_86":87,"_88":89,"_90":91,"_92":25},"version",1,"changes",[19,20],"aiChatInfo","userId",{"_21":42,"_23":-7,"_24":25,"_26":25,"_27":43,"_29":43},{"_21":22,"_23":-7,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_24":25},"previous","deleted",false,"deletedHere","path","server.ts","latestPath","fileId","01a0952e-aa13-73ab-8e30-52d627171a3b","name","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","createdAt",["D",1789209258375],"branchVersion","branchId","020dbb43-7361-4fb8-bb59-6f40b59f0d06",{"_30":44,"_32":43,"_33":45,"_35":46,"_37":47,"_39":14,"_40":41,"_24":25},"main.ts","01a0952e-aa13-73ab-8e30-4dff73c7b4f6","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);",["D",1789209258375],"id","0ee198c1-ca00-465e-a199-50775649e403","ebenenews-radio",["D",1789209258375],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Ébénénews 72.8 radio et lecteur multimédia","imageUrl","45d591c7-259c-4385-884d-13d26dbdf8ae","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","01a09524-21a5-752e-a626-e083125573da","tursoName","0ee198c1ca00465ea19950775649e403","tursoHostname","0ee198c1ca00465ea19950775649e403-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789471840176],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_108":107,"_115":110},"org",{"_108":107,"_109":110,"_111":110,"_18":60,"_112":113,"_114":25},"branch",{"_13":93,"_32":94,"_48":41,"_95":49,"_96":97,"_98":99,"_100":55,"_101":102,"_103":104,"_105":50,"_106":107},"isOwned",138,"main","projectId","forkedBranchId","5ceca850-d09a-42c1-b232-bfd1ed528ec3","forkedBranchVersion",11,"forkedProjectPrivacy","forkedProjectId","63ff13f2-e50d-4896-9b99-d08eacc04d73","forkedProjectOrgId","01a04d97-81fb-71bc-a1db-828e350973f0","projectName","userHandle","ninjantox","handle","displayName","","avatar","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_48":49,"_32":50,"_37":176,"_52":-5,"_53":25,"_54":55,"_56":55,"_57":58,"_59":-5,"_18":60,"_61":44,"_62":63,"_64":-5,"_65":-5,"_66":67,"_68":69,"_70":71,"_72":73,"_74":177,"_76":-5,"_77":78,"_79":78,"_80":81,"_82":81,"_83":81,"_84":78,"_85":78,"_86":178,"_88":179,"_90":180,"_92":25},"tree",[167,168],"files",[167,168],"counts",{"_157":67,"_158":14,"_159":67,"_160":161,"_162":163},"contents",[146,147],"upstreamProject",{"_48":102,"_32":50,"_57":58,"_59":-5,"_54":55,"_86":145},"upstreamBranch",{"_48":97,"_37":139,"_140":141,"_32":94,"_95":102,"_13":99,"_96":-5,"_98":-5,"_142":143,"_52":-5,"_92":25,"_54":55,"_106":144,"_68":104,"_105":50},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1788040586645],"updatedAt",["D",1789208224644],"lockfileKey","1789208224729-esm.town_v_chezlanoisette_ebenenews-radio@11-main","chezlanoisette",{"_108":144,"_115":110},{"_48":154,"_32":43,"_30":44,"_149":-5,"_40":41,"_39":14,"_150":25,"_37":155,"_13":67,"_33":45,"_35":46,"_24":25,"_152":-5,"_27":156},{"_48":148,"_32":28,"_30":31,"_149":-5,"_40":41,"_39":14,"_150":25,"_37":151,"_13":67,"_33":34,"_35":36,"_24":25,"_152":-5,"_27":153},"76baf6b9-c7db-4111-9df2-7f759f0031b2","parentId","latest",["D",1789209258375],"label",[28],"9e14d791-37d0-42bf-9f9e-ac304ed4a766",["D",1789209258375],[43],"pulls","branches","forks","envVars",{"_164":67,"_166":67},"connections",{"_164":67,"_165":67},"count","unfilledCount","emptyCount",{"_48":154,"_32":43,"_30":44,"_149":-5,"_40":41,"_39":14,"_150":25,"_37":173,"_13":67,"_33":45,"_35":46,"_24":25,"_152":-5,"_170":174,"_27":175},{"_48":148,"_32":28,"_30":31,"_149":-5,"_40":41,"_39":14,"_150":25,"_37":169,"_13":67,"_33":34,"_35":36,"_24":25,"_152":-5,"_170":171,"_27":172},["D",1789209258375],"children",[],[28],["D",1789209258375],[],[43],["D",1789209258375],["D",1789471840176],{"_108":107,"_115":110},{"_108":107,"_109":110,"_111":110,"_18":60,"_112":113,"_114":25},{"_13":93,"_32":94,"_48":41,"_95":49,"_96":97,"_98":99,"_100":55,"_101":102,"_103":104,"_105":50,"_106":107},"ctx",{"_86":-5,"_136":214,"_215":216,"_217":218,"_219":25,"_220":25,"_221":25,"_222":63,"_223":-5,"_224":-7,"_225":-7,"_226":67,"_227":25,"_228":25,"_229":-5,"_230":25,"_231":25,"_232":25,"_233":-5},"ENV",{"_185":186,"_187":188,"_189":94,"_190":191,"_192":193,"_194":195,"_196":197,"_198":199,"_200":201,"_202":203,"_204":205,"_206":207,"_208":209,"_210":211,"_212":213},"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 · v1