[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_186":187,"_188":189},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_61":130,"_16":-7,"_135":-5,"_17":136,"_137":138,"_28":139,"_21":140,"_23":141,"_142":-5,"_143":-5,"_144":-5,"_145":36,"_146":147,"_148":34,"_149":-5,"_150":-5,"_151":152},"routes/_app.x.$handle.$name._index",{"_11":12,"_13":14,"_15":-7,"_16":-7,"_17":18,"_19":20,"_21":22,"_23":24,"_25":-7,"_26":-5,"_27":-5,"_28":29,"_30":-5,"_31":-5,"_32":-5,"_33":34,"_35":36,"_37":34},"handle","fred1","name","untitled-7461","branchName","version","project",{"_39":78,"_13":14,"_50":79,"_80":-5,"_81":36,"_82":83,"_84":83,"_85":-5,"_86":-5,"_87":88,"_89":-5,"_90":36,"_91":-5,"_92":-5,"_93":67,"_94":95,"_96":97,"_98":99,"_100":101,"_102":-5,"_103":104,"_105":104,"_106":107,"_108":107,"_109":107,"_110":104,"_111":104,"_112":113,"_114":115,"_116":117,"_118":36},"tags",[],"counts",{"_66":67,"_68":69,"_70":69,"_71":72,"_73":74},"contents",[63],"readme","upstream","pull","files",[38],"preview","ahead","behind","showHomeCustomizationHint",true,"showHTTPPreviewSettingsHint",false,"hasHTTPFiles",{"_39":40,"_13":41,"_42":43,"_44":-5,"_45":46,"_47":48,"_49":34,"_50":51,"_16":52,"_53":54,"_55":56,"_57":36,"_58":-5,"_59":60,"_61":62},"id","3a975eec-f55f-42b4-8c75-bc82a6baa84c","main.ts","fileId","3336de7a-3830-11f1-aade-42b51c65c3df","parentId","branchId","3333516a-3830-11f1-aade-42b51c65c3df","branchVersion",27,"latest","createdAt",["D",1788198759921],22,"fileType","http","content","import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nconst RSVP_BASE_URL = \"https://tinyurl.com/bayrcq\";\n\nconst GRAPHQL_URL =\n \"https://api.tabletop.wizards.com/silverbeak-griffin-service/graphql\";\n\nconst QUERY =\n `query queryEvents($latitude: Float!, $longitude: Float!, $maxMeters: Int!, $tags: [String!]!, $sort: EventSearchSortField, $sortDirection: EventSearchSortDirection, $orgs: [ID!], $startDate: DateTime, $endDate: DateTime, $page: Int, $pageSize: Int) {\n searchEvents(\n query: {latitude: $latitude, longitude: $longitude, maxMeters: $maxMeters, tags: $tags, sort: $sort, sortDirection: $sortDirection, orgs: $orgs, startDate: $startDate, endDate: $endDate, page: $page, pageSize: $pageSize}\n ) {\n events {\n id capacity description distance emailAddress hasTop8\n isAdHoc isOnline latitude longitude title eventTemplateId\n pairingType phoneNumber requiredTeamSize rulesEnforcementLevel\n scheduledStartTime startingTableNumber status tags timeZone\n cardSet { id __typename }\n entryFee { amount currency __typename }\n organization { id isPremium name __typename }\n eventFormat { id __typename }\n __typename\n }\n pageInfo { page pageSize totalResults __typename }\n __typename\n }\n}`;\n\nconst PAYLOAD = {\n operationName: \"queryEvents\",\n variables: {\n latitude: 37.7597481,\n longitude: -122.4750292,\n maxMeters: 160934,\n tags: [\"magic:_the_gathering\", \"regional_championship_qualifier\"],\n sort: \"date\",\n sortDirection: \"Asc\",\n orgs: [],\n pageSize: 50,\n page: 0,\n },\n query: QUERY,\n};\n\nconst FETCH_HEADERS: Record = {\n \"Accept\": \"application/json, text/plain, */*\",\n \"Accept-Encoding\": \"gzip, deflate, br, zstd\",\n \"Accept-Language\": \"en-US,en;q=0.9\",\n \"Cache-Control\": \"no-cache\",\n \"Content-Type\": \"application/json\",\n \"Origin\": \"https://locator.wizards.com\",\n \"Pragma\": \"no-cache\",\n \"Referer\": \"https://locator.wizards.com/\",\n \"Sec-Ch-Ua\":\n '\"Chromium\";v=\"124\", \"Google Chrome\";v=\"124\", \"Not-A.Brand\";v=\"99\"',\n \"Sec-Ch-Ua-Mobile\": \"?0\",\n \"Sec-Ch-Ua-Platform\": '\"macOS\"',\n \"Sec-Fetch-Dest\": \"empty\",\n \"Sec-Fetch-Mode\": \"cors\",\n \"Sec-Fetch-Site\": \"same-site\",\n \"User-Agent\":\n \"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 \" +\n \"(KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36\",\n};\n\n// ── Hardcoded Bay Area transit stations ────────────────────────────────────────\n// No external API needed. Stations change rarely; update if BART/Caltrain expand.\n\n// [lat, lng, name]\ntype Station = [number, number, string];\n\nconst BART_STATIONS: Station[] = [\n [37.7929, -122.3969, \"Embarcadero\"],\n [37.7894, -122.4012, \"Montgomery St\"],\n [37.7845, -122.4089, \"Powell St\"],\n [37.7794, -122.4136, \"Civic Center/UN Plaza\"],\n [37.7650, -122.4197, \"16th St Mission\"],\n [37.7524, -122.4183, \"24th St Mission\"],\n [37.7329, -122.4341, \"Glen Park\"],\n [37.7219, -122.4479, \"Balboa Park\"],\n [37.7061, -122.4690, \"Daly City\"],\n [37.6845, -122.4664, \"Colma\"],\n [37.6307, -122.4116, \"San Bruno\"],\n [37.6643, -122.4442, \"South San Francisco\"],\n [37.6159, -122.3924, \"SFO Airport\"],\n [37.5994, -122.3869, \"Millbrae\"],\n [37.8046, -122.2948, \"West Oakland\"],\n [37.8037, -122.2717, \"12th St Oakland\"],\n [37.8082, -122.2688, \"19th St Oakland\"],\n [37.8289, -122.2678, \"MacArthur\"],\n [37.8441, -122.2515, \"Rockridge\"],\n [37.8930, -122.1243, \"Lafayette\"],\n [37.8782, -122.1830, \"Orinda\"],\n [37.9057, -122.0677, \"Walnut Creek\"],\n [37.9283, -122.0571, \"Pleasant Hill\"],\n [37.9736, -122.0291, \"Concord\"],\n [37.9997, -122.0259, \"North Concord/Martinez\"],\n [38.0183, -121.9454, \"Pittsburg/Bay Point\"],\n [38.0122, -121.9101, \"Pittsburg Center\"],\n [37.8530, -122.2700, \"Ashby\"],\n [37.8699, -122.2680, \"Downtown Berkeley\"],\n [37.8740, -122.2831, \"North Berkeley\"],\n [37.9253, -122.3171, \"El Cerrito del Norte\"],\n [37.9017, -122.2995, \"El Cerrito Plaza\"],\n [37.9371, -122.3531, \"Richmond\"],\n [37.7979, -122.2650, \"Lake Merritt\"],\n [37.7748, -122.2243, \"Fruitvale\"],\n [37.7539, -122.1977, \"Coliseum\"],\n [37.7132, -122.2124, \"Oakland Airport\"],\n [37.7021, -122.1610, \"San Leandro\"],\n [37.6970, -122.1263, \"Bay Fair\"],\n [37.6698, -122.0879, \"Hayward\"],\n [37.6344, -122.0578, \"South Hayward\"],\n [37.5912, -122.0175, \"Union City\"],\n [37.5573, -121.9763, \"Fremont\"],\n [37.5013, -121.9393, \"Warm Springs/South Fremont\"],\n [37.4007, -121.8733, \"Milpitas\"],\n [37.3685, -121.8840, \"Berryessa/North San Jose\"],\n [37.7019, -121.9001, \"Dublin/Pleasanton\"],\n [37.6994, -121.9283, \"West Dublin/Pleasanton\"],\n [37.6906, -122.0759, \"Castro Valley\"],\n [37.8289, -122.2678, \"MacArthur\"],\n [37.9253, -122.3171, \"El Cerrito del Norte\"],\n];\n\nconst CALTRAIN_STATIONS: Station[] = [\n [37.7764, -122.3953, \"San Francisco (4th & King)\"],\n [37.7574, -122.3920, \"22nd Street\"],\n [37.7108, -122.4017, \"Bayshore\"],\n [37.6570, -122.4059, \"South San Francisco\"],\n [37.6301, -122.4118, \"San Bruno\"],\n [37.5994, -122.3873, \"Millbrae\"],\n [37.5794, -122.3475, \"Burlingame\"],\n [37.5671, -122.3230, \"San Mateo\"],\n [37.5503, -122.2928, \"Hayward Park\"],\n [37.5371, -122.2869, \"Hillsdale\"],\n [37.5200, -122.2760, \"Belmont\"],\n [37.5074, -122.2591, \"San Carlos\"],\n [37.4852, -122.2318, \"Redwood City\"],\n [37.4553, -122.1824, \"Menlo Park\"],\n [37.4433, -122.1641, \"Palo Alto\"],\n [37.4290, -122.1430, \"California Ave\"],\n [37.4072, -122.1076, \"San Antonio\"],\n [37.3942, -122.0764, \"Mountain View\"],\n [37.3783, -122.0302, \"Sunnyvale\"],\n [37.3704, -121.9971, \"Lawrence\"],\n [37.3536, -121.9368, \"Santa Clara\"],\n [37.3413, -121.9165, \"College Park\"],\n [37.3299, -121.9023, \"San Jose Diridon\"],\n [37.3113, -121.8841, \"Tamien\"],\n [37.2621, -121.8487, \"Blossom Hill\"],\n [37.1323, -121.6504, \"Morgan Hill\"],\n [37.0875, -121.6101, \"San Martin\"],\n [37.0055, -121.5679, \"Gilroy\"],\n];\n\n// Muni Metro stops — all 5 lines: J-Church, K-Ingleside, L-Taraval, M-Ocean View, N-Judah.\n// Covers both underground stations and surface stops.\n// Coordinates are approximate (±100–200m); sufficient for 600m/1200m threshold scoring.\n// Last updated: added full N-Judah and L-Taraval surface runs to fix Inner/Outer Sunset venues.\nconst MUNI_METRO_STOPS: Station[] = [\n // ── Underground stations (Market St subway) ──────────────────────────────────\n [37.7794, -122.4136, \"Civic Center (Muni)\"],\n [37.7845, -122.4089, \"Powell (Muni)\"],\n [37.7894, -122.4012, \"Montgomery (Muni)\"],\n [37.7929, -122.3969, \"Embarcadero (Muni)\"],\n [37.7650, -122.4197, \"16th St (Muni)\"],\n [37.7524, -122.4183, \"24th St (Muni)\"],\n\n // ── J-Church underground ─────────────────────────────────────────────────────\n [37.7693, -122.4291, \"Church Station\"],\n [37.7639, -122.4502, \"Castro Station\"],\n\n // ── Twin Peaks / West Portal underground ─────────────────────────────────────\n [37.7450, -122.4591, \"Forest Hill\"],\n [37.7408, -122.4638, \"West Portal\"],\n\n // ── T-Third surface (Central Waterfront / Bayview) ───────────────────────────\n [37.7714, -122.3894, \"4th & King (T-Line)\"],\n [37.7642, -122.3894, \"22nd St (T-Line)\"],\n [37.7222, -122.3978, \"Cesar Chavez (T-Line)\"],\n [37.7083, -122.4025, \"Bayshore (T-Line)\"],\n\n // ── J-Church surface (Church St, south of Castro) ────────────────────────────\n // Exits tunnel at Castro, runs surface south through Noe Valley to Balboa Park.\n [37.7524, -122.4283, \"Church & 22nd St (J)\"],\n [37.7499, -122.4283, \"Church & 24th St (J)\"],\n [37.7474, -122.4283, \"Church & 26th St (J)\"],\n [37.7449, -122.4284, \"Church & 28th St (J)\"],\n [37.7424, -122.4290, \"Church & 30th St (J)\"],\n [37.7350, -122.4350, \"San Jose & 30th (J)\"],\n [37.7280, -122.4410, \"Randall & Sanchez (J)\"],\n\n // ── N-Judah surface (Judah St, west of Sunset Tunnel) ───────────────────────\n // Exits Sunset Tunnel near 9th Ave & Irving, runs west along Judah to Ocean Beach.\n // Each Outer Sunset avenue ≈ 115m apart; stops roughly every 2–4 avenues.\n [37.7656, -122.4571, \"Carl & Cole / Sunset Tunnel Portal (N)\"],\n [37.7641, -122.4635, \"Judah & 9th Ave (N)\"],\n [37.7638, -122.4670, \"Judah & 12th Ave (N)\"],\n [37.7636, -122.4704, \"Judah & 15th Ave (N)\"],\n [37.7633, -122.4750, \"Judah & 19th Ave (N)\"], // ← nearest to Game Parlour (17th Ave area)\n [37.7631, -122.4785, \"Judah & 22nd Ave (N)\"],\n [37.7629, -122.4819, \"Judah & 25th Ave (N)\"],\n [37.7626, -122.4877, \"Judah & 30th Ave (N)\"],\n [37.7622, -122.4946, \"Judah & 36th Ave (N)\"],\n [37.7619, -122.4992, \"Judah & 40th Ave (N)\"],\n [37.7615, -122.5061, \"Judah & 46th Ave (N)\"],\n [37.7612, -122.5090, \"Judah & Ocean Beach (N)\"],\n\n // ── L-Taraval surface (Taraval St, west of West Portal) ─────────────────────\n // Exits West Portal station, runs west along Taraval St to SF Zoo / Ocean Beach.\n [37.7420, -122.4704, \"Taraval & 15th Ave (L)\"],\n [37.7418, -122.4727, \"Taraval & 17th Ave (L)\"], // ← Versus Games (1714 Taraval)\n [37.7416, -122.4750, \"Taraval & 19th Ave (L)\"],\n [37.7413, -122.4785, \"Taraval & 22nd Ave (L)\"],\n [37.7411, -122.4808, \"Taraval & 24th Ave (L)\"],\n [37.7408, -122.4854, \"Taraval & 28th Ave (L)\"],\n [37.7403, -122.4877, \"Taraval & 30th Ave (L)\"],\n [37.7400, -122.4912, \"Taraval & 33rd Ave (L)\"],\n [37.7397, -122.4946, \"Taraval & 36th Ave (L)\"],\n [37.7389, -122.5038, \"Taraval & 44th Ave (L)\"],\n [37.7351, -122.5049, \"Taraval & SF Zoo (L)\"],\n\n // ── K-Ingleside surface (Ocean Ave, west of West Portal) ─────────────────────\n // Runs along Claremont Blvd then Ocean Ave toward Balboa Park BART.\n [37.7364, -122.4580, \"Claremont & Monterey (K)\"],\n [37.7295, -122.4555, \"Ocean & Junipero Serra (K)\"],\n [37.7262, -122.4533, \"Ocean & Lee (K)\"],\n [37.7240, -122.4511, \"Ocean & Phelan (K)\"],\n [37.7219, -122.4480, \"Ocean & Plymouth (K)\"],\n\n // ── M-Ocean View surface (19th Ave / Randolph St corridor) ──────────────────\n // Branches from West Portal toward Daly City via 19th Ave then Randolph St.\n [37.7290, -122.4750, \"19th Ave & Holloway (M)\"],\n [37.7230, -122.4750, \"19th Ave & Randolph (M)\"],\n [37.7150, -122.4761, \"19th Ave & Eucalyptus (M)\"],\n [37.7061, -122.4748, \"Geneva & Santos (M)\"],\n [37.7008, -122.4720, \"Geneva & Rolph (M)\"],\n];\n\n// Key VTA light rail stops in South Bay\nconst VTA_STOPS: Station[] = [\n [37.3328, -121.9020, \"Convention Center (VTA)\"],\n [37.3368, -121.8914, \"Japantown/Ayer (VTA)\"],\n [37.3234, -121.8828, \"Children's Discovery (VTA)\"],\n [37.3113, -121.8841, \"Tamien (VTA)\"],\n [37.3942, -122.0764, \"Mountain View (VTA)\"],\n [37.3783, -122.0302, \"Sunnyvale (VTA)\"],\n [37.3536, -121.9368, \"Santa Clara (VTA)\"],\n [37.4007, -121.8733, \"Milpitas (VTA)\"],\n [37.3685, -121.8840, \"Berryessa (VTA)\"],\n];\n\n// ── Transit scoring (pure math, no API calls) ──────────────────────────────────\n\nfunction haversineM(\n lat1: number,\n lon1: number,\n lat2: number,\n lon2: number,\n): number {\n const R = 6_371_000;\n const dLat = ((lat2 - lat1) * Math.PI) / 180;\n const dLon = ((lon2 - lon1) * Math.PI) / 180;\n const a = Math.sin(dLat / 2) ** 2 +\n Math.cos((lat1 * Math.PI) / 180) *\n Math.cos((lat2 * Math.PI) / 180) *\n Math.sin(dLon / 2) ** 2;\n return R * 2 * Math.atan2(Math.sqrt(a), Math.sqrt(1 - a));\n}\n\nfunction nearestStation(\n stations: Station[],\n lat: number,\n lon: number,\n): { dist: number; name: string } {\n let best = { dist: Infinity, name: \"\" };\n for (const [sLat, sLon, name] of stations) {\n const dist = haversineM(lat, lon, sLat, sLon);\n if (dist < best.dist) best = { dist, name };\n }\n return best;\n}\n\nfunction transitScore(lat: number, lon: number): string {\n if (!lat || !lon || isNaN(lat) || isNaN(lon)) {\n return \"❓ Unknown — no coordinates available\";\n }\n\n const bart = nearestStation(BART_STATIONS, lat, lon);\n const caltrain = nearestStation(CALTRAIN_STATIONS, lat, lon);\n const lightRail = nearestStation(\n [...MUNI_METRO_STOPS, ...VTA_STOPS],\n lat,\n lon,\n );\n\n if (bart.dist <= 800) {\n return `🚇🚇🚇🚇🚇 5/5 — ${bart.name} BART within 10 min walk (no transfers from SF)`;\n }\n if (bart.dist <= 1600) {\n return `🚇🚇🚇🚇🚌 4/5 — ${bart.name} BART nearby (~15 min walk or 1 bus)`;\n }\n if (caltrain.dist <= 600) {\n return `🚇🚇🚇🚌🚌 4/5 — ${caltrain.name} Caltrain within 8 min walk (1 transfer via Millbrae/4th St)`;\n }\n if (caltrain.dist <= 1500) {\n return `🚇🚇🚌🚌🚌 3/5 — ${caltrain.name} Caltrain nearby (1 transfer + walk)`;\n }\n if (lightRail.dist <= 600) {\n return `🚌🚌🚌🚌🚗 3/5 — ${lightRail.name} light rail within 8 min walk (1–2 transfers)`;\n }\n if (lightRail.dist <= 1200) {\n return `🚌🚌🚌🚗🚗 2/5 — ${lightRail.name} light rail within 15 min walk`;\n }\n if (bart.dist <= 4000) {\n return `🚌🚌🚗🚗🚗 2/5 — Bus to ${bart.name} BART (multiple transfers)`;\n }\n return \"🚗🚗🚗🚗🚗 1/5 — Drive recommended\";\n}\n\n// ── Cache (address only now — transit is instant) ──────────────────────────────\n\nasync function initCache(): Promise {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS location_cache (\n coord_key TEXT PRIMARY KEY,\n address TEXT NOT NULL DEFAULT '',\n transit TEXT NOT NULL DEFAULT '',\n cached_at TEXT NOT NULL\n )\n `);\n}\n\nasync function loadCache(\n keys: string[],\n): Promise> {\n if (!keys.length) return new Map();\n const placeholders = keys.map(() => \"?\").join(\",\");\n const cutoff = new Date(Date.now() - 60 * 86_400_000).toISOString();\n try {\n const result = await sqlite.execute({\n sql: `SELECT coord_key, address, transit FROM location_cache\n WHERE coord_key IN (${placeholders}) AND cached_at > ?`,\n args: [...keys, cutoff],\n });\n const map = new Map();\n for (const row of result.rows as any[]) {\n map.set(String(row[0]), {\n address: String(row[1]),\n transit: String(row[2]),\n });\n }\n return map;\n } catch {\n return new Map();\n }\n}\n\nasync function saveCache(\n coordKey: string,\n address: string,\n transit: string,\n): Promise {\n await sqlite.execute({\n sql: `INSERT INTO location_cache (coord_key, address, transit, cached_at)\n VALUES (?, ?, ?, ?)\n ON CONFLICT(coord_key) DO UPDATE SET\n address = excluded.address,\n transit = excluded.transit,\n cached_at = excluded.cached_at`,\n args: [coordKey, address, transit, new Date().toISOString()],\n });\n}\n\n// ── Nominatim reverse geocoding ────────────────────────────────────────────────\n\nasync function reverseGeocode(lat: number, lon: number): Promise {\n const controller = new AbortController();\n const timer = setTimeout(() => controller.abort(), 10_000);\n try {\n const res = await fetch(\n `https://nominatim.openstreetmap.org/reverse?lat=${lat}&lon=${lon}&format=json&addressdetails=1`,\n {\n headers: {\n \"User-Agent\": \"MTG-Calendar-Val/1.0 (val.town calendar feed)\",\n \"Accept-Language\": \"en-US,en\",\n },\n signal: controller.signal,\n },\n );\n clearTimeout(timer);\n if (!res.ok) throw new Error(`Nominatim HTTP ${res.status}`);\n const data = await res.json();\n const a = data?.address;\n if (!a) return data?.display_name ?? `${lat}, ${lon}`;\n const street = [a.house_number, a.road].filter(Boolean).join(\" \");\n const city = a.city ?? a.town ?? a.village ?? a.county ?? \"\";\n return [street, city, a.state, a.postcode].filter(Boolean).join(\", \");\n } catch (e: any) {\n clearTimeout(timer);\n throw new Error(e.name === \"AbortError\" ? \"Nominatim timeout\" : e.message);\n }\n}\n\nfunction sleep(ms: number): Promise {\n return new Promise((resolve) => setTimeout(resolve, ms));\n}\n\n// ── Location enrichment ────────────────────────────────────────────────────────\n// Transit scores are now computed locally — instant, no API needed.\n// Only Nominatim geocoding requires an external call (cached 60 days).\n\nasync function enrichLocations(\n events: any[],\n): Promise> {\n await initCache();\n\n const unique = new Map();\n for (const ev of events) {\n const key = `${ev.latitude},${ev.longitude}`;\n if (!unique.has(key)) unique.set(key, [ev.latitude, ev.longitude]);\n }\n\n const cache = await loadCache([...unique.keys()]);\n\n // Geocode missing addresses sequentially (Nominatim: 1 req/sec)\n const needsGeocode = [...unique.entries()].filter(\n ([key]) => !cache.get(key)?.address,\n );\n\n for (let i = 0; i < needsGeocode.length; i++) {\n const [key, [lat, lon]] = needsGeocode[i];\n let address = \"\";\n try {\n address = await reverseGeocode(lat, lon);\n } catch {\n address = `${lat}, ${lon}`;\n }\n // Transit is always computed locally — instant\n const transit = transitScore(lat, lon);\n cache.set(key, { address, transit });\n await saveCache(key, address, transit);\n if (i < needsGeocode.length - 1) await sleep(1100);\n }\n\n // For cached addresses, recompute transit score locally\n // (in case scoring logic has been updated since last cache write)\n for (const [key, [lat, lon]] of unique) {\n if (needsGeocode.some(([k]) => k === key)) continue; // already handled above\n const existing = cache.get(key);\n if (existing) {\n const freshTransit = transitScore(lat, lon);\n if (freshTransit !== existing.transit) {\n cache.set(key, { address: existing.address, transit: freshTransit });\n await saveCache(key, existing.address, freshTransit);\n }\n }\n }\n\n return cache;\n}\n\n// ── RSVPs ──────────────────────────────────────────────────────────────────────\n\nasync function getAllRSVPs(): Promise> {\n try {\n const result = await sqlite.execute(\n \"SELECT event_id, name FROM mtg_rsvps ORDER BY created_at ASC\",\n );\n const map = new Map();\n for (const row of result.rows as any[]) {\n const [eventId, name] = row;\n if (!map.has(eventId)) map.set(eventId, []);\n map.get(eventId)!.push(String(name));\n }\n return map;\n } catch {\n return new Map();\n }\n}\n\n// ── Main ───────────────────────────────────────────────────────────────────────\n\nexport default async function (req: Request): Promise {\n try {\n const res = await fetch(GRAPHQL_URL, {\n method: \"POST\",\n headers: FETCH_HEADERS,\n body: JSON.stringify(PAYLOAD),\n });\n if (!res.ok) {\n const body = await res.text();\n return new Response(`Upstream error ${res.status}: ${body}`, {\n status: 502,\n });\n }\n\n const json = await res.json();\n const raw: any[] = json?.data?.searchEvents?.events ?? [];\n const events = raw.filter((ev) =>\n ev.tags?.includes(\"regional_championship_qualifier\")\n );\n\n if (!events.length) {\n return new Response(\n `No RCQ events found. Raw:\\n${JSON.stringify(json, null, 2)}`,\n { status: 502 },\n );\n }\n\n const [locationMap, rsvpMap] = await Promise.all([\n enrichLocations(events),\n getAllRSVPs(),\n ]);\n\n return new Response(buildICS(events, locationMap, rsvpMap), {\n headers: {\n \"Content-Type\": \"text/calendar; charset=utf-8\",\n \"Content-Disposition\": 'inline; filename=\"mtg-rcq.ics\"',\n \"Cache-Control\": \"public, max-age=43200\",\n },\n });\n } catch (e: any) {\n return new Response(`Error: ${e.message ?? String(e)}`, { status: 502 });\n }\n}\n\n// ── ICS builder ────────────────────────────────────────────────────────────────\n\nfunction buildICS(\n events: any[],\n locationMap: Map,\n rsvpMap: Map,\n): string {\n const lines = [\n \"BEGIN:VCALENDAR\",\n \"VERSION:2.0\",\n \"PRODID:-//MTG RCQ Calendar//EN\",\n \"CALSCALE:GREGORIAN\",\n \"METHOD:PUBLISH\",\n \"X-WR-CALNAME:MTG RCQ Events (SF Bay Area)\",\n \"X-WR-TIMEZONE:America/Los_Angeles\",\n \"REFRESH-INTERVAL;VALUE=DURATION:P1D\",\n \"X-PUBLISHED-TTL:P1D\",\n ];\n\n for (const ev of events) {\n const format = inferFormat(ev.tags);\n const fee = ev.entryFee\n ? `$${(ev.entryFee.amount / 100).toFixed(0)}`\n : \"TBD\";\n const start = new Date(ev.scheduledStartTime);\n const end = new Date(start.getTime() + 4 * 60 * 60 * 1000);\n const coordKey = `${ev.latitude},${ev.longitude}`;\n const loc = locationMap.get(coordKey) ?? { address: \"\", transit: \"\" };\n const address = loc.address;\n const transit = loc.transit || transitScore(ev.latitude, ev.longitude);\n const orgName = ev.organization?.name ?? \"Unknown\";\n const location = address ? `${orgName}, ${address}` : orgName;\n const attendees = rsvpMap.get(ev.id) ?? [];\n const rsvpURL = `${RSVP_BASE_URL}/?event_id=${ev.id}`;\n const miles = ev.distance != null\n ? `${(ev.distance / 1609.344).toFixed(1)} mi from SF`\n : null;\n\n const desc = [\n `Format: ${format}`,\n `Entry Fee: ${fee}`,\n miles ? `Distance: ${miles}` : null,\n `Transit: ${transit}`,\n ev.capacity ? `Capacity: ${ev.capacity} players` : null,\n ev.hasTop8 ? \"Top 8 Cut\" : null,\n address ? `Address: ${address}` : null,\n attendees.length\n ? `\\nGoing (${attendees.length}): ${attendees.join(\", \")}`\n : \"\\nGoing: No RSVPs yet\",\n `RSVP: ${rsvpURL}`,\n ev.description?.trim() ? `\\n${ev.description.trim()}` : null,\n `\\nOrganizer: ${orgName}`,\n ev.emailAddress ? `Email: ${ev.emailAddress}` : null,\n ev.phoneNumber ? `Phone: ${ev.phoneNumber}` : null,\n ]\n .filter(Boolean)\n .join(\"\\n\");\n\n lines.push(\n \"BEGIN:VEVENT\",\n `UID:${ev.id}@mtg-rcq-valtown`,\n `DTSTART:${toICS(start)}`,\n `DTEND:${toICS(end)}`,\n `SUMMARY:MTG RCQ – ${orgName} (${format} · ${fee} · ${miles ?? \"? mi\"})`,\n `LOCATION:${esc(location)}`,\n `URL:${rsvpURL}`,\n `DESCRIPTION:${esc(desc)}`,\n `GEO:${ev.latitude};${ev.longitude}`,\n \"END:VEVENT\",\n );\n }\n\n lines.push(\"END:VCALENDAR\");\n return lines.join(\"\\r\\n\");\n}\n\nfunction inferFormat(tags: string[]): string {\n if (tags?.includes(\"modern\")) return \"Modern\";\n if (tags?.includes(\"standard\")) return \"Standard\";\n if (tags?.includes(\"pioneer\")) return \"Pioneer\";\n if (tags?.includes(\"legacy\")) return \"Legacy\";\n if (tags?.includes(\"sealed_deck\")) return \"Sealed\";\n if (tags?.includes(\"draft\")) return \"Draft\";\n return \"Constructed\";\n}\n\nfunction toICS(d: Date): string {\n return d.toISOString().replace(/[-:.]/g, \"\").slice(0, 15) + \"Z\";\n}\n\nfunction esc(s: string): string {\n return s\n .replace(/\\\\/g, \"\\\\\\\\\")\n .replace(/;/g, \"\\\\;\")\n .replace(/,/g, \"\\\\,\")\n .replace(/\\n/g, \"\\\\n\");\n}","deleted","label","children",[],"path",[41],{"_39":40,"_13":41,"_42":43,"_44":-5,"_45":46,"_47":48,"_49":34,"_50":64,"_16":52,"_53":54,"_55":56,"_57":36,"_58":-5,"_61":65},["D",1788198759921],[41],"pulls",0,"branches",1,"forks","envVars",{"_75":69,"_77":67},"connections",{"_75":67,"_76":67},"count","unfilledCount","emptyCount","33327bfa-3830-11f1-aade-42b51c65c3df",["D",1776191509372],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","acff0871-bb4d-4a00-8272-6b547c3a72e7","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","019d8d43-30d0-73f0-8c83-79ffd38902c8","tursoName","33327bfa383011f1aade42b51c65c3df","tursoHostname","33327bfa383011f1aade42b51c65c3df-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789476033740],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_134":130},"org",{"_11":12,"_128":-5,"_129":130,"_87":88,"_131":132,"_133":36},"branch",{"_16":48,"_13":119,"_39":46,"_120":78,"_121":-5,"_122":-5,"_123":-5,"_124":-5,"_125":-5,"_126":14,"_127":12},"isOwned","main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_39":78,"_13":14,"_50":181,"_80":-5,"_81":36,"_82":83,"_84":83,"_85":-5,"_86":-5,"_87":88,"_89":-5,"_90":36,"_91":-5,"_92":-5,"_93":67,"_94":95,"_96":97,"_98":99,"_100":182,"_102":-5,"_103":104,"_105":104,"_106":107,"_108":107,"_109":107,"_110":104,"_111":104,"_112":183,"_114":184,"_116":185,"_118":36},"tree",[178],[178],{"_66":67,"_68":69,"_70":69,"_71":176,"_73":177},[174],"file","upstreamProject","upstreamBranch","emptyEnvVars","flags",[153,154,155,156,157,158,159,160,161,162],"hasHttpFiles","grants","orgs","customDomains",{},{"_39":173,"_164":-5},{"_39":172,"_164":-5},{"_39":171,"_164":-5},{"_39":170,"_164":-5},{"_39":169,"_164":-5},{"_39":168,"_164":-5},{"_39":167,"_164":-5},{"_39":166,"_164":-5},{"_39":165,"_164":-5},{"_39":163,"_164":-5},"527285b4-d9b2-4b68-b284-96bc02beaadc","reporterId","c45541ed-4157-4355-b6f2-7f4393589cc6","ea337488-dee8-450f-8727-61ed47c70975","1ef51477-61ff-4ab9-9b18-2fc8270b9a26","e98ad32d-6dfc-404e-a5bc-95955bd89077","98c99c65-3ccf-44f7-9a30-aff7efda1063","b76a51ac-73a0-485a-a76f-e2d0cd40272f","f860d8a4-828a-469b-8387-e22b8d5a055b","2669d7e8-fb6e-4644-80f6-f43bf1cbd8a9","e3f353de-33da-4a10-9f78-a92617db80bc",{"_39":40,"_13":41,"_42":43,"_44":-5,"_45":46,"_47":48,"_49":34,"_50":64,"_16":52,"_53":54,"_55":56,"_57":36,"_58":-5,"_61":175},[41],{"_75":69,"_77":67},{"_75":67,"_76":67},{"_39":40,"_13":41,"_42":43,"_44":-5,"_45":46,"_47":48,"_49":34,"_50":51,"_16":52,"_53":54,"_55":56,"_57":36,"_58":-5,"_59":179,"_61":180},[],[41],["D",1776191509372],["D",1789476033740],{"_11":12,"_134":130},{"_11":12,"_128":-5,"_129":130,"_87":88,"_131":132,"_133":36},{"_16":48,"_13":119,"_39":46,"_120":78,"_121":-5,"_122":-5,"_123":-5,"_124":-5,"_125":-5,"_126":14,"_127":12},"ctx",{"_112":-5,"_150":219,"_220":221,"_222":223,"_224":36,"_225":36,"_226":36,"_227":34,"_228":-5,"_229":-7,"_230":-7,"_231":67,"_232":36,"_233":36,"_234":-5,"_235":36,"_236":36,"_237":36,"_238":-5},"ENV",{"_190":191,"_192":193,"_194":119,"_195":196,"_197":198,"_199":200,"_201":202,"_203":204,"_205":206,"_207":208,"_209":210,"_211":212,"_213":214,"_215":216,"_217":218},"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"]