# Get counts cursor = db.conn.cursor() cursor.execute("SELECT COUNT(*) FROM xtream_codes WHERE status='active'") xtream_active = cursor.fetchone()[0]
COPY . .
Use the buttons below to get your code! """ Stbemu Codes and Xtream Codes - Telegram channel
📺 Xtream Codes: {xtream_active} active 📡 STBEmu Codes: {stbemu_active} active 👥 Active Users: {active_users} # Get counts cursor = db
COPY requirements.txt . RUN pip install --no-cache-dir -r requirements.txt """ 📺 Xtream Codes: {xtream_active} active 📡 STBEmu
def get_user_active_codes(self, telegram_id): cursor = self.conn.cursor() cursor.execute(''' SELECT code_type, assigned_code_id, expires_at FROM user_requests WHERE telegram_id = ? AND status = 'active' AND expires_at > ? ''', (telegram_id, datetime.now())) return cursor.fetchall() # bot.py import os import re import logging from datetime import datetime from telegram import Update, InlineKeyboardButton, InlineKeyboardMarkup from telegram.ext import ( Application, CommandHandler, CallbackQueryHandler, MessageHandler, filters, ContextTypes ) from database import Database Configuration TOKEN = os.getenv("TELEGRAM_BOT_TOKEN") ADMIN_IDS = [123456789, 987654321] # Add your admin IDs Initialize database db = Database() Setup logging logging.basicConfig( format='%(asctime)s - %(name)s - %(levelname)s - %(message)s', level=logging.INFO ) logger = logging.getLogger( name ) Validators def validate_mac_address(mac): """Validate MAC address format (00:1A:79:XX:XX:XX)""" pattern = r'^([0-9A-Fa-f]{2}[:-]){5}([0-9A-Fa-f]{2})$' return re.match(pattern, mac) is not None