Function createLotteryConfig

lottery/lottery.ts:326–348

(config: any)

      chat_id, title, keyword, max_participants, winner_count, mode, 
      distribution_mode, claim_timeout, delete_delay, require_avatar, 
      require_username, required_channel, prize_warehouse, allow_bots, 
      member_filter, auto_draw_time, created_at, creator_id, unique_id
    ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  `);
  
  const result = stmt.run(
    config.chat_id, config.title, config.keyword, config.max_participants,
    config.winner_count, config.mode, config.distribution_mode, config.claim_timeout,
    config.delete_delay, config.require_avatar ? 1 : 0, config.require_username ? 1 : 0,
    config.required_channel || null, config.prize_warehouse || 'default', config.allow_bots ? 1 : 0,
    config.member_filter || null, config.auto_draw_time || null, Date.now(), config.creator_id,
    config.unique_id
  );
  
  return result.lastInsertRowid as number;
}

function getActiveLottery(chatId: string): any | null {
  if (!db) return null;
  
  const stmt = db.prepare(`
    SELECT * FROM lottery_config 
    WHERE chat_id = ? AND status = 'active' 
    ORDER BY created_at DESC LIMIT 1
  `);
  return stmt.get(chatId) as any;