[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_188":189,"_190":191},"routes/_app.x.$handle.$name",{"_105":104,"_38":50,"_113":95,"_33":107,"_13":14,"_114":-5,"_11":115,"_116":117,"_118":119,"_120":121,"_122":123,"_26":-5,"_124":-5,"_125":-5,"_126":31,"_127":128,"_129":64,"_130":-5,"_131":-5,"_132":133},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_48":49,"_38":50,"_43":51,"_52":-5,"_53":31,"_54":55,"_56":55,"_57":58,"_59":-5,"_19":60,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":72,"_73":74,"_75":76,"_77":-5,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":88,"_89":90,"_91":92,"_93":31},"version",11,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","3d1d823c-6eca-47b3-b998-ca0e93315c42","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":29,"_30":31,"_32":31,"_33":34,"_35":34},"file",{"_36":37,"_38":34,"_39":26,"_40":42,"_43":44,"_45":14,"_46":47,"_30":31},"previous",{"_36":37,"_38":34,"_39":26,"_40":41},"deleted",false,"deletedHere","path","app.html","latestPath","fileId","f54b1610-8534-11f1-8d27-1607ee4eb77e","name","fileType","content","\n\n\n \n \n Univen Student Hub\n \n\n\n

\n $\"Univen$ \n

Univen Student Hub

University of Venda - Buy, sell, connect & stay updated

\n\n \n\n

\n\n \n

Post a Product for Sale

\n \n

\n\n \n

Share a Vlog

\n \n

\n\n \n

Share the Latest Tea

\n \n

\n\n \n

SRC Announcements and Updates

\n \n

\n\n \n

Upload Timetable or Assignment

\n \n

\n\n \n\n\n","\n\n\n \n \n Univen Student Hub\n \n\n\n

\n $\"Univen$ \n

Univen Student Hub

University of Venda - Buy, sell, connect & stay updated

\n\n \n\n

\n\n \n

Post a Product for Sale

\n \n

\n\n \n

Share a Vlog

\n \n

\n\n \n

Share the Latest Tea

\n \n

\n\n \n

SRC Announcements and Updates

\n \n

\n\n \n

Upload Timetable or Assignment

\n \n

\n\n \n\n\n","createdAt",["D",1784660187698],"branchVersion","branchId","de406310-6ef9-445a-9d95-0ab7a13b20ea","id","9814e6bc-d899-45ef-97ee-28c7338f8a40","univen-student-hub",["D",1784659659428],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Univen student hub: marketplace, vlogs, gossip, SRC & courses","imageUrl","e4c4caa6-441d-4ad1-94be-8595c8de6dc9","pinnedFileId","f559200c-8534-11f1-88fb-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019f85fa-ef66-71be-9e9d-f5bc0c489178","tursoName","9814e6bcd89945ef97ee28c7338f8a40","tursoHostname","9814e6bcd89945ef97ee28c7338f8a40-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789560070146],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_105":104,"_112":107},"org",{"_105":104,"_106":107,"_108":107,"_19":60,"_109":110,"_111":31},"branch",{"_13":94,"_38":95,"_48":47,"_96":49,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":50,"_103":104},"isOwned",16,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","Tsirexx96","handle","displayName","","avatar","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_48":49,"_38":50,"_43":183,"_52":-5,"_53":31,"_54":55,"_56":55,"_57":58,"_59":-5,"_19":60,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":72,"_73":74,"_75":184,"_77":-5,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":185,"_89":186,"_91":187,"_93":31},"tree",[170,171,172],"files",[170,171,172],"counts",{"_160":68,"_161":153,"_162":68,"_163":164,"_165":166},"contents",[134,135,136],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_48":157,"_38":34,"_36":37,"_139":-5,"_46":47,"_45":14,"_141":31,"_43":158,"_13":151,"_39":26,"_40":42,"_30":31,"_146":-5,"_33":159},{"_48":148,"_38":149,"_36":150,"_139":-5,"_46":47,"_45":151,"_141":31,"_43":152,"_13":153,"_39":154,"_40":155,"_30":31,"_146":-5,"_33":156},{"_48":137,"_38":138,"_36":62,"_139":-5,"_46":47,"_45":140,"_141":31,"_43":142,"_13":143,"_39":144,"_40":145,"_30":31,"_146":-5,"_33":147},"53d76965-e9ec-4081-8e24-22a42ffd166e","main.ts","parentId",7,"latest",["D",1784660166492],3,"http","import { readFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\";\nimport { all, run } from \"./db.ts\";\n\nconst FIELDS: Record = {\n products: [\"title\", \"description\", \"price\", \"seller_name\", \"contact\", \"location\"],\n vlogs: [\"title\", \"video_url\", \"author\", \"description\"],\n gossip: [\"title\", \"content\", \"author\"],\n src: [\"title\", \"content\", \"member_name\", \"role\"],\n courses: [\"course_code\", \"course_name\", \"type\", \"content\", \"link\", \"uploaded_by\"],\n};\n\nexport default async function(req: Request): Promise {\n const url = new URL(req.url);\n const path = url.pathname.replace(/\\/$/, \"\");\n\n if (path === \"\" || path === \"/\") {\n const html = await readFile(\"app.html\");\n return new Response(html, {\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n }\n\n // Serve Univen logo (fetched from univen.ac.za, cached in blob storage)\n if (path === \"/logo\") {\n try {\n const cached = await blob.get(\"univen-logo\");\n const buf = await cached.arrayBuffer();\n return new Response(buf, {\n headers: { \"Content-Type\": \"image/png\", \"Cache-Control\": \"max-age=86400\" },\n });\n } catch {\n // Not cached yet — fetch from Univen website\n try {\n const pageRes = await fetch(\"https://www.univen.ac.za\");\n const html = await pageRes.text();\n\n // Try to find logo image URL in the HTML\n let logoUrl =\n html.match(/]*src=\"(https?:\\/\\/[^\"]*(?:logo|UNIVEN|univen)[^\"]*)\"/i)?.[1] ||\n html.match(/]*class=\"[^\"]*logo[^\"]*\"[^>]*src=\"([^\"]*)\"/i)?.[1] ||\n html.match(/]*src=\"([^\"]*)\"[^>]*class=\"[^\"]*logo[^\"]*\"/i)?.[1] ||\n html.match(/]*rel=\"icon\"[^>]*href=\"([^\"]*)\"/i)?.[1] ||\n html.match(/]*rel=\"shortcut icon\"[^>]*href=\"([^\"]*)\"/i)?.[1];\n\n if (logoUrl) {\n if (logoUrl.startsWith(\"/\")) {\n logoUrl = \"https://www.univen.ac.za\" + logoUrl;\n }\n const imgRes = await fetch(logoUrl);\n const imgBuf = await imgRes.arrayBuffer();\n const ct = imgRes.headers.get(\"Content-Type\") || \"image/png\";\n await blob.set(\"univen-logo\", imgBuf);\n return new Response(imgBuf, {\n headers: { \"Content-Type\": ct, \"Cache-Control\": \"max-age=86400\" },\n });\n }\n } catch {\n // Fall through to SVG fallback\n }\n // SVG fallback logo\n const svg = ``;\n return new Response(svg, {\n headers: { \"Content-Type\": \"image/svg+xml\", \"Cache-Control\": \"max-age=3600\" },\n });\n }\n }\n\n // Serve uploaded product photos from blob storage\n const photoMatch = path.match(/^\\/api\\/photo\\/(.+)$/);\n if (photoMatch) {\n try {\n const res = await blob.get(photoMatch[1]);\n const buf = await res.arrayBuffer();\n return new Response(buf, {\n headers: { \"Content-Type\": \"image/jpeg\", \"Cache-Control\": \"max-age=86400\" },\n });\n } catch {\n return new Response(\"Photo not found\", { status: 404 });\n }\n }\n\n const match = path.match(/^\\/api\\/(\\w+)$/);\n if (!match) {\n return new Response(\"Not found\", { status: 404 });\n }\n\n const resource = match[1];\n const fields = FIELDS[resource];\n\n if (!fields) {\n return new Response(JSON.stringify({ error: \"Unknown resource\" }), {\n status: 404,\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n if (req.method === \"GET\") {\n const result = all(`SELECT * FROM ${resource} ORDER BY id DESC`);\n return new Response(JSON.stringify({ rows: result.rows || [] }), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n if (req.method === \"POST\") {\n const contentType = req.headers.get(\"Content-Type\") || \"\";\n\n // Products with photo upload (multipart form data)\n if (resource === \"products\" && contentType.includes(\"multipart/form-data\")) {\n const formData = await req.formData();\n const photoFile = formData.get(\"photo\") as File | null;\n let photoKey = \"\";\n\n if (photoFile && photoFile.size > 0) {\n photoKey = `product-photo-${Date.now()}-${Math.random().toString(36).slice(2)}`;\n await blob.set(photoKey, await photoFile.arrayBuffer());\n }\n\n const values = fields.map((f) => formData.get(f) ?? \"\");\n const allCols = [...fields, \"photo\"];\n const allValues = [...values, photoKey];\n const placeholders = allCols.map(() => \"?\").join(\", \");\n const cols = allCols.join(\", \");\n\n run(`INSERT INTO products (${cols}) VALUES (${placeholders})`, allValues);\n\n return new Response(JSON.stringify({ success: true }), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n // JSON body for all other resources\n let body: Record;\n try {\n body = await req.json();\n } catch {\n return new Response(JSON.stringify({ error: \"Invalid JSON\" }), {\n status: 400,\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n const values = fields.map((f) => body[f] ?? \"\");\n const placeholders = fields.map(() => \"?\").join(\", \");\n const cols = fields.join(\", \");\n\n // Include empty photo for products via JSON\n if (resource === \"products\") {\n run(`INSERT INTO products (${cols}, photo) VALUES (${placeholders}, ?)`, [...values, \"\"]);\n } else {\n run(`INSERT INTO ${resource} (${cols}) VALUES (${placeholders})`, values);\n }\n\n return new Response(JSON.stringify({ success: true }), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n return new Response(JSON.stringify({ error: \"Method not allowed\" }), {\n status: 405,\n headers: { \"Content-Type\": \"application/json\" },\n });\n}\n","label",[138],"d7e52eb0-7174-499b-be2a-4df0417c46c8","db.ts","b5e4df38-8534-11f1-90ae-1607ee4eb77e",4,["D",1784660149421],1,"script","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// Initialize all tables\nsqlite.execute(`\n CREATE TABLE IF NOT EXISTS products (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n description TEXT,\n price TEXT NOT NULL,\n seller_name TEXT NOT NULL,\n contact TEXT NOT NULL,\n location TEXT,\n created_at TEXT DEFAULT (datetime('now'))\n );\n`);\n\n// Migration: add photo column to products\ntry {\n sqlite.execute(`ALTER TABLE products ADD COLUMN photo TEXT DEFAULT ''`);\n} catch {\n // Column already exists\n}\n\nsqlite.execute(`\n CREATE TABLE IF NOT EXISTS vlogs (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n video_url TEXT NOT NULL,\n author TEXT NOT NULL,\n description TEXT,\n created_at TEXT DEFAULT (datetime('now'))\n );\n`);\n\nsqlite.execute(`\n CREATE TABLE IF NOT EXISTS gossip (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n content TEXT NOT NULL,\n author TEXT NOT NULL,\n created_at TEXT DEFAULT (datetime('now'))\n );\n`);\n\nsqlite.execute(`\n CREATE TABLE IF NOT EXISTS src_posts (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n content TEXT NOT NULL,\n member_name TEXT NOT NULL,\n role TEXT,\n created_at TEXT DEFAULT (datetime('now'))\n );\n`);\n\nsqlite.execute(`\n CREATE TABLE IF NOT EXISTS courses (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n course_code TEXT NOT NULL,\n course_name TEXT NOT NULL,\n type TEXT NOT NULL,\n content TEXT NOT NULL,\n link TEXT,\n uploaded_by TEXT NOT NULL,\n created_at TEXT DEFAULT (datetime('now'))\n );\n`);\n\n// Query helpers\nexport function all(query: string, params: unknown[] = []) {\n return sqlite.execute({ sql: query, args: params });\n}\n\nexport function run(query: string, params: unknown[] = []) {\n return sqlite.execute({ sql: query, args: params });\n}\n",[149],"90eab85f-493e-45a5-8ddb-367827e4b23f",["D",1784660187698],[34],"pulls","branches","forks","envVars",{"_167":68,"_169":68},"connections",{"_167":68,"_168":68},"count","unfilledCount","emptyCount",{"_48":157,"_38":34,"_36":37,"_139":-5,"_46":47,"_45":14,"_141":31,"_43":180,"_13":151,"_39":26,"_40":42,"_30":31,"_146":-5,"_174":181,"_33":182},{"_48":148,"_38":149,"_36":150,"_139":-5,"_46":47,"_45":151,"_141":31,"_43":177,"_13":153,"_39":154,"_40":155,"_30":31,"_146":-5,"_174":178,"_33":179},{"_48":137,"_38":138,"_36":62,"_139":-5,"_46":47,"_45":140,"_141":31,"_43":173,"_13":143,"_39":144,"_40":145,"_30":31,"_146":-5,"_174":175,"_33":176},["D",1784660166492],"children",[],[138],["D",1784660149421],[],[149],["D",1784660187698],[],[34],["D",1784659659428],["D",1789560070146],{"_105":104,"_112":107},{"_105":104,"_106":107,"_108":107,"_19":60,"_109":110,"_111":31},{"_13":94,"_38":95,"_48":47,"_96":49,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":50,"_103":104},"ctx",{"_87":-5,"_131":221,"_222":223,"_224":225,"_226":31,"_227":31,"_228":31,"_229":64,"_230":-5,"_231":-7,"_232":-7,"_233":68,"_234":31,"_235":31,"_236":-5,"_237":31,"_238":31,"_239":31,"_240":-5},"ENV",{"_192":193,"_194":195,"_196":95,"_197":198,"_199":200,"_201":202,"_203":204,"_205":206,"_207":208,"_209":210,"_211":212,"_213":214,"_215":216,"_217":218,"_219":220},"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 · v11