Advertisement
Guest User

Untitled

a guest
Sep 6th, 2020
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.72 KB | None | 0 0
  1. !ЭТО КУСОК КОДА!
  2. @bot.event
  3. async def on_ready():
  4. print(f"Hello! Logged in as {bot.user}")
  5. cursor.execute("""CREATE TABLE IF NOT EXISTS users (
  6. name TEXT,
  7. id INT,
  8. cash BIGINT,
  9. rep INT,
  10. lvl INT,
  11. server_id INT
  12. )""")
  13. for guild in client.guilds:
  14. for member in guild.members:
  15. if cursor.execute(f"SELECT id FROM users WHERE id = {member.id}").fetchone() is None:
  16. cursor.execute(f"INSERT INTO users VALUES ('{member}', {member.id}, 0, 0, 1, {guild.id})")
  17. else:
  18. pass
  19. cursor.execute(f"INSERT INTO users VALUES ('{member}', {member.id}, 0, 0, 1, {guild.id})")
  20. connection.commit()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement