[{"_1":2,"_296":-5,"_297":-5},"loaderData",{"_3":4,"_95":96,"_258":259,"_295":-5},"root",{"_5":6,"_34":35,"_62":63,"_93":94},"ctx",{"_7":8,"_19":20,"_21":-5,"_22":23,"_24":25,"_26":27,"_28":27,"_29":27,"_30":31,"_32":33},"auth",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5},"sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","environmentVariableKeys",[],"user","preferences_keybindings","default","preferences_theme","light","preferences_fixers",false,"preferences_copilot","preferences_selection_ai","preferences_model","claude-3-5-haiku-20241022","notification_count",0,"ENV",{"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":51,"_52":53,"_54":55,"_56":57,"_58":59,"_60":61},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","d0c20f053eaf8fd9cfe8eead2a8e9f6930206884","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","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/","API_URL","https://api.val.town","WORKER_FINGERPRINT","fd7e47ba602df66e0f857b45e802b861","clerkState",{"_64":65},"__internal_clerk_state",{"_66":67,"_68":45,"_69":70,"_71":70,"_72":27,"_73":70,"_74":70,"_75":70,"_76":70,"_77":70,"_78":70,"_79":70,"_80":70,"_81":82,"_91":27,"_92":27},"__clerk_ssr_state",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__signInForceRedirectUrl","__signUpForceRedirectUrl","__signInFallbackRedirectUrl","__signUpFallbackRedirectUrl","__clerk_debug",{"_83":27,"_84":70,"_85":86,"_87":70,"_88":45,"_89":27,"_90":70},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","remixVersion",2,"routes/_app.x.$handle.$name",{"_97":98,"_99":100,"_101":-7,"_102":103,"_104":-7,"_105":106,"_145":146,"_234":235,"_236":237,"_243":244,"_245":246,"_249":-5,"_250":251,"_256":27,"_257":27},"handle","argmn","name","testPondiverse","branchName","path","report","version","project",{"_107":108,"_99":100,"_109":110,"_111":-5,"_112":27,"_113":114,"_115":-5,"_116":-5,"_12":117,"_118":119,"_120":121,"_122":123,"_124":33,"_125":126,"_127":126,"_128":129,"_130":129,"_131":129,"_132":126,"_133":27,"_21":134,"_137":138},"id","4cafc870-29be-11f0-85e8-569c3dd06744","createdAt",["D",1746455775556],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","05dccd50-29a3-11f0-89c9-c7d0e2d9e1ea","pinnedFileId","f45113aa-29d6-11f0-8f5b-569c3dd06744","pinPreview",true,"screenshotVersion",137,"likeCount","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","isOwned",{"_97":98,"_135":136},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yd2ZzWmxHQ3hPWGdGMlVhVmJaRlBBWWNRTlUifQ","branch",{"_104":123,"_99":43,"_107":139,"_140":108,"_141":-5,"_142":-5,"_143":-5,"_144":-5},"4cb028c4-29be-11f0-85e8-569c3dd06744","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectUserId","tree",[147,168,178,188,198,208,215,224],{"_107":148,"_99":149,"_150":151,"_152":-5,"_153":139,"_154":155,"_156":121,"_109":157,"_104":158,"_159":160,"_161":162,"_163":27,"_164":-5,"_165":166,"_102":167},"688b2fe8-2a0a-11f0-9767-569c3dd06744","addCreation","fileId","5572776e-29be-11f0-9520-569c3dd06744","parentId","branchId","branchVersion",135,"latest",["D",1746488464034],32,"fileType","script","content","import { blob } from \"https://esm.town/v/std/blob\";\n\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { TABLE_NAME } from \"./updateTable\";\n\nexport default async function(req: Request): Promise {\n // body contains:\n // - title (string)\n // - data (string)\n // - type (string)\n // - image (data url string)\n // sanity checks:\n // - title, not toooo long\n // - data, hmm this needs to be long i guess.. maybe some crazy upper limit sanity check though\n // - type, not too long\n // - image, not toooo large a file size\n let body;\n try {\n body = await req.json();\n } catch (e) {\n return Response.json({ ok: false, error: \"Invalid JSON\" });\n }\n\n const title = body.title;\n const data = body.data;\n const type = body.type;\n const image = body.image;\n\n // Sanity checks\n\n if (title.length > 100) {\n return Response.json({ ok: false, error: \"Title too long\" });\n }\n\n if (type.length > 100) {\n return Response.json({ ok: false, error: \"Type too long\" });\n }\n\n if (image && image.length > 20 * 1024 * 1024) {\n return Response.json({ ok: false, error: \"Thumbnail too large\" });\n }\n\n if (data.length > 20 * 1024 * 1024) {\n return Response.json({ ok: false, error: \"Data too large\" });\n }\n\n // Now it's time to upload things to database and blob storage\n // First, add to database, and get the ID\n const id = await sqlite.execute(\n `INSERT INTO ${TABLE_NAME} (title, data, type, time) VALUES ($title, $data, $type, $time)`,\n {\n $title: title,\n $data: data,\n $type: type,\n $time: (new Date()).toISOString(),\n },\n );\n\n // only creates blob if there is indeed an image and updates the image column to represent that\n if (image) {\n const imageName = \"pondiverse_image\" + id.lastInsertRowid;\n const imageAddr = `${Deno.env.get(\"PONDIVERSE_STORE_BASE_PATH\")}/get-creation-image?id=${id.lastInsertRowid}`;\n await blob.set(imageName, image);\n await sqlite.execute(\n `UPDATE ${TABLE_NAME} SET image = \"${imageAddr}\" WHERE id = ${id.lastInsertRowid}`,\n );\n }\n\n return Response.json({ ok: true, image: image });\n}","deleted","subdomain","children",[],[149],{"_107":169,"_99":170,"_150":171,"_152":-5,"_153":139,"_154":172,"_156":121,"_109":173,"_104":174,"_159":160,"_161":175,"_163":27,"_164":-5,"_165":176,"_102":177},"c3aae466-29e9-11f0-bc66-569c3dd06744","deleteCreation","7273e654-29be-11f0-b2a1-569c3dd06744",92,["D",1746474443526],11,"import { blob } from \"https://esm.town/v/std/blob\";\n\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { TABLE_NAME } from \"./updateTable\";\n\nexport default async function(req: Request): Promise {\n // body contains:\n // - id (number)\n // - password (string), to be checked against PONDIVERSE_STORE_ADMIN_PASSWORD env variable\n\n let body;\n try {\n body = await req.json();\n } catch (e) {\n return Response.json({ ok: false, error: \"Invalid JSON\" });\n }\n\n const id = body.id;\n const password = body.password;\n\n if (!password) {\n return Response.json({ ok: false, error: \"No password provided\" });\n }\n\n if (isNaN(id)) {\n return Response.json({ ok: false, error: \"Invalid ID\" });\n }\n\n // Now it's time to check the password\n\n if (password !== Deno.env.get(\"PONDIVERSE_STORE_ADMIN_PASSWORD\")) {\n return Response.json({ ok: false, error: \"Invalid password\" });\n }\n\n // Now it's time to delete the creation\n const rows = await sqlite.execute(\n `CREATE TABLE deleted AS SELECT id, image FROM ${TABLE_NAME} WHERE id = ?;\n DELETE FROM ${TABLE_NAME} WHERE id IN (SELECT id FROM deleted WHERE id = ?);\n SELECT image FROM deleted WHERE id = ?;\n DROP TABLE deleted;`,\n [id, id, id],\n );\n\n if (rows[0] && rows[0].image) {\n // Also delete the blob!\n blob.delete(\"pondiverse_image\" + id);\n }\n\n return Response.json({ ok: true });\n}",[],[170],{"_107":179,"_99":180,"_150":181,"_152":-5,"_153":139,"_154":182,"_156":121,"_109":183,"_104":184,"_159":160,"_161":185,"_163":27,"_164":-5,"_165":186,"_102":187},"e598c3cc-29e9-11f0-bab8-569c3dd06744","getCreation","9fd67fee-29be-11f0-8066-569c3dd06744",93,["D",1746474500450],20,"import { blob } from \"https://esm.town/v/std/blob\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { TABLE_NAME } from \"./updateTable\";\n\nexport default async function(req: Request): Promise {\n const url = new URL(req.url);\n const id = url.searchParams.get(\"id\");\n\n let result = await sqlite.execute(`SELECT * FROM ${TABLE_NAME} WHERE id = ?`, [\n id,\n ]);\n\n let creation = result.rows[0];\n if (!creation) return Response.json(null, { status: 404 });\n\n const host = Deno.env.get(\"PONDIVERSE_STORE_BASE_PATH\");\n creation.uri = `https://${host}get-creation?id=${creation.id}`;\n\n return Response.json(creation);\n}",[],[180],{"_107":189,"_99":190,"_150":191,"_152":-5,"_153":139,"_154":192,"_156":121,"_109":193,"_104":194,"_159":160,"_161":195,"_163":27,"_164":-5,"_165":196,"_102":197},"a62e848a-2a0a-11f0-9e0b-569c3dd06744","getCreationImage","e3d93d08-29be-11f0-bcec-569c3dd06744",136,["D",1746488567449],12,"import { blob } from \"https://esm.town/v/std/blob\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { TABLE_NAME } from \"./updateTable\";\n\nexport default async function(req: Request): Promise {\n const url = new URL(req.url);\n const id = url.searchParams.get(\"id\");\n\n let response;\n try {\n response = await blob.get(\"pondiverse_image\" + id);\n } catch (e) {\n return new Response(null, { status: 404 });\n }\n if (!response.ok) {\n return new Response(null, { status: 404 });\n }\n\n const dataUrlBase64 = await response.text();\n const [head, tail] = dataUrlBase64.split(\",\");\n const decoded = atob(tail);\n\n const buffer = new Uint8Array(decoded.length);\n for (let i = 0; i < decoded.length; i++) {\n buffer[i] = decoded.charCodeAt(i);\n }\n\n const type = head.split(\";\")[0].split(\":\")[1];\n\n return new Response(buffer, {\n status: 200,\n headers: {\n \"Content-Type\": type,\n // Allow any origin\n \"Access-Control-Allow-Origin\": \"*\",\n },\n });\n}",[],[190],{"_107":199,"_99":200,"_150":201,"_152":-5,"_153":139,"_154":202,"_156":121,"_109":203,"_104":204,"_159":160,"_161":205,"_163":27,"_164":-5,"_165":206,"_102":207},"0f49226e-29ec-11f0-a250-569c3dd06744","getCreations","f4680456-29be-11f0-aa63-569c3dd06744",95,["D",1746475429386],4,"import { blob } from \"https://esm.town/v/std/blob\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { TABLE_NAME } from \"./updateTable\";\n\nexport default async function(req: Request): Promise {\n // First, get the row IDs of all rows that are older than 25 hours old\n const res = await sqlite.execute(`\n SELECT id FROM ${TABLE_NAME}\n WHERE time < DATETIME('now', '-25 hours')\n `);\n\n // Iterate through each one and delete it's blob\n for (const row of res.rows) {\n if (row.image) {\n blob.delete(\"pondiverse_image\" + row.id);\n }\n }\n\n // Then, delete all rows that are older than 25 hours old\n await sqlite.execute(`\n DELETE FROM ${TABLE_NAME}\n WHERE time < DATETIME('now', '-25 hours')\n `);\n\n // Get page number query (5 results per page)\n const url = new URL(req.url);\n // const page = +(url.searchParams.get(\"page\") ?? 0);\n\n // Get all rows\n // const rowsPerPage = 5;\n // const offset = (page - 1) * rowsPerPage;\n\n // fuck pages who needs em anyway\n // if it gets slow just wait 25 hours lol\n const response = await sqlite.execute(`\n SELECT * FROM ${TABLE_NAME}\n ORDER BY time DESC\n `);\n\n // const response = await sqlite.execute(`\n // SELECT * FROM ${TABLE_NAME}\n // ORDER BY time DESC\n // LIMIT ${rowsPerPage}\n // OFFSET ${offset}\n // `);\n\n if (response.rows.length === 0) {\n return Response.json({\n ok: true,\n items: [],\n });\n }\n\n // This makes forking harder sorry\n // for (let creation of response.rows) {\n // creation.url = `https://pondiverse.val.run/get-creation?id=${creation.id}`;\n // creation.image = `https://pondiverse.val.run/get-creation-image?id=${creation.id}`;\n // }\n\n return Response.json({\n ok: true,\n rows: response.rows,\n // This makes forking harder sorry\n // next: `https://pondiverse.val.run/get-creations?page=${page + 1}`,\n });\n}",[],[200],{"_107":209,"_99":43,"_150":119,"_152":-5,"_153":139,"_154":123,"_156":121,"_109":210,"_104":194,"_159":211,"_161":212,"_163":27,"_164":-5,"_165":213,"_102":214},"980a0c08-2a32-11f0-a2a5-569c3dd06744",["D",1746505723588],"http","import addCreation from \"./addCreation\";\nimport deleteCreation from \"./deleteCreation\";\nimport getCreation from \"./getCreation\";\nimport getCreationImage from \"./getCreationImage\";\nimport getCreations from \"./getCreations\";\nimport updateTable from \"./updateTable\";\n\nexport default async function(req: Request): Promise {\n let url = new URL(req.url);\n const path = url.pathname.toLowerCase();\n return Response.json({ page: \"unknown\" }, { status: 404 });\n switch (path) {\n case \"/add-creation\":\n return addCreation(req);\n case \"/get-creation\":\n return getCreation(req);\n case \"/get-creation-image\":\n return getCreationImage(req);\n case \"/get-creations\":\n return getCreations(req);\n case \"/delete-creation\":\n return deleteCreation(req);\n case \"/update-table\":\n return updateTable(req);\n case \"/favicon.ico\":\n return new Response(null, { status: 200 });\n case \"/\":\n return new Response(null, { status: 200 });\n }\n\n return Response.json({ page: \"unknown\" }, { status: 404 });\n}",[],[43],{"_107":216,"_99":103,"_150":217,"_152":-5,"_153":139,"_154":218,"_156":121,"_109":219,"_104":220,"_159":160,"_161":221,"_163":27,"_164":-5,"_165":222,"_102":223},"eded44d6-29ed-11f0-9119-569c3dd06744","1826224c-29ec-11f0-bb7a-569c3dd06744",106,["D",1746476232413],10,"import { email } from \"https://esm.town/v/std/email\";\n\nexport default async function(req: Request): Promise {\n let body;\n try {\n body = await req.json();\n } catch (e) {\n return Response.json({ ok: false, error: \"Invalid JSON\" });\n }\n\n const id = body.id;\n const message = body.message;\n\n const text = `Creation ${id} got reported because:\\n\\n${message}`;\n await email({ subject: `Pondiverse - Report Creation ${id}`, text: `${text}` });\n return Response.json({}, { status: 202 });\n}",[],[103],{"_107":225,"_99":226,"_150":227,"_152":-5,"_153":139,"_154":228,"_156":121,"_109":229,"_104":230,"_159":160,"_161":231,"_163":27,"_164":-5,"_165":232,"_102":233},"80561ec2-29fa-11f0-9285-569c3dd06744","updateTable","060a524a-29bf-11f0-bf7a-569c3dd06744",118,["D",1746481632008],18,"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nexport const TABLE_NAME = \"pondiverse_creations_v4\";\nexport default async function(req: Request): Promise {\n let body;\n try {\n body = await req.json();\n } catch (e) {\n return new Response(null, { status: 400 });\n }\n\n const password = body.password;\n if (!password || password !== Deno.env.get(\"PONDIVERSE_STORE_ADMIN_PASSWORD\")) {\n return new Response(null, { status: 401 });\n }\n\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT,\n data TEXT,\n type TEXT,\n image TEXT,\n time DATETIME NOT NULL\n )`,\n );\n\n return new Response(null, { status: 200 });\n}",[],[226],"files",[147,168,178,188,198,208,215,224],"counts",{"_238":33,"_239":240,"_241":33,"_242":94},"pulls","branches",1,"forks","envVars","contents",[],"file",{"_107":216,"_99":103,"_150":217,"_152":-5,"_153":139,"_154":218,"_156":121,"_109":247,"_104":220,"_159":160,"_161":221,"_163":27,"_164":-5,"_102":248},["D",1746476232413],[103],"upstream","screenshots",{"_252":253,"_254":255},"thumbnail","https://screenshots.valtown.net/screenshot.png?width=1024&height=768&version=137&url=https%3A%2F%2Fargmn--f45113aa29d611f08f5b569c3dd06744.web.val.run","preview","https://screenshots.valtown.net/screenshot.png?width=1920&height=1080&version=137&url=https%3A%2F%2Fargmn--f45113aa29d611f08f5b569c3dd06744.web.val.run","emptyEnvVars","isNew","routes/_app.x.$handle.$name.code.$",{"_97":98,"_99":100,"_101":43,"_104":-7,"_102":103,"_105":260,"_145":264,"_234":289,"_245":290,"_243":292,"_249":-5,"_293":27,"_294":-5},{"_107":108,"_99":100,"_109":261,"_111":-5,"_112":27,"_113":114,"_115":-5,"_116":-5,"_12":117,"_118":119,"_120":121,"_122":123,"_124":33,"_125":126,"_127":126,"_128":129,"_130":129,"_131":129,"_132":126,"_133":27,"_21":262,"_137":263},["D",1746455775556],{"_97":98,"_135":136},{"_104":123,"_99":43,"_107":139,"_140":108,"_141":-5,"_142":-5,"_143":-5,"_144":-5},[265,268,271,274,277,280,283,286],{"_107":148,"_99":149,"_150":151,"_152":-5,"_153":139,"_154":155,"_156":121,"_109":157,"_104":158,"_159":160,"_161":162,"_163":27,"_164":-5,"_165":266,"_102":267},[],[149],{"_107":169,"_99":170,"_150":171,"_152":-5,"_153":139,"_154":172,"_156":121,"_109":173,"_104":174,"_159":160,"_161":175,"_163":27,"_164":-5,"_165":269,"_102":270},[],[170],{"_107":179,"_99":180,"_150":181,"_152":-5,"_153":139,"_154":182,"_156":121,"_109":183,"_104":184,"_159":160,"_161":185,"_163":27,"_164":-5,"_165":272,"_102":273},[],[180],{"_107":189,"_99":190,"_150":191,"_152":-5,"_153":139,"_154":192,"_156":121,"_109":193,"_104":194,"_159":160,"_161":195,"_163":27,"_164":-5,"_165":275,"_102":276},[],[190],{"_107":199,"_99":200,"_150":201,"_152":-5,"_153":139,"_154":202,"_156":121,"_109":203,"_104":204,"_159":160,"_161":205,"_163":27,"_164":-5,"_165":278,"_102":279},[],[200],{"_107":209,"_99":43,"_150":119,"_152":-5,"_153":139,"_154":123,"_156":121,"_109":210,"_104":194,"_159":211,"_161":212,"_163":27,"_164":-5,"_165":281,"_102":282},[],[43],{"_107":216,"_99":103,"_150":217,"_152":-5,"_153":139,"_154":218,"_156":121,"_109":219,"_104":220,"_159":160,"_161":221,"_163":27,"_164":-5,"_165":284,"_102":285},[],[103],{"_107":225,"_99":226,"_150":227,"_152":-5,"_153":139,"_154":228,"_156":121,"_109":229,"_104":230,"_159":160,"_161":231,"_163":27,"_164":-5,"_165":287,"_102":288},[],[226],[265,268,271,274,277,280,283,286],{"_107":216,"_99":103,"_150":217,"_152":-5,"_153":139,"_154":218,"_156":121,"_109":247,"_104":220,"_159":160,"_161":221,"_163":27,"_164":-5,"_102":291},[103],[],"showCompareCallout","pull","routes/_app","actionData","errors"]