Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- @commands.Cog.listener()
- async def on_raw_reaction_add(self, reaction):
- db = sqlite3.connect('creative.sqlite')
- cursor = db.cursor()
- if '<:' is str(reaction.emoji):
- 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}'")
- result = cursor.fetchone()
- guild = self.bot.get_guild(reaction.guild_id)
- if result is None:
- return
- elif str(reaction.emoji.id) in str(result[0]):
- on = discord.utils.get(guild.roles, id=int(result[1]))
- user = guild.get_member(reaction.user_id)
- await user.add_roles(on)
- else:
- return
- elif '<:' not in str(reaction.emoji):
- 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}'")
- result = cursor.fetchone()
- guild = self.bot.get_guild(reaction.guild_id)
- if result is None:
- return
- elif result is not None:
- on = discord.utils.get(guild.roles, id=int(result[1]))
- user = guild.get_member(reaction.user_id)
- await user.add_roles(on)
- else:
- return
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement