API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Nov 17th, 2019
154
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.45 KB | None | 0 0
raw download clone embed print report
  1.  
  2. @bot.event
  3. async def on_reaction_add(reaction,user):
  4. if reaction.message.guild is None:
  5. return
  6. if 'starboard emoji' in reaction.message.content:
  7. return
  8. cursor.execute(f"SELECT channelid FROM starboarden WHERE guildid = '{reaction.message.guild.id}'")
  9. data = cursor.fetchone()
  10. try:
  11. starboard_id = data[0]
  12. except:
  13. return
  14. try:
  15. cursor.execute(f"SELECT emoj FROM staremo WHERE guildid = '{reaction.message.guild.id}'")
  16. emd = cursor.fetchone()
  17. starsone = emd[0]
  18. except:
  19. starsone = "\U00002B50"
  20.  
  21. starboard_channel = reaction.message.guild.get_channel(int(starboard_id))
  22. if reaction.emoji==(starsone):
  23. try:
  24. cursor.execute(f"SELECT amount FROM starcount WHERE guildid = '{reaction.message.guild.id}'")
  25. aids = cursor.fetchone()
  26. reaction_counter = int(aids[0])
  27. except:
  28. reaction_counter = 1
  29.  
  30. if reaction.count==(reaction_counter):
  31. cursor.execute(f"SELECT messageid FROM starboard WHERE reactionid = '{reaction.message.id}'")
  32. data = cursor.fetchone()
  33. try:
  34. before_id = data[0]
  35. return
  36. except:
  37. print("OK")
  38. message = await starboard_channel.send(f"{starsone} **#{reaction_counter}**")
  39. try:
  40. file = reaction.message.attachments[0]
  41. if '[]' in str(message.content):
  42. embedd = discord.Embed(timestamp=reaction.message.created_at)
  43. embedd.set_image(url=file.url)
  44. embedd.set_author(icon_url=reaction.message.author.avatar_url,name=reaction.message.author.display_name)
  45. embedd.set_footer(text=f"Server: {reaction.message.guild} | Channel: {reaction.message.channel} ")
  46. await starboard_channel.send(embed=embedd)
  47. return
  48.  
  49. embed = discord.Embed(description=reaction.message.content,timestamp=reaction.message.created_at)
  50. embed.set_image(url=file.url)
  51. embed.set_author(icon_url=reaction.message.author.avatar_url,name=reaction.message.author.display_name)
  52. embed.set_footer(text=f"Server: {reaction.message.guild} | Channel: {reaction.message.channel} ")
  53. await starboard_channel.send(embed=embed)
  54. else:
  55. embed = discord.Embed(description=reaction.message.content,timestamp=reaction.message.created_at)
  56. embed.set_author(icon_url=reaction.message.author.avatar_url,name=reaction.message.author.display_name)
  57. embed.set_footer(text=f"Server: {reaction.message.guild} | Channel: {reaction.message.channel} ")
  58. await starboard_channel.send(embed=embed)
  59.  
  60.  
  61. cursor.execute(f"DELETE FROM starboard WHERE guildid = '{reaction.message.guild.id}'")
  62. cursor.execute(f"INSERT INTO starboard VALUES ('{message.id}','1','{reaction.message.guild.id}','{reaction.message.id}')")
  63. database.commit()
  64. if reaction.count == (reaction_counter + 1):
  65. cursor.execute(f"SELECT messageid FROM starboard WHERE guildid = '{reaction.message.guild.id}'")
  66. data = cursor.fetchone()
  67. message_id = data[0]
  68. messages = await starboard_channel.fetch_message(message_id)
  69. await messages.edit(content=f"{starsone} **#{reaction_counter + 1}**")
  70. return
  71. if reaction.count==(reaction_counter + 2):
  72. cursor.execute(f"SELECT messageid FROM starboard WHERE guildid = '{reaction.message.guild.id}'")
  73. data = cursor.fetchone()
  74. message_id = data[0]
  75. messages = await starboard_channel.fetch_message(message_id)
  76. await messages.edit(content=f"{starsone} **#{reaction_counter + 2}**")
  77. return
  78. if reaction.count==(reaction_counter + 3):
  79. cursor.execute(f"SELECT messageid FROM starboard WHERE guildid = '{reaction.message.guild.id}'")
  80. data = cursor.fetchone()
  81. message_id = data[0]
  82. messages = await starboard_channel.fetch_message(message_id)
  83. await messages.edit(content=f"{starsone} **#{reaction_counter + 3}**")
  84. return
  85. if reaction.count==(reaction_counter + 4):
  86. cursor.execute(f"SELECT messageid FROM starboard WHERE guildid = '{reaction.message.guild.id}'")
  87. data = cursor.fetchone()
  88. message_id = data[0]
  89. messages = await starboard_channel.fetch_message(message_id)
  90. await messages.edit(content=f"{starsone} **#{reaction_counter + 4}**")
  91. return
  92. if reaction.count==(reaction_counter + 5):
  93. cursor.execute(f"SELECT messageid FROM starboard WHERE guildid = '{reaction.message.guild.id}'")
  94. data = cursor.fetchone()
  95. message_id = data[0]
  96. messages = await starboard_channel.fetch_message(message_id)
  97. await messages.edit(content=f"{starsone} **#{reaction_counter + 5}**")
  98. return
  99. if reaction.count==(reaction_counter + 6):
  100. cursor.execute(f"SELECT messageid FROM starboard WHERE guildid = '{reaction.message.guild.id}'")
  101. data = cursor.fetchone()
  102. message_id = data[0]
  103. messages = await starboard_channel.fetch_message(message_id)
  104. await messages.edit(content=f"{starsone} **#{reaction_counter + 6}**")
  105. return
  106. if reaction.count==(reaction_counter + 7):
  107. cursor.execute(f"SELECT messageid FROM starboard WHERE guildid = '{reaction.message.guild.id}'")
  108. data = cursor.fetchone()
  109. message_id = data[0]
  110. messages = await starboard_channel.fetch_message(message_id)
  111. await messages.edit(content=f"{starsone} **#{reaction_counter + 7}**")
  112. return
  113. if reaction.count==(reaction_counter + 8):
  114. cursor.execute(f"SELECT messageid FROM starboard WHERE guildid = '{reaction.message.guild.id}'")
  115. data = cursor.fetchone()
  116. message_id = data[0]
  117. messages = await starboard_channel.fetch_message(message_id)
  118. await messages.edit(content=f"{starsone} **#{reaction_counter + 8}**")
  119. return
  120. if reaction.count==(reaction_counter + 9):
  121. cursor.execute(f"SELECT messageid FROM starboard WHERE guildid = '{reaction.message.guild.id}'")
  122. data = cursor.fetchone()
  123. message_id = data[0]
  124. messages = await starboard_channel.fetch_message(message_id)
  125. await messages.edit(content=f"{starsone} **#{reaction_counter + 9}**")
  126. return
  127. if reaction.count==(reaction_counter + 10):
  128. cursor.execute(f"SELECT messageid FROM starboard WHERE guildid = '{reaction.message.guild.id}'")
  129. data = cursor.fetchone()
  130. message_id = data[0]
  131. messages = await starboard_channel.fetch_message(message_id)
  132. await messages.edit(content=f"{starsone} **#{reaction_counter + 10}**")
  133. return
  134. if reaction.count==(reaction_counter + 11):
  135. cursor.execute(f"SELECT messageid FROM starboard WHERE guildid = '{reaction.message.guild.id}'")
  136. data = cursor.fetchone()
  137. message_id = data[0]
  138. messages = await starboard_channel.fetch_message(message_id)
  139. await messages.edit(content=f"{starsone} **#{reaction_counter + 11}**")
  140. return
  141. if reaction.count==(reaction_counter + 12):
  142. cursor.execute(f"SELECT messageid FROM starboard WHERE guildid = '{reaction.message.guild.id}'")
  143. data = cursor.fetchone()
  144. message_id = data[0]
  145. messages = await starboard_channel.fetch_message(message_id)
  146. await messages.edit(content=f"{starsone} **#{reaction_counter + 12}**")
  147. return
  148. # pass
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!