[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_297":298,"_299":300},"routes/_app.x.$handle.$name",{"_94":93,"_32":45,"_102":84,"_27":103,"_13":14,"_104":-5,"_11":105,"_106":107,"_108":109,"_110":111,"_112":113,"_20":-5,"_114":-5,"_115":-5,"_116":25,"_117":118,"_119":120,"_121":-5,"_122":-5,"_123":124},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":-5,"_56":25,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":77,"_78":79,"_80":81,"_82":25},"version",25,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","fu84s409985ss54svsq995f492f8e35087.ts","latestPath","fileId","54603992-ff97-11f0-8280-42dde27851f2","name","fileType","http","content","import { connect } from \"npm:@tursodatabase/serverless\";\n\nexport default async function(req: Request): Promise {\n // Read secrets from x-secrets header\n const __secrets = JSON.parse(req.headers.get('x-secrets') || '{}');\n\n if (req.method !== 'POST') {\n return Response.json({ error: 'Method not allowed' }, { status: 405 });\n }\n\n const userUuid = req.headers.get(\"x-user-uuid\");\n if (!userUuid) {\n return Response.json({ error: 'Unauthorized' }, { status: 401 });\n }\n\n try {\n const body = await req.json();\n const { display_name, avatar_url, device_id, device_type, model, os_version } = body;\n\n const conn = connect({\n url: req.headers.get(\"x-database-url\")!,\n authToken: req.headers.get(\"x-database-token\")!\n });\n\n const now = Math.floor(Date.now() / 1000);\n\n // Get user's favorites\n const favStmt = conn.prepare(\"SELECT channel_id FROM user_favorites WHERE user_uuid = ?\");\n const favs = await favStmt.all([userUuid]);\n const favorites = favs.map((f: any) => f.channel_id);\n\n // Get user's recent channels\n const recentStmt = conn.prepare(`\n SELECT channel_id FROM user_recent_channels \n WHERE user_uuid = ? \n ORDER BY last_watched DESC \n LIMIT 10\n `);\n const recents = await recentStmt.all([userUuid]);\n const recentchannels = recents.map((r: any) => r.channel_id);\n\n // Return user profile with synced data\n return Response.json({\n id: userUuid,\n email: req.headers.get(\"x-user-email\") || null,\n display_name: display_name || null,\n avatar_url: avatar_url || null,\n maxconcurrentsessions: 3,\n favorites,\n recentchannels\n });\n\n } catch (error) {\n console.error('Error in /me/sync:', error);\n return Response.json({ error: 'Internal server error' }, { status: 500 });\n }\n}\n","import { connect } from \"npm:@tursodatabase/serverless\";\n\nexport default async function(req: Request): Promise {\n // Read secrets from x-secrets header\n const __secrets = JSON.parse(req.headers.get('x-secrets') || '{}');\n\n if (req.method !== 'POST') {\n return Response.json({ error: 'Method not allowed' }, { status: 405 });\n }\n\n const userUuid = req.headers.get(\"x-user-uuid\");\n if (!userUuid) {\n return Response.json({ error: 'Unauthorized' }, { status: 401 });\n }\n\n try {\n const body = await req.json();\n const { display_name, avatar_url, device_id, device_type, model, os_version } = body;\n\n const conn = connect({\n url: req.headers.get(\"x-database-url\")!,\n authToken: req.headers.get(\"x-database-token\")!\n });\n\n const now = Math.floor(Date.now() / 1000);\n\n // Get user's favorites\n const favStmt = conn.prepare(\"SELECT channel_id FROM user_favorites WHERE user_uuid = ?\");\n const favs = await favStmt.all([userUuid]);\n const favorites = favs.map((f: any) => f.channel_id);\n\n // Get user's recent channels\n const recentStmt = conn.prepare(`\n SELECT channel_id FROM user_recent_channels \n WHERE user_uuid = ? \n ORDER BY last_watched DESC \n LIMIT 10\n `);\n const recents = await recentStmt.all([userUuid]);\n const recentchannels = recents.map((r: any) => r.channel_id);\n\n // Return user profile with synced data\n return Response.json({\n id: userUuid,\n email: req.headers.get(\"x-user-email\") || null,\n display_name: display_name || null,\n avatar_url: avatar_url || null,\n maxconcurrentsessions: 3,\n favorites,\n recentchannels\n });\n\n } catch (error) {\n console.error('Error in me sync:', error);\n return Response.json({ error: 'Internal server error' }, { status: 500 });\n }\n}","createdAt",["D",1770139405073],"branchVersion","branchId","4eafb054-ff97-11f0-b293-42dde27851f2","id","4eaf664e-ff97-11f0-b293-42dde27851f2","tef928st6v04414et18ffe59872ss3fq31",["D",1769968577371],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","0199d9f9-8fb9-705d-a1be-150ee5ea0145","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","0199d9f9-8fb9-705d-a1be-18ed6d1d02d7","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_94":93,"_101":97},"org",{"_94":93,"_95":-5,"_96":97,"_18":54,"_98":99,"_100":25},"branch",{"_13":83,"_32":84,"_43":42,"_85":44,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":45,"_92":93},"isOwned",28,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","kliv","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzMzeW9MdTZSSlZXdUFyNHFTckJtSlg1b3paYiJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":293,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":-5,"_56":25,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":294,"_78":295,"_80":296,"_82":25},"tree",[240,241,242,243,244,245,246,247,248,249,250,251,252],"files",[240,241,242,243,244,245,246,247,248,249,250,251,252],"counts",{"_230":60,"_231":175,"_232":60,"_233":234,"_235":236},"contents",[125,126,127,128,129,130,131,132,133,134,135,136,137],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_43":223,"_32":224,"_30":225,"_141":-5,"_41":42,"_40":226,"_143":120,"_38":227,"_13":60,"_33":34,"_35":228,"_24":25,"_146":-5,"_27":229},{"_43":216,"_32":217,"_30":218,"_141":-5,"_41":42,"_40":219,"_143":120,"_38":220,"_13":175,"_33":34,"_35":221,"_24":25,"_146":-5,"_27":222},{"_43":209,"_32":210,"_30":211,"_141":-5,"_41":42,"_40":212,"_143":120,"_38":213,"_13":60,"_33":34,"_35":214,"_24":25,"_146":-5,"_27":215},{"_43":202,"_32":203,"_30":204,"_141":-5,"_41":42,"_40":205,"_143":120,"_38":206,"_13":175,"_33":34,"_35":207,"_24":25,"_146":-5,"_27":208},{"_43":195,"_32":196,"_30":197,"_141":-5,"_41":42,"_40":198,"_143":25,"_38":199,"_13":175,"_33":34,"_35":200,"_24":25,"_146":-5,"_27":201},{"_43":192,"_32":28,"_30":31,"_141":-5,"_41":42,"_40":14,"_143":120,"_38":193,"_13":175,"_33":34,"_35":37,"_24":25,"_146":-5,"_27":194},{"_43":185,"_32":186,"_30":187,"_141":-5,"_41":42,"_40":188,"_143":120,"_38":189,"_13":175,"_33":34,"_35":190,"_24":25,"_146":-5,"_27":191},{"_43":178,"_32":179,"_30":180,"_141":-5,"_41":42,"_40":181,"_143":25,"_38":182,"_13":153,"_33":34,"_35":183,"_24":25,"_146":-5,"_27":184},{"_43":170,"_32":171,"_30":172,"_141":-5,"_41":42,"_40":173,"_143":120,"_38":174,"_13":175,"_33":34,"_35":176,"_24":25,"_146":-5,"_27":177},{"_43":163,"_32":164,"_30":165,"_141":-5,"_41":42,"_40":166,"_143":25,"_38":167,"_13":60,"_33":34,"_35":168,"_24":25,"_146":-5,"_27":169},{"_43":156,"_32":157,"_30":158,"_141":-5,"_41":42,"_40":159,"_143":120,"_38":160,"_13":153,"_33":34,"_35":161,"_24":25,"_146":-5,"_27":162},{"_43":148,"_32":149,"_30":150,"_141":-5,"_41":42,"_40":151,"_143":120,"_38":152,"_13":153,"_33":34,"_35":154,"_24":25,"_146":-5,"_27":155},{"_43":138,"_32":139,"_30":140,"_141":-5,"_41":42,"_40":142,"_143":120,"_38":144,"_13":60,"_33":34,"_35":145,"_24":25,"_146":-5,"_27":147},"3355030a-ff9b-11f0-88d7-42dde27851f2","futef5set04160428t8913fv4q067f58t3.ts","335503b4-ff9b-11f0-88d7-42dde27851f2","parentId",11,"latest",["D",1769970249455],"// Edge function to import channels from iptv-org GitHub repository\nexport default async function(req: Request): Promise {\n // Read secrets from x-secrets header\n const __secrets = JSON.parse(req.headers.get('x-secrets') || '{}');\n\n try {\n const { category, limit } = await req.json();\n\n // iptv-org provides index.m3u files with channel listings\n const baseUrl = 'https://raw.githubusercontent.com/iptv-org/iptv/master';\n\n // Fetch the main index file\n const indexResponse = await fetch(`${baseUrl}/index.m3u`);\n if (!indexResponse.ok) {\n throw new Error('Failed to fetch iptv-org index');\n }\n\n const m3uContent = await indexResponse.text();\n const channels = parseM3U(m3uContent, category, limit);\n\n return Response.json({\n success: true,\n channels,\n count: channels.length,\n source: 'iptv-org'\n });\n\n } catch (error) {\n return Response.json({\n success: false,\n error: error.message\n }, { status: 500 });\n }\n}\n\nfunction parseM3U(content: string, category?: string, limit?: number) {\n const lines = content.split('\\n');\n const channels: any[] = [];\n let currentChannel: any = null;\n\n for (let i = 0; i < lines.length; i++) {\n const line = lines[i].trim();\n\n if (line.startsWith('#EXTINF:')) {\n const info = parseExtInf(line);\n \n // Filter by category if specified\n if (category && info.group !== category) {\n currentChannel = null;\n continue;\n }\n\n currentChannel = {\n id: generateChannelId(info.name, info.group),\n name: info.name,\n logo: info.logo || '',\n category: info.group || 'Entertainment',\n stream_url: ''\n };\n } else if (line.startsWith('http') && currentChannel) {\n currentChannel.stream_url = line;\n channels.push(currentChannel);\n \n if (limit && channels.length >= limit) {\n break;\n }\n \n currentChannel = null;\n }\n }\n\n return channels;\n}\n\nfunction parseExtInf(line: string) {\n const parts = line.split(',');\n const name = parts[parts.length - 1]?.trim() || 'Unknown Channel';\n \n const logoMatch = line.match(/tvg-logo=\"([^\"]*)\"/);\n const groupMatch = line.match(/group-title=\"([^\"]*)\"/);\n \n return {\n name,\n logo: logoMatch?.[1] || '',\n group: groupMatch?.[1] || 'Entertainment'\n };\n}\n\nfunction generateChannelId(name: string, category: string): string {\n const prefix = category.toLowerCase().replace(/\\s+/g, '-').substring(0, 3);\n const suffix = name.toLowerCase().replace(/[^a-z0-9]/g, '').substring(0, 8);\n return `${prefix}-${suffix}`;\n}","label",[139],"ee661cc6-0124-11f1-bf69-42dde27851f2","fut0qs6v95f9e0445qqq7q9q38e28qe872.ts","5153e28a-ff97-11f0-be3e-42dde27851f2",22,["D",1770139355505],2,"import { connect } from \"npm:@tursodatabase/serverless\";\n\nexport default async function(req: Request): Promise {\n // Read secrets from x-secrets header\n const __secrets = JSON.parse(req.headers.get('x-secrets') || '{}');\n\n const url = new URL(req.url);\n const pathParts = url.pathname.split('/').filter(Boolean);\n \n // Path is /api/v2/function/v1-epg or /api/v2/function/v1-epg/now\n // pathParts[0-2] are: api, v2, function\n // pathParts[3] is function name (v1-epg)\n // pathParts[4] (if exists) is the operation (e.g., 'now')\n \n const functionName = pathParts[3];\n const isNow = pathParts[4] === 'now';\n const channelId = url.searchParams.get('channel_id') || url.searchParams.get('channelid');\n \n if (functionName !== 'v1-epg') {\n return Response.json({ error: 'Invalid route' }, { status: 404 });\n }\n \n if (req.method !== 'GET') {\n return Response.json({ error: 'Method not allowed' }, { status: 405 });\n }\n\n const conn = connect({\n url: req.headers.get(\"x-database-url\")!,\n authToken: req.headers.get(\"x-database-token\")!\n });\n\n try {\n const now = Math.floor(Date.now() / 1000); // Unix timestamp in seconds\n \n if (isNow) {\n // GET /api/v2/function/v1-epg/now - Get currently playing programs\n let query = `\n SELECT c.id as channelid, p.id as programid, p.title, p.start_time, p.end_time\n FROM channels c\n LEFT JOIN epg_programs p ON c.id = p.channel_id\n WHERE c.enabled = 1 \n AND p.start_time <= ? \n AND p.end_time > ?\n ORDER BY c.category, c.name\n `;\n const stmt = conn.prepare(query);\n const programs = await stmt.all([now, now]);\n \n return Response.json(programs.map((p: any) => ({\n channelid: p.channelid,\n programid: p.programid,\n title: p.title,\n start: new Date(p.start_time * 1000).toISOString(),\n end: new Date(p.end_time * 1000).toISOString()\n })));\n } else {\n // GET /api/v2/function/v1-epg?channel_id={id}\n if (!channelId) {\n return Response.json({ error: 'channel_id parameter required' }, { status: 400 });\n }\n \n const stmt = conn.prepare(`\n SELECT * FROM epg_programs \n WHERE channel_id = ? AND end_time > ?\n ORDER BY start_time\n `);\n const programs = await stmt.all([channelId, now]);\n \n return Response.json(programs.map((p: any) => ({\n id: p.id,\n channel_id: p.channel_id,\n title: p.title,\n description: p.description,\n image_url: p.image_url,\n start: new Date(p.start_time * 1000).toISOString(),\n end: new Date(p.end_time * 1000).toISOString()\n })));\n }\n } catch (error) {\n console.error('Error fetching EPG:', error);\n return Response.json({ error: 'Internal server error' }, { status: 500 });\n }\n}",[149],"e6f31962-0124-11f1-8be1-42dde27851f2","fus29sf2vs16sv4q779e96fe6f847783e0.ts","5fdf56f4-ff97-11f0-84fc-42dde27851f2",21,["D",1770139343013],"import { connect } from \"npm:@tursodatabase/serverless\";\n\nexport default async function(req: Request): Promise {\n // Read secrets from x-secrets header\n const __secrets = JSON.parse(req.headers.get('x-secrets') || '{}');\n\n const url = new URL(req.url);\n const pathParts = url.pathname.split('/').filter(Boolean);\n \n // Path is /api/v2/function/v1-recommendations\n // pathParts[0-2] are: api, v2, function\n // pathParts[3] is function name (v1-recommendations)\n \n const functionName = pathParts[3];\n \n if (functionName !== 'v1-recommendations') {\n return Response.json({ error: 'Invalid route' }, { status: 404 });\n }\n \n if (req.method !== 'GET') {\n return Response.json({ error: 'Method not allowed' }, { status: 405 });\n }\n\n const limit = parseInt(url.searchParams.get('limit') || '10');\n const userUuid = req.headers.get(\"x-user-uuid\");\n\n const conn = connect({\n url: req.headers.get(\"x-database-url\")!,\n authToken: req.headers.get(\"x-database-token\")!\n });\n\n try {\n // For anonymous users, return popular/random channels\n if (!userUuid) {\n const popularStmt = conn.prepare(`\n SELECT id as channelid, 0.5 as score FROM channels \n WHERE enabled = 1 \n ORDER BY RANDOM()\n LIMIT ?\n `);\n const popular = await popularStmt.all([limit]);\n return Response.json(popular.map((p: any) => ({ channelid: p.channelid, score: p.score })));\n }\n \n // For authenticated users, get recommendations based on favorites\n const stmt = conn.prepare(`\n SELECT c.id as channelid, COUNT(f.channel_id) as score\n FROM channels c\n INNER JOIN user_favorites f ON f.user_uuid = ? AND c.category = (\n SELECT c2.category FROM channels c2\n INNER JOIN user_favorites f2 ON c2.id = f2.channel_id\n WHERE f2.user_uuid = ?\n GROUP BY c2.category\n ORDER BY COUNT(*) DESC\n LIMIT 1\n )\n WHERE c.id NOT IN (SELECT channel_id FROM user_favorites WHERE user_uuid = ?)\n AND c.enabled = 1\n GROUP BY c.id\n ORDER BY score DESC\n LIMIT ?\n `);\n \n const recommendations = await stmt.all([userUuid, userUuid, userUuid, limit]);\n \n // If no recommendations based on favorites, return popular channels\n if (recommendations.length === 0) {\n const popularStmt = conn.prepare(`\n SELECT id as channelid, 0.5 as score FROM channels \n WHERE enabled = 1 \n ORDER BY RANDOM()\n LIMIT ?\n `);\n const popular = await popularStmt.all([limit]);\n return Response.json(popular.map((p: any) => ({ channelid: p.channelid, score: p.score })));\n }\n \n return Response.json(recommendations.map((r: any) => ({ channelid: r.channelid, score: r.score })));\n\n } catch (error) {\n console.error('Error in recommendations:', error);\n return Response.json({ error: 'Internal server error' }, { status: 500 });\n }\n}",[157],"968a1cd4-ff97-11f0-a05e-42dde27851f2","fuq759s51eteff437es1v5f183vtse4s6v.ts","968a1da6-ff97-11f0-a05e-42dde27851f2",10,["D",1769968697912],"import { connect } from \"npm:@tursodatabase/serverless\";\n\nexport default async function(req: Request): Promise {\n // Read secrets from x-secrets header\n const __secrets = JSON.parse(req.headers.get('x-secrets') || '{}');\n\n const userUuid = req.headers.get(\"x-user-uuid\");\n if (!userUuid) {\n return Response.json({ error: 'Unauthorized' }, { status: 401 });\n }\n\n if (req.method !== 'POST') {\n return Response.json({ error: 'Method not allowed' }, { status: 405 });\n }\n\n try {\n const body = await req.json();\n const { channelid, event_type, devicetype, metadata } = body;\n\n if (!channelid || !event_type) {\n return Response.json({ error: 'channelid and event_type required' }, { status: 400 });\n }\n\n const conn = connect({\n url: req.headers.get(\"x-database-url\")!,\n authToken: req.headers.get(\"x-database-token\")!\n });\n\n const now = Math.floor(Date.now() / 1000);\n const eventId = crypto.randomUUID();\n\n // Log playback event with _created_by\n const stmt = conn.prepare(`\n INSERT INTO playback_events (id, user_uuid, channel_id, event_type, device_type, timestamp, metadata, _created_by, _created_at, _updated_at)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n `);\n await stmt.run([\n eventId,\n userUuid,\n channelid,\n event_type,\n devicetype || null,\n now,\n metadata ? JSON.stringify(metadata) : null,\n userUuid,\n now,\n now\n ]);\n\n // Log to platform for analytics\n const sdkUrl = req.headers.get(\"x-sdk-url\");\n if (sdkUrl) {\n try {\n const { PlatformClient } = await import(sdkUrl);\n const platform = new PlatformClient(\n req.headers.get(\"x-platform-token\"),\n req.headers.get(\"x-api-base-url\")\n );\n await platform.log('info', 'Playback event', { channelid, event_type, devicetype });\n } catch (logError) {\n // Ignore logging errors\n }\n }\n\n return Response.json({ status: 'logged' });\n\n } catch (error) {\n console.error('Error in /ingest/playback:', error);\n return Response.json({ error: 'Internal server error' }, { status: 500 });\n }\n}\n",[164],"8ffed8f6-ff9b-11f0-8ab8-42dde27851f2","fuete0fq86132346etq2v9742s8qs8se10.ts","6aa8f6e0-ff9b-11f0-8556-42dde27851f2",13,["D",1769970404904],1,"// Public endpoint to seed channels with curated IPTV list\n// Returns channels without requiring authentication\nimport { connect } from \"npm:@tursodatabase/serverless\";\n\nexport default async function(req: Request): Promise {\n // Read secrets from x-secrets header\n const __secrets = JSON.parse(req.headers.get('x-secrets') || '{}');\n\n // Handle OPTIONS for CORS\n if (req.method === 'OPTIONS') {\n return Response.json({}, {\n headers: {\n 'Access-Control-Allow-Origin': '*',\n 'Access-Control-Allow-Methods': 'GET, POST, OPTIONS'\n }\n });\n }\n\n try {\n const conn = connect({\n url: req.headers.get(\"x-database-url\")!,\n authToken: req.headers.get(\"x-database-token\")!\n });\n\n // Check if channels already exist\n const countStmt = conn.prepare(\"SELECT COUNT(*) as count FROM channels\");\n const { count } = await countStmt.get();\n\n if (count > 0) {\n // Return existing channels count\n const listStmt = conn.prepare(\"SELECT id, name, logo_url as logo, category FROM channels WHERE enabled = 1 ORDER BY category, name\");\n const channels = await listStmt.all();\n \n return Response.json({\n success: true,\n message: \"Channels already exist\",\n count,\n channels: channels.map((c: any) => ({\n id: c.id,\n name: c.name,\n logo: c.logo,\n category: c.category\n }))\n });\n }\n\n // Curated list of popular free IPTV channels\n const curatedChannels = [\n // Sports\n ['ch_spo-espn3538', 'ESPN', 'https://upload.wikimedia.org/wikipedia/commons/thumb/2/2f/ESPN_wordmark_%282019%29.svg/512px-ESPN_wordmark_%282019%29.svg.png', 'Sports', 'https://amg00750-espn3-amg00750c2-firetv-us-4067.playouts.now.amagi.tv/playlist.m3u8'],\n ['ch_spo-foxsport', 'Fox Sports', 'https://upload.wikimedia.org/wikipedia/en/thumb/6/67/Fox_Sports_2021.svg/512px-Fox_Sports_2021.svg.png', 'Sports', 'https://mon01.chatribble.net/live/fssw.flac.m3u8'],\n ['ch_spo-nbcsport', 'NBC Sports', 'https://upload.wikimedia.org/wikipedia/commons/thumb/e/e5/NBC_Sports_logo.svg/512px-NBC_Sports_logo.svg.png', 'Sports', 'https://amg00366-nbcsportsonamagi-amg00366c1-roku-us-8465.playouts.now.amagi.tv/playlist.m3u8'],\n ['ch_spo-beinspor', 'BeIN Sports', 'https://upload.wikimedia.org/wikipedia/commons/thumb/4/41/BeIN_Sports_logo.svg/512px-BeIN_Sports_logo.svg.png', 'Sports', 'https://d3d0je5h3kguxw.cloudfront.net/live/ds2rbr/manifest.m3u8'],\n \n // News\n ['ch_new-cnn', 'CNN', 'https://upload.wikimedia.org/wikipedia/commons/thumb/b/b1/CNN.svg/512px-CNN.svg.png', 'News', 'https://cnn-cnninternational-1-eu.rakuten.wurl.tv/playlist.m3u8'],\n ['ch_new-bbcnews', 'BBC News', 'https://upload.wikimedia.org/wikipedia/en/thumb/3/39/BBC_News_2019.svg/512px-BBC_News_2019.svg.png', 'News', 'https://amg00383-bbcnews-amg00383c2-samsunguk-us-3139.playouts.now.amagi.tv/playlist.m3u8'],\n ['ch_new-skynews', 'Sky News', 'https://upload.wikimedia.org/wikipedia/en/thumb/2/2f/Sky_News_2019.svg/512px-Sky_News_2019.svg.png', 'News', 'https://amg00384-skynews-amg00384c2-samsunguk-us-3857.playouts.now.amagi.tv/playlist.m3u8'],\n ['ch_new-msnbc', 'MSNBC', 'https://upload.wikimedia.org/wikipedia/commons/thumb/c/c6/MSNBC_logo_%282021%29.svg/512px-MSNBC_logo_%282021%29.svg.png', 'News', 'https://amg00342-msnbc-amg00342c2-roku-us-9065.playouts.now.amagi.tv/playlist.m3u8'],\n ['ch_new-cnbc', 'CNBC', 'https://upload.wikimedia.org/wikipedia/commons/thumb/e/e3/CNBC_logo.svg/512px-CNBC_logo.svg.png', 'News', 'https://amg00329-cnbcworldwide-amg00329c2-vizio-us-6359.playouts.now.amagi.tv/playlist.m3u8'],\n \n // Movies\n ['ch_mov-hbo', 'HBO', 'https://upload.wikimedia.org/wikipedia/commons/thumb/1/17/HBO-Logo.svg/512px-HBO-Logo.svg.png', 'Movies', 'https://fl1.moveonjoy.com/HBO/index.m3u8'],\n ['ch_mov-amc', 'AMC', 'https://upload.wikimedia.org/wikipedia/commons/thumb/3/34/AMC_logo_2019.svg/512px-AMC_logo_2019.svg.png', 'Movies', 'https://fl1.moveonjoy.com/AMC_NETWORK/index.m3u8'],\n ['ch_mov-tnt', 'TNT', 'https://upload.wikimedia.org/wikipedia/commons/thumb/6/6d/TNT_%282016%29.svg/512px-TNT_%282016%29.svg.png', 'Movies', 'https://fl1.moveonjoy.com/TNT/index.m3u8'],\n ['ch_mov-tbs', 'TBS', 'https://upload.wikimedia.org/wikipedia/commons/thumb/6/6e/TBS_2016.svg/512px-TBS_2016.svg.png', 'Movies', 'https://fl1.moveonjoy.com/TBS/index.m3u8'],\n ['ch_mov-fx', 'FX', 'https://upload.wikimedia.org/wikipedia/commons/thumb/9/9e/FX_2022.svg/512px-FX_2022.svg.png', 'Movies', 'https://fl1.moveonjoy.com/FX/index.m3u8'],\n \n // Kids\n ['ch_kid-nick', 'Nickelodeon', 'https://upload.wikimedia.org/wikipedia/commons/thumb/5/50/Nickelodeon_2009_logo.svg/512px-Nickelodeon_2009_logo.svg.png', 'Kids', 'https://fl1.moveonjoy.com/NICK/index.m3u8'],\n ['ch_kid-cartoon', 'Cartoon Network', 'https://upload.wikimedia.org/wikipedia/commons/thumb/8/80/Cartoon_Network_2010_logo.svg/512px-Cartoon_Network_2010_logo.svg.png', 'Kids', 'https://fl1.moveonjoy.com/CARTOON_NETWORK/index.m3u8'],\n ['ch_kid-disney', 'Disney Channel', 'https://upload.wikimedia.org/wikipedia/commons/thumb/a/a8/Disney_Channel_logo_%282019%29.svg/512px-Disney_Channel_logo_%282019%29.svg.png', 'Kids', 'https://fl1.moveonjoy.com/DISNEY/index.m3u8'],\n ['ch_kid-disneyjr', 'Disney Junior', 'https://upload.wikimedia.org/wikipedia/commons/thumb/b/b8/Disney_Junior_%282019%29.svg/512px-Disney_Junior_%282019%29.svg.png', 'Kids', 'https://fl1.moveonjoy.com/DISNEY_JR/index.m3u8'],\n ['ch_kid-nickjr', 'Nick Jr.', 'https://upload.wikimedia.org/wikipedia/commons/thumb/4/43/Nick_Jr._2018.svg/512px-Nick_Jr._2018.svg.png', 'Kids', 'https://fl1.moveonjoy.com/NICK_JR/index.m3u8'],\n \n // Music\n ['ch_mus-mtv', 'MTV', 'https://upload.wikimedia.org/wikipedia/commons/thumb/6/66/MTV_2021_%28brand_version%29.svg/512px-MTV_2021_%28brand_version%29.svg.png', 'Music', 'https://amg00314-mtv-us-amg00314c2-roku-us-3439.playouts.now.amagi.tv/playlist.m3u8'],\n ['ch_mus-vh1', 'VH1', 'https://upload.wikimedia.org/wikipedia/commons/thumb/4/43/VH1_logo_2013.svg/512px-VH1_logo_2013.svg.png', 'Music', 'https://amg00323-vh1-amg00323c2-roku-us-3449.playouts.now.amagi.tv/playlist.m3u8'],\n ['ch_mus-bet', 'BET', 'https://upload.wikimedia.org/wikipedia/commons/thumb/7/7c/BET_logo.svg/512px-BET_logo.svg.png', 'Music', 'https://amg00319-bet-amg00319c2-roku-us-2829.playouts.now.amagi.tv/playlist.m3u8'],\n ['ch_mus-cmt', 'CMT', 'https://upload.wikimedia.org/wikipedia/commons/thumb/e/e3/CMT_%282021%29.svg/512px-CMT_%282021%29.svg.png', 'Music', 'https://amg00321-cmt-amg00321c2-roku-us-6231.playouts.now.amagi.tv/playlist.m3u8'],\n \n // Documentary\n ['ch_doc-natgeo', 'National Geographic', 'https://upload.wikimedia.org/wikipedia/commons/thumb/f/fc/Natgeologo.svg/512px-Natgeologo.svg.png', 'Documentary', 'https://fl1.moveonjoy.com/National_Geographic/index.m3u8'],\n ['ch_doc-discovery', 'Discovery', 'https://upload.wikimedia.org/wikipedia/commons/thumb/1/12/Discovery_Channel_2023.svg/512px-Discovery_Channel_2023.svg.png', 'Documentary', 'https://fl1.moveonjoy.com/Discovery/index.m3u8'],\n ['ch_doc-history', 'History', 'https://upload.wikimedia.org/wikipedia/commons/thumb/0/01/History_%282021%29.svg/512px-History_%282021%29.svg.png', 'Documentary', 'https://fl1.moveonjoy.com/History_Channel/index.m3u8'],\n ['ch_doc-animal', 'Animal Planet', 'https://upload.wikimedia.org/wikipedia/commons/thumb/a/a7/Animal_Planet_%282018%29.svg/512px-Animal_Planet_%282018%29.svg.png', 'Documentary', 'https://fl1.moveonjoy.com/Animal_Planet/index.m3u8'],\n ['ch_doc-tlc', 'TLC', 'https://upload.wikimedia.org/wikipedia/commons/thumb/8/81/TLC_2022.svg/512px-TLC_2022.svg.png', 'Documentary', 'https://fl1.moveonjoy.com/TLC/index.m3u8'],\n \n // Entertainment\n ['ch_ent-comedy', 'Comedy Central', 'https://upload.wikimedia.org/wikipedia/commons/thumb/4/43/Comedy_Central_%282018%29.svg/512px-Comedy_Central_%282018%29.svg.png', 'Entertainment', 'https://fl1.moveonjoy.com/Comedy_Central/index.m3u8'],\n ['ch_ent-e', 'E!', 'https://upload.wikimedia.org/wikipedia/commons/thumb/2/20/E%21_logo.svg/512px-E%21_logo.svg.png', 'Entertainment', 'https://fl1.moveonjoy.com/E/index.m3u8'],\n ['ch_ent-bravo', 'Bravo', 'https://upload.wikimedia.org/wikipedia/commons/thumb/2/29/Bravo_TV_2023.svg/512px-Bravo_TV_2023.svg.png', 'Entertainment', 'https://fl1.moveonjoy.com/Bravo/index.m3u8'],\n ['ch_ent-trutv', 'truTV', 'https://upload.wikimedia.org/wikipedia/commons/thumb/3/31/TruTV_2024.svg/512px-TruTV_2024.svg.png', 'Entertainment', 'https://fl1.moveonjoy.com/truTV/index.m3u8'],\n \n // Lifestyle\n ['ch_lif-hgtv', 'HGTV', 'https://upload.wikimedia.org/wikipedia/commons/thumb/a/ae/HGTV_2023.svg/512px-HGTV_2023.svg.png', 'Lifestyle', 'https://fl1.moveonjoy.com/HGTV/index.m3u8'],\n ['ch_lif-food', 'Food Network', 'https://upload.wikimedia.org/wikipedia/commons/thumb/2/24/Food_Network_New_Logo.svg/512px-Food_Network_New_Logo.svg.png', 'Lifestyle', 'https://fl1.moveonjoy.com/Food_Network/index.m3u8'],\n ['ch_lif-travel', 'Travel Channel', 'https://upload.wikimedia.org/wikipedia/commons/thumb/4/4a/Travel_Channel_logo.svg/512px-Travel_Channel_logo.svg.png', 'Lifestyle', 'https://fl1.moveonjoy.com/Travel_Channel/index.m3u8'],\n ];\n\n const insertStmt = conn.prepare(`\n INSERT OR IGNORE INTO channels (id, name, logo_url, category, stream_url, enabled, _created_by, _created_at, _updated_at)\n VALUES (?, ?, ?, ?, ?, 1, ?, ?, ?)\n `);\n\n let imported = 0;\n const now = Math.floor(Date.now() / 1000);\n const createdBy = req.headers.get(\"x-user-uuid\") || \"system-seed\";\n\n for (const [id, name, logo, category, streamUrl] of curatedChannels) {\n try {\n await insertStmt.run([id, name, logo, category, streamUrl, createdBy, now, now]);\n imported++;\n } catch (error) {\n console.error(`Failed to insert ${name}:`, error);\n }\n }\n\n // Return the seeded channels\n const listStmt = conn.prepare(\"SELECT id, name, logo_url as logo, category FROM channels WHERE enabled = 1 ORDER BY category, name\");\n const channels = await listStmt.all();\n\n return Response.json({\n success: true,\n imported,\n message: `Seeded ${imported} channels successfully`,\n channels: channels.map((c: any) => ({\n id: c.id,\n name: c.name,\n logo: c.logo,\n category: c.category\n }))\n });\n\n } catch (error) {\n return Response.json({\n success: false,\n error: error.message\n }, { status: 500 });\n }\n}",[171],"8a039e2e-ff9f-11f0-b3a0-42dde27851f2","fue2e7vf488q4f4617q3v04v1sq92qe28v.ts","58f9ceaa-ff97-11f0-b348-42dde27851f2",14,["D",1769972112877],"import { connect } from \"npm:@tursodatabase/serverless\";\n\nexport default async function(req: Request): Promise {\n // Read secrets from x-secrets header\n const __secrets = JSON.parse(req.headers.get('x-secrets') || '{}');\n\n const userUuid = req.headers.get(\"x-user-uuid\");\n \n // Allow anonymous access - return empty array for non-authenticated users\n if (!userUuid) {\n if (req.method === 'GET') {\n // Return empty favorites for anonymous users\n return Response.json([]);\n }\n // For POST/DELETE, require auth\n return Response.json({ error: 'Unauthorized' }, { status: 401 });\n }\n\n const conn = connect({\n url: req.headers.get(\"x-database-url\")!,\n authToken: req.headers.get(\"x-database-token\")!\n });\n\n try {\n const now = Math.floor(Date.now() / 1000);\n\n if (req.method === 'GET') {\n // GET /v1/me/favorites - Return list of favorite channel IDs\n const stmt = conn.prepare(\"SELECT channel_id FROM user_favorites WHERE user_uuid = ?\");\n const favorites = await stmt.all([userUuid]);\n \n return Response.json(favorites.map((f: any) => f.channel_id));\n\n } else if (req.method === 'POST') {\n // POST /v1/me/favorites - Add a favorite\n const body = await req.json();\n const { channelid } = body;\n\n if (!channelid) {\n return Response.json({ error: 'channelid required' }, { status: 400 });\n }\n\n const stmt = conn.prepare(`\n INSERT INTO user_favorites (user_uuid, channel_id, _created_by, _created_at, _updated_at)\n VALUES (?, ?, ?, ?, ?)\n ON CONFLICT(user_uuid, channel_id) DO NOTHING\n `);\n await stmt.run([userUuid, channelid, userUuid, now, now]);\n\n return Response.json({ status: 'ok' });\n\n } else if (req.method === 'DELETE') {\n // DELETE /v1/me/favorites - Remove a favorite\n const body = await req.json();\n const { channelid } = body;\n\n if (!channelid) {\n return Response.json({ error: 'channelid required' }, { status: 400 });\n }\n\n const stmt = conn.prepare(\"DELETE FROM user_favorites WHERE user_uuid = ? AND channel_id = ?\");\n await stmt.run([userUuid, channelid]);\n\n return Response.json({ status: 'ok' });\n\n } else {\n return Response.json({ error: 'Method not allowed' }, { status: 405 });\n }\n\n } catch (error) {\n console.error('Error in /me/favorites:', error);\n return Response.json({ error: 'Internal server error' }, { status: 500 });\n }\n}\n",[179],"d9e71764-0124-11f1-93d5-42dde27851f2","fu9vtf10e007t34qs98t754f9fs5q9q793.ts","4ec18374-ff97-11f0-80a0-42dde27851f2",19,["D",1770139321128],"import { connect } from \"npm:@tursodatabase/serverless\";\n\nexport default async function(req: Request): Promise {\n // Read secrets from x-secrets header\n const __secrets = JSON.parse(req.headers.get('x-secrets') || '{}');\n\n const url = new URL(req.url);\n const pathParts = url.pathname.split('/').filter(Boolean);\n \n // Path is /api/v2/function/v1-channels or /api/v2/function/v1-channels/{id}\n // pathParts[0-2] are: api, v2, function\n // pathParts[3] is function name (v1-channels)\n // pathParts[4] (if exists) is the channel ID\n \n const functionName = pathParts[3];\n const channelId = pathParts[4];\n \n if (functionName !== 'v1-channels') {\n return Response.json({ error: 'Invalid route' }, { status: 404 });\n }\n \n if (req.method !== 'GET') {\n return Response.json({ error: 'Method not allowed' }, { status: 405 });\n }\n\n const conn = connect({\n url: req.headers.get(\"x-database-url\")!,\n authToken: req.headers.get(\"x-database-token\")!\n });\n\n try {\n if (channelId) {\n // GET /api/v2/function/v1-channels/{id}\n const stmt = conn.prepare(\"SELECT * FROM channels WHERE id = ?\");\n const channel = await stmt.get([channelId]);\n \n if (!channel) {\n return Response.json({ error: 'Channel not found' }, { status: 404 });\n }\n \n return Response.json({\n id: channel.id,\n name: channel.name,\n logo_url: channel.logo_url,\n category: channel.category,\n stream_url: channel.stream_url\n });\n } else {\n // GET /api/v2/function/v1-channels\n const stmt = conn.prepare(\"SELECT * FROM channels WHERE enabled = 1 ORDER BY category, name\");\n const channels = await stmt.all();\n \n return Response.json(channels.map((ch: any) => ({\n id: ch.id,\n name: ch.name,\n logo_url: ch.logo_url,\n category: ch.category,\n stream_url: ch.stream_url\n })));\n }\n } catch (error) {\n console.error('Error fetching channels:', error);\n return Response.json({ error: 'Internal server error' }, { status: 500 });\n }\n}",[186],"0bef92fe-0125-11f1-a4b2-42dde27851f2",["D",1770139405073],[28],"9a44fec2-ff9f-11f0-9c08-42dde27851f2","fu632v4437q2t74347q200ef503ef952q5.ts","5c02211a-ff97-11f0-9c66-42dde27851f2",15,["D",1769972140146],"import { connect } from \"npm:@tursodatabase/serverless\";\n\nexport default async function(req: Request): Promise {\n // Read secrets from x-secrets header\n const __secrets = JSON.parse(req.headers.get('x-secrets') || '{}');\n\n const userUuid = req.headers.get(\"x-user-uuid\");\n \n // Allow anonymous access - return empty array for non-authenticated users\n if (!userUuid) {\n return Response.json([]);\n }\n\n if (req.method !== 'GET') {\n return Response.json({ error: 'Method not allowed' }, { status: 405 });\n }\n\n const conn = connect({\n url: req.headers.get(\"x-database-url\")!,\n authToken: req.headers.get(\"x-database-token\")!\n });\n\n try {\n // GET /v1/me/recent - Return list of recently watched channel IDs (most recent first)\n const stmt = conn.prepare(`\n SELECT channel_id FROM user_recent_channels \n WHERE user_uuid = ? \n ORDER BY last_watched DESC \n LIMIT 20\n `);\n const recents = await stmt.all([userUuid]);\n \n return Response.json(recents.map((r: any) => r.channel_id));\n\n } catch (error) {\n console.error('Error in /me/recent:', error);\n return Response.json({ error: 'Internal server error' }, { status: 500 });\n }\n}\n",[196],"081114be-0125-11f1-bdfc-42dde27851f2","fu58v8268qe06047t4qq6s768q62121v09.ts","65a8f432-ff97-11f0-87ed-42dde27851f2",24,["D",1770139398568],"import { connect } from \"npm:@tursodatabase/serverless\";\n\nexport default async function(req: Request): Promise {\n // Read secrets from x-secrets header\n const __secrets = JSON.parse(req.headers.get('x-secrets') || '{}');\n\n const userUuid = req.headers.get(\"x-user-uuid\");\n if (!userUuid) {\n return Response.json({ error: 'Unauthorized' }, { status: 401 });\n }\n\n if (req.method !== 'POST') {\n return Response.json({ error: 'Method not allowed' }, { status: 405 });\n }\n\n try {\n const body = await req.json();\n const { channelid, sessionid } = body;\n\n if (!channelid || !sessionid) {\n return Response.json({ error: 'channelid and sessionid required' }, { status: 400 });\n }\n\n const conn = connect({\n url: req.headers.get(\"x-database-url\")!,\n authToken: req.headers.get(\"x-database-token\")!\n });\n\n const now = Math.floor(Date.now() / 1000);\n\n // Verify session exists and belongs to user\n const stmt = conn.prepare(`\n SELECT * FROM user_sessions \n WHERE session_id = ? AND user_uuid = ? AND expires_at > ?\n `);\n const session = await stmt.get([sessionid, userUuid, now]);\n\n if (!session) {\n return Response.json({ error: 'Invalid or expired session' }, { status: 401 });\n }\n\n // Update session expiry\n const updateStmt = conn.prepare(`\n UPDATE user_sessions SET expires_at = ?, _updated_at = ? WHERE session_id = ?\n `);\n const newExpiry = now + (15 * 60); // Extend by 15 minutes\n await updateStmt.run([newExpiry, now, sessionid]);\n\n return Response.json({ status: 'ok' });\n\n } catch (error) {\n console.error('Error in playback heartbeat:', error);\n return Response.json({ error: 'Internal server error' }, { status: 500 });\n }\n}",[203],"a3cc599e-ffa0-11f0-a040-42dde27851f2","fu54q215tq927s44478e4f9e7fe0t48t61.ts","a3cc5ab6-ffa0-11f0-a040-42dde27851f2",17,["D",1769972585632],"import { connect } from \"npm:@tursodatabase/serverless\";\nimport { createHash } from \"npm:crypto\";\n\nexport default async function(req: Request): Promise {\n // Read secrets from x-secrets header\n const __secrets = JSON.parse(req.headers.get('x-secrets') || '{}');\n\n if (req.method !== 'POST') {\n return Response.json({ error: 'Method not allowed' }, { status: 405 });\n }\n\n try {\n const body = await req.json();\n const { email, password } = body;\n\n if (!email || !password) {\n return Response.json({ error: 'Email and password are required' }, { status: 400 });\n }\n\n // Hash password\n const password_hash = createHash('sha256').update(password).digest('hex');\n\n const conn = connect({\n url: req.headers.get(\"x-database-url\")!,\n authToken: req.headers.get(\"x-database-token\")!\n });\n\n // Find user\n const stmt = conn.prepare(\"SELECT * FROM users WHERE email = ? AND password_hash = ?\");\n const user = await stmt.get([email, password_hash]) as any;\n\n if (!user) {\n return Response.json({ error: 'Invalid email or password' }, { status: 401 });\n }\n\n // Return user data\n return Response.json({\n id: user.id,\n email: user.email,\n display_name: user.display_name,\n avatar_url: user.avatar_url,\n role: user.role\n });\n\n } catch (error) {\n console.error('Login error:', error);\n return Response.json({ error: 'Internal server error' }, { status: 500 });\n }\n}\n",[210],"03e95c48-0125-11f1-a289-42dde27851f2","fu4fqt1eq7tv244t02s2v58sv106663vt5.ts","93b0b02c-ff97-11f0-83f7-42dde27851f2",23,["D",1770139391606],"import { connect } from \"npm:@tursodatabase/serverless\";\n\nexport default async function(req: Request): Promise {\n // Read secrets from x-secrets header\n const __secrets = JSON.parse(req.headers.get('x-secrets') || '{}');\n\n const userUuid = req.headers.get(\"x-user-uuid\");\n if (!userUuid) {\n return Response.json({ error: 'Unauthorized' }, { status: 401 });\n }\n\n if (req.method !== 'POST') {\n return Response.json({ error: 'Method not allowed' }, { status: 405 });\n }\n\n try {\n const body = await req.json();\n const { channelid } = body;\n\n if (!channelid) {\n return Response.json({ error: 'channelid required' }, { status: 400 });\n }\n\n const conn = connect({\n url: req.headers.get(\"x-database-url\")!,\n authToken: req.headers.get(\"x-database-token\")!\n });\n\n const now = Math.floor(Date.now() / 1000);\n const expiresAt = now + (4 * 60 * 60); // 4 hours\n const sessionId = crypto.randomUUID();\n\n // Get stream URL\n const channelStmt = conn.prepare(\"SELECT stream_url FROM channels WHERE id = ? AND enabled = 1\");\n const channel = await channelStmt.get([channelid]);\n \n if (!channel) {\n return Response.json({ error: 'Channel not found' }, { status: 404 });\n }\n\n // Create session\n const sessionStmt = conn.prepare(`\n INSERT INTO user_sessions (session_id, user_uuid, channel_id, expires_at, _created_by, _created_at, _updated_at)\n VALUES (?, ?, ?, ?, ?, ?, ?)\n `);\n await sessionStmt.run([sessionId, userUuid, channelid, expiresAt, userUuid, now, now]);\n\n // Add to recent channels\n const recentStmt = conn.prepare(`\n INSERT INTO user_recent_channels (user_uuid, channel_id, last_watched, _created_by, _created_at, _updated_at)\n VALUES (?, ?, ?, ?, ?, ?)\n ON CONFLICT(user_uuid, channel_id) DO UPDATE SET last_watched = ?, _updated_at = ?\n `);\n await recentStmt.run([userUuid, channelid, now, userUuid, now, now, now, now]);\n\n return Response.json({\n playback_url: channel.stream_url + '?token=' + sessionId,\n sessionid: sessionId,\n expires_at: new Date(expiresAt * 1000).toISOString()\n });\n\n } catch (error) {\n console.error('Error in playback token:', error);\n return Response.json({ error: 'Internal server error' }, { status: 500 });\n }\n}",[217],"b3a921da-ffa0-11f0-b5ed-42dde27851f2","fu1vs610ef2q294948q86es3037v23618q.ts","b3a922a2-ffa0-11f0-b5ed-42dde27851f2",18,["D",1769972612243],"import { connect } from \"npm:@tursodatabase/serverless\";\n\nexport default async function(req: Request): Promise {\n // Read secrets from x-secrets header\n const __secrets = JSON.parse(req.headers.get('x-secrets') || '{}');\n\n if (req.method !== 'GET') {\n return Response.json({ error: 'Method not allowed' }, { status: 405 });\n }\n\n const userUuid = req.headers.get(\"x-user-uuid\");\n\n if (!userUuid) {\n return Response.json({ error: 'Unauthorized' }, { status: 401 });\n }\n\n try {\n const conn = connect({\n url: req.headers.get(\"x-database-url\")!,\n authToken: req.headers.get(\"x-database-token\")!\n });\n\n // Get user\n const userStmt = conn.prepare(\"SELECT id, email, display_name, avatar_url, role FROM users WHERE id = ?\");\n const user = await userStmt.get([userUuid]) as any;\n\n if (!user) {\n return Response.json({ error: 'User not found' }, { status: 404 });\n }\n\n // Get subscription\n const subStmt = conn.prepare(`\n SELECT * FROM subscriptions \n WHERE user_id = ? \n ORDER BY created_at DESC \n LIMIT 1\n `);\n const subscription = await subStmt.get([userUuid]) as any;\n\n // Get usage stats\n const recentStmt = conn.prepare(`\n SELECT COUNT(DISTINCT device_id) as devices\n FROM playback_events\n WHERE user_uuid = ? AND timestamp > ?\n `);\n const thirtyDaysAgo = Math.floor((Date.now() - 30 * 24 * 60 * 60 * 1000) / 1000);\n const usage = await recentStmt.get([userUuid, thirtyDaysAgo]) as any;\n\n return Response.json({\n user: {\n id: user.id,\n email: user.email,\n display_name: user.display_name,\n avatar_url: user.avatar_url,\n role: user.role\n },\n subscription: subscription ? {\n status: subscription.status,\n plan_id: subscription.plan_id,\n current_period_end: subscription.current_period_end ? new Date(subscription.current_period_end * 1000).toISOString() : null,\n cancel_at_period_end: Boolean(subscription.cancel_at_period_end)\n } : null,\n usage: {\n devices: usage?.devices || 0,\n watch_time_minutes_30d: 0 // TODO: Calculate from playback_events\n }\n });\n\n } catch (error) {\n console.error('Dashboard error:', error);\n return Response.json({ error: 'Internal server error' }, { status: 500 });\n }\n}\n",[224],"pulls","branches","forks","envVars",{"_237":60,"_239":60},"connections",{"_237":60,"_238":60},"count","unfilledCount","emptyCount",{"_43":223,"_32":224,"_30":225,"_141":-5,"_41":42,"_40":226,"_143":120,"_38":290,"_13":60,"_33":34,"_35":228,"_24":25,"_146":-5,"_254":291,"_27":292},{"_43":216,"_32":217,"_30":218,"_141":-5,"_41":42,"_40":219,"_143":120,"_38":287,"_13":175,"_33":34,"_35":221,"_24":25,"_146":-5,"_254":288,"_27":289},{"_43":209,"_32":210,"_30":211,"_141":-5,"_41":42,"_40":212,"_143":120,"_38":284,"_13":60,"_33":34,"_35":214,"_24":25,"_146":-5,"_254":285,"_27":286},{"_43":202,"_32":203,"_30":204,"_141":-5,"_41":42,"_40":205,"_143":120,"_38":281,"_13":175,"_33":34,"_35":207,"_24":25,"_146":-5,"_254":282,"_27":283},{"_43":195,"_32":196,"_30":197,"_141":-5,"_41":42,"_40":198,"_143":25,"_38":278,"_13":175,"_33":34,"_35":200,"_24":25,"_146":-5,"_254":279,"_27":280},{"_43":192,"_32":28,"_30":31,"_141":-5,"_41":42,"_40":14,"_143":120,"_38":275,"_13":175,"_33":34,"_35":37,"_24":25,"_146":-5,"_254":276,"_27":277},{"_43":185,"_32":186,"_30":187,"_141":-5,"_41":42,"_40":188,"_143":120,"_38":272,"_13":175,"_33":34,"_35":190,"_24":25,"_146":-5,"_254":273,"_27":274},{"_43":178,"_32":179,"_30":180,"_141":-5,"_41":42,"_40":181,"_143":25,"_38":269,"_13":153,"_33":34,"_35":183,"_24":25,"_146":-5,"_254":270,"_27":271},{"_43":170,"_32":171,"_30":172,"_141":-5,"_41":42,"_40":173,"_143":120,"_38":266,"_13":175,"_33":34,"_35":176,"_24":25,"_146":-5,"_254":267,"_27":268},{"_43":163,"_32":164,"_30":165,"_141":-5,"_41":42,"_40":166,"_143":25,"_38":263,"_13":60,"_33":34,"_35":168,"_24":25,"_146":-5,"_254":264,"_27":265},{"_43":156,"_32":157,"_30":158,"_141":-5,"_41":42,"_40":159,"_143":120,"_38":260,"_13":153,"_33":34,"_35":161,"_24":25,"_146":-5,"_254":261,"_27":262},{"_43":148,"_32":149,"_30":150,"_141":-5,"_41":42,"_40":151,"_143":120,"_38":257,"_13":153,"_33":34,"_35":154,"_24":25,"_146":-5,"_254":258,"_27":259},{"_43":138,"_32":139,"_30":140,"_141":-5,"_41":42,"_40":142,"_143":120,"_38":253,"_13":60,"_33":34,"_35":145,"_24":25,"_146":-5,"_254":255,"_27":256},["D",1769970249455],"children",[],[139],["D",1770139355505],[],[149],["D",1770139343013],[],[157],["D",1769968697912],[],[164],["D",1769970404904],[],[171],["D",1769972112877],[],[179],["D",1770139321128],[],[186],["D",1770139405073],[],[28],["D",1769972140146],[],[196],["D",1770139398568],[],[203],["D",1769972585632],[],[210],["D",1770139391606],[],[217],["D",1769972612243],[],[224],["D",1769968577371],{"_94":93,"_101":97},{"_94":93,"_95":-5,"_96":97,"_18":54,"_98":99,"_100":25},{"_13":83,"_32":84,"_43":42,"_85":44,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":45,"_92":93},"ctx",{"_76":-5,"_122":330,"_331":332,"_333":334,"_335":25,"_336":25,"_337":25,"_338":120,"_339":-5,"_340":-7,"_341":-7,"_342":60,"_343":25,"_344":25,"_345":-5,"_346":25,"_347":25,"_348":25,"_349":-5},"ENV",{"_301":302,"_303":304,"_305":84,"_306":307,"_308":309,"_310":311,"_312":313,"_314":315,"_316":317,"_318":319,"_320":321,"_322":323,"_324":325,"_326":327,"_328":329},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v25