\n \n

Google Drive Sentinel

Vui lòng đăng nhập hệ thống

\n ${\n error\n ? `

Sai tài khoản hoặc mật khẩu

`\n : \"\"\n }\n \n

\n \n \n \n `);\n});\n\napp.post(\"/login\", async (c) => {\n const body = await c.req.parseBody();\n if (body.username === ADMIN_USER && body.password === ADMIN_PASS) {\n await ensureDB();\n const newSessionId = crypto.randomUUID();\n await sqlite.execute(\n \"INSERT INTO drive_admin_sessions (session_id) VALUES (?)\",\n [newSessionId],\n );\n setCookie(c, COOKIE_NAME, newSessionId, {\n path: \"/\",\n secure: true,\n httpOnly: true,\n maxAge: 60 * 60 * 24 * 7,\n sameSite: \"Lax\",\n });\n return c.redirect(\"/\");\n }\n return c.redirect(\"/login?error=1\");\n});\n\napp.get(\"/logout\", async (c) => {\n const currentSessionId = getCookie(c, COOKIE_NAME);\n if (currentSessionId) {\n await ensureDB();\n await sqlite.execute(\n \"DELETE FROM drive_admin_sessions WHERE session_id = ?\",\n [currentSessionId],\n );\n }\n deleteCookie(c, COOKIE_NAME, { path: \"/\" });\n return c.redirect(\"/login\");\n});\n\napp.post(\"/api/auth/logout-others\", async (c) => {\n const currentSessionId = c.get(\"sessionId\");\n if (currentSessionId) {\n await sqlite.execute(\n \"DELETE FROM drive_admin_sessions WHERE session_id != ?\",\n [currentSessionId],\n );\n return c.json({ success: true });\n }\n return c.json({ success: false, error: \"Không tìm thấy phiên\" });\n});\n\n// ====================================================================\n// 5. LOGIC HELPERS: GOOGLE DRIVE\n// ====================================================================\nfunction parseDriveLink(link) {\n let id = \"\";\n let kind = \"file\";\n if (!link) return { id: \"\", kind: \"file\" };\n if (!link.startsWith(\"http\")) return { id: link, kind: \"file\" };\n try {\n const url = new URL(link);\n if (url.pathname.includes(\"/folders/\")) {\n id = url.pathname.split(\"/folders/\")[1].split(/[\\/?]/)[0];\n kind = \"folder\";\n } else if (url.pathname.includes(\"/d/\")) {\n id = url.pathname.split(\"/d/\")[1].split(/[\\/?]/)[0];\n kind = \"file\";\n } else id = link;\n } catch (e) {\n id = link;\n }\n return { id, kind };\n}\n\nasync function checkSingleResource(row, fallbackGasUrl) {\n if (row.is_paused) {\n return {\n id: row.id,\n status: \"PAUSED\",\n type: row.resource_type,\n details: \"Đang ngừng theo dõi\",\n owner_email: row.owner_email,\n me_email: row.me_email,\n };\n }\n const workerUrl = row.gas_url || fallbackGasUrl;\n if (!workerUrl) {\n return {\n id: row.id,\n status: \"WARNING\",\n type: row.resource_type,\n details: \"Cần 1 GAS URL\",\n owner_email: row.owner_email,\n me_email: row.me_email,\n };\n }\n try {\n const response = await fetch(`${workerUrl}?id=${row.resource_id}`);\n const data = await response.json();\n let type = row.resource_type;\n let ownerEmail = data.debug_owner || row.owner_email;\n let meEmail = data.debug_me || row.me_email;\n if (data.status === \"OK\") {\n if (row.gas_url) type = data.type;\n else {\n if (type === \"Unknown\") type = \"Public\";\n meEmail = \"Public Check\";\n }\n }\n return {\n id: row.id,\n status: data.status,\n type: type,\n details: data.name,\n owner_email: ownerEmail,\n me_email: meEmail,\n };\n } catch (e) {\n return {\n id: row.id,\n status: \"ERROR\",\n type: row.resource_type,\n details: e.message,\n owner_email: row.owner_email,\n me_email: row.me_email,\n };\n }\n}\nasync function checkResource(row, fallbackGasUrl) {\n return await checkSingleResource(row, fallbackGasUrl);\n}\n\n// ====================================================================\n// 6. API ROUTES\n// ====================================================================\napp.get(\"/api/list\", async (c) => {\n const result = await sqlite.execute(\n \"SELECT * FROM drive_monitor_final ORDER BY sort_order ASC, created_at DESC\",\n );\n return c.json(result.rows);\n});\n\napp.post(\"/api/add\", async (c) => {\n const body = await c.req.json();\n const gasUrl = body.gas_url && body.gas_url.trim() !== \"\"\n ? body.gas_url\n : null;\n const { id, kind } = parseDriveLink(body.resource_link);\n const maxOrderRes = await sqlite.execute(\n \"SELECT MAX(sort_order) as max FROM drive_monitor_final\",\n );\n const nextOrder = (maxOrderRes.rows[0].max !== null)\n ? maxOrderRes.rows[0].max + 1\n : 0;\n await sqlite.execute(\n `INSERT INTO drive_monitor_final (name, resource_id, resource_link, gas_url, kind, status, resource_type, is_paused, sort_order, created_at) VALUES (?, ?, ?, ?, ?, ?, ?, 0, ?, datetime('now'))`,\n [\n body.name,\n id,\n body.resource_link,\n gasUrl,\n kind,\n \"PENDING\",\n \"Unknown\",\n nextOrder,\n ],\n );\n return c.json({ success: true });\n});\n\napp.post(\"/api/update\", async (c) => {\n const body = await c.req.json();\n const gasUrl = body.gas_url && body.gas_url.trim() !== \"\"\n ? body.gas_url\n : null;\n const { id, kind } = parseDriveLink(body.resource_link);\n await sqlite.execute(\n `UPDATE drive_monitor_final SET name = ?, resource_id = ?, resource_link = ?, gas_url = ?, kind = ? WHERE id = ?`,\n [body.name, id, body.resource_link, gasUrl, kind, body.id],\n );\n return c.json({ success: true });\n});\n\napp.post(\"/api/save-order\", async (c) => {\n const body = await c.req.json();\n for (let i = 0; i < body.order.length; i++) {\n await sqlite.execute(\n \"UPDATE drive_monitor_final SET sort_order = ? WHERE id = ?\",\n [i, body.order[i]],\n );\n }\n return c.json({ success: true });\n});\n\napp.post(\"/api/toggle-pause\", async (c) => {\n const body = await c.req.json();\n const cur = await sqlite.execute(\n \"SELECT is_paused FROM drive_monitor_final WHERE id = ?\",\n [body.id],\n );\n const newState = cur.rows[0].is_paused ? 0 : 1;\n const newStatus = newState ? \"PAUSED\" : \"PENDING\";\n await sqlite.execute(\n `UPDATE drive_monitor_final SET is_paused = ?, status = ? WHERE id = ?`,\n [newState, newStatus, body.id],\n );\n return c.json({ success: true });\n});\n\napp.post(\"/api/delete\", async (c) => {\n const body = await c.req.json();\n await sqlite.execute(`DELETE FROM drive_monitor_final WHERE id = ?`, [\n body.id,\n ]);\n return c.json({ success: true });\n});\n\napp.post(\"/api/check-all\", async (c) => {\n const result = await sqlite.execute(\"SELECT * FROM drive_monitor_final\");\n const rows = result.rows;\n const validRow = rows.find((r) => r.gas_url && r.gas_url.startsWith(\"http\"));\n const fallbackGasUrl = validRow ? validRow.gas_url : null;\n\n const checkPromises = rows.map((row) => checkResource(row, fallbackGasUrl));\n const results = await Promise.all(checkPromises);\n const currentErrors = [];\n const updates = [];\n for (const res of results) {\n await sqlite.execute(\n `UPDATE drive_monitor_final SET status = ?, resource_type = ?, details = ?, owner_email = ?, me_email = ?, last_check = datetime('now') WHERE id = ?`,\n [\n res.status,\n res.type,\n res.details,\n res.owner_email,\n res.me_email,\n res.id,\n ],\n );\n updates.push(res);\n if (res.status === \"ERROR\") currentErrors.push(res.id);\n }\n return c.json({ success: true, updates, current_errors: currentErrors });\n});\n\n// ====================================================================\n// 7. UI TEMPLATE & ROUTE\n// ====================================================================\napp.get(\"/\", (c) => {\n return c.html(`\n \n \n \n \n \n Google Drive Sentinel\n \n \n \n \n \n \n \n \n

\n Google Drive Sentinel\n

\n \n \n \n

\n\n \n\n \n\n \n \n \n `);\n});\n\nexport default function (req: Request): Response | Promise {\n return app.fetch(req);\n}","deleted",false,"label",[36],"a41e09c6-395f-11f1-bf50-42b51c65c3df","cron.ts","019c74d7-67e7-76b5-85ca-7404dd99f186",7,["D",1776321836307],"interval","import sqlite from \"https://esm.town/v/std/db/main.ts\";\n\n// --- CẤU HÌNH ---\nconst VAL_MAIN_API_URL = `${Deno.env.get(\"VAL_MAIN_API_URL\")}/api/check-all`;\nconst NTFY_TOPIC = Deno.env.get(\"NTFY_TOPIC\");\n\nexport default async function (interval: Interval) {\n console.log(\"🕒 Starting Google Drive Cron Check...\");\n\n // LẤY MẬT KHẨU TỪ ENVIRONMENT ĐỂ MỞ CỬA API\n const ADMIN_PASS = Deno.env.get(\"ADMIN_PASS\");\n\n // 1. Gọi API Check-All từ Val Chính CÓ KÈM AUTHORIZATION HEADER\n const response = await fetch(VAL_MAIN_API_URL, {\n method: \"POST\",\n headers: {\n \"Authorization\": `Bearer ${ADMIN_PASS}`, // <--- Điểm bảo vệ Cron\n },\n });\n\n if (!response.ok) {\n if (response.status === 401) {\n console.error(\n \"❌ Lỗi 401: Cron Job không được cấp quyền (Sai ADMIN_PASS). Hãy kiểm tra lại biến môi trường.\",\n );\n } else {\n console.error(\"❌ Failed to trigger check:\", response.statusText);\n }\n return;\n }\n\n const data = await response.json();\n const currentErrors = data.current_errors || [];\n\n // 2. Lấy danh sách lỗi cũ từ DB (Lưu tạm trong 1 bảng riêng cho Cron này)\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS cron_error_tracking (\n id INTEGER PRIMARY KEY,\n error_ids TEXT\n )\n `);\n\n const prevRes = await sqlite.execute(\n \"SELECT error_ids FROM cron_error_tracking WHERE id = 1\",\n );\n\n let previousErrors = [];\n if (prevRes.rows.length > 0) {\n previousErrors = JSON.parse(prevRes.rows[0].error_ids || \"[]\");\n } else {\n await sqlite.execute(\n \"INSERT INTO cron_error_tracking (id, error_ids) VALUES (1, '[]')\",\n );\n }\n\n // 3. So sánh: Tìm các lỗi MỚI xuất hiện\n const newErrors = currentErrors.filter((id) => !previousErrors.includes(id));\n\n // 4. Nếu có lỗi mới -> Gửi thông báo\n if (newErrors.length > 0) {\n console.log(\n `⚠️ Found ${newErrors.length} new errors. Sending notification...`,\n );\n\n await fetch(`https://ntfy.sh/${NTFY_TOPIC}`, {\n method: \"POST\",\n body:\n \"Cảnh báo: Phát hiện tài nguyên Google Drive bị lỗi. Kiểm tra ngay.\",\n headers: {\n \"Title\": \"Drive Sentinel Alert\", // ASCII chuẩn\n \"Priority\": \"high\",\n \"Tags\": \"warning,drive\",\n },\n });\n } else {\n console.log(\"✅ No new errors found.\");\n }\n\n // 5. Cập nhật lại danh sách lỗi hiện tại vào DB\n await sqlite.execute(\n \"UPDATE cron_error_tracking SET error_ids = ? WHERE id = 1\",\n [JSON.stringify(currentErrors)],\n );\n}",[58],{"_34":57,"_13":58,"_37":59,"_39":-5,"_40":41,"_42":60,"_44":45,"_46":71,"_17":43,"_49":62,"_51":63,"_53":54,"_55":-5,"_68":72,"_18":73},{"_34":35,"_13":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":67,"_17":48,"_49":50,"_51":52,"_53":54,"_55":-5,"_68":69,"_18":70},["D",1772188131488],"children",[],[36],["D",1776321836307],[],[58],"31c88722-0d66-11f1-bcf0-42dde27851f2",["D",1771486799815],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Guestbook","imageUrl","userId","019c7021-27a1-77a3-91ff-0bee8f142cc4","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019c7021-27a1-77a3-91ff-0ea08d94c033","tursoName","31c887220d6611f1bcf042dde27851f2","tursoHostname","31c887220d6611f1bcf042dde27851f2-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789527643940],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_132":128},"org",{"_11":12,"_125":126,"_127":128,"_84":85,"_129":130,"_131":54},"branch",{"_17":60,"_13":16,"_34":41,"_117":74,"_118":-5,"_119":-5,"_120":-5,"_121":-5,"_122":-5,"_123":14,"_124":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Varina Lab","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18zOXB6RWdqcFJZRGlHSkcxS2NYTXRjUUc3eTYifQ","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_34":74,"_13":14,"_46":171,"_76":-5,"_77":54,"_78":79,"_80":79,"_81":82,"_83":19,"_84":85,"_86":-5,"_87":54,"_88":-5,"_89":-5,"_90":91,"_92":93,"_94":95,"_96":97,"_98":172,"_100":-5,"_101":102,"_103":102,"_104":105,"_106":105,"_107":105,"_108":102,"_109":102,"_110":173,"_112":174,"_114":175,"_116":54},[165,166],"files",[165,166],"counts",{"_155":91,"_156":48,"_157":91,"_31":158,"_159":160},[151,152],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_34":57,"_13":58,"_37":59,"_39":-5,"_40":41,"_42":60,"_44":45,"_46":61,"_17":43,"_49":62,"_51":63,"_53":54,"_55":-5,"_18":154},{"_34":35,"_13":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":47,"_17":48,"_49":50,"_51":52,"_53":54,"_55":-5,"_18":153},[36],[58],"pulls","branches","forks",{"_161":163,"_164":91},"connections",{"_161":91,"_162":91},"count","unfilledCount",4,"emptyCount",{"_34":57,"_13":58,"_37":59,"_39":-5,"_40":41,"_42":60,"_44":45,"_46":71,"_17":43,"_49":62,"_51":63,"_53":54,"_55":-5,"_68":169,"_18":170},{"_34":35,"_13":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":67,"_17":48,"_49":50,"_51":52,"_53":54,"_55":-5,"_68":167,"_18":168},[],[36],[],[58],["D",1771486799815],["D",1789527643940],{"_11":12,"_132":128},{"_11":12,"_125":126,"_127":128,"_84":85,"_129":130,"_131":54},{"_17":60,"_13":16,"_34":41,"_117":74,"_118":-5,"_119":-5,"_120":-5,"_121":-5,"_122":-5,"_123":14,"_124":12},"ctx",{"_110":-5,"_148":209,"_210":211,"_212":213,"_214":54,"_215":54,"_216":54,"_217":45,"_218":-5,"_219":-7,"_220":-7,"_221":91,"_222":54,"_223":54,"_224":-5,"_225":54,"_226":54,"_227":54,"_228":-5},"ENV",{"_180":181,"_182":183,"_184":16,"_185":186,"_187":188,"_189":190,"_191":192,"_193":194,"_195":196,"_197":198,"_199":200,"_201":202,"_203":204,"_205":206,"_207":208},"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"]

Google Drive Sentinel

\n Google Drive Sentinel\n

Thêm tài nguyên

Resource Name

Code