Ответы пользователя по тегу SQLite
  • Как исправить эту ошибку при запуске дискорд бота?

    Taruu
    @Taruu
    Шкодер на Python, и немного на C/С++ lua...
    import discord
    from discord.ext import commands
    
    import sqlite3
    
    client = commands.Bot(command_prefix = "!")
    client.remove_command('help')
    connection = sqlite3.connect('users.db')
    cursor = connection.cursor()
    
    
    @client.event
    async def on_ready():
      cursor.execute("""CREATE TABLE users (name TEXT,id INT,cash BIGINT,rep INT,lvl INT)""")
    
      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)")
          else:
            pass
    
      connection.commit()
      print('bot 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)")
        connection.commit()
      else:
        pass
    
    
    @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])}**"""
        ))
      else:
        await ctx.send(embed = discord.embed(
          description = f"""Баланс пользователя {member} составляет **{cursor.execute("SELECT cash FROM users WHERE id = {}".format(member.id).fetchone()[0])}**"""
        ))
    
    
    client.run()
    Ответ написан
    Комментировать