| 123456789101112131415161718192021222324252627282930313233 |
- # async def user_manage(message: types.Message):
- # if not sql_check_user(f"select tg_id from user_table where tg_id ={message.from_user.id}") or \
- # not sql_simple_check(f"select approved from user_table where tg_id={message.from_user.id}", "approved"):
- # await message.delete()
- # await message.answer("Команды станут доступны после регистрации", reply_markup=register_kb)
- # elif not sql_simple_check(f'select admin from user_table where tg_id = {message.from_user.id}', "admin"):
- # await message.answer("Доступ только для администраторов", reply_markup=main_kb)
- # else:
- # await message.answer(f"Управление пользователями\n\n"
- # f"Здесь вы можете управлять заявками на регистрацию\n\n")
- # if not sql_check_user(f"select name,phone from user_table where approved = '0'"):
- # await message.answer("Нет заявок на регистрацию")
- # else:
- # data = sql_parse_users(f"select id,name,phone from user_table where approved = '0'")
- # await message.answer(f"Заявки на регистрацию")
- # await message.answer(" ".join(sql_parse_users(f"select id,name,phone"
- # f"from user_table"
- # f"where approved = '0'")))
- # await message.answer(''.join(data[:1]), reply_markup=kb_user_manage())
- # @dp.callback_query_handler()
- # async def select_date(call: types.CallbackQuery):
- # await bot.answer_callback_query(call.id)
- # await bot.send_message(call.message.chat.id, "Вы выбрали " + call.data)
- # sql_query_users(f"select name,phone from user_table where approved = '0'")
- # print(sql_simple_check(f"select approved from user_table where tg_id='338836490'"))
- # print(sql_parse_users(f"select id, name,phone from user_table where approved = '0'"))
- # print(sql_simple_check(f"select admin from user_table where tg_id = '338836490'", "admin"))
- # print(not not sql_query_single_get(f"select tg_id from user_table where tg_id = '11'"))
- # sql_query(f"INSERT INTO user_table (tg_id,name,phone) VALUES ('123123','ФФ ыв ывыв','89539299323')")
- # select name,phone from user_table where approved = '0'
|
