[{"_1":2,"_174":-5,"_175":-5},"loaderData",{"_3":4,"_92":93},"root",{"_5":6,"_35":36,"_65":66},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":32,"_33":20,"_34":20},"auth",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20,"_21":22},"sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"tokenType","session_token","user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","notificationCount",0,"flagDenols","isTeamOrgMember","ENV",{"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_51":52,"_53":54,"_55":56,"_57":58,"_59":60,"_61":62,"_63":64},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","adff7c7aeabd218801703bcdcaac3a168cba1c7b","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","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","API_URL","https://api.val.town","clerkState",{"_67":68},"__internal_clerk_state",{"_69":70,"_71":46,"_72":73,"_74":73,"_75":20,"_76":73,"_77":73,"_78":73,"_79":73,"_80":81,"_90":20,"_91":20},"__clerk_ssr_state",{"_21":22,"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_82":20,"_19":20,"_83":73,"_84":85,"_86":73,"_87":46,"_88":20,"_89":73},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_94":95,"_96":97,"_98":99,"_100":101,"_151":152,"_171":172,"_173":-5},"handle","colel","name","rust-coasts-new-community-form","path","backend/index.ts","project",{"_102":103,"_96":97,"_104":105,"_106":-5,"_107":20,"_108":109,"_110":-5,"_111":-5,"_12":112,"_113":114,"_115":116,"_117":116,"_118":-5,"_119":120,"_14":121,"_122":123,"_124":123,"_125":126,"_127":126,"_128":126,"_129":123,"_130":123,"_23":131,"_134":135,"_137":138,"_150":20},"id","a4b5d128-5d11-11f0-a756-0224a6c84d84","createdAt",["D",1752099080759],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","c821e8f7-4cc4-4c23-96f1-319b8f33d4b7","pinnedFileId","2ae437fe-acd4-439c-834d-2f85457f1131","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",1,"6b193d60-e165-45a9-869c-c3f886455f3e","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_94":95,"_132":133},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJ6RVZCOExVNXBIT3FrVDh5a0VZQTNRRG5ycCJ9","org",{"_94":95,"_136":133,"_12":112},"avatar","branch",{"_139":140,"_96":44,"_102":141,"_142":103,"_143":-5,"_144":-5,"_145":-5,"_146":-5,"_147":-5,"_148":97,"_149":95},"version",26,"a4b8165e-5d11-11f0-a756-0224a6c84d84","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_102":153,"_96":154,"_155":114,"_156":157,"_158":141,"_159":160,"_161":116,"_104":162,"_139":120,"_163":164,"_165":166,"_167":20,"_168":-5,"_98":169},"159a4bda-5d1c-11f0-8682-0224a6c84d84","index.ts","fileId","parentId","2224446d-7241-4f56-b007-aa0953c54c1e","branchId","branchVersion",7,"latest",["D",1752103565125],"fileType","http","content","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n throw err;\n});\n\n// Database setup\nconst TABLE_NAME = \"talk_submissions_3\"; // Updated table name for new schema with submitter_name\nconst COMMUNITY_INTEREST_TABLE = \"community_interest_1\"; // New table for community interest capture\n\n// Initialize database\nasync function initDatabase() {\n console.log(`💾 [DB] Initializing database table: ${TABLE_NAME}`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n speaker_name TEXT NOT NULL,\n talk_context TEXT NOT NULL,\n is_on_behalf BOOLEAN NOT NULL,\n submitter_name TEXT,\n discord_channel_id TEXT,\n discord_invite_link TEXT,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )`);\n \n console.log(`💾 [DB] Initializing community interest table: ${COMMUNITY_INTEREST_TABLE}`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${COMMUNITY_INTEREST_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n email TEXT NOT NULL,\n phone TEXT,\n interest_type TEXT NOT NULL,\n comments TEXT,\n location TEXT NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )`);\n \n console.log(`✅ [DB] Database initialization complete`);\n}\n\n// Check Discord environment on startup\nfunction checkDiscordEnvironment() {\n console.log(`🔍 [Discord] Checking environment configuration...`);\n\n const botToken = Deno.env.get(\"DISCORD_BOT_TOKEN\");\n const guildId = Deno.env.get(\"DISCORD_GUILD_ID\");\n const organizersChannelId = Deno.env.get(\"DISCORD_ORGANIZERS_CHANNEL_ID\");\n const categoryId = Deno.env.get(\"DISCORD_CATEGORY_ID\");\n const testCategoryId = Deno.env.get(\"DISCORD_TEST_CATEGORY_ID\");\n const testOrganizersChannelId = Deno.env.get(\"DISCORD_TEST_ORGANIZERS_CHANNEL_ID\");\n const testApiEnabled = Deno.env.get(\"ENABLE_TEST_API\");\n\n console.log(`🤖 [Discord] Bot Token: ${botToken ? \"✅ Present\" : \"❌ Missing\"}`);\n console.log(`🏠 [Discord] Guild ID: ${guildId ? \"✅ Present\" : \"❌ Missing\"}`);\n console.log(`📢 [Discord] Organizers Channel: ${organizersChannelId ? \"✅ Present\" : \"❌ Missing\"}`);\n console.log(`📁 [Discord] Category ID: ${categoryId ? \"✅ Present\" : \"⚪ Optional (not set)\"}`);\n console.log(`🧪 [Discord] Test Category ID: ${testCategoryId ? \"✅ Present\" : \"⚪ Optional (not set)\"}`);\n console.log(`🧪 [Discord] Test Organizers Channel: ${testOrganizersChannelId ? \"✅ Present\" : \"⚪ Optional (not set)\"}`);\n console.log(`🧪 [Discord] Test API Enabled: ${testApiEnabled?.toLowerCase() === \"true\" ? \"✅ Enabled\" : \"⚪ Disabled\"}`);\n\n const isFullyConfigured = botToken && guildId && organizersChannelId;\n\n if (isFullyConfigured) {\n console.log(`✅ [Discord] Full Discord integration enabled`);\n } else {\n console.log(`⚠️ [Discord] Discord integration will use placeholder mode`);\n console.log(\n `ℹ️ [Discord] To enable full integration, set: DISCORD_BOT_TOKEN, DISCORD_GUILD_ID, DISCORD_ORGANIZERS_CHANNEL_ID`,\n );\n }\n\n return isFullyConfigured;\n}\n\n// Initialize DB and check environment on startup\nawait initDatabase();\nconst discordConfigured = checkDiscordEnvironment();\nconsole.log(`🚀 [System] Talk submission system ready! Discord: ${discordConfigured ? \"Enabled\" : \"Placeholder mode\"}`);\n\n// Helper functions for location data\nfunction getLocationName(code: string): string {\n const locationNames: Record = {\n 'SF': 'San Francisco',\n 'LA': 'Los Angeles',\n 'NYC': 'New York City',\n 'SEA': 'Seattle',\n 'CHI': 'Chicago',\n 'BOS': 'Boston',\n 'ATL': 'Atlanta',\n 'DEN': 'Denver',\n 'PDX': 'Portland',\n 'AUS': 'Austin'\n };\n return locationNames[code] || code;\n}\n\nfunction getLocationCoverImage(code: string): string {\n // Return placeholder image URLs for now - these would be replaced with actual images\n const coverImages: Record = {\n 'SF': 'https://images.unsplash.com/photo-1506905925346-21bda4d32df4?w=1200&h=600&fit=crop',\n 'LA': 'https://images.unsplash.com/photo-1444927714506-8492d94b5ba0?w=1200&h=600&fit=crop',\n 'NYC': 'https://images.unsplash.com/photo-1496442226666-8d4d0e62e6e9?w=1200&h=600&fit=crop',\n 'SEA': 'https://images.unsplash.com/photo-1506905925346-21bda4d32df4?w=1200&h=600&fit=crop',\n 'CHI': 'https://images.unsplash.com/photo-1494522358652-f30e61a60313?w=1200&h=600&fit=crop',\n 'BOS': 'https://images.unsplash.com/photo-1559827260-dc66d52bef19?w=1200&h=600&fit=crop',\n 'ATL': 'https://images.unsplash.com/photo-1575558091433-4bf9b2c4b2d6?w=1200&h=600&fit=crop',\n 'DEN': 'https://images.unsplash.com/photo-1619856699906-09e1f58c98b1?w=1200&h=600&fit=crop',\n 'PDX': 'https://images.unsplash.com/photo-1544992064-12b7d04f0c95?w=1200&h=600&fit=crop',\n 'AUS': 'https://images.unsplash.com/photo-1531218150217-54595bc2b934?w=1200&h=600&fit=crop'\n };\n return coverImages[code] || 'https://images.unsplash.com/photo-1506905925346-21bda4d32df4?w=1200&h=600&fit=crop';\n}\n\nfunction getLocationDescription(code: string): string {\n const descriptions: Record = {\n 'SF': 'Join the vibrant tech community in San Francisco',\n 'LA': 'Connect with creators and innovators in Los Angeles',\n 'NYC': 'Be part of the bustling tech scene in New York City',\n 'SEA': 'Engage with the thriving tech ecosystem in Seattle',\n 'CHI': 'Join the growing tech community in Chicago',\n 'BOS': 'Connect with the innovation hub in Boston',\n 'ATL': 'Be part of the emerging tech scene in Atlanta',\n 'DEN': 'Join the mountain tech community in Denver',\n 'PDX': 'Connect with the creative tech scene in Portland',\n 'AUS': 'Join the vibrant startup community in Austin'\n };\n return descriptions[code] || 'Join our local tech community';\n}\n\n// Serve static files\napp.get(\"/frontend/*\", c => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", c => serveFile(c.req.path, import.meta.url));\n\n// Serve main page\napp.get(\"/\", async c => {\n const html = await readFile(\"/frontend/index.html\", import.meta.url);\n return c.html(html);\n});\n\n// Define supported locations\nconst SUPPORTED_LOCATIONS = ['SF', 'LA', 'NYC', 'SEA', 'CHI', 'BOS', 'ATL', 'DEN', 'PDX', 'AUS'];\n\n// Location-specific data endpoint\napp.get(\"/api/locations/:location\", async c => {\n const location = c.req.param(\"location\").toUpperCase();\n \n if (!SUPPORTED_LOCATIONS.includes(location)) {\n return c.json({ error: \"Location not supported\" }, 404);\n }\n \n // Return location-specific configuration\n const locationData = {\n code: location,\n name: getLocationName(location),\n coverImage: getLocationCoverImage(location),\n description: getLocationDescription(location)\n };\n \n return c.json(locationData);\n});\n\n// API Routes\napp.post(\"/api/submissions\", async c => {\n console.log(`🎯 [API] New talk submission received`);\n\n try {\n const body = await c.req.json();\n const { speakerName, talkContext, isOnBehalf, submitterName } = body;\n\n console.log(`📋 [API] Submission details:`);\n console.log(` Speaker: \"${speakerName}\"`);\n console.log(` Context length: ${talkContext?.length || 0} characters`);\n console.log(` On behalf: ${isOnBehalf}`);\n if (isOnBehalf && submitterName) {\n console.log(` Submitter: \"${submitterName}\"`);\n }\n\n // Validate input\n if (!speakerName || !talkContext || typeof isOnBehalf !== \"boolean\") {\n console.error(`❌ [API] Validation failed - missing required fields`);\n console.error(` speakerName: ${!!speakerName}`);\n console.error(` talkContext: ${!!talkContext}`);\n console.error(` isOnBehalf: ${typeof isOnBehalf}`);\n return c.json({ error: \"Missing required fields\" }, 400);\n }\n\n // Validate submitter name if submitting on behalf\n if (isOnBehalf && !submitterName?.trim()) {\n console.error(`❌ [API] Validation failed - submitter name required when submitting on behalf`);\n return c.json({ error: \"Submitter name is required when submitting on behalf of someone else\" }, 400);\n }\n\n console.log(`💾 [API] Inserting submission into database`);\n\n // Insert submission into database\n const result = await sqlite.execute(\n `INSERT INTO ${TABLE_NAME} (speaker_name, talk_context, is_on_behalf, submitter_name) VALUES (?, ?, ?, ?)`,\n [speakerName, talkContext, isOnBehalf, isOnBehalf ? submitterName : null],\n );\n\n const submissionId = Number(result.lastInsertRowid);\n console.log(`✅ [API] Database insertion successful, submission ID: ${submissionId}`);\n\n // Discord integration workflow\n console.log(`🤖 [API] Starting Discord integration workflow`);\n\n console.log(`🔧 [API] Step 1: Creating Discord channel`);\n const discordChannelId = await createDiscordChannel(speakerName, submissionId);\n\n console.log(`🔗 [API] Step 2: Creating Discord invite`);\n const discordInviteLink = await createDiscordInvite(discordChannelId);\n\n console.log(`💬 [API] Step 3: Sending welcome message to channel`);\n await sendWelcomeMessage(discordChannelId, speakerName, talkContext, isOnBehalf, submitterName);\n\n console.log(`📢 [API] Step 4: Notifying organizers`);\n await postToOrganizersChannel(speakerName, talkContext, isOnBehalf, submitterName, discordChannelId);\n\n console.log(`💾 [API] Updating database with Discord information`);\n\n // Update submission with Discord info\n await sqlite.execute(\n `UPDATE ${TABLE_NAME} SET discord_channel_id = ?, discord_invite_link = ? WHERE id = ?`,\n [discordChannelId, discordInviteLink, submissionId],\n );\n\n console.log(`✅ [API] Submission processing complete!`);\n console.log(`📊 [API] Final result:`);\n console.log(` Submission ID: ${submissionId}`);\n console.log(` Discord Channel ID: ${discordChannelId}`);\n console.log(` Discord Invite: ${discordInviteLink}`);\n\n return c.json({\n success: true,\n submissionId: submissionId,\n discordInviteLink,\n });\n } catch (error) {\n console.error(`💥 [API] Critical error processing submission:`, error);\n console.error(`💥 [API] Error type:`, error.constructor.name);\n console.error(`💥 [API] Error message:`, error.message);\n if (error.stack) {\n console.error(`💥 [API] Stack trace:`, error.stack);\n }\n return c.json({ error: \"Internal server error\" }, 500);\n }\n});\n\n// Get all submissions (for admin view)\napp.get(\"/api/submissions\", async c => {\n try {\n const submissions = await sqlite.execute(`SELECT * FROM ${TABLE_NAME} ORDER BY created_at DESC`);\n return c.json(submissions);\n } catch (error) {\n console.error(\"Error fetching submissions:\", error);\n return c.json({ error: \"Internal server error\" }, 500);\n }\n});\n\n// Community interest endpoint\napp.post(\"/api/community-interest\", async c => {\n console.log(`🏘️ [API] New community interest submission received`);\n\n try {\n const body = await c.req.json();\n const { name, email, phone, interest_type, comments, location } = body;\n\n console.log(`📋 [API] Community interest details:`);\n console.log(` Name: \"${name}\"`);\n console.log(` Email: \"${email}\"`);\n console.log(` Phone: \"${phone || 'Not provided'}\"`);\n console.log(` Interest Type: \"${interest_type}\"`);\n console.log(` Location: \"${location}\"`);\n console.log(` Comments: ${comments ? `\"${comments}\"` : 'None'}`);\n\n // Validate required fields\n if (!name || !email || !interest_type || !location) {\n console.error(`❌ [API] Validation failed - missing required fields`);\n console.error(` name: ${!!name}`);\n console.error(` email: ${!!email}`);\n console.error(` interest_type: ${!!interest_type}`);\n console.error(` location: ${!!location}`);\n return c.json({ error: \"Missing required fields: name, email, interest_type, and location are required\" }, 400);\n }\n\n // Validate email format\n const emailRegex = /^[^\\s@]+@[^\\s@]+\\.[^\\s@]+$/;\n if (!emailRegex.test(email)) {\n console.error(`❌ [API] Validation failed - invalid email format: \"${email}\"`);\n return c.json({ error: \"Invalid email format\" }, 400);\n }\n\n // Validate interest_type\n const validInterestTypes = [\"I want to organize events\", \"I want to attend events\", \"Both organizing and attending\"];\n if (!validInterestTypes.includes(interest_type)) {\n console.error(`❌ [API] Validation failed - invalid interest type: \"${interest_type}\"`);\n return c.json({ error: \"Invalid interest type\" }, 400);\n }\n\n // Check for duplicate email in same location\n const existingEntry = await sqlite.execute(\n `SELECT id FROM ${COMMUNITY_INTEREST_TABLE} WHERE email = ? AND location = ?`,\n [email, location]\n );\n\n if (existingEntry.length > 0) {\n console.log(`⚠️ [API] Duplicate email found for location - updating existing entry`);\n \n // Update existing entry\n await sqlite.execute(\n `UPDATE ${COMMUNITY_INTEREST_TABLE} SET name = ?, phone = ?, interest_type = ?, comments = ?, created_at = CURRENT_TIMESTAMP WHERE email = ? AND location = ?`,\n [name, phone || null, interest_type, comments || null, email, location]\n );\n\n const entryId = existingEntry[0].id;\n console.log(`✅ [API] Community interest updated successfully, entry ID: ${entryId}`);\n\n return c.json({\n success: true,\n message: \"Community interest updated successfully\",\n entryId: entryId,\n updated: true\n });\n } else {\n // Insert new entry\n console.log(`💾 [API] Inserting new community interest into database`);\n \n const result = await sqlite.execute(\n `INSERT INTO ${COMMUNITY_INTEREST_TABLE} (name, email, phone, interest_type, comments, location) VALUES (?, ?, ?, ?, ?, ?)`,\n [name, email, phone || null, interest_type, comments || null, location]\n );\n\n const entryId = Number(result.lastInsertRowid);\n console.log(`✅ [API] Community interest saved successfully, entry ID: ${entryId}`);\n\n return c.json({\n success: true,\n message: \"Community interest saved successfully\",\n entryId: entryId,\n updated: false\n });\n }\n } catch (error) {\n console.error(`💥 [API] Critical error processing community interest:`, error);\n console.error(`💥 [API] Error type:`, error.constructor.name);\n console.error(`💥 [API] Error message:`, error.message);\n if (error.stack) {\n console.error(`💥 [API] Stack trace:`, error.stack);\n }\n return c.json({ error: \"Internal server error\" }, 500);\n }\n});\n\n// Get all community interest entries (for admin view)\napp.get(\"/api/community-interest\", async c => {\n try {\n const entries = await sqlite.execute(`SELECT * FROM ${COMMUNITY_INTEREST_TABLE} ORDER BY created_at DESC`);\n return c.json(entries);\n } catch (error) {\n console.error(\"Error fetching community interest entries:\", error);\n return c.json({ error: \"Internal server error\" }, 500);\n }\n});\n\n// Basic auth middleware\nfunction basicAuth(password: string) {\n return async (c: any, next: any) => {\n const auth = c.req.header(\"Authorization\");\n if (!auth || !auth.startsWith(\"Basic \")) {\n return c.json({ error: \"Authorization required\" }, 401);\n }\n \n const credentials = atob(auth.slice(6));\n const [_, providedPassword] = credentials.split(\":\");\n \n if (providedPassword !== password) {\n return c.json({ error: \"Invalid credentials\" }, 401);\n }\n \n await next();\n };\n}\n\n// Admin endpoints\napp.get(\"/api/admin/community-interest\", basicAuth(Deno.env.get(\"ADMIN_PASSWORD\") || \"admin\"), async c => {\n try {\n const location = c.req.query(\"location\");\n const interest_type = c.req.query(\"interest_type\");\n \n let query = `SELECT * FROM ${COMMUNITY_INTEREST_TABLE}`;\n let params: any[] = [];\n \n const conditions: string[] = [];\n \n if (location) {\n conditions.push(\"location = ?\");\n params.push(location);\n }\n \n if (interest_type) {\n conditions.push(\"interest_type = ?\");\n params.push(interest_type);\n }\n \n if (conditions.length > 0) {\n query += \" WHERE \" + conditions.join(\" AND \");\n }\n \n query += \" ORDER BY created_at DESC\";\n \n const entries = await sqlite.execute(query, params);\n return c.json(entries);\n } catch (error) {\n console.error(\"Error fetching admin community interest entries:\", error);\n return c.json({ error: \"Internal server error\" }, 500);\n }\n});\n\n// Admin CSV export endpoint\napp.get(\"/api/admin/community-interest/export\", basicAuth(Deno.env.get(\"ADMIN_PASSWORD\") || \"admin\"), async c => {\n try {\n const location = c.req.query(\"location\");\n const interest_type = c.req.query(\"interest_type\");\n \n let query = `SELECT * FROM ${COMMUNITY_INTEREST_TABLE}`;\n let params: any[] = [];\n \n const conditions: string[] = [];\n \n if (location) {\n conditions.push(\"location = ?\");\n params.push(location);\n }\n \n if (interest_type) {\n conditions.push(\"interest_type = ?\");\n params.push(interest_type);\n }\n \n if (conditions.length > 0) {\n query += \" WHERE \" + conditions.join(\" AND \");\n }\n \n query += \" ORDER BY created_at DESC\";\n \n const entries = await sqlite.execute(query, params);\n \n // Convert to CSV\n const headers = [\"ID\", \"Name\", \"Email\", \"Phone\", \"Interest Type\", \"Comments\", \"Location\", \"Created At\"];\n const csvContent = [\n headers.join(\",\"),\n ...entries.map(entry => [\n entry.id,\n `\"${entry.name}\"`,\n `\"${entry.email}\"`,\n `\"${entry.phone || \"\"}\"`,\n `\"${entry.interest_type}\"`,\n `\"${entry.comments || \"\"}\"`,\n `\"${entry.location}\"`,\n `\"${entry.created_at}\"`\n ].join(\",\"))\n ].join(\"\\n\");\n \n return c.text(csvContent, 200, {\n \"Content-Type\": \"text/csv\",\n \"Content-Disposition\": `attachment; filename=\"community-interest-${Date.now()}.csv\"`\n });\n } catch (error) {\n console.error(\"Error exporting community interest CSV:\", error);\n return c.json({ error: \"Internal server error\" }, 500);\n }\n});\n\n// Test Discord functionality\napp.post(\"/api/discord/test\", async c => {\n console.log(`🧪 [Test] Discord test endpoint called`);\n \n // Check if test API is enabled\n const testApiEnabled = Deno.env.get(\"ENABLE_TEST_API\");\n if (!testApiEnabled || testApiEnabled.toLowerCase() !== \"true\") {\n console.warn(`⚠️ [Test] Test API is disabled. Set ENABLE_TEST_API=true to enable.`);\n return c.json({ error: \"Test API is disabled\" }, 403);\n }\n \n try {\n const body = await c.req.json();\n const { channelName, firstMessage } = body;\n \n if (!channelName || !firstMessage) {\n return c.json({ error: \"channelName and firstMessage are required\" }, 400);\n }\n \n const sanitizedChannelName = channelName.toLowerCase().replace(/[^a-z0-9]/g, \"-\");\n const message = firstMessage;\n \n console.log(`🧪 [Test] Creating test channel: ${sanitizedChannelName}`);\n const channelId = await createDiscordTestChannel(sanitizedChannelName);\n \n console.log(`🧪 [Test] Sending test message to channel: ${channelId}`);\n await sendTestMessage(channelId, message);\n \n console.log(`🧪 [Test] Creating invite for test channel`);\n const inviteLink = await createDiscordInvite(channelId);\n \n console.log(`🧪 [Test] Notifying test organizers`);\n await notifyTestOrganizers(sanitizedChannelName, message, channelId, inviteLink);\n \n return c.json({\n success: true,\n channelId,\n channelName: sanitizedChannelName,\n inviteLink,\n message: \"Test completed successfully!\"\n });\n } catch (error) {\n console.error(`💥 [Test] Error in Discord test:`, error);\n return c.json({ error: error.message }, 500);\n }\n});\n\n// Discord integration functions\nasync function createDiscordChannel(speakerName: string, submissionId: number): Promise {\n console.log(`🔧 [Discord] Starting channel creation for speaker: \"${speakerName}\", submission ID: ${submissionId}`);\n\n const botToken = Deno.env.get(\"DISCORD_BOT_TOKEN\");\n const guildId = Deno.env.get(\"DISCORD_GUILD_ID\");\n const categoryId = Deno.env.get(\"DISCORD_CATEGORY_ID\");\n\n // Check environment variables\n if (!botToken) {\n console.warn(`⚠️ [Discord] DISCORD_BOT_TOKEN not found in environment variables`);\n }\n if (!guildId) {\n console.warn(`⚠️ [Discord] DISCORD_GUILD_ID not found in environment variables`);\n }\n if (categoryId) {\n console.log(`📁 [Discord] Using category ID: ${categoryId}`);\n } else {\n console.log(`📁 [Discord] No category ID specified, channel will be created at root level`);\n }\n\n if (!botToken || !guildId) {\n console.log(`🔄 [Discord] Missing credentials, using placeholder for ${speakerName} (submission ${submissionId})`);\n return `channel_${submissionId}_placeholder`;\n }\n\n try {\n const channelName = `talk-${speakerName.toLowerCase().replace(/[^a-z0-9]/g, \"-\")}-${submissionId}`;\n console.log(`📝 [Discord] Generated channel name: \"${channelName}\"`);\n\n const channelData: any = {\n name: channelName,\n type: 0, // Text channel\n topic: `Discussion for ${speakerName}'s talk proposal (Submission #${submissionId})`,\n };\n\n if (categoryId) {\n channelData.parent_id = categoryId;\n }\n\n console.log(`🚀 [Discord] Making API request to create channel in guild ${guildId}`);\n console.log(`📊 [Discord] Channel data:`, JSON.stringify(channelData, null, 2));\n\n const response = await fetch(`https://discord.com/api/v10/guilds/${guildId}/channels`, {\n method: \"POST\",\n headers: {\n \"Authorization\": `Bot ${botToken}`,\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify(channelData),\n });\n\n console.log(`📡 [Discord] API Response Status: ${response.status} ${response.statusText}`);\n\n if (!response.ok) {\n const errorText = await response.text();\n console.error(`❌ [Discord] Channel creation failed with status ${response.status}`);\n console.error(`❌ [Discord] Error response body:`, errorText);\n\n try {\n const errorJson = JSON.parse(errorText);\n console.error(`❌ [Discord] Parsed error:`, JSON.stringify(errorJson, null, 2));\n } catch {\n console.error(`❌ [Discord] Could not parse error response as JSON`);\n }\n\n throw new Error(`Discord API error: ${response.status} - ${errorText}`);\n }\n\n const channel = await response.json();\n console.log(`✅ [Discord] Channel created successfully!`);\n console.log(`📋 [Discord] Channel ID: ${channel.id}`);\n console.log(`📋 [Discord] Channel Name: ${channel.name}`);\n\n return channel.id;\n } catch (error) {\n console.error(`💥 [Discord] Exception during channel creation:`, error);\n console.error(`💥 [Discord] Error type:`, error.constructor.name);\n console.error(`💥 [Discord] Error message:`, error.message);\n if (error.stack) {\n console.error(`💥 [Discord] Stack trace:`, error.stack);\n }\n return `channel_${submissionId}_placeholder`;\n }\n}\n\nasync function createDiscordInvite(channelId: string): Promise {\n console.log(`🔗 [Discord] Starting invite creation for channel: ${channelId}`);\n\n const botToken = Deno.env.get(\"DISCORD_BOT_TOKEN\");\n\n if (!botToken) {\n console.warn(`⚠️ [Discord] DISCORD_BOT_TOKEN not found for invite creation`);\n }\n\n if (!botToken || channelId.includes(\"placeholder\")) {\n const placeholderInvite = `https://discord.gg/placeholder_${channelId}`;\n console.log(`🔄 [Discord] Using placeholder invite: ${placeholderInvite}`);\n return placeholderInvite;\n }\n\n try {\n const inviteData = {\n max_age: 0, // Never expires\n max_uses: 0, // Unlimited uses\n unique: true,\n };\n\n console.log(`🚀 [Discord] Making API request to create invite for channel ${channelId}`);\n console.log(`📊 [Discord] Invite data:`, JSON.stringify(inviteData, null, 2));\n\n const response = await fetch(`https://discord.com/api/v10/channels/${channelId}/invites`, {\n method: \"POST\",\n headers: {\n \"Authorization\": `Bot ${botToken}`,\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify(inviteData),\n });\n\n console.log(`📡 [Discord] Invite API Response Status: ${response.status} ${response.statusText}`);\n\n if (!response.ok) {\n const errorText = await response.text();\n console.error(`❌ [Discord] Invite creation failed with status ${response.status}`);\n console.error(`❌ [Discord] Error response body:`, errorText);\n\n try {\n const errorJson = JSON.parse(errorText);\n console.error(`❌ [Discord] Parsed invite error:`, JSON.stringify(errorJson, null, 2));\n } catch {\n console.error(`❌ [Discord] Could not parse invite error response as JSON`);\n }\n\n throw new Error(`Discord API error: ${response.status} - ${errorText}`);\n }\n\n const invite = await response.json();\n const inviteUrl = `https://discord.gg/${invite.code}`;\n\n console.log(`✅ [Discord] Invite created successfully!`);\n console.log(`🔗 [Discord] Invite code: ${invite.code}`);\n console.log(`🔗 [Discord] Full invite URL: ${inviteUrl}`);\n console.log(`⏰ [Discord] Invite expires: ${invite.max_age === 0 ? \"Never\" : `${invite.max_age} seconds`}`);\n console.log(`👥 [Discord] Max uses: ${invite.max_uses === 0 ? \"Unlimited\" : invite.max_uses}`);\n\n return inviteUrl;\n } catch (error) {\n console.error(`💥 [Discord] Exception during invite creation:`, error);\n console.error(`💥 [Discord] Error type:`, error.constructor.name);\n console.error(`💥 [Discord] Error message:`, error.message);\n if (error.stack) {\n console.error(`💥 [Discord] Stack trace:`, error.stack);\n }\n\n const fallbackInvite = `https://discord.gg/placeholder_${channelId}`;\n console.log(`🔄 [Discord] Falling back to placeholder invite: ${fallbackInvite}`);\n return fallbackInvite;\n }\n}\n\nasync function createDiscordTestChannel(channelName: string): Promise {\n console.log(`🧪 [Test] Creating test channel: ${channelName}`);\n \n const botToken = Deno.env.get(\"DISCORD_BOT_TOKEN\");\n const guildId = Deno.env.get(\"DISCORD_GUILD_ID\");\n const testCategoryId = Deno.env.get(\"DISCORD_TEST_CATEGORY_ID\");\n \n if (!botToken || !guildId) {\n console.log(`🔄 [Test] Missing credentials, using placeholder`);\n return `test_channel_placeholder_${Date.now()}`;\n }\n \n try {\n const channelData: any = {\n name: channelName,\n type: 0, // Text channel\n topic: `Test channel created at ${new Date().toISOString()}`,\n };\n \n if (testCategoryId) {\n channelData.parent_id = testCategoryId;\n console.log(`📁 [Test] Using test category ID: ${testCategoryId}`);\n }\n \n const response = await fetch(`https://discord.com/api/v10/guilds/${guildId}/channels`, {\n method: \"POST\",\n headers: {\n \"Authorization\": `Bot ${botToken}`,\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify(channelData),\n });\n \n if (!response.ok) {\n const errorText = await response.text();\n console.error(`❌ [Test] Channel creation failed: ${response.status} - ${errorText}`);\n throw new Error(`Discord API error: ${response.status} - ${errorText}`);\n }\n \n const channel = await response.json();\n console.log(`✅ [Test] Test channel created: ${channel.id}`);\n return channel.id;\n } catch (error) {\n console.error(`💥 [Test] Error creating test channel:`, error);\n throw error;\n }\n}\n\nasync function sendTestMessage(channelId: string, message: string): Promise {\n console.log(`🧪 [Test] Sending message to channel: ${channelId}`);\n \n const botToken = Deno.env.get(\"DISCORD_BOT_TOKEN\");\n \n if (!botToken || channelId.includes(\"placeholder\")) {\n console.log(`🔄 [Test] Using placeholder mode, would send: ${message}`);\n return;\n }\n \n try {\n const messageData = {\n content: `🧪 **Test Message**\\n${message}\\n\\n*Sent at ${new Date().toISOString()}*`,\n };\n \n const response = await fetch(`https://discord.com/api/v10/channels/${channelId}/messages`, {\n method: \"POST\",\n headers: {\n \"Authorization\": `Bot ${botToken}`,\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify(messageData),\n });\n \n if (!response.ok) {\n const errorText = await response.text();\n console.error(`❌ [Test] Message sending failed: ${response.status} - ${errorText}`);\n throw new Error(`Discord API error: ${response.status} - ${errorText}`);\n }\n \n const messageResponse = await response.json();\n console.log(`✅ [Test] Message sent successfully: ${messageResponse.id}`);\n } catch (error) {\n console.error(`💥 [Test] Error sending test message:`, error);\n throw error;\n }\n}\n\nasync function notifyTestOrganizers(\n channelName: string,\n firstMessage: string,\n channelId: string,\n inviteLink: string,\n): Promise {\n console.log(`🧪 [Test] Starting test organizer notification for channel: \"${channelName}\"`);\n\n const botToken = Deno.env.get(\"DISCORD_BOT_TOKEN\");\n const testOrganizersChannelId = Deno.env.get(\"DISCORD_TEST_ORGANIZERS_CHANNEL_ID\");\n\n if (!botToken) {\n console.warn(`⚠️ [Test] DISCORD_BOT_TOKEN not found for test organizer notification`);\n }\n if (!testOrganizersChannelId) {\n console.warn(`⚠️ [Test] DISCORD_TEST_ORGANIZERS_CHANNEL_ID not found, skipping notification`);\n return;\n }\n\n const message = `🧪 **Test Channel Created**\n**Channel Name:** ${channelName}\n**First Message:** ${firstMessage}\n**Channel Link:** ${channelId.includes(\"placeholder\") ? \"Channel creation failed\" : `<#${channelId}>`}\n**Invitation Link:** ${inviteLink}`;\n\n console.log(`📝 [Test] Prepared test organizer message:`);\n console.log(message);\n\n if (!botToken) {\n console.log(`🔄 [Test] Missing bot token, would have posted above message`);\n return;\n }\n\n try {\n const messageData = {\n content: message,\n };\n\n console.log(`🚀 [Test] Making API request to post to test organizers channel ${testOrganizersChannelId}`);\n\n const response = await fetch(`https://discord.com/api/v10/channels/${testOrganizersChannelId}/messages`, {\n method: \"POST\",\n headers: {\n \"Authorization\": `Bot ${botToken}`,\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify(messageData),\n });\n\n if (!response.ok) {\n const errorText = await response.text();\n console.error(`❌ [Test] Test organizer notification failed: ${response.status} - ${errorText}`);\n throw new Error(`Discord API error: ${response.status} - ${errorText}`);\n }\n\n const messageResponse = await response.json();\n console.log(`✅ [Test] Test organizer notification sent successfully: ${messageResponse.id}`);\n } catch (error) {\n console.error(`💥 [Test] Error sending test organizer notification:`, error);\n // Don't throw here - we don't want to fail the test if notification fails\n console.log(`🔄 [Test] Continuing despite test organizer notification failure`);\n }\n}\n\nasync function postToOrganizersChannel(\n speakerName: string,\n talkContext: string,\n isOnBehalf: boolean,\n submitterName: string | undefined,\n channelId: string,\n): Promise {\n console.log(`📢 [Discord] Starting organizer notification for speaker: \"${speakerName}\"`);\n\n const botToken = Deno.env.get(\"DISCORD_BOT_TOKEN\");\n const organizersChannelId = Deno.env.get(\"DISCORD_ORGANIZERS_CHANNEL_ID\");\n\n // Check environment variables\n if (!botToken) {\n console.warn(`⚠️ [Discord] DISCORD_BOT_TOKEN not found for organizer notification`);\n }\n if (!organizersChannelId) {\n console.warn(`⚠️ [Discord] DISCORD_ORGANIZERS_CHANNEL_ID not found in environment variables`);\n } else {\n console.log(`📋 [Discord] Using organizers channel ID: ${organizersChannelId}`);\n }\n\n const submissionInfo = isOnBehalf && submitterName\n ? `Submitted by **${submitterName}** on behalf of the speaker`\n : isOnBehalf\n ? \"Submitted by someone else on behalf of the speaker\"\n : \"Submitted by the speaker themselves\";\n\n const message = `🎤 **New Talk Submission**\n**Speaker:** ${speakerName}\n**Talk Context:** ${talkContext}\n**Submission Info:** ${submissionInfo}\n**Discussion Channel:** ${channelId.includes(\"placeholder\") ? \"Channel creation failed\" : `<#${channelId}>`}`;\n\n console.log(`📝 [Discord] Prepared organizer message:`);\n console.log(message);\n\n if (!botToken || !organizersChannelId) {\n console.log(`🔄 [Discord] Missing credentials for organizer notification, would have posted above message`);\n return;\n }\n\n try {\n const messageData = {\n content: message,\n };\n\n console.log(`🚀 [Discord] Making API request to post to organizers channel ${organizersChannelId}`);\n console.log(`📊 [Discord] Message data:`, JSON.stringify(messageData, null, 2));\n\n const response = await fetch(`https://discord.com/api/v10/channels/${organizersChannelId}/messages`, {\n method: \"POST\",\n headers: {\n \"Authorization\": `Bot ${botToken}`,\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify(messageData),\n });\n\n console.log(`📡 [Discord] Message API Response Status: ${response.status} ${response.statusText}`);\n\n if (!response.ok) {\n const errorText = await response.text();\n console.error(`❌ [Discord] Message posting failed with status ${response.status}`);\n console.error(`❌ [Discord] Error response body:`, errorText);\n\n try {\n const errorJson = JSON.parse(errorText);\n console.error(`❌ [Discord] Parsed message error:`, JSON.stringify(errorJson, null, 2));\n\n // Provide specific error guidance\n if (errorJson.code === 50001) {\n console.error(`🔐 [Discord] Missing access to channel - check bot permissions`);\n } else if (errorJson.code === 10003) {\n console.error(`🔍 [Discord] Channel not found - check DISCORD_ORGANIZERS_CHANNEL_ID`);\n } else if (errorJson.code === 50013) {\n console.error(`🚫 [Discord] Missing permissions to send messages in this channel`);\n }\n } catch {\n console.error(`❌ [Discord] Could not parse message error response as JSON`);\n }\n\n throw new Error(`Discord API error: ${response.status} - ${errorText}`);\n }\n\n const messageResponse = await response.json();\n console.log(`✅ [Discord] Message posted successfully to organizers channel!`);\n console.log(`📋 [Discord] Message ID: ${messageResponse.id}`);\n console.log(`⏰ [Discord] Message timestamp: ${messageResponse.timestamp}`);\n } catch (error) {\n console.error(`💥 [Discord] Exception during organizer notification:`, error);\n console.error(`💥 [Discord] Error type:`, error.constructor.name);\n console.error(`💥 [Discord] Error message:`, error.message);\n if (error.stack) {\n console.error(`💥 [Discord] Stack trace:`, error.stack);\n }\n\n // Don't throw here - we don't want to fail the entire submission if organizer notification fails\n console.log(`🔄 [Discord] Continuing despite organizer notification failure`);\n }\n}\n\nasync function sendWelcomeMessage(\n channelId: string,\n speakerName: string,\n talkContext: string,\n isOnBehalf: boolean,\n submitterName: string | undefined,\n): Promise {\n console.log(`💬 [Discord] Sending welcome message to channel: ${channelId}`);\n\n const botToken = Deno.env.get(\"DISCORD_BOT_TOKEN\");\n\n if (!botToken) {\n console.warn(`⚠️ [Discord] DISCORD_BOT_TOKEN not found for welcome message`);\n }\n\n if (!botToken || channelId.includes(\"placeholder\")) {\n console.log(`🔄 [Discord] Using placeholder mode, would send welcome message`);\n return;\n }\n\n const submissionInfo = isOnBehalf && submitterName\n ? `Submitted by **${submitterName}** on behalf of the speaker`\n : isOnBehalf\n ? \"Submitted by someone else on behalf of the speaker\"\n : \"Submitted by the speaker themselves\";\n\n const welcomeMessage = `🎤 **Welcome to your talk discussion channel!**\n\n**Speaker:** ${speakerName}\n**Talk Context:** ${talkContext}\n**Submission:** ${submissionInfo}\n\nThis channel has been created for you to discuss your talk proposal with the organizers. Feel free to share additional details, ask questions, or coordinate next steps here.\n\nThe organizers have been notified and will be in touch soon!`;\n\n console.log(`📝 [Discord] Prepared welcome message for channel ${channelId}`);\n\n try {\n const messageData = {\n content: welcomeMessage,\n };\n\n const response = await fetch(`https://discord.com/api/v10/channels/${channelId}/messages`, {\n method: \"POST\",\n headers: {\n \"Authorization\": `Bot ${botToken}`,\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify(messageData),\n });\n\n console.log(`📡 [Discord] Welcome message API Response Status: ${response.status} ${response.statusText}`);\n\n if (!response.ok) {\n const errorText = await response.text();\n console.error(`❌ [Discord] Welcome message posting failed with status ${response.status}`);\n console.error(`❌ [Discord] Error response body:`, errorText);\n throw new Error(`Discord API error: ${response.status} - ${errorText}`);\n }\n\n const messageResponse = await response.json();\n console.log(`✅ [Discord] Welcome message posted successfully!`);\n console.log(`📋 [Discord] Message ID: ${messageResponse.id}`);\n } catch (error) {\n console.error(`💥 [Discord] Exception during welcome message:`, error);\n console.error(`💥 [Discord] Error type:`, error.constructor.name);\n console.error(`💥 [Discord] Error message:`, error.message);\n if (error.stack) {\n console.error(`💥 [Discord] Stack trace:`, error.stack);\n }\n\n // Don't throw here - we don't want to fail the entire submission if welcome message fails\n console.log(`🔄 [Discord] Continuing despite welcome message failure`);\n }\n}\n\n// Dynamic location routing - handles paths like /SF, /LA, /NYC\n// Place this at the end to avoid conflicts with API routes\napp.get(\"/:location\", async c => {\n const location = c.req.param(\"location\").toUpperCase();\n \n // Check if it's a supported location\n if (SUPPORTED_LOCATIONS.includes(location)) {\n // Read the HTML file and inject location data\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // Inject location data as a script tag before the main app script\n const locationScript = `\n `;\n \n html = html.replace(\n '',\n `${locationScript}\\n `\n );\n \n return c.html(html);\n } else {\n // Fallback for unrecognized paths - serve default page\n const html = await readFile(\"/frontend/index.html\", import.meta.url);\n return c.html(html);\n }\n});\n\nexport default app.fetch;","deleted","label",[170,154],"backend","permalink","https://www.val.town/x/colel/rust-coasts-new-community-form/code/backend/index.ts","extension","actionData","errors"]