[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_153":154,"_155":156},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_87":-7,"_88":89,"_70":-7,"_15":90,"_91":92,"_93":94,"_95":96,"_97":98,"_99":-5,"_100":-5,"_101":-5,"_102":20,"_103":104,"_105":20},"routes/_app.x.$handle.$name.remixes",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":22,"_23":22,"_24":-5},"handle","kailhus","name","checkMixcloudIsLive","project",{"_25":26,"_13":14,"_27":28,"_29":-5,"_30":31,"_32":33,"_34":-5,"_35":-5,"_36":37,"_38":39,"_40":31,"_41":-5,"_42":-5,"_43":44,"_45":46,"_47":48,"_49":50,"_51":52,"_53":-5,"_54":55,"_56":55,"_57":58,"_59":58,"_60":58,"_61":55,"_62":55,"_63":64,"_65":66,"_67":68,"_69":20},"forks",[],"hasNext",false,"page",0,"forkCount","upstream","id","d3a277e4-26dd-11f0-a5b3-569c3dd06744","createdAt",["D",1746139462872],"deletedAt","legacyEnvVars",true,"privacy","public","description","imageUrl","userId","2c30abc4-9b66-491e-a4f2-ea9b4a3a5884","pinnedFileId","d3a58bf0-26dd-11f0-a5b3-569c3dd06744","pinPreview","pinMigrated","screenshotVersion","likeCount",1,"orgId","f329bc44-32b6-42a6-a9ee-bd9e4932e3e1","tursoName","d3a277e426dd11f0a5b3569c3dd06744","tursoHostname","d3a277e426dd11f0a5b3569c3dd06744-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1781143288675],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_86":83},"org",{"_11":12,"_82":83,"_36":37,"_84":85},"branch",{"_70":71,"_13":72,"_25":73,"_74":26,"_75":-5,"_76":-5,"_77":-5,"_78":-5,"_79":-5,"_80":14,"_81":12},"isOwned","version",26,"main","d3a2d2fc-26dd-11f0-a5b3-569c3dd06744","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yWUJtTDhOcERlRlVMbjE1MDU2ZURlbTBaaHoifQ","tier","free","profileImageUrl","branchName","path","",{"_25":26,"_13":14,"_27":148,"_29":-5,"_30":31,"_32":33,"_34":-5,"_35":-5,"_36":37,"_38":39,"_40":31,"_41":-5,"_42":-5,"_43":44,"_45":46,"_47":48,"_49":50,"_51":149,"_53":-5,"_54":55,"_56":55,"_57":58,"_59":58,"_60":58,"_61":55,"_62":55,"_63":150,"_65":151,"_67":152,"_69":20},"tree",[139,140],"files",[139,140],"counts",{"_130":22,"_131":44,"_17":22,"_132":133,"_134":135},"contents",[106,107],"file","upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"navCollapsed",{"_25":124,"_13":125,"_110":126,"_111":-5,"_112":73,"_113":44,"_114":31,"_27":127,"_70":22,"_117":99,"_119":128,"_121":20,"_122":-5,"_88":129},{"_25":108,"_13":109,"_110":39,"_111":-5,"_112":73,"_113":71,"_114":31,"_27":115,"_70":116,"_117":118,"_119":120,"_121":20,"_122":-5,"_88":123},"d446dc3a-26dd-11f0-a5b3-569c3dd06744","main.tsx","fileId","parentId","branchId","branchVersion","latest",["D",1738833909688],25,"fileType","http","content","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\n\nfunction App() {\n const [isLive, setIsLive] = useState(false);\n const [channelName, setChannelName] = useState(\"\");\n const [isLoading, setIsLoading] = useState(false);\n const [submittedChannel, setSubmittedChannel] = React.useState(null);\n\n async function checkLiveStatus(channel: string) {\n try {\n setIsLoading(true);\n setSubmittedChannel(channel);\n const response = await fetch(`/check-live-status?channel=${encodeURIComponent(channel)}`);\n const data = await response.json();\n setIsLive(data.isLive);\n } catch (error) {\n console.error(\"Failed to check live status\", error);\n }\n setIsLoading(false);\n }\n\n const handleSubmit = (e: React.FormEvent) => {\n e.preventDefault();\n if (channelName.trim()) {\n checkLiveStatus(channelName.trim());\n }\n };\n\n return (\n

Mixcloud Live Status Checker

\n );\n}\n\nfunction client() {\n createRoot(document.getElementById(\"root\")).render();\n}\nif (typeof document !== \"undefined\") { client(); }\n\nexport default async function server(request: Request): Promise {\n const url = new URL(request.url);\n\n // Dynamic import of sqlite\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n\n // Use val's unique URL path as a key for table versioning\n const KEY = \"checkMixcloudIsLive\";\n const SCHEMA_VERSION = 1;\n\n // Create table for storing live status results\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_mixcloud_live_status_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n channel_name TEXT NOT NULL,\n is_live BOOLEAN NOT NULL,\n timestamp DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n if (url.pathname === \"/check-live-status\") {\n const channelName = url.searchParams.get(\"channel\");\n if (!channelName) throw \"Missing channel Name\";\n\n const isLive = await checkMixcloudLiveStatus(channelName, sqlite, KEY, SCHEMA_VERSION);\n return new Response(JSON.stringify({ isLive }), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n // New route to get latest status\n if (url.pathname === \"/get-latest-status\") {\n const channelName = url.searchParams.get(\"channel\");\n if (!channelName) {\n return new Response(JSON.stringify({ \n error: \"Missing channel parameter\" \n }), { \n status: 400, \n headers: { \"Content-Type\": \"application/json\" } \n });\n }\n\n const lowercaseChannelName = channelName.toLowerCase();\n \n // Query to get the latest entry for the specific channel\n const result = await sqlite.execute(`\n SELECT is_live, timestamp \n FROM ${KEY}_mixcloud_live_status_${SCHEMA_VERSION}\n WHERE channel_name = ?\n ORDER BY timestamp DESC\n LIMIT 1\n `, [lowercaseChannelName]);\n\n // Determine status based on query result\n let status: 'LIVE' | 'NOT_LIVE' | 'UNKNOWN';\n let dateChecked: string | null = null;\n\n if (result.rows.length > 0) {\n const row = result.rows[0];\n status = row.is_live ? 'LIVE' : 'NOT_LIVE';\n dateChecked = row.timestamp;\n } else {\n status = 'UNKNOWN';\n }\n\n return new Response(JSON.stringify({\n date_checked: dateChecked,\n channel_name: lowercaseChannelName,\n status\n }), {\n headers: { \"Content-Type\": \"application/json\" }\n });\n }\n\n return new Response(\n `\n \n \n Mixcloud Live Status\n \n \n \n \n

\n \n \n \n `,\n {\n headers: { \"Content-Type\": \"text/html\" },\n },\n );\n}\n\nasync function checkMixcloudLiveStatus(\n channelName: string,\n sqlite?: any,\n key?: string,\n schemaVersion?: number,\n): Promise {\n try {\n const browserlessToken = Deno.env.get(\"browserless\");\n if (!browserlessToken) {\n console.error(\"Browserless token not found\");\n return false;\n }\n\n const res = await fetch(\n `https://chrome.browserless.io/scrape?token=${browserlessToken}`,\n {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({\n \"url\": `https://www.mixcloud.com/${channelName}`,\n \"elements\": [\n {\n // Selector to find element with href containing /live/channelName\n \"selector\": `a[href*=\"/live/${channelName}\"]`,\n },\n ],\n }),\n },\n );\n\n // Check if the response is ok\n if (!res.ok) {\n console.error(`Browserless request failed with status: ${res.status}`);\n return false;\n }\n\n // Parse the response\n const data = await res.json();\n\n // Log the raw response for debugging\n console.log(\"Browserless response:\", data);\n\n // Check if the first item exists and has results\n const firstItem = data.data[0];\n\n // Determine live status\n const isLive = firstItem.results.length > 0;\n\n // Store result in SQLite if sqlite connection is provided\n if (sqlite && key && schemaVersion !== undefined) {\n await sqlite.execute(\n `\n INSERT INTO ${key}_mixcloud_live_status_${schemaVersion} \n (channel_name, is_live) \n VALUES (?, ?)\n `,\n [channelName.toLowerCase(), isLive],\n );\n }\n\n // Return true if any matching elements found\n return isLive;\n } catch (error) {\n console.error(\"Comprehensive error checking Mixcloud live status:\", error);\n return false;\n }\n}\n\nconst css = `\nbody { \n font-family: Arial, sans-serif; \n text-align: center; \n max-width: 600px; \n margin: 0 auto; \n padding: 20px;\n}\na { \n text-decoration: none; \n color: #666; \n}\ninput, button {\n font-size: 16px;\n}\n`;","deleted","label",[109],"d3a595be-26dd-11f0-a5b3-569c3dd06744","README.md","d3a5965e-26dd-11f0-a5b3-569c3dd06744",["D",1738531975920],"Server/client to check whether a mixcloud channel is live.\n\nUses browserless.io (add your own 'browserless' key in the Val Town env variables),\n\n",[125],"pulls","branches","envVars",{"_136":22,"_138":22},"connections",{"_136":22,"_137":22},"count","unfilledCount","emptyCount",{"_25":124,"_13":125,"_110":126,"_111":-5,"_112":73,"_113":44,"_114":31,"_27":145,"_70":22,"_117":99,"_119":128,"_121":20,"_122":-5,"_142":146,"_88":147},{"_25":108,"_13":109,"_110":39,"_111":-5,"_112":73,"_113":71,"_114":31,"_27":141,"_70":116,"_117":118,"_119":120,"_121":20,"_122":-5,"_142":143,"_88":144},["D",1738833909688],"children",[],[109],["D",1738531975920],[],[125],["D",1746139462872],["D",1781143288675],{"_11":12,"_86":83},{"_11":12,"_82":83,"_36":37,"_84":85},{"_70":71,"_13":72,"_25":73,"_74":26,"_75":-5,"_76":-5,"_77":-5,"_78":-5,"_79":-5,"_80":14,"_81":12},"ctx",{"_63":-5,"_186":187,"_188":189,"_190":20,"_191":20,"_192":20,"_193":-5,"_194":-7,"_195":-7,"_196":22,"_197":20,"_198":20,"_199":-5,"_200":20,"_201":20},"ENV",{"_157":158,"_159":160,"_161":162,"_163":72,"_164":165,"_166":167,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","f1316bb1ce3ad41ce227a17bcad7725ad044419f","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","API_URL","https://api.val.town","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier"]

Mixcloud Live Status Checker

Channel: {submittedChannel}

Remixes