A complete event check-in system for managing attendee sign-ins with secure name verification.

• Event Management: Create events with attendee lists and password protection
• Secure Check-in: Fuzzy search-based sign-in with name verification
• Analytics Dashboard: Track check-ins with date-based analytics
• CSV Import/Export: Import attendee lists and export check-in data
• Responsive UI: Clean, modern interface built with React and TailwindCSS

1. Event Creation: Organizers create events with attendee lists via CSV upload
2. Attendee Sign-in: Attendees use fuzzy search to find and check in with their names
3. Data Tracking: System tracks all check-ins with timestamps
4. Analytics: Organizers can view check-in analytics and export data
5. Security: No sensitive information exposed, password-protected management

├── backend/
│   └── index.ts              # Main API server with Hono
├── frontend/
│   ├── index.html           # Main HTML template
│   ├── index.tsx            # React app entry point
│   └── components/
│       ├── App.tsx          # Main app component
│       ├── EventSignIn.tsx  # Sign-in component with fuzzy search
│       ├── EventManagement.tsx  # Management dashboard
│       └── EventCreation.tsx    # Event creation form
├── shared/
│   └── types.ts             # Shared TypeScript types
└── README.md

No external API keys required for basic functionality. Optional Discord integration available for future features.

The system uses SQLite with the following schema:

-- Events table
CREATE TABLE events_1 (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  name TEXT NOT NULL,
  password_hash TEXT NOT NULL,
  location TEXT,
  created_at DATETIME DEFAULT CURRENT_TIMESTAMP
);

-- Attendees table  
CREATE TABLE attendees_1 (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  event_id INTEGER NOT NULL,
  name TEXT NOT NULL,
  external_id TEXT,
  FOREIGN KEY (event_id) REFERENCES events_1(id)
);

-- Check-ins table
CREATE TABLE checkins_1 (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  event_id INTEGER NOT NULL,
  attendee_id INTEGER NOT NULL,
  checked_in_at DATETIME DEFAULT CURRENT_TIMESTAMP,
  FOREIGN KEY (event_id) REFERENCES events_1(id),
  FOREIGN KEY (attendee_id) REFERENCES attendees_1(id)
);

• POST /api/submissions - Submit a new talk proposal
• GET /api/submissions - Get all submissions (admin)
• POST /api/discord/test - Test Discord integration (creates test channel and sends message)

✅ Discord integration is fully implemented with comprehensive logging

The system will automatically:

• Create Discord channels for each talk submission
• Generate invite links for the channels
• Post notifications to the organizers channel

Comprehensive Logging: The system includes detailed logging throughout the Discord integration process:

• 🔍 Environment variable checks on startup
• 🎯 API request tracking with submission details
• 🔧 Discord channel creation with API responses
• 🔗 Invite link generation with full details
• 📢 Organizer notifications with message content
• 💥 Detailed error logging with stack traces and specific Discord error codes
• 📊 Final result summaries

Fallback behavior: If Discord credentials are not provided, the system will use placeholder values and log what would have been done, allowing the form to still function for testing.

Debugging: Use the requests tool to view detailed logs of each submission, including all Discord API interactions and any errors that occur.

1. Fill out the talk submission form
2. Submit the form
3. Receive a Discord invite link
4. Join the Discord channel to discuss your talk with organizers

• Backend: Hono (API framework)
• Frontend: React 18.2.0 with TypeScript
• Database: SQLite
• Styling: TailwindCSS
• Platform: Val Town (Deno runtime)