[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_211":212,"_213":214},"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",131,"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","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\nlet dbReady:Promise|null=null;\nexport function initDb(){\n if(dbReady)return dbReady;\n dbReady=(async()=>{\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 return dbReady;\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","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nlet dbReady:Promise|null=null;\nexport function initDb(){\n if(dbReady)return dbReady;\n dbReady=(async()=>{\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 await sqlite.execute({sql:`UPDATE users SET role='admin' WHERE lower(email)=lower(?)`,args:[\"antonin.leturgie@gmail.com\"]});\n })();\n return dbReady;\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","createdAt",["D",1789400914669],"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",1789471840176],"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":206,"_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":207,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":208,"_84":209,"_86":210,"_88":25},"tree",[189,190,191,192],"files",[189,190,191,192],"counts",{"_178":63,"_179":180,"_181":63,"_182":183,"_184":185},"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":170,"_32":171,"_30":57,"_147":-5,"_41":42,"_40":172,"_148":25,"_38":173,"_13":174,"_33":175,"_35":176,"_24":25,"_151":-5,"_27":177},{"_43":162,"_32":163,"_30":164,"_147":-5,"_41":42,"_40":165,"_148":59,"_38":166,"_13":167,"_33":34,"_35":168,"_24":25,"_151":-5,"_27":169},{"_43":153,"_32":154,"_30":155,"_147":-5,"_41":42,"_40":156,"_148":59,"_38":157,"_13":158,"_33":159,"_35":160,"_24":25,"_151":-5,"_27":161},{"_43":146,"_32":28,"_30":31,"_147":-5,"_41":42,"_40":14,"_148":59,"_38":149,"_13":150,"_33":34,"_35":37,"_24":25,"_151":-5,"_27":152},"753017dd-11af-43ae-b751-e3fd04f22758","parentId","latest",["D",1789400914669],10,"label",[28],"8257cf71-2c8a-4c97-b432-47eb6a0f4f8b","schedule.ts","b73cac0c-aeca-11f1-ae3f-1607ee4eb77e",87,["D",1789232910134],2,"interval","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 await tickRadio();\n\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",[154],"e3fb71aa-cc1c-40ae-adda-9a4b1c34804c","radio-engine.ts","9199fab6-aecc-11f1-9340-1607ee4eb77e",126,["D",1789322374463],6,"// Ébénénews 72.8 — moteur radio 24h\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\";\nimport { readContent } from \"./server.ts\";\n\nconst STATE_KEY = \"radio/state.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 out:RadioState[\"schedule\"]=[];\n for(let h=0;h<24;h++){\n out.push({time:`${String(h).padStart(2,\"0\")}:00`,type:\"flash\"});\n out.push({time:`${String(h).padStart(2,\"0\")}:30`,type:\"music\"});\n }\n return out;\n}\n\nexport async function getMusic():Promise{\n try{return (await readContent(\"music\"))||[]}catch{return []}\n}\n\nexport async function getState():Promise{\n try{const saved=await blob.getJSON(STATE_KEY) as RadioState|null;if(saved)return saved}catch{}\n return {updatedAt:new Date().toISOString(),mode:\"music\",currentIndex:0,currentTitle:\"Ébénénews 72.8\",nextFlash:\"00:00\",schedule:buildSchedule()};\n}\n\nexport async function saveState(state:RadioState){await blob.setJSON(STATE_KEY,state);return state;}\n\nexport async function tickRadio(){\n const now=new Date();\n const parts=new Intl.DateTimeFormat(\"fr-FR\",{timeZone:\"Europe/Paris\",hour:\"2-digit\",minute:\"2-digit\",hour12:false}).formatToParts(now);\n const minute=Number(parts.find(p=>p.type===\"minute\")?.value||0);\n const hour=Number(parts.find(p=>p.type===\"hour\")?.value||0);\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 state.schedule=buildSchedule();\n await saveState(state);\n return {state,musicCount:music.length};\n}\n",[163],"2f2f7420-b11b-4c71-b00d-465e96aa8057","main.ts",130,["D",1789400906319],110,"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\";\nimport { getMusic, getState, tickRadio } from \"./radio-engine.ts\";\n\nconst app=new Hono();\nconst OWNER_EMAIL=\"antonin.leturgie@gmail.com\";\nconst MAX_AUDIO=8*1024*1024;\nfunction bearer(req:Request){const h=req.headers.get(\"authorization\")||\"\";return h.toLowerCase().startsWith(\"bearer \")?h.slice(7).trim():\"\"}\nasync function userFrom(req:Request){await initDb();return getUserByToken(bearer(req))}\nasync function requireAdmin(req:Request){const u=await userFrom(req);return u&&String(u.role)===\"admin\"?u:null}\nfunction jsonError(c:any,error:string,status=400){return c.json({ok:false,error},status)}\napp.onError((err)=>{console.error(err);return Response.json({ok:false,error:\"server_error\"},{status:500})});\napp.get(\"/\",async c=>c.redirect(\"/site\"));\napp.get(\"/api/content\",async c=>{await initDb();const [music,program,announcements]=await Promise.all([readContent(\"music\"),readContent(\"program\"),readContent(\"announcements\")]);return c.json({ok:true,music,program,announcements})});\napp.get(\"/api/radio-state\",async c=>{const result=await tickRadio();return c.json({ok:true,...result,serverTime:new Date().toISOString()})});\napp.get(\"/api/health\",async c=>{await initDb();const state=await getState();const music=await getMusic();return c.json({ok:true,service:\"ebenenews-72-8\",radio:state.mode,musicCount:music.length,time:new Date().toISOString()})});\napp.post(\"/api/account/register\",async c=>{await initDb();const b=await c.req.json().catch(()=>({}));const email=String(b.email||\"\").trim().toLowerCase(),name=String(b.name||\"\").trim(),password=String(b.password||\"\");if(!email||!name||password.length<6)return jsonError(c,\"invalid\");try{const u:any=await createUser(email,password,name);const logged=await loginUser(email,password);if(!logged)return jsonError(c,\"login_failed\",500);if(email===OWNER_EMAIL){await setUserRole(Number(logged.user.id),\"admin\");logged.user.role=\"admin\"}await touchPresence(Number(logged.user.id));return c.json({ok:true,token:logged.token,user:logged.user})}catch(e){return jsonError(c,String(e).includes(\"exists\")?\"exists\":\"server_error\",String(e).includes(\"exists\")?409:500)}});\napp.post(\"/api/account/login\",async c=>{await initDb();const b=await c.req.json().catch(()=>({}));const email=String(b.email||\"\").trim().toLowerCase();const logged=await loginUser(email,String(b.password||\"\"));if(!logged)return jsonError(c,\"invalid_credentials\",401);if(email===OWNER_EMAIL){await setUserRole(Number(logged.user.id),\"admin\");logged.user.role=\"admin\"}await touchPresence(Number(logged.user.id));return c.json({ok:true,token:logged.token,user:logged.user})});\napp.get(\"/api/account/me\",async c=>{const u=await userFrom(c.req.raw);if(!u)return jsonError(c,\"unauthorized\",401);await touchPresence(Number(u.id));return c.json({ok:true,user:u})});\napp.post(\"/api/account/presence\",async c=>{const u=await userFrom(c.req.raw);if(!u)return jsonError(c,\"unauthorized\",401);await touchPresence(Number(u.id));return c.json({ok:true})});\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 {sqlite}=await import(\"https://esm.town/v/std/sqlite/main.ts\");const r=await sqlite.execute(\"SELECT COUNT(*) AS count FROM users\");return c.json({ok:true,count:Number(r.rows[0]?.count||0)})});\napp.get(\"/api/account/status\",async c=>{const u=await userFrom(c.req.raw);return c.json({ok:true,authenticated:!!u,user:u||null})});\napp.put(\"/api/admin/content\",async c=>{if(!await requireAdmin(c.req.raw))return jsonError(c,\"admin_required\",403);const b=await c.req.json().catch(()=>({}));const key=String(b.key||\"\");if(![\"music\",\"program\",\"announcements\"].includes(key))return jsonError(c,\"invalid_key\");await writeContent(key,b.value??[]);if(key===\"music\")await blob.setJSON(\"radio/music.json\",b.value??[]);return c.json({ok:true})});\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);const users=await onlineUsers();return c.json({ok:true,count:users.length,users})});\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})});\napp.post(\"/api/admin/upload\",async c=>{const admin=await requireAdmin(c.req.raw);if(!admin)return jsonError(c,\"admin_required\",403);const form=await c.req.formData().catch(()=>null);if(!form)return jsonError(c,\"invalid_form\");const f=form.get(\"file\");if(!(f instanceof File))return jsonError(c,\"file_required\");if(f.size>MAX_AUDIO)return jsonError(c,\"file_too_large\");if(!f.type.startsWith(\"audio/\"))return jsonError(c,\"audio_only\");const safe=String(f.name).replace(/[^a-zA-Z0-9._ -]/g,\"_\").slice(-100)||\"audio.mp3\";const key=`music/${Date.now()}-${crypto.randomUUID()}-${safe}`;await blob.set(key,await f.arrayBuffer());const music:any[]=await readContent(\"music\");music.push({id:crypto.randomUUID(),name:safe,key,url:`/media/${encodeURIComponent(key)}`,type:f.type,size:f.size,addedAt:new Date().toISOString()});await writeContent(\"music\",music);await blob.setJSON(\"radio/music.json\",music);return c.json({ok:true,music})});\napp.delete(\"/api/admin/music/:id\",async c=>{if(!await requireAdmin(c.req.raw))return jsonError(c,\"admin_required\",403);const id=c.req.param(\"id\");const music:any[]=await readContent(\"music\");const item=music.find(x=>String(x.id)===id);if(item?.key){try{await blob.delete(String(item.key))}catch{}}const next=music.filter(x=>String(x.id)!==id);await writeContent(\"music\",next);await blob.setJSON(\"radio/music.json\",next);return c.json({ok:true,music:next})});\napp.get(\"/media/*\",async c=>{const key=decodeURIComponent(c.req.path.slice(\"/media/\".length));if(!key.startsWith(\"music/\"))return c.text(\"Not found\",404);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)}});\nlet broadcastCache:any[]=[];let broadcastCacheAt=0;let broadcastBusy:Promise|null=null;async function fetchBroadcast(){const feeds=[\"https://www.lemonde.fr/rss/tag/actualite.xml\",\"https://www.lemonde.fr/rss/tag/france.xml\",\"https://www.lemonde.fr/rss/tag/international.xml\"];const items:any[]=[];for(const url of feeds){try{const text=await(await fetch(url,{headers:{\"User-Agent\":\"EbeneNewsRadio/1.0\"}})).text();for(const part of text.split(\"\").slice(1)){const title=(part.match(/<!\\[CDATA\\[(.*?)\\]\\]><\\/title>/s)?.[1]||part.match(/<title>(.*?)<\\/title>/s)?.[1]||\"\").trim();const desc=(part.match(/<description><!\\[CDATA\\[(.*?)\\]\\]><\\/description>/s)?.[1]||part.match(/<description>(.*?)<\\/description>/s)?.[1]||\"\").replace(/<[^>]+>/g,\" \").trim();const date=(part.match(/<pubDate>(.*?)<\\/pubDate>/s)?.[1]||\"\").trim();if(title&&!items.some(x=>x.title===title))items.push({title,description:desc,date});if(items.length>=10)break}}catch{}}return items.slice(0,10)}\napp.get(\"/api/broadcast\",async c=>{const now=Date.now();if(now-broadcastCacheAt<60000)return c.json({ok:true,updatedAt:new Date(broadcastCacheAt).toISOString(),news:broadcastCache});if(!broadcastBusy){broadcastBusy=fetchBroadcast().then(x=>{broadcastCache=x;broadcastCacheAt=Date.now();return x}).finally(()=>{broadcastBusy=null})}const news=await broadcastBusy;return c.json({ok:true,updatedAt:new Date(broadcastCacheAt).toISOString(),news})});\napp.get(\"/api/chat\",async c=>{await initDb();return c.json({ok:true,messages:await readContent(\"chat\")})});\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,role:u.role,text,date:new Date().toLocaleString(\"fr-FR\")});await writeContent(\"chat\",a.slice(-200));return c.json({ok:true,messages:a.slice(-200)})});\napp.post(\"/api/admin/chat\",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 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:admin.id,name:admin.name,role:\"admin\",text,date:new Date().toLocaleString(\"fr-FR\")});await writeContent(\"chat\",a.slice(-200));return c.json({ok:true,messages:a.slice(-200)})});\napp.delete(\"/api/admin/chat/:id\",async c=>{if(!await requireAdmin(c.req.raw))return jsonError(c,\"admin_required\",403);const id=c.req.param(\"id\");const a:any[]=await readContent(\"chat\");await writeContent(\"chat\",a.filter((x:any)=>String(x.id)!==id));return c.json({ok:true})});\napp.get(\"/admin\",async c=>c.html(`<!doctype html><html lang=\"fr\"><head><meta charset=\"utf-8\"><meta name=\"viewport\" content=\"width=device-width,initial-scale=1\"><title>Admin — Ébénénews 72.8

📻 Administration Ébénénews 72.8

Connexion administrateur requise.

Personnes connectées

Actualisation automatique.

Musique

Programme

Annonces

Comptes

Chat

`));\napp.get(\"/site\",async c=>c.html(`Ébénénews 72.8 — Radio

📻

Ébénénews 72.8

Radio · musique · actualités · programmes

Connexion…

🎵 Radio

Aucune musique chargée.

Connexion…

📢 Actualités

🎶 Programme

💬 Chat Ébénénews

👤 Mon compte

`));\nawait initDb();\nexport default app.fetch;\n",[171],"pulls","branches",1,"forks","envVars",{"_186":63,"_188":63},"connections",{"_186":63,"_187":63},"count","unfilledCount","emptyCount",{"_43":170,"_32":171,"_30":57,"_147":-5,"_41":42,"_40":172,"_148":25,"_38":203,"_13":174,"_33":175,"_35":176,"_24":25,"_151":-5,"_194":204,"_27":205},{"_43":162,"_32":163,"_30":164,"_147":-5,"_41":42,"_40":165,"_148":59,"_38":200,"_13":167,"_33":34,"_35":168,"_24":25,"_151":-5,"_194":201,"_27":202},{"_43":153,"_32":154,"_30":155,"_147":-5,"_41":42,"_40":156,"_148":59,"_38":197,"_13":158,"_33":159,"_35":160,"_24":25,"_151":-5,"_194":198,"_27":199},{"_43":146,"_32":28,"_30":31,"_147":-5,"_41":42,"_40":14,"_148":59,"_38":193,"_13":150,"_33":34,"_35":37,"_24":25,"_151":-5,"_194":195,"_27":196},["D",1789400914669],"children",[],[28],["D",1789232910134],[],[154],["D",1789322374463],[],[163],["D",1789400906319],[],[171],["D",1789209258375],["D",1789471840176],{"_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":244,"_245":246,"_247":248,"_249":25,"_250":25,"_251":25,"_252":59,"_253":-5,"_254":-7,"_255":-7,"_256":63,"_257":25,"_258":25,"_259":-5,"_260":25,"_261":25,"_262":25,"_263":-5},"ENV",{"_215":216,"_217":218,"_219":90,"_220":221,"_222":223,"_224":225,"_226":227,"_228":229,"_230":231,"_232":233,"_234":235,"_236":237,"_238":239,"_240":241,"_242":243},"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 · v131