René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Bot","articleBody":"# bot.py\nimport sqlite3\nimport random\nfrom aiogram import Bot, Dispatcher, types, executor\nfrom aiogram.types import ParseMode\nfrom datetime import datetime\n\n# ================= CONFIG =================\nBOT_TOKEN = \"TELEGRAM_BOT_TOKEN\"\nADMIN_ID = 123456789  # Sizning telegram ID\nCHANNEL_USERNAME = \"@siznikanal\"\n# ==========================================\n\nbot = Bot(token=BOT_TOKEN)\ndp = Dispatcher(bot)\n\n# ============== DATABASE ==================\nconn = sqlite3.connect(\"pubg_bot.db\")\ncursor = conn.cursor()\n\ncursor.execute(\"\"\"\nCREATE TABLE IF NOT EXISTS users (\n    id INTEGER PRIMARY KEY,\n    telegram_id INTEGER UNIQUE,\n    username TEXT,\n    balance INTEGER DEFAULT 0,\n    referral_id INTEGER,\n    joined_at TEXT DEFAULT CURRENT_TIMESTAMP\n)\n\"\"\")\nconn.commit()\n\ndef add_user(telegram_id, username, referral_id=None):\n    cursor.execute(\"INSERT OR IGNORE INTO users (telegram_id, username, referral_id) VALUES (?, ?, ?)\",\n                   (telegram_id, username, referral_id))\n    conn.commit()\n\ndef update_balance(telegram_id, amount):\n    cursor.execute(\"UPDATE users SET balance = balance + ? WHERE telegram_id = ?\", (amount, telegram_id))\n    conn.commit()\n\ndef get_user(telegram_id):\n    cursor.execute(\"SELECT * FROM users WHERE telegram_id = ?\", (telegram_id,))\n    return cursor.fetchone()\n\ndef get_all_users():\n    cursor.execute(\"SELECT * FROM users\")\n    return cursor.fetchall()\n# ==========================================\n\n# =============== BOT HANDLERS ==============\n@dp.message_handler(commands=[\"start\"])\nasync def start(message: types.Message):\n    referral_id = None\n    if len(message.text.split()) \u003e 1:\n        try:\n            referral_id = int(message.text.split()[1])\n        except:\n            referral_id = None\n\n    user = get_user(message.from_user.id)\n    if not user:\n        add_user(message.from_user.id, message.from_user.username, referral_id)\n\n        # Referral bonus\n        if referral_id:\n            update_balance(referral_id, 5)  # 5 UC bonus referral uchun\n\n    # Obuna tekshiruvi\n    try:\n        chat_member = await bot.get_chat_member(CHANNEL_USERNAME, message.from_user.id)\n        if chat_member.status in [\"left\", \"kicked\"]:\n            await message.answer(f\"Avvalo kanalga obuna bo‘ling: {CHANNEL_USERNAME}\")\n            return\n    except:\n        await message.answer(\"Kanalni tekshirishda xatolik yuz berdi. Kanal username tekshiring.\")\n        return\n\n    await message.answer(\"Salom! Siz botga muvaffaqiyatli ulandingiz.\\n\\n/balance - Balansingizni ko‘rish\\n/lucky - Lucky Spin o‘ynash\")\n\n@dp.message_handler(commands=[\"balance\"])\nasync def balance(message: types.Message):\n    user = get_user(message.from_user.id)\n    if user:\n        await message.answer(f\"Sizning balansingiz: {user[3]} UC\")\n\n@dp.message_handler(commands=[\"lucky\"])\nasync def lucky(message: types.Message):\n    user = get_user(message.from_user.id)\n    if not user:\n        await message.answer(\"Avvalo /start bosing\")\n        return\n    prize = random.choice([0, 5, 10, 20, 50])\n    update_balance(message.from_user.id, prize)\n    await message.answer(f\"🎰 Lucky Spin natijasi: {prize} UC qo‘shildi!\\nYangi balans: {get_user(message.from_user.id)[3]} UC\")\n\n# ================ ADMIN COMMANDS =============\n@dp.message_handler(lambda message: message.from_user.id == ADMIN_ID, commands=[\"users\"])\nasync def admin_users(message: types.Message):\n    users = get_all_users()\n    text = f\"Foydalanuvchilar soni: {len(users)}\\n\\n\"\n    for u in users:\n        text += f\"ID:{u[1]} | Username: @{u[2]} | Balance: {u[3]} UC\\n\"\n    await message.answer(text)\n\n@dp.message_handler(lambda message: message.from_user.id == ADMIN_ID, commands=[\"add\"])\nasync def admin_add(message: types.Message):\n    try:\n        parts = message.text.split()\n        tg_id = int(parts[1])\n        amount = int(parts[2])\n        update_balance(tg_id, amount)\n        await message.answer(f\"{amount} UC foydalanuvchi {tg_id} balansiga qo‘shildi!\")\n    except:\n        await message.answer(\"Xatolik! Format: /add \u003ctelegram_id\u003e \u003camount\u003e\")\n\n# ==========================================\n\nif __name__ == \"__main__\":\n    executor.start_polling(dp, skip_updates=True)","author":{"url":"https://github.com/sharofiddinyuldoshov655-arch","@type":"Person","name":"sharofiddinyuldoshov655-arch"},"datePublished":"2026-04-03T15:38:55.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/39/sample-python/issues/39"}