[{"_1":2,"_298":-5,"_299":-5},"loaderData",{"_3":4,"_95":96,"_279":280,"_297":-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":70,"_103":-7,"_104":105,"_144":145,"_234":235,"_236":237,"_243":244,"_269":-5,"_270":-5,"_271":272,"_277":27,"_278":27},"handle","argmn","name","testPondiverse","branchName","path","version","project",{"_106":107,"_99":100,"_108":109,"_110":-5,"_111":27,"_112":113,"_114":-5,"_115":-5,"_12":116,"_117":118,"_119":120,"_121":122,"_123":33,"_124":125,"_126":125,"_127":128,"_129":128,"_130":128,"_131":125,"_132":27,"_21":133,"_136":137},"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,"_134":135},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yd2ZzWmxHQ3hPWGdGMlVhVmJaRlBBWWNRTlUifQ","branch",{"_103":122,"_99":43,"_106":138,"_139":107,"_140":-5,"_141":-5,"_142":-5,"_143":-5},"4cb028c4-29be-11f0-85e8-569c3dd06744","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectUserId","tree",[146,167,177,187,197,207,214,224],{"_106":147,"_99":148,"_149":150,"_151":-5,"_152":138,"_153":154,"_155":120,"_108":156,"_103":157,"_158":159,"_160":161,"_162":27,"_163":-5,"_164":165,"_102":166},"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",[],[148],{"_106":168,"_99":169,"_149":170,"_151":-5,"_152":138,"_153":171,"_155":120,"_108":172,"_103":173,"_158":159,"_160":174,"_162":27,"_163":-5,"_164":175,"_102":176},"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}",[],[169],{"_106":178,"_99":179,"_149":180,"_151":-5,"_152":138,"_153":181,"_155":120,"_108":182,"_103":183,"_158":159,"_160":184,"_162":27,"_163":-5,"_164":185,"_102":186},"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}",[],[179],{"_106":188,"_99":189,"_149":190,"_151":-5,"_152":138,"_153":191,"_155":120,"_108":192,"_103":193,"_158":159,"_160":194,"_162":27,"_163":-5,"_164":195,"_102":196},"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}",[],[189],{"_106":198,"_99":199,"_149":200,"_151":-5,"_152":138,"_153":201,"_155":120,"_108":202,"_103":203,"_158":159,"_160":204,"_162":27,"_163":-5,"_164":205,"_102":206},"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}",[],[199],{"_106":208,"_99":43,"_149":118,"_151":-5,"_152":138,"_153":122,"_155":120,"_108":209,"_103":193,"_158":210,"_160":211,"_162":27,"_163":-5,"_164":212,"_102":213},"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],{"_106":215,"_99":216,"_149":217,"_151":-5,"_152":138,"_153":218,"_155":120,"_108":219,"_103":220,"_158":159,"_160":221,"_162":27,"_163":-5,"_164":222,"_102":223},"eded44d6-29ed-11f0-9119-569c3dd06744","report","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}",[],[216],{"_106":225,"_99":226,"_149":227,"_151":-5,"_152":138,"_153":228,"_155":120,"_108":229,"_103":230,"_158":159,"_160":231,"_162":27,"_163":-5,"_164":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",[146,167,177,187,197,207,214,224],"counts",{"_238":33,"_239":240,"_241":33,"_242":94},"pulls","branches",1,"forks","envVars","contents",[245,248,251,254,257,260,263,266],{"_106":147,"_99":148,"_149":150,"_151":-5,"_152":138,"_153":154,"_155":120,"_108":246,"_103":157,"_158":159,"_160":161,"_162":27,"_163":-5,"_102":247},["D",1746488464034],[148],{"_106":168,"_99":169,"_149":170,"_151":-5,"_152":138,"_153":171,"_155":120,"_108":249,"_103":173,"_158":159,"_160":174,"_162":27,"_163":-5,"_102":250},["D",1746474443526],[169],{"_106":178,"_99":179,"_149":180,"_151":-5,"_152":138,"_153":181,"_155":120,"_108":252,"_103":183,"_158":159,"_160":184,"_162":27,"_163":-5,"_102":253},["D",1746474500450],[179],{"_106":188,"_99":189,"_149":190,"_151":-5,"_152":138,"_153":191,"_155":120,"_108":255,"_103":193,"_158":159,"_160":194,"_162":27,"_163":-5,"_102":256},["D",1746488567449],[189],{"_106":198,"_99":199,"_149":200,"_151":-5,"_152":138,"_153":201,"_155":120,"_108":258,"_103":203,"_158":159,"_160":204,"_162":27,"_163":-5,"_102":259},["D",1746475429386],[199],{"_106":208,"_99":43,"_149":118,"_151":-5,"_152":138,"_153":122,"_155":120,"_108":261,"_103":193,"_158":210,"_160":211,"_162":27,"_163":-5,"_102":262},["D",1746505723588],[43],{"_106":215,"_99":216,"_149":217,"_151":-5,"_152":138,"_153":218,"_155":120,"_108":264,"_103":220,"_158":159,"_160":221,"_162":27,"_163":-5,"_102":265},["D",1746476232413],[216],{"_106":225,"_99":226,"_149":227,"_151":-5,"_152":138,"_153":228,"_155":120,"_108":267,"_103":230,"_158":159,"_160":231,"_162":27,"_163":-5,"_102":268},["D",1746481632008],[226],"file","upstream","screenshots",{"_273":274,"_275":276},"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.environment-variables",{"_97":98,"_99":100,"_104":281,"_242":285},{"_106":107,"_99":100,"_108":282,"_110":-5,"_111":27,"_112":113,"_114":-5,"_115":-5,"_12":116,"_117":118,"_119":120,"_121":122,"_123":33,"_124":125,"_126":125,"_127":128,"_129":128,"_130":128,"_131":125,"_132":27,"_21":283,"_136":284},["D",1746455775556],{"_97":98,"_134":135},{"_103":122,"_99":43,"_106":138,"_139":107,"_140":-5,"_141":-5,"_142":-5,"_143":-5},[286,293],{"_287":288,"_108":289,"_290":291,"_114":70,"_292":27},"key","PONDIVERSE_STORE_BASE_PATH",["D",1746457545946],"updatedAt",["D",1746479058021],"isEmpty",{"_287":294,"_108":295,"_290":296,"_114":70,"_292":27},"PONDIVERSE_STORE_ADMIN_PASSWORD",["D",1746457514260],["D",1746479223580],"routes/_app","actionData","errors"]

Key	Description
PONDIVERSE_STORE_BASE_PATH
PONDIVERSE_STORE_ADMIN_PASSWORD

Environment variables