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",[103],"6814ad74ef81dc568bda396cae7de65d5167a5267f845aca08e503233727e853","c4f57647-5d5d-4ce5-91a0-9f2847b19b15","05a40fc0-8ecd-11f1-a32e-1607ee4eb77e",9,["D",1785714889783],2,"\n\n\n \n \n Deadly Desire RP — Reviews\n \n \n \n \n\n\n

\n \n

❦

\n\n \n\n

\n \n

\n\n \n\n\n",[103],"9dba4c616799e42a277d10290ee04ccf94d35918e121b4dd7942015f19d5608a",{"_70":136,"_72":-7,"_74":137},{"_70":125,"_72":-7,"_74":126},"discord-update.ts",{"_32":127,"_13":125,"_77":128,"_79":-5,"_80":57,"_81":129,"_82":26,"_34":130,"_40":131,"_85":132,"_87":133,"_64":48,"_89":-5,"_91":-7,"_70":134,"_93":135},"47f6d875-e973-4b6e-a721-1eae00f6e899","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",[125],"ff59b766ffe7e5c69d1e6f34cb0a5915356529554c2cdf3c96a261edfa7719f5","auto-draw.ts",{"_32":138,"_13":136,"_77":139,"_79":-5,"_80":57,"_81":56,"_82":26,"_34":140,"_40":141,"_85":132,"_87":142,"_64":48,"_89":-5,"_91":-7,"_70":143,"_93":144},"b6e2af02-f496-4f46-820e-80de22138ed7","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",[136],"182f40d97ec3aa1d479bffe8689a0f89a7ebd0e0c3efec5674553f3ac36a22f3",["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,"_186":182},"org",{"_11":12,"_179":180,"_181":182,"_151":152,"_183":184,"_185":48},"branch","displayName","Chevelle Ezell","avatar","https://lh3.googleusercontent.com/a/ACg8ocJD2GClHcBju4Xwk2TYAuiheZvOXV2UmcqQ4cPAYsoXDR0zeg=s96-c","tier","free","canRestrictVals","profileImageUrl","","adoptOrgId",{"_32":58,"_13":14,"_34":249,"_46":-5,"_146":48,"_49":50,"_147":50,"_148":149,"_150":-5,"_151":152,"_153":78,"_154":26,"_155":-5,"_156":-5,"_157":131,"_52":53,"_158":159,"_160":161,"_162":250,"_164":-5,"_165":166,"_167":166,"_168":169,"_170":169,"_171":169,"_172":166,"_173":166,"_174":251,"_176":252,"_178":253,"_47":48},"tree",[237,238,239,240],"files",[237,238,239,240],"counts",{"_226":22,"_227":131,"_228":22,"_229":230,"_231":232},"contents",[214,215,216,217],"upstreamProject",{"_32":39,"_13":55,"_148":212,"_150":-5,"_49":50,"_174":213},"upstreamBranch",{"_32":33,"_34":210,"_36":211,"_13":16,"_38":39,"_40":41,"_42":-5,"_43":-5,"_44":45,"_46":-5,"_47":48,"_49":50,"_51":12,"_52":53,"_54":55},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1785713332787],["D",1785715285109],"Private webhook relay for storing incoming POSTs",{"_11":12,"_186":182},{"_32":138,"_13":136,"_77":139,"_79":-5,"_80":57,"_81":56,"_82":26,"_34":224,"_40":141,"_85":132,"_87":142,"_64":48,"_89":-5,"_70":225},{"_32":127,"_13":125,"_77":128,"_79":-5,"_80":57,"_81":129,"_82":26,"_34":222,"_40":131,"_85":132,"_87":133,"_64":48,"_89":-5,"_70":223},{"_32":106,"_13":103,"_77":107,"_79":-5,"_80":57,"_81":108,"_82":26,"_34":220,"_40":110,"_85":111,"_87":112,"_64":48,"_89":-5,"_70":221},{"_32":76,"_13":71,"_77":78,"_79":-5,"_80":57,"_81":20,"_82":26,"_34":218,"_40":84,"_85":86,"_87":88,"_64":48,"_89":90,"_70":219},["D",1785794223067],[71],["D",1785788399400],[103],["D",1785777368889],[125],["D",1785794242288],[136],"pulls","branches","forks","envVars",{"_233":235,"_236":22},"connections",{"_233":22,"_234":22},"count","unfilledCount",5,"emptyCount",{"_32":138,"_13":136,"_77":139,"_79":-5,"_80":57,"_81":56,"_82":26,"_34":140,"_40":141,"_85":132,"_87":142,"_64":48,"_89":-5,"_91":247,"_70":248},{"_32":127,"_13":125,"_77":128,"_79":-5,"_80":57,"_81":129,"_82":26,"_34":130,"_40":131,"_85":132,"_87":133,"_64":48,"_89":-5,"_91":245,"_70":246},{"_32":106,"_13":103,"_77":107,"_79":-5,"_80":57,"_81":108,"_82":26,"_34":109,"_40":110,"_85":111,"_87":112,"_64":48,"_89":-5,"_91":243,"_70":244},{"_32":76,"_13":71,"_77":78,"_79":-5,"_80":57,"_81":20,"_82":26,"_34":83,"_40":84,"_85":86,"_87":88,"_64":48,"_89":90,"_91":241,"_70":242},[],[71],[],[103],[],[125],[],[136],["D",1785715480085],["D",1789648255466],{"_11":12,"_186":182},{"_11":12,"_179":180,"_181":182,"_151":152,"_183":184,"_185":48},{"_40":56,"_13":16,"_32":57,"_38":58,"_42":33,"_43":41,"_59":50,"_60":39,"_61":53,"_54":14,"_51":12},"ctx",{"_174":-5,"_207":287,"_288":289,"_290":291,"_292":48,"_293":48,"_294":48,"_295":26,"_296":-5,"_297":-7,"_298":-7,"_299":22,"_300":48,"_301":48,"_302":-5,"_303":48,"_304":48,"_305":48,"_306":-5},"ENV",{"_258":259,"_260":261,"_262":16,"_263":264,"_265":266,"_267":268,"_269":270,"_271":272,"_273":274,"_275":276,"_277":278,"_279":280,"_281":282,"_283":284,"_285":286},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e8c4b7030cb7600e4eb0736b15f422c8b8bd130f","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

Deadly Desire RP

Compare

MergeDDRP-Giveaways/mainintowebhook-relay/main

index.html+1274-347

Hmain.ts+1057-66

Cauto-draw.ts+283-0

Cdiscord-update.ts+80-0