# 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'