[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_199":200,"_201":202},"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",9,"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","fu09q35t4134vs491v9v329478s1eqv6s6.ts","latestPath","fileId","fc05358c-fdec-11f0-b44e-42dde27851f2","name","fileType","http","content","/**\n * Stream Proxy Edge Function\n * Proxies video stream requests to bypass CORS restrictions\n * Supports HLS (.m3u8) and MPEG-TS streams\n */\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 streamUrl = url.searchParams.get('url');\n\n if (!streamUrl) {\n return new Response('Missing stream URL', { status: 400 });\n }\n\n try {\n // Validate URL protocol\n const parsedUrl = new URL(streamUrl);\n if (!['http:', 'https:'].includes(parsedUrl.protocol)) {\n return new Response('Invalid URL protocol', { status: 400 });\n }\n\n // Fetch the stream with appropriate headers\n const response = await fetch(streamUrl, {\n method: req.method,\n headers: {\n 'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36',\n 'Accept': '*/*',\n 'Accept-Language': 'en-US,en;q=0.9',\n 'Connection': 'keep-alive',\n 'Referer': parsedUrl.origin\n }\n });\n\n if (!response.ok) {\n return new Response(`Stream error: ${response.status}`, { \n status: response.status \n });\n }\n\n // Get content type\n const contentType = response.headers.get('content-type') || 'video/mp2t';\n\n // Create proxy response with CORS headers\n const proxyHeaders = new Headers({\n 'Content-Type': contentType,\n 'Access-Control-Allow-Origin': '*',\n 'Access-Control-Allow-Methods': 'GET, HEAD, OPTIONS',\n 'Access-Control-Allow-Headers': '*',\n 'Cache-Control': 'no-cache, no-store, must-revalidate',\n 'Pragma': 'no-cache',\n 'Expires': '0'\n });\n\n // Handle OPTIONS preflight\n if (req.method === 'OPTIONS') {\n return new Response(null, { \n status: 204,\n headers: proxyHeaders\n });\n }\n\n // Stream the response\n return new Response(response.body, {\n status: response.status,\n headers: proxyHeaders\n });\n\n } catch (error: unknown) {\n console.error('Stream proxy error:', error);\n return new Response(\n `Proxy error: ${error instanceof Error ? error.message : 'Unknown error'}`,\n { status: 500 }\n );\n }\n}","/**\n * Stream Proxy Edge Function\n * Proxies video stream requests to bypass CORS restrictions\n * Supports HLS (.m3u8) and MPEG-TS streams\n */\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 streamUrl = url.searchParams.get('url');\n\n if (!streamUrl) {\n return new Response('Missing stream URL', { status: 400 });\n }\n\n try {\n // Validate URL protocol\n const parsedUrl = new URL(streamUrl);\n if (!['http:', 'https:'].includes(parsedUrl.protocol)) {\n return new Response('Invalid URL protocol', { status: 400 });\n }\n\n console.log(`[Stream Proxy] 🔗 Fetching: ${streamUrl.substring(0, 100)}...`);\n\n // Forward Range header if present\n const requestHeaders: Record = {\n 'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36',\n 'Accept': '*/*',\n 'Accept-Language': 'en-US,en;q=0.9',\n 'Connection': 'keep-alive',\n 'Referer': parsedUrl.origin,\n 'Origin': parsedUrl.origin\n };\n\n // Forward Range header for video seeking\n const rangeHeader = req.headers.get('Range');\n if (rangeHeader) {\n requestHeaders['Range'] = rangeHeader;\n }\n\n // Fetch the stream with appropriate headers\n const response = await fetch(streamUrl, {\n method: req.method,\n headers: requestHeaders\n });\n\n if (!response.ok) {\n console.error(`[Stream Proxy] ❌ Error: ${response.status} ${response.statusText}`);\n return new Response(`Stream error: ${response.status}`, { \n status: response.status \n });\n }\n\n // Get content type\n const contentType = response.headers.get('content-type') || 'video/mp2t';\n console.log(`[Stream Proxy] ✅ Content-Type: ${contentType}`);\n\n // Create proxy response with CORS headers\n const proxyHeaders = new Headers({\n 'Content-Type': contentType,\n 'Access-Control-Allow-Origin': '*',\n 'Access-Control-Allow-Methods': 'GET, HEAD, OPTIONS',\n 'Access-Control-Allow-Headers': 'Range, Content-Type, Authorization',\n 'Access-Control-Expose-Headers': 'Content-Length, Content-Range, Accept-Ranges',\n 'Cache-Control': 'no-cache, no-store, must-revalidate',\n 'Pragma': 'no-cache',\n 'Expires': '0'\n });\n\n // Forward Range response headers\n const contentRange = response.headers.get('content-range');\n if (contentRange) {\n proxyHeaders.set('Content-Range', contentRange);\n }\n const acceptRanges = response.headers.get('accept-ranges');\n if (acceptRanges) {\n proxyHeaders.set('Accept-Ranges', acceptRanges);\n }\n const contentLength = response.headers.get('content-length');\n if (contentLength) {\n proxyHeaders.set('Content-Length', contentLength);\n }\n\n // Handle OPTIONS preflight\n if (req.method === 'OPTIONS') {\n return new Response(null, { \n status: 204,\n headers: proxyHeaders\n });\n }\n\n console.log(`[Stream Proxy] ✅ Streaming response`);\n\n // Stream the response\n return new Response(response.body, {\n status: response.status,\n headers: proxyHeaders\n });\n\n } catch (error: unknown) {\n console.error('[Stream Proxy] ❌ Error:', error);\n return new Response(\n `Proxy error: ${error instanceof Error ? error.message : 'Unknown error'}`,\n { status: 500 }\n );\n }\n}","createdAt",["D",1769786527647],"branchVersion","branchId","edbf681c-fdd3-11f0-bc97-42dde27851f2","id","edbf0e12-fdd3-11f0-bc97-42dde27851f2","te59ss67f0v34e491s9sq9653t8ev50f8v",["D",1769774711707],"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",34,"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":195,"_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":196,"_78":197,"_80":198,"_82":25},"tree",[174,175,176,177,178],"files",[174,175,176,177,178],"counts",{"_164":60,"_165":143,"_166":60,"_167":168,"_169":170},"contents",[125,126,127,128,129],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_43":161,"_32":28,"_30":31,"_133":-5,"_41":42,"_40":14,"_135":25,"_38":162,"_13":143,"_33":34,"_35":37,"_24":25,"_138":-5,"_27":163},{"_43":154,"_32":155,"_30":156,"_133":-5,"_41":42,"_40":157,"_135":25,"_38":158,"_13":134,"_33":34,"_35":159,"_24":25,"_138":-5,"_27":160},{"_43":147,"_32":148,"_30":149,"_133":-5,"_41":42,"_40":150,"_135":120,"_38":151,"_13":143,"_33":34,"_35":152,"_24":25,"_138":-5,"_27":153},{"_43":140,"_32":141,"_30":142,"_133":-5,"_41":42,"_40":143,"_135":120,"_38":144,"_13":60,"_33":34,"_35":145,"_24":25,"_138":-5,"_27":146},{"_43":130,"_32":131,"_30":132,"_133":-5,"_41":42,"_40":134,"_135":120,"_38":136,"_13":60,"_33":34,"_35":137,"_24":25,"_138":-5,"_27":139},"3c2f8c9c-fdda-11f0-a034-42dde27851f2","fuq5tq78q685954502898fe40fs04s733q.ts","3c2f8d6e-fdda-11f0-a034-42dde27851f2","parentId",2,"latest",["D",1769777420285],"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 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 try {\n const body = await req.json();\n const { action } = body;\n\n // Get admin info from headers (platform will inject these for authenticated users)\n const userUuid = req.headers.get(\"x-user-uuid\") || \"system\";\n const userName = req.headers.get(\"x-user-name\") || \"Admin\";\n\n if (action === \"generate_code\") {\n const { duration_months, device_limit } = body;\n \n // Generate random 10-digit code\n const code = Math.random().toString().slice(2, 12).padEnd(10, '0');\n \n // Calculate expiry\n const expiresAt = now + (duration_months * 30 * 24 * 60 * 60);\n \n // Insert code\n const insertStmt = conn.prepare(\n \"INSERT INTO activation_codes (code, duration_months, device_limit, expires_at, is_active, created_by_name, _created_by, _created_at, _updated_at) VALUES (?, ?, ?, ?, 1, ?, ?, ?, ?)\"\n );\n await insertStmt.run([code, duration_months, device_limit, expiresAt, userName, userUuid, now, now]);\n \n // Log activity\n const logStmt = conn.prepare(\n \"INSERT INTO activity_logs (action, details, performed_by, _created_by, _created_at, _updated_at) VALUES (?, ?, ?, ?, ?, ?)\"\n );\n await logStmt.run([\n \"CODE_GENERATED\",\n `Code ${code} generated (${duration_months} months, ${device_limit} devices)`,\n userName,\n userUuid,\n now,\n now\n ]);\n \n return Response.json({ success: true, code, expiresAt });\n }\n\n if (action === \"get_codes\") {\n const stmt = conn.prepare(\"SELECT * FROM activation_codes ORDER BY _created_at DESC\");\n const codes = await stmt.all([]);\n return Response.json({ success: true, codes });\n }\n\n if (action === \"get_sessions\") {\n const stmt = conn.prepare(`\n SELECT us.*, ac.code \n FROM user_sessions us \n JOIN activation_codes ac ON us.code_id = ac._row_id \n ORDER BY us.last_active DESC\n `);\n const sessions = await stmt.all([]);\n return Response.json({ success: true, sessions });\n }\n\n if (action === \"revoke_code\") {\n const { code_id } = body;\n \n const updateStmt = conn.prepare(\"UPDATE activation_codes SET is_active = 0, _updated_at = ? WHERE _row_id = ?\");\n await updateStmt.run([now, code_id]);\n \n const sessionStmt = conn.prepare(\"UPDATE user_sessions SET is_active = 0, _updated_at = ? WHERE code_id = ?\");\n await sessionStmt.run([now, code_id]);\n \n const logStmt = conn.prepare(\n \"INSERT INTO activity_logs (action, details, performed_by, _created_by, _created_at, _updated_at) VALUES (?, ?, ?, ?, ?, ?)\"\n );\n await logStmt.run([\"CODE_REVOKED\", `Code ID ${code_id} revoked`, userName, userUuid, now, now]);\n \n return Response.json({ success: true });\n }\n\n if (action === \"delete_session\") {\n const { session_id } = body;\n \n const deleteStmt = conn.prepare(\"UPDATE user_sessions SET is_active = 0, _updated_at = ? WHERE _row_id = ?\");\n await deleteStmt.run([now, session_id]);\n \n const logStmt = conn.prepare(\n \"INSERT INTO activity_logs (action, details, performed_by, _created_by, _created_at, _updated_at) VALUES (?, ?, ?, ?, ?, ?)\"\n );\n await logStmt.run([\"SESSION_DELETED\", `Session ${session_id} terminated`, userName, userUuid, now, now]);\n \n return Response.json({ success: true });\n }\n\n if (action === \"get_logs\") {\n const stmt = conn.prepare(\"SELECT * FROM activity_logs ORDER BY _created_at DESC LIMIT 100\");\n const logs = await stmt.all([]);\n return Response.json({ success: true, logs });\n }\n\n if (action === \"get_stats\") {\n const totalCodesStmt = conn.prepare(\"SELECT COUNT(*) as count FROM activation_codes\");\n const activeCodesStmt = conn.prepare(\"SELECT COUNT(*) as count FROM activation_codes WHERE is_active = 1 AND expires_at > ?\");\n const activeSessionsStmt = conn.prepare(\"SELECT COUNT(*) as count FROM user_sessions WHERE is_active = 1\");\n \n const totalCodes = await totalCodesStmt.get([]);\n const activeCodes = await activeCodesStmt.get([now]);\n const activeSessions = await activeSessionsStmt.get([]);\n \n return Response.json({ \n success: true, \n stats: {\n totalCodes: totalCodes?.count || 0,\n activeCodes: activeCodes?.count || 0,\n activeSessions: activeSessions?.count || 0\n }\n });\n }\n\n return Response.json({ error: \"Unknown action\" }, { status: 400 });\n } catch (error) {\n console.error(\"Admin action error:\", error);\n return Response.json({ error: error?.message || \"Unknown error\" }, { status: 500 });\n }\n}\n","label",[131],"edce25aa-fdd3-11f0-bc97-42dde27851f2","fuf70t042e002f4917939v9eq47642fvf0.ts","edce26cc-fdd3-11f0-bc97-42dde27851f2",1,["D",1769774711804],"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 const userName = req.headers.get(\"x-user-name\") || \"Admin\";\n \n if (!userUuid) {\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 const now = Math.floor(Date.now() / 1000);\n\n try {\n const body = await req.json();\n const { action } = body;\n\n if (action === \"generate_code\") {\n const { duration_months, device_limit } = body;\n \n // Generate random 10-digit code\n const code = Math.random().toString().slice(2, 12).padEnd(10, '0');\n \n // Calculate expiry (duration_months from now)\n const expiresAt = now + (duration_months * 30 * 24 * 60 * 60);\n \n // Insert code\n const insertStmt = conn.prepare(\n \"INSERT INTO activation_codes (code, duration_months, device_limit, expires_at, is_active, created_by_name, _created_by, _created_at, _updated_at) VALUES (?, ?, ?, ?, 1, ?, ?, ?, ?)\"\n );\n await insertStmt.run([code, duration_months, device_limit, expiresAt, userName, userUuid, now, now]);\n \n // Log activity\n const logStmt = conn.prepare(\n \"INSERT INTO activity_logs (action, details, performed_by, _created_by, _created_at, _updated_at) VALUES (?, ?, ?, ?, ?, ?)\"\n );\n await logStmt.run([\n \"CODE_GENERATED\",\n `Code ${code} generated (${duration_months} months, ${device_limit} devices)`,\n userName,\n userUuid,\n now,\n now\n ]);\n \n return Response.json({ success: true, code, expiresAt });\n }\n\n if (action === \"get_codes\") {\n const stmt = conn.prepare(\"SELECT * FROM activation_codes ORDER BY _created_at DESC\");\n const codes = await stmt.all([]);\n return Response.json({ success: true, codes });\n }\n\n if (action === \"get_sessions\") {\n const stmt = conn.prepare(`\n SELECT us.*, ac.code \n FROM user_sessions us \n JOIN activation_codes ac ON us.code_id = ac._row_id \n ORDER BY us.last_active DESC\n `);\n const sessions = await stmt.all([]);\n return Response.json({ success: true, sessions });\n }\n\n if (action === \"revoke_code\") {\n const { code_id } = body;\n \n // Deactivate code\n const updateStmt = conn.prepare(\"UPDATE activation_codes SET is_active = 0, _updated_at = ? WHERE _row_id = ?\");\n await updateStmt.run([now, code_id]);\n \n // Deactivate all sessions for this code\n const sessionStmt = conn.prepare(\"UPDATE user_sessions SET is_active = 0, _updated_at = ? WHERE code_id = ?\");\n await sessionStmt.run([now, code_id]);\n \n // Log activity\n const logStmt = conn.prepare(\n \"INSERT INTO activity_logs (action, details, performed_by, _created_by, _created_at, _updated_at) VALUES (?, ?, ?, ?, ?, ?)\"\n );\n await logStmt.run([\"CODE_REVOKED\", `Code ID ${code_id} revoked`, userName, userUuid, now, now]);\n \n return Response.json({ success: true });\n }\n\n if (action === \"delete_session\") {\n const { session_id } = body;\n \n const deleteStmt = conn.prepare(\"UPDATE user_sessions SET is_active = 0, _updated_at = ? WHERE _row_id = ?\");\n await deleteStmt.run([now, session_id]);\n \n // Log activity\n const logStmt = conn.prepare(\n \"INSERT INTO activity_logs (action, details, performed_by, _created_by, _created_at, _updated_at) VALUES (?, ?, ?, ?, ?, ?)\"\n );\n await logStmt.run([\"SESSION_DELETED\", `Session ${session_id} terminated`, userName, userUuid, now, now]);\n \n return Response.json({ success: true });\n }\n\n if (action === \"get_logs\") {\n const stmt = conn.prepare(\"SELECT * FROM activity_logs ORDER BY _created_at DESC LIMIT 100\");\n const logs = await stmt.all([]);\n return Response.json({ success: true, logs });\n }\n\n if (action === \"get_stats\") {\n const totalCodesStmt = conn.prepare(\"SELECT COUNT(*) as count FROM activation_codes\");\n const activeCodesStmt = conn.prepare(\"SELECT COUNT(*) as count FROM activation_codes WHERE is_active = 1 AND expires_at > ?\");\n const activeSessionsStmt = conn.prepare(\"SELECT COUNT(*) as count FROM user_sessions WHERE is_active = 1\");\n \n const totalCodes = await totalCodesStmt.get([]);\n const activeCodes = await activeCodesStmt.get([now]);\n const activeSessions = await activeSessionsStmt.get([]);\n \n return Response.json({ \n success: true, \n stats: {\n totalCodes: totalCodes?.count || 0,\n activeCodes: activeCodes?.count || 0,\n activeSessions: activeSessions?.count || 0\n }\n });\n }\n\n return Response.json({ error: \"Unknown action\" }, { status: 400 });\n } catch (error) {\n console.error(\"Admin action error:\", error);\n return Response.json({ error: error.message }, { status: 500 });\n }\n}\n",[141],"d1899a46-fde2-11f0-b746-42dde27851f2","fu4v88288f7es8445t864f439qst81ef4e.ts","9c00c5f2-fddd-11f0-b91f-42dde27851f2",4,["D",1769781106825],"import { connect } from \"npm:@tursodatabase/serverless\";\n\n/**\n * Admin Actions Edge Function\n * Handles IPTV-specific administrative operations:\n * - Code generation (activation codes for IPTV content)\n * - Session management (device sessions for IPTV streaming)\n * - Activity logging\n * \n * Note: This is NOT authentication/user signup. The app uses Kliv Auth for user auth.\n * This function manages IPTV business logic (codes, streaming sessions) which is\n * legitimate application-level functionality.\n */\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 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 try {\n const body = await req.json();\n const { action } = body;\n\n // Get admin info from headers\n const userUuid = req.headers.get(\"x-user-uuid\") || \"system\";\n const userName = req.headers.get(\"x-user-name\") || \"Admin\";\n\n // Generate IPTV activation code\n if (action === \"generate_code\") {\n const { duration_months, device_limit, m3u_url } = body;\n \n if (!duration_months || !device_limit) {\n return Response.json({ error: \"Missing required fields\" }, { status: 400 });\n }\n \n const duration = parseInt(duration_months);\n const limit = parseInt(device_limit);\n \n if (isNaN(duration) || isNaN(limit)) {\n return Response.json({ error: \"Invalid duration or device limit\" }, { status: 400 });\n }\n \n // Generate random 10-digit activation code\n const code = Math.random().toString().slice(2, 12).padEnd(10, '0');\n \n // Calculate expiry date\n const expiresAt = now + (duration * 30 * 24 * 60 * 60);\n \n // Store activation code with M3U playlist URL\n const insertStmt = conn.prepare(\n \"INSERT INTO activation_codes (code, duration_months, device_limit, expires_at, is_active, created_by_name, m3u_url, _created_by, _created_at, _updated_at) VALUES (?, ?, ?, ?, 1, ?, ?, ?, ?, ?)\"\n );\n await insertStmt.run([code, duration, limit, expiresAt, userName, m3u_url || null, userUuid, now, now]);\n \n // Log activity\n const logStmt = conn.prepare(\n \"INSERT INTO activity_logs (action, details, performed_by, _created_by, _created_at, _updated_at) VALUES (?, ?, ?, ?, ?, ?)\"\n );\n await logStmt.run([\n \"CODE_GENERATED\",\n `Code ${code} generated (${duration} months, ${limit} devices${m3u_url ? ', M3U: ' + m3u_url.substring(0, 30) + '...' : ''})`,\n userName,\n userUuid,\n now,\n now\n ]);\n \n return Response.json({ success: true, code, expiresAt });\n }\n\n // List all activation codes\n if (action === \"get_codes\") {\n const stmt = conn.prepare(\"SELECT * FROM activation_codes ORDER BY _created_at DESC\");\n const codes = await stmt.all([]);\n return Response.json({ success: true, codes });\n }\n\n // List active IPTV streaming sessions\n if (action === \"get_sessions\") {\n const stmt = conn.prepare(`\n SELECT us.*, ac.code \n FROM user_sessions us \n JOIN activation_codes ac ON us.code_id = ac._row_id \n ORDER BY us.last_active DESC\n `);\n const sessions = await stmt.all([]);\n return Response.json({ success: true, sessions });\n }\n\n // Revoke activation code (stops IPTV access)\n if (action === \"revoke_code\") {\n const { code_id } = body;\n \n if (!code_id) {\n return Response.json({ error: \"Missing code_id\" }, { status: 400 });\n }\n \n const updateStmt = conn.prepare(\"UPDATE activation_codes SET is_active = 0, _updated_at = ? WHERE _row_id = ?\");\n await updateStmt.run([now, code_id]);\n \n const sessionStmt = conn.prepare(\"UPDATE user_sessions SET is_active = 0, _updated_at = ? WHERE code_id = ?\");\n await sessionStmt.run([now, code_id]);\n \n const logStmt = conn.prepare(\n \"INSERT INTO activity_logs (action, details, performed_by, _created_by, _created_at, _updated_at) VALUES (?, ?, ?, ?, ?, ?)\"\n );\n await logStmt.run([\"CODE_REVOKED\", `Code ID ${code_id} revoked`, userName, userUuid, now, now]);\n \n return Response.json({ success: true });\n }\n\n // Terminate IPTV streaming session\n if (action === \"delete_session\") {\n const { session_id } = body;\n \n if (!session_id) {\n return Response.json({ error: \"Missing session_id\" }, { status: 400 });\n }\n \n const deleteStmt = conn.prepare(\"UPDATE user_sessions SET is_active = 0, _updated_at = ? WHERE _row_id = ?\");\n await deleteStmt.run([now, session_id]);\n \n const logStmt = conn.prepare(\n \"INSERT INTO activity_logs (action, details, performed_by, _created_by, _created_at, _updated_at) VALUES (?, ?, ?, ?, ?, ?)\"\n );\n await logStmt.run([\"SESSION_DELETED\", `Session ${session_id} terminated`, userName, userUuid, now, now]);\n \n return Response.json({ success: true });\n }\n\n // Get activity logs\n if (action === \"get_logs\") {\n const stmt = conn.prepare(\"SELECT * FROM activity_logs ORDER BY _created_at DESC LIMIT 100\");\n const logs = await stmt.all([]);\n return Response.json({ success: true, logs });\n }\n\n // Get dashboard statistics\n if (action === \"get_stats\") {\n const totalCodesStmt = conn.prepare(\"SELECT COUNT(*) as count FROM activation_codes\");\n const activeCodesStmt = conn.prepare(\"SELECT COUNT(*) as count FROM activation_codes WHERE is_active = 1 AND expires_at > ?\");\n const activeSessionsStmt = conn.prepare(\"SELECT COUNT(*) as count FROM user_sessions WHERE is_active = 1\");\n \n const totalCodes = await totalCodesStmt.get([]);\n const activeCodes = await activeCodesStmt.get([now]);\n const activeSessions = await activeSessionsStmt.get([]);\n \n return Response.json({ \n success: true, \n stats: {\n totalCodes: totalCodes?.count || 0,\n activeCodes: activeCodes?.count || 0,\n activeSessions: activeSessions?.count || 0\n }\n });\n }\n\n return Response.json({ error: \"Unknown action\" }, { status: 400 });\n } catch (error) {\n console.error(\"Admin action error:\", error);\n return Response.json({ error: \"Internal server error\" }, { status: 500 });\n }\n}",[148],"6e56a006-fdef-11f0-9d04-42dde27851f2","fu4871544f42284vvt914f05262v596t70.ts","e1209982-fde2-11f0-bbea-42dde27851f2",8,["D",1769786523853],"import { connect } from \"npm:@tursodatabase/serverless\";\n\n/**\n * M3U Parser Edge Function\n * Fetches and parses M3U playlists, storing content in database\n * Also retrieves content for user-facing components\n */\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 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 try {\n const body = await req.json();\n const { action } = body;\n\n // Fetch and parse M3U playlist for a code\n if (action === \"fetch_m3u\") {\n const { code, force_refresh } = body;\n \n if (!code) {\n return Response.json({ error: \"Missing activation code\" }, { status: 400 });\n }\n \n // Get activation code info\n const codeStmt = conn.prepare(\"SELECT * FROM activation_codes WHERE code = ? AND is_active = 1\");\n const codeData = await codeStmt.get([code]);\n \n if (!codeData) {\n return Response.json({ error: \"Invalid or inactive code\" }, { status: 404 });\n }\n \n // Check expiry\n if (codeData.expires_at < now) {\n return Response.json({ error: \"Code expired\" }, { status: 403 });\n }\n \n if (!codeData.m3u_url) {\n return Response.json({ error: \"No M3U URL configured for this code\" }, { status: 400 });\n }\n \n // Hard reset: Delete existing content if force refresh\n if (force_refresh) {\n console.log(`[M3U Parser] 🔥 HARD RESET for code ${code}`);\n const deleteStmt = conn.prepare(\"DELETE FROM m3u_contents WHERE code_id = ?\");\n await deleteStmt.run([codeData._row_id]);\n console.log(`[M3U Parser] ✅ Cleared existing content for code ${code}`);\n }\n \n // Fetch M3U content with timeout\n console.log(`[M3U Parser] 📡 Fetching M3U from: ${codeData.m3u_url}`);\n \n const controller = new AbortController();\n const timeoutId = setTimeout(() => controller.abort(), 60000); // 60s timeout\n \n const m3uResponse = await fetch(codeData.m3u_url, {\n headers: {\n 'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36',\n 'Accept': '*/*',\n 'Accept-Language': 'en-US,en;q=0.9',\n 'Connection': 'keep-alive',\n 'Referer': new URL(codeData.m3u_url).origin\n },\n signal: controller.signal\n });\n \n clearTimeout(timeoutId);\n \n if (!m3uResponse.ok) {\n console.error(`[M3U Parser] ❌ HTTP ${m3uResponse.status} when fetching M3U`);\n return Response.json({ error: `Failed to fetch M3U playlist: HTTP ${m3uResponse.status}` }, { status: 502 });\n }\n \n const m3uContent = await m3uResponse.text();\n console.log(`[M3U Parser] 📄 Fetched ${m3uContent.length} bytes`);\n \n // Parse M3U content\n console.log(`[M3U Parser] 🔍 Starting parse...`);\n const parsedContent = parseM3U(m3uContent);\n console.log(`[M3U Parser] ✅ Parsed ${parsedContent.length} items`);\n \n // Log categorization stats\n const liveCount = parsedContent.filter(i => i.type === 'live').length;\n const vodCount = parsedContent.filter(i => i.type === 'vod').length;\n const seriesCount = parsedContent.filter(i => i.type === 'series').length;\n const catchupCount = parsedContent.filter(i => i.type === 'catchup').length;\n \n console.log(`[M3U Parser] 📊 Categorization: Live=${liveCount}, VOD=${vodCount}, Series=${seriesCount}, Catchup=${catchupCount}`);\n \n if (vodCount > 0 || seriesCount > 0) {\n console.log(`[M3U Parser] 🎉 SUCCESS: Found ${vodCount} Movies and ${seriesCount} Series!`);\n } else {\n console.log(`[M3U Parser] ⚠️ WARNING: No Movies or Series found. Check group-title patterns in your M3U.`);\n }\n \n // Store parsed content in chunks of 100\n const insertStmt = conn.prepare(\n \"INSERT INTO m3u_contents (code_id, content_type, title, logo_url, stream_url, category, _created_by, _created_at, _updated_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)\"\n );\n \n const userUuid = req.headers.get(\"x-user-uuid\") || \"system\";\n let insertCount = 0;\n let errorCount = 0;\n \n for (let i = 0; i < parsedContent.length; i++) {\n const item = parsedContent[i];\n \n try {\n await insertStmt.run([\n codeData._row_id,\n item.type,\n item.title,\n item.logo || null,\n item.url,\n item.category || null,\n userUuid,\n now,\n now\n ]);\n insertCount++;\n \n // Log progress every 100 items\n if (insertCount % 100 === 0) {\n console.log(`[M3U Parser] 💾 Inserted ${insertCount}/${parsedContent.length} items...`);\n }\n } catch (err) {\n console.error(`[M3U Parser] ❌ Error inserting item ${i}:`, err);\n errorCount++;\n }\n }\n \n console.log(`[M3U Parser] ✅ Insert complete: ${insertCount} inserted, ${errorCount} errors`);\n \n return Response.json({ \n success: true, \n cached: false, \n fetched: insertCount,\n errors: errorCount,\n live: liveCount,\n vod: vodCount,\n series: seriesCount,\n catchup: catchupCount\n });\n }\n\n // Get content for user\n if (action === \"get_content\") {\n const { code, type, category } = body;\n \n if (!code) {\n return Response.json({ error: \"Missing activation code\" }, { status: 400 });\n }\n \n // Verify code\n const codeStmt = conn.prepare(\"SELECT _row_id FROM activation_codes WHERE code = ? AND is_active = 1 AND expires_at > ?\");\n const codeData = await codeStmt.get([code, now]);\n \n if (!codeData) {\n return Response.json({ error: \"Invalid or expired code\" }, { status: 403 });\n }\n \n // Build query\n let sql = \"SELECT * FROM m3u_contents WHERE code_id = ?\";\n const params = [codeData._row_id];\n \n if (type) {\n sql += \" AND content_type = ?\";\n params.push(type);\n }\n \n if (category) {\n sql += \" AND category = ?\";\n params.push(category);\n }\n \n sql += \" ORDER BY title ASC LIMIT 500\";\n \n const stmt = conn.prepare(sql);\n const content = await stmt.all(params);\n \n console.log(`[M3U Parser] get_content: code=${code}, type=${type}, found=${content.length}`);\n \n return Response.json({ success: true, content });\n }\n\n // Get categories for a content type\n if (action === \"get_categories\") {\n const { code, type } = body;\n \n if (!code) {\n return Response.json({ error: \"Missing activation code\" }, { status: 400 });\n }\n \n const codeStmt = conn.prepare(\"SELECT _row_id FROM activation_codes WHERE code = ? AND is_active = 1 AND expires_at > ?\");\n const codeData = await codeStmt.get([code, now]);\n \n if (!codeData) {\n return Response.json({ error: \"Invalid or expired code\" }, { status: 403 });\n }\n \n let sql = \"SELECT DISTINCT category FROM m3u_contents WHERE code_id = ?\";\n const params = [codeData._row_id];\n \n if (type) {\n sql += \" AND content_type = ?\";\n params.push(type);\n }\n \n sql += \" AND category IS NOT NULL ORDER BY category ASC\";\n \n const stmt = conn.prepare(sql);\n const categories = await stmt.all(params);\n \n return Response.json({ success: true, categories: categories.map(c => c.category) });\n }\n\n return Response.json({ error: \"Unknown action\" }, { status: 400 });\n } catch (error) {\n console.error(\"[M3U Parser] ❌ Error:\", error);\n return Response.json({ error: \"Internal server error\" }, { status: 500 });\n }\n}\n\n/**\n * Parse M3U playlist content with improved VOD/Series detection\n * Returns array of { type, title, logo, url, category }\n */\nfunction parseM3U(content: string): Array<{type: string, title: string, logo?: string, url: string, category?: string}> {\n const lines = content.split('\\n');\n const items = [];\n let currentItem: any = {};\n let lineCount = 0;\n \n for (const line of lines) {\n lineCount++;\n const trimmedLine = line.trim();\n \n if (trimmedLine.startsWith('#EXTINF:')) {\n // Parse EXTINF line\n currentItem = {};\n \n // Extract title (after the comma)\n const titleMatch = trimmedLine.match(/,(.*)$/);\n if (titleMatch) {\n currentItem.title = titleMatch[1].trim();\n }\n \n // Extract logo from tvg-logo attribute\n const logoMatch = trimmedLine.match(/tvg-logo=\"([^\"]*)\"/);\n if (logoMatch) {\n currentItem.logo = logoMatch[1];\n }\n \n // Extract category from group-title\n const groupMatch = trimmedLine.match(/group-title=\"([^\"]*)\"/);\n if (groupMatch) {\n currentItem.category = groupMatch[1];\n }\n \n // Improved content type detection\n const lineLower = trimmedLine.toLowerCase();\n const titleLower = currentItem.title?.toLowerCase() || '';\n const categoryLower = currentItem.category?.toLowerCase() || '';\n \n // Check for VOD indicators\n if (lineLower.includes('group-title=\"vod\"') || \n lineLower.includes('group-title=\"movies\"') ||\n lineLower.includes('group-title=\"cinema\"') ||\n categoryLower.includes('vod') ||\n categoryLower.includes('movies') ||\n categoryLower.includes('cinema') ||\n categoryLower.includes('أفلام') ||\n categoryLower.includes('afilm') ||\n categoryLower.includes('film') ||\n titleLower.includes('movie')) {\n currentItem.type = 'vod';\n }\n // Check for Series indicators\n else if (lineLower.includes('group-title=\"series\"') || \n lineLower.includes('group-title=\"tv shows\"') ||\n lineLower.includes('group-title=\"مسلسلات\"') ||\n categoryLower.includes('series') ||\n categoryLower.includes('tv shows') ||\n categoryLower.includes('tvshows') ||\n categoryLower.includes('مسلسلات') ||\n categoryLower.includes('mosalsalat') ||\n categoryLower.includes('season') ||\n titleLower.includes('s01') ||\n titleLower.includes('s1e') ||\n titleLower.includes(' e01') ||\n titleLower.includes(' e1 ') ||\n titleLower.includes(' episode ')) {\n currentItem.type = 'series';\n }\n // Check for Catch-up\n else if (lineLower.includes('group-title=\"catchup\"') ||\n lineLower.includes('group-title=\"catch-up\"') ||\n categoryLower.includes('catchup') ||\n categoryLower.includes('catch-up')) {\n currentItem.type = 'catchup';\n }\n // Default to live TV\n else {\n currentItem.type = 'live';\n }\n \n // Log every 100 lines for debugging\n if (lineCount % 100 === 0) {\n console.log(`[M3U Parser] 📝 Processed ${lineCount} lines, found ${items.length} items so far`);\n }\n \n } else if (trimmedLine && !trimmedLine.startsWith('#')) {\n // URL line\n if (currentItem.title) {\n currentItem.url = trimmedLine;\n items.push({ ...currentItem });\n currentItem = {};\n }\n }\n }\n \n console.log(`[M3U Parser] 📝 Total lines processed: ${lineCount}`);\n console.log(`[M3U Parser] 📝 Final item count: ${items.length}`);\n \n return items;\n}",[155],"7098ec2a-fdef-11f0-b183-42dde27851f2",["D",1769786527647],[28],"pulls","branches","forks","envVars",{"_171":60,"_173":60},"connections",{"_171":60,"_172":60},"count","unfilledCount","emptyCount",{"_43":161,"_32":28,"_30":31,"_133":-5,"_41":42,"_40":14,"_135":25,"_38":192,"_13":143,"_33":34,"_35":37,"_24":25,"_138":-5,"_180":193,"_27":194},{"_43":154,"_32":155,"_30":156,"_133":-5,"_41":42,"_40":157,"_135":25,"_38":189,"_13":134,"_33":34,"_35":159,"_24":25,"_138":-5,"_180":190,"_27":191},{"_43":147,"_32":148,"_30":149,"_133":-5,"_41":42,"_40":150,"_135":120,"_38":186,"_13":143,"_33":34,"_35":152,"_24":25,"_138":-5,"_180":187,"_27":188},{"_43":140,"_32":141,"_30":142,"_133":-5,"_41":42,"_40":143,"_135":120,"_38":183,"_13":60,"_33":34,"_35":145,"_24":25,"_138":-5,"_180":184,"_27":185},{"_43":130,"_32":131,"_30":132,"_133":-5,"_41":42,"_40":134,"_135":120,"_38":179,"_13":60,"_33":34,"_35":137,"_24":25,"_138":-5,"_180":181,"_27":182},["D",1769777420285],"children",[],[131],["D",1769774711804],[],[141],["D",1769781106825],[],[148],["D",1769786523853],[],[155],["D",1769786527647],[],[28],["D",1769774711707],{"_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":232,"_233":234,"_235":236,"_237":25,"_238":25,"_239":25,"_240":120,"_241":-5,"_242":-7,"_243":-7,"_244":60,"_245":25,"_246":25,"_247":-5,"_248":25,"_249":25,"_250":25,"_251":-5},"ENV",{"_203":204,"_205":206,"_207":84,"_208":209,"_210":211,"_212":213,"_214":215,"_216":217,"_218":219,"_220":221,"_222":223,"_224":225,"_226":227,"_228":229,"_230":231},"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 · v9