[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_374":375,"_376":377},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_280":-5,"_20":281,"_22":282,"_283":284,"_285":286,"_26":287,"_24":288,"_289":-5,"_290":-5,"_291":55,"_292":293,"_294":46,"_295":-5,"_296":-5,"_297":298},"routes/_app.x.$handle.$name.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":25,"_26":27,"_28":-5,"_29":-5,"_30":-5,"_31":-5,"_32":-5},"handle","horlumosey","name","clip-factory","branchName","main","version","path","shared","project",{"_34":223,"_13":14,"_47":224,"_225":-5,"_226":55,"_227":228,"_229":228,"_230":231,"_232":-5,"_233":234,"_235":-5,"_236":55,"_237":-5,"_238":-5,"_239":49,"_240":241,"_242":243,"_244":245,"_246":247,"_248":-5,"_249":250,"_251":250,"_252":253,"_254":253,"_255":253,"_256":250,"_257":250,"_258":259,"_260":261,"_262":263,"_264":55},"tree",[63,64,65,66,67,68,69],"file",{"_34":58,"_41":42,"_37":40,"_13":19,"_52":-5,"_50":59,"_17":49,"_39":-5,"_47":60,"_43":61,"_56":-5,"_18":62},"contents",[33],"upstream","pull","ahead","behind","envVars",{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_18":57},"id","fe27176a-3a99-11f1-ad7f-42b51c65c3df","types.ts","fileId","fe2718aa-3a99-11f1-ad7f-42b51c65c3df","parentId","f00b9fac-3a99-11f1-a961-42b51c65c3df","branchId","515248ac-3a99-11f1-9f63-42b51c65c3df","branchVersion",7,"latest",true,"createdAt",["D",1776456849340],0,"fileType","script","content","export interface Creator {\n id: number;\n name: string;\n platform: string;\n avatar_emoji: string;\n}\n\nexport interface Clip {\n id: number;\n creator_id: number;\n title: string;\n source_url: string | null;\n status: \"found\" | \"editing\" | \"uploaded\" | \"published\";\n ai_title: string | null;\n ai_description: string | null;\n views: number;\n likes: number;\n revenue: number;\n notes: string | null;\n scheduled_date: string | null;\n created_at: string;\n updated_at: string;\n creator_name?: string;\n avatar_emoji?: string;\n}\n\nexport type ClipStatus = \"found\" | \"editing\" | \"uploaded\" | \"published\";\n\nexport const STATUS_CONFIG: Record = {\n found: { label: \"Found\", emoji: \"🔍\", color: \"bg-blue-100 text-blue-800\" },\n editing: { label: \"Editing\", emoji: \"✂️\", color: \"bg-yellow-100 text-yellow-800\" },\n uploaded: { label: \"Uploaded\", emoji: \"📤\", color: \"bg-purple-100 text-purple-800\" },\n published: { label: \"Published\", emoji: \"🚀\", color: \"bg-green-100 text-green-800\" },\n};\n","deleted",false,"label",[19,36],"f00b9eee-3a99-11f1-a961-42b51c65c3df","directory",["D",1776456825549],4,[19],{"_34":198,"_13":199,"_37":200,"_39":-5,"_41":42,"_43":201,"_45":46,"_47":202,"_17":49,"_50":59,"_52":-5,"_54":55,"_56":-5,"_76":203,"_18":204},{"_34":111,"_13":112,"_37":113,"_39":-5,"_41":42,"_43":114,"_45":46,"_47":115,"_17":49,"_50":59,"_52":-5,"_54":55,"_56":-5,"_76":116,"_18":117},{"_34":58,"_13":19,"_37":40,"_39":-5,"_41":42,"_43":61,"_45":46,"_47":104,"_17":49,"_50":59,"_52":-5,"_54":55,"_56":-5,"_76":105,"_18":106},{"_34":97,"_13":98,"_37":99,"_39":-5,"_41":42,"_43":100,"_45":46,"_47":101,"_17":93,"_50":59,"_52":-5,"_54":55,"_56":-5,"_76":102,"_18":103},{"_34":88,"_13":89,"_37":90,"_39":-5,"_41":42,"_43":91,"_45":46,"_47":92,"_17":93,"_50":24,"_52":94,"_54":55,"_56":-5,"_76":95,"_18":96},{"_34":79,"_13":80,"_37":81,"_39":-5,"_41":42,"_43":82,"_45":46,"_47":83,"_17":61,"_50":84,"_52":85,"_54":55,"_56":-5,"_76":86,"_18":87},{"_34":70,"_13":71,"_37":72,"_39":-5,"_41":42,"_43":73,"_45":46,"_47":74,"_17":49,"_50":51,"_52":75,"_54":55,"_56":-5,"_76":77,"_18":78},"29ae4cf4-3a9b-11f1-a6cb-42b51c65c3df","new-file-9209.ts","29ae4dee-3a9b-11f1-a6cb-42b51c65c3df",21,["D",1776457351872],"","children",[],[71],"acac2ebe-3a9b-11f1-8554-42b51c65c3df","main.ts","515751d0-3a99-11f1-9f63-42b51c65c3df",25,["D",1776457571617],"http","import { Hono } from \"npm:hono@4\";\nimport { runMigrations } from \"./database/migrations.ts\";\nimport {\n getCreators,\n addCreator,\n getClips,\n addClip,\n updateClipStatus,\n updateClipAI,\n updateClipStats,\n deleteClip,\n getDashboardStats,\n getYoutubeLinks,\n addYoutubeLink,\n updateYoutubeLinkStatus,\n deleteYoutubeLink,\n} from \"./database/queries.ts\";\nimport { serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { parseVal } from \"https://esm.town/v/std/utils/index.ts\";\n\nconst app = new Hono();\n\n// Run migrations on startup\nlet migrated = false;\napp.use(\"*\", async (c, next) => {\n if (!migrated) {\n await runMigrations();\n migrated = true;\n }\n await next();\n});\n\n// --- API Routes ---\napp.get(\"/api/stats\", async (c) => {\n const stats = await getDashboardStats();\n return c.json(stats);\n});\n\napp.get(\"/api/creators\", async (c) => {\n const creators = await getCreators();\n return c.json(creators);\n});\n\napp.post(\"/api/creators\", async (c) => {\n const body = await c.req.json();\n await addCreator(body.name, body.platform || \"YouTube/Twitch\", body.avatar_emoji || \"🎮\");\n return c.json({ ok: true });\n});\n\napp.get(\"/api/clips\", async (c) => {\n const status = c.req.query(\"status\");\n const clips = await getClips(status);\n return c.json(clips);\n});\n\napp.post(\"/api/clips\", async (c) => {\n const body = await c.req.json();\n const id = await addClip(body);\n return c.json({ ok: true, id });\n});\n\napp.patch(\"/api/clips/:id/status\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n const { status } = await c.req.json();\n await updateClipStatus(id, status);\n return c.json({ ok: true });\n});\n\napp.patch(\"/api/clips/:id/stats\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n const { views, likes, revenue } = await c.req.json();\n await updateClipStats(id, views, likes, revenue);\n return c.json({ ok: true });\n});\n\napp.patch(\"/api/clips/:id/ai\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n const { ai_title, ai_description } = await c.req.json();\n await updateClipAI(id, ai_title, ai_description);\n return c.json({ ok: true });\n});\n\napp.post(\"/api/clips/:id/generate\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n const { title, creator_name } = await c.req.json();\n\n const apiKey = Deno.env.get(\"OPENAI_API_KEY\");\n if (!apiKey) {\n return c.json({ error: \"OpenAI API key not configured. Add OPENAI_API_KEY to env vars.\" }, 400);\n }\n\n const response = await fetch(\"https://api.openai.com/v1/chat/completions\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\", Authorization: `Bearer ${apiKey}` },\n body: JSON.stringify({\n model: \"gpt-4o-mini\",\n messages: [\n {\n role: \"system\",\n content: `You are a viral YouTube Shorts/clips expert. Generate a clickbait title and SEO description for a clip. \n The title should be attention-grabbing, use caps strategically, and be under 100 chars.\n The description should include relevant hashtags and keywords for YouTube SEO.\n Respond in JSON: {\"title\": \"...\", \"description\": \"...\"}`,\n },\n {\n role: \"user\",\n content: `Creator: ${creator_name}\\nOriginal clip title: ${title}\\nGenerate a viral YouTube title and description.`,\n },\n ],\n response_format: { type: \"json_object\" },\n }),\n });\n\n const data = await response.json();\n const result = JSON.parse(data.choices[0].message.content);\n await updateClipAI(id, result.title, result.description);\n return c.json({ ok: true, ai_title: result.title, ai_description: result.description });\n});\n\napp.delete(\"/api/clips/:id\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n await deleteClip(id);\n return c.json({ ok: true });\n});\n\n// --- YouTube Links ---\napp.get(\"/api/youtube-links\", async (c) => {\n const status = c.req.query(\"status\");\n const links = await getYoutubeLinks(status);\n return c.json(links);\n});\n\napp.post(\"/api/youtube-links\", async (c) => {\n const body = await c.req.json();\n const url: string = body.url || \"\";\n\n // Extract video ID from YouTube URL\n let videoId = \"\";\n try {\n const u = new URL(url);\n if (u.hostname.includes(\"youtu.be\")) {\n videoId = u.pathname.slice(1);\n } else if (u.hostname.includes(\"youtube.com\")) {\n videoId = u.searchParams.get(\"v\") || u.pathname.split(\"/\").pop() || \"\";\n }\n } catch {\n // not a valid URL\n }\n\n const thumbnailUrl = videoId ? `https://img.youtube.com/vi/${videoId}/hqdefault.jpg` : undefined;\n\n const id = await addYoutubeLink({\n url,\n video_id: videoId || undefined,\n video_title: body.video_title || undefined,\n channel_name: body.channel_name || undefined,\n thumbnail_url: thumbnailUrl,\n duration: body.duration || undefined,\n notes: body.notes || undefined,\n });\n return c.json({ ok: true, id, video_id: videoId, thumbnail_url: thumbnailUrl });\n});\n\napp.post(\"/api/youtube-links/:id/auto-clip\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n const { video_title, channel_name, creator_id } = await c.req.json();\n\n // Create a clip from this YouTube link\n const clipId = await addClip({\n creator_id: creator_id,\n title: video_title || \"YouTube Clip\",\n source_url: (await getYoutubeLinks()).find((l: any) => l.id === id)?.url || \"\",\n notes: `Auto-clipped from YouTube — ${channel_name || \"Unknown Channel\"}`,\n });\n\n await updateYoutubeLinkStatus(id, \"clipped\", Number(clipId));\n\n // If OpenAI key exists, auto-generate AI title\n const apiKey = Deno.env.get(\"OPENAI_API_KEY\");\n let aiResult = null;\n if (apiKey && video_title) {\n try {\n const response = await fetch(\"https://api.openai.com/v1/chat/completions\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\", Authorization: `Bearer ${apiKey}` },\n body: JSON.stringify({\n model: \"gpt-4o-mini\",\n messages: [\n {\n role: \"system\",\n content: `You are a viral YouTube Shorts/clips expert. Generate a clickbait title and SEO description for a clip.\n The title should be attention-grabbing, use caps strategically, and be under 100 chars.\n The description should include relevant hashtags and keywords for YouTube SEO.\n Respond in JSON: {\"title\": \"...\", \"description\": \"...\"}`,\n },\n {\n role: \"user\",\n content: `Creator: ${channel_name || \"Unknown\"}\\nOriginal video title: ${video_title}\\nGenerate a viral YouTube clip title and description.`,\n },\n ],\n response_format: { type: \"json_object\" },\n }),\n });\n const data = await response.json();\n aiResult = JSON.parse(data.choices[0].message.content);\n await updateClipAI(Number(clipId), aiResult.title, aiResult.description);\n } catch {\n // AI generation failed, that's okay\n }\n }\n\n return c.json({ ok: true, clip_id: clipId, ai: aiResult });\n});\n\napp.patch(\"/api/youtube-links/:id/status\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n const { status } = await c.req.json();\n await updateYoutubeLinkStatus(id, status);\n return c.json({ ok: true });\n});\n\napp.delete(\"/api/youtube-links/:id\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n await deleteYoutubeLink(id);\n return c.json({ ok: true });\n});\n\n// --- Source ---\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\n// --- Frontend ---\napp.get(\"/frontend/*\", (c) => serveFile(c.req.path));\napp.get(\"/shared/*\", (c) => serveFile(c.req.path));\napp.get(\"/\", (c) => serveFile(\"/frontend/index.html\"));\n\napp.onError((err) => Promise.reject(err));\n\nexport default app.fetch;\n",[],[80],"e18ae328-3a9b-11f1-8554-42b51c65c3df","README.md","5340b968-3a9a-11f1-8e67-42b51c65c3df",28,["D",1776457660328],1,"# 🎬 ClipFactory - Faceless YouTube Dashboard\n\nYour command center for running a faceless YouTube clips channel. Track clips from top creators like IShowSpeed, Kai Cenat, Duke Dennis, and more.\n\n## Features\n\n- **📊 Dashboard** — See total clips, views, likes, revenue, and top performers at a glance\n- **🎞️ Clip Pipeline** — Track clips through stages: Found → Editing → Uploaded → Published\n- **📺 YouTube Clipper** — Paste YouTube links, auto-extract thumbnails, and instantly create clips\n- **⚡ Auto Clip** — One-click: YouTube link → clip entry + AI-generated viral title\n- **🤖 AI Title Generator** — Generate viral YouTube titles & SEO descriptions with OpenAI\n- **📈 Analytics Tracking** — Log views, likes, and revenue per clip\n- **👥 Creator Management** — Pre-loaded with popular creators (Speed, Kai, Duke, etc.)\n\n## Setup\n\n### AI Title Generation (Optional)\nTo enable AI-powered title/description generation:\n1. Get an API key from [OpenAI](https://platform.openai.com/api-keys)\n2. Add it as an environment variable: `OPENAI_API_KEY`\n\n## Architecture\n\n```mermaid\ngraph TB\n Browser[🌐 Browser] --> Hono[Hono API - main.ts]\n Hono --> DB[(SQLite Database)]\n Hono --> OpenAI[🤖 OpenAI API]\n Hono --> Static[📁 Static Files]\n Static --> React[⚛️ React Frontend]\n \n subgraph YouTube Clipper\n YT[📺 Paste YouTube Link] --> Preview[🖼️ Auto Thumbnail]\n Preview --> Queue[📋 Link Queue]\n Queue --> AutoClip[⚡ Auto Clip]\n AutoClip --> AI[🤖 AI Title Gen]\n AutoClip --> Clip[🎞️ Clip Created]\n end\n```\n\n## Pre-loaded Creators\n⚡ IShowSpeed · 🔥 Kai Cenat · 🏀 Duke Dennis · 🎰 Adin Ross · 🎮 xQc · 💰 MrBeast · 🇬🇧 Beta Squad · 😂 Sketch\n",[],[89],"fd9db3f2-3a9a-11f1-9ba9-42b51c65c3df","untitled-folder-3964","f9e950c2-3a9a-11f1-8ff9-42b51c65c3df",20,["D",1776457277914],[],[98],["D",1776456825549],[107],[19],{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":108,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_76":109,"_18":110},["D",1776456849340],[],[19,36],"efbce808-3a99-11f1-ac31-42b51c65c3df","frontend","efbce8e4-3a99-11f1-ac31-42b51c65c3df",3,["D",1776456825159],[118,119,120,121],[112],{"_34":146,"_13":147,"_37":148,"_39":113,"_41":42,"_43":149,"_45":46,"_47":150,"_17":49,"_50":59,"_52":-5,"_54":55,"_56":-5,"_76":151,"_18":152},{"_34":138,"_13":139,"_37":140,"_39":113,"_41":42,"_43":141,"_45":46,"_47":142,"_17":93,"_50":51,"_52":143,"_54":55,"_56":-5,"_76":144,"_18":145},{"_34":130,"_13":131,"_37":132,"_39":113,"_41":42,"_43":133,"_45":46,"_47":134,"_17":49,"_50":24,"_52":135,"_54":55,"_56":-5,"_76":136,"_18":137},{"_34":122,"_13":123,"_37":124,"_39":113,"_41":42,"_43":125,"_45":46,"_47":126,"_17":49,"_50":51,"_52":127,"_54":55,"_56":-5,"_76":128,"_18":129},"0f877a7c-3a9a-11f1-94dc-42b51c65c3df","index.tsx","0f877b3a-3a9a-11f1-94dc-42b51c65c3df",11,["D",1776456878499],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport ReactDOM from \"https://esm.sh/react-dom@18.2.0/client\";\nimport { App } from \"./App.tsx\";\n\nconst root = ReactDOM.createRoot(document.getElementById(\"root\")!);\nroot.render();\n",[],[112,123],"0d292064-3a9a-11f1-8ea3-42b51c65c3df","index.html","0d292276-3a9a-11f1-8ea3-42b51c65c3df",10,["D",1776456874528],"\n\n\n \n \n 🎬 ClipFactory - Faceless YouTube Dashboard\n \n \n \n \n \n\n\n

\n \n\n\n",[],[112,131],"d04dcf80-3a9b-11f1-8393-42b51c65c3df","App.tsx","16fb02d8-3a9a-11f1-94dc-42b51c65c3df",27,["D",1776457631404],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect, useCallback } from \"https://esm.sh/react@18.2.0\";\nimport { Dashboard } from \"./components/Dashboard.tsx\";\nimport { ClipBoard } from \"./components/ClipBoard.tsx\";\nimport { AddClipModal } from \"./components/AddClipModal.tsx\";\nimport { YouTubeClipper } from \"./components/YouTubeClipper.tsx\";\n\ntype Tab = \"dashboard\" | \"clips\" | \"youtube\";\n\nexport function App() {\n const [tab, setTab] = useState(\"dashboard\");\n const [showAddClip, setShowAddClip] = useState(false);\n const [refreshKey, setRefreshKey] = useState(0);\n\n const refresh = useCallback(() => setRefreshKey((k) => k + 1), []);\n\n return (\n

\n {/* Header */}\n

\n 🎬\n

\n ClipFactory\n

\n setTab(\"dashboard\")}\n className={`px-4 py-2 rounded-lg text-sm font-medium transition ${\n tab === \"dashboard\" ? \"bg-red-600 text-white\" : \"text-gray-400 hover:text-white hover:bg-gray-800\"\n }`}\n >\n 📊 Dashboard\n \n setTab(\"clips\")}\n className={`px-4 py-2 rounded-lg text-sm font-medium transition ${\n tab === \"clips\" ? \"bg-red-600 text-white\" : \"text-gray-400 hover:text-white hover:bg-gray-800\"\n }`}\n >\n 🎞️ Clips\n \n setTab(\"youtube\")}\n className={`px-4 py-2 rounded-lg text-sm font-medium transition ${\n tab === \"youtube\" ? \"bg-red-600 text-white\" : \"text-gray-400 hover:text-white hover:bg-gray-800\"\n }`}\n >\n 📺 YouTube\n \n setShowAddClip(true)}\n className=\"ml-2 px-4 py-2 bg-red-600 hover:bg-red-700 rounded-lg text-sm font-bold transition\"\n >\n + New Clip\n \n

\n\n {/* Content */}\n

\n {tab === \"dashboard\" && }\n {tab === \"clips\" && }\n {tab === \"youtube\" && }\n

\n\n {/* Footer */}\n \n\n {/* Modal */}\n {showAddClip && (\n setShowAddClip(false)}\n onSaved={() => {\n setShowAddClip(false);\n refresh();\n setTab(\"clips\");\n }}\n />\n )}\n

\n );\n}\n",[],[112,139],"18a18c6a-3a9a-11f1-8ea3-42b51c65c3df","components","18a18d0a-3a9a-11f1-8ea3-42b51c65c3df",13,["D",1776456893773],[153,154,155,156,157],[112,147],{"_34":190,"_13":191,"_37":192,"_39":148,"_41":42,"_43":193,"_45":46,"_47":194,"_17":49,"_50":51,"_52":195,"_54":55,"_56":-5,"_76":196,"_18":197},{"_34":182,"_13":183,"_37":184,"_39":148,"_41":42,"_43":185,"_45":46,"_47":186,"_17":49,"_50":51,"_52":187,"_54":55,"_56":-5,"_76":188,"_18":189},{"_34":174,"_13":175,"_37":176,"_39":148,"_41":42,"_43":177,"_45":46,"_47":178,"_17":49,"_50":51,"_52":179,"_54":55,"_56":-5,"_76":180,"_18":181},{"_34":166,"_13":167,"_37":168,"_39":148,"_41":42,"_43":169,"_45":46,"_47":170,"_17":49,"_50":51,"_52":171,"_54":55,"_56":-5,"_76":172,"_18":173},{"_34":158,"_13":159,"_37":160,"_39":148,"_41":42,"_43":161,"_45":46,"_47":162,"_17":49,"_50":51,"_52":163,"_54":55,"_56":-5,"_76":164,"_18":165},"c7e5e4a4-3a9b-11f1-8554-42b51c65c3df","YouTubeClipper.tsx","c7e5e56c-3a9b-11f1-8554-42b51c65c3df",26,["D",1776457617312],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\n\nconst LINK_STATUSES = [\n { key: \"\", label: \"All\", emoji: \"📋\" },\n { key: \"queued\", label: \"Queued\", emoji: \"⏳\" },\n { key: \"clipping\", label: \"Clipping\", emoji: \"✂️\" },\n { key: \"clipped\", label: \"Clipped\", emoji: \"✅\" },\n { key: \"failed\", label: \"Failed\", emoji: \"❌\" },\n];\n\nfunction getStatusBadge(status: string) {\n switch (status) {\n case \"queued\": return { bg: \"bg-blue-900/50 border-blue-700\", text: \"text-blue-400\", label: \"⏳ Queued\" };\n case \"clipping\": return { bg: \"bg-yellow-900/50 border-yellow-700\", text: \"text-yellow-400\", label: \"✂️ Clipping\" };\n case \"clipped\": return { bg: \"bg-green-900/50 border-green-700\", text: \"text-green-400\", label: \"✅ Clipped\" };\n case \"failed\": return { bg: \"bg-red-900/50 border-red-700\", text: \"text-red-400\", label: \"❌ Failed\" };\n default: return { bg: \"bg-gray-800 border-gray-700\", text: \"text-gray-400\", label: status };\n }\n}\n\nexport function YouTubeClipper({ onRefresh }: { onRefresh: () => void }) {\n const [links, setLinks] = useState([]);\n const [creators, setCreators] = useState([]);\n const [filter, setFilter] = useState(\"\");\n const [loading, setLoading] = useState(true);\n\n // Add link form\n const [url, setUrl] = useState(\"\");\n const [videoTitle, setVideoTitle] = useState(\"\");\n const [channelName, setChannelName] = useState(\"\");\n const [notes, setNotes] = useState(\"\");\n const [adding, setAdding] = useState(false);\n const [preview, setPreview] = useState<{ videoId: string; thumbnail: string } | null>(null);\n\n const loadLinks = () => {\n setLoading(true);\n const endpoint = filter ? `/api/youtube-links?status=${filter}` : \"/api/youtube-links\";\n fetch(endpoint)\n .then((r) => r.json())\n .then((d) => { setLinks(d); setLoading(false); })\n .catch(() => setLoading(false));\n };\n\n useEffect(() => { loadLinks(); }, [filter]);\n useEffect(() => {\n fetch(\"/api/creators\").then((r) => r.json()).then(setCreators);\n }, []);\n\n // Auto-preview YouTube thumbnail when URL changes\n useEffect(() => {\n if (!url) { setPreview(null); return; }\n try {\n const u = new URL(url);\n let videoId = \"\";\n if (u.hostname.includes(\"youtu.be\")) {\n videoId = u.pathname.slice(1);\n } else if (u.hostname.includes(\"youtube.com\")) {\n videoId = u.searchParams.get(\"v\") || u.pathname.split(\"/\").pop() || \"\";\n }\n if (videoId) {\n setPreview({ videoId, thumbnail: `https://img.youtube.com/vi/${videoId}/hqdefault.jpg` });\n } else {\n setPreview(null);\n }\n } catch {\n setPreview(null);\n }\n }, [url]);\n\n const handleAddLink = async (e: React.FormEvent) => {\n e.preventDefault();\n if (!url) return;\n setAdding(true);\n await fetch(\"/api/youtube-links\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ url, video_title: videoTitle, channel_name: channelName, notes }),\n });\n setUrl(\"\"); setVideoTitle(\"\"); setChannelName(\"\"); setNotes(\"\"); setPreview(null);\n setAdding(false);\n loadLinks();\n };\n\n const handleAutoClip = async (link: any) => {\n const creatorId = prompt(\"Enter creator ID to assign this clip to (check Clips tab for IDs), or leave blank for first creator:\");\n const cId = creatorId ? Number(creatorId) : (creators[0]?.id || 1);\n\n await fetch(`/api/youtube-links/${link.id}/status`, {\n method: \"PATCH\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ status: \"clipping\" }),\n });\n loadLinks();\n\n const res = await fetch(`/api/youtube-links/${link.id}/auto-clip`, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({\n video_title: link.video_title || \"YouTube Clip\",\n channel_name: link.channel_name || \"\",\n creator_id: cId,\n }),\n });\n const data = await res.json();\n if (data.ok) {\n loadLinks();\n onRefresh();\n alert(data.ai ? `✅ Clip created with AI title:\\n\"${data.ai.title}\"` : \"✅ Clip created! Go to Clips tab to see it.\");\n }\n };\n\n const handleDelete = async (id: number) => {\n if (!confirm(\"Remove this YouTube link?\")) return;\n await fetch(`/api/youtube-links/${id}`, { method: \"DELETE\" });\n loadLinks();\n };\n\n return (\n

\n {/* Auto Clip Section */}\n

\n 🎥\n

Auto Clip from YouTube

Paste a YouTube link → auto-extract info → create clip instantly

\n\n

\n {/* URL Input */}\n

\n setUrl(e.target.value)}\n required\n placeholder=\"https://www.youtube.com/watch?v=... or https://youtu.be/...\"\n className=\"w-full bg-gray-900 border border-gray-700 rounded-xl px-4 py-3 text-white placeholder-gray-500 focus:border-red-500 focus:outline-none text-lg\"\n />\n {preview && (\n

\n ✓ Valid\n

\n )}\n

\n\n {/* Preview */}\n {preview && (\n

\n \n

\n setVideoTitle(e.target.value)}\n placeholder=\"Video title (optional — helps AI generate better clip titles)\"\n className=\"w-full bg-gray-800 border border-gray-700 rounded-lg px-3 py-2 text-sm text-white placeholder-gray-500\"\n />\n setChannelName(e.target.value)}\n placeholder=\"Channel name (optional)\"\n className=\"w-full bg-gray-800 border border-gray-700 rounded-lg px-3 py-2 text-sm text-white placeholder-gray-500\"\n />\n

\n )}\n\n {/* Notes */}\n setNotes(e.target.value)}\n placeholder=\"Clip notes — timestamps, ideas, section to clip (optional)\"\n rows={2}\n className=\"w-full bg-gray-900 border border-gray-700 rounded-xl px-4 py-3 text-white placeholder-gray-500 resize-none text-sm\"\n />\n\n {/* Submit */}\n \n {adding ? \"⏳ Adding...\" : \"🎬 Add to Clip Queue\"}\n \n \n

\n\n {/* YouTube Link Queue */}\n

\n 📺 YouTube Link Queue\n ({links.length} links)\n

\n\n {/* Filters */}\n

\n {LINK_STATUSES.map((s) => (\n setFilter(s.key)}\n className={`px-4 py-2 rounded-lg text-sm font-medium transition ${\n filter === s.key\n ? \"bg-red-600 text-white\"\n : \"bg-gray-800 text-gray-400 hover:bg-gray-700 hover:text-white\"\n }`}\n >\n {s.emoji} {s.label}\n \n ))}\n

\n\n {/* Links Grid */}\n {loading ? (\n

Loading links...

\n ) : links.length === 0 ? (\n

📺

No YouTube links yet

Paste a YouTube URL above to start building your clip queue!

\n ) : (\n

\n {links.map((link) => {\n const badge = getStatusBadge(link.status);\n return (\n

\n {/* Thumbnail */}\n {link.thumbnail_url && (\n \n \n \n )}\n\n

\n {/* Title & Channel */}\n

\n {link.video_title && (\n

{link.video_title}

\n )}\n {link.channel_name && (\n

📺 {link.channel_name}

\n )}\n {!link.video_title && !link.channel_name && (\n \n 🔗 {link.url}\n \n )}\n

\n\n {/* Notes */}\n {link.notes && (\n

📝 {link.notes}

\n )}\n\n {/* Status & Actions */}\n

\n {badge.label}\n {new Date(link.created_at).toLocaleDateString()}\n

\n\n

\n {link.status === \"queued\" && (\n handleAutoClip(link)}\n className=\"flex-1 py-2 bg-gradient-to-r from-red-600 to-pink-600 hover:from-red-700 hover:to-pink-700 rounded-lg text-xs font-bold transition\"\n >\n ⚡ Auto Clip\n \n )}\n \n 🔗 Open\n \n handleDelete(link.id)}\n className=\"px-3 py-2 bg-white/5 hover:bg-red-900/50 rounded-lg text-xs text-gray-500 hover:text-red-400 transition\"\n >\n 🗑️\n \n

\n\n {link.status === \"clipped\" && link.clip_id && (\n

\n ✅ Clip #{link.clip_id} created — check the Clips tab!\n

\n )}\n

\n );\n })}\n

\n )}\n

\n );\n}\n",[],[112,147,159],"24cfcf1a-3a9a-11f1-ad7f-42b51c65c3df","Dashboard.tsx","24cfcfec-3a9a-11f1-ad7f-42b51c65c3df",14,["D",1776456914208],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\n\nexport function Dashboard() {\n const [stats, setStats] = useState(null);\n const [loading, setLoading] = useState(true);\n\n useEffect(() => {\n fetch(\"/api/stats\")\n .then((r) => r.json())\n .then((d) => { setStats(d); setLoading(false); })\n .catch(() => setLoading(false));\n }, []);\n\n if (loading) {\n return

Loading dashboard...

;\n }\n\n const statusMap: Record = {};\n (stats?.byStatus || []).forEach((s: any) => { statusMap[s.status] = s.count; });\n\n const statCards = [\n { label: \"Total Clips\", value: stats?.totalClips ?? 0, emoji: \"🎬\", color: \"from-blue-600 to-blue-800\" },\n { label: \"Found\", value: statusMap[\"found\"] ?? 0, emoji: \"🔍\", color: \"from-cyan-600 to-cyan-800\" },\n { label: \"Editing\", value: statusMap[\"editing\"] ?? 0, emoji: \"✂️\", color: \"from-yellow-600 to-yellow-800\" },\n { label: \"Uploaded\", value: statusMap[\"uploaded\"] ?? 0, emoji: \"📤\", color: \"from-purple-600 to-purple-800\" },\n { label: \"Published\", value: statusMap[\"published\"] ?? 0, emoji: \"🚀\", color: \"from-green-600 to-green-800\" },\n ];\n\n const totals = stats?.totals || {};\n\n return (\n

\n {/* Welcome */}\n

Welcome to ClipFactory 🎬

Your faceless YouTube clip empire starts here. Track, edit, and publish viral clips.

\n\n {/* Stat Cards */}\n

\n {statCards.map((card) => (\n

{card.emoji}

{card.value}

{card.label}

\n ))}\n

\n\n {/* Revenue Stats */}\n

\n 👀\n Total Views\n

{Number(totals.total_views || 0).toLocaleString()}

\n 👍\n Total Likes\n

{Number(totals.total_likes || 0).toLocaleString()}

\n 💰\n Total Revenue\n

${Number(totals.total_revenue || 0).toFixed(2)}

\n\n {/* Top Clips */}\n

🏆 Top Performing Clips

\n {(stats?.topClips || []).length === 0 ? (\n

No clips yet. Add your first clip to get started!

\n ) : (\n

\n {(stats?.topClips || []).map((clip: any, i: number) => (\n

\n #{i + 1}\n {clip.avatar_emoji}\n

{clip.ai_title || clip.title}

{clip.creator_name}

{Number(clip.views).toLocaleString()} views

${Number(clip.revenue).toFixed(2)}

\n ))}\n

\n )}\n

\n );\n}\n",[],[112,147,167],"3a095fea-3a9a-11f1-a019-42b51c65c3df","ClipCard.tsx","3a0960d0-3a9a-11f1-a019-42b51c65c3df",16,["D",1776456949817],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\n\nconst STATUS_OPTIONS = [\n { value: \"found\", label: \"🔍 Found\", bg: \"bg-blue-900/50 border-blue-700\" },\n { value: \"editing\", label: \"✂️ Editing\", bg: \"bg-yellow-900/50 border-yellow-700\" },\n { value: \"uploaded\", label: \"📤 Uploaded\", bg: \"bg-purple-900/50 border-purple-700\" },\n { value: \"published\", label: \"🚀 Published\", bg: \"bg-green-900/50 border-green-700\" },\n];\n\nfunction getStatusStyle(status: string) {\n return STATUS_OPTIONS.find((s) => s.value === status) || STATUS_OPTIONS[0];\n}\n\nexport function ClipCard({\n clip,\n onStatusChange,\n onDelete,\n onGenerate,\n onUpdateStats,\n}: {\n clip: any;\n onStatusChange: (id: number, status: string) => void;\n onDelete: (id: number) => void;\n onGenerate: (id: number, title: string, creatorName: string) => void;\n onUpdateStats: (id: number, views: number, likes: number, revenue: number) => void;\n}) {\n const [showStats, setShowStats] = useState(false);\n const [views, setViews] = useState(String(clip.views || 0));\n const [likes, setLikes] = useState(String(clip.likes || 0));\n const [revenue, setRevenue] = useState(String(clip.revenue || 0));\n const [generating, setGenerating] = useState(false);\n\n const statusStyle = getStatusStyle(clip.status);\n\n const handleGenerate = async () => {\n setGenerating(true);\n await onGenerate(clip.id, clip.title, clip.creator_name);\n setGenerating(false);\n };\n\n const handleSaveStats = () => {\n onUpdateStats(clip.id, Number(views), Number(likes), Number(revenue));\n setShowStats(false);\n };\n\n const nextStatus = () => {\n const order = [\"found\", \"editing\", \"uploaded\", \"published\"];\n const idx = order.indexOf(clip.status);\n if (idx < order.length - 1) {\n onStatusChange(clip.id, order[idx + 1]);\n }\n };\n\n return (\n

\n {/* Header */}\n

\n {clip.avatar_emoji}\n

{clip.title}

{clip.creator_name}

\n \n

\n\n {/* AI Generated Title */}\n {clip.ai_title && (\n

🤖 AI Title

{clip.ai_title}

\n {clip.ai_description && (\n

{clip.ai_description}

\n )}\n

\n )}\n\n {/* Source Link */}\n {clip.source_url && (\n \n 🔗 {clip.source_url}\n \n )}\n\n {/* Stats Row */}\n {clip.status === \"published\" && (\n

\n 👀 {Number(clip.views).toLocaleString()}\n 👍 {Number(clip.likes).toLocaleString()}\n 💰 ${Number(clip.revenue).toFixed(2)}\n

\n )}\n\n {/* Stats Editor */}\n {showStats && (\n

\n Views\n setViews(e.target.value)}\n className=\"w-full bg-gray-800 border border-gray-700 rounded px-2 py-1 text-sm\" />\n

\n Likes\n setLikes(e.target.value)}\n className=\"w-full bg-gray-800 border border-gray-700 rounded px-2 py-1 text-sm\" />\n

\n Revenue $\n setRevenue(e.target.value)}\n className=\"w-full bg-gray-800 border border-gray-700 rounded px-2 py-1 text-sm\" />\n

\n \n

\n )}\n\n {/* Actions */}\n

\n {clip.status !== \"published\" && (\n \n )}\n \n {generating ? \"⏳ Generating...\" : \"🤖 AI Title\"}\n \n setShowStats(!showStats)}\n className=\"px-3 py-1.5 bg-white/10 hover:bg-white/20 rounded-lg text-xs font-medium transition\"\n >\n 📊 Stats\n \n

\n\n {/* Date & Status Badge */}\n

\n {new Date(clip.created_at).toLocaleDateString()}\n onStatusChange(clip.id, e.target.value)}\n className=\"text-xs bg-transparent border border-white/10 rounded px-2 py-1 text-gray-300\"\n >\n {STATUS_OPTIONS.map((s) => (\n \n ))}\n \n

\n );\n}\n",[],[112,147,175],"2b73e6da-3a9a-11f1-8ea3-42b51c65c3df","ClipBoard.tsx","2b73e798-3a9a-11f1-8ea3-42b51c65c3df",15,["D",1776456925350],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport { ClipCard } from \"./ClipCard.tsx\";\n\nconst STATUSES = [\n { key: \"\", label: \"All\", emoji: \"📋\" },\n { key: \"found\", label: \"Found\", emoji: \"🔍\" },\n { key: \"editing\", label: \"Editing\", emoji: \"✂️\" },\n { key: \"uploaded\", label: \"Uploaded\", emoji: \"📤\" },\n { key: \"published\", label: \"Published\", emoji: \"🚀\" },\n];\n\nexport function ClipBoard({ onRefresh }: { onRefresh: () => void }) {\n const [clips, setClips] = useState([]);\n const [filter, setFilter] = useState(\"\");\n const [loading, setLoading] = useState(true);\n\n const loadClips = () => {\n setLoading(true);\n const url = filter ? `/api/clips?status=${filter}` : \"/api/clips\";\n fetch(url)\n .then((r) => r.json())\n .then((d) => { setClips(d); setLoading(false); })\n .catch(() => setLoading(false));\n };\n\n useEffect(() => { loadClips(); }, [filter]);\n\n const handleStatusChange = async (id: number, status: string) => {\n await fetch(`/api/clips/${id}/status`, {\n method: \"PATCH\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ status }),\n });\n loadClips();\n onRefresh();\n };\n\n const handleDelete = async (id: number) => {\n if (!confirm(\"Delete this clip?\")) return;\n await fetch(`/api/clips/${id}`, { method: \"DELETE\" });\n loadClips();\n onRefresh();\n };\n\n const handleGenerate = async (id: number, title: string, creatorName: string) => {\n const res = await fetch(`/api/clips/${id}/generate`, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ title, creator_name: creatorName }),\n });\n const data = await res.json();\n if (data.error) {\n alert(data.error);\n return;\n }\n loadClips();\n };\n\n const handleUpdateStats = async (id: number, views: number, likes: number, revenue: number) => {\n await fetch(`/api/clips/${id}/stats`, {\n method: \"PATCH\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ views, likes, revenue }),\n });\n loadClips();\n onRefresh();\n };\n\n return (\n

\n {/* Filters */}\n

\n {STATUSES.map((s) => (\n setFilter(s.key)}\n className={`px-4 py-2 rounded-lg text-sm font-medium transition ${\n filter === s.key\n ? \"bg-red-600 text-white\"\n : \"bg-gray-800 text-gray-400 hover:bg-gray-700 hover:text-white\"\n }`}\n >\n {s.emoji} {s.label}\n \n ))}\n

\n\n {/* Clips */}\n {loading ? (\n

Loading clips...

\n ) : clips.length === 0 ? (\n

🎬

No clips yet

Click \"+ New Clip\" to add your first clip!

\n ) : (\n

\n {clips.map((clip) => (\n \n ))}\n

\n )}\n

\n );\n}\n",[],[112,147,183],"40f6be60-3a9a-11f1-981e-42b51c65c3df","AddClipModal.tsx","40f6bf14-3a9a-11f1-981e-42b51c65c3df",17,["D",1776456961434],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\n\nexport function AddClipModal({ onClose, onSaved }: { onClose: () => void; onSaved: () => void }) {\n const [creators, setCreators] = useState([]);\n const [creatorId, setCreatorId] = useState(\"\");\n const [title, setTitle] = useState(\"\");\n const [sourceUrl, setSourceUrl] = useState(\"\");\n const [notes, setNotes] = useState(\"\");\n const [saving, setSaving] = useState(false);\n\n useEffect(() => {\n fetch(\"/api/creators\").then((r) => r.json()).then(setCreators);\n }, []);\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n if (!creatorId || !title) return;\n setSaving(true);\n await fetch(\"/api/clips\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({\n creator_id: Number(creatorId),\n title,\n source_url: sourceUrl || undefined,\n notes: notes || undefined,\n }),\n });\n onSaved();\n };\n\n return (\n

e.stopPropagation()}>\n

🎬 Add New Clip

\n \n

\n\n

\n {/* Creator */}\n

\n Creator\n setCreatorId(e.target.value)}\n required\n className=\"w-full bg-gray-800 border border-gray-700 rounded-lg px-3 py-2 text-white\"\n >\n \n {creators.map((c: any) => (\n \n ))}\n \n

\n\n {/* Title */}\n

\n Clip Title / Description\n setTitle(e.target.value)}\n required\n placeholder=\"e.g. Speed rages at Minecraft...\"\n className=\"w-full bg-gray-800 border border-gray-700 rounded-lg px-3 py-2 text-white placeholder-gray-500\"\n />\n

\n\n {/* Source URL */}\n

\n Source URL (optional)\n setSourceUrl(e.target.value)}\n placeholder=\"https://twitch.tv/clip/...\"\n className=\"w-full bg-gray-800 border border-gray-700 rounded-lg px-3 py-2 text-white placeholder-gray-500\"\n />\n

\n\n {/* Notes */}\n

\n Notes (optional)\n setNotes(e.target.value)}\n placeholder=\"Timestamp, ideas, etc.\"\n rows={2}\n className=\"w-full bg-gray-800 border border-gray-700 rounded-lg px-3 py-2 text-white placeholder-gray-500 resize-none\"\n />\n

\n\n {/* Submit */}\n \n {saving ? \"Saving...\" : \"🎬 Add Clip\"}\n \n \n

\n );\n}\n",[],[112,147,191],"ef9e7a80-3a99-11f1-ac31-42b51c65c3df","database","ef9e7b48-3a99-11f1-ac31-42b51c65c3df",2,["D",1776456824834],[205,206],[199],{"_34":215,"_13":216,"_37":217,"_39":200,"_41":42,"_43":218,"_45":46,"_47":219,"_17":93,"_50":51,"_52":220,"_54":55,"_56":-5,"_76":221,"_18":222},{"_34":207,"_13":208,"_37":209,"_39":200,"_41":42,"_43":210,"_45":46,"_47":211,"_17":93,"_50":51,"_52":212,"_54":55,"_56":-5,"_76":213,"_18":214},"9eff5ac0-3a9b-11f1-b922-42b51c65c3df","queries.ts","fba59606-3a99-11f1-a961-42b51c65c3df",23,["D",1776457548685],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// --- Creators ---\nexport async function getCreators() {\n const res = await sqlite.execute(\"SELECT * FROM creators ORDER BY name\");\n return res.rows;\n}\n\nexport async function addCreator(name: string, platform: string, emoji: string) {\n await sqlite.execute({\n sql: \"INSERT INTO creators (name, platform, avatar_emoji) VALUES (?, ?, ?)\",\n args: [name, platform, emoji],\n });\n}\n\n// --- Clips ---\nexport async function getClips(status?: string) {\n if (status) {\n const res = await sqlite.execute({\n sql: `SELECT c.*, cr.name as creator_name, cr.avatar_emoji \n FROM clips c JOIN creators cr ON c.creator_id = cr.id \n WHERE c.status = ? ORDER BY c.created_at DESC`,\n args: [status],\n });\n return res.rows;\n }\n const res = await sqlite.execute(\n `SELECT c.*, cr.name as creator_name, cr.avatar_emoji \n FROM clips c JOIN creators cr ON c.creator_id = cr.id \n ORDER BY c.created_at DESC`,\n );\n return res.rows;\n}\n\nexport async function addClip(clip: {\n creator_id: number;\n title: string;\n source_url?: string;\n notes?: string;\n scheduled_date?: string;\n}) {\n const res = await sqlite.execute({\n sql: `INSERT INTO clips (creator_id, title, source_url, notes, scheduled_date) \n VALUES (?, ?, ?, ?, ?)`,\n args: [clip.creator_id, clip.title, clip.source_url || null, clip.notes || null, clip.scheduled_date || null],\n });\n return res.lastInsertRowid;\n}\n\nexport async function updateClipStatus(id: number, status: string) {\n await sqlite.execute({\n sql: \"UPDATE clips SET status = ?, updated_at = datetime('now') WHERE id = ?\",\n args: [status, id],\n });\n}\n\nexport async function updateClipAI(id: number, aiTitle: string, aiDescription: string) {\n await sqlite.execute({\n sql: \"UPDATE clips SET ai_title = ?, ai_description = ?, updated_at = datetime('now') WHERE id = ?\",\n args: [aiTitle, aiDescription, id],\n });\n}\n\nexport async function updateClipStats(id: number, views: number, likes: number, revenue: number) {\n await sqlite.execute({\n sql: \"UPDATE clips SET views = ?, likes = ?, revenue = ?, updated_at = datetime('now') WHERE id = ?\",\n args: [views, likes, revenue, id],\n });\n}\n\nexport async function deleteClip(id: number) {\n await sqlite.execute({ sql: \"DELETE FROM clips WHERE id = ?\", args: [id] });\n}\n\n// --- Stats ---\nexport async function getDashboardStats() {\n const total = await sqlite.execute(\"SELECT COUNT(*) as count FROM clips\");\n const byStatus = await sqlite.execute(\n \"SELECT status, COUNT(*) as count FROM clips GROUP BY status\",\n );\n const totalViews = await sqlite.execute(\n \"SELECT COALESCE(SUM(views),0) as total_views, COALESCE(SUM(likes),0) as total_likes, COALESCE(SUM(revenue),0) as total_revenue FROM clips\",\n );\n const topClips = await sqlite.execute(\n `SELECT c.*, cr.name as creator_name, cr.avatar_emoji \n FROM clips c JOIN creators cr ON c.creator_id = cr.id \n ORDER BY c.views DESC LIMIT 5`,\n );\n return {\n totalClips: total.rows[0]?.count ?? 0,\n byStatus: byStatus.rows,\n totals: totalViews.rows[0] ?? { total_views: 0, total_likes: 0, total_revenue: 0 },\n topClips: topClips.rows,\n };\n}\n\n// --- YouTube Links ---\nexport async function getYoutubeLinks(status?: string) {\n if (status) {\n const res = await sqlite.execute({\n sql: \"SELECT * FROM youtube_links WHERE status = ? ORDER BY created_at DESC\",\n args: [status],\n });\n return res.rows;\n }\n const res = await sqlite.execute(\"SELECT * FROM youtube_links ORDER BY created_at DESC\");\n return res.rows;\n}\n\nexport async function addYoutubeLink(data: {\n url: string;\n video_id?: string;\n video_title?: string;\n channel_name?: string;\n thumbnail_url?: string;\n duration?: string;\n notes?: string;\n}) {\n const res = await sqlite.execute({\n sql: `INSERT INTO youtube_links (url, video_id, video_title, channel_name, thumbnail_url, duration, notes)\n VALUES (?, ?, ?, ?, ?, ?, ?)`,\n args: [\n data.url,\n data.video_id || null,\n data.video_title || null,\n data.channel_name || null,\n data.thumbnail_url || null,\n data.duration || null,\n data.notes || null,\n ],\n });\n return res.lastInsertRowid;\n}\n\nexport async function updateYoutubeLinkStatus(id: number, status: string, clipId?: number) {\n await sqlite.execute({\n sql: \"UPDATE youtube_links SET status = ?, clip_id = ?, updated_at = datetime('now') WHERE id = ?\",\n args: [status, clipId || null, id],\n });\n}\n\nexport async function deleteYoutubeLink(id: number) {\n await sqlite.execute({ sql: \"DELETE FROM youtube_links WHERE id = ?\", args: [id] });\n}\n",[],[199,208],"9aa0e016-3a9b-11f1-b922-42b51c65c3df","migrations.ts","f575ec5e-3a99-11f1-a961-42b51c65c3df",22,["D",1776457541357],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport async function runMigrations() {\n await sqlite.batch([\n {\n sql: `CREATE TABLE IF NOT EXISTS creators (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL UNIQUE,\n platform TEXT DEFAULT 'YouTube/Twitch',\n avatar_emoji TEXT DEFAULT '🎮',\n created_at TEXT DEFAULT (datetime('now'))\n )`,\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS clips (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n creator_id INTEGER NOT NULL,\n title TEXT NOT NULL,\n source_url TEXT,\n status TEXT DEFAULT 'found' CHECK(status IN ('found','editing','uploaded','published')),\n ai_title TEXT,\n ai_description TEXT,\n views INTEGER DEFAULT 0,\n likes INTEGER DEFAULT 0,\n revenue REAL DEFAULT 0.0,\n notes TEXT,\n scheduled_date TEXT,\n created_at TEXT DEFAULT (datetime('now')),\n updated_at TEXT DEFAULT (datetime('now')),\n FOREIGN KEY (creator_id) REFERENCES creators(id)\n )`,\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS youtube_links (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n url TEXT NOT NULL,\n video_id TEXT,\n video_title TEXT,\n channel_name TEXT,\n thumbnail_url TEXT,\n duration TEXT,\n status TEXT DEFAULT 'queued' CHECK(status IN ('queued','clipping','clipped','failed')),\n clip_id INTEGER,\n notes TEXT,\n created_at TEXT DEFAULT (datetime('now')),\n updated_at TEXT DEFAULT (datetime('now')),\n FOREIGN KEY (clip_id) REFERENCES clips(id)\n )`,\n },\n {\n sql: `INSERT OR IGNORE INTO creators (name, platform, avatar_emoji) VALUES \n ('IShowSpeed', 'YouTube/Twitch', '⚡'),\n ('Kai Cenat', 'Twitch', '🔥'),\n ('Duke Dennis', 'YouTube', '🏀'),\n ('Adin Ross', 'Kick', '🎰'),\n ('xQc', 'Kick/Twitch', '🎮'),\n ('MrBeast', 'YouTube', '💰'),\n ('Beta Squad', 'YouTube', '🇬🇧'),\n ('Sketch', 'YouTube', '😂')`,\n },\n ]);\n}\n",[],[199,216],"51514902-3a99-11f1-9f63-42b51c65c3df",["D",1776456559388],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","🎬 Faceless YouTube clip dashboard - track, manage & grow","imageUrl","userId","16f00450-ecbc-11ef-8139-5783405cc753","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","b08ba258-802d-4f4d-aaab-98927562aed8","tursoName","515149023a9911f19f6342b51c65c3df","tursoHostname","515149023a9911f19f6342b51c65c3df-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789511441255],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_279":275},"org",{"_11":12,"_273":-5,"_274":275,"_233":234,"_276":277,"_278":55},"branch",{"_17":91,"_13":16,"_34":42,"_265":223,"_266":-5,"_267":-5,"_268":-5,"_269":-5,"_270":-5,"_271":14,"_272":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ0OHhwbVplVDNmRjJ3elVHUzRTZzdkanlTSiJ9","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_34":223,"_13":14,"_47":369,"_225":-5,"_226":55,"_227":228,"_229":228,"_230":231,"_232":-5,"_233":234,"_235":-5,"_236":55,"_237":-5,"_238":-5,"_239":49,"_240":241,"_242":243,"_244":245,"_246":370,"_248":-5,"_249":250,"_251":250,"_252":253,"_254":253,"_255":253,"_256":250,"_257":250,"_258":371,"_260":372,"_262":373,"_264":55},[312,315,325,327,328,329,330],"files",[312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330],"counts",{"_303":49,"_304":93,"_305":49,"_32":306,"_307":308},[301],{"_34":58,"_41":42,"_37":40,"_13":19,"_52":-5,"_50":59,"_17":49,"_39":-5,"_47":299,"_43":61,"_56":-5,"_18":300},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1776456825549],[19],{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_18":302},[19,36],"pulls","branches","forks",{"_309":49,"_311":49},"connections",{"_309":49,"_310":49},"count","unfilledCount","emptyCount",{"_34":198,"_13":199,"_37":200,"_39":-5,"_41":42,"_43":201,"_45":46,"_47":202,"_17":49,"_50":59,"_52":-5,"_54":55,"_56":-5,"_76":367,"_18":368},{"_34":215,"_13":216,"_37":217,"_39":200,"_41":42,"_43":218,"_45":46,"_47":219,"_17":93,"_50":51,"_52":220,"_54":55,"_56":-5,"_76":365,"_18":366},{"_34":207,"_13":208,"_37":209,"_39":200,"_41":42,"_43":210,"_45":46,"_47":211,"_17":93,"_50":51,"_52":212,"_54":55,"_56":-5,"_76":363,"_18":364},{"_34":111,"_13":112,"_37":113,"_39":-5,"_41":42,"_43":114,"_45":46,"_47":115,"_17":49,"_50":59,"_52":-5,"_54":55,"_56":-5,"_76":361,"_18":362},{"_34":146,"_13":147,"_37":148,"_39":113,"_41":42,"_43":149,"_45":46,"_47":150,"_17":49,"_50":59,"_52":-5,"_54":55,"_56":-5,"_76":359,"_18":360},{"_34":190,"_13":191,"_37":192,"_39":148,"_41":42,"_43":193,"_45":46,"_47":194,"_17":49,"_50":51,"_52":195,"_54":55,"_56":-5,"_76":357,"_18":358},{"_34":182,"_13":183,"_37":184,"_39":148,"_41":42,"_43":185,"_45":46,"_47":186,"_17":49,"_50":51,"_52":187,"_54":55,"_56":-5,"_76":355,"_18":356},{"_34":174,"_13":175,"_37":176,"_39":148,"_41":42,"_43":177,"_45":46,"_47":178,"_17":49,"_50":51,"_52":179,"_54":55,"_56":-5,"_76":353,"_18":354},{"_34":166,"_13":167,"_37":168,"_39":148,"_41":42,"_43":169,"_45":46,"_47":170,"_17":49,"_50":51,"_52":171,"_54":55,"_56":-5,"_76":351,"_18":352},{"_34":158,"_13":159,"_37":160,"_39":148,"_41":42,"_43":161,"_45":46,"_47":162,"_17":49,"_50":51,"_52":163,"_54":55,"_56":-5,"_76":349,"_18":350},{"_34":138,"_13":139,"_37":140,"_39":113,"_41":42,"_43":141,"_45":46,"_47":142,"_17":93,"_50":51,"_52":143,"_54":55,"_56":-5,"_76":347,"_18":348},{"_34":130,"_13":131,"_37":132,"_39":113,"_41":42,"_43":133,"_45":46,"_47":134,"_17":49,"_50":24,"_52":135,"_54":55,"_56":-5,"_76":345,"_18":346},{"_34":122,"_13":123,"_37":124,"_39":113,"_41":42,"_43":125,"_45":46,"_47":126,"_17":49,"_50":51,"_52":127,"_54":55,"_56":-5,"_76":343,"_18":344},{"_34":58,"_13":19,"_37":40,"_39":-5,"_41":42,"_43":61,"_45":46,"_47":104,"_17":49,"_50":59,"_52":-5,"_54":55,"_56":-5,"_76":341,"_18":342},{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":108,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_76":339,"_18":340},{"_34":97,"_13":98,"_37":99,"_39":-5,"_41":42,"_43":100,"_45":46,"_47":101,"_17":93,"_50":59,"_52":-5,"_54":55,"_56":-5,"_76":337,"_18":338},{"_34":88,"_13":89,"_37":90,"_39":-5,"_41":42,"_43":91,"_45":46,"_47":92,"_17":93,"_50":24,"_52":94,"_54":55,"_56":-5,"_76":335,"_18":336},{"_34":79,"_13":80,"_37":81,"_39":-5,"_41":42,"_43":82,"_45":46,"_47":83,"_17":61,"_50":84,"_52":85,"_54":55,"_56":-5,"_76":333,"_18":334},{"_34":70,"_13":71,"_37":72,"_39":-5,"_41":42,"_43":73,"_45":46,"_47":74,"_17":49,"_50":51,"_52":75,"_54":55,"_56":-5,"_76":331,"_18":332},[],[71],[],[80],[],[89],[],[98],[],[19,36],[326],[19],[],[112,123],[],[112,131],[],[112,139],[],[112,147,159],[],[112,147,167],[],[112,147,175],[],[112,147,183],[],[112,147,191],[317,318,319,320,321],[112,147],[316,322,323,324],[112],[],[199,208],[],[199,216],[313,314],[199],["D",1776456559388],["D",1789511441255],{"_11":12,"_279":275},{"_11":12,"_273":-5,"_274":275,"_233":234,"_276":277,"_278":55},{"_17":91,"_13":16,"_34":42,"_265":223,"_266":-5,"_267":-5,"_268":-5,"_269":-5,"_270":-5,"_271":14,"_272":12},"ctx",{"_258":-5,"_296":407,"_408":409,"_410":411,"_412":55,"_413":55,"_414":55,"_415":46,"_416":-5,"_417":-7,"_418":-7,"_419":49,"_420":55,"_421":55,"_422":-5,"_423":55,"_424":55,"_425":55,"_426":-5},"ENV",{"_378":379,"_380":381,"_382":16,"_383":384,"_385":386,"_387":388,"_389":390,"_391":392,"_393":394,"_395":396,"_397":398,"_399":400,"_401":402,"_403":404,"_405":406},"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"]