import discord
from discord.ext import commands
import sqlite3
client = commands.Bot(command_prefix = '$')
connection = sqlite3.connect('server.db')
cur = connection.cursor()
@client.event
async def on_ready():
    cur.execute("""CREATE TABLE IF NOT EXISTS users
        (
        name TEXT,
        ID INT,
        cash INT,
        Clan TEXT,
        LVL INT
        )""")
    for guild in client.guilds:
        for member in guild.members:
            if(cur.execute(f"SELECT id FROM users WHERE id = {member.id}").fetchone()):
                cur.execute(f"INSERT INTO users VALUES ('{member}', {member.id}, 0, 'NONE', 0)")
            else:
                pass
    connection.commit()
@client.event
async def on_member_join(member):
    if(cur.execute(f"SELECT id FROM users WHERE id = {member.id}").fetchone()):
        cur.execute(f"INSERT INTO users VALUES ('{member}', {member.id}, 0, 'NONE', 0)")
        connection.commit()
    else:
        pass
@client.command(pass_context = True)
async def profile(ctx,member: discord.Member = None):
    if member == None:
        member = ctx.author
    emb = discord.Embed(title = f'Профиль участника {member}', colour = discord.Color.blue())
    emb.add_field(name = 'Деньги:',value = f"""{cur.execute("SELECT cash FROM users WHERE ID = {0.id}".format(member)).fetchone()[0]}""")
    emb.add_field(name = 'Имя:',value = f'{member}')
    emb.add_field(name = 'Клан:',value = 'NONE')
    emb.add_field(name = 'Уровень:',value = '0')
    await ctx.channel.send(embed = emb)