[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_209":210,"_211":212},"routes/_app.x.$handle.$name",{"_104":103,"_32":45,"_112":90,"_27":106,"_13":14,"_113":-5,"_11":114,"_115":116,"_117":118,"_119":120,"_121":122,"_20":-5,"_123":124,"_125":126,"_127":25,"_128":129,"_130":59,"_131":-5,"_132":-5,"_133":134},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":25},"version",86,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","schedule.ts","latestPath","fileId","b73cac0c-aeca-11f1-ae3f-1607ee4eb77e","name","fileType","interval","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// Ébénénews — programmation automatique.\n// Le val s'exécute régulièrement et publie dans content/announcements\n// les annonces dont l'heure est arrivée, puis les conserve dans l'historique.\n\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS scheduled_announcements (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n text TEXT NOT NULL,\n scheduled_at TEXT NOT NULL,\n published INTEGER NOT NULL DEFAULT 0,\n created_at TEXT NOT NULL\n)`);\n\nexport default async function (interval: Interval) {\n const now = new Date();\n const rows = await sqlite.execute({\n sql: `SELECT id,text,scheduled_at FROM scheduled_announcements WHERE published=0 AND scheduled_at<=? ORDER BY scheduled_at ASC`,\n args: [now.toISOString()]\n });\n\n if (!rows.rows.length) {\n console.log(\"Ébénénews: aucune annonce à publier.\");\n return;\n }\n\n const current = await sqlite.execute({\n sql: `SELECT value FROM content WHERE key='announcements'`\n });\n let announcements: any[] = [];\n try { announcements = current.rows[0]?.value ? JSON.parse(String(current.rows[0].value)) : []; } catch { announcements = []; }\n if (!Array.isArray(announcements)) announcements = [];\n\n for (const row of rows.rows) {\n announcements.unshift({\n text: String(row.text),\n date: now.toLocaleString(\"fr-FR\"),\n scheduled: true\n });\n await sqlite.execute({\n sql: `UPDATE scheduled_announcements SET published=1 WHERE id=?`,\n args: [row.id]\n });\n console.log(`Ébénénews: annonce publiée #${row.id}`);\n }\n\n await sqlite.execute({\n sql: `INSERT INTO content(key,value,updated_at) VALUES(?,?,?) ON CONFLICT(key) DO UPDATE SET value=excluded.value,updated_at=excluded.updated_at`,\n args: [\"announcements\", JSON.stringify(announcements), now.toISOString()]\n });\n}\n","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// Ébénénews — programmation automatique.\n// Le val s'exécute régulièrement et publie dans content/announcements\n// les annonces dont l'heure est arrivée, puis les conserve dans l'historique.\n\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS scheduled_announcements (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n text TEXT NOT NULL,\n scheduled_at TEXT NOT NULL,\n published INTEGER NOT NULL DEFAULT 0,\n created_at TEXT NOT NULL\n)`);\n\nimport { tickRadio } from \"./radio-engine.ts\";\n\nexport default async function (interval: Interval) {\n const now = new Date();\n const rows = await sqlite.execute({\n sql: `SELECT id,text,scheduled_at FROM scheduled_announcements WHERE published=0 AND scheduled_at<=? ORDER BY scheduled_at ASC`,\n args: [now.toISOString()]\n });\n\n if (!rows.rows.length) {\n console.log(\"Ébénénews: aucune annonce à publier.\");\n return;\n }\n\n const current = await sqlite.execute({\n sql: `SELECT value FROM content WHERE key='announcements'`\n });\n let announcements: any[] = [];\n try { announcements = current.rows[0]?.value ? JSON.parse(String(current.rows[0].value)) : []; } catch { announcements = []; }\n if (!Array.isArray(announcements)) announcements = [];\n\n for (const row of rows.rows) {\n announcements.unshift({\n text: String(row.text),\n date: now.toLocaleString(\"fr-FR\"),\n scheduled: true\n });\n await sqlite.execute({\n sql: `UPDATE scheduled_announcements SET published=1 WHERE id=?`,\n args: [row.id]\n });\n console.log(`Ébénénews: annonce publiée #${row.id}`);\n }\n\n await sqlite.execute({\n sql: `INSERT INTO content(key,value,updated_at) VALUES(?,?,?) ON CONFLICT(key) DO UPDATE SET value=excluded.value,updated_at=excluded.updated_at`,\n args: [\"announcements\", JSON.stringify(announcements), now.toISOString()]\n });\n}\n","createdAt",["D",1789232908422],"branchVersion","branchId","020dbb43-7361-4fb8-bb59-6f40b59f0d06","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","01a0952e-aa13-73ab-8e30-4dff73c7b4f6","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",1789558275908],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_104":103,"_111":106},"org",{"_104":103,"_105":106,"_107":106,"_18":55,"_108":109,"_110":25},"branch",{"_13":89,"_32":90,"_43":42,"_91":44,"_92":93,"_94":95,"_96":50,"_97":98,"_99":100,"_101":45,"_102":103},"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",{"_43":44,"_32":45,"_38":204,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":205,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":206,"_84":207,"_86":208,"_88":25},"tree",[187,188,189,190],"files",[187,188,189,190],"counts",{"_177":63,"_178":160,"_179":63,"_180":181,"_182":183},"contents",[142,143,144,145],"upstreamProject",{"_43":98,"_32":45,"_52":53,"_54":-5,"_49":50,"_82":141},"upstreamBranch",{"_43":93,"_38":135,"_136":137,"_32":90,"_91":98,"_13":95,"_92":-5,"_94":-5,"_138":139,"_47":-5,"_88":25,"_49":50,"_102":140,"_64":100,"_101":45},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1788040586645],"updatedAt",["D",1789208224644],"lockfileKey","1789208224729-esm.town_v_chezlanoisette_ebenenews-radio@11-main","chezlanoisette",{"_104":140,"_111":106},{"_43":169,"_32":170,"_30":57,"_149":-5,"_41":42,"_40":171,"_151":25,"_38":172,"_13":173,"_33":174,"_35":175,"_24":25,"_156":-5,"_27":176},{"_43":162,"_32":163,"_30":164,"_149":-5,"_41":42,"_40":165,"_151":25,"_38":166,"_13":63,"_33":154,"_35":167,"_24":25,"_156":-5,"_27":168},{"_43":158,"_32":28,"_30":31,"_149":-5,"_41":42,"_40":14,"_151":25,"_38":159,"_13":160,"_33":34,"_35":37,"_24":25,"_156":-5,"_27":161},{"_43":146,"_32":147,"_30":148,"_149":-5,"_41":42,"_40":150,"_151":25,"_38":152,"_13":153,"_33":154,"_35":155,"_24":25,"_156":-5,"_27":157},"6cc5752e-10c6-4cbf-bfdd-a452381c979a","server.ts","01a0952e-aa13-73ab-8e30-52d627171a3b","parentId",43,"latest",["D",1789231658579],8,"script","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(`CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY AUTOINCREMENT, email TEXT UNIQUE NOT NULL, password_hash TEXT NOT NULL, name TEXT NOT NULL, role TEXT NOT NULL DEFAULT 'user', created_at TEXT NOT NULL)`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS user_sessions (token TEXT PRIMARY KEY, user_id INTEGER NOT NULL, created_at TEXT NOT NULL, expires_at TEXT NOT NULL)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_user_sessions_user ON user_sessions(user_id)`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS user_presence (user_id INTEGER PRIMARY KEY, last_seen 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\nfunction cleanEmail(email:string){ return String(email||\"\").trim().toLowerCase(); }\n\nasync function hashPassword(password:string){\n const data=new TextEncoder().encode(password);\n const digest=await crypto.subtle.digest(\"SHA-256\",data);\n return Array.from(new Uint8Array(digest)).map(b=>b.toString(16).padStart(2,\"0\")).join(\"\");\n}\n\nexport async function createUser(email:string,password:string,name:string){\n email=cleanEmail(email); name=String(name||\"\").trim().slice(0,80);\n if(!email || !password || password.length<6 || !name) throw new Error(\"invalid\");\n const passwordHash=await hashPassword(password);\n const now=new Date().toISOString();\n try {\n const r=await sqlite.execute({sql:\"INSERT INTO users(email,password_hash,name,role,created_at) VALUES(?,?,?,?,?) RETURNING id,email,name,role,created_at\",args:[email,passwordHash,name,\"user\",now]});\n return r.rows[0];\n } catch(e){\n if(String(e).toLowerCase().includes(\"unique\")) throw new Error(\"exists\");\n throw e;\n }\n}\n\nexport async function loginUser(email:string,password:string){\n const passwordHash=await hashPassword(password);\n const r=await sqlite.execute({sql:\"SELECT id,email,name,role,created_at FROM users WHERE email=? AND password_hash=?\",args:[cleanEmail(email),passwordHash]});\n if(!r.rows.length) return null;\n const user=r.rows[0];\n const token=crypto.randomUUID()+crypto.randomUUID().replaceAll(\"-\",\"\");\n const now=Date.now(); const expires=new Date(now+30*24*60*60*1000).toISOString();\n await sqlite.execute({sql:\"INSERT INTO user_sessions(token,user_id,created_at,expires_at) VALUES(?,?,?,?)\",args:[token,user.id,new Date(now).toISOString(),expires]});\n return {token,user};\n}\n\nexport async function getUserByToken(token:string|null){\n if(!token) return null;\n const r=await sqlite.execute({sql:\"SELECT u.id,u.email,u.name,u.role,u.created_at FROM user_sessions s JOIN users u ON u.id=s.user_id WHERE s.token=? AND s.expires_at>?\",args:[token,new Date().toISOString()]});\n return r.rows[0]||null;\n}\n\nexport async function deleteUserSession(token:string|null){\n if(token) {\n const r=await sqlite.execute({sql:\"SELECT user_id FROM user_sessions WHERE token=?\",args:[token]});\n await sqlite.execute({sql:\"DELETE FROM user_sessions WHERE token=?\",args:[token]});\n if(r.rows[0]?.user_id) await sqlite.execute({sql:\"DELETE FROM user_presence WHERE user_id=?\",args:[r.rows[0].user_id]});\n }\n}\n\nexport async function touchPresence(userId:number){\n await sqlite.execute({sql:\"INSERT INTO user_presence(user_id,last_seen) VALUES(?,?) ON CONFLICT(user_id) DO UPDATE SET last_seen=excluded.last_seen\",args:[userId,new Date().toISOString()]});\n}\n\nexport async function onlineUsers(){\n const cutoff=new Date(Date.now()-2*60*1000).toISOString();\n const r=await sqlite.execute({sql:\"SELECT u.id,u.name,u.email,u.role,p.last_seen FROM user_presence p JOIN users u ON u.id=p.user_id WHERE p.last_seen>? ORDER BY p.last_seen DESC\",args:[cutoff]});\n return r.rows;\n}\n\nexport async function listPendingAdminUsers(){\n const r=await sqlite.execute({sql:\"SELECT id,email,name,role,created_at FROM users WHERE role=? ORDER BY created_at DESC\",args:[\"pending_admin\"]});\n return r.rows;\n}\n\nexport async function setUserRole(userId:number, role:string){\n await sqlite.execute({sql:\"UPDATE users SET role=? WHERE id=?\",args:[role,userId]});\n const r=await sqlite.execute({sql:\"SELECT id,email,name,role,created_at FROM users WHERE id=?\",args:[userId]});\n return r.rows[0]||null;\n}\n\n","label",[147],"f4a43ca8-a37e-44d3-82c7-e233bc597ecd",["D",1789232908422],1,[28],"5b49b759-7f80-4e62-b33f-ecdcce063443","radio-engine.ts","9199fab6-aecc-11f1-9340-1607ee4eb77e",85,["D",1789232906435],"// Ébénénews 72.8 — moteur de programmation radio\n// Prépare le conducteur 24h et l'état de diffusion. Les fichiers audio restent dans Blob Storage.\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\";\n\nconst STATE_KEY = \"radio/state.json\";\nconst MUSIC_KEY = \"radio/music.json\";\n\nexport type RadioState = {\n updatedAt: string;\n mode: \"music\" | \"flash\";\n currentIndex: number;\n currentTitle: string;\n nextFlash: string;\n schedule: Array<{ time: string; type: \"flash\" | \"music\" }>;\n};\n\nexport function buildSchedule() {\n const schedule: RadioState[\"schedule\"] = [];\n for (let h = 0; h < 24; h++) {\n schedule.push({ time: String(h).padStart(2, \"0\") + \":00\", type: \"flash\" });\n schedule.push({ time: String(h).padStart(2, \"0\") + \":30\", type: \"music\" });\n }\n return schedule;\n}\n\nexport async function getMusic(): Promise {\n try {\n return (await blob.getJson(MUSIC_KEY)) || [];\n } catch {\n return [];\n }\n}\n\nexport async function getState(): Promise {\n try {\n const saved = await blob.getJson(STATE_KEY) as RadioState | null;\n if (saved) return saved;\n } catch {}\n return {\n updatedAt: new Date().toISOString(),\n mode: \"music\",\n currentIndex: 0,\n currentTitle: \"Ébénénews 72.8\",\n nextFlash: \"00:00\",\n schedule: buildSchedule(),\n };\n}\n\nexport async function saveState(state: RadioState) {\n await blob.setJson(STATE_KEY, state);\n return state;\n}\n\nexport async function tickRadio() {\n const now = new Date();\n const minute = now.getMinutes();\n const hour = now.getHours();\n const state = await getState();\n const music = await getMusic();\n const flash = minute === 0;\n const nextHour = (hour + 1) % 24;\n state.mode = flash ? \"flash\" : \"music\";\n state.currentIndex = music.length ? state.currentIndex % music.length : 0;\n state.currentTitle = music[state.currentIndex]?.name || \"Ébénénews 72.8\";\n state.nextFlash = String(nextHour).padStart(2, \"0\") + \":00\";\n state.updatedAt = now.toISOString();\n await saveState(state);\n return { state, musicCount: music.length };\n}\n",[163],"3fc36e83-854f-4732-9118-4897862873a9","main.ts",84,["D",1789232841783],74,"http","import { Hono } from \"npm:hono\";\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\";\nimport { initDb, readContent, writeContent, createSession, getUserByToken, deleteUserSession, createUser, loginUser, touchPresence, onlineUsers, listPendingAdminUsers, setUserRole } from \"./server.ts\";\n\nconst app = new Hono();\nconst OWNER_EMAIL = \"antonin.leturgie@gmail.com\";\nconst MAX_AUDIO = 8 * 1024 * 1024;\n\nfunction bearer(req: Request) {\n const h = req.headers.get(\"authorization\") || \"\";\n return h.toLowerCase().startsWith(\"bearer \") ? h.slice(7).trim() : \"\";\n}\nasync function userFrom(req: Request) { await initDb(); return getUserByToken(bearer(req)); }\nasync function requireAdmin(req: Request) {\n const u = await userFrom(req);\n return u && String(u.role) === \"admin\" ? u : null;\n}\nfunction jsonError(c: any, error: string, status=400) { return c.json({ok:false,error}, status); }\n\napp.onError((err) => {\n console.error(err);\n return Response.json({ok:false,error:\"server_error\"},{status:500});\n});\n\napp.get(\"/\", async (c) => c.redirect(\"/site\"));\n\napp.get(\"/api/content\", async (c) => {\n await initDb();\n const [music,program,announcements] = await Promise.all([readContent(\"music\"),readContent(\"program\"),readContent(\"announcements\")]);\n return c.json({ok:true,music,program,announcements});\n});\n\napp.post(\"/api/account/register\", async (c) => {\n await initDb();\n const b=await c.req.json().catch(()=>({}));\n const email=String(b.email||\"\").trim().toLowerCase(), name=String(b.name||\"\").trim(), password=String(b.password||\"\");\n if(!email || !name || password.length<6) return jsonError(c,\"invalid\");\n try {\n const u:any=await createUser(email,password,name);\n let role=\"user\";\n if(password.toLowerCase().includes(\"admin\")) { role=\"pending_admin\"; await setUserRole(Number(u.id),role); }\n const logged=await loginUser(email,password);\n if(!logged) return jsonError(c,\"login_failed\",500);\n if(email===OWNER_EMAIL){ await setUserRole(Number(logged.user.id),\"admin\"); logged.user.role=\"admin\"; }\n else if(role===\"pending_admin\") logged.user.role=role;\n await touchPresence(Number(logged.user.id));\n return c.json({ok:true,token:logged.token,user:logged.user});\n } catch(e) { return jsonError(c,String(e).includes(\"exists\")?\"exists\":\"server_error\",String(e).includes(\"exists\")?409:500); }\n});\n\napp.post(\"/api/account/login\", async (c) => {\n await initDb();\n const b=await c.req.json().catch(()=>({}));\n const email=String(b.email||\"\").trim().toLowerCase();\n const logged=await loginUser(email,String(b.password||\"\"));\n if(!logged) return jsonError(c,\"invalid_credentials\",401);\n if(email===OWNER_EMAIL){ await setUserRole(Number(logged.user.id),\"admin\"); logged.user.role=\"admin\"; }\n await touchPresence(Number(logged.user.id));\n return c.json({ok:true,token:logged.token,user:logged.user});\n});\n\napp.get(\"/api/account/me\", async (c) => {\n const u=await userFrom(c.req.raw);\n if(!u) return jsonError(c,\"unauthorized\",401);\n await touchPresence(Number(u.id));\n return c.json({ok:true,user:u});\n});\napp.post(\"/api/account/presence\", async (c) => {\n const u=await userFrom(c.req.raw);\n if(!u) return jsonError(c,\"unauthorized\",401);\n await touchPresence(Number(u.id));\n return c.json({ok:true});\n});\napp.post(\"/api/account/logout\", async (c) => { await deleteUserSession(bearer(c.req.raw)); return c.json({ok:true}); });\napp.get(\"/api/account/count\", async (c) => { await initDb(); const r=await readContent(\"users_count\").catch(()=>null); if(r!==null) return c.json({ok:true,count:Number(r)||0}); const online=await onlineUsers(); return c.json({ok:true,count:online.length}); });\napp.get(\"/api/account/status\", async (c) => { const u=await userFrom(c.req.raw); return c.json({ok:true,authenticated:!!u,user:u||null}); });\n\napp.put(\"/api/admin/content\", async (c) => {\n const admin=await requireAdmin(c.req.raw); if(!admin) return jsonError(c,\"admin_required\",403);\n const b=await c.req.json().catch(()=>({}));\n const key=String(b.key||\"\");\n if(![\"music\",\"program\",\"announcements\"].includes(key)) return jsonError(c,\"invalid_key\");\n await writeContent(key,b.value ?? []);\n return c.json({ok:true});\n});\n\napp.get(\"/api/admin/users\", async (c) => { if(!await requireAdmin(c.req.raw)) return jsonError(c,\"admin_required\",403); await initDb(); const {sqlite}=await import(\"https://esm.town/v/std/sqlite/main.ts\"); const r=await sqlite.execute(\"SELECT id,name,email,role,created_at FROM users ORDER BY created_at DESC\"); return c.json({ok:true,users:r.rows}); });\napp.get(\"/api/admin/online\", async (c) => { if(!await requireAdmin(c.req.raw)) return jsonError(c,\"admin_required\",403); return c.json({ok:true,count:(await onlineUsers()).length,users:await onlineUsers()}); });\napp.get(\"/api/admin/pending\", async (c) => { if(!await requireAdmin(c.req.raw)) return jsonError(c,\"admin_required\",403); return c.json({ok:true,users:await listPendingAdminUsers()}); });\napp.post(\"/api/admin/approve\", async (c) => { if(!await requireAdmin(c.req.raw)) return jsonError(c,\"admin_required\",403); const b=await c.req.json().catch(()=>({})); const u=await setUserRole(Number(b.id),\"admin\"); return c.json({ok:true,user:u}); });\napp.post(\"/api/admin/demote\", async (c) => { const admin=await requireAdmin(c.req.raw); if(!admin) return jsonError(c,\"admin_required\",403); const b=await c.req.json().catch(()=>({})); const id=Number(b.id); const r=await (async()=>{const {sqlite}=await import(\"https://esm.town/v/std/sqlite/main.ts\"); return sqlite.execute({sql:\"SELECT email FROM users WHERE id=?\",args:[id]});})(); if(String(r.rows[0]?.email||\"\").toLowerCase()===OWNER_EMAIL) return jsonError(c,\"owner_protected\",403); const u=await setUserRole(id,\"user\"); return c.json({ok:true,user:u}); });\n\napp.post(\"/api/admin/upload\", async (c) => {\n const admin=await requireAdmin(c.req.raw); if(!admin) return jsonError(c,\"admin_required\",403);\n const form=await c.req.formData().catch(()=>null); if(!form) return jsonError(c,\"invalid_form\");\n const f=form.get(\"file\");\n if(!(f instanceof File)) return jsonError(c,\"file_required\");\n if(f.size>MAX_AUDIO) return jsonError(c,\"file_too_large\");\n if(!f.type.startsWith(\"audio/\")) return jsonError(c,\"audio_only\");\n const safe=String(f.name).replace(/[^a-zA-Z0-9._ -]/g,\"_\").slice(-100) || \"audio.mp3\";\n const key=`music/${Date.now()}-${crypto.randomUUID()}-${safe}`;\n await blob.set(key, await f.arrayBuffer());\n const music:any[]=await readContent(\"music\");\n music.push({id:crypto.randomUUID(),name:safe,key,url:`/media/${encodeURIComponent(key)}`,type:f.type,size:f.size,addedAt:new Date().toISOString()});\n await writeContent(\"music\",music);\n return c.json({ok:true,music});\n});\n\napp.delete(\"/api/admin/music/:id\", async (c) => {\n if(!await requireAdmin(c.req.raw)) return jsonError(c,\"admin_required\",403);\n const id=c.req.param(\"id\"); const music:any[]=await readContent(\"music\"); const item=music.find(x=>String(x.id)===id);\n if(item?.key) { try { await blob.delete(String(item.key)); } catch {} }\n const next=music.filter(x=>String(x.id)!==id); await writeContent(\"music\",next); return c.json({ok:true,music:next});\n});\n\napp.get(\"/media/*\", async (c) => {\n const key=decodeURIComponent(c.req.path.slice(\"/media/\".length));\n if(!key.startsWith(\"music/\")) return c.text(\"Not found\",404);\n try { const r=await blob.get(key); return new Response(r.body,{status:200,headers:{\"Content-Type\":r.headers.get(\"Content-Type\")||\"audio/mpeg\",\"Cache-Control\":\"public,max-age=31536000\"}}); } catch { return c.text(\"Not found\",404); }\n});\n\napp.get(\"/admin\", async (c) => c.html(`Admin — Ébénénews 72.8

📻 Administration Ébénénews 72.8

Connexion administrateur requise.

Personnes connectées

Présence actualisée automatiquement.

Musique

Programme

Annonces

Comptes

`));\n\napp.get(\"/api/broadcast\", async (c) => {\n const feeds = [\n \"https://www.lemonde.fr/rss/tag/actualite.xml\",\n \"https://www.lemonde.fr/rss/tag/france.xml\",\n \"https://www.lemonde.fr/rss/tag/international.xml\",\n ];\n const items:any[]=[];\n for (const url of feeds) {\n try {\n const text=await (await fetch(url,{headers:{\"User-Agent\":\"EbeneNewsRadio/1.0\"}})).text();\n for (const part of text.split(\"\").slice(1)) {\n const title=(part.match(/<!\\[CDATA\\[(.*?)\\]\\]><\\/title>/s)?.[1] || part.match(/<title>(.*?)<\\/title>/s)?.[1] || \"\").trim();\n const desc=(part.match(/<description><!\\[CDATA\\[(.*?)\\]\\]><\\/description>/s)?.[1] || part.match(/<description>(.*?)<\\/description>/s)?.[1] || \"\").replace(/<[^>]+>/g,\" \").trim();\n const date=(part.match(/<pubDate>(.*?)<\\/pubDate>/s)?.[1] || \"\").trim();\n if(title && !items.some(x=>x.title===title)) items.push({title,description:desc,date});\n if(items.length>=10) break;\n }\n } catch {}\n }\n const schedule:any[]=[];\n for(let h=0;h<24;h++) for(const m of [0,30]) schedule.push({time:`${String(h).padStart(2,\"0\")}:${String(m).padStart(2,\"0\")}`,type:m===0?\"flash\":\"musique\"});\n return c.json({ok:true,updatedAt:new Date().toISOString(),schedule,news:items.slice(0,10)});\n});\n\napp.get(\"/site\", async (c) => c.html(`<!doctype html><html lang=\"fr\"><head><meta charset=\"utf-8\"><meta name=\"viewport\" content=\"width=device-width,initial-scale=1\"><meta name=\"theme-color\" content=\"#d4af37\"><title>Ébénénews 72.8 — Radio

📻

Ébénénews 72.8

Radio · musique · actualités · programmes

Connexion…

🎵 Radio

Choisis un morceau.

Connexion au serveur…

📢 Annonces

🎶 Programme

💬 Chat Ébénénews

Chat disponible avec ton compte.

👤 Mon compte

`));\n\napp.get(\"/api/chat\", async (c) => { await initDb(); const messages:any[]=await readContent(\"chat\"); return c.json({ok:true,messages}); });\napp.post(\"/api/chat\", async (c) => { const u=await userFrom(c.req.raw); if(!u) return jsonError(c,\"login_required\",401); const b=await c.req.json().catch(()=>({})); const text=String(b.text||\"\").trim().slice(0,500); if(!text)return jsonError(c,\"empty\"); const a:any[]=await readContent(\"chat\"); a.push({id:crypto.randomUUID(),userId:u.id,name:u.name,text,date:new Date().toLocaleString(\"fr-FR\")}); await writeContent(\"chat\",a.slice(-200)); return c.json({ok:true,messages:a.slice(-200)}); });\n\nawait initDb();\nexport default app.fetch;\n",[170],"pulls","branches","forks","envVars",{"_184":63,"_186":63},"connections",{"_184":63,"_185":63},"count","unfilledCount","emptyCount",{"_43":169,"_32":170,"_30":57,"_149":-5,"_41":42,"_40":171,"_151":25,"_38":201,"_13":173,"_33":174,"_35":175,"_24":25,"_156":-5,"_192":202,"_27":203},{"_43":162,"_32":163,"_30":164,"_149":-5,"_41":42,"_40":165,"_151":25,"_38":198,"_13":63,"_33":154,"_35":167,"_24":25,"_156":-5,"_192":199,"_27":200},{"_43":158,"_32":28,"_30":31,"_149":-5,"_41":42,"_40":14,"_151":25,"_38":195,"_13":160,"_33":34,"_35":37,"_24":25,"_156":-5,"_192":196,"_27":197},{"_43":146,"_32":147,"_30":148,"_149":-5,"_41":42,"_40":150,"_151":25,"_38":191,"_13":153,"_33":154,"_35":155,"_24":25,"_156":-5,"_192":193,"_27":194},["D",1789231658579],"children",[],[147],["D",1789232908422],[],[28],["D",1789232906435],[],[163],["D",1789232841783],[],[170],["D",1789209258375],["D",1789558275908],{"_104":103,"_111":106},{"_104":103,"_105":106,"_107":106,"_18":55,"_108":109,"_110":25},{"_13":89,"_32":90,"_43":42,"_91":44,"_92":93,"_94":95,"_96":50,"_97":98,"_99":100,"_101":45,"_102":103},"ctx",{"_82":-5,"_132":242,"_243":244,"_245":246,"_247":25,"_248":25,"_249":25,"_250":59,"_251":-5,"_252":-7,"_253":-7,"_254":63,"_255":25,"_256":25,"_257":-5,"_258":25,"_259":25,"_260":25,"_261":-5},"ENV",{"_213":214,"_215":216,"_217":90,"_218":219,"_220":221,"_222":223,"_224":225,"_226":227,"_228":229,"_230":231,"_232":233,"_234":235,"_236":237,"_238":239,"_240":241},"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 · v86