[{"_1":2,"_176":-5,"_177":-5},"loaderData",{"_3":4,"_93":94},"root",{"_5":6,"_36":37,"_66":67},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":-5,"_32":33,"_34":20,"_35":20},"auth",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20,"_21":22},"sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"tokenType","session_token","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":20,"_77":74,"_78":74,"_79":74,"_80":74,"_81":82,"_91":20,"_92":20},"__clerk_ssr_state",{"_21":22,"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_83":20,"_19":20,"_84":74,"_85":86,"_87":74,"_88":47,"_89":20,"_90":74},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_95":96,"_97":98,"_99":100,"_101":102,"_153":154,"_173":174,"_175":-5},"handle","hacomeister","name","untitled-4898","path","fenerbahceStandingsSync.ts","project",{"_103":104,"_97":98,"_105":106,"_107":-5,"_108":20,"_109":110,"_111":-5,"_112":-5,"_12":113,"_114":-5,"_115":20,"_116":-5,"_117":-5,"_118":33,"_14":119,"_120":-5,"_121":-5,"_122":123,"_124":123,"_125":126,"_127":126,"_128":126,"_129":123,"_130":123,"_23":131,"_134":135,"_139":140,"_152":20},"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,"_132":133},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18zOTRsYlhoNWVrTldkUEt2S3BqT0NpU3J6SVkifQ","org",{"_95":96,"_136":133,"_12":113,"_137":138},"avatar","tier","free","branch",{"_141":142,"_97":45,"_103":143,"_144":104,"_145":-5,"_146":-5,"_147":-5,"_148":-5,"_149":-5,"_150":98,"_151":96},"version",26,"97b675c2-ff8c-11f0-aa05-42dde27851f2","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_103":155,"_97":100,"_156":157,"_158":-5,"_159":143,"_160":161,"_162":163,"_105":164,"_141":165,"_166":167,"_168":169,"_170":20,"_171":-5,"_99":172},"5e90be28-ff97-11f0-a274-42dde27851f2","fileId","3aee370e-ff95-11f0-850d-42dde27851f2","parentId","branchId","branchVersion",20,"latest",true,["D",1769968604007],8,"fileType","interval","content","// 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}","deleted","label",[100],"permalink","https://www.val.town/x/hacomeister/untitled-4898/code/fenerbahceStandingsSync.ts","extension","actionData","errors"]