[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_183":184,"_185":186},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_139":-5,"_20":140,"_22":141,"_142":143,"_144":145,"_26":146,"_24":147,"_148":-5,"_149":-5,"_150":51,"_151":152,"_153":43,"_154":-5,"_155":-5,"_156":157},"routes/_app.x.$handle.$name.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":25,"_26":27,"_28":-5,"_29":-5,"_30":-5,"_31":-5,"_32":-5},"handle","Tsirexx96","name","univen-student-hub","branchName","main","version","path","app.html","project",{"_33":81,"_13":14,"_44":82,"_83":-5,"_84":51,"_85":86,"_87":86,"_88":89,"_90":-5,"_91":92,"_93":59,"_94":43,"_95":-5,"_96":-5,"_97":98,"_99":100,"_101":102,"_103":104,"_105":106,"_107":-5,"_108":109,"_110":109,"_111":112,"_113":112,"_114":112,"_115":109,"_116":109,"_117":118,"_119":120,"_121":122,"_123":51},"tree",[54,55,56],"file",{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":45,"_17":46,"_47":24,"_48":49,"_50":51,"_52":-5,"_18":53},"contents",[],"upstream","pull","ahead","behind","envVars","id","891dd985-8473-45ec-b99c-4f55ba481ac3","fileId","f54b1610-8534-11f1-8d27-1607ee4eb77e","parentId","branchId","de406310-6ef9-445a-9d95-0ab7a13b20ea","branchVersion",16,"latest",true,"createdAt",["D",1784660687643],6,"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 Visit University of Venda Website ↗\n

\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","deleted",false,"label",[19],{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":78,"_17":46,"_47":24,"_48":49,"_50":51,"_52":-5,"_65":79,"_18":80},{"_33":68,"_13":69,"_35":70,"_37":-5,"_38":39,"_40":71,"_42":43,"_44":72,"_17":73,"_47":74,"_48":75,"_50":51,"_52":-5,"_65":76,"_18":77},{"_33":57,"_13":58,"_35":59,"_37":-5,"_38":39,"_40":60,"_42":43,"_44":61,"_17":62,"_47":63,"_48":64,"_50":51,"_52":-5,"_65":66,"_18":67},"1d94e37e-d293-4042-8787-27f683eaa61a","main.ts","f559200c-8534-11f1-88fb-1607ee4eb77e",15,["D",1784660560122],4,"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 (cached in blob storage, fetched from univen.ac.za)\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 try {\n const pageRes = await fetch(\"https://www.univen.ac.za\");\n const html = await pageRes.text();\n\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 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 = await 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 await 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 if (resource === \"products\") {\n await run(`INSERT INTO products (${cols}, photo) VALUES (${placeholders}, ?)`, [...values, \"\"]);\n } else {\n await 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","children",[],[58],"b22c7f93-7ae5-4634-92b6-04c15d899d3a","db.ts","b5e4df38-8534-11f1-90ae-1607ee4eb77e",14,["D",1784660523388],3,"script","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// Initialize all tables\nawait sqlite.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 photo TEXT DEFAULT '',\n created_at TEXT DEFAULT (datetime('now'))\n );\n`);\n\nawait sqlite.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\nawait sqlite.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\nawait sqlite.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\nawait sqlite.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 async function all(query: string, params: unknown[] = []) {\n return await sqlite.execute({ sql: query, args: params });\n}\n\nexport async function run(query: string, params: unknown[] = []) {\n return await sqlite.execute({ sql: query, args: params });\n}\n",[],[69],["D",1784660687643],[],[19],"9814e6bc-d899-45ef-97ee-28c7338f8a40",["D",1784659659428],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Univen student hub: marketplace, vlogs, gossip, SRC & courses","imageUrl","userId","e4c4caa6-441d-4ad1-94be-8595c8de6dc9","pinnedFileId","pinPreview","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",{"_11":12,"_138":133},"org",{"_11":12,"_132":133,"_134":133,"_91":92,"_135":136,"_137":51},"branch",{"_17":41,"_13":16,"_33":39,"_124":81,"_125":-5,"_126":-5,"_127":-5,"_128":-5,"_129":-5,"_130":14,"_131":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","","avatar","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":81,"_13":14,"_44":178,"_83":-5,"_84":51,"_85":86,"_87":86,"_88":89,"_90":-5,"_91":92,"_93":59,"_94":43,"_95":-5,"_96":-5,"_97":98,"_99":100,"_101":102,"_103":104,"_105":179,"_107":-5,"_108":109,"_110":109,"_111":112,"_113":112,"_114":112,"_115":109,"_116":109,"_117":180,"_119":181,"_121":182,"_123":51},[169,170,171],"files",[169,170,171],"counts",{"_159":98,"_160":161,"_162":98,"_32":163,"_164":165},[],{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":45,"_17":46,"_47":24,"_48":49,"_50":51,"_52":-5,"_18":158},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[19],"pulls","branches",1,"forks",{"_166":98,"_168":98},"connections",{"_166":98,"_167":98},"count","unfilledCount","emptyCount",{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":78,"_17":46,"_47":24,"_48":49,"_50":51,"_52":-5,"_65":176,"_18":177},{"_33":68,"_13":69,"_35":70,"_37":-5,"_38":39,"_40":71,"_42":43,"_44":72,"_17":73,"_47":74,"_48":75,"_50":51,"_52":-5,"_65":174,"_18":175},{"_33":57,"_13":58,"_35":59,"_37":-5,"_38":39,"_40":60,"_42":43,"_44":61,"_17":62,"_47":63,"_48":64,"_50":51,"_52":-5,"_65":172,"_18":173},[],[58],[],[69],[],[19],["D",1784659659428],["D",1789560070146],{"_11":12,"_138":133},{"_11":12,"_132":133,"_134":133,"_91":92,"_135":136,"_137":51},{"_17":41,"_13":16,"_33":39,"_124":81,"_125":-5,"_126":-5,"_127":-5,"_128":-5,"_129":-5,"_130":14,"_131":12},"ctx",{"_117":-5,"_155":216,"_217":218,"_219":220,"_221":51,"_222":51,"_223":51,"_224":43,"_225":-5,"_226":-7,"_227":-7,"_228":98,"_229":51,"_230":51,"_231":-5,"_232":51,"_233":51,"_234":51,"_235":-5},"ENV",{"_187":188,"_189":190,"_191":16,"_192":193,"_194":195,"_196":197,"_198":199,"_200":201,"_202":203,"_204":205,"_206":207,"_208":209,"_210":211,"_212":213,"_214":215},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","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"]