Advertisement
Guest User

Untitled

a guest
Dec 10th, 2019
113
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.45 KB | None | 0 0
  1. @commands.Cog.listener()
  2. async def on_raw_reaction_add(self, reaction):
  3. db = sqlite3.connect('creative.sqlite')
  4. cursor = db.cursor()
  5. if '<:' is str(reaction.emoji):
  6. cursor.execute(f"SELECT emoji, role, message_id, channel_id FROM reaction WHERE guild_id = '{reaction.guild_id}' and message_id = '{reaction.message_id}' and emoji = '{reaction.emoji.id}'")
  7. result = cursor.fetchone()
  8. guild = self.bot.get_guild(reaction.guild_id)
  9. if result is None:
  10. return
  11. elif str(reaction.emoji.id) in str(result[0]):
  12. on = discord.utils.get(guild.roles, id=int(result[1]))
  13. user = guild.get_member(reaction.user_id)
  14. await user.add_roles(on)
  15. else:
  16. return
  17. elif '<:' not in str(reaction.emoji):
  18. cursor.execute(f"SELECT emoji, role, message_id, channel_id FROM reaction WHERE guild_id = '{reaction.guild_id}' and message_id = '{reaction.message_id}' and emoji = '{reaction.emoji}'")
  19. result = cursor.fetchone()
  20. guild = self.bot.get_guild(reaction.guild_id)
  21. if result is None:
  22. return
  23. elif result is not None:
  24. on = discord.utils.get(guild.roles, id=int(result[1]))
  25. user = guild.get_member(reaction.user_id)
  26. await user.add_roles(on)
  27. else:
  28. return
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement