Error loading jobs. Please try again.

';\n }\n}\n\n// Render jobs to the DOM\nfunction renderJobs() {\n if (jobs.length === 0) {\n jobsContainer.innerHTML = '

No jobs posted yet. Be the first!

';\n return;\n }\n\n jobsContainer.innerHTML = jobs.map(job => `\n

${sanitizeHTML(job.title)}

\n ${formatDate(job.created_at)}\n

${sanitizeHTML(job.company)}

${sanitizeHTML(job.description)}

Contact: ${sanitizeHTML(job.contact)}

\n `).join(\"\");\n}\n\n// Submit new job\njobForm.addEventListener(\"submit\", async (e) => {\n e.preventDefault();\n \n const newJob = {\n title: jobTitle.value.trim(),\n company: jobCompany.value.trim(),\n description: jobDescription.value.trim(),\n contact: jobContact.value.trim()\n };\n \n try {\n const response = await fetch(\"/api/jobs\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(newJob)\n });\n \n if (!response.ok) throw new Error(\"Failed to post job\");\n \n const job = await response.json();\n jobs.unshift(job); // Add to beginning of array\n renderJobs();\n \n // Clear form\n jobForm.reset();\n } catch (error) {\n console.error(\"Error posting job:\", error);\n alert(\"Error posting job. Please try again.\");\n }\n});\n\n// Load chat messages\nasync function loadMessages() {\n try {\n const response = await fetch(\"/api/messages\");\n if (!response.ok) throw new Error(\"Failed to load messages\");\n \n messages = await response.json();\n messages.reverse(); // Show oldest first\n renderMessages();\n } catch (error) {\n console.error(\"Error loading messages:\", error);\n chatContainer.innerHTML = '

Error loading messages. Please try again.

';\n }\n}\n\n// Render messages to the DOM\nfunction renderMessages() {\n if (messages.length === 0) {\n chatContainer.innerHTML = '

No messages yet. Start the conversation!

';\n return;\n }\n\n chatContainer.innerHTML = messages.map(message => `\n

\n ${sanitizeHTML(message.username)}\n ${formatDate(message.created_at)}\n

${sanitizeHTML(message.content)}

\n `).join(\"\");\n \n // Scroll to bottom\n chatContainer.scrollTop = chatContainer.scrollHeight;\n}\n\n// Submit new message\nchatForm.addEventListener(\"submit\", async (e) => {\n e.preventDefault();\n \n const content = chatInput.value.trim();\n if (!content) return;\n \n const newMessage = {\n username,\n content\n };\n \n try {\n const response = await fetch(\"/api/messages\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(newMessage)\n });\n \n if (!response.ok) throw new Error(\"Failed to send message\");\n \n const message = await response.json();\n messages.push(message);\n renderMessages();\n \n // Clear input\n chatForm.reset();\n } catch (error) {\n console.error(\"Error sending message:\", error);\n alert(\"Error sending message. Please try again.\");\n }\n});\n\n// Poll for new messages every 5 seconds\nfunction startMessagePolling() {\n setInterval(loadMessages, 5000);\n}\n\n// Initialize app\ncheckAuth();\nif (username) {\n loadJobs();\n loadMessages();\n startMessagePolling();\n}",[],[114,125],"4d966e84-31e2-11f0-9c4c-569c3dd06744","index.html","34892846-31e2-11f0-9cdd-569c3dd06744",10,["D",1747350848241],"\n\n\n \n \n Job Board with Chat\n \n \n \n \n \n \n\n\n \n \n\n \n

Job Board with Chat

\n Welcome, \n \n

\n\n

\n \n

Post a Job

\n \n

\n\n

Job Listings

\n \n

Loading jobs...

\n\n \n

Discussion Chat

\n \n

Loading messages...

\n \n

\n\n \n\n \n\n",[],[114,133],"48928bd4-31e2-11f0-9a73-569c3dd06744","favicon.svg","48928ca6-31e2-11f0-9a73-569c3dd06744",9,["D",1747350839831],"\n",[],[114,141],"55290cba-31e2-11f0-997f-569c3dd06744","55290d5a-31e2-11f0-997f-569c3dd06744",12,["D",1747350860956],"# Frontend\n\nThis directory contains the client-side code for the Job Board with Chat application.\n\n## Structure\n\n- `index.html` - Main HTML template\n- `index.js` - Frontend JavaScript\n- `favicon.svg` - Application icon\n\n## Features\n\n- Simple username-based authentication\n- Job posting form\n- Job listings display\n- Real-time chat functionality\n\n## Technologies\n\n- HTML5\n- JavaScript (ES6+)\n- Tailwind CSS for styling",[],[114,61],["D",1747350755519],[158,159,160],[19],{"_36":68,"_13":69,"_39":70,"_41":42,"_43":44,"_45":71,"_47":48,"_49":167,"_17":65,"_52":73,"_54":-5,"_56":57,"_58":-5,"_86":168,"_18":169},{"_36":60,"_13":61,"_39":62,"_41":42,"_43":44,"_45":63,"_47":48,"_49":164,"_17":65,"_52":24,"_54":66,"_56":57,"_58":-5,"_86":165,"_18":166},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":161,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_86":162,"_18":163},["D",1747350835531],[],[19,38],["D",1747350856856],[],[19,61],["D",1747350755519],[170,171],[19,69],{"_36":180,"_13":181,"_39":182,"_41":70,"_43":44,"_45":71,"_47":48,"_49":183,"_17":65,"_52":102,"_54":184,"_56":57,"_58":-5,"_86":185,"_18":186},{"_36":172,"_13":173,"_39":174,"_41":70,"_43":44,"_45":175,"_47":48,"_49":176,"_17":65,"_52":102,"_54":177,"_56":57,"_58":-5,"_86":178,"_18":179},"1bad031a-31e2-11f0-997f-569c3dd06744","queries.ts","1bad03e2-31e2-11f0-997f-569c3dd06744",3,["D",1747350764497],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { JOBS_TABLE, MESSAGES_TABLE } from \"./migrations.ts\";\n\n// Types\nexport interface Job {\n id: number;\n title: string;\n company: string;\n description: string;\n contact: string;\n created_at: number;\n}\n\nexport interface Message {\n id: number;\n username: string;\n content: string;\n created_at: number;\n}\n\n// Job queries\nexport async function getAllJobs(): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${JOBS_TABLE} ORDER BY created_at DESC`\n );\n return result.rows;\n}\n\nexport async function createJob(job: Omit): Promise {\n const created_at = Date.now();\n const result = await sqlite.execute<{ id: number }>(\n `INSERT INTO ${JOBS_TABLE} (title, company, description, contact, created_at)\n VALUES (?, ?, ?, ?, ?)\n RETURNING id`,\n [job.title, job.company, job.description, job.contact, created_at]\n );\n \n return {\n id: result.rows[0].id,\n ...job,\n created_at\n };\n}\n\n// Message queries\nexport async function getRecentMessages(limit = 50): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${MESSAGES_TABLE} \n ORDER BY created_at DESC \n LIMIT ?`,\n [limit]\n );\n return result.rows;\n}\n\nexport async function createMessage(message: Omit): Promise {\n const created_at = Date.now();\n const result = await sqlite.execute<{ id: number }>(\n `INSERT INTO ${MESSAGES_TABLE} (username, content, created_at)\n VALUES (?, ?, ?)\n RETURNING id`,\n [message.username, message.content, created_at]\n );\n \n return {\n id: result.rows[0].id,\n ...message,\n created_at\n };\n}",[],[19,69,173],"16514958-31e2-11f0-87b4-569c3dd06744","migrations.ts","16514a16-31e2-11f0-87b4-569c3dd06744",["D",1747350755519],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Table names - use versioning for schema changes\nexport const JOBS_TABLE = \"jobs_v1\";\nexport const MESSAGES_TABLE = \"messages_v1\";\n\n/**\n * Initialize database tables\n */\nexport async function initDatabase() {\n // Create jobs table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${JOBS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n company TEXT NOT NULL,\n description TEXT NOT NULL,\n contact TEXT NOT NULL,\n created_at INTEGER NOT NULL\n )\n `);\n\n // Create messages table for chat\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${MESSAGES_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n username TEXT NOT NULL,\n content TEXT NOT NULL,\n created_at INTEGER NOT NULL\n )\n `);\n}",[],[19,69,181],"0595b72a-31e2-11f0-82d1-569c3dd06744",["D",1747350727452],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","e5091e30-2cb8-11f0-8b3c-8566c5f34604","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","788ca030-1c76-430d-8973-cb5112a92588","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_239":235},"org",{"_11":12,"_233":-5,"_234":235,"_196":197,"_236":237,"_238":57},"branch",{"_17":108,"_13":16,"_36":44,"_225":187,"_226":-5,"_227":-5,"_228":-5,"_229":-5,"_230":-5,"_231":14,"_232":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ3cXlGNGdHR3o4ZzFmdm1xd3Y5T0FYRVU4biJ9","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_36":187,"_13":14,"_49":320,"_189":-5,"_190":57,"_191":192,"_193":192,"_194":-5,"_195":-5,"_196":197,"_198":40,"_199":48,"_200":48,"_201":-5,"_202":65,"_203":204,"_205":-5,"_206":-5,"_207":-5,"_208":-5,"_209":210,"_211":210,"_212":213,"_214":213,"_215":213,"_216":210,"_217":210,"_218":321,"_220":322,"_222":323,"_224":57},[275,281,286,289],"files",[275,276,277,278,279,280,281,282,283,284,285,286,287,288,289],"counts",{"_266":65,"_267":51,"_268":65,"_32":269,"_270":271},[260,261,262],{"_36":75,"_13":19,"_39":42,"_41":-5,"_43":44,"_45":71,"_47":48,"_49":76,"_17":65,"_52":73,"_54":-5,"_56":57,"_58":-5,"_18":259},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[19],{"_36":68,"_13":69,"_39":70,"_41":42,"_43":44,"_45":71,"_47":48,"_49":72,"_17":65,"_52":73,"_54":-5,"_56":57,"_58":-5,"_18":265},{"_36":60,"_13":61,"_39":62,"_41":42,"_43":44,"_45":63,"_47":48,"_49":64,"_17":65,"_52":24,"_54":66,"_56":57,"_58":-5,"_18":264},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_18":263},[19,38],[19,61],[19,69],"pulls","branches","forks",{"_272":65,"_274":65},"connections",{"_272":65,"_273":65},"count","unfilledCount","emptyCount",{"_36":75,"_13":19,"_39":42,"_41":-5,"_43":44,"_45":71,"_47":48,"_49":155,"_17":65,"_52":73,"_54":-5,"_56":57,"_58":-5,"_86":318,"_18":319},{"_36":68,"_13":69,"_39":70,"_41":42,"_43":44,"_45":71,"_47":48,"_49":167,"_17":65,"_52":73,"_54":-5,"_56":57,"_58":-5,"_86":316,"_18":317},{"_36":180,"_13":181,"_39":182,"_41":70,"_43":44,"_45":71,"_47":48,"_49":183,"_17":65,"_52":102,"_54":184,"_56":57,"_58":-5,"_86":314,"_18":315},{"_36":172,"_13":173,"_39":174,"_41":70,"_43":44,"_45":175,"_47":48,"_49":176,"_17":65,"_52":102,"_54":177,"_56":57,"_58":-5,"_86":312,"_18":313},{"_36":60,"_13":61,"_39":62,"_41":42,"_43":44,"_45":63,"_47":48,"_49":164,"_17":65,"_52":24,"_54":66,"_56":57,"_58":-5,"_86":310,"_18":311},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":161,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_86":308,"_18":309},{"_36":113,"_13":114,"_39":115,"_41":-5,"_43":44,"_45":116,"_47":48,"_49":117,"_17":65,"_52":73,"_54":-5,"_56":57,"_58":-5,"_86":306,"_18":307},{"_36":148,"_13":61,"_39":149,"_41":115,"_43":44,"_45":150,"_47":48,"_49":151,"_17":65,"_52":24,"_54":152,"_56":57,"_58":-5,"_86":304,"_18":305},{"_36":140,"_13":141,"_39":142,"_41":115,"_43":44,"_45":143,"_47":48,"_49":144,"_17":65,"_52":24,"_54":145,"_56":57,"_58":-5,"_86":302,"_18":303},{"_36":132,"_13":133,"_39":134,"_41":115,"_43":44,"_45":135,"_47":48,"_49":136,"_17":51,"_52":24,"_54":137,"_56":57,"_58":-5,"_86":300,"_18":301},{"_36":124,"_13":125,"_39":126,"_41":115,"_43":44,"_45":127,"_47":48,"_49":128,"_17":65,"_52":102,"_54":129,"_56":57,"_58":-5,"_86":298,"_18":299},{"_36":89,"_13":90,"_39":91,"_41":-5,"_43":44,"_45":92,"_47":48,"_49":93,"_17":65,"_52":73,"_54":-5,"_56":57,"_58":-5,"_86":296,"_18":297},{"_36":106,"_13":61,"_39":107,"_41":91,"_43":44,"_45":108,"_47":48,"_49":109,"_17":65,"_52":24,"_54":110,"_56":57,"_58":-5,"_86":294,"_18":295},{"_36":98,"_13":99,"_39":100,"_41":91,"_43":44,"_45":92,"_47":48,"_49":101,"_17":65,"_52":102,"_54":103,"_56":57,"_58":-5,"_86":292,"_18":293},{"_36":82,"_13":61,"_39":83,"_41":-5,"_43":44,"_45":51,"_47":48,"_49":84,"_17":65,"_52":24,"_54":85,"_56":57,"_58":-5,"_86":290,"_18":291},[],[61],[],[90,99],[],[90,61],[287,288],[90],[],[114,125],[],[114,133],[],[114,141],[],[114,61],[282,283,284,285],[114],[],[19,38],[],[19,61],[],[19,69,173],[],[19,69,181],[277,278],[19,69],[276,279,280],[19],["D",1747350727452],{"_11":12,"_239":235},{"_11":12,"_233":-5,"_234":235,"_196":197,"_236":237,"_238":57},{"_17":108,"_13":16,"_36":44,"_225":187,"_226":-5,"_227":-5,"_228":-5,"_229":-5,"_230":-5,"_231":14,"_232":12},"ctx",{"_218":-5,"_256":357,"_358":359,"_360":361,"_362":57,"_363":57,"_364":57,"_365":48,"_366":-5,"_367":-7,"_368":-7,"_369":65,"_370":57,"_371":57,"_372":-5,"_373":57,"_374":57,"_375":57,"_376":-5},"ENV",{"_328":329,"_330":331,"_332":16,"_333":334,"_335":336,"_337":338,"_339":340,"_341":342,"_343":344,"_345":346,"_347":348,"_349":350,"_351":352,"_353":354,"_355":356},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","71c1b20804b3232a7e513be260cfffc1932a9e97","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"]