result = self.cursor.execute("SELECT 'signup' FROM 'users' WHERE 'user_id' = ?", (user_id,)).fetchall()result = self.cursor.execute("SELECT signup FROM users WHERE user_id = ?", (user_id,)).fetchall()x = {'4', '3', '2', '1'}
for row in x:
y = str(row[0])
print(y)
@dp.message_handler(lambda msg: any(word in msg.text.lower() for word in word_list))
async def mat(message: types.Message):
await message.delete()
await message.answer(f"{message.from_user.first_name}, ваше сообщение удалено!")from aiogram import Bot, Dispatcher, F
from aiogram.filters import CommandStart
from aiogram.types import (CallbackQuery, Message)
import config
import keyboards
from aiogram.types import FSInputFile
from aiogram.types import InputMediaPhoto
bot = Bot(token=config.TOKEN)
dp = Dispatcher()
@dp.message(CommandStart())
async def process_start_command1(message: Message):
await message.answer(text='Добрый день!', reply_markup=keyboards.keyboard, parse_mode='html')
@dp.callback_query(F.data == 'bt1')
async def process_button_1_press(callback: CallbackQuery):
photo = FSInputFile('monitoring.jpg')
await callback.message.edit_media(InputMediaPhoto(media=photo, caption='Текст'), reply_markup=keyboards.keyboard1)
await callback.message.delete()
@dp.callback_query(F.data == 'bt3')
async def process_button_2_press(callback: CallbackQuery):
await callback.message.edit_text(text='Вы выбрали пункт 1.1', reply_markup=keyboards.keyboard2)
@dp.callback_query(F.data == 'bt4')
async def process_button_15_press(callback: CallbackQuery):
await callback.message.edit_text(text='Вы выбрали пункт 1.2', parse_mode='html')
@dp.callback_query(F.data == 'bt5')
async def process_button_15_press(callback: CallbackQuery):
await callback.message.edit_text(text='Вы вернулись в главное меню', reply_markup=keyboards.keyboard)
if __name__ == '__main__':
dp.run_polling(bot)from aiogram.types import (InlineKeyboardButton, InlineKeyboardMarkup)
bt1 = InlineKeyboardButton(text='Пункт 1', callback_data='bt1')
bt2 = InlineKeyboardButton(text='Пункт 2', callback_data='bt2')
keyboard = InlineKeyboardMarkup(inline_keyboard=[[bt1, bt2]])
bt3 = InlineKeyboardButton(text='Пункт 1.1', callback_data='bt3')
bt4 = InlineKeyboardButton(text='Пункт 1.2', callback_data='bt4')
bt5 = InlineKeyboardButton(text='Назад', callback_data='bt5')
keyboard1 = InlineKeyboardMarkup(inline_keyboard=[[bt3, bt4], [bt5]])
bt6 = InlineKeyboardButton(text='Кнопка 1', callback_data='bt6')
bt7 = InlineKeyboardButton(text='Кнопка 2', callback_data='bt7')
bt8 = InlineKeyboardButton(text='Кнопка 3', callback_data='bt8')
bt9 = InlineKeyboardButton(text='Кнопка 4', callback_data='bt9')
bt10 = InlineKeyboardButton(text='Кнопка 5', callback_data='bt10')
bt11 = InlineKeyboardButton(text='Кнопка 6', callback_data='bt11')
bt12 = InlineKeyboardButton(text='Кнопка 7', callback_data='bt12')
keyboard2 = InlineKeyboardMarkup(inline_keyboard=[[bt6, bt7, bt8], [bt9, bt10, bt11], [bt12]])@dp.callback_query(F.data == 'bt21')
async def process_button_15_press(callback: CallbackQuery):
photo = FSInputFile('monitoring.jpg')
await callback.message.edit_media(InputMediaPhoto(media=photo, caption='Текст'), reply_markup=keyboards.keyboard8)
Да я понимаю, что не могу обращаться в пустоту.. а в чем тогда проблема? почему работает то, что не должно работать