\n \n\n\n",[],[170,241],"16fb0206-3a9a-11f1-94dc-42b51c65c3df","App.tsx","16fb02d8-3a9a-11f1-94dc-42b51c65c3df",12,["D",1776456891002],"/** @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\";\n\ntype Tab = \"dashboard\" | \"clips\";\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 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

\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",[],[170,249],"24cfcf1a-3a9a-11f1-ad7f-42b51c65c3df","Dashboard.tsx","24cfcfec-3a9a-11f1-ad7f-42b51c65c3df","18a18d0a-3a9a-11f1-8ea3-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",[],[170,265,257],"components","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",[],[170,265,267],"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",[],[170,265,275],"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",[],[170,265,283],"18a18c6a-3a9a-11f1-8ea3-42b51c65c3df",13,["D",1776456893773],[195,196,197,198],[170,265],["D",1776456825159],[194,199,200,201],[170],"fba59548-3a99-11f1-a961-42b51c65c3df","queries.ts","fba59606-3a99-11f1-a961-42b51c65c3df",6,["D",1776456845145],"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",[],[176,299],"f575eb8c-3a99-11f1-a961-42b51c65c3df","migrations.ts","f575ec5e-3a99-11f1-a961-42b51c65c3df",5,["D",1776456834766],"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: `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",[],[176,307],["D",1776456824834],[191,192],[176],["D",1776456559388],["D",1789511441255],{"_96":95,"_103":99},{"_96":95,"_97":-5,"_98":99,"_18":53,"_100":101,"_102":24},{"_13":85,"_31":86,"_41":40,"_87":42,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":43,"_94":95},"ctx",{"_78":-5,"_123":355,"_356":357,"_358":359,"_360":24,"_361":24,"_362":24,"_363":121,"_364":-5,"_365":-7,"_366":-7,"_367":59,"_368":24,"_369":24,"_370":-5,"_371":24,"_372":24,"_373":24,"_374":-5},"ENV",{"_326":327,"_328":329,"_330":86,"_331":332,"_333":334,"_335":336,"_337":338,"_339":340,"_341":342,"_343":344,"_345":346,"_347":348,"_349":350,"_351":352,"_353":354},"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 · v21