bot discord python + sqlite eror

20 views Asked by At

I'm trying to add to discord.py + Sql ite but for some reason when I launch the bot and enter the command balance, it says user not found, the error is that users are not added to the data base, please help

code

intents = discord.Intents.all()
bot = commands.Bot(command_prefix='!', intents=intents, test_guild=[1204606906337984513])
bot.remove_command('help')

emoji = "<:emoji_77:1215712871976009788>"
emoji1 = "<:crypto:1215729173029593129>"


connection = sqlite3.connect('server.db')
cursor = connection.cursor()

cursor.execute("""CREATE TABLE IF NOT EXISTS `users_table` (
                      id INTEGER PRIMARY KEY,
                      name TEXT,
                      cash INTEGER DEFAULT 0,
                      bank INTEGER DEFAULT 0,
                      rep INTEGER DEFAULT 0,
                      lvl INTEGER DEFAULT 1,
                      debt INTEGER DEFAULT 0,
                      crypto INTEGER DEFAULT 0,
                      server_id INTEGER
                  );""")
    
for guild in bot.guilds:
    for member in guild.members:
        if cursor.execute(f"SELECT id FROM  `users_table` WHERE id = {member.id}").fetchone() is None:
                cursor.execute(f"INSERT INTO `users_table` VALUES('{member}, {member.id}, 1, 0, 0, 1, 0, 0')")
                connection.commit()
            
        else:
            pass
            
    connection.commit()
    
cursor.execute("""CREATE  TABLE IF NOT EXISTS shop (
    role_id INT,
    id INT,
    cost BIGINT
    )""")```
1

There are 1 answers

0
Mendo On

Aren't you literally selecting the user from a database, and if its here, then you insert the id again? Try making a command that adds the user to the db