🎬 ${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],"bdd484ec-d937-4934-82fe-1035b1b130c1",["D",1789140499494],[27],"cad6b33c-4f04-4ee6-a01c-ae8b3bd66f1a","main.ts",378,["D",1789139913888],199,"// ver.4.1-B SINGLE-FILE — 시간 기준 초기화 (공통 CSS 분리 / 미사용 코드 정리)\nconst EMOJI_MAP: Record = {\n\t금연: \"🚭\",\"흡연\": \"🚬\",\"먹어\": \"🍚\",\"먹지마\": \"🚫\",\"짠\": \"🍻\",\"오늘의 재미\": \"🤣\",\"무서움 지수\": \"👻\",\"문어\": \"🐙\",\"꽃게\": \"🦀\",\"소라\": \"🐚\",\n;\nconst PRIMARY_CHANNEL = \"암본이수혁aguking\";\nconst AUTO_REFRESH_INTERVAL_MS = 15000;\nconst CLIENT_COMMON_JS = `let timer=null;function setStatus(t,e){statusEl.textContent=t,statusEl.className=\"status\"+(e?\" err\":\"\")}function formatCount(t){if(t===\"\"||t===null||t===void 0)return\"\";const e=Number(t);return Number.isFinite(e)?e.toLocaleString(\"en-US\",{maximumFractionDigits:6}):String(t)}function errorMessage(t){return t&&t.message?t.message:\"\\\\uC54C \\\\uC218 \\\\uC5C6\\\\uB294 \\\\uC624\\\\uB958\"}async function fetchJson(t,e){const s=await fetch(t,{cache:\"no-store\",credentials:\"same-origin\",...e||{}}),r=await s.text();let n=null;try{n=r?JSON.parse(r):null}catch{}if(!s.ok||!n||n.ok===!1){const o=n&&(n.message||n.error);throw new Error(o||\"HTTP \"+s.status+(r?\": \"+r:\"\"))}return n}function bindCommonControls(t){document.getElementById(\"loadBtn\").onclick=t,document.getElementById(\"autoRefresh\").onchange=e=>{clearInterval(timer),timer=e.target.checked?setInterval(t,${AUTO_REFRESH_INTERVAL_MS}):null},chInput.addEventListener(\"keydown\",e=>{e.key===\"Enter\"&&t()})}`;\n\nconst BASE_CSS = `:root{--bg:#f5f8fc;--panel:#fff;--line:#dde6f0;--text:#1c2733;--dim:#7891a8;--accent:#3b82f6;--input-bg:#eef3f9;--danger:#e0455a}*{box-sizing:border-box}body{margin:0;background:var(--bg);color:var(--text);font-family:SF Mono,D2Coding,Consolas,monospace;padding:24px 16px 60px;min-height:100vh}.wrap{max-width:560px;margin:0 auto}h1{font-size:15px;font-weight:600;letter-spacing:.02em;color:var(--dim);margin:0}h1 span{color:var(--accent)}.panel{background:var(--panel);border:1px solid var(--line);border-radius:10px;padding:16px;margin-bottom:14px;box-shadow:0 1px 2px #3b82f60f}label{display:block;font-size:12px;color:var(--dim);margin-bottom:6px}.row{display:flex;gap:8px;margin-bottom:10px;flex-wrap:wrap}input[type=text],input[type=number],select{flex:1;min-width:0;background:var(--input-bg);border:1px solid var(--line);border-radius:6px;color:var(--text);padding:9px 10px;font-family:inherit;font-size:16px}input[type=text]:focus,input[type=number]:focus,select:focus{outline:none;border-color:var(--accent)}button{background:var(--accent);color:#fff;border:none;border-radius:6px;padding:9px 14px;font-family:inherit;font-size:13px;font-weight:600;cursor:pointer;min-height:40px}button:hover{filter:brightness(1.08)}button.ghost{background:transparent;color:var(--dim);border:1px solid var(--line);font-weight:500}button.ghost:hover{color:var(--text);border-color:var(--accent)}.toolbar{display:flex;align-items:center;justify-content:space-between;margin-top:4px;flex-wrap:wrap;gap:8px}.auto{display:flex;align-items:center;gap:6px;font-size:12px;color:var(--dim)}.auto input{accent-color:var(--accent)}.status{font-size:12px;color:var(--dim);margin:10px 0 4px;min-height:16px;white-space:pre-wrap;word-break:break-word}.status.err{color:var(--danger)}.items{display:flex;flex-direction:column;gap:8px}.item{display:flex;align-items:baseline;justify-content:space-between;background:var(--input-bg);border:1px solid var(--line);border-radius:8px;padding:10px 12px;gap:8px}.item .name{font-size:14px;word-break:break-word}.item .count{font-size:14px;font-weight:700;color:var(--accent)}.empty{text-align:center;color:var(--dim);font-size:13px;padding:28px 0}@media(max-width:380px){body{padding:16px 12px 48px}}`;\n\nfunction label(item: string): string {\n\tconst emoji = EMOJI_MAP[item];\n\treturn emoji ? `${emoji} ${item}` : item;\n}\n\nconst MAX_CHANNEL_LENGTH = 100;\nconst MAX_ITEM_LENGTH = 100;\n\nfunction toNfc(value: string): string {\n\ttry {\n\t\treturn String(value ?? \"\").normalize(\"NFC\");\n\t} catch {\n\t\treturn String(value ?? \"\");\n\t}\n}\n\nfunction normalizeChannel(channel: string): string {\n\tconst trimmed = toNfc(String(channel ?? \"\").trim());\n\n return trimmed === \"암본이수혁 aguking\" ? PRIMARY_CHANNEL : trimmed;\n}\n\nfunction isSafeChannelName(channel: string): boolean {\n\treturn (\n\t\ttypeof channel === \"string\" && channel.length > 0 && channel.length <= MAX_CHANNEL_LENGTH && !/[\\x00-\\x1F\\x7F]/.test(channel)\n\t);\n}\n\nfunction isSafeItemName(item: string): boolean {\n\treturn typeof item === \"string\" && item.length > 0 && item.length <= MAX_ITEM_LENGTH && !/[\\x00-\\x1F\\x7F]/.test(item);\n}\n\n// Monitor HTML\n\nconst MONITOR_HTML = `Stack Monitoring

채널

불러오는 중...

`;\n\n// Admin HTML\n\nconst ADMIN_HTML = `Stack Admin

Stack Admin · aguking-stack

Maintenance mode

상태 확인 중...

채널

불러오는 중...

`;\n\n// History HTML\n\nconst HISTORY_HTML = `Stack History

채널

기록을 불러오는 중...

`;\n\n// ver. 3 core: security + concurrency + JSON API + dedupe\nfunction getAdminAccounts(): Map {\n\tconst rawAccounts = Deno.env.get(\"ADMIN_ACCOUNTS\") || \"\";\n\tconst accounts = new Map();\n\tfor (const entry of rawAccounts.split(\",\")) {\n\t\tconst separatorIndex = entry.indexOf(\":\");\n\t\tif (separatorIndex <= 0) continue;\n\t\tconst username = toNfc(entry.slice(0, separatorIndex).trim());\n\t\tconst password = entry.slice(separatorIndex + 1).trim();\n\t\tif (username && password) accounts.set(username, password);\n\t}\n\treturn accounts;\n}\nfunction timingSafeEqualText(a: string, b: string): boolean {\n\tconst left = new TextEncoder().encode(a);\n\tconst right = new TextEncoder().encode(b);\n\tlet diff = left.length ^ right.length;\n\tconst length = Math.max(left.length, right.length);\n\tfor (let i = 0; i < length; i++) {\n\t\tdiff |= (left[i] || 0) ^ (right[i] || 0);\n\t}\n\treturn diff === 0;\n}\nfunction bytesToHex(buffer: ArrayBuffer): string {\n\treturn Array.from(new Uint8Array(buffer))\n\t\t.map((b) => b.toString(16).padStart(2, \"0\"))\n\t\t.join(\"\");\n}\nasync function sha256Hex(value: string): Promise {\n\treturn bytesToHex(await crypto.subtle.digest(\"SHA-256\", new TextEncoder().encode(value)));\n}\nasync function getAuthenticatedAdminUser(req: Request): Promise {\n\tconst accounts = getAdminAccounts();\n\tif (!accounts.size) return null;\n\tconst authHeader = req.headers.get(\"authorization\") || \"\";\n\tif (!authHeader.startsWith(\"Basic \")) return null;\n\ttry {\n\t\tconst decoded = new TextDecoder().decode(Uint8Array.from(atob(authHeader.slice(\"Basic \".length)), (c) => c.charCodeAt(0)));\n\t\tconst separatorIndex = decoded.indexOf(\":\");\n\t\tif (separatorIndex < 0) return null;\n\t\tconst inputUser = toNfc(decoded.slice(0, separatorIndex).trim());\n\t\tconst inputPassword = decoded.slice(separatorIndex + 1);\n\t\tconst stored = accounts.get(inputUser);\n\t\tif (!stored) return null;\n\t\tconst valid = stored.startsWith(\"sha256$\")\n\t\t\t? timingSafeEqualText(await sha256Hex(inputPassword), stored.slice(\"sha256$\".length))\n\t\t\t: timingSafeEqualText(inputPassword, stored);\n\t\treturn valid ? inputUser : null;\n\t} catch {\n\t\treturn null;\n\t}\n}\nasync function checkAuth(req: Request): Promise {\n\treturn (await getAuthenticatedAdminUser(req)) !== null;\n}\nconst STACK_API_SECRET = Deno.env.get(\"STACK_API_SECRET\") || \"\";\nfunction checkStackApiKey(req: Request): boolean {\n\tif (!STACK_API_SECRET) return false;\n\tconst headerKey = req.headers.get(\"x-stack-key\") || \"\";\n\tif (headerKey && timingSafeEqualText(headerKey, STACK_API_SECRET)) {\n\t\treturn true;\n\t}\n\tconst url = new URL(req.url);\n\tconst queryKey = url.searchParams.get(\"key\") || \"\";\n\treturn !!queryKey && timingSafeEqualText(queryKey, STACK_API_SECRET);\n}\nfunction unauthorizedResponse(): Response {\n\treturn jsonResponse({ ok: false, error: \"인증이 필요합니다.\" }, 401, {\n\t\t\"WWW-Authenticate\": 'Basic realm=\"Admin Area\", charset=\"UTF-8\"',\n\t});\n}\nfunction forbiddenResponse(): Response {\n\treturn jsonResponse({ ok: false, error: \"권한이 없습니다.\" }, 403);\n}\nconst SEC_HEADERS = { \"cache-control\": \"no-store\", \"x-content-type-options\": \"nosniff\", \"referrer-policy\": \"no-referrer\" };\nfunction jsonResponse(body: unknown, status = 200, extraHeaders: Record = {}): Response {\n\treturn new Response(JSON.stringify(body), {\n\t\tstatus,\n\t\theaders: {\n\t\t\t\"content-type\": \"application/json; charset=utf-8\",\n\t\t\t...SEC_HEADERS,\n\t\t\t...extraHeaders,\n\t\t},\n\t});\n}\nfunction textResponse(body: string, status = 200, extraHeaders: Record = {}): Response {\n\treturn new Response(body, {\n\t\tstatus,\n\t\theaders: {\n\t\t\t\"content-type\": \"text/plain; charset=utf-8\",\n\t\t\t...SEC_HEADERS,\n\t\t\t...extraHeaders,\n\t\t},\n\t});\n}\nfunction htmlResponse(html: string): Response {\n\treturn new Response(html, {\n\t\theaders: {\n\t\t\t\"content-type\": \"text/html; charset=utf-8\",\n\t\t\t...SEC_HEADERS,\n\t\t},\n\t});\n}\nconst MAINTENANCE_KEY = \"system_maintenance\";\nconst MAINTENANCE_MESSAGE = \"🚧 스택봇 점검중입니다.\";\nasync function safeGetJSON(blobStore: { getJSON: (k: string) => Promise }, key: string, fallback: T): Promise {\n\ttry {\n\t\treturn ((await blobStore.getJSON(key)) as T) ?? fallback;\n\t} catch {\n\t\treturn fallback;\n\t}\n}\nasync function getMaintenanceMode(blob: { getJSON: (k: string) => Promise }): Promise {\n\tconst value = await safeGetJSON<{ on?: boolean } | null>(blob, MAINTENANCE_KEY, null);\n\treturn value?.on === true;\n}\nasync function setMaintenanceMode(blob: { setJSON: (k: string, v: unknown) => Promise }, on: boolean): Promise {\n\tawait blob.setJSON(MAINTENANCE_KEY, { on: !!on });\n}\nfunction roundAmount(n: number): number {\n\treturn Math.round(n * 1e6) / 1e6;\n}\nfunction parsePositiveAmount(value: unknown): number | null {\n\tconst s = String(value ?? \"\").trim();\n\tif (!/^\\d+(?:\\.\\d+)?$/.test(s)) return null;\n\tconst n = Number(s);\n\tif (!Number.isFinite(n) || n <= 0 || n > 1_000_000_000) return null;\n\treturn roundAmount(n);\n}\ntype ParsedCommandAmount = {\n\titem: string;\n\tamount: number;\n\tvalid: boolean;\n\tlastToken: string | null;\n};\nfunction endsWithBareNumber(item: string): boolean {\n\treturn /(^|\\s)-?\\d+(?:\\.\\d+)?$/.test(item.trim());\n}\nfunction splitItemAndAmount(rest: string[]): ParsedCommandAmount {\n\tconst tokens = rest.map((token) => toNfc(token.trim())).filter(Boolean);\n\tif (!tokens.length) {\n\t\treturn { item: \"\", amount: 1, valid: true, lastToken: null };\n\t}\n\tconst last = tokens[tokens.length - 1];\n\tif (tokens.length === 1 || !/^-?(?:\\d+(?:\\.\\d+)?)$/.test(last)) {\n\t\treturn { item: tokens.join(\" \"), amount: 1, valid: true, lastToken: last };\n\t}\n\tconst item = tokens.slice(0, -1).join(\" \");\n\tconst amount = parsePositiveAmount(last);\n\treturn amount === null ? { item, amount: 0, valid: false, lastToken: last } : { item, amount, valid: true, lastToken: last };\n}\nfunction normalizeItem(raw: unknown): string {\n\treturn toNfc(String(raw ?? \"\").trim());\n}\nfunction sanitizeStack(input: unknown): Record {\n\tconst out: Record = Object.create(null);\n\tif (!input || typeof input !== \"object\" || Array.isArray(input)) return out;\n\tfor (const [rawItem, rawValue] of Object.entries(input as Record)) {\n\t\tconst item = normalizeItem(rawItem);\n\t\tconst value = Number(rawValue);\n\t\tif (!isSafeItemName(item) || !Number.isFinite(value) || value <= 0) {\n\t\t\tcontinue;\n\t\t}\n\t\tout[item] = roundAmount((out[item] || 0) + value);\n\t}\n\treturn out;\n}\nconst MAX_HISTORY_ENTRIES = 1000;\ninterface HistoryEntry {\n\ttime: string;\n\taction: \"추가\" | \"차감\" | \"삭제\" | \"초기화\";\n\titem?: string;\n\tsource?: \"nightbot\" | \"admin\" | \"api\" | \"youtube-auto\" | \"cron\";\n\tactor?: string;\n\tamount?: number;\n\tcount?: number;\n}\nfunction historyFingerprint(entry: HistoryEntry): string {\n\treturn JSON.stringify([\n\t\tentry.time,\n\t\tentry.action,\n\t\tentry.source || \"\",\n\t\tentry.actor || \"\",\n\t\tentry.item || \"\",\n\t\tentry.amount ?? null,\n\t\tentry.count ?? null,\n\t]);\n}\nfunction sanitizeHistory(input: unknown): HistoryEntry[] {\n\tif (!Array.isArray(input)) return [];\n\tconst seen = new Set();\n\tconst out: HistoryEntry[] = [];\n\tfor (const raw of input) {\n\t\tif (!raw || typeof raw !== \"object\") continue;\n\t\tconst e = raw as Partial;\n\t\tif (typeof e.time !== \"string\") continue;\n\t\tif (![\"추가\", \"차감\", \"삭제\", \"초기화\"].includes(e.action || \"\")) continue;\n\t\tconst item = e.item === undefined ? undefined : normalizeItem(e.item);\n\t\tif (item !== undefined && !isSafeItemName(item)) continue;\n\t\tconst amount = e.amount === undefined ? undefined : Number(e.amount);\n\t\tconst count = e.count === undefined ? undefined : Number(e.count);\n\t\tif (amount !== undefined && (!Number.isFinite(amount) || amount <= 0)) {\n\t\t\tcontinue;\n\t\t}\n\t\tif (count !== undefined && (!Number.isFinite(count) || count < 0)) continue;\n\t\tconst clean: HistoryEntry = {\n\t\t\ttime: e.time,\n\t\t\taction: e.action as HistoryEntry[\"action\"],\n\t\t\t...(typeof e.source === \"string\" ? { source: e.source as HistoryEntry[\"source\"] } : {}),\n\t\t\t...(typeof e.actor === \"string\" ? { actor: e.actor.slice(0, 100) } : {}),\n\t\t\t...(item === undefined ? {} : { item }),\n\t\t\t...(amount === undefined ? {} : { amount: roundAmount(amount) }),\n\t\t\t...(count === undefined ? {} : { count: roundAmount(count) }),\n\t\t};\n\t\tconst fp = historyFingerprint(clean);\n\t\tif (seen.has(fp)) continue;\n\t\tseen.add(fp);\n\t\tout.push(clean);\n\t}\n\treturn out.sort((a, b) => new Date(a.time).getTime() - new Date(b.time).getTime()).slice(-MAX_HISTORY_ENTRIES);\n}\nasync function readHistory(blob: { getJSON: (k: string) => Promise }, channel: string): Promise {\n\treturn sanitizeHistory(await safeGetJSON(blob, `history_${channel}`, null));\n}\nasync function appendHistory(\n\tblob: {\n\t\tgetJSON: (k: string) => Promise;\n\t\tsetJSON: (k: string, v: unknown) => Promise;\n\t},\n\tchannel: string,\n\tentry: HistoryEntry,\n): Promise {\n\tconst history = await readHistory(blob, channel);\n\tconst clean: HistoryEntry = {\n\t\t...entry,\n\t\titem: entry.item === undefined ? undefined : normalizeItem(entry.item),\n\t\tamount: entry.amount === undefined ? undefined : roundAmount(entry.amount),\n\t\tcount: entry.count === undefined ? undefined : roundAmount(entry.count),\n\t};\n\tconst fp = historyFingerprint(clean);\n\tif (!history.some((e) => historyFingerprint(e) === fp)) {\n\t\thistory.push(clean);\n\t}\n\tawait blob.setJSON(`history_${channel}`, sanitizeHistory(history));\n}\nfunction formatStack(stack: Record): string {\n\tconst keys = Object.keys(stack);\n\tif (!keys.length) return \"🤖 현재 스택 없음.\";\n\treturn keys.map((k) => `${label(k)} ${roundAmount(stack[k])}`).join(\", \");\n}\ntype StackAction = \"추가\" | \"차감\" | \"삭제\" | \"초기화\";\nconst STACK_ACTIONS: readonly string[] = [\"추가\", \"차감\", \"삭제\", \"초기화\"];\nfunction isStackAction(value: string): value is StackAction {\n\treturn STACK_ACTIONS.includes(value);\n}\ntype ActionResult = {\n\tok: boolean;\n\taction?: StackAction;\n\tchannel: string;\n\titem?: string;\n\tamount?: number;\n\tcount?: number;\n\tstack: Record;\n\tmessage: string;\n\terror?: string;\n};\nasync function readStack(blob: { getJSON: (k: string) => Promise }, channel: string): Promise> {\n\treturn sanitizeStack(await safeGetJSON(blob, `stack_${channel}`, null));\n}\nasync function writeStack(\n\tblob: { setJSON: (k: string, v: unknown) => Promise },\n\tchannel: string,\n\tstack: Record,\n): Promise {\n\tawait blob.setJSON(`stack_${channel}`, sanitizeStack(stack));\n}\nasync function applyStackAction(\n\tblob: {\n\t\tgetJSON: (k: string) => Promise;\n\t\tsetJSON: (k: string, v: unknown) => Promise;\n\t\tdelete: (k: string) => Promise;\n\t},\n\tchannel: string,\n\taction: StackAction,\n\trawItem?: unknown,\n\trawAmount?: unknown,\n\thistoryMeta: Pick = {},\n): Promise {\n\tconst item = normalizeItem(rawItem);\n\tconst amount = rawAmount === undefined ? 1 : parsePositiveAmount(rawAmount);\n\tconst stack = await readStack(blob, channel);\n\tif (action === \"초기화\") {\n\t\tawait blob.delete(`stack_${channel}`);\n\t\tawait appendHistory(blob, channel, {\n\t\t\ttime: new Date().toISOString(),\n\t\t\taction: \"초기화\",\n\t\t\t...historyMeta,\n\t\t});\n\t\treturn {\n\t\t\tok: true,\n\t\t\taction,\n\t\t\tchannel,\n\t\t\tstack: Object.create(null),\n\t\t\tmessage: \"스택을 초기화했습니다.\",\n\t\t};\n\t}\n\tif (!item) {\n\t\treturn {\n\t\t\tok: false,\n\t\t\tchannel,\n\t\t\tstack,\n\t\t\tmessage: \"항목을 입력해주세요.\",\n\t\t\terror: \"INVALID_ITEM\",\n\t\t};\n\t}\n\tif (!isSafeItemName(item)) {\n\t\treturn {\n\t\t\tok: false,\n\t\t\tchannel,\n\t\t\tstack,\n\t\t\tmessage: \"항목 이름은 1~100 자로 입력해주세요.\",\n\t\t\terror: \"INVALID_ITEM\",\n\t\t};\n\t}\n\tif (amount === null) {\n\t\treturn {\n\t\t\tok: false,\n\t\t\tchannel,\n\t\t\titem,\n\t\t\tstack,\n\t\t\tmessage: \"수량은 0 보다 큰 숫자만 입력할 수 있습니다.\",\n\t\t\terror: \"INVALID_AMOUNT\",\n\t\t};\n\t}\n\tif (action === \"추가\") {\n\t\tconst next = roundAmount((stack[item] || 0) + amount);\n\t\tstack[item] = next;\n\t\tawait writeStack(blob, channel, stack);\n\t\tawait appendHistory(blob, channel, {\n\t\t\ttime: new Date().toISOString(),\n\t\t\taction,\n\t\t\titem,\n\t\t\tamount,\n\t\t\tcount: next,\n\t\t\t...historyMeta,\n\t\t});\n\t\treturn {\n\t\t\tok: true,\n\t\t\taction,\n\t\t\tchannel,\n\t\t\titem,\n\t\t\tamount,\n\t\t\tcount: next,\n\t\t\tstack,\n\t\t\tmessage: `${label(item)} ${next}`,\n\t\t};\n\t}\n\tif (action === \"차감\") {\n\t\tif (!(item in stack)) {\n\t\t\treturn {\n\t\t\t\tok: false,\n\t\t\t\taction,\n\t\t\t\tchannel,\n\t\t\t\titem,\n\t\t\t\tamount,\n\t\t\t\tstack,\n\t\t\t\tmessage: `${label(item)} 항목이 없습니다.`,\n\t\t\t\terror: \"NOT_FOUND\",\n\t\t\t};\n\t\t}\n\t\tconst next = roundAmount(stack[item] - amount);\n\t\tif (next <= 0) {\n\t\t\tdelete stack[item];\n\t\t\tawait writeStack(blob, channel, stack);\n\t\t\tawait appendHistory(blob, channel, {\n\t\t\t\ttime: new Date().toISOString(),\n\t\t\t\taction,\n\t\t\t\titem,\n\t\t\t\tamount,\n\t\t\t\tcount: 0,\n\t\t\t\t...historyMeta,\n\t\t\t});\n\t\t\treturn {\n\t\t\t\tok: true,\n\t\t\t\taction,\n\t\t\t\tchannel,\n\t\t\t\titem,\n\t\t\t\tamount,\n\t\t\t\tcount: 0,\n\t\t\t\tstack,\n\t\t\t\tmessage: `${label(item)} 0 이하가 되어 삭제했습니다.`,\n\t\t\t};\n\t\t}\n\t\tstack[item] = next;\n\t\tawait writeStack(blob, channel, stack);\n\t\tawait appendHistory(blob, channel, {\n\t\t\ttime: new Date().toISOString(),\n\t\t\taction,\n\t\t\titem,\n\t\t\tamount,\n\t\t\tcount: next,\n\t\t\t...historyMeta,\n\t\t});\n\t\treturn {\n\t\t\tok: true,\n\t\t\taction,\n\t\t\tchannel,\n\t\t\titem,\n\t\t\tamount,\n\t\t\tcount: next,\n\t\t\tstack,\n\t\t\tmessage: `${label(item)} ${next}`,\n\t\t};\n\t}\n\tif (!(item in stack)) {\n\t\treturn {\n\t\t\tok: false,\n\t\t\taction,\n\t\t\tchannel,\n\t\t\titem,\n\t\t\tstack,\n\t\t\tmessage: `${label(item)} 항목이 없습니다.`,\n\t\t\terror: \"NOT_FOUND\",\n\t\t};\n\t}\n\tdelete stack[item];\n\tawait writeStack(blob, channel, stack);\n\tawait appendHistory(blob, channel, {\n\t\ttime: new Date().toISOString(),\n\t\taction,\n\t\titem,\n\t\t...historyMeta,\n\t});\n\treturn {\n\t\tok: true,\n\t\taction,\n\t\tchannel,\n\t\titem,\n\t\tstack,\n\t\tmessage: `${label(item)} 삭제했습니다.`,\n\t};\n}\nconst channelLocks = new Map>();\nasync function withChannelLock(channel: string, task: () => Promise): Promise {\n\tconst previous = channelLocks.get(channel) || Promise.resolve();\n\tlet release!: () => void;\n\tconst current = new Promise((resolve) => {\n\t\trelease = resolve;\n\t});\n\tchannelLocks.set(channel, current);\n\tawait previous;\n\ttry {\n\t\treturn await task();\n\t} finally {\n\t\trelease();\n\t\tif (channelLocks.get(channel) === current) channelLocks.delete(channel);\n\t}\n}\nconst MAX_JSON_BODY_BYTES = 16 * 1024;\nasync function readJsonBody(req: Request): Promise | null> {\n\tconst contentLength = Number(req.headers.get(\"content-length\") || 0);\n\tif (Number.isFinite(contentLength) && contentLength > MAX_JSON_BODY_BYTES) {\n\t\treturn null;\n\t}\n\ttry {\n\t\tconst text = await req.text();\n\t\tif (new TextEncoder().encode(text).byteLength > MAX_JSON_BODY_BYTES) {\n\t\t\treturn null;\n\t\t}\n\t\tconst body = JSON.parse(text);\n\t\treturn body && typeof body === \"object\" && !Array.isArray(body) ? (body as Record) : null;\n\t} catch {\n\t\treturn null;\n\t}\n}\nfunction sameOrigin(req: Request, url: URL): boolean {\n\tconst origin = req.headers.get(\"origin\");\n\tconst referer = req.headers.get(\"referer\");\n\tconst valid = (value: string | null) => {\n\t\tif (!value) return false;\n\t\ttry {\n\t\t\treturn new URL(value).origin === url.origin;\n\t\t} catch {\n\t\t\treturn false;\n\t\t}\n\t};\n\treturn valid(origin) || valid(referer);\n}\nfunction getValidatedChannel(raw: unknown): string | null {\n\tconst value = toNfc(String(raw ?? \"\").trim());\n\tif (!value || !isSafeChannelName(value)) return null;\n\treturn normalizeChannel(value);\n}\ntype BlobStore = {\n\tgetJSON: (key: string) => Promise;\n\tsetJSON: (key: string, value: unknown) => Promise;\n\tdelete: (key: string) => Promise;\n};\nconst DAILY_RESET_TRIGGER = \"daily-reset\";\nconst DAILY_RESET_DEDUPE_MS = 60 * 60 * 1000;\nasync function handleStackJsonApi(req: Request, url: URL, blob: BlobStore): Promise {\n\tif (req.method === \"GET\") {\n\t\tconst channel = getValidatedChannel(url.searchParams.get(\"ch\"));\n\t\tif (!channel) {\n\t\t\treturn jsonResponse({ ok: false, error: \"유효하지 않은 채널명입니다.\" }, 400);\n\t\t}\n\t\treturn await withChannelLock(channel, async () => {\n\t\t\tconst stack = await readStack(blob, channel);\n\t\t\treturn jsonResponse({\n\t\t\t\tok: true,\n\t\t\t\tchannel,\n\t\t\t\tstack,\n\t\t\t\titems: Object.entries(stack).map(([item, count]) => ({\n\t\t\t\t\titem,\n\t\t\t\t\tlabel: label(item),\n\t\t\t\t\tcount,\n\t\t\t\t})),\n\t\t\t});\n\t\t});\n\t}\n\tif (req.method !== \"POST\") {\n\t\treturn jsonResponse({ ok: false, error: \"Method Not Allowed\" }, 405, {\n\t\t\tAllow: \"GET, POST\",\n\t\t});\n\t}\n\tconst adminUser = await getAuthenticatedAdminUser(req);\n\tconst apiKey = checkStackApiKey(req);\n\tif (!adminUser && !apiKey) return forbiddenResponse();\n\tif (!apiKey && !sameOrigin(req, url)) return forbiddenResponse();\n\tconst body = await readJsonBody(req);\n\tif (!body) {\n\t\treturn jsonResponse(\n\t\t\t{\n\t\t\t\tok: false,\n\t\t\t\terror: \"JSON body가 올바르지 않거나 너무 큽니다.\",\n\t\t\t},\n\t\t\t400,\n\t\t);\n\t}\n\tconst channel = getValidatedChannel(body.channel);\n\tif (!channel) {\n\t\treturn jsonResponse({ ok: false, error: \"유효하지 않은 채널명입니다.\" }, 400);\n\t}\n\tconst action = toNfc(String(body.action ?? \"\"));\n\tif (action === \"기록초기화\") {\n\t\tif (!adminUser) return forbiddenResponse();\n\t\treturn await withChannelLock(channel, async () => {\n\t\t\tawait blob.delete(`history_${channel}`);\n\t\t\treturn jsonResponse({\n\t\t\t\tok: true,\n\t\t\t\taction,\n\t\t\t\tchannel,\n\t\t\t\tmessage: \"기록 (History) 을 초기화했습니다.\",\n\t\t\t});\n\t\t});\n\t}\n\tif (!isStackAction(action)) {\n\t\treturn jsonResponse({ ok: false, error: \"지원하지 않는 action입니다.\" }, 400);\n\t}\n\tconst isDailyReset = !adminUser && apiKey && action === \"초기화\" && body.trigger === DAILY_RESET_TRIGGER;\n\tconst historyMeta: Pick = adminUser\n\t\t? { source: \"admin\", actor: adminUser }\n\t\t: isDailyReset\n\t\t\t? { source: \"cron\", actor: \"매일 06:00 초기화\" }\n\t\t\t: { source: \"api\", actor: \"API Key\" };\n\treturn await withChannelLock(channel, async () => {\n\t\tif (isDailyReset) {\n\t\t\tconst now = Date.now();\n\t\t\tconst history = await readHistory(blob, channel);\n\t\t\tconst alreadyDone = history.some(\n\t\t\t\t(e) => e.action === \"초기화\" && e.source === \"cron\" && now - Date.parse(e.time) < DAILY_RESET_DEDUPE_MS,\n\t\t\t);\n\t\t\tif (alreadyDone) {\n\t\t\t\treturn jsonResponse({\n\t\t\t\t\tok: true,\n\t\t\t\t\taction,\n\t\t\t\t\tchannel,\n\t\t\t\t\tskipped: true,\n\t\t\t\t\tstack: await readStack(blob, channel),\n\t\t\t\t\tmessage: \"최근 1시간 안에 매일 초기화를 이미 실행해서 건너뜁니다.\",\n\t\t\t\t});\n\t\t\t}\n\t\t}\n\t\tconst result = await applyStackAction(blob, channel, action, body.item, body.amount, historyMeta);\n\t\treturn jsonResponse(result, result.ok ? 200 : 400);\n\t});\n}\nasync function handleHistoryJsonApi(req: Request, url: URL, blob: Pick): Promise {\n\tif (req.method !== \"GET\") {\n\t\treturn jsonResponse({ ok: false, error: \"Method Not Allowed\" }, 405, {\n\t\t\tAllow: \"GET\",\n\t\t});\n\t}\n\tconst channel = getValidatedChannel(url.searchParams.get(\"ch\"));\n\tif (!channel) {\n\t\treturn jsonResponse({ ok: false, error: \"유효하지 않은 채널명입니다.\" }, 400);\n\t}\n\tconst history = (await readHistory(blob, channel)).map((entry) => ({\n\t\t...entry,\n\t\tactor: undefined,\n\t}));\n\tconst payload = { ok: true, channel, history };\n\tconst etag = `\"${(await sha256Hex(JSON.stringify(payload))).slice(0, 32)}\"`;\n\tconst ifNoneMatch = (req.headers.get(\"if-none-match\") || \"\").replace(/^W\\//, \"\");\n\tif (ifNoneMatch === etag) {\n\t\treturn new Response(null, {\n\t\t\tstatus: 304,\n\t\t\theaders: {\n\t\t\t\tetag,\n\t\t\t\t...SEC_HEADERS,\n\t\t\t},\n\t\t});\n\t}\n\treturn jsonResponse(payload, 200, { etag });\n}\nasync function handleNightbotRequest(req: Request, url: URL, blob: BlobStore): Promise {\n\tconst requestedQuery = toNfc((url.searchParams.get(\"q\") || \"\").trim());\n\tconst channel = getValidatedChannel(url.searchParams.get(\"ch\"));\n\tif (!channel) return textResponse(\"채널명을 입력해주세요.\", 200);\n\tif (requestedQuery && !checkStackApiKey(req)) return forbiddenResponse();\n\tif (await getMaintenanceMode(blob)) {\n\t\treturn textResponse(MAINTENANCE_MESSAGE, 200);\n\t}\n\tconst historyMeta: Pick = {\n\t\tsource: \"nightbot\",\n\t\tactor: \"nightbot\",\n\t};\n\treturn await withChannelLock(channel, async () => {\n\t\tif (!requestedQuery) {\n\t\t\treturn textResponse(formatStack(await readStack(blob, channel)));\n\t\t}\n\t\tconst parts = requestedQuery.split(/\\s+/);\n\t\tconst command = parts[0];\n\t\tif (command === \"기록초기화\") {\n\t\t\treturn textResponse(\"기록초기화는 관리자 화면에서만 할 수 있습니다.\");\n\t\t}\n\t\tif (command === \"추가\" || command === \"차감\" || command === \"빼기\") {\n\t\t\tconst parsed = splitItemAndAmount(parts.slice(1));\n\t\t\tif (!parsed.item) {\n\t\t\t\treturn textResponse(\n\t\t\t\t\tcommand === \"추가\"\n\t\t\t\t\t\t? \"사용법 : !스택 추가 [항목] [숫자 (생략가능, 소수 가능)]\"\n\t\t\t\t\t\t: \"사용법 : !스택 차감 (빼기) [항목] [숫자 (생략가능, 소수 가능)]\",\n\t\t\t\t);\n\t\t\t}\n\t\t\tif (!parsed.valid) {\n\t\t\t\treturn textResponse(`수량은 0 보다 큰 숫자만 입력할 수 있습니다. (인식된 수량 토큰: \"${parsed.lastToken ?? \"\"}\")`);\n\t\t\t}\n\t\t\tif (command === \"추가\" && endsWithBareNumber(parsed.item)) {\n\t\t\t\treturn textResponse(`항목 이름(\"${parsed.item}\") 끝에 숫자가 포함되어 있어 추가하지 않았습니다.`);\n\t\t\t}\n\t\t\tconst result = await applyStackAction(\n\t\t\t\tblob,\n\t\t\t\tchannel,\n\t\t\t\tcommand === \"추가\" ? \"추가\" : \"차감\",\n\t\t\t\tparsed.item,\n\t\t\t\tparsed.amount,\n\t\t\t\thistoryMeta,\n\t\t\t);\n\t\t\treturn textResponse(result.message, 200);\n\t\t}\n\t\tif (command === \"삭제\") {\n\t\t\tconst result = await applyStackAction(blob, channel, \"삭제\", parts.slice(1).join(\" \"), undefined, historyMeta);\n\t\t\treturn textResponse(result.message, 200);\n\t\t}\n\t\tif (command === \"초기화\") {\n\t\t\tconst result = await applyStackAction(blob, channel, \"초기화\", undefined, undefined, historyMeta);\n\t\t\treturn textResponse(result.message, 200);\n\t\t}\n\t\treturn textResponse(\"알 수 없는 명령입니다. (추가/차감/삭제/초기화)\", 200);\n\t});\n}\nexport default async function (req: Request): Promise {\n\tconst { blob } = await import(\"https://esm.town/v/std/blob\");\n\tconst url = new URL(req.url);\n\tif (url.pathname === \"/admin\") {\n\t\tif (!(await checkAuth(req))) return unauthorizedResponse();\n\t\treturn htmlResponse(ADMIN_HTML);\n\t}\n\tif (url.pathname === \"/monitor\") return htmlResponse(MONITOR_HTML);\n\tif (url.pathname === \"/history\") return htmlResponse(HISTORY_HTML);\n\tif (url.pathname === \"/api/stack\") {\n\t\treturn handleStackJsonApi(req, url, blob);\n\t}\n\tif (url.pathname === \"/api/history\") {\n\t\treturn handleHistoryJsonApi(req, url, blob);\n\t}\n\tif (url.pathname === \"/admin/maintenance-status\") {\n\t\tif (!(await checkAuth(req))) return unauthorizedResponse();\n\t\treturn jsonResponse({ ok: true, on: await getMaintenanceMode(blob) });\n\t}\n\tif (url.pathname === \"/admin/maintenance\" && req.method === \"POST\") {\n\t\tif (!(await checkAuth(req))) return unauthorizedResponse();\n\t\tif (!sameOrigin(req, url)) return forbiddenResponse();\n\t\tconst body = await readJsonBody(req);\n\t\tif (!body || typeof body.on !== \"boolean\") {\n\t\t\treturn jsonResponse({ ok: false, error: \"on(boolean)이 필요합니다.\" }, 400);\n\t\t}\n\t\tawait setMaintenanceMode(blob, body.on);\n\t\treturn jsonResponse({ ok: true, on: body.on });\n\t}\n\tif (url.pathname === \"/youtube-check\" || url.pathname.startsWith(\"/youtube-webhook\")) {\n\t\treturn jsonResponse(\n\t\t\t{\n\t\t\t\tok: false,\n\t\t\t\terror: \"YouTube 자동 초기화는 사용하지 않습니다. (매일 06:00 초기화로 운영)\",\n\t\t\t},\n\t\t\t410,\n\t\t);\n\t}\n\treturn handleNightbotRequest(req, url, blob);\n}","aguking-stack",[150],"a81d3785-4d93-48a3-a20e-96a95950da37","excel.ts","b6c0703c-a863-11f1-85c1-1607ee4eb77e",371,["D",1789044918857],3,"import { 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}","aguking-excel",[158],"e9f69516-3243-4254-b5c2-2e1f1ede405c","cron.ts","76069368-acbf-11f1-9e7d-1607ee4eb77e",377,["D",1789109900008],8,"interval","// 매일 06:00 KST 스택 초기화 (시간 기준, B)\n// Val Town Cron 스케줄은 지금 설정 그대로 두면 된다. (UTC 기준 0 21 * * * = KST 06:00)\n//\n// - main.ts 의 /api/stack 에 trigger:\"daily-reset\" 으로 초기화를 요청한다.\n// → History에 \"자동초기화(06시)\"로 기록된다.\n// - 일시적인 오류(네트워크, 5xx)는 최대 3번까지 다시 시도한다.\n// 서버가 최근 1시간 안의 매일 초기화를 건너뛰므로 재시도해도 두 번 초기화되지 않는다.\n\nconst STACK_API_URL = \"https://aguking-stack.val.run/api/stack\";\nconst STACK_API_SECRET = Deno.env.get(\"STACK_API_SECRET\") || \"\";\nconst CHANNEL = \"암본이수혁aguking\";\n\nconst MAX_ATTEMPTS = 3;\nconst REQUEST_TIMEOUT_MS = 15_000;\nconst RETRY_DELAY_MS = 5_000;\n\nexport default async function (_interval: Interval) {\n if (!STACK_API_SECRET) {\n console.error(\"STACK_API_SECRET이 없어 매일 초기화를 실행할 수 없습니다.\");\n return;\n }\n\n for (let attempt = 1; attempt <= MAX_ATTEMPTS; attempt++) {\n try {\n const res = await fetch(STACK_API_URL, {\n method: \"POST\",\n headers: {\n \"content-type\": \"application/json\",\n \"x-stack-key\": STACK_API_SECRET,\n },\n body: JSON.stringify({\n channel: CHANNEL,\n action: \"초기화\",\n trigger: \"daily-reset\",\n }),\n signal: AbortSignal.timeout(REQUEST_TIMEOUT_MS),\n });\n const data = await res.json().catch(() => null);\n\n if (res.ok && data?.ok) {\n console.log(\n data.skipped ? \"매일 초기화 건너뜀:\" : \"매일 초기화 성공:\",\n data.message,\n );\n return;\n }\n\n console.error(\n `매일 초기화 실패 (${attempt}/${MAX_ATTEMPTS}):`,\n res.status,\n data,\n );\n // 인증·요청 오류(4xx)는 다시 시도해도 결과가 같으므로 바로 끝낸다.\n if (res.status >= 400 && res.status < 500) return;\n } catch (err) {\n console.error(\n `매일 초기화 요청 오류 (${attempt}/${MAX_ATTEMPTS}):`,\n String(err),\n );\n }\n\n if (attempt < MAX_ATTEMPTS) {\n await new Promise((resolve) => setTimeout(resolve, RETRY_DELAY_MS));\n }\n }\n}",[167],"pulls","branches",1,"forks","envVars",{"_183":185,"_186":61},"connections",{"_183":61,"_184":61},"count","unfilledCount",6,"emptyCount",{"_42":166,"_32":167,"_30":168,"_136":-5,"_40":41,"_39":169,"_138":57,"_37":205,"_13":171,"_33":172,"_35":173,"_23":24,"_143":-5,"_193":206,"_26":207},{"_42":157,"_32":158,"_30":159,"_136":-5,"_40":41,"_39":160,"_138":57,"_37":202,"_13":162,"_33":141,"_35":163,"_23":24,"_143":164,"_193":203,"_26":204},{"_42":149,"_32":150,"_30":55,"_136":-5,"_40":41,"_39":151,"_138":24,"_37":199,"_13":153,"_33":141,"_35":154,"_23":24,"_143":155,"_193":200,"_26":201},{"_42":146,"_32":27,"_30":31,"_136":-5,"_40":41,"_39":14,"_138":24,"_37":196,"_13":61,"_33":34,"_35":36,"_23":24,"_143":-5,"_193":197,"_26":198},{"_42":133,"_32":134,"_30":135,"_136":-5,"_40":41,"_39":137,"_138":57,"_37":192,"_13":140,"_33":141,"_35":142,"_23":24,"_143":144,"_193":194,"_26":195},["D",1788834627060],"children",[],[134],["D",1789140499494],[],[27],["D",1789139913888],[],[150],["D",1789044918857],[],[158],["D",1789109900008],[],[167],["D",1787817154621],["D",1789497078049],{"_98":97,"_106":102},{"_98":97,"_99":100,"_101":102,"_18":53,"_103":104,"_105":24},{"_13":87,"_32":88,"_42":41,"_89":43,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":44,"_96":97},"ctx",{"_80":-5,"_125":246,"_247":248,"_249":250,"_251":24,"_252":24,"_253":24,"_254":57,"_255":-5,"_256":-7,"_257":-7,"_258":61,"_259":24,"_260":24,"_261":-5,"_262":24,"_263":24,"_264":24,"_265":-5},"ENV",{"_217":218,"_219":220,"_221":88,"_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","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"]

🎬 ${escapeHtml(CHANNEL_NAME)}

Stack Monitoring · aguking-stack

Stack Admin · aguking-stack

Stack History · aguking-stack

엑셀 - ${escapeHtml(channel)}

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

Diff · v379