[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_171":172,"_173":174},"routes/_app.x.$handle.$name",{"_104":103,"_32":50,"_113":94,"_27":60,"_13":14,"_114":-5,"_11":115,"_116":117,"_118":119,"_120":121,"_122":123,"_21":-5,"_124":-5,"_125":-5,"_126":25,"_127":128,"_129":130,"_131":-5,"_132":-5,"_133":134},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_48":49,"_32":50,"_37":51,"_52":-5,"_53":25,"_54":55,"_56":55,"_57":58,"_59":60,"_18":61,"_62":-5,"_63":25,"_64":-5,"_65":-5,"_66":67,"_68":69,"_70":71,"_72":73,"_74":75,"_76":-5,"_77":78,"_79":78,"_80":81,"_82":81,"_83":81,"_84":78,"_85":78,"_86":87,"_88":89,"_90":91,"_92":25},"version",1,"changes",[19,20],"aiChatInfo","userId",{"_21":42,"_23":-7,"_24":25,"_26":25,"_27":43,"_29":43},{"_21":22,"_23":-7,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_24":25},"previous","deleted",false,"deletedHere","path","main.tsx","latestPath","fileId","019c784e-8a1e-7323-9e6b-74685e7b2bb9","name","fileType","http","content","/** @jsxImportSource npm:hono/jsx */\nimport { Hono } from \"npm:hono\";\nimport { html } from \"npm:hono/html\";\nimport sqlite from \"https://esm.town/v/std/db/main.ts\";\n\nconst app = new Hono();\n\n// ====================================================================\n// CẤU HÌNH & HẰNG SỐ (Theme Microsoft Sharepoint)\n// ====================================================================\nconst FOLDER_SVG_PATH = ``;\nconst FAVICON_URL = `data:image/svg+xml,${encodeURIComponent(``)}`;\n\n// ====================================================================\n// DATABASE OPERATIONS\n// ====================================================================\nasync function initDB() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS sharepoint_monitor (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n resource_link TEXT NOT NULL,\n status TEXT DEFAULT 'PENDING',\n last_check DATETIME,\n details TEXT,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n is_paused BOOLEAN DEFAULT 0,\n sort_order INTEGER DEFAULT 0\n )\n `);\n}\n\n// ====================================================================\n// LOGIC HELPERS: KIỂM TRA LINK SHAREPOINT BẰNG GIẢ LẬP TRÌNH DUYỆT (COOKIE JAR)\n// ====================================================================\n\nasync function checkSingleSharepoint(row) {\n if (row.is_paused) {\n return { id: row.id, status: \"PAUSED\", details: \"Đang ngừng theo dõi\" };\n }\n\n if (!row.resource_link || !row.resource_link.startsWith(\"http\")) {\n return { id: row.id, status: \"WARNING\", details: \"Link không hợp lệ\" };\n }\n\n try {\n let currentUrl = row.resource_link;\n let cookies = []; // \"Giỏ\" đựng Cookie\n \n // Vòng lặp tối đa 7 lần để tự tay bám theo các lệnh redirect của Microsoft\n for (let i = 0; i < 7; i++) {\n const cookieHeader = cookies.join('; ');\n \n const response = await fetch(currentUrl, {\n method: 'GET',\n redirect: 'manual', // RẤT QUAN TRỌNG: Chặn chuyển hướng tự động để lấy Cookie\n headers: {\n 'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36',\n 'Accept': 'text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,*/*;q=0.8',\n 'Accept-Language': 'vi-VN,vi;q=0.9,en-US;q=0.8,en;q=0.7',\n // Nhét Cookie vào header nếu đã thu thập được ở vòng lặp trước\n ...(cookieHeader ? { 'Cookie': cookieHeader } : {})\n }\n });\n\n // 1. Nhặt Cookie mà SharePoint cấp phát (Guest Token, Session...)\n if (typeof response.headers.getSetCookie === 'function') {\n const newCookies = response.headers.getSetCookie();\n newCookies.forEach(c => {\n // Chỉ lấy phần 'Tên=Giá_trị' trước dấu chấm phẩy đầu tiên\n cookies.push(c.split(';')[0]);\n });\n } else {\n // Fallback\n const rawCookie = response.headers.get('set-cookie');\n if (rawCookie) cookies.push(rawCookie.split(';')[0]);\n }\n\n const status = response.status;\n\n // BẮT LỖI 429: QUÁ NHIỀU REQUEST (TÀI NGUYÊN VẪN SỐNG NHƯNG BỊ GIỚI HẠN)\n if (status === 429 || status === 503) {\n return { id: row.id, status: \"WARNING\", details: \"Bị giới hạn truy cập (HTTP 429) - Link vẫn sống\" };\n }\n\n // 2. Xử lý khi bị máy chủ yêu cầu chuyển hướng (Mã 301, 302, 303, 307)\n if (status >= 300 && status < 400) {\n\n const location = response.headers.get('location');\n if (!location) break;\n \n // Xử lý URL mới\n currentUrl = location.startsWith('http') ? location : new URL(location, currentUrl).href;\n const finalUrlLower = currentUrl.toLowerCase();\n \n // NẾU ĐÍCH ĐẾN LÀ TRANG LOGIN -> XÁC NHẬN MẤT QUYỀN\n if (finalUrlLower.includes('login.microsoftonline.com') || finalUrlLower.includes('accessdenied.aspx')) {\n return { id: row.id, status: \"ERROR\", details: \"Yêu cầu đăng nhập (Link bị khóa)\" };\n }\n \n // Trở lại đầu vòng lặp để đi tiếp tới trang mới cùng với Cookie đã lấy\n continue; \n }\n\n // 3. Đã đến được trang đích cuối cùng (200 OK)\n if (status === 200) {\n const htmlContent = await response.text();\n const lowerHtml = htmlContent.toLowerCase();\n\n // Quét mã HTML tìm các thông báo lỗi đặc trưng của SharePoint khi xóa quyền\n if (\n lowerHtml.includes(\"this link has been removed\") ||\n lowerHtml.includes(\"this link has expired\") ||\n lowerHtml.includes(\"item does not exist\") ||\n lowerHtml.includes(\"liên kết này đã bị xóa\") ||\n lowerHtml.includes(\"we're sorry, but\") ||\n lowerHtml.includes('id=\"loginheader\"') // Form login ẩn\n ) {\n return { id: row.id, status: \"ERROR\", details: \"Link đã hết hạn hoặc bị xóa\" };\n }\n\n // Vượt qua tất cả cửa ải -> Link Public CÒN SỐNG!\n return { id: row.id, status: \"OK\", details: \"Link đang hoạt động tốt\" };\n }\n\n return { id: row.id, status: \"ERROR\", details: `HTTP Lỗi: ${status}` };\n }\n\n return { id: row.id, status: \"ERROR\", details: \"Lỗi: Quá nhiều vòng chuyển hướng\" };\n\n } catch (e) {\n return { id: row.id, status: \"ERROR\", details: `Lỗi hệ thống: ${e.message}` };\n }\n}\n\n\n// ====================================================================\n// API ROUTES\n// ====================================================================\n\napp.get(\"/api/list\", async (c) => {\n await initDB();\n const result = await sqlite.execute(\"SELECT * FROM sharepoint_monitor ORDER BY sort_order ASC, created_at DESC\");\n return c.json(result.rows);\n});\n\napp.post(\"/api/add\", async (c) => {\n await initDB();\n const body = await c.req.json();\n const maxOrderRes = await sqlite.execute(\"SELECT MAX(sort_order) as max FROM sharepoint_monitor\");\n const nextOrder = (maxOrderRes.rows[0].max !== null) ? maxOrderRes.rows[0].max + 1 : 0;\n \n await sqlite.execute(\n `INSERT INTO sharepoint_monitor (name, resource_link, status, is_paused, sort_order, created_at) VALUES (?, ?, ?, 0, ?, datetime('now'))`,\n [body.name, body.resource_link, 'PENDING', nextOrder]\n );\n return c.json({ success: true });\n});\n\napp.post(\"/api/update\", async (c) => {\n const body = await c.req.json();\n await sqlite.execute(\n `UPDATE sharepoint_monitor SET name = ?, resource_link = ? WHERE id = ?`, \n [body.name, body.resource_link, 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 const ids = body.order;\n for (let i = 0; i < ids.length; i++) { \n await sqlite.execute(\"UPDATE sharepoint_monitor SET sort_order = ? WHERE id = ?\", [i, ids[i]]); \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(\"SELECT is_paused FROM sharepoint_monitor WHERE id = ?\", [body.id]);\n const newState = cur.rows[0].is_paused ? 0 : 1;\n const newStatus = newState ? \"PAUSED\" : \"PENDING\"; \n await sqlite.execute(`UPDATE sharepoint_monitor SET is_paused = ?, status = ? WHERE id = ?`, [newState, newStatus, body.id]);\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 sharepoint_monitor WHERE id = ?`, [body.id]);\n return c.json({ success: true });\n});\n\napp.post(\"/api/check-all\", async (c) => {\n const result = await sqlite.execute(\"SELECT * FROM sharepoint_monitor\");\n \n const currentErrors = [];\n const updates = [];\n\n // THAY ĐỔI: Chạy tuần tự (vòng lặp for...of) thay vì Promise.all\n // Để tránh bị Microsoft block vì gửi quá nhiều request cùng lúc (Lỗi 429)\n for (const row of result.rows) {\n const res = await checkSingleSharepoint(row);\n \n await sqlite.execute(\n `UPDATE sharepoint_monitor SET status = ?, details = ?, last_check = datetime('now') WHERE id = ?`,\n [res.status, res.details, res.id]\n );\n \n updates.push(res);\n if (res.status === 'ERROR') {\n currentErrors.push(res.id); // Chỉ thẻ ERROR mới đưa vào danh sách báo động\n }\n \n // Nghỉ 800ms giữa mỗi link để Microsoft không tưởng ta là Bot Spam\n await new Promise(resolve => setTimeout(resolve, 800));\n }\n \n return c.json({ success: true, updates, current_errors: currentErrors });\n});\n\n// ====================================================================\n// UI TEMPLATE & ROUTE\n// ====================================================================\napp.get(\"/\", (c) => {\n return c.html(`\n \n \n \n \n \n SharePoint Sentinel\n \n \n \n \n \n \n \n \n

\n \n \n

\n SharePoint Sentinel\n

\n \n \n

\n \n

\n\n \n

\n\n \n \n\n \n \n\n \n \n \n \n `);\n});\n\nexport default app.fetch;","createdAt",["D",1771544938953],"branchVersion","branchId","8f7384da-0ded-11f1-9968-42dde27851f2",{"_30":44,"_32":43,"_33":45,"_35":46,"_37":47,"_39":14,"_40":41,"_24":25},"cron.ts","019c784e-8a1e-7323-9e6b-710a5e365db9","interval","import sqlite from \"https://esm.town/v/std/db/main.ts\";\n\n// --- CẤU HÌNH ---\n// 1. URL của Val Sharepoint Sentinel chính (Nhớ thêm /api/check-all)\n// ĐỔI DÒNG NÀY THÀNH URL VAL CHÍNH CỦA BẠN\nconst VAL_MAIN_API_URL = \"https://nemofb--019c74e322f2710e8ddbbe001f0ce128.web.val.run/api/check-all\";\n\n// 2. Kênh thông báo ntfy\nconst NTFY_TOPIC = \"varina_thong-bao\";\n\nexport default async function (interval: Interval) {\n console.log(\"🕒 Starting SharePoint Cron Check...\");\n\n // 1. Gọi API Check-All từ Val Chính\n const response = await fetch(VAL_MAIN_API_URL, { method: \"POST\" });\n \n if (!response.ok) {\n console.error(\"❌ Failed to trigger check:\", response.statusText);\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 // Đã đổi tên bảng thành cron_sharepoint_error để không đụng với bản Google Drive\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS cron_sharepoint_error (\n id INTEGER PRIMARY KEY,\n error_ids TEXT -- Lưu JSON array các ID bị lỗi\n )\n `);\n\n const prevRes = await sqlite.execute(\n \"SELECT error_ids FROM cron_sharepoint_error 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 // Lần đầu chạy -> Insert\n await sqlite.execute(\n \"INSERT INTO cron_sharepoint_error (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 (Có trong Current nhưng không có trong Previous)\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 SharePoint 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 SharePoint/OneDrive bị lỗi hoặc mất quyền truy cập. Kiểm tra ngay.\",\n headers: {\n \"Title\": \"SharePoint Sentinel Alert\",\n \"Priority\": \"high\",\n \"Tags\": \"warning,cloud\",\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_sharepoint_error SET error_ids = ? WHERE id = 1\",\n [JSON.stringify(currentErrors)],\n );\n}",["D",1771544938953],"id","8f6e3188-0ded-11f1-9968-42dde27851f2","SharePoint_Sentinel",["D",1771544938953],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Guestbook","imageUrl","","019c7021-27a1-77a3-91ff-0bee8f142cc4","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019c7021-27a1-77a3-91ff-0ea08d94c033","tursoName","8f6e31880ded11f1996842dde27851f2","tursoHostname","8f6e31880ded11f1996842dde27851f2-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789529498250],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_104":103,"_112":108},"org",{"_104":103,"_105":106,"_107":108,"_18":61,"_109":110,"_111":25},"branch",{"_13":93,"_32":94,"_48":41,"_95":49,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":50,"_102":103},"isOwned",6,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","varina_lab","handle","displayName","Varina Lab","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18zOXB6RWdqcFJZRGlHSkcxS2NYTXRjUUc3eTYifQ","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_48":49,"_32":50,"_37":166,"_52":-5,"_53":25,"_54":55,"_56":55,"_57":58,"_59":60,"_18":61,"_62":-5,"_63":25,"_64":-5,"_65":-5,"_66":67,"_68":69,"_70":71,"_72":73,"_74":167,"_76":-5,"_77":78,"_79":78,"_80":81,"_82":81,"_83":81,"_84":78,"_85":78,"_86":168,"_88":169,"_90":170,"_92":25},"tree",[157,158],"files",[157,158],"counts",{"_146":67,"_147":14,"_148":67,"_149":150,"_151":152},"contents",[135,136],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_48":143,"_32":43,"_30":44,"_138":-5,"_40":41,"_39":14,"_139":25,"_37":144,"_13":67,"_33":45,"_35":46,"_24":25,"_141":-5,"_27":145},{"_48":137,"_32":28,"_30":31,"_138":-5,"_40":41,"_39":14,"_139":25,"_37":140,"_13":67,"_33":34,"_35":36,"_24":25,"_141":-5,"_27":142},"8f76c9ce-0ded-11f1-9968-42dde27851f2","parentId","latest",["D",1771544938953],"label",[28],"8f76931e-0ded-11f1-9968-42dde27851f2",["D",1771544938953],[43],"pulls","branches","forks","envVars",{"_153":155,"_156":67},"connections",{"_153":67,"_154":67},"count","unfilledCount",4,"emptyCount",{"_48":143,"_32":43,"_30":44,"_138":-5,"_40":41,"_39":14,"_139":25,"_37":163,"_13":67,"_33":45,"_35":46,"_24":25,"_141":-5,"_160":164,"_27":165},{"_48":137,"_32":28,"_30":31,"_138":-5,"_40":41,"_39":14,"_139":25,"_37":159,"_13":67,"_33":34,"_35":36,"_24":25,"_141":-5,"_160":161,"_27":162},["D",1771544938953],"children",[],[28],["D",1771544938953],[],[43],["D",1771544938953],["D",1789529498250],{"_104":103,"_112":108},{"_104":103,"_105":106,"_107":108,"_18":61,"_109":110,"_111":25},{"_13":93,"_32":94,"_48":41,"_95":49,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":50,"_102":103},"ctx",{"_86":-5,"_132":204,"_205":206,"_207":208,"_209":25,"_210":25,"_211":25,"_212":130,"_213":-5,"_214":-7,"_215":-7,"_216":67,"_217":25,"_218":25,"_219":-5,"_220":25,"_221":25,"_222":25,"_223":-5},"ENV",{"_175":176,"_177":178,"_179":94,"_180":181,"_182":183,"_184":185,"_186":187,"_188":189,"_190":191,"_192":193,"_194":195,"_196":197,"_198":199,"_200":201,"_202":203},"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"]

\n SharePoint Sentinel\n

Thêm tài nguyên SharePoint

Resource Name

Diff · v1