[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_109":110,"_111":112},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","eixixddizca","name","discord-shop-bot","path","lib/community.ts","project",{"_22":48,"_11":12,"_35":49,"_50":-5,"_51":44,"_52":53,"_54":53,"_55":56,"_57":-5,"_58":59,"_60":61,"_62":34,"_63":-5,"_64":-5,"_65":66,"_67":68,"_69":70,"_71":72,"_73":74,"_75":-5,"_76":77,"_78":77,"_79":80,"_81":80,"_82":80,"_83":77,"_84":77,"_85":86,"_87":88,"_89":90,"_91":44},"file",{"_22":23,"_11":24,"_25":26,"_27":28,"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":-5,"_13":46},"permalink","https://www.val.town/x/eixixddizca/discord-shop-bot/code/lib/community.ts","extension","id","346d1d51-281a-4246-8044-d4927cb4bc45","community.ts","fileId","1cc0851c-a232-11f1-8072-1607ee4eb77e","parentId","0c5122a9-bcd5-498b-89dd-adb72a9f617b","branchId","dfaf1e7a-f8eb-4419-ac1e-aa00e1193983","branchVersion",52,"latest",true,"createdAt",["D",1787918323438],"version",5,"fileType","script","content","// Ticket + Suggestion + Poll systems.\n// Tickets: open/close with persistent lifecycle updating the customer profile.\n// Suggestions: upvote/downvote with persistent votes.\n// Polls: vote on options with persistent single-vote-per-user.\n\nimport { reply, replyEmbed, UI } from \"./embeds.ts\";\nimport type { CmdCtx } from \"./shop.ts\";\nimport { generateCode } from \"./db.ts\";\n\nconst DISCORD_API = \"https://discord.com/api/v10\";\n\n// ---------- TICKETS ----------\n// The 4 ticket categories in the dropdown, with your server's custom emojis.\nconst TICKET_OPTIONS = [\n { value: \"general_support\", label: \"General Support\", animated: true, name: \"Support\", id: \"1542859626897473666\",\n description: \"General questions, bugs, or you're not sure where to go.\" },\n { value: \"report_user\", label: \"Report A User\", animated: true, name: \"report\", id: \"1495855121559715922\",\n description: \"Report scamming or rule-breaking with proof.\" },\n { value: \"trader_application\", label: \"Trader Application\", animated: true, name: \"apps\", id: \"1526953458081464453\",\n description: \"Apply to join our trusted trading team.\" },\n { value: \"moderator_application\", label: \"Moderator Application\", animated: true, name: \"518379moderator\", id: \"1505913617017733262\",\n description: \"Become a member of our Support Team.\" },\n];\n\n// Render a custom emoji as a mention (or fall back to a unicode emoji).\nfunction emojiMention(o: { animated?: boolean; name: string; id?: string }, fallback: string): string {\n return o.id ? `${o.animated ? \"` : fallback;\n}\n\nexport async function ticket(ctx: CmdCtx, sub: string): Promise> {\n switch (sub) {\n case \"panel\": {\n // Posts a persistent panel with a category dropdown.\n const fields = TICKET_OPTIONS.map((o) => {\n return { name: `${emojiMention(o, o.name)} ${o.label}`, value: o.description, inline: false };\n });\n return {\n type: 4,\n data: {\n flags: 0,\n embeds: [UI.info({\n title: \"🎫 Wavez Tickets\",\n description: \"Select an option below to open a ticket. Please choose the category that best matches your request so our team can assist you as quickly as possible.\",\n fields,\n })],\n components: [\n {\n type: 1,\n components: [\n {\n type: 3,\n custom_id: \"ticket:category\",\n placeholder: \"Select a category…\",\n min_values: 1,\n max_values: 1,\n options: TICKET_OPTIONS.map((o) => ({\n value: o.value,\n label: o.label,\n description: o.description,\n emoji: { name: o.name, id: o.id },\n })),\n },\n ],\n },\n ],\n },\n };\n }\n case \"new\": {\n const res = await createTicket(ctx.userId, ctx.username, String(ctx.options[\"category\"] ?? \"support\"), String(ctx.options[\"subject\"] ?? \"No subject\"));\n return res.ok\n ? replyEmbed(UI.success({ title: \"🎫 Ticket Opened\", description: `**${res.ticketId}**`, fields: [{ name: \"Subject\", value: res.subject ?? \"\", inline: false }] }))\n : reply(res.msg);\n }\n case \"close\": {\n const { sqlite } = await import(\"https://esm.town/v/std/sqlite/main.ts\");\n const id = String(ctx.options[\"ticket\"] ?? \"\").toUpperCase();\n const t = id\n ? (await sqlite.execute({ sql: \"SELECT * FROM tickets WHERE ticketId = ?\", args: [id] })).rows[0]\n : (await sqlite.execute({ sql: \"SELECT * FROM tickets WHERE userId = ? AND status='open'\", args: [ctx.userId] })).rows[0];\n if (!t) return reply(\"No such open ticket.\");\n if (t.userId !== ctx.userId && !ctx.isStaff && !ctx.isOwner) return reply(\"You can only close your own ticket.\");\n const now = new Date().toISOString();\n await sqlite.execute({\n sql: \"UPDATE tickets SET status='closed', closedBy=?, closedAt=? WHERE ticketId=?\",\n args: [ctx.userId, now, t.ticketId],\n });\n await sqlite.execute({ sql: \"UPDATE customers SET ticketsCompleted = ticketsCompleted + 1 WHERE userId = ?\", args: [t.userId] });\n return reply(`✅ Ticket **${t.ticketId}** closed.`);\n }\n default:\n return reply(\"Unknown ticket command.\");\n }\n}\n\n// ---------- SUGGESTIONS ----------\nexport async function suggest(ctx: CmdCtx, sub: string): Promise> {\n const { sqlite } = await import(\"https://esm.town/v/std/sqlite/main.ts\");\n switch (sub) {\n case \"submit\": {\n const text = String(ctx.options[\"text\"] ?? \"\");\n if (!text) return reply(\"Provide a suggestion.\");\n const suggestionId = \"S-\" + generateCode(6);\n await sqlite.execute({\n sql: `INSERT INTO suggestions (suggestionId, userId, username, text, status, upvotes, downvotes, voters, createdAt)\n VALUES (?, ?, ?, ?, 'pending', 0, 0, '[]', ?)`,\n args: [suggestionId, ctx.userId, ctx.username, text, new Date().toISOString()],\n });\n return replyEmbed(UI.info({\n title: \"💡 Suggestion Submitted\",\n description: `**${suggestionId}**`,\n fields: [{ name: \"Suggestion\", value: text, inline: false }],\n }));\n }\n case \"vote\": {\n const id = String(ctx.options[\"suggestion\"] ?? \"\").toUpperCase();\n const dir = String(ctx.options[\"direction\"] ?? \"up\");\n const row = (await sqlite.execute({ sql: \"SELECT * FROM suggestions WHERE suggestionId = ?\", args: [id] })).rows[0] as any;\n if (!row) return reply(\"No such suggestion.\");\n const voters = JSON.parse((row.voters as string) || \"[]\");\n if (voters.includes(ctx.userId)) return reply(\"You already voted on this suggestion.\");\n voters.push(ctx.userId);\n const up = dir === \"up\" ? Number(row.upvotes) + 1 : Number(row.upvotes);\n const down = dir === \"down\" ? Number(row.downvotes) + 1 : Number(row.downvotes);\n await sqlite.execute({\n sql: \"UPDATE suggestions SET upvotes=?, downvotes=?, voters=? WHERE suggestionId=?\",\n args: [up, down, JSON.stringify(voters), id],\n });\n const score = up - down;\n const status = score >= 5 ? \"approved\" : score <= -3 ? \"rejected\" : \"pending\";\n await sqlite.execute({ sql: \"UPDATE suggestions SET status=? WHERE suggestionId=?\", args: [status, id] });\n return reply(`✅ Voted **${dir}** on ${id}. Score now ${score}`);\n }\n default:\n return reply(\"Unknown suggestion command.\");\n }\n}\n\n// ---------- POLLS ----------\nexport async function poll(ctx: CmdCtx, sub: string): Promise> {\n const { sqlite } = await import(\"https://esm.town/v/std/sqlite/main.ts\");\n switch (sub) {\n case \"create\": {\n const question = String(ctx.options[\"question\"] ?? \"\");\n const optList = String(ctx.options[\"options\"] ?? \"\").split(\",\").map((s) => s.trim()).filter(Boolean).slice(0, 10);\n if (!question || optList.length < 2) return reply(\"Provide a question and at least 2 comma-separated options.\");\n const pollId = \"POLL-\" + generateCode(5);\n const labels = optList.map((_, i) => String.fromCharCode(65 + i));\n const votes: Record = {};\n labels.forEach((l) => (votes[l] = []));\n await sqlite.execute({\n sql: \"INSERT INTO polls (pollId, question, options, votes, userId, createdAt) VALUES (?, ?, ?, ?, ?, ?)\",\n args: [pollId, question, JSON.stringify(optList), JSON.stringify(votes), ctx.userId, new Date().toISOString()],\n });\n const pretty = optList.map((o, i) => `**${labels[i]}** · ${o}`).join(\"\\n\");\n return replyEmbed(UI.info({\n title: \"📊 Poll · \" + pollId,\n description: question,\n fields: [{ name: \"Options\", value: pretty, inline: false }, { name: \"Vote\", value: \"/poll vote \", inline: false }],\n }));\n }\n case \"vote\": {\n const id = String(ctx.options[\"poll\"] ?? \"\").toUpperCase();\n const letter = String(ctx.options[\"option\"] ?? \"\").toUpperCase();\n const row = (await sqlite.execute({ sql: \"SELECT * FROM polls WHERE pollId = ?\", args: [id] })).rows[0] as any;\n if (!row) return reply(\"No such poll.\");\n const votes = JSON.parse(row.votes as string) as Record;\n if (letter && !votes[letter]) return reply(\"Invalid option letter.\");\n for (const l of Object.keys(votes)) {\n if (votes[l].includes(ctx.userId)) return reply(\"You already voted on this poll.\");\n }\n votes[letter].push(ctx.userId);\n await sqlite.execute({ sql: \"UPDATE polls SET votes=? WHERE pollId=?\", args: [JSON.stringify(votes), id] });\n const counts = Object.entries(votes).map(([l, arr]) => `**${l}** — ${arr.length}`).join(\"\\n\");\n return replyEmbed(UI.info({ title: `📊 Poll ${id}`, description: String(row.question), fields: [{ name: \"Results\", value: counts, inline: false }] }));\n }\n default:\n return reply(\"Unknown poll command.\");\n }\n}\n// Shared ticket creation (used by /ticket new and the panel button/modal).\nexport async function createTicket(userId: string, username: string, category: string, subject: string): Promise<{ ok: boolean; msg: string; ticketId?: string; subject?: string }> {\n const { sqlite } = await import(\"https://esm.town/v/std/sqlite/main.ts\");\n const existing = await sqlite.execute({\n sql: \"SELECT * FROM tickets WHERE userId = ? AND status NOT IN ('closed','resolved')\",\n args: [userId],\n });\n if (existing.rows.length) return { ok: false, msg: \"You already have an open ticket.\" };\n const ticketId = \"T-\" + generateCode(6);\n const now = new Date().toISOString();\n await sqlite.execute({\n sql: `INSERT INTO tickets (ticketId, userId, username, category, subject, channelId, staffId, status, priority, openedAt)\n VALUES (?, ?, ?, ?, ?, '', NULL, 'open', 'normal', ?)`,\n args: [ticketId, userId, username, category, subject, now],\n });\n await sqlite.execute({ sql: \"UPDATE customers SET ticketsOpened = ticketsOpened + 1 WHERE userId = ?\", args: [userId] });\n return { ok: true, msg: \"Ticket opened\", ticketId, subject };\n}\n","deleted",false,"label",[47,24],"lib","438fe6a4-2424-4e5d-9feb-81f46ecbe799",["D",1787846270953],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Modular Discord shop & community bot","imageUrl","userId","6b376f3a-5347-4c3a-b4ec-787b333560af","pinnedFileId","27082d74-a230-11f1-8efc-1607ee4eb77e","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","01a043e6-75ad-74fe-b7a7-17e3786f5114","tursoName","438fe6a424244e5d9feb81f46ecbe799","tursoHostname","438fe6a424244e5d9feb81f46ecbe799-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789497078049],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_9":10,"_108":103},"org",{"_9":10,"_102":103,"_104":103,"_58":59,"_105":106,"_107":44},"branch",{"_37":92,"_11":93,"_22":30,"_94":48,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":12,"_101":10},"isOwned",61,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","","avatar","tier","free","canRestrictVals","profileImageUrl","ctx",{"_85":-5,"_142":143,"_144":145,"_146":147,"_148":44,"_149":44,"_150":44,"_151":34,"_152":-5,"_153":-7,"_154":-7,"_155":66,"_156":44,"_157":44,"_158":-5,"_159":44,"_160":44,"_161":44,"_162":-5},"ENV",{"_113":114,"_115":116,"_117":93,"_118":119,"_120":121,"_122":123,"_124":125,"_126":127,"_128":129,"_130":131,"_132":133,"_134":135,"_136":137,"_138":139,"_140":141},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","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","orgs",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]