\n \n

SharePoint 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 sharepoint_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 sharepoint_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 sharepoint_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: KIỂM TRA LINK SHAREPOINT (Giữ nguyên gốc)\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 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 = [];\n\n for (let i = 0; i < 7; i++) {\n const cookieHeader = cookies.join(\"; \");\n const response = await fetch(currentUrl, {\n method: \"GET\",\n redirect: \"manual\",\n headers: {\n \"User-Agent\":\n \"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\":\n \"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 ...(cookieHeader ? { \"Cookie\": cookieHeader } : {}),\n },\n });\n\n if (typeof response.headers.getSetCookie === \"function\") {\n const newCookies = response.headers.getSetCookie();\n newCookies.forEach((c) => cookies.push(c.split(\";\")[0]));\n } else {\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 if (status === 429 || status === 503) {\n return {\n id: row.id,\n status: \"WARNING\",\n details: \"Bị giới hạn truy cập (HTTP 429) - Link vẫn sống\",\n };\n }\n\n if (status >= 300 && status < 400) {\n const location = response.headers.get(\"location\");\n if (!location) break;\n\n currentUrl = location.startsWith(\"http\")\n ? location\n : new URL(location, currentUrl).href;\n const finalUrlLower = currentUrl.toLowerCase();\n\n if (\n finalUrlLower.includes(\"login.microsoftonline.com\") ||\n finalUrlLower.includes(\"accessdenied.aspx\")\n ) {\n return {\n id: row.id,\n status: \"ERROR\",\n details: \"Yêu cầu đăng nhập (Link bị khóa)\",\n };\n }\n continue;\n }\n\n if (status === 200) {\n const htmlContent = await response.text();\n const lowerHtml = htmlContent.toLowerCase();\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\"')\n ) {\n return {\n id: row.id,\n status: \"ERROR\",\n details: \"Link đã hết hạn hoặc bị xóa\",\n };\n }\n return { id: row.id, status: \"OK\", details: \"Link đang hoạt động tốt\" };\n }\n return { id: row.id, status: \"ERROR\", details: `HTTP Lỗi: ${status}` };\n }\n return {\n id: row.id,\n status: \"ERROR\",\n details: \"Lỗi: Quá nhiều vòng chuyển hướng\",\n };\n } catch (e) {\n return {\n id: row.id,\n status: \"ERROR\",\n details: `Lỗi hệ thống: ${e.message}`,\n };\n }\n}\n\n// ====================================================================\n// 6. API ROUTES\n// ====================================================================\napp.get(\"/api/list\", async (c) => {\n const result = await sqlite.execute(\n \"SELECT * FROM sharepoint_monitor 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 maxOrderRes = await sqlite.execute(\n \"SELECT MAX(sort_order) as max FROM sharepoint_monitor\",\n );\n const nextOrder = (maxOrderRes.rows[0].max !== null)\n ? maxOrderRes.rows[0].max + 1\n : 0;\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 for (let i = 0; i < body.order.length; i++) {\n await sqlite.execute(\n \"UPDATE sharepoint_monitor 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 sharepoint_monitor 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 sharepoint_monitor 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 sharepoint_monitor 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 sharepoint_monitor\");\n const currentErrors = [];\n const updates = [];\n\n for (const row of result.rows) {\n const res = await checkSingleSharepoint(row);\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 updates.push(res);\n if (res.status === \"ERROR\") currentErrors.push(res.id);\n await new Promise((resolve) => setTimeout(resolve, 800));\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 SharePoint Sentinel\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\nexport default function (req: Request): Response | Promise {\n return app.fetch(req);\n}","deleted",false,"label",[36],"f6491588-395f-11f1-a880-42b51c65c3df","cron.ts","019c784e-8a1e-7323-9e6b-710a5e365db9",6,["D",1776321974166],"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 SharePoint 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 MẬT\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_sharepoint_error (\n id INTEGER PRIMARY KEY,\n error_ids TEXT\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\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\", // ASCII chuẩn\n \"Priority\": \"high\",\n \"Tags\": \"warning\",\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}",[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",1772187667109],"children",[],[36],["D",1776321974166],[],[58],"8f6e3188-0ded-11f1-9968-42dde27851f2",["D",1771544938953],"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","8f6e31880ded11f1996842dde27851f2","tursoHostname","8f6e31880ded11f1996842dde27851f2-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789442454549],"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":170,"_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":171,"_100":-5,"_101":102,"_103":102,"_104":105,"_106":105,"_107":105,"_108":102,"_109":102,"_110":172,"_112":173,"_114":174,"_116":54},[164,165],"files",[164,165],"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":43,"_163":91},"connections",{"_161":91,"_162":91},"count","unfilledCount","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":168,"_18":169},{"_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":166,"_18":167},[],[36],[],[58],["D",1771544938953],["D",1789442454549],{"_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":208,"_209":210,"_211":212,"_213":54,"_214":54,"_215":54,"_216":45,"_217":-5,"_218":-7,"_219":-7,"_220":91,"_221":54,"_222":54,"_223":-5,"_224":54,"_225":54,"_226":54,"_227":-5},"ENV",{"_179":180,"_181":182,"_183":16,"_184":185,"_186":187,"_188":189,"_190":191,"_192":193,"_194":195,"_196":197,"_198":199,"_200":201,"_202":203,"_204":205,"_206":207},"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"]

SharePoint Sentinel

\n SharePoint Sentinel\n

Thêm tài nguyên SharePoint

Resource Name

Code