\r\n

⚠️ Database Error

\r\n

Unable to load dashboard data. Please check if the database is initialized.

\r\n ← Back to Quiz\r\n

\r\n \r\n \r\n `, 500);\r\n }\r\n});\r\n\r\n// API endpoint for JSON data\r\napp.get(\"/api/data\", async c => {\r\n try {\r\n const submissionsResult = await sqlite.execute(`\r\n SELECT \r\n id,\r\n email,\r\n primary_archetype,\r\n breakdown,\r\n completion_time,\r\n timestamp,\r\n user_agent\r\n FROM ${TABLE_NAME}\r\n ORDER BY timestamp DESC\r\n LIMIT 100\r\n `);\r\n const submissions = Array.isArray(submissionsResult) ? submissionsResult : [];\r\n\r\n return c.json({\r\n submissions,\r\n total: submissions.length,\r\n generatedAt: new Date().toISOString()\r\n });\r\n } catch (error) {\r\n return c.json({ error: \"Failed to fetch data\" }, 500);\r\n }\r\n});\r\n\r\n// Export individual submission data\r\napp.get(\"/api/export\", async c => {\r\n try {\r\n const submissionsResult = await sqlite.execute(`\r\n SELECT \r\n email,\r\n primary_archetype,\r\n breakdown,\r\n completion_time,\r\n timestamp\r\n FROM ${TABLE_NAME}\r\n ORDER BY timestamp DESC\r\n `);\r\n const submissions = Array.isArray(submissionsResult) ? submissionsResult : [];\r\n\r\n const csv = generateCSV(submissions);\r\n \r\n return c.text(csv, 200, {\r\n 'Content-Type': 'text/csv',\r\n 'Content-Disposition': 'attachment; filename=\"quiz-submissions.csv\"'\r\n });\r\n } catch (error) {\r\n return c.json({ error: \"Failed to export data\" }, 500);\r\n }\r\n});\r\n\r\nfunction generateDashboardHTML(stats: any[], submissions: any[], total: number, currentPage: number, totalPages: number): string {\r\n return `\r\n \r\n \r\n \r\n \r\n \r\n Admin Dashboard - Social Archetype Quiz\r\n \r\n \r\n \r\n

\r\n \r\n \r\n

\r\n ${stats.map(stat => `\r\n

\r\n

${stat.primary_archetype}

\r\n

${stat.count}

\r\n

Avg: ${stat.avg_completion_time ? Math.round(stat.avg_completion_time / 1000) + 's' : 'N/A'}

\r\n

\r\n `).join('')}\r\n

\r\n \r\n

\r\n

Recent Submissions

\r\n 📥 Export CSV\r\n

\r\n \r\n

\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n ${submissions.map(sub => {\r\n const breakdown = JSON.parse(sub.breakdown || '{}');\r\n const topArchetypes = Object.entries(breakdown)\r\n .sort(([,a], [,b]) => (b as number) - (a as number))\r\n .slice(0, 2)\r\n .map(([arch, pct]) => `${arch.split(' ')[1] || arch}: ${pct}%`)\r\n .join(', ');\r\n \r\n return `\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n `;\r\n }).join('')}\r\n \r\n

ID	Email	Archetype	Completion	Timestamp	Breakdown
${sub.id}	${sub.email}	${sub.primary_archetype}	${sub.completion_time ? Math.round(sub.completion_time / 1000) + 's' : 'N/A'}	${new Date(sub.timestamp).toLocaleDateString()} ${new Date(sub.timestamp).toLocaleTimeString()}	${topArchetypes}

\r\n

\r\n \r\n ${totalPages > 1 ? `\r\n

\r\n ${currentPage > 1 ? `← Previous` : ''}\r\n ${Array.from({length: Math.min(5, totalPages)}, (_, i) => {\r\n const page = i + 1;\r\n return page === currentPage \r\n ? `${page}`\r\n : `${page}`;\r\n }).join('')}\r\n ${currentPage < totalPages ? `Next →` : ''}\r\n

\r\n ` : ''}\r\n \r\n

\r\n ← Back to Quiz\r\n

\r\n

\r\n \r\n \r\n `;\r\n}\r\n\r\nfunction generateCSV(submissions: any[]): string {\r\n const headers = ['Email', 'Primary Archetype', 'Completion Time (ms)', 'Timestamp', 'Breakdown'];\r\n const rows = submissions.map(sub => [\r\n sub.email,\r\n sub.primary_archetype,\r\n sub.completion_time || '',\r\n sub.timestamp,\r\n sub.breakdown\r\n ]);\r\n \r\n return [headers, ...rows]\r\n .map(row => row.map(field => `\"${String(field).replace(/\"/g, '\"\"')}\"`).join(','))\r\n .join('\\n');\r\n}\r\n\r\nexport default app.fetch; ",[],[99],{"_104":223,"_95":224,"_153":225,"_155":-5,"_156":138,"_157":226,"_159":22,"_106":227,"_100":32,"_162":228,"_164":229,"_165":22,"_166":-5,"_167":230,"_98":231},"77a6159a-4d48-11f0-9294-76b3cceeab13","config.ts","77a6164e-4d48-11f0-9294-76b3cceeab13",10,["D",1750363408875],"script","// Configuration file for the Social Archetype Quiz\r\n// Following Val Town best practices for environment configuration\r\n\r\nexport const config = {\r\n // Admin email for notifications (set to null to disable admin notifications)\r\n adminEmail: \"tom@cal.town\", // Change this to your admin email\r\n \r\n // Site configuration\r\n siteUrl: \"https://ssscQuiz.web.val.run\", // Update with your actual Val Town URL\r\n siteName: \"Social Archetype Quiz\",\r\n \r\n // Email configuration\r\n emailConfig: {\r\n fromName: \"Social Archetype Quiz\",\r\n replyTo: \"tom@cal.town\"\r\n },\r\n \r\n // Database configuration\r\n database: {\r\n tableName: \"sssc_quiz_submissions_v1\",\r\n enableIndexes: true\r\n },\r\n \r\n // Security configuration\r\n hashSalt: \"ssscQuiz2025\", // Change this to a unique salt\r\n \r\n // Analytics configuration\r\n analytics: {\r\n enableUserTracking: true,\r\n maxRecentSubmissions: 10\r\n },\r\n \r\n // Feature flags\r\n features: {\r\n enableAdminNotifications: true,\r\n enableCompletionTimeTracking: true,\r\n enableIPHashing: true,\r\n enableUserAgentTracking: true\r\n },\r\n \r\n // Quiz configuration\r\n quiz: {\r\n maxQuestions: 15,\r\n enableRandomization: false,\r\n completionTimeoutMinutes: 30\r\n }\r\n};\r\n\r\n// Environment-specific overrides\r\n// In production, you might want to use environment variables\r\nif (typeof Deno !== \"undefined\" && Deno.env) {\r\n // Override with environment variables if available\r\n if (Deno.env.get(\"ADMIN_EMAIL\")) {\r\n config.adminEmail = Deno.env.get(\"ADMIN_EMAIL\");\r\n }\r\n \r\n if (Deno.env.get(\"SITE_URL\")) {\r\n config.siteUrl = Deno.env.get(\"SITE_URL\");\r\n }\r\n \r\n if (Deno.env.get(\"HASH_SALT\")) {\r\n config.hashSalt = Deno.env.get(\"HASH_SALT\");\r\n }\r\n} ",[],[224],{"_104":233,"_95":234,"_153":235,"_155":-5,"_156":138,"_157":236,"_159":160,"_106":237,"_100":32,"_162":200,"_164":238,"_165":22,"_166":-5,"_167":239,"_98":240},"77aa2fd6-4d48-11f0-970a-76b3cceeab13","deno.json","77aa3094-4d48-11f0-970a-76b3cceeab13",11,["D",1750363408892],"{\n \"$schema\": \"https://raw.githubusercontent.com/denoland/deno/348900b8b79f4a434cab4c74b3bc8d4d2fa8ee74/cli/schemas/config-file.v1.json\",\n \"lock\": false,\n \"compilerOptions\": {\n \"noImplicitAny\": false,\n \"strict\": false,\n \"types\": [\n \"https://www.val.town/types/valtown.d.ts\"\n ],\n \"lib\": [\n \"dom\",\n \"dom.iterable\",\n \"dom.asynciterable\",\n \"deno.ns\",\n \"deno.unstable\"\n ]\n },\n \"lint\": {\n \"files\": {\n \"include\": [\n \"deno:/https/esm.town/**/*\"\n ]\n },\n \"rules\": {\n \"exclude\": [\n \"no-explicit-any\"\n ]\n }\n },\n \"node_modules_dir\": false,\n \"experimental\": {\n \"unstable-node-globals\": true,\n \"unstable-temporal\": true,\n \"unstable-worker-options\": true,\n \"unstable-sloppy-imports\": true\n }\n}",[],[234],{"_104":242,"_95":243,"_153":244,"_155":-5,"_156":138,"_157":245,"_159":22,"_106":246,"_100":32,"_162":218,"_164":247,"_165":22,"_166":248,"_167":249,"_98":250},"77c7f642-4d48-11f0-9bc0-76b3cceeab13","index.http.ts","77c7f700-4d48-11f0-9bc0-76b3cceeab13",12,["D",1750363409097],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\r\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\r\nimport { email } from \"https://esm.town/v/std/email\";\r\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\r\nimport type { QuizResults, QuizSubmission } from \"./shared/types.ts\";\r\nimport { config } from \"./config.ts\";\r\n\r\nconst app = new Hono();\r\n\r\n// Unwrap Hono errors to see original error details\r\napp.onError((err, c) => {\r\n throw err;\r\n});\r\n\r\n// Database setup following Val Town standards\r\nconst TABLE_NAME = 'sssc_quiz_submissions_v1';\r\n\r\n// Initialize database with Val Town best practices\r\nasync function initDatabase() {\r\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\r\n id INTEGER PRIMARY KEY AUTOINCREMENT,\r\n email TEXT NOT NULL,\r\n primary_archetype TEXT NOT NULL,\r\n breakdown TEXT NOT NULL,\r\n answers TEXT NOT NULL,\r\n timestamp DATETIME DEFAULT CURRENT_TIMESTAMP,\r\n completion_time INTEGER,\r\n insights TEXT,\r\n user_agent TEXT,\r\n ip_hash TEXT\r\n )`);\r\n \r\n // Create indexes for better performance\r\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_email ON ${TABLE_NAME}(email)`);\r\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_archetype ON ${TABLE_NAME}(primary_archetype)`);\r\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_timestamp ON ${TABLE_NAME}(timestamp)`);\r\n}\r\n\r\n// Initialize database on startup\r\nawait initDatabase();\r\n\r\n// Serve static files\r\napp.get(\"/frontend/*\", c => serveFile(c.req.path, import.meta.url));\r\napp.get(\"/shared/*\", c => serveFile(c.req.path, import.meta.url));\r\n\r\n// Main route - serve the quiz with initial data\r\napp.get(\"/\", async c => {\r\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\r\n \r\n // Inject any initial data if needed\r\n const dataScript = ``;\r\n\r\n html = html.replace(\"\", `${dataScript}`);\r\n return c.html(html);\r\n});\r\n\r\n// API Routes\r\napp.post(\"/api/submit-quiz\", async c => {\r\n try {\r\n const body = await c.req.json() as QuizSubmission;\r\n const { email, results, answers, completionTime, insights } = body;\r\n\r\n // Validate required fields\r\n if (!email || !results || !answers) {\r\n return c.json({ error: \"Missing required fields\" }, 400);\r\n }\r\n\r\n // Email validation following Val Town standards\r\n const emailRegex = /^[^\\s@]+@[^\\s@]+\\.[^\\s@]+$/;\r\n if (!emailRegex.test(email)) {\r\n return c.json({ error: \"Invalid email address\" }, 400);\r\n }\r\n\r\n // Get user metadata for analytics\r\n const userAgent = c.req.header('user-agent') || '';\r\n const forwarded = c.req.header('x-forwarded-for') || '';\r\n const ipHash = forwarded ? await hashIP(forwarded.split(',')[0].trim()) : '';\r\n\r\n // Store in database following Val Town patterns\r\n await sqlite.execute(\r\n `INSERT INTO ${TABLE_NAME} (\r\n email, primary_archetype, breakdown, answers, \r\n completion_time, insights, user_agent, ip_hash\r\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?)`,\r\n [\r\n email.toLowerCase().trim(),\r\n results.primaryArchetype,\r\n JSON.stringify(results.breakdown),\r\n JSON.stringify(answers),\r\n completionTime || null,\r\n JSON.stringify(insights || {}),\r\n userAgent,\r\n ipHash\r\n ]\r\n );\r\n\r\n // Send email to user with results\r\n await sendResultsEmail(email, results, completionTime);\r\n\r\n // Send notification email to admin (if configured)\r\n if (config.adminEmail) {\r\n await sendAdminNotification(email, results);\r\n }\r\n\r\n return c.json({ \r\n success: true, \r\n message: \"Quiz results submitted successfully and emailed!\" \r\n });\r\n\r\n } catch (error) {\r\n console.error(\"Error submitting quiz:\", error);\r\n return c.json({ error: \"Failed to submit quiz results\" }, 500);\r\n }\r\n});\r\n\r\n// Get analytics endpoint with proper error handling\r\napp.get(\"/api/analytics\", async c => {\r\n try {\r\n const stats = await sqlite.execute(`\r\n SELECT \r\n primary_archetype,\r\n COUNT(*) as count,\r\n ROUND(AVG(completion_time), 2) as avg_completion_time,\r\n MIN(timestamp) as first_submission,\r\n MAX(timestamp) as latest_submission\r\n FROM ${TABLE_NAME} \r\n GROUP BY primary_archetype\r\n ORDER BY count DESC\r\n `);\r\n\r\n const totalSubmissions = await sqlite.execute(\r\n `SELECT COUNT(*) as total FROM ${TABLE_NAME}`\r\n );\r\n\r\n const recentSubmissions = await sqlite.execute(`\r\n SELECT primary_archetype, timestamp, completion_time\r\n FROM ${TABLE_NAME}\r\n ORDER BY timestamp DESC\r\n LIMIT 10\r\n `);\r\n \r\n return c.json({\r\n archetypeDistribution: stats,\r\n totalSubmissions: totalSubmissions[0]?.total || 0,\r\n recentSubmissions,\r\n generatedAt: new Date().toISOString()\r\n });\r\n } catch (error) {\r\n console.error(\"Error fetching analytics:\", error);\r\n return c.json({ error: \"Failed to fetch analytics\" }, 500);\r\n }\r\n});\r\n\r\n// Enhanced email function following Val Town standards\r\nasync function sendResultsEmail(userEmail: string, results: QuizResults, completionTime?: number) {\r\n const completionTimeText = completionTime \r\n ? `Completion time: ${Math.round(completionTime / 1000)} seconds`\r\n : '';\r\n\r\n const topArchetypes = Object.entries(results.breakdown)\r\n .sort(([,a], [,b]) => b - a)\r\n .slice(0, 3)\r\n .map(([archetype, percentage]) => `${archetype}: ${percentage}%`)\r\n .join('\\n');\r\n\r\n // Enhanced HTML email template following Val Town best practices\r\n const htmlTemplate = `\r\n \r\n \r\n \r\n \r\n \r\n Your Social Archetype Results\r\n \r\n \r\n \r\n

\r\n \r\n \r\n

\r\n

Your Primary Archetype: ${results.primaryArchetype}

\r\n

${results.description || 'You have a unique social personality that influences how you connect with others and engage with communities.'}

\r\n

\r\n\r\n

\r\n

📊 Your Results Breakdown:

\r\n

${topArchetypes}

\r\n ${completionTimeText ? `

⏱️ ${completionTimeText}

` : ''}\r\n

\r\n\r\n

🌟 What This Means:

\r\n

Your primary archetype reflects your natural social tendencies
Look for events and communities that align with your archetype
Connect with others who share similar values
Consider how your archetype influences your social interactions

\r\n\r\n

\r\n Take Quiz Again\r\n

\r\n

\r\n\r\n \r\n

\r\n \r\n \r\n `;\r\n\r\n await email({\r\n to: userEmail,\r\n subject: `🎯 Your Social Archetype: ${results.primaryArchetype}`,\r\n html: htmlTemplate,\r\n text: `\r\nYour Social Archetype: ${results.primaryArchetype}\r\n\r\n${results.description || 'You have a unique social personality.'}\r\n\r\nResults Breakdown:\r\n${topArchetypes}\r\n\r\n${completionTimeText}\r\n\r\nWhat This Means:\r\n- Your primary archetype reflects your natural social tendencies\r\n- Look for events and communities that align with your archetype\r\n- Connect with others who share similar values\r\n- Consider how your archetype influences your social interactions\r\n\r\nThank you for taking the Social Archetype Quiz!\r\n `\r\n });\r\n}\r\n\r\n// Enhanced admin notification following Val Town patterns\r\nasync function sendAdminNotification(userEmail: string, results: QuizResults) {\r\n if (!config.adminEmail) return;\r\n\r\n await email({\r\n to: config.adminEmail,\r\n subject: `📊 New Quiz Submission: ${results.primaryArchetype}`,\r\n html: `\r\n

\r\n

🎯 New Quiz Submission

\r\n

📧 Email: ${userEmail}

\r\n

🎭 Primary Archetype: ${results.primaryArchetype}

\r\n

📅 Timestamp: ${new Date().toISOString()}

\r\n

\r\n \r\n

📊 Breakdown:

\r\n

${archetype}: ${percentage}%

\r\n

\r\n `,\r\n text: `\r\nNew Quiz Submission\r\n\r\nEmail: ${userEmail}\r\nPrimary Archetype: ${results.primaryArchetype}\r\nBreakdown: ${JSON.stringify(results.breakdown, null, 2)}\r\nTimestamp: ${new Date().toISOString()}\r\n `\r\n });\r\n}\r\n\r\n// Utility function to hash IP for privacy compliance\r\nasync function hashIP(ip: string): Promise {\r\n const encoder = new TextEncoder();\r\n const data = encoder.encode(ip + config.hashSalt);\r\n const hashBuffer = await crypto.subtle.digest('SHA-256', data);\r\n const hashArray = Array.from(new Uint8Array(hashBuffer));\r\n return hashArray.map(b => b.toString(16).padStart(2, '0')).join('').substring(0, 16);\r\n}\r\n\r\n// Export the Hono app as the default export for HTTP val\r\nexport default app.fetch; ","club",[],[243],{"_104":252,"_95":253,"_153":254,"_155":-5,"_156":138,"_157":101,"_159":160,"_106":255,"_100":208,"_162":218,"_164":256,"_165":22,"_166":-5,"_167":257,"_98":258},"77d2063c-4d48-11f0-8efa-76b3cceeab13","main.tsx","58feef2a-4d45-11f0-91f7-76b3cceeab13",["D",1750363409161],"// This file now redirects to the new HTTP val structure following Val Town best practices\n// The main application is now in index.http.ts and admin dashboard is in admin.http.ts\nexport { default } from \"./index.http.ts\";",[],[253],"files",[150,170,178,186,194,204,213,222,232,241,251],"counts",{"_263":32,"_264":265,"_266":32,"_267":208},"pulls","branches",1,"forks","envVars","contents",[],{"_104":214,"_95":99,"_153":215,"_155":-5,"_156":138,"_157":216,"_159":22,"_106":271,"_100":32,"_162":218,"_164":219,"_165":22,"_166":-5,"_98":272},["D",1750363408808],[99],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.branch.$branch.version.$version.code.$",{"_93":94,"_95":96,"_97":43,"_100":101,"_98":99,"_102":281,"_148":286,"_259":320,"_200":321,"_268":323,"_324":-5,"_325":22,"_326":-5,"_327":-5,"_328":-5,"_329":330},{"_104":105,"_95":96,"_106":282,"_108":-5,"_109":22,"_110":111,"_112":-5,"_113":-5,"_14":114,"_115":-5,"_116":22,"_117":-5,"_118":32,"_16":119,"_120":121,"_122":121,"_123":124,"_125":124,"_126":124,"_127":121,"_128":121,"_23":283,"_132":284,"_135":285,"_147":22},["D",1750362068477],{"_93":94,"_130":131},{"_93":94,"_134":131},{"_100":137,"_95":43,"_104":138,"_139":105,"_140":-5,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":96,"_146":94},[287,290,293,296,299,302,305,308,311,314,317],{"_104":151,"_95":152,"_153":154,"_155":-5,"_156":138,"_157":158,"_159":160,"_106":161,"_100":32,"_162":163,"_164":-5,"_165":22,"_166":-5,"_167":288,"_98":289},[],[152],{"_104":171,"_95":172,"_153":173,"_155":-5,"_156":138,"_157":174,"_159":160,"_106":175,"_100":32,"_162":163,"_164":-5,"_165":22,"_166":-5,"_167":291,"_98":292},[],[172],{"_104":179,"_95":180,"_153":181,"_155":-5,"_156":138,"_157":182,"_159":160,"_106":183,"_100":32,"_162":163,"_164":-5,"_165":22,"_166":-5,"_167":294,"_98":295},[],[180],{"_104":187,"_95":188,"_153":189,"_155":-5,"_156":138,"_157":190,"_159":160,"_106":191,"_100":32,"_162":163,"_164":-5,"_165":22,"_166":-5,"_167":297,"_98":298},[],[188],{"_104":195,"_95":196,"_153":197,"_155":-5,"_156":138,"_157":198,"_159":160,"_106":199,"_100":32,"_162":200,"_164":201,"_165":22,"_166":-5,"_167":300,"_98":301},[],[196],{"_104":205,"_95":206,"_153":207,"_155":-5,"_156":138,"_157":208,"_159":22,"_106":209,"_100":32,"_162":200,"_164":210,"_165":22,"_166":-5,"_167":303,"_98":304},[],[206],{"_104":214,"_95":99,"_153":215,"_155":-5,"_156":138,"_157":216,"_159":22,"_106":217,"_100":32,"_162":218,"_164":219,"_165":22,"_166":-5,"_167":306,"_98":307},[],[99],{"_104":223,"_95":224,"_153":225,"_155":-5,"_156":138,"_157":226,"_159":22,"_106":227,"_100":32,"_162":228,"_164":229,"_165":22,"_166":-5,"_167":309,"_98":310},[],[224],{"_104":233,"_95":234,"_153":235,"_155":-5,"_156":138,"_157":236,"_159":160,"_106":237,"_100":32,"_162":200,"_164":238,"_165":22,"_166":-5,"_167":312,"_98":313},[],[234],{"_104":242,"_95":243,"_153":244,"_155":-5,"_156":138,"_157":245,"_159":22,"_106":246,"_100":32,"_162":218,"_164":247,"_165":22,"_166":248,"_167":315,"_98":316},[],[243],{"_104":252,"_95":253,"_153":254,"_155":-5,"_156":138,"_157":101,"_159":160,"_106":255,"_100":208,"_162":218,"_164":256,"_165":22,"_166":-5,"_167":318,"_98":319},[],[253],[287,290,293,296,299,302,305,308,311,314,317],{"_104":214,"_95":99,"_153":215,"_155":-5,"_156":138,"_157":216,"_159":22,"_106":271,"_100":32,"_162":218,"_164":219,"_165":22,"_166":-5,"_98":322},[99],[],"upstream","showCompareCallout","pull","ahead","behind","templates",[],"actionData","errors"]

⚠️ Database Error

📊 Admin Dashboard

${stat.primary_archetype}

Recent Submissions

🎯 Your Social Archetype Results

${results.primaryArchetype}

Your Primary Archetype: ${results.primaryArchetype}

📊 Your Results Breakdown:

🌟 What This Means:

🎯 New Quiz Submission

📊 Breakdown: