[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_314":315,"_316":317},"routes/_app.x.$handle.$name",{"_95":94,"_31":44,"_103":85,"_26":104,"_13":14,"_105":-5,"_11":106,"_107":108,"_109":110,"_111":112,"_113":114,"_20":-5,"_115":-5,"_116":-5,"_117":24,"_118":119,"_120":57,"_121":-5,"_122":-5,"_123":124},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_31":44,"_37":45,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":57,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":78,"_79":80,"_81":82,"_83":24},"version",9,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":24},"previous","deleted",false,"deletedHere","path","frontend/components/EventCreation.tsx","latestPath","fileId","0d97ee1c-5dce-11f0-92a2-0224a6c84d84","name","EventCreation.tsx","fileType","script","content","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\n\ninterface EventCreationProps {\n onEventCreated: (eventId: number) => void;\n}\n\nexport default function EventCreation({ onEventCreated }: EventCreationProps) {\n const [formData, setFormData] = useState({\n name: '',\n password: '',\n location: '',\n csvContent: ''\n });\n const [isSubmitting, setIsSubmitting] = useState(false);\n const [error, setError] = useState(null);\n const [csvErrors, setCsvErrors] = useState([]);\n\n const handleFileUpload = (event: React.ChangeEvent) => {\n const file = event.target.files?.[0];\n if (file) {\n const reader = new FileReader();\n reader.onload = (e) => {\n const content = e.target?.result as string;\n setFormData(prev => ({ ...prev, csvContent: content }));\n };\n reader.readAsText(file);\n }\n };\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n setIsSubmitting(true);\n setError(null);\n setCsvErrors([]);\n\n try {\n const response = await fetch('/api/events', {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json',\n },\n body: JSON.stringify(formData),\n });\n\n const result = await response.json();\n\n if (!response.ok) {\n if (result.csvErrors) {\n setCsvErrors(result.csvErrors);\n }\n throw new Error(result.error || 'Failed to create event');\n }\n\n // Show success and redirect\n onEventCreated(result.eventId);\n } catch (err) {\n setError(err instanceof Error ? err.message : 'An error occurred');\n } finally {\n setIsSubmitting(false);\n }\n };\n\n return (\n

\n Create New Event\n

\n Set up your event and upload attendee list\n

\n\n

\n \n Event Name *\n \n setFormData(prev => ({ ...prev, name: e.target.value }))}\n className=\"w-full px-3 py-2 border border-[var(--border-default)] rounded-md focus:outline-none focus:ring-2 focus:ring-[var(--accent-primary)] focus:border-transparent\"\n placeholder=\"Enter event name\"\n />\n

\n\n

\n \n Management Password *\n \n setFormData(prev => ({ ...prev, password: e.target.value }))}\n className=\"w-full px-3 py-2 border border-[var(--border-default)] rounded-md focus:outline-none focus:ring-2 focus:ring-[var(--accent-primary)] focus:border-transparent\"\n placeholder=\"Enter password for event management\"\n />\n

\n This password will be required to access analytics and export data\n

\n\n

\n \n Location\n \n setFormData(prev => ({ ...prev, location: e.target.value }))}\n className=\"w-full px-3 py-2 border border-[var(--border-default)] rounded-md focus:outline-none focus:ring-2 focus:ring-[var(--accent-primary)] focus:border-transparent\"\n placeholder=\"Enter event location (optional)\"\n />\n

\n\n

\n \n Attendee List (CSV) *\n \n \n

Upload a CSV file with attendee names. Supported column headers:

name, Name, full_name
first_name + last_name (will be combined)
id (optional, for external reference)

\n\n {formData.csvContent && (\n

\n CSV loaded: {formData.csvContent.split('\\n').length - 1} rows\n

\n )}\n\n {csvErrors.length > 0 && (\n

CSV Parsing Issues:

• {error}

\n )}\n\n {error && (\n

{error}

\n )}\n\n \n {isSubmitting ? 'Creating Event...' : 'Create Event'}\n \n \n

\n\n

What happens next?

1. Your event will be created with the uploaded attendee list

2. You'll be redirected to the management dashboard

3. Share the sign-in link with your attendees

4. Monitor check-ins and export data as needed

\n );\n}","createdAt",["D",1752180002112],"branchVersion","branchId","24ee5ca6-5dcc-11f0-990d-0224a6c84d84","id","24ebbe74-5dcc-11f0-990d-0224a6c84d84","rust-nyc-event-signin",["D",1752179182252],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","c821e8f7-4cc4-4c23-96f1-319b8f33d4b7","pinnedFileId","bf0d74d5-88e6-41c6-8cbc-04803a89034b","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","6b193d60-e165-45a9-869c-c3f886455f3e","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_95":94,"_102":98},"org",{"_95":94,"_96":-5,"_97":98,"_18":53,"_99":100,"_101":24},"branch",{"_13":84,"_31":85,"_42":41,"_86":43,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":44,"_93":94},"isOwned",60,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","colel","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJ6RVZCOExVNXBIT3FrVDh5a0VZQTNRRG5ycCJ9","tier","pro","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_42":43,"_31":44,"_37":310,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":57,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":311,"_79":312,"_81":313,"_83":24},"tree",[202,204,212,214,215,216,217,218,219],"files",[202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219],"counts",{"_192":61,"_193":139,"_194":61,"_195":196,"_197":198},"contents",[126,127,128,129,130,131,132,133,134],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{"_55":125},"checkin.rustcoasts.com",{"_42":187,"_31":188,"_29":189,"_138":-5,"_40":41,"_39":139,"_140":57,"_37":190,"_13":61,"_33":180,"_35":-5,"_23":24,"_142":-5,"_26":191},{"_42":182,"_31":183,"_29":184,"_138":-5,"_40":41,"_39":139,"_140":57,"_37":185,"_13":61,"_33":180,"_35":-5,"_23":24,"_142":-5,"_26":186},{"_42":176,"_31":177,"_29":178,"_138":-5,"_40":41,"_39":139,"_140":57,"_37":179,"_13":61,"_33":180,"_35":-5,"_23":24,"_142":-5,"_26":181},{"_42":170,"_31":171,"_29":172,"_138":-5,"_40":41,"_39":139,"_140":57,"_37":173,"_13":61,"_33":20,"_35":174,"_23":24,"_142":-5,"_26":175},{"_42":164,"_31":165,"_29":166,"_138":-5,"_40":41,"_39":139,"_140":24,"_37":167,"_13":61,"_33":20,"_35":168,"_23":24,"_142":-5,"_26":169},{"_42":158,"_31":159,"_29":160,"_138":-5,"_40":41,"_39":139,"_140":24,"_37":161,"_13":61,"_33":20,"_35":162,"_23":24,"_142":-5,"_26":163},{"_42":150,"_31":151,"_29":152,"_138":-5,"_40":41,"_39":153,"_140":24,"_37":154,"_13":155,"_33":20,"_35":156,"_23":24,"_142":-5,"_26":157},{"_42":144,"_31":145,"_29":146,"_138":-5,"_40":41,"_39":139,"_140":57,"_37":147,"_13":61,"_33":20,"_35":148,"_23":24,"_142":-5,"_26":149},{"_42":135,"_31":136,"_29":137,"_138":-5,"_40":41,"_39":139,"_140":57,"_37":141,"_13":61,"_33":34,"_35":104,"_23":24,"_142":-5,"_26":143},"24f4a624-5dcc-11f0-990d-0224a6c84d84","main.tsx","e023ccd1-1f70-4b8e-95a2-f4cee096c24a","parentId",1,"latest",["D",1752179182252],"label",[136],"24f4a390-5dcc-11f0-990d-0224a6c84d84","deno.json","79824279-2b5e-4e34-91ae-01f282ccb99a",["D",1752179182252],"{\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}",[145],"a94676ae-5dcd-11f0-9a05-0224a6c84d84","README.md","42873017-f980-4b1a-888b-d23c1db6f951",5,["D",1752179833802],4,"# Event Check-in System\n\nA complete event check-in system for managing attendee sign-ins with secure name verification.\n\n## Features\n\n- **Event Management**: Create events with attendee lists and password protection\n- **Secure Check-in**: Fuzzy search-based sign-in with name verification\n- **Analytics Dashboard**: Track check-ins with date-based analytics\n- **CSV Import/Export**: Import attendee lists and export check-in data\n- **Responsive UI**: Clean, modern interface built with React and TailwindCSS\n\n## How It Works\n\n1. **Event Creation**: Organizers create events with attendee lists via CSV upload\n2. **Attendee Sign-in**: Attendees use fuzzy search to find and check in with their names\n3. **Data Tracking**: System tracks all check-ins with timestamps\n4. **Analytics**: Organizers can view check-in analytics and export data\n5. **Security**: No sensitive information exposed, password-protected management\n\n## Project Structure\n\n```\n├── backend/\n│ └── index.ts # Main API server with Hono\n├── frontend/\n│ ├── index.html # Main HTML template\n│ ├── index.tsx # React app entry point\n│ └── components/\n│ ├── App.tsx # Main app component\n│ ├── EventSignIn.tsx # Sign-in component with fuzzy search\n│ ├── EventManagement.tsx # Management dashboard\n│ └── EventCreation.tsx # Event creation form\n├── shared/\n│ └── types.ts # Shared TypeScript types\n└── README.md\n```\n\n## Setup\n\n### Environment Variables\n\nNo external API keys required for basic functionality. Optional Discord integration available for future features.\n\n### Database\n\nThe system uses SQLite with the following schema:\n\n```sql\n-- Events table\nCREATE TABLE events_1 (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n password_hash TEXT NOT NULL,\n location TEXT,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n);\n\n-- Attendees table \nCREATE TABLE attendees_1 (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n event_id INTEGER NOT NULL,\n name TEXT NOT NULL,\n external_id TEXT,\n FOREIGN KEY (event_id) REFERENCES events_1(id)\n);\n\n-- Check-ins table\nCREATE TABLE checkins_1 (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n event_id INTEGER NOT NULL,\n attendee_id INTEGER NOT NULL,\n checked_in_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (event_id) REFERENCES events_1(id),\n FOREIGN KEY (attendee_id) REFERENCES attendees_1(id)\n);\n```\n\n## API Endpoints\n\n- `POST /api/events` - Create a new event\n- `GET /api/events/:eventId` - Get event details (password protected)\n- `POST /api/events/:eventId/signin` - Sign in to an event\n- `GET /api/events/:eventId/attendees` - Get attendee list for sign-in (names only)\n- `GET /api/events/:eventId/analytics` - Get check-in analytics (password protected)\n- `GET /api/events/:eventId/export` - Export check-in data as CSV (password protected)\n\n## Routes\n\n- `/` - Home page with event creation\n- `/events/new` - Event creation form\n- `/events/:eventId/signin` - Event sign-in page\n- `/events/:eventId/manage` - Event management dashboard (password protected)\n\n## Usage\n\n### Creating an Event\n1. Navigate to the event creation page\n2. Enter event name, password, and location\n3. Upload a CSV file with attendee names\n4. System will parse the CSV and create the event\n\n### Attendee Sign-in\n1. Navigate to the event sign-in page\n2. Use fuzzy search to find your name\n3. Click to sign in\n4. Confirmation displayed\n\n### Event Management\n1. Navigate to the management page\n2. Enter event password\n3. View analytics and export data\n\n## CSV Format\n\nThe system accepts flexible CSV formats with attendee names. Common column headers recognized:\n- `name`, `Name`, `NAME`\n- `full_name`, `Full Name`, `FULL_NAME`\n- `first_name` + `last_name` (will be combined)\n- `given_name` + `family_name` (will be combined)\n\nAdditional columns like `id`, `email`, etc. are preserved but not displayed to attendees.\n\n## Tech Stack\n\n- **Backend**: Hono (API framework)\n- **Frontend**: React 18.2.0 with TypeScript\n- **Database**: SQLite\n- **Styling**: TailwindCSS\n- **Platform**: Val Town (Deno runtime)",[151],"24f498dc-5dcc-11f0-990d-0224a6c84d84","BRAND_STYLE_GUIDE.md","f62e1973-51a2-4b2d-8b12-9f0b8f854b28",["D",1752179182252],"# Brand Style Guide\n## Rust NYC Discord Bot - Talk Submission System\n\n### Overview\nA nostalgic minimal, slightly technical theme that evokes the feeling of early computing interfaces while maintaining modern usability and accessibility.\n\n### Typography\n- **Headings**: Instrument Serif (Google Web Fonts) - Elegant, slightly humanistic serif for warmth\n- **Body Text**: System monospace stack for technical authenticity\n- **Code/Data**: Monospace for technical content and data display\n\n### Color Palette\n```\n// Primary - Muted technical grays and warm accents\n--bg-primary: #f8f9fa // Soft off-white background\n--bg-secondary: #e9ecef // Subtle gray for cards\n--bg-tertiary: #dee2e6 // Light gray for inputs\n\n--text-primary: #2d3748 // Dark gray for primary text\n--text-secondary: #4a5568 // Medium gray for secondary text\n--text-muted: #718096 // Light gray for muted text\n\n--accent-primary: #d69e2e // Warm amber for primary actions\n--accent-secondary: #b7791f // Darker amber for hover states\n--accent-subtle: #faf089 // Light amber for subtle highlights\n\n--border-default: #cbd5e0 // Default border color\n--border-focus: #d69e2e // Amber focus borders\n\n// Status colors\n--success: #38a169 // Muted green\n--error: #e53e3e // Muted red\n--warning: #dd6b20 // Muted orange\n--info: #3182ce // Muted blue\n```\n\n### Layout & Spacing\n- **Container**: Max-width 480px for mobile-first, intimate feel\n- **Spacing Scale**: 4px base unit (4, 8, 12, 16, 24, 32, 48, 64)\n- **Border Radius**: 4px for subtle roundness\n- **Borders**: 1px solid borders throughout\n\n### Components\n\n#### Cards\n- Background: `--bg-secondary`\n- Border: 1px solid `--border-default`\n- Padding: 24px\n- Border radius: 4px\n- Subtle drop shadow\n\n#### Forms\n- Input borders: 1px solid `--border-default`\n- Focus state: 2px solid `--accent-primary`\n- Monospace font for consistency\n- Generous padding (12px)\n\n#### Buttons\n- Primary: `--accent-primary` background, dark text\n- Secondary: `--bg-tertiary` background, dark text\n- Padding: 12px 24px\n- Border radius: 4px\n- Monospace font\n\n#### Typography Scale\n- H1: 24px / text-2xl (primary headings)\n- H2: 20px / text-xl (section headings) \n- H3: 18px / text-lg (subsection headings)\n- Body: 14px / text-sm (main content)\n- Small: 12px / text-xs (captions, metadata)\n\n**Important**: All headings using Instrument Serif (.font-heading) must be sized at text-2xl (24px) or larger to ensure proper readability and visual hierarchy. The serif font performs best at larger sizes and maintains the technical aesthetic when prominently displayed.\n\n### Design Principles\n1. **Functional Beauty**: Every element serves a purpose\n2. **Technical Authenticity**: Embrace monospace and structured layouts\n3. **Nostalgic Warmth**: Subtle amber accents and serif headings\n4. **Accessibility First**: High contrast, clear focus states\n5. **Mobile Responsive**: Single-column layouts, touch-friendly sizing\n\n### Implementation Notes\n- Use CSS custom properties for consistency\n- Maintain semantic HTML structure\n- Progressive enhancement approach\n- Dark mode consideration for future iterations\n",[159],"24f49710-5dcc-11f0-990d-0224a6c84d84","AGENT.md","5c0f5147-120c-4773-8a71-12c12610be9d",["D",1752179182252],"# Agent Configuration for Talk Submission System\n\n## Commands\n- **No explicit test/lint commands** - Val Town platform handles these automatically\n- **Development**: Val Town auto-deploys on changes, no local build needed\n- **Database**: SQLite migrations run automatically on startup in backend/index.ts\n\n## Architecture\n- **Val Town Project**: Deno-based Discord bot for talk submissions with React frontend\n- **Backend**: Hono API server (backend/index.ts) handling submissions and Discord integration\n- **Frontend**: React 18.2.0 with TypeScript (frontend/index.tsx, components/)\n- **Database**: SQLite with talk submissions table (talk_submissions_3)\n- **Discord Integration**: Bot creates channels, sends notifications, generates invite links\n- **Shared**: TypeScript types and utilities (shared/types.ts)\n\n## Discord API Design Notes\n- **Role Mentions**: Use `<@&ROLE_ID>` format in message content\n- **User Mentions**: Use `<@USER_ID>` format in message content\n- **Channel Mentions**: Use `<#CHANNEL_ID>` format in message content\n- **Special Mentions**: `@everyone` and `@here` work as plain text (no ID needed)\n- **Permissions**: Role must be mentionable OR bot needs \"Mention Everyone\" permission\n\n## Code Style (from .cursorrules)\n- **Language**: TypeScript/TSX with React 18.2.0\n- **Imports**: Use `https://esm.sh` for npm packages, pin React to 18.2.0\n- **Types**: Add TypeScript types for all data structures\n- **Secrets**: Always use environment variables, never hardcode secrets\n- **JSX**: Start React files with `/** @jsxImportSource https://esm.sh/react@18.2.0 */`\n- **Styling**: Default to TailwindCSS via CDN script tag\n- **Error Handling**: Let errors bubble up with context, avoid empty catch blocks\n- **Database**: Change table names (e.g., _3, _4) when modifying schemas instead of ALTER TABLE\n- **Platform**: Use Val Town utils for file operations (readFile, serveFile)\n",[165],"24f49468-5dcc-11f0-990d-0224a6c84d84",".vtignore","901592b5-6995-4c7d-9998-1a9a3494fa4f",["D",1752179182252],".git\n.vscode\n.cursorrules\n.DS_Store\nnode_modules\nvendor",[171],"24f4917a-5dcc-11f0-990d-0224a6c84d84","shared","249162fd-4a26-4e4e-9a16-3b2196631f7f",["D",1752179182252],"directory",[177],"24f48d6a-5dcc-11f0-990d-0224a6c84d84","frontend","f7c3a099-146d-441e-9d3b-936fecd56523",["D",1752179182252],[183],"24f47172-5dcc-11f0-990d-0224a6c84d84","backend","ab3f0ddd-bf40-418f-aee1-1e6f03b7f261",["D",1752179182252],[188],"pulls","branches","forks","envVars",{"_199":61,"_201":61},"connections",{"_199":61,"_200":61},"count","unfilledCount","emptyCount",{"_42":187,"_31":188,"_29":189,"_138":-5,"_40":41,"_39":139,"_140":57,"_37":307,"_13":61,"_33":180,"_35":-5,"_23":24,"_142":-5,"_221":308,"_26":309},{"_42":299,"_31":300,"_29":55,"_138":189,"_40":41,"_39":301,"_140":24,"_37":302,"_13":139,"_33":303,"_35":304,"_23":24,"_142":-5,"_221":305,"_26":306},{"_42":182,"_31":183,"_29":184,"_138":-5,"_40":41,"_39":139,"_140":57,"_37":296,"_13":61,"_33":180,"_35":-5,"_23":24,"_142":-5,"_221":297,"_26":298},{"_42":292,"_31":272,"_29":267,"_138":184,"_40":41,"_39":139,"_140":57,"_37":293,"_13":61,"_33":180,"_35":-5,"_23":24,"_142":-5,"_221":294,"_26":295},{"_42":284,"_31":285,"_29":286,"_138":267,"_40":41,"_39":287,"_140":24,"_37":288,"_13":139,"_33":34,"_35":289,"_23":24,"_142":-5,"_221":290,"_26":291},{"_42":280,"_31":32,"_29":30,"_138":267,"_40":41,"_39":14,"_140":24,"_37":281,"_13":61,"_33":34,"_35":36,"_23":24,"_142":-5,"_221":282,"_26":283},{"_42":273,"_31":274,"_29":275,"_138":267,"_40":41,"_39":139,"_140":24,"_37":276,"_13":61,"_33":34,"_35":277,"_23":24,"_142":-5,"_221":278,"_26":279},{"_42":264,"_31":265,"_29":266,"_138":267,"_40":41,"_39":139,"_140":24,"_37":268,"_13":61,"_33":34,"_35":269,"_23":24,"_142":-5,"_221":270,"_26":271},{"_42":257,"_31":258,"_29":259,"_138":184,"_40":41,"_39":139,"_140":57,"_37":260,"_13":61,"_33":20,"_35":261,"_23":24,"_142":-5,"_221":262,"_26":263},{"_42":250,"_31":251,"_29":252,"_138":184,"_40":41,"_39":139,"_140":57,"_37":253,"_13":61,"_33":34,"_35":254,"_23":24,"_142":-5,"_221":255,"_26":256},{"_42":176,"_31":177,"_29":178,"_138":-5,"_40":41,"_39":139,"_140":57,"_37":247,"_13":61,"_33":180,"_35":-5,"_23":24,"_142":-5,"_221":248,"_26":249},{"_42":239,"_31":240,"_29":241,"_138":178,"_40":41,"_39":242,"_140":24,"_37":243,"_13":139,"_33":34,"_35":244,"_23":24,"_142":-5,"_221":245,"_26":246},{"_42":170,"_31":171,"_29":172,"_138":-5,"_40":41,"_39":139,"_140":57,"_37":236,"_13":61,"_33":20,"_35":174,"_23":24,"_142":-5,"_221":237,"_26":238},{"_42":164,"_31":165,"_29":166,"_138":-5,"_40":41,"_39":139,"_140":24,"_37":233,"_13":61,"_33":20,"_35":168,"_23":24,"_142":-5,"_221":234,"_26":235},{"_42":158,"_31":159,"_29":160,"_138":-5,"_40":41,"_39":139,"_140":24,"_37":230,"_13":61,"_33":20,"_35":162,"_23":24,"_142":-5,"_221":231,"_26":232},{"_42":150,"_31":151,"_29":152,"_138":-5,"_40":41,"_39":153,"_140":24,"_37":227,"_13":155,"_33":20,"_35":156,"_23":24,"_142":-5,"_221":228,"_26":229},{"_42":144,"_31":145,"_29":146,"_138":-5,"_40":41,"_39":139,"_140":57,"_37":224,"_13":61,"_33":20,"_35":148,"_23":24,"_142":-5,"_221":225,"_26":226},{"_42":135,"_31":136,"_29":137,"_138":-5,"_40":41,"_39":139,"_140":57,"_37":220,"_13":61,"_33":34,"_35":104,"_23":24,"_142":-5,"_221":222,"_26":223},["D",1752179182252],"children",[],[136],["D",1752179182252],[],[145],["D",1752179833802],[],[151],["D",1752179182252],[],[159],["D",1752179182252],[],[165],["D",1752179182252],[],[171],"b4b9f132-5dcd-11f0-89d0-0224a6c84d84","types.ts","41854f24-ad93-4263-a021-d118e1a48743",6,["D",1752179853012],"// Event-related types\nexport interface Event {\n id: number;\n name: string;\n password_hash: string;\n location?: string;\n created_at: string;\n}\n\nexport interface Attendee {\n id: number;\n event_id: number;\n name: string;\n external_id?: string;\n}\n\nexport interface CheckIn {\n id: number;\n event_id: number;\n attendee_id: number;\n checked_in_at: string;\n}\n\n// API request/response types\nexport interface CreateEventRequest {\n name: string;\n password: string;\n location?: string;\n attendees: AttendeeData[];\n}\n\nexport interface AttendeeData {\n name: string;\n external_id?: string;\n}\n\nexport interface CreateEventResponse {\n success: boolean;\n eventId: number;\n}\n\nexport interface SignInRequest {\n attendeeId: number;\n}\n\nexport interface SignInResponse {\n success: boolean;\n attendeeName: string;\n alreadySignedIn?: boolean;\n // TODO: Consider tracking multiple sign-in attempts for security\n // previousSignIns?: CheckIn[];\n}\n\nexport interface EventDetailsResponse {\n event: Event;\n attendeeCount: number;\n checkedInCount: number;\n}\n\nexport interface AttendeeListResponse {\n attendees: Array<{\n id: number;\n name: string;\n checkedIn: boolean;\n }>;\n}\n\nexport interface AnalyticsResponse {\n totalAttendees: number;\n totalCheckedIn: number;\n checkInsByDate: Array<{\n date: string;\n count: number;\n }>;\n recentCheckIns: Array<{\n attendeeName: string;\n checkedInAt: string;\n }>;\n}\n\n// CSV parsing utility types\nexport interface CSVParseResult {\n attendees: AttendeeData[];\n errors: string[];\n totalRows: number;\n validRows: number;\n}",[],[177,240],["D",1752179182252],[213],[177],"24f48bd0-5dcc-11f0-990d-0224a6c84d84","index.tsx","4bc6335a-40c8-456a-9d1d-3d563a8d6076",["D",1752179182252],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport App from \"./components/App.tsx\";\n\nconst root = createRoot(document.getElementById(\"root\")!);\nroot.render();",[],[183,251],"24f489e6-5dcc-11f0-990d-0224a6c84d84","index.html","61e9c2f8-0042-4c00-8701-c41167df44b0",["D",1752179182252],"\n\n\n \n \n Talk Submission Form\n \n \n\n\n

\n \n\n",[],[183,258],"24f481e4-5dcc-11f0-990d-0224a6c84d84","TalkSubmissionForm.tsx","e6b6dee2-23c7-4c69-b25d-2f328968dfc7","793e3aa2-3ca0-43b9-b9ef-e70d5ec5db87",["D",1752179182252],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport type { SubmissionData } from \"./App.tsx\";\n\ninterface TalkSubmissionFormProps {\n onSubmit: (data: SubmissionData) => void;\n isSubmitting: boolean;\n error: string | null;\n}\n\nexport default function TalkSubmissionForm({ onSubmit, isSubmitting, error }: TalkSubmissionFormProps) {\n const [formData, setFormData] = useState({\n speakerName: \"\",\n talkContext: \"\",\n isOnBehalf: false,\n submitterName: \"\",\n });\n\n const handleSubmit = (e: React.FormEvent) => {\n e.preventDefault();\n \n // Basic validation\n if (!formData.speakerName.trim() || !formData.talkContext.trim()) {\n return;\n }\n\n // Validate submitter name if submitting on behalf\n if (formData.isOnBehalf && !formData.submitterName?.trim()) {\n return;\n }\n\n onSubmit(formData);\n };\n\n const handleInputChange = (field: keyof SubmissionData, value: string | boolean) => {\n setFormData(prev => ({\n ...prev,\n [field]: value\n }));\n };\n\n const isFormValid = formData.speakerName.trim() && \n formData.talkContext.trim() && \n (!formData.isOnBehalf || formData.submitterName?.trim());\n\n return (\n

\n {/* Speaker Name */}\n

\n \n Speaker Name *\n \n handleInputChange(\"speakerName\", e.target.value)}\n className=\"w-full px-3 py-2 border border-[var(--border-default)] rounded bg-white font-mono text-sm focus:outline-none focus:border-[var(--accent-primary)] focus:border-2\"\n placeholder=\"Enter the speaker's full name\"\n disabled={isSubmitting}\n />\n

\n\n {/* Talk Context */}\n

\n \n Talk Context *\n \n handleInputChange(\"talkContext\", e.target.value)}\n className=\"w-full px-3 py-2 border border-[var(--border-default)] rounded bg-white font-mono text-sm focus:outline-none focus:border-[var(--accent-primary)] focus:border-2\"\n placeholder=\"Describe the talk topic, key points, target audience, and any other relevant context...\"\n disabled={isSubmitting}\n />\n

\n\n {/* On Behalf Checkbox */}\n

\n handleInputChange(\"isOnBehalf\", e.target.checked)}\n className=\"w-4 h-4 accent-[var(--accent-primary)] bg-white border-[var(--border-default)] rounded focus:ring-2 focus:ring-[var(--accent-primary)]\"\n disabled={isSubmitting}\n />\n

\n \n I am submitting this on behalf of someone else\n \n

\n Check this if you're not the speaker but are submitting for them\n

\n\n {/* Submitter Name - Only show when submitting on behalf */}\n {formData.isOnBehalf && (\n

\n \n Your Name (Submitter) *\n \n handleInputChange(\"submitterName\", e.target.value)}\n className=\"w-full px-3 py-2 border border-[var(--border-default)] rounded bg-white font-mono text-sm focus:outline-none focus:border-[var(--accent-primary)] focus:border-2\"\n placeholder=\"Enter your full name\"\n disabled={isSubmitting}\n />\n

\n Since you're submitting on behalf of the speaker, please provide your name for our records.\n

\n )}\n\n {/* Error Message */}\n {error && (\n

\n ⚠\n

{error}

\n )}\n\n {/* Submit Button */}\n

\n \n {isSubmitting ? (\n <>\n \n Processing Submission...\n \n ) : (\n \"Submit Talk Proposal\"\n )}\n \n

\n\n

\n After submission, a Discord channel will be created for discussion\n and you'll receive an invitation link.\n

\n );\n}",[],[183,272,265],"components","24f47938-5dcc-11f0-990d-0224a6c84d84","SubmissionSuccess.tsx","b18c71c1-9b6e-4526-80a1-21bef4b468f2",["D",1752179182252],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport type { SubmissionResult } from \"./App.tsx\";\n\ninterface SubmissionSuccessProps {\n result: SubmissionResult;\n onReset: () => void;\n}\n\nexport default function SubmissionSuccess({ result, onReset }: SubmissionSuccessProps) {\n const copyInviteLink = async () => {\n try {\n await navigator.clipboard.writeText(result.discordInviteLink);\n // Could add a toast notification here\n } catch (err) {\n console.error(\"Failed to copy link:\", err);\n }\n };\n\n return (\n

\n {/* Success Icon */}\n

\n ✓\n

\n\n {/* Success Message */}\n

\n Submission Successful\n

\n Your talk proposal has been submitted and our organizers have been notified.\n

\n\n {/* Submission Details */}\n

\n Submission ID: #{result.submissionId}\n

\n\n {/* Discord Invite Section */}\n

\n 💬\n

\n Discord Discussion Channel\n

\n \n

\n A dedicated Discord channel has been created for discussing your talk proposal.\n Join the conversation with our organizers!\n

\n\n

\n {/* Invite Link Display */}\n

\n \n {result.discordInviteLink}\n \n \n 📋\n \n

\n\n {/* Action Buttons */}\n

\n \n Join Discord Channel\n \n \n Copy Invite Link\n \n

\n\n {/* Next Steps */}\n

What happens next?

• Our organizers have been notified of your submission
• Join the Discord channel to discuss details
• We'll review your proposal and get back to you soon
• Keep an eye on Discord for updates and questions

\n\n {/* Reset Button */}\n \n Submit Another Talk →\n \n

\n );\n}",[],[183,272,274],"0d97ed86-5dce-11f0-92a2-0224a6c84d84",["D",1752180002112],[],[183,272,32],"f8029cdc-5dcd-11f0-98fc-0224a6c84d84","App.tsx","06c9fc59-0d9d-467a-873e-97706322b720",8,["D",1752179965896],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport EventCreation from \"./EventCreation.tsx\";\nimport EventSignIn from \"./EventSignIn.tsx\";\nimport EventManagement from \"./EventManagement.tsx\";\n\n// Simple client-side routing based on URL path\nfunction useRouter() {\n const [path, setPath] = useState(window.location.pathname);\n \n useEffect(() => {\n const handlePopState = () => setPath(window.location.pathname);\n window.addEventListener('popstate', handlePopState);\n return () => window.removeEventListener('popstate', handlePopState);\n }, []);\n \n const navigate = (newPath: string) => {\n window.history.pushState({}, '', newPath);\n setPath(newPath);\n };\n \n return { path, navigate };\n}\n\nexport default function App() {\n const { path, navigate } = useRouter();\n \n // Parse route parameters\n const getEventId = () => {\n const match = path.match(/\\/events\\/(\\d+)/);\n return match ? parseInt(match[1]) : null;\n };\n \n const renderPage = () => {\n if (path === '/' || path === '/events/new') {\n return navigate(`/events/${eventId}/manage`)} />;\n }\n \n if (path.includes('/signin')) {\n const eventId = getEventId();\n if (!eventId) return

Invalid event ID

;\n return ;\n }\n \n if (path.includes('/manage')) {\n const eventId = getEventId();\n if (!eventId) return

Invalid event ID

;\n return ;\n }\n \n return

Page not found

;\n };\n\n return (\n <>\n \n \n \n \n \n \n

\n {renderPage()}\n

\n \n );\n}",[],[183,272,285],"24f4886a-5dcc-11f0-990d-0224a6c84d84",["D",1752179182252],[206,207,208,209],[183,272],["D",1752179182252],[205,210,211],[183],"df3f2030-5dcd-11f0-b686-0224a6c84d84","index.ts",7,["D",1752179924351],"http","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\";\nimport { getCookie, setCookie } from \"https://esm.sh/hono@3.11.7/cookie\";\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 table names\nconst EVENTS_TABLE = \"events_1\";\nconst ATTENDEES_TABLE = \"attendees_1\"; \nconst CHECKINS_TABLE = \"checkins_1\";\n\n// Initialize database\nasync function initDatabase() {\n console.log(`💾 [DB] Initializing database tables`);\n \n // Events table\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${EVENTS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n password_hash TEXT NOT NULL,\n location TEXT,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )`);\n \n // Attendees table\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${ATTENDEES_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n event_id INTEGER NOT NULL,\n name TEXT NOT NULL,\n external_id TEXT,\n FOREIGN KEY (event_id) REFERENCES ${EVENTS_TABLE}(id)\n )`);\n \n // Check-ins table\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${CHECKINS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n event_id INTEGER NOT NULL,\n attendee_id INTEGER NOT NULL,\n checked_in_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (event_id) REFERENCES ${EVENTS_TABLE}(id),\n FOREIGN KEY (attendee_id) REFERENCES ${ATTENDEES_TABLE}(id)\n )`);\n \n console.log(`✅ [DB] Database initialization complete`);\n}\n\n// Initialize database on startup\nawait initDatabase();\nconsole.log(`🚀 [System] Event check-in system ready!`);\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// Route handlers for different pages\napp.get(\"/events/new\", async c => {\n const html = await readFile(\"/frontend/index.html\", import.meta.url);\n return c.html(html);\n});\n\napp.get(\"/events/:eventId/signin\", async c => {\n const html = await readFile(\"/frontend/index.html\", import.meta.url);\n return c.html(html);\n});\n\napp.get(\"/events/:eventId/manage\", async c => {\n const html = await readFile(\"/frontend/index.html\", import.meta.url);\n return c.html(html);\n});\n\n// Utility functions\nfunction hashPassword(password: string): string {\n // Simple hash for demo - in production, use proper bcrypt or similar\n return btoa(password + \"salt\").replace(/[^a-zA-Z0-9]/g, '');\n}\n\nfunction verifyPassword(password: string, hash: string): boolean {\n return hashPassword(password) === hash;\n}\n\n// CSV parsing utility\nfunction parseCSV(csvContent: string): { attendees: Array<{name: string, external_id?: string}>, errors: string[] } {\n const lines = csvContent.trim().split('\\n');\n const errors: string[] = [];\n const attendees: Array<{name: string, external_id?: string}> = [];\n \n if (lines.length === 0) {\n errors.push(\"CSV file is empty\");\n return { attendees, errors };\n }\n \n // Parse header row\n const headers = lines[0].split(',').map(h => h.trim().toLowerCase().replace(/\"/g, ''));\n console.log(`📋 [CSV] Found headers:`, headers);\n \n // Find name columns - flexible matching\n let nameIndex = -1;\n let firstNameIndex = -1;\n let lastNameIndex = -1;\n let idIndex = -1;\n \n headers.forEach((header, index) => {\n const cleanHeader = header.toLowerCase();\n if (cleanHeader.includes('name') && !cleanHeader.includes('first') && !cleanHeader.includes('last') && !cleanHeader.includes('given') && !cleanHeader.includes('family')) {\n nameIndex = index;\n } else if (cleanHeader.includes('first') || cleanHeader.includes('given')) {\n firstNameIndex = index;\n } else if (cleanHeader.includes('last') || cleanHeader.includes('family') || cleanHeader.includes('surname')) {\n lastNameIndex = index;\n } else if (cleanHeader.includes('id') && !cleanHeader.includes('email')) {\n idIndex = index;\n }\n });\n \n console.log(`📋 [CSV] Column mapping - name: ${nameIndex}, firstName: ${firstNameIndex}, lastName: ${lastNameIndex}, id: ${idIndex}`);\n \n // Process data rows\n for (let i = 1; i < lines.length; i++) {\n const row = lines[i].split(',').map(cell => cell.trim().replace(/\"/g, ''));\n \n if (row.length !== headers.length) {\n errors.push(`Row ${i + 1}: Column count mismatch`);\n continue;\n }\n \n let name = '';\n \n // Extract name using flexible logic\n if (nameIndex >= 0 && row[nameIndex]) {\n name = row[nameIndex];\n } else if (firstNameIndex >= 0 && lastNameIndex >= 0) {\n const firstName = row[firstNameIndex] || '';\n const lastName = row[lastNameIndex] || '';\n name = `${firstName} ${lastName}`.trim();\n } else if (firstNameIndex >= 0) {\n name = row[firstNameIndex];\n }\n \n if (!name) {\n errors.push(`Row ${i + 1}: No name found`);\n continue;\n }\n \n const attendee: {name: string, external_id?: string} = { name };\n \n if (idIndex >= 0 && row[idIndex]) {\n attendee.external_id = row[idIndex];\n }\n \n attendees.push(attendee);\n }\n \n console.log(`📋 [CSV] Parsed ${attendees.length} attendees with ${errors.length} errors`);\n return { attendees, errors };\n}\n\n// API Routes\n\n// Create new event\napp.post(\"/api/events\", async c => {\n console.log(`🎯 [API] New event creation request`);\n \n try {\n const body = await c.req.json();\n const { name, password, location, csvContent } = body;\n \n console.log(`📋 [API] Event details: \"${name}\", location: \"${location || 'N/A'}\"`);\n \n if (!name || !password || !csvContent) {\n return c.json({ error: \"Missing required fields: name, password, csvContent\" }, 400);\n }\n \n // Parse CSV\n const { attendees, errors } = parseCSV(csvContent);\n \n if (attendees.length === 0) {\n return c.json({ error: \"No valid attendees found in CSV\", csvErrors: errors }, 400);\n }\n \n // Create event\n const passwordHash = hashPassword(password);\n const eventResult = await sqlite.execute(\n `INSERT INTO ${EVENTS_TABLE} (name, password_hash, location) VALUES (?, ?, ?)`,\n [name, passwordHash, location || null]\n );\n \n const eventId = Number(eventResult.lastInsertRowid);\n console.log(`✅ [API] Event created with ID: ${eventId}`);\n \n // Insert attendees\n for (const attendee of attendees) {\n await sqlite.execute(\n `INSERT INTO ${ATTENDEES_TABLE} (event_id, name, external_id) VALUES (?, ?, ?)`,\n [eventId, attendee.name, attendee.external_id || null]\n );\n }\n \n console.log(`✅ [API] Added ${attendees.length} attendees to event`);\n \n return c.json({\n success: true,\n eventId,\n attendeeCount: attendees.length,\n csvErrors: errors\n });\n \n } catch (error) {\n console.error(`💥 [API] Error creating event:`, error);\n return c.json({ error: \"Internal server error\" }, 500);\n }\n});\n\n// Get attendee list for sign-in (names only, no sensitive info)\napp.get(\"/api/events/:eventId/attendees\", async c => {\n const eventId = parseInt(c.req.param(\"eventId\"));\n \n try {\n // Get attendees with check-in status\n const attendees = await sqlite.execute(`\n SELECT a.id, a.name, \n CASE WHEN c.id IS NOT NULL THEN 1 ELSE 0 END as checked_in\n FROM ${ATTENDEES_TABLE} a\n LEFT JOIN ${CHECKINS_TABLE} c ON a.id = c.attendee_id\n WHERE a.event_id = ?\n ORDER BY a.name\n `, [eventId]);\n \n return c.json({\n attendees: attendees.map(row => ({\n id: row.id,\n name: row.name,\n checkedIn: Boolean(row.checked_in)\n }))\n });\n \n } catch (error) {\n console.error(`💥 [API] Error fetching attendees:`, error);\n return c.json({ error: \"Internal server error\" }, 500);\n }\n});\n\n// Sign in to event\napp.post(\"/api/events/:eventId/signin\", async c => {\n const eventId = parseInt(c.req.param(\"eventId\"));\n \n try {\n const body = await c.req.json();\n const { attendeeId } = body;\n \n if (!attendeeId) {\n return c.json({ error: \"Attendee ID required\" }, 400);\n }\n \n // Verify attendee belongs to this event\n const attendee = await sqlite.execute(\n `SELECT * FROM ${ATTENDEES_TABLE} WHERE id = ? AND event_id = ?`,\n [attendeeId, eventId]\n );\n \n if (attendee.length === 0) {\n return c.json({ error: \"Attendee not found for this event\" }, 404);\n }\n \n // Check if already signed in\n const existingCheckIn = await sqlite.execute(\n `SELECT * FROM ${CHECKINS_TABLE} WHERE event_id = ? AND attendee_id = ?`,\n [eventId, attendeeId]\n );\n \n if (existingCheckIn.length > 0) {\n console.log(`⚠️ [API] Attendee ${attendee[0].name} already signed in`);\n // TODO: Consider security implications of multiple sign-in attempts\n // For now, we'll allow it but flag it\n return c.json({\n success: true,\n attendeeName: attendee[0].name,\n alreadySignedIn: true,\n message: \"You were already signed in, but we've recorded this additional check-in.\"\n });\n }\n \n // Record check-in\n await sqlite.execute(\n `INSERT INTO ${CHECKINS_TABLE} (event_id, attendee_id) VALUES (?, ?)`,\n [eventId, attendeeId]\n );\n \n console.log(`✅ [API] ${attendee[0].name} signed in to event ${eventId}`);\n \n return c.json({\n success: true,\n attendeeName: attendee[0].name,\n alreadySignedIn: false\n });\n \n } catch (error) {\n console.error(`💥 [API] Error during sign-in:`, error);\n return c.json({ error: \"Internal server error\" }, 500);\n }\n});\n\n// Get event details (password protected)\napp.post(\"/api/events/:eventId/details\", async c => {\n const eventId = parseInt(c.req.param(\"eventId\"));\n \n try {\n const body = await c.req.json();\n const { password } = body;\n \n if (!password) {\n return c.json({ error: \"Password required\" }, 401);\n }\n \n // Get event\n const events = await sqlite.execute(\n `SELECT * FROM ${EVENTS_TABLE} WHERE id = ?`,\n [eventId]\n );\n \n if (events.length === 0) {\n return c.json({ error: \"Event not found\" }, 404);\n }\n \n const event = events[0];\n \n // Verify password\n if (!verifyPassword(password, event.password_hash)) {\n return c.json({ error: \"Invalid password\" }, 401);\n }\n \n // Get counts\n const attendeeCount = await sqlite.execute(\n `SELECT COUNT(*) as count FROM ${ATTENDEES_TABLE} WHERE event_id = ?`,\n [eventId]\n );\n \n const checkedInCount = await sqlite.execute(\n `SELECT COUNT(*) as count FROM ${CHECKINS_TABLE} WHERE event_id = ?`,\n [eventId]\n );\n \n return c.json({\n event: {\n id: event.id,\n name: event.name,\n location: event.location,\n created_at: event.created_at\n },\n attendeeCount: attendeeCount[0].count,\n checkedInCount: checkedInCount[0].count\n });\n \n } catch (error) {\n console.error(`💥 [API] Error fetching event details:`, error);\n return c.json({ error: \"Internal server error\" }, 500);\n }\n});\n\n// Get analytics (password protected)\napp.post(\"/api/events/:eventId/analytics\", async c => {\n const eventId = parseInt(c.req.param(\"eventId\"));\n \n try {\n const body = await c.req.json();\n const { password } = body;\n \n if (!password) {\n return c.json({ error: \"Password required\" }, 401);\n }\n \n // Verify event and password\n const events = await sqlite.execute(\n `SELECT password_hash FROM ${EVENTS_TABLE} WHERE id = ?`,\n [eventId]\n );\n \n if (events.length === 0) {\n return c.json({ error: \"Event not found\" }, 404);\n }\n \n if (!verifyPassword(password, events[0].password_hash)) {\n return c.json({ error: \"Invalid password\" }, 401);\n }\n \n // Get total counts\n const totalAttendees = await sqlite.execute(\n `SELECT COUNT(*) as count FROM ${ATTENDEES_TABLE} WHERE event_id = ?`,\n [eventId]\n );\n \n const totalCheckedIn = await sqlite.execute(\n `SELECT COUNT(*) as count FROM ${CHECKINS_TABLE} WHERE event_id = ?`,\n [eventId]\n );\n \n // Get check-ins by date\n const checkInsByDate = await sqlite.execute(`\n SELECT DATE(checked_in_at) as date, COUNT(*) as count\n FROM ${CHECKINS_TABLE}\n WHERE event_id = ?\n GROUP BY DATE(checked_in_at)\n ORDER BY date\n `, [eventId]);\n \n // Get recent check-ins\n const recentCheckIns = await sqlite.execute(`\n SELECT a.name as attendee_name, c.checked_in_at\n FROM ${CHECKINS_TABLE} c\n JOIN ${ATTENDEES_TABLE} a ON c.attendee_id = a.id\n WHERE c.event_id = ?\n ORDER BY c.checked_in_at DESC\n LIMIT 10\n `, [eventId]);\n \n return c.json({\n totalAttendees: totalAttendees[0].count,\n totalCheckedIn: totalCheckedIn[0].count,\n checkInsByDate: checkInsByDate.map(row => ({\n date: row.date,\n count: row.count\n })),\n recentCheckIns: recentCheckIns.map(row => ({\n attendeeName: row.attendee_name,\n checkedInAt: row.checked_in_at\n }))\n });\n \n } catch (error) {\n console.error(`💥 [API] Error fetching analytics:`, error);\n return c.json({ error: \"Internal server error\" }, 500);\n }\n});\n\n// Export check-in data as CSV (password protected)\napp.post(\"/api/events/:eventId/export\", async c => {\n const eventId = parseInt(c.req.param(\"eventId\"));\n \n try {\n const body = await c.req.json();\n const { password } = body;\n \n if (!password) {\n return c.json({ error: \"Password required\" }, 401);\n }\n \n // Verify event and password\n const events = await sqlite.execute(\n `SELECT password_hash, name FROM ${EVENTS_TABLE} WHERE id = ?`,\n [eventId]\n );\n \n if (events.length === 0) {\n return c.json({ error: \"Event not found\" }, 404);\n }\n \n if (!verifyPassword(password, events[0].password_hash)) {\n return c.json({ error: \"Invalid password\" }, 401);\n }\n \n // Get all attendees with check-in data\n const data = await sqlite.execute(`\n SELECT a.name, a.external_id, c.checked_in_at\n FROM ${ATTENDEES_TABLE} a\n LEFT JOIN ${CHECKINS_TABLE} c ON a.id = c.attendee_id\n WHERE a.event_id = ?\n ORDER BY a.name\n `, [eventId]);\n \n // Generate CSV\n const csvRows = [\n 'Name,External ID,Checked In,Check-in Time'\n ];\n \n for (const row of data) {\n const checkedIn = row.checked_in_at ? 'Yes' : 'No';\n const checkInTime = row.checked_in_at || '';\n csvRows.push(`\"${row.name}\",\"${row.external_id || ''}\",\"${checkedIn}\",\"${checkInTime}\"`);\n }\n \n const csvContent = csvRows.join('\\n');\n const filename = `${events[0].name.replace(/[^a-zA-Z0-9]/g, '_')}_checkins.csv`;\n \n return new Response(csvContent, {\n headers: {\n 'Content-Type': 'text/csv',\n 'Content-Disposition': `attachment; filename=\"${filename}\"`\n }\n });\n \n } catch (error) {\n console.error(`💥 [API] Error exporting data:`, error);\n return c.json({ error: \"Internal server error\" }, 500);\n }\n});\n\nexport default app.fetch;",[],[188,300],["D",1752179182252],[203],[188],["D",1752179182252],{"_95":94,"_102":98},{"_95":94,"_96":-5,"_97":98,"_18":53,"_99":100,"_101":24},{"_13":84,"_31":85,"_42":41,"_86":43,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":44,"_93":94},"ctx",{"_77":-5,"_122":347,"_348":349,"_350":351,"_352":24,"_353":24,"_354":24,"_355":57,"_356":-5,"_357":-7,"_358":-7,"_359":61,"_360":24,"_361":24,"_362":-5,"_363":24,"_364":24,"_365":24,"_366":-5},"ENV",{"_318":319,"_320":321,"_322":85,"_323":324,"_325":326,"_327":328,"_329":330,"_331":332,"_333":334,"_335":336,"_337":338,"_339":340,"_341":342,"_343":344,"_345":346},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","811aa22498c9b0b5a47e8d778de579cdb990f332","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v9