DDRP Giveaways

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_219":220,"_221":222},"routes/_app.x.$handle.$name",{"_108":107,"_38":50,"_117":95,"_33":118,"_13":14,"_119":-5,"_11":120,"_121":122,"_123":124,"_125":126,"_127":128,"_26":-5,"_129":130,"_131":132,"_133":31,"_134":135,"_136":64,"_137":-5,"_138":-5,"_139":140},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_48":49,"_38":50,"_43":51,"_52":-5,"_53":31,"_54":55,"_56":55,"_57":58,"_59":-5,"_19":60,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":72,"_73":74,"_75":76,"_77":-5,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":88,"_89":90,"_91":92,"_93":31},"version",85,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","b7ed243e-d434-488f-b6ec-f283cbb30596","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":29,"_30":31,"_32":31,"_33":34,"_35":34},"file",{"_36":37,"_38":34,"_39":26,"_40":42,"_43":44,"_45":14,"_46":47,"_30":31},"previous",{"_36":37,"_38":34,"_39":26,"_40":41},"deleted",false,"deletedHere","path","index.html","latestPath","fileId","019fc4ef-d665-710f-acbe-8eccbafc9836","name","fileType","content","\n\n\n \n \n DDRP Giveaways\n \n \n \n \n \n\n\n

\n \n \n

❦

\n\n \n

\n \n

Active Giveaways

\n \n

Loading giveaways…

\n\n \n

\n \n \n

\n\n

✦

\n\n

Submit Your Entry

\n Your Discord User ID *\n \n

Right-click your Discord profile → Copy User ID. Used to look up your entries and mention you on Discord. Discord Developer Mode must be turned on (Settings → Advanced → Developer Mode).

\n ⚠️ Important: If you do not enter your proper Discord User ID, you will not be qualified to win the prize.\n

\n Pick Your Numbers *\n

\n \n

\n\n \n

My Entries

\n \n

\n Your ID\n \n

\n \n

\n\n \n \n\n \n

📊 Owner Dashboard

\n \n \n

\n\n

\n \n \n

\n\n

Loading…

\n\n

Loading stats…

\n\n

\n 🔒 Owner Dashboard\n ·\n view source\n

\n\n \n \n\n \n

\n\n \n\n\n","\n\n\n \n \n DDRP Giveaways\n \n \n \n \n \n\n\n

\n \n \n

❦

\n\n \n

\n \n

Active Giveaways

\n \n

Loading giveaways…

\n\n \n

\n \n \n

\n\n

✦

\n\n

Submit Your Entry

\n Your Discord User ID *\n

\n \n \n

Click \"Connect Discord\" to automatically get your User ID — no Developer Mode needed. Or manually right-click your Discord profile → Copy User ID (requires Developer Mode in Settings → Advanced).

\n ⚠️ Important: If you do not enter your proper Discord User ID, you will not be qualified to win the prize.\n

\n Pick Your Numbers *\n

\n \n

\n\n \n

My Entries

\n \n

\n Your ID\n \n

\n \n

\n\n \n \n\n \n

📊 Owner Dashboard

\n \n \n

\n\n

\n \n \n

\n\n

Loading…

\n\n

Loading stats…

\n\n

\n 🔒 Owner Dashboard\n ·\n view source\n

\n\n \n \n\n \n

\n\n \n\n\n","createdAt",["D",1785781584395],"branchVersion","branchId","bf0f841f-6c64-4702-a3e9-9cf57962dc9d","id","216614e6-7881-4097-8292-87a412f1487d","DDRP-Giveaways",["D",1785715480085],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Giveaway system with owner dashboard, entries & private notes","imageUrl","12cf16a3-2a6a-421b-b356-b38cc8b42700","pinnedFileId","019fc4ef-d665-710f-acbe-909da26bd235","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",1,"orgId","019fc4cd-f05d-7068-b194-b5dea919cc29","tursoName","216614e678814097829287a412f1487d","tursoHostname","216614e678814097829287a412f1487d-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789648255466],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_108":107,"_116":112},"org",{"_108":107,"_109":110,"_111":112,"_19":60,"_113":114,"_115":31},"branch",{"_13":94,"_38":95,"_48":47,"_96":49,"_97":98,"_99":100,"_101":55,"_102":103,"_104":70,"_105":50,"_106":107},"isOwned",161,"main","projectId","forkedBranchId","271a7958-6cbf-438c-b7e8-9dd2d2d4a2bc","forkedBranchVersion",12,"forkedProjectPrivacy","forkedProjectId","fea1f135-2d3a-472a-a6ed-5fa4688670b5","forkedProjectOrgId","projectName","userHandle","ASHxo","handle","displayName","Chevelle Ezell","avatar","https://lh3.googleusercontent.com/a/ACg8ocJD2GClHcBju4Xwk2TYAuiheZvOXV2UmcqQ4cPAYsoXDR0zeg=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_48":49,"_38":50,"_43":214,"_52":-5,"_53":31,"_54":55,"_56":55,"_57":58,"_59":-5,"_19":60,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":72,"_73":74,"_75":215,"_77":-5,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":216,"_89":217,"_91":218,"_93":31},"tree",[197,198,199,200],"files",[197,198,199,200],"counts",{"_185":186,"_187":68,"_188":186,"_189":190,"_191":192},"contents",[149,150,151,152],"upstreamProject",{"_48":103,"_38":146,"_57":147,"_59":-5,"_54":55,"_87":148},"upstreamBranch",{"_48":98,"_43":141,"_142":143,"_38":95,"_96":103,"_13":100,"_97":-5,"_99":-5,"_144":145,"_52":-5,"_93":31,"_54":55,"_106":107,"_69":70,"_105":146},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1785713332787],"updatedAt",["D",1785715285109],"lockfileKey","1785715285416-esm.town_v_ASHxo_webhook-relay@12-main","webhook-relay","Private webhook relay for storing incoming POSTs",{"_108":107,"_116":112},{"_48":177,"_38":178,"_36":179,"_155":-5,"_46":47,"_45":180,"_157":31,"_43":181,"_13":182,"_39":174,"_40":183,"_30":31,"_162":-5,"_33":184},{"_48":169,"_38":170,"_36":171,"_155":-5,"_46":47,"_45":172,"_157":64,"_43":173,"_13":68,"_39":174,"_40":175,"_30":31,"_162":-5,"_33":176},{"_48":165,"_38":34,"_36":37,"_155":-5,"_46":47,"_45":14,"_157":31,"_43":166,"_13":167,"_39":26,"_40":42,"_30":31,"_162":-5,"_33":168},{"_48":153,"_38":154,"_36":62,"_155":-5,"_46":47,"_45":156,"_157":31,"_43":158,"_13":159,"_39":160,"_40":161,"_30":31,"_162":163,"_33":164},"dcf27059-dd93-4ee0-a8a8-5b5099c23b9d","main.ts","parentId",83,"latest",["D",1785781552585],41,"http","import { staticHTTPServer, parseVal } from \"https://esm.town/v/std/utils/index.ts\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { email } from \"https://esm.town/v/std/email\";\nimport { Hono } from \"npm:hono\";\n\nconst OWNER_PIN = Deno.env.get(\"OWNER_PIN\") ?? \"4947\";\nconst OWNER_EMAIL = Deno.env.get(\"OWNER_EMAIL\") ?? \"\";\n\n// ─── Database Schema ───────────────────────────────────────────────\nawait sqlite.batch([\n { sql: `CREATE TABLE IF NOT EXISTS giveaways (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n description TEXT DEFAULT '',\n status TEXT DEFAULT 'active',\n allow_duplicate_numbers INTEGER DEFAULT 0,\n number_min INTEGER DEFAULT 1,\n number_max INTEGER DEFAULT 100,\n numbers_per_entry INTEGER DEFAULT 1,\n max_entries_per_person INTEGER DEFAULT 1,\n ends_at TEXT,\n auto_draw INTEGER DEFAULT 0,\n notify_participants INTEGER DEFAULT 0,\n created_at TEXT DEFAULT (datetime('now')),\n updated_at TEXT DEFAULT (datetime('now'))\n )` },\n { sql: `CREATE TABLE IF NOT EXISTS entries (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n giveaway_id INTEGER NOT NULL,\n participant_name TEXT NOT NULL,\n participant_id TEXT NOT NULL,\n numbers TEXT NOT NULL,\n email TEXT,\n created_at TEXT DEFAULT (datetime('now'))\n )` },\n { sql: `CREATE TABLE IF NOT EXISTS winners (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n giveaway_id INTEGER NOT NULL,\n winning_number INTEGER NOT NULL,\n prize_description TEXT DEFAULT '',\n created_at TEXT DEFAULT (datetime('now'))\n )` },\n { sql: `CREATE TABLE IF NOT EXISTS owner_notes (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n giveaway_id INTEGER,\n note_text TEXT NOT NULL,\n created_at TEXT DEFAULT (datetime('now'))\n )` },\n { sql: `CREATE TABLE IF NOT EXISTS owner_sessions (\n token TEXT PRIMARY KEY,\n created_at TEXT DEFAULT (datetime('now')),\n expires_at TEXT NOT NULL\n )` },\n]);\n\n// ─── Migrations: add new columns to existing tables ────────────────\nasync function migrateColumn(table: string, column: string, def: string) {\n try {\n await sqlite.execute({ sql: `ALTER TABLE ${table} ADD COLUMN ${column} ${def}` });\n } catch {\n // Column already exists — safe to ignore\n }\n}\nawait migrateColumn(\"giveaways\", \"ends_at\", \"TEXT\");\nawait migrateColumn(\"giveaways\", \"auto_draw\", \"INTEGER DEFAULT 0\");\nawait migrateColumn(\"giveaways\", \"notify_participants\", \"INTEGER DEFAULT 0\");\nawait migrateColumn(\"giveaways\", \"recurring\", \"INTEGER DEFAULT 0\");\nawait migrateColumn(\"giveaways\", \"recurring_interval_days\", \"INTEGER\");\nawait migrateColumn(\"giveaways\", \"next_draw_at\", \"TEXT\");\nawait migrateColumn(\"entries\", \"email\", \"TEXT\");\n\n// ─── Helpers ───────────────────────────────────────────────────────\n\nasync function isAuthed(req: Request): Promise {\n const auth = req.headers.get(\"Authorization\");\n if (!auth?.startsWith(\"Bearer \")) return false;\n const token = auth.slice(7);\n const result = await sqlite.execute({\n sql: \"SELECT 1 FROM owner_sessions WHERE token = ? AND expires_at > datetime('now')\",\n args: [token],\n });\n return result.rows.length > 0;\n}\n\nfunction json(data: unknown, status = 200): Response {\n return new Response(JSON.stringify(data, (_key, value) =>\n typeof value === \"bigint\" ? Number(value) : value\n ), {\n status,\n headers: { \"Content-Type\": \"application/json\" },\n });\n}\n\nfunction normalizeGiveaway(row: Record) {\n return {\n id: Number(row.id),\n name: row.name,\n description: row.description ?? \"\",\n status: row.status ?? \"active\",\n allow_duplicate_numbers: !!row.allow_duplicate_numbers,\n number_min: Number(row.number_min) || 1,\n number_max: Number(row.number_max) || 100,\n numbers_per_entry: Number(row.numbers_per_entry) || 1,\n max_entries_per_person: Number(row.max_entries_per_person) || 1,\n ends_at: row.ends_at ?? null,\n auto_draw: !!row.auto_draw,\n notify_participants: !!row.notify_participants,\n recurring: !!row.recurring,\n recurring_interval_days: row.recurring_interval_days ? Number(row.recurring_interval_days) : null,\n next_draw_at: row.next_draw_at ?? null,\n created_at: row.created_at,\n updated_at: row.updated_at,\n };\n}\n\nasync function getTakenNumbers(giveawayId: number): Promise> {\n const result = await sqlite.execute({\n sql: \"SELECT numbers FROM entries WHERE giveaway_id = ?\",\n args: [giveawayId],\n });\n const taken = new Set();\n for (const row of result.rows) {\n const nums = JSON.parse(row.numbers as string) as number[];\n nums.forEach((n) => taken.add(n));\n }\n return taken;\n}\n\nasync function getEntryCount(giveawayId: number): Promise {\n const result = await sqlite.execute({\n sql: \"SELECT COUNT(*) as count FROM entries WHERE giveaway_id = ?\",\n args: [giveawayId],\n });\n return result.rows[0].count as number;\n}\n\nasync function sendWinnerNotifications(\n giveawayId: number,\n giveawayName: string,\n winningNumber: number,\n prizeDescription: string,\n notifyParticipants: boolean,\n) {\n const entriesResult = await sqlite.execute({\n sql: \"SELECT participant_name, participant_id, email, numbers FROM entries WHERE giveaway_id = ?\",\n args: [giveawayId],\n });\n\n const matchers: { name: string; id: string }[] = [];\n const participantEmails: string[] = [];\n\n for (const row of entriesResult.rows) {\n const nums = JSON.parse(row.numbers as string) as number[];\n if (nums.includes(winningNumber)) {\n matchers.push({ name: row.participant_name as string, id: row.participant_id as string });\n }\n if (row.email) participantEmails.push(row.email as string);\n }\n\n // Notify owner\n if (OWNER_EMAIL) {\n try {\n await email({\n to: OWNER_EMAIL,\n subject: `🎲 Winner drawn: ${giveawayName}`,\n text: `A winner has been drawn for \"${giveawayName}\".\\n\\nWinning number: ${winningNumber}\\nPrize: ${prizeDescription || \"—\"}\\nWinner(s): ${matchers.map((m) => m.name).join(\", \") || \"No match found\"}\\nTotal entries: ${entriesResult.rows.length}`,\n });\n } catch (e) {\n console.error(\"Failed to send owner email:\", e);\n }\n }\n\n // Notify participants\n if (notifyParticipants) {\n for (const emailAddr of participantEmails) {\n try {\n await email({\n to: emailAddr,\n subject: `🎁 ${giveawayName} — Winner Drawn!`,\n text: `The winning number for \"${giveawayName}\" is ${winningNumber}!\\n\\n${matchers.length ? `Winner(s): ${matchers.map((m) => m.name).join(\", \")}` : \"No match found for this number.\"}\\n\\nThank you for participating in DDRP Giveaways!`,\n });\n } catch (e) {\n console.error(`Failed to send email to ${emailAddr}:`, e);\n }\n }\n }\n\n // Send winner announcement to Discord webhook (with role ping)\n const webhookUrl = Deno.env.get(\"GIVEAWAY_DISCORD_WEBHOOK\");\n if (webhookUrl && matchers.length > 0) {\n try {\n const WINNER_ROLE_ID = \"1462179730923982941\";\n const embed = {\n title: `🎉 Winner: ${giveawayName}`,\n fields: [\n { name: \"🔢 Winning Number\", value: String(winningNumber), inline: true },\n { name: \"🏆 Winner(s)\", value: matchers.map((m) => `<@${m.id}>`).join(\", \"), inline: false },\n { name: \"🎁 Prize\", value: prizeDescription || \"—\", inline: false },\n ],\n color: 0xc41e3a,\n timestamp: new Date().toISOString(),\n footer: { text: \"DDRP Giveaways · Winner Announcement\" },\n };\n await fetch(webhookUrl, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({\n content: `<@&${WINNER_ROLE_ID}>`,\n embeds: [embed],\n allowed_mentions: { roles: [WINNER_ROLE_ID] },\n }),\n });\n } catch (e) {\n console.error(\"Failed to send Discord winner announcement:\", e);\n }\n }\n\n return matchers;\n}\n\n// ─── Hono API ──────────────────────────────────────────────────────\n\nconst api = new Hono();\napi.onError((err) => Promise.reject(err));\n\n// ─── PUBLIC ROUTES ──────────────────────────────────────────────────\n\n// List active giveaways\napi.get(\"/api/giveaways\", async (c) => {\n const result = await sqlite.execute(\n \"SELECT * FROM giveaways WHERE status = 'active' ORDER BY created_at DESC\",\n );\n const giveaways = [];\n for (const row of result.rows) {\n giveaways.push({\n ...normalizeGiveaway(row),\n entryCount: await getEntryCount(row.id as number),\n });\n }\n return json(giveaways);\n});\n\n// Get giveaway details\napi.get(\"/api/giveaways/:id\", async (c) => {\n const id = parseInt(c.req.param(\"id\"));\n const result = await sqlite.execute({\n sql: \"SELECT * FROM giveaways WHERE id = ?\",\n args: [id],\n });\n if (result.rows.length === 0) return json({ error: \"Giveaway not found\" }, 404);\n\n const giveaway = normalizeGiveaway(result.rows[0]);\n const taken = await getTakenNumbers(id);\n const winners = await sqlite.execute({\n sql: \"SELECT * FROM winners WHERE giveaway_id = ? ORDER BY created_at DESC\",\n args: [id],\n });\n\n return json({\n ...giveaway,\n entryCount: await getEntryCount(id),\n takenNumbers: [...taken].sort((a, b) => a - b),\n winners: winners.rows,\n });\n});\n\n// Submit entry\napi.post(\"/api/giveaways/:id/entries\", async (c) => {\n const id = parseInt(c.req.param(\"id\"));\n let body;\n try {\n body = await c.req.json();\n } catch {\n return json({ error: \"Invalid JSON body\" }, 400);\n }\n\n const result = await sqlite.execute({\n sql: \"SELECT * FROM giveaways WHERE id = ? AND status = 'active'\",\n args: [id],\n });\n if (result.rows.length === 0) return json({ error: \"Giveaway not found or inactive\" }, 404);\n const giveaway = normalizeGiveaway(result.rows[0]);\n\n // Check if giveaway has ended\n if (giveaway.ends_at && new Date(giveaway.ends_at) <= new Date()) {\n return json({ error: \"This giveaway has ended\" }, 400);\n }\n\n const participantName = typeof body.participantName === \"string\" ? body.participantName.trim() : \"\";\n const participantId = typeof body.participantId === \"string\" ? body.participantId.trim() : \"\";\n if (!participantId) return json({ error: \"Discord User ID is required\" }, 400);\n if (!/^\\d{17,19}$/.test(participantId)) {\n return json({ error: \"Invalid Discord User ID. It must be a 17-19 digit numeric ID.\" }, 400);\n }\n\n const numbers = body.numbers;\n if (!Array.isArray(numbers) || numbers.length !== giveaway.numbers_per_entry) {\n return json({ error: `You must pick exactly ${giveaway.numbers_per_entry} number(s)` }, 400);\n }\n for (const n of numbers) {\n if (typeof n !== \"number\" || !Number.isInteger(n) || n < giveaway.number_min || n > giveaway.number_max) {\n return json({ error: `Numbers must be whole numbers between ${giveaway.number_min} and ${giveaway.number_max}` }, 400);\n }\n }\n\n const unique = new Set(numbers);\n if (unique.size !== numbers.length && !giveaway.allow_duplicate_numbers) {\n return json({ error: \"Duplicate numbers in a single entry are not allowed\" }, 400);\n }\n\n const existing = await sqlite.execute({\n sql: \"SELECT COUNT(*) as count FROM entries WHERE giveaway_id = ? AND participant_id = ?\",\n args: [id, participantId],\n });\n if (!giveaway.unlimited_entries && (existing.rows[0].count as number) >= giveaway.max_entries_per_person) {\n return json({ error: `Maximum entries (${giveaway.max_entries_per_person}) reached for this giveaway` }, 400);\n }\n\n if (!giveaway.allow_duplicate_numbers) {\n const taken = await getTakenNumbers(id);\n for (const n of numbers) {\n if (taken.has(n)) {\n return json({ error: `Number ${n} is already taken. Please choose another.` }, 400);\n }\n }\n }\n\n const participantEmail = null;\n\n await sqlite.execute({\n sql: \"INSERT INTO entries (giveaway_id, participant_name, participant_id, numbers, email) VALUES (?, ?, ?, ?, ?)\",\n args: [id, participantName, participantId, JSON.stringify(numbers), participantEmail || null],\n });\n\n // Send confirmation email to participant\n if (participantEmail && giveaway.notify_participants) {\n try {\n await email({\n to: participantEmail,\n subject: `✅ Entry confirmed: ${giveaway.name}`,\n text: `Your entry for \"${giveaway.name}\" has been confirmed!\\n\\nYour number(s): ${numbers.join(\", \")}\\n${giveaway.ends_at ? `\\nThis giveaway ends on ${giveaway.ends_at}.` : \"\"}\\nGood luck! 🌹`,\n });\n } catch (e) {\n console.error(\"Failed to send confirmation email:\", e);\n }\n }\n\n // Notify owner of new entry\n if (OWNER_EMAIL && giveaway.notify_participants) {\n try {\n await email({\n to: OWNER_EMAIL,\n subject: `📝 New entry: ${giveaway.name}`,\n text: `New entry in \"${giveaway.name}\" from ${participantName}.\\nNumber(s): ${numbers.join(\", \")}\\nTotal entries: ${await getEntryCount(id)}`,\n });\n } catch (e) {\n console.error(\"Failed to send owner notification:\", e);\n }\n }\n\n // Send entry notification to Discord webhook\n const webhookUrl = Deno.env.get(\"GIVEAWAY_DISCORD_WEBHOOK\");\n if (webhookUrl) {\n try {\n const numList = numbers.join(\", \");\n const giveawayName = giveaway.name;\n const isNumericId = /^\\d{17,19}$/.test(participantId);\n const mention = isNumericId ? `<@${participantId}>` : participantId;\n const embed = {\n title: `📝 New Entry: ${giveawayName}`,\n description: `**Discord:** ${mention}`,\n fields: [\n { name: \"🔢 Number(s)\", value: numList, inline: false },\n { name: \"📊 Total Entries\", value: String(await getEntryCount(id)), inline: true },\n ],\n color: 0xc41e3a,\n timestamp: new Date().toISOString(),\n footer: { text: \"DDRP Giveaways · New Entry\" },\n };\n await fetch(webhookUrl, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ embeds: [embed] }),\n });\n } catch (e) {\n console.error(\"Failed to send Discord entry notification:\", e);\n }\n }\n\n return json({ ok: true, message: \"Entry submitted successfully!\" }, 201);\n});\n\n// Get entries for a participant\napi.get(\"/api/giveaways/:id/entries\", async (c) => {\n const id = parseInt(c.req.param(\"id\"));\n const participantId = c.req.query(\"participant_id\");\n if (!participantId) return json({ error: \"participant_id query parameter is required\" }, 400);\n\n const result = await sqlite.execute({\n sql: \"SELECT * FROM entries WHERE giveaway_id = ? AND participant_id = ? ORDER BY created_at DESC\",\n args: [id, participantId],\n });\n const entries = result.rows.map((row) => ({\n ...row,\n numbers: JSON.parse(row.numbers as string),\n }));\n return json(entries);\n});\n\n// Get winners (public)\napi.get(\"/api/giveaways/:id/winners\", async (c) => {\n const id = parseInt(c.req.param(\"id\"));\n const result = await sqlite.execute({\n sql: \"SELECT * FROM winners WHERE giveaway_id = ? ORDER BY created_at DESC\",\n args: [id],\n });\n return json(result.rows);\n});\n\n// ─── OWNER ROUTES ──────────────────────────────────────────────────\n\n// Login with PIN\napi.post(\"/api/owner/login\", async (c) => {\n let body;\n try {\n body = await c.req.json();\n } catch {\n return json({ error: \"Invalid JSON body\" }, 400);\n }\n if (body.pin !== OWNER_PIN) return json({ error: \"Invalid PIN\" }, 401);\n\n await sqlite.execute(\"DELETE FROM owner_sessions WHERE expires_at < datetime('now')\");\n const token = crypto.randomUUID();\n const expires = new Date(Date.now() + 24 * 60 * 60 * 1000).toISOString();\n await sqlite.execute({\n sql: \"INSERT INTO owner_sessions (token, expires_at) VALUES (?, ?)\",\n args: [token, expires],\n });\n\n return json({ token });\n});\n\n// Verify token\napi.post(\"/api/owner/verify\", async (c) => {\n if (!(await isAuthed(c.req.raw))) return json({ error: \"Unauthorized\" }, 401);\n return json({ ok: true });\n});\n\n// List ALL giveaways (owner)\napi.get(\"/api/owner/giveaways\", async (c) => {\n if (!(await isAuthed(c.req.raw))) return json({ error: \"Unauthorized\" }, 401);\n const result = await sqlite.execute(\"SELECT * FROM giveaways ORDER BY created_at DESC\");\n const giveaways = [];\n for (const row of result.rows) {\n giveaways.push({\n ...normalizeGiveaway(row),\n entryCount: await getEntryCount(row.id as number),\n });\n }\n return json(giveaways);\n});\n\n// Create giveaway\napi.post(\"/api/owner/giveaways\", async (c) => {\n if (!(await isAuthed(c.req.raw))) return json({ error: \"Unauthorized\" }, 401);\n let body;\n try {\n body = await c.req.json();\n } catch {\n return json({ error: \"Invalid JSON body\" }, 400);\n }\n\n const name = typeof body.name === \"string\" ? body.name.trim() : \"\";\n if (!name) return json({ error: \"Giveaway name is required\" }, 400);\n\n const result = await sqlite.execute({\n sql: `INSERT INTO giveaways (name, description, status, allow_duplicate_numbers, number_min, number_max, numbers_per_entry, max_entries_per_person, ends_at, auto_draw, notify_participants, recurring, recurring_interval_days)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [\n name,\n typeof body.description === \"string\" ? body.description.trim() : \"\",\n body.status ?? \"active\",\n body.allow_duplicate_numbers ? 1 : 0,\n parseInt(body.number_min) || 1,\n parseInt(body.number_max) || 100,\n parseInt(body.numbers_per_entry) || 1,\n parseInt(body.max_entries_per_person) || 1,\n typeof body.ends_at === \"string\" && body.ends_at ? body.ends_at : null,\n body.auto_draw ? 1 : 0,\n body.notify_participants ? 1 : 0,\n body.recurring ? 1 : 0,\n body.recurring_interval_days ? parseInt(body.recurring_interval_days) : null,\n ],\n });\n\n return json({ id: result.lastInsertRowid, ok: true }, 201);\n});\n\n// Update giveaway\napi.put(\"/api/owner/giveaways/:id\", async (c) => {\n if (!(await isAuthed(c.req.raw))) return json({ error: \"Unauthorized\" }, 401);\n const id = parseInt(c.req.param(\"id\"));\n let body;\n try {\n body = await c.req.json();\n } catch {\n return json({ error: \"Invalid JSON body\" }, 400);\n }\n\n const updates: string[] = [];\n const args: (string | number | null)[] = [];\n\n const fields: Record = {\n name: body.name,\n description: body.description,\n status: body.status,\n allow_duplicate_numbers: body.allow_duplicate_numbers !== undefined ? (body.allow_duplicate_numbers ? 1 : 0) : undefined,\n number_min: body.number_min !== undefined ? parseInt(body.number_min) : undefined,\n number_max: body.number_max !== undefined ? parseInt(body.number_max) : undefined,\n numbers_per_entry: body.numbers_per_entry !== undefined ? parseInt(body.numbers_per_entry) : undefined,\n max_entries_per_person: body.max_entries_per_person !== undefined ? parseInt(body.max_entries_per_person) : undefined,\n ends_at: body.ends_at !== undefined ? (body.ends_at || null) : undefined,\n auto_draw: body.auto_draw !== undefined ? (body.auto_draw ? 1 : 0) : undefined,\n notify_participants: body.notify_participants !== undefined ? (body.notify_participants ? 1 : 0) : undefined,\n recurring: body.recurring !== undefined ? (body.recurring ? 1 : 0) : undefined,\n recurring_interval_days: body.recurring_interval_days !== undefined ? (body.recurring_interval_days ? parseInt(body.recurring_interval_days) : null) : undefined,\n };\n\n for (const [key, value] of Object.entries(fields)) {\n if (value !== undefined) {\n updates.push(`${key} = ?`);\n args.push(value as string | number | null);\n }\n }\n updates.push(\"updated_at = datetime('now')\");\n args.push(id);\n\n await sqlite.execute({\n sql: `UPDATE giveaways SET ${updates.join(\", \")} WHERE id = ?`,\n args,\n });\n\n return json({ ok: true });\n});\n\n// Delete giveaway\napi.delete(\"/api/owner/giveaways/:id\", async (c) => {\n if (!(await isAuthed(c.req.raw))) return json({ error: \"Unauthorized\" }, 401);\n const id = parseInt(c.req.param(\"id\"));\n await sqlite.batch([\n { sql: \"DELETE FROM entries WHERE giveaway_id = ?\", args: [id] },\n { sql: \"DELETE FROM winners WHERE giveaway_id = ?\", args: [id] },\n { sql: \"DELETE FROM owner_notes WHERE giveaway_id = ?\", args: [id] },\n { sql: \"DELETE FROM giveaways WHERE id = ?\", args: [id] },\n ]);\n return json({ ok: true });\n});\n\n// List all entries for a giveaway (owner)\napi.get(\"/api/owner/giveaways/:id/entries\", async (c) => {\n if (!(await isAuthed(c.req.raw))) return json({ error: \"Unauthorized\" }, 401);\n const id = parseInt(c.req.param(\"id\"));\n const result = await sqlite.execute({\n sql: \"SELECT * FROM entries WHERE giveaway_id = ? ORDER BY created_at DESC\",\n args: [id],\n });\n const entries = result.rows.map((row) => ({\n ...row,\n numbers: JSON.parse(row.numbers as string),\n }));\n return json(entries);\n});\n\n// Add a winner (manual)\napi.post(\"/api/owner/giveaways/:id/winners\", async (c) => {\n if (!(await isAuthed(c.req.raw))) return json({ error: \"Unauthorized\" }, 401);\n const id = parseInt(c.req.param(\"id\"));\n let body;\n try {\n body = await c.req.json();\n } catch {\n return json({ error: \"Invalid JSON body\" }, 400);\n }\n\n const winningNumber = parseInt(body.winning_number);\n if (isNaN(winningNumber)) return json({ error: \"A valid winning number is required\" }, 400);\n\n const giveawayResult = await sqlite.execute({\n sql: \"SELECT name, notify_participants, recurring, recurring_interval_days, next_draw_at FROM giveaways WHERE id = ?\",\n args: [id],\n });\n if (giveawayResult.rows.length === 0) return json({ error: \"Giveaway not found\" }, 404);\n const giveaway = giveawayResult.rows[0];\n\n const prizeDesc = typeof body.prize_description === \"string\" ? body.prize_description.trim() : \"\";\n const result = await sqlite.execute({\n sql: \"INSERT INTO winners (giveaway_id, winning_number, prize_description) VALUES (?, ?, ?)\",\n args: [id, winningNumber, prizeDesc],\n });\n\n const matchers = await sendWinnerNotifications(\n id, giveaway.name as string, winningNumber, prizeDesc, !!giveaway.notify_participants,\n );\n\n // If recurring or scheduled recurring, clear entries so the giveaway restarts fresh\n if (giveaway.recurring || giveaway.recurring_interval_days) {\n await sqlite.execute({ sql: \"DELETE FROM entries WHERE giveaway_id = ?\", args: [id] });\n }\n\n // If scheduled recurring, set the next auto-draw date (only if not already scheduled in the future)\n const intervalDays = giveaway.recurring_interval_days ? Number(giveaway.recurring_interval_days) : null;\n if (intervalDays) {\n const existingNextDraw = giveaway.next_draw_at as string | null;\n if (!existingNextDraw || new Date(existingNextDraw) <= new Date()) {\n const nextDraw = new Date(Date.now() + intervalDays * 86400000).toISOString();\n await sqlite.execute({ sql: \"UPDATE giveaways SET next_draw_at = ? WHERE id = ?\", args: [nextDraw, id] });\n }\n }\n\n return json({ id: result.lastInsertRowid, ok: true, matchers, recurred: !!giveaway.recurring }, 201);\n});\n\n// Auto-draw a random winner\napi.post(\"/api/owner/giveaways/:id/auto-draw\", async (c) => {\n if (!(await isAuthed(c.req.raw))) return json({ error: \"Unauthorized\" }, 401);\n const id = parseInt(c.req.param(\"id\"));\n let body = {};\n try { body = await c.req.json(); } catch { /* no body needed */ }\n\n const giveawayResult = await sqlite.execute({\n sql: \"SELECT * FROM giveaways WHERE id = ?\",\n args: [id],\n });\n if (giveawayResult.rows.length === 0) return json({ error: \"Giveaway not found\" }, 404);\n const giveaway = normalizeGiveaway(giveawayResult.rows[0]);\n\n let winningNumber: number;\n if (giveaway.recurring) {\n // Recurring: pick a random number in the full range (e.g. 1-1000)\n winningNumber = Math.floor(Math.random() * (giveaway.number_max - giveaway.number_min + 1)) + giveaway.number_min;\n } else {\n const taken = await getTakenNumbers(id);\n const availableNumbers = [...taken];\n if (availableNumbers.length === 0) {\n return json({ error: \"No entries to draw from\" }, 400);\n }\n winningNumber = availableNumbers[Math.floor(Math.random() * availableNumbers.length)];\n }\n const prizeDesc = typeof body.prize_description === \"string\" ? body.prize_description.trim() : \"Auto-drawn winner\";\n\n const result = await sqlite.execute({\n sql: \"INSERT INTO winners (giveaway_id, winning_number, prize_description) VALUES (?, ?, ?)\",\n args: [id, winningNumber, prizeDesc],\n });\n\n const matchers = await sendWinnerNotifications(\n id, giveaway.name, winningNumber, prizeDesc, giveaway.notify_participants,\n );\n\n // If recurring or scheduled recurring, clear entries\n if (giveaway.recurring || giveaway.recurring_interval_days) {\n await sqlite.execute({ sql: \"DELETE FROM entries WHERE giveaway_id = ?\", args: [id] });\n }\n\n // If scheduled recurring, set the next auto-draw date (only if not already scheduled in the future)\n if (giveaway.recurring_interval_days) {\n if (!giveaway.next_draw_at || new Date(giveaway.next_draw_at) <= new Date()) {\n const nextDraw = new Date(Date.now() + giveaway.recurring_interval_days * 86400000).toISOString();\n await sqlite.execute({ sql: \"UPDATE giveaways SET next_draw_at = ? WHERE id = ?\", args: [nextDraw, id] });\n }\n }\n\n return json({ id: result.lastInsertRowid, ok: true, winningNumber, matchers, recurred: giveaway.recurring }, 201);\n});\n\n// End a giveaway manually\napi.post(\"/api/owner/giveaways/:id/end\", async (c) => {\n if (!(await isAuthed(c.req.raw))) return json({ error: \"Unauthorized\" }, 401);\n const id = parseInt(c.req.param(\"id\"));\n await sqlite.execute({\n sql: \"UPDATE giveaways SET status = 'ended', updated_at = datetime('now') WHERE id = ?\",\n args: [id],\n });\n return json({ ok: true });\n});\n\n// Get stats (owner)\napi.get(\"/api/owner/stats\", async (c) => {\n if (!(await isAuthed(c.req.raw))) return json({ error: \"Unauthorized\" }, 401);\n\n const totalGiveaways = await sqlite.execute(\"SELECT COUNT(*) as count FROM giveaways\");\n const activeGiveaways = await sqlite.execute(\"SELECT COUNT(*) as count FROM giveaways WHERE status = 'active'\");\n const draftGiveaways = await sqlite.execute(\"SELECT COUNT(*) as count FROM giveaways WHERE status = 'draft'\");\n const endedGiveaways = await sqlite.execute(\"SELECT COUNT(*) as count FROM giveaways WHERE status = 'ended'\");\n const totalEntries = await sqlite.execute(\"SELECT COUNT(*) as count FROM entries\");\n const totalWinners = await sqlite.execute(\"SELECT COUNT(*) as count FROM winners\");\n const uniqueParticipants = await sqlite.execute(\"SELECT COUNT(DISTINCT participant_id) as count FROM entries\");\n\n const popular = await sqlite.execute({\n sql: `SELECT g.id, g.name, g.status, COUNT(e.id) as entry_count\n FROM giveaways g LEFT JOIN entries e ON g.id = e.giveaway_id\n GROUP BY g.id ORDER BY entry_count DESC LIMIT 5`,\n });\n\n const recent = await sqlite.execute({\n sql: `SELECT e.id, e.participant_name, e.participant_id, e.numbers, e.created_at, g.name as giveaway_name\n FROM entries e JOIN giveaways g ON e.giveaway_id = g.id\n ORDER BY e.created_at DESC LIMIT 10`,\n });\n\n return json({\n totalGiveaways: totalGiveaways.rows[0].count,\n activeGiveaways: activeGiveaways.rows[0].count,\n draftGiveaways: draftGiveaways.rows[0].count,\n endedGiveaways: endedGiveaways.rows[0].count,\n totalEntries: totalEntries.rows[0].count,\n totalWinners: totalWinners.rows[0].count,\n uniqueParticipants: uniqueParticipants.rows[0].count,\n popularGiveaways: popular.rows.map((r) => ({\n id: Number(r.id),\n name: r.name,\n status: r.status,\n entryCount: Number(r.entry_count),\n })),\n recentEntries: recent.rows.map((r) => ({\n id: Number(r.id),\n participantName: r.participant_name,\n participantId: r.participant_id,\n numbers: JSON.parse(r.numbers as string),\n createdAt: r.created_at,\n giveawayName: r.giveaway_name,\n })),\n });\n});\n\n// Delete a winner\napi.delete(\"/api/owner/giveaways/:id/winners/:wid\", async (c) => {\n if (!(await isAuthed(c.req.raw))) return json({ error: \"Unauthorized\" }, 401);\n const wid = parseInt(c.req.param(\"wid\"));\n await sqlite.execute({ sql: \"DELETE FROM winners WHERE id = ?\", args: [wid] });\n return json({ ok: true });\n});\n\n// Get notes for a giveaway\napi.get(\"/api/owner/giveaways/:id/notes\", async (c) => {\n if (!(await isAuthed(c.req.raw))) return json({ error: \"Unauthorized\" }, 401);\n const id = parseInt(c.req.param(\"id\"));\n const result = await sqlite.execute({\n sql: \"SELECT * FROM owner_notes WHERE giveaway_id = ? ORDER BY created_at DESC\",\n args: [id],\n });\n return c.json(result.rows);\n});\n\n// Add a note\napi.post(\"/api/owner/giveaways/:id/notes\", async (c) => {\n if (!(await isAuthed(c.req.raw))) return json({ error: \"Unauthorized\" }, 401);\n const id = parseInt(c.req.param(\"id\"));\n let body;\n try {\n body = await c.req.json();\n } catch {\n return json({ error: \"Invalid JSON body\" }, 400);\n }\n\n const noteText = typeof body.note_text === \"string\" ? body.note_text.trim() : \"\";\n if (!noteText) return json({ error: \"Note text is required\" }, 400);\n\n const result = await sqlite.execute({\n sql: \"INSERT INTO owner_notes (giveaway_id, note_text) VALUES (?, ?)\",\n args: [id, noteText],\n });\n\n return json({ id: result.lastInsertRowid, ok: true }, 201);\n});\n\n// Delete a note\napi.delete(\"/api/owner/notes/:nid\", async (c) => {\n if (!(await isAuthed(c.req.raw))) return json({ error: \"Unauthorized\" }, 401);\n const nid = parseInt(c.req.param(\"nid\"));\n await sqlite.execute({ sql: \"DELETE FROM owner_notes WHERE id = ?\", args: [nid] });\n return json({ ok: true });\n});\n\n// ─── DISCORD OAUTH2 ──────────────────────────────────────────────────\n\n// Redirect to Discord authorization page\napi.get(\"/api/auth/discord\", (c) => {\n const clientId = Deno.env.get(\"DISCORD_CLIENT_ID\");\n if (!clientId) return json({ error: \"Discord OAuth not configured\" }, 500);\n\n const url = new URL(c.req.url);\n const redirectUri = `${url.origin}/api/auth/discord/callback`;\n const state = c.req.query(\"state\") || \"\";\n\n const params = new URLSearchParams({\n client_id: clientId,\n redirect_uri: redirectUri,\n response_type: \"code\",\n scope: \"identify\",\n state,\n });\n\n return Response.redirect(\n `https://discord.com/api/oauth2/authorize?${params}`,\n 302,\n );\n});\n\n// Discord callback — exchange code, get user info, set cookies, redirect back\napi.get(\"/api/auth/discord/callback\", async (c) => {\n const url = new URL(c.req.url);\n const origin = url.origin;\n const code = c.req.query(\"code\");\n const state = c.req.query(\"state\") || \"\";\n const error = c.req.query(\"error\");\n\n if (error) {\n return Response.redirect(\n `${origin}/?discord_error=${encodeURIComponent(error)}`,\n 302,\n );\n }\n if (!code) return json({ error: \"No authorization code provided\" }, 400);\n\n const clientId = Deno.env.get(\"DISCORD_CLIENT_ID\");\n const clientSecret = Deno.env.get(\"DISCORD_CLIENT_SECRET\");\n if (!clientId || !clientSecret) {\n return json({ error: \"Discord OAuth not configured\" }, 500);\n }\n\n const redirectUri = `${origin}/api/auth/discord/callback`;\n\n // Exchange code for access token\n const tokenRes = await fetch(\"https://discord.com/api/oauth2/token\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/x-www-form-urlencoded\" },\n body: new URLSearchParams({\n client_id: clientId,\n client_secret: clientSecret,\n grant_type: \"authorization_code\",\n code,\n redirect_uri: redirectUri,\n }),\n });\n\n if (!tokenRes.ok) {\n console.error(\"Discord token exchange failed:\", await tokenRes.text());\n return Response.redirect(`${origin}/?discord_error=token_failed`, 302);\n }\n\n const tokenData = await tokenRes.json();\n\n // Fetch user info from Discord\n const userRes = await fetch(\"https://discord.com/api/users/@me\", {\n headers: { Authorization: `Bearer ${tokenData.access_token}` },\n });\n\n if (!userRes.ok) {\n return Response.redirect(`${origin}/?discord_error=user_fetch_failed`, 302);\n }\n\n const userData = await userRes.json();\n\n // Redirect back to the giveaway (if state) or home, with cookies set\n const redirectUrl = state\n ? `${origin}/?giveaway=${encodeURIComponent(state)}`\n : `${origin}/`;\n\n const headers = new Headers();\n headers.set(\"Location\", redirectUrl);\n headers.append(\n \"Set-Cookie\",\n `discord_id=${userData.id}; Path=/; Max-Age=31536000; SameSite=Lax`,\n );\n headers.append(\n \"Set-Cookie\",\n `discord_name=${encodeURIComponent(userData.username)}; Path=/; Max-Age=31536000; SameSite=Lax`,\n );\n\n return new Response(null, { status: 302, headers });\n});\n\n// ─── Main Handler ──────────────────────────────────────────────────\n\nexport default staticHTTPServer(import.meta.url, async (req) => {\n const url = new URL(req.url);\n\n if (url.pathname.startsWith(\"/api/\")) {\n return await api.fetch(req);\n }\n\n if (url.pathname === \"/source\") {\n return new Response(null, { status: 302, headers: { Location: parseVal().links.self.val } });\n }\n\n return null;\n});\n","label","ddrp-giveaways",[154],"e78d6afe-5ad5-4185-9dea-6ce03eb6e0e9",["D",1785781584395],34,[34],"47f6d875-e973-4b6e-a721-1eae00f6e899","discord-update.ts","aa1dd9c8-8f5e-11f1-b2a5-1607ee4eb77e",46,["D",1785777368889],"interval","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport default async function () {\n const webhookUrl = Deno.env.get(\"GIVEAWAY_DISCORD_WEBHOOK\");\n if (!webhookUrl) {\n console.error(\"GIVEAWAY_DISCORD_WEBHOOK not set — skipping Discord update\");\n return;\n }\n\n // Get all active giveaways with entry counts\n const result = await sqlite.execute({\n sql: `SELECT g.id, g.name, g.description, g.number_min, g.number_max,\n g.numbers_per_entry, g.allow_duplicate_numbers, g.ends_at,\n g.recurring, g.auto_draw,\n COUNT(e.id) as entry_count\n FROM giveaways g\n LEFT JOIN entries e ON g.id = e.giveaway_id\n WHERE g.status = 'active'\n GROUP BY g.id\n ORDER BY g.created_at DESC`,\n });\n\n // Build Discord embed\n let totalEntries = 0;\n const fields: Record[] = [];\n\n for (const row of result.rows) {\n const name = row.name as string;\n const entryCount = Number(row.entry_count);\n totalEntries += entryCount;\n const range = `${row.number_min}-${row.number_max}`;\n const recurring = !!row.recurring;\n const endsAt = row.ends_at as string | null;\n\n let value = `📊 **${entryCount}** entries\\n🔢 Range: ${range}`;\n if (recurring) value += \"\\n🔁 Recurring — resets after each draw\";\n if (endsAt) {\n const ended = new Date(endsAt) <= new Date();\n if (!ended) {\n const diff = new Date(endsAt).getTime() - Date.now();\n const hrs = Math.floor(diff / 3600000);\n const days = Math.floor(hrs / 24);\n value += days > 0\n ? `\\n⏰ Ends in ${days}d ${hrs % 24}h`\n : `\\n⏰ Ends in ${hrs}h`;\n }\n }\n\n fields.push({ name: `🎁 ${name}`, value, inline: false });\n }\n\n const embed = {\n title: \"🌹 DDRP Giveaways — Status Update\",\n description: result.rows.length === 0\n ? \"No active giveaways right now.\"\n : `**${result.rows.length}** active giveaway(s) · **${totalEntries}** total entries`,\n color: 0xc41e3a,\n fields: fields.slice(0, 25), // Discord embed limit\n timestamp: new Date().toISOString(),\n footer: { text: \"DDRP Giveaways · Auto-update every 3 hours\" },\n };\n\n try {\n const res = await fetch(webhookUrl, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ embeds: [embed] }),\n });\n if (!res.ok) {\n console.error(\"Discord webhook failed:\", res.status, await res.text());\n } else {\n console.log(`Discord update sent: ${result.rows.length} giveaways, ${totalEntries} entries`);\n }\n } catch (e) {\n console.error(\"Failed to send Discord update:\", e);\n }\n\n // Clean up expired owner sessions\n await sqlite.execute(\"DELETE FROM owner_sessions WHERE expires_at < datetime('now')\");\n}\n",[170],"32a0e945-a023-4308-b8d7-4d36fb69a8c7","auto-draw.ts","3e2802f2-8f59-11f1-be0c-1607ee4eb77e",74,["D",1785780440461],6,"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { email } from \"https://esm.town/v/std/email\";\n\nexport default async function () {\n // Find giveaways that have ended and need auto-draw\n const result = await sqlite.execute({\n sql: `SELECT * FROM giveaways\n WHERE ends_at IS NOT NULL\n AND ends_at <= datetime('now')\n AND auto_draw = 1\n AND status = 'active'`,\n });\n\n for (const giveaway of result.rows) {\n const id = Number(giveaway.id);\n const giveawayName = giveaway.name as string;\n const notifyParticipants = !!giveaway.notify_participants;\n\n // Get all entries with their numbers\n const entriesResult = await sqlite.execute({\n sql: \"SELECT id, participant_name, participant_id, email, numbers FROM entries WHERE giveaway_id = ?\",\n args: [id],\n });\n\n // Collect all taken numbers\n const takenNumbers: number[] = [];\n for (const row of entriesResult.rows) {\n const nums = JSON.parse(row.numbers as string) as number[];\n nums.forEach((n) => { if (!takenNumbers.includes(n)) takenNumbers.push(n); });\n }\n\n const isRecurring = !!giveaway.recurring;\n\n // For recurring giveaways, pick a random number in the full range (e.g. 1-1000)\n // For non-recurring, pick from entered numbers\n let winningNumber: number;\n if (isRecurring) {\n const min = Number(giveaway.number_min) || 1;\n const max = Number(giveaway.number_max) || 1000;\n winningNumber = Math.floor(Math.random() * (max - min + 1)) + min;\n } else {\n if (takenNumbers.length === 0) {\n // No entries, just mark as ended\n await sqlite.execute({\n sql: \"UPDATE giveaways SET status = 'ended', updated_at = datetime('now') WHERE id = ?\",\n args: [id],\n });\n console.log(`Giveaway \"${giveawayName}\" ended with no entries.`);\n continue;\n }\n winningNumber = takenNumbers[Math.floor(Math.random() * takenNumbers.length)];\n }\n\n // Insert winner\n await sqlite.execute({\n sql: \"INSERT INTO winners (giveaway_id, winning_number, prize_description) VALUES (?, ?, ?)\",\n args: [id, winningNumber, \"Auto-drawn winner\"],\n });\n\n if (isRecurring) {\n // Clear entries for the next round; keep status active\n await sqlite.execute({ sql: \"DELETE FROM entries WHERE giveaway_id = ?\", args: [id] });\n await sqlite.execute({\n sql: \"UPDATE giveaways SET updated_at = datetime('now') WHERE id = ?\",\n args: [id],\n });\n } else {\n await sqlite.execute({\n sql: \"UPDATE giveaways SET status = 'ended', updated_at = datetime('now') WHERE id = ?\",\n args: [id],\n });\n }\n\n // Find winner(s) and collect emails\n const winnerNames: string[] = [];\n const winnerIds: string[] = [];\n const participantEmails: string[] = [];\n for (const row of entriesResult.rows) {\n const nums = JSON.parse(row.numbers as string) as number[];\n if (nums.includes(winningNumber)) {\n winnerNames.push(row.participant_name as string);\n winnerIds.push(row.participant_id as string);\n }\n if (row.email) participantEmails.push(row.email as string);\n }\n\n // Send winner announcement to Discord webhook (with role ping)\n const webhookUrl = Deno.env.get(\"GIVEAWAY_DISCORD_WEBHOOK\");\n if (webhookUrl && winnerIds.length > 0) {\n try {\n const WINNER_ROLE_ID = \"1462179730923982941\";\n const embed = {\n title: `🎉 Winner: ${giveawayName}`,\n fields: [\n { name: \"🔢 Winning Number\", value: String(winningNumber), inline: true },\n { name: \"🏆 Winner(s)\", value: winnerIds.map((id) => `<@${id}>`).join(\", \"), inline: false },\n { name: \"🎁 Prize\", value: \"Auto-drawn winner\", inline: false },\n ],\n color: 0xc41e3a,\n timestamp: new Date().toISOString(),\n footer: { text: \"DDRP Giveaways · Winner Announcement\" },\n };\n await fetch(webhookUrl, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({\n content: `<@&${WINNER_ROLE_ID}>`,\n embeds: [embed],\n allowed_mentions: { roles: [WINNER_ROLE_ID] },\n }),\n });\n } catch (e) {\n console.error(\"Failed to send Discord winner announcement:\", e);\n }\n }\n\n // Notify owner\n const ownerEmail = Deno.env.get(\"OWNER_EMAIL\");\n if (ownerEmail) {\n try {\n await email({\n to: ownerEmail,\n subject: `🎲 Auto-draw complete: ${giveawayName}`,\n text: `Giveaway \"${giveawayName}\" has ended and a winner has been auto-drawn.\\n\\nWinning number: ${winningNumber}\\nWinner(s): ${winnerNames.join(\", \") || \"No match\"}\\nTotal entries: ${entriesResult.rows.length}`,\n });\n } catch (e) {\n console.error(\"Failed to send owner email:\", e);\n }\n }\n\n // Notify participants\n if (notifyParticipants) {\n for (const emailAddr of participantEmails) {\n try {\n await email({\n to: emailAddr,\n subject: `🎁 ${giveawayName} — Winner Drawn!`,\n text: `The winning number for \"${giveawayName}\" is ${winningNumber}!\\n\\n${winnerNames.length ? `Winner(s): ${winnerNames.join(\", \")}` : \"No match found for this number.\"}\\n\\nThank you for participating in DDRP Giveaways!`,\n });\n } catch (e) {\n console.error(`Failed to send email to ${emailAddr}:`, e);\n }\n }\n }\n\n console.log(`Auto-drew winner for \"${giveawayName}\": winning number ${winningNumber}`);\n }\n\n // ─── Scheduled recurring draws ──────────────────────────────────\n // Check for giveaways with a scheduled next_draw_at that has passed\n const scheduled = await sqlite.execute({\n sql: `SELECT * FROM giveaways\n WHERE next_draw_at IS NOT NULL\n AND next_draw_at <= datetime('now')\n AND status = 'active'`,\n });\n\n for (const g of scheduled.rows) {\n const sid = Number(g.id);\n const sName = g.name as string;\n const sMin = Number(g.number_min) || 1;\n const sMax = Number(g.number_max) || 1000;\n const sInterval = Number(g.recurring_interval_days) || 14;\n const sNotify = !!g.notify_participants;\n\n // Pick a random winning number in the full range\n const sWinning = Math.floor(Math.random() * (sMax - sMin + 1)) + sMin;\n\n // Fetch entries BEFORE clearing them (needed to find matchers)\n const sEntriesResult = await sqlite.execute({\n sql: \"SELECT participant_name, participant_id, numbers FROM entries WHERE giveaway_id = ?\",\n args: [sid],\n });\n\n // Insert winner\n await sqlite.execute({\n sql: \"INSERT INTO winners (giveaway_id, winning_number, prize_description) VALUES (?, ?, ?)\",\n args: [sid, sWinning, \"Scheduled auto-draw winner\"],\n });\n\n // Find matchers BEFORE clearing entries\n const sWinnerIds: string[] = [];\n for (const row of sEntriesResult.rows) {\n const nums = JSON.parse(row.numbers as string) as number[];\n if (nums.includes(sWinning)) {\n sWinnerIds.push(row.participant_id as string);\n }\n }\n\n // Send winner announcement to Discord webhook (with role ping)\n const sWebhookUrl = Deno.env.get(\"GIVEAWAY_DISCORD_WEBHOOK\");\n if (sWebhookUrl && sWinnerIds.length > 0) {\n try {\n const WINNER_ROLE_ID = \"1462179730923982941\";\n const embed = {\n title: `🎉 Winner: ${sName}`,\n fields: [\n { name: \"🔢 Winning Number\", value: String(sWinning), inline: true },\n { name: \"🏆 Winner(s)\", value: sWinnerIds.map((id) => `<@${id}>`).join(\", \"), inline: false },\n { name: \"🎁 Prize\", value: \"Scheduled auto-draw winner\", inline: false },\n ],\n color: 0xc41e3a,\n timestamp: new Date().toISOString(),\n footer: { text: \"DDRP Giveaways · Winner Announcement\" },\n };\n await fetch(sWebhookUrl, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({\n content: `<@&${WINNER_ROLE_ID}>`,\n embeds: [embed],\n allowed_mentions: { roles: [WINNER_ROLE_ID] },\n }),\n });\n } catch (e) {\n console.error(\"Failed to send Discord winner announcement:\", e);\n }\n }\n\n // Clear entries for the next round\n await sqlite.execute({ sql: \"DELETE FROM entries WHERE giveaway_id = ?\", args: [sid] });\n\n // Set next draw date\n const nextDraw = new Date(Date.now() + sInterval * 86400000).toISOString();\n await sqlite.execute({\n sql: \"UPDATE giveaways SET next_draw_at = ?, updated_at = datetime('now') WHERE id = ?\",\n args: [nextDraw, sid],\n });\n\n // Notify owner\n const sOwnerEmail = Deno.env.get(\"OWNER_EMAIL\");\n if (sOwnerEmail) {\n try {\n await email({\n to: sOwnerEmail,\n subject: `📅 Scheduled draw: ${sName}`,\n text: `Scheduled auto-draw for \"${sName}\".\\n\\nWinning number: ${sWinning}\\nNext draw: ${nextDraw}`,\n });\n } catch (e) {\n console.error(\"Failed to send scheduled draw email:\", e);\n }\n }\n\n console.log(`Scheduled draw for \"${sName}\": winning number ${sWinning}`);\n }\n\n // Clean up expired owner sessions\n await sqlite.execute(\"DELETE FROM owner_sessions WHERE expires_at < datetime('now')\");\n}\n",[178],"pulls",0,"branches","forks","envVars",{"_193":195,"_196":186},"connections",{"_193":186,"_194":186},"count","unfilledCount",5,"emptyCount",{"_48":177,"_38":178,"_36":179,"_155":-5,"_46":47,"_45":180,"_157":31,"_43":211,"_13":182,"_39":174,"_40":183,"_30":31,"_162":-5,"_202":212,"_33":213},{"_48":169,"_38":170,"_36":171,"_155":-5,"_46":47,"_45":172,"_157":64,"_43":208,"_13":68,"_39":174,"_40":175,"_30":31,"_162":-5,"_202":209,"_33":210},{"_48":165,"_38":34,"_36":37,"_155":-5,"_46":47,"_45":14,"_157":31,"_43":205,"_13":167,"_39":26,"_40":42,"_30":31,"_162":-5,"_202":206,"_33":207},{"_48":153,"_38":154,"_36":62,"_155":-5,"_46":47,"_45":156,"_157":31,"_43":201,"_13":159,"_39":160,"_40":161,"_30":31,"_162":163,"_202":203,"_33":204},["D",1785781552585],"children",[],[154],["D",1785781584395],[],[34],["D",1785777368889],[],[170],["D",1785780440461],[],[178],["D",1785715480085],["D",1789648255466],{"_108":107,"_116":112},{"_108":107,"_109":110,"_111":112,"_19":60,"_113":114,"_115":31},{"_13":94,"_38":95,"_48":47,"_96":49,"_97":98,"_99":100,"_101":55,"_102":103,"_104":70,"_105":50,"_106":107},"ctx",{"_87":-5,"_138":252,"_253":254,"_255":256,"_257":31,"_258":31,"_259":31,"_260":64,"_261":-5,"_262":-7,"_263":-7,"_264":186,"_265":31,"_266":31,"_267":-5,"_268":31,"_269":31,"_270":31,"_271":-5},"ENV",{"_223":224,"_225":226,"_227":95,"_228":229,"_230":231,"_232":233,"_234":235,"_236":237,"_238":239,"_240":241,"_242":243,"_244":245,"_246":247,"_248":249,"_250":251},"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"]

DDRP Giveaways

Active Giveaways

Submit Your Entry

My Entries

Owner Access

📊 Owner Dashboard

DDRP Giveaways

Active Giveaways

Submit Your Entry

My Entries

Owner Access

📊 Owner Dashboard

Diff · v85