Garrisons & Whiskey — In Memoriam

\n \n\n`;\n return c.html(html);\n});\n\nexport default app.fetch;\n","deleted","label","children",[],[169],"files",[167],"counts",{"_191":33,"_192":193,"_194":33,"_195":196,"_199":200},"pulls","branches",1,"forks","envVars",{"_197":33,"_198":33},"count","emptyCount","connections",{"_197":33,"_201":33},"unfilledCount","contents",[204],{"_108":168,"_100":169,"_170":171,"_172":-5,"_173":155,"_174":105,"_175":22,"_110":205,"_104":177,"_178":179,"_180":181,"_182":22,"_183":-5,"_103":206},["D",1775918204367],[169],"file","upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_106":216,"_104":105,"_222":223},{"_108":109,"_100":101,"_110":217,"_112":-5,"_113":22,"_114":115,"_116":117,"_118":-5,"_14":119,"_120":121,"_122":123,"_124":-5,"_125":-5,"_126":33,"_16":127,"_128":129,"_130":131,"_132":218,"_134":-5,"_135":136,"_137":136,"_138":139,"_140":139,"_141":139,"_142":136,"_143":136,"_23":219,"_147":220,"_152":221,"_164":22},["D",1775918094881],["D",1775918437100],{"_98":99,"_145":146},{"_98":99,"_149":146,"_14":119,"_150":151},{"_104":154,"_100":46,"_108":155,"_156":109,"_157":-5,"_158":-5,"_159":-5,"_160":-5,"_161":-5,"_162":101,"_163":99},"changes",[224],{"_207":225,"_227":228,"_182":123,"_103":169,"_230":169},{"_170":171,"_100":169,"_178":179,"_180":181,"_110":226,"_174":105,"_173":155},["D",1775918204367],"previous",{"_170":171,"_100":169,"_178":179,"_180":229},"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { Hono } from \"npm:hono\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { parseVal } from \"https://esm.town/v/std/utils/index.ts\";\nimport { renderToString } from \"https://esm.sh/react-dom@18.2.0/server\";\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { Profanity, ProfanityOptions } from \"npm:@2toad/profanity\";\n\nconst profanityFilter = new Profanity({ wholeWord: false });\nfunction containsProfanity(text: string): boolean {\n return profanityFilter.exists(text);\n}\n\nconst app = new Hono();\napp.onError((err) => Promise.reject(err));\n\n// DB setup\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS signatures (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n message TEXT NOT NULL,\n drink TEXT NOT NULL DEFAULT 'Whiskey',\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n`);\n\n// Seed some fun signatures if empty\nconst count = await sqlite.execute(\"SELECT COUNT(*) as c FROM signatures\");\nif ((count.rows[0] as any).c === 0) {\n await sqlite.batch([\n { sql: \"INSERT INTO signatures (name, message, drink) VALUES (?, ?, ?)\", args: [\"Sgt. BarrelRoll\", \"Never forget the defense of Hill 400. We held it for 45 minutes with nothing but a flamethrower and a prayer. Rest easy, old friend.\", \"Bourbon, neat\"] },\n { sql: \"INSERT INTO signatures (name, message, drink) VALUES (?, ?, ?)\", args: [\"MajorMoustache\", \"The late night Normandy runs, the squad wipes, the miraculous comebacks… G&W was the best 100 men I never met. Raising my glass.\", \"Scotch\"] },\n { sql: \"INSERT INTO signatures (name, message, drink) VALUES (?, ?, ?)\", args: [\"Pvt. PanzerschreckPete\", \"Taught me everything I know about supply nodes and whiskey pairings. This server changed my life.\", \"Rye Whiskey\"] },\n { sql: \"INSERT INTO signatures (name, message, drink) VALUES (?, ?, ?)\", args: [\"Col. CamoFlask\", \"100 players. One voice channel. Zero tactical discipline. All heart. Miss you every day.\", \"Irish Whiskey\"] },\n { sql: \"INSERT INTO signatures (name, message, drink) VALUES (?, ?, ?)\", args: [\"LieutenantLager\", \"I came for the WW2 action. I stayed for the people. The server is gone but the trauma of being teamkilled by a Panzer is forever.\", \"Beer (traitor)\"] },\n ]);\n}\n\n// Routes\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\napp.get(\"/api/signatures\", async (c) => {\n const rows = await sqlite.execute(\"SELECT * FROM signatures ORDER BY created_at DESC\");\n return c.json(rows.rows);\n});\n\napp.post(\"/api/signatures\", async (c) => {\n const body = await c.req.json();\n const { name, message, drink } = body;\n if (!name || !message) return c.json({ error: \"Name and message required\" }, 400);\n if (name.length > 60 || message.length > 500) return c.json({ error: \"Too long\" }, 400);\n await sqlite.execute({\n sql: \"INSERT INTO signatures (name, message, drink) VALUES (?, ?, ?)\",\n args: [name.trim(), message.trim(), (drink || \"Whiskey\").trim()],\n });\n return c.json({ ok: true });\n});\n\napp.get(\"/\", (c) => {\n const html = `\n\n\n \n \n Garrisons & Whiskey — In Memoriam\n \n \n \n \n\n\n

\n \n\n`;\n return c.html(html);\n});\n\nexport default app.fetch;\n","latestPath","actionData","errors"]

catalloc

garrisons-and-whiskey-memorial