Function getLotteryParticipants

lottery/lottery.ts:404–412

(lotteryId: number)

  `);
  return stmt.all(lotteryId);
}

function getLotteryWinners(lotteryId: number): any[] {
  if (!db) return [];
  
  const stmt = db.prepare(`
    SELECT w.*, p.username, p.first_name, p.last_name 
    FROM lottery_winners w
    LEFT JOIN lottery_participants p ON w.user_id = p.user_id AND w.lottery_id = p.lottery_id
    WHERE w.lottery_id = ?
    ORDER BY w.assigned_at
  `);