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",[83],"47f6d875-e973-4b6e-a721-1eae00f6e899","discord-update.ts","aa1dd9c8-8f5e-11f1-b2a5-1607ee4eb77e",46,["D",1785777368889],1,"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",[91],"b6e2af02-f496-4f46-820e-80de22138ed7","auto-draw.ts","3e2802f2-8f59-11f1-be0c-1607ee4eb77e",161,["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",[100],{"_35":99,"_13":100,"_64":101,"_66":-5,"_67":68,"_69":102,"_70":71,"_37":121,"_17":104,"_74":96,"_76":105,"_78":50,"_79":-5,"_112":122,"_18":123},{"_35":90,"_13":91,"_64":92,"_66":-5,"_67":68,"_69":93,"_70":71,"_37":118,"_17":95,"_74":96,"_76":97,"_78":50,"_79":-5,"_112":119,"_18":120},{"_35":82,"_13":83,"_64":84,"_66":-5,"_67":68,"_69":85,"_70":71,"_37":115,"_17":87,"_74":24,"_76":88,"_78":50,"_79":-5,"_112":116,"_18":117},{"_35":62,"_13":63,"_64":65,"_66":-5,"_67":68,"_69":31,"_70":71,"_37":111,"_17":73,"_74":75,"_76":77,"_78":50,"_79":80,"_112":113,"_18":114},["D",1785794223067],"children",[],[63],["D",1785788399400],[],[83],["D",1785777368889],[],[91],["D",1785794242288],[],[100],"216614e6-7881-4097-8292-87a412f1487d",["D",1785715480085],"legacyEnvVars","httpPrivacy","description","Giveaway system with owner dashboard, entries & private notes","imageUrl","userId","12cf16a3-2a6a-421b-b356-b38cc8b42700","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","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",{"_11":12,"_170":166},"org",{"_11":12,"_163":164,"_165":166,"_131":132,"_167":168,"_169":50},"branch",{"_17":102,"_13":16,"_35":68,"_41":124,"_44":36,"_45":43,"_160":52,"_161":42,"_162":55,"_56":14,"_53":12},"forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","displayName","Chevelle Ezell","avatar","https://lh3.googleusercontent.com/a/ACg8ocJD2GClHcBju4Xwk2TYAuiheZvOXV2UmcqQ4cPAYsoXDR0zeg=s96-c","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_35":124,"_13":14,"_37":225,"_48":-5,"_126":50,"_51":52,"_127":52,"_128":129,"_130":-5,"_131":132,"_133":65,"_134":71,"_135":-5,"_136":-5,"_137":95,"_54":55,"_138":139,"_140":141,"_142":226,"_144":-5,"_145":146,"_147":146,"_148":149,"_150":149,"_151":149,"_152":146,"_153":146,"_154":227,"_156":228,"_158":229,"_49":50},[213,214,215,216],"files",[213,214,215,216],"counts",{"_203":33,"_204":95,"_205":33,"_34":206,"_207":208},[195,196,197,198],"upstreamProject",{"_35":42,"_13":57,"_128":193,"_130":-5,"_51":52,"_154":194},"upstreamBranch",{"_35":36,"_37":191,"_39":192,"_13":16,"_41":42,"_17":43,"_44":-5,"_45":-5,"_46":47,"_48":-5,"_49":50,"_51":52,"_53":12,"_54":55,"_56":57},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1785713332787],["D",1785715285109],"Private webhook relay for storing incoming POSTs",{"_11":12,"_170":166},{"_35":99,"_13":100,"_64":101,"_66":-5,"_67":68,"_69":102,"_70":71,"_37":103,"_17":104,"_74":96,"_76":105,"_78":50,"_79":-5,"_18":202},{"_35":90,"_13":91,"_64":92,"_66":-5,"_67":68,"_69":93,"_70":71,"_37":94,"_17":95,"_74":96,"_76":97,"_78":50,"_79":-5,"_18":201},{"_35":82,"_13":83,"_64":84,"_66":-5,"_67":68,"_69":85,"_70":71,"_37":86,"_17":87,"_74":24,"_76":88,"_78":50,"_79":-5,"_18":200},{"_35":62,"_13":63,"_64":65,"_66":-5,"_67":68,"_69":31,"_70":71,"_37":72,"_17":73,"_74":75,"_76":77,"_78":50,"_79":80,"_18":199},[63],[83],[91],[100],"pulls","branches","forks",{"_209":211,"_212":33},"connections",{"_209":33,"_210":33},"count","unfilledCount",5,"emptyCount",{"_35":99,"_13":100,"_64":101,"_66":-5,"_67":68,"_69":102,"_70":71,"_37":121,"_17":104,"_74":96,"_76":105,"_78":50,"_79":-5,"_112":223,"_18":224},{"_35":90,"_13":91,"_64":92,"_66":-5,"_67":68,"_69":93,"_70":71,"_37":118,"_17":95,"_74":96,"_76":97,"_78":50,"_79":-5,"_112":221,"_18":222},{"_35":82,"_13":83,"_64":84,"_66":-5,"_67":68,"_69":85,"_70":71,"_37":115,"_17":87,"_74":24,"_76":88,"_78":50,"_79":-5,"_112":219,"_18":220},{"_35":62,"_13":63,"_64":65,"_66":-5,"_67":68,"_69":31,"_70":71,"_37":111,"_17":73,"_74":75,"_76":77,"_78":50,"_79":80,"_112":217,"_18":218},[],[63],[],[83],[],[91],[],[100],["D",1785715480085],["D",1789648255466],{"_11":12,"_170":166},{"_11":12,"_163":164,"_165":166,"_131":132,"_167":168,"_169":50},{"_17":102,"_13":16,"_35":68,"_41":124,"_44":36,"_45":43,"_160":52,"_161":42,"_162":55,"_56":14,"_53":12},"ctx",{"_154":-5,"_188":263,"_264":265,"_266":267,"_268":50,"_269":50,"_270":50,"_271":71,"_272":-5,"_273":-7,"_274":-7,"_275":33,"_276":50,"_277":50,"_278":-5,"_279":50,"_280":50,"_281":50,"_282":-5},"ENV",{"_234":235,"_236":237,"_238":16,"_239":240,"_241":242,"_243":244,"_245":246,"_247":248,"_249":250,"_251":252,"_253":254,"_255":256,"_257":258,"_259":260,"_261":262},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","d010005ccf3ba21435d5d6fb7028afb409c58b2e","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

Code