[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_180":181,"_182":183},"routes/_app.x.$handle.$name",{"_96":95,"_32":45,"_104":86,"_27":98,"_13":14,"_105":-5,"_11":106,"_107":108,"_109":110,"_111":112,"_113":114,"_20":-5,"_115":-5,"_116":-5,"_117":25,"_118":119,"_120":58,"_121":-5,"_122":-5,"_123":124},"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":31,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":79,"_80":81,"_82":83,"_84":25},"version",18,"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","main.ts","latestPath","fileId","2b9822b4-5cf7-11f1-882d-1607ee4eb77e","name","fileType","http","content","import { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\n\n// カラム追加にともない、テーブルバージョンを v2 に変更しました\nconst TABLE = \"rtchat_messages_v2\";\n\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n room TEXT NOT NULL,\n user_id TEXT NOT NULL,\n name TEXT NOT NULL,\n body TEXT NOT NULL,\n created_at INTEGER NOT NULL\n )\n`);\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n\n // --- API: メッセージ取得 ---\n if (url.pathname === \"/api/messages\") {\n const room = url.searchParams.get(\"room\") || \"lobby\";\n const since = Number(url.searchParams.get(\"since\") || \"0\");\n const result = await sqlite.execute({\n // user_id も取得するようにSQLを変更\n sql: `SELECT id, user_id, name, body, created_at FROM ${TABLE}\n WHERE room = ? AND id > ? ORDER BY id ASC LIMIT 200`,\n args: [room, since],\n });\n const messages = result.rows.map((r) => ({\n id: r[0],\n user_id: r[1],\n name: r[2],\n body: r[3],\n created_at: r[4],\n }));\n return Response.json({ messages });\n }\n\n // --- API: メッセージ送信 ---\n if (url.pathname === \"/api/send\" && req.method === \"POST\") {\n const { room, user_id, name, body } = await req.json();\n const cleanRoom = String(room || \"lobby\").slice(0, 60);\n const cleanUserId = String(user_id || \"unknown\").slice(0, 50);\n const cleanName = String(name || \"名無し\").slice(0, 40);\n const cleanBody = String(body || \"\").slice(0, 2000).trim();\n\n if (!cleanBody) return Response.json({ error: \"empty\" }, { status: 400 });\n\n // user_id を含めてインサート\n await sqlite.execute({\n sql:\n `INSERT INTO ${TABLE} (room, user_id, name, body, created_at) VALUES (?, ?, ?, ?, ?)`,\n args: [cleanRoom, cleanUserId, cleanName, cleanBody, Date.now()],\n });\n return Response.json({ ok: true });\n }\n\n // --- 静的ファイル ---\n if (url.pathname === \"/client.js\") {\n return serveFile(\"./client.js\", import.meta.url);\n }\n\n // --- HTML ---\n const html = await readFile(\"./index.html\", import.meta.url);\n return new Response(html, {\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n}","import { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\n\n// 変更: 画像URL（Base64）を追加するためにテーブルバージョンを v3 に変更\nconst TABLE = \"rtchat_messages_v3\";\n\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n room TEXT NOT NULL,\n user_id TEXT NOT NULL,\n name TEXT NOT NULL,\n body TEXT NOT NULL,\n image_url TEXT,\n created_at INTEGER NOT NULL\n )\n`);\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n\n // --- API: メッセージ取得 ---\n if (url.pathname === \"/api/messages\") {\n const room = url.searchParams.get(\"room\") || \"lobby\";\n const since = Number(url.searchParams.get(\"since\") || \"0\");\n\n // 変更: image_url もセレクトするように変更\n const result = await sqlite.execute({\n sql: `SELECT id, user_id, name, body, image_url, created_at FROM ${TABLE}\n WHERE room = ? AND id > ? ORDER BY id ASC`,\n args: [room, since],\n });\n\n // 取得したレコードをオブジェクト配列にマップ\n const messages = result.rows.map((row) => ({\n id: Number(row[0]),\n user_id: String(row[1]),\n name: String(row[2]),\n body: String(row[3]),\n image_url: row[4] ? String(row[4]) : \"\",\n created_at: Number(row[5]),\n }));\n\n return new Response(JSON.stringify({ messages }), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n // --- API: メッセージ送信 ---\n if (url.pathname === \"/api/send\" && req.method === \"POST\") {\n try {\n const data = await req.json();\n const room = data.room || \"lobby\";\n const user_id = data.user_id || \"unknown\";\n const name = data.name || \"名無し\";\n const body = data.body || \"\";\n const image_url = data.image_url || \"\"; // 追加\n const created_at = Date.now();\n\n // 変更: image_url をバインドしてINSERT\n await sqlite.execute({\n sql:\n `INSERT INTO ${TABLE} (room, user_id, name, body, image_url, created_at)\n VALUES (?, ?, ?, ?, ?, ?)`,\n args: [room, user_id, name, body, image_url, created_at],\n });\n\n return new Response(JSON.stringify({ success: true }), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n } catch (err) {\n return new Response(JSON.stringify({ error: String(err) }), {\n status: 400,\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n }\n\n // --- 静的ファイルの配信 ---\n if (url.pathname === \"/\" || url.pathname === \"/index.html\") {\n return serveFile(req, \"./index.html\");\n }\n if (url.pathname === \"/client.js\") {\n return serveFile(req, \"./client.js\");\n }\n\n return new Response(\"Not Found\", { status: 404 });\n}","createdAt",["D",1780245643733],"branchVersion","branchId","22c90180-5cf7-11f1-882d-1607ee4eb77e","id","22c84542-5cf7-11f1-882d-1607ee4eb77e","Test",["D",1780235193541],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","チャット","imageUrl","4e63582b-038f-4e64-ae21-6b505dc48848","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019e7e46-1daf-71f5-8305-66ffe737bab8","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_96":95,"_103":98},"org",{"_96":95,"_97":98,"_99":98,"_18":55,"_100":101,"_102":25},"branch",{"_13":85,"_32":86,"_43":42,"_87":44,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":45,"_94":95},"isOwned",20,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","nanana","handle","displayName","","avatar","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_43":44,"_32":45,"_38":176,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":31,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":177,"_80":178,"_82":179,"_84":25},"tree",[163,164,165],"files",[163,164,165],"counts",{"_152":62,"_153":154,"_155":62,"_156":157,"_158":159},"contents",[125,126,127],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":143,"_32":144,"_30":145,"_129":-5,"_41":42,"_40":146,"_130":58,"_38":147,"_13":148,"_33":149,"_35":150,"_24":25,"_133":-5,"_27":151},{"_43":135,"_32":136,"_30":137,"_129":-5,"_41":42,"_40":138,"_130":58,"_38":139,"_13":140,"_33":20,"_35":141,"_24":25,"_133":-5,"_27":142},{"_43":128,"_32":28,"_30":31,"_129":-5,"_41":42,"_40":14,"_130":25,"_38":131,"_13":132,"_33":34,"_35":37,"_24":25,"_133":-5,"_27":134},"7798052c-5d0f-11f1-b41a-1607ee4eb77e","parentId","latest",["D",1780245643733],2,"label",[28],"5769ba02-5d0f-11f1-a058-1607ee4eb77e","index.html","371809c4-5cf7-11f1-a193-1607ee4eb77e",16,["D",1780245589744],9,"\n\n \n \n \n \n あああ\n \n \n \n

あああ

\n #lobby\n

\n 名前\n \n 招待リンクをコピー\n

まだメッセージはありません

\n \n \n",[136],"67ce2fd6-5d0f-11f1-a523-1607ee4eb77e","client.js","3dbbe50c-5cf7-11f1-9ebe-1607ee4eb77e",17,["D",1780245617242],4,"script","// 部屋IDはURLのハッシュ (#room) で決まる。なければランダム生成してURLに付与。\nfunction getRoom() {\n let room = location.hash.replace(/^#/, \"\");\n if (!room) {\n room = Math.random().toString(36).slice(2, 8);\n location.hash = room;\n }\n return room;\n}\n\n// ユーザーIDを取得または生成（名前が被っても自分を特定できるようにする）\nfunction getUserId() {\n let id = localStorage.getItem(\"chatUserId\");\n if (!id) {\n id = Math.random().toString(36).slice(2, 12) + Date.now().toString(36);\n localStorage.setItem(\"chatUserId\", id);\n }\n return id;\n}\n\nconst room = getRoom();\nconst myUserId = getUserId();\nconst messagesEl = document.getElementById(\"messages\");\nconst composer = document.getElementById(\"composer\");\nconst bodyInput = document.getElementById(\"body\");\nconst nameInput = document.getElementById(\"name\");\nconst roomLabel = document.getElementById(\"roomLabel\");\nconst invite = document.getElementById(\"invite\");\n// 追加\nconst fileInput = document.getElementById(\"imageFile\");\nconst fileLabel = document.getElementById(\"fileLabel\");\n\nroomLabel.textContent = \"#\" + room;\n\n// 名前を保存\nnameInput.value = localStorage.getItem(\"chatName\") || \"\";\n\nnameInput.addEventListener(\"input\", () => {\n localStorage.setItem(\"chatName\", nameInput.value);\n});\n\n// 追加: ファイルが選択されたらクリップのUIの色を変える\nfileInput.addEventListener(\"change\", () => {\n if (fileInput.files.length > 0) {\n fileLabel.classList.add(\"has-file\");\n } else {\n fileLabel.classList.remove(\"has-file\");\n }\n});\n\n// 招待リンクコピー\ninvite.addEventListener(\"click\", async () => {\n try {\n await navigator.clipboard.writeText(location.href);\n invite.textContent = \"コピーしました！\";\n\n setTimeout(() => {\n invite.textContent = \"招待リンクをコピー\";\n }, 1800);\n } catch (err) {\n console.error(err);\n }\n});\n\nlet lastId = 0;\nlet firstLoad = true;\nlet sending = false;\n\n// 重複描画防止\nconst renderedIds = new Set();\n\nfunction fmtTime(ts) {\n const d = new Date(ts);\n\n return (\n d.getHours().toString().padStart(2, \"0\") +\n \":\" +\n d.getMinutes().toString().padStart(2, \"0\")\n );\n}\n\nfunction escapeHtml(s) {\n if (!s) return \"\";\n return s.replace(/[&<>\"']/g, (c) => ({\n \"&\": \"&\",\n \"<\": \"<\",\n \">\": \">\",\n '\"': \""\",\n \"'\": \"'\",\n }[c]));\n}\n\n// 追加: ファイルをBase64文字列に変換するヘルパー\nfunction fileToBase64(file) {\n return new Promise((resolve, reject) => {\n const reader = new FileReader();\n reader.readAsDataURL(file);\n reader.onload = () => resolve(reader.result);\n reader.onerror = (error) => reject(error);\n });\n}\n\nfunction render(messages) {\n if (firstLoad) {\n messagesEl.innerHTML = \"\";\n firstLoad = false;\n }\n\n for (const m of messages) {\n // 同じメッセージを二回描画しない\n if (renderedIds.has(m.id)) {\n continue;\n }\n\n renderedIds.add(m.id);\n\n const wrap = document.createElement(\"div\");\n\n // 名前ではなく、システム的に発行したuser_idで自分の発言か判定\n const mine = m.user_id === myUserId;\n\n wrap.className = \"msg \" + (mine ? \"me\" : \"them\");\n\n // 変更: 画像データ(m.image_url)がある場合はimgタグを追加する\n let imgHtml = \"\";\n if (m.image_url) {\n imgHtml =\n ` $\"uploaded$ `;\n }\n\n wrap.innerHTML = '

' +\n escapeHtml(m.name) +\n \" ・ \" +\n fmtTime(m.created_at) +\n \"

\" +\n '

' +\n escapeHtml(m.body) +\n imgHtml +\n \"

\";\n\n messagesEl.appendChild(wrap);\n\n lastId = Math.max(lastId, m.id);\n }\n\n messagesEl.scrollTop = messagesEl.scrollHeight;\n}\n\nasync function poll() {\n try {\n const res = await fetch(\n \"/api/messages?room=\" +\n encodeURIComponent(room) +\n \"&since=\" +\n lastId,\n );\n\n const data = await res.json();\n\n if (data.messages && data.messages.length) {\n render(data.messages);\n }\n } catch (err) {\n console.error(err);\n }\n}\n\ncomposer.addEventListener(\"submit\", async (e) => {\n e.preventDefault();\n\n if (sending) return;\n\n const body = bodyInput.value.trim();\n const file = fileInput.files[0];\n\n // テキストも画像もない場合は何もしない\n if (!body && !file) return;\n\n sending = true;\n bodyInput.disabled = true;\n\n try {\n // 追加: 画像があればBase64文字列に変換\n let imageUrl = \"\";\n if (file) {\n imageUrl = await fileToBase64(file);\n }\n\n await fetch(\"/api/send\", {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({\n room,\n user_id: myUserId,\n name: nameInput.value || \"名無し\",\n body,\n image_url: imageUrl, // 追加: 画像のBase64文字列を送る\n }),\n });\n\n bodyInput.value = \"\";\n fileInput.value = \"\"; // ファイル選択をリセット\n fileLabel.classList.remove(\"has-file\");\n\n await poll();\n } catch (err) {\n console.error(err);\n } finally {\n bodyInput.disabled = false;\n bodyInput.focus();\n sending = false;\n }\n});\n\npoll();\nsetInterval(poll, 1500);",[144],"pulls","branches",1,"forks","envVars",{"_160":62,"_162":62},"connections",{"_160":62,"_161":62},"count","unfilledCount","emptyCount",{"_43":143,"_32":144,"_30":145,"_129":-5,"_41":42,"_40":146,"_130":58,"_38":173,"_13":148,"_33":149,"_35":150,"_24":25,"_133":-5,"_167":174,"_27":175},{"_43":135,"_32":136,"_30":137,"_129":-5,"_41":42,"_40":138,"_130":58,"_38":170,"_13":140,"_33":20,"_35":141,"_24":25,"_133":-5,"_167":171,"_27":172},{"_43":128,"_32":28,"_30":31,"_129":-5,"_41":42,"_40":14,"_130":25,"_38":166,"_13":132,"_33":34,"_35":37,"_24":25,"_133":-5,"_167":168,"_27":169},["D",1780245643733],"children",[],[28],["D",1780245589744],[],[136],["D",1780245617242],[],[144],["D",1780235193541],{"_96":95,"_103":98},{"_96":95,"_97":98,"_99":98,"_18":55,"_100":101,"_102":25},{"_13":85,"_32":86,"_43":42,"_87":44,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":45,"_94":95},"ctx",{"_78":-5,"_122":213,"_214":215,"_216":217,"_218":25,"_219":25,"_220":25,"_221":58,"_222":-5,"_223":-7,"_224":-7,"_225":62,"_226":25,"_227":25,"_228":-5,"_229":25,"_230":25,"_231":25,"_232":-5},"ENV",{"_184":185,"_186":187,"_188":86,"_189":190,"_191":192,"_193":194,"_195":196,"_197":198,"_199":200,"_201":202,"_203":204,"_205":206,"_207":208,"_209":210,"_211":212},"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 · v18