DDRP Giveaways

\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 Discord Connection *\n \n

Click \"Connect Discord\" to link your account and enter the giveaway.

\n ⚠️ Important: You must connect your Discord account.\n

\n Pick Your Numbers *\n

\n \n

\n\n \n

My Entries

\n \n

\n Discord Connection\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",[151],"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",[159],"b6e2af02-f496-4f46-820e-80de22138ed7","auto-draw.ts","3e2802f2-8f59-11f1-be0c-1607ee4eb77e",["D",1785794242288],21,"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { email } from \"https://esm.town/v/std/email\";\n\n/**\n * Pick a random winning number from [min, max] that hasn't been drawn before\n * for this giveaway. When every number in the range has been used at least\n * once, falls back to a fully random pick (cycle resets).\n */\nasync function pickUniqueWinningNumber(giveawayId: number, min: number, max: number): Promise {\n const prevWinners = await sqlite.execute({\n sql: \"SELECT winning_number FROM winners WHERE giveaway_id = ?\",\n args: [giveawayId],\n });\n const used = new Set();\n for (const row of prevWinners.rows) {\n used.add(Number(row.winning_number));\n }\n\n const available: number[] = [];\n for (let i = min; i <= max; i++) {\n if (!used.has(i)) available.push(i);\n }\n\n // All numbers exhausted — reset and pick freely\n if (available.length === 0) {\n return Math.floor(Math.random() * (max - min + 1)) + min;\n }\n\n return available[Math.floor(Math.random() * available.length)];\n}\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 // Pick a winning number that avoids repeating any previous draw for this giveaway\n const min = Number(giveaway.number_min) || 1;\n const max = Number(giveaway.number_max) || 1000;\n const winningNumber = await pickUniqueWinningNumber(id, min, max);\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) — always fires\n const webhookUrl = Deno.env.get(\"GIVEAWAY_DISCORD_WEBHOOK\");\n if (webhookUrl) {\n try {\n const WINNER_ROLE_ID = \"1462179730923982941\";\n const winnerValue = winnerIds.length > 0\n ? winnerIds.map((id) => `<@${id}>`).join(\", \")\n : \"No match found for this number.\";\n const embed = {\n title: `🎉 Winner: ${giveawayName}`,\n fields: [\n { name: \"🔢 Winning Number\", value: String(winningNumber), inline: true },\n { name: \"🏆 Winner(s)\", value: winnerValue, inline: false },\n { name: \"🎁 Prize\", value: \"Auto-drawn winner\", inline: false },\n { name: \"📊 Total Entries\", value: String(entriesResult.rows.length), inline: true },\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 winning number that avoids repeating any previous draw for this giveaway\n const sWinning = await pickUniqueWinningNumber(sid, sMin, sMax);\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) — always fires\n const sWebhookUrl = Deno.env.get(\"GIVEAWAY_DISCORD_WEBHOOK\");\n if (sWebhookUrl) {\n try {\n const WINNER_ROLE_ID = \"1462179730923982941\";\n const sWinnerValue = sWinnerIds.length > 0\n ? sWinnerIds.map((id) => `<@${id}>`).join(\", \")\n : \"No match found for this number.\";\n // Build combined entry list for the announcement\n const sEntryLines = sEntriesResult.rows.map((row: Record) => {\n const nums = JSON.parse(row.numbers as string) as number[];\n const pid = row.participant_id as string;\n const isNumeric = /^\\d{17,19}$/.test(pid);\n const mention = isNumeric ? `<@${pid}>` : pid;\n return `${mention} — ${nums.join(\", \")}`;\n });\n const sEntryList = sEntryLines.length > 0\n ? sEntryLines.join(\"\\n\").slice(0, 1024)\n : \"No entries.\";\n const embed = {\n title: `🎉 Winner: ${sName}`,\n fields: [\n { name: \"🔢 Winning Number\", value: String(sWinning), inline: true },\n { name: \"🏆 Winner(s)\", value: sWinnerValue, inline: false },\n { name: \"🎁 Prize\", value: \"Scheduled auto-draw winner\", inline: false },\n { name: \"📊 Total Entries\", value: String(sEntriesResult.rows.length), inline: true },\n { name: \"📋 All Entries\", value: sEntryList, inline: false },\n { name: \"🔗 Enter Here\", value: \"https://ddrp-giveaways.val.run\" },\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",[167],"pulls",0,"forks","envVars",{"_180":182,"_183":174},"connections",{"_180":174,"_181":174},"count","unfilledCount",5,"emptyCount",{"_20":166,"_13":167,"_134":168,"_135":-5,"_136":21,"_137":30,"_139":52,"_22":198,"_29":170,"_142":163,"_144":171,"_146":40,"_147":-5,"_189":199,"_97":200},{"_20":158,"_13":159,"_134":160,"_135":-5,"_136":21,"_137":161,"_139":52,"_22":195,"_29":56,"_142":163,"_144":164,"_146":40,"_147":-5,"_189":196,"_97":197},{"_20":150,"_13":151,"_134":152,"_135":-5,"_136":21,"_137":153,"_139":52,"_22":192,"_29":155,"_142":109,"_144":156,"_146":40,"_147":-5,"_189":193,"_97":194},{"_20":132,"_13":133,"_134":50,"_135":-5,"_136":21,"_137":138,"_139":52,"_22":188,"_29":141,"_142":143,"_144":145,"_146":40,"_147":148,"_189":190,"_97":191},["D",1785794223067],"children",[],[133],["D",1785788399400],[],[151],["D",1785777368889],[],[159],["D",1785794242288],[],[167],["D",1785715480085],["D",1789648255466],{"_11":12,"_95":91},{"_11":12,"_88":89,"_90":91,"_47":48,"_92":93,"_94":40},{"_29":30,"_13":26,"_20":21,"_27":28,"_31":32,"_33":34,"_82":42,"_83":84,"_85":58,"_86":14,"_87":12},"ctx",{"_75":-5,"_119":239,"_240":241,"_242":243,"_244":40,"_245":40,"_246":40,"_247":52,"_248":-5,"_249":-7,"_250":-7,"_251":174,"_252":40,"_253":40,"_254":-5,"_255":40,"_256":40,"_257":40,"_258":-5},"ENV",{"_210":211,"_212":213,"_214":26,"_215":216,"_217":218,"_219":220,"_221":222,"_223":224,"_225":226,"_227":228,"_229":230,"_231":232,"_233":234,"_235":236,"_237":238},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","a3e067d4463eea85f6334f8e583e8516ae58c4f6","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

Branches1

Branches
1