(winnerId: number, status: PrizeStatus, claimedAt?: number)
| 475 | `); |
| 476 | stmt.run(status, claimedAt || null, winnerId); |
| 477 | } |
| 478 | |
| 479 | function updateWinnerStatusByUser(lotteryId: number, userId: string, status: PrizeStatus, claimedAt?: number): boolean { |
| 480 | if (!db) return false; |
| 481 | |
| 482 | const stmt = db.prepare(` |
| 483 | UPDATE lottery_winners |
| 484 | SET status = ?, claimed_at = ? |
| 485 | WHERE lottery_id = ? AND user_id = ? |
| 486 | `); |
| 487 | const result = stmt.run(status, claimedAt || Date.now(), lotteryId, userId); |
| 488 | return result.changes > 0; |
| 489 | } |