LiveChat 💬

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_280":281,"_282":283},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_211":-5,"_20":212,"_22":213,"_214":215,"_216":217,"_26":218,"_24":219,"_220":-5,"_221":-5,"_222":54,"_223":224,"_225":46,"_226":-5,"_227":-5,"_228":229},"routes/_app.x.$handle.$name.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":25,"_26":27,"_28":-5,"_29":-5,"_30":-5,"_31":-5,"_32":-5},"handle","MJK","name","live-groupchat","branchName","main","version","path","bookmarklet","project",{"_34":154,"_13":14,"_47":155,"_156":-5,"_157":54,"_158":159,"_160":159,"_161":162,"_163":-5,"_164":165,"_166":-5,"_167":54,"_168":-5,"_169":-5,"_170":60,"_171":172,"_173":174,"_175":176,"_177":178,"_179":-5,"_180":181,"_182":181,"_183":184,"_185":184,"_186":184,"_187":181,"_188":181,"_189":190,"_191":192,"_193":194,"_195":54},"tree",[63,64,65,66,67],"file",{"_34":57,"_13":19,"_37":40,"_39":-5,"_41":42,"_43":58,"_45":46,"_47":59,"_17":60,"_50":61,"_51":-5,"_53":54,"_55":-5,"_18":62},"contents",[33],"upstream","pull","ahead","behind","envVars",{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_17":49,"_50":24,"_51":52,"_53":54,"_55":-5,"_18":56},"id","4ef2d0a8-2efb-11f1-9398-42dde27851f2","source.js","fileId","382c7858-2ef9-11f1-977e-42dde27851f2","parentId","761c320d-60c7-4a68-9911-89597f56de08","branchId","f42b2574-2ef7-11f1-ab55-42dde27851f2","branchVersion",19,"latest",true,"createdAt",["D",1775179232123],3,"fileType","content","// =============================================================\n// LiveChat — All-in-One Bookmarklet (readable source)\n// Uses Shadow DOM for full style isolation from the host page.\n// Custom resize grip so overflow:hidden doesn't break it.\n// Double-send prevention via sending flag.\n// Messages: others LEFT, yours RIGHT (standard chat layout).\n// Token persisted in localStorage — no re-login needed.\n// =============================================================\n(function () {\n var BASE = 'https://MJK--2cb58f1a2ef811f1946342dde27851f2.web.val.run';\n var HOST_ID = '__lc_host';\n\n // ── Toggle ───────────────────────────────────────────────\n if (document.getElementById(HOST_ID)) {\n document.getElementById(HOST_ID).remove();\n return;\n }\n\n // ── Persistent state ─────────────────────────────────────\n var token = localStorage.getItem('__lc_tok') || null;\n var me = localStorage.getItem('__lc_me') || null;\n var lastId = 0, pollTimer = null, authTab = 'login', sending = false;\n\n // Saved geometry\n var W = Math.max(280, parseInt(localStorage.getItem('__lc_w') || '320'));\n var H = Math.max(300, parseInt(localStorage.getItem('__lc_h') || '460'));\n var PX = parseInt(localStorage.getItem('__lc_x') || String(window.innerWidth - W - 24));\n var PY = parseInt(localStorage.getItem('__lc_y') || String(window.innerHeight - H - 24));\n\n // ── Host element (shadow root attached here) ─────────────\n var host = document.createElement('div');\n host.id = HOST_ID;\n // Host sits outside the page flow; all real layout is inside shadow DOM\n host.style.cssText = 'all:initial;position:fixed;left:0;top:0;width:0;height:0;z-index:2147483647;';\n document.body.appendChild(host);\n\n var shadow = host.attachShadow({ mode: 'open' });\n\n // ── Shadow DOM styles ─────────────────────────────────────\n var styleEl = document.createElement('style');\n styleEl.textContent = `\n :host { all: initial; }\n\n #panel {\n position: fixed;\n left: ${PX}px; top: ${PY}px;\n width: ${W}px; height: ${H}px;\n min-width: 260px; min-height: 300px;\n background: #1a1a24;\n border: 1px solid #2e2e3e;\n border-radius: 14px;\n box-shadow: 0 12px 40px rgba(0,0,0,.75);\n font-family: system-ui, sans-serif;\n font-size: 14px;\n color: #f1f1f5;\n display: flex;\n flex-direction: column;\n overflow: hidden;\n /* NO resize:both — we use a custom grip so overflow:hidden doesn't eat it */\n }\n\n /* ── Header / drag bar ── */\n #hdr {\n background: #23232f;\n padding: 10px 14px;\n display: flex;\n justify-content: space-between;\n align-items: center;\n border-bottom: 1px solid #2e2e3e;\n flex-shrink: 0;\n cursor: grab;\n user-select: none;\n }\n #hdr.grabbing { cursor: grabbing; }\n #hdr-title { color: #f1f1f5; font-weight: 700; font-size: 14px; pointer-events: none; }\n #close-btn {\n background: none; border: none; color: #888;\n font-size: 22px; cursor: pointer; line-height: 1; padding: 0; flex-shrink: 0;\n }\n #close-btn:hover { color: #f1f1f5; }\n\n /* ── Body ── */\n #body { display: flex; flex-direction: column; flex: 1; overflow: hidden; }\n\n /* ── Auth ── */\n #auth-wrap {\n display: flex; flex-direction: column; gap: 10px;\n padding: 24px 18px; flex: 1; justify-content: center;\n }\n .auth-title { color: #f1f1f5; font-size: 15px; font-weight: 700; text-align: center; margin-bottom: 4px; }\n .tab-row { display: flex; background: #0f0f13; border-radius: 8px; padding: 3px; gap: 3px; }\n .tab {\n flex: 1; padding: 6px; border: none; border-radius: 6px;\n background: transparent; color: #888; cursor: pointer; font-size: 13px; font-weight: 600;\n }\n .tab.active { background: #6366f1; color: #fff; }\n .lc-input {\n padding: 9px 12px; border-radius: 8px; border: 1px solid #2e2e3e;\n background: #0f0f13; color: #f1f1f5; font-size: 14px; outline: none; width: 100%;\n box-sizing: border-box;\n }\n .lc-input:focus { border-color: #6366f1; }\n .err { color: #ef4444; font-size: 12px; text-align: center; min-height: 14px; }\n .primary-btn {\n padding: 9px; border-radius: 8px; border: none;\n background: #6366f1; color: #fff; font-size: 14px;\n font-weight: 700; cursor: pointer; width: 100%;\n }\n .primary-btn:hover { background: #4f46e5; }\n .primary-btn:disabled { opacity: 0.6; cursor: default; }\n\n /* ── Chat logbar ── */\n #logbar {\n display: flex; justify-content: space-between; align-items: center;\n padding: 5px 14px; background: #23232f; font-size: 11px; color: #888;\n flex-shrink: 0; border-bottom: 1px solid #2e2e3e;\n }\n #logbar span { color: #a5b4fc; font-weight: 700; margin-left: 4px; }\n #logout-btn {\n background: none; border: none; color: #555; cursor: pointer; font-size: 11px;\n }\n #logout-btn:hover { color: #ef4444; }\n\n /* ── Messages ── */\n #msgs {\n flex: 1; overflow-y: auto; padding: 10px 12px;\n display: flex; flex-direction: column; gap: 6px;\n }\n #msgs::-webkit-scrollbar { width: 4px; }\n #msgs::-webkit-scrollbar-thumb { background: #2e2e3e; border-radius: 2px; }\n\n .msg-row {\n display: flex;\n flex-direction: column;\n max-width: 80%;\n }\n .msg-row.mine { align-self: flex-end; align-items: flex-end; }\n .msg-row.theirs { align-self: flex-start; align-items: flex-start; }\n\n .msg-name {\n font-size: 10px; font-weight: 700; margin-bottom: 2px;\n color: #a5b4fc;\n }\n .msg-row.mine .msg-name { color: #c7d2fe; }\n\n .msg-bubble {\n font-size: 12px; padding: 7px 10px; border-radius: 12px;\n line-height: 1.5; word-break: break-word; max-width: 100%;\n }\n .msg-row.theirs .msg-bubble {\n background: #23232f; border-radius: 2px 12px 12px 12px;\n }\n .msg-row.mine .msg-bubble {\n background: #4f46e5; border-radius: 12px 2px 12px 12px;\n }\n\n .empty-msg { color: #555; font-size: 12px; text-align: center; margin: auto; }\n\n /* ── Footer input ── */\n #footer {\n padding: 8px; border-top: 1px solid #2e2e3e;\n display: flex; gap: 6px; flex-shrink: 0;\n }\n #msg-inp {\n flex: 1; background: #0f0f13; border: 1px solid #2e2e3e;\n border-radius: 8px; padding: 7px 10px; color: #f1f1f5;\n font-size: 13px; outline: none; box-sizing: border-box;\n }\n #msg-inp:focus { border-color: #6366f1; }\n #send-btn {\n background: #6366f1; border: none; border-radius: 8px;\n padding: 7px 14px; color: #fff; cursor: pointer;\n font-weight: 700; font-size: 13px; flex-shrink: 0;\n }\n #send-btn:hover { background: #4f46e5; }\n\n /* ── Custom resize grip (bottom-right corner) ── */\n #grip {\n position: absolute;\n bottom: 0; right: 0;\n width: 18px; height: 18px;\n cursor: nwse-resize;\n z-index: 10;\n /* visual triangle indicator */\n background: linear-gradient(135deg, transparent 50%, #444 50%);\n border-radius: 0 0 14px 0;\n opacity: 0.5;\n }\n #grip:hover { opacity: 1; }\n `;\n shadow.appendChild(styleEl);\n\n // ── Panel ─────────────────────────────────────────────────\n var panel = document.createElement('div');\n panel.id = 'panel';\n shadow.appendChild(panel);\n\n // ── Header ────────────────────────────────────────────────\n var hdr = document.createElement('div');\n hdr.id = 'hdr';\n hdr.innerHTML = '💬 LiveChat';\n var closeBtn = document.createElement('button');\n closeBtn.id = 'close-btn';\n closeBtn.textContent = '×';\n closeBtn.onclick = function () { clearInterval(pollTimer); host.remove(); };\n hdr.appendChild(closeBtn);\n panel.appendChild(hdr);\n\n // ── Body ──────────────────────────────────────────────────\n var body = document.createElement('div');\n body.id = 'body';\n panel.appendChild(body);\n\n // ── Resize grip ───────────────────────────────────────────\n var grip = document.createElement('div');\n grip.id = 'grip';\n panel.appendChild(grip);\n\n // ── Drag (header) ─────────────────────────────────────────\n var dragging = false, dSX, dSY, pSX, pSY;\n hdr.addEventListener('mousedown', function (e) {\n if (e.target === closeBtn) return;\n dragging = true;\n dSX = e.clientX; dSY = e.clientY;\n pSX = parseInt(panel.style.left); pSY = parseInt(panel.style.top);\n hdr.classList.add('grabbing');\n e.preventDefault();\n });\n document.addEventListener('mousemove', function (e) {\n if (!dragging) return;\n var nx = Math.max(0, Math.min(pSX + e.clientX - dSX, window.innerWidth - panel.offsetWidth));\n var ny = Math.max(0, Math.min(pSY + e.clientY - dSY, window.innerHeight - panel.offsetHeight));\n panel.style.left = nx + 'px';\n panel.style.top = ny + 'px';\n });\n document.addEventListener('mouseup', function () {\n if (!dragging) return;\n dragging = false;\n hdr.classList.remove('grabbing');\n localStorage.setItem('__lc_x', parseInt(panel.style.left));\n localStorage.setItem('__lc_y', parseInt(panel.style.top));\n });\n\n // ── Custom resize grip ────────────────────────────────────\n var resizing = false, rSX, rSY, rSW, rSH;\n grip.addEventListener('mousedown', function (e) {\n resizing = true;\n rSX = e.clientX; rSY = e.clientY;\n rSW = panel.offsetWidth; rSH = panel.offsetHeight;\n e.preventDefault();\n e.stopPropagation();\n });\n document.addEventListener('mousemove', function (e) {\n if (!resizing) return;\n var nw = Math.max(260, rSW + e.clientX - rSX);\n var nh = Math.max(300, rSH + e.clientY - rSY);\n panel.style.width = nw + 'px';\n panel.style.height = nh + 'px';\n });\n document.addEventListener('mouseup', function () {\n if (!resizing) return;\n resizing = false;\n localStorage.setItem('__lc_w', panel.offsetWidth);\n localStorage.setItem('__lc_h', panel.offsetHeight);\n });\n\n // ═══════════════════════════════════════════════════════════\n // AUTH SCREEN\n // ═══════════════════════════════════════════════════════════\n function showAuth() {\n clearInterval(pollTimer);\n body.innerHTML = '';\n\n var wrap = document.createElement('div');\n wrap.id = 'auth-wrap';\n\n var title = document.createElement('div');\n title.className = 'auth-title';\n title.textContent = '💬 LiveChat';\n wrap.appendChild(title);\n\n var tabRow = document.createElement('div');\n tabRow.className = 'tab-row';\n var tLogin = document.createElement('button');\n tLogin.className = 'tab active'; tLogin.textContent = 'Login';\n var tReg = document.createElement('button');\n tReg.className = 'tab'; tReg.textContent = 'Register';\n tabRow.appendChild(tLogin); tabRow.appendChild(tReg);\n wrap.appendChild(tabRow);\n\n var inpU = document.createElement('input');\n inpU.className = 'lc-input'; inpU.placeholder = 'Username'; inpU.type = 'text';\n var inpP = document.createElement('input');\n inpP.className = 'lc-input'; inpP.placeholder = 'Password'; inpP.type = 'password';\n var errEl = document.createElement('div');\n errEl.className = 'err';\n var subBtn = document.createElement('button');\n subBtn.className = 'primary-btn'; subBtn.textContent = 'Login';\n\n [inpU, inpP, errEl, subBtn].forEach(function (n) { wrap.appendChild(n); });\n body.appendChild(wrap);\n setTimeout(function () { inpU.focus(); }, 60);\n\n tLogin.onclick = function () {\n authTab = 'login';\n tLogin.classList.add('active'); tReg.classList.remove('active');\n subBtn.textContent = 'Login'; errEl.textContent = '';\n };\n tReg.onclick = function () {\n authTab = 'register';\n tReg.classList.add('active'); tLogin.classList.remove('active');\n subBtn.textContent = 'Create Account'; errEl.textContent = '';\n };\n inpP.addEventListener('keydown', function (e) { if (e.key === 'Enter') doAuth(); });\n subBtn.onclick = doAuth;\n\n async function doAuth() {\n var u = inpU.value.trim(), p = inpP.value;\n errEl.textContent = '';\n if (!u || !p) { errEl.textContent = 'Fill in both fields'; return; }\n subBtn.textContent = '…'; subBtn.disabled = true;\n try {\n var r = await fetch(BASE + '/api/' + authTab, {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({ username: u, password: p }),\n });\n var d = await r.json();\n if (!r.ok) {\n errEl.textContent = d.error || 'Error';\n subBtn.textContent = authTab === 'login' ? 'Login' : 'Create Account';\n subBtn.disabled = false;\n return;\n }\n token = d.token; me = d.user.username;\n localStorage.setItem('__lc_tok', token);\n localStorage.setItem('__lc_me', me);\n showChat();\n } catch (e) {\n errEl.textContent = 'Network error';\n subBtn.textContent = authTab === 'login' ? 'Login' : 'Create Account';\n subBtn.disabled = false;\n }\n }\n }\n\n // ═══════════════════════════════════════════════════════════\n // CHAT SCREEN\n // ═══════════════════════════════════════════════════════════\n function showChat() {\n body.innerHTML = '';\n\n // Logbar\n var logbar = document.createElement('div'); logbar.id = 'logbar';\n logbar.innerHTML = 'Chatting as ' + me + '';\n var loBtn = document.createElement('button'); loBtn.id = 'logout-btn'; loBtn.textContent = 'logout';\n loBtn.onclick = doLogout;\n logbar.appendChild(loBtn);\n body.appendChild(logbar);\n\n // Messages\n var msgs = document.createElement('div'); msgs.id = 'msgs';\n var loadingEl = document.createElement('div');\n loadingEl.className = 'empty-msg'; loadingEl.textContent = 'Loading…';\n msgs.appendChild(loadingEl);\n body.appendChild(msgs);\n\n // Footer\n var footer = document.createElement('div'); footer.id = 'footer';\n var inp = document.createElement('input');\n inp.id = 'msg-inp'; inp.placeholder = 'Type a message…'; inp.maxLength = 500; inp.type = 'text';\n var sendBtn = document.createElement('button'); sendBtn.id = 'send-btn'; sendBtn.textContent = 'Send';\n footer.appendChild(inp); footer.appendChild(sendBtn);\n body.appendChild(footer);\n setTimeout(function () { inp.focus(); }, 60);\n\n // ── Render a message bubble ──────────────────────────────\n function addMsg(m) {\n var empty = msgs.querySelector('.empty-msg');\n if (empty) empty.remove();\n var isOwn = m.username === me;\n\n var row = document.createElement('div');\n row.className = 'msg-row ' + (isOwn ? 'mine' : 'theirs');\n\n var name = document.createElement('div');\n name.className = 'msg-name';\n name.textContent = isOwn ? 'You' : m.username;\n\n var bubble = document.createElement('div');\n bubble.className = 'msg-bubble';\n bubble.textContent = m.content; // textContent — safe, no XSS\n\n row.appendChild(name);\n row.appendChild(bubble);\n msgs.appendChild(row);\n msgs.scrollTop = msgs.scrollHeight;\n }\n\n // ── Load initial messages ────────────────────────────────\n async function load() {\n try {\n var r = await fetch(BASE + '/api/messages?limit=20');\n var d = await r.json();\n msgs.innerHTML = '';\n if (!d.messages || !d.messages.length) {\n var e = document.createElement('div');\n e.className = 'empty-msg'; e.textContent = 'No messages yet. Say hello! 👋';\n msgs.appendChild(e);\n } else {\n d.messages.forEach(addMsg);\n lastId = d.messages[d.messages.length - 1].id;\n }\n } catch (e) {}\n }\n\n // ── Poll for new messages ────────────────────────────────\n async function poll() {\n try {\n var r = await fetch(BASE + '/api/messages/poll?since=' + lastId, {\n headers: { 'Authorization': 'Bearer ' + token }\n });\n if (!r.ok) return;\n var d = await r.json();\n if (d.messages && d.messages.length) {\n d.messages.forEach(function (m) { addMsg(m); lastId = m.id; });\n }\n } catch (e) {}\n }\n\n // ── Send (with double-send guard) ────────────────────────\n async function send() {\n if (sending) return; // ← prevents double-send\n var c = inp.value.trim();\n if (!c) return;\n sending = true;\n inp.value = '';\n try {\n var r = await fetch(BASE + '/api/messages', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json', 'Authorization': 'Bearer ' + token },\n body: JSON.stringify({ content: c }),\n });\n if (r.ok) {\n await poll();\n } else {\n inp.value = c; // restore on failure\n }\n } catch (e) {\n inp.value = c;\n } finally {\n sending = false;\n }\n }\n\n // ── Wire up events ───────────────────────────────────────\n sendBtn.addEventListener('click', send);\n inp.addEventListener('keydown', function (e) {\n if (e.key === 'Enter') {\n e.preventDefault(); // prevent form submit / button click propagation\n send();\n }\n });\n\n load();\n pollTimer = setInterval(poll, 2000);\n }\n\n // ── Logout ────────────────────────────────────────────────\n function doLogout() {\n clearInterval(pollTimer);\n token = null; me = null; lastId = 0; sending = false;\n localStorage.removeItem('__lc_tok');\n localStorage.removeItem('__lc_me');\n fetch(BASE + '/api/logout', { method: 'POST' }).catch(function () {});\n showAuth();\n }\n\n // ── Boot ──────────────────────────────────────────────────\n if (token && me) {\n fetch(BASE + '/api/me', { headers: { 'Authorization': 'Bearer ' + token } })\n .then(function (r) { r.ok ? showChat() : showAuth(); })\n .catch(function () { showAuth(); });\n } else {\n showAuth();\n }\n})();\n","deleted",false,"label",[19,36],"382ce5d6-2ef9-11f1-977e-42dde27851f2",13,["D",1775178334898],0,"directory",[19],{"_34":57,"_13":19,"_37":40,"_39":-5,"_41":42,"_43":58,"_45":46,"_47":147,"_17":60,"_50":61,"_51":-5,"_53":54,"_55":-5,"_76":148,"_18":149},{"_34":122,"_13":123,"_37":124,"_39":-5,"_41":42,"_43":102,"_45":46,"_47":125,"_17":60,"_50":61,"_51":-5,"_53":54,"_55":-5,"_76":126,"_18":127},{"_34":88,"_13":89,"_37":90,"_39":-5,"_41":42,"_43":49,"_45":46,"_47":91,"_17":60,"_50":61,"_51":-5,"_53":54,"_55":-5,"_76":92,"_18":93},{"_34":79,"_13":80,"_37":81,"_39":-5,"_41":42,"_43":82,"_45":46,"_47":83,"_17":60,"_50":84,"_51":85,"_53":54,"_55":-5,"_76":86,"_18":87},{"_34":68,"_13":69,"_37":70,"_39":-5,"_41":42,"_43":71,"_45":46,"_47":72,"_17":73,"_50":74,"_51":75,"_53":54,"_55":-5,"_76":77,"_18":78},"2a938d66-2efa-11f1-8742-42dde27851f2","main.ts","2cb58f1a-2ef8-11f1-9463-42dde27851f2",15,["D",1775178741609],2,"http","import { Hono } from \"npm:hono@4\";\nimport { serveFile, parseVal } from \"https://esm.town/v/std/utils/index.ts\";\nimport { runMigrations } from \"./database/migrations.ts\";\nimport {\n createUser, getUserByCredentials,\n createSession, getSessionUser, deleteSession,\n saveMessage, getRecentMessages, getMessagesSince,\n getUserByToken, createApiToken,\n} from \"./database/queries.ts\";\n\nawait runMigrations();\n\nconst app = new Hono();\napp.onError((err) => Promise.reject(err));\n\n// ─── CORS ────────────────────────────────────────────────────────────────────\n// Applied to EVERY response so bookmarklets on any origin can call the API.\nconst CORS_HEADERS = {\n \"Access-Control-Allow-Origin\": \"*\",\n \"Access-Control-Allow-Methods\": \"GET, POST, OPTIONS\",\n \"Access-Control-Allow-Headers\": \"Content-Type, Authorization\",\n \"Access-Control-Max-Age\": \"86400\",\n};\n\n// Handle all preflight OPTIONS requests up-front\napp.options(\"*\", (c) => {\n return new Response(null, { status: 204, headers: CORS_HEADERS });\n});\n\n// Inject CORS headers into every response\napp.use(\"*\", async (c, next) => {\n await next();\n for (const [k, v] of Object.entries(CORS_HEADERS)) c.res.headers.set(k, v);\n});\n\n// ─── Auth helpers ────────────────────────────────────────────────────────────\nfunction getSessionId(req: Request): string | null {\n const cookie = req.headers.get(\"cookie\") || \"\";\n const match = cookie.match(/session=([^;]+)/);\n return match ? match[1] : null;\n}\n\n/** Bearer token from Authorization header (for bookmarklets / API clients) */\nfunction getBearerToken(req: Request): string | null {\n const auth = req.headers.get(\"authorization\") || \"\";\n const match = auth.match(/^Bearer\\s+(.+)$/i);\n return match ? match[1] : null;\n}\n\nfunction sessionCookie(id: string, maxAge = 604800) {\n // SameSite=None + Secure so cross-site bookmarklets can send the cookie too\n return `session=${id}; Path=/; HttpOnly; SameSite=None; Secure; Max-Age=${maxAge}`;\n}\n\n/** Returns the authenticated user via session cookie OR Bearer token */\nasync function requireAuth(c: any) {\n // 1. Session cookie\n const sid = getSessionId(c.req.raw);\n if (sid) {\n const user = await getSessionUser(sid);\n if (user) return user;\n }\n // 2. Bearer API token\n const token = getBearerToken(c.req.raw);\n if (token) {\n const user = await getUserByToken(token);\n if (user) return user;\n }\n return null;\n}\n\n// ─── Auth routes ─────────────────────────────────────────────────────────────\napp.post(\"/api/register\", async (c) => {\n const { username, password } = await c.req.json();\n if (!username || !password) return c.json({ error: \"Username and password required\" }, 400);\n if (username.length < 2 || username.length > 20) return c.json({ error: \"Username must be 2–20 chars\" }, 400);\n if (!/^[a-zA-Z0-9_]+$/.test(username)) return c.json({ error: \"Username: letters, numbers, underscores only\" }, 400);\n if (password.length < 6) return c.json({ error: \"Password must be at least 6 characters\" }, 400);\n const user = await createUser(username, password);\n if (!user) return c.json({ error: \"Username already taken\" }, 409);\n const sid = await createSession(user.id);\n c.header(\"Set-Cookie\", sessionCookie(sid));\n // Also return a Bearer token so cross-origin clients (bookmarklets) don't need cookies\n const token = await createApiToken(user.id);\n return c.json({ user: { id: user.id, username: user.username, avatar_color: user.avatar_color }, token });\n});\n\napp.post(\"/api/login\", async (c) => {\n const { username, password } = await c.req.json();\n if (!username || !password) return c.json({ error: \"Username and password required\" }, 400);\n const user = await getUserByCredentials(username, password);\n if (!user) return c.json({ error: \"Invalid username or password\" }, 401);\n const sid = await createSession(user.id);\n c.header(\"Set-Cookie\", sessionCookie(sid));\n // Also return a Bearer token so cross-origin clients (bookmarklets) don't need cookies\n const token = await createApiToken(user.id);\n return c.json({ user: { id: user.id, username: user.username, avatar_color: user.avatar_color }, token });\n});\n\napp.post(\"/api/logout\", async (c) => {\n const sid = getSessionId(c.req.raw);\n if (sid) await deleteSession(sid);\n c.header(\"Set-Cookie\", sessionCookie(\"\", 0));\n return c.json({ ok: true });\n});\n\napp.get(\"/api/me\", async (c) => {\n const user = await requireAuth(c);\n if (!user) return c.json({ error: \"Unauthorized\" }, 401);\n return c.json({ user });\n});\n\n/** Generate a long-lived API token — useful for bookmarklets */\napp.post(\"/api/token\", async (c) => {\n const user = await requireAuth(c);\n if (!user) return c.json({ error: \"Unauthorized\" }, 401);\n const token = await createApiToken(user.id);\n return c.json({ token });\n});\n\n// ─── Messages ────────────────────────────────────────────────────────────────\n\n/**\n * GET /api/messages\n * Returns the last 20 messages as JSON. No auth required — readable by anyone,\n * including bookmarklets on other sites.\n *\n * Optional query param: ?limit=N (1–100, default 20)\n */\napp.get(\"/api/messages\", async (c) => {\n const limit = Math.min(100, Math.max(1, Number(c.req.query(\"limit\") || \"20\")));\n const messages = await getRecentMessages(limit);\n return c.json({ messages });\n});\n\n/**\n * GET /api/messages/poll?since=\n * Returns all messages with id > lastId. Requires auth.\n */\napp.get(\"/api/messages/poll\", async (c) => {\n const user = await requireAuth(c);\n if (!user) return c.json({ error: \"Unauthorized\" }, 401);\n const since = Number(c.req.query(\"since\") || \"0\");\n const messages = await getMessagesSince(since);\n return c.json({ messages });\n});\n\n/**\n * POST /api/messages\n * Save a new message. Accepts auth via:\n * - Session cookie (in-app users)\n * - Authorization: Bearer (bookmarklets / API clients)\n *\n * Body: { \"content\": \"hello world\" }\n *\n * For unauthenticated bookmarklet use, you can also pass:\n * { \"content\": \"hello\", \"username\": \"myname\", \"api_key\": \"\" }\n * This lets anonymous guests post if you set CHAT_API_KEY in your env.\n */\napp.post(\"/api/messages\", async (c) => {\n const body = await c.req.json();\n\n // --- Authenticated path (session or Bearer token) ---\n let user = await requireAuth(c);\n\n // --- Guest / bookmarklet path (shared API key) ---\n if (!user) {\n const sharedKey = Deno.env.get(\"CHAT_API_KEY\");\n if (sharedKey && body.api_key === sharedKey && body.username) {\n const guestName = String(body.username).replace(/[^a-zA-Z0-9_ ]/g, \"\").slice(0, 20) || \"Guest\";\n user = { id: 0, username: guestName, avatar_color: \"#94a3b8\" } as any;\n }\n }\n\n if (!user) return c.json({ error: \"Unauthorized — login or provide a Bearer token / api_key\" }, 401);\n\n const content = String(body.content || \"\").trim().slice(0, 500);\n if (!content) return c.json({ error: \"content is required\" }, 400);\n\n const id = await saveMessage(user.id, user.username, user.avatar_color, content);\n return c.json({ ok: true, id, username: user.username });\n});\n\n// ─── Source & static ─────────────────────────────────────────────────────────\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\napp.get(\"/frontend/*\", (c) => serveFile(c.req.path, import.meta.url));\napp.get(\"*\", (c) => serveFile(\"/frontend/index.html\", import.meta.url));\n\nexport default app.fetch;\n","children",[],[69],"1e2a6968-2efb-11f1-9398-42dde27851f2","cleanup.ts","1e2a6a44-2efb-11f1-9398-42dde27851f2",18,["D",1775179150281],"interval","import { deleteExpiredMessages } from \"./database/queries.ts\";\n\nexport default async function (_interval: Interval) {\n const deleted = await deleteExpiredMessages();\n console.log(`[cleanup] Deleted ${deleted} expired messages`);\n}\n",[],[80],"0666cd60-2ef8-11f1-8561-42dde27851f2","frontend","b501ffcf-0dce-4a1c-a1c7-2032c83dbfa9",["D",1775177821530],[94,95,96],[89],{"_34":114,"_13":115,"_37":116,"_39":90,"_41":42,"_43":117,"_45":46,"_47":118,"_17":102,"_50":24,"_51":119,"_53":54,"_55":-5,"_76":120,"_18":121},{"_34":106,"_13":107,"_37":108,"_39":90,"_41":42,"_43":109,"_45":46,"_47":110,"_17":102,"_50":24,"_51":111,"_53":54,"_55":-5,"_76":112,"_18":113},{"_34":97,"_13":98,"_37":99,"_39":90,"_41":42,"_43":100,"_45":46,"_47":101,"_17":102,"_50":24,"_51":103,"_53":54,"_55":-5,"_76":104,"_18":105},"8105b338-2ef8-11f1-8957-42dde27851f2","style.css","170f1bc2-2ef8-11f1-8777-42dde27851f2",12,["D",1775178027556],1,"*, *::before, *::after { box-sizing: border-box; margin: 0; padding: 0; }\n\n:root {\n --bg: #0f0f13;\n --surface: #1a1a24;\n --surface2: #23232f;\n --border: #2e2e3e;\n --accent: #6366f1;\n --accent-hover: #4f46e5;\n --text: #f1f1f5;\n --muted: #8888aa;\n --error: #ef4444;\n --radius: 12px;\n}\n\nbody {\n font-family: 'Segoe UI', system-ui, sans-serif;\n background: var(--bg);\n color: var(--text);\n height: 100dvh;\n display: flex;\n flex-direction: column;\n}\n\n/* AUTH */\n.screen { display: flex; flex-direction: column; height: 100dvh; }\n\n.auth-box {\n margin: auto;\n background: var(--surface);\n border: 1px solid var(--border);\n border-radius: var(--radius);\n padding: 2.5rem 2rem;\n width: 100%;\n max-width: 380px;\n box-shadow: 0 20px 60px rgba(0,0,0,0.5);\n}\n\n.logo { font-size: 2rem; font-weight: 800; text-align: center; margin-bottom: 0.4rem; }\n.tagline { text-align: center; color: var(--muted); font-size: 0.875rem; margin-bottom: 1.5rem; }\n\n.tab-row { display: flex; border-radius: 8px; background: var(--bg); padding: 4px; gap: 4px; margin-bottom: 1.2rem; }\n.tab {\n flex: 1; padding: 0.5rem; border: none; border-radius: 6px;\n background: transparent; color: var(--muted); cursor: pointer;\n font-size: 0.9rem; font-weight: 600; transition: all 0.2s;\n}\n.tab.active { background: var(--accent); color: white; }\n\n#auth-form { display: flex; flex-direction: column; gap: 0.75rem; }\n\n#auth-form input {\n padding: 0.75rem 1rem; border-radius: 8px;\n border: 1px solid var(--border); background: var(--bg);\n color: var(--text); font-size: 1rem; outline: none; transition: border 0.2s;\n}\n#auth-form input:focus { border-color: var(--accent); }\n\n#auth-form button[type=submit] {\n padding: 0.75rem; border-radius: 8px; border: none;\n background: var(--accent); color: white; font-size: 1rem;\n font-weight: 700; cursor: pointer; transition: background 0.2s;\n margin-top: 0.25rem;\n}\n#auth-form button[type=submit]:hover { background: var(--accent-hover); }\n\n.error-msg { color: var(--error); font-size: 0.85rem; text-align: center; }\n.source-link { text-align: center; margin-top: 1rem; font-size: 0.8rem; }\n.source-link a { color: var(--muted); text-decoration: none; }\n.source-link a:hover { color: var(--text); }\n\n/* CHAT */\nheader {\n display: flex; align-items: center; justify-content: space-between;\n padding: 1rem 1.5rem; background: var(--surface);\n border-bottom: 1px solid var(--border); flex-shrink: 0;\n}\n.header-left { font-size: 1.1rem; }\n.header-right { display: flex; align-items: center; gap: 0.75rem; color: var(--muted); font-size: 0.875rem; }\n.logout-btn {\n padding: 0.35rem 0.75rem; border-radius: 6px; border: 1px solid var(--border);\n background: transparent; color: var(--muted); cursor: pointer; font-size: 0.85rem;\n transition: all 0.2s;\n}\n.logout-btn:hover { background: var(--error); color: white; border-color: var(--error); }\n\n.messages {\n flex: 1; overflow-y: auto; padding: 1rem 1.5rem;\n display: flex; flex-direction: column; gap: 0.5rem;\n scroll-behavior: smooth;\n}\n.messages::-webkit-scrollbar { width: 6px; }\n.messages::-webkit-scrollbar-track { background: transparent; }\n.messages::-webkit-scrollbar-thumb { background: var(--border); border-radius: 3px; }\n\n.msg {\n display: flex; gap: 0.75rem; align-items: flex-start;\n animation: fadeIn 0.2s ease;\n}\n@keyframes fadeIn { from { opacity: 0; transform: translateY(6px); } to { opacity: 1; transform: none; } }\n\n.avatar {\n width: 36px; height: 36px; border-radius: 50%;\n display: flex; align-items: center; justify-content: center;\n font-weight: 700; font-size: 0.85rem; flex-shrink: 0; color: white;\n text-transform: uppercase;\n}\n\n.msg-body { display: flex; flex-direction: column; gap: 0.15rem; max-width: calc(100% - 50px); }\n.msg-meta { display: flex; align-items: baseline; gap: 0.5rem; }\n.msg-user { font-weight: 700; font-size: 0.875rem; }\n.msg-time { color: var(--muted); font-size: 0.75rem; }\n.msg-text {\n background: var(--surface2); padding: 0.5rem 0.75rem;\n border-radius: 0 12px 12px 12px; font-size: 0.95rem;\n line-height: 1.5; word-break: break-word;\n border: 1px solid var(--border);\n}\n\n.msg.own { flex-direction: row-reverse; }\n.msg.own .msg-meta { flex-direction: row-reverse; }\n.msg.own .msg-text {\n background: var(--accent); border-color: var(--accent);\n border-radius: 12px 0 12px 12px;\n}\n\n.divider {\n text-align: center; color: var(--muted); font-size: 0.75rem;\n position: relative; margin: 0.5rem 0;\n}\n.divider::before, .divider::after {\n content: ''; position: absolute; top: 50%;\n width: 40%; height: 1px; background: var(--border);\n}\n.divider::before { left: 0; }\n.divider::after { right: 0; }\n\n.input-area {\n padding: 1rem 1.5rem; background: var(--surface);\n border-top: 1px solid var(--border); flex-shrink: 0;\n}\n.input-area form { display: flex; gap: 0.75rem; }\n#msg-input {\n flex: 1; padding: 0.75rem 1rem; border-radius: 10px;\n border: 1px solid var(--border); background: var(--bg);\n color: var(--text); font-size: 1rem; outline: none; transition: border 0.2s;\n}\n#msg-input:focus { border-color: var(--accent); }\n.input-area button {\n padding: 0.75rem 1.25rem; border-radius: 10px; border: none;\n background: var(--accent); color: white; font-size: 1rem;\n font-weight: 700; cursor: pointer; transition: background 0.2s;\n}\n.input-area button:hover { background: var(--accent-hover); }\n\n.system-msg { text-align: center; color: var(--muted); font-size: 0.8rem; font-style: italic; }\n\n@media (max-width: 500px) {\n .auth-box { border-radius: 0; border: none; height: 100dvh; display: flex; flex-direction: column; justify-content: center; }\n .messages { padding: 0.75rem; }\n .input-area { padding: 0.75rem; }\n header { padding: 0.75rem 1rem; }\n}\n\n/* ── API Token button ── */\n.token-btn {\n padding: 0.35rem 0.75rem; border-radius: 6px; border: 1px solid var(--border);\n background: transparent; color: var(--muted); cursor: pointer; font-size: 0.85rem;\n transition: all 0.2s;\n}\n.token-btn:hover { background: var(--accent); color: white; border-color: var(--accent); }\n\n/* ── Modal ── */\n.modal-backdrop {\n position: fixed; inset: 0; background: rgba(0,0,0,0.7);\n display: flex; align-items: center; justify-content: center;\n z-index: 100; padding: 1rem;\n}\n.modal {\n background: var(--surface); border: 1px solid var(--border);\n border-radius: var(--radius); padding: 2rem; max-width: 520px; width: 100%;\n box-shadow: 0 24px 60px rgba(0,0,0,0.6); display: flex; flex-direction: column; gap: 1rem;\n}\n.modal h3 { font-size: 1.1rem; }\n.modal p { color: var(--muted); font-size: 0.875rem; line-height: 1.5; }\n.token-display {\n background: var(--bg); border: 1px solid var(--border); border-radius: 8px;\n padding: 0.75rem 1rem; font-family: monospace; font-size: 0.8rem;\n word-break: break-all; color: #a5f3fc;\n}\n.modal-actions { display: flex; gap: 0.75rem; }\n.copy-btn {\n flex: 1; padding: 0.6rem; border-radius: 8px; border: none;\n background: var(--accent); color: white; cursor: pointer; font-weight: 700;\n transition: background 0.2s;\n}\n.copy-btn:hover { background: var(--accent-hover); }\n.close-btn {\n flex: 1; padding: 0.6rem; border-radius: 8px;\n border: 1px solid var(--border); background: transparent;\n color: var(--muted); cursor: pointer; transition: all 0.2s;\n}\n.close-btn:hover { background: var(--border); color: var(--text); }\n\n/* ── Bookmarklet section ── */\n.bookmarklet-section { border-top: 1px solid var(--border); padding-top: 0.75rem; }\n.bookmarklet-section summary {\n cursor: pointer; color: var(--muted); font-size: 0.85rem; user-select: none;\n}\n.code-block {\n margin-top: 0.75rem; background: var(--bg); border: 1px solid var(--border);\n border-radius: 8px; padding: 0.75rem; font-size: 0.75rem; font-family: monospace;\n white-space: pre-wrap; word-break: break-all; color: #86efac; line-height: 1.6;\n max-height: 200px; overflow-y: auto;\n}\n",[],[89,98],"6900f928-2ef8-11f1-982b-42dde27851f2","index.html","0666badc-2ef8-11f1-8561-42dde27851f2",10,["D",1775177987327],"\n\n\n \n \n LiveChat 💬\n \n \n\n\n

💬 LiveChat

Real-time groupchat — join the conversation

\n \n \n

\n \n

view source

\n\n \n\n \n \n\n \n\n\n",[],[89,107],"78c0d068-2ef8-11f1-9449-42dde27851f2","app.js","22d03c98-2ef8-11f1-8174-42dde27851f2",11,["D",1775178013768],"// ─── State ────────────────────────────────────────────────────────────────────\nlet currentUser = null;\nlet lastMessageId = 0;\nlet pollInterval = null;\nlet currentTab = \"login\";\nlet cachedToken = null;\n\n// ─── Helpers ──────────────────────────────────────────────────────────────────\nfunction formatTime(isoStr) {\n const d = new Date(isoStr.endsWith(\"Z\") ? isoStr : isoStr + \"Z\");\n return d.toLocaleTimeString([], { hour: \"2-digit\", minute: \"2-digit\" });\n}\n\nfunction escapeHtml(str) {\n return String(str)\n .replace(/&/g, \"&\")\n .replace(//g, \">\")\n .replace(/\"/g, \""\");\n}\n\n// ─── Tab switching ────────────────────────────────────────────────────────────\nwindow.showTab = function (tab) {\n currentTab = tab;\n document.getElementById(\"tab-login\").classList.toggle(\"active\", tab === \"login\");\n document.getElementById(\"tab-register\").classList.toggle(\"active\", tab === \"register\");\n document.getElementById(\"auth-submit\").textContent =\n tab === \"login\" ? \"Login\" : \"Create Account\";\n document.getElementById(\"auth-error\").style.display = \"none\";\n};\n\n// ─── Auth ─────────────────────────────────────────────────────────────────────\nwindow.submitAuth = async function (e) {\n e.preventDefault();\n const username = document.getElementById(\"auth-username\").value.trim();\n const password = document.getElementById(\"auth-password\").value;\n const errorEl = document.getElementById(\"auth-error\");\n errorEl.style.display = \"none\";\n\n const endpoint = currentTab === \"login\" ? \"/api/login\" : \"/api/register\";\n try {\n const res = await fetch(endpoint, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ username, password }),\n });\n const data = await res.json();\n if (!res.ok) {\n errorEl.textContent = data.error || \"Something went wrong\";\n errorEl.style.display = \"block\";\n return;\n }\n currentUser = data.user;\n showChat();\n } catch {\n errorEl.textContent = \"Network error. Try again.\";\n errorEl.style.display = \"block\";\n }\n};\n\nwindow.logout = async function () {\n await fetch(\"/api/logout\", { method: \"POST\" });\n currentUser = null;\n cachedToken = null;\n lastMessageId = 0;\n clearInterval(pollInterval);\n pollInterval = null;\n document.getElementById(\"chat-screen\").style.display = \"none\";\n document.getElementById(\"auth-screen\").style.display = \"flex\";\n document.getElementById(\"messages\").innerHTML = \"\";\n};\n\n// ─── Chat ─────────────────────────────────────────────────────────────────────\nfunction showChat() {\n document.getElementById(\"auth-screen\").style.display = \"none\";\n document.getElementById(\"chat-screen\").style.display = \"flex\";\n document.getElementById(\"header-user\").textContent = \"👤 \" + currentUser.username;\n loadMessages();\n pollInterval = setInterval(pollMessages, 1500);\n document.getElementById(\"msg-input\").focus();\n}\n\nfunction renderMessage(msg) {\n const isOwn = currentUser && msg.username === currentUser.username;\n const initial = msg.username[0].toUpperCase();\n const div = document.createElement(\"div\");\n div.className = \"msg\" + (isOwn ? \" own\" : \"\");\n div.dataset.id = msg.id;\n div.innerHTML = `\n

${initial}

\n ${isOwn ? \"You\" : escapeHtml(msg.username)}\n ${formatTime(msg.created_at)}\n

${escapeHtml(msg.content)}

`;\n return div;\n}\n\nasync function loadMessages() {\n const res = await fetch(\"/api/messages?limit=20\");\n const data = await res.json();\n const container = document.getElementById(\"messages\");\n container.innerHTML = \"\";\n if (!data.messages.length) {\n container.innerHTML = '

No messages yet. Say hello! 👋

';\n } else {\n data.messages.forEach((m) => container.appendChild(renderMessage(m)));\n lastMessageId = data.messages[data.messages.length - 1].id;\n }\n container.scrollTop = container.scrollHeight;\n}\n\nasync function pollMessages() {\n if (!currentUser) return;\n try {\n const res = await fetch(`/api/messages/poll?since=${lastMessageId}`);\n if (!res.ok) return;\n const data = await res.json();\n if (data.messages?.length) {\n const container = document.getElementById(\"messages\");\n const wasAtBottom =\n container.scrollHeight - container.scrollTop - container.clientHeight < 80;\n const placeholder = container.querySelector(\".system-msg\");\n if (placeholder) placeholder.remove();\n data.messages.forEach((m) => container.appendChild(renderMessage(m)));\n lastMessageId = data.messages[data.messages.length - 1].id;\n if (wasAtBottom) container.scrollTop = container.scrollHeight;\n }\n } catch { /* ignore polling errors */ }\n}\n\nwindow.sendMessage = async function (e) {\n e.preventDefault();\n const input = document.getElementById(\"msg-input\");\n const content = input.value.trim();\n if (!content) return;\n input.value = \"\";\n try {\n await fetch(\"/api/messages\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ content }),\n });\n await pollMessages();\n } catch {\n input.value = content;\n }\n};\n\n// ─── API Token modal ──────────────────────────────────────────────────────────\nconst BASE_URL = window.location.origin;\n\nwindow.showTokenModal = async function () {\n const modal = document.getElementById(\"token-modal\");\n modal.style.display = \"flex\";\n const display = document.getElementById(\"token-display\");\n\n if (cachedToken) {\n display.textContent = cachedToken;\n updateBookmarklet(cachedToken);\n return;\n }\n\n display.textContent = \"Generating…\";\n try {\n const res = await fetch(\"/api/token\", { method: \"POST\" });\n const data = await res.json();\n cachedToken = data.token;\n display.textContent = cachedToken;\n updateBookmarklet(cachedToken);\n } catch {\n display.textContent = \"Error generating token. Try again.\";\n }\n};\n\nfunction updateBookmarklet(token) {\n const code = document.getElementById(\"bookmarklet-code\");\n const snippet = `// Paste in browser console or use as bookmarklet:\nfetch(\"${BASE_URL}/api/messages\", {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n \"Authorization\": \"Bearer ${token}\"\n },\n body: JSON.stringify({ content: \"Hello from my bookmarklet!\" })\n}).then(r => r.json()).then(console.log);`;\n code.textContent = snippet;\n}\n\nwindow.copyToken = function () {\n if (!cachedToken) return;\n navigator.clipboard.writeText(cachedToken).then(() => {\n const btn = document.querySelector(\".copy-btn\");\n btn.textContent = \"Copied ✓\";\n setTimeout(() => (btn.textContent = \"Copy\"), 2000);\n });\n};\n\nwindow.closeTokenModal = function (e) {\n if (!e || e.target.id === \"token-modal\") {\n document.getElementById(\"token-modal\").style.display = \"none\";\n }\n};\n\n// ─── Init — check if already logged in ────────────────────────────────────────\n(async () => {\n try {\n const res = await fetch(\"/api/me\");\n if (res.ok) {\n const data = await res.json();\n currentUser = data.user;\n showChat();\n }\n } catch { /* not logged in */ }\n})();\n",[],[89,115],"f8f9b20a-2ef7-11f1-a3d8-42dde27851f2","database","e057c3b1-c233-4139-b46f-1ca324d9d565",["D",1775177799201],[128,129],[123],{"_34":139,"_13":140,"_37":141,"_39":124,"_41":42,"_43":142,"_45":46,"_47":143,"_17":102,"_50":135,"_51":144,"_53":54,"_55":-5,"_76":145,"_18":146},{"_34":130,"_13":131,"_37":132,"_39":124,"_41":42,"_43":133,"_45":46,"_47":134,"_17":73,"_50":135,"_51":136,"_53":54,"_55":-5,"_76":137,"_18":138},"1b66a71e-2efb-11f1-b457-42dde27851f2","queries.ts","009ca616-2ef8-11f1-8561-42dde27851f2",17,["D",1775179145640],"script","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { createHmac, randomBytes } from \"node:crypto\";\n\nconst SECRET_KEY = Deno.env.get(\"CHAT_SECRET_KEY\") || \"default-secret-key-change-me\";\n\n// ─── Password Hashing ─────────────────────────────────────────────────────────\nexport function hashPassword(password: string): string {\n return createHmac(\"sha256\", SECRET_KEY).update(password).digest(\"hex\");\n}\nexport function verifyPassword(password: string, hash: string): boolean {\n return hashPassword(password) === hash;\n}\n\n// ─── Users ────────────────────────────────────────────────────────────────────\nexport async function createUser(\n username: string,\n password: string,\n): Promise<{ id: number; username: string; avatar_color: string } | null> {\n const colors = [\"#6366f1\", \"#ec4899\", \"#f59e0b\", \"#10b981\", \"#3b82f6\", \"#ef4444\", \"#8b5cf6\", \"#14b8a6\"];\n const color = colors[Math.floor(Math.random() * colors.length)];\n const hash = hashPassword(password);\n try {\n const result = await sqlite.execute({\n sql: `INSERT INTO users (username, password_hash, avatar_color) VALUES (?, ?, ?)`,\n args: [username, hash, color],\n });\n return { id: Number(result.lastInsertRowid), username, avatar_color: color };\n } catch {\n return null;\n }\n}\n\nexport async function getUserByCredentials(username: string, password: string) {\n const result = await sqlite.execute({\n sql: `SELECT id, username, avatar_color, password_hash FROM users WHERE username = ?`,\n args: [username],\n });\n if (!result.rows.length) return null;\n const user = result.rows[0] as { id: number; username: string; avatar_color: string; password_hash: string };\n if (!verifyPassword(password, user.password_hash)) return null;\n return { id: user.id, username: user.username, avatar_color: user.avatar_color };\n}\n\n// ─── Sessions ─────────────────────────────────────────────────────────────────\nexport async function createSession(userId: number): Promise {\n const sessionId = randomBytes(32).toString(\"hex\");\n const expiresAt = new Date(Date.now() + 7 * 24 * 60 * 60 * 1000).toISOString();\n await sqlite.execute({\n sql: `INSERT INTO sessions (id, user_id, expires_at) VALUES (?, ?, ?)`,\n args: [sessionId, userId, expiresAt],\n });\n return sessionId;\n}\n\nexport async function getSessionUser(sessionId: string) {\n const result = await sqlite.execute({\n sql: `SELECT u.id, u.username, u.avatar_color FROM sessions s\n JOIN users u ON u.id = s.user_id\n WHERE s.id = ? AND s.expires_at > datetime('now')`,\n args: [sessionId],\n });\n if (!result.rows.length) return null;\n return result.rows[0] as { id: number; username: string; avatar_color: string };\n}\n\nexport async function deleteSession(sessionId: string) {\n await sqlite.execute({ sql: `DELETE FROM sessions WHERE id = ?`, args: [sessionId] });\n}\n\n// ─── API Tokens ───────────────────────────────────────────────────────────────\nexport async function createApiToken(userId: number): Promise {\n const token = randomBytes(40).toString(\"hex\");\n await sqlite.execute({\n sql: `INSERT INTO api_tokens (token, user_id) VALUES (?, ?)`,\n args: [token, userId],\n });\n return token;\n}\n\nexport async function getUserByToken(token: string) {\n const result = await sqlite.execute({\n sql: `SELECT u.id, u.username, u.avatar_color FROM api_tokens t\n JOIN users u ON u.id = t.user_id WHERE t.token = ?`,\n args: [token],\n });\n if (!result.rows.length) return null;\n return result.rows[0] as { id: number; username: string; avatar_color: string };\n}\n\n// ─── Messages ─────────────────────────────────────────────────────────────────\nexport async function saveMessage(\n userId: number, username: string, avatarColor: string, content: string,\n): Promise {\n const result = await sqlite.execute({\n sql: `INSERT INTO messages (user_id, username, avatar_color, content) VALUES (?, ?, ?, ?)`,\n args: [userId, username, avatarColor, content],\n });\n return Number(result.lastInsertRowid);\n}\n\n/** Last N messages, only from the past 24 hours, oldest first */\nexport async function getRecentMessages(limit = 20) {\n const result = await sqlite.execute({\n sql: `SELECT id, username, avatar_color, content, created_at\n FROM messages\n WHERE created_at > datetime('now', '-24 hours')\n ORDER BY id DESC LIMIT ?`,\n args: [limit],\n });\n return (result.rows as {\n id: number; username: string; avatar_color: string; content: string; created_at: string;\n }[]).reverse();\n}\n\n/** New messages since lastId, only within 24 hours */\nexport async function getMessagesSince(lastId: number) {\n const result = await sqlite.execute({\n sql: `SELECT id, username, avatar_color, content, created_at\n FROM messages\n WHERE id > ? AND created_at > datetime('now', '-24 hours')\n ORDER BY id ASC`,\n args: [lastId],\n });\n return result.rows as {\n id: number; username: string; avatar_color: string; content: string; created_at: string;\n }[];\n}\n\n/** Delete messages older than 24 hours — call from a cleanup cron */\nexport async function deleteExpiredMessages() {\n const result = await sqlite.execute(\n `DELETE FROM messages WHERE created_at <= datetime('now', '-24 hours')`\n );\n return result.rowsAffected;\n}\n",[],[123,131],"606766a8-2ef8-11f1-a3f4-42dde27851f2","migrations.ts","f8f999f0-2ef7-11f1-a3d8-42dde27851f2",9,["D",1775177972912],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport async function runMigrations() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS users (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n username TEXT NOT NULL UNIQUE,\n password_hash TEXT NOT NULL,\n avatar_color TEXT NOT NULL DEFAULT '#6366f1',\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS sessions (\n id TEXT PRIMARY KEY,\n user_id INTEGER NOT NULL,\n created_at TEXT NOT NULL DEFAULT (datetime('now')),\n expires_at TEXT NOT NULL,\n FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE\n )\n `);\n\n // Long-lived tokens for bookmarklets / external API clients\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS api_tokens (\n token TEXT PRIMARY KEY,\n user_id INTEGER NOT NULL,\n created_at TEXT NOT NULL DEFAULT (datetime('now')),\n FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS messages (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_id INTEGER NOT NULL DEFAULT 0,\n username TEXT NOT NULL,\n avatar_color TEXT NOT NULL DEFAULT '#94a3b8',\n content TEXT NOT NULL,\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n )\n `);\n}\n",[],[123,140],["D",1775178334898],[150],[19],{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":151,"_17":49,"_50":24,"_51":52,"_53":54,"_55":-5,"_76":152,"_18":153},["D",1775179232123],[],[19,36],"f42a4ed8-2ef7-11f1-ab55-42dde27851f2",["D",1775177791326],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Live groupchat with user auth and secure data storage","imageUrl","userId","019d50d6-6e5e-72f9-bffe-0f2f8a74be8e","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","019d50d6-6e5e-72f9-bffe-12eb0819d881","tursoName","f42a4ed82ef711f1ab5542dde27851f2","tursoHostname","f42a4ed82ef711f1ab5542dde27851f2-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789516253896],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_210":206},"org",{"_11":12,"_204":-5,"_205":206,"_164":165,"_207":208,"_209":54},"branch",{"_17":44,"_13":16,"_34":42,"_196":154,"_197":-5,"_198":-5,"_199":-5,"_200":-5,"_201":-5,"_202":14,"_203":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzNCcEVmOEdvazVHU1JjUXNpbkJpOUpRVFE1YSJ9","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_34":154,"_13":14,"_47":275,"_156":-5,"_157":54,"_158":159,"_160":159,"_161":162,"_163":-5,"_164":165,"_166":-5,"_167":54,"_168":-5,"_169":-5,"_170":60,"_171":172,"_173":174,"_175":176,"_177":276,"_179":-5,"_180":181,"_182":181,"_183":184,"_185":184,"_186":184,"_187":181,"_188":181,"_189":277,"_191":278,"_193":279,"_195":54},[242,244,247,251,252],"files",[242,243,244,245,246,247,248,249,250,251,252],"counts",{"_233":60,"_234":102,"_235":60,"_32":236,"_237":238},[231],{"_34":57,"_13":19,"_37":40,"_39":-5,"_41":42,"_43":58,"_45":46,"_47":59,"_17":60,"_50":61,"_51":-5,"_53":54,"_55":-5,"_18":230},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[19],{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_17":49,"_50":24,"_51":52,"_53":54,"_55":-5,"_18":232},[19,36],"pulls","branches","forks",{"_239":60,"_241":60},"connections",{"_239":60,"_240":60},"count","unfilledCount","emptyCount",{"_34":57,"_13":19,"_37":40,"_39":-5,"_41":42,"_43":58,"_45":46,"_47":147,"_17":60,"_50":61,"_51":-5,"_53":54,"_55":-5,"_76":273,"_18":274},{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":151,"_17":49,"_50":24,"_51":52,"_53":54,"_55":-5,"_76":271,"_18":272},{"_34":122,"_13":123,"_37":124,"_39":-5,"_41":42,"_43":102,"_45":46,"_47":125,"_17":60,"_50":61,"_51":-5,"_53":54,"_55":-5,"_76":269,"_18":270},{"_34":139,"_13":140,"_37":141,"_39":124,"_41":42,"_43":142,"_45":46,"_47":143,"_17":102,"_50":135,"_51":144,"_53":54,"_55":-5,"_76":267,"_18":268},{"_34":130,"_13":131,"_37":132,"_39":124,"_41":42,"_43":133,"_45":46,"_47":134,"_17":73,"_50":135,"_51":136,"_53":54,"_55":-5,"_76":265,"_18":266},{"_34":88,"_13":89,"_37":90,"_39":-5,"_41":42,"_43":49,"_45":46,"_47":91,"_17":60,"_50":61,"_51":-5,"_53":54,"_55":-5,"_76":263,"_18":264},{"_34":114,"_13":115,"_37":116,"_39":90,"_41":42,"_43":117,"_45":46,"_47":118,"_17":102,"_50":24,"_51":119,"_53":54,"_55":-5,"_76":261,"_18":262},{"_34":106,"_13":107,"_37":108,"_39":90,"_41":42,"_43":109,"_45":46,"_47":110,"_17":102,"_50":24,"_51":111,"_53":54,"_55":-5,"_76":259,"_18":260},{"_34":97,"_13":98,"_37":99,"_39":90,"_41":42,"_43":100,"_45":46,"_47":101,"_17":102,"_50":24,"_51":103,"_53":54,"_55":-5,"_76":257,"_18":258},{"_34":79,"_13":80,"_37":81,"_39":-5,"_41":42,"_43":82,"_45":46,"_47":83,"_17":60,"_50":84,"_51":85,"_53":54,"_55":-5,"_76":255,"_18":256},{"_34":68,"_13":69,"_37":70,"_39":-5,"_41":42,"_43":71,"_45":46,"_47":72,"_17":73,"_50":74,"_51":75,"_53":54,"_55":-5,"_76":253,"_18":254},[],[69],[],[80],[],[89,98],[],[89,107],[],[89,115],[248,249,250],[89],[],[123,131],[],[123,140],[245,246],[123],[],[19,36],[243],[19],["D",1775177791326],["D",1789516253896],{"_11":12,"_210":206},{"_11":12,"_204":-5,"_205":206,"_164":165,"_207":208,"_209":54},{"_17":44,"_13":16,"_34":42,"_196":154,"_197":-5,"_198":-5,"_199":-5,"_200":-5,"_201":-5,"_202":14,"_203":12},"ctx",{"_189":-5,"_227":313,"_314":315,"_316":317,"_318":54,"_319":54,"_320":54,"_321":46,"_322":-5,"_323":-7,"_324":-7,"_325":60,"_326":54,"_327":54,"_328":-5,"_329":54,"_330":54,"_331":54,"_332":-5},"ENV",{"_284":285,"_286":287,"_288":16,"_289":290,"_291":292,"_293":294,"_295":296,"_297":298,"_299":300,"_301":302,"_303":304,"_305":306,"_307":308,"_309":310,"_311":312},"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"]

🔑 Your API Token