`);\n }\n return template(\n \"\",\n `\n

Title

URL

`,\n );\n}\n\nexport async function linkExists(url: string): Promise {\n var rows = await sqlite.execute(\n \"SELECT * FROM hbc_stories WHERE url = ? AND (CURRENT_TIMESTAMP - posted) < (86400 * 60)\",\n [url],\n );\n return (rows.rows.length > 0);\n}\n\nexport async function insertLink(title: string, url: string, poster: string) {\n await sqlite.execute({\n sql: `INSERT INTO hbc_stories (title, url, poster) VALUES (?, ?, ?)`,\n args: [title, url, poster],\n });\n}\n\nasync function addLink(c): Promise {\n const auth = getAuth(c);\n if (auth?.userId) {\n const formData = await c.req.formData();\n const title = escapeHtml(formData.get(\"title\") as string);\n const url = normalizeUrl(formData.get(\"url\") as string, { forceHttp: true });\n const poster = auth.userId as string;\n if (await linkExists(url)) {\n return \"./duplicate\";\n }\n await insertLink(title, url, poster);\n }\n return \"/\";\n}\n\nfunction dupe(c): string {\n return template(`\n

Duplicate link

It looks like this link has already been posted in the past 2 months.

Go back

`);\n}\n\n// Helper function to escape HTML special characters\nfunction escapeHtml(str: string): string {\n return str\n .replace(/&/g, \"&\")\n .replace(//g, \">\")\n .replace(/\"/g, \""\")\n .replace(/'/g, \"'\");\n}","deleted","label",[99],"permalink","https://www.val.town/x/flymaster/hardballcity/code/submitLink","extension","actionData","errors"]