interface GameDeal { id: number; title: string; platform: string; url: string; end_date: string | null; created_at: string; } export default async function server(request: Request): Promise { const { sqlite } = await import("https://esm.town/v/stevekrouse/sqlite"); const KEY = new URL(import.meta.url).pathname.split("/").at(-1); const deals = await sqlite.execute(` SELECT * FROM ${KEY}_deals WHERE end_date IS NULL OR end_date > datetime('now') ORDER BY CASE WHEN platform = 'Epic Games' THEN 1 WHEN platform = 'Steam' THEN 2 WHEN platform = 'GOG' THEN 3 ELSE 4 END, created_at DESC LIMIT 50 `); const dealsHtml = deals.rows.map((deal: GameDeal) => `

${deal.title}

${deal.platform}

${deal.end_date ? `

Ends: ${new Date(deal.end_date).toLocaleDateString()}

` : ""} Get it now!

`).join(""); const html = ` Free Game Deals

🎮 Free Game Deals

Your daily dose of free games from Steam, Epic Games, and GOG!

${dealsHtml}

`; return new Response(html, { headers: { "content-type": "text/html", }, }); } const css = ` :root { --primary-color: #4a4a4a; --secondary-color: #3498db; --background-color: #f0f0f0; --card-background: #ffffff; } body { font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif; background-color: var(--background-color); margin: 0; padding: 0; color: var(--primary-color); } .container { max-width: 1200px; margin: 0 auto; padding: 20px; } header { text-align: center; margin-bottom: 40px; } h1 { font-size: 2.5em; color: var(--secondary-color); margin-bottom: 10px; } header p { font-size: 1.2em; color: var(--primary-color); } .deals-grid { display: grid; grid-template-columns: repeat(auto-fill, minmax(280px, 1fr)); gap: 20px; } .deal-card { background-color: var(--card-background); border-radius: 8px; padding: 20px; box-shadow: 0 4px 6px rgba(0, 0, 0, 0.1); transition: transform 0.2s ease-in-out; } .deal-card:hover { transform: translateY(-5px); } .deal-card h2 { margin-top: 0; font-size: 1.3em; color: var(--secondary-color); } .platform { font-weight: bold; color: #7f8c8d; } .end-date { color: #e74c3c; font-size: 0.9em; } .btn { display: inline-block; background-color: var(--secondary-color); color: white; padding: 10px 15px; text-decoration: none; border-radius: 4px; margin-top: 10px; transition: background-color 0.2s ease-in-out; } .btn:hover { background-color: #2980b9; } footer { text-align: center; margin-top: 40px; color: #95a5a6; } footer a { color: var(--secondary-color); text-decoration: none; } footer a:hover { text-decoration: underline; } @media (max-width: 600px) { .container { padding: 10px; } h1 { font-size: 2em; } .deals-grid { grid-template-columns: 1fr; } } `;

delightfulVioletAntlion