About

Hardball City is a community link aggregator for baseball news and \n information.

All members are encouraged to submit links that relate in any way to the sport \n of baseball (and softball!) around the world. Links that don't have anything to do \n with baseball will be removed.

\n `,\n );\n}","deleted","label","children",[],[150],{"_102":171,"_95":172,"_151":173,"_153":-5,"_154":136,"_155":174,"_157":158,"_104":175,"_99":176,"_161":162,"_163":177,"_165":22,"_166":-5,"_167":178,"_98":179},"65bc26ee-f1f4-11ef-adc7-569c3dd06744","deleteStory","e4a4b582-f1f1-11ef-8db0-569c3dd06744",311,["D",1740321745284],12,"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { clerkMiddleware, getAuth } from \"npm:@hono/clerk-auth\";\nimport { Hono } from \"npm:hono\";\nimport normalizeUrl from \"npm:normalize-url\";\nimport { template } from \"./util\";\n\nconst authDomain = Deno.env.get(\"CLERK_DOMAIN\");\nexport default async function(req: Request): Promise {\n const app = await getApp();\n\n return app.fetch(req);\n}\n\nexport async function getApp(): Promise {\n var app = new Hono();\n app.use(clerkMiddleware());\n app.get(\"/:id\", async (c) => c.html(await deleteForm(c)));\n app.post(\"/:id\", async (c) => c.redirect(await deleteStory(c)));\n return app;\n}\n\nasync function isAdmin(id: string): Promise {\n const rows = await sqlite.execute(\"select * from hbc_admins where id = :id;\", { id: id });\n return rows.rows.length > 0;\n}\n\nasync function deleteForm(c): Promise {\n const auth = getAuth(c);\n var id = c.req.param(\"id\");\n\n if (await !isAdmin(auth?.userId)) {\n return template(\"\", `

Not authorized

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

Are you sure you want to delete this story?

`,\n );\n}\n\nexport async function deleteStory(c): Promise {\n const auth = getAuth(c);\n var id = c.req.param(\"id\");\n if (await !isAdmin(auth?.userId)) {\n return \"/\";\n }\n var rows = await sqlite.execute(\n \"UPDATE hbc_stories SET deleted = CURRENT_TIMESTAMP WHERE rowid = ?\",\n [id],\n );\n return \"/\";\n}",[],[172],{"_102":181,"_95":182,"_151":183,"_153":-5,"_154":136,"_155":184,"_157":158,"_104":185,"_99":186,"_161":162,"_163":187,"_165":22,"_166":-5,"_167":188,"_98":189},"2a5d6c70-f7cb-11ef-b950-569c3dd06744","front","4517e6c4-e31e-11ef-9361-e6cdfca9ef9f",367,["D",1740963743286],51,"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { clerkMiddleware, getAuth } from \"npm:@hono/clerk-auth\";\nimport { Hono } from \"npm:hono\";\nimport moment from \"npm:moment\";\nimport { template } from \"./util\";\n\nconst authDomain = Deno.env.get(\"CLERK_DOMAIN\");\nexport default async function(req: Request): Promise {\n const app = await getApp();\n\n return app.fetch(req);\n}\n\nexport async function getApp(): Promise {\n var app = new Hono();\n app.use(clerkMiddleware());\n app.get(\"/\", async (c) => c.html(await mainPage(c)));\n return app;\n}\n\nasync function isAdmin(id: string): Promise {\n const rows = await sqlite.execute(\"select * from hbc_admins where id = :id;\", { id: id });\n return rows.rows.length > 0;\n}\n\nasync function getLoginLine(c): Promise {\n const auth = getAuth(c);\n var login =\n `Log in`;\n if (auth?.userId) {\n const clerkClient = c.get(\"clerk\");\n\n try {\n const user = await clerkClient.users.getUser(auth.userId);\n await updateUser(auth.userId, user.username);\n var admin = await isAdmin(auth.userId) ? \" | Admin\" : \"\";\n\n login =\n `Submit a Link | ${user.username}${admin}`;\n } catch (e) {\n console.error(e);\n }\n }\n return login;\n}\n\nasync function mainPage(c): Promise {\n const login = await getLoginLine(c);\n const body = await getStories();\n return template(login, body);\n}\n\nasync function getStories(): Promise {\n var rows = await sqlite.execute(\n `select \n title, \n url, \n posted, \n name, \n hbc_stories.rowid as rowid,\n numcomments\nfrom \n hbc_stories, \n hbc_users\nleft join (\n select \n hbc_stories.rowid as jrowid, \n hbc_comments.story as jstory,\n count(hbc_comments.rowid) as numcomments\n from \n hbc_stories, \n hbc_comments \n where \n jstory = jrowid\n group by story\n ) on jstory = rowid\nwhere \n hbc_stories.deleted is null and\n hbc_stories.poster = hbc_users.id \norder by posted desc limit 50;`,\n );\n var items = \"

\";\n for (const row of rows.rows) {\n items +=\n `

${row.title}via ${row.name} ${\n moment(row.posted).fromNow()\n } | ${\n row.numcomments ? row.numcomments : 0\n }

`;\n }\n items += \"

\";\n return items;\n}\n\nasync function updateUser(id: string, username: string) {\n await sqlite.execute({\n sql: \"INSERT INTO hbc_users (id, name) VALUES(:id, :username) ON CONFLICT(id) DO UPDATE SET name = :username;\",\n args: { \"id\": id, \"username\": username },\n });\n}",[],[182],{"_102":191,"_95":192,"_151":193,"_153":-5,"_154":136,"_155":194,"_157":158,"_104":195,"_99":196,"_161":197,"_163":198,"_165":22,"_166":-5,"_167":199,"_98":200},"983b3cc4-e63a-11ef-8d36-e6cdfca9ef9f","mlbCron","8da98f6e-e639-11ef-9e69-e6cdfca9ef9f",290,["D",1739032480821],4,"interval","import Parser from \"npm:rss-parser\";\nimport { insertLink, linkExists } from \"./submitLink\";\n\nexport default async function(interval: Interval) {\n // Get the first story from mlb.com rss feed\n let parser = new Parser({\n timeout: 5000,\n });\n let feedFile = await fetch(\"https://mlb.com/feeds/news/rss.xml\");\n let feedText = await feedFile.text();\n let feedData = await parser.parseString(feedText);\n let title = feedData.items[0]?.title ?? feedData.items[0].link;\n let url = feedData.items[0].link;\n\n if (await linkExists(url)) {\n return;\n }\n await insertLink(title, url, \"1\");\n}",[],[192],{"_102":202,"_95":203,"_151":204,"_153":-5,"_154":136,"_155":135,"_157":158,"_104":205,"_99":206,"_161":162,"_163":207,"_165":22,"_166":-5,"_167":208,"_98":209},"26f7fb66-721b-11f0-8ff0-0224a6c84d84","postComment","36260f36-f38d-11ef-b128-569c3dd06744",["D",1754412139185],36,"import { marked } from \"https://esm.sh/marked@11.2.0\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { clerkMiddleware, getAuth } from \"npm:@hono/clerk-auth\";\nimport { Hono } from \"npm:hono\";\nimport moment from \"npm:moment\";\nimport normalizeUrl from \"npm:normalize-url\";\nimport xss from \"npm:xss\";\nimport { template } from \"./util\";\n\nconst authDomain = Deno.env.get(\"CLERK_DOMAIN\");\nexport default async function(req: Request): Promise {\n const app = await getApp();\n\n return app.fetch(req);\n}\n\nexport async function getApp(): Promise {\n var app = new Hono();\n app.use(clerkMiddleware());\n app.get(\"/:story\", async (c) => c.html(await showComments(c)));\n app.post(\"/:story\", async (c) => c.redirect(await postComment(c)));\n return app;\n}\n\nasync function getComments(story: number): Promise {\n var rows = await sqlite.execute(\n \"select name, comment, posted from hbc_comments, hbc_users where hbc_comments.story = ? and hbc_comments.poster = hbc_users.id order by posted asc;\",\n [story],\n );\n var items = \"

\";\n for (const row of rows.rows) {\n items += `

${\n xss(marked.parse(row.comment))\n }

by ${row.name} ${moment(row.posted).fromNow()}

`;\n }\n items += \"

\";\n return items;\n}\n\nasync function getLink(story: number): Promise {\n var rows = await sqlite.execute(\n \"select title, url, posted, name, hbc_stories.rowid as rowid from hbc_stories, hbc_users where hbc_stories.poster = hbc_users.id and rowid = ? order by posted desc limit 25;\",\n [story],\n );\n var items = \"

\";\n for (const row of rows.rows) {\n items +=\n `

${row.title}via ${row.name} ${\n moment(row.posted).fromNow()\n }

`;\n }\n items += \"

\";\n return items;\n}\n\nasync function showComments(c): Promise {\n const auth = getAuth(c);\n if (!auth?.userId) {\n return template(\"\", `

`);\n }\n const storyid = c.req.param(\"story\");\n return template(\n \"\",\n `\n ${await getLink(storyid)}\n

Comments

\n ${await getComments(storyid)}\n ${await getForm(storyid, auth)}\n `,\n );\n}\n\nasync function getForm(story: number, auth): Promise {\n if (auth?.userId) {\n return `\n

Post Comment

`;\n }\n return \"\";\n}\n\nexport async function insertComment(comment: string, story: number, poster: string) {\n await sqlite.execute({\n sql: `INSERT INTO hbc_comments (poster, comment, story) VALUES (?, ?, ?)`,\n args: [poster, comment, story],\n });\n}\n\nasync function postComment(c): Promise {\n const auth = getAuth(c);\n const story = c.req.param(\"story\");\n if (auth?.userId) {\n const formData = await c.req.formData();\n const comment = escapeHtml(formData.get(\"comment\") as string);\n const poster = auth.userId as string;\n await insertComment(comment, story, poster);\n }\n return `./${story}`;\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}",[],[203],{"_102":211,"_95":212,"_151":213,"_153":-5,"_154":136,"_155":214,"_157":158,"_104":215,"_99":216,"_161":162,"_163":217,"_165":22,"_166":-5,"_167":218,"_98":219},"3287faaa-f38e-11ef-bdf2-569c3dd06744","router","de0bf3d4-e0f8-11ef-9bbc-e6cdfca9ef9f",325,["D",1740497753038],160,"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { clerkMiddleware, getAuth } from \"npm:@hono/clerk-auth\";\nimport { Hono } from \"npm:hono\";\nimport { appendTrailingSlash } from \"npm:hono/trailing-slash\";\nimport moment from \"npm:moment\";\nimport { getApp as getAboutApp } from \"./about\";\nimport { getApp as getDeleteStoryApp } from \"./deleteStory\";\nimport { getApp as getMainApp } from \"./front\";\nimport { getApp as getLinkApp } from \"./submitLink\";\nimport {getApp as getCommentsApp} from \"./postComment\";\nimport { template } from \"./util\";\n\nconst authDomain = Deno.env.get(\"CLERK_DOMAIN\");\nexport default async function(req: Request): Promise {\n const app = new Hono();\n app.use(\"*\", clerkMiddleware());\n app.use(\"*\", appendTrailingSlash());\n\n app.route(\"/\", await getMainApp());\n app.route(\"/new/\", await getLinkApp());\n app.route(\"/about/\", await getAboutApp());\n app.route(\"/delete/\", await getDeleteStoryApp());\n app.route(\"/story/\", await getCommentsApp());\n\n return app.fetch(req);\n}",[],[212],{"_102":221,"_95":222,"_151":223,"_153":-5,"_154":136,"_155":224,"_157":158,"_104":225,"_99":226,"_161":162,"_163":227,"_165":22,"_166":-5,"_167":228,"_98":229},"d2267c28-e63a-11ef-aba9-e6cdfca9ef9f","submitLink","a41d7d74-e327-11ef-873c-e6cdfca9ef9f",293,["D",1739032577993],37,"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { clerkMiddleware, getAuth } from \"npm:@hono/clerk-auth\";\nimport { Hono } from \"npm:hono\";\nimport normalizeUrl from \"npm:normalize-url\";\nimport { template } from \"./util\";\n\nconst authDomain = Deno.env.get(\"CLERK_DOMAIN\");\nexport default async function(req: Request): Promise {\n const app = await getApp();\n\n return app.fetch(req);\n}\n\nexport async function getApp(): Promise {\n var app = new Hono();\n app.use(clerkMiddleware());\n app.get(\"/\", async (c) => c.html(await newLinkForm(c)));\n app.post(\"/\", async (c) => c.redirect(await addLink(c)));\n app.get(\"/duplicate\", async (c) => c.html(await dupe(c)));\n return app;\n}\n\nasync function newLinkForm(c): Promise {\n const auth = getAuth(c);\n if (!auth?.userId) {\n return template(\"\", `

`);\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}",[],[222],{"_102":231,"_95":232,"_151":233,"_153":-5,"_154":136,"_155":234,"_157":158,"_104":235,"_99":236,"_161":237,"_163":238,"_165":22,"_166":-5,"_167":239,"_98":240},"81988a60-f776-11ef-84bc-569c3dd06744","util","139c42e2-e31a-11ef-91c3-e6cdfca9ef9f",363,["D",1740927382413],47,"script","export function template(login: string, body: string): string {\n return `\n \n \n Hardball City\n \n \n \n ⚾\"/>\n \n \n \n ${body}\n \n \n `;\n}\n\nfunction css(): string {\n return `\n:root {\n --management: #e63946ff;\n --background: #f1faeeff;\n --non-photo-blue: #a8dadcff;\n --dim-text: #457b9dff;\n --text: #1d3557ff;\n}\nbody { \n background-color: var(--background);\n color: var(--text);\n font-family: Seravek, 'Gill Sans Nova', Ubuntu, Calibri, 'DejaVu Sans', source-sans-pro, sans-serif;\n font-weight: normal;\n max-width: 900px;\n margin: auto;\n}\na {\n text-decoration: none; \n font-weight: 500;\n color: var(--text);\n}\na:visited {\n color: var(--dim-text);\n}\n.storyinfo {\n font-size: smaller;\n font-weight: 100;\n color: var(--dim-text);\n text-align: right;\n}\nh1 {\n font-size: large;\n margin-bottom: 0px;\n margin-top: .2em;\n}\n.header {\n margin-top: 1em;\n height: 2em;\n display: flex;\n justify-content: space-between;\n}\n.story {\n display: flex;\n justify-content: space-between;\n margin: 1em;\n}\n.title\n{ \n font-family: Seravek, 'Gill Sans Nova', Ubuntu, Calibri, 'DejaVu Sans', source-sans-pro, sans-serif;\n font-weight: 800; \n}\n.manage, .manage a {\n font-family: Seravek, 'Gill Sans Nova', Ubuntu, Calibri, 'DejaVu Sans', source-sans-pro, sans-serif;\n font-weight: 100;\n margin-bottom: 5em;\n}\nlabel {\n width: 6em;\n}\ninput[type='text'], input[type='url'] {\n width: 50em;\n}\n`;\n}",[],[232],"files",[148,170,180,190,201,210,220,230],"counts",{"_245":32,"_246":247,"_248":32,"_249":250},"pulls","branches",1,"forks","envVars",3,"contents",[253,256,259,262,265,268,271,274],{"_102":149,"_95":150,"_151":152,"_153":-5,"_154":136,"_155":156,"_157":158,"_104":254,"_99":160,"_161":162,"_163":164,"_165":22,"_166":-5,"_98":255},["D",1739199455019],[150],{"_102":171,"_95":172,"_151":173,"_153":-5,"_154":136,"_155":174,"_157":158,"_104":257,"_99":176,"_161":162,"_163":177,"_165":22,"_166":-5,"_98":258},["D",1740321745284],[172],{"_102":181,"_95":182,"_151":183,"_153":-5,"_154":136,"_155":184,"_157":158,"_104":260,"_99":186,"_161":162,"_163":187,"_165":22,"_166":-5,"_98":261},["D",1740963743286],[182],{"_102":191,"_95":192,"_151":193,"_153":-5,"_154":136,"_155":194,"_157":158,"_104":263,"_99":196,"_161":197,"_163":198,"_165":22,"_166":-5,"_98":264},["D",1739032480821],[192],{"_102":202,"_95":203,"_151":204,"_153":-5,"_154":136,"_155":135,"_157":158,"_104":266,"_99":206,"_161":162,"_163":207,"_165":22,"_166":-5,"_98":267},["D",1754412139185],[203],{"_102":211,"_95":212,"_151":213,"_153":-5,"_154":136,"_155":214,"_157":158,"_104":269,"_99":216,"_161":162,"_163":217,"_165":22,"_166":-5,"_98":270},["D",1740497753038],[212],{"_102":221,"_95":222,"_151":223,"_153":-5,"_154":136,"_155":224,"_157":158,"_104":272,"_99":226,"_161":162,"_163":227,"_165":22,"_166":-5,"_98":273},["D",1739032577993],[222],{"_102":231,"_95":232,"_151":233,"_153":-5,"_154":136,"_155":234,"_157":158,"_104":275,"_99":236,"_161":237,"_163":238,"_165":22,"_166":-5,"_98":276},["D",1740927382413],[232],"file","upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.environment-variables",{"_93":94,"_95":96,"_100":286,"_249":291},{"_102":103,"_95":96,"_104":287,"_106":-5,"_107":22,"_108":109,"_110":-5,"_111":-5,"_14":112,"_113":-5,"_114":22,"_115":-5,"_116":32,"_16":117,"_118":119,"_120":119,"_121":122,"_123":122,"_124":122,"_125":119,"_126":119,"_23":288,"_130":289,"_133":290,"_145":22},["D",1738454446307],{"_93":94,"_128":129},{"_93":94,"_132":129},{"_99":135,"_95":43,"_102":136,"_137":103,"_138":-5,"_139":-5,"_140":-5,"_141":-5,"_142":-5,"_143":96,"_144":94},[292,299,303],{"_293":294,"_104":295,"_296":297,"_110":-5,"_298":22},"key","CLERK_DOMAIN",["D",1738455649085],"updatedAt",["D",1738456626322],"isEmpty",{"_293":300,"_104":301,"_296":302,"_110":-5,"_298":22},"CLERK_SECRET_KEY",["D",1738455013216],["D",1738456596521],{"_293":44,"_104":304,"_296":305,"_110":-5,"_298":22},["D",1738454984293],["D",1738456583760],"actionData","errors"]

Key	Description
CLERK_DOMAIN
CLERK_SECRET_KEY
CLERK_PUBLISHABLE_KEY

flymaster

hardballcity

Environment variables