Discord DM Analyzer

\n \n \n \n",[],[152,187,202],{"_108":211,"_100":212,"_153":213,"_155":188,"_156":140,"_157":214,"_159":121,"_110":215,"_104":31,"_161":180,"_163":216,"_164":27,"_165":-5,"_166":217,"_103":218},"7cb7fd86-2710-11f0-a1a2-569c3dd06744","index.tsx","7cb7fe1c-2710-11f0-a1a2-569c3dd06744",9,["D",1746161221382],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client?deps=react@18.2.0\";\nimport { App } from \"./components/App.tsx\";\n\n// Get root element\nconst root = document.getElementById(\"root\");\nif (!root) {\n throw new Error(\"Root element not found in document\");\n}\n\n// Render the App\ncreateRoot(root).render();",[],[152,187,212],[152,187],{"_108":221,"_100":222,"_153":223,"_155":154,"_156":140,"_157":224,"_159":121,"_110":225,"_104":31,"_161":162,"_163":-5,"_164":27,"_165":-5,"_166":226,"_103":227},"7c75e126-2710-11f0-8393-569c3dd06744","shared","7c75e1b2-2710-11f0-8393-569c3dd06744",4,["D",1746161220949],[],[152,222],[152],{"_108":230,"_100":231,"_153":232,"_155":-5,"_156":140,"_157":233,"_159":121,"_110":234,"_104":31,"_161":206,"_163":235,"_164":27,"_165":-5,"_166":236,"_103":237},"7cb3e872-2710-11f0-bc07-569c3dd06744","DISCORD_BOT_SETUP.md","7cb3e930-2710-11f0-bc07-569c3dd06744",8,["D",1746161221312],"# Step-by-Step Discord Bot Setup Guide\n\nThis guide will walk you through creating a Discord bot and setting it up to work with the Discord DM Analyzer.\n\n## 1. Create a Discord Application\n\n1. Go to the [Discord Developer Portal](https://discord.com/developers/applications)\n2. Click the \"New Application\" button in the top-right corner\n3. Enter a name for your application (e.g., \"DM Analyzer\")\n4. Accept the terms and click \"Create\"\n\n## 2. Set Up the Bot\n\n1. In the left sidebar, click on \"Bot\"\n2. Click the \"Add Bot\" button on the right\n3. Confirm by clicking \"Yes, do it!\"\n4. Under the bot's username, you'll see a \"Reset Token\" button\n5. Click \"Reset Token\" and confirm\n6. Copy the token that appears - this is your `DISCORD_TOKEN`\n7. Under \"Privileged Gateway Intents\", enable:\n - MESSAGE CONTENT INTENT\n - SERVER MEMBERS INTENT\n8. Scroll down and click \"Save Changes\"\n\n## 3. Get Your Application ID\n\n1. In the left sidebar, click on \"General Information\"\n2. Under \"Application ID\", click the \"Copy\" button\n3. This is your `DISCORD_CLIENT_ID`\n\n## 4. Get Your User ID\n\n1. Open Discord\n2. Go to User Settings (gear icon next to your name)\n3. Select \"Advanced\" in the left sidebar\n4. Enable \"Developer Mode\"\n5. Close User Settings\n6. Right-click on your username anywhere in Discord\n7. Select \"Copy ID\"\n8. This is your `DISCORD_USER_ID`\n\n## 5. Get Your Spouse's User ID\n\n1. Right-click on your spouse's username in Discord\n2. Select \"Copy ID\"\n3. This is your `SPOUSE_USER_ID`\n\n## 6. Update Environment Variables\n\n1. In your project directory, create a `.env` file if you haven't already\n2. Add the following variables:\n ```\n DISCORD_TOKEN=your_discord_token_here\n DISCORD_CLIENT_ID=your_client_id_here\n DISCORD_USER_ID=your_user_id_here\n SPOUSE_USER_ID=spouse_user_id_here\n ```\n\n## 7. Get OpenAI API Key\n\n1. Go to [OpenAI's website](https://platform.openai.com/)\n2. Sign up or log in\n3. Navigate to the API keys section\n4. Create a new API key\n5. Copy the key\n6. Add it to your `.env` file:\n ```\n OPENAI_API_KEY=your_openai_api_key_here\n ```\n\n## 8. Register Bot Commands\n\n1. In your project directory, run:\n ```\n node discord-commands.js\n ```\n2. You should see \"Successfully registered application commands.\"\n\n## 9. Invite the Bot to Your Server\n\n1. In the Discord Developer Portal, click on \"OAuth2\" in the left sidebar\n2. Click on \"URL Generator\"\n3. Under \"Scopes\", select:\n - bot\n - applications.commands\n4. Under \"Bot Permissions\", select:\n - Read Messages/View Channels\n - Send Messages\n - Read Message History\n5. Copy the generated URL at the bottom\n6. Paste the URL in your browser\n7. Select a server where you want to add the bot\n8. Click \"Authorize\"\n9. Complete the CAPTCHA if prompted\n\n## 10. Deploy to Val.town (Optional)\n\n1. Install the Val.town CLI:\n ```\n npm install -g val-town-cli\n ```\n2. Authenticate with Val.town:\n ```\n vt login\n ```\n3. Deploy the application:\n ```\n node val-town-deploy.js\n ```\n4. Set up environment variables in Val.town:\n - Go to the Val.town dashboard\n - Find your deployed functions\n - Add the same environment variables from your `.env` file\n5. Set up a scheduled task for periodic DM fetching:\n - Create a new scheduled task in Val.town\n - Use the `discordDMBotCron` function\n - Choose a schedule (e.g., every 6 hours)\n\n## 11. Test Your Bot\n\n1. Start the local server:\n ```\n node index.js\n ```\n2. In Discord, use one of the slash commands:\n - `/search What did we say about the IKEA table?`\n - `/links sofa`\n - `/categories`\n - `/analyze Summarize our furniture discussions`\n\n3. You can also manually trigger a DM fetch:\n ```\n node val-town-cron.js\n ```\n\n## Troubleshooting\n\n### Bot not responding to commands\n- Make sure the bot is running (`node index.js`)\n- Check if commands were registered successfully\n- Verify that the bot has proper permissions\n\n### Cannot fetch DMs\n- Ensure both you and your spouse have DMed each other at least once\n- Verify that all tokens and IDs in the `.env` file are correct\n- Check Discord developer portal for any token or permission issues\n\n### Val.town deployment issues\n- Make sure you're logged in to Val.town CLI\n- Check for any errors in the deployment logs\n- Verify that environment variables are set correctly in Val.town\n\n## Next Steps\n\n1. Customize the bot's responses by editing the API endpoints in `api-server.js`\n2. Add more categories for link classification in `database.js`\n3. Enhance the AI queries by modifying prompts in `query-service.js`\n4. Create a web interface that connects to your API endpoints",[],[231],{"_108":239,"_100":240,"_153":241,"_155":-5,"_156":140,"_157":242,"_159":121,"_110":243,"_104":31,"_161":180,"_163":244,"_164":27,"_165":-5,"_166":245,"_103":246},"7cafebdc-2710-11f0-9826-569c3dd06744","database.js","7cafec68-2710-11f0-9826-569c3dd06744",7,["D",1746161221310],"import Database from 'better-sqlite3';\nimport linkify from 'linkify-it';\nimport 'dotenv/config';\n\n// For Val.town, we'll use the built-in SQLite functionality\n// In local dev, we'll use a file-based database\nconst DB_PATH = process.env.NODE_ENV === 'production' ? ':memory:' : './messages.db';\n\n// Initialize link parser\nconst linkParser = linkify();\n\n/**\n * Initialize the database schema\n */\nexport function initializeDatabase() {\n const db = new Database(DB_PATH);\n \n // Create messages table\n db.exec(`\n CREATE TABLE IF NOT EXISTS messages (\n id TEXT PRIMARY KEY,\n content TEXT,\n author_id TEXT,\n timestamp INTEGER,\n processed INTEGER DEFAULT 0\n )\n `);\n \n // Create attachments table\n db.exec(`\n CREATE TABLE IF NOT EXISTS attachments (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n message_id TEXT,\n url TEXT,\n FOREIGN KEY (message_id) REFERENCES messages(id)\n )\n `);\n \n // Create embeds table\n db.exec(`\n CREATE TABLE IF NOT EXISTS embeds (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n message_id TEXT,\n data TEXT,\n FOREIGN KEY (message_id) REFERENCES messages(id)\n )\n `);\n \n // Create links table\n db.exec(`\n CREATE TABLE IF NOT EXISTS links (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n message_id TEXT,\n url TEXT,\n category TEXT,\n title TEXT,\n description TEXT,\n FOREIGN KEY (message_id) REFERENCES messages(id)\n )\n `);\n \n // Create categories table for organizing links\n db.exec(`\n CREATE TABLE IF NOT EXISTS categories (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT UNIQUE,\n created_at INTEGER\n )\n `);\n \n // Create table for AI-based message summaries\n db.exec(`\n CREATE TABLE IF NOT EXISTS conversations (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n start_timestamp INTEGER,\n end_timestamp INTEGER,\n summary TEXT,\n topic TEXT\n )\n `);\n \n // Insert some default categories for furniture (per your example)\n const defaultCategories = [\n 'sofa', 'chair', 'table', 'bed', 'dresser', 'desk', \n 'lamp', 'shelf', 'bookcase', 'rug', 'curtain', 'other'\n ];\n \n const insertCategory = db.prepare('INSERT OR IGNORE INTO categories (name, created_at) VALUES (?, ?)');\n const now = Date.now();\n \n for (const category of defaultCategories) {\n insertCategory.run(category, now);\n }\n \n return db;\n}\n\n/**\n * Save messages to the database\n * @param {Array} messages - Array of message objects to save\n */\nexport async function saveDMMessages(messages) {\n const db = initializeDatabase();\n \n // Prepare statements\n const insertMessage = db.prepare(`\n INSERT OR IGNORE INTO messages (id, content, author_id, timestamp)\n VALUES (?, ?, ?, ?)\n `);\n \n const insertAttachment = db.prepare(`\n INSERT INTO attachments (message_id, url)\n VALUES (?, ?)\n `);\n \n const insertEmbed = db.prepare(`\n INSERT INTO embeds (message_id, data)\n VALUES (?, ?)\n `);\n \n const insertLink = db.prepare(`\n INSERT INTO links (message_id, url, category)\n VALUES (?, ?, ?)\n `);\n \n // Begin transaction\n const transaction = db.transaction((messages) => {\n for (const message of messages) {\n // Insert message\n insertMessage.run(\n message.id,\n message.content,\n message.authorId,\n message.timestamp\n );\n \n // Insert attachments\n if (message.attachments && message.attachments.length > 0) {\n for (const url of message.attachments) {\n insertAttachment.run(message.id, url);\n }\n }\n \n // Insert embeds\n if (message.embeds && message.embeds.length > 0) {\n for (const embed of message.embeds) {\n insertEmbed.run(message.id, embed);\n }\n }\n \n // Extract and insert links\n if (message.content) {\n const links = linkParser.match(message.content);\n if (links) {\n for (const link of links) {\n // Default to 'other' category, can be updated later\n insertLink.run(message.id, link.url, 'other');\n }\n }\n }\n }\n });\n \n // Execute transaction\n transaction(messages);\n \n console.log(`Saved ${messages.length} messages to database`);\n \n db.close();\n}\n\n/**\n * Get messages from the database, with optional filtering\n * @param {Object} filters - Optional filters for messages\n * @returns {Array} - Array of message objects\n */\nexport function getMessages(filters = {}) {\n const db = initializeDatabase();\n \n let query = `\n SELECT m.*, a.url as attachment_url\n FROM messages m\n LEFT JOIN attachments a ON m.id = a.message_id\n `;\n \n const queryParams = [];\n const whereClauses = [];\n \n // Apply filters\n if (filters.startDate) {\n whereClauses.push('m.timestamp >= ?');\n queryParams.push(new Date(filters.startDate).getTime());\n }\n \n if (filters.endDate) {\n whereClauses.push('m.timestamp <= ?');\n queryParams.push(new Date(filters.endDate).getTime());\n }\n \n if (filters.authorId) {\n whereClauses.push('m.author_id = ?');\n queryParams.push(filters.authorId);\n }\n \n if (filters.search) {\n whereClauses.push('m.content LIKE ?');\n queryParams.push(`%${filters.search}%`);\n }\n \n // Construct final query\n if (whereClauses.length > 0) {\n query += ' WHERE ' + whereClauses.join(' AND ');\n }\n \n query += ' ORDER BY m.timestamp DESC';\n \n // Add limit if specified\n if (filters.limit) {\n query += ' LIMIT ?';\n queryParams.push(filters.limit);\n }\n \n const results = db.prepare(query).all(...queryParams);\n \n db.close();\n \n return results;\n}\n\n/**\n * Get links from the database, with optional filtering\n * @param {Object} filters - Optional filters for links\n * @returns {Array} - Array of link objects\n */\nexport function getLinks(filters = {}) {\n const db = initializeDatabase();\n \n let query = `\n SELECT l.*, m.content, m.timestamp, m.author_id\n FROM links l\n JOIN messages m ON l.message_id = m.id\n `;\n \n const queryParams = [];\n const whereClauses = [];\n \n // Apply filters\n if (filters.category) {\n whereClauses.push('l.category = ?');\n queryParams.push(filters.category);\n }\n \n if (filters.url) {\n whereClauses.push('l.url LIKE ?');\n queryParams.push(`%${filters.url}%`);\n }\n \n if (filters.startDate) {\n whereClauses.push('m.timestamp >= ?');\n queryParams.push(new Date(filters.startDate).getTime());\n }\n \n if (filters.endDate) {\n whereClauses.push('m.timestamp <= ?');\n queryParams.push(new Date(filters.endDate).getTime());\n }\n \n // Construct final query\n if (whereClauses.length > 0) {\n query += ' WHERE ' + whereClauses.join(' AND ');\n }\n \n query += ' ORDER BY m.timestamp DESC';\n \n // Add limit if specified\n if (filters.limit) {\n query += ' LIMIT ?';\n queryParams.push(filters.limit);\n }\n \n const results = db.prepare(query).all(...queryParams);\n \n db.close();\n \n return results;\n}\n\n/**\n * Update link category\n * @param {number} linkId - ID of the link to update\n * @param {string} category - New category\n */\nexport function updateLinkCategory(linkId, category) {\n const db = initializeDatabase();\n \n db.prepare('UPDATE links SET category = ? WHERE id = ?').run(category, linkId);\n \n db.close();\n}\n\n/**\n * Get all available categories\n * @returns {Array} - Array of category objects\n */\nexport function getCategories() {\n const db = initializeDatabase();\n \n const categories = db.prepare('SELECT * FROM categories ORDER BY name').all();\n \n db.close();\n \n return categories;\n}\n\n/**\n * Add a new category\n * @param {string} name - Name of the new category\n */\nexport function addCategory(name) {\n const db = initializeDatabase();\n \n db.prepare('INSERT OR IGNORE INTO categories (name, created_at) VALUES (?, ?)').run(name, Date.now());\n \n db.close();\n}",[],[240],{"_108":248,"_100":249,"_153":250,"_155":-5,"_156":140,"_157":251,"_159":121,"_110":252,"_104":31,"_161":180,"_163":253,"_164":27,"_165":-5,"_166":254,"_103":255},"7cac8bae-2710-11f0-99f2-569c3dd06744","discord-commands.js","7cac8c62-2710-11f0-99f2-569c3dd06744",6,["D",1746161221307],"import { REST, Routes, SlashCommandBuilder } from 'discord.js';\nimport 'dotenv/config';\n\nconst commands = [\n new SlashCommandBuilder()\n .setName('search')\n .setDescription('Search your conversation history')\n .addStringOption(option => \n option.setName('query')\n .setDescription('What would you like to search for?')\n .setRequired(true)),\n \n new SlashCommandBuilder()\n .setName('links')\n .setDescription('Find links shared in your conversations')\n .addStringOption(option => \n option.setName('category')\n .setDescription('Category of links to show (e.g., sofa, table)')\n .setRequired(false)),\n \n new SlashCommandBuilder()\n .setName('categories')\n .setDescription('List all available link categories'),\n \n new SlashCommandBuilder()\n .setName('analyze')\n .setDescription('Analyze your conversation with AI')\n .addStringOption(option => \n option.setName('query')\n .setDescription('What would you like to know about your conversations?')\n .setRequired(true)),\n];\n\nconst rest = new REST({ version: '10' }).setToken(process.env.DISCORD_TOKEN);\n\n/**\n * Register slash commands with Discord\n */\nexport async function registerCommands() {\n try {\n console.log('Registering slash commands...');\n \n await rest.put(\n Routes.applicationCommands(process.env.DISCORD_CLIENT_ID),\n { body: commands }\n );\n \n console.log('Successfully registered application commands.');\n } catch (error) {\n console.error('Error registering commands:', error);\n }\n}\n\n// If this script is being run directly, register commands\nif (process.argv[1] === new URL(import.meta.url).pathname) {\n registerCommands()\n .then(() => process.exit(0))\n .catch(error => {\n console.error('Error:', error);\n process.exit(1);\n });\n}",[],[249],"files",[150,168,175,185,192,200,210,220,229,238,247],"counts",{"_260":31,"_261":158,"_262":31,"_263":242},"pulls","branches","forks","envVars","contents",[266,269,272,275],{"_108":151,"_100":152,"_153":154,"_155":-5,"_156":140,"_157":158,"_159":121,"_110":267,"_104":31,"_161":162,"_163":-5,"_164":27,"_165":-5,"_103":268},["D",1746161220600],[152],{"_108":230,"_100":231,"_153":232,"_155":-5,"_156":140,"_157":233,"_159":121,"_110":270,"_104":31,"_161":206,"_163":235,"_164":27,"_165":-5,"_103":271},["D",1746161221312],[231],{"_108":239,"_100":240,"_153":241,"_155":-5,"_156":140,"_157":242,"_159":121,"_110":273,"_104":31,"_161":180,"_163":244,"_164":27,"_165":-5,"_103":274},["D",1746161221310],[240],{"_108":248,"_100":249,"_153":250,"_155":-5,"_156":140,"_157":251,"_159":121,"_110":276,"_104":31,"_161":180,"_163":253,"_164":27,"_165":-5,"_103":277},["D",1746161221307],[249],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","routes/_app.x.$handle.$name.branch.$branch.version.$version.code.$",{"_98":99,"_100":101,"_102":42,"_104":105,"_103":73,"_106":284,"_148":288,"_256":322,"_206":-7,"_264":323,"_332":-5,"_333":27,"_334":-5,"_335":-5,"_336":-5,"_337":338},{"_108":109,"_100":101,"_110":285,"_112":-5,"_113":27,"_114":115,"_116":73,"_117":-5,"_12":118,"_119":-5,"_120":121,"_122":-5,"_123":31,"_124":125,"_126":125,"_127":128,"_129":128,"_130":128,"_131":125,"_132":125,"_133":27,"_21":286,"_137":287},["D",1746146349872],{"_98":99,"_135":136},{"_104":139,"_100":42,"_108":140,"_141":109,"_142":-5,"_143":-5,"_144":-5,"_145":-5,"_146":101,"_147":99},[289,313,316,319],{"_108":151,"_100":152,"_153":154,"_155":-5,"_156":140,"_157":158,"_159":121,"_110":160,"_104":31,"_161":162,"_163":-5,"_164":27,"_165":-5,"_166":290,"_103":312},[291,297,309],{"_108":169,"_100":170,"_153":171,"_155":154,"_156":140,"_157":172,"_159":121,"_110":173,"_104":31,"_161":162,"_163":-5,"_164":27,"_165":-5,"_166":292,"_103":296},[293],{"_108":176,"_100":177,"_153":178,"_155":171,"_156":140,"_157":105,"_159":121,"_110":179,"_104":31,"_161":180,"_163":181,"_164":27,"_165":-5,"_166":294,"_103":295},[],[152,170,177],[152,170],{"_108":186,"_100":187,"_153":188,"_155":154,"_156":140,"_157":189,"_159":121,"_110":190,"_104":31,"_161":162,"_163":-5,"_164":27,"_165":-5,"_166":298,"_103":308},[299,302,305],{"_108":193,"_100":194,"_153":195,"_155":188,"_156":140,"_157":196,"_159":121,"_110":197,"_104":31,"_161":162,"_163":-5,"_164":27,"_165":-5,"_166":300,"_103":301},[],[152,187,194],{"_108":201,"_100":202,"_153":203,"_155":188,"_156":140,"_157":204,"_159":121,"_110":205,"_104":31,"_161":206,"_163":207,"_164":27,"_165":-5,"_166":303,"_103":304},[],[152,187,202],{"_108":211,"_100":212,"_153":213,"_155":188,"_156":140,"_157":214,"_159":121,"_110":215,"_104":31,"_161":180,"_163":216,"_164":27,"_165":-5,"_166":306,"_103":307},[],[152,187,212],[152,187],{"_108":221,"_100":222,"_153":223,"_155":154,"_156":140,"_157":224,"_159":121,"_110":225,"_104":31,"_161":162,"_163":-5,"_164":27,"_165":-5,"_166":310,"_103":311},[],[152,222],[152],{"_108":230,"_100":231,"_153":232,"_155":-5,"_156":140,"_157":233,"_159":121,"_110":234,"_104":31,"_161":206,"_163":235,"_164":27,"_165":-5,"_166":314,"_103":315},[],[231],{"_108":239,"_100":240,"_153":241,"_155":-5,"_156":140,"_157":242,"_159":121,"_110":243,"_104":31,"_161":180,"_163":244,"_164":27,"_165":-5,"_166":317,"_103":318},[],[240],{"_108":248,"_100":249,"_153":250,"_155":-5,"_156":140,"_157":251,"_159":121,"_110":252,"_104":31,"_161":180,"_163":253,"_164":27,"_165":-5,"_166":320,"_103":321},[],[249],[289,291,293,297,299,302,305,309,313,316,319],[324,326,328,330],{"_108":151,"_100":152,"_153":154,"_155":-5,"_156":140,"_157":158,"_159":121,"_110":267,"_104":31,"_161":162,"_163":-5,"_164":27,"_165":-5,"_103":325},[152],{"_108":230,"_100":231,"_153":232,"_155":-5,"_156":140,"_157":233,"_159":121,"_110":270,"_104":31,"_161":206,"_163":235,"_164":27,"_165":-5,"_103":327},[231],{"_108":239,"_100":240,"_153":241,"_155":-5,"_156":140,"_157":242,"_159":121,"_110":273,"_104":31,"_161":180,"_163":244,"_164":27,"_165":-5,"_103":329},[240],{"_108":248,"_100":249,"_153":250,"_155":-5,"_156":140,"_157":251,"_159":121,"_110":276,"_104":31,"_161":180,"_163":253,"_164":27,"_165":-5,"_103":331},[249],"upstream","showCompareCallout","pull","ahead","behind","templates",[],"routes/_app","actionData","errors"]