[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_213":214,"_215":216},"routes/_app.x.$handle.$name",{"_97":96,"_32":43,"_106":87,"_27":107,"_13":14,"_108":-5,"_11":109,"_110":111,"_112":113,"_114":115,"_116":117,"_20":-5,"_118":-5,"_119":-5,"_120":47,"_121":122,"_123":25,"_124":-5,"_125":-5,"_126":127},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_41":42,"_32":43,"_36":44,"_45":-5,"_46":47,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":55,"_56":25,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":64,"_65":66,"_67":68,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":80,"_81":82,"_83":84,"_85":47},"version",277,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":20,"_34":35,"_36":37,"_38":14,"_39":40,"_24":25},"previous",{"_30":31,"_32":28,"_33":20,"_34":35},"deleted",true,"deletedHere","path","deno.json","latestPath","fileId","e494cd2e-a862-11f1-ad37-1607ee4eb77e","name","fileType","content","{\n \"$schema\": \"https://raw.githubusercontent.com/denoland/deno/98f62cee78e85bfc47c62ed703777c6bc8794f1c/cli/schemas/config-file.v1.json\",\n \"lock\": false,\n \"compilerOptions\": {\n \"noImplicitAny\": false,\n \"strict\": true,\n \"types\": [\"https://www.val.town/types/valtown.d.ts\"],\n \"lib\": [\n \"dom\",\n \"dom.iterable\",\n \"dom.asynciterable\",\n \"deno.ns\",\n \"deno.unstable\"\n ]\n },\n \"lint\": {\n \"include\": [\"deno:/https/esm.town/**/*\"],\n \"rules\": {\n \"exclude\": [\"no-explicit-any\"]\n }\n },\n \"node_modules_dir\": false,\n \"experimental\": {\n \"unstable-node-globals\": true,\n \"unstable-temporal\": true,\n \"unstable-worker-options\": true,\n \"unstable-sloppy-imports\": true\n }\n}","createdAt",["D",1788528142925],"branchVersion","branchId","a669a274-1d8e-4aec-b258-6ada72f2e9bb","id","9d4dc10d-0136-4985-94f6-6b0bf535e31e","Aguking_Stack",["D",1787817154621],"deletedAt","legacyEnvVars",false,"privacy","public","httpPrivacy","description","imageUrl","d7bd44ad-648e-46fe-b25e-97dc3e998420","pinnedFileId","e746b2fa-a4ff-11f1-8cae-1607ee4eb77e","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","01a04226-b52a-76ab-bc3d-16937b891876","tursoName","9d4dc10d0136498594f66b0bf535e31e","tursoHostname","9d4dc10d0136498594f66b0bf535e31e-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789583507842],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_97":96,"_105":101},"org",{"_97":96,"_98":99,"_100":101,"_18":53,"_102":103,"_104":47},"branch",{"_13":86,"_32":87,"_41":40,"_88":42,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":43,"_95":96},"isOwned",415,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","Steven_Jin","handle","displayName","Steven-J-KY","avatar","https://avatars.githubusercontent.com/u/321694553?v=4","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_41":42,"_32":43,"_36":208,"_45":-5,"_46":47,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":55,"_56":25,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":64,"_65":66,"_67":209,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":210,"_81":211,"_83":212,"_85":47},"tree",[187,188,189,190,191],"files",[187,188,189,190,191],"counts",{"_175":60,"_176":177,"_178":60,"_179":180,"_181":182},"contents",[128,129,130,131,132],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_41":168,"_32":169,"_30":170,"_136":-5,"_39":40,"_38":171,"_138":47,"_36":172,"_13":60,"_33":20,"_34":173,"_24":47,"_143":-5,"_27":174},{"_41":161,"_32":162,"_30":163,"_136":-5,"_39":40,"_38":164,"_138":47,"_36":165,"_13":60,"_33":20,"_34":166,"_24":47,"_143":-5,"_27":167},{"_41":154,"_32":155,"_30":156,"_136":-5,"_39":40,"_38":157,"_138":47,"_36":158,"_13":60,"_33":141,"_34":159,"_24":47,"_143":-5,"_27":160},{"_41":146,"_32":147,"_30":55,"_136":-5,"_39":40,"_38":148,"_138":47,"_36":149,"_13":150,"_33":141,"_34":151,"_24":47,"_143":152,"_27":153},{"_41":133,"_32":134,"_30":135,"_136":-5,"_39":40,"_38":137,"_138":47,"_36":139,"_13":140,"_33":141,"_34":142,"_24":47,"_143":144,"_27":145},"0ae48fc6-cb1a-4584-94c8-76cee46c075c","youtube-notice-bot.ts","31ef2e96-a5e5-11f1-aa35-1607ee4eb77e","parentId",154,"latest",["D",1788264306338],26,"http","/**\n * YouTube Live Stream Viewer for Val Town\n * 암본이수혁 (aguking) 유튜브 채널의 라이브 방송을 볼 수 있는 화면\n */\n\nconst CHANNEL_ID = \"UC1LiqB9tfyRge5fZ2-7BTVQ\";\nconst CHANNEL_NAME = \"암본이수혁 (aguking)\";\nconst CHANNEL_URL =\n \"https://www.youtube.com/@%EC%97%B0%EC%97%94%ED%84%B0%EC%9D%B4%EC%88%98%ED%98%81\";\nconst CHECK_INTERVAL_MS = 15 * 60_000;\n\ntype LiveResult =\n | { live: true; videoId: string; title: string }\n | { live: false; reason?: string };\n\nasync function findCurrentLive(): Promise {\n const apiKey = Deno.env.get(\"YOUTUBE_API_KEY\")?.trim();\n\n if (!apiKey) {\n return {\n live: false,\n reason: \"Val Town Secrets에 YOUTUBE_API_KEY가 설정되지 않았습니다.\",\n };\n }\n\n const params = new URLSearchParams({\n part: \"snippet\",\n channelId: CHANNEL_ID,\n eventType: \"live\",\n type: \"video\",\n order: \"date\",\n maxResults: \"1\",\n key: apiKey,\n });\n\n try {\n const response = await fetch(\n `https://www.googleapis.com/youtube/v3/search?${params.toString()}`,\n );\n\n if (!response.ok) {\n const detail = await response.text();\n console.error(\"YouTube API error:\", response.status, detail);\n return {\n live: false,\n reason:\n `YouTube API 요청 오류 (${response.status}). API 키와 YouTube Data API v3 활성화 상태를 확인하세요.`,\n };\n }\n\n const data = await response.json();\n const item = data.items?.[0];\n const videoId = item?.id?.videoId;\n\n if (!videoId || !/^[A-Za-z0-9_-]{11}$/.test(videoId)) {\n return { live: false };\n }\n\n return {\n live: true,\n videoId,\n title: item?.snippet?.title || \"YouTube Live\",\n };\n } catch (error) {\n console.error(\"YouTube API request failed:\", error);\n return {\n live: false,\n reason: \"YouTube API 연결에 실패했습니다. 잠시 후 다시 시도합니다.\",\n };\n }\n}\n\nfunction escapeHtml(value: string): string {\n return value.replace(/[&<>'\"]/g, (character) => {\n const entities: Record = {\n \"&\": \"&\",\n \"<\": \"<\",\n \">\": \">\",\n \"'\": \"'\",\n '\"': \""\",\n };\n return entities[character];\n });\n}\n\nfunction renderPage(origin: string): string {\n const liveApiUrl = `${origin}?api=live`;\n\n return `\n\n\n \n \n \n ${escapeHtml(CHANNEL_NAME)} 라이브\n \n\n\n

🎬 ${escapeHtml(CHANNEL_NAME)}

YouTube 라이브 시청 · 채팅

라이브 상태 확인 중…

\n\n

라이브 상태를 확인하고 있습니다

잠시만 기다려 주세요.

\n \n

\n\n

15분마다 새 라이브 여부를 자동으로 확인합니다.

\n YouTube 채널에서 열기\n

\n\n \n

\n\n \n\n`;\n}\n\nexport default async function handler(request: Request): Promise {\n const url = new URL(request.url);\n\n if (url.searchParams.get(\"api\") === \"live\") {\n return Response.json(await findCurrentLive(), {\n headers: { \"cache-control\": \"no-store\" },\n });\n }\n\n return new Response(renderPage(url.origin), {\n headers: {\n \"content-type\": \"text/html; charset=utf-8\",\n \"cache-control\": \"no-store\",\n },\n });\n}","label","aguking-live",[134],"9e18e128-ad17-462b-9e8e-7a00891dfc47","main.ts",275,["D",1788527812156],144,"// Update. 2026-09-05. ver. 2.3 - 전송 테스트\n//\n// 변경사항\n// 1. \"암본이수혁 aguking\" → \"암본이수혁aguking\" 통일\n// 2. 기존 데이터 자동 마이그레이션\n// 3. Admin 403 문제 수정 — credentials: \"same-origin\" 유지\n// 4. Admin API 오류 표시 개선\n// 5. 음수/0 수량 입력 방지\n// 6. Monitor / History / Admin / YouTube 자동 초기화 유지\n// 7. [수정] /monitor, /admin 에서 API 호출 경로 문제 해결 — window.location.origin 사용\n// 8. [수정] 채널명 검증 강화 — 빈 문자열, 100 자 초과, 제어 문자 차단\n// 9. [수정] normalizeChannel 안전 처리 — 빈 값이면 PRIMARY_CHANNEL 반환\n//\n// 보안\n// - Stack API: 관리자 Basic Auth + Nightbot key 호환\n// - Admin Basic 인증\n// - YouTube check secret fail-closed\n// - Admin maintenance Origin / Referer 검증\n// - DOM textContent 기반 렌더링\n//\n// Nightbot\n// !스택 $(urlfetch $(eval `https://aguking-stack.val.run/?ch=${encodeURIComponent(\"$(channel)\")}&q=${encodeURIComponent(\"$(querystring)\")}&key=A`))\n//\n// Timer\n// $(urlfetch $(eval `https://aguking-stack.val.run/?ch=${encodeURIComponent(\"$(channel)\")}&q=&key=A`))\n\nconst EMOJI_MAP: Record = {\n \"금연\": \"🚭\",\n \"흡연\": \"🚬\",\n \"먹어\": \"🍚\",\n \"먹지마\": \"🚫\",\n \"짠\": \"🍻\",\n \"오늘의 재미\": \"🤣\",\n \"무서움 지수\": \"👻\",\n};\n\n// 현재 사용하는 정식 채널명\nconst PRIMARY_CHANNEL = \"암본이수혁aguking\";\n\n// 기존에 사용하던 채널명\nconst LEGACY_CHANNELS = [\n \"암본이수혁 aguking\",\n];\n\n// 채널 표시 이름\nconst CHANNEL_NAME_MAP: Record = {\n [PRIMARY_CHANNEL]: PRIMARY_CHANNEL,\n \"암본이수혁 aguking\": PRIMARY_CHANNEL,\n};\n\nconst AUTO_REFRESH_INTERVAL_MS = 15000;\n\nfunction label(item: string): string {\n const emoji = EMOJI_MAP[item];\n return emoji ? `${emoji} ${item}` : item;\n}\n\nfunction channelLabel(ch: string): string {\n return CHANNEL_NAME_MAP[ch] || ch;\n}\n\n// ─────────────────────────────────────────────\n// Monitor HTML\n// ─────────────────────────────────────────────\n\nconst MONITOR_HTML = `\n\n\n\n\nStack Monitoring\n\n\n\n\n\n

\n\n\n\n

\n\n채널\n\n

\n \n\n \n

\n\n

\n\n\n\n

\n\n

\n 불러오는 중...\n

\n\n\n\n

\n\n\n\n\n`;\n\n// ─────────────────────────────────────────────\n// Admin HTML\n// ─────────────────────────────────────────────\n\nconst ADMIN_HTML = `\n\n\n\n\nStack Admin\n\n\n\n\n\n

\n\n

Stack Admin · aguking-stack

\n\n

\n\n\n \n Maintenance mode\n\n\n

\n 상태 확인 중...\n

\n\n

\n\n채널\n\n

\n \n\n \n

\n\n

\n\n\n\n

\n\n

\n 불러오는 중...\n

\n\n\n\n

\n\n\n\n\n`;\n\n// ─────────────────────────────────────────────\n// History HTML (기존 유지, API 경로만 동일하게 수정)\n// ─────────────────────────────────────────────\n\nconst HISTORY_HTML = `\n\n\n\n\nStack History\n\n\n\n\n\n

\n\n\n\n

\n\n채널\n\n

\n\n\n\n\n\n

\n\n

\n\n\n\n

\n\n

\n기록을 불러오는 중...\n

\n\n

\n\n\n\n\n\n\n`;\n\n// ─────────────────────────────────────────────\n// 관리자 인증\n// ─────────────────────────────────────────────\n\ntype AdminAccount = {\n username: string;\n password: string;\n};\n\nfunction getAdminAccounts(): Map {\n const rawAccounts = Deno.env.get(\"ADMIN_ACCOUNTS\") || \"\";\n const accounts = new Map();\n\n for (const entry of rawAccounts.split(\",\")) {\n const separatorIndex = entry.indexOf(\":\");\n if (separatorIndex <= 0) continue;\n\n const username = entry.slice(0, separatorIndex).trim();\n const password = entry.slice(separatorIndex + 1).trim();\n\n if (username && password) {\n accounts.set(username, password);\n }\n }\n\n return accounts;\n}\n\nfunction timingSafeEqualText(a: string, b: string): boolean {\n const left = new TextEncoder().encode(a);\n const right = new TextEncoder().encode(b);\n let diff = left.length ^ right.length;\n const length = Math.max(left.length, right.length);\n\n for (let i = 0; i < length; i++) {\n diff |= (left[i] || 0) ^ (right[i] || 0);\n }\n\n return diff === 0;\n}\n\nasync function sha256Hex(value: string): Promise {\n const data = new TextEncoder().encode(value);\n const digest = await crypto.subtle.digest(\"SHA-256\", data);\n return Array.from(new Uint8Array(digest))\n .map((b) => b.toString(16).padStart(2, \"0\"))\n .join(\"\");\n}\n\nasync function checkAuth(req: Request): Promise {\n const accounts = getAdminAccounts();\n if (!accounts.size) return false;\n\n const authHeader = req.headers.get(\"authorization\") || \"\";\n if (!authHeader.startsWith(\"Basic \")) return false;\n\n try {\n const decoded = atob(authHeader.slice(\"Basic \".length));\n const separatorIndex = decoded.indexOf(\":\");\n if (separatorIndex < 0) return false;\n\n const inputUser = decoded.slice(0, separatorIndex).trim();\n const inputPassword = decoded.slice(separatorIndex + 1);\n const stored = accounts.get(inputUser);\n if (!stored) return false;\n\n if (stored.startsWith(\"sha256$\")) {\n const expectedHash = stored.slice(\"sha256$\".length);\n const actualHash = await sha256Hex(inputPassword);\n return timingSafeEqualText(actualHash, expectedHash);\n }\n\n return timingSafeEqualText(inputPassword, stored);\n } catch {\n return false;\n }\n}\n\n// ─────────────────────────────────────────────\n// Stack API 인증\n// ─────────────────────────────────────────────\n\nconst STACK_API_SECRET = Deno.env.get(\"STACK_API_SECRET\") || \"\";\n\nfunction checkStackApiKey(req: Request): boolean {\n if (!STACK_API_SECRET) return false;\n\n const headerKey = req.headers.get(\"x-stack-key\");\n if (headerKey) return timingSafeEqualText(headerKey, STACK_API_SECRET);\n\n const url = new URL(req.url);\n const queryKey = url.searchParams.get(\"key\");\n return !!queryKey && timingSafeEqualText(queryKey, STACK_API_SECRET);\n}\n\nasync function checkStackCommandAuth(req: Request): Promise {\n if (await checkAuth(req)) return true;\n return checkStackApiKey(req);\n}\n\nfunction forbiddenResponse(): Response {\n return new Response(\"권한이 없습니다.\", {\n status: 403,\n headers: { \"content-type\": \"text/plain; charset=utf-8\" },\n });\n}\n\nfunction unauthorizedResponse(): Response {\n return new Response(\"인증이 필요합니다.\", {\n status: 401,\n headers: {\n \"content-type\": \"text/plain; charset=utf-8\",\n \"WWW-Authenticate\": 'Basic realm=\"Admin Area\", charset=\"UTF-8\"',\n },\n });\n}\n\nfunction htmlResponse(html: string): Response {\n return new Response(html, {\n headers: {\n \"content-type\": \"text/html; charset=utf-8\",\n \"cache-control\": \"no-store\",\n \"x-content-type-options\": \"nosniff\",\n \"referrer-policy\": \"no-referrer\",\n },\n });\n}\n\n// ─────────────────────────────────────────────\n// Maintenance\n// ─────────────────────────────────────────────\n\nconst MAINTENANCE_KEY = \"system_maintenance\";\nconst MAINTENANCE_MESSAGE = \"⚙ 스택명령어 점검중입니다.\";\n\nasync function getMaintenanceMode(\n blob: { getJSON: (k: string) => Promise },\n): Promise {\n try {\n const v = await blob.getJSON(MAINTENANCE_KEY) as { on?: boolean } | null;\n return !!v?.on;\n } catch {\n return false;\n }\n}\n\nasync function setMaintenanceMode(\n blob: { setJSON: (k: string, v: unknown) => Promise },\n on: boolean,\n): Promise {\n await blob.setJSON(MAINTENANCE_KEY, { on });\n}\n\n// ─────────────────────────────────────────────\n// 수량 / 항목명 파싱\n// ─────────────────────────────────────────────\n\nfunction roundAmount(n: number): number {\n return Math.round(n * 1e6) / 1e6;\n}\n\nfunction parsePositiveAmount(value: string): number | null {\n const s = String(value).trim();\n if (!/^\\\\d+(?:\\\\.\\\\d+)?$/.test(s)) return null;\n\n const n = Number(s);\n if (!Number.isFinite(n) || n <= 0) return null;\n\n return roundAmount(n);\n}\n\ntype ParsedCommandAmount = {\n item: string;\n amount: number;\n valid: boolean;\n debug: {\n tokens: string[];\n lastToken: string | null;\n treatedLastAsAmount: boolean;\n };\n};\n\nfunction endsWithBareNumber(item: string): boolean {\n return /(^|\\\\s)-?\\\\d+(?:\\\\.\\\\d+)?$/.test(item.trim());\n}\n\nfunction splitItemAndAmount(rest: string[]): ParsedCommandAmount {\n const tokens = rest.map((token) => token.trim()).filter(Boolean);\n\n if (tokens.length === 0) {\n return {\n item: \"\",\n amount: 1,\n valid: true,\n debug: { tokens, lastToken: null, treatedLastAsAmount: false },\n };\n }\n\n if (tokens.length === 1) {\n return {\n item: tokens[0],\n amount: 1,\n valid: true,\n debug: { tokens, lastToken: tokens[0], treatedLastAsAmount: false },\n };\n }\n\n const last = tokens[tokens.length - 1];\n const lastLooksNumeric = /^-?(?:\\\\d+(?:\\\\.\\\\d+)?)$/.test(last);\n\n if (!lastLooksNumeric) {\n return {\n item: tokens.join(\" \"),\n amount: 1,\n valid: true,\n debug: { tokens, lastToken: last, treatedLastAsAmount: false },\n };\n }\n\n const amount = parsePositiveAmount(last);\n\n if (amount === null) {\n return {\n item: tokens.slice(0, -1).join(\" \"),\n amount: 0,\n valid: false,\n debug: { tokens, lastToken: last, treatedLastAsAmount: true },\n };\n }\n\n return {\n item: tokens.slice(0, -1).join(\" \"),\n amount,\n valid: true,\n debug: { tokens, lastToken: last, treatedLastAsAmount: true },\n };\n}\n\n// ─────────────────────────────────────────────\n// History\n// ─────────────────────────────────────────────\n\nconst MAX_HISTORY_ENTRIES = 200;\nconst MIGRATION_DONE_KEY = \"migration_v1_done\";\n\ninterface HistoryEntry {\n time: string;\n action: \"추가\" | \"차감\" | \"삭제\" | \"초기화\";\n item?: string;\n amount?: number;\n count?: number;\n}\n\nasync function appendHistory(\n blob: {\n getJSON: (k: string) => Promise;\n setJSON: (k: string, v: unknown) => Promise;\n },\n channel: string,\n entry: HistoryEntry,\n): Promise {\n const key = `history_${channel}`;\n let history: HistoryEntry[] = [];\n\n try {\n const existing = await blob.getJSON(key);\n if (Array.isArray(existing)) {\n history = existing as HistoryEntry[];\n }\n } catch {\n history = [];\n }\n\n history.push(entry);\n\n if (history.length > MAX_HISTORY_ENTRIES) {\n history = history.slice(history.length - MAX_HISTORY_ENTRIES);\n }\n\n await blob.setJSON(key, history);\n}\n\nfunction formatStack(stack: Record): string {\n const keys = Object.keys(stack);\n if (!keys.length) return \"저장된 항목이 없습니다.\";\n\n return keys\n .map((k) => `${label(k)} ${roundAmount(stack[k])}`)\n .join(\", \");\n}\n\n// ─────────────────────────────────────────────\n// 채널명 정규화 (수정됨)\n// ─────────────────────────────────────────────\n\nfunction normalizeChannel(channel: string): string {\n const trimmed = String(channel || \"\").trim();\n if (trimmed === \"암본이수혁 aguking\") return PRIMARY_CHANNEL;\n // 빈 문자열이면 기본 채널명 반환\n return trimmed || PRIMARY_CHANNEL;\n}\n\nconst MAX_CHANNEL_LENGTH = 100;\nconst MAX_ITEM_LENGTH = 100;\n\nfunction isSafeChannelName(channel: string): boolean {\n return (\n typeof channel === \"string\" &&\n channel.length > 0 &&\n channel.length <= MAX_CHANNEL_LENGTH &&\n !/[\\\\u0000-\\\\u001F\\\\u007F]/.test(channel)\n );\n}\n\nfunction isSafeItemName(item: string): boolean {\n return (\n typeof item === \"string\" &&\n item.length > 0 &&\n item.length <= MAX_ITEM_LENGTH &&\n !/[\\\\u0000-\\\\u001F\\\\u007F]/.test(item)\n );\n}\n\n// ─────────────────────────────────────────────\n// 기존 데이터 자동 마이그레이션\n// ─────────────────────────────────────────────\n\nasync function migrateLegacyChannelData(\n blob: {\n getJSON: (k: string) => Promise;\n setJSON: (k: string, v: unknown) => Promise;\n delete: (k: string) => Promise;\n },\n): Promise {\n const newStackKey = `stack_${PRIMARY_CHANNEL}`;\n const newHistoryKey = `history_${PRIMARY_CHANNEL}`;\n\n let newStack: Record = Object.create(null);\n let newHistory: HistoryEntry[] = [];\n\n try {\n const existing = await blob.getJSON(newStackKey);\n if (existing && typeof existing === \"object\" && !Array.isArray(existing)) {\n newStack = Object.assign(\n Object.create(null),\n existing as Record,\n );\n }\n } catch {}\n\n try {\n const existing = await blob.getJSON(newHistoryKey);\n if (Array.isArray(existing)) {\n newHistory = existing as HistoryEntry[];\n }\n } catch {}\n\n let stackChanged = false;\n let historyChanged = false;\n\n for (const legacyChannel of LEGACY_CHANNELS) {\n const legacyStackKey = `stack_${legacyChannel}`;\n const legacyHistoryKey = `history_${legacyChannel}`;\n\n let legacyStack: Record | null = null;\n let legacyHistory: HistoryEntry[] | null = null;\n\n try {\n const existing = await blob.getJSON(legacyStackKey);\n if (\n existing && typeof existing === \"object\" && !Array.isArray(existing)\n ) {\n legacyStack = existing as Record;\n }\n } catch {}\n\n try {\n const existing = await blob.getJSON(legacyHistoryKey);\n if (Array.isArray(existing)) {\n legacyHistory = existing as HistoryEntry[];\n }\n } catch {}\n\n if (legacyStack) {\n for (const [item, value] of Object.entries(legacyStack)) {\n const n = Number(value);\n if (Number.isFinite(n) && n > 0) {\n newStack[item] = roundAmount((newStack[item] || 0) + n);\n stackChanged = true;\n }\n }\n await blob.delete(legacyStackKey);\n }\n\n if (legacyHistory) {\n newHistory = newHistory.concat(legacyHistory);\n historyChanged = true;\n await blob.delete(legacyHistoryKey);\n }\n }\n\n if (stackChanged) {\n await blob.setJSON(newStackKey, newStack);\n }\n\n if (historyChanged) {\n newHistory = newHistory\n .filter((e) => e && typeof e.time === \"string\")\n .sort((a, b) => new Date(a.time).getTime() - new Date(b.time).getTime())\n .slice(-MAX_HISTORY_ENTRIES);\n\n await blob.setJSON(newHistoryKey, newHistory);\n }\n}\n\n// ─────────────────────────────────────────────\n// YouTube Live 자동 초기화\n// ─────────────────────────────────────────────\n\nconst YOUTUBE_CHANNEL_ID = \"UC1LiqB9tfyRge5fZ2-7BTVQ\";\nconst YOUTUBE_STACK_CHANNEL = PRIMARY_CHANNEL;\nconst YOUTUBE_API_KEY = Deno.env.get(\"YOUTUBE_API_KEY\") || \"\";\nconst YOUTUBE_AUTO_RESET_KEY = \"youtube_live_auto_reset\";\n\ntype YouTubeLiveState = {\n videoId?: string;\n wasLive?: boolean;\n lastResetDate?: string;\n};\n\nconst KST_OFFSET_MS = 9 * 60 * 60 * 1000;\n\nfunction getKstDateKey(): string {\n const kst = new Date(Date.now() + KST_OFFSET_MS);\n return kst.toISOString().slice(0, 10);\n}\n\nasync function getYouTubeLiveVideoId(): Promise {\n if (!YOUTUBE_API_KEY) return null;\n\n const youtubeUrl = new URL(\"https://www.googleapis.com/youtube/v3/search\");\n youtubeUrl.searchParams.set(\"part\", \"id\");\n youtubeUrl.searchParams.set(\"channelId\", YOUTUBE_CHANNEL_ID);\n youtubeUrl.searchParams.set(\"eventType\", \"live\");\n youtubeUrl.searchParams.set(\"type\", \"video\");\n youtubeUrl.searchParams.set(\"maxResults\", \"1\");\n youtubeUrl.searchParams.set(\"key\", YOUTUBE_API_KEY);\n\n try {\n const response = await fetch(youtubeUrl);\n if (!response.ok) return null;\n\n const data = await response.json() as {\n items?: Array<{ id?: { videoId?: string } }>;\n };\n\n return data.items?.[0]?.id?.videoId || null;\n } catch {\n return null;\n }\n}\n\nasync function getYouTubeLiveState(\n blob: { getJSON: (key: string) => Promise },\n): Promise {\n try {\n return (await blob.getJSON(YOUTUBE_AUTO_RESET_KEY)) as YouTubeLiveState ||\n {};\n } catch {\n return {};\n }\n}\n\nasync function setYouTubeLiveState(\n blob: { setJSON: (key: string, value: unknown) => Promise },\n state: YouTubeLiveState,\n): Promise {\n await blob.setJSON(YOUTUBE_AUTO_RESET_KEY, state);\n}\n\n// ─────────────────────────────────────────────\n// Main\n// ─────────────────────────────────────────────\n\nconst channelLocks = new Map>();\n\nasync function withChannelLock(\n channel: string,\n task: () => Promise,\n): Promise {\n const previous = channelLocks.get(channel) || Promise.resolve();\n let release!: () => void;\n const current = new Promise((resolve) => {\n release = resolve;\n });\n channelLocks.set(channel, current);\n\n await previous;\n try {\n return await task();\n } finally {\n release();\n if (channelLocks.get(channel) === current) {\n channelLocks.delete(channel);\n }\n }\n}\n\nexport default async function (req: Request): Promise {\n const { blob } = await import(\"https://esm.town/v/std/blob\");\n\n const url = new URL(req.url);\n\n let migrationDone = false;\n try {\n const state = await blob.getJSON(MIGRATION_DONE_KEY);\n migrationDone = state === true ||\n (state as { done?: boolean } | null)?.done === true;\n } catch {}\n\n if (!migrationDone) {\n await migrateLegacyChannelData(blob);\n await blob.setJSON(MIGRATION_DONE_KEY, { done: true, version: 1 });\n }\n\n if (url.pathname === \"/admin\") {\n if (!(await checkAuth(req))) return unauthorizedResponse();\n return htmlResponse(ADMIN_HTML);\n }\n\n if (url.pathname === \"/monitor\") {\n return htmlResponse(MONITOR_HTML);\n }\n\n if (url.pathname === \"/history\") {\n return htmlResponse(HISTORY_HTML);\n }\n\n if (url.pathname === \"/youtube-check\") {\n const checkSecret = Deno.env.get(\"YOUTUBE_CHECK_SECRET\") || \"\";\n\n if (!checkSecret) {\n return new Response(\n \"YouTube check is disabled: missing YOUTUBE_CHECK_SECRET\",\n {\n status: 500,\n headers: { \"content-type\": \"text/plain; charset=utf-8\" },\n },\n );\n }\n\n const suppliedCheckSecret = req.headers.get(\"x-youtube-check-secret\") ||\n url.searchParams.get(\"secret\") ||\n \"\";\n\n if (!timingSafeEqualText(suppliedCheckSecret, checkSecret)) {\n return new Response(\"권한이 없습니다.\", {\n status: 403,\n headers: { \"content-type\": \"text/plain; charset=utf-8\" },\n });\n }\n\n if (!YOUTUBE_API_KEY) {\n return new Response(\n JSON.stringify({\n ok: false,\n error: \"YOUTUBE_API_KEY 환경변수가 설정되지 않았습니다.\",\n }),\n {\n status: 500,\n headers: { \"content-type\": \"application/json; charset=utf-8\" },\n },\n );\n }\n\n const liveVideoId = await getYouTubeLiveVideoId();\n const previous = await getYouTubeLiveState(blob);\n const todayKst = getKstDateKey();\n\n if (!liveVideoId) {\n await setYouTubeLiveState(blob, { ...previous, wasLive: false });\n\n return new Response(\n JSON.stringify({\n ok: true,\n live: false,\n reset: false,\n resetDate: previous.lastResetDate || null,\n channel: YOUTUBE_STACK_CHANNEL,\n }),\n { headers: { \"content-type\": \"application/json; charset=utf-8\" } },\n );\n }\n\n const shouldReset = previous.lastResetDate !== todayKst;\n\n if (shouldReset) {\n await blob.delete(`stack_${YOUTUBE_STACK_CHANNEL}`);\n await appendHistory(blob, YOUTUBE_STACK_CHANNEL, {\n time: new Date().toISOString(),\n action: \"초기화\",\n });\n }\n\n await setYouTubeLiveState(blob, {\n videoId: liveVideoId,\n wasLive: true,\n lastResetDate: shouldReset ? todayKst : previous.lastResetDate,\n });\n\n return new Response(\n JSON.stringify({\n ok: true,\n live: true,\n reset: shouldReset,\n videoId: liveVideoId,\n resetDate: shouldReset ? todayKst : previous.lastResetDate,\n channel: YOUTUBE_STACK_CHANNEL,\n }),\n { headers: { \"content-type\": \"application/json; charset=utf-8\" } },\n );\n }\n\n if (url.pathname === \"/admin/maintenance-status\") {\n if (!(await checkAuth(req))) return unauthorizedResponse();\n\n const on = await getMaintenanceMode(blob);\n return new Response(JSON.stringify({ on }), {\n headers: { \"content-type\": \"application/json; charset=utf-8\" },\n });\n }\n\n if (url.pathname === \"/admin/maintenance\" && req.method === \"POST\") {\n if (!(await checkAuth(req))) return unauthorizedResponse();\n\n const origin = req.headers.get(\"origin\");\n const referer = req.headers.get(\"referer\");\n\n const isSameOrigin = (value: string | null): boolean => {\n if (!value) return false;\n try {\n return new URL(value).origin === url.origin;\n } catch {\n return false;\n }\n };\n\n if (!isSameOrigin(origin) && !isSameOrigin(referer)) {\n return new Response(\"Forbidden: cross-origin request\", { status: 403 });\n }\n\n let body: { on?: boolean } = {};\n try {\n body = await req.json();\n } catch {\n body = {};\n }\n\n const on = body.on === true;\n await setMaintenanceMode(blob, on);\n\n return new Response(JSON.stringify({ on }), {\n headers: { \"content-type\": \"application/json; charset=utf-8\" },\n });\n }\n\n if (url.searchParams.get(\"history\") === \"1\") {\n const historyChannel = normalizeChannel(\n url.searchParams.get(\"ch\") || \"default\",\n );\n\n let history: HistoryEntry[] = [];\n try {\n const existing = await blob.getJSON(`history_${historyChannel}`);\n if (Array.isArray(existing)) {\n history = existing as HistoryEntry[];\n }\n } catch {\n history = [];\n }\n\n return new Response(JSON.stringify(history), {\n headers: { \"content-type\": \"application/json; charset=utf-8\" },\n });\n }\n\n if (await getMaintenanceMode(blob)) {\n return new Response(MAINTENANCE_MESSAGE, {\n headers: { \"content-type\": \"text/plain; charset=utf-8\" },\n });\n }\n\n const requestedQuery = (url.searchParams.get(\"q\") || \"\").trim();\n\n if (requestedQuery && !(await checkStackCommandAuth(req))) {\n return forbiddenResponse();\n }\n\n // ─────────────────────────────────────────────\n // 채널명 검증 (수정됨) — raw 값 먼저 검사\n // ─────────────────────────────────────────────\n const rawChannel = (url.searchParams.get(\"ch\") || \"\").trim();\n\n if (!rawChannel) {\n return new Response(\"채널명을 입력해주세요.\", {\n status: 400,\n headers: { \"content-type\": \"text/plain; charset=utf-8\" },\n });\n }\n\n if (\n rawChannel.length > MAX_CHANNEL_LENGTH ||\n /[\\\\u0000-\\\\u001F\\\\u007F]/.test(rawChannel)\n ) {\n return new Response(\"채널명은 1~100 자로 입력해주세요.\", {\n status: 400,\n headers: { \"content-type\": \"text/plain; charset=utf-8\" },\n });\n }\n\n const channelForLock = normalizeChannel(rawChannel);\n\n return await withChannelLock(channelForLock, async () => {\n const channel = normalizeChannel(rawChannel);\n const key = `stack_${channel}`;\n\n let stack: Record = Object.create(null);\n\n try {\n const existing = await blob.getJSON(key);\n if (\n existing && typeof existing === \"object\" && !Array.isArray(existing)\n ) {\n stack = Object.assign(\n Object.create(null),\n existing as Record,\n );\n }\n } catch {\n stack = {};\n }\n\n let stackSanitized = false;\n\n for (const item of Object.keys(stack)) {\n const n = Number(stack[item]);\n\n if (!Number.isFinite(n) || n <= 0) {\n delete stack[item];\n stackSanitized = true;\n } else {\n const rounded = roundAmount(n);\n if (rounded !== stack[item]) {\n stack[item] = rounded;\n stackSanitized = true;\n }\n }\n }\n\n if (stackSanitized) {\n await blob.setJSON(key, stack);\n }\n\n let responseText: string;\n\n if (query === \"\") {\n responseText = formatStack(stack);\n } else {\n const parts = query.split(/\\\\s+/);\n const command = parts[0];\n\n if (command === \"추가\") {\n const parsed = splitItemAndAmount(parts.slice(1));\n\n if (!parsed.item) {\n responseText =\n \"사용법 : !스택 추가 [항목] [숫자 (생략가능, 소수 가능)]\";\n } else if (!parsed.valid) {\n responseText = `수량은 0 보다 큰 숫자만 입력할 수 있습니다. ` +\n `(받은 값: \"${query}\", 인식된 수량 토큰: \"${\n parsed.debug.lastToken ?? \"\"\n }\")`;\n } else if (!isSafeItemName(parsed.item)) {\n responseText = \"항목 이름은 1~100 자로 입력해주세요.\";\n } else if (endsWithBareNumber(parsed.item)) {\n responseText =\n `항목 이름(\"${parsed.item}\") 끝에 숫자가 포함되어 있어 추가하지 않았습니다. ` +\n `항목 이름과 수량을 분리해서 다시 입력해주세요. (받은 값: \"${query}\")`;\n } else {\n const current = Number(stack[parsed.item] || 0);\n stack[parsed.item] = roundAmount(\n Math.max(0, current + parsed.amount),\n );\n\n await blob.setJSON(key, stack);\n\n await appendHistory(blob, channel, {\n time: new Date().toISOString(),\n action: \"추가\",\n item: parsed.item,\n amount: parsed.amount,\n count: stack[parsed.item],\n });\n\n responseText = `${label(parsed.item)} ${stack[parsed.item]}`;\n }\n } else if (command === \"차감\" || command === \"빼기\") {\n const parsed = splitItemAndAmount(parts.slice(1));\n\n if (!parsed.item) {\n responseText =\n \"사용법 : !스택 차감 (빼기) [항목] [숫자 (생략가능, 소수 가능)]\";\n } else if (!parsed.valid) {\n responseText = `수량은 0 보다 큰 숫자만 입력할 수 있습니다. ` +\n `(받은 값: \"${query}\", 인식된 수량 토큰: \"${\n parsed.debug.lastToken ?? \"\"\n }\")`;\n } else if (!isSafeItemName(parsed.item)) {\n responseText = \"항목 이름은 1~100 자로 입력해주세요.\";\n } else if (!(parsed.item in stack)) {\n responseText = `${label(parsed.item)} 항목이 없습니다.`;\n } else {\n const current = Number(stack[parsed.item]);\n const next = roundAmount(current - parsed.amount);\n\n if (next <= 0) {\n delete stack[parsed.item];\n await blob.setJSON(key, stack);\n\n await appendHistory(blob, channel, {\n time: new Date().toISOString(),\n action: \"차감\",\n item: parsed.item,\n amount: parsed.amount,\n count: 0,\n });\n\n responseText = `${label(parsed.item)} 0 이하가 되어 삭제했습니다.`;\n } else {\n stack[parsed.item] = next;\n await blob.setJSON(key, stack);\n\n await appendHistory(blob, channel, {\n time: new Date().toISOString(),\n action: \"차감\",\n item: parsed.item,\n amount: parsed.amount,\n count: next,\n });\n\n responseText = `${label(parsed.item)} ${next}`;\n }\n }\n } else if (command === \"삭제\") {\n const item = parts.slice(1).join(\" \");\n\n if (!item) {\n responseText = \"사용법 : !스택 삭제 [항목]\";\n } else if (!isSafeItemName(item)) {\n responseText = \"항목 이름은 1~100 자로 입력해주세요.\";\n } else if (!(item in stack)) {\n responseText = `${label(item)} 항목이 없습니다.`;\n } else {\n delete stack[item];\n await blob.setJSON(key, stack);\n\n await appendHistory(blob, channel, {\n time: new Date().toISOString(),\n action: \"삭제\",\n item,\n });\n\n responseText = `${label(item)} 삭제했습니다.`;\n }\n } else if (command === \"초기화\") {\n await blob.delete(key);\n\n await appendHistory(blob, channel, {\n time: new Date().toISOString(),\n action: \"초기화\",\n });\n\n responseText = \"스택을 초기화했습니다.\";\n } else if (command === \"기록초기화\") {\n await blob.delete(`history_${channel}`);\n responseText = \"기록 (History) 을 초기화했습니다.\";\n } else {\n responseText =\n \"알 수 없는 명령입니다. (추가/차감/삭제/초기화/기록초기화 지원)\";\n }\n }\n\n return new Response(responseText, {\n headers: { \"content-type\": \"text/plain; charset=utf-8\" },\n });\n });\n}\n","aguking-stack",[147],"8d3acc3b-fab2-4bf7-a1c0-dd31589eafdd","excel.ts","e0105100-a78c-11f1-bc53-1607ee4eb77e",238,["D",1788435892149],"// aguking-excel.val.run\n// val.town HTTP val - 나이트봇 연동 엑셀(이름별 수량) 관리\n//\n// 사용법 (나이트봇 명령):\n// !엑셀 -> 현재 목록 조회 (항목별 랜덤 이모지 포함)\n// !엑셀 추가 홍길동 10 -> GET /?ch=채널명&q=추가 홍길동 10\n// !엑셀 차감 홍길동 3 -> GET /?ch=채널명&q=차감 홍길동 3\n// !엑셀 삭제 홍길동 -> GET /?ch=채널명&q=삭제 홍길동\n// !엑셀 초기화 -> GET /?ch=채널명&q=초기화\n//\n// 웹에서 https://aguking-excel.val.run/?ch=채널명 으로 접속하면\n// 랜덤 이모지가 포함된 목록을 볼 수 있고, /admin에서는 추가·차감·삭제·초기화가 가능합니다.\n// q 파라미터가 없으면 HTML 화면을 반환합니다.\n// q=처럼 비어 있으면 나이트봇용 전체 목록을 반환합니다.\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst TABLE = \"excel_items\";\nconst DEFAULT_CHANNEL = \"암본이수혁aguking\";\nconst DECIMAL_PLACES = 6;\nconst SCALE = 1_000_000;\n\nconst EMOJIS = [\n \"🍎\",\n \"🍏\",\n \"🍓\",\n \"🍒\",\n \"🍋\",\n \"🧅\",\n \"🥔\",\n \"🧄\",\n \"🌽\",\n \"🥕\",\n \"👑\",\n \"💎\",\n \"⚔️\",\n \"🐉\",\n \"🔥\",\n \"🦁\",\n \"🐯\",\n \"🐺\",\n \"🦊\",\n \"🐻\",\n \"🎲\",\n \"⭐\",\n \"✨\",\n \"💫\",\n \"🌈\",\n \"🎯\",\n \"🏆\",\n \"🎮\",\n \"🎁\",\n \"🚀\",\n \"📦\",\n \"🔹\",\n \"🎉\",\n \"✅\",\n];\n\ntype Item = { name: string; qty: number };\n\ntype Command =\n | { command: \"추가\" | \"차감\"; name?: string; amount: number }\n | { command: \"삭제\"; name?: string }\n | { command: \"초기화\" }\n | { command: \"unknown\" };\n\nfunction round6(value: number): number {\n return Math.round((value + Number.EPSILON) * SCALE) / SCALE;\n}\n\nfunction formatQty(value: number): string {\n const safe = Number.isFinite(value) ? round6(value) : 0;\n return safe.toFixed(DECIMAL_PLACES).replace(/\\.?0+$/, \"\");\n}\n\nfunction parseAmount(raw: string | undefined): number {\n const value = Number(raw);\n return Number.isFinite(value) && value > 0 ? round6(value) : 1;\n}\n\nfunction getRandomEmoji(): string {\n return EMOJIS[Math.floor(Math.random() * EMOJIS.length)];\n}\n\nfunction escapeHtml(value: string): string {\n return value\n .replaceAll(\"&\", \"&\")\n .replaceAll(\"<\", \"<\")\n .replaceAll(\">\", \">\")\n .replaceAll('\"', \""\")\n .replaceAll(\"'\", \"'\");\n}\n\nfunction readResultValue(result: any, row: any, column: string): unknown {\n if (row && typeof row === \"object\" && !Array.isArray(row) && column in row) {\n return row[column];\n }\n\n const columns = Array.isArray(result.columns) ? result.columns : [];\n const index = columns.findIndex(\n (item: unknown) => String(item).toLowerCase() === column.toLowerCase(),\n );\n\n return index >= 0 && row ? row[index] : undefined;\n}\n\nasync function ensureTable(): Promise {\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS ${TABLE} (\n channel TEXT NOT NULL,\n name TEXT NOT NULL,\n qty REAL NOT NULL DEFAULT 0,\n PRIMARY KEY (channel, name)\n )`,\n );\n}\n\nasync function getItems(channel: string): Promise {\n const result: any = await sqlite.execute({\n sql: `SELECT name, qty\n FROM ${TABLE}\n WHERE channel = ?\n ORDER BY CASE WHEN name = '국고' THEN 1 ELSE 0 END ASC,\n rowid ASC`,\n args: [channel],\n });\n\n return (result.rows || [])\n .map((row: any) => ({\n name: String(readResultValue(result, row, \"name\") ?? \"\").trim(),\n qty: round6(Number(readResultValue(result, row, \"qty\")) || 0),\n }))\n .filter((item: Item) => item.name !== \"\");\n}\n\nasync function listItemsText(channel: string): Promise {\n const items = await getItems(channel);\n\n return items.length\n ? items\n .map(\n (item) => `${getRandomEmoji()} ${item.name} ${formatQty(item.qty)}`,\n )\n .join(\", \")\n : \"✨ 아직 비어 있어요. 항목을 추가해 주세요!\";\n}\n\nasync function addItem(\n channel: string,\n name: string,\n amount: number,\n): Promise {\n if (name === \"국고\") {\n // 1) 기존 국고 수량 읽기\n const result: any = await sqlite.execute({\n sql: `SELECT qty FROM ${TABLE} WHERE channel = ? AND name = ?`,\n args: [channel, name],\n });\n\n const oldQty = result.rows?.length\n ? round6(Number(readResultValue(result, result.rows[0], \"qty\")) || 0)\n : 0;\n\n const newQty = round6(oldQty + amount);\n\n // 2) 기존 국고 삭제 (있으면)\n if (result.rows?.length) {\n await sqlite.execute({\n sql: `DELETE FROM ${TABLE} WHERE channel = ? AND name = ?`,\n args: [channel, name],\n });\n }\n\n // 3) 새 행으로 INSERT → rowid 가 가장 큰 값이 되어 맨 뒤로 감\n await sqlite.execute({\n sql: `INSERT INTO ${TABLE} (channel, name, qty) VALUES (?, ?, ?)`,\n args: [channel, name, newQty],\n });\n\n return newQty;\n }\n\n // 일반 항목: 기존 로직 유지 (중복 시 합산)\n await sqlite.execute({\n sql: `INSERT INTO ${TABLE} (channel, name, qty) VALUES (?, ?, ?)\n ON CONFLICT(channel, name)\n DO UPDATE SET qty = ROUND(qty + excluded.qty, 6)`,\n args: [channel, name, amount],\n });\n\n const result: any = await sqlite.execute({\n sql: `SELECT qty FROM ${TABLE} WHERE channel = ? AND name = ?`,\n args: [channel, name],\n });\n\n return round6(Number(readResultValue(result, result.rows[0], \"qty\")) || 0);\n}\n\nasync function subtractItem(\n channel: string,\n name: string,\n amount: number,\n): Promise {\n const result: any = await sqlite.execute({\n sql: `SELECT qty FROM ${TABLE} WHERE channel = ? AND name = ?`,\n args: [channel, name],\n });\n\n if (!result.rows?.length) return null;\n\n const current = round6(\n Number(readResultValue(result, result.rows[0], \"qty\")) || 0,\n );\n const next = Math.max(0, round6(current - amount));\n\n if (name === \"국고\") {\n // 국고는 삭제 후 재 INSERT 로 rowid 갱신 (항상 맨 뒤)\n await sqlite.execute({\n sql: `DELETE FROM ${TABLE} WHERE channel = ? AND name = ?`,\n args: [channel, name],\n });\n\n await sqlite.execute({\n sql: `INSERT INTO ${TABLE} (channel, name, qty) VALUES (?, ?, ?)`,\n args: [channel, name, next],\n });\n } else {\n // 일반 항목은 그냥 업데이트\n await sqlite.execute({\n sql: `UPDATE ${TABLE} SET qty = ? WHERE channel = ? AND name = ?`,\n args: [next, channel, name],\n });\n }\n\n return next;\n}\n\nasync function deleteItem(channel: string, name: string): Promise {\n await sqlite.execute({\n sql: `DELETE FROM ${TABLE} WHERE channel = ? AND name = ?`,\n args: [channel, name],\n });\n}\n\nasync function resetChannel(channel: string): Promise {\n await sqlite.execute({\n sql: `DELETE FROM ${TABLE} WHERE channel = ?`,\n args: [channel],\n });\n}\n\nfunction parseCommand(q: string): Command {\n const parts = q.trim().split(/\\s+/);\n const command = parts[0] || \"\";\n\n if (command === \"추가\" || command === \"차감\") {\n return {\n command,\n name: parts[1],\n amount: parseAmount(parts[2]),\n };\n }\n\n if (command === \"삭제\") {\n return {\n command,\n name: parts[1],\n };\n }\n\n if (command === \"초기화\") {\n return { command };\n }\n\n return { command: \"unknown\" };\n}\n\nasync function handleCommand(channel: string, q: string): Promise {\n if (!q.trim()) {\n return await listItemsText(channel);\n }\n\n const parsed = parseCommand(q);\n\n switch (parsed.command) {\n case \"추가\": {\n if (!parsed.name) return \"사용법: 추가 이름 수량\";\n\n const qty = await addItem(channel, parsed.name, parsed.amount);\n return `${parsed.name} 추가됨 (현재 ${formatQty(qty)})`;\n }\n\n case \"차감\": {\n if (!parsed.name) return \"사용법: 차감 이름 수량\";\n\n const qty = await subtractItem(channel, parsed.name, parsed.amount);\n\n return qty === null\n ? `${parsed.name} 항목이 없습니다.`\n : `${parsed.name} 차감됨 (현재 ${formatQty(qty)})`;\n }\n\n case \"삭제\": {\n if (!parsed.name) return \"사용법: 삭제 이름\";\n\n await deleteItem(channel, parsed.name);\n return `${parsed.name} 삭제됨`;\n }\n\n case \"초기화\":\n await resetChannel(channel);\n return \"전체 초기화 완료\";\n\n default:\n return \"알 수 없는 명령어입니다. (추가/차감/삭제/초기화)\";\n }\n}\n\nfunction checkAuth(req: Request): boolean {\n const accounts = new Map();\n\n for (const entry of (Deno.env.get(\"ADMIN_ACCOUNTS\") || \"\").split(\",\")) {\n const index = entry.indexOf(\":\");\n\n if (index > 0) {\n accounts.set(\n entry.slice(0, index).trim(),\n entry.slice(index + 1).trim(),\n );\n }\n }\n\n if (!accounts.size) return false;\n\n const header = req.headers.get(\"authorization\") || \"\";\n if (!header.startsWith(\"Basic \")) return false;\n\n try {\n const decoded = atob(header.slice(6));\n const index = decoded.indexOf(\":\");\n\n return index >= 0 &&\n accounts.get(decoded.slice(0, index).trim()) === decoded.slice(index + 1);\n } catch {\n return false;\n }\n}\n\nfunction refreshControlsHtml(channel: string): string {\n return `\n Auto\n \n \n \n \n \n\n \n\n `;\n}\n\nconst COMMON_CSS = `\n body {\n background: #0f1115;\n color: #eee;\n font-family: sans-serif;\n padding: 24px;\n }\n\n a { color: #9ab5ff; }\n\n table {\n width: 100%;\n border-collapse: collapse;\n background: #181b21;\n margin-top: 16px;\n }\n\n th, td {\n padding: 12px;\n text-align: left;\n border-bottom: 1px solid #2a2e37;\n }\n\n th { color: #9aa0a6; }\n\n .top-controls {\n position: fixed;\n top: 18px;\n right: 18px;\n display: flex;\n align-items: center;\n gap: 10px;\n z-index: 10;\n }\n\n .page-link {\n display: inline-flex;\n align-items: center;\n min-height: 38px;\n padding: 0 12px;\n box-sizing: border-box;\n border: 1px solid #3c4657;\n border-radius: 7px;\n color: #eaf0ff;\n background: #202631;\n text-decoration: none;\n font-size: 14px;\n font-weight: 700;\n }\n\n .page-link:hover {\n background: #303947;\n }\n\n .auto-toggle {\n display: inline-flex;\n align-items: center;\n gap: 8px;\n cursor: pointer;\n user-select: none;\n color: #c9ced8;\n font-size: 14px;\n }\n\n .auto-label {\n font-weight: 700;\n letter-spacing: .2px;\n }\n\n .auto-toggle input {\n position: absolute;\n width: 1px;\n height: 1px;\n opacity: 0;\n pointer-events: none;\n }\n\n .toggle-track {\n width: 42px;\n height: 24px;\n padding: 3px;\n box-sizing: border-box;\n border-radius: 999px;\n background: #343943;\n border: 1px solid #4b5260;\n transition: background .2s ease, border-color .2s ease;\n }\n\n .toggle-knob {\n display: block;\n width: 16px;\n height: 16px;\n border-radius: 50%;\n background: #fff;\n box-shadow: 0 1px 3px rgba(0, 0, 0, .45);\n transform: translateX(0);\n transition: transform .2s ease;\n }\n\n .auto-toggle input:checked + .toggle-track {\n background: #2a8a4b;\n border-color: #48b96b;\n }\n\n .auto-toggle input:checked + .toggle-track .toggle-knob {\n transform: translateX(16px);\n }\n\n .auto-toggle input:focus-visible + .toggle-track {\n outline: 2px solid #8fb1ff;\n outline-offset: 3px;\n }\n\n .manual-refresh {\n min-height: 38px;\n padding: 8px 12px;\n border: 1px solid #3c4657;\n border-radius: 7px;\n cursor: pointer;\n color: #eaf0ff;\n background: #263a63;\n font-weight: 700;\n }\n\n .manual-refresh:hover {\n background: #31508d;\n }\n`;\n\nfunction renderViewPage(channel: string, items: Item[]): string {\n const rows = items\n .map(\n (item) =>\n `${getRandomEmoji()} ${escapeHtml(item.name)}${\n formatQty(item.qty)\n }`,\n )\n .join(\"\");\n\n const adminUrl = `/admin?ch=${encodeURIComponent(channel)}`;\n\n return `\n\n\n \n \n 엑셀 - ${escapeHtml(channel)}\n \n\n\n

엑셀 - ${escapeHtml(channel)}

\n Admin\n ${refreshControlsHtml(channel)}\n

\n ${\n rows\n ? `\n \n ${rows}\n

이름	수량

`\n : \"

✨ 아직 비어 있어요. 항목을 추가해 주세요!

\"\n }\n\n`;\n}\n\nfunction renderAdminPage(channel: string, items: Item[]): string {\n const rows = items\n .map((item) => {\n const name = JSON.stringify(item.name);\n\n return `\n ${escapeHtml(item.name)}\n ${formatQty(item.qty)}\n \n \n \n \n \n `;\n })\n .join(\"\");\n\n const listUrl = `/?ch=${encodeURIComponent(channel)}`;\n\n return `\n\n\n \n \n 엑셀 관리 - ${escapeHtml(channel)}\n \n\n\n

엑셀 관리 - ${escapeHtml(channel)}

\n Monitoring\n ${refreshControlsHtml(channel)}\n

\n\n \n\n ${\n rows\n ? `\n \n ${rows}\n

이름	수량	관리

`\n : \"

✨ 아직 비어 있어요. 항목을 추가해 주세요! 항목이 없습니다.

\"\n }\n\n \n\n`;\n}\n\nexport default async function (req: Request): Promise {\n await ensureTable();\n\n const url = new URL(req.url);\n const channel = url.searchParams.get(\"ch\")?.trim() || DEFAULT_CHANNEL;\n const q = url.searchParams.get(\"q\");\n const isAdmin = url.pathname === \"/admin\";\n\n if (isAdmin && !checkAuth(req)) {\n return new Response(\"관리자 인증이 필요합니다.\", {\n status: 401,\n headers: {\n \"content-type\": \"text/plain; charset=utf-8\",\n \"www-authenticate\": 'Basic realm=\"Excel Admin\", charset=\"UTF-8\"',\n },\n });\n }\n\n if (q !== null) {\n return new Response(await handleCommand(channel, q), {\n headers: {\n \"content-type\": \"text/plain; charset=utf-8\",\n },\n });\n }\n\n const items = await getItems(channel);\n const html = isAdmin\n ? renderAdminPage(channel, items)\n : renderViewPage(channel, items);\n\n return new Response(html, {\n headers: {\n \"content-type\": \"text/html; charset=utf-8\",\n },\n });\n}",[155],"57af6c2f-ba12-4bc3-853a-a23252d53414","AGENTS.md","e4b77158-a862-11f1-a891-1607ee4eb77e",276,["D",1788527812127],"You are an advanced assistant specialized in generating Val Town code.\n\n## Core Guidelines\n\n- Ask clarifying questions when requirements are ambiguous\n- Provide complete, functional solutions rather than skeleton implementations\n- Test your logic against edge cases before presenting the final solution\n- Ensure all code follows Val Town's specific platform requirements\n- If a section of code that you're working on is getting too complex, consider\n refactoring it into subcomponents\n\n## Code Standards\n\n- Generate code in TypeScript or TSX\n- Add appropriate TypeScript types and interfaces for all data structures\n- Prefer official SDKs or libraries than writing API calls directly\n- Ask the user to supply API or library documentation if you are at all unsure\n about it\n- **Never bake in secrets into the code** - always use environment variables\n- Include comments explaining complex logic (avoid commenting obvious\n operations)\n- Follow modern ES6+ conventions and functional programming practices if\n possible\n\n## Types of triggers\n\n### 1. HTTP Trigger\n\n- Create web APIs and endpoints\n- Handle HTTP requests and responses\n- Example structure:\n\n```ts\nexport default async function (req: Request) {\n return new Response(\"Hello World\");\n}\n```\n\nFiles that are HTTP triggers have http in their name like `foobar.http.tsx`\n\n### 2. Cron Triggers\n\n- Run on a schedule\n- Use cron expressions for timing\n- Example structure:\n\n```ts\nexport default async function () {\n // Scheduled task code\n}\n```\n\nFiles that are Cron triggers have cron in their name like `foobar.cron.tsx`\n\n### 3. Email Triggers\n\n- Process incoming emails\n- Handle email-based workflows\n- Example structure:\n\n```ts\nexport default async function (email: Email) {\n // Process email\n}\n```\n\nFiles that are Email triggers have email in their name like `foobar.email.tsx`\n\n## Val Town Standard Libraries\n\nVal Town provides several hosted services and utility functions.\n\n### Blob Storage\n\n```ts\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\";\nawait blob.setJSON(\"myKey\", { hello: \"world\" });\nlet blobDemo = await blob.getJSON(\"myKey\");\nlet appKeys = await blob.list(\"app_\");\nawait blob.delete(\"myKey\");\n```\n\n### SQLite\n\n```ts\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst TABLE_NAME = \"todo_app_users_2\";\n// Create table - do this before usage and change table name when modifying schema\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL\n)`);\n// Query data\nconst result = await sqlite.execute(\n `SELECT * FROM ${TABLE_NAME} WHERE id = ?`,\n [1],\n);\n```\n\n### OpenAI\n\n```ts\nimport { OpenAI } from \"https://esm.town/v/std/openai\";\nconst openai = new OpenAI();\nconst completion = await openai.chat.completions.create({\n messages: [\n { role: \"user\", content: \"Say hello in a creative way\" },\n ],\n model: \"gpt-4o-mini\",\n max_tokens: 30,\n});\n```\n\n### Email\n\n```ts\nimport { email } from \"https://esm.town/v/std/email\";\n// By default emails the owner of the val\nawait email({\n subject: \"Hi\",\n text: \"Hi\",\n html: \"

Hi

\",\n});\n```\n\n## Val Town Utility Functions\n\nVal Town provides several utility functions to help with common project tasks.\n\n### Importing Utilities\n\nAlways import utilities with version pins to avoid breaking changes:\n\n```ts\nimport {\n parseProject,\n readFile,\n serveFile,\n} from \"https://esm.town/v/std/utils@85-main/index.ts\";\n```\n\n### Available Utilities\n\n#### **serveFile** - Serve project files with proper content types\n\nFor example, in Hono:\n\n```ts\n// serve all files in frontend/ and shared/\napp.get(\"/frontend/*\", (c) => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", (c) => serveFile(c.req.path, import.meta.url));\n```\n\n#### **readFile** - Read files from within the project:\n\n```ts\n// Read a file from the project\nconst fileContent = await readFile(\"/frontend/index.html\", import.meta.url);\n```\n\n#### **listFiles** - List all files in the project\n\n```ts\nconst files = await listFiles(import.meta.url);\n```\n\n#### **parseProject** - Extract information about the current project from import.meta.url\n\nThis is useful for including info for linking back to a val, ie in \"view source\"\nurls:\n\n```ts\nconst projectVal = parseProject(import.meta.url);\nconsole.log(projectVal.username); // Owner of the project\nconsole.log(projectVal.name); // Project name\nconsole.log(projectVal.version); // Version number\nconsole.log(projectVal.branch); // Branch name\nconsole.log(projectVal.links.self.project); // URL to the project page\n```\n\nHowever, it's _extremely importing_ to note that `parseProject` and other\nStandard Library utilities ONLY RUN ON THE SERVER. If you need access to this\ndata on the client, run it in the server and pass it to the client by splicing\nit into the HTML page or by making an API request for it.\n\n## Val Town Platform Specifics\n\n- **Redirects:** Use\n `return new Response(null, { status: 302, headers: { Location: \"/place/to/redirect\" }})`\n instead of `Response.redirect` which is broken\n- **Images:** Avoid external images or base64 images. Use emojis, unicode\n symbols, or icon fonts/libraries instead\n- **AI Image:** To inline generate an AI image use:\n `

`\n- **Storage:** DO NOT use the Deno KV module for storage\n- **Browser APIs:** DO NOT use the `alert()`, `prompt()`, or `confirm()` methods\n- **Weather Data:** Use open-meteo for weather data (doesn't require API keys)\n unless otherwise specified\n- **View Source:** Add a view source link by importing & using\n `import.meta.url.replace(\"esm.sh\", \"val.town)\"` (or passing this data to the\n client) and include `target=\"_top\"` attribute\n- **Error Debugging:** Add\n `` to HTML to capture\n client-side errors\n- **Error Handling:** Only use try...catch when there's a clear local\n resolution; Avoid catches that merely log or return 500s. Let errors bubble up\n with full context\n- **Environment Variables:** Use `Deno.env.get('keyname')` when you need to, but\n generally prefer APIs that don't require keys\n- **Imports:** Use `https://esm.sh` for npm and Deno dependencies to ensure\n compatibility on server and browser\n- **Storage Strategy:** Only use backend storage if explicitly required; prefer\n simple static client-side sites\n- **React Configuration:** When using React libraries, pin versions with\n `?deps=react@18.2.0,react-dom@18.2.0` and start the file with\n `/** @jsxImportSource https://esm.sh/react@18.2.0 */`\n- Ensure all React dependencies and sub-dependencies are pinned to the same\n version\n- **Styling:** Default to using TailwindCSS via\n `` unless otherwise\n specified\n\n## Project Structure and Design Patterns\n\n### Recommended Directory Structure\n\n```\n├── backend/\n│ ├── database/\n│ │ ├── migrations.ts # Schema definitions\n│ │ ├── queries.ts # DB query functions\n│ │ └── README.md\n│ └── routes/ # Route modules\n│ ├── [route].ts\n│ └── static.ts # Static file serving\n│ ├── index.ts # Main entry point\n│ └── README.md\n├── frontend/\n│ ├── components/\n│ │ ├── App.tsx\n│ │ └── [Component].tsx\n│ ├── favicon.svg\n│ ├── index.html # Main HTML template\n│ ├── index.tsx # Frontend JS entry point\n│ ├── README.md\n│ └── style.css\n├── README.md\n└── shared/\n ├── README.md\n └── utils.ts # Shared types and functions\n```\n\n### Backend (Hono) Best Practices\n\n- Hono is the recommended API framework\n- Main entry point should be `backend/index.ts`\n- **Static asset serving:** Use the utility functions to read and serve project\n files:\n ```ts\n import {\n readFile,\n serveFile,\n } from \"https://esm.town/v/std/utils@85-main/index.ts\";\n\n // serve all files in frontend/ and shared/\n app.get(\"/frontend/*\", (c) => serveFile(c.req.path, import.meta.url));\n app.get(\"/shared/*\", (c) => serveFile(c.req.path, import.meta.url));\n\n // For index.html, often you'll want to bootstrap with initial data\n app.get(\"/\", async (c) => {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n\n // Inject data to avoid extra round-trips\n const initialData = await fetchInitialData();\n const dataScript = ``;\n\n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n });\n ```\n- Create RESTful API routes for CRUD operations\n- Always include this snippet at the top-level Hono app to re-throwing errors to\n see full stack traces:\n ```ts\n // Unwrap Hono errors to see original error details\n app.onError((err, c) => {\n throw err;\n });\n ```\n\n### Database Patterns\n\n- Run migrations on startup or comment out for performance\n- Change table names when modifying schemas rather than altering\n- Export clear query functions with proper TypeScript typing\n\n## Common Gotchas and Solutions\n\n1. **Environment Limitations:**\n - Val Town runs on Deno in a serverless context, not Node.js\n - Code in `shared/` must work in both frontend and backend environments\n - Cannot use `Deno` keyword in shared code\n - Use `https://esm.sh` for imports that work in both environments\n\n2. **SQLite Peculiarities:**\n - Limited support for ALTER TABLE operations\n - Create new tables with updated schemas and copy data when needed\n - Always run table creation before querying\n\n3. **React Configuration:**\n - All React dependencies must be pinned to 18.2.0\n - Always include `@jsxImportSource https://esm.sh/react@18.2.0` at the top of\n React files\n - Rendering issues often come from mismatched React versions\n\n4. **File Handling:**\n - Val Town only supports text files, not binary\n - Use the provided utilities to read files across branches and forks\n - For files in the project, use `readFile` helpers\n\n5. **API Design:**\n - `fetch` handler is the entry point for HTTP vals\n - Run the Hono app with\n `export default app.fetch // This is the entry point for HTTP vals`",[162],"76ae369e-891b-4767-a1a3-9ee0740d2d7d",".vtignore","e4a045d2-a862-11f1-9f72-1607ee4eb77e",274,["D",1788527812102],".git\n.vscode\n.cursorrules\n.DS_Store\nnode_modules\nvendor",[169],"pulls","branches",1,"forks","envVars",{"_183":185,"_186":60},"connections",{"_183":60,"_184":60},"count","unfilledCount",8,"emptyCount",{"_41":168,"_32":169,"_30":170,"_136":-5,"_39":40,"_38":171,"_138":47,"_36":205,"_13":60,"_33":20,"_34":173,"_24":47,"_143":-5,"_193":206,"_27":207},{"_41":161,"_32":162,"_30":163,"_136":-5,"_39":40,"_38":164,"_138":47,"_36":202,"_13":60,"_33":20,"_34":166,"_24":47,"_143":-5,"_193":203,"_27":204},{"_41":154,"_32":155,"_30":156,"_136":-5,"_39":40,"_38":157,"_138":47,"_36":199,"_13":60,"_33":141,"_34":159,"_24":47,"_143":-5,"_193":200,"_27":201},{"_41":146,"_32":147,"_30":55,"_136":-5,"_39":40,"_38":148,"_138":47,"_36":196,"_13":150,"_33":141,"_34":151,"_24":47,"_143":152,"_193":197,"_27":198},{"_41":133,"_32":134,"_30":135,"_136":-5,"_39":40,"_38":137,"_138":47,"_36":192,"_13":140,"_33":141,"_34":142,"_24":47,"_143":144,"_193":194,"_27":195},["D",1788264306338],"children",[],[134],["D",1788527812156],[],[147],["D",1788435892149],[],[155],["D",1788527812127],[],[162],["D",1788527812102],[],[169],["D",1787817154621],["D",1789583507842],{"_97":96,"_105":101},{"_97":96,"_98":99,"_100":101,"_18":53,"_102":103,"_104":47},{"_13":86,"_32":87,"_41":40,"_88":42,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":43,"_95":96},"ctx",{"_79":-5,"_125":246,"_247":248,"_249":250,"_251":47,"_252":47,"_253":47,"_254":25,"_255":-5,"_256":-7,"_257":-7,"_258":60,"_259":47,"_260":47,"_261":-5,"_262":47,"_263":47,"_264":47,"_265":-5},"ENV",{"_217":218,"_219":220,"_221":87,"_222":223,"_224":225,"_226":227,"_228":229,"_230":231,"_232":233,"_234":235,"_236":237,"_238":239,"_240":241,"_242":243,"_244":245},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","811aa22498c9b0b5a47e8d778de579cdb990f332","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"]

🎬 ${escapeHtml(CHANNEL_NAME)}

Stack Monitoring · aguking-stack

Stack Admin · aguking-stack

\nStack History\n · \naguking-stack\n

엑셀 - ${escapeHtml(channel)}

엑셀 관리 - ${escapeHtml(channel)}

Hi

Diff · v277