From: Mr. Blueberry

profile.py

import asyncio
import random
import sqlite3
import re

from aiogram import types
from aiogram.types import ParseMode, InlineKeyboardMarkup, InlineKeyboardButton
from misc import dp, bot, allow_chats, group_error_msg



db = sqlite3.connect("profile.db")
sql = db.cursor()


@dp.message_handler(commands=['setname'])
async def porvat(message: types.Message):
    # Проверка на группу
	cm_parse = re.compile(r"(/setname) ?([\w+\D ]+)?")
	parsed = cm_parse.match(message.text)
	say = parsed.group(2)
	for store in sql.execute(f"SELECT name FROM users WHERE id_user = {message.from_user.id}"):
		
		sql.execute('UPDATE users SET name = ? WHERE id_user = ?', (say, message.from_user.id))
		text = f"<b>{message.from_user.get_mention(as_html=True)} добавлено в профиль!</b>"
		db.commit()
		await message.answer(text, parse_mode=ParseMode.HTML)
		
		
		
@dp.message_handler(commands=['setxbox'])
async def porvat(message: types.Message):
    # Проверка на группу
	cm_parse = re.compile(r"(/setxbox) ?([\w+\D ]+)?")
	parsed = cm_parse.match(message.text)
	say = parsed.group(2)
	for store in sql.execute(f"SELECT xbox FROM users WHERE id_user = {message.from_user.id}"):
		
		sql.execute('UPDATE users SET xbox = ? WHERE id_user = ?', (say, message.from_user.id))
		text = f"<b>{message.from_user.get_mention(as_html=True)} добавлено в профиль!</b>"
		db.commit()
		await message.answer(text, parse_mode=ParseMode.HTML)
		
		
@dp.message_handler(commands=['setage'])
async def porvat(message: types.Message):
    # Проверка на группу
	cm_parse = re.compile(r"(/setage) ?([\w+\D ]+)?")
	parsed = cm_parse.match(message.text)
	say = parsed.group(2)
	for store in sql.execute(f"SELECT age FROM users WHERE id_user = {message.from_user.id}"):
		
		sql.execute('UPDATE users SET age = ? WHERE id_user = ?', (say, message.from_user.id))
		text = f"<b>{message.from_user.get_mention(as_html=True)} добавлено в профиль!</b>"
		db.commit()
		await message.answer(text, parse_mode=ParseMode.HTML)




@dp.message_handler(commands=['setsex'])
async def porvat(message: types.Message):
    # Проверка на группу
	cm_parse = re.compile(r"(/setsex) ?([\w+\D ]+)?")
	parsed = cm_parse.match(message.text)
	say = parsed.group(2)
	for store in sql.execute(f"SELECT item FROM users WHERE id_user = {message.from_user.id}"):
		
		sql.execute('UPDATE users SET item = ? WHERE id_user = ?', (say, message.from_user.id))
		text = f"<b>{message.from_user.get_mention(as_html=True)} добавлено в профиль!</b>"
		db.commit()
		await message.answer(text, parse_mode=ParseMode.HTML)



@dp.message_handler(commands=['setcountry'])
async def porvat(message: types.Message):
    # Проверка на группу
	cm_parse = re.compile(r"(/setcountry) ?([\w+\D ]+)?")
	parsed = cm_parse.match(message.text)
	say = parsed.group(2)
	for store in sql.execute(f"SELECT country FROM users WHERE id_user = {message.from_user.id}"):
		
		sql.execute('UPDATE users SET country = ? WHERE id_user = ?', (say, message.from_user.id))
		text = f"<b>{message.from_user.get_mention(as_html=True)} добавлено в профиль!</b>"
		db.commit()
		await message.answer(text, parse_mode=ParseMode.HTML)





















#КОМАНДА !ПРОФИЛЬ
@dp.message_handler(commands=['профиль'], commands_prefix='!')
async def kisa(message: types.Message):
    id = message.from_user.id
    # Проверка на группу
    if f'{message.chat.id}' not in allow_chats:
        return await message.reply(group_error_msg)
    
    if message.reply_to_message:
     for profile in sql.execute(f"SELECT * FROM users WHERE id_user = {message.reply_to_message.from_user.id}"):
    		 await message.reply("Имя: "+ str(profile[5])+ "\nXbox ник: "+ str(profile[3])+ "\nВозраст: "+ str(profile[2])+ "\nПол: "+ str(profile[7])+ "\nСтрана: "+ str(profile[4])+ "", parse_mode='HTML')
    else:
    	for profile in sql.execute(f"SELECT * FROM users WHERE id_user = {id}"):
    		await message.reply("Имя: "+ str(profile[5])+ "\nXbox ник: "+ str(profile[3])+ "\nВозраст: "+ str(profile[2])+ "\nПол: "+ str(profile[7])+ "\nСтрана: "+ str(profile[4])+ "", parse_mode='HTML')
    		
    		
    		
    		
    		
@dp.message_handler()
async def message_text(message: types.Message):
	id = message.from_user.id
	username = message.from_user.first_name
	text = message.from_user.first_name
	texts = message.from_user.first_name
	textss = message.from_user.first_name
	textsss = message.from_user.first_name
	# создание таблицы если она каким-то образом была сциганена
	sql.execute("""CREATE TABLE IF NOT EXISTS users (id_user INT, username TEXT, age INT, xbox TEXT, country TEXT, name TEXT, post_mesto INT, item TEXT)""")
	db.commit()
	# проверяем в таблице существование юзера в базе даных
	sql.execute(F"SELECT id_user FROM users WHERE id_user = {id}")
	if sql.fetchone() is None:
		# Добавляем его в гей пати (в базу данных, знаю я еблан, но так тебе будет понятнее ;) )
		sql.execute(f"INSERT INTO users VALUES (?, ?, ?, ?, ?, ?, ?, ?)", (id, username, 0, textss, texts, textsss, 0, text))
		db.commit()
	else:
	    pass