Задать вопрос
  • Почему мой бот не работает?

    anton_02
    @anton_02 Автор вопроса
    soremix,
    @client.command(aliases = ['balance', 'cash'])
    async def __balance(ctx, member: discord.Member = None):
        if member is None:
            await ctx.send(embed = discord.Embed(
                description = f"""Баланс пользователя **{ctx.author}** составляет **{cursor.execute("SELECT cash FROM users WHERE id = {}".format(ctx.author.id)).fetchone()[0]} :leaves:**"""
            ))
            
        else:
            await ctx.send(embed = discord.Embed(
                description = f"""Баланс пользователя **{member}** составляет **{cursor.execute("SELECT cash FROM users WHERE id = {}".format(member.id)).fetchone()[0]} :leaves:**"""
            ))
  • Почему мой бот не работает?

    anton_02
    @anton_02 Автор вопроса
    soremix,
    import discord
    from discord.ext import commands
    import json
     
    import sqlite3
    from config import settings
    from Cybernator import Paginator as pag
     
    client = commands.Bot(command_prefix = settings['PREFIX'])
    client.remove_command('help')
     
    connection = sqlite3.connect('server.db')
    cursor = connection.cursor()
     
     
    @client.event
    async def on_ready():
        cursor.execute("""CREATE TABLE IF NOT EXISTS users (
            name TEXT,
            id INT,
            cash BIGINT,
            rep INT,
            lvl INT,
            server_id INT
        )""")
     
        cursor.execute("""CREATE TABLE IF NOT EXISTS shop (
            role_id INT,
            id INT,
            cost BIGINT
        )""")
     
        for guild in client.guilds:
            for member in guild.members:
                if cursor.execute(f"SELECT id FROM users WHERE id = {member.id}").fetchone() is None:
                    cursor.execute(f"INSERT INTO users VALUES ('{member}', {member.id}, 0, 0, 1, {guild.id})")
                else:
                    pass
     
        connection.commit()
        print('client connected')
     
     
    @client.event
    async def on_member_join(member):
        if cursor.execute(f"SELECT id FROM users WHERE id = {member.id}").fetchone() is None:
            cursor.execute(f"INSERT INTO users VALUES ('{member}', {member.id}, 0, 0, 1, {member.guild.id})")
            connection.commit()
        else:
            pass