[{"_1":2,"_266":-5,"_267":-5},"loaderData",{"_3":4,"_93":94,"_242":243},"root",{"_5":6,"_36":37,"_66":67},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":22,"_29":22,"_30":22,"_31":-5,"_32":33,"_34":22,"_35":22},"auth",{"_9":10,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":-5,"_20":-5,"_21":22},"tokenType","session_token","sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesChatPanelState","notificationCount",0,"flagDenols","isTeamOrgMember","ENV",{"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":51,"_52":53,"_54":55,"_56":57,"_58":59,"_60":61,"_62":63,"_64":65},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","6050acf0705e6826bb1b68e27572c5b8979c5bd9","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","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","API_URL","https://api.val.town","clerkState",{"_68":69},"__internal_clerk_state",{"_70":71,"_72":47,"_73":74,"_75":74,"_76":22,"_77":74,"_78":74,"_79":74,"_80":74,"_81":82,"_91":22,"_92":22},"__clerk_ssr_state",{"_9":10,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":-5,"_20":-5,"_21":22},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_83":22,"_21":22,"_84":74,"_85":86,"_87":74,"_88":47,"_89":22,"_90":74},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/_app.x.$handle.$name",{"_95":96,"_97":98,"_99":-7,"_100":74,"_101":-7,"_102":103,"_153":154,"_206":207,"_208":209,"_221":222,"_235":-5,"_236":-5,"_237":-5,"_238":22,"_239":22,"_240":241},"handle","hacomeister","name","untitled-4898","branchName","path","version","project",{"_104":105,"_97":98,"_106":107,"_108":-5,"_109":22,"_110":111,"_112":-5,"_113":-5,"_14":114,"_115":-5,"_116":22,"_117":-5,"_118":-5,"_119":33,"_16":120,"_121":-5,"_122":-5,"_123":124,"_125":124,"_126":127,"_128":127,"_129":127,"_130":124,"_131":124,"_23":132,"_135":136,"_140":141,"_152":22},"id","97b618a2-ff8c-11f0-aa05-42dde27851f2","createdAt",["D",1769963975424],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","019c1a08-a088-74fa-82fc-567a665324ea","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","019c1a08-a088-74fa-82fc-59cb7cc9f48f","tursoName","tursoHostname","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_95":96,"_133":134},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18zOTRsYlhoNWVrTldkUEt2S3BqT0NpU3J6SVkifQ","org",{"_95":96,"_137":134,"_14":114,"_138":139},"avatar","tier","free","branch",{"_101":142,"_97":45,"_104":143,"_144":105,"_145":-5,"_146":-5,"_147":-5,"_148":-5,"_149":-5,"_150":98,"_151":96},26,"97b675c2-ff8c-11f0-aa05-42dde27851f2","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","tree",[155,176,185,196],{"_104":156,"_97":157,"_158":159,"_160":-5,"_161":143,"_162":142,"_163":164,"_106":165,"_101":166,"_167":168,"_169":170,"_171":22,"_172":-5,"_173":174,"_100":175},"4a6f1e96-ff9a-11f0-8b9a-42dde27851f2","fenerbahceFindTeamId.ts","fileId","b1d1e66e-ff99-11f0-a9d5-42dde27851f2","parentId","branchId","branchVersion","latest",true,["D",1769969858706],5,"fileType","interval","content","// Val Town: fenerbahceFindTeamId\n// Type: Script (Manual)\n// Description: Helper script to find Fenerbahce team ID from football-data.org\n//\n// Run this once to verify the correct team ID for Fenerbahce\n// Required Environment Variable: FOOTBALL_DATA_API_KEY\n\nexport default async function findFenerbahceTeamId() {\n const apiKey = Deno.env.get(\"FOOTBALL_DATA_API_KEY\");\n if (!apiKey) {\n return { error: \"FOOTBALL_DATA_API_KEY environment variable is not set\" };\n }\n\n console.log(\"🔍 Searching for Fenerbahce team ID...\\n\");\n\n // Method 1: Get teams from Turkish Super League\n const tslUrl = \"https://api.football-data.org/v4/competitions/TSL/teams\";\n\n try {\n const response = await fetch(tslUrl, {\n headers: { \"X-Auth-Token\": apiKey },\n });\n\n if (!response.ok) {\n const error = await response.text();\n console.error(`API Error: ${response.status} - ${error}`);\n\n // If TSL is not in free tier, try searching by name\n console.log(\n \"\\nTSL might require paid tier. Trying alternative search...\\n\",\n );\n\n // Method 2: Try to get Fenerbahce directly by checking a wider range of IDs\n // Turkish team IDs seem to be in various ranges, let's search more broadly\n const idsToCheck = [\n // 600s range (where we found Galatasaray at 610)\n ...Array.from({ length: 50 }, (_, i) => 600 + i),\n // Also check some other common ranges\n ...Array.from({ length: 20 }, (_, i) => 550 + i),\n ...Array.from({ length: 20 }, (_, i) => 650 + i),\n ];\n\n const turkishTeams: Array<\n { id: number; name: string; shortName: string }\n > = [];\n\n for (const testId of idsToCheck) {\n try {\n const teamResponse = await fetch(\n `https://api.football-data.org/v4/teams/${testId}`,\n {\n headers: { \"X-Auth-Token\": apiKey },\n },\n );\n\n if (teamResponse.ok) {\n const team = await teamResponse.json();\n // Check if it's a Turkish team (area.name or competition)\n const isTurkish = team.area?.name === \"Turkey\" ||\n team.name?.toLowerCase().includes(\"spor\") ||\n team.name?.toLowerCase().includes(\"sk\");\n\n if (\n isTurkish || team.name.toLowerCase().includes(\"fener\") ||\n team.name.toLowerCase().includes(\"galata\") ||\n team.name.toLowerCase().includes(\"besik\") ||\n team.name.toLowerCase().includes(\"trabzon\")\n ) {\n turkishTeams.push({\n id: team.id,\n name: team.name,\n shortName: team.shortName || team.tla || \"\",\n });\n\n const isFener = team.name.toLowerCase().includes(\"fener\");\n const prefix = isFener ? \"⭐\" : \" \";\n console.log(\n `${prefix} ID ${team.id}: ${team.name} (${\n team.shortName || team.tla\n })`,\n );\n }\n }\n } catch {\n // Continue checking (404 or other errors are expected for non-existent IDs)\n }\n\n // Add small delay to avoid rate limiting (10 req/min for free tier)\n if (testId % 5 === 0) {\n await new Promise((resolve) => setTimeout(resolve, 500));\n }\n }\n\n // Find Fenerbahce in the results\n const fenerbahce = turkishTeams.find((t) =>\n t.name.toLowerCase().includes(\"fener\")\n );\n\n if (fenerbahce) {\n console.log(`\\n✅ Found Fenerbahce!`);\n console.log(` ID: ${fenerbahce.id}`);\n console.log(` Name: ${fenerbahce.name}`);\n return {\n teamId: fenerbahce.id,\n team: fenerbahce,\n allTurkishTeams: turkishTeams,\n };\n }\n\n console.log(\n `\\nFound ${turkishTeams.length} Turkish teams but Fenerbahce not found.`,\n );\n console.log(\"All Turkish teams found:\", turkishTeams);\n\n return {\n error: \"Could not find Fenerbahce team ID\",\n turkishTeamsFound: turkishTeams,\n };\n }\n\n const data = await response.json();\n console.log(`Found ${data.teams.length} teams in Turkish Super League:\\n`);\n\n let fenerbahceTeam = null;\n\n for (const team of data.teams) {\n const isFener = team.name.toLowerCase().includes(\"fener\");\n const prefix = isFener ? \"⭐\" : \" \";\n console.log(\n `${prefix} ${team.id}: ${team.name} (${team.shortName || team.tla})`,\n );\n\n if (isFener) {\n fenerbahceTeam = team;\n }\n }\n\n if (fenerbahceTeam) {\n console.log(`\\n✅ Fenerbahce Team ID: ${fenerbahceTeam.id}`);\n console.log(` Full Name: ${fenerbahceTeam.name}`);\n console.log(` Short Name: ${fenerbahceTeam.shortName}`);\n console.log(` TLA: ${fenerbahceTeam.tla}`);\n console.log(` Crest URL: ${fenerbahceTeam.crest}`);\n\n return {\n teamId: fenerbahceTeam.id,\n team: fenerbahceTeam,\n allTeams: data.teams.map((t: any) => ({ id: t.id, name: t.name })),\n };\n }\n\n return {\n error: \"Fenerbahce not found in the list\",\n teams: data.teams.map((t: any) => ({ id: t.id, name: t.name })),\n };\n } catch (error) {\n console.error(\"Error:\", error);\n return {\n error: error instanceof Error ? error.message : \"Unknown error\",\n };\n }\n}","deleted","label","children",[],[157],{"_104":177,"_97":178,"_158":179,"_160":-5,"_161":143,"_162":180,"_163":164,"_106":181,"_101":166,"_167":168,"_169":182,"_171":22,"_172":-5,"_173":183,"_100":184},"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}",[],[178],{"_104":186,"_97":187,"_158":188,"_160":-5,"_161":143,"_162":189,"_163":164,"_106":190,"_101":191,"_167":192,"_169":193,"_171":22,"_172":-5,"_173":194,"_100":195},"b30ab1a2-ff92-11f0-b3fe-42dde27851f2","fenerbahceSquadUpdate.ts","750b3f36-ff90-11f0-8b32-42dde27851f2",11,["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}",[],[187],{"_104":197,"_97":198,"_158":199,"_160":-5,"_161":143,"_162":200,"_163":164,"_106":201,"_101":202,"_167":168,"_169":203,"_171":22,"_172":-5,"_173":204,"_100":205},"5e90be28-ff97-11f0-a274-42dde27851f2","fenerbahceStandingsSync.ts","3aee370e-ff95-11f0-850d-42dde27851f2",20,["D",1769968604007],8,"// 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 // Stats are in elements: lblOyun, Label4, lblKazanma, lblPuan, Label1, Label2, Label5, Label3\n // Order: O(played), G(wins), B(draws), M(losses), A(for), Y(against), AV(diff), P(points)\n const startIdx = team.index;\n const searchArea = html.substring(startIdx, startIdx + 2000);\n\n // Extract all numbers from span elements after the team name\n // Pattern: number (including negative numbers for goal difference)\n const spanRegex = /]*>(-?\\d+)<\\/span>/gi;\n const numbers: number[] = [];\n\n let spanMatch;\n while ((spanMatch = spanRegex.exec(searchArea)) !== null) {\n numbers.push(parseInt(spanMatch[1]));\n if (numbers.length >= 8) break;\n }\n\n if (numbers.length >= 7) {\n // If only 7 numbers found, calculate goal difference from goals for/against\n if (numbers.length === 7) {\n // Insert calculated goal difference at position 6\n const goalDiff = numbers[4] - numbers[5];\n numbers.splice(6, 0, goalDiff);\n }\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],\n points: numbers[7],\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 numbers.join(\", \")\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}",[],[198],"files",[155,176,185,196],"counts",{"_210":33,"_211":212,"_213":33,"_214":215,"_218":219},"pulls","branches",1,"forks","envVars",{"_216":191,"_217":33},"count","emptyCount","connections",{"_216":33,"_220":33},"unfilledCount","contents",[223,226,229,232],{"_104":156,"_97":157,"_158":159,"_160":-5,"_161":143,"_162":142,"_163":164,"_106":224,"_101":166,"_167":168,"_169":170,"_171":22,"_172":-5,"_100":225},["D",1769969858706],[157],{"_104":177,"_97":178,"_158":179,"_160":-5,"_161":143,"_162":180,"_163":164,"_106":227,"_101":166,"_167":168,"_169":182,"_171":22,"_172":-5,"_100":228},["D",1769964469722],[178],{"_104":186,"_97":187,"_158":188,"_160":-5,"_161":143,"_162":189,"_163":164,"_106":230,"_101":191,"_167":192,"_169":193,"_171":22,"_172":-5,"_100":231},["D",1769966598253],[187],{"_104":197,"_97":198,"_158":199,"_160":-5,"_161":143,"_162":200,"_163":164,"_106":233,"_101":202,"_167":168,"_169":203,"_171":22,"_172":-5,"_100":234},["D",1769968604007],[198],"file","upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.environment-variables",{"_95":96,"_97":98,"_102":244,"_214":249,"_265":22},{"_104":105,"_97":98,"_106":245,"_108":-5,"_109":22,"_110":111,"_112":-5,"_113":-5,"_14":114,"_115":-5,"_116":22,"_117":-5,"_118":-5,"_119":33,"_16":120,"_121":-5,"_122":-5,"_123":124,"_125":124,"_126":127,"_128":127,"_129":127,"_130":124,"_131":124,"_23":246,"_135":247,"_140":248,"_152":22},["D",1769963975424],{"_95":96,"_133":134},{"_95":96,"_137":134,"_14":114,"_138":139},{"_101":142,"_97":45,"_104":143,"_144":105,"_145":-5,"_146":-5,"_147":-5,"_148":-5,"_149":-5,"_150":98,"_151":96},[250,256,259,262],{"_251":252,"_106":253,"_254":-5,"_112":74,"_255":22},"key","FOOTBALL_DATA_API_KEY",["D",1769969593201],"updatedAt","isEmpty",{"_251":257,"_106":258,"_254":-5,"_112":74,"_255":22},"FIREBASE_PRIVATE_KEY",["D",1769964133473],{"_251":260,"_106":261,"_254":-5,"_112":74,"_255":22},"FIREBASE_CLIENT_EMAIL",["D",1769964113369],{"_251":263,"_106":264,"_254":-5,"_112":74,"_255":22},"FIREBASE_PROJECT_ID",["D",1769964098496],"isTeamOrg","actionData","errors"]

Key	Description
FOOTBALL_DATA_API_KEY
FIREBASE_PRIVATE_KEY
FIREBASE_CLIENT_EMAIL
FIREBASE_PROJECT_ID

hacomeister

untitled-4898

Environment variables