[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_195":196,"_197":198},"routes/_app.x.$handle.$name",{"_102":101,"_31":43,"_110":88,"_26":104,"_13":14,"_111":-5,"_11":112,"_113":114,"_115":116,"_117":118,"_119":120,"_20":-5,"_121":122,"_123":124,"_125":24,"_126":127,"_128":57,"_129":-5,"_130":-5,"_131":132},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_41":42,"_31":43,"_36":44,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":51,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":81,"_82":83,"_84":85,"_86":24},"version",63,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":27,"_32":33,"_34":35,"_36":37,"_38":14,"_39":40,"_23":24},"previous","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","createdAt",["D",1789232110569],"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",{"_102":101,"_109":104},"org",{"_102":101,"_103":104,"_105":104,"_18":53,"_106":107,"_108":24},"branch",{"_13":87,"_31":88,"_41":40,"_89":42,"_90":91,"_92":93,"_94":48,"_95":96,"_97":98,"_99":43,"_100":101},"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",{"_41":42,"_31":43,"_36":190,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":51,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":191,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":192,"_82":193,"_84":194,"_86":24},"tree",[177,178,179],"files",[177,178,179],"counts",{"_166":61,"_167":168,"_169":61,"_170":171,"_172":173},"contents",[140,141,142],"upstreamProject",{"_41":96,"_31":43,"_50":51,"_52":-5,"_47":48,"_80":139},"upstreamBranch",{"_41":91,"_36":133,"_134":135,"_31":88,"_89":96,"_13":93,"_90":-5,"_92":-5,"_136":137,"_45":-5,"_86":24,"_47":48,"_100":138,"_62":98,"_99":43},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1788040586645],"updatedAt",["D",1789208224644],"lockfileKey","1789208224729-esm.town_v_chezlanoisette_ebenenews-radio@11-main","chezlanoisette",{"_102":138,"_109":104},{"_41":158,"_31":159,"_29":55,"_146":-5,"_39":40,"_38":160,"_148":24,"_36":161,"_13":162,"_32":163,"_34":164,"_23":24,"_153":-5,"_26":165},{"_41":155,"_31":27,"_29":30,"_146":-5,"_39":40,"_38":14,"_148":24,"_36":156,"_13":61,"_32":33,"_34":35,"_23":24,"_153":-5,"_26":157},{"_41":143,"_31":144,"_29":145,"_146":-5,"_39":40,"_38":147,"_148":24,"_36":149,"_13":150,"_32":151,"_34":152,"_23":24,"_153":-5,"_26":154},"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",[144],"dce72d85-1f43-414d-8e97-830dceb35e10",["D",1789232110569],[27],"517f6f2d-22c7-44df-b9e7-475c9b9b7908","main.ts",62,["D",1789232094713],53,"http","import { Hono } from \"npm:hono\";\nimport { email } from \"https://esm.town/v/std/email\";\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\";\nimport { getOAuthUserData, oauthMiddleware } from \"https://esm.town/v/std/oauth/middleware.ts\";\nimport { initDb, readContent, writeContent, createSession, validSession, deleteSession, createUser, loginUser, getUserByToken, deleteUserSession, setUserRole, listPendingAdminUsers, touchPresence, onlineUsers } from \"./server.ts\";\n\nconst OWNER = \"ninjantox\";\nconst OWNER_EMAIL = \"antonin.leturgie@gmail.com\";\nconst GITHUB_INDEX = \"https://raw.githubusercontent.com/antoninleturgie-arch/ebenenews-radio/main/radio.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}\nfunction userToken(req: Request) { return tokenFrom(req); }\nasync function requireAdmin(req: Request) { const token=tokenFrom(req); if(!token) return false; if(await validSession(token)) return true; const user=await getUserByToken(token); return String(user?.role||\"\")===\"admin\"; }\n\napp.get(\"/\", async (c) => {\n await initDb();\n const [music, program, announcements] = await Promise.all([readContent(\"music\"), readContent(\"program\"), readContent(\"announcements\")]);\n return c.html(`Ébénénews 72.8

📻 Ébénénews 72.8

Serveur actif

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

`);\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 Ébénénews.\", 502);\n let html = await r.text();\n const start = html.indexOf(\"function envoyerAnnonce() {\");\n const end = html.indexOf(\"function getAnnouncements() {\", start);\n if (start >= 0 && end > start) {\n const clean = `function envoyerAnnonce() {\n if(!isAdmin()) { alert('❌ Admin uniquement !'); return; }\n const input = document.getElementById(\"annonceText\");\n const text = input ? input.value.trim() : \"\";\n if(!text) return;\n const announcements = getAnnouncements();\n announcements.unshift({text, date:new Date().toLocaleString('fr-FR')});\n saveAnnouncements(announcements);\n if(typeof displayAnnouncements === 'function') displayAnnouncements();\n if(input) input.value = \"\";\n alert(\"✅ Annonce envoyée !\");\n}\n\n`;\n html = html.slice(0, start) + clean + html.slice(end);\n }\n\n const bridge = ``;\n html = html.replace(\"\", bridge + \"\");\n return c.html(html);\n});\n\napp.get(\"/api/content\", async (c) => { await initDb(); return c.json({ok:true,music:await readContent(\"music\"),program:await readContent(\"program\"),announcements:await readContent(\"announcements\")}); });\n\napp.post(\"/api/admin/upload\", async (c) => {\n await initDb();\n if (!(await requireAdmin(c.req.raw))) return c.json({ok:false,error:\"admin_required\"},401);\n const form = await c.req.parseBody();\n const file = form.file;\n if (!(file instanceof File)) return c.json({ok:false,error:\"file_required\"},400);\n if (file.size > 10 * 1024 * 1024) return c.json({ok:false,error:\"file_too_large\"},413);\n if (!String(file.type||\"\").startsWith(\"audio/\")) return c.json({ok:false,error:\"audio_only\"},400);\n const safe = file.name.replace(/[^a-zA-Z0-9._-]/g,\"_\").slice(-120) || \"audio.mp3\";\n const key = `music/${crypto.randomUUID()}-${safe}`;\n await blob.set(key, file);\n const music = await readContent(\"music\");\n music.push({name:file.name,type:\"audio\",url:`/media/${encodeURIComponent(key)}`,key,addedAt:new Date().toISOString()});\n await writeContent(\"music\",music);\n return c.json({ok:true,music,uploaded:{name:file.name,key,url:`/media/${encodeURIComponent(key)}`}});\n});\n\napp.get(\"/media/*\", async (c) => {\n const key = decodeURIComponent(new URL(c.req.url).pathname.slice(\"/media/\".length));\n if (!key.startsWith(\"music/\")) return c.notFound();\n try {\n const r = await blob.get(key);\n const headers = new Headers(r.headers);\n headers.set(\"Cache-Control\",\"public, max-age=31536000, immutable\");\n return new Response(r.body,{status:200,headers});\n } catch { return c.notFound(); }\n});\n\napp.post(\"/api/account/register\", async (c) => {\n await initDb();\n const body=await c.req.json().catch(()=>null);\n try {\n const user=await createUser(body?.email,body?.password,body?.name);\n const wantsAdmin=String(body?.password||\"\").toLowerCase().includes(\"admin\");\n if(wantsAdmin) await setUserRole(Number(user.id),\"pending_admin\");\n const login=await loginUser(body.email,body.password);\n if(!login) return c.json({ok:false,error:\"login_failed\"},500);\n const emailAddress=String(body.email||\"\").trim().toLowerCase();\n const ownerEmail=OWNER_EMAIL;\n if(wantsAdmin) {\n try { await email({to:ownerEmail,subject:\"Ébénénews — demande à vérifier\",text:`Nouveau compte à vérifier.\\nPseudo : ${String(body?.name||\"\").trim()}\\nEmail : ${emailAddress}\\nNe partage jamais le mot de passe dans cet e-mail.`}); }\n catch(e) { console.error(\"Email admin verification failed\",e); }\n }\n return c.json({ok:true,token:login.token,user});\n } catch(e) {\n const msg=String(e?.message||e);\n if(msg===\"exists\") return c.json({ok:false,error:\"exists\"},409);\n if(msg===\"invalid\") return c.json({ok:false,error:\"invalid\"},400);\n return c.json({ok:false,error:\"server_error\"},500);\n }\n});\n\napp.post(\"/api/account/login\", async (c) => {\n await initDb();\n const body=await c.req.json().catch(()=>null);\n if(!body?.email || !body?.password) return c.json({ok:false,error:\"invalid\"},400);\n const result=await loginUser(body.email,body.password);\n if(!result) return c.json({ok:false,error:\"invalid_credentials\"},401);\n return c.json({ok:true,token:result.token,user:result.user});\n});\n\napp.get(\"/api/account/me\", async (c) => { await initDb(); const user=await getUserByToken(userToken(c.req.raw)); if(!user)return c.json({ok:false},401); await touchPresence(Number(user.id)); return c.json({ok:true,user}); });\napp.post(\"/api/account/presence\", async (c) => { await initDb(); const user=await getUserByToken(userToken(c.req.raw)); if(!user)return c.json({ok:false},401); await touchPresence(Number(user.id)); return c.json({ok:true}); });\napp.get(\"/api/admin/online\", async (c) => { if(!(await requireAdmin(c.req.raw))) return c.json({ok:false,error:\"admin_required\"},401); await initDb(); const users=await onlineUsers(); return c.json({ok:true,count:users.length,users}); });\napp.get(\"/api/admin/users\", async (c) => { if(!(await requireAdmin(c.req.raw))) return c.json({ok:false,error:\"admin_required\"},401); await initDb(); const r=await import(\"https://esm.town/v/std/sqlite/main.ts\").then(m=>m.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.post(\"/api/account/logout\", async (c) => { await deleteUserSession(userToken(c.req.raw)); return c.json({ok:true}); });\napp.get(\"/api/account/count\", async (c) => { await initDb(); const r=await import(\"https://esm.town/v/std/sqlite/main.ts\").then(m=>m.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) => { await initDb(); const user=await getUserByToken(userToken(c.req.raw)); return c.json({ok:!!user,user:user||null,isAdmin:String(user?.role||\"\")===\"admin\"}); });\n\napp.get(\"/admin\", async (c) => {\n const session = await getOAuthUserData(c.req.raw);\n const client = await getUserByToken(userToken(c.req.raw));\n const clientIsAdmin = String(client?.role||\"\")===\"admin\";\n if (!session?.user && !clientIsAdmin) return c.redirect(\"/auth/login?returnTo=/admin\");\n if (session?.user && session.user.username !== OWNER && !clientIsAdmin) return c.text(\"Accès refusé : compte non administrateur.\",403);\n await initDb();\n const token = session?.user ? await createSession() : \"\";\n return c.html(`Admin Ébénénews

📻 Admin Ébénénews 72.8

Connecté en tant que ${session?.user?.username||client?.name||client?.email}.

${token ? 'Jeton serveur :' : 'Administration via ton compte client sécurisé.'}

${token ? ''+token+'

Le jeton expire dans 7 jours.

' : ''}

Demandes d'administration

Chargement…

`);\n});\napp.post(\"/api/admin/promote-owner\", async (c) => {\n const session=await getOAuthUserData(c.req.raw);\n if(!(await requireAdmin(c.req.raw))) return c.json({ok:false,error:\"forbidden\"},403);\n await initDb();\n const r=await import(\"https://esm.town/v/std/sqlite/main.ts\").then(m=>m.sqlite.execute({sql:\"SELECT id FROM users WHERE lower(email)=?\",args:[OWNER_EMAIL.toLowerCase()]}));\n const id=Number(r.rows[0]?.id||0);\n if(!id) return c.json({ok:false,error:\"owner_account_not_found\"},404);\n const user=await setUserRole(id,\"admin\");\n return c.json({ok:true,user});\n});\n\napp.get(\"/api/admin/pending\", async (c) => {\n const session=await getOAuthUserData(c.req.raw);\n if(!(await requireAdmin(c.req.raw))) return c.json({ok:false,error:\"forbidden\"},403);\n await initDb();\n return c.json({ok:true,users:await listPendingAdminUsers()});\n});\n\napp.post(\"/api/admin/approve\", async (c) => {\n const session=await getOAuthUserData(c.req.raw);\n if(!(await requireAdmin(c.req.raw))) return c.json({ok:false,error:\"forbidden\"},403);\n const body=await c.req.json().catch(()=>null);\n const id=Number(body?.id);\n if(!Number.isInteger(id) || id<1) return c.json({ok:false,error:\"invalid\"},400);\n await initDb();\n const user=await setUserRole(id,\"admin\");\n if(!user) return c.json({ok:false,error:\"not_found\"},404);\n return c.json({ok:true,user});\n});\n\n\napp.get(\"/auth/logout-server\", async (c) => { await deleteSession(tokenFrom(c.req.raw)); return c.text(\"Déconnecté\"); });\napp.put(\"/api/admin/content\", async (c) => { await initDb(); if (!(await requireAdmin(c.req.raw))) return c.json({ok:false,error:\"admin_required\"},401); const body=await c.req.json().catch(()=>null); if(!body||![\"music\",\"program\",\"announcements\"].includes(body.key)||!Array.isArray(body.value)) return c.json({ok:false,error:\"invalid_payload\"},400); await writeContent(body.key,body.value); return c.json({ok:true,key:body.key,value:body.value}); });\n\nexport default oauthMiddleware(app.fetch);",[159],"pulls","branches",1,"forks","envVars",{"_174":61,"_176":61},"connections",{"_174":61,"_175":61},"count","unfilledCount","emptyCount",{"_41":158,"_31":159,"_29":55,"_146":-5,"_39":40,"_38":160,"_148":24,"_36":187,"_13":162,"_32":163,"_34":164,"_23":24,"_153":-5,"_181":188,"_26":189},{"_41":155,"_31":27,"_29":30,"_146":-5,"_39":40,"_38":14,"_148":24,"_36":184,"_13":61,"_32":33,"_34":35,"_23":24,"_153":-5,"_181":185,"_26":186},{"_41":143,"_31":144,"_29":145,"_146":-5,"_39":40,"_38":147,"_148":24,"_36":180,"_13":150,"_32":151,"_34":152,"_23":24,"_153":-5,"_181":182,"_26":183},["D",1789231658579],"children",[],[144],["D",1789232110569],[],[27],["D",1789232094713],[],[159],["D",1789209258375],["D",1789558275908],{"_102":101,"_109":104},{"_102":101,"_103":104,"_105":104,"_18":53,"_106":107,"_108":24},{"_13":87,"_31":88,"_41":40,"_89":42,"_90":91,"_92":93,"_94":48,"_95":96,"_97":98,"_99":43,"_100":101},"ctx",{"_80":-5,"_130":228,"_229":230,"_231":232,"_233":24,"_234":24,"_235":24,"_236":57,"_237":-5,"_238":-7,"_239":-7,"_240":61,"_241":24,"_242":24,"_243":-5,"_244":24,"_245":24,"_246":24,"_247":-5},"ENV",{"_199":200,"_201":202,"_203":88,"_204":205,"_206":207,"_208":209,"_210":211,"_212":213,"_214":215,"_216":217,"_218":219,"_220":221,"_222":223,"_224":225,"_226":227},"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 · v63