[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_179":180,"_181":182},"routes/_app.x.$handle.$name",{"_94":93,"_32":45,"_102":84,"_27":103,"_13":14,"_104":-5,"_11":105,"_106":107,"_108":109,"_110":111,"_112":113,"_20":-5,"_114":-5,"_115":-5,"_116":25,"_117":118,"_119":25,"_120":-5,"_121":-5,"_122":123},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":-5,"_56":25,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":77,"_78":79,"_80":81,"_82":25},"version",17,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","fenerbahceStandingsSync.ts","latestPath","fileId","3aee370e-ff95-11f0-850d-42dde27851f2","name","fileType","interval","content","// Val Town: fenerbahceStandingsSync\n// Type: Cron\n// Schedule: 0 */6 * * * (every 6 hours) or 0 8 * * * (daily at 8am)\n// Description: Scrapes TFF Super Lig standings and updates Firebase\n\n// ============ FIREBASE AUTH ============\n\nasync function getFirebaseAccessToken(): Promise {\n const clientEmail = Deno.env.get(\"FIREBASE_CLIENT_EMAIL\")!;\n const privateKey = Deno.env.get(\"FIREBASE_PRIVATE_KEY\")!.replace(\n /\\\\n/g,\n \"\\n\",\n );\n\n const header = { alg: \"RS256\", typ: \"JWT\" };\n const now = Math.floor(Date.now() / 1000);\n const claim = {\n iss: clientEmail,\n scope: \"https://www.googleapis.com/auth/datastore\",\n aud: \"https://oauth2.googleapis.com/token\",\n exp: now + 3600,\n iat: now,\n };\n\n const base64url = (data: Uint8Array | string): string => {\n const str = typeof data === \"string\" ? data : String.fromCharCode(...data);\n return btoa(str).replace(/\\+/g, \"-\").replace(/\\//g, \"_\").replace(/=+$/, \"\");\n };\n\n const headerB64 = base64url(JSON.stringify(header));\n const claimB64 = base64url(JSON.stringify(claim));\n const unsignedToken = `${headerB64}.${claimB64}`;\n\n const pemContents = privateKey\n .replace(\"-----BEGIN PRIVATE KEY-----\", \"\")\n .replace(\"-----END PRIVATE KEY-----\", \"\")\n .replace(/\\s/g, \"\");\n\n const binaryKey = Uint8Array.from(atob(pemContents), (c) => c.charCodeAt(0));\n\n const cryptoKey = await crypto.subtle.importKey(\n \"pkcs8\",\n binaryKey,\n { name: \"RSASSA-PKCS1-v1_5\", hash: \"SHA-256\" },\n false,\n [\"sign\"],\n );\n\n const signature = await crypto.subtle.sign(\n \"RSASSA-PKCS1-v1_5\",\n cryptoKey,\n new TextEncoder().encode(unsignedToken),\n );\n\n const signatureB64 = base64url(new Uint8Array(signature));\n const jwt = `${unsignedToken}.${signatureB64}`;\n\n const tokenResponse = await fetch(\"https://oauth2.googleapis.com/token\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/x-www-form-urlencoded\" },\n body:\n `grant_type=urn:ietf:params:oauth:grant-type:jwt-bearer&assertion=${jwt}`,\n });\n\n const tokenData = await tokenResponse.json();\n if (!tokenData.access_token) {\n throw new Error(`Failed to get access token: ${JSON.stringify(tokenData)}`);\n }\n\n return tokenData.access_token;\n}\n\n// ============ TEAM LOGO URLS ============\n\nconst teamLogos: Record = {\n \"galatasaray\":\n \"https://upload.wikimedia.org/wikipedia/commons/thumb/f/f6/Galatasaray_Sports_Club_Logo.png/200px-Galatasaray_Sports_Club_Logo.png\",\n \"fenerbahce\":\n \"https://upload.wikimedia.org/wikipedia/en/thumb/8/86/Fenerbahce_SK.svg/200px-Fenerbahce_SK.svg.png\",\n \"fenerbahçe\":\n \"https://upload.wikimedia.org/wikipedia/en/thumb/8/86/Fenerbahce_SK.svg/200px-Fenerbahce_SK.svg.png\",\n \"trabzonspor\":\n \"https://upload.wikimedia.org/wikipedia/en/thumb/1/1f/Trabzonspor.svg/200px-Trabzonspor.svg.png\",\n \"besiktas\":\n \"https://upload.wikimedia.org/wikipedia/commons/thumb/5/52/Be%C5%9Fikta%C5%9F_Logo_Be%C5%9Fikta%C5%9F_Amblem_Be%C5%9Fikta%C5%9F_Arma.png/200px-Be%C5%9Fikta%C5%9F_Logo_Be%C5%9Fikta%C5%9F_Amblem_Be%C5%9Fikta%C5%9F_Arma.png\",\n \"beşiktaş\":\n \"https://upload.wikimedia.org/wikipedia/commons/thumb/5/52/Be%C5%9Fikta%C5%9F_Logo_Be%C5%9Fikta%C5%9F_Amblem_Be%C5%9Fikta%C5%9F_Arma.png/200px-Be%C5%9Fikta%C5%9F_Logo_Be%C5%9Fikta%C5%9F_Amblem_Be%C5%9Fikta%C5%9F_Arma.png\",\n \"goztepe\":\n \"https://upload.wikimedia.org/wikipedia/en/thumb/c/c8/G%C3%B6ztepe_SK.svg/200px-G%C3%B6ztepe_SK.svg.png\",\n \"göztepe\":\n \"https://upload.wikimedia.org/wikipedia/en/thumb/c/c8/G%C3%B6ztepe_SK.svg/200px-G%C3%B6ztepe_SK.svg.png\",\n \"basaksehir\":\n \"https://upload.wikimedia.org/wikipedia/en/thumb/5/56/Istanbul_Ba%C5%9Fak%C5%9Fehir_FK.svg/200px-Istanbul_Ba%C5%9Fak%C5%9Fehir_FK.svg.png\",\n \"başakşehir\":\n \"https://upload.wikimedia.org/wikipedia/en/thumb/5/56/Istanbul_Ba%C5%9Fak%C5%9Fehir_FK.svg/200px-Istanbul_Ba%C5%9Fak%C5%9Fehir_FK.svg.png\",\n \"samsunspor\":\n \"https://upload.wikimedia.org/wikipedia/en/thumb/0/0c/Samsunspor_logo.svg/200px-Samsunspor_logo.svg.png\",\n \"gaziantep\":\n \"https://upload.wikimedia.org/wikipedia/en/thumb/9/9e/Gaziantep_FK_logo.svg/200px-Gaziantep_FK_logo.svg.png\",\n \"kocaelispor\":\n \"https://upload.wikimedia.org/wikipedia/en/thumb/e/e3/Kocaelispor.svg/200px-Kocaelispor.svg.png\",\n \"alanyaspor\":\n \"https://upload.wikimedia.org/wikipedia/en/thumb/2/24/Alanyaspor.svg/200px-Alanyaspor.svg.png\",\n \"genclerbirligi\":\n \"https://upload.wikimedia.org/wikipedia/en/thumb/a/a2/Gen%C3%A7lerbirli%C4%9Fi_SK_logo.svg/200px-Gen%C3%A7lerbirli%C4%9Fi_SK_logo.svg.png\",\n \"gençlerbirliği\":\n \"https://upload.wikimedia.org/wikipedia/en/thumb/a/a2/Gen%C3%A7lerbirli%C4%9Fi_SK_logo.svg/200px-Gen%C3%A7lerbirli%C4%9Fi_SK_logo.svg.png\",\n \"rizespor\":\n \"https://upload.wikimedia.org/wikipedia/en/thumb/4/43/%C3%87aykur_Rizespor.svg/200px-%C3%87aykur_Rizespor.svg.png\",\n \"çaykur rizespor\":\n \"https://upload.wikimedia.org/wikipedia/en/thumb/4/43/%C3%87aykur_Rizespor.svg/200px-%C3%87aykur_Rizespor.svg.png\",\n \"antalyaspor\":\n \"https://upload.wikimedia.org/wikipedia/en/thumb/d/d9/Antalyaspor_logo.svg/200px-Antalyaspor_logo.svg.png\",\n \"konyaspor\":\n \"https://upload.wikimedia.org/wikipedia/en/thumb/4/44/Konyaspor_logo.svg/200px-Konyaspor_logo.svg.png\",\n \"eyupspor\":\n \"https://upload.wikimedia.org/wikipedia/en/thumb/4/44/Ey%C3%BCpspor.svg/200px-Ey%C3%BCpspor.svg.png\",\n \"eyüpspor\":\n \"https://upload.wikimedia.org/wikipedia/en/thumb/4/44/Ey%C3%BCpspor.svg/200px-Ey%C3%BCpspor.svg.png\",\n \"kasimpasa\":\n \"https://upload.wikimedia.org/wikipedia/en/thumb/e/e3/Kasimpasa_SK.svg/200px-Kasimpasa_SK.svg.png\",\n \"kasımpaşa\":\n \"https://upload.wikimedia.org/wikipedia/en/thumb/e/e3/Kasimpasa_SK.svg/200px-Kasimpasa_SK.svg.png\",\n \"kayserispor\":\n \"https://upload.wikimedia.org/wikipedia/en/thumb/f/f3/Kayserispor_logo.svg/200px-Kayserispor_logo.svg.png\",\n \"fatih karagumruk\":\n \"https://upload.wikimedia.org/wikipedia/en/thumb/3/30/Fatih_Karag%C3%BCmr%C3%BCk_S.K..svg/200px-Fatih_Karag%C3%BCmr%C3%BCk_S.K..svg.png\",\n \"karagümrük\":\n \"https://upload.wikimedia.org/wikipedia/en/thumb/3/30/Fatih_Karag%C3%BCmr%C3%BCk_S.K..svg/200px-Fatih_Karag%C3%BCmr%C3%BCk_S.K..svg.png\",\n};\n\nfunction getTeamLogo(teamName: string): string {\n const normalized = teamName.toLowerCase()\n .replace(/a\\.ş\\./gi, \"\")\n .replace(/a\\.s\\./gi, \"\")\n .replace(/\\d+\\./g, \"\")\n .replace(/corendon/gi, \"\")\n .replace(/hesap\\.com/gi, \"\")\n .replace(/tümosan/gi, \"\")\n .replace(/ikas/gi, \"\")\n .replace(/zecorner/gi, \"\")\n .replace(/mısırlı\\.com\\.tr/gi, \"\")\n .replace(/rams/gi, \"\")\n .replace(/futbol kulübü/gi, \"\")\n .trim();\n\n for (const [key, url] of Object.entries(teamLogos)) {\n if (normalized.includes(key)) {\n return url;\n }\n }\n\n return \"https://upload.wikimedia.org/wikipedia/commons/thumb/a/a0/Football_-_The_Noun_Project.svg/200px-Football_-_The_Noun_Project.svg.png\";\n}\n\nfunction isFenerbahce(teamName: string): boolean {\n const lower = teamName.toLowerCase();\n return lower.includes(\"fenerbah\");\n}\n\n// ============ SCRAPER ============\n\ninterface StandingEntry {\n position: number;\n teamName: string;\n teamLogoUrl: string;\n matchesPlayed: number;\n wins: number;\n draws: number;\n losses: number;\n goalsFor: number;\n goalsAgainst: number;\n goalDifference: number;\n points: number;\n isFenerbahce: boolean;\n}\n\nasync function scrapeStandings(): Promise {\n console.log(\"Fetching TFF standings page...\");\n\n const response = await fetch(\"https://www.tff.org/default.aspx?pageID=198\", {\n headers: {\n \"User-Agent\":\n \"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36\",\n \"Accept\":\n \"text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8\",\n \"Accept-Language\": \"tr-TR,tr;q=0.9,en-US;q=0.8,en;q=0.7\",\n },\n });\n\n if (!response.ok) {\n throw new Error(`Failed to fetch TFF page: ${response.status}`);\n }\n\n const html = await response.text();\n console.log(`Fetched ${html.length} bytes of HTML`);\n\n const standings: StandingEntry[] = [];\n\n // Pattern: \"1.GALATASARAY A.Ş.\" followed by numbers\n // Format: position.TEAM NAME ... O G B M A Y AV P\n // Example: 1.GALATASARAY A.Ş. ... 19 14 4 1 43 14 29 46\n\n // Match team entries with pattern: number.TEAM NAME followed by 8 numbers\n const teamRowRegex =\n /(\\d+)\\.([\\wÇĞİÖŞÜçğıöşü\\s\\.]+(?:A\\.Ş\\.|SPOR|SK|FK)?)<\\/a>[\\s\\S]*?]*>\\s*(\\d+)\\s*<\\/td>\\s*]*>\\s*(\\d+)\\s*<\\/td>\\s*]*>\\s*(\\d+)\\s*<\\/td>\\s*]*>\\s*(\\d+)\\s*<\\/td>\\s*]*>\\s*(\\d+)\\s*<\\/td>\\s*]*>\\s*(\\d+)\\s*<\\/td>\\s*]*>\\s*(-?\\d+)\\s*<\\/td>\\s*]*>[\\s\\S]*?(\\d+)/gi;\n\n let match;\n while ((match = teamRowRegex.exec(html)) !== null) {\n const [\n ,\n pos,\n name,\n played,\n wins,\n draws,\n losses,\n goalsFor,\n goalsAgainst,\n goalDiff,\n points,\n ] = match;\n\n const teamName = name.trim();\n const entry: StandingEntry = {\n position: parseInt(pos),\n teamName,\n teamLogoUrl: getTeamLogo(teamName),\n matchesPlayed: parseInt(played),\n wins: parseInt(wins),\n draws: parseInt(draws),\n losses: parseInt(losses),\n goalsFor: parseInt(goalsFor),\n goalsAgainst: parseInt(goalsAgainst),\n goalDifference: parseInt(goalDiff),\n points: parseInt(points),\n isFenerbahce: isFenerbahce(teamName),\n };\n\n standings.push(entry);\n console.log(` ${entry.position}. ${entry.teamName} - ${entry.points} pts`);\n }\n\n // If first regex didn't work, try simpler pattern\n if (standings.length < 5) {\n console.log(\"Trying simpler pattern...\");\n\n // Look for patterns like: >1.GALATASARAY A.Ş.<\n const simpleTeamRegex =\n />(\\d+)\\.([\\wÇĞİÖŞÜçğıöşü\\s\\.\\-]+(?:A\\.Ş\\.|SPOR|SK|FK|KULÜBÜ)?) 3 &&\n (name.includes(\"SPOR\") || name.includes(\"A.Ş.\") ||\n name.includes(\"SK\") || name.includes(\"FK\") ||\n /[A-ZÇĞİÖŞÜ]{3,}/.test(name))\n ) {\n // Avoid duplicates\n if (!teams.find((t) => t.pos === pos)) {\n teams.push({ pos, name });\n }\n }\n }\n\n console.log(`Found ${teams.length} teams with simple pattern`);\n\n // Now find numbers after each team\n for (const team of teams) {\n // Find the row containing this team and extract numbers\n const teamEscaped = team.name.replace(/[.*+?^${}()|[\\]\\\\]/g, \"\\\\$&\");\n const rowRegex = new RegExp(\n `${team.pos}\\\\.${teamEscaped}[\\\\s\\\\S]*?<\\\\/tr>`,\n \"i\",\n );\n const rowMatch = html.match(rowRegex);\n\n if (rowMatch) {\n // Extract all numbers from this row\n const numbers = rowMatch[0].match(/>(\\d+)\n parseInt(n.replace(/[><]/g, \"\"))\n ) || [];\n const boldNumber = rowMatch[0].match(/(\\d+)<\\/b>/);\n\n // We expect: O(played), G(wins), B(draws), M(losses), A(for), Y(against), AV(diff), P(points)\n if (numbers.length >= 7) {\n const entry: StandingEntry = {\n position: team.pos,\n teamName: team.name,\n teamLogoUrl: getTeamLogo(team.name),\n matchesPlayed: numbers[0],\n wins: numbers[1],\n draws: numbers[2],\n losses: numbers[3],\n goalsFor: numbers[4],\n goalsAgainst: numbers[5],\n goalDifference: numbers[6] < 50\n ? numbers[6]\n : (numbers[4] - numbers[5]), // AV might be negative or calculated\n points: boldNumber\n ? parseInt(boldNumber[1])\n : numbers[numbers.length - 1],\n isFenerbahce: isFenerbahce(team.name),\n };\n\n standings.push(entry);\n console.log(\n ` ${entry.position}. ${entry.teamName} - ${entry.points} pts`,\n );\n }\n }\n }\n }\n\n // Third attempt: manual extraction based on known structure\n if (standings.length < 5) {\n console.log(\"Trying manual extraction...\");\n\n // The TFF page has teams in format: 1.GALATASARAY A.Ş.\n // followed by table cells with numbers\n\n const allTeamMatches = [\n ...html.matchAll(/]*>(\\d+)\\.([\\wÇĞİÖŞÜçğıöşü\\s\\.\\-']+)<\\/a>/gi),\n ];\n console.log(`Found ${allTeamMatches.length} potential team links`);\n\n for (const teamMatch of allTeamMatches) {\n const pos = parseInt(teamMatch[1]);\n const name = teamMatch[2].trim();\n\n // Skip if already have this position or name doesn't look like a team\n if (standings.find((s) => s.position === pos)) continue;\n if (name.length < 3) continue;\n\n // Find position of this match in HTML\n const startIdx = teamMatch.index! + teamMatch[0].length;\n // Look for the next 500 characters to find numbers\n const searchArea = html.substring(startIdx, startIdx + 1000);\n\n // Extract numbers from td elements\n const tdNumbers = [\n ...searchArea.matchAll(/]*>\\s*(-?\\d+)\\s*<\\/td>/gi),\n ].map((m) => parseInt(m[1]));\n const boldPoints = searchArea.match(/(\\d+)<\\/b>/);\n\n if (tdNumbers.length >= 7) {\n const entry: StandingEntry = {\n position: pos,\n teamName: name,\n teamLogoUrl: getTeamLogo(name),\n matchesPlayed: tdNumbers[0],\n wins: tdNumbers[1],\n draws: tdNumbers[2],\n losses: tdNumbers[3],\n goalsFor: tdNumbers[4],\n goalsAgainst: tdNumbers[5],\n goalDifference: tdNumbers[6],\n points: boldPoints\n ? parseInt(boldPoints[1])\n : tdNumbers[7] || tdNumbers[tdNumbers.length - 1],\n isFenerbahce: isFenerbahce(name),\n };\n\n standings.push(entry);\n console.log(\n ` ${entry.position}. ${entry.teamName} - ${entry.points} pts`,\n );\n }\n }\n }\n\n // Sort by position\n standings.sort((a, b) => a.position - b.position);\n\n return standings;\n}\n\n// ============ FIREBASE UPDATE ============\n\nasync function updateStandingsInFirebase(\n accessToken: string,\n standings: StandingEntry[],\n): Promise {\n const projectId = Deno.env.get(\"FIREBASE_PROJECT_ID\")!;\n const docId = \"football_men_2024_2025\";\n const now = new Date().toISOString();\n\n const standingsArray = standings.map((s) => ({\n mapValue: {\n fields: {\n position: { integerValue: String(s.position) },\n teamName: { stringValue: s.teamName },\n teamLogoUrl: { stringValue: s.teamLogoUrl },\n matchesPlayed: { integerValue: String(s.matchesPlayed) },\n wins: { integerValue: String(s.wins) },\n draws: { integerValue: String(s.draws) },\n losses: { integerValue: String(s.losses) },\n goalsFor: { integerValue: String(s.goalsFor) },\n goalsAgainst: { integerValue: String(s.goalsAgainst) },\n goalDifference: { integerValue: String(s.goalDifference) },\n points: { integerValue: String(s.points) },\n isFenerbahce: { booleanValue: s.isFenerbahce },\n },\n },\n }));\n\n const document = {\n fields: {\n id: { stringValue: docId },\n season: { stringValue: \"2024-2025\" },\n competition: { stringValue: \"Super Lig\" },\n sportType: { stringValue: \"football_men\" },\n standings: { arrayValue: { values: standingsArray } },\n updatedAt: { timestampValue: now },\n },\n };\n\n const url =\n `https://firestore.googleapis.com/v1/projects/${projectId}/databases/(default)/documents/standings/${docId}`;\n\n const response = await fetch(url, {\n method: \"PATCH\",\n headers: {\n Authorization: `Bearer ${accessToken}`,\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify(document),\n });\n\n if (!response.ok) {\n const error = await response.text();\n console.error(\"Firebase error:\", error);\n return false;\n }\n\n return true;\n}\n\n// ============ MAIN ============\n\nexport default async function standingsSyncCron() {\n console.log(\"🏆 Starting Super Lig standings sync...\\n\");\n const startTime = Date.now();\n\n try {\n console.log(\"🔐 Authenticating with Firebase...\");\n const accessToken = await getFirebaseAccessToken();\n console.log(\"✅ Firebase authenticated!\\n\");\n\n console.log(\"📊 Scraping standings from TFF...\");\n const standings = await scrapeStandings();\n\n if (standings.length === 0) {\n console.log(\"⚠️ No standings data found!\");\n return { success: false, error: \"No standings data scraped\" };\n }\n\n console.log(`\\n✅ Found ${standings.length} teams\\n`);\n\n console.log(\"💾 Updating Firebase...\");\n const success = await updateStandingsInFirebase(accessToken, standings);\n\n if (success) {\n const duration = ((Date.now() - startTime) / 1000).toFixed(2);\n console.log(`\\n✨ Standings sync completed in ${duration}s`);\n\n const fb = standings.find((s) => s.isFenerbahce);\n if (fb) {\n console.log(\n `\\n⭐ Fenerbahçe: ${fb.position}. sırada - ${fb.points} puan`,\n );\n }\n\n return {\n success: true,\n teamsUpdated: standings.length,\n duration: `${duration}s`,\n fenerbahcePosition: fb?.position,\n fenerbahcePoints: fb?.points,\n };\n } else {\n return { success: false, error: \"Failed to update Firebase\" };\n }\n } catch (error) {\n console.error(\"❌ Standings sync failed:\", error);\n return {\n success: false,\n error: error instanceof Error ? error.message : \"Unknown error\",\n };\n }\n}","// Val Town: fenerbahceStandingsSync\n// Type: Cron\n// Schedule: 0 */6 * * * (every 6 hours)\n// Description: Scrapes TFF Super Lig standings and updates Firebase\n\n// ============ FIREBASE AUTH ============\n\nasync function getFirebaseAccessToken(): Promise {\n const clientEmail = Deno.env.get(\"FIREBASE_CLIENT_EMAIL\")!;\n const privateKey = Deno.env.get(\"FIREBASE_PRIVATE_KEY\")!.replace(\n /\\\\n/g,\n \"\\n\",\n );\n\n const header = { alg: \"RS256\", typ: \"JWT\" };\n const now = Math.floor(Date.now() / 1000);\n const claim = {\n iss: clientEmail,\n scope: \"https://www.googleapis.com/auth/datastore\",\n aud: \"https://oauth2.googleapis.com/token\",\n exp: now + 3600,\n iat: now,\n };\n\n const base64url = (data: Uint8Array | string): string => {\n const str = typeof data === \"string\" ? data : String.fromCharCode(...data);\n return btoa(str).replace(/\\+/g, \"-\").replace(/\\//g, \"_\").replace(/=+$/, \"\");\n };\n\n const headerB64 = base64url(JSON.stringify(header));\n const claimB64 = base64url(JSON.stringify(claim));\n const unsignedToken = `${headerB64}.${claimB64}`;\n\n const pemContents = privateKey\n .replace(\"-----BEGIN PRIVATE KEY-----\", \"\")\n .replace(\"-----END PRIVATE KEY-----\", \"\")\n .replace(/\\s/g, \"\");\n\n const binaryKey = Uint8Array.from(atob(pemContents), (c) => c.charCodeAt(0));\n\n const cryptoKey = await crypto.subtle.importKey(\n \"pkcs8\",\n binaryKey,\n { name: \"RSASSA-PKCS1-v1_5\", hash: \"SHA-256\" },\n false,\n [\"sign\"],\n );\n\n const signature = await crypto.subtle.sign(\n \"RSASSA-PKCS1-v1_5\",\n cryptoKey,\n new TextEncoder().encode(unsignedToken),\n );\n\n const signatureB64 = base64url(new Uint8Array(signature));\n const jwt = `${unsignedToken}.${signatureB64}`;\n\n const tokenResponse = await fetch(\"https://oauth2.googleapis.com/token\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/x-www-form-urlencoded\" },\n body:\n `grant_type=urn:ietf:params:oauth:grant-type:jwt-bearer&assertion=${jwt}`,\n });\n\n const tokenData = await tokenResponse.json();\n if (!tokenData.access_token) {\n throw new Error(`Failed to get access token: ${JSON.stringify(tokenData)}`);\n }\n\n return tokenData.access_token;\n}\n\n// ============ TEAM LOGO URLS ============\n\nconst teamLogos: Record = {\n \"galatasaray\":\n \"https://upload.wikimedia.org/wikipedia/commons/thumb/f/f6/Galatasaray_Sports_Club_Logo.png/200px-Galatasaray_Sports_Club_Logo.png\",\n \"fenerbahce\":\n \"https://upload.wikimedia.org/wikipedia/en/thumb/8/86/Fenerbahce_SK.svg/200px-Fenerbahce_SK.svg.png\",\n \"trabzonspor\":\n \"https://upload.wikimedia.org/wikipedia/en/thumb/1/1f/Trabzonspor.svg/200px-Trabzonspor.svg.png\",\n \"besiktas\":\n \"https://upload.wikimedia.org/wikipedia/commons/thumb/5/52/Be%C5%9Fikta%C5%9F_Logo_Be%C5%9Fikta%C5%9F_Amblem_Be%C5%9Fikta%C5%9F_Arma.png/200px-Be%C5%9Fikta%C5%9F_Logo_Be%C5%9Fikta%C5%9F_Amblem_Be%C5%9Fikta%C5%9F_Arma.png\",\n \"goztepe\":\n \"https://upload.wikimedia.org/wikipedia/en/thumb/c/c8/G%C3%B6ztepe_SK.svg/200px-G%C3%B6ztepe_SK.svg.png\",\n \"basaksehir\":\n \"https://upload.wikimedia.org/wikipedia/en/thumb/5/56/Istanbul_Ba%C5%9Fak%C5%9Fehir_FK.svg/200px-Istanbul_Ba%C5%9Fak%C5%9Fehir_FK.svg.png\",\n \"samsunspor\":\n \"https://upload.wikimedia.org/wikipedia/en/thumb/0/0c/Samsunspor_logo.svg/200px-Samsunspor_logo.svg.png\",\n \"gaziantep\":\n \"https://upload.wikimedia.org/wikipedia/en/thumb/9/9e/Gaziantep_FK_logo.svg/200px-Gaziantep_FK_logo.svg.png\",\n \"kocaelispor\":\n \"https://upload.wikimedia.org/wikipedia/en/thumb/e/e3/Kocaelispor.svg/200px-Kocaelispor.svg.png\",\n \"alanyaspor\":\n \"https://upload.wikimedia.org/wikipedia/en/thumb/2/24/Alanyaspor.svg/200px-Alanyaspor.svg.png\",\n \"genclerbirligi\":\n \"https://upload.wikimedia.org/wikipedia/en/thumb/a/a2/Gen%C3%A7lerbirli%C4%9Fi_SK_logo.svg/200px-Gen%C3%A7lerbirli%C4%9Fi_SK_logo.svg.png\",\n \"rizespor\":\n \"https://upload.wikimedia.org/wikipedia/en/thumb/4/43/%C3%87aykur_Rizespor.svg/200px-%C3%87aykur_Rizespor.svg.png\",\n \"antalyaspor\":\n \"https://upload.wikimedia.org/wikipedia/en/thumb/d/d9/Antalyaspor_logo.svg/200px-Antalyaspor_logo.svg.png\",\n \"konyaspor\":\n \"https://upload.wikimedia.org/wikipedia/en/thumb/4/44/Konyaspor_logo.svg/200px-Konyaspor_logo.svg.png\",\n \"eyupspor\":\n \"https://upload.wikimedia.org/wikipedia/en/thumb/4/44/Ey%C3%BCpspor.svg/200px-Ey%C3%BCpspor.svg.png\",\n \"kasimpasa\":\n \"https://upload.wikimedia.org/wikipedia/en/thumb/e/e3/Kasimpasa_SK.svg/200px-Kasimpasa_SK.svg.png\",\n \"kayserispor\":\n \"https://upload.wikimedia.org/wikipedia/en/thumb/f/f3/Kayserispor_logo.svg/200px-Kayserispor_logo.svg.png\",\n \"karagumruk\":\n \"https://upload.wikimedia.org/wikipedia/en/thumb/3/30/Fatih_Karag%C3%BCmr%C3%BCk_S.K..svg/200px-Fatih_Karag%C3%BCmr%C3%BCk_S.K..svg.png\",\n};\n\nfunction getTeamLogo(teamName: string): string {\n const normalized = teamName.toLowerCase();\n\n for (const [key, url] of Object.entries(teamLogos)) {\n if (normalized.includes(key)) {\n return url;\n }\n }\n\n // Special mappings for Turkish characters\n if (normalized.includes(\"fener\")) return teamLogos[\"fenerbahce\"];\n if (normalized.includes(\"be\") && normalized.includes(\"kta\")) {\n return teamLogos[\"besiktas\"];\n }\n if (normalized.includes(\"g\") && normalized.includes(\"zte\")) {\n return teamLogos[\"goztepe\"];\n }\n if (\n normalized.includes(\"ba\") && normalized.includes(\"ak\") &&\n normalized.includes(\"eh\")\n ) return teamLogos[\"basaksehir\"];\n if (normalized.includes(\"gen\") && normalized.includes(\"ler\")) {\n return teamLogos[\"genclerbirligi\"];\n }\n if (normalized.includes(\"riz\") && normalized.includes(\"spor\")) {\n return teamLogos[\"rizespor\"];\n }\n if (normalized.includes(\"kon\") && normalized.includes(\"spor\")) {\n return teamLogos[\"konyaspor\"];\n }\n if (normalized.includes(\"ey\") && normalized.includes(\"pspor\")) {\n return teamLogos[\"eyupspor\"];\n }\n if (normalized.includes(\"kas\") && normalized.includes(\"pa\")) {\n return teamLogos[\"kasimpasa\"];\n }\n if (normalized.includes(\"kay\") && normalized.includes(\"spor\")) {\n return teamLogos[\"kayserispor\"];\n }\n if (normalized.includes(\"karag\") && normalized.includes(\"mr\")) {\n return teamLogos[\"karagumruk\"];\n }\n\n return \"https://upload.wikimedia.org/wikipedia/commons/thumb/a/a0/Football_-_The_Noun_Project.svg/200px-Football_-_The_Noun_Project.svg.png\";\n}\n\nfunction isFenerbahce(teamName: string): boolean {\n const lower = teamName.toLowerCase();\n return lower.includes(\"fener\");\n}\n\n// ============ SCRAPER ============\n\ninterface StandingEntry {\n position: number;\n teamName: string;\n teamLogoUrl: string;\n matchesPlayed: number;\n wins: number;\n draws: number;\n losses: number;\n goalsFor: number;\n goalsAgainst: number;\n goalDifference: number;\n points: number;\n isFenerbahce: boolean;\n}\n\n// Clean team name from Turkish encoded characters\nfunction cleanTeamName(name: string): string {\n return name\n .replace(/\\.\\./g, \"Ş\") // A.. -> AŞ\n .replace(/\\s+/g, \" \")\n .trim();\n}\n\nasync function scrapeStandings(): Promise {\n console.log(\"Fetching TFF standings page...\");\n\n const response = await fetch(\"https://www.tff.org/default.aspx?pageID=198\", {\n headers: {\n \"User-Agent\":\n \"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36\",\n \"Accept\":\n \"text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8\",\n \"Accept-Language\": \"tr-TR,tr;q=0.9\",\n },\n });\n\n if (!response.ok) {\n throw new Error(`Failed to fetch TFF page: ${response.status}`);\n }\n\n // Get as bytes and decode as windows-1254\n const buffer = await response.arrayBuffer();\n const decoder = new TextDecoder(\"windows-1254\");\n const html = decoder.decode(buffer);\n\n console.log(`Fetched ${html.length} characters`);\n\n const standings: StandingEntry[] = [];\n\n // The TFF page uses grvACetvel grid with lnkTakim links\n // Pattern: grvACetvel_ctl01_lnkTakim...>1.GALATASARAY A.Ş.\n // Then followed by: 19144143142946\n\n // Match all team links in the standings grid\n const teamLinkRegex =\n /grvACetvel_ctl(\\d+)_lnkTakim[^>]+>(\\d+)\\.([^<]+)<\\/a>/gi;\n\n let match;\n const teams: {\n ctlNum: string;\n position: number;\n name: string;\n index: number;\n }[] = [];\n\n while ((match = teamLinkRegex.exec(html)) !== null) {\n teams.push({\n ctlNum: match[1],\n position: parseInt(match[2]),\n name: cleanTeamName(match[3]),\n index: match.index,\n });\n }\n\n console.log(`Found ${teams.length} teams in standings grid`);\n\n // For each team, extract the stats from the row\n for (const team of teams) {\n // Find the row data after the team link\n // Looking for pattern: 1914...\n const startIdx = team.index;\n const searchArea = html.substring(startIdx, startIdx + 500);\n\n // Extract all numbers from td elements after the team name\n // Pattern: number or number\n const tdRegex = /]*>(?:)?(\\d+)(?:<\\/b>)?<\\/td>/gi;\n const numbers: number[] = [];\n\n let tdMatch;\n while ((tdMatch = tdRegex.exec(searchArea)) !== null) {\n numbers.push(parseInt(tdMatch[1]));\n if (numbers.length >= 8) break;\n }\n\n // Also check for goal difference which might be negative\n const avMatch = searchArea.match(/]*>(-?\\d+)<\\/td>/);\n\n if (numbers.length >= 7) {\n // O(played), G(wins), B(draws), M(losses), A(for), Y(against), AV(diff), P(points)\n const entry: StandingEntry = {\n position: team.position,\n teamName: team.name,\n teamLogoUrl: getTeamLogo(team.name),\n matchesPlayed: numbers[0],\n wins: numbers[1],\n draws: numbers[2],\n losses: numbers[3],\n goalsFor: numbers[4],\n goalsAgainst: numbers[5],\n goalDifference: numbers[6] > 50 || numbers[6] < -50\n ? numbers[4] - numbers[5]\n : numbers[6],\n points: numbers[7] || numbers[numbers.length - 1],\n isFenerbahce: isFenerbahce(team.name),\n };\n\n standings.push(entry);\n console.log(\n ` ${entry.position}. ${entry.teamName} - ${entry.points} pts (${entry.wins}W-${entry.draws}D-${entry.losses}L)`,\n );\n } else {\n console.log(\n ` Warning: Could not parse stats for ${team.name}, found ${numbers.length} numbers`,\n );\n }\n }\n\n // Sort by position\n standings.sort((a, b) => a.position - b.position);\n\n return standings;\n}\n\n// ============ FIREBASE UPDATE ============\n\nasync function updateStandingsInFirebase(\n accessToken: string,\n standings: StandingEntry[],\n): Promise {\n const projectId = Deno.env.get(\"FIREBASE_PROJECT_ID\")!;\n const docId = \"football_men_2024_2025\";\n const now = new Date().toISOString();\n\n const standingsArray = standings.map((s) => ({\n mapValue: {\n fields: {\n position: { integerValue: String(s.position) },\n teamName: { stringValue: s.teamName },\n teamLogoUrl: { stringValue: s.teamLogoUrl },\n matchesPlayed: { integerValue: String(s.matchesPlayed) },\n wins: { integerValue: String(s.wins) },\n draws: { integerValue: String(s.draws) },\n losses: { integerValue: String(s.losses) },\n goalsFor: { integerValue: String(s.goalsFor) },\n goalsAgainst: { integerValue: String(s.goalsAgainst) },\n goalDifference: { integerValue: String(s.goalDifference) },\n points: { integerValue: String(s.points) },\n isFenerbahce: { booleanValue: s.isFenerbahce },\n },\n },\n }));\n\n const document = {\n fields: {\n id: { stringValue: docId },\n season: { stringValue: \"2024-2025\" },\n competition: { stringValue: \"Super Lig\" },\n sportType: { stringValue: \"football_men\" },\n standings: { arrayValue: { values: standingsArray } },\n updatedAt: { timestampValue: now },\n },\n };\n\n const url =\n `https://firestore.googleapis.com/v1/projects/${projectId}/databases/(default)/documents/standings/${docId}`;\n\n const response = await fetch(url, {\n method: \"PATCH\",\n headers: {\n Authorization: `Bearer ${accessToken}`,\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify(document),\n });\n\n if (!response.ok) {\n const error = await response.text();\n console.error(\"Firebase error:\", error);\n return false;\n }\n\n return true;\n}\n\n// ============ MAIN ============\n\nexport default async function standingsSyncCron() {\n console.log(\"🏆 Starting Super Lig standings sync...\\n\");\n const startTime = Date.now();\n\n try {\n console.log(\"🔐 Authenticating with Firebase...\");\n const accessToken = await getFirebaseAccessToken();\n console.log(\"✅ Firebase authenticated!\\n\");\n\n console.log(\"📊 Scraping standings from TFF...\");\n const standings = await scrapeStandings();\n\n if (standings.length === 0) {\n console.log(\"⚠️ No standings data found!\");\n return { success: false, error: \"No standings data scraped\" };\n }\n\n console.log(`\\n✅ Found ${standings.length} teams\\n`);\n\n console.log(\"💾 Updating Firebase...\");\n const success = await updateStandingsInFirebase(accessToken, standings);\n\n if (success) {\n const duration = ((Date.now() - startTime) / 1000).toFixed(2);\n console.log(`\\n✨ Standings sync completed in ${duration}s`);\n\n const fb = standings.find((s) => s.isFenerbahce);\n if (fb) {\n console.log(\n `\\n⭐ Fenerbahçe: ${fb.position}. sırada - ${fb.points} puan`,\n );\n }\n\n return {\n success: true,\n teamsUpdated: standings.length,\n duration: `${duration}s`,\n fenerbahcePosition: fb?.position,\n fenerbahcePoints: fb?.points,\n };\n } else {\n return { success: false, error: \"Failed to update Firebase\" };\n }\n } catch (error) {\n console.error(\"❌ Standings sync failed:\", error);\n return {\n success: false,\n error: error instanceof Error ? error.message : \"Unknown error\",\n };\n }\n}","createdAt",["D",1769968186166],"branchVersion","branchId","97b675c2-ff8c-11f0-aa05-42dde27851f2","id","97b618a2-ff8c-11f0-aa05-42dde27851f2","untitled-4898",["D",1769963975424],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","019c1a08-a088-74fa-82fc-567a665324ea","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019c1a08-a088-74fa-82fc-59cb7cc9f48f","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_94":93,"_101":97},"org",{"_94":93,"_95":-5,"_96":97,"_18":54,"_98":99,"_100":25},"branch",{"_13":83,"_32":84,"_43":42,"_85":44,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":45,"_92":93},"isOwned",26,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","hacomeister","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18zOTRsYlhoNWVrTldkUEt2S3BqT0NpU3J6SVkifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":175,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":-5,"_56":25,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":176,"_78":177,"_80":178,"_82":25},"tree",[162,163,164],"files",[162,163,164],"counts",{"_151":60,"_152":153,"_154":60,"_155":156,"_157":158},"contents",[124,125,126],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":144,"_32":145,"_30":146,"_128":-5,"_41":42,"_40":147,"_129":138,"_38":148,"_13":131,"_33":34,"_35":149,"_24":25,"_132":-5,"_27":150},{"_43":134,"_32":135,"_30":136,"_128":-5,"_41":42,"_40":137,"_129":138,"_38":139,"_13":140,"_33":141,"_35":142,"_24":25,"_132":-5,"_27":143},{"_43":127,"_32":28,"_30":31,"_128":-5,"_41":42,"_40":14,"_129":25,"_38":130,"_13":131,"_33":34,"_35":37,"_24":25,"_132":-5,"_27":133},"6583a2d2-ff96-11f0-8d99-42dde27851f2","parentId","latest",["D",1769968186166],5,"label",[28],"b30ab1a2-ff92-11f0-b3fe-42dde27851f2","fenerbahceSquadUpdate.ts","750b3f36-ff90-11f0-8b32-42dde27851f2",11,true,["D",1769966598253],4,"script","// Val Town: fenerbahceSquadUpdate\n// Type: Script (run once manually)\n// Description: Deletes existing squad and adds new Fenerbahce players to Firebase\n\n// ============ FIREBASE AUTH (same as RSS sync) ============\n\nasync function getFirebaseAccessToken(): Promise {\n const clientEmail = Deno.env.get(\"FIREBASE_CLIENT_EMAIL\")!;\n const privateKey = Deno.env.get(\"FIREBASE_PRIVATE_KEY\")!.replace(\n /\\\\n/g,\n \"\\n\",\n );\n\n const header = { alg: \"RS256\", typ: \"JWT\" };\n const now = Math.floor(Date.now() / 1000);\n const claim = {\n iss: clientEmail,\n scope: \"https://www.googleapis.com/auth/datastore\",\n aud: \"https://oauth2.googleapis.com/token\",\n exp: now + 3600,\n iat: now,\n };\n\n const base64url = (data: Uint8Array | string): string => {\n const str = typeof data === \"string\" ? data : String.fromCharCode(...data);\n return btoa(str).replace(/\\+/g, \"-\").replace(/\\//g, \"_\").replace(/=+$/, \"\");\n };\n\n const headerB64 = base64url(JSON.stringify(header));\n const claimB64 = base64url(JSON.stringify(claim));\n const unsignedToken = `${headerB64}.${claimB64}`;\n\n const pemContents = privateKey\n .replace(\"-----BEGIN PRIVATE KEY-----\", \"\")\n .replace(\"-----END PRIVATE KEY-----\", \"\")\n .replace(/\\s/g, \"\");\n\n const binaryKey = Uint8Array.from(atob(pemContents), (c) => c.charCodeAt(0));\n\n const cryptoKey = await crypto.subtle.importKey(\n \"pkcs8\",\n binaryKey,\n { name: \"RSASSA-PKCS1-v1_5\", hash: \"SHA-256\" },\n false,\n [\"sign\"],\n );\n\n const signature = await crypto.subtle.sign(\n \"RSASSA-PKCS1-v1_5\",\n cryptoKey,\n new TextEncoder().encode(unsignedToken),\n );\n\n const signatureB64 = base64url(new Uint8Array(signature));\n const jwt = `${unsignedToken}.${signatureB64}`;\n\n const tokenResponse = await fetch(\"https://oauth2.googleapis.com/token\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/x-www-form-urlencoded\" },\n body:\n `grant_type=urn:ietf:params:oauth:grant-type:jwt-bearer&assertion=${jwt}`,\n });\n\n const tokenData = await tokenResponse.json();\n if (!tokenData.access_token) {\n throw new Error(`Failed to get access token: ${JSON.stringify(tokenData)}`);\n }\n\n return tokenData.access_token;\n}\n\n// ============ SQUAD DATA ============\n\nconst fenerbahcePlayers = [\n // Goalkeepers\n { playerName: \"Ederson\", playerNumber: 31, defaultPosition: \"GK\" },\n { playerName: \"Tank Çetin\", playerNumber: 13, defaultPosition: \"GK\" },\n { playerName: \"Mert Günok\", playerNumber: 34, defaultPosition: \"GK\" },\n\n // Defenders\n { playerName: \"Milan Skriniar\", playerNumber: 37, defaultPosition: \"CB\" },\n { playerName: \"Jayden Oosterwolde\", playerNumber: 24, defaultPosition: \"LB\" },\n { playerName: \"Nelson Semedo\", playerNumber: 27, defaultPosition: \"RB\" },\n { playerName: \"Archie Brown\", playerNumber: 3, defaultPosition: \"CB\" },\n { playerName: \"Mert Müldür\", playerNumber: 18, defaultPosition: \"RB\" },\n { playerName: \"Çağlar Söyüncü\", playerNumber: 4, defaultPosition: \"CB\" },\n\n // Midfielders\n { playerName: \"Edson Alvarez\", playerNumber: 11, defaultPosition: \"CDM\" },\n { playerName: \"Levent Mercan\", playerNumber: 22, defaultPosition: \"CM\" },\n { playerName: \"Yiğit Efe Demir\", playerNumber: 14, defaultPosition: \"CAM\" },\n { playerName: \"Yusuf Akçiçek\", playerNumber: 95, defaultPosition: \"CM\" },\n { playerName: \"Kamil Efe Üregen\", playerNumber: 67, defaultPosition: \"CM\" },\n { playerName: \"İsmail Yüksek\", playerNumber: 5, defaultPosition: \"CDM\" },\n { playerName: \"Fred\", playerNumber: 7, defaultPosition: \"CM\" },\n { playerName: \"Oğuz Aydın\", playerNumber: 70, defaultPosition: \"CAM\" },\n { playerName: \"Marco Asensio\", playerNumber: 21, defaultPosition: \"CAM\" },\n { playerName: \"Matteo Guendouzi\", playerNumber: 6, defaultPosition: \"CM\" },\n\n // Forwards\n { playerName: \"Anderson Talisca\", playerNumber: 94, defaultPosition: \"ST\" },\n { playerName: \"Youssef En Nesyri\", playerNumber: 19, defaultPosition: \"ST\" },\n { playerName: \"Kerem Aktürkoğlu\", playerNumber: 9, defaultPosition: \"LW\" },\n { playerName: \"Dorgeles Nene\", playerNumber: 45, defaultPosition: \"RW\" },\n { playerName: \"Jhon Duran\", playerNumber: 10, defaultPosition: \"ST\" },\n { playerName: \"Anthony Musaba\", playerNumber: 20, defaultPosition: \"RW\" },\n];\n\n// ============ FIRESTORE OPERATIONS ============\n\nasync function deleteAllSquadPlayers(accessToken: string): Promise {\n const projectId = Deno.env.get(\"FIREBASE_PROJECT_ID\")!;\n let deletedCount = 0;\n\n // First, get all documents in squads collection\n const listUrl =\n `https://firestore.googleapis.com/v1/projects/${projectId}/databases/(default)/documents/squads?pageSize=100`;\n\n const listResponse = await fetch(listUrl, {\n headers: { Authorization: `Bearer ${accessToken}` },\n });\n\n const listData = await listResponse.json();\n\n if (listData.documents && listData.documents.length > 0) {\n console.log(\n `Found ${listData.documents.length} existing players to delete...`,\n );\n\n for (const doc of listData.documents) {\n const docPath = doc.name; // Full path like projects/.../documents/squads/fb_1\n const deleteUrl = `https://firestore.googleapis.com/v1/${docPath}`;\n\n const deleteResponse = await fetch(deleteUrl, {\n method: \"DELETE\",\n headers: { Authorization: `Bearer ${accessToken}` },\n });\n\n if (deleteResponse.ok) {\n deletedCount++;\n }\n }\n }\n\n return deletedCount;\n}\n\nasync function addPlayer(\n accessToken: string,\n player: { playerName: string; playerNumber: number; defaultPosition: string },\n): Promise {\n const projectId = Deno.env.get(\"FIREBASE_PROJECT_ID\")!;\n const playerId = `fb_${player.playerNumber}`;\n const now = new Date().toISOString();\n\n const document = {\n fields: {\n id: { stringValue: playerId },\n teamId: { stringValue: \"fenerbahce_001\" },\n playerName: { stringValue: player.playerName },\n playerNumber: { integerValue: String(player.playerNumber) },\n defaultPosition: { stringValue: player.defaultPosition },\n updatedAt: { timestampValue: now },\n },\n };\n\n const url =\n `https://firestore.googleapis.com/v1/projects/${projectId}/databases/(default)/documents/squads?documentId=${playerId}`;\n\n const response = await fetch(url, {\n method: \"POST\",\n headers: {\n Authorization: `Bearer ${accessToken}`,\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify(document),\n });\n\n return response.ok;\n}\n\n// ============ MAIN ============\n\nexport default async function updateSquad() {\n console.log(\"🔄 Starting Fenerbahçe squad update...\\n\");\n\n try {\n // Authenticate\n console.log(\"🔐 Authenticating with Firebase...\");\n const accessToken = await getFirebaseAccessToken();\n console.log(\"✅ Firebase authenticated!\\n\");\n\n // Delete existing players\n console.log(\"🗑️ Deleting existing players...\");\n const deletedCount = await deleteAllSquadPlayers(accessToken);\n console.log(`✅ Deleted ${deletedCount} existing players\\n`);\n\n // Add new players\n console.log(\"👥 Adding new players...\\n\");\n let addedCount = 0;\n\n for (const player of fenerbahcePlayers) {\n const success = await addPlayer(accessToken, player);\n if (success) {\n console.log(\n `✅ Added: #${player.playerNumber} ${player.playerName} (${player.defaultPosition})`,\n );\n addedCount++;\n } else {\n console.log(`❌ Failed: #${player.playerNumber} ${player.playerName}`);\n }\n }\n\n console.log(`\\n✨ Squad update complete!`);\n console.log(\n `📊 Total players added: ${addedCount}/${fenerbahcePlayers.length}`,\n );\n\n return {\n success: true,\n deleted: deletedCount,\n added: addedCount,\n total: fenerbahcePlayers.length,\n };\n } catch (error) {\n console.error(\"❌ Squad update failed:\", error);\n return {\n success: false,\n error: error instanceof Error ? error.message : \"Unknown error\",\n };\n }\n}",[135],"be57024a-ff8d-11f0-b9e1-42dde27851f2","fenerbahceRssSync.ts","97b91d68-ff8c-11f0-aa05-42dde27851f2",6,["D",1769964469722],"// Val Town: fenerbahceRssSync\n// Type: Cron\n// Schedule: */30 * * * * (every 30 minutes)\n// Description: Fetches RSS feeds and saves Fenerbahce news to Firebase using REST API\n\n// ============ CONFIG ============\n\nconst config = {\n feedUrls: [\n \"https://www.fotospor.com/feed/rss_sondakika.xml\",\n \"https://www.ntvspor.net/rss/kategori/futbol\",\n \"https://www.fotomac.com.tr/rss/Fenerbahce.xml\",\n \"https://kontraspor.com/rss\",\n \"https://www.sozcu.com.tr/feeds-rss-category-futbol\",\n \"https://www.aspor.com.tr/rss/anasayfa.xml\",\n \"https://ajansspor.com/rss\",\n ],\n keywords: [\"Fenerbahçe\", \"Fenerbahce\", \"Fener\", \"Sarı Kanaryalar\", \"Sarı Kanarya\", \"FB\"],\n excludeKeywords: [\"spam\", \"reklam\", \"advertisement\"],\n dateFromDays: 7,\n minDescriptionLength: 30,\n};\n\n// ============ TYPES ============\n\ninterface RSSItem {\n title: string;\n description?: string;\n link: string;\n pubDate?: string;\n pubDateParsed?: Date;\n source: string;\n imageUrl?: string;\n category?: string;\n guid?: string;\n}\n\n// ============ FIREBASE REST API ============\n\nasync function getFirebaseAccessToken(): Promise {\n const clientEmail = Deno.env.get(\"FIREBASE_CLIENT_EMAIL\")!;\n const privateKey = Deno.env.get(\"FIREBASE_PRIVATE_KEY\")!.replace(/\\\\n/g, \"\\n\");\n\n // Create JWT\n const header = { alg: \"RS256\", typ: \"JWT\" };\n const now = Math.floor(Date.now() / 1000);\n const claim = {\n iss: clientEmail,\n scope: \"https://www.googleapis.com/auth/datastore\",\n aud: \"https://oauth2.googleapis.com/token\",\n exp: now + 3600,\n iat: now,\n };\n\n const encoder = new TextEncoder();\n\n // Base64URL encode\n const base64url = (data: Uint8Array | string): string => {\n const str = typeof data === \"string\" ? data : String.fromCharCode(...data);\n return btoa(str).replace(/\\+/g, \"-\").replace(/\\//g, \"_\").replace(/=+$/, \"\");\n };\n\n const headerB64 = base64url(JSON.stringify(header));\n const claimB64 = base64url(JSON.stringify(claim));\n const unsignedToken = `${headerB64}.${claimB64}`;\n\n // Import private key and sign\n const pemContents = privateKey\n .replace(\"-----BEGIN PRIVATE KEY-----\", \"\")\n .replace(\"-----END PRIVATE KEY-----\", \"\")\n .replace(/\\s/g, \"\");\n\n const binaryKey = Uint8Array.from(atob(pemContents), (c) => c.charCodeAt(0));\n\n const cryptoKey = await crypto.subtle.importKey(\n \"pkcs8\",\n binaryKey,\n { name: \"RSASSA-PKCS1-v1_5\", hash: \"SHA-256\" },\n false,\n [\"sign\"]\n );\n\n const signature = await crypto.subtle.sign(\n \"RSASSA-PKCS1-v1_5\",\n cryptoKey,\n encoder.encode(unsignedToken)\n );\n\n const signatureB64 = base64url(new Uint8Array(signature));\n const jwt = `${unsignedToken}.${signatureB64}`;\n\n // Exchange JWT for access token\n const tokenResponse = await fetch(\"https://oauth2.googleapis.com/token\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/x-www-form-urlencoded\" },\n body: `grant_type=urn:ietf:params:oauth:grant-type:jwt-bearer&assertion=${jwt}`,\n });\n\n const tokenData = await tokenResponse.json();\n if (!tokenData.access_token) {\n throw new Error(`Failed to get access token: ${JSON.stringify(tokenData)}`);\n }\n\n return tokenData.access_token;\n}\n\nasync function firestoreRequest(\n accessToken: string,\n method: string,\n path: string,\n body?: any\n): Promise {\n const projectId = Deno.env.get(\"FIREBASE_PROJECT_ID\")!;\n const baseUrl = `https://firestore.googleapis.com/v1/projects/${projectId}/databases/(default)/documents`;\n\n const response = await fetch(`${baseUrl}${path}`, {\n method,\n headers: {\n Authorization: `Bearer ${accessToken}`,\n \"Content-Type\": \"application/json\",\n },\n body: body ? JSON.stringify(body) : undefined,\n });\n\n if (!response.ok) {\n const error = await response.text();\n throw new Error(`Firestore error: ${response.status} - ${error}`);\n }\n\n return response.json();\n}\n\nfunction toFirestoreValue(value: any): any {\n if (value === null || value === undefined) {\n return { nullValue: null };\n }\n if (typeof value === \"string\") {\n return { stringValue: value };\n }\n if (typeof value === \"number\") {\n return { integerValue: String(value) };\n }\n if (typeof value === \"boolean\") {\n return { booleanValue: value };\n }\n if (value instanceof Date) {\n return { timestampValue: value.toISOString() };\n }\n if (Array.isArray(value)) {\n return { arrayValue: { values: value.map(toFirestoreValue) } };\n }\n if (typeof value === \"object\") {\n const fields: any = {};\n for (const [k, v] of Object.entries(value)) {\n fields[k] = toFirestoreValue(v);\n }\n return { mapValue: { fields } };\n }\n return { stringValue: String(value) };\n}\n\nasync function checkExistingLinks(accessToken: string, links: string[]): Promise> {\n const existingLinks = new Set();\n const projectId = Deno.env.get(\"FIREBASE_PROJECT_ID\")!;\n\n // Query in batches of 10 (Firestore 'in' limit)\n for (let i = 0; i < links.length; i += 10) {\n const chunk = links.slice(i, i + 10);\n\n const query = {\n structuredQuery: {\n from: [{ collectionId: \"news\" }],\n where: {\n fieldFilter: {\n field: { fieldPath: \"link\" },\n op: \"IN\",\n value: { arrayValue: { values: chunk.map(l => ({ stringValue: l })) } },\n },\n },\n select: { fields: [{ fieldPath: \"link\" }] },\n limit: 10,\n },\n };\n\n try {\n const response = await fetch(\n `https://firestore.googleapis.com/v1/projects/${projectId}/databases/(default)/documents:runQuery`,\n {\n method: \"POST\",\n headers: {\n Authorization: `Bearer ${accessToken}`,\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify(query),\n }\n );\n\n const results = await response.json();\n\n if (Array.isArray(results)) {\n for (const result of results) {\n if (result.document?.fields?.link?.stringValue) {\n existingLinks.add(result.document.fields.link.stringValue);\n }\n }\n }\n } catch (error) {\n console.error(\"Error checking existing links:\", error);\n }\n }\n\n return existingLinks;\n}\n\nasync function saveNewsItem(accessToken: string, item: RSSItem): Promise {\n const projectId = Deno.env.get(\"FIREBASE_PROJECT_ID\")!;\n const now = new Date().toISOString();\n\n const document = {\n fields: {\n title: { stringValue: item.title },\n description: { stringValue: item.description || \"\" },\n link: { stringValue: item.link },\n pubDate: { timestampValue: item.pubDateParsed?.toISOString() || now },\n source: { stringValue: item.source },\n imageUrl: { stringValue: item.imageUrl || \"\" },\n category: { stringValue: item.category || \"\" },\n guid: { stringValue: item.guid || item.link },\n createdAt: { timestampValue: now },\n updatedAt: { timestampValue: now },\n },\n };\n\n try {\n const response = await fetch(\n `https://firestore.googleapis.com/v1/projects/${projectId}/databases/(default)/documents/news`,\n {\n method: \"POST\",\n headers: {\n Authorization: `Bearer ${accessToken}`,\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify(document),\n }\n );\n\n return response.ok;\n } catch (error) {\n console.error(\"Error saving news item:\", error);\n return false;\n }\n}\n\n// ============ RSS FETCHING ============\n\nfunction extractSourceName(url: string): string {\n try {\n const urlObj = new URL(url);\n let domain = urlObj.hostname;\n if (domain.startsWith(\"www.\")) {\n domain = domain.substring(4);\n }\n return domain;\n } catch {\n return url;\n }\n}\n\nfunction normalizeUrl(url: string | null | undefined): string | null {\n if (!url || typeof url !== \"string\") return null;\n try {\n let normalized = url.trim().replace(/\\/+$/, \"\");\n return normalized.toLowerCase();\n } catch {\n return url.toLowerCase().trim();\n }\n}\n\nasync function fetchRSSFeed(url: string): Promise {\n try {\n const response = await fetch(url, {\n headers: {\n \"User-Agent\": \"Mozilla/5.0 (compatible; RSSBot/1.0)\",\n Accept: \"application/rss+xml, application/xml, text/xml, */*\",\n },\n });\n\n if (!response.ok) {\n console.error(`Failed to fetch ${url}: ${response.status}`);\n return [];\n }\n\n const text = await response.text();\n const items: RSSItem[] = [];\n const itemRegex = /([\\s\\S]*?)<\\/item>/gi;\n const sourceName = extractSourceName(url);\n\n let match;\n while ((match = itemRegex.exec(text)) !== null) {\n const itemXml = match[1];\n\n const getTagContent = (tag: string): string | undefined => {\n const cdataRegex = new RegExp(`<${tag}[^>]*>\\\\s*\\\\s*`, \"i\");\n const cdataMatch = itemXml.match(cdataRegex);\n if (cdataMatch) return cdataMatch[1].trim();\n\n const regex = new RegExp(`<${tag}[^>]*>([\\\\s\\\\S]*?)`, \"i\");\n const contentMatch = itemXml.match(regex);\n return contentMatch ? contentMatch[1].trim() : undefined;\n };\n\n const getAttrValue = (tag: string, attr: string): string | undefined => {\n const regex = new RegExp(`<${tag}[^>]*${attr}=[\"']([^\"']+)[\"']`, \"i\");\n const attrMatch = itemXml.match(regex);\n return attrMatch ? attrMatch[1] : undefined;\n };\n\n const title = getTagContent(\"title\") || \"Untitled\";\n const description = getTagContent(\"description\") || getTagContent(\"content:encoded\");\n const link = getTagContent(\"link\") || getTagContent(\"guid\");\n const pubDate = getTagContent(\"pubDate\");\n const guid = getTagContent(\"guid\");\n const category = getTagContent(\"category\");\n\n let imageUrl = getAttrValue(\"media:content\", \"url\") || getAttrValue(\"enclosure\", \"url\");\n if (!imageUrl && description) {\n const imgMatch = description.match(/]+src=[\"']([^\"']+)[\"']/i);\n if (imgMatch) imageUrl = imgMatch[1];\n }\n\n if (link) {\n items.push({\n title,\n description: description?.replace(/<[^>]+>/g, \"\").substring(0, 500),\n link,\n pubDate,\n pubDateParsed: pubDate ? new Date(pubDate) : new Date(),\n source: sourceName,\n imageUrl,\n category,\n guid: guid || link,\n });\n }\n }\n\n console.log(`Fetched ${items.length} items from ${sourceName}`);\n return items;\n } catch (error) {\n console.error(`Error fetching ${url}:`, error);\n return [];\n }\n}\n\nasync function fetchAllFeeds(): Promise {\n const results = await Promise.allSettled(config.feedUrls.map((url) => fetchRSSFeed(url)));\n\n const allItems: RSSItem[] = [];\n for (const result of results) {\n if (result.status === \"fulfilled\") {\n allItems.push(...result.value);\n }\n }\n\n return allItems;\n}\n\nfunction filterItems(items: RSSItem[]): RSSItem[] {\n const dateFrom = new Date(Date.now() - config.dateFromDays * 24 * 60 * 60 * 1000);\n\n return items.filter((item) => {\n const searchText = `${item.title} ${item.description || \"\"}`.toLowerCase();\n\n // Must contain at least one keyword\n const hasKeyword = config.keywords.some((kw) => searchText.includes(kw.toLowerCase()));\n if (!hasKeyword) return false;\n\n // Must not contain excluded keywords\n const hasExcluded = config.excludeKeywords.some((kw) => searchText.includes(kw.toLowerCase()));\n if (hasExcluded) return false;\n\n // Must be recent\n const itemDate = item.pubDateParsed || new Date(0);\n if (itemDate < dateFrom) return false;\n\n // Must have minimum description length\n if ((item.description || \"\").length < config.minDescriptionLength) return false;\n\n return true;\n });\n}\n\n// ============ MAIN ============\n\nexport default async function rssSyncCron() {\n console.log(\"Starting RSS sync...\");\n const startTime = Date.now();\n\n try {\n // Get Firebase access token\n console.log(\"Authenticating with Firebase...\");\n const accessToken = await getFirebaseAccessToken();\n console.log(\"Firebase authenticated!\");\n\n // Fetch RSS feeds\n console.log(`Fetching from ${config.feedUrls.length} RSS feeds...`);\n const allItems = await fetchAllFeeds();\n console.log(`Fetched ${allItems.length} total items`);\n\n // Filter items\n let filteredItems = filterItems(allItems);\n console.log(`After filtering: ${filteredItems.length} items`);\n\n // Remove duplicates within batch\n const seenLinks = new Set();\n filteredItems = filteredItems.filter((item) => {\n const normalized = normalizeUrl(item.link);\n if (!normalized || seenLinks.has(normalized)) return false;\n seenLinks.add(normalized);\n return true;\n });\n console.log(`After deduplication: ${filteredItems.length} items`);\n\n // Check existing in Firebase (limit to first 30 to avoid timeout)\n const itemsToCheck = filteredItems.slice(0, 30);\n const links = itemsToCheck.map((item) => item.link);\n console.log(`Checking ${links.length} items against Firebase...`);\n const existingLinks = await checkExistingLinks(accessToken, links);\n console.log(`Found ${existingLinks.size} existing items`);\n\n // Filter out existing\n const newItems = itemsToCheck.filter((item) => !existingLinks.has(item.link));\n console.log(`New items to save: ${newItems.length}`);\n\n // Save new items (limit to 20 per run to avoid timeout)\n const itemsToSave = newItems.slice(0, 20);\n let savedCount = 0;\n\n for (const item of itemsToSave) {\n const saved = await saveNewsItem(accessToken, item);\n if (saved) savedCount++;\n }\n\n const duration = ((Date.now() - startTime) / 1000).toFixed(2);\n console.log(`RSS sync completed in ${duration}s. Saved: ${savedCount}/${itemsToSave.length}`);\n\n return {\n success: true,\n totalFetched: allItems.length,\n afterFilter: filteredItems.length,\n checked: itemsToCheck.length,\n newItems: newItems.length,\n saved: savedCount,\n duration: `${duration}s`,\n };\n } catch (error) {\n console.error(\"RSS sync failed:\", error);\n return {\n success: false,\n error: error instanceof Error ? error.message : \"Unknown error\",\n };\n }\n}",[145],"pulls","branches",1,"forks","envVars",{"_159":140,"_161":60},"connections",{"_159":60,"_160":60},"count","unfilledCount","emptyCount",{"_43":144,"_32":145,"_30":146,"_128":-5,"_41":42,"_40":147,"_129":138,"_38":172,"_13":131,"_33":34,"_35":149,"_24":25,"_132":-5,"_166":173,"_27":174},{"_43":134,"_32":135,"_30":136,"_128":-5,"_41":42,"_40":137,"_129":138,"_38":169,"_13":140,"_33":141,"_35":142,"_24":25,"_132":-5,"_166":170,"_27":171},{"_43":127,"_32":28,"_30":31,"_128":-5,"_41":42,"_40":14,"_129":25,"_38":165,"_13":131,"_33":34,"_35":37,"_24":25,"_132":-5,"_166":167,"_27":168},["D",1769968186166],"children",[],[28],["D",1769966598253],[],[135],["D",1769964469722],[],[145],["D",1769963975424],{"_94":93,"_101":97},{"_94":93,"_95":-5,"_96":97,"_18":54,"_98":99,"_100":25},{"_13":83,"_32":84,"_43":42,"_85":44,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":45,"_92":93},"ctx",{"_76":-5,"_121":212,"_213":214,"_215":216,"_217":25,"_218":25,"_219":25,"_220":138,"_221":-5,"_222":-7,"_223":-7,"_224":60,"_225":25,"_226":25,"_227":-5,"_228":25,"_229":25,"_230":25,"_231":-5},"ENV",{"_183":184,"_185":186,"_187":84,"_188":189,"_190":191,"_192":193,"_194":195,"_196":197,"_198":199,"_200":201,"_202":203,"_204":205,"_206":207,"_208":209,"_210":211},"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"]

Diff · v17